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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 99-106 CREATE TABLE `authorised_values` ( -- stores values for authorized values catego Link Here
99
  `id` int(11) NOT NULL auto_increment, -- unique key, used to identify the authorized value
99
  `id` int(11) NOT NULL auto_increment, -- unique key, used to identify the authorized value
100
  `category` varchar(10) NOT NULL default '', -- key used to identify the authorized value category
100
  `category` varchar(10) NOT NULL default '', -- key used to identify the authorized value category
101
  `authorised_value` varchar(80) NOT NULL default '', -- code use to identify the authorized value
101
  `authorised_value` varchar(80) NOT NULL default '', -- code use to identify the authorized value
102
  `lib` varchar(80) default NULL, -- authorized value description as printed in the staff client
102
  `lib` varchar(200) default NULL, -- authorized value description as printed in the staff client
103
  `lib_opac` VARCHAR(80) default NULL, -- authorized value description as printed in the OPAC
103
  `lib_opac` varchar(200) default NULL, -- authorized value description as printed in the OPAC
104
  `imageurl` varchar(200) default NULL, -- authorized value URL
104
  `imageurl` varchar(200) default NULL, -- authorized value URL
105
  PRIMARY KEY  (`id`),
105
  PRIMARY KEY  (`id`),
106
  KEY `name` (`category`),
106
  KEY `name` (`category`),
(-)a/installer/data/mysql/updatedatabase.pl (+9 lines)
Lines 5696-5701 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
5696
    SetVersion($DBversion);
5696
    SetVersion($DBversion);
5697
}
5697
}
5698
5698
5699
$DBversion = "3.09.00.XXX";
5700
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
5701
    $dbh->do("ALTER TABLE authorised_values MODIFY lib varchar(200)");
5702
    $dbh->do("ALTER TABLE authorised_values MODIFY lib_opac varchar(200)");
5703
5704
    print "Upgrade to $DBversion done (Raise the length of Authorised Values descriptions)\n";
5705
    SetVersion($DBversion);
5706
}
5707
5699
=head1 FUNCTIONS
5708
=head1 FUNCTIONS
5700
5709
5701
=head2 TableExists($table)
5710
=head2 TableExists($table)
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt (-3 / +2 lines)
Lines 72-82 Link Here
72
        </li>
72
        </li>
73
        <li>
73
        <li>
74
            <label for="lib">Description</label>
74
            <label for="lib">Description</label>
75
            <input type="text" name="lib" id="lib" value="[% lib %]" maxlength="80" />
75
            <input type="text" name="lib" id="lib" value="[% lib %]" maxlength="200" />
76
        </li>
76
        </li>
77
	<li>
77
	<li>
78
            <label for="lib_opac">Description (OPAC)</label>
78
            <label for="lib_opac">Description (OPAC)</label>
79
            <input type="text" name="lib_opac" id="lib_opac" value="[% lib_opac %]" maxlength="80" />
79
            <input type="text" name="lib_opac" id="lib_opac" value="[% lib_opac %]" maxlength="200" />
80
        </li>
80
        </li>
81
		</ol>
81
		</ol>
82
        <div id="icons" class="toptabs" style="clear:both">
82
        <div id="icons" class="toptabs" style="clear:both">
83
- 

Return to bug 8757