X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/45cd16c554746d78e10b48dfa2b625fff8bf62ee..faa0e892e7fd698c438b6656f378ee99c5cf95d9:/sql/lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 18f27aae7..6ccc09931 100644
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -109,12 +109,23 @@ CREATE TABLE "defaults" (
 	"rfqnumber" text,
         "customernumber" text,
         "vendornumber" text,
+        "audittrail" bool default 'f',
         "articlenumber" text,
         "servicenumber" text,
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp
 );
-INSERT INTO defaults (version) VALUES ('2.1.2');
+INSERT INTO defaults (version,audittrail) VALUES ('2.1.2', 't');
+
+CREATE TABLE audittrail (
+        "trans_id" int,
+        "tablename" text,
+        "reference" text,
+        "formname" text,
+        "action" text,
+        "transdate" timestamp default current_timestamp,
+        "employee_id" int
+);
 
 CREATE TABLE "acc_trans" (
 	"trans_id" integer,