-- ============================================================
--  Migration: Dashboard Ads
--  Run once in phpMyAdmin on your femtecht_otp database
-- ============================================================

CREATE TABLE IF NOT EXISTS `dashboard_ads` (
  `id`         INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `title`      VARCHAR(120) NOT NULL DEFAULT '',
  `image_file` VARCHAR(255) NOT NULL,
  `link_url`   VARCHAR(500) NOT NULL DEFAULT '#',
  `is_active`  TINYINT(1)  NOT NULL DEFAULT 1,
  `sort_order` TINYINT     NOT NULL DEFAULT 0,
  `created_at` DATETIME    NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;