Debian Codegraph @

mysql-test/suite/engines/funcs/r/ta_drop_index.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NOT NULL, INDEX i1 (c1));
3 SHOW TABLES;
4 Tables_in_test
5 t1
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `c1` bit(1) NOT NULL,
10 KEY `i1` (`c1`)
11 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 ALTER TABLE t1 DROP KEY i1;
13 SHOW TABLES;
14 Tables_in_test
15 t1
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `c1` bit(1) NOT NULL
20 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
21 DROP TABLE t1;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t1(c1 TINYINT NOT NULL, INDEX i1 (c1));
25 SHOW TABLES;
26 Tables_in_test
27 t1
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `c1` tinyint NOT NULL,
32 KEY `i1` (`c1`)
33 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
34 ALTER TABLE t1 DROP KEY i1;
35 SHOW TABLES;
36 Tables_in_test
37 t1
38 SHOW CREATE TABLE t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `c1` tinyint NOT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 DROP TABLE t1;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t1(c1 SMALLINT NOT NULL, INDEX i1 (c1));
47 SHOW TABLES;
48 Tables_in_test
49 t1
50 SHOW CREATE TABLE t1;
51 Table Create Table
52 t1 CREATE TABLE `t1` (
53 `c1` smallint NOT NULL,
54 KEY `i1` (`c1`)
55 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
56 ALTER TABLE t1 DROP KEY i1;
57 SHOW TABLES;
58 Tables_in_test
59 t1
60 SHOW CREATE TABLE t1;
61 Table Create Table
62 t1 CREATE TABLE `t1` (
63 `c1` smallint NOT NULL
64 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
65 DROP TABLE t1;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, INDEX i1 (c1));
69 SHOW TABLES;
70 Tables_in_test
71 t1
72 SHOW CREATE TABLE t1;
73 Table Create Table
74 t1 CREATE TABLE `t1` (
75 `c1` mediumint NOT NULL,
76 KEY `i1` (`c1`)
77 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
78 ALTER TABLE t1 DROP KEY i1;
79 SHOW TABLES;
80 Tables_in_test
81 t1
82 SHOW CREATE TABLE t1;
83 Table Create Table
84 t1 CREATE TABLE `t1` (
85 `c1` mediumint NOT NULL
86 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
87 DROP TABLE t1;
88 SHOW TABLES;
89 Tables_in_test
90 CREATE TABLE t1(c1 INT NOT NULL, INDEX i1 (c1));
91 SHOW TABLES;
92 Tables_in_test
93 t1
94 SHOW CREATE TABLE t1;
95 Table Create Table
96 t1 CREATE TABLE `t1` (
97 `c1` int NOT NULL,
98 KEY `i1` (`c1`)
99 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
100 ALTER TABLE t1 DROP KEY i1;
101 SHOW TABLES;
102 Tables_in_test
103 t1
104 SHOW CREATE TABLE t1;
105 Table Create Table
106 t1 CREATE TABLE `t1` (
107 `c1` int NOT NULL
108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
109 DROP TABLE t1;
110 SHOW TABLES;
111 Tables_in_test
112 CREATE TABLE t1(c1 INTEGER NOT NULL, INDEX i1 (c1));
113 SHOW TABLES;
114 Tables_in_test
115 t1
116 SHOW CREATE TABLE t1;
117 Table Create Table
118 t1 CREATE TABLE `t1` (
119 `c1` int NOT NULL,
120 KEY `i1` (`c1`)
121 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
122 ALTER TABLE t1 DROP KEY i1;
123 SHOW TABLES;
124 Tables_in_test
125 t1
126 SHOW CREATE TABLE t1;
127 Table Create Table
128 t1 CREATE TABLE `t1` (
129 `c1` int NOT NULL
130 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 DROP TABLE t1;
132 SHOW TABLES;
133 Tables_in_test
134 CREATE TABLE t1(c1 BIGINT NOT NULL, INDEX i1 (c1));
135 SHOW TABLES;
136 Tables_in_test
137 t1
138 SHOW CREATE TABLE t1;
139 Table Create Table
140 t1 CREATE TABLE `t1` (
141 `c1` bigint NOT NULL,
142 KEY `i1` (`c1`)
143 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
144 ALTER TABLE t1 DROP KEY i1;
145 SHOW TABLES;
146 Tables_in_test
147 t1
148 SHOW CREATE TABLE t1;
149 Table Create Table
150 t1 CREATE TABLE `t1` (
151 `c1` bigint NOT NULL
152 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
153 DROP TABLE t1;
154 SHOW TABLES;
155 Tables_in_test
156 CREATE TABLE t1(c1 REAL NOT NULL, INDEX i1 (c1));
157 SHOW TABLES;
158 Tables_in_test
159 t1
160 SHOW CREATE TABLE t1;
161 Table Create Table
162 t1 CREATE TABLE `t1` (
163 `c1` double NOT NULL,
164 KEY `i1` (`c1`)
165 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
166 ALTER TABLE t1 DROP KEY i1;
167 SHOW TABLES;
168 Tables_in_test
169 t1
170 SHOW CREATE TABLE t1;
171 Table Create Table
172 t1 CREATE TABLE `t1` (
173 `c1` double NOT NULL
174 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
175 DROP TABLE t1;
176 SHOW TABLES;
177 Tables_in_test
178 CREATE TABLE t1(c1 DOUBLE NOT NULL, INDEX i1 (c1));
179 SHOW TABLES;
180 Tables_in_test
181 t1
182 SHOW CREATE TABLE t1;
183 Table Create Table
184 t1 CREATE TABLE `t1` (
185 `c1` double NOT NULL,
186 KEY `i1` (`c1`)
187 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
188 ALTER TABLE t1 DROP KEY i1;
189 SHOW TABLES;
190 Tables_in_test
191 t1
192 SHOW CREATE TABLE t1;
193 Table Create Table
194 t1 CREATE TABLE `t1` (
195 `c1` double NOT NULL
196 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
197 DROP TABLE t1;
198 SHOW TABLES;
199 Tables_in_test
200 CREATE TABLE t1(c1 FLOAT NOT NULL, INDEX i1 (c1));
201 SHOW TABLES;
202 Tables_in_test
203 t1
204 SHOW CREATE TABLE t1;
205 Table Create Table
206 t1 CREATE TABLE `t1` (
207 `c1` float NOT NULL,
208 KEY `i1` (`c1`)
209 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
210 ALTER TABLE t1 DROP KEY i1;
211 SHOW TABLES;
212 Tables_in_test
213 t1
214 SHOW CREATE TABLE t1;
215 Table Create Table
216 t1 CREATE TABLE `t1` (
217 `c1` float NOT NULL
218 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 DROP TABLE t1;
220 SHOW TABLES;
221 Tables_in_test
222 CREATE TABLE t1(c1 DECIMAL NOT NULL, INDEX i1 (c1));
223 SHOW TABLES;
224 Tables_in_test
225 t1
226 SHOW CREATE TABLE t1;
227 Table Create Table
228 t1 CREATE TABLE `t1` (
229 `c1` decimal(10,0) NOT NULL,
230 KEY `i1` (`c1`)
231 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
232 ALTER TABLE t1 DROP KEY i1;
233 SHOW TABLES;
234 Tables_in_test
235 t1
236 SHOW CREATE TABLE t1;
237 Table Create Table
238 t1 CREATE TABLE `t1` (
239 `c1` decimal(10,0) NOT NULL
240 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
241 DROP TABLE t1;
242 SHOW TABLES;
243 Tables_in_test
244 CREATE TABLE t1(c1 NUMERIC NOT NULL, INDEX i1 (c1));
245 SHOW TABLES;
246 Tables_in_test
247 t1
248 SHOW CREATE TABLE t1;
249 Table Create Table
250 t1 CREATE TABLE `t1` (
251 `c1` decimal(10,0) NOT NULL,
252 KEY `i1` (`c1`)
253 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
254 ALTER TABLE t1 DROP KEY i1;
255 SHOW TABLES;
256 Tables_in_test
257 t1
258 SHOW CREATE TABLE t1;
259 Table Create Table
260 t1 CREATE TABLE `t1` (
261 `c1` decimal(10,0) NOT NULL
262 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 DROP TABLE t1;
264 SHOW TABLES;
265 Tables_in_test
266 CREATE TABLE t1(c1 DATE NOT NULL, INDEX i1 (c1));
267 SHOW TABLES;
268 Tables_in_test
269 t1
270 SHOW CREATE TABLE t1;
271 Table Create Table
272 t1 CREATE TABLE `t1` (
273 `c1` date NOT NULL,
274 KEY `i1` (`c1`)
275 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
276 ALTER TABLE t1 DROP KEY i1;
277 SHOW TABLES;
278 Tables_in_test
279 t1
280 SHOW CREATE TABLE t1;
281 Table Create Table
282 t1 CREATE TABLE `t1` (
283 `c1` date NOT NULL
284 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 DROP TABLE t1;
286 SHOW TABLES;
287 Tables_in_test
288 CREATE TABLE t1(c1 TIME NOT NULL, INDEX i1 (c1));
289 SHOW TABLES;
290 Tables_in_test
291 t1
292 SHOW CREATE TABLE t1;
293 Table Create Table
294 t1 CREATE TABLE `t1` (
295 `c1` time NOT NULL,
296 KEY `i1` (`c1`)
297 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
298 ALTER TABLE t1 DROP KEY i1;
299 SHOW TABLES;
300 Tables_in_test
301 t1
302 SHOW CREATE TABLE t1;
303 Table Create Table
304 t1 CREATE TABLE `t1` (
305 `c1` time NOT NULL
306 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
307 DROP TABLE t1;
308 SHOW TABLES;
309 Tables_in_test
310 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, INDEX i1 (c1));
311 SHOW TABLES;
312 Tables_in_test
313 t1
314 SHOW CREATE TABLE t1;
315 Table Create Table
316 t1 CREATE TABLE `t1` (
317 `c1` timestamp NOT NULL,
318 KEY `i1` (`c1`)
319 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
320 ALTER TABLE t1 DROP KEY i1;
321 SHOW TABLES;
322 Tables_in_test
323 t1
324 SHOW CREATE TABLE t1;
325 Table Create Table
326 t1 CREATE TABLE `t1` (
327 `c1` timestamp NOT NULL
328 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
329 DROP TABLE t1;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TABLE t1(c1 YEAR NOT NULL, INDEX i1 (c1));
333 SHOW TABLES;
334 Tables_in_test
335 t1
336 SHOW CREATE TABLE t1;
337 Table Create Table
338 t1 CREATE TABLE `t1` (
339 `c1` year NOT NULL,
340 KEY `i1` (`c1`)
341 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
342 ALTER TABLE t1 DROP KEY i1;
343 SHOW TABLES;
344 Tables_in_test
345 t1
346 SHOW CREATE TABLE t1;
347 Table Create Table
348 t1 CREATE TABLE `t1` (
349 `c1` year NOT NULL
350 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
351 DROP TABLE t1;
352 SHOW TABLES;
353 Tables_in_test
354 CREATE TABLE t1(c1 BIT NOT NULL, INDEX i1 (c1));
355 SHOW TABLES;
356 Tables_in_test
357 t1
358 SHOW CREATE TABLE t1;
359 Table Create Table
360 t1 CREATE TABLE `t1` (
361 `c1` bit(1) NOT NULL,
362 KEY `i1` (`c1`)
363 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
364 ALTER TABLE t1 DROP KEY i1;
365 SHOW TABLES;
366 Tables_in_test
367 t1
368 SHOW CREATE TABLE t1;
369 Table Create Table
370 t1 CREATE TABLE `t1` (
371 `c1` bit(1) NOT NULL
372 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
373 DROP TABLE t1;
374 SHOW TABLES;
375 Tables_in_test
376 CREATE TABLE t1(c1 TINYINT NOT NULL, INDEX i1 (c1));
377 SHOW TABLES;
378 Tables_in_test
379 t1
380 SHOW CREATE TABLE t1;
381 Table Create Table
382 t1 CREATE TABLE `t1` (
383 `c1` tinyint NOT NULL,
384 KEY `i1` (`c1`)
385 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
386 ALTER TABLE t1 DROP KEY i1;
387 SHOW TABLES;
388 Tables_in_test
389 t1
390 SHOW CREATE TABLE t1;
391 Table Create Table
392 t1 CREATE TABLE `t1` (
393 `c1` tinyint NOT NULL
394 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
395 DROP TABLE t1;
396 SHOW TABLES;
397 Tables_in_test
398 CREATE TABLE t1(c1 SMALLINT NOT NULL, INDEX i1 (c1));
399 SHOW TABLES;
400 Tables_in_test
401 t1
402 SHOW CREATE TABLE t1;
403 Table Create Table
404 t1 CREATE TABLE `t1` (
405 `c1` smallint NOT NULL,
406 KEY `i1` (`c1`)
407 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
408 ALTER TABLE t1 DROP KEY i1;
409 SHOW TABLES;
410 Tables_in_test
411 t1
412 SHOW CREATE TABLE t1;
413 Table Create Table
414 t1 CREATE TABLE `t1` (
415 `c1` smallint NOT NULL
416 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
417 DROP TABLE t1;
418 SHOW TABLES;
419 Tables_in_test
420 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, INDEX i1 (c1));
421 SHOW TABLES;
422 Tables_in_test
423 t1
424 SHOW CREATE TABLE t1;
425 Table Create Table
426 t1 CREATE TABLE `t1` (
427 `c1` mediumint NOT NULL,
428 KEY `i1` (`c1`)
429 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
430 ALTER TABLE t1 DROP KEY i1;
431 SHOW TABLES;
432 Tables_in_test
433 t1
434 SHOW CREATE TABLE t1;
435 Table Create Table
436 t1 CREATE TABLE `t1` (
437 `c1` mediumint NOT NULL
438 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
439 DROP TABLE t1;
440 SHOW TABLES;
441 Tables_in_test
442 CREATE TABLE t1(c1 INT NOT NULL, INDEX i1 (c1));
443 SHOW TABLES;
444 Tables_in_test
445 t1
446 SHOW CREATE TABLE t1;
447 Table Create Table
448 t1 CREATE TABLE `t1` (
449 `c1` int NOT NULL,
450 KEY `i1` (`c1`)
451 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
452 ALTER TABLE t1 DROP KEY i1;
453 SHOW TABLES;
454 Tables_in_test
455 t1
456 SHOW CREATE TABLE t1;
457 Table Create Table
458 t1 CREATE TABLE `t1` (
459 `c1` int NOT NULL
460 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
461 DROP TABLE t1;
462 SHOW TABLES;
463 Tables_in_test
464 CREATE TABLE t1(c1 INTEGER NOT NULL, INDEX i1 (c1));
465 SHOW TABLES;
466 Tables_in_test
467 t1
468 SHOW CREATE TABLE t1;
469 Table Create Table
470 t1 CREATE TABLE `t1` (
471 `c1` int NOT NULL,
472 KEY `i1` (`c1`)
473 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
474 ALTER TABLE t1 DROP KEY i1;
475 SHOW TABLES;
476 Tables_in_test
477 t1
478 SHOW CREATE TABLE t1;
479 Table Create Table
480 t1 CREATE TABLE `t1` (
481 `c1` int NOT NULL
482 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
483 DROP TABLE t1;
484 SHOW TABLES;
485 Tables_in_test
486 CREATE TABLE t1(c1 BIGINT NOT NULL, INDEX i1 (c1));
487 SHOW TABLES;
488 Tables_in_test
489 t1
490 SHOW CREATE TABLE t1;
491 Table Create Table
492 t1 CREATE TABLE `t1` (
493 `c1` bigint NOT NULL,
494 KEY `i1` (`c1`)
495 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
496 ALTER TABLE t1 DROP KEY i1;
497 SHOW TABLES;
498 Tables_in_test
499 t1
500 SHOW CREATE TABLE t1;
501 Table Create Table
502 t1 CREATE TABLE `t1` (
503 `c1` bigint NOT NULL
504 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
505 DROP TABLE t1;
506 SHOW TABLES;
507 Tables_in_test
508 CREATE TABLE t1(c1 REAL NOT NULL, INDEX i1 (c1));
509 SHOW TABLES;
510 Tables_in_test
511 t1
512 SHOW CREATE TABLE t1;
513 Table Create Table
514 t1 CREATE TABLE `t1` (
515 `c1` double NOT NULL,
516 KEY `i1` (`c1`)
517 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
518 ALTER TABLE t1 DROP KEY i1;
519 SHOW TABLES;
520 Tables_in_test
521 t1
522 SHOW CREATE TABLE t1;
523 Table Create Table
524 t1 CREATE TABLE `t1` (
525 `c1` double NOT NULL
526 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
527 DROP TABLE t1;
528 SHOW TABLES;
529 Tables_in_test
530 CREATE TABLE t1(c1 DOUBLE NOT NULL, INDEX i1 (c1));
531 SHOW TABLES;
532 Tables_in_test
533 t1
534 SHOW CREATE TABLE t1;
535 Table Create Table
536 t1 CREATE TABLE `t1` (
537 `c1` double NOT NULL,
538 KEY `i1` (`c1`)
539 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
540 ALTER TABLE t1 DROP KEY i1;
541 SHOW TABLES;
542 Tables_in_test
543 t1
544 SHOW CREATE TABLE t1;
545 Table Create Table
546 t1 CREATE TABLE `t1` (
547 `c1` double NOT NULL
548 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
549 DROP TABLE t1;
550 SHOW TABLES;
551 Tables_in_test
552 CREATE TABLE t1(c1 FLOAT NOT NULL, INDEX i1 (c1));
553 SHOW TABLES;
554 Tables_in_test
555 t1
556 SHOW CREATE TABLE t1;
557 Table Create Table
558 t1 CREATE TABLE `t1` (
559 `c1` float NOT NULL,
560 KEY `i1` (`c1`)
561 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
562 ALTER TABLE t1 DROP KEY i1;
563 SHOW TABLES;
564 Tables_in_test
565 t1
566 SHOW CREATE TABLE t1;
567 Table Create Table
568 t1 CREATE TABLE `t1` (
569 `c1` float NOT NULL
570 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
571 DROP TABLE t1;
572 SHOW TABLES;
573 Tables_in_test
574 CREATE TABLE t1(c1 DECIMAL NOT NULL, INDEX i1 (c1));
575 SHOW TABLES;
576 Tables_in_test
577 t1
578 SHOW CREATE TABLE t1;
579 Table Create Table
580 t1 CREATE TABLE `t1` (
581 `c1` decimal(10,0) NOT NULL,
582 KEY `i1` (`c1`)
583 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
584 ALTER TABLE t1 DROP KEY i1;
585 SHOW TABLES;
586 Tables_in_test
587 t1
588 SHOW CREATE TABLE t1;
589 Table Create Table
590 t1 CREATE TABLE `t1` (
591 `c1` decimal(10,0) NOT NULL
592 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
593 DROP TABLE t1;
594 SHOW TABLES;
595 Tables_in_test
596 CREATE TABLE t1(c1 NUMERIC NOT NULL, INDEX i1 (c1));
597 SHOW TABLES;
598 Tables_in_test
599 t1
600 SHOW CREATE TABLE t1;
601 Table Create Table
602 t1 CREATE TABLE `t1` (
603 `c1` decimal(10,0) NOT NULL,
604 KEY `i1` (`c1`)
605 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
606 ALTER TABLE t1 DROP KEY i1;
607 SHOW TABLES;
608 Tables_in_test
609 t1
610 SHOW CREATE TABLE t1;
611 Table Create Table
612 t1 CREATE TABLE `t1` (
613 `c1` decimal(10,0) NOT NULL
614 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
615 DROP TABLE t1;
616 SHOW TABLES;
617 Tables_in_test
618 CREATE TABLE t1(c1 DATE NOT NULL, INDEX i1 (c1));
619 SHOW TABLES;
620 Tables_in_test
621 t1
622 SHOW CREATE TABLE t1;
623 Table Create Table
624 t1 CREATE TABLE `t1` (
625 `c1` date NOT NULL,
626 KEY `i1` (`c1`)
627 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
628 ALTER TABLE t1 DROP KEY i1;
629 SHOW TABLES;
630 Tables_in_test
631 t1
632 SHOW CREATE TABLE t1;
633 Table Create Table
634 t1 CREATE TABLE `t1` (
635 `c1` date NOT NULL
636 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
637 DROP TABLE t1;
638 SHOW TABLES;
639 Tables_in_test
640 CREATE TABLE t1(c1 TIME NOT NULL, INDEX i1 (c1));
641 SHOW TABLES;
642 Tables_in_test
643 t1
644 SHOW CREATE TABLE t1;
645 Table Create Table
646 t1 CREATE TABLE `t1` (
647 `c1` time NOT NULL,
648 KEY `i1` (`c1`)
649 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
650 ALTER TABLE t1 DROP KEY i1;
651 SHOW TABLES;
652 Tables_in_test
653 t1
654 SHOW CREATE TABLE t1;
655 Table Create Table
656 t1 CREATE TABLE `t1` (
657 `c1` time NOT NULL
658 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
659 DROP TABLE t1;
660 SHOW TABLES;
661 Tables_in_test
662 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, INDEX i1 (c1));
663 SHOW TABLES;
664 Tables_in_test
665 t1
666 SHOW CREATE TABLE t1;
667 Table Create Table
668 t1 CREATE TABLE `t1` (
669 `c1` timestamp NOT NULL,
670 KEY `i1` (`c1`)
671 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
672 ALTER TABLE t1 DROP KEY i1;
673 SHOW TABLES;
674 Tables_in_test
675 t1
676 SHOW CREATE TABLE t1;
677 Table Create Table
678 t1 CREATE TABLE `t1` (
679 `c1` timestamp NOT NULL
680 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
681 DROP TABLE t1;
682 SHOW TABLES;
683 Tables_in_test
684 CREATE TABLE t1(c1 YEAR NOT NULL, INDEX i1 (c1));
685 SHOW TABLES;
686 Tables_in_test
687 t1
688 SHOW CREATE TABLE t1;
689 Table Create Table
690 t1 CREATE TABLE `t1` (
691 `c1` year NOT NULL,
692 KEY `i1` (`c1`)
693 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
694 ALTER TABLE t1 DROP KEY i1;
695 SHOW TABLES;
696 Tables_in_test
697 t1
698 SHOW CREATE TABLE t1;
699 Table Create Table
700 t1 CREATE TABLE `t1` (
701 `c1` year NOT NULL
702 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
703 DROP TABLE t1;
704 SHOW TABLES;
705 Tables_in_test
706 CREATE TABLE t1(c1 BIT NOT NULL, INDEX i1 (c1));
707 SHOW TABLES;
708 Tables_in_test
709 t1
710 SHOW CREATE TABLE t1;
711 Table Create Table
712 t1 CREATE TABLE `t1` (
713 `c1` bit(1) NOT NULL,
714 KEY `i1` (`c1`)
715 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
716 ALTER TABLE t1 DROP KEY i1;
717 SHOW TABLES;
718 Tables_in_test
719 t1
720 SHOW CREATE TABLE t1;
721 Table Create Table
722 t1 CREATE TABLE `t1` (
723 `c1` bit(1) NOT NULL
724 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
725 DROP TABLE t1;
726 SHOW TABLES;
727 Tables_in_test
728 CREATE TABLE t1(c1 TINYINT NOT NULL, INDEX i1 (c1));
729 SHOW TABLES;
730 Tables_in_test
731 t1
732 SHOW CREATE TABLE t1;
733 Table Create Table
734 t1 CREATE TABLE `t1` (
735 `c1` tinyint NOT NULL,
736 KEY `i1` (`c1`)
737 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
738 ALTER TABLE t1 DROP KEY i1;
739 SHOW TABLES;
740 Tables_in_test
741 t1
742 SHOW CREATE TABLE t1;
743 Table Create Table
744 t1 CREATE TABLE `t1` (
745 `c1` tinyint NOT NULL
746 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
747 DROP TABLE t1;
748 SHOW TABLES;
749 Tables_in_test
750 CREATE TABLE t1(c1 SMALLINT NOT NULL, INDEX i1 (c1));
751 SHOW TABLES;
752 Tables_in_test
753 t1
754 SHOW CREATE TABLE t1;
755 Table Create Table
756 t1 CREATE TABLE `t1` (
757 `c1` smallint NOT NULL,
758 KEY `i1` (`c1`)
759 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
760 ALTER TABLE t1 DROP KEY i1;
761 SHOW TABLES;
762 Tables_in_test
763 t1
764 SHOW CREATE TABLE t1;
765 Table Create Table
766 t1 CREATE TABLE `t1` (
767 `c1` smallint NOT NULL
768 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
769 DROP TABLE t1;
770 SHOW TABLES;
771 Tables_in_test
772 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, INDEX i1 (c1));
773 SHOW TABLES;
774 Tables_in_test
775 t1
776 SHOW CREATE TABLE t1;
777 Table Create Table
778 t1 CREATE TABLE `t1` (
779 `c1` mediumint NOT NULL,
780 KEY `i1` (`c1`)
781 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
782 ALTER TABLE t1 DROP KEY i1;
783 SHOW TABLES;
784 Tables_in_test
785 t1
786 SHOW CREATE TABLE t1;
787 Table Create Table
788 t1 CREATE TABLE `t1` (
789 `c1` mediumint NOT NULL
790 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
791 DROP TABLE t1;
792 SHOW TABLES;
793 Tables_in_test
794 CREATE TABLE t1(c1 INT NOT NULL, INDEX i1 (c1));
795 SHOW TABLES;
796 Tables_in_test
797 t1
798 SHOW CREATE TABLE t1;
799 Table Create Table
800 t1 CREATE TABLE `t1` (
801 `c1` int NOT NULL,
802 KEY `i1` (`c1`)
803 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
804 ALTER TABLE t1 DROP KEY i1;
805 SHOW TABLES;
806 Tables_in_test
807 t1
808 SHOW CREATE TABLE t1;
809 Table Create Table
810 t1 CREATE TABLE `t1` (
811 `c1` int NOT NULL
812 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
813 DROP TABLE t1;
814 SHOW TABLES;
815 Tables_in_test
816 CREATE TABLE t1(c1 INTEGER NOT NULL, INDEX i1 (c1));
817 SHOW TABLES;
818 Tables_in_test
819 t1
820 SHOW CREATE TABLE t1;
821 Table Create Table
822 t1 CREATE TABLE `t1` (
823 `c1` int NOT NULL,
824 KEY `i1` (`c1`)
825 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
826 ALTER TABLE t1 DROP KEY i1;
827 SHOW TABLES;
828 Tables_in_test
829 t1
830 SHOW CREATE TABLE t1;
831 Table Create Table
832 t1 CREATE TABLE `t1` (
833 `c1` int NOT NULL
834 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
835 DROP TABLE t1;
836 SHOW TABLES;
837 Tables_in_test
838 CREATE TABLE t1(c1 BIGINT NOT NULL, INDEX i1 (c1));
839 SHOW TABLES;
840 Tables_in_test
841 t1
842 SHOW CREATE TABLE t1;
843 Table Create Table
844 t1 CREATE TABLE `t1` (
845 `c1` bigint NOT NULL,
846 KEY `i1` (`c1`)
847 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
848 ALTER TABLE t1 DROP KEY i1;
849 SHOW TABLES;
850 Tables_in_test
851 t1
852 SHOW CREATE TABLE t1;
853 Table Create Table
854 t1 CREATE TABLE `t1` (
855 `c1` bigint NOT NULL
856 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
857 DROP TABLE t1;
858 SHOW TABLES;
859 Tables_in_test
860 CREATE TABLE t1(c1 REAL NOT NULL, INDEX i1 (c1));
861 SHOW TABLES;
862 Tables_in_test
863 t1
864 SHOW CREATE TABLE t1;
865 Table Create Table
866 t1 CREATE TABLE `t1` (
867 `c1` double NOT NULL,
868 KEY `i1` (`c1`)
869 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
870 ALTER TABLE t1 DROP KEY i1;
871 SHOW TABLES;
872 Tables_in_test
873 t1
874 SHOW CREATE TABLE t1;
875 Table Create Table
876 t1 CREATE TABLE `t1` (
877 `c1` double NOT NULL
878 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
879 DROP TABLE t1;
880 SHOW TABLES;
881 Tables_in_test
882 CREATE TABLE t1(c1 DOUBLE NOT NULL, INDEX i1 (c1));
883 SHOW TABLES;
884 Tables_in_test
885 t1
886 SHOW CREATE TABLE t1;
887 Table Create Table
888 t1 CREATE TABLE `t1` (
889 `c1` double NOT NULL,
890 KEY `i1` (`c1`)
891 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
892 ALTER TABLE t1 DROP KEY i1;
893 SHOW TABLES;
894 Tables_in_test
895 t1
896 SHOW CREATE TABLE t1;
897 Table Create Table
898 t1 CREATE TABLE `t1` (
899 `c1` double NOT NULL
900 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
901 DROP TABLE t1;
902 SHOW TABLES;
903 Tables_in_test
904 CREATE TABLE t1(c1 FLOAT NOT NULL, INDEX i1 (c1));
905 SHOW TABLES;
906 Tables_in_test
907 t1
908 SHOW CREATE TABLE t1;
909 Table Create Table
910 t1 CREATE TABLE `t1` (
911 `c1` float NOT NULL,
912 KEY `i1` (`c1`)
913 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
914 ALTER TABLE t1 DROP KEY i1;
915 SHOW TABLES;
916 Tables_in_test
917 t1
918 SHOW CREATE TABLE t1;
919 Table Create Table
920 t1 CREATE TABLE `t1` (
921 `c1` float NOT NULL
922 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
923 DROP TABLE t1;
924 SHOW TABLES;
925 Tables_in_test
926 CREATE TABLE t1(c1 DECIMAL NOT NULL, INDEX i1 (c1));
927 SHOW TABLES;
928 Tables_in_test
929 t1
930 SHOW CREATE TABLE t1;
931 Table Create Table
932 t1 CREATE TABLE `t1` (
933 `c1` decimal(10,0) NOT NULL,
934 KEY `i1` (`c1`)
935 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
936 ALTER TABLE t1 DROP KEY i1;
937 SHOW TABLES;
938 Tables_in_test
939 t1
940 SHOW CREATE TABLE t1;
941 Table Create Table
942 t1 CREATE TABLE `t1` (
943 `c1` decimal(10,0) NOT NULL
944 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
945 DROP TABLE t1;
946 SHOW TABLES;
947 Tables_in_test
948 CREATE TABLE t1(c1 NUMERIC NOT NULL, INDEX i1 (c1));
949 SHOW TABLES;
950 Tables_in_test
951 t1
952 SHOW CREATE TABLE t1;
953 Table Create Table
954 t1 CREATE TABLE `t1` (
955 `c1` decimal(10,0) NOT NULL,
956 KEY `i1` (`c1`)
957 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
958 ALTER TABLE t1 DROP KEY i1;
959 SHOW TABLES;
960 Tables_in_test
961 t1
962 SHOW CREATE TABLE t1;
963 Table Create Table
964 t1 CREATE TABLE `t1` (
965 `c1` decimal(10,0) NOT NULL
966 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
967 DROP TABLE t1;
968 SHOW TABLES;
969 Tables_in_test
970 CREATE TABLE t1(c1 DATE NOT NULL, INDEX i1 (c1));
971 SHOW TABLES;
972 Tables_in_test
973 t1
974 SHOW CREATE TABLE t1;
975 Table Create Table
976 t1 CREATE TABLE `t1` (
977 `c1` date NOT NULL,
978 KEY `i1` (`c1`)
979 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
980 ALTER TABLE t1 DROP KEY i1;
981 SHOW TABLES;
982 Tables_in_test
983 t1
984 SHOW CREATE TABLE t1;
985 Table Create Table
986 t1 CREATE TABLE `t1` (
987 `c1` date NOT NULL
988 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
989 DROP TABLE t1;
990 SHOW TABLES;
991 Tables_in_test
992 CREATE TABLE t1(c1 TIME NOT NULL, INDEX i1 (c1));
993 SHOW TABLES;
994 Tables_in_test
995 t1
996 SHOW CREATE TABLE t1;
997 Table Create Table
998 t1 CREATE TABLE `t1` (
999 `c1` time NOT NULL,
1000 KEY `i1` (`c1`)
1001 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1002 ALTER TABLE t1 DROP KEY i1;
1003 SHOW TABLES;
1004 Tables_in_test
1005 t1
1006 SHOW CREATE TABLE t1;
1007 Table Create Table
1008 t1 CREATE TABLE `t1` (
1009 `c1` time NOT NULL
1010 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1011 DROP TABLE t1;
1012 SHOW TABLES;
1013 Tables_in_test
1014 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, INDEX i1 (c1));
1015 SHOW TABLES;
1016 Tables_in_test
1017 t1
1018 SHOW CREATE TABLE t1;
1019 Table Create Table
1020 t1 CREATE TABLE `t1` (
1021 `c1` timestamp NOT NULL,
1022 KEY `i1` (`c1`)
1023 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1024 ALTER TABLE t1 DROP KEY i1;
1025 SHOW TABLES;
1026 Tables_in_test
1027 t1
1028 SHOW CREATE TABLE t1;
1029 Table Create Table
1030 t1 CREATE TABLE `t1` (
1031 `c1` timestamp NOT NULL
1032 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1033 DROP TABLE t1;
1034 SHOW TABLES;
1035 Tables_in_test
1036 CREATE TABLE t1(c1 YEAR NOT NULL, INDEX i1 (c1));
1037 SHOW TABLES;
1038 Tables_in_test
1039 t1
1040 SHOW CREATE TABLE t1;
1041 Table Create Table
1042 t1 CREATE TABLE `t1` (
1043 `c1` year NOT NULL,
1044 KEY `i1` (`c1`)
1045 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1046 ALTER TABLE t1 DROP KEY i1;
1047 SHOW TABLES;
1048 Tables_in_test
1049 t1
1050 SHOW CREATE TABLE t1;
1051 Table Create Table
1052 t1 CREATE TABLE `t1` (
1053 `c1` year NOT NULL
1054 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1055 DROP TABLE t1;
1056 SHOW TABLES;
1057 Tables_in_test
1058 CREATE TABLE t1(c1 BIT NOT NULL, INDEX i1 (c1));
1059 SHOW TABLES;
1060 Tables_in_test
1061 t1
1062 SHOW CREATE TABLE t1;
1063 Table Create Table
1064 t1 CREATE TABLE `t1` (
1065 `c1` bit(1) NOT NULL,
1066 KEY `i1` (`c1`)
1067 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1068 ALTER TABLE t1 DROP INDEX i1;
1069 SHOW TABLES;
1070 Tables_in_test
1071 t1
1072 SHOW CREATE TABLE t1;
1073 Table Create Table
1074 t1 CREATE TABLE `t1` (
1075 `c1` bit(1) NOT NULL
1076 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1077 DROP TABLE t1;
1078 SHOW TABLES;
1079 Tables_in_test
1080 CREATE TABLE t1(c1 TINYINT NOT NULL, INDEX i1 (c1));
1081 SHOW TABLES;
1082 Tables_in_test
1083 t1
1084 SHOW CREATE TABLE t1;
1085 Table Create Table
1086 t1 CREATE TABLE `t1` (
1087 `c1` tinyint NOT NULL,
1088 KEY `i1` (`c1`)
1089 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1090 ALTER TABLE t1 DROP INDEX i1;
1091 SHOW TABLES;
1092 Tables_in_test
1093 t1
1094 SHOW CREATE TABLE t1;
1095 Table Create Table
1096 t1 CREATE TABLE `t1` (
1097 `c1` tinyint NOT NULL
1098 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1099 DROP TABLE t1;
1100 SHOW TABLES;
1101 Tables_in_test
1102 CREATE TABLE t1(c1 SMALLINT NOT NULL, INDEX i1 (c1));
1103 SHOW TABLES;
1104 Tables_in_test
1105 t1
1106 SHOW CREATE TABLE t1;
1107 Table Create Table
1108 t1 CREATE TABLE `t1` (
1109 `c1` smallint NOT NULL,
1110 KEY `i1` (`c1`)
1111 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1112 ALTER TABLE t1 DROP INDEX i1;
1113 SHOW TABLES;
1114 Tables_in_test
1115 t1
1116 SHOW CREATE TABLE t1;
1117 Table Create Table
1118 t1 CREATE TABLE `t1` (
1119 `c1` smallint NOT NULL
1120 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1121 DROP TABLE t1;
1122 SHOW TABLES;
1123 Tables_in_test
1124 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, INDEX i1 (c1));
1125 SHOW TABLES;
1126 Tables_in_test
1127 t1
1128 SHOW CREATE TABLE t1;
1129 Table Create Table
1130 t1 CREATE TABLE `t1` (
1131 `c1` mediumint NOT NULL,
1132 KEY `i1` (`c1`)
1133 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1134 ALTER TABLE t1 DROP INDEX i1;
1135 SHOW TABLES;
1136 Tables_in_test
1137 t1
1138 SHOW CREATE TABLE t1;
1139 Table Create Table
1140 t1 CREATE TABLE `t1` (
1141 `c1` mediumint NOT NULL
1142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1143 DROP TABLE t1;
1144 SHOW TABLES;
1145 Tables_in_test
1146 CREATE TABLE t1(c1 INT NOT NULL, INDEX i1 (c1));
1147 SHOW TABLES;
1148 Tables_in_test
1149 t1
1150 SHOW CREATE TABLE t1;
1151 Table Create Table
1152 t1 CREATE TABLE `t1` (
1153 `c1` int NOT NULL,
1154 KEY `i1` (`c1`)
1155 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1156 ALTER TABLE t1 DROP INDEX i1;
1157 SHOW TABLES;
1158 Tables_in_test
1159 t1
1160 SHOW CREATE TABLE t1;
1161 Table Create Table
1162 t1 CREATE TABLE `t1` (
1163 `c1` int NOT NULL
1164 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1165 DROP TABLE t1;
1166 SHOW TABLES;
1167 Tables_in_test
1168 CREATE TABLE t1(c1 INTEGER NOT NULL, INDEX i1 (c1));
1169 SHOW TABLES;
1170 Tables_in_test
1171 t1
1172 SHOW CREATE TABLE t1;
1173 Table Create Table
1174 t1 CREATE TABLE `t1` (
1175 `c1` int NOT NULL,
1176 KEY `i1` (`c1`)
1177 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1178 ALTER TABLE t1 DROP INDEX i1;
1179 SHOW TABLES;
1180 Tables_in_test
1181 t1
1182 SHOW CREATE TABLE t1;
1183 Table Create Table
1184 t1 CREATE TABLE `t1` (
1185 `c1` int NOT NULL
1186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1187 DROP TABLE t1;
1188 SHOW TABLES;
1189 Tables_in_test
1190 CREATE TABLE t1(c1 BIGINT NOT NULL, INDEX i1 (c1));
1191 SHOW TABLES;
1192 Tables_in_test
1193 t1
1194 SHOW CREATE TABLE t1;
1195 Table Create Table
1196 t1 CREATE TABLE `t1` (
1197 `c1` bigint NOT NULL,
1198 KEY `i1` (`c1`)
1199 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1200 ALTER TABLE t1 DROP INDEX i1;
1201 SHOW TABLES;
1202 Tables_in_test
1203 t1
1204 SHOW CREATE TABLE t1;
1205 Table Create Table
1206 t1 CREATE TABLE `t1` (
1207 `c1` bigint NOT NULL
1208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1209 DROP TABLE t1;
1210 SHOW TABLES;
1211 Tables_in_test
1212 CREATE TABLE t1(c1 REAL NOT NULL, INDEX i1 (c1));
1213 SHOW TABLES;
1214 Tables_in_test
1215 t1
1216 SHOW CREATE TABLE t1;
1217 Table Create Table
1218 t1 CREATE TABLE `t1` (
1219 `c1` double NOT NULL,
1220 KEY `i1` (`c1`)
1221 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1222 ALTER TABLE t1 DROP INDEX i1;
1223 SHOW TABLES;
1224 Tables_in_test
1225 t1
1226 SHOW CREATE TABLE t1;
1227 Table Create Table
1228 t1 CREATE TABLE `t1` (
1229 `c1` double NOT NULL
1230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1231 DROP TABLE t1;
1232 SHOW TABLES;
1233 Tables_in_test
1234 CREATE TABLE t1(c1 DOUBLE NOT NULL, INDEX i1 (c1));
1235 SHOW TABLES;
1236 Tables_in_test
1237 t1
1238 SHOW CREATE TABLE t1;
1239 Table Create Table
1240 t1 CREATE TABLE `t1` (
1241 `c1` double NOT NULL,
1242 KEY `i1` (`c1`)
1243 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1244 ALTER TABLE t1 DROP INDEX i1;
1245 SHOW TABLES;
1246 Tables_in_test
1247 t1
1248 SHOW CREATE TABLE t1;
1249 Table Create Table
1250 t1 CREATE TABLE `t1` (
1251 `c1` double NOT NULL
1252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1253 DROP TABLE t1;
1254 SHOW TABLES;
1255 Tables_in_test
1256 CREATE TABLE t1(c1 FLOAT NOT NULL, INDEX i1 (c1));
1257 SHOW TABLES;
1258 Tables_in_test
1259 t1
1260 SHOW CREATE TABLE t1;
1261 Table Create Table
1262 t1 CREATE TABLE `t1` (
1263 `c1` float NOT NULL,
1264 KEY `i1` (`c1`)
1265 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1266 ALTER TABLE t1 DROP INDEX i1;
1267 SHOW TABLES;
1268 Tables_in_test
1269 t1
1270 SHOW CREATE TABLE t1;
1271 Table Create Table
1272 t1 CREATE TABLE `t1` (
1273 `c1` float NOT NULL
1274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1275 DROP TABLE t1;
1276 SHOW TABLES;
1277 Tables_in_test
1278 CREATE TABLE t1(c1 DECIMAL NOT NULL, INDEX i1 (c1));
1279 SHOW TABLES;
1280 Tables_in_test
1281 t1
1282 SHOW CREATE TABLE t1;
1283 Table Create Table
1284 t1 CREATE TABLE `t1` (
1285 `c1` decimal(10,0) NOT NULL,
1286 KEY `i1` (`c1`)
1287 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1288 ALTER TABLE t1 DROP INDEX i1;
1289 SHOW TABLES;
1290 Tables_in_test
1291 t1
1292 SHOW CREATE TABLE t1;
1293 Table Create Table
1294 t1 CREATE TABLE `t1` (
1295 `c1` decimal(10,0) NOT NULL
1296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1297 DROP TABLE t1;
1298 SHOW TABLES;
1299 Tables_in_test
1300 CREATE TABLE t1(c1 NUMERIC NOT NULL, INDEX i1 (c1));
1301 SHOW TABLES;
1302 Tables_in_test
1303 t1
1304 SHOW CREATE TABLE t1;
1305 Table Create Table
1306 t1 CREATE TABLE `t1` (
1307 `c1` decimal(10,0) NOT NULL,
1308 KEY `i1` (`c1`)
1309 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1310 ALTER TABLE t1 DROP INDEX i1;
1311 SHOW TABLES;
1312 Tables_in_test
1313 t1
1314 SHOW CREATE TABLE t1;
1315 Table Create Table
1316 t1 CREATE TABLE `t1` (
1317 `c1` decimal(10,0) NOT NULL
1318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1319 DROP TABLE t1;
1320 SHOW TABLES;
1321 Tables_in_test
1322 CREATE TABLE t1(c1 DATE NOT NULL, INDEX i1 (c1));
1323 SHOW TABLES;
1324 Tables_in_test
1325 t1
1326 SHOW CREATE TABLE t1;
1327 Table Create Table
1328 t1 CREATE TABLE `t1` (
1329 `c1` date NOT NULL,
1330 KEY `i1` (`c1`)
1331 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1332 ALTER TABLE t1 DROP INDEX i1;
1333 SHOW TABLES;
1334 Tables_in_test
1335 t1
1336 SHOW CREATE TABLE t1;
1337 Table Create Table
1338 t1 CREATE TABLE `t1` (
1339 `c1` date NOT NULL
1340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1341 DROP TABLE t1;
1342 SHOW TABLES;
1343 Tables_in_test
1344 CREATE TABLE t1(c1 TIME NOT NULL, INDEX i1 (c1));
1345 SHOW TABLES;
1346 Tables_in_test
1347 t1
1348 SHOW CREATE TABLE t1;
1349 Table Create Table
1350 t1 CREATE TABLE `t1` (
1351 `c1` time NOT NULL,
1352 KEY `i1` (`c1`)
1353 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1354 ALTER TABLE t1 DROP INDEX i1;
1355 SHOW TABLES;
1356 Tables_in_test
1357 t1
1358 SHOW CREATE TABLE t1;
1359 Table Create Table
1360 t1 CREATE TABLE `t1` (
1361 `c1` time NOT NULL
1362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1363 DROP TABLE t1;
1364 SHOW TABLES;
1365 Tables_in_test
1366 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, INDEX i1 (c1));
1367 SHOW TABLES;
1368 Tables_in_test
1369 t1
1370 SHOW CREATE TABLE t1;
1371 Table Create Table
1372 t1 CREATE TABLE `t1` (
1373 `c1` timestamp NOT NULL,
1374 KEY `i1` (`c1`)
1375 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1376 ALTER TABLE t1 DROP INDEX i1;
1377 SHOW TABLES;
1378 Tables_in_test
1379 t1
1380 SHOW CREATE TABLE t1;
1381 Table Create Table
1382 t1 CREATE TABLE `t1` (
1383 `c1` timestamp NOT NULL
1384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1385 DROP TABLE t1;
1386 SHOW TABLES;
1387 Tables_in_test
1388 CREATE TABLE t1(c1 YEAR NOT NULL, INDEX i1 (c1));
1389 SHOW TABLES;
1390 Tables_in_test
1391 t1
1392 SHOW CREATE TABLE t1;
1393 Table Create Table
1394 t1 CREATE TABLE `t1` (
1395 `c1` year NOT NULL,
1396 KEY `i1` (`c1`)
1397 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1398 ALTER TABLE t1 DROP INDEX i1;
1399 SHOW TABLES;
1400 Tables_in_test
1401 t1
1402 SHOW CREATE TABLE t1;
1403 Table Create Table
1404 t1 CREATE TABLE `t1` (
1405 `c1` year NOT NULL
1406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1407 DROP TABLE t1;
1408 SHOW TABLES;
1409 Tables_in_test
1410 CREATE TABLE t1(c1 BIT NOT NULL, INDEX i1 (c1));
1411 SHOW TABLES;
1412 Tables_in_test
1413 t1
1414 SHOW CREATE TABLE t1;
1415 Table Create Table
1416 t1 CREATE TABLE `t1` (
1417 `c1` bit(1) NOT NULL,
1418 KEY `i1` (`c1`)
1419 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1420 ALTER TABLE t1 DROP INDEX i1;
1421 SHOW TABLES;
1422 Tables_in_test
1423 t1
1424 SHOW CREATE TABLE t1;
1425 Table Create Table
1426 t1 CREATE TABLE `t1` (
1427 `c1` bit(1) NOT NULL
1428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1429 DROP TABLE t1;
1430 SHOW TABLES;
1431 Tables_in_test
1432 CREATE TABLE t1(c1 TINYINT NOT NULL, INDEX i1 (c1));
1433 SHOW TABLES;
1434 Tables_in_test
1435 t1
1436 SHOW CREATE TABLE t1;
1437 Table Create Table
1438 t1 CREATE TABLE `t1` (
1439 `c1` tinyint NOT NULL,
1440 KEY `i1` (`c1`)
1441 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1442 ALTER TABLE t1 DROP INDEX i1;
1443 SHOW TABLES;
1444 Tables_in_test
1445 t1
1446 SHOW CREATE TABLE t1;
1447 Table Create Table
1448 t1 CREATE TABLE `t1` (
1449 `c1` tinyint NOT NULL
1450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1451 DROP TABLE t1;
1452 SHOW TABLES;
1453 Tables_in_test
1454 CREATE TABLE t1(c1 SMALLINT NOT NULL, INDEX i1 (c1));
1455 SHOW TABLES;
1456 Tables_in_test
1457 t1
1458 SHOW CREATE TABLE t1;
1459 Table Create Table
1460 t1 CREATE TABLE `t1` (
1461 `c1` smallint NOT NULL,
1462 KEY `i1` (`c1`)
1463 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1464 ALTER TABLE t1 DROP INDEX i1;
1465 SHOW TABLES;
1466 Tables_in_test
1467 t1
1468 SHOW CREATE TABLE t1;
1469 Table Create Table
1470 t1 CREATE TABLE `t1` (
1471 `c1` smallint NOT NULL
1472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1473 DROP TABLE t1;
1474 SHOW TABLES;
1475 Tables_in_test
1476 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, INDEX i1 (c1));
1477 SHOW TABLES;
1478 Tables_in_test
1479 t1
1480 SHOW CREATE TABLE t1;
1481 Table Create Table
1482 t1 CREATE TABLE `t1` (
1483 `c1` mediumint NOT NULL,
1484 KEY `i1` (`c1`)
1485 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1486 ALTER TABLE t1 DROP INDEX i1;
1487 SHOW TABLES;
1488 Tables_in_test
1489 t1
1490 SHOW CREATE TABLE t1;
1491 Table Create Table
1492 t1 CREATE TABLE `t1` (
1493 `c1` mediumint NOT NULL
1494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1495 DROP TABLE t1;
1496 SHOW TABLES;
1497 Tables_in_test
1498 CREATE TABLE t1(c1 INT NOT NULL, INDEX i1 (c1));
1499 SHOW TABLES;
1500 Tables_in_test
1501 t1
1502 SHOW CREATE TABLE t1;
1503 Table Create Table
1504 t1 CREATE TABLE `t1` (
1505 `c1` int NOT NULL,
1506 KEY `i1` (`c1`)
1507 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1508 ALTER TABLE t1 DROP INDEX i1;
1509 SHOW TABLES;
1510 Tables_in_test
1511 t1
1512 SHOW CREATE TABLE t1;
1513 Table Create Table
1514 t1 CREATE TABLE `t1` (
1515 `c1` int NOT NULL
1516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1517 DROP TABLE t1;
1518 SHOW TABLES;
1519 Tables_in_test
1520 CREATE TABLE t1(c1 INTEGER NOT NULL, INDEX i1 (c1));
1521 SHOW TABLES;
1522 Tables_in_test
1523 t1
1524 SHOW CREATE TABLE t1;
1525 Table Create Table
1526 t1 CREATE TABLE `t1` (
1527 `c1` int NOT NULL,
1528 KEY `i1` (`c1`)
1529 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1530 ALTER TABLE t1 DROP INDEX i1;
1531 SHOW TABLES;
1532 Tables_in_test
1533 t1
1534 SHOW CREATE TABLE t1;
1535 Table Create Table
1536 t1 CREATE TABLE `t1` (
1537 `c1` int NOT NULL
1538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1539 DROP TABLE t1;
1540 SHOW TABLES;
1541 Tables_in_test
1542 CREATE TABLE t1(c1 BIGINT NOT NULL, INDEX i1 (c1));
1543 SHOW TABLES;
1544 Tables_in_test
1545 t1
1546 SHOW CREATE TABLE t1;
1547 Table Create Table
1548 t1 CREATE TABLE `t1` (
1549 `c1` bigint NOT NULL,
1550 KEY `i1` (`c1`)
1551 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1552 ALTER TABLE t1 DROP INDEX i1;
1553 SHOW TABLES;
1554 Tables_in_test
1555 t1
1556 SHOW CREATE TABLE t1;
1557 Table Create Table
1558 t1 CREATE TABLE `t1` (
1559 `c1` bigint NOT NULL
1560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1561 DROP TABLE t1;
1562 SHOW TABLES;
1563 Tables_in_test
1564 CREATE TABLE t1(c1 REAL NOT NULL, INDEX i1 (c1));
1565 SHOW TABLES;
1566 Tables_in_test
1567 t1
1568 SHOW CREATE TABLE t1;
1569 Table Create Table
1570 t1 CREATE TABLE `t1` (
1571 `c1` double NOT NULL,
1572 KEY `i1` (`c1`)
1573 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1574 ALTER TABLE t1 DROP INDEX i1;
1575 SHOW TABLES;
1576 Tables_in_test
1577 t1
1578 SHOW CREATE TABLE t1;
1579 Table Create Table
1580 t1 CREATE TABLE `t1` (
1581 `c1` double NOT NULL
1582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1583 DROP TABLE t1;
1584 SHOW TABLES;
1585 Tables_in_test
1586 CREATE TABLE t1(c1 DOUBLE NOT NULL, INDEX i1 (c1));
1587 SHOW TABLES;
1588 Tables_in_test
1589 t1
1590 SHOW CREATE TABLE t1;
1591 Table Create Table
1592 t1 CREATE TABLE `t1` (
1593 `c1` double NOT NULL,
1594 KEY `i1` (`c1`)
1595 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1596 ALTER TABLE t1 DROP INDEX i1;
1597 SHOW TABLES;
1598 Tables_in_test
1599 t1
1600 SHOW CREATE TABLE t1;
1601 Table Create Table
1602 t1 CREATE TABLE `t1` (
1603 `c1` double NOT NULL
1604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1605 DROP TABLE t1;
1606 SHOW TABLES;
1607 Tables_in_test
1608 CREATE TABLE t1(c1 FLOAT NOT NULL, INDEX i1 (c1));
1609 SHOW TABLES;
1610 Tables_in_test
1611 t1
1612 SHOW CREATE TABLE t1;
1613 Table Create Table
1614 t1 CREATE TABLE `t1` (
1615 `c1` float NOT NULL,
1616 KEY `i1` (`c1`)
1617 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1618 ALTER TABLE t1 DROP INDEX i1;
1619 SHOW TABLES;
1620 Tables_in_test
1621 t1
1622 SHOW CREATE TABLE t1;
1623 Table Create Table
1624 t1 CREATE TABLE `t1` (
1625 `c1` float NOT NULL
1626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1627 DROP TABLE t1;
1628 SHOW TABLES;
1629 Tables_in_test
1630 CREATE TABLE t1(c1 DECIMAL NOT NULL, INDEX i1 (c1));
1631 SHOW TABLES;
1632 Tables_in_test
1633 t1
1634 SHOW CREATE TABLE t1;
1635 Table Create Table
1636 t1 CREATE TABLE `t1` (
1637 `c1` decimal(10,0) NOT NULL,
1638 KEY `i1` (`c1`)
1639 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1640 ALTER TABLE t1 DROP INDEX i1;
1641 SHOW TABLES;
1642 Tables_in_test
1643 t1
1644 SHOW CREATE TABLE t1;
1645 Table Create Table
1646 t1 CREATE TABLE `t1` (
1647 `c1` decimal(10,0) NOT NULL
1648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1649 DROP TABLE t1;
1650 SHOW TABLES;
1651 Tables_in_test
1652 CREATE TABLE t1(c1 NUMERIC NOT NULL, INDEX i1 (c1));
1653 SHOW TABLES;
1654 Tables_in_test
1655 t1
1656 SHOW CREATE TABLE t1;
1657 Table Create Table
1658 t1 CREATE TABLE `t1` (
1659 `c1` decimal(10,0) NOT NULL,
1660 KEY `i1` (`c1`)
1661 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1662 ALTER TABLE t1 DROP INDEX i1;
1663 SHOW TABLES;
1664 Tables_in_test
1665 t1
1666 SHOW CREATE TABLE t1;
1667 Table Create Table
1668 t1 CREATE TABLE `t1` (
1669 `c1` decimal(10,0) NOT NULL
1670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1671 DROP TABLE t1;
1672 SHOW TABLES;
1673 Tables_in_test
1674 CREATE TABLE t1(c1 DATE NOT NULL, INDEX i1 (c1));
1675 SHOW TABLES;
1676 Tables_in_test
1677 t1
1678 SHOW CREATE TABLE t1;
1679 Table Create Table
1680 t1 CREATE TABLE `t1` (
1681 `c1` date NOT NULL,
1682 KEY `i1` (`c1`)
1683 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1684 ALTER TABLE t1 DROP INDEX i1;
1685 SHOW TABLES;
1686 Tables_in_test
1687 t1
1688 SHOW CREATE TABLE t1;
1689 Table Create Table
1690 t1 CREATE TABLE `t1` (
1691 `c1` date NOT NULL
1692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1693 DROP TABLE t1;
1694 SHOW TABLES;
1695 Tables_in_test
1696 CREATE TABLE t1(c1 TIME NOT NULL, INDEX i1 (c1));
1697 SHOW TABLES;
1698 Tables_in_test
1699 t1
1700 SHOW CREATE TABLE t1;
1701 Table Create Table
1702 t1 CREATE TABLE `t1` (
1703 `c1` time NOT NULL,
1704 KEY `i1` (`c1`)
1705 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1706 ALTER TABLE t1 DROP INDEX i1;
1707 SHOW TABLES;
1708 Tables_in_test
1709 t1
1710 SHOW CREATE TABLE t1;
1711 Table Create Table
1712 t1 CREATE TABLE `t1` (
1713 `c1` time NOT NULL
1714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1715 DROP TABLE t1;
1716 SHOW TABLES;
1717 Tables_in_test
1718 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, INDEX i1 (c1));
1719 SHOW TABLES;
1720 Tables_in_test
1721 t1
1722 SHOW CREATE TABLE t1;
1723 Table Create Table
1724 t1 CREATE TABLE `t1` (
1725 `c1` timestamp NOT NULL,
1726 KEY `i1` (`c1`)
1727 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1728 ALTER TABLE t1 DROP INDEX i1;
1729 SHOW TABLES;
1730 Tables_in_test
1731 t1
1732 SHOW CREATE TABLE t1;
1733 Table Create Table
1734 t1 CREATE TABLE `t1` (
1735 `c1` timestamp NOT NULL
1736 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1737 DROP TABLE t1;
1738 SHOW TABLES;
1739 Tables_in_test
1740 CREATE TABLE t1(c1 YEAR NOT NULL, INDEX i1 (c1));
1741 SHOW TABLES;
1742 Tables_in_test
1743 t1
1744 SHOW CREATE TABLE t1;
1745 Table Create Table
1746 t1 CREATE TABLE `t1` (
1747 `c1` year NOT NULL,
1748 KEY `i1` (`c1`)
1749 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1750 ALTER TABLE t1 DROP INDEX i1;
1751 SHOW TABLES;
1752 Tables_in_test
1753 t1
1754 SHOW CREATE TABLE t1;
1755 Table Create Table
1756 t1 CREATE TABLE `t1` (
1757 `c1` year NOT NULL
1758 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1759 DROP TABLE t1;
1760 SHOW TABLES;
1761 Tables_in_test
1762 CREATE TABLE t1(c1 BIT NOT NULL, INDEX i1 (c1));
1763 SHOW TABLES;
1764 Tables_in_test
1765 t1
1766 SHOW CREATE TABLE t1;
1767 Table Create Table
1768 t1 CREATE TABLE `t1` (
1769 `c1` bit(1) NOT NULL,
1770 KEY `i1` (`c1`)
1771 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1772 ALTER TABLE t1 DROP INDEX i1;
1773 SHOW TABLES;
1774 Tables_in_test
1775 t1
1776 SHOW CREATE TABLE t1;
1777 Table Create Table
1778 t1 CREATE TABLE `t1` (
1779 `c1` bit(1) NOT NULL
1780 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1781 DROP TABLE t1;
1782 SHOW TABLES;
1783 Tables_in_test
1784 CREATE TABLE t1(c1 TINYINT NOT NULL, INDEX i1 (c1));
1785 SHOW TABLES;
1786 Tables_in_test
1787 t1
1788 SHOW CREATE TABLE t1;
1789 Table Create Table
1790 t1 CREATE TABLE `t1` (
1791 `c1` tinyint NOT NULL,
1792 KEY `i1` (`c1`)
1793 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1794 ALTER TABLE t1 DROP INDEX i1;
1795 SHOW TABLES;
1796 Tables_in_test
1797 t1
1798 SHOW CREATE TABLE t1;
1799 Table Create Table
1800 t1 CREATE TABLE `t1` (
1801 `c1` tinyint NOT NULL
1802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1803 DROP TABLE t1;
1804 SHOW TABLES;
1805 Tables_in_test
1806 CREATE TABLE t1(c1 SMALLINT NOT NULL, INDEX i1 (c1));
1807 SHOW TABLES;
1808 Tables_in_test
1809 t1
1810 SHOW CREATE TABLE t1;
1811 Table Create Table
1812 t1 CREATE TABLE `t1` (
1813 `c1` smallint NOT NULL,
1814 KEY `i1` (`c1`)
1815 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1816 ALTER TABLE t1 DROP INDEX i1;
1817 SHOW TABLES;
1818 Tables_in_test
1819 t1
1820 SHOW CREATE TABLE t1;
1821 Table Create Table
1822 t1 CREATE TABLE `t1` (
1823 `c1` smallint NOT NULL
1824 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1825 DROP TABLE t1;
1826 SHOW TABLES;
1827 Tables_in_test
1828 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, INDEX i1 (c1));
1829 SHOW TABLES;
1830 Tables_in_test
1831 t1
1832 SHOW CREATE TABLE t1;
1833 Table Create Table
1834 t1 CREATE TABLE `t1` (
1835 `c1` mediumint NOT NULL,
1836 KEY `i1` (`c1`)
1837 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1838 ALTER TABLE t1 DROP INDEX i1;
1839 SHOW TABLES;
1840 Tables_in_test
1841 t1
1842 SHOW CREATE TABLE t1;
1843 Table Create Table
1844 t1 CREATE TABLE `t1` (
1845 `c1` mediumint NOT NULL
1846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1847 DROP TABLE t1;
1848 SHOW TABLES;
1849 Tables_in_test
1850 CREATE TABLE t1(c1 INT NOT NULL, INDEX i1 (c1));
1851 SHOW TABLES;
1852 Tables_in_test
1853 t1
1854 SHOW CREATE TABLE t1;
1855 Table Create Table
1856 t1 CREATE TABLE `t1` (
1857 `c1` int NOT NULL,
1858 KEY `i1` (`c1`)
1859 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1860 ALTER TABLE t1 DROP INDEX i1;
1861 SHOW TABLES;
1862 Tables_in_test
1863 t1
1864 SHOW CREATE TABLE t1;
1865 Table Create Table
1866 t1 CREATE TABLE `t1` (
1867 `c1` int NOT NULL
1868 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1869 DROP TABLE t1;
1870 SHOW TABLES;
1871 Tables_in_test
1872 CREATE TABLE t1(c1 INTEGER NOT NULL, INDEX i1 (c1));
1873 SHOW TABLES;
1874 Tables_in_test
1875 t1
1876 SHOW CREATE TABLE t1;
1877 Table Create Table
1878 t1 CREATE TABLE `t1` (
1879 `c1` int NOT NULL,
1880 KEY `i1` (`c1`)
1881 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1882 ALTER TABLE t1 DROP INDEX i1;
1883 SHOW TABLES;
1884 Tables_in_test
1885 t1
1886 SHOW CREATE TABLE t1;
1887 Table Create Table
1888 t1 CREATE TABLE `t1` (
1889 `c1` int NOT NULL
1890 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1891 DROP TABLE t1;
1892 SHOW TABLES;
1893 Tables_in_test
1894 CREATE TABLE t1(c1 BIGINT NOT NULL, INDEX i1 (c1));
1895 SHOW TABLES;
1896 Tables_in_test
1897 t1
1898 SHOW CREATE TABLE t1;
1899 Table Create Table
1900 t1 CREATE TABLE `t1` (
1901 `c1` bigint NOT NULL,
1902 KEY `i1` (`c1`)
1903 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1904 ALTER TABLE t1 DROP INDEX i1;
1905 SHOW TABLES;
1906 Tables_in_test
1907 t1
1908 SHOW CREATE TABLE t1;
1909 Table Create Table
1910 t1 CREATE TABLE `t1` (
1911 `c1` bigint NOT NULL
1912 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1913 DROP TABLE t1;
1914 SHOW TABLES;
1915 Tables_in_test
1916 CREATE TABLE t1(c1 REAL NOT NULL, INDEX i1 (c1));
1917 SHOW TABLES;
1918 Tables_in_test
1919 t1
1920 SHOW CREATE TABLE t1;
1921 Table Create Table
1922 t1 CREATE TABLE `t1` (
1923 `c1` double NOT NULL,
1924 KEY `i1` (`c1`)
1925 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1926 ALTER TABLE t1 DROP INDEX i1;
1927 SHOW TABLES;
1928 Tables_in_test
1929 t1
1930 SHOW CREATE TABLE t1;
1931 Table Create Table
1932 t1 CREATE TABLE `t1` (
1933 `c1` double NOT NULL
1934 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1935 DROP TABLE t1;
1936 SHOW TABLES;
1937 Tables_in_test
1938 CREATE TABLE t1(c1 DOUBLE NOT NULL, INDEX i1 (c1));
1939 SHOW TABLES;
1940 Tables_in_test
1941 t1
1942 SHOW CREATE TABLE t1;
1943 Table Create Table
1944 t1 CREATE TABLE `t1` (
1945 `c1` double NOT NULL,
1946 KEY `i1` (`c1`)
1947 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1948 ALTER TABLE t1 DROP INDEX i1;
1949 SHOW TABLES;
1950 Tables_in_test
1951 t1
1952 SHOW CREATE TABLE t1;
1953 Table Create Table
1954 t1 CREATE TABLE `t1` (
1955 `c1` double NOT NULL
1956 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1957 DROP TABLE t1;
1958 SHOW TABLES;
1959 Tables_in_test
1960 CREATE TABLE t1(c1 FLOAT NOT NULL, INDEX i1 (c1));
1961 SHOW TABLES;
1962 Tables_in_test
1963 t1
1964 SHOW CREATE TABLE t1;
1965 Table Create Table
1966 t1 CREATE TABLE `t1` (
1967 `c1` float NOT NULL,
1968 KEY `i1` (`c1`)
1969 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1970 ALTER TABLE t1 DROP INDEX i1;
1971 SHOW TABLES;
1972 Tables_in_test
1973 t1
1974 SHOW CREATE TABLE t1;
1975 Table Create Table
1976 t1 CREATE TABLE `t1` (
1977 `c1` float NOT NULL
1978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1979 DROP TABLE t1;
1980 SHOW TABLES;
1981 Tables_in_test
1982 CREATE TABLE t1(c1 DECIMAL NOT NULL, INDEX i1 (c1));
1983 SHOW TABLES;
1984 Tables_in_test
1985 t1
1986 SHOW CREATE TABLE t1;
1987 Table Create Table
1988 t1 CREATE TABLE `t1` (
1989 `c1` decimal(10,0) NOT NULL,
1990 KEY `i1` (`c1`)
1991 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1992 ALTER TABLE t1 DROP INDEX i1;
1993 SHOW TABLES;
1994 Tables_in_test
1995 t1
1996 SHOW CREATE TABLE t1;
1997 Table Create Table
1998 t1 CREATE TABLE `t1` (
1999 `c1` decimal(10,0) NOT NULL
2000 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2001 DROP TABLE t1;
2002 SHOW TABLES;
2003 Tables_in_test
2004 CREATE TABLE t1(c1 NUMERIC NOT NULL, INDEX i1 (c1));
2005 SHOW TABLES;
2006 Tables_in_test
2007 t1
2008 SHOW CREATE TABLE t1;
2009 Table Create Table
2010 t1 CREATE TABLE `t1` (
2011 `c1` decimal(10,0) NOT NULL,
2012 KEY `i1` (`c1`)
2013 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2014 ALTER TABLE t1 DROP INDEX i1;
2015 SHOW TABLES;
2016 Tables_in_test
2017 t1
2018 SHOW CREATE TABLE t1;
2019 Table Create Table
2020 t1 CREATE TABLE `t1` (
2021 `c1` decimal(10,0) NOT NULL
2022 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2023 DROP TABLE t1;
2024 SHOW TABLES;
2025 Tables_in_test
2026 CREATE TABLE t1(c1 DATE NOT NULL, INDEX i1 (c1));
2027 SHOW TABLES;
2028 Tables_in_test
2029 t1
2030 SHOW CREATE TABLE t1;
2031 Table Create Table
2032 t1 CREATE TABLE `t1` (
2033 `c1` date NOT NULL,
2034 KEY `i1` (`c1`)
2035 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2036 ALTER TABLE t1 DROP INDEX i1;
2037 SHOW TABLES;
2038 Tables_in_test
2039 t1
2040 SHOW CREATE TABLE t1;
2041 Table Create Table
2042 t1 CREATE TABLE `t1` (
2043 `c1` date NOT NULL
2044 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2045 DROP TABLE t1;
2046 SHOW TABLES;
2047 Tables_in_test
2048 CREATE TABLE t1(c1 TIME NOT NULL, INDEX i1 (c1));
2049 SHOW TABLES;
2050 Tables_in_test
2051 t1
2052 SHOW CREATE TABLE t1;
2053 Table Create Table
2054 t1 CREATE TABLE `t1` (
2055 `c1` time NOT NULL,
2056 KEY `i1` (`c1`)
2057 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2058 ALTER TABLE t1 DROP INDEX i1;
2059 SHOW TABLES;
2060 Tables_in_test
2061 t1
2062 SHOW CREATE TABLE t1;
2063 Table Create Table
2064 t1 CREATE TABLE `t1` (
2065 `c1` time NOT NULL
2066 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2067 DROP TABLE t1;
2068 SHOW TABLES;
2069 Tables_in_test
2070 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, INDEX i1 (c1));
2071 SHOW TABLES;
2072 Tables_in_test
2073 t1
2074 SHOW CREATE TABLE t1;
2075 Table Create Table
2076 t1 CREATE TABLE `t1` (
2077 `c1` timestamp NOT NULL,
2078 KEY `i1` (`c1`)
2079 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2080 ALTER TABLE t1 DROP INDEX i1;
2081 SHOW TABLES;
2082 Tables_in_test
2083 t1
2084 SHOW CREATE TABLE t1;
2085 Table Create Table
2086 t1 CREATE TABLE `t1` (
2087 `c1` timestamp NOT NULL
2088 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2089 DROP TABLE t1;
2090 SHOW TABLES;
2091 Tables_in_test
2092 CREATE TABLE t1(c1 YEAR NOT NULL, INDEX i1 (c1));
2093 SHOW TABLES;
2094 Tables_in_test
2095 t1
2096 SHOW CREATE TABLE t1;
2097 Table Create Table
2098 t1 CREATE TABLE `t1` (
2099 `c1` year NOT NULL,
2100 KEY `i1` (`c1`)
2101 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2102 ALTER TABLE t1 DROP INDEX i1;
2103 SHOW TABLES;
2104 Tables_in_test
2105 t1
2106 SHOW CREATE TABLE t1;
2107 Table Create Table
2108 t1 CREATE TABLE `t1` (
2109 `c1` year NOT NULL
2110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2111 DROP TABLE t1;
2112 SHOW TABLES;
2113 Tables_in_test