Revision 75f484cf
Von Sven Donath vor etwa 14 Jahren hinzugefügt
| sql/lx-office.sql | ||
|---|---|---|
| 1253 | 1253 |
-- Name: defaults; Type: TABLE DATA; Schema: public; Owner: postgres |
| 1254 | 1254 |
-- |
| 1255 | 1255 |
|
| 1256 |
INSERT INTO "defaults" ("version") VALUES ('2.4.0.0');
|
|
| 1257 |
|
|
| 1256 |
INSERT INTO "defaults" ("version", "curr") VALUES ('2.4.0.0', 'EUR:USD');
|
|
| 1258 | 1257 |
|
| 1259 | 1258 |
-- |
| 1260 | 1259 |
-- Data for TOC entry 204 (OID 1982194) |
| ... | ... | |
| 1954 | 1953 |
-- Name: units; Type: TABLE DATA; Schema: public; Owner: postgres |
| 1955 | 1954 |
-- |
| 1956 | 1955 |
|
| 1957 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('mg', NULL, NULL, 'dimension');
|
|
| 1958 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('g', 'mg', 1000.00000, 'dimension');
|
|
| 1959 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('kg', 'g', 1000.00000, 'dimension');
|
|
| 1960 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('t', 'kg', 1000.00000, 'dimension');
|
|
| 1961 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('ml', NULL, NULL, 'dimension');
|
|
| 1962 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('L', 'ml', 1000.00000, 'dimension');
|
|
| 1963 | 1956 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Stck', NULL, NULL, 'dimension');
|
| 1964 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('min', NULL, 0.00000, 'service');
|
|
| 1965 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Std', 'min', 60.00000, 'service');
|
|
| 1966 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Tag', 'Std', 8.00000, 'service');
|
|
| 1967 | 1957 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('psch', NULL, 0.00000, 'service');
|
| 1958 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Tag', 'Std', 8.00000, 'service');
|
|
| 1959 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('Std', 'min', 60.00000, 'service');
|
|
| 1960 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('min', NULL, 0.00000, 'service');
|
|
| 1961 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('t', 'kg', 1000.00000, 'dimension');
|
|
| 1962 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('kg', 'g', 1000.00000, 'dimension');
|
|
| 1963 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('g', 'mg', 1000.00000, 'dimension');
|
|
| 1964 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('mg', NULL, NULL, 'dimension');
|
|
| 1965 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('L', 'ml', 1000.00000, 'dimension');
|
|
| 1966 |
INSERT INTO units (name, base_unit, factor, "type") VALUES ('ml', NULL, NULL, 'dimension');
|
|
| 1968 | 1967 |
|
| 1969 | 1968 |
|
| 1970 | 1969 |
-- |
Auch abrufbar als: Unified diff
Vorgaben bei Neuinstallation auf sinnvollere Werte geändert.
Das sind: * "Stck" statt "mg" an erste Stelle. Alle anderen von groß nach klein sortiert * "EUR:USD" als Vorgabe für Währungen. * "Standard 16%/19%" Buchungsgruppe an erste Stelle gesetzt
Alle Änderungen sollen den Start nach der Neuinstallation vereinfachen und
bei Updates nichts verändern.