CREATE DATABASE valleyviewhotele_eventos
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;

USE valleyviewhotele_eventos;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(150) NOT NULL,
    username VARCHAR(100) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    role ENUM('admin','manager','staff') DEFAULT 'staff',
    active TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE event_status (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    color VARCHAR(20) NULL
);

INSERT INTO event_status (name,color) VALUES
('Orçamento','#3498db'),
('Pré-Reserva','#f1c40f'),
('Confirmado','#2ecc71'),
('Cancelado','#e74c3c'),
('Concluído','#7f8c8d');

CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    event_date DATE,
    status_id INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);