Alesia
House

CREATE TABLE IF NOT EXISTS availability ( id BIGSERIAL PRIMARY KEY, date DATE NOT NULL, apartment TEXT NOT NULL, status TEXT DEFAULT 'booked', source TEXT DEFAULT 'manual', booking_id BIGINT, UNIQUE(date, apartment) ); CREATE TABLE IF NOT EXISTS reviews ( id BIGSERIAL PRIMARY KEY, name TEXT NOT NULL, country TEXT, rating INTEGER DEFAULT 5, text TEXT NOT NULL, date_label TEXT, source TEXT DEFAULT 'Booking.com', visible BOOLEAN DEFAULT true ); CREATE TABLE IF NOT EXISTS guide ( id BIGSERIAL PRIMARY KEY, cat TEXT, name TEXT NOT NULL, description TEXT NOT NULL, dist TEXT, icon TEXT DEFAULT '📍', position INTEGER DEFAULT 0 ); -- RLS policies (run once) ALTER TABLE availability ENABLE ROW LEVEL SECURITY; ALTER TABLE reviews ENABLE ROW LEVEL SECURITY; ALTER TABLE guide ENABLE ROW LEVEL SECURITY; CREATE POLICY "all_avail" ON availability FOR ALL TO anon USING (true) WITH CHECK (true); CREATE POLICY "read_rev" ON reviews FOR SELECT TO anon USING (true); CREATE POLICY "all_rev" ON reviews FOR ALL TO anon USING (true) WITH CHECK (true); CREATE POLICY "all_guide" ON guide FOR ALL TO anon USING (true) WITH CHECK (true);