-- FamilyTrack schema (run in Supabase → SQL Editor) CREATE TABLE tracking_sessions ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), admin_name TEXT, session_name TEXT, admin_token TEXT DEFAULT gen_random_uuid()::text, created_at TIMESTAMPTZ DEFAULT now(), is_active BOOLEAN DEFAULT true ); CREATE TABLE trackers ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), session_id UUID REFERENCES tracking_sessions(id), child_name TEXT, tracker_token TEXT DEFAULT gen_random_uuid()::text, latitude DOUBLE PRECISION, longitude DOUBLE PRECISION, accuracy DOUBLE PRECISION, altitude DOUBLE PRECISION, speed DOUBLE PRECISION, battery_level DOUBLE PRECISION, battery_charging BOOLEAN, device_type TEXT, os_info TEXT, browser_info TEXT, screen_resolution TEXT, language TEXT, ip_address TEXT, network_type TEXT, last_seen TIMESTAMPTZ DEFAULT now(), created_at TIMESTAMPTZ DEFAULT now(), is_online BOOLEAN DEFAULT false ); CREATE TABLE location_history ( id BIGSERIAL PRIMARY KEY, tracker_id UUID REFERENCES trackers(id), latitude DOUBLE PRECISION, longitude DOUBLE PRECISION, accuracy DOUBLE PRECISION, battery_level DOUBLE PRECISION, recorded_at TIMESTAMPTZ DEFAULT now() ); ALTER TABLE tracking_sessions ENABLE ROW LEVEL SECURITY; ALTER TABLE trackers ENABLE ROW LEVEL SECURITY; ALTER TABLE location_history ENABLE ROW LEVEL SECURITY; CREATE POLICY "p1" ON tracking_sessions FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "p2" ON trackers FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "p3" ON location_history FOR ALL USING (true) WITH CHECK (true); ALTER PUBLICATION supabase_realtime ADD TABLE trackers;