CREATE TABLE INGRESOS
(
    ID_ingreso int PRIMARY KEY AUTO_INCREMENT,
    Nombre varchar (50),
    Tel int,
    DPI int
);

CREATE TABLE VEHICULOS
(
    id_vehiculo int PRIMARY KEY AUTO_INCREMENT,
    modelo int,
    marca varchar (50),
    placa char (5),
    papeles char (5),
    estado char (5),
    precio int,
    fecha_ingreso date 
);

CREATE TABLE CLIENTES
(
    id_cliente int PRIMARY KEY AUTO_INCREMENT,
    nombre varchar (50),
    tel INT,
    DPI int,
    fecha_nacimiento date
);

CREATE TABLE VENTAS
(
    id_venta int PRIMARY KEY AUTO_INCREMENT,
    tipo_pago varchar (30),
    precio_venta INT
);

INSERT INTO ingresos
(Nombre, Tel, DPI)
VALUES
("Jose",48017552,00175612),
("Mario",58739548,52001988),
("Gustavo",95620173,00259910),
("Celeste",36456562,7978000),
("Raul",38012122,010297);

INSERT INTO vehiculos
(modelo, marca, placa, papeles, estado, precio, fecha_ingreso)
VALUES
(2008, "Honda", "ABC-123", "si", "bueno", 1180, "2025-04-13"),
(2024, "Toyota", "NEU-454", "si", "bueno", 5500, "2025-04-25"),
(2020, "Toyota", "LMO-560", "si", "bueno", 2670, "2025-05-01"),
(2014, "Honda", "RLM-780", "si", "bueno", 1680, "2025-08-10"),
(2025, "Honda", "PRU-890", "si", "bueno", 2108, "2025-08-20");

INSERT INTO clientes
(Nombre, Tel, DPI, fecha_nacimiento)
VALUES
("Juan", 35079437, 047987, "24-01-2000"),
("Maria", 08973606, 470837, "30-12-2001"),
("mariana", 35945110, 17970835, "08-03-1998"),
("Jose", 45364506, 37007897, "01-03-2000"),
("Marta", 35079876, 4500079, "10-11-1988");

INSERT INTO ventas
(tipo_pago,precio_venta)
VALUES
("tarjeta",50000),
("efectivo",80000),
("efectivo",60000),
("tarjeta",90000),
("tarjeta",95000);