От: | pva | ||
Дата: | 01.09.21 18:10 | ||
Оценка: |
Поле from создается с DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)CREATE TABLE `report_rules` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`service_id` INT(10) UNSIGNED NOT NULL,
`from` TIMESTAMP(3) NOT NULL,
`to` TIMESTAMP(3) NOT NULL,
`state` ENUM ('new','progress','done') NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `report_rules_service_id_foreign` (`service_id`) USING BTREE,
CONSTRAINT `report_rules_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `cv`.`services` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
)