Revision 54e4131e
Von Moritz Bunkus vor mehr als 18 Jahren hinzugefügt
| sql/lx-office.sql | ||
|---|---|---|
|
"itime" timestamp DEFAULT now(),
|
||
|
"mtime" timestamp
|
||
|
);
|
||
|
INSERT INTO defaults (version,audittrail) VALUES ('2.2.0', 't');
|
||
|
INSERT INTO defaults (version,audittrail) VALUES ('2.2.0.1', 't');
|
||
|
|
||
|
CREATE TABLE audittrail (
|
||
|
"trans_id" int,
|
||
| ... | ... | |
|
"bank_code" varchar(10),
|
||
|
"bank" text,
|
||
|
"language" varchar(5),
|
||
|
"language_id" integer,
|
||
|
"payment_id" integer,
|
||
|
"datevexport" integer,
|
||
|
"itime" timestamp DEFAULT now(),
|
||
|
"mtime" timestamp,
|
||
| ... | ... | |
|
"bank_code" varchar(10),
|
||
|
"bank" text,
|
||
|
"language" varchar(5),
|
||
|
"language_id" integer,
|
||
|
"payment_id" integer,
|
||
|
"datevexport" integer,
|
||
|
"itime" timestamp DEFAULT now(),
|
||
|
"mtime" timestamp,
|
||
| ... | ... | |
|
"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(),
|
||
| ... | ... | |
|
"employee_id" integer,
|
||
|
"quonumber" text,
|
||
|
"intnotes" text,
|
||
|
"language_id" integer,
|
||
|
"payment_id" integer,
|
||
|
"department_id" integer DEFAULT 0,
|
||
|
"itime" timestamp DEFAULT now(),
|
||
|
"mtime" timestamp,
|
||
| ... | ... | |
|
"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,
|
||
| ... | ... | |
|
"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,
|
||
| ... | ... | |
|
|
||
|
CREATE SEQUENCE "invoiceid" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1;
|
||
|
|
||
|
CREATE SEQUENCE "orderitemsid" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1 cycle;
|
||
|
CREATE SEQUENCE "orderitemsid" start 1 increment 1 maxvalue 100000 minvalue 1 cache 1 cycle;
|
||
|
|
||
|
CREATE TABLE "warehouse" (
|
||
|
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
|
||
| ... | ... | |
|
"mtime" timestamp
|
||
|
);
|
||
|
|
||
|
|
||
|
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),
|
||
Auch abrufbar als: Unified diff
Uebernahme der kompletten Version, so wie sie Philip als "Demo-Version" gezeigt hat, in das unstable-Repo. Dabei werden auch einige Patches, die seit der 2.2.0 hier eingepflegt wurden, wieder ueberschrieben. Diese werden in den naechsten Tagen wieder eingespielt, sofern noetig. Zu den neuen Features gehoeren (ohne Anspruch auf Vollstaendigkeit) Mahnwesen, Einheiten, Template-Neucodierung, AJAX-basierende Dialoge an einigen Stellen, Buchungsgruppen etc etc.