/
wax_boy
/
semaphore_custom
Обзор
Документация
Войти
/
wax_boy
/
semaphore_custom
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
develop
db/sql/migrations/v2.16.0.sql
25 строк
1 KB
Denis Gukov
fix(secrets): delete cascade for storage_id
06 авг 2025, 10:21
Не верифицирован
06 авг 2025, 10:21
2d27862
Код
Авторство
О чём код?
alter table `access_key` add `owner` varchar(20) default '' not null; alter table `access_key` add `plain` text; update access_key set `owner` = 'variable' where environment_id is not null and name like 'var.%'; update access_key set `owner` = 'environment' where environment_id is not null and name like 'env.%'; create table project__secret_storage ( id integer primary key autoincrement, project_id int not null, name varchar(100) not null, type varchar(20) not null, params text, readonly boolean not null default false, foreign key (`project_id`) references project(`id`) on delete cascade ); alter table `access_key` add `storage_id` int null references `project__secret_storage`(`id`) on delete cascade; alter table `access_key` add `source_storage_id` int null references `project__secret_storage`(`id`); alter table `access_key` add `source_storage_key` varchar(1000); alter table `project__environment` add `secret_storage_id` int null references `project__secret_storage`(`id`); alter table `project__environment` add `secret_storage_key_prefix` varchar(1000); alter table `project` add `default_secret_storage_id` int null references `project__secret_storage`(`id`);