csVDdnKV

1CREATE TABLE IF NOT EXISTS `p_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 `p_exam_dates` (`exam_date`, `exam_hour`, `free_places`) VALUES 
8('2017-11-25', '9:00', 9),
9('2017-11-25', '10:30', 10),
10('2017-11-25', '11:30', 10),
11('2017-11-25', '14:30', 10),
12('2017-11-25', '16:30', 10),
13('2017-12-01', '9:00', 9),
14('2017-12-01', '10:30', 10),
15('2017-12-01', '11:30', 10),
16('2017-12-01', '14:30', 10),
17('2017-12-01', '16:30', 10),
18('2017-12-02', '9:00', 10),
19('2017-12-02', '10:30', 10),
20('2017-12-02', '11:30', 10),
21('2017-12-02', '14:30', 10),
22('2017-12-02', '16:30', 10),
23('2017-12-03', '9:00', 10),
24('2017-12-03', '10:30', 10),
25('2017-12-03', '11:30', 10),
26('2017-12-03', '14:30', 10),
27('2017-12-03', '16:30', 10),
28('2017-12-04', '9:00', 10),
29('2017-12-04', '10:30', 10),
30('2017-12-04', '11:30', 10),
31('2017-12-04', '14:30', 10),
32('2017-12-04', '16:30', 10),
33('2017-12-05', '9:00', 10),
34('2017-12-05', '10:30', 10),
35('2017-12-05', '11:30', 10),
36('2017-12-05', '14:30', 10),
37('2017-12-05', '16:30', 10),
38('2017-12-06', '9:00', 10),
39('2017-12-06', '10:30', 10),
40('2017-12-06', '11:30', 10),
41('2017-12-06', '14:30', 10),
42('2017-12-06', '16:30', 10),
43('2017-12-07', '9:00', 10),
44('2017-12-07', '10:30', 10),
45('2017-12-07', '11:30', 10),
46('2017-12-07', '14:30', 10),
47('2017-12-07', '16:30', 10),
48('2017-12-08', '9:00', 10),
49('2017-12-08', '10:30', 10),
50('2017-12-08', '11:30', 10),
51('2017-12-08', '14:30', 10),
52('2017-12-08', '16:30', 10),
53('2017-12-09', '9:00', 9),
54('2017-12-09', '10:30', 10),
55('2017-12-09', '11:30', 10),
56('2017-12-09', '14:30', 10),
57('2017-12-09', '16:30', 10),
58('2017-12-10', '9:00', 10),
59('2017-12-10', '10:30', 10),
60('2017-12-10', '11:30', 10),
61('2017-12-10', '14:30', 10),
62('2017-12-10', '16:30', 10),
63('2017-12-11', '9:00', 10),
64('2017-12-11', '10:30', 10),
65('2017-12-11', '11:30', 10),
66('2017-12-11', '14:30', 10),
67('2017-12-11', '16:30', 10),
68('2017-12-12', '9:00', 10),
69('2017-12-12', '10:30', 10),
70('2017-12-12', '11:30', 10),
71('2017-12-12', '14:30', 10),
72('2017-12-12', '16:30', 10),
73('2017-12-13', '9:00', 10),
74('2017-12-13', '10:30', 10),
75('2017-12-13', '11:30', 10),
76('2017-12-13', '14:30', 10),
77('2017-12-13', '16:30', 10),
78('2017-12-14', '9:00', 10),
79('2017-12-14', '10:30', 10),
80('2017-12-14', '11:30', 10),
81('2017-12-14', '14:30', 10),
82('2017-12-14', '16:30', 10),
83('2017-12-15', '9:00', 10),
84('2017-12-15', '10:30', 10),
85('2017-12-15', '11:30', 10),
86('2017-12-15', '14:30', 10),
87('2017-12-15', '16:30', 10),
88('2017-12-16', '9:00', 10),
89('2017-12-16', '10:30', 10),
90('2017-12-16', '11:30', 10),
91('2017-12-16', '14:30', 10),
92('2017-12-16', '16:30', 10),
93('2017-12-17', '9:00', 10),
94('2017-12-17', '10:30', 10),
95('2017-12-17', '11:30', 10),
96('2017-12-17', '14:30', 10),
97('2017-12-17', '16:30', 10),
98('2017-12-18', '9:00', 10),
99('2017-12-18', '10:30', 10),
100('2017-12-18', '11:30', 10),
101('2017-12-18', '14:30', 10),
102('2017-12-18', '16:30', 10),
103('2017-12-19', '9:00', 9),
104('2017-12-19', '10:30', 10),
105('2017-12-19', '11:30', 10),
106('2017-12-19', '14:30', 10),
107('2017-12-19', '16:30', 10),
108('2017-12-20', '9:00', 10),
109('2017-12-20', '10:30', 10),
110('2017-12-20', '11:30', 10),
111('2017-12-20', '14:30', 10),
112('2017-12-20', '16:30', 10),
113('2017-12-21', '9:00', 10),
114('2017-12-21', '10:30', 10),
115('2017-12-21', '11:30', 10),
116('2017-12-21', '14:30', 10),
117('2017-12-21', '16:30', 10),
118('2017-12-22', '9:00', 10),
119('2017-12-22', '10:30', 10),
120('2017-12-22', '11:30', 10),
121('2017-12-22', '14:30', 10),
122('2017-12-22', '16:30', 10),
123('2017-12-23', '9:00', 10),
124('2017-12-23', '10:30', 10),
125('2017-12-23', '11:30', 10),
126('2017-12-23', '14:30', 10),
127('2017-12-23', '16:30', 10),
128('2017-12-24', '9:00', 10),
129('2017-12-24', '10:30', 10),
130('2017-12-24', '11:30', 10),
131('2017-12-24', '14:30', 10),
132('2017-12-24', '16:30', 10),
133('2017-12-25', '9:00', 10),
134('2017-12-25', '10:30', 10),
135('2017-12-25', '11:30', 10),
136('2017-12-25', '14:30', 10),
137('2017-12-25', '16:30', 10),
138('2017-12-26', '9:00', 10),
139('2017-12-26', '10:30', 10),
140('2017-12-26', '11:30', 10),
141('2017-12-26', '14:30', 10),
142('2017-12-26', '16:30', 10),
143('2017-12-27', '9:00', 10),
144('2017-12-27', '10:30', 10),
145('2017-12-27', '11:30', 10),
146('2017-12-27', '14:30', 10),
147('2017-12-27', '16:30', 10),
148('2017-12-28', '9:00', 10),
149('2017-12-28', '10:30', 10),
150('2017-12-28', '11:30', 10),
151('2017-12-28', '14:30', 10),
152('2017-12-28', '16:30', 10),
153('2017-12-29', '9:00', 10),
154('2017-12-29', '10:30', 10),
155('2017-12-29', '11:30', 10),
156('2017-12-29', '14:30', 10),
157('2017-12-29', '16:30', 10),
158('2017-12-30', '9:00', 10),
159('2017-12-30', '10:30', 10),
160('2017-12-30', '11:30', 10),
161('2017-12-30', '14:30', 10),
162('2017-12-30', '16:30', 10),
163('2017-12-31', '9:00', 10),
164('2017-12-31', '10:30', 10),
165('2017-12-31', '11:30', 10),
166('2017-12-31', '14:30', 10),
167('2017-12-31', '16:30', 10),
168('2018-01-01', '9:00', 10),
169('2018-01-01', '10:30', 10),
170('2018-01-01', '11:30', 10),
171('2018-01-01', '14:30', 10),
172('2018-01-01', '16:30', 10),
173('2018-01-02', '9:00', 10),
174('2018-01-02', '10:30', 10),
175('2018-01-02', '11:30', 10),
176('2018-01-02', '14:30', 10),
177('2018-01-02', '16:30', 10),
178('2018-01-03', '9:00', 10),
179('2018-01-03', '10:30', 10),
180('2018-01-03', '11:30', 10),
181('2018-01-03', '14:30', 10),
182('2018-01-03', '16:30', 10),
183('2018-01-04', '9:00', 10),
184('2018-01-04', '10:30', 10),
185('2018-01-04', '11:30', 10),
186('2018-01-04', '14:30', 10),
187('2018-01-04', '16:30', 10),
188('2018-01-05', '9:00', 10),
189('2018-01-05', '10:30', 10),
190('2018-01-05', '11:30', 10),
191('2018-01-05', '14:30', 10),
192('2018-01-05', '16:30', 10),
193('2018-01-06', '9:00', 10),
194('2018-01-06', '10:30', 10),
195('2018-01-06', '11:30', 10),
196('2018-01-06', '14:30', 10),
197('2018-01-06', '16:30', 10),
198('2018-01-07', '9:00', 10),
199('2018-01-07', '10:30', 10),
200('2018-01-07', '11:30', 10),
201('2018-01-07', '14:30', 10),
202('2018-01-07', '16:30', 10),
203('2018-01-08', '9:00', 10),
204('2018-01-08', '10:30', 10),
205('2018-01-08', '11:30', 10),
206('2018-01-08', '14:30', 10),
207('2018-01-08', '16:30', 10),
208('2018-01-09', '9:00', 10),
209('2018-01-09', '10:30', 10),
210('2018-01-09', '11:30', 10),
211('2018-01-09', '14:30', 10),
212('2018-01-09', '16:30', 10),
213('2018-01-10', '9:00', 10),
214('2018-01-10', '10:30', 10),
215('2018-01-10', '11:30', 10),
216('2018-01-10', '14:30', 10),
217('2018-01-10', '16:30', 10),
218('2018-01-11', '9:00', 10),
219('2018-01-11', '10:30', 10),
220('2018-01-11', '11:30', 10),
221('2018-01-11', '14:30', 10),
222('2018-01-11', '16:30', 10),
223('2018-01-12', '9:00', 10),
224('2018-01-12', '10:30', 10),
225('2018-01-12', '11:30', 10),
226('2018-01-12', '14:30', 10),
227('2018-01-12', '16:30', 10),
228('2018-01-13', '9:00', 10),
229('2018-01-13', '10:30', 10),
230('2018-01-13', '11:30', 10),
231('2018-01-13', '14:30', 10),
232('2018-01-13', '16:30', 10),
233('2018-01-14', '9:00', 10),
234('2018-01-14', '10:30', 10),
235('2018-01-14', '11:30', 10),
236('2018-01-14', '14:30', 10),
237('2018-01-14', '16:30', 10),
238('2018-01-15', '9:00', 10),
239('2018-01-15', '10:30', 10),
240('2018-01-15', '11:30', 10),
241('2018-01-15', '14:30', 10),
242('2018-01-15', '16:30', 10),
243('2018-01-16', '9:00', 10),
244('2018-01-16', '10:30', 10),
245('2018-01-16', '11:30', 10),
246('2018-01-16', '14:30', 10),
247('2018-01-16', '16:30', 10),
248('2018-01-17', '9:00', 10),
249('2018-01-17', '10:30', 10),
250('2018-01-17', '11:30', 10),
251('2018-01-17', '14:30', 10),
252('2018-01-17', '16:30', 10),
253('2018-01-18', '9:00', 10),
254('2018-01-18', '10:30', 10),
255('2018-01-18', '11:30', 10),
256('2018-01-18', '14:30', 10),
257('2018-01-18', '16:30', 10),
258('2018-01-19', '9:00', 10),
259('2018-01-19', '10:30', 10),
260('2018-01-19', '11:30', 10),
261('2018-01-19', '14:30', 10),
262('2018-01-19', '16:30', 10),
263('2018-01-20', '9:00', 10),
264('2018-01-20', '10:30', 10),
265('2018-01-20', '11:30', 10),
266('2018-01-20', '14:30', 10),
267('2018-01-20', '16:30', 10),
268('2018-01-21', '9:00', 10),
269('2018-01-21', '10:30', 10),
270('2018-01-21', '11:30', 10),
271('2018-01-21', '14:30', 10),
272('2018-01-21', '16:30', 10),
273('2018-01-22', '9:00', 10),
274('2018-01-22', '10:30', 10),
275('2018-01-22', '11:30', 10),
276('2018-01-22', '14:30', 10),
277('2018-01-22', '16:30', 10),
278('2018-01-23', '9:00', 10),
279('2018-01-23', '10:30', 10),
280('2018-01-23', '11:30', 10),
281('2018-01-23', '14:30', 10),
282('2018-01-23', '16:30', 10),
283('2018-01-24', '9:00', 10),
284('2018-01-24', '10:30', 10),
285('2018-01-24', '11:30', 10),
286('2018-01-24', '14:30', 10),
287('2018-01-24', '16:30', 10),
288('2018-01-25', '9:00', 10),
289('2018-01-25', '10:30', 10),
290('2018-01-25', '11:30', 10),
291('2018-01-25', '14:30', 10),
292('2018-01-25', '16:30', 10),
293('2018-01-26', '9:00', 10),
294('2018-01-26', '10:30', 10),
295('2018-01-26', '11:30', 10),
296('2018-01-26', '14:30', 10),
297('2018-01-26', '16:30', 10),
298('2018-01-27', '9:00', 10),
299('2018-01-27', '10:30', 10),
300('2018-01-27', '11:30', 10),
301('2018-01-27', '14:30', 10),
302('2018-01-27', '16:30', 10),
303('2018-01-28', '9:00', 10),
304('2018-01-28', '10:30', 10),
305('2018-01-28', '11:30', 10),
306('2018-01-28', '14:30', 10),
307('2018-01-28', '16:30', 10),
308('2018-01-29', '9:00', 10),
309('2018-01-29', '10:30', 10),
310('2018-01-29', '11:30', 10),
311('2018-01-29', '14:30', 10),
312('2018-01-29', '16:30', 10),
313('2018-01-30', '9:00', 10),
314('2018-01-30', '10:30', 10),
315('2018-01-30', '11:30', 10),
316('2018-01-30', '14:30', 10),
317('2018-01-30', '16:30', 10),
318('2018-01-31', '9:00', 10),
319('2018-01-31', '10:30', 10),
320('2018-01-31', '11:30', 10),
321('2018-01-31', '14:30', 10),
322('2018-01-31', '16:30', 10);