1 alter table chart add column new_chart_id integer;
2 alter table chart add column valid_from date;
4 create table tax_zones (
9 insert into tax_zones (id, description) VALUES (0, 'Inland');
10 insert into tax_zones (id, description) VALUES (1, 'EU mit USt-ID Nummer');
11 insert into tax_zones (id, description) VALUES (2, 'EU ohne USt-ID Nummer');
12 insert into tax_zones (id, description) VALUES (3, 'Außerhalb EU');
14 create table buchungsgruppen (
15 id integer DEFAULT nextval('id'::text) PRIMARY KEY,
17 inventory_accno_id integer,
18 income_accno_id_0 integer,
19 expense_accno_id_0 integer,
20 income_accno_id_1 integer,
21 expense_accno_id_1 integer,
22 income_accno_id_2 integer,
23 expense_accno_id_2 integer,
24 income_accno_id_3 integer,
25 expense_accno_id_3 integer
28 alter table parts add column buchungsgruppen_id integer;
30 alter table vendor add column taxzone_id integer;
31 alter table customer add column taxzone_id integer;
33 alter table ar add column taxzone_id integer;
34 alter table ap add column taxzone_id integer;
35 alter table oe add column taxzone_id integer;