Lines 244-250
CREATE TABLE `additional_field_values` (
Link Here
|
244 |
`record_id` int(11) NOT NULL COMMENT 'record_id', |
244 |
`record_id` int(11) NOT NULL COMMENT 'record_id', |
245 |
`value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field', |
245 |
`value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field', |
246 |
PRIMARY KEY (`id`), |
246 |
PRIMARY KEY (`id`), |
247 |
UNIQUE KEY `field_record` (`field_id`,`record_id`), |
247 |
KEY `afv_fk` (`field_id`), |
248 |
CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
248 |
CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
249 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
249 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
250 |
/*!40101 SET character_set_client = @saved_cs_client */; |
250 |
/*!40101 SET character_set_client = @saved_cs_client */; |
Lines 264-269
CREATE TABLE `additional_fields` (
Link Here
|
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 |
`repeatable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field repeatable?', |
267 |
PRIMARY KEY (`id`), |
268 |
PRIMARY KEY (`id`), |
268 |
UNIQUE KEY `fields_uniq` (`tablename`(191),`name`(191)) |
269 |
UNIQUE KEY `fields_uniq` (`tablename`(191),`name`(191)) |
269 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
270 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
270 |
- |
|
|