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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 104-109 CREATE TABLE `authorised_values` ( -- stores values for authorized values catego Link Here
104
  `lib_opac` varchar(200) default NULL, -- authorized value description as printed in the OPAC
104
  `lib_opac` varchar(200) default NULL, -- authorized value description as printed in the OPAC
105
  `imageurl` varchar(200) default NULL, -- authorized value URL
105
  `imageurl` varchar(200) default NULL, -- authorized value URL
106
  PRIMARY KEY  (`id`),
106
  PRIMARY KEY  (`id`),
107
  UNIQUE KEY `av_uniq` (`category`,`authorised_value`),
107
  KEY `name` (`category`),
108
  KEY `name` (`category`),
108
  KEY `lib` (`lib`),
109
  KEY `lib` (`lib`),
109
  KEY `auth_value_idx` (`authorised_value`)
110
  KEY `auth_value_idx` (`authorised_value`)
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +10 lines)
Lines 7953-7958 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
7953
    SetVersion($DBversion);
7953
    SetVersion($DBversion);
7954
}
7954
}
7955
7955
7956
$DBversion = "3.15.00.XXX";
7957
if ( CheckVersion($DBversion) ) {
7958
    $dbh->do(q{
7959
        ALTER TABLE authorised_values ADD UNIQUE KEY av_uniq(category, authorised_value);
7960
    });
7961
    print "Upgrade to $DBversion done (Bug XXXXX: Add unique key on the authorised_values table)\n";
7962
    SetVersion($DBversion);
7963
}
7964
7965
7956
=head1 FUNCTIONS
7966
=head1 FUNCTIONS
7957
7967
7958
=head2 TableExists($table)
7968
=head2 TableExists($table)
7959
- 

Return to bug 10363