/
dimamir
/
rill
Обзор
Документация
Войти
/
dimamir
/
rill
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
admin/database/postgres/migrations/0028.sql
20 строк
819 B
Parag Jain
PKCE authentication support for the local UI (#4843)
09 май 2024, 15:24
Не верифицирован
09 май 2024, 15:24
38796b4
Код
Авторство
О чём код?
-- Hard-coded first-party auth clients INSERT INTO auth_clients (id, display_name) VALUES ('12345678-0000-0000-0000-000000000004', 'Rill Localhost'); -- Table for storing authorization codes for PKCE auth flow CREATE TABLE authorization_codes ( id UUID DEFAULT uuid_generate_v4() PRIMARY KEY, code TEXT NOT NULL, user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, client_id UUID NOT NULL REFERENCES auth_clients(id) ON DELETE CASCADE, redirect_uri TEXT NOT NULL, code_challenge TEXT NOT NULL, code_challenge_method TEXT NOT NULL, expires_on TIMESTAMP NOT NULL, created_on TIMESTAMPTZ DEFAULT now() NOT NULL, updated_on TIMESTAMPTZ DEFAULT now() NOT NULL ); -- create index on code column CREATE UNIQUE INDEX authorization_codes_code_idx ON authorization_codes(code);