1 CREATE TABLE "language" (
2 "id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
6 "itime" timestamp DEFAULT now(),
10 CREATE TABLE "payment_terms" (
11 "id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
13 "description_long" text,
14 "terms_netto" integer,
15 "terms_skonto" integer,
16 "percent_skonto" real,
17 "itime" timestamp DEFAULT now(),
21 CREATE TABLE "translation" (
23 "language_id" integer,
25 "itime" timestamp DEFAULT now(),
29 ALTER TABLE customer ADD column language_id integer;
30 ALTER TABLE customer ADD column payment_id integer;
31 ALTER TABLE vendor ADD column language_id integer;
32 ALTER TABLE vendor ADD column payment_id integer;
33 ALTER TABLE ar ADD column language_id integer;
34 ALTER TABLE ar ADD column payment_id integer;
35 ALTER TABLE ap ADD column language_id integer;
36 ALTER TABLE ap ADD column payment_id integer;
37 ALTER TABLE oe ADD column language_id integer;
38 ALTER TABLE oe ADD column payment_id integer;
40 ALTER TABLE ar ADD column delivery_customer_id integer;
41 ALTER TABLE ar ADD column delivery_vendor_id integer;
42 ALTER TABLE oe ADD column delivery_customer_id integer;
43 ALTER TABLE oe ADD column delivery_vendor_id integer;