/
dimamir
/
rill
Обзор
Документация
Войти
/
dimamir
/
rill
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
admin/database/postgres/migrations/0029.sql
28 строк
1 KB
Benjamin Egelund-Müller
Magic tokens for sharing filtered dashboards to non-users (#5071)
19 июн 2024, 13:55
Не верифицирован
19 июн 2024, 13:55
c422dd8
Код
Авторство
О чём код?
CREATE TABLE magic_auth_tokens ( id UUID DEFAULT uuid_generate_v4() PRIMARY KEY, secret_hash BYTEA NOT NULL, project_id UUID NOT NULL REFERENCES projects (id) ON DELETE CASCADE, created_on TIMESTAMPTZ DEFAULT now() NOT NULL, expires_on TIMESTAMPTZ, used_on TIMESTAMPTZ DEFAULT now() NOT NULL, created_by_user_id UUID REFERENCES users (id) ON DELETE SET NULL, attributes JSONB DEFAULT '{}'::JSONB NOT NULL, metrics_view TEXT NOT NULL, metrics_view_filter_json TEXT NOT NULL, metrics_view_fields TEXT[] NOT NULL ); CREATE INDEX magic_auth_tokens_project_id_idx ON magic_auth_tokens (project_id); CREATE INDEX magic_auth_tokens_created_by_user_id_idx ON magic_auth_tokens (created_by_user_id) WHERE created_by_user_id IS NOT NULL; ALTER TABLE project_roles ADD create_magic_auth_tokens BOOLEAN DEFAULT false NOT NULL; UPDATE project_roles SET create_magic_auth_tokens = manage_project_members; ALTER TABLE project_roles ADD manage_magic_auth_tokens BOOLEAN DEFAULT false NOT NULL; UPDATE project_roles SET manage_magic_auth_tokens = manage_project_members; ALTER TABLE project_roles ADD create_bookmarks BOOLEAN DEFAULT false NOT NULL; UPDATE project_roles SET create_bookmarks = read_project; ALTER TABLE project_roles ADD manage_bookmarks BOOLEAN DEFAULT false NOT NULL; UPDATE project_roles SET manage_bookmarks = manage_project;