X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Flx-office.sql;h=6807f217fa72244257c9d8d33c46448d67a2ec41;hb=0e50c3d80f4705a01cea9d664e0edaa2f8d0cdfa;hp=9caa7bd04f995fab042af741b1ea949be8502827;hpb=487d4f1f6ccd3e22c05469f679bf5d0685914611;p=kivitendo-erp.git diff --git a/sql/lx-office.sql b/sql/lx-office.sql index 9caa7bd04..6807f217f 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -115,7 +115,7 @@ CREATE TABLE "defaults" ( "itime" timestamp DEFAULT now(), "mtime" timestamp ); -INSERT INTO defaults (version,audittrail) VALUES ('2.1.2', 't'); +INSERT INTO defaults (version,audittrail) VALUES ('2.2.0', 't'); CREATE TABLE audittrail ( "trans_id" int, @@ -534,6 +534,7 @@ CREATE TABLE "business" ( "mtime" timestamp ); + CREATE TABLE "sic" ( "code" text, "sictype" character(1),