create table empleados
(
id_imt primary key auto_increment,
nombre varchar (60),
puesto varchar (60),
fecha_nac date,
hora date,
sueldo date);


CREATE table clientes
(
id_registro INT primary key AUTO_INCREMENT,
nombre varchar (30),
cel INT NOT NULL,
dpi int NOT NULL,
fecha_nac date
);


create TABLE registros
(
id_registro int primary key AUTO_INCREMENT,
entrada int NOT NULL,
salida int NOT NULL,
id_cliente int,
no_habitacion varchar (10),
tipo_pago int
);


CREATE TABLE costos
(
id_costos INT PRIMARY KEY AUTO_INCREMENT,
HORA DATE,
dia DATE,
semana DATE
);

INSERT INTO empleados
(nombre,puesto,fecha_nac,hora,sueldo) VALUES
("maria","administrador","2001-04-16","3:00",5000),
("juan","secretaria","1999-07-01","1:00",3500),
("ana","limpieza","2002-03-02","12:00",3000),
("monica","ama de llaves","2001-04-05","2:00",5000),
("fernando","conserge","2003-05-05","3:00",6000);