View | Details | Raw Unified | Return to bug 36153
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_36153_-_increase_authorised_value_description_lengths.pl (+30 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "36153",
5
    description => "Increase allowed length of authorized value descriptions",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        if ( column_exists( 'authorised_values', 'lib' ) ) {
11
            $dbh->do(
12
                q{
13
              ALTER TABLE authorised_values MODIFY COLUMN `lib` varchar(400) DEFAULT NULL COMMENT 'authorized value description as printed in the staff interface'
14
          }
15
            );
16
17
            say $out "Increase length of 'authorised_values.lib' to 400 characters";
18
        }
19
20
        if ( column_exists( 'authorised_values', 'lib_opac' ) ) {
21
            $dbh->do(
22
                q{
23
              ALTER TABLE authorised_values MODIFY COLUMN `lib_opac` varchar(400) DEFAULT NULL COMMENT 'authorized value description as printed in the OPAC'
24
          }
25
            );
26
27
            say $out "Increase length of 'authorised_values.lib_opac' to 400 characters";
28
        }
29
    },
30
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 1023-1030 CREATE TABLE `authorised_values` ( Link Here
1023
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the authorized value',
1023
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the authorized value',
1024
  `category` varchar(32) NOT NULL DEFAULT '' COMMENT 'key used to identify the authorized value category',
1024
  `category` varchar(32) NOT NULL DEFAULT '' COMMENT 'key used to identify the authorized value category',
1025
  `authorised_value` varchar(80) NOT NULL DEFAULT '' COMMENT 'code use to identify the authorized value',
1025
  `authorised_value` varchar(80) NOT NULL DEFAULT '' COMMENT 'code use to identify the authorized value',
1026
  `lib` varchar(200) DEFAULT NULL COMMENT 'authorized value description as printed in the staff interface',
1026
  `lib` varchar(400) DEFAULT NULL COMMENT 'authorized value description as printed in the staff interface',
1027
  `lib_opac` varchar(200) DEFAULT NULL COMMENT 'authorized value description as printed in the OPAC',
1027
  `lib_opac` varchar(400) DEFAULT NULL COMMENT 'authorized value description as printed in the OPAC',
1028
  `imageurl` varchar(200) DEFAULT NULL COMMENT 'authorized value URL',
1028
  `imageurl` varchar(200) DEFAULT NULL COMMENT 'authorized value URL',
1029
  PRIMARY KEY (`id`),
1029
  PRIMARY KEY (`id`),
1030
  UNIQUE KEY `av_uniq` (`category`,`authorised_value`),
1030
  UNIQUE KEY `av_uniq` (`category`,`authorised_value`),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt (-4 / +3 lines)
Lines 150-160 Link Here
150
                                    </li>
150
                                    </li>
151
                                    <li>
151
                                    <li>
152
                                        <label for="lib">Description: </label>
152
                                        <label for="lib">Description: </label>
153
                                        <input type="text" name="lib" id="lib" value="[% av.lib | html %]" maxlength="200" />
153
                                        <input type="text" name="lib" id="lib" value="[% av.lib | html %]" maxlength="400" />
154
                                    </li>
154
                                    </li>
155
                                    <li>
155
                                    <li>
156
                                        <label for="lib_opac">Description (OPAC): </label>
156
                                        <label for="lib_opac">Description (OPAC): </label>
157
                                        <input type="text" name="lib_opac" id="lib_opac" value="[% av.lib_opac | html %]" maxlength="200" />
157
                                        <input type="text" name="lib_opac" id="lib_opac" value="[% av.lib_opac | html %]" maxlength="400" />
158
                                    </li>
158
                                    </li>
159
                                    <li><label for="branches">Library limitations: </label>
159
                                    <li><label for="branches">Library limitations: </label>
160
                                        <select id="branches" name="branches" multiple size="10">
160
                                        <select id="branches" name="branches" multiple size="10">
Lines 402-408 Link Here
402
        [% CASE 'AUSTLANG' %]
402
        [% CASE 'AUSTLANG' %]
403
            <p>Indigenous Australian languages, sourced from <a href="https://collection.aiatsis.gov.au/datasets/austlang/001">the Australian Institute of Aboriginal and Torres Strait Islander Studies (AIATSIS)</a></p>
403
            <p>Indigenous Australian languages, sourced from <a href="https://collection.aiatsis.gov.au/datasets/austlang/001">the Australian Institute of Aboriginal and Torres Strait Islander Studies (AIATSIS)</a></p>
404
        [% CASE 'BOR_NOTES' %]
404
        [% CASE 'BOR_NOTES' %]
405
            <p>Values for custom patron messages that appear on the circulation screen and the OPAC. The value in the description field should be the message text and is limited to 200 characters</p>
405
            <p>Values for custom patron messages that appear on the circulation screen and the OPAC. The value in the description field should be the message text and is limited to 400 characters</p>
406
        [% CASE 'branches' %]
406
        [% CASE 'branches' %]
407
            <p></p>
407
            <p></p>
408
        [% CASE 'Bsort1' %]
408
        [% CASE 'Bsort1' %]
409
- 

Return to bug 36153