Bugzilla – Attachment 149631 Details for
Bug 33104
Add vendor interfaces
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 33104: Rename interfaces.id with interface_id
Bug-33104-Rename-interfacesid-with-interfaceid.patch (text/plain), 3.36 KB, created by
Jonathan Druart
on 2023-04-14 06:15:21 UTC
(
hide
)
Description:
Bug 33104: Rename interfaces.id with interface_id
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2023-04-14 06:15:21 UTC
Size:
3.36 KB
patch
obsolete
>From 2bf493d5133a2e7b485ed296d838d4b88f739da5 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 33104
:
147632
|
147633
|
147634
|
147635
|
147636
|
147637
|
147638
|
147639
|
148459
|
148460
|
148461
|
148462
|
148463
|
148464
|
148465
|
148466
|
148473
|
148474
|
148475
|
148476
|
148477
|
148478
|
148479
|
148480
|
149375
|
149420
|
149421
|
149422
|
149431
|
149492
|
149493
|
149494
|
149495
|
149496
|
149497
|
149498
|
149499
|
149500
|
149501
|
149502
|
149503
| 149631 |
149632