/ - Diff - projekt kivitendo - wissen

« Zurück | Weiter »

Revision faa0e892

Merge von 584 aus unstable: Datenbankschema erweitert fuer Audit Informationen

     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';
-...
     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';
     --

     	"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,

Auch abrufbar als: Unified diff