CREATE TABLE users(
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(80),
password VARCHAR(255),
role VARCHAR(30)
);

CREATE TABLE scenes(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
template VARCHAR(100),
active INT DEFAULT 0
);

CREATE TABLE graphics(
id INT AUTO_INCREMENT PRIMARY KEY,
scene_id INT,
title TEXT,
subtitle TEXT,
ticker TEXT,
hashtag VARCHAR(100),
logo VARCHAR(255),
animation VARCHAR(50),
active INT DEFAULT 0
);

CREATE TABLE assets(
id INT AUTO_INCREMENT PRIMARY KEY,
type VARCHAR(50),
file VARCHAR(255)
);

CREATE TABLE logs(
id INT AUTO_INCREMENT PRIMARY KEY,
action TEXT,
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO scenes(name,template) VALUES
('Noticias','news'),
('Deportes','sports'),
('Boda Premium','wedding'),
('Cultural','culture'),
('Breaking','breaking');