Datenbankschema erweitert fuer Audit Informationen

diff --git a/sql/Pg-upgrade-2.1.1-2.1.2.sql b/sql/Pg-upgrade-2.1.1-2.1.2.sql
index 7ff54927a0206f8c4a5ba38490171f26cc4004cb..8973fd09eff2b8483a74e1f7c0df344e24f6475d 100644 (file)
--- a/sql/Pg-upgrade-2.1.1-2.1.2.sql
+++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql
@@ -132,6 +132,8 @@ alter table vendor add column salesman_id integer;
 alter table shipto add column shiptodepartment_1 varchar(75);
 alter table shipto add column shiptodepartment_2 varchar(75);
 
 alter table shipto add column shiptodepartment_1 varchar(75);
 alter table shipto add column shiptodepartment_2 varchar(75);
 

+
+

 -- Addon for business
 alter table business add column salesman boolean;
 alter table business alter column salesman set default 'false';
 -- Addon for business
 alter table business add column salesman boolean;
 alter table business alter column salesman set default 'false';


@@ -183,6 +185,18 @@ update vendor set temp_account_number=account_number;
 alter table vendor drop column account_number;
 alter table vendor rename temp_account_number to  account_number;
 
 alter table vendor drop column account_number;
 alter table vendor rename temp_account_number to  account_number;
 

-update defaults set version = '2.1.2';
+-- audit
+alter table defaults add column audittrail bool;
+CREATE TABLE audittrail (
+  trans_id int,
+  tablename text,
+  reference text,
+  formname text,
+  action text,
+  transdate timestamp default current_timestamp,
+  employee_id int
+);
+
+update defaults set version = '2.1.2', audittrail = 't';

 --
 
 --
 

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 18f27aae77bc90e370dbbef4ff5d07d92814cb17..6ccc09931eb6dd9aa9636d786c0a1087ad4ac316 100644 (file)
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -109,12 +109,23 @@ CREATE TABLE "defaults" (
        "rfqnumber" text,
         "customernumber" text,
         "vendornumber" text,
        "rfqnumber" text,
         "customernumber" text,
         "vendornumber" text,

+        "audittrail" bool default 'f',

         "articlenumber" text,
         "servicenumber" text,
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp
 );
         "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,
 
 CREATE TABLE "acc_trans" (
        "trans_id" integer,