-- Crear la base de datos
CREATE DATABASE IF NOT EXISTS fidelizacion;
USE fidelizacion;

-- Crear la tabla histcompra
CREATE TABLE histcompra (
    ID_hist      INT AUTO_INCREMENT PRIMARY KEY,
    RUT_hist     VARCHAR(10),
    DOC_hist     VARCHAR(50),
    TIPO_hist    VARCHAR(59),
    FECHA_hist   DATE,
    TDA_hist     INT,
    CANT_hist    INT,
    NOMART_hist  VARCHAR(100),
    SKU_hist     VARCHAR(50),
    GRAT_hist    INT
);