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