Revision 3f4a45a9
Von Udo Spallek vor etwa 17 Jahren hinzugefügt
| sql/Pg-upgrade2/USTVA_at.pl | ||
|---|---|---|
| 468 | 468 |
|
| 469 | 469 |
"ALTER TABLE taxkeys DROP COLUMN pos_ustva;", |
| 470 | 470 |
"ALTER TABLE taxkeys ADD COLUMN pos_ustva text;", |
| 471 |
"INSERT INTO taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) |
|
| 472 |
SELECT id, 0, 0, NULL, '01.01.1970' FROM chart WHERE charttype='A';", |
|
| 471 |
# "INSERT INTO taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate)
|
|
| 472 |
# SELECT id, 0, 0, NULL, '01.01.1970' FROM chart WHERE charttype='A';",
|
|
| 473 | 473 |
"UPDATE chart SET taxkey_id = 0 WHERE taxkey_id ISNULL;", |
| 474 | 474 |
"UPDATE taxkeys SET pos_ustva='000' WHERE chart_id IN (SELECT id FROM chart WHERE accno IN (4010, 4015, 4020, 4025, 4030, 4035, 4040, 4045, 4050, 4310, 4315, 4320, 4322, 4325, 4330, 4335, 4340, 4345, 4350, 4450, 4029, 4329));", |
| 475 | 475 |
"UPDATE taxkeys SET pos_ustva='011' WHERE chart_id IN (SELECT id FROM chart WHERE accno IN (4029, 4329));", |
Auch abrufbar als: Unified diff
Bloeder Bug: eine zu gefräßige INSERT legt zu allen Konten taxkeys an, was aber nicht sein soll, weil dubletten erzeugt werden