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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 103-108 CREATE TABLE `authorised_values` ( -- stores values for authorized values catego Link Here
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`)
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +12 lines)
Lines 6984-6989 INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ( Link Here
6984
}
6984
}
6985
6985
6986
6986
6987
6988
6989
6990
$DBversion = "3.13.00.XXX";
6991
if ( CheckVersion($DBversion) ) {
6992
    $dbh->do(q{
6993
        ALTER TABLE authorised_values ADD UNIQUE KEY av_uniq(category, authorised_value);
6994
    });
6995
    print "Upgrade to $DBversion done (Bug XXXXX: Add unique key on the authorised_values table)\n";
6996
    SetVersion($DBversion);
6997
}
6998
6987
=head1 FUNCTIONS
6999
=head1 FUNCTIONS
6988
7000
6989
=head2 TableExists($table)
7001
=head2 TableExists($table)
6990
- 

Return to bug 10363