· 8 years ago · Nov 29, 2017, 07:00 PM
1CREATE TABLE IF NOT EXISTS `t_exam_dates` (
2 `exam_date` date NOT NULL,
3 `exam_hour` time NOT NULL,
4 `free_places` int(10) NOT NULL
5 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
6
7INSERT INTO `t_exam_dates` (`exam_date`, `exam_hour`, `free_places`) VALUES
8('2017-11-23', '8:00', 8),
9('2017-11-23', '10:00', 10),
10('2017-12-01', '8:00', 9),
11('2017-12-01', '10:00', 10),
12('2017-12-02', '8:00', 10),
13('2017-12-02', '10:00', 10),
14('2017-12-03', '8:00', 10),
15('2017-12-03', '10:00', 10),
16('2017-12-04', '8:00', 10),
17('2017-12-04', '10:00', 10),
18('2017-12-05', '8:00', 10),
19('2017-12-05', '10:00', 10),
20('2017-12-06', '8:00', 10),
21('2017-12-06', '10:00', 10),
22('2017-12-07', '8:00', 10),
23('2017-12-07', '10:00', 10),
24('2017-12-08', '8:00', 10),
25('2017-12-08', '10:00', 10),
26('2017-12-09', '8:00', 9),
27('2017-12-09', '10:00', 10),
28('2017-12-10', '8:00', 10),
29('2017-12-10', '10:00', 10),
30('2017-12-11', '8:00', 10),
31('2017-12-11', '10:00', 10),
32('2017-12-12', '8:00', 10),
33('2017-12-12', '10:00', 10),
34('2017-12-13', '8:00', 10),
35('2017-12-13', '10:00', 10),
36('2017-12-14', '8:00', 10),
37('2017-12-14', '10:00', 10),
38('2017-12-15', '8:00', 10),
39('2017-12-15', '10:00', 10),
40('2017-12-16', '8:00', 10),
41('2017-12-16', '10:00', 10),
42('2017-12-17', '8:00', 10),
43('2017-12-17', '10:00', 10),
44('2017-12-18', '8:00', 10),
45('2017-12-18', '10:00', 10),
46('2017-12-19', '8:00', 10),
47('2017-12-19', '10:00', 10),
48('2017-12-20', '8:00', 10),
49('2017-12-20', '10:00', 10),
50('2017-12-21', '8:00', 10),
51('2017-12-21', '10:00', 10),
52('2017-12-22', '8:00', 10),
53('2017-12-22', '10:00', 10),
54('2017-12-23', '8:00', 10),
55('2017-12-23', '10:00', 10),
56('2017-12-24', '8:00', 10),
57('2017-12-24', '10:00', 10),
58('2017-12-25', '8:00', 10),
59('2017-12-25', '10:00', 10),
60('2017-12-26', '8:00', 10),
61('2017-12-26', '10:00', 10),
62('2017-12-27', '8:00', 10),
63('2017-12-27', '10:00', 10),
64('2017-12-28', '8:00', 10),
65('2017-12-28', '10:00', 10),
66('2017-12-29', '8:00', 10),
67('2017-12-29', '10:00', 10),
68('2017-12-30', '8:00', 10),
69('2017-12-30', '10:00', 10),
70('2017-12-31', '8:00', 10),
71('2017-12-31', '10:00', 10),
72('2018-01-01', '8:00', 10),
73('2018-01-01', '10:00', 10),
74('2018-01-02', '8:00', 10),
75('2018-01-02', '10:00', 10),
76('2018-01-03', '8:00', 10),
77('2018-01-03', '10:00', 10),
78('2018-01-04', '8:00', 10),
79('2018-01-04', '10:00', 10),
80('2018-01-05', '8:00', 10),
81('2018-01-05', '10:00', 10),
82('2018-01-06', '8:00', 10),
83('2018-01-06', '10:00', 10),
84('2018-01-07', '8:00', 10),
85('2018-01-07', '10:00', 10),
86('2018-01-08', '8:00', 10),
87('2018-01-08', '10:00', 10),
88('2018-01-09', '8:00', 10),
89('2018-01-09', '10:00', 10),
90('2018-01-10', '8:00', 10),
91('2018-01-10', '10:00', 10),
92('2018-01-11', '8:00', 10),
93('2018-01-11', '10:00', 10),
94('2018-01-12', '8:00', 10),
95('2018-01-12', '10:00', 10),
96('2018-01-13', '8:00', 10),
97('2018-01-13', '10:00', 10),
98('2018-01-14', '8:00', 10),
99('2018-01-14', '10:00', 10),
100('2018-01-15', '8:00', 10),
101('2018-01-15', '10:00', 10),
102('2018-01-16', '8:00', 10),
103('2018-01-16', '10:00', 10),
104('2018-01-17', '8:00', 10),
105('2018-01-17', '10:00', 10),
106('2018-01-18', '8:00', 10),
107('2018-01-18', '10:00', 10),
108('2018-01-19', '8:00', 10),
109('2018-01-19', '10:00', 10),
110('2018-01-20', '8:00', 10),
111('2018-01-20', '10:00', 10),
112('2018-01-21', '8:00', 10),
113('2018-01-21', '10:00', 10),
114('2018-01-22', '8:00', 10),
115('2018-01-22', '10:00', 10),
116('2018-01-23', '8:00', 10),
117('2018-01-23', '10:00', 10),
118('2018-01-24', '8:00', 10),
119('2018-01-24', '10:00', 10),
120('2018-01-25', '8:00', 10),
121('2018-01-25', '10:00', 10),
122('2018-01-26', '8:00', 10),
123('2018-01-26', '10:00', 10),
124('2018-01-27', '8:00', 10),
125('2018-01-27', '10:00', 10),
126('2018-01-28', '8:00', 10),
127('2018-01-28', '10:00', 10),
128('2018-01-29', '8:00', 10),
129('2018-01-29', '10:00', 10),
130('2018-01-30', '8:00', 10),
131('2018-01-30', '10:00', 10),
132('2018-01-31', '8:00', 10),
133('2018-01-31', '10:00', 10);