-- ============================================================================
-- Migration v8: Adsterra banner ad system
-- Run this ONCE on your existing database (phpMyAdmin > SQL tab).
-- Safe to run more than once.
-- ============================================================================

CREATE TABLE IF NOT EXISTS adsterra_ads (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(150) NOT NULL,
    banner_script TEXT NOT NULL,
    width INT NOT NULL DEFAULT 300,
    height INT NOT NULL DEFAULT 250,
    position ENUM('top','bottom','left','right') NOT NULL DEFAULT 'top',
    show_pages TEXT DEFAULT NULL,        -- comma-separated page filenames, or 'all'
    show_on_login TINYINT(1) NOT NULL DEFAULT 0,
    show_on_register TINYINT(1) NOT NULL DEFAULT 0,
    status ENUM('active','inactive') NOT NULL DEFAULT 'active',
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;