Revision d4c280d5
Von Stephan Köhler vor etwa 19 Jahren hinzugefügt
| sql/Pg-upgrade-2.1.1-2.1.2.sql | ||
|---|---|---|
| 182 | 182 |
alter table warehouse add primary key (id); |
| 183 | 183 |
alter table business add primary key (id); |
| 184 | 184 |
alter table license add primary key (id); |
| 185 |
alter table orderitems add primary key (id); |
|
| 186 | 185 |
|
| 187 | 186 |
alter table acc_trans add foreign key (chart_id) references chart (id); |
| 188 | 187 |
alter table invoice add foreign key (parts_id) references parts (id); |
| ... | ... | |
| 234 | 233 |
ALTER TABLE invoice ADD column pricegroup_id integer; |
| 235 | 234 |
ALTER TABLE orderitems ADD column pricegroup_id integer; |
| 236 | 235 |
|
| 237 |
update defaults set version = '2.1.2', audittrail = 't'; |
|
| 238 | 236 |
|
| 239 | 237 |
-- USTVA Update solve Bug 49 conributed by Andre Schubert |
| 240 | 238 |
update chart set pos_ustva='861' where accno='1771'; |
| 241 | 239 |
update chart set pos_ustva='511' where accno='1775'; |
| 242 |
update chart set pos_ustva='511' where pos_ustva='51r'; |
|
| 243 |
update chart set pos_ustva='861' where pos_ustva='86r'; |
|
| 244 |
update chart set pos_ustva='971' where pos_ustva='97r'; |
|
| 245 |
update chart set pos_ustva='931' where pos_ustva='93r'; |
|
| 240 |
-- update chart set pos_ustva='511' where pos_ustva='51r';
|
|
| 241 |
-- update chart set pos_ustva='861' where pos_ustva='86r';
|
|
| 242 |
-- update chart set pos_ustva='971' where pos_ustva='97r';
|
|
| 243 |
-- update chart set pos_ustva='931' where pos_ustva='93r';
|
|
| 246 | 244 |
|
| 247 | 245 |
-- add fields for ordnumber/transdate/cusordnumber in invoice/orderitems (r690 cleanup) |
| 248 | 246 |
alter table orderitems add column ordnumber text; |
| ... | ... | |
| 253 | 251 |
alter table invoice add column cusordnumber text; |
| 254 | 252 |
-- |
| 255 | 253 |
|
| 254 |
update defaults set version = '2.1.2'; |
|
Auch abrufbar als: Unified diff
Merge von 762 aus unstable: Bugfix Primary Key und Sql-Fehler beim Pg-upgrade
Probleme mit Primary Key in orderitems behoben
Anmerkung:
In einer bestehenden Datenbank muss der Primary Key auf der id von orderitems
manuell entfernt werden, sonst gibt es auf einigen Systemen beim Generieren
eines Auftrages Probleme.