summaryrefslogtreecommitdiff
path: root/sql/legacy/Pg-upgrade-2.5.2-2.6.0.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/legacy/Pg-upgrade-2.5.2-2.6.0.sql')
-rwxr-xr-xsql/legacy/Pg-upgrade-2.5.2-2.6.0.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/legacy/Pg-upgrade-2.5.2-2.6.0.sql b/sql/legacy/Pg-upgrade-2.5.2-2.6.0.sql
new file mode 100755
index 00000000..7a848b16
--- /dev/null
+++ b/sql/legacy/Pg-upgrade-2.5.2-2.6.0.sql
@@ -0,0 +1,9 @@
+--
+alter table oe add terms smallint;
+alter table oe alter terms set default 0;
+--
+alter table ap alter terms set default 0;
+--
+delete from inventory where warehouse_id = 0;
+--
+update defaults set version = '2.6.0';