diff options
| author |   Alex Legler <a3li@gentoo.org> | 2009-04-10 23:29:19 +0200 |
|---|---|---|
| committer | Alex Legler <a3li@gentoo.org> | 2009-04-10 23:29:19 +0200 |
| commit | 2ba0bedea334a0dcf29e3e790bb83b583c4aea7e (patch) | |
| tree | bef48bcbd64c1341bb9e6f534497ae32c98a68f8 /db | |
| parent | Adding impact to edit view, much nicer severity icon (diff) | |
| download | glsamaker-2ba0bedea334a0dcf29e3e790bb83b583c4aea7e.tar.gz glsamaker-2ba0bedea334a0dcf29e3e790bb83b583c4aea7e.tar.bz2 glsamaker-2ba0bedea334a0dcf29e3e790bb83b583c4aea7e.zip | |
Adding userid field to revision
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20090410212514_add_user_id_to_revisions.rb | 9 | ||||
| -rw-r--r-- | db/migrate/20090410212600_add_revisions_user_id_constraint.rb | 9 |
2 files changed, 18 insertions, 0 deletions
diff --git a/db/migrate/20090410212514_add_user_id_to_revisions.rb b/db/migrate/20090410212514_add_user_id_to_revisions.rb new file mode 100644 index 0000000..f6c0254 --- /dev/null +++ b/db/migrate/20090410212514_add_user_id_to_revisions.rb @@ -0,0 +1,9 @@ +class AddUserIdToRevisions < ActiveRecord::Migration + def self.up + add_column :revisions, :user_id, :integer + end + + def self.down + remove_column :revisions, :user_id + end +end diff --git a/db/migrate/20090410212600_add_revisions_user_id_constraint.rb b/db/migrate/20090410212600_add_revisions_user_id_constraint.rb new file mode 100644 index 0000000..b90531d --- /dev/null +++ b/db/migrate/20090410212600_add_revisions_user_id_constraint.rb @@ -0,0 +1,9 @@ +class AddRevisionsUserIdConstraint < ActiveRecord::Migration + def self.up + execute "ALTER TABLE `revisions` ADD CONSTRAINT revisions_user_userid FOREIGN KEY (user_id) REFERENCES revisions (id)" + end + + def self.down + execute "ALTER TABLE `revisions` DROP FOREIGN KEY revisions_user_userid" + end +end
\ No newline at end of file |