kivitendo/sql/Pg-upgrade/Pg-upgrade-2.2.0.2-2.2.0.3.sql @ 43115782
| 54e4131e | Moritz Bunkus | CREATE TABLE "language" (
|
|
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
|
|||
"description" text,
|
|||
"template_code" text,
|
|||
"article_code" text,
|
|||
"itime" timestamp DEFAULT now(),
|
|||
"mtime" timestamp
|
|||
);
|
|||
CREATE TABLE "payment_terms" (
|
|||
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
|
|||
"description" text,
|
|||
"description_long" text,
|
|||
"terms_netto" integer,
|
|||
"terms_skonto" integer,
|
|||
"percent_skonto" real,
|
|||
"itime" timestamp DEFAULT now(),
|
|||
"mtime" timestamp
|
|||
);
|
|||
CREATE TABLE "translation" (
|
|||
"parts_id" integer,
|
|||
"language_id" integer,
|
|||
"translation" text,
|
|||
"itime" timestamp DEFAULT now(),
|
|||
"mtime" timestamp
|
|||
);
|
|||
ALTER TABLE customer ADD column language_id integer;
|
|||
ALTER TABLE customer ADD column payment_id integer;
|
|||
ALTER TABLE vendor ADD column language_id integer;
|
|||
ALTER TABLE vendor ADD column payment_id integer;
|
|||
ALTER TABLE ar ADD column language_id integer;
|
|||
ALTER TABLE ar ADD column payment_id integer;
|
|||
ALTER TABLE ap ADD column language_id integer;
|
|||
ALTER TABLE ap ADD column payment_id integer;
|
|||
ALTER TABLE oe ADD column language_id integer;
|
|||
ALTER TABLE oe ADD column payment_id integer;
|
|||
ALTER TABLE ar ADD column delivery_customer_id integer;
|
|||
ALTER TABLE ar ADD column delivery_vendor_id integer;
|
|||
ALTER TABLE oe ADD column delivery_customer_id integer;
|
|||
ALTER TABLE oe ADD column delivery_vendor_id integer;
|