summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql b/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
index 384cae25..82310ec8 100644
--- a/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
+++ b/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql
@@ -34,6 +34,9 @@ ALTER TABLE makemodel ADD PRIMARY KEY (parts_id);
ALTER TABLE oe ADD PRIMARY KEY (id);
+SELECT setval('orderitemsid', 1);
+UPDATE orderitems SET id = nextval('orderitemsid');
+
ALTER TABLE orderitems ADD PRIMARY KEY (id);
ALTER TABLE parts ADD PRIMARY KEY (id);