1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1(c1 BIT NOT NULL); 3SHOW TABLES; 4Tables_in_test 5t1 6SHOW CREATE TABLE t1; 7Table Create Table 8t1 CREATE TABLE `t1` ( 9 `c1` bit(1) NOT NULL 10) ENGINE=ENGINE DEFAULT CHARSET=latin1 11ALTER TABLE t1 ADD KEY (c1); 12SHOW TABLES; 13Tables_in_test 14t1 15SHOW CREATE TABLE t1; 16Table Create Table 17t1 CREATE TABLE `t1` ( 18 `c1` bit(1) NOT NULL, 19 KEY `c1` (`c1`) 20) ENGINE=ENGINE DEFAULT CHARSET=latin1 21DROP TABLE t1; 22SHOW TABLES; 23Tables_in_test 24CREATE TABLE t1(c1 TINYINT NOT NULL); 25SHOW TABLES; 26Tables_in_test 27t1 28SHOW CREATE TABLE t1; 29Table Create Table 30t1 CREATE TABLE `t1` ( 31 `c1` tinyint(4) NOT NULL 32) ENGINE=ENGINE DEFAULT CHARSET=latin1 33ALTER TABLE t1 ADD KEY (c1); 34SHOW TABLES; 35Tables_in_test 36t1 37SHOW CREATE TABLE t1; 38Table Create Table 39t1 CREATE TABLE `t1` ( 40 `c1` tinyint(4) NOT NULL, 41 KEY `c1` (`c1`) 42) ENGINE=ENGINE DEFAULT CHARSET=latin1 43DROP TABLE t1; 44SHOW TABLES; 45Tables_in_test 46CREATE TABLE t1(c1 SMALLINT NOT NULL); 47SHOW TABLES; 48Tables_in_test 49t1 50SHOW CREATE TABLE t1; 51Table Create Table 52t1 CREATE TABLE `t1` ( 53 `c1` smallint(6) NOT NULL 54) ENGINE=ENGINE DEFAULT CHARSET=latin1 55ALTER TABLE t1 ADD KEY (c1); 56SHOW TABLES; 57Tables_in_test 58t1 59SHOW CREATE TABLE t1; 60Table Create Table 61t1 CREATE TABLE `t1` ( 62 `c1` smallint(6) NOT NULL, 63 KEY `c1` (`c1`) 64) ENGINE=ENGINE DEFAULT CHARSET=latin1 65DROP TABLE t1; 66SHOW TABLES; 67Tables_in_test 68CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 69SHOW TABLES; 70Tables_in_test 71t1 72SHOW CREATE TABLE t1; 73Table Create Table 74t1 CREATE TABLE `t1` ( 75 `c1` mediumint(9) NOT NULL 76) ENGINE=ENGINE DEFAULT CHARSET=latin1 77ALTER TABLE t1 ADD KEY (c1); 78SHOW TABLES; 79Tables_in_test 80t1 81SHOW CREATE TABLE t1; 82Table Create Table 83t1 CREATE TABLE `t1` ( 84 `c1` mediumint(9) NOT NULL, 85 KEY `c1` (`c1`) 86) ENGINE=ENGINE DEFAULT CHARSET=latin1 87DROP TABLE t1; 88SHOW TABLES; 89Tables_in_test 90CREATE TABLE t1(c1 INT NOT NULL); 91SHOW TABLES; 92Tables_in_test 93t1 94SHOW CREATE TABLE t1; 95Table Create Table 96t1 CREATE TABLE `t1` ( 97 `c1` int(11) NOT NULL 98) ENGINE=ENGINE DEFAULT CHARSET=latin1 99ALTER TABLE t1 ADD KEY (c1); 100SHOW TABLES; 101Tables_in_test 102t1 103SHOW CREATE TABLE t1; 104Table Create Table 105t1 CREATE TABLE `t1` ( 106 `c1` int(11) NOT NULL, 107 KEY `c1` (`c1`) 108) ENGINE=ENGINE DEFAULT CHARSET=latin1 109DROP TABLE t1; 110SHOW TABLES; 111Tables_in_test 112CREATE TABLE t1(c1 INTEGER NOT NULL); 113SHOW TABLES; 114Tables_in_test 115t1 116SHOW CREATE TABLE t1; 117Table Create Table 118t1 CREATE TABLE `t1` ( 119 `c1` int(11) NOT NULL 120) ENGINE=ENGINE DEFAULT CHARSET=latin1 121ALTER TABLE t1 ADD KEY (c1); 122SHOW TABLES; 123Tables_in_test 124t1 125SHOW CREATE TABLE t1; 126Table Create Table 127t1 CREATE TABLE `t1` ( 128 `c1` int(11) NOT NULL, 129 KEY `c1` (`c1`) 130) ENGINE=ENGINE DEFAULT CHARSET=latin1 131DROP TABLE t1; 132SHOW TABLES; 133Tables_in_test 134CREATE TABLE t1(c1 BIGINT NOT NULL); 135SHOW TABLES; 136Tables_in_test 137t1 138SHOW CREATE TABLE t1; 139Table Create Table 140t1 CREATE TABLE `t1` ( 141 `c1` bigint(20) NOT NULL 142) ENGINE=ENGINE DEFAULT CHARSET=latin1 143ALTER TABLE t1 ADD KEY (c1); 144SHOW TABLES; 145Tables_in_test 146t1 147SHOW CREATE TABLE t1; 148Table Create Table 149t1 CREATE TABLE `t1` ( 150 `c1` bigint(20) NOT NULL, 151 KEY `c1` (`c1`) 152) ENGINE=ENGINE DEFAULT CHARSET=latin1 153DROP TABLE t1; 154SHOW TABLES; 155Tables_in_test 156CREATE TABLE t1(c1 REAL NOT NULL); 157SHOW TABLES; 158Tables_in_test 159t1 160SHOW CREATE TABLE t1; 161Table Create Table 162t1 CREATE TABLE `t1` ( 163 `c1` double NOT NULL 164) ENGINE=ENGINE DEFAULT CHARSET=latin1 165ALTER TABLE t1 ADD KEY (c1); 166SHOW TABLES; 167Tables_in_test 168t1 169SHOW CREATE TABLE t1; 170Table Create Table 171t1 CREATE TABLE `t1` ( 172 `c1` double NOT NULL, 173 KEY `c1` (`c1`) 174) ENGINE=ENGINE DEFAULT CHARSET=latin1 175DROP TABLE t1; 176SHOW TABLES; 177Tables_in_test 178CREATE TABLE t1(c1 DOUBLE NOT NULL); 179SHOW TABLES; 180Tables_in_test 181t1 182SHOW CREATE TABLE t1; 183Table Create Table 184t1 CREATE TABLE `t1` ( 185 `c1` double NOT NULL 186) ENGINE=ENGINE DEFAULT CHARSET=latin1 187ALTER TABLE t1 ADD KEY (c1); 188SHOW TABLES; 189Tables_in_test 190t1 191SHOW CREATE TABLE t1; 192Table Create Table 193t1 CREATE TABLE `t1` ( 194 `c1` double NOT NULL, 195 KEY `c1` (`c1`) 196) ENGINE=ENGINE DEFAULT CHARSET=latin1 197DROP TABLE t1; 198SHOW TABLES; 199Tables_in_test 200CREATE TABLE t1(c1 FLOAT NOT NULL); 201SHOW TABLES; 202Tables_in_test 203t1 204SHOW CREATE TABLE t1; 205Table Create Table 206t1 CREATE TABLE `t1` ( 207 `c1` float NOT NULL 208) ENGINE=ENGINE DEFAULT CHARSET=latin1 209ALTER TABLE t1 ADD KEY (c1); 210SHOW TABLES; 211Tables_in_test 212t1 213SHOW CREATE TABLE t1; 214Table Create Table 215t1 CREATE TABLE `t1` ( 216 `c1` float NOT NULL, 217 KEY `c1` (`c1`) 218) ENGINE=ENGINE DEFAULT CHARSET=latin1 219DROP TABLE t1; 220SHOW TABLES; 221Tables_in_test 222CREATE TABLE t1(c1 DECIMAL NOT NULL); 223SHOW TABLES; 224Tables_in_test 225t1 226SHOW CREATE TABLE t1; 227Table Create Table 228t1 CREATE TABLE `t1` ( 229 `c1` decimal(10,0) NOT NULL 230) ENGINE=ENGINE DEFAULT CHARSET=latin1 231ALTER TABLE t1 ADD KEY (c1); 232SHOW TABLES; 233Tables_in_test 234t1 235SHOW CREATE TABLE t1; 236Table Create Table 237t1 CREATE TABLE `t1` ( 238 `c1` decimal(10,0) NOT NULL, 239 KEY `c1` (`c1`) 240) ENGINE=ENGINE DEFAULT CHARSET=latin1 241DROP TABLE t1; 242SHOW TABLES; 243Tables_in_test 244CREATE TABLE t1(c1 NUMERIC NOT NULL); 245SHOW TABLES; 246Tables_in_test 247t1 248SHOW CREATE TABLE t1; 249Table Create Table 250t1 CREATE TABLE `t1` ( 251 `c1` decimal(10,0) NOT NULL 252) ENGINE=ENGINE DEFAULT CHARSET=latin1 253ALTER TABLE t1 ADD KEY (c1); 254SHOW TABLES; 255Tables_in_test 256t1 257SHOW CREATE TABLE t1; 258Table Create Table 259t1 CREATE TABLE `t1` ( 260 `c1` decimal(10,0) NOT NULL, 261 KEY `c1` (`c1`) 262) ENGINE=ENGINE DEFAULT CHARSET=latin1 263DROP TABLE t1; 264SHOW TABLES; 265Tables_in_test 266CREATE TABLE t1(c1 DATE NOT NULL); 267SHOW TABLES; 268Tables_in_test 269t1 270SHOW CREATE TABLE t1; 271Table Create Table 272t1 CREATE TABLE `t1` ( 273 `c1` date NOT NULL 274) ENGINE=ENGINE DEFAULT CHARSET=latin1 275ALTER TABLE t1 ADD KEY (c1); 276SHOW TABLES; 277Tables_in_test 278t1 279SHOW CREATE TABLE t1; 280Table Create Table 281t1 CREATE TABLE `t1` ( 282 `c1` date NOT NULL, 283 KEY `c1` (`c1`) 284) ENGINE=ENGINE DEFAULT CHARSET=latin1 285DROP TABLE t1; 286SHOW TABLES; 287Tables_in_test 288CREATE TABLE t1(c1 TIME NOT NULL); 289SHOW TABLES; 290Tables_in_test 291t1 292SHOW CREATE TABLE t1; 293Table Create Table 294t1 CREATE TABLE `t1` ( 295 `c1` time NOT NULL 296) ENGINE=ENGINE DEFAULT CHARSET=latin1 297ALTER TABLE t1 ADD KEY (c1); 298SHOW TABLES; 299Tables_in_test 300t1 301SHOW CREATE TABLE t1; 302Table Create Table 303t1 CREATE TABLE `t1` ( 304 `c1` time NOT NULL, 305 KEY `c1` (`c1`) 306) ENGINE=ENGINE DEFAULT CHARSET=latin1 307DROP TABLE t1; 308SHOW TABLES; 309Tables_in_test 310CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 311SHOW TABLES; 312Tables_in_test 313t1 314SHOW CREATE TABLE t1; 315Table Create Table 316t1 CREATE TABLE `t1` ( 317 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 318) ENGINE=ENGINE DEFAULT CHARSET=latin1 319ALTER TABLE t1 ADD KEY (c1); 320SHOW TABLES; 321Tables_in_test 322t1 323SHOW CREATE TABLE t1; 324Table Create Table 325t1 CREATE TABLE `t1` ( 326 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 327 KEY `c1` (`c1`) 328) ENGINE=ENGINE DEFAULT CHARSET=latin1 329DROP TABLE t1; 330SHOW TABLES; 331Tables_in_test 332CREATE TABLE t1(c1 YEAR NOT NULL); 333SHOW TABLES; 334Tables_in_test 335t1 336SHOW CREATE TABLE t1; 337Table Create Table 338t1 CREATE TABLE `t1` ( 339 `c1` year(4) NOT NULL 340) ENGINE=ENGINE DEFAULT CHARSET=latin1 341ALTER TABLE t1 ADD KEY (c1); 342SHOW TABLES; 343Tables_in_test 344t1 345SHOW CREATE TABLE t1; 346Table Create Table 347t1 CREATE TABLE `t1` ( 348 `c1` year(4) NOT NULL, 349 KEY `c1` (`c1`) 350) ENGINE=ENGINE DEFAULT CHARSET=latin1 351DROP TABLE t1; 352SHOW TABLES; 353Tables_in_test 354CREATE TABLE t1(c1 BIT NOT NULL); 355SHOW TABLES; 356Tables_in_test 357t1 358SHOW CREATE TABLE t1; 359Table Create Table 360t1 CREATE TABLE `t1` ( 361 `c1` bit(1) NOT NULL 362) ENGINE=ENGINE DEFAULT CHARSET=latin1 363ALTER TABLE t1 ADD KEY USING BTREE (c1); 364SHOW TABLES; 365Tables_in_test 366t1 367SHOW CREATE TABLE t1; 368Table Create Table 369t1 CREATE TABLE `t1` ( 370 `c1` bit(1) NOT NULL, 371 KEY `c1` (`c1`) USING BTREE 372) ENGINE=ENGINE DEFAULT CHARSET=latin1 373DROP TABLE t1; 374SHOW TABLES; 375Tables_in_test 376CREATE TABLE t1(c1 TINYINT NOT NULL); 377SHOW TABLES; 378Tables_in_test 379t1 380SHOW CREATE TABLE t1; 381Table Create Table 382t1 CREATE TABLE `t1` ( 383 `c1` tinyint(4) NOT NULL 384) ENGINE=ENGINE DEFAULT CHARSET=latin1 385ALTER TABLE t1 ADD KEY USING BTREE (c1); 386SHOW TABLES; 387Tables_in_test 388t1 389SHOW CREATE TABLE t1; 390Table Create Table 391t1 CREATE TABLE `t1` ( 392 `c1` tinyint(4) NOT NULL, 393 KEY `c1` (`c1`) USING BTREE 394) ENGINE=ENGINE DEFAULT CHARSET=latin1 395DROP TABLE t1; 396SHOW TABLES; 397Tables_in_test 398CREATE TABLE t1(c1 SMALLINT NOT NULL); 399SHOW TABLES; 400Tables_in_test 401t1 402SHOW CREATE TABLE t1; 403Table Create Table 404t1 CREATE TABLE `t1` ( 405 `c1` smallint(6) NOT NULL 406) ENGINE=ENGINE DEFAULT CHARSET=latin1 407ALTER TABLE t1 ADD KEY USING BTREE (c1); 408SHOW TABLES; 409Tables_in_test 410t1 411SHOW CREATE TABLE t1; 412Table Create Table 413t1 CREATE TABLE `t1` ( 414 `c1` smallint(6) NOT NULL, 415 KEY `c1` (`c1`) USING BTREE 416) ENGINE=ENGINE DEFAULT CHARSET=latin1 417DROP TABLE t1; 418SHOW TABLES; 419Tables_in_test 420CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 421SHOW TABLES; 422Tables_in_test 423t1 424SHOW CREATE TABLE t1; 425Table Create Table 426t1 CREATE TABLE `t1` ( 427 `c1` mediumint(9) NOT NULL 428) ENGINE=ENGINE DEFAULT CHARSET=latin1 429ALTER TABLE t1 ADD KEY USING BTREE (c1); 430SHOW TABLES; 431Tables_in_test 432t1 433SHOW CREATE TABLE t1; 434Table Create Table 435t1 CREATE TABLE `t1` ( 436 `c1` mediumint(9) NOT NULL, 437 KEY `c1` (`c1`) USING BTREE 438) ENGINE=ENGINE DEFAULT CHARSET=latin1 439DROP TABLE t1; 440SHOW TABLES; 441Tables_in_test 442CREATE TABLE t1(c1 INT NOT NULL); 443SHOW TABLES; 444Tables_in_test 445t1 446SHOW CREATE TABLE t1; 447Table Create Table 448t1 CREATE TABLE `t1` ( 449 `c1` int(11) NOT NULL 450) ENGINE=ENGINE DEFAULT CHARSET=latin1 451ALTER TABLE t1 ADD KEY USING BTREE (c1); 452SHOW TABLES; 453Tables_in_test 454t1 455SHOW CREATE TABLE t1; 456Table Create Table 457t1 CREATE TABLE `t1` ( 458 `c1` int(11) NOT NULL, 459 KEY `c1` (`c1`) USING BTREE 460) ENGINE=ENGINE DEFAULT CHARSET=latin1 461DROP TABLE t1; 462SHOW TABLES; 463Tables_in_test 464CREATE TABLE t1(c1 INTEGER NOT NULL); 465SHOW TABLES; 466Tables_in_test 467t1 468SHOW CREATE TABLE t1; 469Table Create Table 470t1 CREATE TABLE `t1` ( 471 `c1` int(11) NOT NULL 472) ENGINE=ENGINE DEFAULT CHARSET=latin1 473ALTER TABLE t1 ADD KEY USING BTREE (c1); 474SHOW TABLES; 475Tables_in_test 476t1 477SHOW CREATE TABLE t1; 478Table Create Table 479t1 CREATE TABLE `t1` ( 480 `c1` int(11) NOT NULL, 481 KEY `c1` (`c1`) USING BTREE 482) ENGINE=ENGINE DEFAULT CHARSET=latin1 483DROP TABLE t1; 484SHOW TABLES; 485Tables_in_test 486CREATE TABLE t1(c1 BIGINT NOT NULL); 487SHOW TABLES; 488Tables_in_test 489t1 490SHOW CREATE TABLE t1; 491Table Create Table 492t1 CREATE TABLE `t1` ( 493 `c1` bigint(20) NOT NULL 494) ENGINE=ENGINE DEFAULT CHARSET=latin1 495ALTER TABLE t1 ADD KEY USING BTREE (c1); 496SHOW TABLES; 497Tables_in_test 498t1 499SHOW CREATE TABLE t1; 500Table Create Table 501t1 CREATE TABLE `t1` ( 502 `c1` bigint(20) NOT NULL, 503 KEY `c1` (`c1`) USING BTREE 504) ENGINE=ENGINE DEFAULT CHARSET=latin1 505DROP TABLE t1; 506SHOW TABLES; 507Tables_in_test 508CREATE TABLE t1(c1 REAL NOT NULL); 509SHOW TABLES; 510Tables_in_test 511t1 512SHOW CREATE TABLE t1; 513Table Create Table 514t1 CREATE TABLE `t1` ( 515 `c1` double NOT NULL 516) ENGINE=ENGINE DEFAULT CHARSET=latin1 517ALTER TABLE t1 ADD KEY USING BTREE (c1); 518SHOW TABLES; 519Tables_in_test 520t1 521SHOW CREATE TABLE t1; 522Table Create Table 523t1 CREATE TABLE `t1` ( 524 `c1` double NOT NULL, 525 KEY `c1` (`c1`) USING BTREE 526) ENGINE=ENGINE DEFAULT CHARSET=latin1 527DROP TABLE t1; 528SHOW TABLES; 529Tables_in_test 530CREATE TABLE t1(c1 DOUBLE NOT NULL); 531SHOW TABLES; 532Tables_in_test 533t1 534SHOW CREATE TABLE t1; 535Table Create Table 536t1 CREATE TABLE `t1` ( 537 `c1` double NOT NULL 538) ENGINE=ENGINE DEFAULT CHARSET=latin1 539ALTER TABLE t1 ADD KEY USING BTREE (c1); 540SHOW TABLES; 541Tables_in_test 542t1 543SHOW CREATE TABLE t1; 544Table Create Table 545t1 CREATE TABLE `t1` ( 546 `c1` double NOT NULL, 547 KEY `c1` (`c1`) USING BTREE 548) ENGINE=ENGINE DEFAULT CHARSET=latin1 549DROP TABLE t1; 550SHOW TABLES; 551Tables_in_test 552CREATE TABLE t1(c1 FLOAT NOT NULL); 553SHOW TABLES; 554Tables_in_test 555t1 556SHOW CREATE TABLE t1; 557Table Create Table 558t1 CREATE TABLE `t1` ( 559 `c1` float NOT NULL 560) ENGINE=ENGINE DEFAULT CHARSET=latin1 561ALTER TABLE t1 ADD KEY USING BTREE (c1); 562SHOW TABLES; 563Tables_in_test 564t1 565SHOW CREATE TABLE t1; 566Table Create Table 567t1 CREATE TABLE `t1` ( 568 `c1` float NOT NULL, 569 KEY `c1` (`c1`) USING BTREE 570) ENGINE=ENGINE DEFAULT CHARSET=latin1 571DROP TABLE t1; 572SHOW TABLES; 573Tables_in_test 574CREATE TABLE t1(c1 DECIMAL NOT NULL); 575SHOW TABLES; 576Tables_in_test 577t1 578SHOW CREATE TABLE t1; 579Table Create Table 580t1 CREATE TABLE `t1` ( 581 `c1` decimal(10,0) NOT NULL 582) ENGINE=ENGINE DEFAULT CHARSET=latin1 583ALTER TABLE t1 ADD KEY USING BTREE (c1); 584SHOW TABLES; 585Tables_in_test 586t1 587SHOW CREATE TABLE t1; 588Table Create Table 589t1 CREATE TABLE `t1` ( 590 `c1` decimal(10,0) NOT NULL, 591 KEY `c1` (`c1`) USING BTREE 592) ENGINE=ENGINE DEFAULT CHARSET=latin1 593DROP TABLE t1; 594SHOW TABLES; 595Tables_in_test 596CREATE TABLE t1(c1 NUMERIC NOT NULL); 597SHOW TABLES; 598Tables_in_test 599t1 600SHOW CREATE TABLE t1; 601Table Create Table 602t1 CREATE TABLE `t1` ( 603 `c1` decimal(10,0) NOT NULL 604) ENGINE=ENGINE DEFAULT CHARSET=latin1 605ALTER TABLE t1 ADD KEY USING BTREE (c1); 606SHOW TABLES; 607Tables_in_test 608t1 609SHOW CREATE TABLE t1; 610Table Create Table 611t1 CREATE TABLE `t1` ( 612 `c1` decimal(10,0) NOT NULL, 613 KEY `c1` (`c1`) USING BTREE 614) ENGINE=ENGINE DEFAULT CHARSET=latin1 615DROP TABLE t1; 616SHOW TABLES; 617Tables_in_test 618CREATE TABLE t1(c1 DATE NOT NULL); 619SHOW TABLES; 620Tables_in_test 621t1 622SHOW CREATE TABLE t1; 623Table Create Table 624t1 CREATE TABLE `t1` ( 625 `c1` date NOT NULL 626) ENGINE=ENGINE DEFAULT CHARSET=latin1 627ALTER TABLE t1 ADD KEY USING BTREE (c1); 628SHOW TABLES; 629Tables_in_test 630t1 631SHOW CREATE TABLE t1; 632Table Create Table 633t1 CREATE TABLE `t1` ( 634 `c1` date NOT NULL, 635 KEY `c1` (`c1`) USING BTREE 636) ENGINE=ENGINE DEFAULT CHARSET=latin1 637DROP TABLE t1; 638SHOW TABLES; 639Tables_in_test 640CREATE TABLE t1(c1 TIME NOT NULL); 641SHOW TABLES; 642Tables_in_test 643t1 644SHOW CREATE TABLE t1; 645Table Create Table 646t1 CREATE TABLE `t1` ( 647 `c1` time NOT NULL 648) ENGINE=ENGINE DEFAULT CHARSET=latin1 649ALTER TABLE t1 ADD KEY USING BTREE (c1); 650SHOW TABLES; 651Tables_in_test 652t1 653SHOW CREATE TABLE t1; 654Table Create Table 655t1 CREATE TABLE `t1` ( 656 `c1` time NOT NULL, 657 KEY `c1` (`c1`) USING BTREE 658) ENGINE=ENGINE DEFAULT CHARSET=latin1 659DROP TABLE t1; 660SHOW TABLES; 661Tables_in_test 662CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 663SHOW TABLES; 664Tables_in_test 665t1 666SHOW CREATE TABLE t1; 667Table Create Table 668t1 CREATE TABLE `t1` ( 669 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 670) ENGINE=ENGINE DEFAULT CHARSET=latin1 671ALTER TABLE t1 ADD KEY USING BTREE (c1); 672SHOW TABLES; 673Tables_in_test 674t1 675SHOW CREATE TABLE t1; 676Table Create Table 677t1 CREATE TABLE `t1` ( 678 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 679 KEY `c1` (`c1`) USING BTREE 680) ENGINE=ENGINE DEFAULT CHARSET=latin1 681DROP TABLE t1; 682SHOW TABLES; 683Tables_in_test 684CREATE TABLE t1(c1 YEAR NOT NULL); 685SHOW TABLES; 686Tables_in_test 687t1 688SHOW CREATE TABLE t1; 689Table Create Table 690t1 CREATE TABLE `t1` ( 691 `c1` year(4) NOT NULL 692) ENGINE=ENGINE DEFAULT CHARSET=latin1 693ALTER TABLE t1 ADD KEY USING BTREE (c1); 694SHOW TABLES; 695Tables_in_test 696t1 697SHOW CREATE TABLE t1; 698Table Create Table 699t1 CREATE TABLE `t1` ( 700 `c1` year(4) NOT NULL, 701 KEY `c1` (`c1`) USING BTREE 702) ENGINE=ENGINE DEFAULT CHARSET=latin1 703DROP TABLE t1; 704SHOW TABLES; 705Tables_in_test 706CREATE TABLE t1(c1 BIT NOT NULL); 707SHOW TABLES; 708Tables_in_test 709t1 710SHOW CREATE TABLE t1; 711Table Create Table 712t1 CREATE TABLE `t1` ( 713 `c1` bit(1) NOT NULL 714) ENGINE=ENGINE DEFAULT CHARSET=latin1 715ALTER TABLE t1 ADD KEY USING HASH (c1); 716SHOW TABLES; 717Tables_in_test 718t1 719SHOW CREATE TABLE t1; 720Table Create Table 721t1 CREATE TABLE `t1` ( 722 `c1` bit(1) NOT NULL, 723 KEY `c1` (`c1`) USING HASH 724) ENGINE=ENGINE DEFAULT CHARSET=latin1 725DROP TABLE t1; 726SHOW TABLES; 727Tables_in_test 728CREATE TABLE t1(c1 TINYINT NOT NULL); 729SHOW TABLES; 730Tables_in_test 731t1 732SHOW CREATE TABLE t1; 733Table Create Table 734t1 CREATE TABLE `t1` ( 735 `c1` tinyint(4) NOT NULL 736) ENGINE=ENGINE DEFAULT CHARSET=latin1 737ALTER TABLE t1 ADD KEY USING HASH (c1); 738SHOW TABLES; 739Tables_in_test 740t1 741SHOW CREATE TABLE t1; 742Table Create Table 743t1 CREATE TABLE `t1` ( 744 `c1` tinyint(4) NOT NULL, 745 KEY `c1` (`c1`) USING HASH 746) ENGINE=ENGINE DEFAULT CHARSET=latin1 747DROP TABLE t1; 748SHOW TABLES; 749Tables_in_test 750CREATE TABLE t1(c1 SMALLINT NOT NULL); 751SHOW TABLES; 752Tables_in_test 753t1 754SHOW CREATE TABLE t1; 755Table Create Table 756t1 CREATE TABLE `t1` ( 757 `c1` smallint(6) NOT NULL 758) ENGINE=ENGINE DEFAULT CHARSET=latin1 759ALTER TABLE t1 ADD KEY USING HASH (c1); 760SHOW TABLES; 761Tables_in_test 762t1 763SHOW CREATE TABLE t1; 764Table Create Table 765t1 CREATE TABLE `t1` ( 766 `c1` smallint(6) NOT NULL, 767 KEY `c1` (`c1`) USING HASH 768) ENGINE=ENGINE DEFAULT CHARSET=latin1 769DROP TABLE t1; 770SHOW TABLES; 771Tables_in_test 772CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 773SHOW TABLES; 774Tables_in_test 775t1 776SHOW CREATE TABLE t1; 777Table Create Table 778t1 CREATE TABLE `t1` ( 779 `c1` mediumint(9) NOT NULL 780) ENGINE=ENGINE DEFAULT CHARSET=latin1 781ALTER TABLE t1 ADD KEY USING HASH (c1); 782SHOW TABLES; 783Tables_in_test 784t1 785SHOW CREATE TABLE t1; 786Table Create Table 787t1 CREATE TABLE `t1` ( 788 `c1` mediumint(9) NOT NULL, 789 KEY `c1` (`c1`) USING HASH 790) ENGINE=ENGINE DEFAULT CHARSET=latin1 791DROP TABLE t1; 792SHOW TABLES; 793Tables_in_test 794CREATE TABLE t1(c1 INT NOT NULL); 795SHOW TABLES; 796Tables_in_test 797t1 798SHOW CREATE TABLE t1; 799Table Create Table 800t1 CREATE TABLE `t1` ( 801 `c1` int(11) NOT NULL 802) ENGINE=ENGINE DEFAULT CHARSET=latin1 803ALTER TABLE t1 ADD KEY USING HASH (c1); 804SHOW TABLES; 805Tables_in_test 806t1 807SHOW CREATE TABLE t1; 808Table Create Table 809t1 CREATE TABLE `t1` ( 810 `c1` int(11) NOT NULL, 811 KEY `c1` (`c1`) USING HASH 812) ENGINE=ENGINE DEFAULT CHARSET=latin1 813DROP TABLE t1; 814SHOW TABLES; 815Tables_in_test 816CREATE TABLE t1(c1 INTEGER NOT NULL); 817SHOW TABLES; 818Tables_in_test 819t1 820SHOW CREATE TABLE t1; 821Table Create Table 822t1 CREATE TABLE `t1` ( 823 `c1` int(11) NOT NULL 824) ENGINE=ENGINE DEFAULT CHARSET=latin1 825ALTER TABLE t1 ADD KEY USING HASH (c1); 826SHOW TABLES; 827Tables_in_test 828t1 829SHOW CREATE TABLE t1; 830Table Create Table 831t1 CREATE TABLE `t1` ( 832 `c1` int(11) NOT NULL, 833 KEY `c1` (`c1`) USING HASH 834) ENGINE=ENGINE DEFAULT CHARSET=latin1 835DROP TABLE t1; 836SHOW TABLES; 837Tables_in_test 838CREATE TABLE t1(c1 BIGINT NOT NULL); 839SHOW TABLES; 840Tables_in_test 841t1 842SHOW CREATE TABLE t1; 843Table Create Table 844t1 CREATE TABLE `t1` ( 845 `c1` bigint(20) NOT NULL 846) ENGINE=ENGINE DEFAULT CHARSET=latin1 847ALTER TABLE t1 ADD KEY USING HASH (c1); 848SHOW TABLES; 849Tables_in_test 850t1 851SHOW CREATE TABLE t1; 852Table Create Table 853t1 CREATE TABLE `t1` ( 854 `c1` bigint(20) NOT NULL, 855 KEY `c1` (`c1`) USING HASH 856) ENGINE=ENGINE DEFAULT CHARSET=latin1 857DROP TABLE t1; 858SHOW TABLES; 859Tables_in_test 860CREATE TABLE t1(c1 REAL NOT NULL); 861SHOW TABLES; 862Tables_in_test 863t1 864SHOW CREATE TABLE t1; 865Table Create Table 866t1 CREATE TABLE `t1` ( 867 `c1` double NOT NULL 868) ENGINE=ENGINE DEFAULT CHARSET=latin1 869ALTER TABLE t1 ADD KEY USING HASH (c1); 870SHOW TABLES; 871Tables_in_test 872t1 873SHOW CREATE TABLE t1; 874Table Create Table 875t1 CREATE TABLE `t1` ( 876 `c1` double NOT NULL, 877 KEY `c1` (`c1`) USING HASH 878) ENGINE=ENGINE DEFAULT CHARSET=latin1 879DROP TABLE t1; 880SHOW TABLES; 881Tables_in_test 882CREATE TABLE t1(c1 DOUBLE NOT NULL); 883SHOW TABLES; 884Tables_in_test 885t1 886SHOW CREATE TABLE t1; 887Table Create Table 888t1 CREATE TABLE `t1` ( 889 `c1` double NOT NULL 890) ENGINE=ENGINE DEFAULT CHARSET=latin1 891ALTER TABLE t1 ADD KEY USING HASH (c1); 892SHOW TABLES; 893Tables_in_test 894t1 895SHOW CREATE TABLE t1; 896Table Create Table 897t1 CREATE TABLE `t1` ( 898 `c1` double NOT NULL, 899 KEY `c1` (`c1`) USING HASH 900) ENGINE=ENGINE DEFAULT CHARSET=latin1 901DROP TABLE t1; 902SHOW TABLES; 903Tables_in_test 904CREATE TABLE t1(c1 FLOAT NOT NULL); 905SHOW TABLES; 906Tables_in_test 907t1 908SHOW CREATE TABLE t1; 909Table Create Table 910t1 CREATE TABLE `t1` ( 911 `c1` float NOT NULL 912) ENGINE=ENGINE DEFAULT CHARSET=latin1 913ALTER TABLE t1 ADD KEY USING HASH (c1); 914SHOW TABLES; 915Tables_in_test 916t1 917SHOW CREATE TABLE t1; 918Table Create Table 919t1 CREATE TABLE `t1` ( 920 `c1` float NOT NULL, 921 KEY `c1` (`c1`) USING HASH 922) ENGINE=ENGINE DEFAULT CHARSET=latin1 923DROP TABLE t1; 924SHOW TABLES; 925Tables_in_test 926CREATE TABLE t1(c1 DECIMAL NOT NULL); 927SHOW TABLES; 928Tables_in_test 929t1 930SHOW CREATE TABLE t1; 931Table Create Table 932t1 CREATE TABLE `t1` ( 933 `c1` decimal(10,0) NOT NULL 934) ENGINE=ENGINE DEFAULT CHARSET=latin1 935ALTER TABLE t1 ADD KEY USING HASH (c1); 936SHOW TABLES; 937Tables_in_test 938t1 939SHOW CREATE TABLE t1; 940Table Create Table 941t1 CREATE TABLE `t1` ( 942 `c1` decimal(10,0) NOT NULL, 943 KEY `c1` (`c1`) USING HASH 944) ENGINE=ENGINE DEFAULT CHARSET=latin1 945DROP TABLE t1; 946SHOW TABLES; 947Tables_in_test 948CREATE TABLE t1(c1 NUMERIC NOT NULL); 949SHOW TABLES; 950Tables_in_test 951t1 952SHOW CREATE TABLE t1; 953Table Create Table 954t1 CREATE TABLE `t1` ( 955 `c1` decimal(10,0) NOT NULL 956) ENGINE=ENGINE DEFAULT CHARSET=latin1 957ALTER TABLE t1 ADD KEY USING HASH (c1); 958SHOW TABLES; 959Tables_in_test 960t1 961SHOW CREATE TABLE t1; 962Table Create Table 963t1 CREATE TABLE `t1` ( 964 `c1` decimal(10,0) NOT NULL, 965 KEY `c1` (`c1`) USING HASH 966) ENGINE=ENGINE DEFAULT CHARSET=latin1 967DROP TABLE t1; 968SHOW TABLES; 969Tables_in_test 970CREATE TABLE t1(c1 DATE NOT NULL); 971SHOW TABLES; 972Tables_in_test 973t1 974SHOW CREATE TABLE t1; 975Table Create Table 976t1 CREATE TABLE `t1` ( 977 `c1` date NOT NULL 978) ENGINE=ENGINE DEFAULT CHARSET=latin1 979ALTER TABLE t1 ADD KEY USING HASH (c1); 980SHOW TABLES; 981Tables_in_test 982t1 983SHOW CREATE TABLE t1; 984Table Create Table 985t1 CREATE TABLE `t1` ( 986 `c1` date NOT NULL, 987 KEY `c1` (`c1`) USING HASH 988) ENGINE=ENGINE DEFAULT CHARSET=latin1 989DROP TABLE t1; 990SHOW TABLES; 991Tables_in_test 992CREATE TABLE t1(c1 TIME NOT NULL); 993SHOW TABLES; 994Tables_in_test 995t1 996SHOW CREATE TABLE t1; 997Table Create Table 998t1 CREATE TABLE `t1` ( 999 `c1` time NOT NULL 1000) ENGINE=ENGINE DEFAULT CHARSET=latin1 1001ALTER TABLE t1 ADD KEY USING HASH (c1); 1002SHOW TABLES; 1003Tables_in_test 1004t1 1005SHOW CREATE TABLE t1; 1006Table Create Table 1007t1 CREATE TABLE `t1` ( 1008 `c1` time NOT NULL, 1009 KEY `c1` (`c1`) USING HASH 1010) ENGINE=ENGINE DEFAULT CHARSET=latin1 1011DROP TABLE t1; 1012SHOW TABLES; 1013Tables_in_test 1014CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1015SHOW TABLES; 1016Tables_in_test 1017t1 1018SHOW CREATE TABLE t1; 1019Table Create Table 1020t1 CREATE TABLE `t1` ( 1021 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 1022) ENGINE=ENGINE DEFAULT CHARSET=latin1 1023ALTER TABLE t1 ADD KEY USING HASH (c1); 1024SHOW TABLES; 1025Tables_in_test 1026t1 1027SHOW CREATE TABLE t1; 1028Table Create Table 1029t1 CREATE TABLE `t1` ( 1030 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 1031 KEY `c1` (`c1`) USING HASH 1032) ENGINE=ENGINE DEFAULT CHARSET=latin1 1033DROP TABLE t1; 1034SHOW TABLES; 1035Tables_in_test 1036CREATE TABLE t1(c1 YEAR NOT NULL); 1037SHOW TABLES; 1038Tables_in_test 1039t1 1040SHOW CREATE TABLE t1; 1041Table Create Table 1042t1 CREATE TABLE `t1` ( 1043 `c1` year(4) NOT NULL 1044) ENGINE=ENGINE DEFAULT CHARSET=latin1 1045ALTER TABLE t1 ADD KEY USING HASH (c1); 1046SHOW TABLES; 1047Tables_in_test 1048t1 1049SHOW CREATE TABLE t1; 1050Table Create Table 1051t1 CREATE TABLE `t1` ( 1052 `c1` year(4) NOT NULL, 1053 KEY `c1` (`c1`) USING HASH 1054) ENGINE=ENGINE DEFAULT CHARSET=latin1 1055DROP TABLE t1; 1056SHOW TABLES; 1057Tables_in_test 1058CREATE TABLE t1(c1 BIT NOT NULL); 1059SHOW TABLES; 1060Tables_in_test 1061t1 1062SHOW CREATE TABLE t1; 1063Table Create Table 1064t1 CREATE TABLE `t1` ( 1065 `c1` bit(1) NOT NULL 1066) ENGINE=ENGINE DEFAULT CHARSET=latin1 1067ALTER TABLE t1 ADD INDEX (c1); 1068SHOW TABLES; 1069Tables_in_test 1070t1 1071SHOW CREATE TABLE t1; 1072Table Create Table 1073t1 CREATE TABLE `t1` ( 1074 `c1` bit(1) NOT NULL, 1075 KEY `c1` (`c1`) 1076) ENGINE=ENGINE DEFAULT CHARSET=latin1 1077DROP TABLE t1; 1078SHOW TABLES; 1079Tables_in_test 1080CREATE TABLE t1(c1 TINYINT NOT NULL); 1081SHOW TABLES; 1082Tables_in_test 1083t1 1084SHOW CREATE TABLE t1; 1085Table Create Table 1086t1 CREATE TABLE `t1` ( 1087 `c1` tinyint(4) NOT NULL 1088) ENGINE=ENGINE DEFAULT CHARSET=latin1 1089ALTER TABLE t1 ADD INDEX (c1); 1090SHOW TABLES; 1091Tables_in_test 1092t1 1093SHOW CREATE TABLE t1; 1094Table Create Table 1095t1 CREATE TABLE `t1` ( 1096 `c1` tinyint(4) NOT NULL, 1097 KEY `c1` (`c1`) 1098) ENGINE=ENGINE DEFAULT CHARSET=latin1 1099DROP TABLE t1; 1100SHOW TABLES; 1101Tables_in_test 1102CREATE TABLE t1(c1 SMALLINT NOT NULL); 1103SHOW TABLES; 1104Tables_in_test 1105t1 1106SHOW CREATE TABLE t1; 1107Table Create Table 1108t1 CREATE TABLE `t1` ( 1109 `c1` smallint(6) NOT NULL 1110) ENGINE=ENGINE DEFAULT CHARSET=latin1 1111ALTER TABLE t1 ADD INDEX (c1); 1112SHOW TABLES; 1113Tables_in_test 1114t1 1115SHOW CREATE TABLE t1; 1116Table Create Table 1117t1 CREATE TABLE `t1` ( 1118 `c1` smallint(6) NOT NULL, 1119 KEY `c1` (`c1`) 1120) ENGINE=ENGINE DEFAULT CHARSET=latin1 1121DROP TABLE t1; 1122SHOW TABLES; 1123Tables_in_test 1124CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1125SHOW TABLES; 1126Tables_in_test 1127t1 1128SHOW CREATE TABLE t1; 1129Table Create Table 1130t1 CREATE TABLE `t1` ( 1131 `c1` mediumint(9) NOT NULL 1132) ENGINE=ENGINE DEFAULT CHARSET=latin1 1133ALTER TABLE t1 ADD INDEX (c1); 1134SHOW TABLES; 1135Tables_in_test 1136t1 1137SHOW CREATE TABLE t1; 1138Table Create Table 1139t1 CREATE TABLE `t1` ( 1140 `c1` mediumint(9) NOT NULL, 1141 KEY `c1` (`c1`) 1142) ENGINE=ENGINE DEFAULT CHARSET=latin1 1143DROP TABLE t1; 1144SHOW TABLES; 1145Tables_in_test 1146CREATE TABLE t1(c1 INT NOT NULL); 1147SHOW TABLES; 1148Tables_in_test 1149t1 1150SHOW CREATE TABLE t1; 1151Table Create Table 1152t1 CREATE TABLE `t1` ( 1153 `c1` int(11) NOT NULL 1154) ENGINE=ENGINE DEFAULT CHARSET=latin1 1155ALTER TABLE t1 ADD INDEX (c1); 1156SHOW TABLES; 1157Tables_in_test 1158t1 1159SHOW CREATE TABLE t1; 1160Table Create Table 1161t1 CREATE TABLE `t1` ( 1162 `c1` int(11) NOT NULL, 1163 KEY `c1` (`c1`) 1164) ENGINE=ENGINE DEFAULT CHARSET=latin1 1165DROP TABLE t1; 1166SHOW TABLES; 1167Tables_in_test 1168CREATE TABLE t1(c1 INTEGER NOT NULL); 1169SHOW TABLES; 1170Tables_in_test 1171t1 1172SHOW CREATE TABLE t1; 1173Table Create Table 1174t1 CREATE TABLE `t1` ( 1175 `c1` int(11) NOT NULL 1176) ENGINE=ENGINE DEFAULT CHARSET=latin1 1177ALTER TABLE t1 ADD INDEX (c1); 1178SHOW TABLES; 1179Tables_in_test 1180t1 1181SHOW CREATE TABLE t1; 1182Table Create Table 1183t1 CREATE TABLE `t1` ( 1184 `c1` int(11) NOT NULL, 1185 KEY `c1` (`c1`) 1186) ENGINE=ENGINE DEFAULT CHARSET=latin1 1187DROP TABLE t1; 1188SHOW TABLES; 1189Tables_in_test 1190CREATE TABLE t1(c1 BIGINT NOT NULL); 1191SHOW TABLES; 1192Tables_in_test 1193t1 1194SHOW CREATE TABLE t1; 1195Table Create Table 1196t1 CREATE TABLE `t1` ( 1197 `c1` bigint(20) NOT NULL 1198) ENGINE=ENGINE DEFAULT CHARSET=latin1 1199ALTER TABLE t1 ADD INDEX (c1); 1200SHOW TABLES; 1201Tables_in_test 1202t1 1203SHOW CREATE TABLE t1; 1204Table Create Table 1205t1 CREATE TABLE `t1` ( 1206 `c1` bigint(20) NOT NULL, 1207 KEY `c1` (`c1`) 1208) ENGINE=ENGINE DEFAULT CHARSET=latin1 1209DROP TABLE t1; 1210SHOW TABLES; 1211Tables_in_test 1212CREATE TABLE t1(c1 REAL NOT NULL); 1213SHOW TABLES; 1214Tables_in_test 1215t1 1216SHOW CREATE TABLE t1; 1217Table Create Table 1218t1 CREATE TABLE `t1` ( 1219 `c1` double NOT NULL 1220) ENGINE=ENGINE DEFAULT CHARSET=latin1 1221ALTER TABLE t1 ADD INDEX (c1); 1222SHOW TABLES; 1223Tables_in_test 1224t1 1225SHOW CREATE TABLE t1; 1226Table Create Table 1227t1 CREATE TABLE `t1` ( 1228 `c1` double NOT NULL, 1229 KEY `c1` (`c1`) 1230) ENGINE=ENGINE DEFAULT CHARSET=latin1 1231DROP TABLE t1; 1232SHOW TABLES; 1233Tables_in_test 1234CREATE TABLE t1(c1 DOUBLE NOT NULL); 1235SHOW TABLES; 1236Tables_in_test 1237t1 1238SHOW CREATE TABLE t1; 1239Table Create Table 1240t1 CREATE TABLE `t1` ( 1241 `c1` double NOT NULL 1242) ENGINE=ENGINE DEFAULT CHARSET=latin1 1243ALTER TABLE t1 ADD INDEX (c1); 1244SHOW TABLES; 1245Tables_in_test 1246t1 1247SHOW CREATE TABLE t1; 1248Table Create Table 1249t1 CREATE TABLE `t1` ( 1250 `c1` double NOT NULL, 1251 KEY `c1` (`c1`) 1252) ENGINE=ENGINE DEFAULT CHARSET=latin1 1253DROP TABLE t1; 1254SHOW TABLES; 1255Tables_in_test 1256CREATE TABLE t1(c1 FLOAT NOT NULL); 1257SHOW TABLES; 1258Tables_in_test 1259t1 1260SHOW CREATE TABLE t1; 1261Table Create Table 1262t1 CREATE TABLE `t1` ( 1263 `c1` float NOT NULL 1264) ENGINE=ENGINE DEFAULT CHARSET=latin1 1265ALTER TABLE t1 ADD INDEX (c1); 1266SHOW TABLES; 1267Tables_in_test 1268t1 1269SHOW CREATE TABLE t1; 1270Table Create Table 1271t1 CREATE TABLE `t1` ( 1272 `c1` float NOT NULL, 1273 KEY `c1` (`c1`) 1274) ENGINE=ENGINE DEFAULT CHARSET=latin1 1275DROP TABLE t1; 1276SHOW TABLES; 1277Tables_in_test 1278CREATE TABLE t1(c1 DECIMAL NOT NULL); 1279SHOW TABLES; 1280Tables_in_test 1281t1 1282SHOW CREATE TABLE t1; 1283Table Create Table 1284t1 CREATE TABLE `t1` ( 1285 `c1` decimal(10,0) NOT NULL 1286) ENGINE=ENGINE DEFAULT CHARSET=latin1 1287ALTER TABLE t1 ADD INDEX (c1); 1288SHOW TABLES; 1289Tables_in_test 1290t1 1291SHOW CREATE TABLE t1; 1292Table Create Table 1293t1 CREATE TABLE `t1` ( 1294 `c1` decimal(10,0) NOT NULL, 1295 KEY `c1` (`c1`) 1296) ENGINE=ENGINE DEFAULT CHARSET=latin1 1297DROP TABLE t1; 1298SHOW TABLES; 1299Tables_in_test 1300CREATE TABLE t1(c1 NUMERIC NOT NULL); 1301SHOW TABLES; 1302Tables_in_test 1303t1 1304SHOW CREATE TABLE t1; 1305Table Create Table 1306t1 CREATE TABLE `t1` ( 1307 `c1` decimal(10,0) NOT NULL 1308) ENGINE=ENGINE DEFAULT CHARSET=latin1 1309ALTER TABLE t1 ADD INDEX (c1); 1310SHOW TABLES; 1311Tables_in_test 1312t1 1313SHOW CREATE TABLE t1; 1314Table Create Table 1315t1 CREATE TABLE `t1` ( 1316 `c1` decimal(10,0) NOT NULL, 1317 KEY `c1` (`c1`) 1318) ENGINE=ENGINE DEFAULT CHARSET=latin1 1319DROP TABLE t1; 1320SHOW TABLES; 1321Tables_in_test 1322CREATE TABLE t1(c1 DATE NOT NULL); 1323SHOW TABLES; 1324Tables_in_test 1325t1 1326SHOW CREATE TABLE t1; 1327Table Create Table 1328t1 CREATE TABLE `t1` ( 1329 `c1` date NOT NULL 1330) ENGINE=ENGINE DEFAULT CHARSET=latin1 1331ALTER TABLE t1 ADD INDEX (c1); 1332SHOW TABLES; 1333Tables_in_test 1334t1 1335SHOW CREATE TABLE t1; 1336Table Create Table 1337t1 CREATE TABLE `t1` ( 1338 `c1` date NOT NULL, 1339 KEY `c1` (`c1`) 1340) ENGINE=ENGINE DEFAULT CHARSET=latin1 1341DROP TABLE t1; 1342SHOW TABLES; 1343Tables_in_test 1344CREATE TABLE t1(c1 TIME NOT NULL); 1345SHOW TABLES; 1346Tables_in_test 1347t1 1348SHOW CREATE TABLE t1; 1349Table Create Table 1350t1 CREATE TABLE `t1` ( 1351 `c1` time NOT NULL 1352) ENGINE=ENGINE DEFAULT CHARSET=latin1 1353ALTER TABLE t1 ADD INDEX (c1); 1354SHOW TABLES; 1355Tables_in_test 1356t1 1357SHOW CREATE TABLE t1; 1358Table Create Table 1359t1 CREATE TABLE `t1` ( 1360 `c1` time NOT NULL, 1361 KEY `c1` (`c1`) 1362) ENGINE=ENGINE DEFAULT CHARSET=latin1 1363DROP TABLE t1; 1364SHOW TABLES; 1365Tables_in_test 1366CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1367SHOW TABLES; 1368Tables_in_test 1369t1 1370SHOW CREATE TABLE t1; 1371Table Create Table 1372t1 CREATE TABLE `t1` ( 1373 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 1374) ENGINE=ENGINE DEFAULT CHARSET=latin1 1375ALTER TABLE t1 ADD INDEX (c1); 1376SHOW TABLES; 1377Tables_in_test 1378t1 1379SHOW CREATE TABLE t1; 1380Table Create Table 1381t1 CREATE TABLE `t1` ( 1382 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 1383 KEY `c1` (`c1`) 1384) ENGINE=ENGINE DEFAULT CHARSET=latin1 1385DROP TABLE t1; 1386SHOW TABLES; 1387Tables_in_test 1388CREATE TABLE t1(c1 YEAR NOT NULL); 1389SHOW TABLES; 1390Tables_in_test 1391t1 1392SHOW CREATE TABLE t1; 1393Table Create Table 1394t1 CREATE TABLE `t1` ( 1395 `c1` year(4) NOT NULL 1396) ENGINE=ENGINE DEFAULT CHARSET=latin1 1397ALTER TABLE t1 ADD INDEX (c1); 1398SHOW TABLES; 1399Tables_in_test 1400t1 1401SHOW CREATE TABLE t1; 1402Table Create Table 1403t1 CREATE TABLE `t1` ( 1404 `c1` year(4) NOT NULL, 1405 KEY `c1` (`c1`) 1406) ENGINE=ENGINE DEFAULT CHARSET=latin1 1407DROP TABLE t1; 1408SHOW TABLES; 1409Tables_in_test 1410CREATE TABLE t1(c1 BIT NOT NULL); 1411SHOW TABLES; 1412Tables_in_test 1413t1 1414SHOW CREATE TABLE t1; 1415Table Create Table 1416t1 CREATE TABLE `t1` ( 1417 `c1` bit(1) NOT NULL 1418) ENGINE=ENGINE DEFAULT CHARSET=latin1 1419ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1420SHOW TABLES; 1421Tables_in_test 1422t1 1423SHOW CREATE TABLE t1; 1424Table Create Table 1425t1 CREATE TABLE `t1` ( 1426 `c1` bit(1) NOT NULL, 1427 KEY `c1` (`c1`) USING BTREE 1428) ENGINE=ENGINE DEFAULT CHARSET=latin1 1429DROP TABLE t1; 1430SHOW TABLES; 1431Tables_in_test 1432CREATE TABLE t1(c1 TINYINT NOT NULL); 1433SHOW TABLES; 1434Tables_in_test 1435t1 1436SHOW CREATE TABLE t1; 1437Table Create Table 1438t1 CREATE TABLE `t1` ( 1439 `c1` tinyint(4) NOT NULL 1440) ENGINE=ENGINE DEFAULT CHARSET=latin1 1441ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1442SHOW TABLES; 1443Tables_in_test 1444t1 1445SHOW CREATE TABLE t1; 1446Table Create Table 1447t1 CREATE TABLE `t1` ( 1448 `c1` tinyint(4) NOT NULL, 1449 KEY `c1` (`c1`) USING BTREE 1450) ENGINE=ENGINE DEFAULT CHARSET=latin1 1451DROP TABLE t1; 1452SHOW TABLES; 1453Tables_in_test 1454CREATE TABLE t1(c1 SMALLINT NOT NULL); 1455SHOW TABLES; 1456Tables_in_test 1457t1 1458SHOW CREATE TABLE t1; 1459Table Create Table 1460t1 CREATE TABLE `t1` ( 1461 `c1` smallint(6) NOT NULL 1462) ENGINE=ENGINE DEFAULT CHARSET=latin1 1463ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1464SHOW TABLES; 1465Tables_in_test 1466t1 1467SHOW CREATE TABLE t1; 1468Table Create Table 1469t1 CREATE TABLE `t1` ( 1470 `c1` smallint(6) NOT NULL, 1471 KEY `c1` (`c1`) USING BTREE 1472) ENGINE=ENGINE DEFAULT CHARSET=latin1 1473DROP TABLE t1; 1474SHOW TABLES; 1475Tables_in_test 1476CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1477SHOW TABLES; 1478Tables_in_test 1479t1 1480SHOW CREATE TABLE t1; 1481Table Create Table 1482t1 CREATE TABLE `t1` ( 1483 `c1` mediumint(9) NOT NULL 1484) ENGINE=ENGINE DEFAULT CHARSET=latin1 1485ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1486SHOW TABLES; 1487Tables_in_test 1488t1 1489SHOW CREATE TABLE t1; 1490Table Create Table 1491t1 CREATE TABLE `t1` ( 1492 `c1` mediumint(9) NOT NULL, 1493 KEY `c1` (`c1`) USING BTREE 1494) ENGINE=ENGINE DEFAULT CHARSET=latin1 1495DROP TABLE t1; 1496SHOW TABLES; 1497Tables_in_test 1498CREATE TABLE t1(c1 INT NOT NULL); 1499SHOW TABLES; 1500Tables_in_test 1501t1 1502SHOW CREATE TABLE t1; 1503Table Create Table 1504t1 CREATE TABLE `t1` ( 1505 `c1` int(11) NOT NULL 1506) ENGINE=ENGINE DEFAULT CHARSET=latin1 1507ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1508SHOW TABLES; 1509Tables_in_test 1510t1 1511SHOW CREATE TABLE t1; 1512Table Create Table 1513t1 CREATE TABLE `t1` ( 1514 `c1` int(11) NOT NULL, 1515 KEY `c1` (`c1`) USING BTREE 1516) ENGINE=ENGINE DEFAULT CHARSET=latin1 1517DROP TABLE t1; 1518SHOW TABLES; 1519Tables_in_test 1520CREATE TABLE t1(c1 INTEGER NOT NULL); 1521SHOW TABLES; 1522Tables_in_test 1523t1 1524SHOW CREATE TABLE t1; 1525Table Create Table 1526t1 CREATE TABLE `t1` ( 1527 `c1` int(11) NOT NULL 1528) ENGINE=ENGINE DEFAULT CHARSET=latin1 1529ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1530SHOW TABLES; 1531Tables_in_test 1532t1 1533SHOW CREATE TABLE t1; 1534Table Create Table 1535t1 CREATE TABLE `t1` ( 1536 `c1` int(11) NOT NULL, 1537 KEY `c1` (`c1`) USING BTREE 1538) ENGINE=ENGINE DEFAULT CHARSET=latin1 1539DROP TABLE t1; 1540SHOW TABLES; 1541Tables_in_test 1542CREATE TABLE t1(c1 BIGINT NOT NULL); 1543SHOW TABLES; 1544Tables_in_test 1545t1 1546SHOW CREATE TABLE t1; 1547Table Create Table 1548t1 CREATE TABLE `t1` ( 1549 `c1` bigint(20) NOT NULL 1550) ENGINE=ENGINE DEFAULT CHARSET=latin1 1551ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1552SHOW TABLES; 1553Tables_in_test 1554t1 1555SHOW CREATE TABLE t1; 1556Table Create Table 1557t1 CREATE TABLE `t1` ( 1558 `c1` bigint(20) NOT NULL, 1559 KEY `c1` (`c1`) USING BTREE 1560) ENGINE=ENGINE DEFAULT CHARSET=latin1 1561DROP TABLE t1; 1562SHOW TABLES; 1563Tables_in_test 1564CREATE TABLE t1(c1 REAL NOT NULL); 1565SHOW TABLES; 1566Tables_in_test 1567t1 1568SHOW CREATE TABLE t1; 1569Table Create Table 1570t1 CREATE TABLE `t1` ( 1571 `c1` double NOT NULL 1572) ENGINE=ENGINE DEFAULT CHARSET=latin1 1573ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1574SHOW TABLES; 1575Tables_in_test 1576t1 1577SHOW CREATE TABLE t1; 1578Table Create Table 1579t1 CREATE TABLE `t1` ( 1580 `c1` double NOT NULL, 1581 KEY `c1` (`c1`) USING BTREE 1582) ENGINE=ENGINE DEFAULT CHARSET=latin1 1583DROP TABLE t1; 1584SHOW TABLES; 1585Tables_in_test 1586CREATE TABLE t1(c1 DOUBLE NOT NULL); 1587SHOW TABLES; 1588Tables_in_test 1589t1 1590SHOW CREATE TABLE t1; 1591Table Create Table 1592t1 CREATE TABLE `t1` ( 1593 `c1` double NOT NULL 1594) ENGINE=ENGINE DEFAULT CHARSET=latin1 1595ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1596SHOW TABLES; 1597Tables_in_test 1598t1 1599SHOW CREATE TABLE t1; 1600Table Create Table 1601t1 CREATE TABLE `t1` ( 1602 `c1` double NOT NULL, 1603 KEY `c1` (`c1`) USING BTREE 1604) ENGINE=ENGINE DEFAULT CHARSET=latin1 1605DROP TABLE t1; 1606SHOW TABLES; 1607Tables_in_test 1608CREATE TABLE t1(c1 FLOAT NOT NULL); 1609SHOW TABLES; 1610Tables_in_test 1611t1 1612SHOW CREATE TABLE t1; 1613Table Create Table 1614t1 CREATE TABLE `t1` ( 1615 `c1` float NOT NULL 1616) ENGINE=ENGINE DEFAULT CHARSET=latin1 1617ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1618SHOW TABLES; 1619Tables_in_test 1620t1 1621SHOW CREATE TABLE t1; 1622Table Create Table 1623t1 CREATE TABLE `t1` ( 1624 `c1` float NOT NULL, 1625 KEY `c1` (`c1`) USING BTREE 1626) ENGINE=ENGINE DEFAULT CHARSET=latin1 1627DROP TABLE t1; 1628SHOW TABLES; 1629Tables_in_test 1630CREATE TABLE t1(c1 DECIMAL NOT NULL); 1631SHOW TABLES; 1632Tables_in_test 1633t1 1634SHOW CREATE TABLE t1; 1635Table Create Table 1636t1 CREATE TABLE `t1` ( 1637 `c1` decimal(10,0) NOT NULL 1638) ENGINE=ENGINE DEFAULT CHARSET=latin1 1639ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1640SHOW TABLES; 1641Tables_in_test 1642t1 1643SHOW CREATE TABLE t1; 1644Table Create Table 1645t1 CREATE TABLE `t1` ( 1646 `c1` decimal(10,0) NOT NULL, 1647 KEY `c1` (`c1`) USING BTREE 1648) ENGINE=ENGINE DEFAULT CHARSET=latin1 1649DROP TABLE t1; 1650SHOW TABLES; 1651Tables_in_test 1652CREATE TABLE t1(c1 NUMERIC NOT NULL); 1653SHOW TABLES; 1654Tables_in_test 1655t1 1656SHOW CREATE TABLE t1; 1657Table Create Table 1658t1 CREATE TABLE `t1` ( 1659 `c1` decimal(10,0) NOT NULL 1660) ENGINE=ENGINE DEFAULT CHARSET=latin1 1661ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1662SHOW TABLES; 1663Tables_in_test 1664t1 1665SHOW CREATE TABLE t1; 1666Table Create Table 1667t1 CREATE TABLE `t1` ( 1668 `c1` decimal(10,0) NOT NULL, 1669 KEY `c1` (`c1`) USING BTREE 1670) ENGINE=ENGINE DEFAULT CHARSET=latin1 1671DROP TABLE t1; 1672SHOW TABLES; 1673Tables_in_test 1674CREATE TABLE t1(c1 DATE NOT NULL); 1675SHOW TABLES; 1676Tables_in_test 1677t1 1678SHOW CREATE TABLE t1; 1679Table Create Table 1680t1 CREATE TABLE `t1` ( 1681 `c1` date NOT NULL 1682) ENGINE=ENGINE DEFAULT CHARSET=latin1 1683ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1684SHOW TABLES; 1685Tables_in_test 1686t1 1687SHOW CREATE TABLE t1; 1688Table Create Table 1689t1 CREATE TABLE `t1` ( 1690 `c1` date NOT NULL, 1691 KEY `c1` (`c1`) USING BTREE 1692) ENGINE=ENGINE DEFAULT CHARSET=latin1 1693DROP TABLE t1; 1694SHOW TABLES; 1695Tables_in_test 1696CREATE TABLE t1(c1 TIME NOT NULL); 1697SHOW TABLES; 1698Tables_in_test 1699t1 1700SHOW CREATE TABLE t1; 1701Table Create Table 1702t1 CREATE TABLE `t1` ( 1703 `c1` time NOT NULL 1704) ENGINE=ENGINE DEFAULT CHARSET=latin1 1705ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1706SHOW TABLES; 1707Tables_in_test 1708t1 1709SHOW CREATE TABLE t1; 1710Table Create Table 1711t1 CREATE TABLE `t1` ( 1712 `c1` time NOT NULL, 1713 KEY `c1` (`c1`) USING BTREE 1714) ENGINE=ENGINE DEFAULT CHARSET=latin1 1715DROP TABLE t1; 1716SHOW TABLES; 1717Tables_in_test 1718CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 1719SHOW TABLES; 1720Tables_in_test 1721t1 1722SHOW CREATE TABLE t1; 1723Table Create Table 1724t1 CREATE TABLE `t1` ( 1725 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 1726) ENGINE=ENGINE DEFAULT CHARSET=latin1 1727ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1728SHOW TABLES; 1729Tables_in_test 1730t1 1731SHOW CREATE TABLE t1; 1732Table Create Table 1733t1 CREATE TABLE `t1` ( 1734 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 1735 KEY `c1` (`c1`) USING BTREE 1736) ENGINE=ENGINE DEFAULT CHARSET=latin1 1737DROP TABLE t1; 1738SHOW TABLES; 1739Tables_in_test 1740CREATE TABLE t1(c1 YEAR NOT NULL); 1741SHOW TABLES; 1742Tables_in_test 1743t1 1744SHOW CREATE TABLE t1; 1745Table Create Table 1746t1 CREATE TABLE `t1` ( 1747 `c1` year(4) NOT NULL 1748) ENGINE=ENGINE DEFAULT CHARSET=latin1 1749ALTER TABLE t1 ADD INDEX USING BTREE (c1); 1750SHOW TABLES; 1751Tables_in_test 1752t1 1753SHOW CREATE TABLE t1; 1754Table Create Table 1755t1 CREATE TABLE `t1` ( 1756 `c1` year(4) NOT NULL, 1757 KEY `c1` (`c1`) USING BTREE 1758) ENGINE=ENGINE DEFAULT CHARSET=latin1 1759DROP TABLE t1; 1760SHOW TABLES; 1761Tables_in_test 1762CREATE TABLE t1(c1 BIT NOT NULL); 1763SHOW TABLES; 1764Tables_in_test 1765t1 1766SHOW CREATE TABLE t1; 1767Table Create Table 1768t1 CREATE TABLE `t1` ( 1769 `c1` bit(1) NOT NULL 1770) ENGINE=ENGINE DEFAULT CHARSET=latin1 1771ALTER TABLE t1 ADD INDEX USING HASH (c1); 1772SHOW TABLES; 1773Tables_in_test 1774t1 1775SHOW CREATE TABLE t1; 1776Table Create Table 1777t1 CREATE TABLE `t1` ( 1778 `c1` bit(1) NOT NULL, 1779 KEY `c1` (`c1`) USING HASH 1780) ENGINE=ENGINE DEFAULT CHARSET=latin1 1781DROP TABLE t1; 1782SHOW TABLES; 1783Tables_in_test 1784CREATE TABLE t1(c1 TINYINT NOT NULL); 1785SHOW TABLES; 1786Tables_in_test 1787t1 1788SHOW CREATE TABLE t1; 1789Table Create Table 1790t1 CREATE TABLE `t1` ( 1791 `c1` tinyint(4) NOT NULL 1792) ENGINE=ENGINE DEFAULT CHARSET=latin1 1793ALTER TABLE t1 ADD INDEX USING HASH (c1); 1794SHOW TABLES; 1795Tables_in_test 1796t1 1797SHOW CREATE TABLE t1; 1798Table Create Table 1799t1 CREATE TABLE `t1` ( 1800 `c1` tinyint(4) NOT NULL, 1801 KEY `c1` (`c1`) USING HASH 1802) ENGINE=ENGINE DEFAULT CHARSET=latin1 1803DROP TABLE t1; 1804SHOW TABLES; 1805Tables_in_test 1806CREATE TABLE t1(c1 SMALLINT NOT NULL); 1807SHOW TABLES; 1808Tables_in_test 1809t1 1810SHOW CREATE TABLE t1; 1811Table Create Table 1812t1 CREATE TABLE `t1` ( 1813 `c1` smallint(6) NOT NULL 1814) ENGINE=ENGINE DEFAULT CHARSET=latin1 1815ALTER TABLE t1 ADD INDEX USING HASH (c1); 1816SHOW TABLES; 1817Tables_in_test 1818t1 1819SHOW CREATE TABLE t1; 1820Table Create Table 1821t1 CREATE TABLE `t1` ( 1822 `c1` smallint(6) NOT NULL, 1823 KEY `c1` (`c1`) USING HASH 1824) ENGINE=ENGINE DEFAULT CHARSET=latin1 1825DROP TABLE t1; 1826SHOW TABLES; 1827Tables_in_test 1828CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1829SHOW TABLES; 1830Tables_in_test 1831t1 1832SHOW CREATE TABLE t1; 1833Table Create Table 1834t1 CREATE TABLE `t1` ( 1835 `c1` mediumint(9) NOT NULL 1836) ENGINE=ENGINE DEFAULT CHARSET=latin1 1837ALTER TABLE t1 ADD INDEX USING HASH (c1); 1838SHOW TABLES; 1839Tables_in_test 1840t1 1841SHOW CREATE TABLE t1; 1842Table Create Table 1843t1 CREATE TABLE `t1` ( 1844 `c1` mediumint(9) NOT NULL, 1845 KEY `c1` (`c1`) USING HASH 1846) ENGINE=ENGINE DEFAULT CHARSET=latin1 1847DROP TABLE t1; 1848SHOW TABLES; 1849Tables_in_test 1850CREATE TABLE t1(c1 INT NOT NULL); 1851SHOW TABLES; 1852Tables_in_test 1853t1 1854SHOW CREATE TABLE t1; 1855Table Create Table 1856t1 CREATE TABLE `t1` ( 1857 `c1` int(11) NOT NULL 1858) ENGINE=ENGINE DEFAULT CHARSET=latin1 1859ALTER TABLE t1 ADD INDEX USING HASH (c1); 1860SHOW TABLES; 1861Tables_in_test 1862t1 1863SHOW CREATE TABLE t1; 1864Table Create Table 1865t1 CREATE TABLE `t1` ( 1866 `c1` int(11) NOT NULL, 1867 KEY `c1` (`c1`) USING HASH 1868) ENGINE=ENGINE DEFAULT CHARSET=latin1 1869DROP TABLE t1; 1870SHOW TABLES; 1871Tables_in_test 1872CREATE TABLE t1(c1 INTEGER NOT NULL); 1873SHOW TABLES; 1874Tables_in_test 1875t1 1876SHOW CREATE TABLE t1; 1877Table Create Table 1878t1 CREATE TABLE `t1` ( 1879 `c1` int(11) NOT NULL 1880) ENGINE=ENGINE DEFAULT CHARSET=latin1 1881ALTER TABLE t1 ADD INDEX USING HASH (c1); 1882SHOW TABLES; 1883Tables_in_test 1884t1 1885SHOW CREATE TABLE t1; 1886Table Create Table 1887t1 CREATE TABLE `t1` ( 1888 `c1` int(11) NOT NULL, 1889 KEY `c1` (`c1`) USING HASH 1890) ENGINE=ENGINE DEFAULT CHARSET=latin1 1891DROP TABLE t1; 1892SHOW TABLES; 1893Tables_in_test 1894CREATE TABLE t1(c1 BIGINT NOT NULL); 1895SHOW TABLES; 1896Tables_in_test 1897t1 1898SHOW CREATE TABLE t1; 1899Table Create Table 1900t1 CREATE TABLE `t1` ( 1901 `c1` bigint(20) NOT NULL 1902) ENGINE=ENGINE DEFAULT CHARSET=latin1 1903ALTER TABLE t1 ADD INDEX USING HASH (c1); 1904SHOW TABLES; 1905Tables_in_test 1906t1 1907SHOW CREATE TABLE t1; 1908Table Create Table 1909t1 CREATE TABLE `t1` ( 1910 `c1` bigint(20) NOT NULL, 1911 KEY `c1` (`c1`) USING HASH 1912) ENGINE=ENGINE DEFAULT CHARSET=latin1 1913DROP TABLE t1; 1914SHOW TABLES; 1915Tables_in_test 1916CREATE TABLE t1(c1 REAL NOT NULL); 1917SHOW TABLES; 1918Tables_in_test 1919t1 1920SHOW CREATE TABLE t1; 1921Table Create Table 1922t1 CREATE TABLE `t1` ( 1923 `c1` double NOT NULL 1924) ENGINE=ENGINE DEFAULT CHARSET=latin1 1925ALTER TABLE t1 ADD INDEX USING HASH (c1); 1926SHOW TABLES; 1927Tables_in_test 1928t1 1929SHOW CREATE TABLE t1; 1930Table Create Table 1931t1 CREATE TABLE `t1` ( 1932 `c1` double NOT NULL, 1933 KEY `c1` (`c1`) USING HASH 1934) ENGINE=ENGINE DEFAULT CHARSET=latin1 1935DROP TABLE t1; 1936SHOW TABLES; 1937Tables_in_test 1938CREATE TABLE t1(c1 DOUBLE NOT NULL); 1939SHOW TABLES; 1940Tables_in_test 1941t1 1942SHOW CREATE TABLE t1; 1943Table Create Table 1944t1 CREATE TABLE `t1` ( 1945 `c1` double NOT NULL 1946) ENGINE=ENGINE DEFAULT CHARSET=latin1 1947ALTER TABLE t1 ADD INDEX USING HASH (c1); 1948SHOW TABLES; 1949Tables_in_test 1950t1 1951SHOW CREATE TABLE t1; 1952Table Create Table 1953t1 CREATE TABLE `t1` ( 1954 `c1` double NOT NULL, 1955 KEY `c1` (`c1`) USING HASH 1956) ENGINE=ENGINE DEFAULT CHARSET=latin1 1957DROP TABLE t1; 1958SHOW TABLES; 1959Tables_in_test 1960CREATE TABLE t1(c1 FLOAT NOT NULL); 1961SHOW TABLES; 1962Tables_in_test 1963t1 1964SHOW CREATE TABLE t1; 1965Table Create Table 1966t1 CREATE TABLE `t1` ( 1967 `c1` float NOT NULL 1968) ENGINE=ENGINE DEFAULT CHARSET=latin1 1969ALTER TABLE t1 ADD INDEX USING HASH (c1); 1970SHOW TABLES; 1971Tables_in_test 1972t1 1973SHOW CREATE TABLE t1; 1974Table Create Table 1975t1 CREATE TABLE `t1` ( 1976 `c1` float NOT NULL, 1977 KEY `c1` (`c1`) USING HASH 1978) ENGINE=ENGINE DEFAULT CHARSET=latin1 1979DROP TABLE t1; 1980SHOW TABLES; 1981Tables_in_test 1982CREATE TABLE t1(c1 DECIMAL NOT NULL); 1983SHOW TABLES; 1984Tables_in_test 1985t1 1986SHOW CREATE TABLE t1; 1987Table Create Table 1988t1 CREATE TABLE `t1` ( 1989 `c1` decimal(10,0) NOT NULL 1990) ENGINE=ENGINE DEFAULT CHARSET=latin1 1991ALTER TABLE t1 ADD INDEX USING HASH (c1); 1992SHOW TABLES; 1993Tables_in_test 1994t1 1995SHOW CREATE TABLE t1; 1996Table Create Table 1997t1 CREATE TABLE `t1` ( 1998 `c1` decimal(10,0) NOT NULL, 1999 KEY `c1` (`c1`) USING HASH 2000) ENGINE=ENGINE DEFAULT CHARSET=latin1 2001DROP TABLE t1; 2002SHOW TABLES; 2003Tables_in_test 2004CREATE TABLE t1(c1 NUMERIC NOT NULL); 2005SHOW TABLES; 2006Tables_in_test 2007t1 2008SHOW CREATE TABLE t1; 2009Table Create Table 2010t1 CREATE TABLE `t1` ( 2011 `c1` decimal(10,0) NOT NULL 2012) ENGINE=ENGINE DEFAULT CHARSET=latin1 2013ALTER TABLE t1 ADD INDEX USING HASH (c1); 2014SHOW TABLES; 2015Tables_in_test 2016t1 2017SHOW CREATE TABLE t1; 2018Table Create Table 2019t1 CREATE TABLE `t1` ( 2020 `c1` decimal(10,0) NOT NULL, 2021 KEY `c1` (`c1`) USING HASH 2022) ENGINE=ENGINE DEFAULT CHARSET=latin1 2023DROP TABLE t1; 2024SHOW TABLES; 2025Tables_in_test 2026CREATE TABLE t1(c1 DATE NOT NULL); 2027SHOW TABLES; 2028Tables_in_test 2029t1 2030SHOW CREATE TABLE t1; 2031Table Create Table 2032t1 CREATE TABLE `t1` ( 2033 `c1` date NOT NULL 2034) ENGINE=ENGINE DEFAULT CHARSET=latin1 2035ALTER TABLE t1 ADD INDEX USING HASH (c1); 2036SHOW TABLES; 2037Tables_in_test 2038t1 2039SHOW CREATE TABLE t1; 2040Table Create Table 2041t1 CREATE TABLE `t1` ( 2042 `c1` date NOT NULL, 2043 KEY `c1` (`c1`) USING HASH 2044) ENGINE=ENGINE DEFAULT CHARSET=latin1 2045DROP TABLE t1; 2046SHOW TABLES; 2047Tables_in_test 2048CREATE TABLE t1(c1 TIME NOT NULL); 2049SHOW TABLES; 2050Tables_in_test 2051t1 2052SHOW CREATE TABLE t1; 2053Table Create Table 2054t1 CREATE TABLE `t1` ( 2055 `c1` time NOT NULL 2056) ENGINE=ENGINE DEFAULT CHARSET=latin1 2057ALTER TABLE t1 ADD INDEX USING HASH (c1); 2058SHOW TABLES; 2059Tables_in_test 2060t1 2061SHOW CREATE TABLE t1; 2062Table Create Table 2063t1 CREATE TABLE `t1` ( 2064 `c1` time NOT NULL, 2065 KEY `c1` (`c1`) USING HASH 2066) ENGINE=ENGINE DEFAULT CHARSET=latin1 2067DROP TABLE t1; 2068SHOW TABLES; 2069Tables_in_test 2070CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2071SHOW TABLES; 2072Tables_in_test 2073t1 2074SHOW CREATE TABLE t1; 2075Table Create Table 2076t1 CREATE TABLE `t1` ( 2077 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 2078) ENGINE=ENGINE DEFAULT CHARSET=latin1 2079ALTER TABLE t1 ADD INDEX USING HASH (c1); 2080SHOW TABLES; 2081Tables_in_test 2082t1 2083SHOW CREATE TABLE t1; 2084Table Create Table 2085t1 CREATE TABLE `t1` ( 2086 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 2087 KEY `c1` (`c1`) USING HASH 2088) ENGINE=ENGINE DEFAULT CHARSET=latin1 2089DROP TABLE t1; 2090SHOW TABLES; 2091Tables_in_test 2092CREATE TABLE t1(c1 YEAR NOT NULL); 2093SHOW TABLES; 2094Tables_in_test 2095t1 2096SHOW CREATE TABLE t1; 2097Table Create Table 2098t1 CREATE TABLE `t1` ( 2099 `c1` year(4) NOT NULL 2100) ENGINE=ENGINE DEFAULT CHARSET=latin1 2101ALTER TABLE t1 ADD INDEX USING HASH (c1); 2102SHOW TABLES; 2103Tables_in_test 2104t1 2105SHOW CREATE TABLE t1; 2106Table Create Table 2107t1 CREATE TABLE `t1` ( 2108 `c1` year(4) NOT NULL, 2109 KEY `c1` (`c1`) USING HASH 2110) ENGINE=ENGINE DEFAULT CHARSET=latin1 2111DROP TABLE t1; 2112SHOW TABLES; 2113Tables_in_test 2114CREATE TABLE t1(c1 BIT NOT NULL); 2115SHOW TABLES; 2116Tables_in_test 2117t1 2118SHOW CREATE TABLE t1; 2119Table Create Table 2120t1 CREATE TABLE `t1` ( 2121 `c1` bit(1) NOT NULL 2122) ENGINE=ENGINE DEFAULT CHARSET=latin1 2123ALTER TABLE t1 ADD KEY i1 (c1); 2124SHOW TABLES; 2125Tables_in_test 2126t1 2127SHOW CREATE TABLE t1; 2128Table Create Table 2129t1 CREATE TABLE `t1` ( 2130 `c1` bit(1) NOT NULL, 2131 KEY `i1` (`c1`) 2132) ENGINE=ENGINE DEFAULT CHARSET=latin1 2133DROP TABLE t1; 2134SHOW TABLES; 2135Tables_in_test 2136CREATE TABLE t1(c1 TINYINT NOT NULL); 2137SHOW TABLES; 2138Tables_in_test 2139t1 2140SHOW CREATE TABLE t1; 2141Table Create Table 2142t1 CREATE TABLE `t1` ( 2143 `c1` tinyint(4) NOT NULL 2144) ENGINE=ENGINE DEFAULT CHARSET=latin1 2145ALTER TABLE t1 ADD KEY i1 (c1); 2146SHOW TABLES; 2147Tables_in_test 2148t1 2149SHOW CREATE TABLE t1; 2150Table Create Table 2151t1 CREATE TABLE `t1` ( 2152 `c1` tinyint(4) NOT NULL, 2153 KEY `i1` (`c1`) 2154) ENGINE=ENGINE DEFAULT CHARSET=latin1 2155DROP TABLE t1; 2156SHOW TABLES; 2157Tables_in_test 2158CREATE TABLE t1(c1 SMALLINT NOT NULL); 2159SHOW TABLES; 2160Tables_in_test 2161t1 2162SHOW CREATE TABLE t1; 2163Table Create Table 2164t1 CREATE TABLE `t1` ( 2165 `c1` smallint(6) NOT NULL 2166) ENGINE=ENGINE DEFAULT CHARSET=latin1 2167ALTER TABLE t1 ADD KEY i1 (c1); 2168SHOW TABLES; 2169Tables_in_test 2170t1 2171SHOW CREATE TABLE t1; 2172Table Create Table 2173t1 CREATE TABLE `t1` ( 2174 `c1` smallint(6) NOT NULL, 2175 KEY `i1` (`c1`) 2176) ENGINE=ENGINE DEFAULT CHARSET=latin1 2177DROP TABLE t1; 2178SHOW TABLES; 2179Tables_in_test 2180CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2181SHOW TABLES; 2182Tables_in_test 2183t1 2184SHOW CREATE TABLE t1; 2185Table Create Table 2186t1 CREATE TABLE `t1` ( 2187 `c1` mediumint(9) NOT NULL 2188) ENGINE=ENGINE DEFAULT CHARSET=latin1 2189ALTER TABLE t1 ADD KEY i1 (c1); 2190SHOW TABLES; 2191Tables_in_test 2192t1 2193SHOW CREATE TABLE t1; 2194Table Create Table 2195t1 CREATE TABLE `t1` ( 2196 `c1` mediumint(9) NOT NULL, 2197 KEY `i1` (`c1`) 2198) ENGINE=ENGINE DEFAULT CHARSET=latin1 2199DROP TABLE t1; 2200SHOW TABLES; 2201Tables_in_test 2202CREATE TABLE t1(c1 INT NOT NULL); 2203SHOW TABLES; 2204Tables_in_test 2205t1 2206SHOW CREATE TABLE t1; 2207Table Create Table 2208t1 CREATE TABLE `t1` ( 2209 `c1` int(11) NOT NULL 2210) ENGINE=ENGINE DEFAULT CHARSET=latin1 2211ALTER TABLE t1 ADD KEY i1 (c1); 2212SHOW TABLES; 2213Tables_in_test 2214t1 2215SHOW CREATE TABLE t1; 2216Table Create Table 2217t1 CREATE TABLE `t1` ( 2218 `c1` int(11) NOT NULL, 2219 KEY `i1` (`c1`) 2220) ENGINE=ENGINE DEFAULT CHARSET=latin1 2221DROP TABLE t1; 2222SHOW TABLES; 2223Tables_in_test 2224CREATE TABLE t1(c1 INTEGER NOT NULL); 2225SHOW TABLES; 2226Tables_in_test 2227t1 2228SHOW CREATE TABLE t1; 2229Table Create Table 2230t1 CREATE TABLE `t1` ( 2231 `c1` int(11) NOT NULL 2232) ENGINE=ENGINE DEFAULT CHARSET=latin1 2233ALTER TABLE t1 ADD KEY i1 (c1); 2234SHOW TABLES; 2235Tables_in_test 2236t1 2237SHOW CREATE TABLE t1; 2238Table Create Table 2239t1 CREATE TABLE `t1` ( 2240 `c1` int(11) NOT NULL, 2241 KEY `i1` (`c1`) 2242) ENGINE=ENGINE DEFAULT CHARSET=latin1 2243DROP TABLE t1; 2244SHOW TABLES; 2245Tables_in_test 2246CREATE TABLE t1(c1 BIGINT NOT NULL); 2247SHOW TABLES; 2248Tables_in_test 2249t1 2250SHOW CREATE TABLE t1; 2251Table Create Table 2252t1 CREATE TABLE `t1` ( 2253 `c1` bigint(20) NOT NULL 2254) ENGINE=ENGINE DEFAULT CHARSET=latin1 2255ALTER TABLE t1 ADD KEY i1 (c1); 2256SHOW TABLES; 2257Tables_in_test 2258t1 2259SHOW CREATE TABLE t1; 2260Table Create Table 2261t1 CREATE TABLE `t1` ( 2262 `c1` bigint(20) NOT NULL, 2263 KEY `i1` (`c1`) 2264) ENGINE=ENGINE DEFAULT CHARSET=latin1 2265DROP TABLE t1; 2266SHOW TABLES; 2267Tables_in_test 2268CREATE TABLE t1(c1 REAL NOT NULL); 2269SHOW TABLES; 2270Tables_in_test 2271t1 2272SHOW CREATE TABLE t1; 2273Table Create Table 2274t1 CREATE TABLE `t1` ( 2275 `c1` double NOT NULL 2276) ENGINE=ENGINE DEFAULT CHARSET=latin1 2277ALTER TABLE t1 ADD KEY i1 (c1); 2278SHOW TABLES; 2279Tables_in_test 2280t1 2281SHOW CREATE TABLE t1; 2282Table Create Table 2283t1 CREATE TABLE `t1` ( 2284 `c1` double NOT NULL, 2285 KEY `i1` (`c1`) 2286) ENGINE=ENGINE DEFAULT CHARSET=latin1 2287DROP TABLE t1; 2288SHOW TABLES; 2289Tables_in_test 2290CREATE TABLE t1(c1 DOUBLE NOT NULL); 2291SHOW TABLES; 2292Tables_in_test 2293t1 2294SHOW CREATE TABLE t1; 2295Table Create Table 2296t1 CREATE TABLE `t1` ( 2297 `c1` double NOT NULL 2298) ENGINE=ENGINE DEFAULT CHARSET=latin1 2299ALTER TABLE t1 ADD KEY i1 (c1); 2300SHOW TABLES; 2301Tables_in_test 2302t1 2303SHOW CREATE TABLE t1; 2304Table Create Table 2305t1 CREATE TABLE `t1` ( 2306 `c1` double NOT NULL, 2307 KEY `i1` (`c1`) 2308) ENGINE=ENGINE DEFAULT CHARSET=latin1 2309DROP TABLE t1; 2310SHOW TABLES; 2311Tables_in_test 2312CREATE TABLE t1(c1 FLOAT NOT NULL); 2313SHOW TABLES; 2314Tables_in_test 2315t1 2316SHOW CREATE TABLE t1; 2317Table Create Table 2318t1 CREATE TABLE `t1` ( 2319 `c1` float NOT NULL 2320) ENGINE=ENGINE DEFAULT CHARSET=latin1 2321ALTER TABLE t1 ADD KEY i1 (c1); 2322SHOW TABLES; 2323Tables_in_test 2324t1 2325SHOW CREATE TABLE t1; 2326Table Create Table 2327t1 CREATE TABLE `t1` ( 2328 `c1` float NOT NULL, 2329 KEY `i1` (`c1`) 2330) ENGINE=ENGINE DEFAULT CHARSET=latin1 2331DROP TABLE t1; 2332SHOW TABLES; 2333Tables_in_test 2334CREATE TABLE t1(c1 DECIMAL NOT NULL); 2335SHOW TABLES; 2336Tables_in_test 2337t1 2338SHOW CREATE TABLE t1; 2339Table Create Table 2340t1 CREATE TABLE `t1` ( 2341 `c1` decimal(10,0) NOT NULL 2342) ENGINE=ENGINE DEFAULT CHARSET=latin1 2343ALTER TABLE t1 ADD KEY i1 (c1); 2344SHOW TABLES; 2345Tables_in_test 2346t1 2347SHOW CREATE TABLE t1; 2348Table Create Table 2349t1 CREATE TABLE `t1` ( 2350 `c1` decimal(10,0) NOT NULL, 2351 KEY `i1` (`c1`) 2352) ENGINE=ENGINE DEFAULT CHARSET=latin1 2353DROP TABLE t1; 2354SHOW TABLES; 2355Tables_in_test 2356CREATE TABLE t1(c1 NUMERIC NOT NULL); 2357SHOW TABLES; 2358Tables_in_test 2359t1 2360SHOW CREATE TABLE t1; 2361Table Create Table 2362t1 CREATE TABLE `t1` ( 2363 `c1` decimal(10,0) NOT NULL 2364) ENGINE=ENGINE DEFAULT CHARSET=latin1 2365ALTER TABLE t1 ADD KEY i1 (c1); 2366SHOW TABLES; 2367Tables_in_test 2368t1 2369SHOW CREATE TABLE t1; 2370Table Create Table 2371t1 CREATE TABLE `t1` ( 2372 `c1` decimal(10,0) NOT NULL, 2373 KEY `i1` (`c1`) 2374) ENGINE=ENGINE DEFAULT CHARSET=latin1 2375DROP TABLE t1; 2376SHOW TABLES; 2377Tables_in_test 2378CREATE TABLE t1(c1 DATE NOT NULL); 2379SHOW TABLES; 2380Tables_in_test 2381t1 2382SHOW CREATE TABLE t1; 2383Table Create Table 2384t1 CREATE TABLE `t1` ( 2385 `c1` date NOT NULL 2386) ENGINE=ENGINE DEFAULT CHARSET=latin1 2387ALTER TABLE t1 ADD KEY i1 (c1); 2388SHOW TABLES; 2389Tables_in_test 2390t1 2391SHOW CREATE TABLE t1; 2392Table Create Table 2393t1 CREATE TABLE `t1` ( 2394 `c1` date NOT NULL, 2395 KEY `i1` (`c1`) 2396) ENGINE=ENGINE DEFAULT CHARSET=latin1 2397DROP TABLE t1; 2398SHOW TABLES; 2399Tables_in_test 2400CREATE TABLE t1(c1 TIME NOT NULL); 2401SHOW TABLES; 2402Tables_in_test 2403t1 2404SHOW CREATE TABLE t1; 2405Table Create Table 2406t1 CREATE TABLE `t1` ( 2407 `c1` time NOT NULL 2408) ENGINE=ENGINE DEFAULT CHARSET=latin1 2409ALTER TABLE t1 ADD KEY i1 (c1); 2410SHOW TABLES; 2411Tables_in_test 2412t1 2413SHOW CREATE TABLE t1; 2414Table Create Table 2415t1 CREATE TABLE `t1` ( 2416 `c1` time NOT NULL, 2417 KEY `i1` (`c1`) 2418) ENGINE=ENGINE DEFAULT CHARSET=latin1 2419DROP TABLE t1; 2420SHOW TABLES; 2421Tables_in_test 2422CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2423SHOW TABLES; 2424Tables_in_test 2425t1 2426SHOW CREATE TABLE t1; 2427Table Create Table 2428t1 CREATE TABLE `t1` ( 2429 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 2430) ENGINE=ENGINE DEFAULT CHARSET=latin1 2431ALTER TABLE t1 ADD KEY i1 (c1); 2432SHOW TABLES; 2433Tables_in_test 2434t1 2435SHOW CREATE TABLE t1; 2436Table Create Table 2437t1 CREATE TABLE `t1` ( 2438 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 2439 KEY `i1` (`c1`) 2440) ENGINE=ENGINE DEFAULT CHARSET=latin1 2441DROP TABLE t1; 2442SHOW TABLES; 2443Tables_in_test 2444CREATE TABLE t1(c1 YEAR NOT NULL); 2445SHOW TABLES; 2446Tables_in_test 2447t1 2448SHOW CREATE TABLE t1; 2449Table Create Table 2450t1 CREATE TABLE `t1` ( 2451 `c1` year(4) NOT NULL 2452) ENGINE=ENGINE DEFAULT CHARSET=latin1 2453ALTER TABLE t1 ADD KEY i1 (c1); 2454SHOW TABLES; 2455Tables_in_test 2456t1 2457SHOW CREATE TABLE t1; 2458Table Create Table 2459t1 CREATE TABLE `t1` ( 2460 `c1` year(4) NOT NULL, 2461 KEY `i1` (`c1`) 2462) ENGINE=ENGINE DEFAULT CHARSET=latin1 2463DROP TABLE t1; 2464SHOW TABLES; 2465Tables_in_test 2466CREATE TABLE t1(c1 BIT NOT NULL); 2467SHOW TABLES; 2468Tables_in_test 2469t1 2470SHOW CREATE TABLE t1; 2471Table Create Table 2472t1 CREATE TABLE `t1` ( 2473 `c1` bit(1) NOT NULL 2474) ENGINE=ENGINE DEFAULT CHARSET=latin1 2475ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2476SHOW TABLES; 2477Tables_in_test 2478t1 2479SHOW CREATE TABLE t1; 2480Table Create Table 2481t1 CREATE TABLE `t1` ( 2482 `c1` bit(1) NOT NULL, 2483 KEY `i1` (`c1`) USING BTREE 2484) ENGINE=ENGINE DEFAULT CHARSET=latin1 2485DROP TABLE t1; 2486SHOW TABLES; 2487Tables_in_test 2488CREATE TABLE t1(c1 TINYINT NOT NULL); 2489SHOW TABLES; 2490Tables_in_test 2491t1 2492SHOW CREATE TABLE t1; 2493Table Create Table 2494t1 CREATE TABLE `t1` ( 2495 `c1` tinyint(4) NOT NULL 2496) ENGINE=ENGINE DEFAULT CHARSET=latin1 2497ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2498SHOW TABLES; 2499Tables_in_test 2500t1 2501SHOW CREATE TABLE t1; 2502Table Create Table 2503t1 CREATE TABLE `t1` ( 2504 `c1` tinyint(4) NOT NULL, 2505 KEY `i1` (`c1`) USING BTREE 2506) ENGINE=ENGINE DEFAULT CHARSET=latin1 2507DROP TABLE t1; 2508SHOW TABLES; 2509Tables_in_test 2510CREATE TABLE t1(c1 SMALLINT NOT NULL); 2511SHOW TABLES; 2512Tables_in_test 2513t1 2514SHOW CREATE TABLE t1; 2515Table Create Table 2516t1 CREATE TABLE `t1` ( 2517 `c1` smallint(6) NOT NULL 2518) ENGINE=ENGINE DEFAULT CHARSET=latin1 2519ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2520SHOW TABLES; 2521Tables_in_test 2522t1 2523SHOW CREATE TABLE t1; 2524Table Create Table 2525t1 CREATE TABLE `t1` ( 2526 `c1` smallint(6) NOT NULL, 2527 KEY `i1` (`c1`) USING BTREE 2528) ENGINE=ENGINE DEFAULT CHARSET=latin1 2529DROP TABLE t1; 2530SHOW TABLES; 2531Tables_in_test 2532CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2533SHOW TABLES; 2534Tables_in_test 2535t1 2536SHOW CREATE TABLE t1; 2537Table Create Table 2538t1 CREATE TABLE `t1` ( 2539 `c1` mediumint(9) NOT NULL 2540) ENGINE=ENGINE DEFAULT CHARSET=latin1 2541ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2542SHOW TABLES; 2543Tables_in_test 2544t1 2545SHOW CREATE TABLE t1; 2546Table Create Table 2547t1 CREATE TABLE `t1` ( 2548 `c1` mediumint(9) NOT NULL, 2549 KEY `i1` (`c1`) USING BTREE 2550) ENGINE=ENGINE DEFAULT CHARSET=latin1 2551DROP TABLE t1; 2552SHOW TABLES; 2553Tables_in_test 2554CREATE TABLE t1(c1 INT NOT NULL); 2555SHOW TABLES; 2556Tables_in_test 2557t1 2558SHOW CREATE TABLE t1; 2559Table Create Table 2560t1 CREATE TABLE `t1` ( 2561 `c1` int(11) NOT NULL 2562) ENGINE=ENGINE DEFAULT CHARSET=latin1 2563ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2564SHOW TABLES; 2565Tables_in_test 2566t1 2567SHOW CREATE TABLE t1; 2568Table Create Table 2569t1 CREATE TABLE `t1` ( 2570 `c1` int(11) NOT NULL, 2571 KEY `i1` (`c1`) USING BTREE 2572) ENGINE=ENGINE DEFAULT CHARSET=latin1 2573DROP TABLE t1; 2574SHOW TABLES; 2575Tables_in_test 2576CREATE TABLE t1(c1 INTEGER NOT NULL); 2577SHOW TABLES; 2578Tables_in_test 2579t1 2580SHOW CREATE TABLE t1; 2581Table Create Table 2582t1 CREATE TABLE `t1` ( 2583 `c1` int(11) NOT NULL 2584) ENGINE=ENGINE DEFAULT CHARSET=latin1 2585ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2586SHOW TABLES; 2587Tables_in_test 2588t1 2589SHOW CREATE TABLE t1; 2590Table Create Table 2591t1 CREATE TABLE `t1` ( 2592 `c1` int(11) NOT NULL, 2593 KEY `i1` (`c1`) USING BTREE 2594) ENGINE=ENGINE DEFAULT CHARSET=latin1 2595DROP TABLE t1; 2596SHOW TABLES; 2597Tables_in_test 2598CREATE TABLE t1(c1 BIGINT NOT NULL); 2599SHOW TABLES; 2600Tables_in_test 2601t1 2602SHOW CREATE TABLE t1; 2603Table Create Table 2604t1 CREATE TABLE `t1` ( 2605 `c1` bigint(20) NOT NULL 2606) ENGINE=ENGINE DEFAULT CHARSET=latin1 2607ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2608SHOW TABLES; 2609Tables_in_test 2610t1 2611SHOW CREATE TABLE t1; 2612Table Create Table 2613t1 CREATE TABLE `t1` ( 2614 `c1` bigint(20) NOT NULL, 2615 KEY `i1` (`c1`) USING BTREE 2616) ENGINE=ENGINE DEFAULT CHARSET=latin1 2617DROP TABLE t1; 2618SHOW TABLES; 2619Tables_in_test 2620CREATE TABLE t1(c1 REAL NOT NULL); 2621SHOW TABLES; 2622Tables_in_test 2623t1 2624SHOW CREATE TABLE t1; 2625Table Create Table 2626t1 CREATE TABLE `t1` ( 2627 `c1` double NOT NULL 2628) ENGINE=ENGINE DEFAULT CHARSET=latin1 2629ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2630SHOW TABLES; 2631Tables_in_test 2632t1 2633SHOW CREATE TABLE t1; 2634Table Create Table 2635t1 CREATE TABLE `t1` ( 2636 `c1` double NOT NULL, 2637 KEY `i1` (`c1`) USING BTREE 2638) ENGINE=ENGINE DEFAULT CHARSET=latin1 2639DROP TABLE t1; 2640SHOW TABLES; 2641Tables_in_test 2642CREATE TABLE t1(c1 DOUBLE NOT NULL); 2643SHOW TABLES; 2644Tables_in_test 2645t1 2646SHOW CREATE TABLE t1; 2647Table Create Table 2648t1 CREATE TABLE `t1` ( 2649 `c1` double NOT NULL 2650) ENGINE=ENGINE DEFAULT CHARSET=latin1 2651ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2652SHOW TABLES; 2653Tables_in_test 2654t1 2655SHOW CREATE TABLE t1; 2656Table Create Table 2657t1 CREATE TABLE `t1` ( 2658 `c1` double NOT NULL, 2659 KEY `i1` (`c1`) USING BTREE 2660) ENGINE=ENGINE DEFAULT CHARSET=latin1 2661DROP TABLE t1; 2662SHOW TABLES; 2663Tables_in_test 2664CREATE TABLE t1(c1 FLOAT NOT NULL); 2665SHOW TABLES; 2666Tables_in_test 2667t1 2668SHOW CREATE TABLE t1; 2669Table Create Table 2670t1 CREATE TABLE `t1` ( 2671 `c1` float NOT NULL 2672) ENGINE=ENGINE DEFAULT CHARSET=latin1 2673ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2674SHOW TABLES; 2675Tables_in_test 2676t1 2677SHOW CREATE TABLE t1; 2678Table Create Table 2679t1 CREATE TABLE `t1` ( 2680 `c1` float NOT NULL, 2681 KEY `i1` (`c1`) USING BTREE 2682) ENGINE=ENGINE DEFAULT CHARSET=latin1 2683DROP TABLE t1; 2684SHOW TABLES; 2685Tables_in_test 2686CREATE TABLE t1(c1 DECIMAL NOT NULL); 2687SHOW TABLES; 2688Tables_in_test 2689t1 2690SHOW CREATE TABLE t1; 2691Table Create Table 2692t1 CREATE TABLE `t1` ( 2693 `c1` decimal(10,0) NOT NULL 2694) ENGINE=ENGINE DEFAULT CHARSET=latin1 2695ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2696SHOW TABLES; 2697Tables_in_test 2698t1 2699SHOW CREATE TABLE t1; 2700Table Create Table 2701t1 CREATE TABLE `t1` ( 2702 `c1` decimal(10,0) NOT NULL, 2703 KEY `i1` (`c1`) USING BTREE 2704) ENGINE=ENGINE DEFAULT CHARSET=latin1 2705DROP TABLE t1; 2706SHOW TABLES; 2707Tables_in_test 2708CREATE TABLE t1(c1 NUMERIC NOT NULL); 2709SHOW TABLES; 2710Tables_in_test 2711t1 2712SHOW CREATE TABLE t1; 2713Table Create Table 2714t1 CREATE TABLE `t1` ( 2715 `c1` decimal(10,0) NOT NULL 2716) ENGINE=ENGINE DEFAULT CHARSET=latin1 2717ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2718SHOW TABLES; 2719Tables_in_test 2720t1 2721SHOW CREATE TABLE t1; 2722Table Create Table 2723t1 CREATE TABLE `t1` ( 2724 `c1` decimal(10,0) NOT NULL, 2725 KEY `i1` (`c1`) USING BTREE 2726) ENGINE=ENGINE DEFAULT CHARSET=latin1 2727DROP TABLE t1; 2728SHOW TABLES; 2729Tables_in_test 2730CREATE TABLE t1(c1 DATE NOT NULL); 2731SHOW TABLES; 2732Tables_in_test 2733t1 2734SHOW CREATE TABLE t1; 2735Table Create Table 2736t1 CREATE TABLE `t1` ( 2737 `c1` date NOT NULL 2738) ENGINE=ENGINE DEFAULT CHARSET=latin1 2739ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2740SHOW TABLES; 2741Tables_in_test 2742t1 2743SHOW CREATE TABLE t1; 2744Table Create Table 2745t1 CREATE TABLE `t1` ( 2746 `c1` date NOT NULL, 2747 KEY `i1` (`c1`) USING BTREE 2748) ENGINE=ENGINE DEFAULT CHARSET=latin1 2749DROP TABLE t1; 2750SHOW TABLES; 2751Tables_in_test 2752CREATE TABLE t1(c1 TIME NOT NULL); 2753SHOW TABLES; 2754Tables_in_test 2755t1 2756SHOW CREATE TABLE t1; 2757Table Create Table 2758t1 CREATE TABLE `t1` ( 2759 `c1` time NOT NULL 2760) ENGINE=ENGINE DEFAULT CHARSET=latin1 2761ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2762SHOW TABLES; 2763Tables_in_test 2764t1 2765SHOW CREATE TABLE t1; 2766Table Create Table 2767t1 CREATE TABLE `t1` ( 2768 `c1` time NOT NULL, 2769 KEY `i1` (`c1`) USING BTREE 2770) ENGINE=ENGINE DEFAULT CHARSET=latin1 2771DROP TABLE t1; 2772SHOW TABLES; 2773Tables_in_test 2774CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 2775SHOW TABLES; 2776Tables_in_test 2777t1 2778SHOW CREATE TABLE t1; 2779Table Create Table 2780t1 CREATE TABLE `t1` ( 2781 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 2782) ENGINE=ENGINE DEFAULT CHARSET=latin1 2783ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2784SHOW TABLES; 2785Tables_in_test 2786t1 2787SHOW CREATE TABLE t1; 2788Table Create Table 2789t1 CREATE TABLE `t1` ( 2790 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 2791 KEY `i1` (`c1`) USING BTREE 2792) ENGINE=ENGINE DEFAULT CHARSET=latin1 2793DROP TABLE t1; 2794SHOW TABLES; 2795Tables_in_test 2796CREATE TABLE t1(c1 YEAR NOT NULL); 2797SHOW TABLES; 2798Tables_in_test 2799t1 2800SHOW CREATE TABLE t1; 2801Table Create Table 2802t1 CREATE TABLE `t1` ( 2803 `c1` year(4) NOT NULL 2804) ENGINE=ENGINE DEFAULT CHARSET=latin1 2805ALTER TABLE t1 ADD KEY i1 USING BTREE (c1); 2806SHOW TABLES; 2807Tables_in_test 2808t1 2809SHOW CREATE TABLE t1; 2810Table Create Table 2811t1 CREATE TABLE `t1` ( 2812 `c1` year(4) NOT NULL, 2813 KEY `i1` (`c1`) USING BTREE 2814) ENGINE=ENGINE DEFAULT CHARSET=latin1 2815DROP TABLE t1; 2816SHOW TABLES; 2817Tables_in_test 2818CREATE TABLE t1(c1 BIT NOT NULL); 2819SHOW TABLES; 2820Tables_in_test 2821t1 2822SHOW CREATE TABLE t1; 2823Table Create Table 2824t1 CREATE TABLE `t1` ( 2825 `c1` bit(1) NOT NULL 2826) ENGINE=ENGINE DEFAULT CHARSET=latin1 2827ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 2828SHOW TABLES; 2829Tables_in_test 2830t1 2831SHOW CREATE TABLE t1; 2832Table Create Table 2833t1 CREATE TABLE `t1` ( 2834 `c1` bit(1) NOT NULL, 2835 KEY `i1` (`c1`) USING HASH 2836) ENGINE=ENGINE DEFAULT CHARSET=latin1 2837DROP TABLE t1; 2838SHOW TABLES; 2839Tables_in_test 2840CREATE TABLE t1(c1 TINYINT NOT NULL); 2841SHOW TABLES; 2842Tables_in_test 2843t1 2844SHOW CREATE TABLE t1; 2845Table Create Table 2846t1 CREATE TABLE `t1` ( 2847 `c1` tinyint(4) NOT NULL 2848) ENGINE=ENGINE DEFAULT CHARSET=latin1 2849ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 2850SHOW TABLES; 2851Tables_in_test 2852t1 2853SHOW CREATE TABLE t1; 2854Table Create Table 2855t1 CREATE TABLE `t1` ( 2856 `c1` tinyint(4) NOT NULL, 2857 KEY `i1` (`c1`) USING HASH 2858) ENGINE=ENGINE DEFAULT CHARSET=latin1 2859DROP TABLE t1; 2860SHOW TABLES; 2861Tables_in_test 2862CREATE TABLE t1(c1 SMALLINT NOT NULL); 2863SHOW TABLES; 2864Tables_in_test 2865t1 2866SHOW CREATE TABLE t1; 2867Table Create Table 2868t1 CREATE TABLE `t1` ( 2869 `c1` smallint(6) NOT NULL 2870) ENGINE=ENGINE DEFAULT CHARSET=latin1 2871ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 2872SHOW TABLES; 2873Tables_in_test 2874t1 2875SHOW CREATE TABLE t1; 2876Table Create Table 2877t1 CREATE TABLE `t1` ( 2878 `c1` smallint(6) NOT NULL, 2879 KEY `i1` (`c1`) USING HASH 2880) ENGINE=ENGINE DEFAULT CHARSET=latin1 2881DROP TABLE t1; 2882SHOW TABLES; 2883Tables_in_test 2884CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 2885SHOW TABLES; 2886Tables_in_test 2887t1 2888SHOW CREATE TABLE t1; 2889Table Create Table 2890t1 CREATE TABLE `t1` ( 2891 `c1` mediumint(9) NOT NULL 2892) ENGINE=ENGINE DEFAULT CHARSET=latin1 2893ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 2894SHOW TABLES; 2895Tables_in_test 2896t1 2897SHOW CREATE TABLE t1; 2898Table Create Table 2899t1 CREATE TABLE `t1` ( 2900 `c1` mediumint(9) NOT NULL, 2901 KEY `i1` (`c1`) USING HASH 2902) ENGINE=ENGINE DEFAULT CHARSET=latin1 2903DROP TABLE t1; 2904SHOW TABLES; 2905Tables_in_test 2906CREATE TABLE t1(c1 INT NOT NULL); 2907SHOW TABLES; 2908Tables_in_test 2909t1 2910SHOW CREATE TABLE t1; 2911Table Create Table 2912t1 CREATE TABLE `t1` ( 2913 `c1` int(11) NOT NULL 2914) ENGINE=ENGINE DEFAULT CHARSET=latin1 2915ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 2916SHOW TABLES; 2917Tables_in_test 2918t1 2919SHOW CREATE TABLE t1; 2920Table Create Table 2921t1 CREATE TABLE `t1` ( 2922 `c1` int(11) NOT NULL, 2923 KEY `i1` (`c1`) USING HASH 2924) ENGINE=ENGINE DEFAULT CHARSET=latin1 2925DROP TABLE t1; 2926SHOW TABLES; 2927Tables_in_test 2928CREATE TABLE t1(c1 INTEGER NOT NULL); 2929SHOW TABLES; 2930Tables_in_test 2931t1 2932SHOW CREATE TABLE t1; 2933Table Create Table 2934t1 CREATE TABLE `t1` ( 2935 `c1` int(11) NOT NULL 2936) ENGINE=ENGINE DEFAULT CHARSET=latin1 2937ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 2938SHOW TABLES; 2939Tables_in_test 2940t1 2941SHOW CREATE TABLE t1; 2942Table Create Table 2943t1 CREATE TABLE `t1` ( 2944 `c1` int(11) NOT NULL, 2945 KEY `i1` (`c1`) USING HASH 2946) ENGINE=ENGINE DEFAULT CHARSET=latin1 2947DROP TABLE t1; 2948SHOW TABLES; 2949Tables_in_test 2950CREATE TABLE t1(c1 BIGINT NOT NULL); 2951SHOW TABLES; 2952Tables_in_test 2953t1 2954SHOW CREATE TABLE t1; 2955Table Create Table 2956t1 CREATE TABLE `t1` ( 2957 `c1` bigint(20) NOT NULL 2958) ENGINE=ENGINE DEFAULT CHARSET=latin1 2959ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 2960SHOW TABLES; 2961Tables_in_test 2962t1 2963SHOW CREATE TABLE t1; 2964Table Create Table 2965t1 CREATE TABLE `t1` ( 2966 `c1` bigint(20) NOT NULL, 2967 KEY `i1` (`c1`) USING HASH 2968) ENGINE=ENGINE DEFAULT CHARSET=latin1 2969DROP TABLE t1; 2970SHOW TABLES; 2971Tables_in_test 2972CREATE TABLE t1(c1 REAL NOT NULL); 2973SHOW TABLES; 2974Tables_in_test 2975t1 2976SHOW CREATE TABLE t1; 2977Table Create Table 2978t1 CREATE TABLE `t1` ( 2979 `c1` double NOT NULL 2980) ENGINE=ENGINE DEFAULT CHARSET=latin1 2981ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 2982SHOW TABLES; 2983Tables_in_test 2984t1 2985SHOW CREATE TABLE t1; 2986Table Create Table 2987t1 CREATE TABLE `t1` ( 2988 `c1` double NOT NULL, 2989 KEY `i1` (`c1`) USING HASH 2990) ENGINE=ENGINE DEFAULT CHARSET=latin1 2991DROP TABLE t1; 2992SHOW TABLES; 2993Tables_in_test 2994CREATE TABLE t1(c1 DOUBLE NOT NULL); 2995SHOW TABLES; 2996Tables_in_test 2997t1 2998SHOW CREATE TABLE t1; 2999Table Create Table 3000t1 CREATE TABLE `t1` ( 3001 `c1` double NOT NULL 3002) ENGINE=ENGINE DEFAULT CHARSET=latin1 3003ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 3004SHOW TABLES; 3005Tables_in_test 3006t1 3007SHOW CREATE TABLE t1; 3008Table Create Table 3009t1 CREATE TABLE `t1` ( 3010 `c1` double NOT NULL, 3011 KEY `i1` (`c1`) USING HASH 3012) ENGINE=ENGINE DEFAULT CHARSET=latin1 3013DROP TABLE t1; 3014SHOW TABLES; 3015Tables_in_test 3016CREATE TABLE t1(c1 FLOAT NOT NULL); 3017SHOW TABLES; 3018Tables_in_test 3019t1 3020SHOW CREATE TABLE t1; 3021Table Create Table 3022t1 CREATE TABLE `t1` ( 3023 `c1` float NOT NULL 3024) ENGINE=ENGINE DEFAULT CHARSET=latin1 3025ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 3026SHOW TABLES; 3027Tables_in_test 3028t1 3029SHOW CREATE TABLE t1; 3030Table Create Table 3031t1 CREATE TABLE `t1` ( 3032 `c1` float NOT NULL, 3033 KEY `i1` (`c1`) USING HASH 3034) ENGINE=ENGINE DEFAULT CHARSET=latin1 3035DROP TABLE t1; 3036SHOW TABLES; 3037Tables_in_test 3038CREATE TABLE t1(c1 DECIMAL NOT NULL); 3039SHOW TABLES; 3040Tables_in_test 3041t1 3042SHOW CREATE TABLE t1; 3043Table Create Table 3044t1 CREATE TABLE `t1` ( 3045 `c1` decimal(10,0) NOT NULL 3046) ENGINE=ENGINE DEFAULT CHARSET=latin1 3047ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 3048SHOW TABLES; 3049Tables_in_test 3050t1 3051SHOW CREATE TABLE t1; 3052Table Create Table 3053t1 CREATE TABLE `t1` ( 3054 `c1` decimal(10,0) NOT NULL, 3055 KEY `i1` (`c1`) USING HASH 3056) ENGINE=ENGINE DEFAULT CHARSET=latin1 3057DROP TABLE t1; 3058SHOW TABLES; 3059Tables_in_test 3060CREATE TABLE t1(c1 NUMERIC NOT NULL); 3061SHOW TABLES; 3062Tables_in_test 3063t1 3064SHOW CREATE TABLE t1; 3065Table Create Table 3066t1 CREATE TABLE `t1` ( 3067 `c1` decimal(10,0) NOT NULL 3068) ENGINE=ENGINE DEFAULT CHARSET=latin1 3069ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 3070SHOW TABLES; 3071Tables_in_test 3072t1 3073SHOW CREATE TABLE t1; 3074Table Create Table 3075t1 CREATE TABLE `t1` ( 3076 `c1` decimal(10,0) NOT NULL, 3077 KEY `i1` (`c1`) USING HASH 3078) ENGINE=ENGINE DEFAULT CHARSET=latin1 3079DROP TABLE t1; 3080SHOW TABLES; 3081Tables_in_test 3082CREATE TABLE t1(c1 DATE NOT NULL); 3083SHOW TABLES; 3084Tables_in_test 3085t1 3086SHOW CREATE TABLE t1; 3087Table Create Table 3088t1 CREATE TABLE `t1` ( 3089 `c1` date NOT NULL 3090) ENGINE=ENGINE DEFAULT CHARSET=latin1 3091ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 3092SHOW TABLES; 3093Tables_in_test 3094t1 3095SHOW CREATE TABLE t1; 3096Table Create Table 3097t1 CREATE TABLE `t1` ( 3098 `c1` date NOT NULL, 3099 KEY `i1` (`c1`) USING HASH 3100) ENGINE=ENGINE DEFAULT CHARSET=latin1 3101DROP TABLE t1; 3102SHOW TABLES; 3103Tables_in_test 3104CREATE TABLE t1(c1 TIME NOT NULL); 3105SHOW TABLES; 3106Tables_in_test 3107t1 3108SHOW CREATE TABLE t1; 3109Table Create Table 3110t1 CREATE TABLE `t1` ( 3111 `c1` time NOT NULL 3112) ENGINE=ENGINE DEFAULT CHARSET=latin1 3113ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 3114SHOW TABLES; 3115Tables_in_test 3116t1 3117SHOW CREATE TABLE t1; 3118Table Create Table 3119t1 CREATE TABLE `t1` ( 3120 `c1` time NOT NULL, 3121 KEY `i1` (`c1`) USING HASH 3122) ENGINE=ENGINE DEFAULT CHARSET=latin1 3123DROP TABLE t1; 3124SHOW TABLES; 3125Tables_in_test 3126CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 3127SHOW TABLES; 3128Tables_in_test 3129t1 3130SHOW CREATE TABLE t1; 3131Table Create Table 3132t1 CREATE TABLE `t1` ( 3133 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 3134) ENGINE=ENGINE DEFAULT CHARSET=latin1 3135ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 3136SHOW TABLES; 3137Tables_in_test 3138t1 3139SHOW CREATE TABLE t1; 3140Table Create Table 3141t1 CREATE TABLE `t1` ( 3142 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 3143 KEY `i1` (`c1`) USING HASH 3144) ENGINE=ENGINE DEFAULT CHARSET=latin1 3145DROP TABLE t1; 3146SHOW TABLES; 3147Tables_in_test 3148CREATE TABLE t1(c1 YEAR NOT NULL); 3149SHOW TABLES; 3150Tables_in_test 3151t1 3152SHOW CREATE TABLE t1; 3153Table Create Table 3154t1 CREATE TABLE `t1` ( 3155 `c1` year(4) NOT NULL 3156) ENGINE=ENGINE DEFAULT CHARSET=latin1 3157ALTER TABLE t1 ADD KEY i1 USING HASH (c1); 3158SHOW TABLES; 3159Tables_in_test 3160t1 3161SHOW CREATE TABLE t1; 3162Table Create Table 3163t1 CREATE TABLE `t1` ( 3164 `c1` year(4) NOT NULL, 3165 KEY `i1` (`c1`) USING HASH 3166) ENGINE=ENGINE DEFAULT CHARSET=latin1 3167DROP TABLE t1; 3168SHOW TABLES; 3169Tables_in_test 3170CREATE TABLE t1(c1 BIT NOT NULL); 3171SHOW TABLES; 3172Tables_in_test 3173t1 3174SHOW CREATE TABLE t1; 3175Table Create Table 3176t1 CREATE TABLE `t1` ( 3177 `c1` bit(1) NOT NULL 3178) ENGINE=ENGINE DEFAULT CHARSET=latin1 3179ALTER TABLE t1 ADD INDEX i1 (c1); 3180SHOW TABLES; 3181Tables_in_test 3182t1 3183SHOW CREATE TABLE t1; 3184Table Create Table 3185t1 CREATE TABLE `t1` ( 3186 `c1` bit(1) NOT NULL, 3187 KEY `i1` (`c1`) 3188) ENGINE=ENGINE DEFAULT CHARSET=latin1 3189DROP TABLE t1; 3190SHOW TABLES; 3191Tables_in_test 3192CREATE TABLE t1(c1 TINYINT NOT NULL); 3193SHOW TABLES; 3194Tables_in_test 3195t1 3196SHOW CREATE TABLE t1; 3197Table Create Table 3198t1 CREATE TABLE `t1` ( 3199 `c1` tinyint(4) NOT NULL 3200) ENGINE=ENGINE DEFAULT CHARSET=latin1 3201ALTER TABLE t1 ADD INDEX i1 (c1); 3202SHOW TABLES; 3203Tables_in_test 3204t1 3205SHOW CREATE TABLE t1; 3206Table Create Table 3207t1 CREATE TABLE `t1` ( 3208 `c1` tinyint(4) NOT NULL, 3209 KEY `i1` (`c1`) 3210) ENGINE=ENGINE DEFAULT CHARSET=latin1 3211DROP TABLE t1; 3212SHOW TABLES; 3213Tables_in_test 3214CREATE TABLE t1(c1 SMALLINT NOT NULL); 3215SHOW TABLES; 3216Tables_in_test 3217t1 3218SHOW CREATE TABLE t1; 3219Table Create Table 3220t1 CREATE TABLE `t1` ( 3221 `c1` smallint(6) NOT NULL 3222) ENGINE=ENGINE DEFAULT CHARSET=latin1 3223ALTER TABLE t1 ADD INDEX i1 (c1); 3224SHOW TABLES; 3225Tables_in_test 3226t1 3227SHOW CREATE TABLE t1; 3228Table Create Table 3229t1 CREATE TABLE `t1` ( 3230 `c1` smallint(6) NOT NULL, 3231 KEY `i1` (`c1`) 3232) ENGINE=ENGINE DEFAULT CHARSET=latin1 3233DROP TABLE t1; 3234SHOW TABLES; 3235Tables_in_test 3236CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 3237SHOW TABLES; 3238Tables_in_test 3239t1 3240SHOW CREATE TABLE t1; 3241Table Create Table 3242t1 CREATE TABLE `t1` ( 3243 `c1` mediumint(9) NOT NULL 3244) ENGINE=ENGINE DEFAULT CHARSET=latin1 3245ALTER TABLE t1 ADD INDEX i1 (c1); 3246SHOW TABLES; 3247Tables_in_test 3248t1 3249SHOW CREATE TABLE t1; 3250Table Create Table 3251t1 CREATE TABLE `t1` ( 3252 `c1` mediumint(9) NOT NULL, 3253 KEY `i1` (`c1`) 3254) ENGINE=ENGINE DEFAULT CHARSET=latin1 3255DROP TABLE t1; 3256SHOW TABLES; 3257Tables_in_test 3258CREATE TABLE t1(c1 INT NOT NULL); 3259SHOW TABLES; 3260Tables_in_test 3261t1 3262SHOW CREATE TABLE t1; 3263Table Create Table 3264t1 CREATE TABLE `t1` ( 3265 `c1` int(11) NOT NULL 3266) ENGINE=ENGINE DEFAULT CHARSET=latin1 3267ALTER TABLE t1 ADD INDEX i1 (c1); 3268SHOW TABLES; 3269Tables_in_test 3270t1 3271SHOW CREATE TABLE t1; 3272Table Create Table 3273t1 CREATE TABLE `t1` ( 3274 `c1` int(11) NOT NULL, 3275 KEY `i1` (`c1`) 3276) ENGINE=ENGINE DEFAULT CHARSET=latin1 3277DROP TABLE t1; 3278SHOW TABLES; 3279Tables_in_test 3280CREATE TABLE t1(c1 INTEGER NOT NULL); 3281SHOW TABLES; 3282Tables_in_test 3283t1 3284SHOW CREATE TABLE t1; 3285Table Create Table 3286t1 CREATE TABLE `t1` ( 3287 `c1` int(11) NOT NULL 3288) ENGINE=ENGINE DEFAULT CHARSET=latin1 3289ALTER TABLE t1 ADD INDEX i1 (c1); 3290SHOW TABLES; 3291Tables_in_test 3292t1 3293SHOW CREATE TABLE t1; 3294Table Create Table 3295t1 CREATE TABLE `t1` ( 3296 `c1` int(11) NOT NULL, 3297 KEY `i1` (`c1`) 3298) ENGINE=ENGINE DEFAULT CHARSET=latin1 3299DROP TABLE t1; 3300SHOW TABLES; 3301Tables_in_test 3302CREATE TABLE t1(c1 BIGINT NOT NULL); 3303SHOW TABLES; 3304Tables_in_test 3305t1 3306SHOW CREATE TABLE t1; 3307Table Create Table 3308t1 CREATE TABLE `t1` ( 3309 `c1` bigint(20) NOT NULL 3310) ENGINE=ENGINE DEFAULT CHARSET=latin1 3311ALTER TABLE t1 ADD INDEX i1 (c1); 3312SHOW TABLES; 3313Tables_in_test 3314t1 3315SHOW CREATE TABLE t1; 3316Table Create Table 3317t1 CREATE TABLE `t1` ( 3318 `c1` bigint(20) NOT NULL, 3319 KEY `i1` (`c1`) 3320) ENGINE=ENGINE DEFAULT CHARSET=latin1 3321DROP TABLE t1; 3322SHOW TABLES; 3323Tables_in_test 3324CREATE TABLE t1(c1 REAL NOT NULL); 3325SHOW TABLES; 3326Tables_in_test 3327t1 3328SHOW CREATE TABLE t1; 3329Table Create Table 3330t1 CREATE TABLE `t1` ( 3331 `c1` double NOT NULL 3332) ENGINE=ENGINE DEFAULT CHARSET=latin1 3333ALTER TABLE t1 ADD INDEX i1 (c1); 3334SHOW TABLES; 3335Tables_in_test 3336t1 3337SHOW CREATE TABLE t1; 3338Table Create Table 3339t1 CREATE TABLE `t1` ( 3340 `c1` double NOT NULL, 3341 KEY `i1` (`c1`) 3342) ENGINE=ENGINE DEFAULT CHARSET=latin1 3343DROP TABLE t1; 3344SHOW TABLES; 3345Tables_in_test 3346CREATE TABLE t1(c1 DOUBLE NOT NULL); 3347SHOW TABLES; 3348Tables_in_test 3349t1 3350SHOW CREATE TABLE t1; 3351Table Create Table 3352t1 CREATE TABLE `t1` ( 3353 `c1` double NOT NULL 3354) ENGINE=ENGINE DEFAULT CHARSET=latin1 3355ALTER TABLE t1 ADD INDEX i1 (c1); 3356SHOW TABLES; 3357Tables_in_test 3358t1 3359SHOW CREATE TABLE t1; 3360Table Create Table 3361t1 CREATE TABLE `t1` ( 3362 `c1` double NOT NULL, 3363 KEY `i1` (`c1`) 3364) ENGINE=ENGINE DEFAULT CHARSET=latin1 3365DROP TABLE t1; 3366SHOW TABLES; 3367Tables_in_test 3368CREATE TABLE t1(c1 FLOAT NOT NULL); 3369SHOW TABLES; 3370Tables_in_test 3371t1 3372SHOW CREATE TABLE t1; 3373Table Create Table 3374t1 CREATE TABLE `t1` ( 3375 `c1` float NOT NULL 3376) ENGINE=ENGINE DEFAULT CHARSET=latin1 3377ALTER TABLE t1 ADD INDEX i1 (c1); 3378SHOW TABLES; 3379Tables_in_test 3380t1 3381SHOW CREATE TABLE t1; 3382Table Create Table 3383t1 CREATE TABLE `t1` ( 3384 `c1` float NOT NULL, 3385 KEY `i1` (`c1`) 3386) ENGINE=ENGINE DEFAULT CHARSET=latin1 3387DROP TABLE t1; 3388SHOW TABLES; 3389Tables_in_test 3390CREATE TABLE t1(c1 DECIMAL NOT NULL); 3391SHOW TABLES; 3392Tables_in_test 3393t1 3394SHOW CREATE TABLE t1; 3395Table Create Table 3396t1 CREATE TABLE `t1` ( 3397 `c1` decimal(10,0) NOT NULL 3398) ENGINE=ENGINE DEFAULT CHARSET=latin1 3399ALTER TABLE t1 ADD INDEX i1 (c1); 3400SHOW TABLES; 3401Tables_in_test 3402t1 3403SHOW CREATE TABLE t1; 3404Table Create Table 3405t1 CREATE TABLE `t1` ( 3406 `c1` decimal(10,0) NOT NULL, 3407 KEY `i1` (`c1`) 3408) ENGINE=ENGINE DEFAULT CHARSET=latin1 3409DROP TABLE t1; 3410SHOW TABLES; 3411Tables_in_test 3412CREATE TABLE t1(c1 NUMERIC NOT NULL); 3413SHOW TABLES; 3414Tables_in_test 3415t1 3416SHOW CREATE TABLE t1; 3417Table Create Table 3418t1 CREATE TABLE `t1` ( 3419 `c1` decimal(10,0) NOT NULL 3420) ENGINE=ENGINE DEFAULT CHARSET=latin1 3421ALTER TABLE t1 ADD INDEX i1 (c1); 3422SHOW TABLES; 3423Tables_in_test 3424t1 3425SHOW CREATE TABLE t1; 3426Table Create Table 3427t1 CREATE TABLE `t1` ( 3428 `c1` decimal(10,0) NOT NULL, 3429 KEY `i1` (`c1`) 3430) ENGINE=ENGINE DEFAULT CHARSET=latin1 3431DROP TABLE t1; 3432SHOW TABLES; 3433Tables_in_test 3434CREATE TABLE t1(c1 DATE NOT NULL); 3435SHOW TABLES; 3436Tables_in_test 3437t1 3438SHOW CREATE TABLE t1; 3439Table Create Table 3440t1 CREATE TABLE `t1` ( 3441 `c1` date NOT NULL 3442) ENGINE=ENGINE DEFAULT CHARSET=latin1 3443ALTER TABLE t1 ADD INDEX i1 (c1); 3444SHOW TABLES; 3445Tables_in_test 3446t1 3447SHOW CREATE TABLE t1; 3448Table Create Table 3449t1 CREATE TABLE `t1` ( 3450 `c1` date NOT NULL, 3451 KEY `i1` (`c1`) 3452) ENGINE=ENGINE DEFAULT CHARSET=latin1 3453DROP TABLE t1; 3454SHOW TABLES; 3455Tables_in_test 3456CREATE TABLE t1(c1 TIME NOT NULL); 3457SHOW TABLES; 3458Tables_in_test 3459t1 3460SHOW CREATE TABLE t1; 3461Table Create Table 3462t1 CREATE TABLE `t1` ( 3463 `c1` time NOT NULL 3464) ENGINE=ENGINE DEFAULT CHARSET=latin1 3465ALTER TABLE t1 ADD INDEX i1 (c1); 3466SHOW TABLES; 3467Tables_in_test 3468t1 3469SHOW CREATE TABLE t1; 3470Table Create Table 3471t1 CREATE TABLE `t1` ( 3472 `c1` time NOT NULL, 3473 KEY `i1` (`c1`) 3474) ENGINE=ENGINE DEFAULT CHARSET=latin1 3475DROP TABLE t1; 3476SHOW TABLES; 3477Tables_in_test 3478CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 3479SHOW TABLES; 3480Tables_in_test 3481t1 3482SHOW CREATE TABLE t1; 3483Table Create Table 3484t1 CREATE TABLE `t1` ( 3485 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 3486) ENGINE=ENGINE DEFAULT CHARSET=latin1 3487ALTER TABLE t1 ADD INDEX i1 (c1); 3488SHOW TABLES; 3489Tables_in_test 3490t1 3491SHOW CREATE TABLE t1; 3492Table Create Table 3493t1 CREATE TABLE `t1` ( 3494 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 3495 KEY `i1` (`c1`) 3496) ENGINE=ENGINE DEFAULT CHARSET=latin1 3497DROP TABLE t1; 3498SHOW TABLES; 3499Tables_in_test 3500CREATE TABLE t1(c1 YEAR NOT NULL); 3501SHOW TABLES; 3502Tables_in_test 3503t1 3504SHOW CREATE TABLE t1; 3505Table Create Table 3506t1 CREATE TABLE `t1` ( 3507 `c1` year(4) NOT NULL 3508) ENGINE=ENGINE DEFAULT CHARSET=latin1 3509ALTER TABLE t1 ADD INDEX i1 (c1); 3510SHOW TABLES; 3511Tables_in_test 3512t1 3513SHOW CREATE TABLE t1; 3514Table Create Table 3515t1 CREATE TABLE `t1` ( 3516 `c1` year(4) NOT NULL, 3517 KEY `i1` (`c1`) 3518) ENGINE=ENGINE DEFAULT CHARSET=latin1 3519DROP TABLE t1; 3520SHOW TABLES; 3521Tables_in_test 3522CREATE TABLE t1(c1 BIT NOT NULL); 3523SHOW TABLES; 3524Tables_in_test 3525t1 3526SHOW CREATE TABLE t1; 3527Table Create Table 3528t1 CREATE TABLE `t1` ( 3529 `c1` bit(1) NOT NULL 3530) ENGINE=ENGINE DEFAULT CHARSET=latin1 3531ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3532SHOW TABLES; 3533Tables_in_test 3534t1 3535SHOW CREATE TABLE t1; 3536Table Create Table 3537t1 CREATE TABLE `t1` ( 3538 `c1` bit(1) NOT NULL, 3539 KEY `i1` (`c1`) USING BTREE 3540) ENGINE=ENGINE DEFAULT CHARSET=latin1 3541DROP TABLE t1; 3542SHOW TABLES; 3543Tables_in_test 3544CREATE TABLE t1(c1 TINYINT NOT NULL); 3545SHOW TABLES; 3546Tables_in_test 3547t1 3548SHOW CREATE TABLE t1; 3549Table Create Table 3550t1 CREATE TABLE `t1` ( 3551 `c1` tinyint(4) NOT NULL 3552) ENGINE=ENGINE DEFAULT CHARSET=latin1 3553ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3554SHOW TABLES; 3555Tables_in_test 3556t1 3557SHOW CREATE TABLE t1; 3558Table Create Table 3559t1 CREATE TABLE `t1` ( 3560 `c1` tinyint(4) NOT NULL, 3561 KEY `i1` (`c1`) USING BTREE 3562) ENGINE=ENGINE DEFAULT CHARSET=latin1 3563DROP TABLE t1; 3564SHOW TABLES; 3565Tables_in_test 3566CREATE TABLE t1(c1 SMALLINT NOT NULL); 3567SHOW TABLES; 3568Tables_in_test 3569t1 3570SHOW CREATE TABLE t1; 3571Table Create Table 3572t1 CREATE TABLE `t1` ( 3573 `c1` smallint(6) NOT NULL 3574) ENGINE=ENGINE DEFAULT CHARSET=latin1 3575ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3576SHOW TABLES; 3577Tables_in_test 3578t1 3579SHOW CREATE TABLE t1; 3580Table Create Table 3581t1 CREATE TABLE `t1` ( 3582 `c1` smallint(6) NOT NULL, 3583 KEY `i1` (`c1`) USING BTREE 3584) ENGINE=ENGINE DEFAULT CHARSET=latin1 3585DROP TABLE t1; 3586SHOW TABLES; 3587Tables_in_test 3588CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 3589SHOW TABLES; 3590Tables_in_test 3591t1 3592SHOW CREATE TABLE t1; 3593Table Create Table 3594t1 CREATE TABLE `t1` ( 3595 `c1` mediumint(9) NOT NULL 3596) ENGINE=ENGINE DEFAULT CHARSET=latin1 3597ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3598SHOW TABLES; 3599Tables_in_test 3600t1 3601SHOW CREATE TABLE t1; 3602Table Create Table 3603t1 CREATE TABLE `t1` ( 3604 `c1` mediumint(9) NOT NULL, 3605 KEY `i1` (`c1`) USING BTREE 3606) ENGINE=ENGINE DEFAULT CHARSET=latin1 3607DROP TABLE t1; 3608SHOW TABLES; 3609Tables_in_test 3610CREATE TABLE t1(c1 INT NOT NULL); 3611SHOW TABLES; 3612Tables_in_test 3613t1 3614SHOW CREATE TABLE t1; 3615Table Create Table 3616t1 CREATE TABLE `t1` ( 3617 `c1` int(11) NOT NULL 3618) ENGINE=ENGINE DEFAULT CHARSET=latin1 3619ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3620SHOW TABLES; 3621Tables_in_test 3622t1 3623SHOW CREATE TABLE t1; 3624Table Create Table 3625t1 CREATE TABLE `t1` ( 3626 `c1` int(11) NOT NULL, 3627 KEY `i1` (`c1`) USING BTREE 3628) ENGINE=ENGINE DEFAULT CHARSET=latin1 3629DROP TABLE t1; 3630SHOW TABLES; 3631Tables_in_test 3632CREATE TABLE t1(c1 INTEGER NOT NULL); 3633SHOW TABLES; 3634Tables_in_test 3635t1 3636SHOW CREATE TABLE t1; 3637Table Create Table 3638t1 CREATE TABLE `t1` ( 3639 `c1` int(11) NOT NULL 3640) ENGINE=ENGINE DEFAULT CHARSET=latin1 3641ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3642SHOW TABLES; 3643Tables_in_test 3644t1 3645SHOW CREATE TABLE t1; 3646Table Create Table 3647t1 CREATE TABLE `t1` ( 3648 `c1` int(11) NOT NULL, 3649 KEY `i1` (`c1`) USING BTREE 3650) ENGINE=ENGINE DEFAULT CHARSET=latin1 3651DROP TABLE t1; 3652SHOW TABLES; 3653Tables_in_test 3654CREATE TABLE t1(c1 BIGINT NOT NULL); 3655SHOW TABLES; 3656Tables_in_test 3657t1 3658SHOW CREATE TABLE t1; 3659Table Create Table 3660t1 CREATE TABLE `t1` ( 3661 `c1` bigint(20) NOT NULL 3662) ENGINE=ENGINE DEFAULT CHARSET=latin1 3663ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3664SHOW TABLES; 3665Tables_in_test 3666t1 3667SHOW CREATE TABLE t1; 3668Table Create Table 3669t1 CREATE TABLE `t1` ( 3670 `c1` bigint(20) NOT NULL, 3671 KEY `i1` (`c1`) USING BTREE 3672) ENGINE=ENGINE DEFAULT CHARSET=latin1 3673DROP TABLE t1; 3674SHOW TABLES; 3675Tables_in_test 3676CREATE TABLE t1(c1 REAL NOT NULL); 3677SHOW TABLES; 3678Tables_in_test 3679t1 3680SHOW CREATE TABLE t1; 3681Table Create Table 3682t1 CREATE TABLE `t1` ( 3683 `c1` double NOT NULL 3684) ENGINE=ENGINE DEFAULT CHARSET=latin1 3685ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3686SHOW TABLES; 3687Tables_in_test 3688t1 3689SHOW CREATE TABLE t1; 3690Table Create Table 3691t1 CREATE TABLE `t1` ( 3692 `c1` double NOT NULL, 3693 KEY `i1` (`c1`) USING BTREE 3694) ENGINE=ENGINE DEFAULT CHARSET=latin1 3695DROP TABLE t1; 3696SHOW TABLES; 3697Tables_in_test 3698CREATE TABLE t1(c1 DOUBLE NOT NULL); 3699SHOW TABLES; 3700Tables_in_test 3701t1 3702SHOW CREATE TABLE t1; 3703Table Create Table 3704t1 CREATE TABLE `t1` ( 3705 `c1` double NOT NULL 3706) ENGINE=ENGINE DEFAULT CHARSET=latin1 3707ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3708SHOW TABLES; 3709Tables_in_test 3710t1 3711SHOW CREATE TABLE t1; 3712Table Create Table 3713t1 CREATE TABLE `t1` ( 3714 `c1` double NOT NULL, 3715 KEY `i1` (`c1`) USING BTREE 3716) ENGINE=ENGINE DEFAULT CHARSET=latin1 3717DROP TABLE t1; 3718SHOW TABLES; 3719Tables_in_test 3720CREATE TABLE t1(c1 FLOAT NOT NULL); 3721SHOW TABLES; 3722Tables_in_test 3723t1 3724SHOW CREATE TABLE t1; 3725Table Create Table 3726t1 CREATE TABLE `t1` ( 3727 `c1` float NOT NULL 3728) ENGINE=ENGINE DEFAULT CHARSET=latin1 3729ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3730SHOW TABLES; 3731Tables_in_test 3732t1 3733SHOW CREATE TABLE t1; 3734Table Create Table 3735t1 CREATE TABLE `t1` ( 3736 `c1` float NOT NULL, 3737 KEY `i1` (`c1`) USING BTREE 3738) ENGINE=ENGINE DEFAULT CHARSET=latin1 3739DROP TABLE t1; 3740SHOW TABLES; 3741Tables_in_test 3742CREATE TABLE t1(c1 DECIMAL NOT NULL); 3743SHOW TABLES; 3744Tables_in_test 3745t1 3746SHOW CREATE TABLE t1; 3747Table Create Table 3748t1 CREATE TABLE `t1` ( 3749 `c1` decimal(10,0) NOT NULL 3750) ENGINE=ENGINE DEFAULT CHARSET=latin1 3751ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3752SHOW TABLES; 3753Tables_in_test 3754t1 3755SHOW CREATE TABLE t1; 3756Table Create Table 3757t1 CREATE TABLE `t1` ( 3758 `c1` decimal(10,0) NOT NULL, 3759 KEY `i1` (`c1`) USING BTREE 3760) ENGINE=ENGINE DEFAULT CHARSET=latin1 3761DROP TABLE t1; 3762SHOW TABLES; 3763Tables_in_test 3764CREATE TABLE t1(c1 NUMERIC NOT NULL); 3765SHOW TABLES; 3766Tables_in_test 3767t1 3768SHOW CREATE TABLE t1; 3769Table Create Table 3770t1 CREATE TABLE `t1` ( 3771 `c1` decimal(10,0) NOT NULL 3772) ENGINE=ENGINE DEFAULT CHARSET=latin1 3773ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3774SHOW TABLES; 3775Tables_in_test 3776t1 3777SHOW CREATE TABLE t1; 3778Table Create Table 3779t1 CREATE TABLE `t1` ( 3780 `c1` decimal(10,0) NOT NULL, 3781 KEY `i1` (`c1`) USING BTREE 3782) ENGINE=ENGINE DEFAULT CHARSET=latin1 3783DROP TABLE t1; 3784SHOW TABLES; 3785Tables_in_test 3786CREATE TABLE t1(c1 DATE NOT NULL); 3787SHOW TABLES; 3788Tables_in_test 3789t1 3790SHOW CREATE TABLE t1; 3791Table Create Table 3792t1 CREATE TABLE `t1` ( 3793 `c1` date NOT NULL 3794) ENGINE=ENGINE DEFAULT CHARSET=latin1 3795ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3796SHOW TABLES; 3797Tables_in_test 3798t1 3799SHOW CREATE TABLE t1; 3800Table Create Table 3801t1 CREATE TABLE `t1` ( 3802 `c1` date NOT NULL, 3803 KEY `i1` (`c1`) USING BTREE 3804) ENGINE=ENGINE DEFAULT CHARSET=latin1 3805DROP TABLE t1; 3806SHOW TABLES; 3807Tables_in_test 3808CREATE TABLE t1(c1 TIME NOT NULL); 3809SHOW TABLES; 3810Tables_in_test 3811t1 3812SHOW CREATE TABLE t1; 3813Table Create Table 3814t1 CREATE TABLE `t1` ( 3815 `c1` time NOT NULL 3816) ENGINE=ENGINE DEFAULT CHARSET=latin1 3817ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3818SHOW TABLES; 3819Tables_in_test 3820t1 3821SHOW CREATE TABLE t1; 3822Table Create Table 3823t1 CREATE TABLE `t1` ( 3824 `c1` time NOT NULL, 3825 KEY `i1` (`c1`) USING BTREE 3826) ENGINE=ENGINE DEFAULT CHARSET=latin1 3827DROP TABLE t1; 3828SHOW TABLES; 3829Tables_in_test 3830CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 3831SHOW TABLES; 3832Tables_in_test 3833t1 3834SHOW CREATE TABLE t1; 3835Table Create Table 3836t1 CREATE TABLE `t1` ( 3837 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 3838) ENGINE=ENGINE DEFAULT CHARSET=latin1 3839ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3840SHOW TABLES; 3841Tables_in_test 3842t1 3843SHOW CREATE TABLE t1; 3844Table Create Table 3845t1 CREATE TABLE `t1` ( 3846 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 3847 KEY `i1` (`c1`) USING BTREE 3848) ENGINE=ENGINE DEFAULT CHARSET=latin1 3849DROP TABLE t1; 3850SHOW TABLES; 3851Tables_in_test 3852CREATE TABLE t1(c1 YEAR NOT NULL); 3853SHOW TABLES; 3854Tables_in_test 3855t1 3856SHOW CREATE TABLE t1; 3857Table Create Table 3858t1 CREATE TABLE `t1` ( 3859 `c1` year(4) NOT NULL 3860) ENGINE=ENGINE DEFAULT CHARSET=latin1 3861ALTER TABLE t1 ADD INDEX i1 USING BTREE (c1); 3862SHOW TABLES; 3863Tables_in_test 3864t1 3865SHOW CREATE TABLE t1; 3866Table Create Table 3867t1 CREATE TABLE `t1` ( 3868 `c1` year(4) NOT NULL, 3869 KEY `i1` (`c1`) USING BTREE 3870) ENGINE=ENGINE DEFAULT CHARSET=latin1 3871DROP TABLE t1; 3872SHOW TABLES; 3873Tables_in_test 3874CREATE TABLE t1(c1 BIT NOT NULL); 3875SHOW TABLES; 3876Tables_in_test 3877t1 3878SHOW CREATE TABLE t1; 3879Table Create Table 3880t1 CREATE TABLE `t1` ( 3881 `c1` bit(1) NOT NULL 3882) ENGINE=ENGINE DEFAULT CHARSET=latin1 3883ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 3884SHOW TABLES; 3885Tables_in_test 3886t1 3887SHOW CREATE TABLE t1; 3888Table Create Table 3889t1 CREATE TABLE `t1` ( 3890 `c1` bit(1) NOT NULL, 3891 KEY `i1` (`c1`) USING HASH 3892) ENGINE=ENGINE DEFAULT CHARSET=latin1 3893DROP TABLE t1; 3894SHOW TABLES; 3895Tables_in_test 3896CREATE TABLE t1(c1 TINYINT NOT NULL); 3897SHOW TABLES; 3898Tables_in_test 3899t1 3900SHOW CREATE TABLE t1; 3901Table Create Table 3902t1 CREATE TABLE `t1` ( 3903 `c1` tinyint(4) NOT NULL 3904) ENGINE=ENGINE DEFAULT CHARSET=latin1 3905ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 3906SHOW TABLES; 3907Tables_in_test 3908t1 3909SHOW CREATE TABLE t1; 3910Table Create Table 3911t1 CREATE TABLE `t1` ( 3912 `c1` tinyint(4) NOT NULL, 3913 KEY `i1` (`c1`) USING HASH 3914) ENGINE=ENGINE DEFAULT CHARSET=latin1 3915DROP TABLE t1; 3916SHOW TABLES; 3917Tables_in_test 3918CREATE TABLE t1(c1 SMALLINT NOT NULL); 3919SHOW TABLES; 3920Tables_in_test 3921t1 3922SHOW CREATE TABLE t1; 3923Table Create Table 3924t1 CREATE TABLE `t1` ( 3925 `c1` smallint(6) NOT NULL 3926) ENGINE=ENGINE DEFAULT CHARSET=latin1 3927ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 3928SHOW TABLES; 3929Tables_in_test 3930t1 3931SHOW CREATE TABLE t1; 3932Table Create Table 3933t1 CREATE TABLE `t1` ( 3934 `c1` smallint(6) NOT NULL, 3935 KEY `i1` (`c1`) USING HASH 3936) ENGINE=ENGINE DEFAULT CHARSET=latin1 3937DROP TABLE t1; 3938SHOW TABLES; 3939Tables_in_test 3940CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 3941SHOW TABLES; 3942Tables_in_test 3943t1 3944SHOW CREATE TABLE t1; 3945Table Create Table 3946t1 CREATE TABLE `t1` ( 3947 `c1` mediumint(9) NOT NULL 3948) ENGINE=ENGINE DEFAULT CHARSET=latin1 3949ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 3950SHOW TABLES; 3951Tables_in_test 3952t1 3953SHOW CREATE TABLE t1; 3954Table Create Table 3955t1 CREATE TABLE `t1` ( 3956 `c1` mediumint(9) NOT NULL, 3957 KEY `i1` (`c1`) USING HASH 3958) ENGINE=ENGINE DEFAULT CHARSET=latin1 3959DROP TABLE t1; 3960SHOW TABLES; 3961Tables_in_test 3962CREATE TABLE t1(c1 INT NOT NULL); 3963SHOW TABLES; 3964Tables_in_test 3965t1 3966SHOW CREATE TABLE t1; 3967Table Create Table 3968t1 CREATE TABLE `t1` ( 3969 `c1` int(11) NOT NULL 3970) ENGINE=ENGINE DEFAULT CHARSET=latin1 3971ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 3972SHOW TABLES; 3973Tables_in_test 3974t1 3975SHOW CREATE TABLE t1; 3976Table Create Table 3977t1 CREATE TABLE `t1` ( 3978 `c1` int(11) NOT NULL, 3979 KEY `i1` (`c1`) USING HASH 3980) ENGINE=ENGINE DEFAULT CHARSET=latin1 3981DROP TABLE t1; 3982SHOW TABLES; 3983Tables_in_test 3984CREATE TABLE t1(c1 INTEGER NOT NULL); 3985SHOW TABLES; 3986Tables_in_test 3987t1 3988SHOW CREATE TABLE t1; 3989Table Create Table 3990t1 CREATE TABLE `t1` ( 3991 `c1` int(11) NOT NULL 3992) ENGINE=ENGINE DEFAULT CHARSET=latin1 3993ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 3994SHOW TABLES; 3995Tables_in_test 3996t1 3997SHOW CREATE TABLE t1; 3998Table Create Table 3999t1 CREATE TABLE `t1` ( 4000 `c1` int(11) NOT NULL, 4001 KEY `i1` (`c1`) USING HASH 4002) ENGINE=ENGINE DEFAULT CHARSET=latin1 4003DROP TABLE t1; 4004SHOW TABLES; 4005Tables_in_test 4006CREATE TABLE t1(c1 BIGINT NOT NULL); 4007SHOW TABLES; 4008Tables_in_test 4009t1 4010SHOW CREATE TABLE t1; 4011Table Create Table 4012t1 CREATE TABLE `t1` ( 4013 `c1` bigint(20) NOT NULL 4014) ENGINE=ENGINE DEFAULT CHARSET=latin1 4015ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4016SHOW TABLES; 4017Tables_in_test 4018t1 4019SHOW CREATE TABLE t1; 4020Table Create Table 4021t1 CREATE TABLE `t1` ( 4022 `c1` bigint(20) NOT NULL, 4023 KEY `i1` (`c1`) USING HASH 4024) ENGINE=ENGINE DEFAULT CHARSET=latin1 4025DROP TABLE t1; 4026SHOW TABLES; 4027Tables_in_test 4028CREATE TABLE t1(c1 REAL NOT NULL); 4029SHOW TABLES; 4030Tables_in_test 4031t1 4032SHOW CREATE TABLE t1; 4033Table Create Table 4034t1 CREATE TABLE `t1` ( 4035 `c1` double NOT NULL 4036) ENGINE=ENGINE DEFAULT CHARSET=latin1 4037ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4038SHOW TABLES; 4039Tables_in_test 4040t1 4041SHOW CREATE TABLE t1; 4042Table Create Table 4043t1 CREATE TABLE `t1` ( 4044 `c1` double NOT NULL, 4045 KEY `i1` (`c1`) USING HASH 4046) ENGINE=ENGINE DEFAULT CHARSET=latin1 4047DROP TABLE t1; 4048SHOW TABLES; 4049Tables_in_test 4050CREATE TABLE t1(c1 DOUBLE NOT NULL); 4051SHOW TABLES; 4052Tables_in_test 4053t1 4054SHOW CREATE TABLE t1; 4055Table Create Table 4056t1 CREATE TABLE `t1` ( 4057 `c1` double NOT NULL 4058) ENGINE=ENGINE DEFAULT CHARSET=latin1 4059ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4060SHOW TABLES; 4061Tables_in_test 4062t1 4063SHOW CREATE TABLE t1; 4064Table Create Table 4065t1 CREATE TABLE `t1` ( 4066 `c1` double NOT NULL, 4067 KEY `i1` (`c1`) USING HASH 4068) ENGINE=ENGINE DEFAULT CHARSET=latin1 4069DROP TABLE t1; 4070SHOW TABLES; 4071Tables_in_test 4072CREATE TABLE t1(c1 FLOAT NOT NULL); 4073SHOW TABLES; 4074Tables_in_test 4075t1 4076SHOW CREATE TABLE t1; 4077Table Create Table 4078t1 CREATE TABLE `t1` ( 4079 `c1` float NOT NULL 4080) ENGINE=ENGINE DEFAULT CHARSET=latin1 4081ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4082SHOW TABLES; 4083Tables_in_test 4084t1 4085SHOW CREATE TABLE t1; 4086Table Create Table 4087t1 CREATE TABLE `t1` ( 4088 `c1` float NOT NULL, 4089 KEY `i1` (`c1`) USING HASH 4090) ENGINE=ENGINE DEFAULT CHARSET=latin1 4091DROP TABLE t1; 4092SHOW TABLES; 4093Tables_in_test 4094CREATE TABLE t1(c1 DECIMAL NOT NULL); 4095SHOW TABLES; 4096Tables_in_test 4097t1 4098SHOW CREATE TABLE t1; 4099Table Create Table 4100t1 CREATE TABLE `t1` ( 4101 `c1` decimal(10,0) NOT NULL 4102) ENGINE=ENGINE DEFAULT CHARSET=latin1 4103ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4104SHOW TABLES; 4105Tables_in_test 4106t1 4107SHOW CREATE TABLE t1; 4108Table Create Table 4109t1 CREATE TABLE `t1` ( 4110 `c1` decimal(10,0) NOT NULL, 4111 KEY `i1` (`c1`) USING HASH 4112) ENGINE=ENGINE DEFAULT CHARSET=latin1 4113DROP TABLE t1; 4114SHOW TABLES; 4115Tables_in_test 4116CREATE TABLE t1(c1 NUMERIC NOT NULL); 4117SHOW TABLES; 4118Tables_in_test 4119t1 4120SHOW CREATE TABLE t1; 4121Table Create Table 4122t1 CREATE TABLE `t1` ( 4123 `c1` decimal(10,0) NOT NULL 4124) ENGINE=ENGINE DEFAULT CHARSET=latin1 4125ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4126SHOW TABLES; 4127Tables_in_test 4128t1 4129SHOW CREATE TABLE t1; 4130Table Create Table 4131t1 CREATE TABLE `t1` ( 4132 `c1` decimal(10,0) NOT NULL, 4133 KEY `i1` (`c1`) USING HASH 4134) ENGINE=ENGINE DEFAULT CHARSET=latin1 4135DROP TABLE t1; 4136SHOW TABLES; 4137Tables_in_test 4138CREATE TABLE t1(c1 DATE NOT NULL); 4139SHOW TABLES; 4140Tables_in_test 4141t1 4142SHOW CREATE TABLE t1; 4143Table Create Table 4144t1 CREATE TABLE `t1` ( 4145 `c1` date NOT NULL 4146) ENGINE=ENGINE DEFAULT CHARSET=latin1 4147ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4148SHOW TABLES; 4149Tables_in_test 4150t1 4151SHOW CREATE TABLE t1; 4152Table Create Table 4153t1 CREATE TABLE `t1` ( 4154 `c1` date NOT NULL, 4155 KEY `i1` (`c1`) USING HASH 4156) ENGINE=ENGINE DEFAULT CHARSET=latin1 4157DROP TABLE t1; 4158SHOW TABLES; 4159Tables_in_test 4160CREATE TABLE t1(c1 TIME NOT NULL); 4161SHOW TABLES; 4162Tables_in_test 4163t1 4164SHOW CREATE TABLE t1; 4165Table Create Table 4166t1 CREATE TABLE `t1` ( 4167 `c1` time NOT NULL 4168) ENGINE=ENGINE DEFAULT CHARSET=latin1 4169ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4170SHOW TABLES; 4171Tables_in_test 4172t1 4173SHOW CREATE TABLE t1; 4174Table Create Table 4175t1 CREATE TABLE `t1` ( 4176 `c1` time NOT NULL, 4177 KEY `i1` (`c1`) USING HASH 4178) ENGINE=ENGINE DEFAULT CHARSET=latin1 4179DROP TABLE t1; 4180SHOW TABLES; 4181Tables_in_test 4182CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 4183SHOW TABLES; 4184Tables_in_test 4185t1 4186SHOW CREATE TABLE t1; 4187Table Create Table 4188t1 CREATE TABLE `t1` ( 4189 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() 4190) ENGINE=ENGINE DEFAULT CHARSET=latin1 4191ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4192SHOW TABLES; 4193Tables_in_test 4194t1 4195SHOW CREATE TABLE t1; 4196Table Create Table 4197t1 CREATE TABLE `t1` ( 4198 `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), 4199 KEY `i1` (`c1`) USING HASH 4200) ENGINE=ENGINE DEFAULT CHARSET=latin1 4201DROP TABLE t1; 4202SHOW TABLES; 4203Tables_in_test 4204CREATE TABLE t1(c1 YEAR NOT NULL); 4205SHOW TABLES; 4206Tables_in_test 4207t1 4208SHOW CREATE TABLE t1; 4209Table Create Table 4210t1 CREATE TABLE `t1` ( 4211 `c1` year(4) NOT NULL 4212) ENGINE=ENGINE DEFAULT CHARSET=latin1 4213ALTER TABLE t1 ADD INDEX i1 USING HASH (c1); 4214SHOW TABLES; 4215Tables_in_test 4216t1 4217SHOW CREATE TABLE t1; 4218Table Create Table 4219t1 CREATE TABLE `t1` ( 4220 `c1` year(4) NOT NULL, 4221 KEY `i1` (`c1`) USING HASH 4222) ENGINE=ENGINE DEFAULT CHARSET=latin1 4223DROP TABLE t1; 4224SHOW TABLES; 4225Tables_in_test 4226