Attachment 60121 Details for Bug 18097 – Bug 18097 - Update kohastructure.pl

[patch] Bug 18097 - Update kohastructure.pl

Bug-18097---Update-kohastructurepl.patch (text/plain), 6.65 KB, created by Kyle M Hall (khall) on 2017-02-10 16:25:56 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2017-02-10 16:25:56 UTC

Size: 6.65 KB

patch

obsolete

>From ce58b4650ec34f02d45d31d3c1e1f7ba7b1974a5 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@kylehall.info>
>Date: Fri, 10 Feb 2017 11:25:30 -0500
>Subject: [PATCH] Bug 18097 - Update kohastructure.pl
>
>---
> installer/data/mysql/kohastructure.sql | 20 ++++++++++----------
> 1 file changed, 10 insertions(+), 10 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index b75bcc9..4b45a75 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -61,7 +61,7 @@ CREATE TABLE `auth_subfield_structure` (
>   `repeatable` tinyint(4) NOT NULL default 0,
>   `mandatory` tinyint(4) NOT NULL default 0,
>   `tab` tinyint(1) default NULL,
>-  `authorised_value` varchar(10) default NULL,
>+  `authorised_value` varchar(80) default NULL,
>   `value_builder` varchar(80) default NULL,
>   `seealso` varchar(255) default NULL,
>   `isurl` tinyint(1) default NULL,
>@@ -87,7 +87,7 @@ CREATE TABLE `auth_tag_structure` (
>   `libopac` varchar(255) NOT NULL default '',
>   `repeatable` tinyint(4) NOT NULL default 0,
>   `mandatory` tinyint(4) NOT NULL default 0,
>-  `authorised_value` varchar(10) default NULL,
>+  `authorised_value` varchar(80) default NULL,
>   PRIMARY KEY  (`authtypecode`,`tagfield`),
>   CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>@@ -647,7 +647,7 @@ CREATE TABLE `deleteditems` (
>   `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
>   `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
>   `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
>-  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
>+  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
>   `materials` text default NULL, -- materials specified (MARC21 952$3)
>   `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
>   `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
>@@ -888,7 +888,7 @@ CREATE TABLE `items` ( -- holdings/item information
>   `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
>   `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
>   `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
>-  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
>+  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
>   `materials` text default NULL, -- materials specified (MARC21 952$3)
>   `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
>   `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
>@@ -1071,7 +1071,7 @@ CREATE TABLE `marc_subfield_structure` (
>   `mandatory` tinyint(4) NOT NULL default 0,
>   `kohafield` varchar(40) default NULL,
>   `tab` tinyint(1) default NULL,
>-  `authorised_value` varchar(20) default NULL,
>+  `authorised_value` varchar(80) default NULL,
>   `authtypecode` varchar(20) default NULL,
>   `value_builder` varchar(80) default NULL,
>   `isurl` tinyint(1) default NULL,
>@@ -1098,7 +1098,7 @@ CREATE TABLE `marc_tag_structure` (
>   `libopac` varchar(255) NOT NULL default '',
>   `repeatable` tinyint(4) NOT NULL default 0,
>   `mandatory` tinyint(4) NOT NULL default 0,
>-  `authorised_value` varchar(10) default NULL,
>+  `authorised_value` varchar(80) default NULL,
>   `frameworkcode` varchar(4) NOT NULL default '',
>   PRIMARY KEY  (`frameworkcode`,`tagfield`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>@@ -1847,7 +1847,7 @@ CREATE TABLE `statistics` ( -- information related to transactions (circulation
>   `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
>   `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
>   `associatedborrower` int(11) default NULL, -- unused in Koha
>-  `ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code
>+  `ccode` varchar(80) default NULL, -- foreign key from the items table, links transaction to a specific collection code
>   KEY `timeidx` (`datetime`),
>   KEY `branch_idx` (`branch`),
>   KEY `proccode_idx` (`proccode`),
>@@ -2508,7 +2508,7 @@ CREATE TABLE branch_transfer_limits (
>     toBranch varchar(10) NOT NULL,
>     fromBranch varchar(10) NOT NULL,
>     itemtype varchar(10) NULL,
>-    ccode varchar(10) NULL,
>+    ccode varchar(80) NULL,
>     PRIMARY KEY  (limitId)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
> 
>@@ -3417,7 +3417,7 @@ CREATE TABLE `additional_fields` (
>   `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
>   `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
>   `name` varchar(255) NOT NULL DEFAULT '', -- name of the field
>-  `authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category
>+  `authorised_value_category` varchar(32) NOT NULL DEFAULT '', -- is an authorised value category
>   `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
>   `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
>   PRIMARY KEY (`id`),
>@@ -3528,7 +3528,7 @@ CREATE TABLE `course_items` (
>   `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
>   `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
>   `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
>-  `ccode` varchar(10) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
>+  `ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
>   `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
>   `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
>   `enabled` enum('yes','no') NOT NULL DEFAULT 'no', -- if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 18097: 60121 | 60656