

CREATE TABLE IF NOT EXISTS slides (
  id INT AUTO_INCREMENT PRIMARY KEY,
  type ENUM('image','video','text') NOT NULL DEFAULT 'text',
  file_path VARCHAR(255) DEFAULT NULL,
  text_content TEXT DEFAULT NULL,
  font_family VARCHAR(100) DEFAULT 'Arial',
  font_size INT DEFAULT 48,
  text_color VARCHAR(20) DEFAULT '#FFFFFF',
  background_color VARCHAR(20) DEFAULT '#000000',
  `align` ENUM('left','center','right') DEFAULT 'center',
  start_time DATETIME DEFAULT NULL,
  end_time DATETIME DEFAULT NULL,
  days_active VARCHAR(50) DEFAULT NULL,  -- npr: 'mon,tue,wed'
  daily_time_start TIME DEFAULT NULL,
  daily_time_end TIME DEFAULT NULL,
  duration_secs INT DEFAULT 7,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
