create table accounts (
  id uuid primary key default gen_random_uuid(),
  username text unique not null,
  password text not null,
  is_default boolean default false,
  created_at timestamptz default now(),
  created_by text
);

create table records (
  id text primary key,
  data jsonb not null,
  serial_no int,
  submitted_by text,
  submitted_role text,
  created_at timestamptz default now(),
  updated_at timestamptz
);

alter table accounts enable row level security;
alter table records enable row level security;
create policy "public_all" on accounts for all using (true) with check (true);
create policy "public_all" on records for all using (true) with check (true);