From dae6150e52e9fd344e0c05fad970c0d0a1293378 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Thu, 23 Nov 2006 13:21:39 +0000 Subject: [PATCH] Diese Aenderungen sind noch nicht im Datenbankschema der 2.2.0 enthalten und werden durch die Upgrades auf 2.2.0.1 und 2.2.0.2 erstellt. Die grosse Schemadatei lx-office.sql wird erst direkt vor dem naechsten Release aktualisiert und dann auch die Version des Datenbankschemas hochgesetzt. --- sql/lx-office.sql | 44 +------------------------------------------- 1 file changed, 1 insertion(+), 43 deletions(-) diff --git a/sql/lx-office.sql b/sql/lx-office.sql index e7206536f..7b67ce77b 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -115,7 +115,7 @@ CREATE TABLE "defaults" ( "itime" timestamp DEFAULT now(), "mtime" timestamp ); -INSERT INTO defaults (version,audittrail) VALUES ('2.2.0.1', 't'); +INSERT INTO defaults (version,audittrail) VALUES ('2.2.0.0', 't'); CREATE TABLE audittrail ( "trans_id" int, @@ -197,8 +197,6 @@ CREATE TABLE "vendor" ( "bank_code" varchar(10), "bank" text, "language" varchar(5), - "language_id" integer, - "payment_id" integer, "datevexport" integer, "itime" timestamp DEFAULT now(), "mtime" timestamp, @@ -239,8 +237,6 @@ CREATE TABLE "customer" ( "bank_code" varchar(10), "bank" text, "language" varchar(5), - "language_id" integer, - "payment_id" integer, "datevexport" integer, "itime" timestamp DEFAULT now(), "mtime" timestamp, @@ -300,10 +296,6 @@ CREATE TABLE "ar" ( "quonumber" text, "cusordnumber" text, "intnotes" text, - "language_id" integer, - "payment_id" integer, - "delivery_customer_id" integer, - "delivery_vendor_id" integer, "department_id" integer DEFAULT 0, "shipvia" text, "itime" timestamp DEFAULT now(), @@ -330,8 +322,6 @@ CREATE TABLE "ap" ( "employee_id" integer, "quonumber" text, "intnotes" text, - "language_id" integer, - "payment_id" integer, "department_id" integer DEFAULT 0, "itime" timestamp DEFAULT now(), "mtime" timestamp, @@ -370,14 +360,6 @@ CREATE TABLE "vendortax" ( "mtime" timestamp ); -CREATE TABLE "translation" ( - "parts_id" integer, - "language_id" integer, - "translation" text, - "itime" timestamp DEFAULT now(), - "mtime" timestamp -); - CREATE TABLE "oe" ( "id" integer DEFAULT nextval('id'::text) PRIMARY KEY, "ordnumber" text NOT NULL, @@ -397,10 +379,6 @@ CREATE TABLE "oe" ( "quonumber" text, "cusordnumber" text, "intnotes" text, - "delivery_customer_id" integer, - "delivery_vendor_id" integer, - "language_id" integer, - "payment_id" integer, "department_id" integer DEFAULT 0, "itime" timestamp DEFAULT now(), "mtime" timestamp, @@ -557,26 +535,6 @@ CREATE TABLE "business" ( ); -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 "sic" ( "code" text, "sictype" character(1), -- 2.20.1