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