X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Flx-office.sql;h=3cffed08f66a4285b883ec1864b2511f2a618944;hb=3d7898cf2bab46c72face3011460d093d8778b32;hp=12819196c02b167756e84a13a86be9fe55929074;hpb=0f6e82efb2365d305e32d9ce5756133313b93303;p=kivitendo-erp.git diff --git a/sql/lx-office.sql b/sql/lx-office.sql index 12819196c..3cffed08f 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -1253,8 +1253,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 +1953,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'); --