-- Run this in Supabase SQL Editor
CREATE TABLE IF NOT EXISTS site_settings (
    id SERIAL PRIMARY KEY,
    key TEXT UNIQUE NOT NULL,
    value TEXT NOT NULL,
    updated_at TIMESTAMP DEFAULT NOW()
);

-- Enable RLS
ALTER TABLE site_settings ENABLE ROW LEVEL SECURITY;

-- Allow admin users to manage settings
CREATE POLICY "Allow admin full access" ON site_settings
    FOR ALL USING (auth.role() = 'authenticated');

-- Insert default values
INSERT INTO site_settings (key, value) VALUES
('top_picks_count', '12'),
('top_picks_category', 'all'),
('new_arrivals_logic', 'hybrid'),
('new_arrivals_count', '10'),
('new_badge_duration_days', '14'),
('show_empty_new_arrivals', 'true')
ON CONFLICT (key) DO NOTHING;