diff options
| author | Christopher Baines <mail@cbaines.net> | 2021-03-29 19:38:43 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2021-03-29 19:38:43 +0100 |
| commit | 57932a3d80ba6e41bb349487372f990cf56063d1 (patch) | |
| tree | b11512b9de8622f45c09577c6429c5258c8d308f /sqitch/sqlite/revert/use_numeric_primary_keys.sql | |
| parent | f350d650aaddc22469314472b8f5999c06f4a19f (diff) | |
| download | build-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/sqlite/revert/use_numeric_primary_keys.sql')
| -rw-r--r-- | sqitch/sqlite/revert/use_numeric_primary_keys.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/sqlite/revert/use_numeric_primary_keys.sql b/sqitch/sqlite/revert/use_numeric_primary_keys.sql new file mode 100644 index 0000000..fdb22de --- /dev/null +++ b/sqitch/sqlite/revert/use_numeric_primary_keys.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:use_numeric_primary_keys from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; |