CREATE TABLE IF NOT EXISTS pos_sales (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    numero VARCHAR(50) NOT NULL,
    valor_total DECIMAL(18,2) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS cash_closures (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    data DATE NOT NULL,
    status VARCHAR(20) DEFAULT 'aberto',
    valor_fechamento DECIMAL(18,2) DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);