on local at 2026-07-13 17:00:29
| 1 | CREATE TABLE `WATCH_LIST` ( | |
| 2 | `watch_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| 3 | `file_monitor_list_id` int(10) unsigned NOT NULL, | |
| 4 | `file_name` varchar(500) NOT NULL, | |
| 5 | `priority` enum('high','critical') NOT NULL DEFAULT 'high', | |
| 6 | `note` varchar(500) DEFAULT NULL, | |
| 7 | `added_by` varchar(80) DEFAULT NULL, | |
| 8 | `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 9 | PRIMARY KEY (`watch_id`), | |
| 10 | UNIQUE KEY `watch_uk` (`file_monitor_list_id`,`file_name`(191)), | |
| 11 | KEY `mid_ix` (`file_monitor_list_id`) | |
| 12 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |