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