aboutsummaryrefslogtreecommitdiff
path: root/sqitch/pg/revert
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2021-03-29 19:38:43 +0100
committerChristopher Baines <mail@cbaines.net>2021-03-29 19:38:43 +0100
commit57932a3d80ba6e41bb349487372f990cf56063d1 (patch)
treeb11512b9de8622f45c09577c6429c5258c8d308f /sqitch/pg/revert
parentf350d650aaddc22469314472b8f5999c06f4a19f (diff)
downloadbuild-coordinator-57932a3d80ba6e41bb349487372f990cf56063d1.tar
build-coordinator-57932a3d80ba6e41bb349487372f990cf56063d1.tar.gz
Use numeric ids for the derivations and builds
Using natural IDs was nice at the start, but just doesn't scale. This migration cuts the database size, and potentially speeds up queries as well.
Diffstat (limited to 'sqitch/pg/revert')
-rw-r--r--sqitch/pg/revert/use_numeric_primary_keys.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/pg/revert/use_numeric_primary_keys.sql b/sqitch/pg/revert/use_numeric_primary_keys.sql
new file mode 100644
index 0000000..df77446
--- /dev/null
+++ b/sqitch/pg/revert/use_numeric_primary_keys.sql
@@ -0,0 +1,7 @@
+-- Revert guix-build-coordinator:use_numeric_primary_keys from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;