|
Lines 99-106
CREATE TABLE `authorised_values` ( -- stores values for authorized values catego
Link Here
|
| 99 |
`id` int(11) NOT NULL auto_increment, -- unique key, used to identify the authorized value |
99 |
`id` int(11) NOT NULL auto_increment, -- unique key, used to identify the authorized value |
| 100 |
`category` varchar(10) NOT NULL default '', -- key used to identify the authorized value category |
100 |
`category` varchar(10) NOT NULL default '', -- key used to identify the authorized value category |
| 101 |
`authorised_value` varchar(80) NOT NULL default '', -- code use to identify the authorized value |
101 |
`authorised_value` varchar(80) NOT NULL default '', -- code use to identify the authorized value |
| 102 |
`lib` varchar(80) default NULL, -- authorized value description as printed in the staff client |
102 |
`lib` varchar(200) default NULL, -- authorized value description as printed in the staff client |
| 103 |
`lib_opac` VARCHAR(80) 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 |
KEY `name` (`category`), |
106 |
KEY `name` (`category`), |