X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/f772018b9e88abb60a63bdc680ef086a45c792ff..aacd5750af1d2371dff2abd2db5f6f5f0cca02e6:/sql/lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 3e0befb75..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
 );
@@ -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),
