Bugzilla – Attachment 177860 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.85 KB, created by
Jonathan Druart
on 2025-02-12 13:25:52 UTC
(
hide
)
Description:
Bug 32773: Add column biblio_framework.is_fast_add
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2025-02-12 13:25:52 UTC
Size:
2.85 KB
patch
obsolete
>From 23e75475097f7c45d5c69f7117b49956a18cd19c 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 | 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
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