Bugzilla – Attachment 140144 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 followup) Add comment to new database column
Bug-7021-QA-followup-Add-comment-to-new-database-c.patch (text/plain), 1.40 KB, created by
Kyle M Hall (khall)
on 2022-09-02 13:34:08 UTC
(
hide
)
Description:
Bug 7021: (QA followup) Add comment to new database column
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2022-09-02 13:34:08 UTC
Size:
1.40 KB
patch
obsolete
>From 89c29818bde1961a0719abb21745e8dbedf8bd83 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Fri, 2 Sep 2022 13:33:38 +0000 >Subject: [PATCH] Bug 7021: (QA followup) Add comment to new database column > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > installer/data/mysql/kohastructure.sql | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index a406a7e510..8032db8a84 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, >+ `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.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 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