Revision f164578c
Von Stephan Köhler vor mehr als 18 Jahren hinzugefügt
| sql/Pg-upgrade-2.1.1-2.1.2.sql | ||
|---|---|---|
| 318 | 318 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.07','1572','18','Steuerpfl. EG-Erwerb 7%'); |
| 319 | 319 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.16','1573','19','Steuerpfl. EG-Erwerb 16%'); |
| 320 | 320 |
|
| 321 |
update defaults set version = '2.1.2'; |
|
| 322 |
|
|
| 323 | 321 |
-- |
| 324 | 322 |
-- add unqiue constraint to project |
| 325 | 323 |
ALTER TABLE project ADD constraint project_projectnumber_key UNIQUE(projectnumber); |
| 324 |
|
|
| 325 |
update defaults set version = '2.1.2'; |
|
Auch abrufbar als: Unified diff
Nachtrag r825, Reihenfolge DB-Schemata