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