Mehrere neue Outputtypen für die parsing engine eingebaut:

[mfinanz.git] / sql / lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 3e0befb75e92359ae8738d4662633628438125f3..b4f956bbc1b574abc703efcfdad910045e83f269 100644 (file)
--- 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
 );
@@ -488,7 +489,7 @@ CREATE TABLE "status" (
 
 CREATE SEQUENCE "invoiceid" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1;
 
-CREATE SEQUENCE "orderitemsid" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1 cycle;
+CREATE SEQUENCE "orderitemsid" start 1 increment 1 maxvalue 100000 minvalue 1 cache 1 cycle;
 
 CREATE TABLE "warehouse" (
        "id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
@@ -534,6 +535,7 @@ CREATE TABLE "business" (
         "mtime" timestamp
 );
 
+
 CREATE TABLE "sic" (
        "code" text,
        "sictype" character(1),