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

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index e57a683ba..fcb157c2c 100644
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -142,7 +142,7 @@ CREATE TABLE parts (
     not_discountable boolean DEFAULT false,
     buchungsgruppen_id integer,
     payment_id integer
-);
+) WITH OIDS;
 
 
 --
@@ -177,7 +177,10 @@ CREATE TABLE "defaults" (
     itime timestamp without time zone DEFAULT now(),
     mtime timestamp without time zone,
     rmanumber text,
-    cnnumber text
+    cnnumber text,
+    accounting_method text,
+    inventory_system text,
+    profit_determination text
 );
 
 
@@ -216,7 +219,7 @@ CREATE TABLE acc_trans (
     taxkey integer,
     itime timestamp without time zone DEFAULT now(),
     mtime timestamp without time zone
-);
+) WITH OIDS;
 
 
 --
@@ -248,7 +251,7 @@ CREATE TABLE invoice (
     base_qty real,
     subtotal boolean DEFAULT false,
     longdescription text
-);
+) WITH OIDS;
 
 
 --
@@ -395,7 +398,7 @@ CREATE TABLE assembly (
     bom boolean,
     itime timestamp without time zone DEFAULT now(),
     mtime timestamp without time zone
-);
+) WITH OIDS;
 
 
 --
@@ -602,7 +605,7 @@ CREATE TABLE orderitems (
     base_qty real,
     subtotal boolean DEFAULT false,
     longdescription text
-);
+) WITH OIDS;
 
 
 --
@@ -694,7 +697,7 @@ CREATE TABLE partsgroup (
     partsgroup text,
     itime timestamp without time zone DEFAULT now(),
     mtime timestamp without time zone
-);
+) WITH OIDS;
 
 
 --
@@ -1253,8 +1256,7 @@ CREATE TABLE taxkeys (
 -- Name: defaults; Type: TABLE DATA; Schema: public; Owner: postgres
 --
 
-INSERT INTO "defaults" ("version") VALUES ('2.4.0.0');
-
+INSERT INTO "defaults" ("version", "curr") VALUES ('2.4.0.0', 'EUR:USD');
 
 --
 -- Data for TOC entry 204 (OID 1982194)
@@ -1954,17 +1956,17 @@ INSERT INTO finanzamt (fa_land_nr, fa_bufa_nr, fa_name, fa_strasse, fa_plz, fa_o
 -- Name: units; Type: TABLE DATA; Schema: public; Owner: postgres
 --
 
-INSERT INTO units (name, base_unit, factor, "type") VALUES ('mg', NULL, NULL, 'dimension');
-INSERT INTO units (name, base_unit, factor, "type") VALUES ('g', 'mg', 1000.00000, 'dimension');
-INSERT INTO units (name, base_unit, factor, "type") VALUES ('kg', 'g', 1000.00000, 'dimension');
-INSERT INTO units (name, base_unit, factor, "type") VALUES ('t', 'kg', 1000.00000, 'dimension');
-INSERT INTO units (name, base_unit, factor, "type") VALUES ('ml', NULL, NULL, 'dimension');
-INSERT INTO units (name, base_unit, factor, "type") VALUES ('L', 'ml', 1000.00000, 'dimension');
 INSERT INTO units (name, base_unit, factor, "type") VALUES ('Stck', NULL, NULL, 'dimension');
-INSERT INTO units (name, base_unit, factor, "type") VALUES ('min', NULL, 0.00000, 'service');
-INSERT INTO units (name, base_unit, factor, "type") VALUES ('Std', 'min', 60.00000, 'service');
-INSERT INTO units (name, base_unit, factor, "type") VALUES ('Tag', 'Std', 8.00000, 'service');
 INSERT INTO units (name, base_unit, factor, "type") VALUES ('psch', NULL, 0.00000, 'service');
+INSERT INTO units (name, base_unit, factor, "type") VALUES ('Tag', 'Std', 8.00000, 'service');
+INSERT INTO units (name, base_unit, factor, "type") VALUES ('Std', 'min', 60.00000, 'service');
+INSERT INTO units (name, base_unit, factor, "type") VALUES ('min', NULL, 0.00000, 'service');
+INSERT INTO units (name, base_unit, factor, "type") VALUES ('t', 'kg', 1000.00000, 'dimension');
+INSERT INTO units (name, base_unit, factor, "type") VALUES ('kg', 'g', 1000.00000, 'dimension');
+INSERT INTO units (name, base_unit, factor, "type") VALUES ('g', 'mg', 1000.00000, 'dimension');
+INSERT INTO units (name, base_unit, factor, "type") VALUES ('mg', NULL, NULL, 'dimension');
+INSERT INTO units (name, base_unit, factor, "type") VALUES ('L', 'ml', 1000.00000, 'dimension');
+INSERT INTO units (name, base_unit, factor, "type") VALUES ('ml', NULL, NULL, 'dimension');
 
 
 --
