Lines 227-233
CREATE TABLE `additional_field_values` (
Link Here
|
227 |
`record_id` int(11) NOT NULL COMMENT 'record_id', |
227 |
`record_id` int(11) NOT NULL COMMENT 'record_id', |
228 |
`value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field', |
228 |
`value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field', |
229 |
PRIMARY KEY (`id`), |
229 |
PRIMARY KEY (`id`), |
230 |
UNIQUE KEY `field_record` (`field_id`,`record_id`), |
230 |
KEY `afv_fk` (`field_id`), |
231 |
CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
231 |
CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
232 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
232 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
233 |
/*!40101 SET character_set_client = @saved_cs_client */; |
233 |
/*!40101 SET character_set_client = @saved_cs_client */; |
Lines 247-252
CREATE TABLE `additional_fields` (
Link Here
|
247 |
`marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', |
247 |
`marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', |
248 |
`marcfield_mode` enum('get','set') NOT NULL DEFAULT 'get' COMMENT 'mode of operation (get or set) for marcfield', |
248 |
`marcfield_mode` enum('get','set') NOT NULL DEFAULT 'get' COMMENT 'mode of operation (get or set) for marcfield', |
249 |
`searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?', |
249 |
`searchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field searchable?', |
|
|
250 |
`repeatable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the field repeatable?', |
250 |
PRIMARY KEY (`id`), |
251 |
PRIMARY KEY (`id`), |
251 |
UNIQUE KEY `fields_uniq` (`tablename`(191),`name`(191)) |
252 |
UNIQUE KEY `fields_uniq` (`tablename`(191),`name`(191)) |
252 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
253 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
253 |
- |
|
|