Attachment 149629 Details for Bug 33103 – Bug 33103: Rename aqbookseller_aliases.id with alias_id

[patch] Bug 33103: Rename aqbookseller_aliases.id with alias_id

Bug-33103-Rename-aqbookselleraliasesid-with-aliasi.patch (text/plain), 3.04 KB, created by Jonathan Druart on 2023-04-14 06:06:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2023-04-14 06:06:33 UTC

Size: 3.04 KB

patch

obsolete

>From a0455c7f1a8201a24b5721525a77eb599cdb6d94 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>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

Actions: View | Diff | Splinter Review

Attachments on bug 33103: 147621 | 147622 | 147623 | 147624 | 147625 | 147626 | 147627 | 147628 | 147629 | 147630 | 147645 | 147646 | 147647 | 147648 | 147649 | 147650 | 147651 | 147652 | 147653 | 147654 | 147827 | 148448 | 148449 | 148450 | 148451 | 148452 | 148453 | 148454 | 148455 | 148456 | 148457 | 148458 | 149414 | 149419 | 149479 | 149480 | 149481 | 149482 | 149483 | 149484 | 149485 | 149486 | 149487 | 149488 | 149489 | 149490 | 149491 | 149606 | 149607 | 149608 | 149609 | 149629 | 149630 | 149788