diff options
author | Christopher Baines <mail@cbaines.net> | 2019-08-04 09:39:40 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2019-08-04 09:39:40 +0100 |
commit | 84197686ce227b21dae48745f2919a51e070c3c5 (patch) | |
tree | 0ed4cc11138628575e490b803e766e8749a337d6 /sqitch/sqitch.plan | |
parent | 1724bc485f13922d768bc09309a6a7975678c321 (diff) | |
download | data-service-84197686ce227b21dae48745f2919a51e070c3c5.tar data-service-84197686ce227b21dae48745f2919a51e070c3c5.tar.gz |
Fix some duplicated values in tables
The licenses table, along with the package_metadata table had duplicate
values. This could happen as the unique constraints on those tables didn't
properly account for the nullable fields.
The duplicates in those tables also affected the license_sets, packages,
package_derivations tables in a similar way. Finally, the
guix_revision_package_derivations table was also affected.
This commit adds a migration to fix the data, as well as the constraints. THe
code to populate the licenses and package_metadata tables is also updated.
Diffstat (limited to 'sqitch/sqitch.plan')
-rw-r--r-- | sqitch/sqitch.plan | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index 7a37548..bd513cc 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -15,3 +15,4 @@ dates_to_load_new_guix_revision_jobs 2019-06-02T07:39:49Z Christopher Baines <ma load_new_guix_revision_job_events 2019-06-02T15:44:41Z Christopher Baines <mail@cbaines.net> # Add new table for guix_revision_job_events load_new_guix_revision_job_logs 2019-06-21T14:33:09Z chris <chris@phact> # Add load_new_guix_revision_job_logs change_load_new_guix_revision_job_logs_contents_to_be_nullable 2019-07-07T20:10:54Z Christopher Baines <mail@cbaines.net> # Change the contents field in the load_new_guix_revision_job_logs table\nto be nullable.\n\nwith '#' will # be ignored, and an empty message aborts the add. #\nChange to add: # #\nchange_load_new_guix_revision_job_logs_contents_to_be_nullable #\nsqitch/deploy/change_load_new_guix_revision_job_logs_contents_to_be_nullable.sql\nsqitch/revert/change_load_new_guix_revision_job_logs_contents_to_be_nullable.sql\nsqitch/verify/change_load_new_guix_revision_job_logs_contents_to_be_nullable.sql +fix_duplicated_licenses 2019-07-30T05:48:17Z Christopher Baines <mail@cbaines.net> # Fix duplicated licenses, and add constraints |