Revision 59c1d7e3
Von Philip Reetz vor mehr als 19 Jahren hinzugefügt
| sql/Pg-upgrade-2.1.1-2.1.2.sql | ||
|---|---|---|
| 132 | 132 |
alter table shipto add column shiptodepartment_1 varchar(75); |
| 133 | 133 |
alter table shipto add column shiptodepartment_2 varchar(75); |
| 134 | 134 |
|
| 135 |
|
|
| 136 |
|
|
| 135 | 137 |
-- Addon for business |
| 136 | 138 |
alter table business add column salesman boolean; |
| 137 | 139 |
alter table business alter column salesman set default 'false'; |
| ... | ... | |
| 183 | 185 |
alter table vendor drop column account_number; |
| 184 | 186 |
alter table vendor rename temp_account_number to account_number; |
| 185 | 187 |
|
| 186 |
update defaults set version = '2.1.2'; |
|
| 188 |
-- audit |
|
| 189 |
alter table defaults add column audittrail bool; |
|
| 190 |
CREATE TABLE audittrail ( |
|
| 191 |
trans_id int, |
|
| 192 |
tablename text, |
|
| 193 |
reference text, |
|
| 194 |
formname text, |
|
| 195 |
action text, |
|
| 196 |
transdate timestamp default current_timestamp, |
|
| 197 |
employee_id int |
|
| 198 |
); |
|
| 199 |
|
|
| 200 |
update defaults set version = '2.1.2', audittrail = 't'; |
|
| 187 | 201 |
-- |
| 188 | 202 |
|
Auch abrufbar als: Unified diff
Datenbankschema erweitert fuer Audit Informationen