Revision 59c1d7e3
Von Philip Reetz vor mehr als 19 Jahren hinzugefügt
| sql/lx-office.sql | ||
|---|---|---|
| 109 | 109 |
"rfqnumber" text, |
| 110 | 110 |
"customernumber" text, |
| 111 | 111 |
"vendornumber" text, |
| 112 |
"audittrail" bool default 'f', |
|
| 112 | 113 |
"articlenumber" text, |
| 113 | 114 |
"servicenumber" text, |
| 114 | 115 |
"itime" timestamp DEFAULT now(), |
| 115 | 116 |
"mtime" timestamp |
| 116 | 117 |
); |
| 117 |
INSERT INTO defaults (version) VALUES ('2.1.2');
|
|
| 118 |
INSERT INTO defaults (version,audittrail) VALUES ('2.1.2', 't');
|
|
| 119 |
|
|
| 120 |
CREATE TABLE audittrail ( |
|
| 121 |
"trans_id" int, |
|
| 122 |
"tablename" text, |
|
| 123 |
"reference" text, |
|
| 124 |
"formname" text, |
|
| 125 |
"action" text, |
|
| 126 |
"transdate" timestamp default current_timestamp, |
|
| 127 |
"employee_id" int |
|
| 128 |
); |
|
| 118 | 129 |
|
| 119 | 130 |
CREATE TABLE "acc_trans" ( |
| 120 | 131 |
"trans_id" integer, |
Auch abrufbar als: Unified diff
Datenbankschema erweitert fuer Audit Informationen