Lines 3662-3667
CREATE TABLE `additional_fields` (
Link Here
|
3662 |
`name` varchar(255) NOT NULL DEFAULT '', -- name of the field |
3662 |
`name` varchar(255) NOT NULL DEFAULT '', -- name of the field |
3663 |
`authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category |
3663 |
`authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category |
3664 |
`marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record |
3664 |
`marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record |
|
|
3665 |
marcfield_mode ENUM('get', 'set') NOT NULL DEFAULT 'get', -- get value from MARC field or save value into MARC field |
3665 |
`searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable? |
3666 |
`searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable? |
3666 |
PRIMARY KEY (`id`), |
3667 |
PRIMARY KEY (`id`), |
3667 |
UNIQUE KEY `fields_uniq` (`tablename` (191),`name` (191)) |
3668 |
UNIQUE KEY `fields_uniq` (`tablename` (191),`name` (191)) |
3668 |
- |
|
|