Bugzilla – Attachment 129226 Details for
Bug 23352
Define serial's collection in the subscription
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23352: Database changes
Bug-23352-Database-changes.patch (text/plain), 1.99 KB, created by
Samu Heiskanen
on 2022-01-09 02:11:07 UTC
(
hide
)
Description:
Bug 23352: Database changes
Filename:
MIME Type:
Creator:
Samu Heiskanen
Created:
2022-01-09 02:11:07 UTC
Size:
1.99 KB
patch
obsolete
>From ee98e08d36811739824ab38e0ee37c28d8fd9423 Mon Sep 17 00:00:00 2001 >From: Alex Buckley <alexbuckley@catalyst.net.nz> >Date: Mon, 13 Dec 2021 13:56:38 +0000 >Subject: [PATCH] Bug 23352: Database changes > >Sponsored-By: Brimbank Library, Australia > >Signed-off-by: Samu Heiskanen <samu.heiskanen@hypernova.fi> >--- > ...52-add_ccode_column_to_subscriptions_table.pl | 16 ++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 17 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl b/installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl >new file mode 100644 >index 0000000000..c182576392 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl >@@ -0,0 +1,16 @@ >+use Modern::Perl; >+ >+{ >+ bug_number => "23352", >+ description => "Adding new column 'subscription.ccode'", >+ up => sub { >+ my ($args) = @_; >+ my $dbh = $args->{dbh}; >+ >+ if( !column_exists( 'subscription', 'ccode' ) ) { >+ $dbh->do(q{ >+ ALTER TABLE subscription ADD COLUMN `ccode` varchar(80) DEFAULT NULL AFTER `mana_id` >+ }); >+ } >+ }, >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index a309cea736..ac63fca7e6 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4824,6 +4824,7 @@ CREATE TABLE `subscription` ( > `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `mana_id` int(11) DEFAULT NULL, >+ `ccode` varchar(80) DEFAULT NULL COMMENT 'collection code to assign to serial items', > PRIMARY KEY (`subscriptionid`), > KEY `subscription_ibfk_1` (`periodicity`), > KEY `subscription_ibfk_2` (`numberpattern`), >-- >2.25.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 23352
:
91678
|
91679
|
91901
|
91985
|
91986
|
92149
|
92165
|
92166
|
95662
|
101913
|
101914
|
101916
|
129123
|
129124
|
129125
|
129225
|
129226
|
129227
|
129228
|
131426
|
131427
|
131435
|
131437
|
131438
|
131439
|
132920
|
133679
|
133680
|
133681
|
133682
|
133683
|
133786
|
133787
|
133788
|
133789
|
133790
|
163965