X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Flx-office.sql;h=12819196c02b167756e84a13a86be9fe55929074;hb=22a63412fb88b026d8ff6e6989416d030cb62652;hp=e57a683baf85863a1d70197d3ee4236ad9e2c6ec;hpb=b41ae2a4dca58d2ee54b6b0f8a9b1c0bb3790c36;p=kivitendo-erp.git diff --git a/sql/lx-office.sql b/sql/lx-office.sql index e57a683ba..12819196c 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -142,7 +142,7 @@ CREATE TABLE parts ( not_discountable boolean DEFAULT false, buchungsgruppen_id integer, payment_id integer -); +) WITH OIDS; -- @@ -216,7 +216,7 @@ CREATE TABLE acc_trans ( taxkey integer, itime timestamp without time zone DEFAULT now(), mtime timestamp without time zone -); +) WITH OIDS; -- @@ -248,7 +248,7 @@ CREATE TABLE invoice ( base_qty real, subtotal boolean DEFAULT false, longdescription text -); +) WITH OIDS; -- @@ -395,7 +395,7 @@ CREATE TABLE assembly ( bom boolean, itime timestamp without time zone DEFAULT now(), mtime timestamp without time zone -); +) WITH OIDS; -- @@ -602,7 +602,7 @@ CREATE TABLE orderitems ( base_qty real, subtotal boolean DEFAULT false, longdescription text -); +) WITH OIDS; -- @@ -694,7 +694,7 @@ CREATE TABLE partsgroup ( partsgroup text, itime timestamp without time zone DEFAULT now(), mtime timestamp without time zone -); +) WITH OIDS; --