projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Die Datenbankversion in den 2.2.xer Versionen lautet "2.2.0" (wichtig fuer die Upgrad...
[kivitendo-erp.git]
/
sql
/
lx-office.sql
diff --git
a/sql/lx-office.sql
b/sql/lx-office.sql
index
9caa7bd
..
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,
@@
-534,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),