/
wax_boy
/
semaphore_custom
Обзор
Документация
Войти
/
wax_boy
/
semaphore_custom
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
develop
db/sql/migrations/v2.15.3.sql
24 строки
857 B
Denis Gukov
feat(db): add migrations
14 июл 2025, 14:27
Не верифицирован
14 июл 2025, 14:27
18d98b2
Код
Авторство
О чём код?
create table task__ansible_error( `id` integer primary key autoincrement, `task_id` int NOT NULL, `project_id` int NOT NULL, `task` varchar(250) NOT NULL, `error` varchar(1000) NOT NULL, foreign key (`project_id`) references `project`(`id`) on delete cascade, foreign key (`task_id`) references `task`(`id`) on delete cascade ); create table task__ansible_host( `id` integer primary key autoincrement, `task_id` int NOT NULL, `project_id` int NOT NULL, `host` varchar(250) NOT NULL, `failed` int NOT NULL, `ignored` int NOT NULL, `changed` int NOT NULL, `ok` int NOT NULL, `rescued` int NOT NULL, `skipped` int NOT NULL, `unreachable` int NOT NULL, foreign key (`project_id`) references `project`(`id`) on delete cascade, foreign key (`task_id`) references `task`(`id`) on delete cascade );