diff options
Diffstat (limited to 'db/migrate/20180217105604_change_govuk_guix_revisions_primary_key.rb')
| -rw-r--r-- | db/migrate/20180217105604_change_govuk_guix_revisions_primary_key.rb | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/db/migrate/20180217105604_change_govuk_guix_revisions_primary_key.rb b/db/migrate/20180217105604_change_govuk_guix_revisions_primary_key.rb new file mode 100644 index 0000000..5b582ad --- /dev/null +++ b/db/migrate/20180217105604_change_govuk_guix_revisions_primary_key.rb @@ -0,0 +1,7 @@ +class ChangeGovukGuixRevisionsPrimaryKey < ActiveRecord::Migration[5.1] + def change + execute 'ALTER TABLE govuk_guix_revisions DROP CONSTRAINT govuk_guix_revisions_pkey;' + execute 'ALTER TABLE govuk_guix_revisions ADD PRIMARY KEY (commit_hash);' + remove_column :govuk_guix_revisions, :id + end +end |