Bugzilla – Attachment 189521 Details for
Bug 40841
Limit z39.50 targets to specific branches
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 40841: DB changes
Bug-40841-DB-changes.patch (text/plain), 3.43 KB, created by
David Nind
on 2025-11-12 19:27:58 UTC
(
hide
)
Description:
Bug 40841: DB changes
Filename:
MIME Type:
Creator:
David Nind
Created:
2025-11-12 19:27:58 UTC
Size:
3.43 KB
patch
obsolete
>From fca95de1bf1cd849bad64a7acab91d4ca9522249 Mon Sep 17 00:00:00 2001 >From: =?UTF-8?q?Tom=C3=A1s=20Cohen=20Arazi?= <tomascohen@theke.io> >Date: Wed, 29 Oct 2025 09:35:15 -0300 >Subject: [PATCH] Bug 40841: DB changes >MIME-Version: 1.0 >Content-Type: text/plain; charset=UTF-8 >Content-Transfer-Encoding: 8bit > >Signed-off-by: Tomás Cohen Arazi <tomascohen@theke.io> >Signed-off-by: David Nind <david@davidnind.com> >--- > .../bug_40841_z3950_library_limits.pl | 26 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 17 ++++++++++++ > 2 files changed, 43 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_40841_z3950_library_limits.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_40841_z3950_library_limits.pl b/installer/data/mysql/atomicupdate/bug_40841_z3950_library_limits.pl >new file mode 100755 >index 0000000000..7d79a8cce6 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_40841_z3950_library_limits.pl >@@ -0,0 +1,26 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "40841", >+ description => "Add library limits support for Z39.50 servers", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ unless ( TableExists('z3950servers_branches') ) { >+ $dbh->do( >+ q{ >+ CREATE TABLE z3950servers_branches ( >+ server_id int(11) NOT NULL COMMENT 'z3950server id', >+ branchcode varchar(10) NOT NULL COMMENT 'branch code', >+ PRIMARY KEY (server_id,branchcode), >+ KEY z3950servers_branches_ibfk_2 (branchcode), >+ CONSTRAINT z3950servers_branches_ibfk_1 FOREIGN KEY (server_id) REFERENCES z3950servers (id) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT z3950servers_branches_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE >+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci >+ } >+ ); >+ say $out "Added z3950servers_branches table for library limits"; >+ } >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index d3b36dca87..9199db70dd 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -6849,6 +6849,23 @@ CREATE TABLE `z3950servers` ( > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > >+-- >+-- Table structure for table `z3950servers_branches` >+-- >+ >+DROP TABLE IF EXISTS `z3950servers_branches`; >+/*!40101 SET @saved_cs_client = @@character_set_client */; >+/*!40101 SET character_set_client = utf8mb4 */; >+CREATE TABLE `z3950servers_branches` ( >+ `server_id` int(11) NOT NULL COMMENT 'z3950server id', >+ `branchcode` varchar(10) NOT NULL COMMENT 'branch code', >+ PRIMARY KEY (`server_id`,`branchcode`), >+ KEY `z3950servers_branches_ibfk_2` (`branchcode`), >+ CONSTRAINT `z3950servers_branches_ibfk_1` FOREIGN KEY (`server_id`) REFERENCES `z3950servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `z3950servers_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+/*!40101 SET character_set_client = @saved_cs_client */; >+ > -- > -- Table structure for table `zebraqueue` > -- >-- >2.39.5
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 40841
:
188587
|
188588
|
188589
|
188590
|
188591
|
188597
|
188598
|
188599
|
188600
|
188601
|
188602
|
188603
|
188604
|
188605
|
188606
|
189497
|
189498
|
189499
|
189500
|
189501
| 189521 |
189522
|
189523
|
189524
|
189525