diff options
| -rw-r--r-- | sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql | 3 |
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); |