Lines 424-429
CREATE TABLE `aqbooksellers` (
Link Here
|
424 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
424 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
425 |
/*!40101 SET character_set_client = @saved_cs_client */; |
425 |
/*!40101 SET character_set_client = @saved_cs_client */; |
426 |
|
426 |
|
|
|
427 |
-- |
428 |
-- Table structure for table `aqbookseller_aliases` |
429 |
-- |
430 |
|
431 |
DROP TABLE IF EXISTS `aqbookseller_aliases`; |
432 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
433 |
/*!40101 SET character_set_client = utf8 */; |
434 |
CREATE TABLE `aqbookseller_aliases` ( |
435 |
`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', |
437 |
`alias` varchar(255) NOT NULL COMMENT "the alias", |
438 |
PRIMARY KEY (`id`), |
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; |
441 |
/*!40101 SET character_set_client = @saved_cs_client */; |
442 |
|
427 |
-- |
443 |
-- |
428 |
-- Table structure for table `aqbudgetborrowers` |
444 |
-- Table structure for table `aqbudgetborrowers` |
429 |
-- |
445 |
-- |
430 |
- |
|
|