X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Flx-office.sql;h=b4f956bbc1b574abc703efcfdad910045e83f269;hb=80ec19fe41dfa899593655963628334ab656ae54;hp=ffcf8ca3615526becdef4cec14af2fbe9dcf579c;hpb=c5b4fdf47f0959a9cb7546fe907ff5b14330f7b3;p=kivitendo-erp.git diff --git a/sql/lx-office.sql b/sql/lx-office.sql index ffcf8ca36..b4f956bbc 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -112,6 +112,7 @@ CREATE TABLE "defaults" ( "audittrail" bool default 'f', "articlenumber" text, "servicenumber" text, + "coa" text, "itime" timestamp DEFAULT now(), "mtime" timestamp ); @@ -534,6 +535,7 @@ CREATE TABLE "business" ( "mtime" timestamp ); + CREATE TABLE "sic" ( "code" text, "sictype" character(1),