Database Setup Required

The price_settings table was not found or cannot be accessed. Run this SQL in your Supabase → SQL Editor:

-- Run this in Supabase SQL Editor
-- Option A: FULL RESET (drops old table - loses data)
DROP TABLE IF EXISTS public.service_requests CASCADE;

CREATE TABLE public.service_requests (
  id bigserial PRIMARY KEY,
  full_name text NOT NULL, phone text NOT NULL,
  email text NOT NULL, address text NOT NULL,
  service_type text NOT NULL, cleaning_date date NOT NULL,
  cleaning_time text NOT NULL, description text NOT NULL DEFAULT '',
  status text NOT NULL DEFAULT 'pending',
  agreed_value numeric(10,2) DEFAULT NULL,
  estimated_value numeric(10,2) DEFAULT NULL,
  carpet_length numeric(10,2) DEFAULT NULL,
  carpet_width numeric(10,2) DEFAULT NULL,
  move_bedrooms integer DEFAULT 0, move_bathrooms integer DEFAULT 0,
  move_oven text DEFAULT 'no', move_fridge text DEFAULT 'no',
  move_living_rooms integer DEFAULT 0, move_shower_glass integer DEFAULT 0,
  move_pets_kids text DEFAULT '', move_sqft text DEFAULT '',
  move_carpet text DEFAULT 'no', move_smoke text DEFAULT 'no',
  res_bedrooms integer DEFAULT 0, res_bathrooms integer DEFAULT 0,
  res_living_rooms integer DEFAULT 0, res_shower_glass integer DEFAULT 0,
  res_pets_kids text DEFAULT '', res_sqft text DEFAULT '', res_smoke text DEFAULT 'no',
  rv_length text DEFAULT '', rv_beds text DEFAULT '',
  rv_bathrooms text DEFAULT '', rv_kitchen text DEFAULT 'yes',
  rv_appliances text DEFAULT '', rv_last_cleaned text DEFAULT '',
  rv_water text DEFAULT 'yes', rv_electricity text DEFAULT 'yes', rv_pets text DEFAULT 'no',
  constr_type text DEFAULT '', constr_sqft text DEFAULT '',
  constr_work_type text DEFAULT '', constr_completed text DEFAULT 'yes',
  constr_level text DEFAULT '', constr_windows integer DEFAULT 0,
  constr_bedrooms integer DEFAULT 0, constr_bathrooms integer DEFAULT 0,
  constr_high_ceilings text DEFAULT 'no', constr_appliances text DEFAULT 'no',
  constr_appliances_list text DEFAULT '', constr_garage text DEFAULT 'no',
  constr_empty text DEFAULT 'yes',
  church_bathrooms integer DEFAULT 0, church_kitchen text DEFAULT 'no',
  church_carpet text DEFAULT 'no', church_sqft text DEFAULT '', church_offices integer DEFAULT 0,
  comm_bathrooms integer DEFAULT 0, comm_kitchen text DEFAULT 'no',
  comm_carpet text DEFAULT 'no', comm_sqft text DEFAULT '',
  comm_offices text DEFAULT '0', comm_desks text DEFAULT '0',
  bedrooms integer DEFAULT 0, bathrooms integer DEFAULT 0,
  shower_box_count integer DEFAULT 0, has_pets boolean DEFAULT false,
  pet_count integer DEFAULT 0, has_children boolean DEFAULT false,
  children_count integer DEFAULT 0,
  created_at timestamptz DEFAULT now(), updated_at timestamptz DEFAULT now()
);
ALTER TABLE public.service_requests ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "anon_all_service_requests" ON public.service_requests;
CREATE POLICY "anon_all_service_requests" ON public.service_requests
  FOR ALL TO anon USING (true) WITH CHECK (true);
CREATE INDEX IF NOT EXISTS idx_sr_status ON public.service_requests(status);
CREATE INDEX IF NOT EXISTS idx_sr_created_at ON public.service_requests(created_at);
CREATE INDEX IF NOT EXISTS idx_sr_cleaning_date ON public.service_requests(cleaning_date);
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $$ BEGIN NEW.updated_at=now(); RETURN NEW; END; $$ language 'plpgsql';
DROP TRIGGER IF EXISTS update_sr_updated_at ON public.service_requests;
CREATE TRIGGER update_sr_updated_at BEFORE UPDATE ON public.service_requests
  FOR EACH ROW EXECUTE FUNCTION update_updated_at_column();

-- Option B: KEEP DATA - just add new columns
-- ALTER TABLE public.service_requests
--   ADD COLUMN IF NOT EXISTS move_bedrooms integer DEFAULT 0,
--   ADD COLUMN IF NOT EXISTS move_oven text DEFAULT 'no',
--   ... (see the .sql file for complete ALTER TABLE)

After running, click Reload from Database below.