From: Tom Hughes <tom@compton.nu>
Date: Thu, 7 May 2009 17:54:52 +0000 (+0000)
Subject: Add foreign key constraints for users.
X-Git-Tag: live~7412
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/3404fd5bbe0550348a4c0a2024024db61b656f04?hp=6327e3e690aea05aaad047d93f19f9297ac9c213;ds=sidebyside

Add foreign key constraints for users.
---

diff --git a/db/migrate/029_add_user_foreign_keys.rb b/db/migrate/029_add_user_foreign_keys.rb
new file mode 100644
index 000000000..d11f81cbb
--- /dev/null
+++ b/db/migrate/029_add_user_foreign_keys.rb
@@ -0,0 +1,18 @@
+class AddUserForeignKeys < ActiveRecord::Migration
+  def self.up
+    add_foreign_key :changesets, [:user_id], :users, [:id]
+    add_foreign_key :diary_comments, [:user_id], :users, [:id]
+    add_foreign_key :diary_entries, [:user_id], :users, [:id]
+    add_foreign_key :friends, [:user_id], :users, [:id]
+    add_foreign_key :friends, [:friend_user_id], :users, [:id]
+    add_foreign_key :gpx_files, [:user_id], :users, [:id]
+    add_foreign_key :messages, [:from_user_id], :users, [:id]
+    add_foreign_key :messages, [:to_user_id], :users, [:id]
+    add_foreign_key :user_preferences, [:user_id], :users, [:id]
+    add_foreign_key :user_tokens, [:user_id], :users, [:id]
+  end
+
+  def self.down
+    raise IrreversibleMigration.new
+  end
+end