-- Migration 009: Promotions slideshow for the customer ordering app's Home tab
-- Run this once on your existing database via phpMyAdmin or the mysql CLI.

CREATE TABLE promotions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(150) NOT NULL,
    subtitle VARCHAR(255) NULL,
    image_path VARCHAR(255) NULL,
    button_text VARCHAR(50) DEFAULT 'Browse Menu',
    display_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;