on local at 2026-07-13 17:00:25
| 1 | CREATE TABLE `NAMED_RELEASES` ( | |
| 2 | `named_release_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| 3 | `name` varchar(120) NOT NULL, | |
| 4 | `description` varchar(500) DEFAULT NULL, | |
| 5 | `released_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 6 | `released_by` varchar(120) DEFAULT NULL, | |
| 7 | `is_locked` tinyint(1) NOT NULL DEFAULT '1', | |
| 8 | `notes` text, | |
| 9 | `created_at` timestamp NULL DEFAULT NULL, | |
| 10 | `scope_monitor_id` int(10) unsigned DEFAULT NULL, | |
| 11 | `scope_server_id` int(10) unsigned DEFAULT NULL, | |
| 12 | `alert_delivery_kind` enum('none','generic_webhook','slack','discord') NOT NULL DEFAULT 'none', | |
| 13 | `alert_delivery_url` varchar(2000) DEFAULT NULL, | |
| 14 | `last_pin_drift_check_at` datetime DEFAULT NULL, | |
| 15 | `tier` enum('draft','working','stable') NOT NULL DEFAULT 'draft', | |
| 16 | `version_label` varchar(60) DEFAULT NULL, | |
| 17 | `auto_promote_stable_days` int(11) DEFAULT NULL, | |
| 18 | `annotation` text, | |
| 19 | PRIMARY KEY (`named_release_id`), | |
| 20 | KEY `idx_released_at` (`released_at`) | |
| 21 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |