Bugzilla – Attachment 166522 Details for
Bug 30047
Add a field to auth_header to record main heading as text string
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 30047: DB Updates
Bug-30047-DB-Updates.patch (text/plain), 1.99 KB, created by
Marcel de Rooy
on 2024-05-10 09:52:23 UTC
(
hide
)
Description:
Bug 30047: DB Updates
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2024-05-10 09:52:23 UTC
Size:
1.99 KB
patch
obsolete
>From 70739e16bad791fd937fc204671ded157b8527ba Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Fri, 19 Jan 2024 14:19:32 +0000 >Subject: [PATCH] Bug 30047: DB Updates >Content-Type: text/plain; charset=utf-8 > >Signed-off-by: Andrew Fuerste-Henry <andrewfh@dubcolib.org> > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > .../data/mysql/atomicupdate/bug_30047.pl | 20 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 21 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_30047.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_30047.pl b/installer/data/mysql/atomicupdate/bug_30047.pl >new file mode 100755 >index 0000000000..7f2855afb8 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_30047.pl >@@ -0,0 +1,20 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "30047", >+ description => "Add thesaurus and heading fields to auth_header table", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ if ( !column_exists( 'auth_header', 'heading' ) ) { >+ $dbh->do( >+ q{ >+ ALTER TABLE auth_header ADD COLUMN `heading` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER `modification_time` >+ } >+ ); >+ say $out "Added column 'auth_header.heading'"; >+ } >+ >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 452103bfb3..51506b456a 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -920,6 +920,7 @@ CREATE TABLE `auth_header` ( > `authtypecode` varchar(10) NOT NULL DEFAULT '', > `datecreated` date DEFAULT NULL, > `modification_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), >+ `heading` longtext DEFAULT NULL, > `origincode` varchar(20) DEFAULT NULL, > `authtrees` longtext DEFAULT NULL, > `marc` blob DEFAULT NULL, >-- >2.30.2
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 30047
:
161208
|
161209
|
161210
|
161211
|
161213
|
161214
|
161215
|
161216
| 166522 |
166523
|
166524
|
166525
|
166644