Различия
Здесь показаны различия между двумя версиями данной страницы.
| Следующая версия | Предыдущая версия | ||
|
cust:ship:shpsh_request_20120531_1s_sql [2012/05/31 15:12] jamis7005 создано |
cust:ship:shpsh_request_20120531_1s_sql [2012/06/06 07:17] (текущий) jamis7005 |
||
|---|---|---|---|
| Строка 1: | Строка 1: | ||
| ====== SHPSHWES_upd.sql ====== | ====== SHPSHWES_upd.sql ====== | ||
| - | <sql> | + | <code sql> |
| SET SQL DIALECT 3; | SET SQL DIALECT 3; | ||
| Строка 11: | Строка 11: | ||
| + | ALTER TABLE BATCHES ADD IDBATCHEXT INTEGER; | ||
| ALTER TABLE BATCHOPER ADD USES_BATCHEXT INTEGER DEFAULT 0; | ALTER TABLE BATCHOPER ADD USES_BATCHEXT INTEGER DEFAULT 0; | ||
| - | |||
| Строка 82: | Строка 82: | ||
| ALTER TABLE BATCHEXTPROD ADD CONSTRAINT PK_BATCHEXTPROD PRIMARY KEY (IDBATCHEXT, IDPROD); | ALTER TABLE BATCHEXTPROD ADD CONSTRAINT PK_BATCHEXTPROD PRIMARY KEY (IDBATCHEXT, IDPROD); | ||
| - | ALTER TABLE BATCHEXTPROD ADD CONSTRAINT FK_BATCHEXTPROD_1 FOREIGN KEY (IDBATCHEXT) REFERENCES BATCHEXT (IDBATCHEXT) ON DELETE CASCADE ON UPDATE CASCADE; | + | ALTER TABLE BATCHEXTPROD ADD CONSTRAINT FK_BATCHEXTPROD_1 FOREIGN KEY (IDBATCHEXT) |
| - | ALTER TABLE BATCHEXTPROD ADD CONSTRAINT FK_BATCHEXTPROD_2 FOREIGN KEY (IDPROD) REFERENCES PRODUCT (IDPROD) ON DELETE CASCADE ON UPDATE CASCADE; | + | REFERENCES BATCHEXT (IDBATCHEXT) ON DELETE CASCADE ON UPDATE CASCADE; |
| + | |||
| + | ALTER TABLE BATCHEXTPROD ADD CONSTRAINT FK_BATCHEXTPROD_2 FOREIGN KEY (IDPROD) | ||
| + | REFERENCES PRODUCT (IDPROD) ON DELETE CASCADE ON UPDATE CASCADE; | ||
| - | </sql> | + | </code> |
