From 23e75475097f7c45d5c69f7117b49956a18cd19c Mon Sep 17 00:00:00 2001 From: Brendan Lawlor Date: Tue, 29 Oct 2024 20:43:44 +0000 Subject: [PATCH] Bug 32773: Add column biblio_framework.is_fast_add Signed-off-by: Andrew Fuerste Henry --- .../data/mysql/atomicupdate/bug_32773.pl | 30 +++++++++++++++++++ installer/data/mysql/kohastructure.sql | 3 +- 2 files changed, 32 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_32773.pl diff --git a/installer/data/mysql/atomicupdate/bug_32773.pl b/installer/data/mysql/atomicupdate/bug_32773.pl new file mode 100644 index 00000000000..20b6d747d27 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_32773.pl @@ -0,0 +1,30 @@ +use Modern::Perl; +use Koha::Installer::Output qw(say_warning say_failure say_success say_info); + +return { + bug_number => "32773", + description => "Add ability to have more than 1 Fast Add framework", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + if ( !column_exists( 'biblio_framework', 'is_fast_add' ) ) { + $dbh->do( + q{ + ALTER TABLE biblio_framework + ADD COLUMN is_fast_add TINYINT(1) NOT NULL DEFAULT 0 + AFTER frameworktext; + } + ); + say_success( $out, "Added column 'biblio_framework.is_fast_add'" ); + $dbh->do( + q{ + UPDATE biblio_framework SET is_fast_add = 1 where frameworkcode = 'FA'; + } + ); + say_success( $out, "Set is_fast_add = 1 for FA framework'" ); + } else { + say_info( $out, "Column 'biblio_framework.is_fast_add' already exists!" ); + } + }, +}; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3bf15c1007d..558db75bded 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1126,6 +1126,7 @@ DROP TABLE IF EXISTS `biblio_framework`; CREATE TABLE `biblio_framework` ( `frameworkcode` varchar(4) NOT NULL DEFAULT '' COMMENT 'the unique code assigned to the framework', `frameworktext` varchar(255) NOT NULL DEFAULT '' COMMENT 'the description/name given to the framework', + `is_fast_add` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'the ability to be used as a Fast Add framework', PRIMARY KEY (`frameworkcode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -6755,4 +6756,4 @@ CREATE TABLE `zebraqueue` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-11-25 12:13:27 +-- Dump completed on 2024-11-25 12:13:27 \ No newline at end of file -- 2.34.1