-- Fix site_settings write permissions (allows admin edits to save to cloud) DROP POLICY IF EXISTS "settings admin insert" ON site_settings; CREATE POLICY "settings admin insert" ON site_settings FOR INSERT TO anon, authenticated WITH CHECK (true); DROP POLICY IF EXISTS "settings admin update" ON site_settings; CREATE POLICY "settings admin update" ON site_settings FOR UPDATE TO anon, authenticated USING (true) WITH CHECK (true); DROP POLICY IF EXISTS "settings admin delete" ON site_settings; CREATE POLICY "settings admin delete" ON site_settings FOR DELETE TO anon, authenticated USING (true);

UPDATE profiles SET tier = 'pro' WHERE email = 'member@example.com';

ALTER TABLE profiles ADD COLUMN IF NOT EXISTS company text DEFAULT ''; ALTER TABLE profiles ADD COLUMN IF NOT EXISTS country text DEFAULT ''; ALTER TABLE profiles ADD COLUMN IF NOT EXISTS position text DEFAULT ''; -- Update the signup trigger so new members get these fields automatically: CREATE OR REPLACE FUNCTION public.handle_new_user() RETURNS trigger LANGUAGE plpgsql SECURITY DEFINER SET search_path = public AS $$ BEGIN INSERT INTO public.profiles (id, name, email, tier, is_admin, company, country, position) VALUES ( new.id, COALESCE(new.raw_user_meta_data->>'name','Member'), new.email, 'basic', false, COALESCE(new.raw_user_meta_data->>'company',''), COALESCE(new.raw_user_meta_data->>'country',''), COALESCE(new.raw_user_meta_data->>'position','') ); RETURN new; END; $$; -- Backfill existing users who already signed up: UPDATE profiles p SET company = COALESCE((SELECT raw_user_meta_data->>'company' FROM auth.users u WHERE u.id = p.id),''), country = COALESCE((SELECT raw_user_meta_data->>'country' FROM auth.users u WHERE u.id = p.id),''), position = COALESCE((SELECT raw_user_meta_data->>'position' FROM auth.users u WHERE u.id = p.id),'') WHERE company IS NULL OR company = '';