CREATE TABLE IF NOT EXISTS admins (
  id INT AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(190) NOT NULL UNIQUE,
  password_hash VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS stations (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(190) NOT NULL,
  slug VARCHAR(190) NOT NULL UNIQUE,
  slogan VARCHAR(255) DEFAULT NULL,
  stream_url TEXT NOT NULL,
  logo VARCHAR(255) DEFAULT NULL,
  cover_image VARCHAR(255) DEFAULT NULL,
  facebook TEXT DEFAULT NULL,
  youtube TEXT DEFAULT NULL,
  instagram TEXT DEFAULT NULL,
  whatsapp TEXT DEFAULT NULL,
  tiktok TEXT DEFAULT NULL,
  android_url TEXT DEFAULT NULL,
  ios_url TEXT DEFAULT NULL,
  primary_color VARCHAR(20) DEFAULT '#ff4b2b',
  secondary_color VARCHAR(20) DEFAULT '#5f9dc9',
  status ENUM('active','inactive') DEFAULT 'active',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO admins (email, password_hash)
VALUES ('admin@vsgtech.co', '$2y$10$WyMx2ZJhYlV9UYIw8L0WmeTVlHTy7OHfMG0jTq6zgZJSGjOgzcHQ2')
ON DUPLICATE KEY UPDATE email=email;

INSERT INTO stations 
(name, slug, slogan, stream_url, logo, cover_image, facebook, youtube, instagram, whatsapp, tiktok, android_url, ios_url, primary_color, secondary_color)
VALUES
('VSGTECH Radio Demo', 'vsgtech-radio-demo', 'Streaming profesional 24/7', 'https://cloud8.vsgtech.co/8094/stream', '', '', '#', '#', '#', '#', '#', '#', '#', '#ff4b2b', '#5f9dc9')
ON DUPLICATE KEY UPDATE slug=slug;