/
dimamir
/
rill
Обзор
Документация
Войти
/
dimamir
/
rill
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
admin/database/postgres/migrations/0017.sql
12 строк
467 B
Benjamin Egelund-Müller
Support ad-hoc code files backed by Postgres (#3258)
25 окт 2023, 21:08
Не верифицирован
25 окт 2023, 21:08
505b1f6
Код
Авторство
О чём код?
CREATE TABLE virtual_files ( project_id UUID NOT NULL REFERENCES projects (id) ON DELETE CASCADE, branch TEXT NOT NULL, path TEXT NOT NULL, data BYTEA NOT NULL, deleted BOOLEAN NOT NULL, created_on TIMESTAMPTZ DEFAULT now() NOT NULL, updated_on TIMESTAMPTZ DEFAULT now() NOT NULL, PRIMARY KEY (project_id, branch, path) ); CREATE INDEX virtual_files_project_id_branch_updated_on_idx ON virtual_files (project_id, branch, updated_on);