· 6 years ago · Aug 15, 2019, 09:56 PM
1CREATE TABLE IF NOT EXISTS horario (
2 emp_id INT NOT NULL UNIQUE,
3 lunes TINYINT NOT NULL,
4 martes TINYINT NOT NULL,
5 miercoles TINYINT NOT NULL,
6 jueves TINYINT NOT NULL,
7 viernes TINYINT NOT NULL,
8 sabado TINYINT NOT NULL,
9 domingo TINYINT NOT NULL,
10 apertura VARCHAR(5) NOT NULL,
11 cierre VARCHAR(5) NOT NULL
12) ENGINE=InnoDB;
13
14CREATE TABLE horarios(
15 id INT PRIMARY KEY AUTO_INCREMENT,
16 dia VARCHAR(20) NOT NULL,
17 horarioApertura TIME,
18 horarioCierre TIME
19);
20
21INSERT INTO horarios(dia, horarioApertura, horarioCierre)
22VALUES
23("Lunes", "09:00:00", "18:00:00"),
24("Martes", "09:00:00", "18:00:00"),
25("Miercoles", "09:00:00", "18:00:00"),
26("Jueves", "09:00:00", "18:00:00"),
27("Viernes", "09:00:00", "18:00:00"),
28("Sábado", "09:00:00", "13:00:00"),
29("Domingo", "09:00:00", "13:00:00");