<?php
require 'config/db.php';

$sql = "CREATE TABLE IF NOT EXISTS tbl_custom_description (
    id INT AUTO_INCREMENT PRIMARY KEY,
    description TEXT NOT NULL,
    status ENUM('active', 'inactive') DEFAULT 'active',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP,
    created_by INT,
    updated_by INT
)";

try {
    $pdo->exec($sql);
    echo "Table tbl_custom_description created successfully\n";
} catch (PDOException $e) {
    echo "Error creating table: " . $e->getMessage() . "\n";
}
