|
Lines 448-454
DROP TABLE IF EXISTS `aqbookseller_interfaces`;
Link Here
|
| 448 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
448 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 449 |
/*!40101 SET character_set_client = utf8 */; |
449 |
/*!40101 SET character_set_client = utf8 */; |
| 450 |
CREATE TABLE `aqbookseller_interfaces` ( |
450 |
CREATE TABLE `aqbookseller_interfaces` ( |
| 451 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
451 |
`interface_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', |
| 452 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
452 |
`vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', |
| 453 |
`type` varchar(80) DEFAULT NULL COMMENT "type of the interface, authorised value VENDOR_INTERFACE_TYPE", |
453 |
`type` varchar(80) DEFAULT NULL COMMENT "type of the interface, authorised value VENDOR_INTERFACE_TYPE", |
| 454 |
`name` varchar(255) NOT NULL COMMENT 'name of the interface', |
454 |
`name` varchar(255) NOT NULL COMMENT 'name of the interface', |
|
Lines 457-463
CREATE TABLE `aqbookseller_interfaces` (
Link Here
|
| 457 |
`password` mediumtext DEFAULT NULL COMMENT 'hashed password', |
457 |
`password` mediumtext DEFAULT NULL COMMENT 'hashed password', |
| 458 |
`account_email` mediumtext DEFAULT NULL COMMENT 'account email', |
458 |
`account_email` mediumtext DEFAULT NULL COMMENT 'account email', |
| 459 |
`notes` longtext DEFAULT NULL COMMENT 'notes', |
459 |
`notes` longtext DEFAULT NULL COMMENT 'notes', |
| 460 |
PRIMARY KEY (`id`), |
460 |
PRIMARY KEY (`interface_id`), |
| 461 |
CONSTRAINT `aqbookseller_interfaces_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
461 |
CONSTRAINT `aqbookseller_interfaces_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 462 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
462 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 463 |
/*!40101 SET character_set_client = @saved_cs_client */; |
463 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 464 |
- |
|
|