create table registrations(id uuid default gen_random_uuid() primary key,user_id uuid references auth.users(id) on delete cascade,home_name text not null,home_name_lower text unique not null,address text,plan text default 'standard',reg_num text,status text default 'pending_payment',verified boolean default false,plaque_ordered boolean default false,created_at timestamptz default now(),renews_at timestamptz default now()+interval '1 year'); create table stories(id uuid default gen_random_uuid() primary key,user_id uuid references auth.users(id) on delete cascade,registration_id uuid references registrations(id) on delete cascade,content text default '',established text default '',style text default '',updated_at timestamptz default now()); create table timeline_entries(id uuid default gen_random_uuid() primary key,user_id uuid references auth.users(id) on delete cascade,registration_id uuid references registrations(id) on delete cascade,year int,month text,title text not null,description text,category text default 'milestone',created_at timestamptz default now()); create table stats(id int primary key default 1,homes int default 0,cities int default 0,plaques int default 0); insert into stats(id) values(1) on conflict do nothing; alter table registrations enable row level security; alter table stories enable row level security; alter table timeline_entries enable row level security; alter table stats enable row level security; create policy "pub_read" on registrations for select using(true); create policy "user_ins" on registrations for insert with check(auth.uid()=user_id); create policy "user_upd" on registrations for update using(auth.uid()=user_id); create policy "pub_stories" on stories for select using(true); create policy "user_stories" on stories for all using(auth.uid()=user_id); create policy "pub_tl" on timeline_entries for select using(true); create policy "user_tl" on timeline_entries for all using(auth.uid()=user_id); create policy "pub_stats" on stats for select using(true);