Merge von 690 aus unstable: Sammelauftraege und DB-Schema

[kivitendo-erp.git] / sql / Pg-upgrade-2.1.1-2.1.2.sql

diff --git a/sql/Pg-upgrade-2.1.1-2.1.2.sql b/sql/Pg-upgrade-2.1.1-2.1.2.sql
index 534a255..7fc8516 100644 (file)
--- a/sql/Pg-upgrade-2.1.1-2.1.2.sql
+++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql
@@ -67,6 +67,10 @@ alter table invoice add column fxsellprice numeric(15,5);
 update invoice set fxsellprice=fxsellpriceold;
 alter table invoice drop column fxsellpriceold;
 --
+alter table invoice add column ordnumber text;
+alter table invoice add column transdate text;
+alter table invoice add column cusordnumber text;
+--
 --TABLE oe
 alter table oe rename column amount to amountold;
 alter table oe add column amount numeric(15,5);
@@ -84,6 +88,10 @@ alter table orderitems add column sellprice numeric(15,5);
 update orderitems set sellprice=sellpriceold;
 alter table orderitems drop column sellpriceold;
 --
+alter table orderitems add column ordnumber text;
+alter table orderitems add column transdate text;
+alter table orderitems add column cusordnumber text;
+--
 --TABLE parts
 alter table parts rename column listprice to listpriceold;
 alter table parts add column listprice numeric(15,5);