
CREATE DATABASE IF NOT EXISTS rn_viagens CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE rn_viagens;

CREATE TABLE IF NOT EXISTS vendas (
    id INT AUTO_INCREMENT PRIMARY KEY,
    cliente VARCHAR(100) NOT NULL,
    destino VARCHAR(150) NOT NULL,
    valor DECIMAL(10,2) DEFAULT 0,
    telefone VARCHAR(20),
    status VARCHAR(50) NOT NULL DEFAULT 'Interesse',
    data DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
