mirror of https://github.com/artifacthub/hub.git
11 lines
546 B
SQL
11 lines
546 B
SQL
delete from password_reset_code;
|
|
alter table password_reset_code alter column password_reset_code_id drop default;
|
|
alter table password_reset_code alter column password_reset_code_id type bytea using password_reset_code_id::text::bytea;
|
|
drop function if exists register_password_reset_code(text);
|
|
|
|
---- create above / drop below ----
|
|
|
|
delete from password_reset_code;
|
|
alter table password_reset_code alter column password_reset_code_id type uuid;
|
|
alter table password_reset_code alter column password_reset_code_id set default gen_random_uuid();
|