Da fehlte noch eine Spalte.

[kivitendo-erp.git] / sql / lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 7b67ce7..b4f956b 100644 (file)
--- 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.2.0.0', 't');
+INSERT INTO defaults (version,audittrail) VALUES ('2.2.0', 't');
 
 CREATE TABLE audittrail (
         "trans_id" int,