on local at 2026-07-13 19:57:53
| 1 | CREATE TABLE `FILE_MONITOR_SETTINGS` ( | |
| 2 | `file_monitor_list_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| 3 | `server_id` int(10) unsigned NOT NULL DEFAULT '1', | |
| 4 | `container_target_id` int(10) unsigned DEFAULT NULL, | |
| 5 | `datetime_last_change` datetime DEFAULT NULL, | |
| 6 | `scan_path` varchar(1000) DEFAULT NULL, | |
| 7 | `ignore_list` text, | |
| 8 | `max_file_size_bytes` bigint(20) unsigned DEFAULT NULL, | |
| 9 | `file_type_filter` varchar(500) DEFAULT NULL, | |
| 10 | `last_scanned` datetime DEFAULT NULL, | |
| 11 | `status` tinyint(1) NOT NULL DEFAULT '0', | |
| 12 | `scan_name` varchar(250) DEFAULT NULL, | |
| 13 | `retention_days` int(10) unsigned DEFAULT NULL, | |
| 14 | `quiet_hours_start` time DEFAULT NULL, | |
| 15 | `quiet_hours_end` time DEFAULT NULL, | |
| 16 | PRIMARY KEY (`file_monitor_list_id`), | |
| 17 | KEY `idx_server` (`server_id`), | |
| 18 | KEY `idx_container` (`container_target_id`) | |
| 19 | ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 |