From 7be376e142e5d9a30f8353928929ce112a5abaf4 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Wed, 2 Apr 2025 12:54:58 +0000 Subject: [PATCH] Bug 37054: Amend DBUpdate --- .../data/mysql/atomicupdate/bug_37054_add_branchcolor.pl | 9 ++++----- installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 6 insertions(+), 7 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_37054_add_branchcolor.pl b/installer/data/mysql/atomicupdate/bug_37054_add_branchcolor.pl index 8bb54539bc5..669ea04751f 100755 --- a/installer/data/mysql/atomicupdate/bug_37054_add_branchcolor.pl +++ b/installer/data/mysql/atomicupdate/bug_37054_add_branchcolor.pl @@ -3,21 +3,20 @@ use Koha::Installer::Output qw(say_warning say_failure say_success say_info); return { bug_number => "37054", - description => "Add branches.branchcolor", + description => "Add branches.library_color", up => sub { my ($args) = @_; my ( $dbh, $out ) = @$args{qw(dbh out)}; - if ( !column_exists( 'branches', 'branchcolor' ) ) { + if ( !column_exists( 'branches', 'library_color' ) ) { $dbh->do( q{ ALTER TABLE branches - ADD COLUMN `branchcolor` varchar(16) DEFAULT 0 COMMENT 'defines the branch color' + ADD COLUMN `library_color` varchar(16) DEFAULT 0 COMMENT 'defines the branch color' AFTER `opacusercss` } ); } - say $out "Added column 'branch.branchcolor'"; - + say $out "Added column 'branch.library_color'"; }, }; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 6767dea39a7..a86792fe239 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1678,7 +1678,7 @@ CREATE TABLE `branches` ( `public` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'whether this library should show in the opac', `opacuserjs` longtext DEFAULT NULL COMMENT 'branch specific javascript for the OPAC', `opacusercss` longtext DEFAULT NULL COMMENT 'branch specific css for the OPAC', - `branchcolor` varchar(16) DEFAULT NULL COMMENT 'branch specific color', + `library_color` varchar(16) DEFAULT NULL COMMENT 'library specific color', PRIMARY KEY (`branchcode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -6799,4 +6799,4 @@ CREATE TABLE `zebraqueue` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2025-05-26 13:26:31 +-- Dump completed on 2024-11-25 12:13:27 -- 2.39.5