Lines 432-441
DROP TABLE IF EXISTS `aqbookseller_aliases`;
Link Here
|
432 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
432 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
433 |
/*!40101 SET character_set_client = utf8 */; |
433 |
/*!40101 SET character_set_client = utf8 */; |
434 |
CREATE TABLE `aqbookseller_aliases` ( |
434 |
CREATE TABLE `aqbookseller_aliases` ( |
435 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
435 |
`alias_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
436 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
436 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
437 |
`alias` varchar(255) NOT NULL COMMENT "the alias", |
437 |
`alias` varchar(255) NOT NULL COMMENT "the alias", |
438 |
PRIMARY KEY (`id`), |
438 |
PRIMARY KEY (`alias_id`), |
439 |
CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
439 |
CONSTRAINT `aqbookseller_aliases_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
440 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
440 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
441 |
/*!40101 SET character_set_client = @saved_cs_client */; |
441 |
/*!40101 SET character_set_client = @saved_cs_client */; |
442 |
- |
|
|