|
Lines 3266-3274
CREATE TABLE IF NOT EXISTS edifact_messages (
Link Here
|
| 3266 |
KEY vendorid ( vendor_id), |
3266 |
KEY vendorid ( vendor_id), |
| 3267 |
KEY ediacct (edi_acct), |
3267 |
KEY ediacct (edi_acct), |
| 3268 |
KEY basketno ( basketno), |
3268 |
KEY basketno ( basketno), |
| 3269 |
CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ), |
3269 |
CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3270 |
CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ), |
3270 |
CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3271 |
CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) |
3271 |
CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE |
| 3272 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3272 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3273 |
|
3273 |
|
| 3274 |
-- |
3274 |
-- |
| 3275 |
- |
|
|