mirror of https://github.com/artifacthub/hub.git
16 lines
776 B
SQL
16 lines
776 B
SQL
delete from password_reset_code;
|
|
alter table password_reset_code alter column password_reset_code_id type text;
|
|
alter table session alter column session_id type text using substring(session_id::bytea::text from 3);
|
|
drop function if exists add_api_key(jsonb);
|
|
drop function if exists approve_session(bytea, text);
|
|
drop function if exists register_password_reset_code(text);
|
|
drop function if exists register_session(jsonb);
|
|
drop function if exists reset_user_password(bytea, text);
|
|
drop function if exists verify_password_reset_code(bytea);
|
|
|
|
---- create above / drop below ----
|
|
|
|
delete from password_reset_code;
|
|
alter table password_reset_code alter column password_reset_code_id type bytea;
|
|
alter table session alter column session_id type bytea using session_id::text::bytea;
|