-- Raj Group starter schema - MySQL 8+, UTF8MB4
CREATE DATABASE IF NOT EXISTS rajgroup_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE rajgroup_db;
CREATE TABLE IF NOT EXISTS enquiries (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(120) NOT NULL,
 email VARCHAR(190) NOT NULL, company VARCHAR(190) DEFAULT NULL, phone VARCHAR(80) DEFAULT NULL,
 message TEXT NOT NULL, consent_at DATETIME NOT NULL,
 created_at DATETIME NULL, updated_at DATETIME NULL,
 INDEX idx_enquiries_created(created_at), INDEX idx_enquiries_email(email)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS admin_users (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 email VARCHAR(190) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL,
 full_name VARCHAR(150) NOT NULL, is_active TINYINT(1) NOT NULL DEFAULT 1,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS articles (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 title VARCHAR(255) NOT NULL, slug VARCHAR(255) NOT NULL UNIQUE,
 excerpt TEXT, body LONGTEXT, status ENUM('draft','published') NOT NULL DEFAULT 'draft',
 published_at DATETIME NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS content_pages (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 slug VARCHAR(255) NOT NULL UNIQUE, title VARCHAR(255) NOT NULL,
 body LONGTEXT, seo_title VARCHAR(255), seo_description VARCHAR(320),
 status ENUM('draft','published') NOT NULL DEFAULT 'draft',
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;