/
wax_boy
/
semaphore_custom
Обзор
Документация
Войти
/
wax_boy
/
semaphore_custom
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
develop
db/sql/migrations/v2.15.0.sql
23 строки
900 B
Denis Gukov
fix: rename migration
25 апр 2025, 20:39
Не верифицирован
25 апр 2025, 20:39
42945ca
Код
Авторство
О чём код?
create table task__stage ( `id` integer primary key autoincrement, `task_id` int NOT NULL, `start` datetime null, `start_output_id` bigint null, `end` datetime null, `end_output_id` bigint null, `type` varchar(100), foreign key (`task_id`) references `task` (`id`) on delete cascade, foreign key (`start_output_id`) references `task__output` (`id`) on delete set null, foreign key (`end_output_id`) references `task__output` (`id`) on delete set null ); create table task__stage_result ( `id` integer primary key autoincrement, `task_id` int NOT NULL, `stage_id` int NOT NULL, `json` text, foreign key (`task_id`) references `task` (`id`) on delete cascade, foreign key (`stage_id`) references `task__stage` (`id`) on delete cascade );