diff options
| author | Christopher Baines <mail@cbaines.net> | 2019-05-12 17:01:51 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2019-05-12 18:08:17 +0100 |
| commit | 8eac26b17d996e3e171c92e43536333daf72b7c9 (patch) | |
| tree | 72cd6fdf496b4bb5b1c21713fe4395d0dc429623 /sqitch/deploy/remove_package_metadata_sha1_hash.sql | |
| parent | 0ab1c71722e81404972f80c91c9717e429d03ec3 (diff) | |
| download | data-service-8eac26b17d996e3e171c92e43536333daf72b7c9.tar data-service-8eac26b17d996e3e171c92e43536333daf72b7c9.tar.gz | |
Remove the sha1_hash from the package_metadata table
I'm thinking about adding more fields to this table, and the sha1_hash values
will make this tricker.
Therefore, remove the value, and adjust the existing code to cope. This commit
also adds a new test which coveres some of the changed functionality.
Diffstat (limited to 'sqitch/deploy/remove_package_metadata_sha1_hash.sql')
| -rw-r--r-- | sqitch/deploy/remove_package_metadata_sha1_hash.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/deploy/remove_package_metadata_sha1_hash.sql b/sqitch/deploy/remove_package_metadata_sha1_hash.sql new file mode 100644 index 0000000..f0bb286 --- /dev/null +++ b/sqitch/deploy/remove_package_metadata_sha1_hash.sql @@ -0,0 +1,7 @@ +-- Deploy guix-data-service:remove_package_metadata_sha1_hash to pg + +BEGIN; + +ALTER TABLE package_metadata DROP COLUMN sha1_hash; + +COMMIT; |