Lines 2904-2910
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
Link Here
|
2904 |
PRIMARY KEY (`id`), |
2904 |
PRIMARY KEY (`id`), |
2905 |
KEY `listprice` (`listprice`), |
2905 |
KEY `listprice` (`listprice`), |
2906 |
KEY `invoiceprice` (`invoiceprice`), |
2906 |
KEY `invoiceprice` (`invoiceprice`), |
2907 |
KEY `name` (`name`(255)), |
2907 |
KEY `name` (`name`), |
2908 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
2908 |
CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE, |
2909 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
2909 |
CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE |
2910 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2910 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
2911 |
- |
|
|