Lines 1023-1030
CREATE TABLE `authorised_values` (
Link Here
|
1023 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the authorized value', |
1023 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key, used to identify the authorized value', |
1024 |
`category` varchar(32) NOT NULL DEFAULT '' COMMENT 'key used to identify the authorized value category', |
1024 |
`category` varchar(32) NOT NULL DEFAULT '' COMMENT 'key used to identify the authorized value category', |
1025 |
`authorised_value` varchar(80) NOT NULL DEFAULT '' COMMENT 'code use to identify the authorized value', |
1025 |
`authorised_value` varchar(80) NOT NULL DEFAULT '' COMMENT 'code use to identify the authorized value', |
1026 |
`lib` varchar(200) DEFAULT NULL COMMENT 'authorized value description as printed in the staff interface', |
1026 |
`lib` varchar(400) DEFAULT NULL COMMENT 'authorized value description as printed in the staff interface', |
1027 |
`lib_opac` varchar(200) DEFAULT NULL COMMENT 'authorized value description as printed in the OPAC', |
1027 |
`lib_opac` varchar(400) DEFAULT NULL COMMENT 'authorized value description as printed in the OPAC', |
1028 |
`imageurl` varchar(200) DEFAULT NULL COMMENT 'authorized value URL', |
1028 |
`imageurl` varchar(200) DEFAULT NULL COMMENT 'authorized value URL', |
1029 |
PRIMARY KEY (`id`), |
1029 |
PRIMARY KEY (`id`), |
1030 |
UNIQUE KEY `av_uniq` (`category`,`authorised_value`), |
1030 |
UNIQUE KEY `av_uniq` (`category`,`authorised_value`), |