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`) |