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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 11ALTER TABLE t1 ADD UNIQUE (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 UNIQUE KEY `c1` (`c1`) 20) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 32) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 33ALTER TABLE t1 ADD UNIQUE (c1); 34SHOW TABLES; 35Tables_in_test 36t1 37SHOW CREATE TABLE t1; 38Table Create Table 39t1 CREATE TABLE `t1` ( 40 `c1` tinyint NOT NULL, 41 UNIQUE KEY `c1` (`c1`) 42) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 54) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 55ALTER TABLE t1 ADD UNIQUE (c1); 56SHOW TABLES; 57Tables_in_test 58t1 59SHOW CREATE TABLE t1; 60Table Create Table 61t1 CREATE TABLE `t1` ( 62 `c1` smallint NOT NULL, 63 UNIQUE KEY `c1` (`c1`) 64) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 76) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 77ALTER TABLE t1 ADD UNIQUE (c1); 78SHOW TABLES; 79Tables_in_test 80t1 81SHOW CREATE TABLE t1; 82Table Create Table 83t1 CREATE TABLE `t1` ( 84 `c1` mediumint NOT NULL, 85 UNIQUE KEY `c1` (`c1`) 86) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 98) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 99ALTER TABLE t1 ADD UNIQUE (c1); 100SHOW TABLES; 101Tables_in_test 102t1 103SHOW CREATE TABLE t1; 104Table Create Table 105t1 CREATE TABLE `t1` ( 106 `c1` int NOT NULL, 107 UNIQUE KEY `c1` (`c1`) 108) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 120) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 121ALTER TABLE t1 ADD UNIQUE (c1); 122SHOW TABLES; 123Tables_in_test 124t1 125SHOW CREATE TABLE t1; 126Table Create Table 127t1 CREATE TABLE `t1` ( 128 `c1` int NOT NULL, 129 UNIQUE KEY `c1` (`c1`) 130) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 142) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 143ALTER TABLE t1 ADD UNIQUE (c1); 144SHOW TABLES; 145Tables_in_test 146t1 147SHOW CREATE TABLE t1; 148Table Create Table 149t1 CREATE TABLE `t1` ( 150 `c1` bigint NOT NULL, 151 UNIQUE KEY `c1` (`c1`) 152) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 165ALTER TABLE t1 ADD UNIQUE (c1); 166SHOW TABLES; 167Tables_in_test 168t1 169SHOW CREATE TABLE t1; 170Table Create Table 171t1 CREATE TABLE `t1` ( 172 `c1` double NOT NULL, 173 UNIQUE KEY `c1` (`c1`) 174) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 187ALTER TABLE t1 ADD UNIQUE (c1); 188SHOW TABLES; 189Tables_in_test 190t1 191SHOW CREATE TABLE t1; 192Table Create Table 193t1 CREATE TABLE `t1` ( 194 `c1` double NOT NULL, 195 UNIQUE KEY `c1` (`c1`) 196) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 209ALTER TABLE t1 ADD UNIQUE (c1); 210SHOW TABLES; 211Tables_in_test 212t1 213SHOW CREATE TABLE t1; 214Table Create Table 215t1 CREATE TABLE `t1` ( 216 `c1` float NOT NULL, 217 UNIQUE KEY `c1` (`c1`) 218) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 231ALTER TABLE t1 ADD UNIQUE (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 UNIQUE KEY `c1` (`c1`) 240) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 253ALTER TABLE t1 ADD UNIQUE (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 UNIQUE KEY `c1` (`c1`) 262) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 275ALTER TABLE t1 ADD UNIQUE (c1); 276SHOW TABLES; 277Tables_in_test 278t1 279SHOW CREATE TABLE t1; 280Table Create Table 281t1 CREATE TABLE `t1` ( 282 `c1` date NOT NULL, 283 UNIQUE KEY `c1` (`c1`) 284) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 297ALTER TABLE t1 ADD UNIQUE (c1); 298SHOW TABLES; 299Tables_in_test 300t1 301SHOW CREATE TABLE t1; 302Table Create Table 303t1 CREATE TABLE `t1` ( 304 `c1` time NOT NULL, 305 UNIQUE KEY `c1` (`c1`) 306) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 318) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 319ALTER TABLE t1 ADD UNIQUE (c1); 320SHOW TABLES; 321Tables_in_test 322t1 323SHOW CREATE TABLE t1; 324Table Create Table 325t1 CREATE TABLE `t1` ( 326 `c1` timestamp NOT NULL, 327 UNIQUE KEY `c1` (`c1`) 328) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 340) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 341ALTER TABLE t1 ADD UNIQUE (c1); 342SHOW TABLES; 343Tables_in_test 344t1 345SHOW CREATE TABLE t1; 346Table Create Table 347t1 CREATE TABLE `t1` ( 348 `c1` year NOT NULL, 349 UNIQUE KEY `c1` (`c1`) 350) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 363ALTER TABLE t1 ADD UNIQUE KEY (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 UNIQUE KEY `c1` (`c1`) 372) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 384) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 385ALTER TABLE t1 ADD UNIQUE KEY (c1); 386SHOW TABLES; 387Tables_in_test 388t1 389SHOW CREATE TABLE t1; 390Table Create Table 391t1 CREATE TABLE `t1` ( 392 `c1` tinyint NOT NULL, 393 UNIQUE KEY `c1` (`c1`) 394) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 406) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 407ALTER TABLE t1 ADD UNIQUE KEY (c1); 408SHOW TABLES; 409Tables_in_test 410t1 411SHOW CREATE TABLE t1; 412Table Create Table 413t1 CREATE TABLE `t1` ( 414 `c1` smallint NOT NULL, 415 UNIQUE KEY `c1` (`c1`) 416) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 428) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 429ALTER TABLE t1 ADD UNIQUE KEY (c1); 430SHOW TABLES; 431Tables_in_test 432t1 433SHOW CREATE TABLE t1; 434Table Create Table 435t1 CREATE TABLE `t1` ( 436 `c1` mediumint NOT NULL, 437 UNIQUE KEY `c1` (`c1`) 438) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 450) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 451ALTER TABLE t1 ADD UNIQUE KEY (c1); 452SHOW TABLES; 453Tables_in_test 454t1 455SHOW CREATE TABLE t1; 456Table Create Table 457t1 CREATE TABLE `t1` ( 458 `c1` int NOT NULL, 459 UNIQUE KEY `c1` (`c1`) 460) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 472) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 473ALTER TABLE t1 ADD UNIQUE KEY (c1); 474SHOW TABLES; 475Tables_in_test 476t1 477SHOW CREATE TABLE t1; 478Table Create Table 479t1 CREATE TABLE `t1` ( 480 `c1` int NOT NULL, 481 UNIQUE KEY `c1` (`c1`) 482) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 494) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 495ALTER TABLE t1 ADD UNIQUE KEY (c1); 496SHOW TABLES; 497Tables_in_test 498t1 499SHOW CREATE TABLE t1; 500Table Create Table 501t1 CREATE TABLE `t1` ( 502 `c1` bigint NOT NULL, 503 UNIQUE KEY `c1` (`c1`) 504) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 517ALTER TABLE t1 ADD UNIQUE KEY (c1); 518SHOW TABLES; 519Tables_in_test 520t1 521SHOW CREATE TABLE t1; 522Table Create Table 523t1 CREATE TABLE `t1` ( 524 `c1` double NOT NULL, 525 UNIQUE KEY `c1` (`c1`) 526) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 539ALTER TABLE t1 ADD UNIQUE KEY (c1); 540SHOW TABLES; 541Tables_in_test 542t1 543SHOW CREATE TABLE t1; 544Table Create Table 545t1 CREATE TABLE `t1` ( 546 `c1` double NOT NULL, 547 UNIQUE KEY `c1` (`c1`) 548) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 561ALTER TABLE t1 ADD UNIQUE KEY (c1); 562SHOW TABLES; 563Tables_in_test 564t1 565SHOW CREATE TABLE t1; 566Table Create Table 567t1 CREATE TABLE `t1` ( 568 `c1` float NOT NULL, 569 UNIQUE KEY `c1` (`c1`) 570) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 583ALTER TABLE t1 ADD UNIQUE KEY (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 UNIQUE KEY `c1` (`c1`) 592) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 605ALTER TABLE t1 ADD UNIQUE KEY (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 UNIQUE KEY `c1` (`c1`) 614) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 627ALTER TABLE t1 ADD UNIQUE KEY (c1); 628SHOW TABLES; 629Tables_in_test 630t1 631SHOW CREATE TABLE t1; 632Table Create Table 633t1 CREATE TABLE `t1` ( 634 `c1` date NOT NULL, 635 UNIQUE KEY `c1` (`c1`) 636) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 649ALTER TABLE t1 ADD UNIQUE KEY (c1); 650SHOW TABLES; 651Tables_in_test 652t1 653SHOW CREATE TABLE t1; 654Table Create Table 655t1 CREATE TABLE `t1` ( 656 `c1` time NOT NULL, 657 UNIQUE KEY `c1` (`c1`) 658) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 670) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 671ALTER TABLE t1 ADD UNIQUE KEY (c1); 672SHOW TABLES; 673Tables_in_test 674t1 675SHOW CREATE TABLE t1; 676Table Create Table 677t1 CREATE TABLE `t1` ( 678 `c1` timestamp NOT NULL, 679 UNIQUE KEY `c1` (`c1`) 680) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 692) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 693ALTER TABLE t1 ADD UNIQUE KEY (c1); 694SHOW TABLES; 695Tables_in_test 696t1 697SHOW CREATE TABLE t1; 698Table Create Table 699t1 CREATE TABLE `t1` ( 700 `c1` year NOT NULL, 701 UNIQUE KEY `c1` (`c1`) 702) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 715ALTER TABLE t1 ADD UNIQUE INDEX (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 UNIQUE KEY `c1` (`c1`) 724) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 736) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 737ALTER TABLE t1 ADD UNIQUE INDEX (c1); 738SHOW TABLES; 739Tables_in_test 740t1 741SHOW CREATE TABLE t1; 742Table Create Table 743t1 CREATE TABLE `t1` ( 744 `c1` tinyint NOT NULL, 745 UNIQUE KEY `c1` (`c1`) 746) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 758) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 759ALTER TABLE t1 ADD UNIQUE INDEX (c1); 760SHOW TABLES; 761Tables_in_test 762t1 763SHOW CREATE TABLE t1; 764Table Create Table 765t1 CREATE TABLE `t1` ( 766 `c1` smallint NOT NULL, 767 UNIQUE KEY `c1` (`c1`) 768) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 780) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 781ALTER TABLE t1 ADD UNIQUE INDEX (c1); 782SHOW TABLES; 783Tables_in_test 784t1 785SHOW CREATE TABLE t1; 786Table Create Table 787t1 CREATE TABLE `t1` ( 788 `c1` mediumint NOT NULL, 789 UNIQUE KEY `c1` (`c1`) 790) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 802) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 803ALTER TABLE t1 ADD UNIQUE INDEX (c1); 804SHOW TABLES; 805Tables_in_test 806t1 807SHOW CREATE TABLE t1; 808Table Create Table 809t1 CREATE TABLE `t1` ( 810 `c1` int NOT NULL, 811 UNIQUE KEY `c1` (`c1`) 812) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 824) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 825ALTER TABLE t1 ADD UNIQUE INDEX (c1); 826SHOW TABLES; 827Tables_in_test 828t1 829SHOW CREATE TABLE t1; 830Table Create Table 831t1 CREATE TABLE `t1` ( 832 `c1` int NOT NULL, 833 UNIQUE KEY `c1` (`c1`) 834) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 846) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 847ALTER TABLE t1 ADD UNIQUE INDEX (c1); 848SHOW TABLES; 849Tables_in_test 850t1 851SHOW CREATE TABLE t1; 852Table Create Table 853t1 CREATE TABLE `t1` ( 854 `c1` bigint NOT NULL, 855 UNIQUE KEY `c1` (`c1`) 856) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 869ALTER TABLE t1 ADD UNIQUE INDEX (c1); 870SHOW TABLES; 871Tables_in_test 872t1 873SHOW CREATE TABLE t1; 874Table Create Table 875t1 CREATE TABLE `t1` ( 876 `c1` double NOT NULL, 877 UNIQUE KEY `c1` (`c1`) 878) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 891ALTER TABLE t1 ADD UNIQUE INDEX (c1); 892SHOW TABLES; 893Tables_in_test 894t1 895SHOW CREATE TABLE t1; 896Table Create Table 897t1 CREATE TABLE `t1` ( 898 `c1` double NOT NULL, 899 UNIQUE KEY `c1` (`c1`) 900) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 913ALTER TABLE t1 ADD UNIQUE INDEX (c1); 914SHOW TABLES; 915Tables_in_test 916t1 917SHOW CREATE TABLE t1; 918Table Create Table 919t1 CREATE TABLE `t1` ( 920 `c1` float NOT NULL, 921 UNIQUE KEY `c1` (`c1`) 922) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 935ALTER TABLE t1 ADD UNIQUE INDEX (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 UNIQUE KEY `c1` (`c1`) 944) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 957ALTER TABLE t1 ADD UNIQUE INDEX (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 UNIQUE KEY `c1` (`c1`) 966) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 979ALTER TABLE t1 ADD UNIQUE INDEX (c1); 980SHOW TABLES; 981Tables_in_test 982t1 983SHOW CREATE TABLE t1; 984Table Create Table 985t1 CREATE TABLE `t1` ( 986 `c1` date NOT NULL, 987 UNIQUE KEY `c1` (`c1`) 988) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1001ALTER TABLE t1 ADD UNIQUE INDEX (c1); 1002SHOW TABLES; 1003Tables_in_test 1004t1 1005SHOW CREATE TABLE t1; 1006Table Create Table 1007t1 CREATE TABLE `t1` ( 1008 `c1` time NOT NULL, 1009 UNIQUE KEY `c1` (`c1`) 1010) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 1022) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1023ALTER TABLE t1 ADD UNIQUE INDEX (c1); 1024SHOW TABLES; 1025Tables_in_test 1026t1 1027SHOW CREATE TABLE t1; 1028Table Create Table 1029t1 CREATE TABLE `t1` ( 1030 `c1` timestamp NOT NULL, 1031 UNIQUE KEY `c1` (`c1`) 1032) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1044) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1045ALTER TABLE t1 ADD UNIQUE INDEX (c1); 1046SHOW TABLES; 1047Tables_in_test 1048t1 1049SHOW CREATE TABLE t1; 1050Table Create Table 1051t1 CREATE TABLE `t1` ( 1052 `c1` year NOT NULL, 1053 UNIQUE KEY `c1` (`c1`) 1054) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1067ALTER TABLE t1 ADD CONSTRAINT UNIQUE (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 UNIQUE KEY `c1` (`c1`) 1076) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1088) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1089ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1090SHOW TABLES; 1091Tables_in_test 1092t1 1093SHOW CREATE TABLE t1; 1094Table Create Table 1095t1 CREATE TABLE `t1` ( 1096 `c1` tinyint NOT NULL, 1097 UNIQUE KEY `c1` (`c1`) 1098) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1110) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1111ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1112SHOW TABLES; 1113Tables_in_test 1114t1 1115SHOW CREATE TABLE t1; 1116Table Create Table 1117t1 CREATE TABLE `t1` ( 1118 `c1` smallint NOT NULL, 1119 UNIQUE KEY `c1` (`c1`) 1120) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1132) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1133ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1134SHOW TABLES; 1135Tables_in_test 1136t1 1137SHOW CREATE TABLE t1; 1138Table Create Table 1139t1 CREATE TABLE `t1` ( 1140 `c1` mediumint NOT NULL, 1141 UNIQUE KEY `c1` (`c1`) 1142) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1154) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1155ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1156SHOW TABLES; 1157Tables_in_test 1158t1 1159SHOW CREATE TABLE t1; 1160Table Create Table 1161t1 CREATE TABLE `t1` ( 1162 `c1` int NOT NULL, 1163 UNIQUE KEY `c1` (`c1`) 1164) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1176) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1177ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1178SHOW TABLES; 1179Tables_in_test 1180t1 1181SHOW CREATE TABLE t1; 1182Table Create Table 1183t1 CREATE TABLE `t1` ( 1184 `c1` int NOT NULL, 1185 UNIQUE KEY `c1` (`c1`) 1186) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1198) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1199ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1200SHOW TABLES; 1201Tables_in_test 1202t1 1203SHOW CREATE TABLE t1; 1204Table Create Table 1205t1 CREATE TABLE `t1` ( 1206 `c1` bigint NOT NULL, 1207 UNIQUE KEY `c1` (`c1`) 1208) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1221ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1222SHOW TABLES; 1223Tables_in_test 1224t1 1225SHOW CREATE TABLE t1; 1226Table Create Table 1227t1 CREATE TABLE `t1` ( 1228 `c1` double NOT NULL, 1229 UNIQUE KEY `c1` (`c1`) 1230) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1243ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1244SHOW TABLES; 1245Tables_in_test 1246t1 1247SHOW CREATE TABLE t1; 1248Table Create Table 1249t1 CREATE TABLE `t1` ( 1250 `c1` double NOT NULL, 1251 UNIQUE KEY `c1` (`c1`) 1252) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1265ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1266SHOW TABLES; 1267Tables_in_test 1268t1 1269SHOW CREATE TABLE t1; 1270Table Create Table 1271t1 CREATE TABLE `t1` ( 1272 `c1` float NOT NULL, 1273 UNIQUE KEY `c1` (`c1`) 1274) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1287ALTER TABLE t1 ADD CONSTRAINT UNIQUE (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 UNIQUE KEY `c1` (`c1`) 1296) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1309ALTER TABLE t1 ADD CONSTRAINT UNIQUE (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 UNIQUE KEY `c1` (`c1`) 1318) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1331ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1332SHOW TABLES; 1333Tables_in_test 1334t1 1335SHOW CREATE TABLE t1; 1336Table Create Table 1337t1 CREATE TABLE `t1` ( 1338 `c1` date NOT NULL, 1339 UNIQUE KEY `c1` (`c1`) 1340) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1353ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1354SHOW TABLES; 1355Tables_in_test 1356t1 1357SHOW CREATE TABLE t1; 1358Table Create Table 1359t1 CREATE TABLE `t1` ( 1360 `c1` time NOT NULL, 1361 UNIQUE KEY `c1` (`c1`) 1362) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 1374) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1375ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1376SHOW TABLES; 1377Tables_in_test 1378t1 1379SHOW CREATE TABLE t1; 1380Table Create Table 1381t1 CREATE TABLE `t1` ( 1382 `c1` timestamp NOT NULL, 1383 UNIQUE KEY `c1` (`c1`) 1384) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1396) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1397ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); 1398SHOW TABLES; 1399Tables_in_test 1400t1 1401SHOW CREATE TABLE t1; 1402Table Create Table 1403t1 CREATE TABLE `t1` ( 1404 `c1` year NOT NULL, 1405 UNIQUE KEY `c1` (`c1`) 1406) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1419ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (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 UNIQUE KEY `c1` (`c1`) 1428) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1440) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1441ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1442SHOW TABLES; 1443Tables_in_test 1444t1 1445SHOW CREATE TABLE t1; 1446Table Create Table 1447t1 CREATE TABLE `t1` ( 1448 `c1` tinyint NOT NULL, 1449 UNIQUE KEY `c1` (`c1`) 1450) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1462) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1463ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1464SHOW TABLES; 1465Tables_in_test 1466t1 1467SHOW CREATE TABLE t1; 1468Table Create Table 1469t1 CREATE TABLE `t1` ( 1470 `c1` smallint NOT NULL, 1471 UNIQUE KEY `c1` (`c1`) 1472) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1484) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1485ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1486SHOW TABLES; 1487Tables_in_test 1488t1 1489SHOW CREATE TABLE t1; 1490Table Create Table 1491t1 CREATE TABLE `t1` ( 1492 `c1` mediumint NOT NULL, 1493 UNIQUE KEY `c1` (`c1`) 1494) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1506) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1507ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1508SHOW TABLES; 1509Tables_in_test 1510t1 1511SHOW CREATE TABLE t1; 1512Table Create Table 1513t1 CREATE TABLE `t1` ( 1514 `c1` int NOT NULL, 1515 UNIQUE KEY `c1` (`c1`) 1516) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1528) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1529ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1530SHOW TABLES; 1531Tables_in_test 1532t1 1533SHOW CREATE TABLE t1; 1534Table Create Table 1535t1 CREATE TABLE `t1` ( 1536 `c1` int NOT NULL, 1537 UNIQUE KEY `c1` (`c1`) 1538) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1550) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1551ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1552SHOW TABLES; 1553Tables_in_test 1554t1 1555SHOW CREATE TABLE t1; 1556Table Create Table 1557t1 CREATE TABLE `t1` ( 1558 `c1` bigint NOT NULL, 1559 UNIQUE KEY `c1` (`c1`) 1560) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1573ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1574SHOW TABLES; 1575Tables_in_test 1576t1 1577SHOW CREATE TABLE t1; 1578Table Create Table 1579t1 CREATE TABLE `t1` ( 1580 `c1` double NOT NULL, 1581 UNIQUE KEY `c1` (`c1`) 1582) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1595ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1596SHOW TABLES; 1597Tables_in_test 1598t1 1599SHOW CREATE TABLE t1; 1600Table Create Table 1601t1 CREATE TABLE `t1` ( 1602 `c1` double NOT NULL, 1603 UNIQUE KEY `c1` (`c1`) 1604) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1617ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1618SHOW TABLES; 1619Tables_in_test 1620t1 1621SHOW CREATE TABLE t1; 1622Table Create Table 1623t1 CREATE TABLE `t1` ( 1624 `c1` float NOT NULL, 1625 UNIQUE KEY `c1` (`c1`) 1626) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1639ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (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 UNIQUE KEY `c1` (`c1`) 1648) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1661ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (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 UNIQUE KEY `c1` (`c1`) 1670) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1683ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1684SHOW TABLES; 1685Tables_in_test 1686t1 1687SHOW CREATE TABLE t1; 1688Table Create Table 1689t1 CREATE TABLE `t1` ( 1690 `c1` date NOT NULL, 1691 UNIQUE KEY `c1` (`c1`) 1692) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1705ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1706SHOW TABLES; 1707Tables_in_test 1708t1 1709SHOW CREATE TABLE t1; 1710Table Create Table 1711t1 CREATE TABLE `t1` ( 1712 `c1` time NOT NULL, 1713 UNIQUE KEY `c1` (`c1`) 1714) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 1726) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1727ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1728SHOW TABLES; 1729Tables_in_test 1730t1 1731SHOW CREATE TABLE t1; 1732Table Create Table 1733t1 CREATE TABLE `t1` ( 1734 `c1` timestamp NOT NULL, 1735 UNIQUE KEY `c1` (`c1`) 1736) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1748) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1749ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); 1750SHOW TABLES; 1751Tables_in_test 1752t1 1753SHOW CREATE TABLE t1; 1754Table Create Table 1755t1 CREATE TABLE `t1` ( 1756 `c1` year NOT NULL, 1757 UNIQUE KEY `c1` (`c1`) 1758) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1771ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (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 UNIQUE KEY `c1` (`c1`) 1780) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1792) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1793ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 1794SHOW TABLES; 1795Tables_in_test 1796t1 1797SHOW CREATE TABLE t1; 1798Table Create Table 1799t1 CREATE TABLE `t1` ( 1800 `c1` tinyint NOT NULL, 1801 UNIQUE KEY `c1` (`c1`) 1802) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1814) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1815ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 1816SHOW TABLES; 1817Tables_in_test 1818t1 1819SHOW CREATE TABLE t1; 1820Table Create Table 1821t1 CREATE TABLE `t1` ( 1822 `c1` smallint NOT NULL, 1823 UNIQUE KEY `c1` (`c1`) 1824) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1836) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1837ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 1838SHOW TABLES; 1839Tables_in_test 1840t1 1841SHOW CREATE TABLE t1; 1842Table Create Table 1843t1 CREATE TABLE `t1` ( 1844 `c1` mediumint NOT NULL, 1845 UNIQUE KEY `c1` (`c1`) 1846) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1858) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1859ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 1860SHOW TABLES; 1861Tables_in_test 1862t1 1863SHOW CREATE TABLE t1; 1864Table Create Table 1865t1 CREATE TABLE `t1` ( 1866 `c1` int NOT NULL, 1867 UNIQUE KEY `c1` (`c1`) 1868) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1880) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1881ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 1882SHOW TABLES; 1883Tables_in_test 1884t1 1885SHOW CREATE TABLE t1; 1886Table Create Table 1887t1 CREATE TABLE `t1` ( 1888 `c1` int NOT NULL, 1889 UNIQUE KEY `c1` (`c1`) 1890) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 1902) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1903ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 1904SHOW TABLES; 1905Tables_in_test 1906t1 1907SHOW CREATE TABLE t1; 1908Table Create Table 1909t1 CREATE TABLE `t1` ( 1910 `c1` bigint NOT NULL, 1911 UNIQUE KEY `c1` (`c1`) 1912) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1925ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 1926SHOW TABLES; 1927Tables_in_test 1928t1 1929SHOW CREATE TABLE t1; 1930Table Create Table 1931t1 CREATE TABLE `t1` ( 1932 `c1` double NOT NULL, 1933 UNIQUE KEY `c1` (`c1`) 1934) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1947ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 1948SHOW TABLES; 1949Tables_in_test 1950t1 1951SHOW CREATE TABLE t1; 1952Table Create Table 1953t1 CREATE TABLE `t1` ( 1954 `c1` double NOT NULL, 1955 UNIQUE KEY `c1` (`c1`) 1956) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1969ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 1970SHOW TABLES; 1971Tables_in_test 1972t1 1973SHOW CREATE TABLE t1; 1974Table Create Table 1975t1 CREATE TABLE `t1` ( 1976 `c1` float NOT NULL, 1977 UNIQUE KEY `c1` (`c1`) 1978) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1991ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (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 UNIQUE KEY `c1` (`c1`) 2000) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2013ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (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 UNIQUE KEY `c1` (`c1`) 2022) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2035ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 2036SHOW TABLES; 2037Tables_in_test 2038t1 2039SHOW CREATE TABLE t1; 2040Table Create Table 2041t1 CREATE TABLE `t1` ( 2042 `c1` date NOT NULL, 2043 UNIQUE KEY `c1` (`c1`) 2044) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2057ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 2058SHOW TABLES; 2059Tables_in_test 2060t1 2061SHOW CREATE TABLE t1; 2062Table Create Table 2063t1 CREATE TABLE `t1` ( 2064 `c1` time NOT NULL, 2065 UNIQUE KEY `c1` (`c1`) 2066) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 2078) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2079ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 2080SHOW TABLES; 2081Tables_in_test 2082t1 2083SHOW CREATE TABLE t1; 2084Table Create Table 2085t1 CREATE TABLE `t1` ( 2086 `c1` timestamp NOT NULL, 2087 UNIQUE KEY `c1` (`c1`) 2088) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2100) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2101ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); 2102SHOW TABLES; 2103Tables_in_test 2104t1 2105SHOW CREATE TABLE t1; 2106Table Create Table 2107t1 CREATE TABLE `t1` ( 2108 `c1` year NOT NULL, 2109 UNIQUE KEY `c1` (`c1`) 2110) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2123ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (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 UNIQUE KEY `cst1` (`c1`) 2132) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2144) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2145ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2146SHOW TABLES; 2147Tables_in_test 2148t1 2149SHOW CREATE TABLE t1; 2150Table Create Table 2151t1 CREATE TABLE `t1` ( 2152 `c1` tinyint NOT NULL, 2153 UNIQUE KEY `cst1` (`c1`) 2154) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2166) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2167ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2168SHOW TABLES; 2169Tables_in_test 2170t1 2171SHOW CREATE TABLE t1; 2172Table Create Table 2173t1 CREATE TABLE `t1` ( 2174 `c1` smallint NOT NULL, 2175 UNIQUE KEY `cst1` (`c1`) 2176) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2188) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2189ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2190SHOW TABLES; 2191Tables_in_test 2192t1 2193SHOW CREATE TABLE t1; 2194Table Create Table 2195t1 CREATE TABLE `t1` ( 2196 `c1` mediumint NOT NULL, 2197 UNIQUE KEY `cst1` (`c1`) 2198) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2210) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2211ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2212SHOW TABLES; 2213Tables_in_test 2214t1 2215SHOW CREATE TABLE t1; 2216Table Create Table 2217t1 CREATE TABLE `t1` ( 2218 `c1` int NOT NULL, 2219 UNIQUE KEY `cst1` (`c1`) 2220) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2232) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2233ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2234SHOW TABLES; 2235Tables_in_test 2236t1 2237SHOW CREATE TABLE t1; 2238Table Create Table 2239t1 CREATE TABLE `t1` ( 2240 `c1` int NOT NULL, 2241 UNIQUE KEY `cst1` (`c1`) 2242) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2254) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2255ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2256SHOW TABLES; 2257Tables_in_test 2258t1 2259SHOW CREATE TABLE t1; 2260Table Create Table 2261t1 CREATE TABLE `t1` ( 2262 `c1` bigint NOT NULL, 2263 UNIQUE KEY `cst1` (`c1`) 2264) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2277ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2278SHOW TABLES; 2279Tables_in_test 2280t1 2281SHOW CREATE TABLE t1; 2282Table Create Table 2283t1 CREATE TABLE `t1` ( 2284 `c1` double NOT NULL, 2285 UNIQUE KEY `cst1` (`c1`) 2286) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2299ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2300SHOW TABLES; 2301Tables_in_test 2302t1 2303SHOW CREATE TABLE t1; 2304Table Create Table 2305t1 CREATE TABLE `t1` ( 2306 `c1` double NOT NULL, 2307 UNIQUE KEY `cst1` (`c1`) 2308) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2321ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2322SHOW TABLES; 2323Tables_in_test 2324t1 2325SHOW CREATE TABLE t1; 2326Table Create Table 2327t1 CREATE TABLE `t1` ( 2328 `c1` float NOT NULL, 2329 UNIQUE KEY `cst1` (`c1`) 2330) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2343ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (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 UNIQUE KEY `cst1` (`c1`) 2352) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2365ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (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 UNIQUE KEY `cst1` (`c1`) 2374) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2387ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2388SHOW TABLES; 2389Tables_in_test 2390t1 2391SHOW CREATE TABLE t1; 2392Table Create Table 2393t1 CREATE TABLE `t1` ( 2394 `c1` date NOT NULL, 2395 UNIQUE KEY `cst1` (`c1`) 2396) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2409ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2410SHOW TABLES; 2411Tables_in_test 2412t1 2413SHOW CREATE TABLE t1; 2414Table Create Table 2415t1 CREATE TABLE `t1` ( 2416 `c1` time NOT NULL, 2417 UNIQUE KEY `cst1` (`c1`) 2418) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 2430) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2431ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2432SHOW TABLES; 2433Tables_in_test 2434t1 2435SHOW CREATE TABLE t1; 2436Table Create Table 2437t1 CREATE TABLE `t1` ( 2438 `c1` timestamp NOT NULL, 2439 UNIQUE KEY `cst1` (`c1`) 2440) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2452) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2453ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); 2454SHOW TABLES; 2455Tables_in_test 2456t1 2457SHOW CREATE TABLE t1; 2458Table Create Table 2459t1 CREATE TABLE `t1` ( 2460 `c1` year NOT NULL, 2461 UNIQUE KEY `cst1` (`c1`) 2462) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2475ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (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 UNIQUE KEY `cst1` (`c1`) 2484) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2496) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2497ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2498SHOW TABLES; 2499Tables_in_test 2500t1 2501SHOW CREATE TABLE t1; 2502Table Create Table 2503t1 CREATE TABLE `t1` ( 2504 `c1` tinyint NOT NULL, 2505 UNIQUE KEY `cst1` (`c1`) 2506) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2518) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2519ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2520SHOW TABLES; 2521Tables_in_test 2522t1 2523SHOW CREATE TABLE t1; 2524Table Create Table 2525t1 CREATE TABLE `t1` ( 2526 `c1` smallint NOT NULL, 2527 UNIQUE KEY `cst1` (`c1`) 2528) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2540) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2541ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2542SHOW TABLES; 2543Tables_in_test 2544t1 2545SHOW CREATE TABLE t1; 2546Table Create Table 2547t1 CREATE TABLE `t1` ( 2548 `c1` mediumint NOT NULL, 2549 UNIQUE KEY `cst1` (`c1`) 2550) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2562) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2563ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2564SHOW TABLES; 2565Tables_in_test 2566t1 2567SHOW CREATE TABLE t1; 2568Table Create Table 2569t1 CREATE TABLE `t1` ( 2570 `c1` int NOT NULL, 2571 UNIQUE KEY `cst1` (`c1`) 2572) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2584) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2585ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2586SHOW TABLES; 2587Tables_in_test 2588t1 2589SHOW CREATE TABLE t1; 2590Table Create Table 2591t1 CREATE TABLE `t1` ( 2592 `c1` int NOT NULL, 2593 UNIQUE KEY `cst1` (`c1`) 2594) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2606) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2607ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2608SHOW TABLES; 2609Tables_in_test 2610t1 2611SHOW CREATE TABLE t1; 2612Table Create Table 2613t1 CREATE TABLE `t1` ( 2614 `c1` bigint NOT NULL, 2615 UNIQUE KEY `cst1` (`c1`) 2616) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2629ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2630SHOW TABLES; 2631Tables_in_test 2632t1 2633SHOW CREATE TABLE t1; 2634Table Create Table 2635t1 CREATE TABLE `t1` ( 2636 `c1` double NOT NULL, 2637 UNIQUE KEY `cst1` (`c1`) 2638) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2651ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2652SHOW TABLES; 2653Tables_in_test 2654t1 2655SHOW CREATE TABLE t1; 2656Table Create Table 2657t1 CREATE TABLE `t1` ( 2658 `c1` double NOT NULL, 2659 UNIQUE KEY `cst1` (`c1`) 2660) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2673ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2674SHOW TABLES; 2675Tables_in_test 2676t1 2677SHOW CREATE TABLE t1; 2678Table Create Table 2679t1 CREATE TABLE `t1` ( 2680 `c1` float NOT NULL, 2681 UNIQUE KEY `cst1` (`c1`) 2682) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2695ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (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 UNIQUE KEY `cst1` (`c1`) 2704) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2717ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (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 UNIQUE KEY `cst1` (`c1`) 2726) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2739ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2740SHOW TABLES; 2741Tables_in_test 2742t1 2743SHOW CREATE TABLE t1; 2744Table Create Table 2745t1 CREATE TABLE `t1` ( 2746 `c1` date NOT NULL, 2747 UNIQUE KEY `cst1` (`c1`) 2748) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2761ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2762SHOW TABLES; 2763Tables_in_test 2764t1 2765SHOW CREATE TABLE t1; 2766Table Create Table 2767t1 CREATE TABLE `t1` ( 2768 `c1` time NOT NULL, 2769 UNIQUE KEY `cst1` (`c1`) 2770) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 2782) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2783ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2784SHOW TABLES; 2785Tables_in_test 2786t1 2787SHOW CREATE TABLE t1; 2788Table Create Table 2789t1 CREATE TABLE `t1` ( 2790 `c1` timestamp NOT NULL, 2791 UNIQUE KEY `cst1` (`c1`) 2792) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2804) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2805ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); 2806SHOW TABLES; 2807Tables_in_test 2808t1 2809SHOW CREATE TABLE t1; 2810Table Create Table 2811t1 CREATE TABLE `t1` ( 2812 `c1` year NOT NULL, 2813 UNIQUE KEY `cst1` (`c1`) 2814) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2827ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (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 UNIQUE KEY `cst1` (`c1`) 2836) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2848) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2849ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 2850SHOW TABLES; 2851Tables_in_test 2852t1 2853SHOW CREATE TABLE t1; 2854Table Create Table 2855t1 CREATE TABLE `t1` ( 2856 `c1` tinyint NOT NULL, 2857 UNIQUE KEY `cst1` (`c1`) 2858) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2870) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2871ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 2872SHOW TABLES; 2873Tables_in_test 2874t1 2875SHOW CREATE TABLE t1; 2876Table Create Table 2877t1 CREATE TABLE `t1` ( 2878 `c1` smallint NOT NULL, 2879 UNIQUE KEY `cst1` (`c1`) 2880) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2892) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2893ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 2894SHOW TABLES; 2895Tables_in_test 2896t1 2897SHOW CREATE TABLE t1; 2898Table Create Table 2899t1 CREATE TABLE `t1` ( 2900 `c1` mediumint NOT NULL, 2901 UNIQUE KEY `cst1` (`c1`) 2902) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2914) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2915ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 2916SHOW TABLES; 2917Tables_in_test 2918t1 2919SHOW CREATE TABLE t1; 2920Table Create Table 2921t1 CREATE TABLE `t1` ( 2922 `c1` int NOT NULL, 2923 UNIQUE KEY `cst1` (`c1`) 2924) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2936) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2937ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 2938SHOW TABLES; 2939Tables_in_test 2940t1 2941SHOW CREATE TABLE t1; 2942Table Create Table 2943t1 CREATE TABLE `t1` ( 2944 `c1` int NOT NULL, 2945 UNIQUE KEY `cst1` (`c1`) 2946) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 2958) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2959ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 2960SHOW TABLES; 2961Tables_in_test 2962t1 2963SHOW CREATE TABLE t1; 2964Table Create Table 2965t1 CREATE TABLE `t1` ( 2966 `c1` bigint NOT NULL, 2967 UNIQUE KEY `cst1` (`c1`) 2968) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 2981ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 2982SHOW TABLES; 2983Tables_in_test 2984t1 2985SHOW CREATE TABLE t1; 2986Table Create Table 2987t1 CREATE TABLE `t1` ( 2988 `c1` double NOT NULL, 2989 UNIQUE KEY `cst1` (`c1`) 2990) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3003ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 3004SHOW TABLES; 3005Tables_in_test 3006t1 3007SHOW CREATE TABLE t1; 3008Table Create Table 3009t1 CREATE TABLE `t1` ( 3010 `c1` double NOT NULL, 3011 UNIQUE KEY `cst1` (`c1`) 3012) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3025ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 3026SHOW TABLES; 3027Tables_in_test 3028t1 3029SHOW CREATE TABLE t1; 3030Table Create Table 3031t1 CREATE TABLE `t1` ( 3032 `c1` float NOT NULL, 3033 UNIQUE KEY `cst1` (`c1`) 3034) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3047ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (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 UNIQUE KEY `cst1` (`c1`) 3056) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3069ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (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 UNIQUE KEY `cst1` (`c1`) 3078) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3091ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 3092SHOW TABLES; 3093Tables_in_test 3094t1 3095SHOW CREATE TABLE t1; 3096Table Create Table 3097t1 CREATE TABLE `t1` ( 3098 `c1` date NOT NULL, 3099 UNIQUE KEY `cst1` (`c1`) 3100) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3113ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 3114SHOW TABLES; 3115Tables_in_test 3116t1 3117SHOW CREATE TABLE t1; 3118Table Create Table 3119t1 CREATE TABLE `t1` ( 3120 `c1` time NOT NULL, 3121 UNIQUE KEY `cst1` (`c1`) 3122) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 3134) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3135ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 3136SHOW TABLES; 3137Tables_in_test 3138t1 3139SHOW CREATE TABLE t1; 3140Table Create Table 3141t1 CREATE TABLE `t1` ( 3142 `c1` timestamp NOT NULL, 3143 UNIQUE KEY `cst1` (`c1`) 3144) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3156) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3157ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); 3158SHOW TABLES; 3159Tables_in_test 3160t1 3161SHOW CREATE TABLE t1; 3162Table Create Table 3163t1 CREATE TABLE `t1` ( 3164 `c1` year NOT NULL, 3165 UNIQUE KEY `cst1` (`c1`) 3166) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3179ALTER TABLE t1 ADD UNIQUE 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 UNIQUE KEY `i1` (`c1`) 3188) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3200) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3201ALTER TABLE t1 ADD UNIQUE i1 (c1); 3202SHOW TABLES; 3203Tables_in_test 3204t1 3205SHOW CREATE TABLE t1; 3206Table Create Table 3207t1 CREATE TABLE `t1` ( 3208 `c1` tinyint NOT NULL, 3209 UNIQUE KEY `i1` (`c1`) 3210) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3222) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3223ALTER TABLE t1 ADD UNIQUE i1 (c1); 3224SHOW TABLES; 3225Tables_in_test 3226t1 3227SHOW CREATE TABLE t1; 3228Table Create Table 3229t1 CREATE TABLE `t1` ( 3230 `c1` smallint NOT NULL, 3231 UNIQUE KEY `i1` (`c1`) 3232) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3244) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3245ALTER TABLE t1 ADD UNIQUE i1 (c1); 3246SHOW TABLES; 3247Tables_in_test 3248t1 3249SHOW CREATE TABLE t1; 3250Table Create Table 3251t1 CREATE TABLE `t1` ( 3252 `c1` mediumint NOT NULL, 3253 UNIQUE KEY `i1` (`c1`) 3254) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3266) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3267ALTER TABLE t1 ADD UNIQUE i1 (c1); 3268SHOW TABLES; 3269Tables_in_test 3270t1 3271SHOW CREATE TABLE t1; 3272Table Create Table 3273t1 CREATE TABLE `t1` ( 3274 `c1` int NOT NULL, 3275 UNIQUE KEY `i1` (`c1`) 3276) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3288) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3289ALTER TABLE t1 ADD UNIQUE i1 (c1); 3290SHOW TABLES; 3291Tables_in_test 3292t1 3293SHOW CREATE TABLE t1; 3294Table Create Table 3295t1 CREATE TABLE `t1` ( 3296 `c1` int NOT NULL, 3297 UNIQUE KEY `i1` (`c1`) 3298) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3310) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3311ALTER TABLE t1 ADD UNIQUE i1 (c1); 3312SHOW TABLES; 3313Tables_in_test 3314t1 3315SHOW CREATE TABLE t1; 3316Table Create Table 3317t1 CREATE TABLE `t1` ( 3318 `c1` bigint NOT NULL, 3319 UNIQUE KEY `i1` (`c1`) 3320) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3333ALTER TABLE t1 ADD UNIQUE 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 UNIQUE KEY `i1` (`c1`) 3342) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3355ALTER TABLE t1 ADD UNIQUE 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 UNIQUE KEY `i1` (`c1`) 3364) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3377ALTER TABLE t1 ADD UNIQUE 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 UNIQUE KEY `i1` (`c1`) 3386) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3399ALTER TABLE t1 ADD UNIQUE 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 UNIQUE KEY `i1` (`c1`) 3408) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3421ALTER TABLE t1 ADD UNIQUE 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 UNIQUE KEY `i1` (`c1`) 3430) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3443ALTER TABLE t1 ADD UNIQUE 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 UNIQUE KEY `i1` (`c1`) 3452) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3465ALTER TABLE t1 ADD UNIQUE 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 UNIQUE KEY `i1` (`c1`) 3474) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 3486) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3487ALTER TABLE t1 ADD UNIQUE i1 (c1); 3488SHOW TABLES; 3489Tables_in_test 3490t1 3491SHOW CREATE TABLE t1; 3492Table Create Table 3493t1 CREATE TABLE `t1` ( 3494 `c1` timestamp NOT NULL, 3495 UNIQUE KEY `i1` (`c1`) 3496) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3508) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3509ALTER TABLE t1 ADD UNIQUE i1 (c1); 3510SHOW TABLES; 3511Tables_in_test 3512t1 3513SHOW CREATE TABLE t1; 3514Table Create Table 3515t1 CREATE TABLE `t1` ( 3516 `c1` year NOT NULL, 3517 UNIQUE KEY `i1` (`c1`) 3518) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3531ALTER TABLE t1 ADD UNIQUE KEY i1 (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 UNIQUE KEY `i1` (`c1`) 3540) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3552) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3553ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3554SHOW TABLES; 3555Tables_in_test 3556t1 3557SHOW CREATE TABLE t1; 3558Table Create Table 3559t1 CREATE TABLE `t1` ( 3560 `c1` tinyint NOT NULL, 3561 UNIQUE KEY `i1` (`c1`) 3562) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3574) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3575ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3576SHOW TABLES; 3577Tables_in_test 3578t1 3579SHOW CREATE TABLE t1; 3580Table Create Table 3581t1 CREATE TABLE `t1` ( 3582 `c1` smallint NOT NULL, 3583 UNIQUE KEY `i1` (`c1`) 3584) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3596) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3597ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3598SHOW TABLES; 3599Tables_in_test 3600t1 3601SHOW CREATE TABLE t1; 3602Table Create Table 3603t1 CREATE TABLE `t1` ( 3604 `c1` mediumint NOT NULL, 3605 UNIQUE KEY `i1` (`c1`) 3606) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3618) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3619ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3620SHOW TABLES; 3621Tables_in_test 3622t1 3623SHOW CREATE TABLE t1; 3624Table Create Table 3625t1 CREATE TABLE `t1` ( 3626 `c1` int NOT NULL, 3627 UNIQUE KEY `i1` (`c1`) 3628) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3640) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3641ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3642SHOW TABLES; 3643Tables_in_test 3644t1 3645SHOW CREATE TABLE t1; 3646Table Create Table 3647t1 CREATE TABLE `t1` ( 3648 `c1` int NOT NULL, 3649 UNIQUE KEY `i1` (`c1`) 3650) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3662) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3663ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3664SHOW TABLES; 3665Tables_in_test 3666t1 3667SHOW CREATE TABLE t1; 3668Table Create Table 3669t1 CREATE TABLE `t1` ( 3670 `c1` bigint NOT NULL, 3671 UNIQUE KEY `i1` (`c1`) 3672) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3685ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3686SHOW TABLES; 3687Tables_in_test 3688t1 3689SHOW CREATE TABLE t1; 3690Table Create Table 3691t1 CREATE TABLE `t1` ( 3692 `c1` double NOT NULL, 3693 UNIQUE KEY `i1` (`c1`) 3694) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3707ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3708SHOW TABLES; 3709Tables_in_test 3710t1 3711SHOW CREATE TABLE t1; 3712Table Create Table 3713t1 CREATE TABLE `t1` ( 3714 `c1` double NOT NULL, 3715 UNIQUE KEY `i1` (`c1`) 3716) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3729ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3730SHOW TABLES; 3731Tables_in_test 3732t1 3733SHOW CREATE TABLE t1; 3734Table Create Table 3735t1 CREATE TABLE `t1` ( 3736 `c1` float NOT NULL, 3737 UNIQUE KEY `i1` (`c1`) 3738) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3751ALTER TABLE t1 ADD UNIQUE KEY i1 (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 UNIQUE KEY `i1` (`c1`) 3760) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3773ALTER TABLE t1 ADD UNIQUE KEY i1 (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 UNIQUE KEY `i1` (`c1`) 3782) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3795ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3796SHOW TABLES; 3797Tables_in_test 3798t1 3799SHOW CREATE TABLE t1; 3800Table Create Table 3801t1 CREATE TABLE `t1` ( 3802 `c1` date NOT NULL, 3803 UNIQUE KEY `i1` (`c1`) 3804) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3817ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3818SHOW TABLES; 3819Tables_in_test 3820t1 3821SHOW CREATE TABLE t1; 3822Table Create Table 3823t1 CREATE TABLE `t1` ( 3824 `c1` time NOT NULL, 3825 UNIQUE KEY `i1` (`c1`) 3826) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 3838) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3839ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3840SHOW TABLES; 3841Tables_in_test 3842t1 3843SHOW CREATE TABLE t1; 3844Table Create Table 3845t1 CREATE TABLE `t1` ( 3846 `c1` timestamp NOT NULL, 3847 UNIQUE KEY `i1` (`c1`) 3848) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3860) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3861ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); 3862SHOW TABLES; 3863Tables_in_test 3864t1 3865SHOW CREATE TABLE t1; 3866Table Create Table 3867t1 CREATE TABLE `t1` ( 3868 `c1` year NOT NULL, 3869 UNIQUE KEY `i1` (`c1`) 3870) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3883ALTER TABLE t1 ADD UNIQUE INDEX i1 (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 UNIQUE KEY `i1` (`c1`) 3892) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3904) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3905ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 3906SHOW TABLES; 3907Tables_in_test 3908t1 3909SHOW CREATE TABLE t1; 3910Table Create Table 3911t1 CREATE TABLE `t1` ( 3912 `c1` tinyint NOT NULL, 3913 UNIQUE KEY `i1` (`c1`) 3914) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3926) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3927ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 3928SHOW TABLES; 3929Tables_in_test 3930t1 3931SHOW CREATE TABLE t1; 3932Table Create Table 3933t1 CREATE TABLE `t1` ( 3934 `c1` smallint NOT NULL, 3935 UNIQUE KEY `i1` (`c1`) 3936) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3948) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3949ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 3950SHOW TABLES; 3951Tables_in_test 3952t1 3953SHOW CREATE TABLE t1; 3954Table Create Table 3955t1 CREATE TABLE `t1` ( 3956 `c1` mediumint NOT NULL, 3957 UNIQUE KEY `i1` (`c1`) 3958) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3970) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3971ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 3972SHOW TABLES; 3973Tables_in_test 3974t1 3975SHOW CREATE TABLE t1; 3976Table Create Table 3977t1 CREATE TABLE `t1` ( 3978 `c1` int NOT NULL, 3979 UNIQUE KEY `i1` (`c1`) 3980) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 3992) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 3993ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 3994SHOW TABLES; 3995Tables_in_test 3996t1 3997SHOW CREATE TABLE t1; 3998Table Create Table 3999t1 CREATE TABLE `t1` ( 4000 `c1` int NOT NULL, 4001 UNIQUE KEY `i1` (`c1`) 4002) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 4014) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4015ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 4016SHOW TABLES; 4017Tables_in_test 4018t1 4019SHOW CREATE TABLE t1; 4020Table Create Table 4021t1 CREATE TABLE `t1` ( 4022 `c1` bigint NOT NULL, 4023 UNIQUE KEY `i1` (`c1`) 4024) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4037ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 4038SHOW TABLES; 4039Tables_in_test 4040t1 4041SHOW CREATE TABLE t1; 4042Table Create Table 4043t1 CREATE TABLE `t1` ( 4044 `c1` double NOT NULL, 4045 UNIQUE KEY `i1` (`c1`) 4046) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4059ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 4060SHOW TABLES; 4061Tables_in_test 4062t1 4063SHOW CREATE TABLE t1; 4064Table Create Table 4065t1 CREATE TABLE `t1` ( 4066 `c1` double NOT NULL, 4067 UNIQUE KEY `i1` (`c1`) 4068) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4081ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 4082SHOW TABLES; 4083Tables_in_test 4084t1 4085SHOW CREATE TABLE t1; 4086Table Create Table 4087t1 CREATE TABLE `t1` ( 4088 `c1` float NOT NULL, 4089 UNIQUE KEY `i1` (`c1`) 4090) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4103ALTER TABLE t1 ADD UNIQUE INDEX i1 (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 UNIQUE KEY `i1` (`c1`) 4112) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4125ALTER TABLE t1 ADD UNIQUE INDEX i1 (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 UNIQUE KEY `i1` (`c1`) 4134) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4147ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 4148SHOW TABLES; 4149Tables_in_test 4150t1 4151SHOW CREATE TABLE t1; 4152Table Create Table 4153t1 CREATE TABLE `t1` ( 4154 `c1` date NOT NULL, 4155 UNIQUE KEY `i1` (`c1`) 4156) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4169ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 4170SHOW TABLES; 4171Tables_in_test 4172t1 4173SHOW CREATE TABLE t1; 4174Table Create Table 4175t1 CREATE TABLE `t1` ( 4176 `c1` time NOT NULL, 4177 UNIQUE KEY `i1` (`c1`) 4178) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 4190) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4191ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 4192SHOW TABLES; 4193Tables_in_test 4194t1 4195SHOW CREATE TABLE t1; 4196Table Create Table 4197t1 CREATE TABLE `t1` ( 4198 `c1` timestamp NOT NULL, 4199 UNIQUE KEY `i1` (`c1`) 4200) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 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 NOT NULL 4212) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4213ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); 4214SHOW TABLES; 4215Tables_in_test 4216t1 4217SHOW CREATE TABLE t1; 4218Table Create Table 4219t1 CREATE TABLE `t1` ( 4220 `c1` year NOT NULL, 4221 UNIQUE KEY `i1` (`c1`) 4222) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4223DROP TABLE t1; 4224SHOW TABLES; 4225Tables_in_test 4226CREATE TABLE t1(c1 BIT NOT NULL); 4227SHOW TABLES; 4228Tables_in_test 4229t1 4230SHOW CREATE TABLE t1; 4231Table Create Table 4232t1 CREATE TABLE `t1` ( 4233 `c1` bit(1) NOT NULL 4234) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4235ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4236SHOW TABLES; 4237Tables_in_test 4238t1 4239SHOW CREATE TABLE t1; 4240Table Create Table 4241t1 CREATE TABLE `t1` ( 4242 `c1` bit(1) NOT NULL, 4243 UNIQUE KEY `i1` (`c1`) 4244) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4245DROP TABLE t1; 4246SHOW TABLES; 4247Tables_in_test 4248CREATE TABLE t1(c1 TINYINT NOT NULL); 4249SHOW TABLES; 4250Tables_in_test 4251t1 4252SHOW CREATE TABLE t1; 4253Table Create Table 4254t1 CREATE TABLE `t1` ( 4255 `c1` tinyint NOT NULL 4256) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4257ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4258SHOW TABLES; 4259Tables_in_test 4260t1 4261SHOW CREATE TABLE t1; 4262Table Create Table 4263t1 CREATE TABLE `t1` ( 4264 `c1` tinyint NOT NULL, 4265 UNIQUE KEY `i1` (`c1`) 4266) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4267DROP TABLE t1; 4268SHOW TABLES; 4269Tables_in_test 4270CREATE TABLE t1(c1 SMALLINT NOT NULL); 4271SHOW TABLES; 4272Tables_in_test 4273t1 4274SHOW CREATE TABLE t1; 4275Table Create Table 4276t1 CREATE TABLE `t1` ( 4277 `c1` smallint NOT NULL 4278) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4279ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4280SHOW TABLES; 4281Tables_in_test 4282t1 4283SHOW CREATE TABLE t1; 4284Table Create Table 4285t1 CREATE TABLE `t1` ( 4286 `c1` smallint NOT NULL, 4287 UNIQUE KEY `i1` (`c1`) 4288) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4289DROP TABLE t1; 4290SHOW TABLES; 4291Tables_in_test 4292CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 4293SHOW TABLES; 4294Tables_in_test 4295t1 4296SHOW CREATE TABLE t1; 4297Table Create Table 4298t1 CREATE TABLE `t1` ( 4299 `c1` mediumint NOT NULL 4300) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4301ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4302SHOW TABLES; 4303Tables_in_test 4304t1 4305SHOW CREATE TABLE t1; 4306Table Create Table 4307t1 CREATE TABLE `t1` ( 4308 `c1` mediumint NOT NULL, 4309 UNIQUE KEY `i1` (`c1`) 4310) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4311DROP TABLE t1; 4312SHOW TABLES; 4313Tables_in_test 4314CREATE TABLE t1(c1 INT NOT NULL); 4315SHOW TABLES; 4316Tables_in_test 4317t1 4318SHOW CREATE TABLE t1; 4319Table Create Table 4320t1 CREATE TABLE `t1` ( 4321 `c1` int NOT NULL 4322) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4323ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4324SHOW TABLES; 4325Tables_in_test 4326t1 4327SHOW CREATE TABLE t1; 4328Table Create Table 4329t1 CREATE TABLE `t1` ( 4330 `c1` int NOT NULL, 4331 UNIQUE KEY `i1` (`c1`) 4332) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4333DROP TABLE t1; 4334SHOW TABLES; 4335Tables_in_test 4336CREATE TABLE t1(c1 INTEGER NOT NULL); 4337SHOW TABLES; 4338Tables_in_test 4339t1 4340SHOW CREATE TABLE t1; 4341Table Create Table 4342t1 CREATE TABLE `t1` ( 4343 `c1` int NOT NULL 4344) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4345ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4346SHOW TABLES; 4347Tables_in_test 4348t1 4349SHOW CREATE TABLE t1; 4350Table Create Table 4351t1 CREATE TABLE `t1` ( 4352 `c1` int NOT NULL, 4353 UNIQUE KEY `i1` (`c1`) 4354) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4355DROP TABLE t1; 4356SHOW TABLES; 4357Tables_in_test 4358CREATE TABLE t1(c1 BIGINT NOT NULL); 4359SHOW TABLES; 4360Tables_in_test 4361t1 4362SHOW CREATE TABLE t1; 4363Table Create Table 4364t1 CREATE TABLE `t1` ( 4365 `c1` bigint NOT NULL 4366) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4367ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4368SHOW TABLES; 4369Tables_in_test 4370t1 4371SHOW CREATE TABLE t1; 4372Table Create Table 4373t1 CREATE TABLE `t1` ( 4374 `c1` bigint NOT NULL, 4375 UNIQUE KEY `i1` (`c1`) 4376) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4377DROP TABLE t1; 4378SHOW TABLES; 4379Tables_in_test 4380CREATE TABLE t1(c1 REAL NOT NULL); 4381SHOW TABLES; 4382Tables_in_test 4383t1 4384SHOW CREATE TABLE t1; 4385Table Create Table 4386t1 CREATE TABLE `t1` ( 4387 `c1` double NOT NULL 4388) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4389ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4390SHOW TABLES; 4391Tables_in_test 4392t1 4393SHOW CREATE TABLE t1; 4394Table Create Table 4395t1 CREATE TABLE `t1` ( 4396 `c1` double NOT NULL, 4397 UNIQUE KEY `i1` (`c1`) 4398) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4399DROP TABLE t1; 4400SHOW TABLES; 4401Tables_in_test 4402CREATE TABLE t1(c1 DOUBLE NOT NULL); 4403SHOW TABLES; 4404Tables_in_test 4405t1 4406SHOW CREATE TABLE t1; 4407Table Create Table 4408t1 CREATE TABLE `t1` ( 4409 `c1` double NOT NULL 4410) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4411ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4412SHOW TABLES; 4413Tables_in_test 4414t1 4415SHOW CREATE TABLE t1; 4416Table Create Table 4417t1 CREATE TABLE `t1` ( 4418 `c1` double NOT NULL, 4419 UNIQUE KEY `i1` (`c1`) 4420) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4421DROP TABLE t1; 4422SHOW TABLES; 4423Tables_in_test 4424CREATE TABLE t1(c1 FLOAT NOT NULL); 4425SHOW TABLES; 4426Tables_in_test 4427t1 4428SHOW CREATE TABLE t1; 4429Table Create Table 4430t1 CREATE TABLE `t1` ( 4431 `c1` float NOT NULL 4432) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4433ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4434SHOW TABLES; 4435Tables_in_test 4436t1 4437SHOW CREATE TABLE t1; 4438Table Create Table 4439t1 CREATE TABLE `t1` ( 4440 `c1` float NOT NULL, 4441 UNIQUE KEY `i1` (`c1`) 4442) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4443DROP TABLE t1; 4444SHOW TABLES; 4445Tables_in_test 4446CREATE TABLE t1(c1 DECIMAL NOT NULL); 4447SHOW TABLES; 4448Tables_in_test 4449t1 4450SHOW CREATE TABLE t1; 4451Table Create Table 4452t1 CREATE TABLE `t1` ( 4453 `c1` decimal(10,0) NOT NULL 4454) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4455ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4456SHOW TABLES; 4457Tables_in_test 4458t1 4459SHOW CREATE TABLE t1; 4460Table Create Table 4461t1 CREATE TABLE `t1` ( 4462 `c1` decimal(10,0) NOT NULL, 4463 UNIQUE KEY `i1` (`c1`) 4464) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4465DROP TABLE t1; 4466SHOW TABLES; 4467Tables_in_test 4468CREATE TABLE t1(c1 NUMERIC NOT NULL); 4469SHOW TABLES; 4470Tables_in_test 4471t1 4472SHOW CREATE TABLE t1; 4473Table Create Table 4474t1 CREATE TABLE `t1` ( 4475 `c1` decimal(10,0) NOT NULL 4476) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4477ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4478SHOW TABLES; 4479Tables_in_test 4480t1 4481SHOW CREATE TABLE t1; 4482Table Create Table 4483t1 CREATE TABLE `t1` ( 4484 `c1` decimal(10,0) NOT NULL, 4485 UNIQUE KEY `i1` (`c1`) 4486) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4487DROP TABLE t1; 4488SHOW TABLES; 4489Tables_in_test 4490CREATE TABLE t1(c1 DATE NOT NULL); 4491SHOW TABLES; 4492Tables_in_test 4493t1 4494SHOW CREATE TABLE t1; 4495Table Create Table 4496t1 CREATE TABLE `t1` ( 4497 `c1` date NOT NULL 4498) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4499ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4500SHOW TABLES; 4501Tables_in_test 4502t1 4503SHOW CREATE TABLE t1; 4504Table Create Table 4505t1 CREATE TABLE `t1` ( 4506 `c1` date NOT NULL, 4507 UNIQUE KEY `i1` (`c1`) 4508) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4509DROP TABLE t1; 4510SHOW TABLES; 4511Tables_in_test 4512CREATE TABLE t1(c1 TIME NOT NULL); 4513SHOW TABLES; 4514Tables_in_test 4515t1 4516SHOW CREATE TABLE t1; 4517Table Create Table 4518t1 CREATE TABLE `t1` ( 4519 `c1` time NOT NULL 4520) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4521ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4522SHOW TABLES; 4523Tables_in_test 4524t1 4525SHOW CREATE TABLE t1; 4526Table Create Table 4527t1 CREATE TABLE `t1` ( 4528 `c1` time NOT NULL, 4529 UNIQUE KEY `i1` (`c1`) 4530) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4531DROP TABLE t1; 4532SHOW TABLES; 4533Tables_in_test 4534CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 4535SHOW TABLES; 4536Tables_in_test 4537t1 4538SHOW CREATE TABLE t1; 4539Table Create Table 4540t1 CREATE TABLE `t1` ( 4541 `c1` timestamp NOT NULL 4542) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4543ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4544SHOW TABLES; 4545Tables_in_test 4546t1 4547SHOW CREATE TABLE t1; 4548Table Create Table 4549t1 CREATE TABLE `t1` ( 4550 `c1` timestamp NOT NULL, 4551 UNIQUE KEY `i1` (`c1`) 4552) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4553DROP TABLE t1; 4554SHOW TABLES; 4555Tables_in_test 4556CREATE TABLE t1(c1 YEAR NOT NULL); 4557SHOW TABLES; 4558Tables_in_test 4559t1 4560SHOW CREATE TABLE t1; 4561Table Create Table 4562t1 CREATE TABLE `t1` ( 4563 `c1` year NOT NULL 4564) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4565ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); 4566SHOW TABLES; 4567Tables_in_test 4568t1 4569SHOW CREATE TABLE t1; 4570Table Create Table 4571t1 CREATE TABLE `t1` ( 4572 `c1` year NOT NULL, 4573 UNIQUE KEY `i1` (`c1`) 4574) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4575DROP TABLE t1; 4576SHOW TABLES; 4577Tables_in_test 4578CREATE TABLE t1(c1 BIT NOT NULL); 4579SHOW TABLES; 4580Tables_in_test 4581t1 4582SHOW CREATE TABLE t1; 4583Table Create Table 4584t1 CREATE TABLE `t1` ( 4585 `c1` bit(1) NOT NULL 4586) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4587ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4588SHOW TABLES; 4589Tables_in_test 4590t1 4591SHOW CREATE TABLE t1; 4592Table Create Table 4593t1 CREATE TABLE `t1` ( 4594 `c1` bit(1) NOT NULL, 4595 UNIQUE KEY `i1` (`c1`) 4596) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4597DROP TABLE t1; 4598SHOW TABLES; 4599Tables_in_test 4600CREATE TABLE t1(c1 TINYINT NOT NULL); 4601SHOW TABLES; 4602Tables_in_test 4603t1 4604SHOW CREATE TABLE t1; 4605Table Create Table 4606t1 CREATE TABLE `t1` ( 4607 `c1` tinyint NOT NULL 4608) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4609ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4610SHOW TABLES; 4611Tables_in_test 4612t1 4613SHOW CREATE TABLE t1; 4614Table Create Table 4615t1 CREATE TABLE `t1` ( 4616 `c1` tinyint NOT NULL, 4617 UNIQUE KEY `i1` (`c1`) 4618) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4619DROP TABLE t1; 4620SHOW TABLES; 4621Tables_in_test 4622CREATE TABLE t1(c1 SMALLINT NOT NULL); 4623SHOW TABLES; 4624Tables_in_test 4625t1 4626SHOW CREATE TABLE t1; 4627Table Create Table 4628t1 CREATE TABLE `t1` ( 4629 `c1` smallint NOT NULL 4630) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4631ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4632SHOW TABLES; 4633Tables_in_test 4634t1 4635SHOW CREATE TABLE t1; 4636Table Create Table 4637t1 CREATE TABLE `t1` ( 4638 `c1` smallint NOT NULL, 4639 UNIQUE KEY `i1` (`c1`) 4640) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4641DROP TABLE t1; 4642SHOW TABLES; 4643Tables_in_test 4644CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 4645SHOW TABLES; 4646Tables_in_test 4647t1 4648SHOW CREATE TABLE t1; 4649Table Create Table 4650t1 CREATE TABLE `t1` ( 4651 `c1` mediumint NOT NULL 4652) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4653ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4654SHOW TABLES; 4655Tables_in_test 4656t1 4657SHOW CREATE TABLE t1; 4658Table Create Table 4659t1 CREATE TABLE `t1` ( 4660 `c1` mediumint NOT NULL, 4661 UNIQUE KEY `i1` (`c1`) 4662) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4663DROP TABLE t1; 4664SHOW TABLES; 4665Tables_in_test 4666CREATE TABLE t1(c1 INT NOT NULL); 4667SHOW TABLES; 4668Tables_in_test 4669t1 4670SHOW CREATE TABLE t1; 4671Table Create Table 4672t1 CREATE TABLE `t1` ( 4673 `c1` int NOT NULL 4674) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4675ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4676SHOW TABLES; 4677Tables_in_test 4678t1 4679SHOW CREATE TABLE t1; 4680Table Create Table 4681t1 CREATE TABLE `t1` ( 4682 `c1` int NOT NULL, 4683 UNIQUE KEY `i1` (`c1`) 4684) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4685DROP TABLE t1; 4686SHOW TABLES; 4687Tables_in_test 4688CREATE TABLE t1(c1 INTEGER NOT NULL); 4689SHOW TABLES; 4690Tables_in_test 4691t1 4692SHOW CREATE TABLE t1; 4693Table Create Table 4694t1 CREATE TABLE `t1` ( 4695 `c1` int NOT NULL 4696) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4697ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4698SHOW TABLES; 4699Tables_in_test 4700t1 4701SHOW CREATE TABLE t1; 4702Table Create Table 4703t1 CREATE TABLE `t1` ( 4704 `c1` int NOT NULL, 4705 UNIQUE KEY `i1` (`c1`) 4706) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4707DROP TABLE t1; 4708SHOW TABLES; 4709Tables_in_test 4710CREATE TABLE t1(c1 BIGINT NOT NULL); 4711SHOW TABLES; 4712Tables_in_test 4713t1 4714SHOW CREATE TABLE t1; 4715Table Create Table 4716t1 CREATE TABLE `t1` ( 4717 `c1` bigint NOT NULL 4718) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4719ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4720SHOW TABLES; 4721Tables_in_test 4722t1 4723SHOW CREATE TABLE t1; 4724Table Create Table 4725t1 CREATE TABLE `t1` ( 4726 `c1` bigint NOT NULL, 4727 UNIQUE KEY `i1` (`c1`) 4728) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4729DROP TABLE t1; 4730SHOW TABLES; 4731Tables_in_test 4732CREATE TABLE t1(c1 REAL NOT NULL); 4733SHOW TABLES; 4734Tables_in_test 4735t1 4736SHOW CREATE TABLE t1; 4737Table Create Table 4738t1 CREATE TABLE `t1` ( 4739 `c1` double NOT NULL 4740) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4741ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4742SHOW TABLES; 4743Tables_in_test 4744t1 4745SHOW CREATE TABLE t1; 4746Table Create Table 4747t1 CREATE TABLE `t1` ( 4748 `c1` double NOT NULL, 4749 UNIQUE KEY `i1` (`c1`) 4750) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4751DROP TABLE t1; 4752SHOW TABLES; 4753Tables_in_test 4754CREATE TABLE t1(c1 DOUBLE NOT NULL); 4755SHOW TABLES; 4756Tables_in_test 4757t1 4758SHOW CREATE TABLE t1; 4759Table Create Table 4760t1 CREATE TABLE `t1` ( 4761 `c1` double NOT NULL 4762) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4763ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4764SHOW TABLES; 4765Tables_in_test 4766t1 4767SHOW CREATE TABLE t1; 4768Table Create Table 4769t1 CREATE TABLE `t1` ( 4770 `c1` double NOT NULL, 4771 UNIQUE KEY `i1` (`c1`) 4772) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4773DROP TABLE t1; 4774SHOW TABLES; 4775Tables_in_test 4776CREATE TABLE t1(c1 FLOAT NOT NULL); 4777SHOW TABLES; 4778Tables_in_test 4779t1 4780SHOW CREATE TABLE t1; 4781Table Create Table 4782t1 CREATE TABLE `t1` ( 4783 `c1` float NOT NULL 4784) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4785ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4786SHOW TABLES; 4787Tables_in_test 4788t1 4789SHOW CREATE TABLE t1; 4790Table Create Table 4791t1 CREATE TABLE `t1` ( 4792 `c1` float NOT NULL, 4793 UNIQUE KEY `i1` (`c1`) 4794) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4795DROP TABLE t1; 4796SHOW TABLES; 4797Tables_in_test 4798CREATE TABLE t1(c1 DECIMAL NOT NULL); 4799SHOW TABLES; 4800Tables_in_test 4801t1 4802SHOW CREATE TABLE t1; 4803Table Create Table 4804t1 CREATE TABLE `t1` ( 4805 `c1` decimal(10,0) NOT NULL 4806) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4807ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4808SHOW TABLES; 4809Tables_in_test 4810t1 4811SHOW CREATE TABLE t1; 4812Table Create Table 4813t1 CREATE TABLE `t1` ( 4814 `c1` decimal(10,0) NOT NULL, 4815 UNIQUE KEY `i1` (`c1`) 4816) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4817DROP TABLE t1; 4818SHOW TABLES; 4819Tables_in_test 4820CREATE TABLE t1(c1 NUMERIC NOT NULL); 4821SHOW TABLES; 4822Tables_in_test 4823t1 4824SHOW CREATE TABLE t1; 4825Table Create Table 4826t1 CREATE TABLE `t1` ( 4827 `c1` decimal(10,0) NOT NULL 4828) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4829ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4830SHOW TABLES; 4831Tables_in_test 4832t1 4833SHOW CREATE TABLE t1; 4834Table Create Table 4835t1 CREATE TABLE `t1` ( 4836 `c1` decimal(10,0) NOT NULL, 4837 UNIQUE KEY `i1` (`c1`) 4838) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4839DROP TABLE t1; 4840SHOW TABLES; 4841Tables_in_test 4842CREATE TABLE t1(c1 DATE NOT NULL); 4843SHOW TABLES; 4844Tables_in_test 4845t1 4846SHOW CREATE TABLE t1; 4847Table Create Table 4848t1 CREATE TABLE `t1` ( 4849 `c1` date NOT NULL 4850) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4851ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4852SHOW TABLES; 4853Tables_in_test 4854t1 4855SHOW CREATE TABLE t1; 4856Table Create Table 4857t1 CREATE TABLE `t1` ( 4858 `c1` date NOT NULL, 4859 UNIQUE KEY `i1` (`c1`) 4860) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4861DROP TABLE t1; 4862SHOW TABLES; 4863Tables_in_test 4864CREATE TABLE t1(c1 TIME NOT NULL); 4865SHOW TABLES; 4866Tables_in_test 4867t1 4868SHOW CREATE TABLE t1; 4869Table Create Table 4870t1 CREATE TABLE `t1` ( 4871 `c1` time NOT NULL 4872) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4873ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4874SHOW TABLES; 4875Tables_in_test 4876t1 4877SHOW CREATE TABLE t1; 4878Table Create Table 4879t1 CREATE TABLE `t1` ( 4880 `c1` time NOT NULL, 4881 UNIQUE KEY `i1` (`c1`) 4882) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4883DROP TABLE t1; 4884SHOW TABLES; 4885Tables_in_test 4886CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 4887SHOW TABLES; 4888Tables_in_test 4889t1 4890SHOW CREATE TABLE t1; 4891Table Create Table 4892t1 CREATE TABLE `t1` ( 4893 `c1` timestamp NOT NULL 4894) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4895ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4896SHOW TABLES; 4897Tables_in_test 4898t1 4899SHOW CREATE TABLE t1; 4900Table Create Table 4901t1 CREATE TABLE `t1` ( 4902 `c1` timestamp NOT NULL, 4903 UNIQUE KEY `i1` (`c1`) 4904) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4905DROP TABLE t1; 4906SHOW TABLES; 4907Tables_in_test 4908CREATE TABLE t1(c1 YEAR NOT NULL); 4909SHOW TABLES; 4910Tables_in_test 4911t1 4912SHOW CREATE TABLE t1; 4913Table Create Table 4914t1 CREATE TABLE `t1` ( 4915 `c1` year NOT NULL 4916) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4917ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); 4918SHOW TABLES; 4919Tables_in_test 4920t1 4921SHOW CREATE TABLE t1; 4922Table Create Table 4923t1 CREATE TABLE `t1` ( 4924 `c1` year NOT NULL, 4925 UNIQUE KEY `i1` (`c1`) 4926) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4927DROP TABLE t1; 4928SHOW TABLES; 4929Tables_in_test 4930CREATE TABLE t1(c1 BIT NOT NULL); 4931SHOW TABLES; 4932Tables_in_test 4933t1 4934SHOW CREATE TABLE t1; 4935Table Create Table 4936t1 CREATE TABLE `t1` ( 4937 `c1` bit(1) NOT NULL 4938) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4939ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 4940SHOW TABLES; 4941Tables_in_test 4942t1 4943SHOW CREATE TABLE t1; 4944Table Create Table 4945t1 CREATE TABLE `t1` ( 4946 `c1` bit(1) NOT NULL, 4947 UNIQUE KEY `i1` (`c1`) 4948) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4949DROP TABLE t1; 4950SHOW TABLES; 4951Tables_in_test 4952CREATE TABLE t1(c1 TINYINT NOT NULL); 4953SHOW TABLES; 4954Tables_in_test 4955t1 4956SHOW CREATE TABLE t1; 4957Table Create Table 4958t1 CREATE TABLE `t1` ( 4959 `c1` tinyint NOT NULL 4960) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4961ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 4962SHOW TABLES; 4963Tables_in_test 4964t1 4965SHOW CREATE TABLE t1; 4966Table Create Table 4967t1 CREATE TABLE `t1` ( 4968 `c1` tinyint NOT NULL, 4969 UNIQUE KEY `i1` (`c1`) 4970) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4971DROP TABLE t1; 4972SHOW TABLES; 4973Tables_in_test 4974CREATE TABLE t1(c1 SMALLINT NOT NULL); 4975SHOW TABLES; 4976Tables_in_test 4977t1 4978SHOW CREATE TABLE t1; 4979Table Create Table 4980t1 CREATE TABLE `t1` ( 4981 `c1` smallint NOT NULL 4982) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4983ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 4984SHOW TABLES; 4985Tables_in_test 4986t1 4987SHOW CREATE TABLE t1; 4988Table Create Table 4989t1 CREATE TABLE `t1` ( 4990 `c1` smallint NOT NULL, 4991 UNIQUE KEY `i1` (`c1`) 4992) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 4993DROP TABLE t1; 4994SHOW TABLES; 4995Tables_in_test 4996CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 4997SHOW TABLES; 4998Tables_in_test 4999t1 5000SHOW CREATE TABLE t1; 5001Table Create Table 5002t1 CREATE TABLE `t1` ( 5003 `c1` mediumint NOT NULL 5004) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5005ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5006SHOW TABLES; 5007Tables_in_test 5008t1 5009SHOW CREATE TABLE t1; 5010Table Create Table 5011t1 CREATE TABLE `t1` ( 5012 `c1` mediumint NOT NULL, 5013 UNIQUE KEY `i1` (`c1`) 5014) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5015DROP TABLE t1; 5016SHOW TABLES; 5017Tables_in_test 5018CREATE TABLE t1(c1 INT NOT NULL); 5019SHOW TABLES; 5020Tables_in_test 5021t1 5022SHOW CREATE TABLE t1; 5023Table Create Table 5024t1 CREATE TABLE `t1` ( 5025 `c1` int NOT NULL 5026) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5027ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5028SHOW TABLES; 5029Tables_in_test 5030t1 5031SHOW CREATE TABLE t1; 5032Table Create Table 5033t1 CREATE TABLE `t1` ( 5034 `c1` int NOT NULL, 5035 UNIQUE KEY `i1` (`c1`) 5036) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5037DROP TABLE t1; 5038SHOW TABLES; 5039Tables_in_test 5040CREATE TABLE t1(c1 INTEGER NOT NULL); 5041SHOW TABLES; 5042Tables_in_test 5043t1 5044SHOW CREATE TABLE t1; 5045Table Create Table 5046t1 CREATE TABLE `t1` ( 5047 `c1` int NOT NULL 5048) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5049ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5050SHOW TABLES; 5051Tables_in_test 5052t1 5053SHOW CREATE TABLE t1; 5054Table Create Table 5055t1 CREATE TABLE `t1` ( 5056 `c1` int NOT NULL, 5057 UNIQUE KEY `i1` (`c1`) 5058) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5059DROP TABLE t1; 5060SHOW TABLES; 5061Tables_in_test 5062CREATE TABLE t1(c1 BIGINT NOT NULL); 5063SHOW TABLES; 5064Tables_in_test 5065t1 5066SHOW CREATE TABLE t1; 5067Table Create Table 5068t1 CREATE TABLE `t1` ( 5069 `c1` bigint NOT NULL 5070) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5071ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5072SHOW TABLES; 5073Tables_in_test 5074t1 5075SHOW CREATE TABLE t1; 5076Table Create Table 5077t1 CREATE TABLE `t1` ( 5078 `c1` bigint NOT NULL, 5079 UNIQUE KEY `i1` (`c1`) 5080) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5081DROP TABLE t1; 5082SHOW TABLES; 5083Tables_in_test 5084CREATE TABLE t1(c1 REAL NOT NULL); 5085SHOW TABLES; 5086Tables_in_test 5087t1 5088SHOW CREATE TABLE t1; 5089Table Create Table 5090t1 CREATE TABLE `t1` ( 5091 `c1` double NOT NULL 5092) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5093ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5094SHOW TABLES; 5095Tables_in_test 5096t1 5097SHOW CREATE TABLE t1; 5098Table Create Table 5099t1 CREATE TABLE `t1` ( 5100 `c1` double NOT NULL, 5101 UNIQUE KEY `i1` (`c1`) 5102) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5103DROP TABLE t1; 5104SHOW TABLES; 5105Tables_in_test 5106CREATE TABLE t1(c1 DOUBLE NOT NULL); 5107SHOW TABLES; 5108Tables_in_test 5109t1 5110SHOW CREATE TABLE t1; 5111Table Create Table 5112t1 CREATE TABLE `t1` ( 5113 `c1` double NOT NULL 5114) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5115ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5116SHOW TABLES; 5117Tables_in_test 5118t1 5119SHOW CREATE TABLE t1; 5120Table Create Table 5121t1 CREATE TABLE `t1` ( 5122 `c1` double NOT NULL, 5123 UNIQUE KEY `i1` (`c1`) 5124) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5125DROP TABLE t1; 5126SHOW TABLES; 5127Tables_in_test 5128CREATE TABLE t1(c1 FLOAT NOT NULL); 5129SHOW TABLES; 5130Tables_in_test 5131t1 5132SHOW CREATE TABLE t1; 5133Table Create Table 5134t1 CREATE TABLE `t1` ( 5135 `c1` float NOT NULL 5136) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5137ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5138SHOW TABLES; 5139Tables_in_test 5140t1 5141SHOW CREATE TABLE t1; 5142Table Create Table 5143t1 CREATE TABLE `t1` ( 5144 `c1` float NOT NULL, 5145 UNIQUE KEY `i1` (`c1`) 5146) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5147DROP TABLE t1; 5148SHOW TABLES; 5149Tables_in_test 5150CREATE TABLE t1(c1 DECIMAL NOT NULL); 5151SHOW TABLES; 5152Tables_in_test 5153t1 5154SHOW CREATE TABLE t1; 5155Table Create Table 5156t1 CREATE TABLE `t1` ( 5157 `c1` decimal(10,0) NOT NULL 5158) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5159ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5160SHOW TABLES; 5161Tables_in_test 5162t1 5163SHOW CREATE TABLE t1; 5164Table Create Table 5165t1 CREATE TABLE `t1` ( 5166 `c1` decimal(10,0) NOT NULL, 5167 UNIQUE KEY `i1` (`c1`) 5168) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5169DROP TABLE t1; 5170SHOW TABLES; 5171Tables_in_test 5172CREATE TABLE t1(c1 NUMERIC NOT NULL); 5173SHOW TABLES; 5174Tables_in_test 5175t1 5176SHOW CREATE TABLE t1; 5177Table Create Table 5178t1 CREATE TABLE `t1` ( 5179 `c1` decimal(10,0) NOT NULL 5180) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5181ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5182SHOW TABLES; 5183Tables_in_test 5184t1 5185SHOW CREATE TABLE t1; 5186Table Create Table 5187t1 CREATE TABLE `t1` ( 5188 `c1` decimal(10,0) NOT NULL, 5189 UNIQUE KEY `i1` (`c1`) 5190) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5191DROP TABLE t1; 5192SHOW TABLES; 5193Tables_in_test 5194CREATE TABLE t1(c1 DATE NOT NULL); 5195SHOW TABLES; 5196Tables_in_test 5197t1 5198SHOW CREATE TABLE t1; 5199Table Create Table 5200t1 CREATE TABLE `t1` ( 5201 `c1` date NOT NULL 5202) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5203ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5204SHOW TABLES; 5205Tables_in_test 5206t1 5207SHOW CREATE TABLE t1; 5208Table Create Table 5209t1 CREATE TABLE `t1` ( 5210 `c1` date NOT NULL, 5211 UNIQUE KEY `i1` (`c1`) 5212) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5213DROP TABLE t1; 5214SHOW TABLES; 5215Tables_in_test 5216CREATE TABLE t1(c1 TIME NOT NULL); 5217SHOW TABLES; 5218Tables_in_test 5219t1 5220SHOW CREATE TABLE t1; 5221Table Create Table 5222t1 CREATE TABLE `t1` ( 5223 `c1` time NOT NULL 5224) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5225ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5226SHOW TABLES; 5227Tables_in_test 5228t1 5229SHOW CREATE TABLE t1; 5230Table Create Table 5231t1 CREATE TABLE `t1` ( 5232 `c1` time NOT NULL, 5233 UNIQUE KEY `i1` (`c1`) 5234) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5235DROP TABLE t1; 5236SHOW TABLES; 5237Tables_in_test 5238CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 5239SHOW TABLES; 5240Tables_in_test 5241t1 5242SHOW CREATE TABLE t1; 5243Table Create Table 5244t1 CREATE TABLE `t1` ( 5245 `c1` timestamp NOT NULL 5246) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5247ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5248SHOW TABLES; 5249Tables_in_test 5250t1 5251SHOW CREATE TABLE t1; 5252Table Create Table 5253t1 CREATE TABLE `t1` ( 5254 `c1` timestamp NOT NULL, 5255 UNIQUE KEY `i1` (`c1`) 5256) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5257DROP TABLE t1; 5258SHOW TABLES; 5259Tables_in_test 5260CREATE TABLE t1(c1 YEAR NOT NULL); 5261SHOW TABLES; 5262Tables_in_test 5263t1 5264SHOW CREATE TABLE t1; 5265Table Create Table 5266t1 CREATE TABLE `t1` ( 5267 `c1` year NOT NULL 5268) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5269ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); 5270SHOW TABLES; 5271Tables_in_test 5272t1 5273SHOW CREATE TABLE t1; 5274Table Create Table 5275t1 CREATE TABLE `t1` ( 5276 `c1` year NOT NULL, 5277 UNIQUE KEY `i1` (`c1`) 5278) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5279DROP TABLE t1; 5280SHOW TABLES; 5281Tables_in_test 5282CREATE TABLE t1(c1 BIT NOT NULL); 5283SHOW TABLES; 5284Tables_in_test 5285t1 5286SHOW CREATE TABLE t1; 5287Table Create Table 5288t1 CREATE TABLE `t1` ( 5289 `c1` bit(1) NOT NULL 5290) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5291ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5292SHOW TABLES; 5293Tables_in_test 5294t1 5295SHOW CREATE TABLE t1; 5296Table Create Table 5297t1 CREATE TABLE `t1` ( 5298 `c1` bit(1) NOT NULL, 5299 UNIQUE KEY `i1` (`c1`) 5300) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5301DROP TABLE t1; 5302SHOW TABLES; 5303Tables_in_test 5304CREATE TABLE t1(c1 TINYINT NOT NULL); 5305SHOW TABLES; 5306Tables_in_test 5307t1 5308SHOW CREATE TABLE t1; 5309Table Create Table 5310t1 CREATE TABLE `t1` ( 5311 `c1` tinyint NOT NULL 5312) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5313ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5314SHOW TABLES; 5315Tables_in_test 5316t1 5317SHOW CREATE TABLE t1; 5318Table Create Table 5319t1 CREATE TABLE `t1` ( 5320 `c1` tinyint NOT NULL, 5321 UNIQUE KEY `i1` (`c1`) 5322) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5323DROP TABLE t1; 5324SHOW TABLES; 5325Tables_in_test 5326CREATE TABLE t1(c1 SMALLINT NOT NULL); 5327SHOW TABLES; 5328Tables_in_test 5329t1 5330SHOW CREATE TABLE t1; 5331Table Create Table 5332t1 CREATE TABLE `t1` ( 5333 `c1` smallint NOT NULL 5334) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5335ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5336SHOW TABLES; 5337Tables_in_test 5338t1 5339SHOW CREATE TABLE t1; 5340Table Create Table 5341t1 CREATE TABLE `t1` ( 5342 `c1` smallint NOT NULL, 5343 UNIQUE KEY `i1` (`c1`) 5344) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5345DROP TABLE t1; 5346SHOW TABLES; 5347Tables_in_test 5348CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 5349SHOW TABLES; 5350Tables_in_test 5351t1 5352SHOW CREATE TABLE t1; 5353Table Create Table 5354t1 CREATE TABLE `t1` ( 5355 `c1` mediumint NOT NULL 5356) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5357ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5358SHOW TABLES; 5359Tables_in_test 5360t1 5361SHOW CREATE TABLE t1; 5362Table Create Table 5363t1 CREATE TABLE `t1` ( 5364 `c1` mediumint NOT NULL, 5365 UNIQUE KEY `i1` (`c1`) 5366) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5367DROP TABLE t1; 5368SHOW TABLES; 5369Tables_in_test 5370CREATE TABLE t1(c1 INT NOT NULL); 5371SHOW TABLES; 5372Tables_in_test 5373t1 5374SHOW CREATE TABLE t1; 5375Table Create Table 5376t1 CREATE TABLE `t1` ( 5377 `c1` int NOT NULL 5378) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5379ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5380SHOW TABLES; 5381Tables_in_test 5382t1 5383SHOW CREATE TABLE t1; 5384Table Create Table 5385t1 CREATE TABLE `t1` ( 5386 `c1` int NOT NULL, 5387 UNIQUE KEY `i1` (`c1`) 5388) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5389DROP TABLE t1; 5390SHOW TABLES; 5391Tables_in_test 5392CREATE TABLE t1(c1 INTEGER NOT NULL); 5393SHOW TABLES; 5394Tables_in_test 5395t1 5396SHOW CREATE TABLE t1; 5397Table Create Table 5398t1 CREATE TABLE `t1` ( 5399 `c1` int NOT NULL 5400) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5401ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5402SHOW TABLES; 5403Tables_in_test 5404t1 5405SHOW CREATE TABLE t1; 5406Table Create Table 5407t1 CREATE TABLE `t1` ( 5408 `c1` int NOT NULL, 5409 UNIQUE KEY `i1` (`c1`) 5410) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5411DROP TABLE t1; 5412SHOW TABLES; 5413Tables_in_test 5414CREATE TABLE t1(c1 BIGINT NOT NULL); 5415SHOW TABLES; 5416Tables_in_test 5417t1 5418SHOW CREATE TABLE t1; 5419Table Create Table 5420t1 CREATE TABLE `t1` ( 5421 `c1` bigint NOT NULL 5422) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5423ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5424SHOW TABLES; 5425Tables_in_test 5426t1 5427SHOW CREATE TABLE t1; 5428Table Create Table 5429t1 CREATE TABLE `t1` ( 5430 `c1` bigint NOT NULL, 5431 UNIQUE KEY `i1` (`c1`) 5432) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5433DROP TABLE t1; 5434SHOW TABLES; 5435Tables_in_test 5436CREATE TABLE t1(c1 REAL NOT NULL); 5437SHOW TABLES; 5438Tables_in_test 5439t1 5440SHOW CREATE TABLE t1; 5441Table Create Table 5442t1 CREATE TABLE `t1` ( 5443 `c1` double NOT NULL 5444) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5445ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5446SHOW TABLES; 5447Tables_in_test 5448t1 5449SHOW CREATE TABLE t1; 5450Table Create Table 5451t1 CREATE TABLE `t1` ( 5452 `c1` double NOT NULL, 5453 UNIQUE KEY `i1` (`c1`) 5454) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5455DROP TABLE t1; 5456SHOW TABLES; 5457Tables_in_test 5458CREATE TABLE t1(c1 DOUBLE NOT NULL); 5459SHOW TABLES; 5460Tables_in_test 5461t1 5462SHOW CREATE TABLE t1; 5463Table Create Table 5464t1 CREATE TABLE `t1` ( 5465 `c1` double NOT NULL 5466) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5467ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5468SHOW TABLES; 5469Tables_in_test 5470t1 5471SHOW CREATE TABLE t1; 5472Table Create Table 5473t1 CREATE TABLE `t1` ( 5474 `c1` double NOT NULL, 5475 UNIQUE KEY `i1` (`c1`) 5476) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5477DROP TABLE t1; 5478SHOW TABLES; 5479Tables_in_test 5480CREATE TABLE t1(c1 FLOAT NOT NULL); 5481SHOW TABLES; 5482Tables_in_test 5483t1 5484SHOW CREATE TABLE t1; 5485Table Create Table 5486t1 CREATE TABLE `t1` ( 5487 `c1` float NOT NULL 5488) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5489ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5490SHOW TABLES; 5491Tables_in_test 5492t1 5493SHOW CREATE TABLE t1; 5494Table Create Table 5495t1 CREATE TABLE `t1` ( 5496 `c1` float NOT NULL, 5497 UNIQUE KEY `i1` (`c1`) 5498) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5499DROP TABLE t1; 5500SHOW TABLES; 5501Tables_in_test 5502CREATE TABLE t1(c1 DECIMAL NOT NULL); 5503SHOW TABLES; 5504Tables_in_test 5505t1 5506SHOW CREATE TABLE t1; 5507Table Create Table 5508t1 CREATE TABLE `t1` ( 5509 `c1` decimal(10,0) NOT NULL 5510) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5511ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5512SHOW TABLES; 5513Tables_in_test 5514t1 5515SHOW CREATE TABLE t1; 5516Table Create Table 5517t1 CREATE TABLE `t1` ( 5518 `c1` decimal(10,0) NOT NULL, 5519 UNIQUE KEY `i1` (`c1`) 5520) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5521DROP TABLE t1; 5522SHOW TABLES; 5523Tables_in_test 5524CREATE TABLE t1(c1 NUMERIC NOT NULL); 5525SHOW TABLES; 5526Tables_in_test 5527t1 5528SHOW CREATE TABLE t1; 5529Table Create Table 5530t1 CREATE TABLE `t1` ( 5531 `c1` decimal(10,0) NOT NULL 5532) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5533ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5534SHOW TABLES; 5535Tables_in_test 5536t1 5537SHOW CREATE TABLE t1; 5538Table Create Table 5539t1 CREATE TABLE `t1` ( 5540 `c1` decimal(10,0) NOT NULL, 5541 UNIQUE KEY `i1` (`c1`) 5542) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5543DROP TABLE t1; 5544SHOW TABLES; 5545Tables_in_test 5546CREATE TABLE t1(c1 DATE NOT NULL); 5547SHOW TABLES; 5548Tables_in_test 5549t1 5550SHOW CREATE TABLE t1; 5551Table Create Table 5552t1 CREATE TABLE `t1` ( 5553 `c1` date NOT NULL 5554) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5555ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5556SHOW TABLES; 5557Tables_in_test 5558t1 5559SHOW CREATE TABLE t1; 5560Table Create Table 5561t1 CREATE TABLE `t1` ( 5562 `c1` date NOT NULL, 5563 UNIQUE KEY `i1` (`c1`) 5564) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5565DROP TABLE t1; 5566SHOW TABLES; 5567Tables_in_test 5568CREATE TABLE t1(c1 TIME NOT NULL); 5569SHOW TABLES; 5570Tables_in_test 5571t1 5572SHOW CREATE TABLE t1; 5573Table Create Table 5574t1 CREATE TABLE `t1` ( 5575 `c1` time NOT NULL 5576) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5577ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5578SHOW TABLES; 5579Tables_in_test 5580t1 5581SHOW CREATE TABLE t1; 5582Table Create Table 5583t1 CREATE TABLE `t1` ( 5584 `c1` time NOT NULL, 5585 UNIQUE KEY `i1` (`c1`) 5586) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5587DROP TABLE t1; 5588SHOW TABLES; 5589Tables_in_test 5590CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 5591SHOW TABLES; 5592Tables_in_test 5593t1 5594SHOW CREATE TABLE t1; 5595Table Create Table 5596t1 CREATE TABLE `t1` ( 5597 `c1` timestamp NOT NULL 5598) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5599ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5600SHOW TABLES; 5601Tables_in_test 5602t1 5603SHOW CREATE TABLE t1; 5604Table Create Table 5605t1 CREATE TABLE `t1` ( 5606 `c1` timestamp NOT NULL, 5607 UNIQUE KEY `i1` (`c1`) 5608) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5609DROP TABLE t1; 5610SHOW TABLES; 5611Tables_in_test 5612CREATE TABLE t1(c1 YEAR NOT NULL); 5613SHOW TABLES; 5614Tables_in_test 5615t1 5616SHOW CREATE TABLE t1; 5617Table Create Table 5618t1 CREATE TABLE `t1` ( 5619 `c1` year NOT NULL 5620) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5621ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); 5622SHOW TABLES; 5623Tables_in_test 5624t1 5625SHOW CREATE TABLE t1; 5626Table Create Table 5627t1 CREATE TABLE `t1` ( 5628 `c1` year NOT NULL, 5629 UNIQUE KEY `i1` (`c1`) 5630) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5631DROP TABLE t1; 5632SHOW TABLES; 5633Tables_in_test 5634CREATE TABLE t1(c1 BIT NOT NULL); 5635SHOW TABLES; 5636Tables_in_test 5637t1 5638SHOW CREATE TABLE t1; 5639Table Create Table 5640t1 CREATE TABLE `t1` ( 5641 `c1` bit(1) NOT NULL 5642) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5643ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5644SHOW TABLES; 5645Tables_in_test 5646t1 5647SHOW CREATE TABLE t1; 5648Table Create Table 5649t1 CREATE TABLE `t1` ( 5650 `c1` bit(1) NOT NULL, 5651 UNIQUE KEY `i1` (`c1`) 5652) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5653DROP TABLE t1; 5654SHOW TABLES; 5655Tables_in_test 5656CREATE TABLE t1(c1 TINYINT NOT NULL); 5657SHOW TABLES; 5658Tables_in_test 5659t1 5660SHOW CREATE TABLE t1; 5661Table Create Table 5662t1 CREATE TABLE `t1` ( 5663 `c1` tinyint NOT NULL 5664) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5665ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5666SHOW TABLES; 5667Tables_in_test 5668t1 5669SHOW CREATE TABLE t1; 5670Table Create Table 5671t1 CREATE TABLE `t1` ( 5672 `c1` tinyint NOT NULL, 5673 UNIQUE KEY `i1` (`c1`) 5674) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5675DROP TABLE t1; 5676SHOW TABLES; 5677Tables_in_test 5678CREATE TABLE t1(c1 SMALLINT NOT NULL); 5679SHOW TABLES; 5680Tables_in_test 5681t1 5682SHOW CREATE TABLE t1; 5683Table Create Table 5684t1 CREATE TABLE `t1` ( 5685 `c1` smallint NOT NULL 5686) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5687ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5688SHOW TABLES; 5689Tables_in_test 5690t1 5691SHOW CREATE TABLE t1; 5692Table Create Table 5693t1 CREATE TABLE `t1` ( 5694 `c1` smallint NOT NULL, 5695 UNIQUE KEY `i1` (`c1`) 5696) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5697DROP TABLE t1; 5698SHOW TABLES; 5699Tables_in_test 5700CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 5701SHOW TABLES; 5702Tables_in_test 5703t1 5704SHOW CREATE TABLE t1; 5705Table Create Table 5706t1 CREATE TABLE `t1` ( 5707 `c1` mediumint NOT NULL 5708) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5709ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5710SHOW TABLES; 5711Tables_in_test 5712t1 5713SHOW CREATE TABLE t1; 5714Table Create Table 5715t1 CREATE TABLE `t1` ( 5716 `c1` mediumint NOT NULL, 5717 UNIQUE KEY `i1` (`c1`) 5718) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5719DROP TABLE t1; 5720SHOW TABLES; 5721Tables_in_test 5722CREATE TABLE t1(c1 INT NOT NULL); 5723SHOW TABLES; 5724Tables_in_test 5725t1 5726SHOW CREATE TABLE t1; 5727Table Create Table 5728t1 CREATE TABLE `t1` ( 5729 `c1` int NOT NULL 5730) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5731ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5732SHOW TABLES; 5733Tables_in_test 5734t1 5735SHOW CREATE TABLE t1; 5736Table Create Table 5737t1 CREATE TABLE `t1` ( 5738 `c1` int NOT NULL, 5739 UNIQUE KEY `i1` (`c1`) 5740) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5741DROP TABLE t1; 5742SHOW TABLES; 5743Tables_in_test 5744CREATE TABLE t1(c1 INTEGER NOT NULL); 5745SHOW TABLES; 5746Tables_in_test 5747t1 5748SHOW CREATE TABLE t1; 5749Table Create Table 5750t1 CREATE TABLE `t1` ( 5751 `c1` int NOT NULL 5752) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5753ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5754SHOW TABLES; 5755Tables_in_test 5756t1 5757SHOW CREATE TABLE t1; 5758Table Create Table 5759t1 CREATE TABLE `t1` ( 5760 `c1` int NOT NULL, 5761 UNIQUE KEY `i1` (`c1`) 5762) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5763DROP TABLE t1; 5764SHOW TABLES; 5765Tables_in_test 5766CREATE TABLE t1(c1 BIGINT NOT NULL); 5767SHOW TABLES; 5768Tables_in_test 5769t1 5770SHOW CREATE TABLE t1; 5771Table Create Table 5772t1 CREATE TABLE `t1` ( 5773 `c1` bigint NOT NULL 5774) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5775ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5776SHOW TABLES; 5777Tables_in_test 5778t1 5779SHOW CREATE TABLE t1; 5780Table Create Table 5781t1 CREATE TABLE `t1` ( 5782 `c1` bigint NOT NULL, 5783 UNIQUE KEY `i1` (`c1`) 5784) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5785DROP TABLE t1; 5786SHOW TABLES; 5787Tables_in_test 5788CREATE TABLE t1(c1 REAL NOT NULL); 5789SHOW TABLES; 5790Tables_in_test 5791t1 5792SHOW CREATE TABLE t1; 5793Table Create Table 5794t1 CREATE TABLE `t1` ( 5795 `c1` double NOT NULL 5796) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5797ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5798SHOW TABLES; 5799Tables_in_test 5800t1 5801SHOW CREATE TABLE t1; 5802Table Create Table 5803t1 CREATE TABLE `t1` ( 5804 `c1` double NOT NULL, 5805 UNIQUE KEY `i1` (`c1`) 5806) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5807DROP TABLE t1; 5808SHOW TABLES; 5809Tables_in_test 5810CREATE TABLE t1(c1 DOUBLE NOT NULL); 5811SHOW TABLES; 5812Tables_in_test 5813t1 5814SHOW CREATE TABLE t1; 5815Table Create Table 5816t1 CREATE TABLE `t1` ( 5817 `c1` double NOT NULL 5818) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5819ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5820SHOW TABLES; 5821Tables_in_test 5822t1 5823SHOW CREATE TABLE t1; 5824Table Create Table 5825t1 CREATE TABLE `t1` ( 5826 `c1` double NOT NULL, 5827 UNIQUE KEY `i1` (`c1`) 5828) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5829DROP TABLE t1; 5830SHOW TABLES; 5831Tables_in_test 5832CREATE TABLE t1(c1 FLOAT NOT NULL); 5833SHOW TABLES; 5834Tables_in_test 5835t1 5836SHOW CREATE TABLE t1; 5837Table Create Table 5838t1 CREATE TABLE `t1` ( 5839 `c1` float NOT NULL 5840) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5841ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5842SHOW TABLES; 5843Tables_in_test 5844t1 5845SHOW CREATE TABLE t1; 5846Table Create Table 5847t1 CREATE TABLE `t1` ( 5848 `c1` float NOT NULL, 5849 UNIQUE KEY `i1` (`c1`) 5850) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5851DROP TABLE t1; 5852SHOW TABLES; 5853Tables_in_test 5854CREATE TABLE t1(c1 DECIMAL NOT NULL); 5855SHOW TABLES; 5856Tables_in_test 5857t1 5858SHOW CREATE TABLE t1; 5859Table Create Table 5860t1 CREATE TABLE `t1` ( 5861 `c1` decimal(10,0) NOT NULL 5862) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5863ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5864SHOW TABLES; 5865Tables_in_test 5866t1 5867SHOW CREATE TABLE t1; 5868Table Create Table 5869t1 CREATE TABLE `t1` ( 5870 `c1` decimal(10,0) NOT NULL, 5871 UNIQUE KEY `i1` (`c1`) 5872) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5873DROP TABLE t1; 5874SHOW TABLES; 5875Tables_in_test 5876CREATE TABLE t1(c1 NUMERIC NOT NULL); 5877SHOW TABLES; 5878Tables_in_test 5879t1 5880SHOW CREATE TABLE t1; 5881Table Create Table 5882t1 CREATE TABLE `t1` ( 5883 `c1` decimal(10,0) NOT NULL 5884) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5885ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5886SHOW TABLES; 5887Tables_in_test 5888t1 5889SHOW CREATE TABLE t1; 5890Table Create Table 5891t1 CREATE TABLE `t1` ( 5892 `c1` decimal(10,0) NOT NULL, 5893 UNIQUE KEY `i1` (`c1`) 5894) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5895DROP TABLE t1; 5896SHOW TABLES; 5897Tables_in_test 5898CREATE TABLE t1(c1 DATE NOT NULL); 5899SHOW TABLES; 5900Tables_in_test 5901t1 5902SHOW CREATE TABLE t1; 5903Table Create Table 5904t1 CREATE TABLE `t1` ( 5905 `c1` date NOT NULL 5906) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5907ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5908SHOW TABLES; 5909Tables_in_test 5910t1 5911SHOW CREATE TABLE t1; 5912Table Create Table 5913t1 CREATE TABLE `t1` ( 5914 `c1` date NOT NULL, 5915 UNIQUE KEY `i1` (`c1`) 5916) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5917DROP TABLE t1; 5918SHOW TABLES; 5919Tables_in_test 5920CREATE TABLE t1(c1 TIME NOT NULL); 5921SHOW TABLES; 5922Tables_in_test 5923t1 5924SHOW CREATE TABLE t1; 5925Table Create Table 5926t1 CREATE TABLE `t1` ( 5927 `c1` time NOT NULL 5928) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5929ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5930SHOW TABLES; 5931Tables_in_test 5932t1 5933SHOW CREATE TABLE t1; 5934Table Create Table 5935t1 CREATE TABLE `t1` ( 5936 `c1` time NOT NULL, 5937 UNIQUE KEY `i1` (`c1`) 5938) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5939DROP TABLE t1; 5940SHOW TABLES; 5941Tables_in_test 5942CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 5943SHOW TABLES; 5944Tables_in_test 5945t1 5946SHOW CREATE TABLE t1; 5947Table Create Table 5948t1 CREATE TABLE `t1` ( 5949 `c1` timestamp NOT NULL 5950) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5951ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5952SHOW TABLES; 5953Tables_in_test 5954t1 5955SHOW CREATE TABLE t1; 5956Table Create Table 5957t1 CREATE TABLE `t1` ( 5958 `c1` timestamp NOT NULL, 5959 UNIQUE KEY `i1` (`c1`) 5960) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5961DROP TABLE t1; 5962SHOW TABLES; 5963Tables_in_test 5964CREATE TABLE t1(c1 YEAR NOT NULL); 5965SHOW TABLES; 5966Tables_in_test 5967t1 5968SHOW CREATE TABLE t1; 5969Table Create Table 5970t1 CREATE TABLE `t1` ( 5971 `c1` year NOT NULL 5972) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5973ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); 5974SHOW TABLES; 5975Tables_in_test 5976t1 5977SHOW CREATE TABLE t1; 5978Table Create Table 5979t1 CREATE TABLE `t1` ( 5980 `c1` year NOT NULL, 5981 UNIQUE KEY `i1` (`c1`) 5982) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5983DROP TABLE t1; 5984SHOW TABLES; 5985Tables_in_test 5986CREATE TABLE t1(c1 BIT NOT NULL); 5987SHOW TABLES; 5988Tables_in_test 5989t1 5990SHOW CREATE TABLE t1; 5991Table Create Table 5992t1 CREATE TABLE `t1` ( 5993 `c1` bit(1) NOT NULL 5994) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 5995ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 5996SHOW TABLES; 5997Tables_in_test 5998t1 5999SHOW CREATE TABLE t1; 6000Table Create Table 6001t1 CREATE TABLE `t1` ( 6002 `c1` bit(1) NOT NULL, 6003 UNIQUE KEY `i1` (`c1`) 6004) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6005DROP TABLE t1; 6006SHOW TABLES; 6007Tables_in_test 6008CREATE TABLE t1(c1 TINYINT NOT NULL); 6009SHOW TABLES; 6010Tables_in_test 6011t1 6012SHOW CREATE TABLE t1; 6013Table Create Table 6014t1 CREATE TABLE `t1` ( 6015 `c1` tinyint NOT NULL 6016) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6017ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6018SHOW TABLES; 6019Tables_in_test 6020t1 6021SHOW CREATE TABLE t1; 6022Table Create Table 6023t1 CREATE TABLE `t1` ( 6024 `c1` tinyint NOT NULL, 6025 UNIQUE KEY `i1` (`c1`) 6026) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6027DROP TABLE t1; 6028SHOW TABLES; 6029Tables_in_test 6030CREATE TABLE t1(c1 SMALLINT NOT NULL); 6031SHOW TABLES; 6032Tables_in_test 6033t1 6034SHOW CREATE TABLE t1; 6035Table Create Table 6036t1 CREATE TABLE `t1` ( 6037 `c1` smallint NOT NULL 6038) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6039ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6040SHOW TABLES; 6041Tables_in_test 6042t1 6043SHOW CREATE TABLE t1; 6044Table Create Table 6045t1 CREATE TABLE `t1` ( 6046 `c1` smallint NOT NULL, 6047 UNIQUE KEY `i1` (`c1`) 6048) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6049DROP TABLE t1; 6050SHOW TABLES; 6051Tables_in_test 6052CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 6053SHOW TABLES; 6054Tables_in_test 6055t1 6056SHOW CREATE TABLE t1; 6057Table Create Table 6058t1 CREATE TABLE `t1` ( 6059 `c1` mediumint NOT NULL 6060) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6061ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6062SHOW TABLES; 6063Tables_in_test 6064t1 6065SHOW CREATE TABLE t1; 6066Table Create Table 6067t1 CREATE TABLE `t1` ( 6068 `c1` mediumint NOT NULL, 6069 UNIQUE KEY `i1` (`c1`) 6070) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6071DROP TABLE t1; 6072SHOW TABLES; 6073Tables_in_test 6074CREATE TABLE t1(c1 INT NOT NULL); 6075SHOW TABLES; 6076Tables_in_test 6077t1 6078SHOW CREATE TABLE t1; 6079Table Create Table 6080t1 CREATE TABLE `t1` ( 6081 `c1` int NOT NULL 6082) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6083ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6084SHOW TABLES; 6085Tables_in_test 6086t1 6087SHOW CREATE TABLE t1; 6088Table Create Table 6089t1 CREATE TABLE `t1` ( 6090 `c1` int NOT NULL, 6091 UNIQUE KEY `i1` (`c1`) 6092) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6093DROP TABLE t1; 6094SHOW TABLES; 6095Tables_in_test 6096CREATE TABLE t1(c1 INTEGER NOT NULL); 6097SHOW TABLES; 6098Tables_in_test 6099t1 6100SHOW CREATE TABLE t1; 6101Table Create Table 6102t1 CREATE TABLE `t1` ( 6103 `c1` int NOT NULL 6104) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6105ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6106SHOW TABLES; 6107Tables_in_test 6108t1 6109SHOW CREATE TABLE t1; 6110Table Create Table 6111t1 CREATE TABLE `t1` ( 6112 `c1` int NOT NULL, 6113 UNIQUE KEY `i1` (`c1`) 6114) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6115DROP TABLE t1; 6116SHOW TABLES; 6117Tables_in_test 6118CREATE TABLE t1(c1 BIGINT NOT NULL); 6119SHOW TABLES; 6120Tables_in_test 6121t1 6122SHOW CREATE TABLE t1; 6123Table Create Table 6124t1 CREATE TABLE `t1` ( 6125 `c1` bigint NOT NULL 6126) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6127ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6128SHOW TABLES; 6129Tables_in_test 6130t1 6131SHOW CREATE TABLE t1; 6132Table Create Table 6133t1 CREATE TABLE `t1` ( 6134 `c1` bigint NOT NULL, 6135 UNIQUE KEY `i1` (`c1`) 6136) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6137DROP TABLE t1; 6138SHOW TABLES; 6139Tables_in_test 6140CREATE TABLE t1(c1 REAL NOT NULL); 6141SHOW TABLES; 6142Tables_in_test 6143t1 6144SHOW CREATE TABLE t1; 6145Table Create Table 6146t1 CREATE TABLE `t1` ( 6147 `c1` double NOT NULL 6148) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6149ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6150SHOW TABLES; 6151Tables_in_test 6152t1 6153SHOW CREATE TABLE t1; 6154Table Create Table 6155t1 CREATE TABLE `t1` ( 6156 `c1` double NOT NULL, 6157 UNIQUE KEY `i1` (`c1`) 6158) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6159DROP TABLE t1; 6160SHOW TABLES; 6161Tables_in_test 6162CREATE TABLE t1(c1 DOUBLE NOT NULL); 6163SHOW TABLES; 6164Tables_in_test 6165t1 6166SHOW CREATE TABLE t1; 6167Table Create Table 6168t1 CREATE TABLE `t1` ( 6169 `c1` double NOT NULL 6170) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6171ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6172SHOW TABLES; 6173Tables_in_test 6174t1 6175SHOW CREATE TABLE t1; 6176Table Create Table 6177t1 CREATE TABLE `t1` ( 6178 `c1` double NOT NULL, 6179 UNIQUE KEY `i1` (`c1`) 6180) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6181DROP TABLE t1; 6182SHOW TABLES; 6183Tables_in_test 6184CREATE TABLE t1(c1 FLOAT NOT NULL); 6185SHOW TABLES; 6186Tables_in_test 6187t1 6188SHOW CREATE TABLE t1; 6189Table Create Table 6190t1 CREATE TABLE `t1` ( 6191 `c1` float NOT NULL 6192) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6193ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6194SHOW TABLES; 6195Tables_in_test 6196t1 6197SHOW CREATE TABLE t1; 6198Table Create Table 6199t1 CREATE TABLE `t1` ( 6200 `c1` float NOT NULL, 6201 UNIQUE KEY `i1` (`c1`) 6202) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6203DROP TABLE t1; 6204SHOW TABLES; 6205Tables_in_test 6206CREATE TABLE t1(c1 DECIMAL NOT NULL); 6207SHOW TABLES; 6208Tables_in_test 6209t1 6210SHOW CREATE TABLE t1; 6211Table Create Table 6212t1 CREATE TABLE `t1` ( 6213 `c1` decimal(10,0) NOT NULL 6214) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6215ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6216SHOW TABLES; 6217Tables_in_test 6218t1 6219SHOW CREATE TABLE t1; 6220Table Create Table 6221t1 CREATE TABLE `t1` ( 6222 `c1` decimal(10,0) NOT NULL, 6223 UNIQUE KEY `i1` (`c1`) 6224) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6225DROP TABLE t1; 6226SHOW TABLES; 6227Tables_in_test 6228CREATE TABLE t1(c1 NUMERIC NOT NULL); 6229SHOW TABLES; 6230Tables_in_test 6231t1 6232SHOW CREATE TABLE t1; 6233Table Create Table 6234t1 CREATE TABLE `t1` ( 6235 `c1` decimal(10,0) NOT NULL 6236) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6237ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6238SHOW TABLES; 6239Tables_in_test 6240t1 6241SHOW CREATE TABLE t1; 6242Table Create Table 6243t1 CREATE TABLE `t1` ( 6244 `c1` decimal(10,0) NOT NULL, 6245 UNIQUE KEY `i1` (`c1`) 6246) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6247DROP TABLE t1; 6248SHOW TABLES; 6249Tables_in_test 6250CREATE TABLE t1(c1 DATE NOT NULL); 6251SHOW TABLES; 6252Tables_in_test 6253t1 6254SHOW CREATE TABLE t1; 6255Table Create Table 6256t1 CREATE TABLE `t1` ( 6257 `c1` date NOT NULL 6258) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6259ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6260SHOW TABLES; 6261Tables_in_test 6262t1 6263SHOW CREATE TABLE t1; 6264Table Create Table 6265t1 CREATE TABLE `t1` ( 6266 `c1` date NOT NULL, 6267 UNIQUE KEY `i1` (`c1`) 6268) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6269DROP TABLE t1; 6270SHOW TABLES; 6271Tables_in_test 6272CREATE TABLE t1(c1 TIME NOT NULL); 6273SHOW TABLES; 6274Tables_in_test 6275t1 6276SHOW CREATE TABLE t1; 6277Table Create Table 6278t1 CREATE TABLE `t1` ( 6279 `c1` time NOT NULL 6280) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6281ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6282SHOW TABLES; 6283Tables_in_test 6284t1 6285SHOW CREATE TABLE t1; 6286Table Create Table 6287t1 CREATE TABLE `t1` ( 6288 `c1` time NOT NULL, 6289 UNIQUE KEY `i1` (`c1`) 6290) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6291DROP TABLE t1; 6292SHOW TABLES; 6293Tables_in_test 6294CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 6295SHOW TABLES; 6296Tables_in_test 6297t1 6298SHOW CREATE TABLE t1; 6299Table Create Table 6300t1 CREATE TABLE `t1` ( 6301 `c1` timestamp NOT NULL 6302) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6303ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6304SHOW TABLES; 6305Tables_in_test 6306t1 6307SHOW CREATE TABLE t1; 6308Table Create Table 6309t1 CREATE TABLE `t1` ( 6310 `c1` timestamp NOT NULL, 6311 UNIQUE KEY `i1` (`c1`) 6312) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6313DROP TABLE t1; 6314SHOW TABLES; 6315Tables_in_test 6316CREATE TABLE t1(c1 YEAR NOT NULL); 6317SHOW TABLES; 6318Tables_in_test 6319t1 6320SHOW CREATE TABLE t1; 6321Table Create Table 6322t1 CREATE TABLE `t1` ( 6323 `c1` year NOT NULL 6324) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6325ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); 6326SHOW TABLES; 6327Tables_in_test 6328t1 6329SHOW CREATE TABLE t1; 6330Table Create Table 6331t1 CREATE TABLE `t1` ( 6332 `c1` year NOT NULL, 6333 UNIQUE KEY `i1` (`c1`) 6334) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 6335DROP TABLE t1; 6336SHOW TABLES; 6337Tables_in_test 6338