Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(30) NOT NULL);
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` char(30) NOT NULL
10 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 ALTER TABLE t1 ADD UNIQUE (c1);
12 SHOW TABLES;
13 Tables_in_test
14 t1
15 SHOW CREATE TABLE t1;
16 Table Create Table
17 t1 CREATE TABLE `t1` (
18 `c1` char(30) NOT NULL,
19 UNIQUE KEY `c1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
32 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 ALTER TABLE t1 ADD UNIQUE (c1);
34 SHOW TABLES;
35 Tables_in_test
36 t1
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `c1` varchar(30) NOT NULL,
41 UNIQUE KEY `c1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
54 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
55 ALTER TABLE t1 ADD UNIQUE (c1);
56 SHOW TABLES;
57 Tables_in_test
58 t1
59 SHOW CREATE TABLE t1;
60 Table Create Table
61 t1 CREATE TABLE `t1` (
62 `c1` binary(30) NOT NULL,
63 UNIQUE KEY `c1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
76 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
77 ALTER TABLE t1 ADD UNIQUE (c1);
78 SHOW TABLES;
79 Tables_in_test
80 t1
81 SHOW CREATE TABLE t1;
82 Table Create Table
83 t1 CREATE TABLE `t1` (
84 `c1` varbinary(30) NOT NULL,
85 UNIQUE KEY `c1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
98 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
99 ALTER TABLE t1 ADD UNIQUE KEY (c1);
100 SHOW TABLES;
101 Tables_in_test
102 t1
103 SHOW CREATE TABLE t1;
104 Table Create Table
105 t1 CREATE TABLE `t1` (
106 `c1` char(30) NOT NULL,
107 UNIQUE KEY `c1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
120 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
121 ALTER TABLE t1 ADD UNIQUE KEY (c1);
122 SHOW TABLES;
123 Tables_in_test
124 t1
125 SHOW CREATE TABLE t1;
126 Table Create Table
127 t1 CREATE TABLE `t1` (
128 `c1` varchar(30) NOT NULL,
129 UNIQUE KEY `c1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
142 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
143 ALTER TABLE t1 ADD UNIQUE KEY (c1);
144 SHOW TABLES;
145 Tables_in_test
146 t1
147 SHOW CREATE TABLE t1;
148 Table Create Table
149 t1 CREATE TABLE `t1` (
150 `c1` binary(30) NOT NULL,
151 UNIQUE KEY `c1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
164 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
165 ALTER TABLE t1 ADD UNIQUE KEY (c1);
166 SHOW TABLES;
167 Tables_in_test
168 t1
169 SHOW CREATE TABLE t1;
170 Table Create Table
171 t1 CREATE TABLE `t1` (
172 `c1` varbinary(30) NOT NULL,
173 UNIQUE KEY `c1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
186 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
187 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
188 SHOW TABLES;
189 Tables_in_test
190 t1
191 SHOW CREATE TABLE t1;
192 Table Create Table
193 t1 CREATE TABLE `t1` (
194 `c1` char(30) NOT NULL,
195 UNIQUE KEY `c1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
208 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
209 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
210 SHOW TABLES;
211 Tables_in_test
212 t1
213 SHOW CREATE TABLE t1;
214 Table Create Table
215 t1 CREATE TABLE `t1` (
216 `c1` varchar(30) NOT NULL,
217 UNIQUE KEY `c1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
231 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
232 SHOW TABLES;
233 Tables_in_test
234 t1
235 SHOW CREATE TABLE t1;
236 Table Create Table
237 t1 CREATE TABLE `t1` (
238 `c1` binary(30) NOT NULL,
239 UNIQUE KEY `c1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
252 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
253 ALTER TABLE t1 ADD UNIQUE INDEX (c1);
254 SHOW TABLES;
255 Tables_in_test
256 t1
257 SHOW CREATE TABLE t1;
258 Table Create Table
259 t1 CREATE TABLE `t1` (
260 `c1` varbinary(30) NOT NULL,
261 UNIQUE KEY `c1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
275 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
276 SHOW TABLES;
277 Tables_in_test
278 t1
279 SHOW CREATE TABLE t1;
280 Table Create Table
281 t1 CREATE TABLE `t1` (
282 `c1` char(30) NOT NULL,
283 UNIQUE KEY `c1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
296 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
297 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
298 SHOW TABLES;
299 Tables_in_test
300 t1
301 SHOW CREATE TABLE t1;
302 Table Create Table
303 t1 CREATE TABLE `t1` (
304 `c1` varchar(30) NOT NULL,
305 UNIQUE KEY `c1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
318 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
319 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
320 SHOW TABLES;
321 Tables_in_test
322 t1
323 SHOW CREATE TABLE t1;
324 Table Create Table
325 t1 CREATE TABLE `t1` (
326 `c1` binary(30) NOT NULL,
327 UNIQUE KEY `c1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
340 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
341 ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1);
342 SHOW TABLES;
343 Tables_in_test
344 t1
345 SHOW CREATE TABLE t1;
346 Table Create Table
347 t1 CREATE TABLE `t1` (
348 `c1` varbinary(30) NOT NULL,
349 UNIQUE KEY `c1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
362 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
363 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
364 SHOW TABLES;
365 Tables_in_test
366 t1
367 SHOW CREATE TABLE t1;
368 Table Create Table
369 t1 CREATE TABLE `t1` (
370 `c1` char(30) NOT NULL,
371 UNIQUE KEY `c1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
384 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
385 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
386 SHOW TABLES;
387 Tables_in_test
388 t1
389 SHOW CREATE TABLE t1;
390 Table Create Table
391 t1 CREATE TABLE `t1` (
392 `c1` varchar(30) NOT NULL,
393 UNIQUE KEY `c1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
406 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
407 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
408 SHOW TABLES;
409 Tables_in_test
410 t1
411 SHOW CREATE TABLE t1;
412 Table Create Table
413 t1 CREATE TABLE `t1` (
414 `c1` binary(30) NOT NULL,
415 UNIQUE KEY `c1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
428 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
429 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1);
430 SHOW TABLES;
431 Tables_in_test
432 t1
433 SHOW CREATE TABLE t1;
434 Table Create Table
435 t1 CREATE TABLE `t1` (
436 `c1` varbinary(30) NOT NULL,
437 UNIQUE KEY `c1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
450 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
451 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
452 SHOW TABLES;
453 Tables_in_test
454 t1
455 SHOW CREATE TABLE t1;
456 Table Create Table
457 t1 CREATE TABLE `t1` (
458 `c1` char(30) NOT NULL,
459 UNIQUE KEY `c1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
472 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
473 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
474 SHOW TABLES;
475 Tables_in_test
476 t1
477 SHOW CREATE TABLE t1;
478 Table Create Table
479 t1 CREATE TABLE `t1` (
480 `c1` varchar(30) NOT NULL,
481 UNIQUE KEY `c1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
494 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
495 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
496 SHOW TABLES;
497 Tables_in_test
498 t1
499 SHOW CREATE TABLE t1;
500 Table Create Table
501 t1 CREATE TABLE `t1` (
502 `c1` binary(30) NOT NULL,
503 UNIQUE KEY `c1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
516 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
517 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1);
518 SHOW TABLES;
519 Tables_in_test
520 t1
521 SHOW CREATE TABLE t1;
522 Table Create Table
523 t1 CREATE TABLE `t1` (
524 `c1` varbinary(30) NOT NULL,
525 UNIQUE KEY `c1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
538 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
539 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
540 SHOW TABLES;
541 Tables_in_test
542 t1
543 SHOW CREATE TABLE t1;
544 Table Create Table
545 t1 CREATE TABLE `t1` (
546 `c1` char(30) NOT NULL,
547 UNIQUE KEY `cst1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
560 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
561 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
562 SHOW TABLES;
563 Tables_in_test
564 t1
565 SHOW CREATE TABLE t1;
566 Table Create Table
567 t1 CREATE TABLE `t1` (
568 `c1` varchar(30) NOT NULL,
569 UNIQUE KEY `cst1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
583 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
584 SHOW TABLES;
585 Tables_in_test
586 t1
587 SHOW CREATE TABLE t1;
588 Table Create Table
589 t1 CREATE TABLE `t1` (
590 `c1` binary(30) NOT NULL,
591 UNIQUE KEY `cst1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
604 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
605 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1);
606 SHOW TABLES;
607 Tables_in_test
608 t1
609 SHOW CREATE TABLE t1;
610 Table Create Table
611 t1 CREATE TABLE `t1` (
612 `c1` varbinary(30) NOT NULL,
613 UNIQUE KEY `cst1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
626 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
627 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
628 SHOW TABLES;
629 Tables_in_test
630 t1
631 SHOW CREATE TABLE t1;
632 Table Create Table
633 t1 CREATE TABLE `t1` (
634 `c1` char(30) NOT NULL,
635 UNIQUE KEY `cst1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
648 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
649 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
650 SHOW TABLES;
651 Tables_in_test
652 t1
653 SHOW CREATE TABLE t1;
654 Table Create Table
655 t1 CREATE TABLE `t1` (
656 `c1` varchar(30) NOT NULL,
657 UNIQUE KEY `cst1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
670 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
671 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
672 SHOW TABLES;
673 Tables_in_test
674 t1
675 SHOW CREATE TABLE t1;
676 Table Create Table
677 t1 CREATE TABLE `t1` (
678 `c1` binary(30) NOT NULL,
679 UNIQUE KEY `cst1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
692 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
693 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1);
694 SHOW TABLES;
695 Tables_in_test
696 t1
697 SHOW CREATE TABLE t1;
698 Table Create Table
699 t1 CREATE TABLE `t1` (
700 `c1` varbinary(30) NOT NULL,
701 UNIQUE KEY `cst1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
714 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
715 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
716 SHOW TABLES;
717 Tables_in_test
718 t1
719 SHOW CREATE TABLE t1;
720 Table Create Table
721 t1 CREATE TABLE `t1` (
722 `c1` char(30) NOT NULL,
723 UNIQUE KEY `cst1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
736 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
737 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
738 SHOW TABLES;
739 Tables_in_test
740 t1
741 SHOW CREATE TABLE t1;
742 Table Create Table
743 t1 CREATE TABLE `t1` (
744 `c1` varchar(30) NOT NULL,
745 UNIQUE KEY `cst1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
758 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
759 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
760 SHOW TABLES;
761 Tables_in_test
762 t1
763 SHOW CREATE TABLE t1;
764 Table Create Table
765 t1 CREATE TABLE `t1` (
766 `c1` binary(30) NOT NULL,
767 UNIQUE KEY `cst1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
780 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
781 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1);
782 SHOW TABLES;
783 Tables_in_test
784 t1
785 SHOW CREATE TABLE t1;
786 Table Create Table
787 t1 CREATE TABLE `t1` (
788 `c1` varbinary(30) NOT NULL,
789 UNIQUE KEY `cst1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
802 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
803 ALTER TABLE t1 ADD UNIQUE i1 (c1);
804 SHOW TABLES;
805 Tables_in_test
806 t1
807 SHOW CREATE TABLE t1;
808 Table Create Table
809 t1 CREATE TABLE `t1` (
810 `c1` char(30) NOT NULL,
811 UNIQUE KEY `i1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
824 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
825 ALTER TABLE t1 ADD UNIQUE i1 (c1);
826 SHOW TABLES;
827 Tables_in_test
828 t1
829 SHOW CREATE TABLE t1;
830 Table Create Table
831 t1 CREATE TABLE `t1` (
832 `c1` varchar(30) NOT NULL,
833 UNIQUE KEY `i1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
846 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
847 ALTER TABLE t1 ADD UNIQUE i1 (c1);
848 SHOW TABLES;
849 Tables_in_test
850 t1
851 SHOW CREATE TABLE t1;
852 Table Create Table
853 t1 CREATE TABLE `t1` (
854 `c1` binary(30) NOT NULL,
855 UNIQUE KEY `i1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
868 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
869 ALTER TABLE t1 ADD UNIQUE i1 (c1);
870 SHOW TABLES;
871 Tables_in_test
872 t1
873 SHOW CREATE TABLE t1;
874 Table Create Table
875 t1 CREATE TABLE `t1` (
876 `c1` varbinary(30) NOT NULL,
877 UNIQUE KEY `i1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
890 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
891 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
892 SHOW TABLES;
893 Tables_in_test
894 t1
895 SHOW CREATE TABLE t1;
896 Table Create Table
897 t1 CREATE TABLE `t1` (
898 `c1` char(30) NOT NULL,
899 UNIQUE KEY `i1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
912 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
913 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
914 SHOW TABLES;
915 Tables_in_test
916 t1
917 SHOW CREATE TABLE t1;
918 Table Create Table
919 t1 CREATE TABLE `t1` (
920 `c1` varchar(30) NOT NULL,
921 UNIQUE KEY `i1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
934 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
935 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
936 SHOW TABLES;
937 Tables_in_test
938 t1
939 SHOW CREATE TABLE t1;
940 Table Create Table
941 t1 CREATE TABLE `t1` (
942 `c1` binary(30) NOT NULL,
943 UNIQUE KEY `i1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
956 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
957 ALTER TABLE t1 ADD UNIQUE KEY i1 (c1);
958 SHOW TABLES;
959 Tables_in_test
960 t1
961 SHOW CREATE TABLE t1;
962 Table Create Table
963 t1 CREATE TABLE `t1` (
964 `c1` varbinary(30) NOT NULL,
965 UNIQUE KEY `i1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
978 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
979 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
980 SHOW TABLES;
981 Tables_in_test
982 t1
983 SHOW CREATE TABLE t1;
984 Table Create Table
985 t1 CREATE TABLE `t1` (
986 `c1` char(30) NOT NULL,
987 UNIQUE KEY `i1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
1000 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1001 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1002 SHOW TABLES;
1003 Tables_in_test
1004 t1
1005 SHOW CREATE TABLE t1;
1006 Table Create Table
1007 t1 CREATE TABLE `t1` (
1008 `c1` varchar(30) NOT NULL,
1009 UNIQUE KEY `i1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
1022 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1023 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1024 SHOW TABLES;
1025 Tables_in_test
1026 t1
1027 SHOW CREATE TABLE t1;
1028 Table Create Table
1029 t1 CREATE TABLE `t1` (
1030 `c1` binary(30) NOT NULL,
1031 UNIQUE KEY `i1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
1044 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1045 ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1);
1046 SHOW TABLES;
1047 Tables_in_test
1048 t1
1049 SHOW CREATE TABLE t1;
1050 Table Create Table
1051 t1 CREATE TABLE `t1` (
1052 `c1` varbinary(30) NOT NULL,
1053 UNIQUE KEY `i1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
1066 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1067 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1068 SHOW TABLES;
1069 Tables_in_test
1070 t1
1071 SHOW CREATE TABLE t1;
1072 Table Create Table
1073 t1 CREATE TABLE `t1` (
1074 `c1` char(30) NOT NULL,
1075 UNIQUE KEY `i1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
1088 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1089 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1090 SHOW TABLES;
1091 Tables_in_test
1092 t1
1093 SHOW CREATE TABLE t1;
1094 Table Create Table
1095 t1 CREATE TABLE `t1` (
1096 `c1` varchar(30) NOT NULL,
1097 UNIQUE KEY `i1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
1110 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1111 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1112 SHOW TABLES;
1113 Tables_in_test
1114 t1
1115 SHOW CREATE TABLE t1;
1116 Table Create Table
1117 t1 CREATE TABLE `t1` (
1118 `c1` binary(30) NOT NULL,
1119 UNIQUE KEY `i1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
1132 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1133 ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1);
1134 SHOW TABLES;
1135 Tables_in_test
1136 t1
1137 SHOW CREATE TABLE t1;
1138 Table Create Table
1139 t1 CREATE TABLE `t1` (
1140 `c1` varbinary(30) NOT NULL,
1141 UNIQUE KEY `i1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
1154 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1155 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1156 SHOW TABLES;
1157 Tables_in_test
1158 t1
1159 SHOW CREATE TABLE t1;
1160 Table Create Table
1161 t1 CREATE TABLE `t1` (
1162 `c1` char(30) NOT NULL,
1163 UNIQUE KEY `i1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
1176 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1177 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1178 SHOW TABLES;
1179 Tables_in_test
1180 t1
1181 SHOW CREATE TABLE t1;
1182 Table Create Table
1183 t1 CREATE TABLE `t1` (
1184 `c1` varchar(30) NOT NULL,
1185 UNIQUE KEY `i1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
1198 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1199 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1200 SHOW TABLES;
1201 Tables_in_test
1202 t1
1203 SHOW CREATE TABLE t1;
1204 Table Create Table
1205 t1 CREATE TABLE `t1` (
1206 `c1` binary(30) NOT NULL,
1207 UNIQUE KEY `i1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
1220 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1221 ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1);
1222 SHOW TABLES;
1223 Tables_in_test
1224 t1
1225 SHOW CREATE TABLE t1;
1226 Table Create Table
1227 t1 CREATE TABLE `t1` (
1228 `c1` varbinary(30) NOT NULL,
1229 UNIQUE KEY `i1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
1242 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1243 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1244 SHOW TABLES;
1245 Tables_in_test
1246 t1
1247 SHOW CREATE TABLE t1;
1248 Table Create Table
1249 t1 CREATE TABLE `t1` (
1250 `c1` char(30) NOT NULL,
1251 UNIQUE KEY `i1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
1264 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1265 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1266 SHOW TABLES;
1267 Tables_in_test
1268 t1
1269 SHOW CREATE TABLE t1;
1270 Table Create Table
1271 t1 CREATE TABLE `t1` (
1272 `c1` varchar(30) NOT NULL,
1273 UNIQUE KEY `i1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
1286 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1287 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1288 SHOW TABLES;
1289 Tables_in_test
1290 t1
1291 SHOW CREATE TABLE t1;
1292 Table Create Table
1293 t1 CREATE TABLE `t1` (
1294 `c1` binary(30) NOT NULL,
1295 UNIQUE KEY `i1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
1308 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1309 ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1);
1310 SHOW TABLES;
1311 Tables_in_test
1312 t1
1313 SHOW CREATE TABLE t1;
1314 Table Create Table
1315 t1 CREATE TABLE `t1` (
1316 `c1` varbinary(30) NOT NULL,
1317 UNIQUE KEY `i1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
1330 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1331 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1332 SHOW TABLES;
1333 Tables_in_test
1334 t1
1335 SHOW CREATE TABLE t1;
1336 Table Create Table
1337 t1 CREATE TABLE `t1` (
1338 `c1` char(30) NOT NULL,
1339 UNIQUE KEY `i1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
1352 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1353 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1354 SHOW TABLES;
1355 Tables_in_test
1356 t1
1357 SHOW CREATE TABLE t1;
1358 Table Create Table
1359 t1 CREATE TABLE `t1` (
1360 `c1` varchar(30) NOT NULL,
1361 UNIQUE KEY `i1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
1374 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1375 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1376 SHOW TABLES;
1377 Tables_in_test
1378 t1
1379 SHOW CREATE TABLE t1;
1380 Table Create Table
1381 t1 CREATE TABLE `t1` (
1382 `c1` binary(30) NOT NULL,
1383 UNIQUE KEY `i1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
1396 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1397 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1);
1398 SHOW TABLES;
1399 Tables_in_test
1400 t1
1401 SHOW CREATE TABLE t1;
1402 Table Create Table
1403 t1 CREATE TABLE `t1` (
1404 `c1` varbinary(30) NOT NULL,
1405 UNIQUE KEY `i1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
1418 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1419 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
1420 SHOW TABLES;
1421 Tables_in_test
1422 t1
1423 SHOW CREATE TABLE t1;
1424 Table Create Table
1425 t1 CREATE TABLE `t1` (
1426 `c1` char(30) NOT NULL,
1427 UNIQUE KEY `i1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
1440 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1441 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
1442 SHOW TABLES;
1443 Tables_in_test
1444 t1
1445 SHOW CREATE TABLE t1;
1446 Table Create Table
1447 t1 CREATE TABLE `t1` (
1448 `c1` varchar(30) NOT NULL,
1449 UNIQUE KEY `i1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
1462 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1463 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
1464 SHOW TABLES;
1465 Tables_in_test
1466 t1
1467 SHOW CREATE TABLE t1;
1468 Table Create Table
1469 t1 CREATE TABLE `t1` (
1470 `c1` binary(30) NOT NULL,
1471 UNIQUE KEY `i1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
1484 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1485 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1);
1486 SHOW TABLES;
1487 Tables_in_test
1488 t1
1489 SHOW CREATE TABLE t1;
1490 Table Create Table
1491 t1 CREATE TABLE `t1` (
1492 `c1` varbinary(30) NOT NULL,
1493 UNIQUE KEY `i1` (`c1`)
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 CHAR(30) NOT NULL);
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` char(30) NOT NULL
1506 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1507 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
1508 SHOW TABLES;
1509 Tables_in_test
1510 t1
1511 SHOW CREATE TABLE t1;
1512 Table Create Table
1513 t1 CREATE TABLE `t1` (
1514 `c1` char(30) NOT NULL,
1515 UNIQUE KEY `i1` (`c1`)
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 VARCHAR(30) NOT NULL);
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` varchar(30) NOT NULL
1528 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1529 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
1530 SHOW TABLES;
1531 Tables_in_test
1532 t1
1533 SHOW CREATE TABLE t1;
1534 Table Create Table
1535 t1 CREATE TABLE `t1` (
1536 `c1` varchar(30) NOT NULL,
1537 UNIQUE KEY `i1` (`c1`)
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 BINARY(30) NOT NULL);
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` binary(30) NOT NULL
1550 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1551 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
1552 SHOW TABLES;
1553 Tables_in_test
1554 t1
1555 SHOW CREATE TABLE t1;
1556 Table Create Table
1557 t1 CREATE TABLE `t1` (
1558 `c1` binary(30) NOT NULL,
1559 UNIQUE KEY `i1` (`c1`)
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 VARBINARY(30) NOT NULL);
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` varbinary(30) NOT NULL
1572 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1573 ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1);
1574 SHOW TABLES;
1575 Tables_in_test
1576 t1
1577 SHOW CREATE TABLE t1;
1578 Table Create Table
1579 t1 CREATE TABLE `t1` (
1580 `c1` varbinary(30) NOT NULL,
1581 UNIQUE KEY `i1` (`c1`)
1582 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1583 DROP TABLE t1;
1584 SHOW TABLES;
1585 Tables_in_test