Attachment #21834 for bug #10363

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

Lines 103-108 CREATE TABLE `authorised_values` ( -- stores values for authorized values catego Link Here

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
103	`lib_opac` varchar(200) 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	UNIQUE KEY `av_uniq` (`category`,`authorised_value`),
106	KEY `name` (`category`),	107	KEY `name` (`category`),
107	KEY `lib` (`lib`),	108	KEY `lib` (`lib`),
108	KEY `auth_value_idx` (`authorised_value`)	109	KEY `auth_value_idx` (`authorised_value`)




    SetVersion ($DBversion);
}




$DBversion = "3.13.00.XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do(q{
        ALTER TABLE authorised_values ADD UNIQUE KEY av_uniq(category, authorised_value);
    });
    print "Upgrade to $DBversion done (Bug XXXXX: Add unique key on the authorised_values table)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 10363

Lines 7169-7174 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +12 lines)
7169	SetVersion ($DBversion);	7169	SetVersion ($DBversion);
7170	}	7170	}
7171		7171
		7172
		7173
		7174
		7175	$DBversion = "3.13.00.XXX";
		7176	if ( CheckVersion($DBversion) ) {
		7177	$dbh->do(q{
		7178	ALTER TABLE authorised_values ADD UNIQUE KEY av_uniq(category, authorised_value);
		7179	});
		7180	print "Upgrade to $DBversion done (Bug XXXXX: Add unique key on the authorised_values table)\n";
		7181	SetVersion($DBversion);
		7182	}
		7183
7172	=head1 FUNCTIONS	7184	=head1 FUNCTIONS
7173		7185
7174	=head2 TableExists($table)	7186	=head2 TableExists($table)
7175	-