-- Create database and tables for KonguTourist Offer System
-- Run this in phpMyAdmin or MySQL console

CREATE DATABASE IF NOT EXISTS kongutourist_offers;
USE kongutourist_offers;

-- Create offers table
CREATE TABLE IF NOT EXISTS offers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) DEFAULT '',
    image_url VARCHAR(500) NOT NULL,
    start_date DATETIME NOT NULL,
    end_date DATETIME NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    status ENUM('active', 'inactive') DEFAULT 'active'
);

