1
by brian
clean slate |
1 |
drop table if exists abs; |
2 |
drop table if exists bug21114_child; |
|
3 |
SHOW CREATE TABLE abs; |
|
4 |
Table Create Table |
|
5 |
abs CREATE TABLE `abs` ( |
|
6 |
`col1` int(11) NOT NULL, |
|
7 |
`col2` int(11) NOT NULL, |
|
8 |
`col3` varchar(10) DEFAULT NULL, |
|
9 |
PRIMARY KEY (`col1`,`col2`) |
|
10 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
11 |
SHOW CREATE TABLE bug21114_child; |
|
12 |
Table Create Table |
|
13 |
bug21114_child CREATE TABLE `bug21114_child` ( |
|
14 |
`pk` int(11) NOT NULL, |
|
15 |
`fk_col1` int(11) NOT NULL, |
|
16 |
`fk_col2` int(11) NOT NULL, |
|
17 |
`fk_col3` int(11) NOT NULL, |
|
18 |
`fk_col4` int(11) NOT NULL, |
|
19 |
KEY `fk_fct` (`fk_col1`,`fk_col2`), |
|
20 |
KEY `fk_fct_space` (`fk_col3`,`fk_col4`), |
|
21 |
CONSTRAINT `fk_fct` FOREIGN KEY (`fk_col1`, `fk_col2`) REFERENCES `abs` (`col1`, `col2`), |
|
22 |
CONSTRAINT `fk_fct_space` FOREIGN KEY (`fk_col3`, `fk_col4`) REFERENCES `abs` (`col1`, `col2`) |
|
23 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
24 |
DROP TABLE bug21114_child; |
|
25 |
DROP TABLE abs; |
|
26 |
drop table if exists field; |
|
27 |
drop table if exists bug21114_child; |
|
28 |
SHOW CREATE TABLE field; |
|
29 |
Table Create Table |
|
30 |
field CREATE TABLE `field` ( |
|
31 |
`col1` int(11) NOT NULL, |
|
32 |
`col2` int(11) NOT NULL, |
|
33 |
`col3` varchar(10) DEFAULT NULL, |
|
34 |
PRIMARY KEY (`col1`,`col2`) |
|
35 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
36 |
SHOW CREATE TABLE bug21114_child; |
|
37 |
Table Create Table |
|
38 |
bug21114_child CREATE TABLE `bug21114_child` ( |
|
39 |
`pk` int(11) NOT NULL, |
|
40 |
`fk_col1` int(11) NOT NULL, |
|
41 |
`fk_col2` int(11) NOT NULL, |
|
42 |
`fk_col3` int(11) NOT NULL, |
|
43 |
`fk_col4` int(11) NOT NULL, |
|
44 |
KEY `fk_fct` (`fk_col1`,`fk_col2`), |
|
45 |
KEY `fk_fct_space` (`fk_col3`,`fk_col4`), |
|
46 |
CONSTRAINT `fk_fct` FOREIGN KEY (`fk_col1`, `fk_col2`) REFERENCES `field` (`col1`, `col2`), |
|
47 |
CONSTRAINT `fk_fct_space` FOREIGN KEY (`fk_col3`, `fk_col4`) REFERENCES `field` (`col1`, `col2`) |
|
48 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
49 |
DROP TABLE bug21114_child; |
|
50 |
DROP TABLE field; |
|
51 |
drop table if exists format; |
|
52 |
drop table if exists bug21114_child; |
|
53 |
SHOW CREATE TABLE format; |
|
54 |
Table Create Table |
|
55 |
format CREATE TABLE `format` ( |
|
56 |
`col1` int(11) NOT NULL, |
|
57 |
`col2` int(11) NOT NULL, |
|
58 |
`col3` varchar(10) DEFAULT NULL, |
|
59 |
PRIMARY KEY (`col1`,`col2`) |
|
60 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
61 |
SHOW CREATE TABLE bug21114_child; |
|
62 |
Table Create Table |
|
63 |
bug21114_child CREATE TABLE `bug21114_child` ( |
|
64 |
`pk` int(11) NOT NULL, |
|
65 |
`fk_col1` int(11) NOT NULL, |
|
66 |
`fk_col2` int(11) NOT NULL, |
|
67 |
`fk_col3` int(11) NOT NULL, |
|
68 |
`fk_col4` int(11) NOT NULL, |
|
69 |
KEY `fk_fct` (`fk_col1`,`fk_col2`), |
|
70 |
KEY `fk_fct_space` (`fk_col3`,`fk_col4`), |
|
71 |
CONSTRAINT `fk_fct` FOREIGN KEY (`fk_col1`, `fk_col2`) REFERENCES `format` (`col1`, `col2`), |
|
72 |
CONSTRAINT `fk_fct_space` FOREIGN KEY (`fk_col3`, `fk_col4`) REFERENCES `format` (`col1`, `col2`) |
|
73 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
74 |
DROP TABLE bug21114_child; |
|
75 |
DROP TABLE format; |
|
76 |
drop table if exists acos; |
|
77 |
drop table if exists bug21114_child; |
|
78 |
DROP TABLE bug21114_child; |
|
79 |
DROP TABLE acos; |
|
80 |
drop table if exists adddate; |
|
81 |
drop table if exists bug21114_child; |
|
82 |
DROP TABLE bug21114_child; |
|
83 |
DROP TABLE adddate; |
|
84 |
drop table if exists addtime; |
|
85 |
drop table if exists bug21114_child; |
|
86 |
DROP TABLE bug21114_child; |
|
87 |
DROP TABLE addtime; |
|
88 |
drop table if exists aes_decrypt; |
|
89 |
drop table if exists bug21114_child; |
|
90 |
DROP TABLE bug21114_child; |
|
91 |
DROP TABLE aes_decrypt; |
|
92 |
drop table if exists aes_encrypt; |
|
93 |
drop table if exists bug21114_child; |
|
94 |
DROP TABLE bug21114_child; |
|
95 |
DROP TABLE aes_encrypt; |
|
96 |
drop table if exists area; |
|
97 |
drop table if exists bug21114_child; |
|
98 |
DROP TABLE bug21114_child; |
|
99 |
DROP TABLE area; |
|
100 |
drop table if exists asbinary; |
|
101 |
drop table if exists bug21114_child; |
|
102 |
DROP TABLE bug21114_child; |
|
103 |
DROP TABLE asbinary; |
|
104 |
drop table if exists asin; |
|
105 |
drop table if exists bug21114_child; |
|
106 |
DROP TABLE bug21114_child; |
|
107 |
DROP TABLE asin; |
|
108 |
drop table if exists astext; |
|
109 |
drop table if exists bug21114_child; |
|
110 |
DROP TABLE bug21114_child; |
|
111 |
DROP TABLE astext; |
|
112 |
drop table if exists aswkb; |
|
113 |
drop table if exists bug21114_child; |
|
114 |
DROP TABLE bug21114_child; |
|
115 |
DROP TABLE aswkb; |
|
116 |
drop table if exists aswkt; |
|
117 |
drop table if exists bug21114_child; |
|
118 |
DROP TABLE bug21114_child; |
|
119 |
DROP TABLE aswkt; |
|
120 |
drop table if exists atan; |
|
121 |
drop table if exists bug21114_child; |
|
122 |
DROP TABLE bug21114_child; |
|
123 |
DROP TABLE atan; |
|
124 |
drop table if exists atan2; |
|
125 |
drop table if exists bug21114_child; |
|
126 |
DROP TABLE bug21114_child; |
|
127 |
DROP TABLE atan2; |
|
128 |
drop table if exists benchmark; |
|
129 |
drop table if exists bug21114_child; |
|
130 |
DROP TABLE bug21114_child; |
|
131 |
DROP TABLE benchmark; |
|
132 |
drop table if exists bin; |
|
133 |
drop table if exists bug21114_child; |
|
134 |
DROP TABLE bug21114_child; |
|
135 |
DROP TABLE bin; |
|
136 |
drop table if exists bit_count; |
|
137 |
drop table if exists bug21114_child; |
|
138 |
DROP TABLE bug21114_child; |
|
139 |
DROP TABLE bit_count; |
|
140 |
drop table if exists bit_length; |
|
141 |
drop table if exists bug21114_child; |
|
142 |
DROP TABLE bug21114_child; |
|
143 |
DROP TABLE bit_length; |
|
144 |
drop table if exists ceil; |
|
145 |
drop table if exists bug21114_child; |
|
146 |
DROP TABLE bug21114_child; |
|
147 |
DROP TABLE ceil; |
|
148 |
drop table if exists ceiling; |
|
149 |
drop table if exists bug21114_child; |
|
150 |
DROP TABLE bug21114_child; |
|
151 |
DROP TABLE ceiling; |
|
152 |
drop table if exists centroid; |
|
153 |
drop table if exists bug21114_child; |
|
154 |
DROP TABLE bug21114_child; |
|
155 |
DROP TABLE centroid; |
|
156 |
drop table if exists character_length; |
|
157 |
drop table if exists bug21114_child; |
|
158 |
DROP TABLE bug21114_child; |
|
159 |
DROP TABLE character_length; |
|
160 |
drop table if exists char_length; |
|
161 |
drop table if exists bug21114_child; |
|
162 |
DROP TABLE bug21114_child; |
|
163 |
DROP TABLE char_length; |
|
164 |
drop table if exists coercibility; |
|
165 |
drop table if exists bug21114_child; |
|
166 |
DROP TABLE bug21114_child; |
|
167 |
DROP TABLE coercibility; |
|
168 |
drop table if exists compress; |
|
169 |
drop table if exists bug21114_child; |
|
170 |
DROP TABLE bug21114_child; |
|
171 |
DROP TABLE compress; |
|
172 |
drop table if exists concat; |
|
173 |
drop table if exists bug21114_child; |
|
174 |
DROP TABLE bug21114_child; |
|
175 |
DROP TABLE concat; |
|
176 |
drop table if exists concat_ws; |
|
177 |
drop table if exists bug21114_child; |
|
178 |
DROP TABLE bug21114_child; |
|
179 |
DROP TABLE concat_ws; |
|
180 |
drop table if exists connection_id; |
|
181 |
drop table if exists bug21114_child; |
|
182 |
DROP TABLE bug21114_child; |
|
183 |
DROP TABLE connection_id; |
|
184 |
drop table if exists conv; |
|
185 |
drop table if exists bug21114_child; |
|
186 |
DROP TABLE bug21114_child; |
|
187 |
DROP TABLE conv; |
|
188 |
drop table if exists convert_tz; |
|
189 |
drop table if exists bug21114_child; |
|
190 |
DROP TABLE bug21114_child; |
|
191 |
DROP TABLE convert_tz; |
|
192 |
drop table if exists cos; |
|
193 |
drop table if exists bug21114_child; |
|
194 |
DROP TABLE bug21114_child; |
|
195 |
DROP TABLE cos; |
|
196 |
drop table if exists cot; |
|
197 |
drop table if exists bug21114_child; |
|
198 |
DROP TABLE bug21114_child; |
|
199 |
DROP TABLE cot; |
|
200 |
drop table if exists crc32; |
|
201 |
drop table if exists bug21114_child; |
|
202 |
DROP TABLE bug21114_child; |
|
203 |
DROP TABLE crc32; |
|
204 |
drop table if exists crosses; |
|
205 |
drop table if exists bug21114_child; |
|
206 |
DROP TABLE bug21114_child; |
|
207 |
DROP TABLE crosses; |
|
208 |
drop table if exists datediff; |
|
209 |
drop table if exists bug21114_child; |
|
210 |
DROP TABLE bug21114_child; |
|
211 |
DROP TABLE datediff; |
|
212 |
drop table if exists date_format; |
|
213 |
drop table if exists bug21114_child; |
|
214 |
DROP TABLE bug21114_child; |
|
215 |
DROP TABLE date_format; |
|
216 |
drop table if exists dayname; |
|
217 |
drop table if exists bug21114_child; |
|
218 |
DROP TABLE bug21114_child; |
|
219 |
DROP TABLE dayname; |
|
220 |
drop table if exists dayofmonth; |
|
221 |
drop table if exists bug21114_child; |
|
222 |
DROP TABLE bug21114_child; |
|
223 |
DROP TABLE dayofmonth; |
|
224 |
drop table if exists dayofweek; |
|
225 |
drop table if exists bug21114_child; |
|
226 |
DROP TABLE bug21114_child; |
|
227 |
DROP TABLE dayofweek; |
|
228 |
drop table if exists dayofyear; |
|
229 |
drop table if exists bug21114_child; |
|
230 |
DROP TABLE bug21114_child; |
|
231 |
DROP TABLE dayofyear; |
|
232 |
drop table if exists decode; |
|
233 |
drop table if exists bug21114_child; |
|
234 |
DROP TABLE bug21114_child; |
|
235 |
DROP TABLE decode; |
|
236 |
drop table if exists degrees; |
|
237 |
drop table if exists bug21114_child; |
|
238 |
DROP TABLE bug21114_child; |
|
239 |
DROP TABLE degrees; |
|
240 |
drop table if exists des_decrypt; |
|
241 |
drop table if exists bug21114_child; |
|
242 |
DROP TABLE bug21114_child; |
|
243 |
DROP TABLE des_decrypt; |
|
244 |
drop table if exists des_encrypt; |
|
245 |
drop table if exists bug21114_child; |
|
246 |
DROP TABLE bug21114_child; |
|
247 |
DROP TABLE des_encrypt; |
|
248 |
drop table if exists dimension; |
|
249 |
drop table if exists bug21114_child; |
|
250 |
DROP TABLE bug21114_child; |
|
251 |
DROP TABLE dimension; |
|
252 |
drop table if exists disjoint; |
|
253 |
drop table if exists bug21114_child; |
|
254 |
DROP TABLE bug21114_child; |
|
255 |
DROP TABLE disjoint; |
|
256 |
drop table if exists elt; |
|
257 |
drop table if exists bug21114_child; |
|
258 |
DROP TABLE bug21114_child; |
|
259 |
DROP TABLE elt; |
|
260 |
drop table if exists encode; |
|
261 |
drop table if exists bug21114_child; |
|
262 |
DROP TABLE bug21114_child; |
|
263 |
DROP TABLE encode; |
|
264 |
drop table if exists encrypt; |
|
265 |
drop table if exists bug21114_child; |
|
266 |
DROP TABLE bug21114_child; |
|
267 |
DROP TABLE encrypt; |
|
268 |
drop table if exists endpoint; |
|
269 |
drop table if exists bug21114_child; |
|
270 |
DROP TABLE bug21114_child; |
|
271 |
DROP TABLE endpoint; |
|
272 |
drop table if exists envelope; |
|
273 |
drop table if exists bug21114_child; |
|
274 |
DROP TABLE bug21114_child; |
|
275 |
DROP TABLE envelope; |
|
276 |
drop table if exists equals; |
|
277 |
drop table if exists bug21114_child; |
|
278 |
DROP TABLE bug21114_child; |
|
279 |
DROP TABLE equals; |
|
280 |
drop table if exists exp; |
|
281 |
drop table if exists bug21114_child; |
|
282 |
DROP TABLE bug21114_child; |
|
283 |
DROP TABLE exp; |
|
284 |
drop table if exists export_set; |
|
285 |
drop table if exists bug21114_child; |
|
286 |
DROP TABLE bug21114_child; |
|
287 |
DROP TABLE export_set; |
|
288 |
drop table if exists exteriorring; |
|
289 |
drop table if exists bug21114_child; |
|
290 |
DROP TABLE bug21114_child; |
|
291 |
DROP TABLE exteriorring; |
|
292 |
drop table if exists extractvalue; |
|
293 |
drop table if exists bug21114_child; |
|
294 |
DROP TABLE bug21114_child; |
|
295 |
DROP TABLE extractvalue; |
|
296 |
drop table if exists find_in_set; |
|
297 |
drop table if exists bug21114_child; |
|
298 |
DROP TABLE bug21114_child; |
|
299 |
DROP TABLE find_in_set; |
|
300 |
drop table if exists floor; |
|
301 |
drop table if exists bug21114_child; |
|
302 |
DROP TABLE bug21114_child; |
|
303 |
DROP TABLE floor; |
|
304 |
drop table if exists found_rows; |
|
305 |
drop table if exists bug21114_child; |
|
306 |
DROP TABLE bug21114_child; |
|
307 |
DROP TABLE found_rows; |
|
308 |
drop table if exists from_days; |
|
309 |
drop table if exists bug21114_child; |
|
310 |
DROP TABLE bug21114_child; |
|
311 |
DROP TABLE from_days; |
|
312 |
drop table if exists from_unixtime; |
|
313 |
drop table if exists bug21114_child; |
|
314 |
DROP TABLE bug21114_child; |
|
315 |
DROP TABLE from_unixtime; |
|
316 |
drop table if exists geomcollfromtext; |
|
317 |
drop table if exists bug21114_child; |
|
318 |
DROP TABLE bug21114_child; |
|
319 |
DROP TABLE geomcollfromtext; |
|
320 |
drop table if exists geomcollfromwkb; |
|
321 |
drop table if exists bug21114_child; |
|
322 |
DROP TABLE bug21114_child; |
|
323 |
DROP TABLE geomcollfromwkb; |
|
324 |
drop table if exists geometrycollectionfromtext; |
|
325 |
drop table if exists bug21114_child; |
|
326 |
DROP TABLE bug21114_child; |
|
327 |
DROP TABLE geometrycollectionfromtext; |
|
328 |
drop table if exists geometrycollectionfromwkb; |
|
329 |
drop table if exists bug21114_child; |
|
330 |
DROP TABLE bug21114_child; |
|
331 |
DROP TABLE geometrycollectionfromwkb; |
|
332 |
drop table if exists geometryfromtext; |
|
333 |
drop table if exists bug21114_child; |
|
334 |
DROP TABLE bug21114_child; |
|
335 |
DROP TABLE geometryfromtext; |
|
336 |
drop table if exists geometryfromwkb; |
|
337 |
drop table if exists bug21114_child; |
|
338 |
DROP TABLE bug21114_child; |
|
339 |
DROP TABLE geometryfromwkb; |
|
340 |
drop table if exists geometryn; |
|
341 |
drop table if exists bug21114_child; |
|
342 |
DROP TABLE bug21114_child; |
|
343 |
DROP TABLE geometryn; |
|
344 |
drop table if exists geometrytype; |
|
345 |
drop table if exists bug21114_child; |
|
346 |
DROP TABLE bug21114_child; |
|
347 |
DROP TABLE geometrytype; |
|
348 |
drop table if exists geomfromtext; |
|
349 |
drop table if exists bug21114_child; |
|
350 |
DROP TABLE bug21114_child; |
|
351 |
DROP TABLE geomfromtext; |
|
352 |
drop table if exists geomfromwkb; |
|
353 |
drop table if exists bug21114_child; |
|
354 |
DROP TABLE bug21114_child; |
|
355 |
DROP TABLE geomfromwkb; |
|
356 |
drop table if exists get_lock; |
|
357 |
drop table if exists bug21114_child; |
|
358 |
DROP TABLE bug21114_child; |
|
359 |
DROP TABLE get_lock; |
|
360 |
drop table if exists glength; |
|
361 |
drop table if exists bug21114_child; |
|
362 |
DROP TABLE bug21114_child; |
|
363 |
DROP TABLE glength; |
|
364 |
drop table if exists greatest; |
|
365 |
drop table if exists bug21114_child; |
|
366 |
DROP TABLE bug21114_child; |
|
367 |
DROP TABLE greatest; |
|
368 |
drop table if exists hex; |
|
369 |
drop table if exists bug21114_child; |
|
370 |
DROP TABLE bug21114_child; |
|
371 |
DROP TABLE hex; |
|
372 |
drop table if exists ifnull; |
|
373 |
drop table if exists bug21114_child; |
|
374 |
DROP TABLE bug21114_child; |
|
375 |
DROP TABLE ifnull; |
|
376 |
drop table if exists inet_aton; |
|
377 |
drop table if exists bug21114_child; |
|
378 |
DROP TABLE bug21114_child; |
|
379 |
DROP TABLE inet_aton; |
|
380 |
drop table if exists inet_ntoa; |
|
381 |
drop table if exists bug21114_child; |
|
382 |
DROP TABLE bug21114_child; |
|
383 |
DROP TABLE inet_ntoa; |
|
384 |
drop table if exists instr; |
|
385 |
drop table if exists bug21114_child; |
|
386 |
DROP TABLE bug21114_child; |
|
387 |
DROP TABLE instr; |
|
388 |
drop table if exists interiorringn; |
|
389 |
drop table if exists bug21114_child; |
|
390 |
DROP TABLE bug21114_child; |
|
391 |
DROP TABLE interiorringn; |
|
392 |
drop table if exists intersects; |
|
393 |
drop table if exists bug21114_child; |
|
394 |
DROP TABLE bug21114_child; |
|
395 |
DROP TABLE intersects; |
|
396 |
drop table if exists isclosed; |
|
397 |
drop table if exists bug21114_child; |
|
398 |
DROP TABLE bug21114_child; |
|
399 |
DROP TABLE isclosed; |
|
400 |
drop table if exists isempty; |
|
401 |
drop table if exists bug21114_child; |
|
402 |
DROP TABLE bug21114_child; |
|
403 |
DROP TABLE isempty; |
|
404 |
drop table if exists isnull; |
|
405 |
drop table if exists bug21114_child; |
|
406 |
DROP TABLE bug21114_child; |
|
407 |
DROP TABLE isnull; |
|
408 |
drop table if exists issimple; |
|
409 |
drop table if exists bug21114_child; |
|
410 |
DROP TABLE bug21114_child; |
|
411 |
DROP TABLE issimple; |
|
412 |
drop table if exists is_free_lock; |
|
413 |
drop table if exists bug21114_child; |
|
414 |
DROP TABLE bug21114_child; |
|
415 |
DROP TABLE is_free_lock; |
|
416 |
drop table if exists is_used_lock; |
|
417 |
drop table if exists bug21114_child; |
|
418 |
DROP TABLE bug21114_child; |
|
419 |
DROP TABLE is_used_lock; |
|
420 |
drop table if exists last_day; |
|
421 |
drop table if exists bug21114_child; |
|
422 |
DROP TABLE bug21114_child; |
|
423 |
DROP TABLE last_day; |
|
424 |
drop table if exists last_insert_id; |
|
425 |
drop table if exists bug21114_child; |
|
426 |
DROP TABLE bug21114_child; |
|
427 |
DROP TABLE last_insert_id; |
|
428 |
drop table if exists lcase; |
|
429 |
drop table if exists bug21114_child; |
|
430 |
DROP TABLE bug21114_child; |
|
431 |
DROP TABLE lcase; |
|
432 |
drop table if exists least; |
|
433 |
drop table if exists bug21114_child; |
|
434 |
DROP TABLE bug21114_child; |
|
435 |
DROP TABLE least; |
|
436 |
drop table if exists length; |
|
437 |
drop table if exists bug21114_child; |
|
438 |
DROP TABLE bug21114_child; |
|
439 |
DROP TABLE length; |
|
440 |
drop table if exists linefromtext; |
|
441 |
drop table if exists bug21114_child; |
|
442 |
DROP TABLE bug21114_child; |
|
443 |
DROP TABLE linefromtext; |
|
444 |
drop table if exists linefromwkb; |
|
445 |
drop table if exists bug21114_child; |
|
446 |
DROP TABLE bug21114_child; |
|
447 |
DROP TABLE linefromwkb; |
|
448 |
drop table if exists linestringfromtext; |
|
449 |
drop table if exists bug21114_child; |
|
450 |
DROP TABLE bug21114_child; |
|
451 |
DROP TABLE linestringfromtext; |
|
452 |
drop table if exists linestringfromwkb; |
|
453 |
drop table if exists bug21114_child; |
|
454 |
DROP TABLE bug21114_child; |
|
455 |
DROP TABLE linestringfromwkb; |
|
456 |
drop table if exists ln; |
|
457 |
drop table if exists bug21114_child; |
|
458 |
DROP TABLE bug21114_child; |
|
459 |
DROP TABLE ln; |
|
460 |
drop table if exists load_file; |
|
461 |
drop table if exists bug21114_child; |
|
462 |
DROP TABLE bug21114_child; |
|
463 |
DROP TABLE load_file; |
|
464 |
drop table if exists locate; |
|
465 |
drop table if exists bug21114_child; |
|
466 |
DROP TABLE bug21114_child; |
|
467 |
DROP TABLE locate; |
|
468 |
drop table if exists log; |
|
469 |
drop table if exists bug21114_child; |
|
470 |
DROP TABLE bug21114_child; |
|
471 |
DROP TABLE log; |
|
472 |
drop table if exists log10; |
|
473 |
drop table if exists bug21114_child; |
|
474 |
DROP TABLE bug21114_child; |
|
475 |
DROP TABLE log10; |
|
476 |
drop table if exists log2; |
|
477 |
drop table if exists bug21114_child; |
|
478 |
DROP TABLE bug21114_child; |
|
479 |
DROP TABLE log2; |
|
480 |
drop table if exists lower; |
|
481 |
drop table if exists bug21114_child; |
|
482 |
DROP TABLE bug21114_child; |
|
483 |
DROP TABLE lower; |
|
484 |
drop table if exists lpad; |
|
485 |
drop table if exists bug21114_child; |
|
486 |
DROP TABLE bug21114_child; |
|
487 |
DROP TABLE lpad; |
|
488 |
drop table if exists ltrim; |
|
489 |
drop table if exists bug21114_child; |
|
490 |
DROP TABLE bug21114_child; |
|
491 |
DROP TABLE ltrim; |
|
492 |
drop table if exists makedate; |
|
493 |
drop table if exists bug21114_child; |
|
494 |
DROP TABLE bug21114_child; |
|
495 |
DROP TABLE makedate; |
|
496 |
drop table if exists maketime; |
|
497 |
drop table if exists bug21114_child; |
|
498 |
DROP TABLE bug21114_child; |
|
499 |
DROP TABLE maketime; |
|
500 |
drop table if exists make_set; |
|
501 |
drop table if exists bug21114_child; |
|
502 |
DROP TABLE bug21114_child; |
|
503 |
DROP TABLE make_set; |
|
504 |
drop table if exists master_pos_wait; |
|
505 |
drop table if exists bug21114_child; |
|
506 |
DROP TABLE bug21114_child; |
|
507 |
DROP TABLE master_pos_wait; |
|
508 |
drop table if exists mbrcontains; |
|
509 |
drop table if exists bug21114_child; |
|
510 |
DROP TABLE bug21114_child; |
|
511 |
DROP TABLE mbrcontains; |
|
512 |
drop table if exists mbrdisjoint; |
|
513 |
drop table if exists bug21114_child; |
|
514 |
DROP TABLE bug21114_child; |
|
515 |
DROP TABLE mbrdisjoint; |
|
516 |
drop table if exists mbrequal; |
|
517 |
drop table if exists bug21114_child; |
|
518 |
DROP TABLE bug21114_child; |
|
519 |
DROP TABLE mbrequal; |
|
520 |
drop table if exists mbrintersects; |
|
521 |
drop table if exists bug21114_child; |
|
522 |
DROP TABLE bug21114_child; |
|
523 |
DROP TABLE mbrintersects; |
|
524 |
drop table if exists mbroverlaps; |
|
525 |
drop table if exists bug21114_child; |
|
526 |
DROP TABLE bug21114_child; |
|
527 |
DROP TABLE mbroverlaps; |
|
528 |
drop table if exists mbrtouches; |
|
529 |
drop table if exists bug21114_child; |
|
530 |
DROP TABLE bug21114_child; |
|
531 |
DROP TABLE mbrtouches; |
|
532 |
drop table if exists mbrwithin; |
|
533 |
drop table if exists bug21114_child; |
|
534 |
DROP TABLE bug21114_child; |
|
535 |
DROP TABLE mbrwithin; |
|
536 |
drop table if exists md5; |
|
537 |
drop table if exists bug21114_child; |
|
538 |
DROP TABLE bug21114_child; |
|
539 |
DROP TABLE md5; |
|
540 |
drop table if exists mlinefromtext; |
|
541 |
drop table if exists bug21114_child; |
|
542 |
DROP TABLE bug21114_child; |
|
543 |
DROP TABLE mlinefromtext; |
|
544 |
drop table if exists mlinefromwkb; |
|
545 |
drop table if exists bug21114_child; |
|
546 |
DROP TABLE bug21114_child; |
|
547 |
DROP TABLE mlinefromwkb; |
|
548 |
drop table if exists monthname; |
|
549 |
drop table if exists bug21114_child; |
|
550 |
DROP TABLE bug21114_child; |
|
551 |
DROP TABLE monthname; |
|
552 |
drop table if exists mpointfromtext; |
|
553 |
drop table if exists bug21114_child; |
|
554 |
DROP TABLE bug21114_child; |
|
555 |
DROP TABLE mpointfromtext; |
|
556 |
drop table if exists mpointfromwkb; |
|
557 |
drop table if exists bug21114_child; |
|
558 |
DROP TABLE bug21114_child; |
|
559 |
DROP TABLE mpointfromwkb; |
|
560 |
drop table if exists mpolyfromtext; |
|
561 |
drop table if exists bug21114_child; |
|
562 |
DROP TABLE bug21114_child; |
|
563 |
DROP TABLE mpolyfromtext; |
|
564 |
drop table if exists mpolyfromwkb; |
|
565 |
drop table if exists bug21114_child; |
|
566 |
DROP TABLE bug21114_child; |
|
567 |
DROP TABLE mpolyfromwkb; |
|
568 |
drop table if exists multilinestringfromtext; |
|
569 |
drop table if exists bug21114_child; |
|
570 |
DROP TABLE bug21114_child; |
|
571 |
DROP TABLE multilinestringfromtext; |
|
572 |
drop table if exists multilinestringfromwkb; |
|
573 |
drop table if exists bug21114_child; |
|
574 |
DROP TABLE bug21114_child; |
|
575 |
DROP TABLE multilinestringfromwkb; |
|
576 |
drop table if exists multipointfromtext; |
|
577 |
drop table if exists bug21114_child; |
|
578 |
DROP TABLE bug21114_child; |
|
579 |
DROP TABLE multipointfromtext; |
|
580 |
drop table if exists multipointfromwkb; |
|
581 |
drop table if exists bug21114_child; |
|
582 |
DROP TABLE bug21114_child; |
|
583 |
DROP TABLE multipointfromwkb; |
|
584 |
drop table if exists multipolygonfromtext; |
|
585 |
drop table if exists bug21114_child; |
|
586 |
DROP TABLE bug21114_child; |
|
587 |
DROP TABLE multipolygonfromtext; |
|
588 |
drop table if exists multipolygonfromwkb; |
|
589 |
drop table if exists bug21114_child; |
|
590 |
DROP TABLE bug21114_child; |
|
591 |
DROP TABLE multipolygonfromwkb; |
|
592 |
drop table if exists name_const; |
|
593 |
drop table if exists bug21114_child; |
|
594 |
DROP TABLE bug21114_child; |
|
595 |
DROP TABLE name_const; |
|
596 |
drop table if exists nullif; |
|
597 |
drop table if exists bug21114_child; |
|
598 |
DROP TABLE bug21114_child; |
|
599 |
DROP TABLE nullif; |
|
600 |
drop table if exists numgeometries; |
|
601 |
drop table if exists bug21114_child; |
|
602 |
DROP TABLE bug21114_child; |
|
603 |
DROP TABLE numgeometries; |
|
604 |
drop table if exists numinteriorrings; |
|
605 |
drop table if exists bug21114_child; |
|
606 |
DROP TABLE bug21114_child; |
|
607 |
DROP TABLE numinteriorrings; |
|
608 |
drop table if exists numpoints; |
|
609 |
drop table if exists bug21114_child; |
|
610 |
DROP TABLE bug21114_child; |
|
611 |
DROP TABLE numpoints; |
|
612 |
drop table if exists oct; |
|
613 |
drop table if exists bug21114_child; |
|
614 |
DROP TABLE bug21114_child; |
|
615 |
DROP TABLE oct; |
|
616 |
drop table if exists octet_length; |
|
617 |
drop table if exists bug21114_child; |
|
618 |
DROP TABLE bug21114_child; |
|
619 |
DROP TABLE octet_length; |
|
620 |
drop table if exists ord; |
|
621 |
drop table if exists bug21114_child; |
|
622 |
DROP TABLE bug21114_child; |
|
623 |
DROP TABLE ord; |
|
624 |
drop table if exists overlaps; |
|
625 |
drop table if exists bug21114_child; |
|
626 |
DROP TABLE bug21114_child; |
|
627 |
DROP TABLE overlaps; |
|
628 |
drop table if exists period_add; |
|
629 |
drop table if exists bug21114_child; |
|
630 |
DROP TABLE bug21114_child; |
|
631 |
DROP TABLE period_add; |
|
632 |
drop table if exists period_diff; |
|
633 |
drop table if exists bug21114_child; |
|
634 |
DROP TABLE bug21114_child; |
|
635 |
DROP TABLE period_diff; |
|
636 |
drop table if exists pi; |
|
637 |
drop table if exists bug21114_child; |
|
638 |
DROP TABLE bug21114_child; |
|
639 |
DROP TABLE pi; |
|
640 |
drop table if exists pointfromtext; |
|
641 |
drop table if exists bug21114_child; |
|
642 |
DROP TABLE bug21114_child; |
|
643 |
DROP TABLE pointfromtext; |
|
644 |
drop table if exists pointfromwkb; |
|
645 |
drop table if exists bug21114_child; |
|
646 |
DROP TABLE bug21114_child; |
|
647 |
DROP TABLE pointfromwkb; |
|
648 |
drop table if exists pointn; |
|
649 |
drop table if exists bug21114_child; |
|
650 |
DROP TABLE bug21114_child; |
|
651 |
DROP TABLE pointn; |
|
652 |
drop table if exists polyfromtext; |
|
653 |
drop table if exists bug21114_child; |
|
654 |
DROP TABLE bug21114_child; |
|
655 |
DROP TABLE polyfromtext; |
|
656 |
drop table if exists polyfromwkb; |
|
657 |
drop table if exists bug21114_child; |
|
658 |
DROP TABLE bug21114_child; |
|
659 |
DROP TABLE polyfromwkb; |
|
660 |
drop table if exists polygonfromtext; |
|
661 |
drop table if exists bug21114_child; |
|
662 |
DROP TABLE bug21114_child; |
|
663 |
DROP TABLE polygonfromtext; |
|
664 |
drop table if exists polygonfromwkb; |
|
665 |
drop table if exists bug21114_child; |
|
666 |
DROP TABLE bug21114_child; |
|
667 |
DROP TABLE polygonfromwkb; |
|
668 |
drop table if exists pow; |
|
669 |
drop table if exists bug21114_child; |
|
670 |
DROP TABLE bug21114_child; |
|
671 |
DROP TABLE pow; |
|
672 |
drop table if exists power; |
|
673 |
drop table if exists bug21114_child; |
|
674 |
DROP TABLE bug21114_child; |
|
675 |
DROP TABLE power; |
|
676 |
drop table if exists quote; |
|
677 |
drop table if exists bug21114_child; |
|
678 |
DROP TABLE bug21114_child; |
|
679 |
DROP TABLE quote; |
|
680 |
drop table if exists radians; |
|
681 |
drop table if exists bug21114_child; |
|
682 |
DROP TABLE bug21114_child; |
|
683 |
DROP TABLE radians; |
|
684 |
drop table if exists rand; |
|
685 |
drop table if exists bug21114_child; |
|
686 |
DROP TABLE bug21114_child; |
|
687 |
DROP TABLE rand; |
|
688 |
drop table if exists release_lock; |
|
689 |
drop table if exists bug21114_child; |
|
690 |
DROP TABLE bug21114_child; |
|
691 |
DROP TABLE release_lock; |
|
692 |
drop table if exists reverse; |
|
693 |
drop table if exists bug21114_child; |
|
694 |
DROP TABLE bug21114_child; |
|
695 |
DROP TABLE reverse; |
|
696 |
drop table if exists round; |
|
697 |
drop table if exists bug21114_child; |
|
698 |
DROP TABLE bug21114_child; |
|
699 |
DROP TABLE round; |
|
700 |
drop table if exists row_count; |
|
701 |
drop table if exists bug21114_child; |
|
702 |
DROP TABLE bug21114_child; |
|
703 |
DROP TABLE row_count; |
|
704 |
drop table if exists rpad; |
|
705 |
drop table if exists bug21114_child; |
|
706 |
DROP TABLE bug21114_child; |
|
707 |
DROP TABLE rpad; |
|
708 |
drop table if exists rtrim; |
|
709 |
drop table if exists bug21114_child; |
|
710 |
DROP TABLE bug21114_child; |
|
711 |
DROP TABLE rtrim; |
|
712 |
drop table if exists sec_to_time; |
|
713 |
drop table if exists bug21114_child; |
|
714 |
DROP TABLE bug21114_child; |
|
715 |
DROP TABLE sec_to_time; |
|
716 |
drop table if exists session_user; |
|
717 |
drop table if exists bug21114_child; |
|
718 |
DROP TABLE bug21114_child; |
|
719 |
DROP TABLE session_user; |
|
720 |
drop table if exists sha; |
|
721 |
drop table if exists bug21114_child; |
|
722 |
DROP TABLE bug21114_child; |
|
723 |
DROP TABLE sha; |
|
724 |
drop table if exists sha1; |
|
725 |
drop table if exists bug21114_child; |
|
726 |
DROP TABLE bug21114_child; |
|
727 |
DROP TABLE sha1; |
|
728 |
drop table if exists sign; |
|
729 |
drop table if exists bug21114_child; |
|
730 |
DROP TABLE bug21114_child; |
|
731 |
DROP TABLE sign; |
|
732 |
drop table if exists sin; |
|
733 |
drop table if exists bug21114_child; |
|
734 |
DROP TABLE bug21114_child; |
|
735 |
DROP TABLE sin; |
|
736 |
drop table if exists sleep; |
|
737 |
drop table if exists bug21114_child; |
|
738 |
DROP TABLE bug21114_child; |
|
739 |
DROP TABLE sleep; |
|
740 |
drop table if exists soundex; |
|
741 |
drop table if exists bug21114_child; |
|
742 |
DROP TABLE bug21114_child; |
|
743 |
DROP TABLE soundex; |
|
744 |
drop table if exists space; |
|
745 |
drop table if exists bug21114_child; |
|
746 |
DROP TABLE bug21114_child; |
|
747 |
DROP TABLE space; |
|
748 |
drop table if exists sqrt; |
|
749 |
drop table if exists bug21114_child; |
|
750 |
DROP TABLE bug21114_child; |
|
751 |
DROP TABLE sqrt; |
|
752 |
drop table if exists srid; |
|
753 |
drop table if exists bug21114_child; |
|
754 |
DROP TABLE bug21114_child; |
|
755 |
DROP TABLE srid; |
|
756 |
drop table if exists startpoint; |
|
757 |
drop table if exists bug21114_child; |
|
758 |
DROP TABLE bug21114_child; |
|
759 |
DROP TABLE startpoint; |
|
760 |
drop table if exists strcmp; |
|
761 |
drop table if exists bug21114_child; |
|
762 |
DROP TABLE bug21114_child; |
|
763 |
DROP TABLE strcmp; |
|
764 |
drop table if exists str_to_date; |
|
765 |
drop table if exists bug21114_child; |
|
766 |
DROP TABLE bug21114_child; |
|
767 |
DROP TABLE str_to_date; |
|
768 |
drop table if exists subdate; |
|
769 |
drop table if exists bug21114_child; |
|
770 |
DROP TABLE bug21114_child; |
|
771 |
DROP TABLE subdate; |
|
772 |
drop table if exists substring_index; |
|
773 |
drop table if exists bug21114_child; |
|
774 |
DROP TABLE bug21114_child; |
|
775 |
DROP TABLE substring_index; |
|
776 |
drop table if exists subtime; |
|
777 |
drop table if exists bug21114_child; |
|
778 |
DROP TABLE bug21114_child; |
|
779 |
DROP TABLE subtime; |
|
780 |
drop table if exists system_user; |
|
781 |
drop table if exists bug21114_child; |
|
782 |
DROP TABLE bug21114_child; |
|
783 |
DROP TABLE system_user; |
|
784 |
drop table if exists tan; |
|
785 |
drop table if exists bug21114_child; |
|
786 |
DROP TABLE bug21114_child; |
|
787 |
DROP TABLE tan; |
|
788 |
drop table if exists timediff; |
|
789 |
drop table if exists bug21114_child; |
|
790 |
DROP TABLE bug21114_child; |
|
791 |
DROP TABLE timediff; |
|
792 |
drop table if exists time_format; |
|
793 |
drop table if exists bug21114_child; |
|
794 |
DROP TABLE bug21114_child; |
|
795 |
DROP TABLE time_format; |
|
796 |
drop table if exists time_to_sec; |
|
797 |
drop table if exists bug21114_child; |
|
798 |
DROP TABLE bug21114_child; |
|
799 |
DROP TABLE time_to_sec; |
|
800 |
drop table if exists touches; |
|
801 |
drop table if exists bug21114_child; |
|
802 |
DROP TABLE bug21114_child; |
|
803 |
DROP TABLE touches; |
|
804 |
drop table if exists to_days; |
|
805 |
drop table if exists bug21114_child; |
|
806 |
DROP TABLE bug21114_child; |
|
807 |
DROP TABLE to_days; |
|
808 |
drop table if exists ucase; |
|
809 |
drop table if exists bug21114_child; |
|
810 |
DROP TABLE bug21114_child; |
|
811 |
DROP TABLE ucase; |
|
812 |
drop table if exists uncompress; |
|
813 |
drop table if exists bug21114_child; |
|
814 |
DROP TABLE bug21114_child; |
|
815 |
DROP TABLE uncompress; |
|
816 |
drop table if exists uncompressed_length; |
|
817 |
drop table if exists bug21114_child; |
|
818 |
DROP TABLE bug21114_child; |
|
819 |
DROP TABLE uncompressed_length; |
|
820 |
drop table if exists unhex; |
|
821 |
drop table if exists bug21114_child; |
|
822 |
DROP TABLE bug21114_child; |
|
823 |
DROP TABLE unhex; |
|
824 |
drop table if exists unix_timestamp; |
|
825 |
drop table if exists bug21114_child; |
|
826 |
DROP TABLE bug21114_child; |
|
827 |
DROP TABLE unix_timestamp; |
|
828 |
drop table if exists updatexml; |
|
829 |
drop table if exists bug21114_child; |
|
830 |
DROP TABLE bug21114_child; |
|
831 |
DROP TABLE updatexml; |
|
832 |
drop table if exists upper; |
|
833 |
drop table if exists bug21114_child; |
|
834 |
DROP TABLE bug21114_child; |
|
835 |
DROP TABLE upper; |
|
836 |
drop table if exists uuid; |
|
837 |
drop table if exists bug21114_child; |
|
838 |
DROP TABLE bug21114_child; |
|
839 |
DROP TABLE uuid; |
|
840 |
drop table if exists version; |
|
841 |
drop table if exists bug21114_child; |
|
842 |
DROP TABLE bug21114_child; |
|
843 |
DROP TABLE version; |
|
844 |
drop table if exists weekday; |
|
845 |
drop table if exists bug21114_child; |
|
846 |
DROP TABLE bug21114_child; |
|
847 |
DROP TABLE weekday; |
|
848 |
drop table if exists weekofyear; |
|
849 |
drop table if exists bug21114_child; |
|
850 |
DROP TABLE bug21114_child; |
|
851 |
DROP TABLE weekofyear; |
|
852 |
drop table if exists within; |
|
853 |
drop table if exists bug21114_child; |
|
854 |
DROP TABLE bug21114_child; |
|
855 |
DROP TABLE within; |
|
856 |
drop table if exists x; |
|
857 |
drop table if exists bug21114_child; |
|
858 |
DROP TABLE bug21114_child; |
|
859 |
DROP TABLE x; |
|
860 |
drop table if exists y; |
|
861 |
drop table if exists bug21114_child; |
|
862 |
DROP TABLE bug21114_child; |
|
863 |
DROP TABLE y; |
|
864 |
drop table if exists yearweek; |
|
865 |
drop table if exists bug21114_child; |
|
866 |
DROP TABLE bug21114_child; |
|
867 |
DROP TABLE yearweek; |