Revision 43cbbf5a
Von Philip Reetz vor fast 19 Jahren hinzugefügt
| sql/Pg-upgrade-2.1.1-2.1.2.sql | ||
|---|---|---|
| 170 | 170 |
alter table invoice add foreign key (parts_id) references parts (id); |
| 171 | 171 |
alter table ar add foreign key (customer_id) references customer (id); |
| 172 | 172 |
alter table ap add foreign key (vendor_id) references vendor (id); |
| 173 |
alter table orderitems add foreign key (trans_id) references oe (id); |
|
| 174 | 173 |
alter table orderitems add foreign key (parts_id) references parts (id); |
| 175 | 174 |
|
| 176 | 175 |
--Modify the possible length of bank account numbers |
| sql/lx-office.sql | ||
|---|---|---|
| 370 | 370 |
); |
| 371 | 371 |
|
| 372 | 372 |
CREATE TABLE "orderitems" ( |
| 373 |
"trans_id" integer REFERENCES oe (id),
|
|
| 373 |
"trans_id" integer, |
|
| 374 | 374 |
"parts_id" integer REFERENCES parts (id), |
| 375 | 375 |
"description" text, |
| 376 | 376 |
"qty" real, |
Auch abrufbar als: Unified diff
Fixed Bug #199