X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/487d4f1f6ccd3e22c05469f679bf5d0685914611..9f055edb25f912aa2cb3dfd8e8a4cf20703f75a2:/sql/lx-office.sql diff --git a/sql/lx-office.sql b/sql/lx-office.sql index 9caa7bd04..b4f956bbc 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -112,10 +112,11 @@ CREATE TABLE "defaults" ( "audittrail" bool default 'f', "articlenumber" text, "servicenumber" text, + "coa" text, "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 +535,7 @@ CREATE TABLE "business" ( "mtime" timestamp ); + CREATE TABLE "sic" ( "code" text, "sictype" character(1),