Attachment #141722 for bug #31716

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




use Modern::Perl;

return {
    bug_number => "31716",
    description => "Enlarge the size of the authorised_value column in authorised_values",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        # Do you stuffs here
        $dbh->do(q{
            ALTER TABLE authorised_values MODIFY COLUMN authorised_value varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'code use to identify the authorized value';
        });
        # Print useful stuff here
        say $out "Column enlarged";
    },
};

Lines 941-947 DROP TABLE IF EXISTS `authorised_values`; Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
941	CREATE TABLE `authorised_values` (	941	CREATE TABLE `authorised_values` (
942	`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the authorized value',	942	`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the authorized value',
943	`category` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'key used to identify the authorized value category',	943	`category` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'key used to identify the authorized value category',
944	`authorised_value` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'code use to identify the authorized value',	944	`authorised_value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'code use to identify the authorized value',
945	`lib` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value description as printed in the staff interface',	945	`lib` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value description as printed in the staff interface',
946	`lib_opac` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value description as printed in the OPAC',	946	`lib_opac` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value description as printed in the OPAC',
947	`imageurl` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value URL',	947	`imageurl` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value URL',

Lines 20-25 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt (-2 / +2 lines)
20	padding-bottom: 0;	20	padding-bottom: 0;
21	width: auto;	21	width: auto;
22	}	22	}
		23	#authorised_value,
23	#lib,	24	#lib,
24	#lib_opac {	25	#lib_opac {
25	width: 75%;	26	width: 75%;
Lines 137-143 Link Here
137	[% IF ( action_modify ) %]	138	[% IF ( action_modify ) %]
138	<input type="hidden" id="id" name="id" value="[% av.id \| html %]" />	139	<input type="hidden" id="id" name="id" value="[% av.id \| html %]" />
139	[% END %]	140	[% END %]
140	<input type="text" id="authorised_value" name="authorised_value" value="[% av.authorised_value \| html %]" maxlength="80" class="focus" />	141	<input type="text" id="authorised_value" name="authorised_value" value="[% av.authorised_value \| html %]" maxlength="255" class="focus" />
141	</li>	142	</li>
142	<li>	143	<li>
143	<label for="lib">Description: </label>	144	<label for="lib">Description: </label>
144	-

Return to bug 31716

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_31716_enlarge_av_column.pl (+16 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "31716",
	5	description => "Enlarge the size of the authorised_value column in authorised_values",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	# Do you stuffs here
	10	$dbh->do(q{
	11	ALTER TABLE authorised_values MODIFY COLUMN authorised_value varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'code use to identify the authorized value';
	12	});
	13	# Print useful stuff here
	14	say $out "Column enlarged";
	15	},
	16	};