Bugzilla – Attachment 176927 Details for
Bug 32773
Have the ability to have more than 1 Fast Add framework
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32773: Add column biblio_framework.is_fast_add
Bug-32773-Add-column-biblioframeworkisfastadd.patch (text/plain), 2.57 KB, created by
Brendan Lawlor
on 2025-01-22 19:47:41 UTC
(
hide
)
Description:
Bug 32773: Add column biblio_framework.is_fast_add
Filename:
MIME Type:
Creator:
Brendan Lawlor
Created:
2025-01-22 19:47:41 UTC
Size:
2.57 KB
patch
obsolete
>From 51a39f8cc05e6d1183039da0c08f12393ee0b43e Mon Sep 17 00:00:00 2001 >From: Brendan Lawlor <blawlor@clamsnet.org> >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 <andrew@bywatersolutions.com> >--- > .../data/mysql/atomicupdate/bug_32773.pl | 30 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 31 insertions(+) > create mode 100755 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 100755 >index 0000000000..20b6d747d2 >--- /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 3bf15c1007..2c8f5987a2 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 */; >-- >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 32773
:
173401
|
173417
|
173878
|
173879
|
173880
|
173881
|
173882
|
173883
|
173954
|
173955
|
173956
|
173957
|
173958
|
173959
|
173960
|
173961
|
174028
|
174029
|
174030
|
174031
|
174032
|
174033
|
174034
|
174035
|
176927
|
176928
|
176929
|
176930
|
176931
|
176932
|
176933
|
176934
|
176935
|
177860
|
177861
|
177862
|
177863
|
177864
|
177865
|
177866
|
177867