From 3404fd5bbe0550348a4c0a2024024db61b656f04 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Thu, 7 May 2009 17:54:52 +0000 Subject: [PATCH] Add foreign key constraints for users. --- db/migrate/029_add_user_foreign_keys.rb | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 db/migrate/029_add_user_foreign_keys.rb 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 -- 2.43.2