View | Details | Raw Unified | Return to bug 33104
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_33104.pl (-2 / +2 lines)
Lines 9-15 return { Link Here
9 
        unless ( TableExists('aqbookseller_interfaces') ) {
 9 
        unless ( TableExists('aqbookseller_interfaces') ) {
10 
            $dbh->do(q{
 10 
            $dbh->do(q{
11 
                CREATE TABLE `aqbookseller_interfaces` (
 11 
                CREATE TABLE `aqbookseller_interfaces` (
12 
                  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha',
 12 
                  `interface_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha',
13 
                  `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor',
 13 
                  `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor',
14 
                  `type` varchar(80) DEFAULT NULL COMMENT "type of the interface, authorised value VENDOR_INTERFACE_TYPE",
 14 
                  `type` varchar(80) DEFAULT NULL COMMENT "type of the interface, authorised value VENDOR_INTERFACE_TYPE",
15 
                  `name` varchar(255) NOT NULL COMMENT 'name of the interface',
 15 
                  `name` varchar(255) NOT NULL COMMENT 'name of the interface',
Lines 18-24 return { Link Here
18 
                  `password` mediumtext DEFAULT NULL COMMENT 'hashed password',
 18 
                  `password` mediumtext DEFAULT NULL COMMENT 'hashed password',
19 
                  `account_email` mediumtext DEFAULT NULL COMMENT 'account email',
 19 
                  `account_email` mediumtext DEFAULT NULL COMMENT 'account email',
20 
                  `notes` longtext DEFAULT NULL COMMENT 'notes',
 20 
                  `notes` longtext DEFAULT NULL COMMENT 'notes',
21 
                  PRIMARY KEY (`id`),
 21 
                  PRIMARY KEY (`interface_id`),
22 
                  CONSTRAINT `aqbookseller_interfaces_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
 22 
                  CONSTRAINT `aqbookseller_interfaces_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
23 
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 23 
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
24 
            });
 24 
            });
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
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 
-

Return to bug 33104