Lines 260-266
CREATE TABLE `additional_fields` (
Link Here
|
260 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
260 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
261 |
`tablename` varchar(255) NOT NULL DEFAULT '' COMMENT 'tablename of the new field', |
261 |
`tablename` varchar(255) NOT NULL DEFAULT '' COMMENT 'tablename of the new field', |
262 |
`name` varchar(255) NOT NULL DEFAULT '' COMMENT 'name of the field', |
262 |
`name` varchar(255) NOT NULL DEFAULT '' COMMENT 'name of the field', |
263 |
`authorised_value_category` varchar(32) NOT NULL DEFAULT '' COMMENT 'is an authorised value category', |
263 |
`authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'is an authorised value category', |
264 |
`marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', |
264 |
`marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', |
265 |
`marcfield_mode` enum('get','set') NOT NULL DEFAULT 'get' COMMENT 'mode of operation (get or set) for marcfield', |
265 |
`marcfield_mode` enum('get','set') NOT NULL DEFAULT 'get' COMMENT 'mode of operation (get or set) for marcfield', |
266 |
`searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?', |
266 |
`searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?', |
267 |
- |
|
|