BoardingPanel

-- BOARDINGPANEL SQL COMPLETO v2.4
CREATE TABLE IF NOT EXISTS boarding_passes (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  passenger_name TEXT, program TEXT, category TEXT,
  origin TEXT, destination TEXT, flight_number TEXT,
  departure_time TEXT, departure_date TEXT,
  arrival_time TEXT, arrival_date TEXT,
  boarding_time TEXT, gate TEXT, seat TEXT,
  section TEXT, boarding_type TEXT,
  amount NUMERIC DEFAULT 0, pix_expiry_secs INTEGER DEFAULT 600,
  pix_key TEXT, pix_name TEXT, pix_city TEXT,
  gateway_id TEXT, status TEXT DEFAULT 'pending',
  pdf_url TEXT, airline TEXT DEFAULT 'azul',
  proof_url TEXT
);
ALTER TABLE boarding_passes ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "Allow all boarding_passes" ON boarding_passes;
CREATE POLICY "Allow all boarding_passes" ON boarding_passes FOR ALL TO anon USING (true) WITH CHECK (true);
ALTER PUBLICATION supabase_realtime ADD TABLE boarding_passes;

CREATE TABLE IF NOT EXISTS gateway_configs (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  gateway_id TEXT UNIQUE NOT NULL,
  gateway_name TEXT, config JSONB DEFAULT '{}',
  is_active BOOLEAN DEFAULT false,
  updated_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE gateway_configs ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "Allow all gateway_configs" ON gateway_configs;
CREATE POLICY "Allow all gateway_configs" ON gateway_configs FOR ALL TO anon USING (true) WITH CHECK (true);

INSERT INTO storage.buckets (id, name, public, file_size_limit, allowed_mime_types)
VALUES ('boarding-attachments','boarding-attachments',true,10485760,ARRAY['application/pdf','image/jpeg','image/png','image/webp'])
ON CONFLICT (id) DO UPDATE SET public=true,file_size_limit=10485760,allowed_mime_types=ARRAY['application/pdf','image/jpeg','image/png','image/webp'];

DROP POLICY IF EXISTS "Allow public upload files" ON storage.objects;
CREATE POLICY "Allow public upload files" ON storage.objects FOR INSERT TO anon WITH CHECK (bucket_id='boarding-attachments');
DROP POLICY IF EXISTS "Allow public read files" ON storage.objects;
CREATE POLICY "Allow public read files" ON storage.objects FOR SELECT TO anon USING (bucket_id='boarding-attachments');
DROP POLICY IF EXISTS "Allow public delete files" ON storage.objects;
CREATE POLICY "Allow public delete files" ON storage.objects FOR DELETE TO anon USING (bucket_id='boarding-attachments');