From 2bf493d5133a2e7b485ed296d838d4b88f739da5 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 14 Apr 2023 08:14:47 +0200 Subject: [PATCH] Bug 33104: Rename interfaces.id with interface_id --- installer/data/mysql/atomicupdate/bug_33104.pl | 4 ++-- installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_33104.pl b/installer/data/mysql/atomicupdate/bug_33104.pl index 0fb650ca02f..1c1b3a820aa 100755 --- a/installer/data/mysql/atomicupdate/bug_33104.pl +++ b/installer/data/mysql/atomicupdate/bug_33104.pl @@ -9,7 +9,7 @@ return { unless ( TableExists('aqbookseller_interfaces') ) { $dbh->do(q{ CREATE TABLE `aqbookseller_interfaces` ( - `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', + `interface_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', `type` varchar(80) DEFAULT NULL COMMENT "type of the interface, authorised value VENDOR_INTERFACE_TYPE", `name` varchar(255) NOT NULL COMMENT 'name of the interface', @@ -18,7 +18,7 @@ return { `password` mediumtext DEFAULT NULL COMMENT 'hashed password', `account_email` mediumtext DEFAULT NULL COMMENT 'account email', `notes` longtext DEFAULT NULL COMMENT 'notes', - PRIMARY KEY (`id`), + PRIMARY KEY (`interface_id`), CONSTRAINT `aqbookseller_interfaces_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; }); diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index a47a44ae1ed..ade1b4f58cb 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -448,7 +448,7 @@ DROP TABLE IF EXISTS `aqbookseller_interfaces`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `aqbookseller_interfaces` ( - `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', + `interface_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', `type` varchar(80) DEFAULT NULL COMMENT "type of the interface, authorised value VENDOR_INTERFACE_TYPE", `name` varchar(255) NOT NULL COMMENT 'name of the interface', @@ -457,7 +457,7 @@ CREATE TABLE `aqbookseller_interfaces` ( `password` mediumtext DEFAULT NULL COMMENT 'hashed password', `account_email` mediumtext DEFAULT NULL COMMENT 'account email', `notes` longtext DEFAULT NULL COMMENT 'notes', - PRIMARY KEY (`id`), + PRIMARY KEY (`interface_id`), CONSTRAINT `aqbookseller_interfaces_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- 2.25.1