From 97bea39b05e49e84817fbaf1fb02933c47774986 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Tue, 10 Feb 2026 16:54:01 +0000 Subject: [PATCH] Bug 28530: (RM follow-up) Move kohastructure update to right place alphabetically --- installer/data/mysql/kohastructure.sql | 32 +++++++++++++++----------- 1 file changed, 18 insertions(+), 14 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 912784ec608..1222ef6387c 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4460,6 +4460,24 @@ CREATE TABLE `letter` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `library_float_limits` +-- + +DROP TABLE IF EXISTS `library_float_limits`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8mb4 */; +CREATE TABLE `library_float_limits` ( + `branchcode` varchar(10) NOT NULL, + `itemtype` varchar(10) NOT NULL, + `float_limit` int(11) DEFAULT NULL, + PRIMARY KEY (`branchcode`,`itemtype`), + KEY `itemtype_idx` (`itemtype`), + CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) 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 `library_groups` -- @@ -6887,20 +6905,6 @@ CREATE TABLE `transport_cost` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -DROP TABLE IF EXISTS `library_float_limits`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `library_float_limits` ( - `branchcode` varchar(10) NOT NULL, - `itemtype` varchar(10) NOT NULL, - `float_limit` int(11) NULL DEFAULT NULL, - PRIMARY KEY (`branchcode`,`itemtype`), - KEY `itemtype_idx` (`itemtype`), - CONSTRAINT `library_float_limits_ibfk_bc` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `library_float_limits_ibfk_it` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) 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 `uploaded_files` -- -- 2.39.5