projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Solved Bug 365: Falsche UStVA bei negativem Vorsteuer-Betrag (Teil 2)
[kivitendo-erp.git]
/
sql
/
lx-office.sql
diff --git
a/sql/lx-office.sql
b/sql/lx-office.sql
index
ca5b1d3
..
3e0befb
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,
@@
-285,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,
@@
-453,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
@@
-487,7
+488,7
@@
CREATE TABLE "status" (
CREATE SEQUENCE "invoiceid" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1;
CREATE SEQUENCE "invoiceid" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1;
-CREATE SEQUENCE "orderitemsid" start 1 increment 1 maxvalue
100000
minvalue 1 cache 1 cycle;
+CREATE SEQUENCE "orderitemsid" start 1 increment 1 maxvalue
9223372036854775807
minvalue 1 cache 1 cycle;
CREATE TABLE "warehouse" (
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
CREATE TABLE "warehouse" (
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,