|
Lines 3223-3231
CREATE TABLE IF NOT EXISTS edifact_messages (
Link Here
|
| 3223 |
KEY vendorid ( vendor_id), |
3223 |
KEY vendorid ( vendor_id), |
| 3224 |
KEY ediacct (edi_acct), |
3224 |
KEY ediacct (edi_acct), |
| 3225 |
KEY basketno ( basketno), |
3225 |
KEY basketno ( basketno), |
| 3226 |
CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ), |
3226 |
CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3227 |
CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ), |
3227 |
CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3228 |
CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) |
3228 |
CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE |
| 3229 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3229 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3230 |
|
3230 |
|
| 3231 |
-- |
3231 |
-- |
| 3232 |
- |
|
|