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` int(11) NOT NULL COMMENT 'record_id', |
251 |
`record_id` int(11) NOT NULL 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 */; |
Lines 6755-6758
CREATE TABLE `zebraqueue` (
Link Here
|
6755 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
6757 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
6756 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
6758 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
6757 |
|
6759 |
|
6758 |
-- Dump completed on 2024-11-25 12:13:27 |
6760 |
-- Dump completed on 2024-11-25 12:13:27 |
6759 |
- |
|
|