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