1 CREATE TABLE `additional_fields` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `tablename` varchar(255) NOT NULL DEFAULT '',
4 `name` varchar(255) NOT NULL DEFAULT '',
5 `authorised_value_category` varchar(16) NOT NULL DEFAULT '',
6 `marcfield` varchar(16) NOT NULL DEFAULT '',
7 `searchable` tinyint(1) NOT NULL DEFAULT '0',
9 UNIQUE KEY `fields_uniq` (`tablename`,`name`)
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
12 CREATE TABLE `additional_field_values` (
13 `id` int(11) NOT NULL AUTO_INCREMENT,
14 `field_id` int(11) NOT NULL,
15 `record_id` int(11) NOT NULL,
16 `value` varchar(255) NOT NULL DEFAULT '',
18 UNIQUE KEY `field_record` (`field_id`,`record_id`),
19 CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
20 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;