Bugzilla – Attachment 9287 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]
Bug 8002 - Can't add patron attribute type in newer installation
Bug-8002---Cant-add-patron-attribute-type-in-newer.patch (text/plain), 1.89 KB, created by
Owen Leonard
on 2012-04-24 15:26:03 UTC
(
hide
)
Description:
Bug 8002 - Can't add patron attribute type in newer installation
Filename:
MIME Type:
Creator:
Owen Leonard
Created:
2012-04-24 15:26:03 UTC
Size:
1.89 KB
patch
obsolete
>From 60375f259641e029a780a05281df94c6807d335d Mon Sep 17 00:00:00 2001 >From: Owen Leonard <oleonard@myacpl.org> >Date: Tue, 24 Apr 2012 11:20:42 -0400 >Subject: [PATCH] Bug 8002 - Can't add patron attribute type in newer > installation >Content-Type: text/plain; charset="utf-8" > >Correcting patron_attributes_types definition in kohastructure.sql >to allow NULL entries for category_code, matching the definition >specified in updatedatabase.pl. > >To test: Back up your Koha database, drop it, and recreate it. >Load the staff interface and go through the web installer. After >recreating the database enable ExtendedPatronAttributes and >try adding a new patron attribute type with no patron category >specified. The operation should be successful. >--- > installer/data/mysql/kohastructure.sql | 2 +- > 1 files changed, 1 insertions(+), 1 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index a210293..488a4f0 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) NOT NULL DEFAULT '',-- defines a category for an attribute_type >+ `category_code` VARCHAR(1) 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`) >-- >1.7.5.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