From a0455c7f1a8201a24b5721525a77eb599cdb6d94 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 14 Apr 2023 08:05:58 +0200 Subject: [PATCH] Bug 33103: Rename aqbookseller_aliases.id with alias_id --- api/v1/swagger/definitions/vendor_alias.yaml | 2 +- installer/data/mysql/atomicupdate/bug_33103.pl | 4 ++-- installer/data/mysql/kohastructure.sql | 4 ++-- 3 files changed, 5 insertions(+), 5 deletions(-) diff --git a/api/v1/swagger/definitions/vendor_alias.yaml b/api/v1/swagger/definitions/vendor_alias.yaml index 0a9f9ef17bb..435388524bd 100644 --- a/api/v1/swagger/definitions/vendor_alias.yaml +++ b/api/v1/swagger/definitions/vendor_alias.yaml @@ -1,7 +1,7 @@ --- type: object properties: - id: + alias_id: description: Internal ID for the extended attribute type: integer vendor_id: diff --git a/installer/data/mysql/atomicupdate/bug_33103.pl b/installer/data/mysql/atomicupdate/bug_33103.pl index cd06f7835b8..2db6e9a8d28 100755 --- a/installer/data/mysql/atomicupdate/bug_33103.pl +++ b/installer/data/mysql/atomicupdate/bug_33103.pl @@ -9,10 +9,10 @@ return { unless ( TableExists('aqbookseller_aliases') ) { $dbh->do(q{ CREATE TABLE `aqbookseller_aliases` ( - `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', + `alias_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', `alias` varchar(255) NOT NULL COMMENT "the alias", - PRIMARY KEY (`id`), + PRIMARY KEY (`alias_id`), CONSTRAINT `aqbookseller_aliases_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 4651cf9de51..e92ffc11210 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -432,10 +432,10 @@ DROP TABLE IF EXISTS `aqbookseller_aliases`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `aqbookseller_aliases` ( - `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', + `alias_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', `alias` varchar(255) NOT NULL COMMENT "the alias", - PRIMARY KEY (`id`), + PRIMARY KEY (`alias_id`), CONSTRAINT `aqbookseller_aliases_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