-- CREATE CORE TABLES FOR SORAT BATTING
CREATE TABLE IF NOT EXISTS public.admin_settings (
    id TEXT PRIMARY KEY DEFAULT 'default',
    admin_mode TEXT DEFAULT 'AUTO_LOW_EXPOSURE',
    manual_override_item_id INT,
    password TEXT DEFAULT 'sorat777',
    default_timer INT DEFAULT 60,
    logo_url TEXT DEFAULT '',
    updated_at TIMESTAMPTZ DEFAULT NOW()
);
INSERT INTO public.admin_settings (id, admin_mode, manual_override_item_id, password, default_timer, logo_url)
VALUES ('default', 'AUTO_LOW_EXPOSURE', NULL, 'sorat777', 60, '')
ON CONFLICT (id) DO NOTHING;

CREATE TABLE IF NOT EXISTS public.game_rounds (
    id INT PRIMARY KEY DEFAULT 1,
    timer INT DEFAULT 60,
    status TEXT DEFAULT 'open',
    winning_symbol TEXT DEFAULT 'None',
    mode TEXT DEFAULT 'auto',
    is_manual BOOLEAN DEFAULT FALSE,
    updated_at TIMESTAMPTZ DEFAULT NOW()
);
INSERT INTO public.game_rounds (id, timer, status, winning_symbol, mode, is_manual)
VALUES (1, 60, 'open', 'None', 'auto', FALSE)
ON CONFLICT (id) DO NOTHING;

CREATE TABLE IF NOT EXISTS public.profiles (
    user_id TEXT PRIMARY KEY,
    username TEXT,
    wallet_balance NUMERIC DEFAULT 0,
    total_wins NUMERIC DEFAULT 0,
    total_losses NUMERIC DEFAULT 0,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS public.user_balance (
    "userId" TEXT PRIMARY KEY,
    balance NUMERIC DEFAULT 0,
    "totalBets" NUMERIC DEFAULT 0,
    "totalWins" NUMERIC DEFAULT 0,
    updated_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS public.bets (
    id BIGSERIAL PRIMARY KEY,
    user_id TEXT,
    round_id INT DEFAULT 1,
    symbol TEXT NOT NULL,
    amount NUMERIC DEFAULT 0,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS public.deposits (
    id BIGSERIAL PRIMARY KEY,
    user_id TEXT NOT NULL,
    username TEXT,
    amount NUMERIC NOT NULL,
    transaction_id TEXT UNIQUE NOT NULL,
    screenshot_url TEXT NOT NULL,
    status TEXT DEFAULT 'Pending',
    created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS public.withdrawals (
    id BIGSERIAL PRIMARY KEY,
    user_id TEXT NOT NULL,
    username TEXT,
    amount NUMERIC NOT NULL,
    payment_method TEXT DEFAULT 'UPI',
    upi_id TEXT,
    bank_details TEXT,
    status TEXT DEFAULT 'Pending',
    created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS public.payment_gateway_settings (
    id INT PRIMARY KEY DEFAULT 1,
    upi_id TEXT DEFAULT 'payment@upi',
    qr_code_url TEXT DEFAULT '',
    updated_at TIMESTAMPTZ DEFAULT NOW()
);
INSERT INTO public.payment_gateway_settings (id, upi_id, qr_code_url)
VALUES (1, 'payment@upi', '')
ON CONFLICT (id) DO NOTHING;

CREATE TABLE IF NOT EXISTS public.app_content (
    id INT PRIMARY KEY DEFAULT 1,
    apk_popup_notification TEXT DEFAULT 'Welcome to SORAT BATTING!',
    terms_and_policy TEXT DEFAULT 'Default terms...',
    privacy_policy TEXT DEFAULT 'Default privacy...',
    contact_support TEXT DEFAULT 'Support Email: support@soratbatting.com',
    updated_at TIMESTAMPTZ DEFAULT NOW()
);
INSERT INTO public.app_content (id, apk_popup_notification, terms_and_policy, privacy_policy, contact_support)
VALUES (1, 'Welcome to SORAT BATTING!', 'Default terms...', 'Default privacy...', 'Support Email: support@soratbatting.com')
ON CONFLICT (id) DO NOTHING;

CREATE TABLE IF NOT EXISTS public.system_debug_logs (
    id BIGSERIAL PRIMARY KEY,
    log_type TEXT DEFAULT 'DEBUG',
    message TEXT NOT NULL,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Enable Postgres replication realtime for instant dashboards updates
alter publication supabase_realtime add table public.bets;
alter publication supabase_realtime add table public.game_rounds;
alter publication supabase_realtime add table public.admin_settings;
alter publication supabase_realtime add table public.deposits;
alter publication supabase_realtime add table public.withdrawals;
alter publication supabase_realtime add table public.system_debug_logs;