Lines 247-256
DROP TABLE IF EXISTS `additional_field_values`;
Link Here
|
247 |
CREATE TABLE `additional_field_values` ( |
247 |
CREATE TABLE `additional_field_values` ( |
248 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
248 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', |
249 |
`field_id` int(11) NOT NULL COMMENT 'foreign key references additional_fields(id)', |
249 |
`field_id` int(11) NOT NULL COMMENT 'foreign key references additional_fields(id)', |
|
|
250 |
`record_table` varchar(255) NOT NULL DEFAULT '' COMMENT 'tablename of the related record', |
250 |
`record_id` varchar(11) NOT NULL DEFAULT '' COMMENT 'record_id', |
251 |
`record_id` varchar(11) NOT NULL DEFAULT '' COMMENT 'record_id', |
251 |
`value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field', |
252 |
`value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field', |
252 |
PRIMARY KEY (`id`), |
253 |
PRIMARY KEY (`id`), |
253 |
KEY `afv_fk` (`field_id`), |
254 |
KEY `afv_fk` (`field_id`), |
|
|
255 |
KEY `record_table` (`record_table`), |
254 |
CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
256 |
CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
255 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
257 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
256 |
/*!40101 SET character_set_client = @saved_cs_client */; |
258 |
/*!40101 SET character_set_client = @saved_cs_client */; |
257 |
- |
|
|