Bugzilla – Attachment 12034 Details for
Bug 8002
Can't add patron attribute type in newer installation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[3.8.X] Bug 8002: FIX Change datatype from varchar 1 to 10 for borrower_attribute_types.category_code
0001-Bug-8002-FIX-Change-datatype-from-varchar-1-to-10-fo.patch (text/plain), 2.49 KB, created by
Jonathan Druart
on 2012-09-07 07:29:10 UTC
(
hide
)
Description:
[3.8.X] Bug 8002: FIX Change datatype from varchar 1 to 10 for borrower_attribute_types.category_code
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2012-09-07 07:29:10 UTC
Size:
2.49 KB
patch
obsolete
>From 6586eb228af7f3a3749a959fc3843dc03591d1f9 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Thu, 6 Sep 2012 16:03:42 +0200 >Subject: [PATCH 1/1] Bug 8002: FIX Change datatype from varchar 1 to 10 for > borrower_attribute_types.category_code > >--- > installer/data/mysql/kohastructure.sql | 2 +- > installer/data/mysql/updatedatabase.pl | 7 +++++++ > 2 files changed, 8 insertions(+), 1 deletion(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 488a4f0..8648e18 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -286,7 +286,7 @@ CREATE TABLE `borrower_attribute_types` ( -- definitions for custom patron field > `staff_searchable` tinyint(1) NOT NULL default 0, -- defines if this field is searchable via the patron search in the staff client (1 for yes, 0 for no) > `authorised_value_category` varchar(10) default NULL, -- foreign key from authorised_values that links this custom field to an authorized value category > `display_checkout` tinyint(1) NOT NULL default 0,-- defines if this field displays in checkout screens >- `category_code` VARCHAR(1) NULL DEFAULT NULL,-- defines a category for an attribute_type >+ `category_code` VARCHAR(10) NULL DEFAULT NULL,-- defines a category for an attribute_type > `class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type > PRIMARY KEY (`code`), > KEY `auth_val_cat_idx` (`authorised_value_category`) >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 1887d5f..2db10c9 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -5263,6 +5263,13 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > SetVersion ($DBversion); > } > >+$DBversion = "3.08.00.XXX"; >+if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { >+ $dbh->do("ALTER TABLE borrower_attribute_types MODIFY category_code VARCHAR( 10 ) NULL DEFAULT NULL"); >+ print "Upgrade to $DBversion done. (Bug 8002: Update patron attribute types table from varchar(1) to varchar(10) category_code)\nWarning to Koha System Administrators: If you use borrower attributes defined by borrower categories, you have to check your configuration. A bug may have removed your attribute links to borrower categories.\nPlease check, and fix it if necessary."; >+ SetVersion($DBversion); >+} >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >1.7.10.4 >
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 8002
:
9287
|
9288
|
9311
|
9367
|
12011
|
12012
|
12033
| 12034 |
12206