-- Simple SQL script to create admin_settings table
-- Run this in your Supabase SQL editor

-- Create the admin_settings table
CREATE TABLE IF NOT EXISTS admin_settings (
  id TEXT PRIMARY KEY,
  settings JSONB NOT NULL DEFAULT '{}',
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- Insert default settings
INSERT INTO admin_settings (id, settings) VALUES 
('algorithm_settings', '{}'),
('platform_settings', '{}')
ON CONFLICT (id) DO NOTHING;
