diff options
author | Christopher Baines <mail@cbaines.net> | 2019-12-05 14:09:47 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2019-12-12 20:07:22 +0000 |
commit | 8a5beb7f8813ec6ecca3d1e8da256bbbbcc67a36 (patch) | |
tree | 5de7c3936c7e37252c9c7b8c20441f69aa366e1f /sqitch/deploy | |
parent | 5168b38c2a50e39e74c04b616ff6f962363130c0 (diff) | |
download | data-service-8a5beb7f8813ec6ecca3d1e8da256bbbbcc67a36.tar data-service-8a5beb7f8813ec6ecca3d1e8da256bbbbcc67a36.tar.gz |
Change nar_urls size to bigint
As some nars can be bigger than the size of an int.
Diffstat (limited to 'sqitch/deploy')
-rw-r--r-- | sqitch/deploy/change_nar_urls_size_to_bigint.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/deploy/change_nar_urls_size_to_bigint.sql b/sqitch/deploy/change_nar_urls_size_to_bigint.sql new file mode 100644 index 0000000..4b6fdf3 --- /dev/null +++ b/sqitch/deploy/change_nar_urls_size_to_bigint.sql @@ -0,0 +1,7 @@ +-- Deploy guix-data-service:change_nar_urls_size_to_bigint to pg + +BEGIN; + +ALTER TABLE nar_urls ALTER COLUMN file_size TYPE bigint USING file_size::bigint; + +COMMIT; |