Revision dae6150e
Von Moritz Bunkus vor fast 18 Jahren hinzugefügt
| sql/lx-office.sql | ||
|---|---|---|
| 115 | 115 |
"itime" timestamp DEFAULT now(), |
| 116 | 116 |
"mtime" timestamp |
| 117 | 117 |
); |
| 118 |
INSERT INTO defaults (version,audittrail) VALUES ('2.2.0.1', 't');
|
|
| 118 |
INSERT INTO defaults (version,audittrail) VALUES ('2.2.0.0', 't');
|
|
| 119 | 119 |
|
| 120 | 120 |
CREATE TABLE audittrail ( |
| 121 | 121 |
"trans_id" int, |
| ... | ... | |
| 197 | 197 |
"bank_code" varchar(10), |
| 198 | 198 |
"bank" text, |
| 199 | 199 |
"language" varchar(5), |
| 200 |
"language_id" integer, |
|
| 201 |
"payment_id" integer, |
|
| 202 | 200 |
"datevexport" integer, |
| 203 | 201 |
"itime" timestamp DEFAULT now(), |
| 204 | 202 |
"mtime" timestamp, |
| ... | ... | |
| 239 | 237 |
"bank_code" varchar(10), |
| 240 | 238 |
"bank" text, |
| 241 | 239 |
"language" varchar(5), |
| 242 |
"language_id" integer, |
|
| 243 |
"payment_id" integer, |
|
| 244 | 240 |
"datevexport" integer, |
| 245 | 241 |
"itime" timestamp DEFAULT now(), |
| 246 | 242 |
"mtime" timestamp, |
| ... | ... | |
| 300 | 296 |
"quonumber" text, |
| 301 | 297 |
"cusordnumber" text, |
| 302 | 298 |
"intnotes" text, |
| 303 |
"language_id" integer, |
|
| 304 |
"payment_id" integer, |
|
| 305 |
"delivery_customer_id" integer, |
|
| 306 |
"delivery_vendor_id" integer, |
|
| 307 | 299 |
"department_id" integer DEFAULT 0, |
| 308 | 300 |
"shipvia" text, |
| 309 | 301 |
"itime" timestamp DEFAULT now(), |
| ... | ... | |
| 330 | 322 |
"employee_id" integer, |
| 331 | 323 |
"quonumber" text, |
| 332 | 324 |
"intnotes" text, |
| 333 |
"language_id" integer, |
|
| 334 |
"payment_id" integer, |
|
| 335 | 325 |
"department_id" integer DEFAULT 0, |
| 336 | 326 |
"itime" timestamp DEFAULT now(), |
| 337 | 327 |
"mtime" timestamp, |
| ... | ... | |
| 370 | 360 |
"mtime" timestamp |
| 371 | 361 |
); |
| 372 | 362 |
|
| 373 |
CREATE TABLE "translation" ( |
|
| 374 |
"parts_id" integer, |
|
| 375 |
"language_id" integer, |
|
| 376 |
"translation" text, |
|
| 377 |
"itime" timestamp DEFAULT now(), |
|
| 378 |
"mtime" timestamp |
|
| 379 |
); |
|
| 380 |
|
|
| 381 | 363 |
CREATE TABLE "oe" ( |
| 382 | 364 |
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
|
| 383 | 365 |
"ordnumber" text NOT NULL, |
| ... | ... | |
| 397 | 379 |
"quonumber" text, |
| 398 | 380 |
"cusordnumber" text, |
| 399 | 381 |
"intnotes" text, |
| 400 |
"delivery_customer_id" integer, |
|
| 401 |
"delivery_vendor_id" integer, |
|
| 402 |
"language_id" integer, |
|
| 403 |
"payment_id" integer, |
|
| 404 | 382 |
"department_id" integer DEFAULT 0, |
| 405 | 383 |
"itime" timestamp DEFAULT now(), |
| 406 | 384 |
"mtime" timestamp, |
| ... | ... | |
| 557 | 535 |
); |
| 558 | 536 |
|
| 559 | 537 |
|
| 560 |
CREATE TABLE "language" ( |
|
| 561 |
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
|
|
| 562 |
"description" text, |
|
| 563 |
"template_code" text, |
|
| 564 |
"article_code" text, |
|
| 565 |
"itime" timestamp DEFAULT now(), |
|
| 566 |
"mtime" timestamp |
|
| 567 |
); |
|
| 568 |
|
|
| 569 |
CREATE TABLE "payment_terms" ( |
|
| 570 |
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
|
|
| 571 |
"description" text, |
|
| 572 |
"description_long" text, |
|
| 573 |
"terms_netto" integer, |
|
| 574 |
"terms_skonto" integer, |
|
| 575 |
"percent_skonto" real, |
|
| 576 |
"itime" timestamp DEFAULT now(), |
|
| 577 |
"mtime" timestamp |
|
| 578 |
); |
|
| 579 |
|
|
| 580 | 538 |
CREATE TABLE "sic" ( |
| 581 | 539 |
"code" text, |
| 582 | 540 |
"sictype" character(1), |
Auch abrufbar als: Unified diff
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.