|
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 |
- |
|
|