Revision 614534b9
Von Philip Reetz vor etwa 19 Jahren hinzugefügt
| sql/Pg-upgrade-2.1.1-2.1.2.sql | ||
|---|---|---|
|
alter table warehouse add primary key (id);
|
||
|
alter table business add primary key (id);
|
||
|
alter table license add primary key (id);
|
||
|
alter table orderitems add primary key (id);
|
||
|
|
||
|
alter table acc_trans add foreign key (chart_id) references chart (id);
|
||
|
alter table invoice add foreign key (parts_id) references parts (id);
|
||
| ... | ... | |
|
ALTER TABLE invoice ADD column pricegroup_id integer;
|
||
|
ALTER TABLE orderitems ADD column pricegroup_id integer;
|
||
|
|
||
|
update defaults set version = '2.1.2', audittrail = 't';
|
||
|
|
||
|
-- USTVA Update solve Bug 49 conributed by Andre Schubert
|
||
|
update chart set pos_ustva='861' where accno='1771';
|
||
|
update chart set pos_ustva='511' where accno='1775';
|
||
|
update chart set pos_ustva='511' where pos_ustva='51r';
|
||
|
update chart set pos_ustva='861' where pos_ustva='86r';
|
||
|
update chart set pos_ustva='971' where pos_ustva='97r';
|
||
|
update chart set pos_ustva='931' where pos_ustva='93r';
|
||
|
-- update chart set pos_ustva='511' where pos_ustva='51r';
|
||
|
-- update chart set pos_ustva='861' where pos_ustva='86r';
|
||
|
-- update chart set pos_ustva='971' where pos_ustva='97r';
|
||
|
-- update chart set pos_ustva='931' where pos_ustva='93r';
|
||
|
|
||
|
-- add fields for ordnumber/transdate/cusordnumber in invoice/orderitems (r690 cleanup)
|
||
|
alter table orderitems add column ordnumber text;
|
||
| ... | ... | |
|
alter table invoice add column cusordnumber text;
|
||
|
--
|
||
|
|
||
|
update defaults set version = '2.1.2';
|
||
| sql/lx-office.sql | ||
|---|---|---|
|
"reqdate" date,
|
||
|
"ship" real,
|
||
|
"serialnumber" text,
|
||
|
"id" integer DEFAULT nextval('orderitemsid'::text) PRIMARY KEY,
|
||
|
"id" integer DEFAULT nextval('orderitemsid'::text),
|
||
|
"itime" timestamp DEFAULT now(),
|
||
|
"mtime" timestamp,
|
||
|
"pricegroup_id" integer,
|
||
Auch abrufbar als: Unified diff
Probleme mit Primary Key in orderitems behoben