|
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 |
- |
|
|