From 1fbf6fc78c10c74da7011bd26597d03a6500d738 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Tom=C3=A1s=20Cohen=20Arazi?= Date: Wed, 29 Oct 2025 09:35:15 -0300 Subject: [PATCH] Bug 40841: DB changes --- .../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 00000000000..7d79a8cce61 --- /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 ce39d6a933f..e483748b93b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -6823,6 +6823,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.51.2