summaryrefslogtreecommitdiff
path: root/maintenance/postgres/archives/patch-uploadstash_sequence.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/postgres/archives/patch-uploadstash_sequence.sql')
-rw-r--r--maintenance/postgres/archives/patch-uploadstash_sequence.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/maintenance/postgres/archives/patch-uploadstash_sequence.sql b/maintenance/postgres/archives/patch-uploadstash_sequence.sql
new file mode 100644
index 00000000..550b794e
--- /dev/null
+++ b/maintenance/postgres/archives/patch-uploadstash_sequence.sql
@@ -0,0 +1,2 @@
+ALTER TABLE uploadstash RENAME us_id_seq TO uploadstash_us_id_seq;
+ALTER TABLE uploadstash ALTER COLUMN us_id SET DEFAULT NEXTVAL('uploadstash_us_id_seq');