Bugzilla – Attachment 140845 Details for
Bug 7021
Add patron category to the statistics table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 7021: (QA follow-up) Fix typo
Bug-7021-QA-follow-up-Fix-typo.patch (text/plain), 2.33 KB, created by
Tomás Cohen Arazi (tcohen)
on 2022-09-22 12:37:35 UTC
(
hide
)
Description:
Bug 7021: (QA follow-up) Fix typo
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2022-09-22 12:37:35 UTC
Size:
2.33 KB
patch
obsolete
>From 506246793450cfe6a70d7a8dce0ffa62afd105a0 Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >Date: Thu, 22 Sep 2022 09:37:07 -0300 >Subject: [PATCH] Bug 7021: (QA follow-up) Fix typo > >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> >--- > installer/data/mysql/atomicupdate/bug_7201.pl | 7 ++++--- > installer/data/mysql/kohastructure.sql | 2 +- > 2 files changed, 5 insertions(+), 4 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_7201.pl b/installer/data/mysql/atomicupdate/bug_7201.pl >index 5df49de4fb..5e030823a8 100755 >--- a/installer/data/mysql/atomicupdate/bug_7201.pl >+++ b/installer/data/mysql/atomicupdate/bug_7201.pl >@@ -8,9 +8,10 @@ return { > my ($dbh, $out) = @$args{qw(dbh out)}; > > if( !column_exists( 'statistics', 'categorycode' ) ) { >- $dbh->do( >- "ALTER TABLE statistics ADD COLUMN categorycode varchar(10) AFTER ccode" >- ); >+ $dbh->do(q{ >+ ALTER TABLE statistics >+ ADD COLUMN categorycode varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category' >+ }); > } > }, > }; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 27760125e0..ce0c4eacc5 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4937,7 +4937,7 @@ CREATE TABLE `statistics` ( > `location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', > `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower', > `ccode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code', >- `categorycode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category',, >+ `categorycode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category', > KEY `timeidx` (`datetime`), > KEY `branch_idx` (`branch`), > KEY `type_idx` (`type`), >-- >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 7021
:
29456
|
29508
|
122881
|
122882
|
122883
|
129119
|
129120
|
129121
|
129122
|
135269
|
135270
|
135271
|
135272
|
135273
|
135274
|
140103
|
140104
|
140105
|
140106
|
140107
|
140108
|
140109
|
140110
|
140116
|
140144
| 140845