-- Create password_change_verification_codes table in Supabase
-- Run this in Supabase SQL Editor

create table public.password_change_verification_codes (
  id serial not null,
  user_id integer not null,
  code text not null,
  expires_at timestamp with time zone not null,
  verified boolean null default false,
  created_at timestamp with time zone null default now(),
  constraint password_change_verification_codes_pkey primary key (id)
) TABLESPACE pg_default;

create index IF not exists idx_password_change_user_id on public.password_change_verification_codes using btree (user_id) TABLESPACE pg_default;
