LUKZI SUPREME DECK

-- 1. Create tables for Products, Error Fixes, Settings and Feedbacks CREATE TABLE IF NOT EXISTS site_products ( id TEXT PRIMARY KEY, data JSONB NOT NULL, updated_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()) ); CREATE TABLE IF NOT EXISTS site_error_fixes ( id TEXT PRIMARY KEY, data JSONB NOT NULL, updated_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()) ); CREATE TABLE IF NOT EXISTS site_settings ( id TEXT PRIMARY KEY, data JSONB NOT NULL, updated_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()) ); CREATE TABLE IF NOT EXISTS site_feedbacks ( id TEXT PRIMARY KEY, data JSONB NOT NULL, updated_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()) ); -- 2. Enable public read and write policies ALTER TABLE site_products ENABLE ROW LEVEL SECURITY; ALTER TABLE site_error_fixes ENABLE ROW LEVEL SECURITY; ALTER TABLE site_settings ENABLE ROW LEVEL SECURITY; ALTER TABLE site_feedbacks ENABLE ROW LEVEL SECURITY; CREATE POLICY "Allow public read-write for site_products" ON site_products FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "Allow public read-write for site_error_fixes" ON site_error_fixes FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "Allow public read-write for site_settings" ON site_settings FOR ALL USING (true) WITH CHECK (true); CREATE POLICY "Allow public read-write for site_feedbacks" ON site_feedbacks FOR ALL USING (true) WITH CHECK (true);