|
Lines 418-427
DROP TABLE IF EXISTS `aqbookseller_aliases`;
Link Here
|
| 418 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
418 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 419 |
/*!40101 SET character_set_client = utf8mb4 */; |
419 |
/*!40101 SET character_set_client = utf8mb4 */; |
| 420 |
CREATE TABLE `aqbookseller_aliases` ( |
420 |
CREATE TABLE `aqbookseller_aliases` ( |
| 421 |
`alias_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
421 |
`vendor_alias_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
| 422 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
422 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
| 423 |
`alias` varchar(255) NOT NULL COMMENT 'the alias', |
423 |
`alias` varchar(255) NOT NULL COMMENT 'the alias', |
| 424 |
PRIMARY KEY (`alias_id`), |
424 |
PRIMARY KEY (`vendor_alias_id`), |
| 425 |
KEY `aqbookseller_aliases_ibfk_1` (`vendor_id`), |
425 |
KEY `aqbookseller_aliases_ibfk_1` (`vendor_id`), |
| 426 |
CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
426 |
CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 427 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
427 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 428 |
- |
|
|