projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Ueberbleibsel von ADR entfernt.
[kivitendo-erp.git]
/
sql
/
lx-office.sql
diff --git
a/sql/lx-office.sql
b/sql/lx-office.sql
index
4b1606c
..
6807f21
100644
(file)
--- a/
sql/lx-office.sql
+++ b/
sql/lx-office.sql
@@
-115,7
+115,7
@@
CREATE TABLE "defaults" (
"itime" timestamp DEFAULT now(),
"mtime" timestamp
);
"itime" timestamp DEFAULT now(),
"mtime" timestamp
);
-INSERT INTO defaults (version,audittrail) VALUES ('2.
1.2
', 't');
+INSERT INTO defaults (version,audittrail) VALUES ('2.
2.0
', 't');
CREATE TABLE audittrail (
"trans_id" int,
CREATE TABLE audittrail (
"trans_id" int,
@@
-161,7
+161,10
@@
CREATE TABLE "invoice" (
"serialnumber" text,
"itime" timestamp DEFAULT now(),
"mtime" timestamp,
"serialnumber" text,
"itime" timestamp DEFAULT now(),
"mtime" timestamp,
- "pricegroup_id" integer
+ "pricegroup_id" integer,
+ "ordnumber" text,
+ "transdate" text,
+ "cusordnumber" text
);
CREATE TABLE "vendor" (
);
CREATE TABLE "vendor" (
@@
-240,7
+243,7
@@
CREATE TABLE "customer" (
"obsolete" boolean DEFAULT 'f',
"ustid" varchar(12),
"username" varchar(50),
"obsolete" boolean DEFAULT 'f',
"ustid" varchar(12),
"username" varchar(50),
- "user_password"
varchar(12)
,
+ "user_password"
text
,
"salesman_id" integer,
"c_vendor_id" text,
"klass" integer DEFAULT 0
"salesman_id" integer,
"c_vendor_id" text,
"klass" integer DEFAULT 0
@@
-282,6
+285,7
@@
CREATE TABLE "ar" (
"paid" numeric (15,5),
"datepaid" date,
"duedate" date,
"paid" numeric (15,5),
"datepaid" date,
"duedate" date,
+ "deliverydate" date,
"invoice" boolean DEFAULT 'f',
"shippingpoint" text,
"terms" smallint DEFAULT 0,
"invoice" boolean DEFAULT 'f',
"shippingpoint" text,
"terms" smallint DEFAULT 0,
@@
-394,10
+398,13
@@
CREATE TABLE "orderitems" (
"reqdate" date,
"ship" real,
"serialnumber" text,
"reqdate" date,
"ship" real,
"serialnumber" text,
- "id" integer DEFAULT nextval('orderitemsid'::text)
PRIMARY KEY
,
+ "id" integer DEFAULT nextval('orderitemsid'::text),
"itime" timestamp DEFAULT now(),
"mtime" timestamp,
"itime" timestamp DEFAULT now(),
"mtime" timestamp,
- "pricegroup_id" integer
+ "pricegroup_id" integer,
+ "ordnumber" text,
+ "transdate" text,
+ "cusordnumber" text
);
CREATE TABLE "exchangerate" (
);
CREATE TABLE "exchangerate" (
@@
-447,7
+454,7
@@
CREATE TABLE "shipto" (
CREATE TABLE "project" (
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
CREATE TABLE "project" (
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
- "projectnumber" text,
+ "projectnumber" text
UNIQUE
,
"description" text,
"itime" timestamp DEFAULT now(),
"mtime" timestamp
"description" text,
"itime" timestamp DEFAULT now(),
"mtime" timestamp
@@
-527,6
+534,7
@@
CREATE TABLE "business" (
"mtime" timestamp
);
"mtime" timestamp
);
+
CREATE TABLE "sic" (
"code" text,
"sictype" character(1),
CREATE TABLE "sic" (
"code" text,
"sictype" character(1),