/
wax_boy
/
semaphore_custom
Обзор
Документация
Войти
/
wax_boy
/
semaphore_custom
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
develop
db/sql/migrations/v2.11.5.sql
23 строки
919 B
Denis Gukov
fix(be): migration
18 дек 2024, 00:53
Не верифицирован
18 дек 2024, 00:53
8d68e9e
Код
Авторство
О чём код?
create table project__terraform_inventory_alias( `alias` varchar(100) primary key, `project_id` int NOT NULL, `inventory_id` int NOT NULL, `auth_key_id` int NOT NULL, foreign key (`project_id`) references project(`id`) on delete cascade, foreign key (`inventory_id`) references project__inventory(`id`) on delete cascade, foreign key (`auth_key_id`) references access_key(`id`) ); create table project__terraform_inventory_state( `id` integer primary key autoincrement, `project_id` int NOT NULL, `inventory_id` int NOT NULL, `state` text NOT NULL, `created` datetime NOT NULL, `task_id` int, foreign key (`task_id`) references task(`id`) on delete set null, foreign key (`project_id`) references project(`id`) on delete cascade, foreign key (`inventory_id`) references project__inventory(`id`) on delete cascade ); alter table `project__inventory` change `holder_id` `template_id` int