-- Struktura baze za prošireni CMS
CREATE TABLE IF NOT EXISTS users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) NOT NULL UNIQUE,
  password VARCHAR(255) NOT NULL
);

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
);

-- admin / admin123
INSERT INTO users (username, password) VALUES
('admin', '$2y$10$EwUSZUzLZXQeTL9JkC3Z5uUAMxUoWRuVOppE0nUDo3nV7KJgbzERW')
ON DUPLICATE KEY UPDATE password=VALUES(password);