👥 Hiring Portal

⚠ One-time Supabase setup required. Run the following SQL in your Supabase dashboard → SQL Editor, then refresh this page:

CREATE TABLE hiring_roles (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  created_at timestamptz DEFAULT now(),
  location text NOT NULL,
  position text NOT NULL,
  openings integer NOT NULL DEFAULT 1,
  status text NOT NULL DEFAULT 'open',
  notes text,
  created_by text
);
ALTER TABLE hiring_roles ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow all" ON hiring_roles FOR ALL USING (true) WITH CHECK (true);

CREATE TABLE hiring_candidates (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  created_at timestamptz DEFAULT now(),
  name text NOT NULL,
  phone text,
  email text,
  role_id uuid REFERENCES hiring_roles(id),
  source text,
  status text NOT NULL DEFAULT 'new',
  added_by text
);
ALTER TABLE hiring_candidates ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow all" ON hiring_candidates FOR ALL USING (true) WITH CHECK (true);

CREATE TABLE hiring_contact_log (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  created_at timestamptz DEFAULT now(),
  candidate_id uuid NOT NULL REFERENCES hiring_candidates(id) ON DELETE CASCADE,
  contact_date date NOT NULL,
  method text NOT NULL,
  logged_by text,
  notes text
);
ALTER TABLE hiring_contact_log ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow all" ON hiring_contact_log FOR ALL USING (true) WITH CHECK (true);