1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
11
`c3` int(11) DEFAULT NULL,
12
`c4` varchar(10) NOT NULL
13
) ENGINE=ENGINE DEFAULT CHARSET=latin1
14
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
20
t1 CREATE TABLE `t1` (
23
`c3` int(11) DEFAULT NULL,
24
`c4` varchar(10) NOT NULL,
25
PRIMARY KEY (`c1`,`c2`)
26
) ENGINE=ENGINE DEFAULT CHARSET=latin1
30
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
36
t1 CREATE TABLE `t1` (
37
`c1` tinyint(4) NOT NULL,
39
`c3` int(11) DEFAULT NULL,
40
`c4` varchar(10) NOT NULL
41
) ENGINE=ENGINE DEFAULT CHARSET=latin1
42
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
48
t1 CREATE TABLE `t1` (
49
`c1` tinyint(4) NOT NULL,
51
`c3` int(11) DEFAULT NULL,
52
`c4` varchar(10) NOT NULL,
53
PRIMARY KEY (`c1`,`c2`)
54
) ENGINE=ENGINE DEFAULT CHARSET=latin1
58
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
64
t1 CREATE TABLE `t1` (
65
`c1` smallint(6) NOT NULL,
67
`c3` int(11) DEFAULT NULL,
68
`c4` varchar(10) NOT NULL
69
) ENGINE=ENGINE DEFAULT CHARSET=latin1
70
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
76
t1 CREATE TABLE `t1` (
77
`c1` smallint(6) NOT NULL,
79
`c3` int(11) DEFAULT NULL,
80
`c4` varchar(10) NOT NULL,
81
PRIMARY KEY (`c1`,`c2`)
82
) ENGINE=ENGINE DEFAULT CHARSET=latin1
86
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
92
t1 CREATE TABLE `t1` (
93
`c1` mediumint(9) NOT NULL,
95
`c3` int(11) DEFAULT NULL,
96
`c4` varchar(10) NOT NULL
97
) ENGINE=ENGINE DEFAULT CHARSET=latin1
98
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
102
SHOW CREATE TABLE t1;
104
t1 CREATE TABLE `t1` (
105
`c1` mediumint(9) NOT NULL,
106
`c2` bit(1) NOT NULL,
107
`c3` int(11) DEFAULT NULL,
108
`c4` varchar(10) NOT NULL,
109
PRIMARY KEY (`c1`,`c2`)
110
) ENGINE=ENGINE DEFAULT CHARSET=latin1
114
CREATE TABLE t1(c1 INT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
118
SHOW CREATE TABLE t1;
120
t1 CREATE TABLE `t1` (
121
`c1` int(11) NOT NULL,
122
`c2` bit(1) NOT NULL,
123
`c3` int(11) DEFAULT NULL,
124
`c4` varchar(10) NOT NULL
125
) ENGINE=ENGINE DEFAULT CHARSET=latin1
126
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
130
SHOW CREATE TABLE t1;
132
t1 CREATE TABLE `t1` (
133
`c1` int(11) NOT NULL,
134
`c2` bit(1) NOT NULL,
135
`c3` int(11) DEFAULT NULL,
136
`c4` varchar(10) NOT NULL,
137
PRIMARY KEY (`c1`,`c2`)
138
) ENGINE=ENGINE DEFAULT CHARSET=latin1
142
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
146
SHOW CREATE TABLE t1;
148
t1 CREATE TABLE `t1` (
149
`c1` int(11) NOT NULL,
150
`c2` bit(1) NOT NULL,
151
`c3` int(11) DEFAULT NULL,
152
`c4` varchar(10) NOT NULL
153
) ENGINE=ENGINE DEFAULT CHARSET=latin1
154
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
158
SHOW CREATE TABLE t1;
160
t1 CREATE TABLE `t1` (
161
`c1` int(11) NOT NULL,
162
`c2` bit(1) NOT NULL,
163
`c3` int(11) DEFAULT NULL,
164
`c4` varchar(10) NOT NULL,
165
PRIMARY KEY (`c1`,`c2`)
166
) ENGINE=ENGINE DEFAULT CHARSET=latin1
170
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
174
SHOW CREATE TABLE t1;
176
t1 CREATE TABLE `t1` (
177
`c1` bigint(20) NOT NULL,
178
`c2` bit(1) NOT NULL,
179
`c3` int(11) DEFAULT NULL,
180
`c4` varchar(10) NOT NULL
181
) ENGINE=ENGINE DEFAULT CHARSET=latin1
182
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
186
SHOW CREATE TABLE t1;
188
t1 CREATE TABLE `t1` (
189
`c1` bigint(20) NOT NULL,
190
`c2` bit(1) NOT NULL,
191
`c3` int(11) DEFAULT NULL,
192
`c4` varchar(10) NOT NULL,
193
PRIMARY KEY (`c1`,`c2`)
194
) ENGINE=ENGINE DEFAULT CHARSET=latin1
198
CREATE TABLE t1(c1 REAL NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
202
SHOW CREATE TABLE t1;
204
t1 CREATE TABLE `t1` (
205
`c1` double NOT NULL,
206
`c2` bit(1) NOT NULL,
207
`c3` int(11) DEFAULT NULL,
208
`c4` varchar(10) NOT NULL
209
) ENGINE=ENGINE DEFAULT CHARSET=latin1
210
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
214
SHOW CREATE TABLE t1;
216
t1 CREATE TABLE `t1` (
217
`c1` double NOT NULL,
218
`c2` bit(1) NOT NULL,
219
`c3` int(11) DEFAULT NULL,
220
`c4` varchar(10) NOT NULL,
221
PRIMARY KEY (`c1`,`c2`)
222
) ENGINE=ENGINE DEFAULT CHARSET=latin1
226
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
230
SHOW CREATE TABLE t1;
232
t1 CREATE TABLE `t1` (
233
`c1` double NOT NULL,
234
`c2` bit(1) NOT NULL,
235
`c3` int(11) DEFAULT NULL,
236
`c4` varchar(10) NOT NULL
237
) ENGINE=ENGINE DEFAULT CHARSET=latin1
238
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
242
SHOW CREATE TABLE t1;
244
t1 CREATE TABLE `t1` (
245
`c1` double NOT NULL,
246
`c2` bit(1) NOT NULL,
247
`c3` int(11) DEFAULT NULL,
248
`c4` varchar(10) NOT NULL,
249
PRIMARY KEY (`c1`,`c2`)
250
) ENGINE=ENGINE DEFAULT CHARSET=latin1
254
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
258
SHOW CREATE TABLE t1;
260
t1 CREATE TABLE `t1` (
262
`c2` bit(1) NOT NULL,
263
`c3` int(11) DEFAULT NULL,
264
`c4` varchar(10) NOT NULL
265
) ENGINE=ENGINE DEFAULT CHARSET=latin1
266
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
270
SHOW CREATE TABLE t1;
272
t1 CREATE TABLE `t1` (
274
`c2` bit(1) NOT NULL,
275
`c3` int(11) DEFAULT NULL,
276
`c4` varchar(10) NOT NULL,
277
PRIMARY KEY (`c1`,`c2`)
278
) ENGINE=ENGINE DEFAULT CHARSET=latin1
282
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
286
SHOW CREATE TABLE t1;
288
t1 CREATE TABLE `t1` (
289
`c1` decimal(10,0) NOT NULL,
290
`c2` bit(1) NOT NULL,
291
`c3` int(11) DEFAULT NULL,
292
`c4` varchar(10) NOT NULL
293
) ENGINE=ENGINE DEFAULT CHARSET=latin1
294
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
298
SHOW CREATE TABLE t1;
300
t1 CREATE TABLE `t1` (
301
`c1` decimal(10,0) NOT NULL,
302
`c2` bit(1) NOT NULL,
303
`c3` int(11) DEFAULT NULL,
304
`c4` varchar(10) NOT NULL,
305
PRIMARY KEY (`c1`,`c2`)
306
) ENGINE=ENGINE DEFAULT CHARSET=latin1
310
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
314
SHOW CREATE TABLE t1;
316
t1 CREATE TABLE `t1` (
317
`c1` decimal(10,0) NOT NULL,
318
`c2` bit(1) NOT NULL,
319
`c3` int(11) DEFAULT NULL,
320
`c4` varchar(10) NOT NULL
321
) ENGINE=ENGINE DEFAULT CHARSET=latin1
322
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
326
SHOW CREATE TABLE t1;
328
t1 CREATE TABLE `t1` (
329
`c1` decimal(10,0) NOT NULL,
330
`c2` bit(1) NOT NULL,
331
`c3` int(11) DEFAULT NULL,
332
`c4` varchar(10) NOT NULL,
333
PRIMARY KEY (`c1`,`c2`)
334
) ENGINE=ENGINE DEFAULT CHARSET=latin1
338
CREATE TABLE t1(c1 DATE NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
342
SHOW CREATE TABLE t1;
344
t1 CREATE TABLE `t1` (
346
`c2` bit(1) NOT NULL,
347
`c3` int(11) DEFAULT NULL,
348
`c4` varchar(10) NOT NULL
349
) ENGINE=ENGINE DEFAULT CHARSET=latin1
350
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
354
SHOW CREATE TABLE t1;
356
t1 CREATE TABLE `t1` (
358
`c2` bit(1) NOT NULL,
359
`c3` int(11) DEFAULT NULL,
360
`c4` varchar(10) NOT NULL,
361
PRIMARY KEY (`c1`,`c2`)
362
) ENGINE=ENGINE DEFAULT CHARSET=latin1
366
CREATE TABLE t1(c1 TIME NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
370
SHOW CREATE TABLE t1;
372
t1 CREATE TABLE `t1` (
374
`c2` bit(1) NOT NULL,
375
`c3` int(11) DEFAULT NULL,
376
`c4` varchar(10) NOT NULL
377
) ENGINE=ENGINE DEFAULT CHARSET=latin1
378
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
382
SHOW CREATE TABLE t1;
384
t1 CREATE TABLE `t1` (
386
`c2` bit(1) NOT NULL,
387
`c3` int(11) DEFAULT NULL,
388
`c4` varchar(10) NOT NULL,
389
PRIMARY KEY (`c1`,`c2`)
390
) ENGINE=ENGINE DEFAULT CHARSET=latin1
394
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
398
SHOW CREATE TABLE t1;
400
t1 CREATE TABLE `t1` (
401
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
402
`c2` bit(1) NOT NULL,
403
`c3` int(11) DEFAULT NULL,
404
`c4` varchar(10) NOT NULL
405
) ENGINE=ENGINE DEFAULT CHARSET=latin1
406
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
410
SHOW CREATE TABLE t1;
412
t1 CREATE TABLE `t1` (
413
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
414
`c2` bit(1) NOT NULL,
415
`c3` int(11) DEFAULT NULL,
416
`c4` varchar(10) NOT NULL,
417
PRIMARY KEY (`c1`,`c2`)
418
) ENGINE=ENGINE DEFAULT CHARSET=latin1
422
CREATE TABLE t1(c1 YEAR NOT NULL, c2 BIT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
426
SHOW CREATE TABLE t1;
428
t1 CREATE TABLE `t1` (
429
`c1` year(4) NOT NULL,
430
`c2` bit(1) NOT NULL,
431
`c3` int(11) DEFAULT NULL,
432
`c4` varchar(10) NOT NULL
433
) ENGINE=ENGINE DEFAULT CHARSET=latin1
434
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
438
SHOW CREATE TABLE t1;
440
t1 CREATE TABLE `t1` (
441
`c1` year(4) NOT NULL,
442
`c2` bit(1) NOT NULL,
443
`c3` int(11) DEFAULT NULL,
444
`c4` varchar(10) NOT NULL,
445
PRIMARY KEY (`c1`,`c2`)
446
) ENGINE=ENGINE DEFAULT CHARSET=latin1
450
CREATE TABLE t1(c1 BIT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
454
SHOW CREATE TABLE t1;
456
t1 CREATE TABLE `t1` (
457
`c1` bit(1) NOT NULL,
458
`c2` tinyint(4) NOT NULL,
459
`c3` int(11) DEFAULT NULL,
460
`c4` varchar(10) NOT NULL
461
) ENGINE=ENGINE DEFAULT CHARSET=latin1
462
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
466
SHOW CREATE TABLE t1;
468
t1 CREATE TABLE `t1` (
469
`c1` bit(1) NOT NULL,
470
`c2` tinyint(4) NOT NULL,
471
`c3` int(11) DEFAULT NULL,
472
`c4` varchar(10) NOT NULL,
473
PRIMARY KEY (`c1`,`c2`)
474
) ENGINE=ENGINE DEFAULT CHARSET=latin1
478
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
482
SHOW CREATE TABLE t1;
484
t1 CREATE TABLE `t1` (
485
`c1` tinyint(4) NOT NULL,
486
`c2` tinyint(4) NOT NULL,
487
`c3` int(11) DEFAULT NULL,
488
`c4` varchar(10) NOT NULL
489
) ENGINE=ENGINE DEFAULT CHARSET=latin1
490
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
494
SHOW CREATE TABLE t1;
496
t1 CREATE TABLE `t1` (
497
`c1` tinyint(4) NOT NULL,
498
`c2` tinyint(4) NOT NULL,
499
`c3` int(11) DEFAULT NULL,
500
`c4` varchar(10) NOT NULL,
501
PRIMARY KEY (`c1`,`c2`)
502
) ENGINE=ENGINE DEFAULT CHARSET=latin1
506
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
510
SHOW CREATE TABLE t1;
512
t1 CREATE TABLE `t1` (
513
`c1` smallint(6) NOT NULL,
514
`c2` tinyint(4) NOT NULL,
515
`c3` int(11) DEFAULT NULL,
516
`c4` varchar(10) NOT NULL
517
) ENGINE=ENGINE DEFAULT CHARSET=latin1
518
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
522
SHOW CREATE TABLE t1;
524
t1 CREATE TABLE `t1` (
525
`c1` smallint(6) NOT NULL,
526
`c2` tinyint(4) NOT NULL,
527
`c3` int(11) DEFAULT NULL,
528
`c4` varchar(10) NOT NULL,
529
PRIMARY KEY (`c1`,`c2`)
530
) ENGINE=ENGINE DEFAULT CHARSET=latin1
534
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
538
SHOW CREATE TABLE t1;
540
t1 CREATE TABLE `t1` (
541
`c1` mediumint(9) NOT NULL,
542
`c2` tinyint(4) NOT NULL,
543
`c3` int(11) DEFAULT NULL,
544
`c4` varchar(10) NOT NULL
545
) ENGINE=ENGINE DEFAULT CHARSET=latin1
546
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
550
SHOW CREATE TABLE t1;
552
t1 CREATE TABLE `t1` (
553
`c1` mediumint(9) NOT NULL,
554
`c2` tinyint(4) NOT NULL,
555
`c3` int(11) DEFAULT NULL,
556
`c4` varchar(10) NOT NULL,
557
PRIMARY KEY (`c1`,`c2`)
558
) ENGINE=ENGINE DEFAULT CHARSET=latin1
562
CREATE TABLE t1(c1 INT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
566
SHOW CREATE TABLE t1;
568
t1 CREATE TABLE `t1` (
569
`c1` int(11) NOT NULL,
570
`c2` tinyint(4) NOT NULL,
571
`c3` int(11) DEFAULT NULL,
572
`c4` varchar(10) NOT NULL
573
) ENGINE=ENGINE DEFAULT CHARSET=latin1
574
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
578
SHOW CREATE TABLE t1;
580
t1 CREATE TABLE `t1` (
581
`c1` int(11) NOT NULL,
582
`c2` tinyint(4) NOT NULL,
583
`c3` int(11) DEFAULT NULL,
584
`c4` varchar(10) NOT NULL,
585
PRIMARY KEY (`c1`,`c2`)
586
) ENGINE=ENGINE DEFAULT CHARSET=latin1
590
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
594
SHOW CREATE TABLE t1;
596
t1 CREATE TABLE `t1` (
597
`c1` int(11) NOT NULL,
598
`c2` tinyint(4) NOT NULL,
599
`c3` int(11) DEFAULT NULL,
600
`c4` varchar(10) NOT NULL
601
) ENGINE=ENGINE DEFAULT CHARSET=latin1
602
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
606
SHOW CREATE TABLE t1;
608
t1 CREATE TABLE `t1` (
609
`c1` int(11) NOT NULL,
610
`c2` tinyint(4) NOT NULL,
611
`c3` int(11) DEFAULT NULL,
612
`c4` varchar(10) NOT NULL,
613
PRIMARY KEY (`c1`,`c2`)
614
) ENGINE=ENGINE DEFAULT CHARSET=latin1
618
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
622
SHOW CREATE TABLE t1;
624
t1 CREATE TABLE `t1` (
625
`c1` bigint(20) NOT NULL,
626
`c2` tinyint(4) NOT NULL,
627
`c3` int(11) DEFAULT NULL,
628
`c4` varchar(10) NOT NULL
629
) ENGINE=ENGINE DEFAULT CHARSET=latin1
630
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
634
SHOW CREATE TABLE t1;
636
t1 CREATE TABLE `t1` (
637
`c1` bigint(20) NOT NULL,
638
`c2` tinyint(4) NOT NULL,
639
`c3` int(11) DEFAULT NULL,
640
`c4` varchar(10) NOT NULL,
641
PRIMARY KEY (`c1`,`c2`)
642
) ENGINE=ENGINE DEFAULT CHARSET=latin1
646
CREATE TABLE t1(c1 REAL NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
650
SHOW CREATE TABLE t1;
652
t1 CREATE TABLE `t1` (
653
`c1` double NOT NULL,
654
`c2` tinyint(4) NOT NULL,
655
`c3` int(11) DEFAULT NULL,
656
`c4` varchar(10) NOT NULL
657
) ENGINE=ENGINE DEFAULT CHARSET=latin1
658
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
662
SHOW CREATE TABLE t1;
664
t1 CREATE TABLE `t1` (
665
`c1` double NOT NULL,
666
`c2` tinyint(4) NOT NULL,
667
`c3` int(11) DEFAULT NULL,
668
`c4` varchar(10) NOT NULL,
669
PRIMARY KEY (`c1`,`c2`)
670
) ENGINE=ENGINE DEFAULT CHARSET=latin1
674
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
678
SHOW CREATE TABLE t1;
680
t1 CREATE TABLE `t1` (
681
`c1` double NOT NULL,
682
`c2` tinyint(4) NOT NULL,
683
`c3` int(11) DEFAULT NULL,
684
`c4` varchar(10) NOT NULL
685
) ENGINE=ENGINE DEFAULT CHARSET=latin1
686
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
690
SHOW CREATE TABLE t1;
692
t1 CREATE TABLE `t1` (
693
`c1` double NOT NULL,
694
`c2` tinyint(4) NOT NULL,
695
`c3` int(11) DEFAULT NULL,
696
`c4` varchar(10) NOT NULL,
697
PRIMARY KEY (`c1`,`c2`)
698
) ENGINE=ENGINE DEFAULT CHARSET=latin1
702
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
706
SHOW CREATE TABLE t1;
708
t1 CREATE TABLE `t1` (
710
`c2` tinyint(4) NOT NULL,
711
`c3` int(11) DEFAULT NULL,
712
`c4` varchar(10) NOT NULL
713
) ENGINE=ENGINE DEFAULT CHARSET=latin1
714
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
718
SHOW CREATE TABLE t1;
720
t1 CREATE TABLE `t1` (
722
`c2` tinyint(4) NOT NULL,
723
`c3` int(11) DEFAULT NULL,
724
`c4` varchar(10) NOT NULL,
725
PRIMARY KEY (`c1`,`c2`)
726
) ENGINE=ENGINE DEFAULT CHARSET=latin1
730
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
734
SHOW CREATE TABLE t1;
736
t1 CREATE TABLE `t1` (
737
`c1` decimal(10,0) NOT NULL,
738
`c2` tinyint(4) NOT NULL,
739
`c3` int(11) DEFAULT NULL,
740
`c4` varchar(10) NOT NULL
741
) ENGINE=ENGINE DEFAULT CHARSET=latin1
742
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
746
SHOW CREATE TABLE t1;
748
t1 CREATE TABLE `t1` (
749
`c1` decimal(10,0) NOT NULL,
750
`c2` tinyint(4) NOT NULL,
751
`c3` int(11) DEFAULT NULL,
752
`c4` varchar(10) NOT NULL,
753
PRIMARY KEY (`c1`,`c2`)
754
) ENGINE=ENGINE DEFAULT CHARSET=latin1
758
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
762
SHOW CREATE TABLE t1;
764
t1 CREATE TABLE `t1` (
765
`c1` decimal(10,0) NOT NULL,
766
`c2` tinyint(4) NOT NULL,
767
`c3` int(11) DEFAULT NULL,
768
`c4` varchar(10) NOT NULL
769
) ENGINE=ENGINE DEFAULT CHARSET=latin1
770
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
774
SHOW CREATE TABLE t1;
776
t1 CREATE TABLE `t1` (
777
`c1` decimal(10,0) NOT NULL,
778
`c2` tinyint(4) NOT NULL,
779
`c3` int(11) DEFAULT NULL,
780
`c4` varchar(10) NOT NULL,
781
PRIMARY KEY (`c1`,`c2`)
782
) ENGINE=ENGINE DEFAULT CHARSET=latin1
786
CREATE TABLE t1(c1 DATE NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
790
SHOW CREATE TABLE t1;
792
t1 CREATE TABLE `t1` (
794
`c2` tinyint(4) NOT NULL,
795
`c3` int(11) DEFAULT NULL,
796
`c4` varchar(10) NOT NULL
797
) ENGINE=ENGINE DEFAULT CHARSET=latin1
798
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
802
SHOW CREATE TABLE t1;
804
t1 CREATE TABLE `t1` (
806
`c2` tinyint(4) NOT NULL,
807
`c3` int(11) DEFAULT NULL,
808
`c4` varchar(10) NOT NULL,
809
PRIMARY KEY (`c1`,`c2`)
810
) ENGINE=ENGINE DEFAULT CHARSET=latin1
814
CREATE TABLE t1(c1 TIME NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
818
SHOW CREATE TABLE t1;
820
t1 CREATE TABLE `t1` (
822
`c2` tinyint(4) NOT NULL,
823
`c3` int(11) DEFAULT NULL,
824
`c4` varchar(10) NOT NULL
825
) ENGINE=ENGINE DEFAULT CHARSET=latin1
826
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
830
SHOW CREATE TABLE t1;
832
t1 CREATE TABLE `t1` (
834
`c2` tinyint(4) NOT NULL,
835
`c3` int(11) DEFAULT NULL,
836
`c4` varchar(10) NOT NULL,
837
PRIMARY KEY (`c1`,`c2`)
838
) ENGINE=ENGINE DEFAULT CHARSET=latin1
842
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
846
SHOW CREATE TABLE t1;
848
t1 CREATE TABLE `t1` (
849
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
850
`c2` tinyint(4) NOT NULL,
851
`c3` int(11) DEFAULT NULL,
852
`c4` varchar(10) NOT NULL
853
) ENGINE=ENGINE DEFAULT CHARSET=latin1
854
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
858
SHOW CREATE TABLE t1;
860
t1 CREATE TABLE `t1` (
861
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
862
`c2` tinyint(4) NOT NULL,
863
`c3` int(11) DEFAULT NULL,
864
`c4` varchar(10) NOT NULL,
865
PRIMARY KEY (`c1`,`c2`)
866
) ENGINE=ENGINE DEFAULT CHARSET=latin1
870
CREATE TABLE t1(c1 YEAR NOT NULL, c2 TINYINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
874
SHOW CREATE TABLE t1;
876
t1 CREATE TABLE `t1` (
877
`c1` year(4) NOT NULL,
878
`c2` tinyint(4) NOT NULL,
879
`c3` int(11) DEFAULT NULL,
880
`c4` varchar(10) NOT NULL
881
) ENGINE=ENGINE DEFAULT CHARSET=latin1
882
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
886
SHOW CREATE TABLE t1;
888
t1 CREATE TABLE `t1` (
889
`c1` year(4) NOT NULL,
890
`c2` tinyint(4) NOT NULL,
891
`c3` int(11) DEFAULT NULL,
892
`c4` varchar(10) NOT NULL,
893
PRIMARY KEY (`c1`,`c2`)
894
) ENGINE=ENGINE DEFAULT CHARSET=latin1
898
CREATE TABLE t1(c1 BIT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
902
SHOW CREATE TABLE t1;
904
t1 CREATE TABLE `t1` (
905
`c1` bit(1) NOT NULL,
906
`c2` smallint(6) NOT NULL,
907
`c3` int(11) DEFAULT NULL,
908
`c4` varchar(10) NOT NULL
909
) ENGINE=ENGINE DEFAULT CHARSET=latin1
910
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
914
SHOW CREATE TABLE t1;
916
t1 CREATE TABLE `t1` (
917
`c1` bit(1) NOT NULL,
918
`c2` smallint(6) NOT NULL,
919
`c3` int(11) DEFAULT NULL,
920
`c4` varchar(10) NOT NULL,
921
PRIMARY KEY (`c1`,`c2`)
922
) ENGINE=ENGINE DEFAULT CHARSET=latin1
926
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
930
SHOW CREATE TABLE t1;
932
t1 CREATE TABLE `t1` (
933
`c1` tinyint(4) NOT NULL,
934
`c2` smallint(6) NOT NULL,
935
`c3` int(11) DEFAULT NULL,
936
`c4` varchar(10) NOT NULL
937
) ENGINE=ENGINE DEFAULT CHARSET=latin1
938
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
942
SHOW CREATE TABLE t1;
944
t1 CREATE TABLE `t1` (
945
`c1` tinyint(4) NOT NULL,
946
`c2` smallint(6) NOT NULL,
947
`c3` int(11) DEFAULT NULL,
948
`c4` varchar(10) NOT NULL,
949
PRIMARY KEY (`c1`,`c2`)
950
) ENGINE=ENGINE DEFAULT CHARSET=latin1
954
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
958
SHOW CREATE TABLE t1;
960
t1 CREATE TABLE `t1` (
961
`c1` smallint(6) NOT NULL,
962
`c2` smallint(6) NOT NULL,
963
`c3` int(11) DEFAULT NULL,
964
`c4` varchar(10) NOT NULL
965
) ENGINE=ENGINE DEFAULT CHARSET=latin1
966
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
970
SHOW CREATE TABLE t1;
972
t1 CREATE TABLE `t1` (
973
`c1` smallint(6) NOT NULL,
974
`c2` smallint(6) NOT NULL,
975
`c3` int(11) DEFAULT NULL,
976
`c4` varchar(10) NOT NULL,
977
PRIMARY KEY (`c1`,`c2`)
978
) ENGINE=ENGINE DEFAULT CHARSET=latin1
982
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
986
SHOW CREATE TABLE t1;
988
t1 CREATE TABLE `t1` (
989
`c1` mediumint(9) NOT NULL,
990
`c2` smallint(6) NOT NULL,
991
`c3` int(11) DEFAULT NULL,
992
`c4` varchar(10) NOT NULL
993
) ENGINE=ENGINE DEFAULT CHARSET=latin1
994
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
998
SHOW CREATE TABLE t1;
1000
t1 CREATE TABLE `t1` (
1001
`c1` mediumint(9) NOT NULL,
1002
`c2` smallint(6) NOT NULL,
1003
`c3` int(11) DEFAULT NULL,
1004
`c4` varchar(10) NOT NULL,
1005
PRIMARY KEY (`c1`,`c2`)
1006
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1010
CREATE TABLE t1(c1 INT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1014
SHOW CREATE TABLE t1;
1016
t1 CREATE TABLE `t1` (
1017
`c1` int(11) NOT NULL,
1018
`c2` smallint(6) NOT NULL,
1019
`c3` int(11) DEFAULT NULL,
1020
`c4` varchar(10) NOT NULL
1021
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1022
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1026
SHOW CREATE TABLE t1;
1028
t1 CREATE TABLE `t1` (
1029
`c1` int(11) NOT NULL,
1030
`c2` smallint(6) NOT NULL,
1031
`c3` int(11) DEFAULT NULL,
1032
`c4` varchar(10) NOT NULL,
1033
PRIMARY KEY (`c1`,`c2`)
1034
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1038
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1042
SHOW CREATE TABLE t1;
1044
t1 CREATE TABLE `t1` (
1045
`c1` int(11) NOT NULL,
1046
`c2` smallint(6) NOT NULL,
1047
`c3` int(11) DEFAULT NULL,
1048
`c4` varchar(10) NOT NULL
1049
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1050
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1054
SHOW CREATE TABLE t1;
1056
t1 CREATE TABLE `t1` (
1057
`c1` int(11) NOT NULL,
1058
`c2` smallint(6) NOT NULL,
1059
`c3` int(11) DEFAULT NULL,
1060
`c4` varchar(10) NOT NULL,
1061
PRIMARY KEY (`c1`,`c2`)
1062
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1066
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1070
SHOW CREATE TABLE t1;
1072
t1 CREATE TABLE `t1` (
1073
`c1` bigint(20) NOT NULL,
1074
`c2` smallint(6) NOT NULL,
1075
`c3` int(11) DEFAULT NULL,
1076
`c4` varchar(10) NOT NULL
1077
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1078
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1082
SHOW CREATE TABLE t1;
1084
t1 CREATE TABLE `t1` (
1085
`c1` bigint(20) NOT NULL,
1086
`c2` smallint(6) NOT NULL,
1087
`c3` int(11) DEFAULT NULL,
1088
`c4` varchar(10) NOT NULL,
1089
PRIMARY KEY (`c1`,`c2`)
1090
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1094
CREATE TABLE t1(c1 REAL NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1098
SHOW CREATE TABLE t1;
1100
t1 CREATE TABLE `t1` (
1101
`c1` double NOT NULL,
1102
`c2` smallint(6) NOT NULL,
1103
`c3` int(11) DEFAULT NULL,
1104
`c4` varchar(10) NOT NULL
1105
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1106
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1110
SHOW CREATE TABLE t1;
1112
t1 CREATE TABLE `t1` (
1113
`c1` double NOT NULL,
1114
`c2` smallint(6) NOT NULL,
1115
`c3` int(11) DEFAULT NULL,
1116
`c4` varchar(10) NOT NULL,
1117
PRIMARY KEY (`c1`,`c2`)
1118
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1122
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1126
SHOW CREATE TABLE t1;
1128
t1 CREATE TABLE `t1` (
1129
`c1` double NOT NULL,
1130
`c2` smallint(6) NOT NULL,
1131
`c3` int(11) DEFAULT NULL,
1132
`c4` varchar(10) NOT NULL
1133
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1134
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1138
SHOW CREATE TABLE t1;
1140
t1 CREATE TABLE `t1` (
1141
`c1` double NOT NULL,
1142
`c2` smallint(6) NOT NULL,
1143
`c3` int(11) DEFAULT NULL,
1144
`c4` varchar(10) NOT NULL,
1145
PRIMARY KEY (`c1`,`c2`)
1146
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1150
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1154
SHOW CREATE TABLE t1;
1156
t1 CREATE TABLE `t1` (
1157
`c1` float NOT NULL,
1158
`c2` smallint(6) NOT NULL,
1159
`c3` int(11) DEFAULT NULL,
1160
`c4` varchar(10) NOT NULL
1161
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1162
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1166
SHOW CREATE TABLE t1;
1168
t1 CREATE TABLE `t1` (
1169
`c1` float NOT NULL,
1170
`c2` smallint(6) NOT NULL,
1171
`c3` int(11) DEFAULT NULL,
1172
`c4` varchar(10) NOT NULL,
1173
PRIMARY KEY (`c1`,`c2`)
1174
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1178
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1182
SHOW CREATE TABLE t1;
1184
t1 CREATE TABLE `t1` (
1185
`c1` decimal(10,0) NOT NULL,
1186
`c2` smallint(6) NOT NULL,
1187
`c3` int(11) DEFAULT NULL,
1188
`c4` varchar(10) NOT NULL
1189
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1190
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1194
SHOW CREATE TABLE t1;
1196
t1 CREATE TABLE `t1` (
1197
`c1` decimal(10,0) NOT NULL,
1198
`c2` smallint(6) NOT NULL,
1199
`c3` int(11) DEFAULT NULL,
1200
`c4` varchar(10) NOT NULL,
1201
PRIMARY KEY (`c1`,`c2`)
1202
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1206
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1210
SHOW CREATE TABLE t1;
1212
t1 CREATE TABLE `t1` (
1213
`c1` decimal(10,0) NOT NULL,
1214
`c2` smallint(6) NOT NULL,
1215
`c3` int(11) DEFAULT NULL,
1216
`c4` varchar(10) NOT NULL
1217
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1218
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1222
SHOW CREATE TABLE t1;
1224
t1 CREATE TABLE `t1` (
1225
`c1` decimal(10,0) NOT NULL,
1226
`c2` smallint(6) NOT NULL,
1227
`c3` int(11) DEFAULT NULL,
1228
`c4` varchar(10) NOT NULL,
1229
PRIMARY KEY (`c1`,`c2`)
1230
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1234
CREATE TABLE t1(c1 DATE NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1238
SHOW CREATE TABLE t1;
1240
t1 CREATE TABLE `t1` (
1242
`c2` smallint(6) NOT NULL,
1243
`c3` int(11) DEFAULT NULL,
1244
`c4` varchar(10) NOT NULL
1245
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1246
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1250
SHOW CREATE TABLE t1;
1252
t1 CREATE TABLE `t1` (
1254
`c2` smallint(6) NOT NULL,
1255
`c3` int(11) DEFAULT NULL,
1256
`c4` varchar(10) NOT NULL,
1257
PRIMARY KEY (`c1`,`c2`)
1258
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1262
CREATE TABLE t1(c1 TIME NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1266
SHOW CREATE TABLE t1;
1268
t1 CREATE TABLE `t1` (
1270
`c2` smallint(6) NOT NULL,
1271
`c3` int(11) DEFAULT NULL,
1272
`c4` varchar(10) NOT NULL
1273
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1274
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1278
SHOW CREATE TABLE t1;
1280
t1 CREATE TABLE `t1` (
1282
`c2` smallint(6) NOT NULL,
1283
`c3` int(11) DEFAULT NULL,
1284
`c4` varchar(10) NOT NULL,
1285
PRIMARY KEY (`c1`,`c2`)
1286
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1290
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1294
SHOW CREATE TABLE t1;
1296
t1 CREATE TABLE `t1` (
1297
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1298
`c2` smallint(6) NOT NULL,
1299
`c3` int(11) DEFAULT NULL,
1300
`c4` varchar(10) NOT NULL
1301
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1302
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1306
SHOW CREATE TABLE t1;
1308
t1 CREATE TABLE `t1` (
1309
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1310
`c2` smallint(6) NOT NULL,
1311
`c3` int(11) DEFAULT NULL,
1312
`c4` varchar(10) NOT NULL,
1313
PRIMARY KEY (`c1`,`c2`)
1314
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1318
CREATE TABLE t1(c1 YEAR NOT NULL, c2 SMALLINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1322
SHOW CREATE TABLE t1;
1324
t1 CREATE TABLE `t1` (
1325
`c1` year(4) NOT NULL,
1326
`c2` smallint(6) NOT NULL,
1327
`c3` int(11) DEFAULT NULL,
1328
`c4` varchar(10) NOT NULL
1329
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1330
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1334
SHOW CREATE TABLE t1;
1336
t1 CREATE TABLE `t1` (
1337
`c1` year(4) NOT NULL,
1338
`c2` smallint(6) NOT NULL,
1339
`c3` int(11) DEFAULT NULL,
1340
`c4` varchar(10) NOT NULL,
1341
PRIMARY KEY (`c1`,`c2`)
1342
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1346
CREATE TABLE t1(c1 BIT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1350
SHOW CREATE TABLE t1;
1352
t1 CREATE TABLE `t1` (
1353
`c1` bit(1) NOT NULL,
1354
`c2` mediumint(9) NOT NULL,
1355
`c3` int(11) DEFAULT NULL,
1356
`c4` varchar(10) NOT NULL
1357
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1358
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1362
SHOW CREATE TABLE t1;
1364
t1 CREATE TABLE `t1` (
1365
`c1` bit(1) NOT NULL,
1366
`c2` mediumint(9) NOT NULL,
1367
`c3` int(11) DEFAULT NULL,
1368
`c4` varchar(10) NOT NULL,
1369
PRIMARY KEY (`c1`,`c2`)
1370
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1374
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1378
SHOW CREATE TABLE t1;
1380
t1 CREATE TABLE `t1` (
1381
`c1` tinyint(4) NOT NULL,
1382
`c2` mediumint(9) NOT NULL,
1383
`c3` int(11) DEFAULT NULL,
1384
`c4` varchar(10) NOT NULL
1385
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1386
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1390
SHOW CREATE TABLE t1;
1392
t1 CREATE TABLE `t1` (
1393
`c1` tinyint(4) NOT NULL,
1394
`c2` mediumint(9) NOT NULL,
1395
`c3` int(11) DEFAULT NULL,
1396
`c4` varchar(10) NOT NULL,
1397
PRIMARY KEY (`c1`,`c2`)
1398
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1402
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1406
SHOW CREATE TABLE t1;
1408
t1 CREATE TABLE `t1` (
1409
`c1` smallint(6) NOT NULL,
1410
`c2` mediumint(9) NOT NULL,
1411
`c3` int(11) DEFAULT NULL,
1412
`c4` varchar(10) NOT NULL
1413
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1414
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1418
SHOW CREATE TABLE t1;
1420
t1 CREATE TABLE `t1` (
1421
`c1` smallint(6) NOT NULL,
1422
`c2` mediumint(9) NOT NULL,
1423
`c3` int(11) DEFAULT NULL,
1424
`c4` varchar(10) NOT NULL,
1425
PRIMARY KEY (`c1`,`c2`)
1426
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1430
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1434
SHOW CREATE TABLE t1;
1436
t1 CREATE TABLE `t1` (
1437
`c1` mediumint(9) NOT NULL,
1438
`c2` mediumint(9) NOT NULL,
1439
`c3` int(11) DEFAULT NULL,
1440
`c4` varchar(10) NOT NULL
1441
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1442
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1446
SHOW CREATE TABLE t1;
1448
t1 CREATE TABLE `t1` (
1449
`c1` mediumint(9) NOT NULL,
1450
`c2` mediumint(9) NOT NULL,
1451
`c3` int(11) DEFAULT NULL,
1452
`c4` varchar(10) NOT NULL,
1453
PRIMARY KEY (`c1`,`c2`)
1454
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1458
CREATE TABLE t1(c1 INT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1462
SHOW CREATE TABLE t1;
1464
t1 CREATE TABLE `t1` (
1465
`c1` int(11) NOT NULL,
1466
`c2` mediumint(9) NOT NULL,
1467
`c3` int(11) DEFAULT NULL,
1468
`c4` varchar(10) NOT NULL
1469
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1470
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1474
SHOW CREATE TABLE t1;
1476
t1 CREATE TABLE `t1` (
1477
`c1` int(11) NOT NULL,
1478
`c2` mediumint(9) NOT NULL,
1479
`c3` int(11) DEFAULT NULL,
1480
`c4` varchar(10) NOT NULL,
1481
PRIMARY KEY (`c1`,`c2`)
1482
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1486
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1490
SHOW CREATE TABLE t1;
1492
t1 CREATE TABLE `t1` (
1493
`c1` int(11) NOT NULL,
1494
`c2` mediumint(9) NOT NULL,
1495
`c3` int(11) DEFAULT NULL,
1496
`c4` varchar(10) NOT NULL
1497
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1498
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1502
SHOW CREATE TABLE t1;
1504
t1 CREATE TABLE `t1` (
1505
`c1` int(11) NOT NULL,
1506
`c2` mediumint(9) NOT NULL,
1507
`c3` int(11) DEFAULT NULL,
1508
`c4` varchar(10) NOT NULL,
1509
PRIMARY KEY (`c1`,`c2`)
1510
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1514
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1518
SHOW CREATE TABLE t1;
1520
t1 CREATE TABLE `t1` (
1521
`c1` bigint(20) NOT NULL,
1522
`c2` mediumint(9) NOT NULL,
1523
`c3` int(11) DEFAULT NULL,
1524
`c4` varchar(10) NOT NULL
1525
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1526
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1530
SHOW CREATE TABLE t1;
1532
t1 CREATE TABLE `t1` (
1533
`c1` bigint(20) NOT NULL,
1534
`c2` mediumint(9) NOT NULL,
1535
`c3` int(11) DEFAULT NULL,
1536
`c4` varchar(10) NOT NULL,
1537
PRIMARY KEY (`c1`,`c2`)
1538
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1542
CREATE TABLE t1(c1 REAL NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1546
SHOW CREATE TABLE t1;
1548
t1 CREATE TABLE `t1` (
1549
`c1` double NOT NULL,
1550
`c2` mediumint(9) NOT NULL,
1551
`c3` int(11) DEFAULT NULL,
1552
`c4` varchar(10) NOT NULL
1553
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1554
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1558
SHOW CREATE TABLE t1;
1560
t1 CREATE TABLE `t1` (
1561
`c1` double NOT NULL,
1562
`c2` mediumint(9) NOT NULL,
1563
`c3` int(11) DEFAULT NULL,
1564
`c4` varchar(10) NOT NULL,
1565
PRIMARY KEY (`c1`,`c2`)
1566
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1570
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1574
SHOW CREATE TABLE t1;
1576
t1 CREATE TABLE `t1` (
1577
`c1` double NOT NULL,
1578
`c2` mediumint(9) NOT NULL,
1579
`c3` int(11) DEFAULT NULL,
1580
`c4` varchar(10) NOT NULL
1581
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1582
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1586
SHOW CREATE TABLE t1;
1588
t1 CREATE TABLE `t1` (
1589
`c1` double NOT NULL,
1590
`c2` mediumint(9) NOT NULL,
1591
`c3` int(11) DEFAULT NULL,
1592
`c4` varchar(10) NOT NULL,
1593
PRIMARY KEY (`c1`,`c2`)
1594
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1598
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1602
SHOW CREATE TABLE t1;
1604
t1 CREATE TABLE `t1` (
1605
`c1` float NOT NULL,
1606
`c2` mediumint(9) NOT NULL,
1607
`c3` int(11) DEFAULT NULL,
1608
`c4` varchar(10) NOT NULL
1609
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1610
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1614
SHOW CREATE TABLE t1;
1616
t1 CREATE TABLE `t1` (
1617
`c1` float NOT NULL,
1618
`c2` mediumint(9) NOT NULL,
1619
`c3` int(11) DEFAULT NULL,
1620
`c4` varchar(10) NOT NULL,
1621
PRIMARY KEY (`c1`,`c2`)
1622
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1626
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1630
SHOW CREATE TABLE t1;
1632
t1 CREATE TABLE `t1` (
1633
`c1` decimal(10,0) NOT NULL,
1634
`c2` mediumint(9) NOT NULL,
1635
`c3` int(11) DEFAULT NULL,
1636
`c4` varchar(10) NOT NULL
1637
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1638
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1642
SHOW CREATE TABLE t1;
1644
t1 CREATE TABLE `t1` (
1645
`c1` decimal(10,0) NOT NULL,
1646
`c2` mediumint(9) NOT NULL,
1647
`c3` int(11) DEFAULT NULL,
1648
`c4` varchar(10) NOT NULL,
1649
PRIMARY KEY (`c1`,`c2`)
1650
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1654
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1658
SHOW CREATE TABLE t1;
1660
t1 CREATE TABLE `t1` (
1661
`c1` decimal(10,0) NOT NULL,
1662
`c2` mediumint(9) NOT NULL,
1663
`c3` int(11) DEFAULT NULL,
1664
`c4` varchar(10) NOT NULL
1665
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1666
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1670
SHOW CREATE TABLE t1;
1672
t1 CREATE TABLE `t1` (
1673
`c1` decimal(10,0) NOT NULL,
1674
`c2` mediumint(9) NOT NULL,
1675
`c3` int(11) DEFAULT NULL,
1676
`c4` varchar(10) NOT NULL,
1677
PRIMARY KEY (`c1`,`c2`)
1678
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1682
CREATE TABLE t1(c1 DATE NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1686
SHOW CREATE TABLE t1;
1688
t1 CREATE TABLE `t1` (
1690
`c2` mediumint(9) NOT NULL,
1691
`c3` int(11) DEFAULT NULL,
1692
`c4` varchar(10) NOT NULL
1693
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1694
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1698
SHOW CREATE TABLE t1;
1700
t1 CREATE TABLE `t1` (
1702
`c2` mediumint(9) NOT NULL,
1703
`c3` int(11) DEFAULT NULL,
1704
`c4` varchar(10) NOT NULL,
1705
PRIMARY KEY (`c1`,`c2`)
1706
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1710
CREATE TABLE t1(c1 TIME NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1714
SHOW CREATE TABLE t1;
1716
t1 CREATE TABLE `t1` (
1718
`c2` mediumint(9) NOT NULL,
1719
`c3` int(11) DEFAULT NULL,
1720
`c4` varchar(10) NOT NULL
1721
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1722
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1726
SHOW CREATE TABLE t1;
1728
t1 CREATE TABLE `t1` (
1730
`c2` mediumint(9) NOT NULL,
1731
`c3` int(11) DEFAULT NULL,
1732
`c4` varchar(10) NOT NULL,
1733
PRIMARY KEY (`c1`,`c2`)
1734
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1738
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1742
SHOW CREATE TABLE t1;
1744
t1 CREATE TABLE `t1` (
1745
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1746
`c2` mediumint(9) NOT NULL,
1747
`c3` int(11) DEFAULT NULL,
1748
`c4` varchar(10) NOT NULL
1749
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1750
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1754
SHOW CREATE TABLE t1;
1756
t1 CREATE TABLE `t1` (
1757
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1758
`c2` mediumint(9) NOT NULL,
1759
`c3` int(11) DEFAULT NULL,
1760
`c4` varchar(10) NOT NULL,
1761
PRIMARY KEY (`c1`,`c2`)
1762
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1766
CREATE TABLE t1(c1 YEAR NOT NULL, c2 MEDIUMINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1770
SHOW CREATE TABLE t1;
1772
t1 CREATE TABLE `t1` (
1773
`c1` year(4) NOT NULL,
1774
`c2` mediumint(9) NOT NULL,
1775
`c3` int(11) DEFAULT NULL,
1776
`c4` varchar(10) NOT NULL
1777
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1778
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1782
SHOW CREATE TABLE t1;
1784
t1 CREATE TABLE `t1` (
1785
`c1` year(4) NOT NULL,
1786
`c2` mediumint(9) NOT NULL,
1787
`c3` int(11) DEFAULT NULL,
1788
`c4` varchar(10) NOT NULL,
1789
PRIMARY KEY (`c1`,`c2`)
1790
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1794
CREATE TABLE t1(c1 BIT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1798
SHOW CREATE TABLE t1;
1800
t1 CREATE TABLE `t1` (
1801
`c1` bit(1) NOT NULL,
1802
`c2` int(11) NOT NULL,
1803
`c3` int(11) DEFAULT NULL,
1804
`c4` varchar(10) NOT NULL
1805
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1806
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1810
SHOW CREATE TABLE t1;
1812
t1 CREATE TABLE `t1` (
1813
`c1` bit(1) NOT NULL,
1814
`c2` int(11) NOT NULL,
1815
`c3` int(11) DEFAULT NULL,
1816
`c4` varchar(10) NOT NULL,
1817
PRIMARY KEY (`c1`,`c2`)
1818
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1822
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1826
SHOW CREATE TABLE t1;
1828
t1 CREATE TABLE `t1` (
1829
`c1` tinyint(4) NOT NULL,
1830
`c2` int(11) NOT NULL,
1831
`c3` int(11) DEFAULT NULL,
1832
`c4` varchar(10) NOT NULL
1833
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1834
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1838
SHOW CREATE TABLE t1;
1840
t1 CREATE TABLE `t1` (
1841
`c1` tinyint(4) NOT NULL,
1842
`c2` int(11) NOT NULL,
1843
`c3` int(11) DEFAULT NULL,
1844
`c4` varchar(10) NOT NULL,
1845
PRIMARY KEY (`c1`,`c2`)
1846
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1850
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1854
SHOW CREATE TABLE t1;
1856
t1 CREATE TABLE `t1` (
1857
`c1` smallint(6) NOT NULL,
1858
`c2` int(11) NOT NULL,
1859
`c3` int(11) DEFAULT NULL,
1860
`c4` varchar(10) NOT NULL
1861
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1862
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1866
SHOW CREATE TABLE t1;
1868
t1 CREATE TABLE `t1` (
1869
`c1` smallint(6) NOT NULL,
1870
`c2` int(11) NOT NULL,
1871
`c3` int(11) DEFAULT NULL,
1872
`c4` varchar(10) NOT NULL,
1873
PRIMARY KEY (`c1`,`c2`)
1874
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1878
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1882
SHOW CREATE TABLE t1;
1884
t1 CREATE TABLE `t1` (
1885
`c1` mediumint(9) NOT NULL,
1886
`c2` int(11) NOT NULL,
1887
`c3` int(11) DEFAULT NULL,
1888
`c4` varchar(10) NOT NULL
1889
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1890
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1894
SHOW CREATE TABLE t1;
1896
t1 CREATE TABLE `t1` (
1897
`c1` mediumint(9) NOT NULL,
1898
`c2` int(11) NOT NULL,
1899
`c3` int(11) DEFAULT NULL,
1900
`c4` varchar(10) NOT NULL,
1901
PRIMARY KEY (`c1`,`c2`)
1902
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1906
CREATE TABLE t1(c1 INT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1910
SHOW CREATE TABLE t1;
1912
t1 CREATE TABLE `t1` (
1913
`c1` int(11) NOT NULL,
1914
`c2` int(11) NOT NULL,
1915
`c3` int(11) DEFAULT NULL,
1916
`c4` varchar(10) NOT NULL
1917
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1918
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1922
SHOW CREATE TABLE t1;
1924
t1 CREATE TABLE `t1` (
1925
`c1` int(11) NOT NULL,
1926
`c2` int(11) NOT NULL,
1927
`c3` int(11) DEFAULT NULL,
1928
`c4` varchar(10) NOT NULL,
1929
PRIMARY KEY (`c1`,`c2`)
1930
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1934
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1938
SHOW CREATE TABLE t1;
1940
t1 CREATE TABLE `t1` (
1941
`c1` int(11) NOT NULL,
1942
`c2` int(11) NOT NULL,
1943
`c3` int(11) DEFAULT NULL,
1944
`c4` varchar(10) NOT NULL
1945
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1946
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1950
SHOW CREATE TABLE t1;
1952
t1 CREATE TABLE `t1` (
1953
`c1` int(11) NOT NULL,
1954
`c2` int(11) NOT NULL,
1955
`c3` int(11) DEFAULT NULL,
1956
`c4` varchar(10) NOT NULL,
1957
PRIMARY KEY (`c1`,`c2`)
1958
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1962
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1966
SHOW CREATE TABLE t1;
1968
t1 CREATE TABLE `t1` (
1969
`c1` bigint(20) NOT NULL,
1970
`c2` int(11) NOT NULL,
1971
`c3` int(11) DEFAULT NULL,
1972
`c4` varchar(10) NOT NULL
1973
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1974
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
1978
SHOW CREATE TABLE t1;
1980
t1 CREATE TABLE `t1` (
1981
`c1` bigint(20) NOT NULL,
1982
`c2` int(11) NOT NULL,
1983
`c3` int(11) DEFAULT NULL,
1984
`c4` varchar(10) NOT NULL,
1985
PRIMARY KEY (`c1`,`c2`)
1986
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1990
CREATE TABLE t1(c1 REAL NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
1994
SHOW CREATE TABLE t1;
1996
t1 CREATE TABLE `t1` (
1997
`c1` double NOT NULL,
1998
`c2` int(11) NOT NULL,
1999
`c3` int(11) DEFAULT NULL,
2000
`c4` varchar(10) NOT NULL
2001
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2002
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2006
SHOW CREATE TABLE t1;
2008
t1 CREATE TABLE `t1` (
2009
`c1` double NOT NULL,
2010
`c2` int(11) NOT NULL,
2011
`c3` int(11) DEFAULT NULL,
2012
`c4` varchar(10) NOT NULL,
2013
PRIMARY KEY (`c1`,`c2`)
2014
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2018
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2022
SHOW CREATE TABLE t1;
2024
t1 CREATE TABLE `t1` (
2025
`c1` double NOT NULL,
2026
`c2` int(11) NOT NULL,
2027
`c3` int(11) DEFAULT NULL,
2028
`c4` varchar(10) NOT NULL
2029
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2030
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2034
SHOW CREATE TABLE t1;
2036
t1 CREATE TABLE `t1` (
2037
`c1` double NOT NULL,
2038
`c2` int(11) NOT NULL,
2039
`c3` int(11) DEFAULT NULL,
2040
`c4` varchar(10) NOT NULL,
2041
PRIMARY KEY (`c1`,`c2`)
2042
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2046
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2050
SHOW CREATE TABLE t1;
2052
t1 CREATE TABLE `t1` (
2053
`c1` float NOT NULL,
2054
`c2` int(11) NOT NULL,
2055
`c3` int(11) DEFAULT NULL,
2056
`c4` varchar(10) NOT NULL
2057
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2058
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2062
SHOW CREATE TABLE t1;
2064
t1 CREATE TABLE `t1` (
2065
`c1` float NOT NULL,
2066
`c2` int(11) NOT NULL,
2067
`c3` int(11) DEFAULT NULL,
2068
`c4` varchar(10) NOT NULL,
2069
PRIMARY KEY (`c1`,`c2`)
2070
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2074
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2078
SHOW CREATE TABLE t1;
2080
t1 CREATE TABLE `t1` (
2081
`c1` decimal(10,0) NOT NULL,
2082
`c2` int(11) NOT NULL,
2083
`c3` int(11) DEFAULT NULL,
2084
`c4` varchar(10) NOT NULL
2085
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2086
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2090
SHOW CREATE TABLE t1;
2092
t1 CREATE TABLE `t1` (
2093
`c1` decimal(10,0) NOT NULL,
2094
`c2` int(11) NOT NULL,
2095
`c3` int(11) DEFAULT NULL,
2096
`c4` varchar(10) NOT NULL,
2097
PRIMARY KEY (`c1`,`c2`)
2098
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2102
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2106
SHOW CREATE TABLE t1;
2108
t1 CREATE TABLE `t1` (
2109
`c1` decimal(10,0) NOT NULL,
2110
`c2` int(11) NOT NULL,
2111
`c3` int(11) DEFAULT NULL,
2112
`c4` varchar(10) NOT NULL
2113
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2114
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2118
SHOW CREATE TABLE t1;
2120
t1 CREATE TABLE `t1` (
2121
`c1` decimal(10,0) NOT NULL,
2122
`c2` int(11) NOT NULL,
2123
`c3` int(11) DEFAULT NULL,
2124
`c4` varchar(10) NOT NULL,
2125
PRIMARY KEY (`c1`,`c2`)
2126
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2130
CREATE TABLE t1(c1 DATE NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2134
SHOW CREATE TABLE t1;
2136
t1 CREATE TABLE `t1` (
2138
`c2` int(11) NOT NULL,
2139
`c3` int(11) DEFAULT NULL,
2140
`c4` varchar(10) NOT NULL
2141
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2142
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2146
SHOW CREATE TABLE t1;
2148
t1 CREATE TABLE `t1` (
2150
`c2` int(11) NOT NULL,
2151
`c3` int(11) DEFAULT NULL,
2152
`c4` varchar(10) NOT NULL,
2153
PRIMARY KEY (`c1`,`c2`)
2154
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2158
CREATE TABLE t1(c1 TIME NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2162
SHOW CREATE TABLE t1;
2164
t1 CREATE TABLE `t1` (
2166
`c2` int(11) NOT NULL,
2167
`c3` int(11) DEFAULT NULL,
2168
`c4` varchar(10) NOT NULL
2169
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2170
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2174
SHOW CREATE TABLE t1;
2176
t1 CREATE TABLE `t1` (
2178
`c2` int(11) NOT NULL,
2179
`c3` int(11) DEFAULT NULL,
2180
`c4` varchar(10) NOT NULL,
2181
PRIMARY KEY (`c1`,`c2`)
2182
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2186
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2190
SHOW CREATE TABLE t1;
2192
t1 CREATE TABLE `t1` (
2193
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2194
`c2` int(11) NOT NULL,
2195
`c3` int(11) DEFAULT NULL,
2196
`c4` varchar(10) NOT NULL
2197
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2198
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2202
SHOW CREATE TABLE t1;
2204
t1 CREATE TABLE `t1` (
2205
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2206
`c2` int(11) NOT NULL,
2207
`c3` int(11) DEFAULT NULL,
2208
`c4` varchar(10) NOT NULL,
2209
PRIMARY KEY (`c1`,`c2`)
2210
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2214
CREATE TABLE t1(c1 YEAR NOT NULL, c2 INT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2218
SHOW CREATE TABLE t1;
2220
t1 CREATE TABLE `t1` (
2221
`c1` year(4) NOT NULL,
2222
`c2` int(11) NOT NULL,
2223
`c3` int(11) DEFAULT NULL,
2224
`c4` varchar(10) NOT NULL
2225
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2226
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2230
SHOW CREATE TABLE t1;
2232
t1 CREATE TABLE `t1` (
2233
`c1` year(4) NOT NULL,
2234
`c2` int(11) NOT NULL,
2235
`c3` int(11) DEFAULT NULL,
2236
`c4` varchar(10) NOT NULL,
2237
PRIMARY KEY (`c1`,`c2`)
2238
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2242
CREATE TABLE t1(c1 BIT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2246
SHOW CREATE TABLE t1;
2248
t1 CREATE TABLE `t1` (
2249
`c1` bit(1) NOT NULL,
2250
`c2` int(11) NOT NULL,
2251
`c3` int(11) DEFAULT NULL,
2252
`c4` varchar(10) NOT NULL
2253
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2254
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2258
SHOW CREATE TABLE t1;
2260
t1 CREATE TABLE `t1` (
2261
`c1` bit(1) NOT NULL,
2262
`c2` int(11) NOT NULL,
2263
`c3` int(11) DEFAULT NULL,
2264
`c4` varchar(10) NOT NULL,
2265
PRIMARY KEY (`c1`,`c2`)
2266
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2270
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2274
SHOW CREATE TABLE t1;
2276
t1 CREATE TABLE `t1` (
2277
`c1` tinyint(4) NOT NULL,
2278
`c2` int(11) NOT NULL,
2279
`c3` int(11) DEFAULT NULL,
2280
`c4` varchar(10) NOT NULL
2281
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2282
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2286
SHOW CREATE TABLE t1;
2288
t1 CREATE TABLE `t1` (
2289
`c1` tinyint(4) NOT NULL,
2290
`c2` int(11) NOT NULL,
2291
`c3` int(11) DEFAULT NULL,
2292
`c4` varchar(10) NOT NULL,
2293
PRIMARY KEY (`c1`,`c2`)
2294
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2298
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2302
SHOW CREATE TABLE t1;
2304
t1 CREATE TABLE `t1` (
2305
`c1` smallint(6) NOT NULL,
2306
`c2` int(11) NOT NULL,
2307
`c3` int(11) DEFAULT NULL,
2308
`c4` varchar(10) NOT NULL
2309
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2310
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2314
SHOW CREATE TABLE t1;
2316
t1 CREATE TABLE `t1` (
2317
`c1` smallint(6) NOT NULL,
2318
`c2` int(11) NOT NULL,
2319
`c3` int(11) DEFAULT NULL,
2320
`c4` varchar(10) NOT NULL,
2321
PRIMARY KEY (`c1`,`c2`)
2322
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2326
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2330
SHOW CREATE TABLE t1;
2332
t1 CREATE TABLE `t1` (
2333
`c1` mediumint(9) NOT NULL,
2334
`c2` int(11) NOT NULL,
2335
`c3` int(11) DEFAULT NULL,
2336
`c4` varchar(10) NOT NULL
2337
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2338
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2342
SHOW CREATE TABLE t1;
2344
t1 CREATE TABLE `t1` (
2345
`c1` mediumint(9) NOT NULL,
2346
`c2` int(11) NOT NULL,
2347
`c3` int(11) DEFAULT NULL,
2348
`c4` varchar(10) NOT NULL,
2349
PRIMARY KEY (`c1`,`c2`)
2350
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2354
CREATE TABLE t1(c1 INT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2358
SHOW CREATE TABLE t1;
2360
t1 CREATE TABLE `t1` (
2361
`c1` int(11) NOT NULL,
2362
`c2` int(11) NOT NULL,
2363
`c3` int(11) DEFAULT NULL,
2364
`c4` varchar(10) NOT NULL
2365
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2366
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2370
SHOW CREATE TABLE t1;
2372
t1 CREATE TABLE `t1` (
2373
`c1` int(11) NOT NULL,
2374
`c2` int(11) NOT NULL,
2375
`c3` int(11) DEFAULT NULL,
2376
`c4` varchar(10) NOT NULL,
2377
PRIMARY KEY (`c1`,`c2`)
2378
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2382
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2386
SHOW CREATE TABLE t1;
2388
t1 CREATE TABLE `t1` (
2389
`c1` int(11) NOT NULL,
2390
`c2` int(11) NOT NULL,
2391
`c3` int(11) DEFAULT NULL,
2392
`c4` varchar(10) NOT NULL
2393
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2394
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2398
SHOW CREATE TABLE t1;
2400
t1 CREATE TABLE `t1` (
2401
`c1` int(11) NOT NULL,
2402
`c2` int(11) NOT NULL,
2403
`c3` int(11) DEFAULT NULL,
2404
`c4` varchar(10) NOT NULL,
2405
PRIMARY KEY (`c1`,`c2`)
2406
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2410
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2414
SHOW CREATE TABLE t1;
2416
t1 CREATE TABLE `t1` (
2417
`c1` bigint(20) NOT NULL,
2418
`c2` int(11) NOT NULL,
2419
`c3` int(11) DEFAULT NULL,
2420
`c4` varchar(10) NOT NULL
2421
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2422
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2426
SHOW CREATE TABLE t1;
2428
t1 CREATE TABLE `t1` (
2429
`c1` bigint(20) NOT NULL,
2430
`c2` int(11) NOT NULL,
2431
`c3` int(11) DEFAULT NULL,
2432
`c4` varchar(10) NOT NULL,
2433
PRIMARY KEY (`c1`,`c2`)
2434
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2438
CREATE TABLE t1(c1 REAL NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2442
SHOW CREATE TABLE t1;
2444
t1 CREATE TABLE `t1` (
2445
`c1` double NOT NULL,
2446
`c2` int(11) NOT NULL,
2447
`c3` int(11) DEFAULT NULL,
2448
`c4` varchar(10) NOT NULL
2449
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2450
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2454
SHOW CREATE TABLE t1;
2456
t1 CREATE TABLE `t1` (
2457
`c1` double NOT NULL,
2458
`c2` int(11) NOT NULL,
2459
`c3` int(11) DEFAULT NULL,
2460
`c4` varchar(10) NOT NULL,
2461
PRIMARY KEY (`c1`,`c2`)
2462
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2466
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2470
SHOW CREATE TABLE t1;
2472
t1 CREATE TABLE `t1` (
2473
`c1` double NOT NULL,
2474
`c2` int(11) NOT NULL,
2475
`c3` int(11) DEFAULT NULL,
2476
`c4` varchar(10) NOT NULL
2477
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2478
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2482
SHOW CREATE TABLE t1;
2484
t1 CREATE TABLE `t1` (
2485
`c1` double NOT NULL,
2486
`c2` int(11) NOT NULL,
2487
`c3` int(11) DEFAULT NULL,
2488
`c4` varchar(10) NOT NULL,
2489
PRIMARY KEY (`c1`,`c2`)
2490
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2494
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2498
SHOW CREATE TABLE t1;
2500
t1 CREATE TABLE `t1` (
2501
`c1` float NOT NULL,
2502
`c2` int(11) NOT NULL,
2503
`c3` int(11) DEFAULT NULL,
2504
`c4` varchar(10) NOT NULL
2505
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2506
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2510
SHOW CREATE TABLE t1;
2512
t1 CREATE TABLE `t1` (
2513
`c1` float NOT NULL,
2514
`c2` int(11) NOT NULL,
2515
`c3` int(11) DEFAULT NULL,
2516
`c4` varchar(10) NOT NULL,
2517
PRIMARY KEY (`c1`,`c2`)
2518
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2522
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2526
SHOW CREATE TABLE t1;
2528
t1 CREATE TABLE `t1` (
2529
`c1` decimal(10,0) NOT NULL,
2530
`c2` int(11) NOT NULL,
2531
`c3` int(11) DEFAULT NULL,
2532
`c4` varchar(10) NOT NULL
2533
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2534
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2538
SHOW CREATE TABLE t1;
2540
t1 CREATE TABLE `t1` (
2541
`c1` decimal(10,0) NOT NULL,
2542
`c2` int(11) NOT NULL,
2543
`c3` int(11) DEFAULT NULL,
2544
`c4` varchar(10) NOT NULL,
2545
PRIMARY KEY (`c1`,`c2`)
2546
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2550
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2554
SHOW CREATE TABLE t1;
2556
t1 CREATE TABLE `t1` (
2557
`c1` decimal(10,0) NOT NULL,
2558
`c2` int(11) NOT NULL,
2559
`c3` int(11) DEFAULT NULL,
2560
`c4` varchar(10) NOT NULL
2561
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2562
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2566
SHOW CREATE TABLE t1;
2568
t1 CREATE TABLE `t1` (
2569
`c1` decimal(10,0) NOT NULL,
2570
`c2` int(11) NOT NULL,
2571
`c3` int(11) DEFAULT NULL,
2572
`c4` varchar(10) NOT NULL,
2573
PRIMARY KEY (`c1`,`c2`)
2574
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2578
CREATE TABLE t1(c1 DATE NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2582
SHOW CREATE TABLE t1;
2584
t1 CREATE TABLE `t1` (
2586
`c2` int(11) NOT NULL,
2587
`c3` int(11) DEFAULT NULL,
2588
`c4` varchar(10) NOT NULL
2589
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2590
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2594
SHOW CREATE TABLE t1;
2596
t1 CREATE TABLE `t1` (
2598
`c2` int(11) NOT NULL,
2599
`c3` int(11) DEFAULT NULL,
2600
`c4` varchar(10) NOT NULL,
2601
PRIMARY KEY (`c1`,`c2`)
2602
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2606
CREATE TABLE t1(c1 TIME NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2610
SHOW CREATE TABLE t1;
2612
t1 CREATE TABLE `t1` (
2614
`c2` int(11) NOT NULL,
2615
`c3` int(11) DEFAULT NULL,
2616
`c4` varchar(10) NOT NULL
2617
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2618
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2622
SHOW CREATE TABLE t1;
2624
t1 CREATE TABLE `t1` (
2626
`c2` int(11) NOT NULL,
2627
`c3` int(11) DEFAULT NULL,
2628
`c4` varchar(10) NOT NULL,
2629
PRIMARY KEY (`c1`,`c2`)
2630
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2634
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2638
SHOW CREATE TABLE t1;
2640
t1 CREATE TABLE `t1` (
2641
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2642
`c2` int(11) NOT NULL,
2643
`c3` int(11) DEFAULT NULL,
2644
`c4` varchar(10) NOT NULL
2645
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2646
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2650
SHOW CREATE TABLE t1;
2652
t1 CREATE TABLE `t1` (
2653
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2654
`c2` int(11) NOT NULL,
2655
`c3` int(11) DEFAULT NULL,
2656
`c4` varchar(10) NOT NULL,
2657
PRIMARY KEY (`c1`,`c2`)
2658
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2662
CREATE TABLE t1(c1 YEAR NOT NULL, c2 INTEGER NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2666
SHOW CREATE TABLE t1;
2668
t1 CREATE TABLE `t1` (
2669
`c1` year(4) NOT NULL,
2670
`c2` int(11) NOT NULL,
2671
`c3` int(11) DEFAULT NULL,
2672
`c4` varchar(10) NOT NULL
2673
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2674
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2678
SHOW CREATE TABLE t1;
2680
t1 CREATE TABLE `t1` (
2681
`c1` year(4) NOT NULL,
2682
`c2` int(11) NOT NULL,
2683
`c3` int(11) DEFAULT NULL,
2684
`c4` varchar(10) NOT NULL,
2685
PRIMARY KEY (`c1`,`c2`)
2686
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2690
CREATE TABLE t1(c1 BIT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2694
SHOW CREATE TABLE t1;
2696
t1 CREATE TABLE `t1` (
2697
`c1` bit(1) NOT NULL,
2698
`c2` bigint(20) NOT NULL,
2699
`c3` int(11) DEFAULT NULL,
2700
`c4` varchar(10) NOT NULL
2701
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2702
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2706
SHOW CREATE TABLE t1;
2708
t1 CREATE TABLE `t1` (
2709
`c1` bit(1) NOT NULL,
2710
`c2` bigint(20) NOT NULL,
2711
`c3` int(11) DEFAULT NULL,
2712
`c4` varchar(10) NOT NULL,
2713
PRIMARY KEY (`c1`,`c2`)
2714
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2718
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2722
SHOW CREATE TABLE t1;
2724
t1 CREATE TABLE `t1` (
2725
`c1` tinyint(4) NOT NULL,
2726
`c2` bigint(20) NOT NULL,
2727
`c3` int(11) DEFAULT NULL,
2728
`c4` varchar(10) NOT NULL
2729
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2730
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2734
SHOW CREATE TABLE t1;
2736
t1 CREATE TABLE `t1` (
2737
`c1` tinyint(4) NOT NULL,
2738
`c2` bigint(20) NOT NULL,
2739
`c3` int(11) DEFAULT NULL,
2740
`c4` varchar(10) NOT NULL,
2741
PRIMARY KEY (`c1`,`c2`)
2742
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2746
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2750
SHOW CREATE TABLE t1;
2752
t1 CREATE TABLE `t1` (
2753
`c1` smallint(6) NOT NULL,
2754
`c2` bigint(20) NOT NULL,
2755
`c3` int(11) DEFAULT NULL,
2756
`c4` varchar(10) NOT NULL
2757
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2758
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2762
SHOW CREATE TABLE t1;
2764
t1 CREATE TABLE `t1` (
2765
`c1` smallint(6) NOT NULL,
2766
`c2` bigint(20) NOT NULL,
2767
`c3` int(11) DEFAULT NULL,
2768
`c4` varchar(10) NOT NULL,
2769
PRIMARY KEY (`c1`,`c2`)
2770
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2774
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2778
SHOW CREATE TABLE t1;
2780
t1 CREATE TABLE `t1` (
2781
`c1` mediumint(9) NOT NULL,
2782
`c2` bigint(20) NOT NULL,
2783
`c3` int(11) DEFAULT NULL,
2784
`c4` varchar(10) NOT NULL
2785
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2786
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2790
SHOW CREATE TABLE t1;
2792
t1 CREATE TABLE `t1` (
2793
`c1` mediumint(9) NOT NULL,
2794
`c2` bigint(20) NOT NULL,
2795
`c3` int(11) DEFAULT NULL,
2796
`c4` varchar(10) NOT NULL,
2797
PRIMARY KEY (`c1`,`c2`)
2798
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2802
CREATE TABLE t1(c1 INT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2806
SHOW CREATE TABLE t1;
2808
t1 CREATE TABLE `t1` (
2809
`c1` int(11) NOT NULL,
2810
`c2` bigint(20) NOT NULL,
2811
`c3` int(11) DEFAULT NULL,
2812
`c4` varchar(10) NOT NULL
2813
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2814
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2818
SHOW CREATE TABLE t1;
2820
t1 CREATE TABLE `t1` (
2821
`c1` int(11) NOT NULL,
2822
`c2` bigint(20) NOT NULL,
2823
`c3` int(11) DEFAULT NULL,
2824
`c4` varchar(10) NOT NULL,
2825
PRIMARY KEY (`c1`,`c2`)
2826
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2830
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2834
SHOW CREATE TABLE t1;
2836
t1 CREATE TABLE `t1` (
2837
`c1` int(11) NOT NULL,
2838
`c2` bigint(20) NOT NULL,
2839
`c3` int(11) DEFAULT NULL,
2840
`c4` varchar(10) NOT NULL
2841
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2842
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2846
SHOW CREATE TABLE t1;
2848
t1 CREATE TABLE `t1` (
2849
`c1` int(11) NOT NULL,
2850
`c2` bigint(20) NOT NULL,
2851
`c3` int(11) DEFAULT NULL,
2852
`c4` varchar(10) NOT NULL,
2853
PRIMARY KEY (`c1`,`c2`)
2854
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2858
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2862
SHOW CREATE TABLE t1;
2864
t1 CREATE TABLE `t1` (
2865
`c1` bigint(20) NOT NULL,
2866
`c2` bigint(20) NOT NULL,
2867
`c3` int(11) DEFAULT NULL,
2868
`c4` varchar(10) NOT NULL
2869
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2870
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2874
SHOW CREATE TABLE t1;
2876
t1 CREATE TABLE `t1` (
2877
`c1` bigint(20) NOT NULL,
2878
`c2` bigint(20) NOT NULL,
2879
`c3` int(11) DEFAULT NULL,
2880
`c4` varchar(10) NOT NULL,
2881
PRIMARY KEY (`c1`,`c2`)
2882
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2886
CREATE TABLE t1(c1 REAL NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2890
SHOW CREATE TABLE t1;
2892
t1 CREATE TABLE `t1` (
2893
`c1` double NOT NULL,
2894
`c2` bigint(20) NOT NULL,
2895
`c3` int(11) DEFAULT NULL,
2896
`c4` varchar(10) NOT NULL
2897
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2898
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2902
SHOW CREATE TABLE t1;
2904
t1 CREATE TABLE `t1` (
2905
`c1` double NOT NULL,
2906
`c2` bigint(20) NOT NULL,
2907
`c3` int(11) DEFAULT NULL,
2908
`c4` varchar(10) NOT NULL,
2909
PRIMARY KEY (`c1`,`c2`)
2910
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2914
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2918
SHOW CREATE TABLE t1;
2920
t1 CREATE TABLE `t1` (
2921
`c1` double NOT NULL,
2922
`c2` bigint(20) NOT NULL,
2923
`c3` int(11) DEFAULT NULL,
2924
`c4` varchar(10) NOT NULL
2925
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2926
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2930
SHOW CREATE TABLE t1;
2932
t1 CREATE TABLE `t1` (
2933
`c1` double NOT NULL,
2934
`c2` bigint(20) NOT NULL,
2935
`c3` int(11) DEFAULT NULL,
2936
`c4` varchar(10) NOT NULL,
2937
PRIMARY KEY (`c1`,`c2`)
2938
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2942
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2946
SHOW CREATE TABLE t1;
2948
t1 CREATE TABLE `t1` (
2949
`c1` float NOT NULL,
2950
`c2` bigint(20) NOT NULL,
2951
`c3` int(11) DEFAULT NULL,
2952
`c4` varchar(10) NOT NULL
2953
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2954
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2958
SHOW CREATE TABLE t1;
2960
t1 CREATE TABLE `t1` (
2961
`c1` float NOT NULL,
2962
`c2` bigint(20) NOT NULL,
2963
`c3` int(11) DEFAULT NULL,
2964
`c4` varchar(10) NOT NULL,
2965
PRIMARY KEY (`c1`,`c2`)
2966
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2970
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
2974
SHOW CREATE TABLE t1;
2976
t1 CREATE TABLE `t1` (
2977
`c1` decimal(10,0) NOT NULL,
2978
`c2` bigint(20) NOT NULL,
2979
`c3` int(11) DEFAULT NULL,
2980
`c4` varchar(10) NOT NULL
2981
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2982
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
2986
SHOW CREATE TABLE t1;
2988
t1 CREATE TABLE `t1` (
2989
`c1` decimal(10,0) NOT NULL,
2990
`c2` bigint(20) NOT NULL,
2991
`c3` int(11) DEFAULT NULL,
2992
`c4` varchar(10) NOT NULL,
2993
PRIMARY KEY (`c1`,`c2`)
2994
) ENGINE=ENGINE DEFAULT CHARSET=latin1
2998
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3002
SHOW CREATE TABLE t1;
3004
t1 CREATE TABLE `t1` (
3005
`c1` decimal(10,0) NOT NULL,
3006
`c2` bigint(20) NOT NULL,
3007
`c3` int(11) DEFAULT NULL,
3008
`c4` varchar(10) NOT NULL
3009
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3010
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3014
SHOW CREATE TABLE t1;
3016
t1 CREATE TABLE `t1` (
3017
`c1` decimal(10,0) NOT NULL,
3018
`c2` bigint(20) NOT NULL,
3019
`c3` int(11) DEFAULT NULL,
3020
`c4` varchar(10) NOT NULL,
3021
PRIMARY KEY (`c1`,`c2`)
3022
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3026
CREATE TABLE t1(c1 DATE NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3030
SHOW CREATE TABLE t1;
3032
t1 CREATE TABLE `t1` (
3034
`c2` bigint(20) NOT NULL,
3035
`c3` int(11) DEFAULT NULL,
3036
`c4` varchar(10) NOT NULL
3037
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3038
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3042
SHOW CREATE TABLE t1;
3044
t1 CREATE TABLE `t1` (
3046
`c2` bigint(20) NOT NULL,
3047
`c3` int(11) DEFAULT NULL,
3048
`c4` varchar(10) NOT NULL,
3049
PRIMARY KEY (`c1`,`c2`)
3050
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3054
CREATE TABLE t1(c1 TIME NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3058
SHOW CREATE TABLE t1;
3060
t1 CREATE TABLE `t1` (
3062
`c2` bigint(20) NOT NULL,
3063
`c3` int(11) DEFAULT NULL,
3064
`c4` varchar(10) NOT NULL
3065
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3066
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3070
SHOW CREATE TABLE t1;
3072
t1 CREATE TABLE `t1` (
3074
`c2` bigint(20) NOT NULL,
3075
`c3` int(11) DEFAULT NULL,
3076
`c4` varchar(10) NOT NULL,
3077
PRIMARY KEY (`c1`,`c2`)
3078
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3082
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3086
SHOW CREATE TABLE t1;
3088
t1 CREATE TABLE `t1` (
3089
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3090
`c2` bigint(20) NOT NULL,
3091
`c3` int(11) DEFAULT NULL,
3092
`c4` varchar(10) NOT NULL
3093
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3094
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3098
SHOW CREATE TABLE t1;
3100
t1 CREATE TABLE `t1` (
3101
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3102
`c2` bigint(20) NOT NULL,
3103
`c3` int(11) DEFAULT NULL,
3104
`c4` varchar(10) NOT NULL,
3105
PRIMARY KEY (`c1`,`c2`)
3106
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3110
CREATE TABLE t1(c1 YEAR NOT NULL, c2 BIGINT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3114
SHOW CREATE TABLE t1;
3116
t1 CREATE TABLE `t1` (
3117
`c1` year(4) NOT NULL,
3118
`c2` bigint(20) NOT NULL,
3119
`c3` int(11) DEFAULT NULL,
3120
`c4` varchar(10) NOT NULL
3121
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3122
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3126
SHOW CREATE TABLE t1;
3128
t1 CREATE TABLE `t1` (
3129
`c1` year(4) NOT NULL,
3130
`c2` bigint(20) NOT NULL,
3131
`c3` int(11) DEFAULT NULL,
3132
`c4` varchar(10) NOT NULL,
3133
PRIMARY KEY (`c1`,`c2`)
3134
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3138
CREATE TABLE t1(c1 BIT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3142
SHOW CREATE TABLE t1;
3144
t1 CREATE TABLE `t1` (
3145
`c1` bit(1) NOT NULL,
3146
`c2` double NOT NULL,
3147
`c3` int(11) DEFAULT NULL,
3148
`c4` varchar(10) NOT NULL
3149
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3150
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3154
SHOW CREATE TABLE t1;
3156
t1 CREATE TABLE `t1` (
3157
`c1` bit(1) NOT NULL,
3158
`c2` double NOT NULL,
3159
`c3` int(11) DEFAULT NULL,
3160
`c4` varchar(10) NOT NULL,
3161
PRIMARY KEY (`c1`,`c2`)
3162
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3166
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3170
SHOW CREATE TABLE t1;
3172
t1 CREATE TABLE `t1` (
3173
`c1` tinyint(4) NOT NULL,
3174
`c2` double NOT NULL,
3175
`c3` int(11) DEFAULT NULL,
3176
`c4` varchar(10) NOT NULL
3177
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3178
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3182
SHOW CREATE TABLE t1;
3184
t1 CREATE TABLE `t1` (
3185
`c1` tinyint(4) NOT NULL,
3186
`c2` double NOT NULL,
3187
`c3` int(11) DEFAULT NULL,
3188
`c4` varchar(10) NOT NULL,
3189
PRIMARY KEY (`c1`,`c2`)
3190
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3194
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3198
SHOW CREATE TABLE t1;
3200
t1 CREATE TABLE `t1` (
3201
`c1` smallint(6) NOT NULL,
3202
`c2` double NOT NULL,
3203
`c3` int(11) DEFAULT NULL,
3204
`c4` varchar(10) NOT NULL
3205
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3206
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3210
SHOW CREATE TABLE t1;
3212
t1 CREATE TABLE `t1` (
3213
`c1` smallint(6) NOT NULL,
3214
`c2` double NOT NULL,
3215
`c3` int(11) DEFAULT NULL,
3216
`c4` varchar(10) NOT NULL,
3217
PRIMARY KEY (`c1`,`c2`)
3218
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3222
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3226
SHOW CREATE TABLE t1;
3228
t1 CREATE TABLE `t1` (
3229
`c1` mediumint(9) NOT NULL,
3230
`c2` double NOT NULL,
3231
`c3` int(11) DEFAULT NULL,
3232
`c4` varchar(10) NOT NULL
3233
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3234
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3238
SHOW CREATE TABLE t1;
3240
t1 CREATE TABLE `t1` (
3241
`c1` mediumint(9) NOT NULL,
3242
`c2` double NOT NULL,
3243
`c3` int(11) DEFAULT NULL,
3244
`c4` varchar(10) NOT NULL,
3245
PRIMARY KEY (`c1`,`c2`)
3246
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3250
CREATE TABLE t1(c1 INT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3254
SHOW CREATE TABLE t1;
3256
t1 CREATE TABLE `t1` (
3257
`c1` int(11) NOT NULL,
3258
`c2` double NOT NULL,
3259
`c3` int(11) DEFAULT NULL,
3260
`c4` varchar(10) NOT NULL
3261
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3262
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3266
SHOW CREATE TABLE t1;
3268
t1 CREATE TABLE `t1` (
3269
`c1` int(11) NOT NULL,
3270
`c2` double NOT NULL,
3271
`c3` int(11) DEFAULT NULL,
3272
`c4` varchar(10) NOT NULL,
3273
PRIMARY KEY (`c1`,`c2`)
3274
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3278
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3282
SHOW CREATE TABLE t1;
3284
t1 CREATE TABLE `t1` (
3285
`c1` int(11) NOT NULL,
3286
`c2` double NOT NULL,
3287
`c3` int(11) DEFAULT NULL,
3288
`c4` varchar(10) NOT NULL
3289
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3290
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3294
SHOW CREATE TABLE t1;
3296
t1 CREATE TABLE `t1` (
3297
`c1` int(11) NOT NULL,
3298
`c2` double NOT NULL,
3299
`c3` int(11) DEFAULT NULL,
3300
`c4` varchar(10) NOT NULL,
3301
PRIMARY KEY (`c1`,`c2`)
3302
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3306
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3310
SHOW CREATE TABLE t1;
3312
t1 CREATE TABLE `t1` (
3313
`c1` bigint(20) NOT NULL,
3314
`c2` double NOT NULL,
3315
`c3` int(11) DEFAULT NULL,
3316
`c4` varchar(10) NOT NULL
3317
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3318
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3322
SHOW CREATE TABLE t1;
3324
t1 CREATE TABLE `t1` (
3325
`c1` bigint(20) NOT NULL,
3326
`c2` double NOT NULL,
3327
`c3` int(11) DEFAULT NULL,
3328
`c4` varchar(10) NOT NULL,
3329
PRIMARY KEY (`c1`,`c2`)
3330
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3334
CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3338
SHOW CREATE TABLE t1;
3340
t1 CREATE TABLE `t1` (
3341
`c1` double NOT NULL,
3342
`c2` double NOT NULL,
3343
`c3` int(11) DEFAULT NULL,
3344
`c4` varchar(10) NOT NULL
3345
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3346
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3350
SHOW CREATE TABLE t1;
3352
t1 CREATE TABLE `t1` (
3353
`c1` double NOT NULL,
3354
`c2` double NOT NULL,
3355
`c3` int(11) DEFAULT NULL,
3356
`c4` varchar(10) NOT NULL,
3357
PRIMARY KEY (`c1`,`c2`)
3358
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3362
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3366
SHOW CREATE TABLE t1;
3368
t1 CREATE TABLE `t1` (
3369
`c1` double NOT NULL,
3370
`c2` double NOT NULL,
3371
`c3` int(11) DEFAULT NULL,
3372
`c4` varchar(10) NOT NULL
3373
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3374
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3378
SHOW CREATE TABLE t1;
3380
t1 CREATE TABLE `t1` (
3381
`c1` double NOT NULL,
3382
`c2` double NOT NULL,
3383
`c3` int(11) DEFAULT NULL,
3384
`c4` varchar(10) NOT NULL,
3385
PRIMARY KEY (`c1`,`c2`)
3386
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3390
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3394
SHOW CREATE TABLE t1;
3396
t1 CREATE TABLE `t1` (
3397
`c1` float NOT NULL,
3398
`c2` double NOT NULL,
3399
`c3` int(11) DEFAULT NULL,
3400
`c4` varchar(10) NOT NULL
3401
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3402
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3406
SHOW CREATE TABLE t1;
3408
t1 CREATE TABLE `t1` (
3409
`c1` float NOT NULL,
3410
`c2` double NOT NULL,
3411
`c3` int(11) DEFAULT NULL,
3412
`c4` varchar(10) NOT NULL,
3413
PRIMARY KEY (`c1`,`c2`)
3414
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3418
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3422
SHOW CREATE TABLE t1;
3424
t1 CREATE TABLE `t1` (
3425
`c1` decimal(10,0) NOT NULL,
3426
`c2` double NOT NULL,
3427
`c3` int(11) DEFAULT NULL,
3428
`c4` varchar(10) NOT NULL
3429
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3430
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3434
SHOW CREATE TABLE t1;
3436
t1 CREATE TABLE `t1` (
3437
`c1` decimal(10,0) NOT NULL,
3438
`c2` double NOT NULL,
3439
`c3` int(11) DEFAULT NULL,
3440
`c4` varchar(10) NOT NULL,
3441
PRIMARY KEY (`c1`,`c2`)
3442
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3446
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3450
SHOW CREATE TABLE t1;
3452
t1 CREATE TABLE `t1` (
3453
`c1` decimal(10,0) NOT NULL,
3454
`c2` double NOT NULL,
3455
`c3` int(11) DEFAULT NULL,
3456
`c4` varchar(10) NOT NULL
3457
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3458
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3462
SHOW CREATE TABLE t1;
3464
t1 CREATE TABLE `t1` (
3465
`c1` decimal(10,0) NOT NULL,
3466
`c2` double NOT NULL,
3467
`c3` int(11) DEFAULT NULL,
3468
`c4` varchar(10) NOT NULL,
3469
PRIMARY KEY (`c1`,`c2`)
3470
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3474
CREATE TABLE t1(c1 DATE NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3478
SHOW CREATE TABLE t1;
3480
t1 CREATE TABLE `t1` (
3482
`c2` double NOT NULL,
3483
`c3` int(11) DEFAULT NULL,
3484
`c4` varchar(10) NOT NULL
3485
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3486
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3490
SHOW CREATE TABLE t1;
3492
t1 CREATE TABLE `t1` (
3494
`c2` double NOT NULL,
3495
`c3` int(11) DEFAULT NULL,
3496
`c4` varchar(10) NOT NULL,
3497
PRIMARY KEY (`c1`,`c2`)
3498
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3502
CREATE TABLE t1(c1 TIME NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3506
SHOW CREATE TABLE t1;
3508
t1 CREATE TABLE `t1` (
3510
`c2` double NOT NULL,
3511
`c3` int(11) DEFAULT NULL,
3512
`c4` varchar(10) NOT NULL
3513
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3514
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3518
SHOW CREATE TABLE t1;
3520
t1 CREATE TABLE `t1` (
3522
`c2` double NOT NULL,
3523
`c3` int(11) DEFAULT NULL,
3524
`c4` varchar(10) NOT NULL,
3525
PRIMARY KEY (`c1`,`c2`)
3526
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3530
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3534
SHOW CREATE TABLE t1;
3536
t1 CREATE TABLE `t1` (
3537
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3538
`c2` double NOT NULL,
3539
`c3` int(11) DEFAULT NULL,
3540
`c4` varchar(10) NOT NULL
3541
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3542
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3546
SHOW CREATE TABLE t1;
3548
t1 CREATE TABLE `t1` (
3549
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3550
`c2` double NOT NULL,
3551
`c3` int(11) DEFAULT NULL,
3552
`c4` varchar(10) NOT NULL,
3553
PRIMARY KEY (`c1`,`c2`)
3554
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3558
CREATE TABLE t1(c1 YEAR NOT NULL, c2 REAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3562
SHOW CREATE TABLE t1;
3564
t1 CREATE TABLE `t1` (
3565
`c1` year(4) NOT NULL,
3566
`c2` double NOT NULL,
3567
`c3` int(11) DEFAULT NULL,
3568
`c4` varchar(10) NOT NULL
3569
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3570
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3574
SHOW CREATE TABLE t1;
3576
t1 CREATE TABLE `t1` (
3577
`c1` year(4) NOT NULL,
3578
`c2` double NOT NULL,
3579
`c3` int(11) DEFAULT NULL,
3580
`c4` varchar(10) NOT NULL,
3581
PRIMARY KEY (`c1`,`c2`)
3582
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3586
CREATE TABLE t1(c1 BIT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3590
SHOW CREATE TABLE t1;
3592
t1 CREATE TABLE `t1` (
3593
`c1` bit(1) NOT NULL,
3594
`c2` double NOT NULL,
3595
`c3` int(11) DEFAULT NULL,
3596
`c4` varchar(10) NOT NULL
3597
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3598
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3602
SHOW CREATE TABLE t1;
3604
t1 CREATE TABLE `t1` (
3605
`c1` bit(1) NOT NULL,
3606
`c2` double NOT NULL,
3607
`c3` int(11) DEFAULT NULL,
3608
`c4` varchar(10) NOT NULL,
3609
PRIMARY KEY (`c1`,`c2`)
3610
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3614
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3618
SHOW CREATE TABLE t1;
3620
t1 CREATE TABLE `t1` (
3621
`c1` tinyint(4) NOT NULL,
3622
`c2` double NOT NULL,
3623
`c3` int(11) DEFAULT NULL,
3624
`c4` varchar(10) NOT NULL
3625
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3626
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3630
SHOW CREATE TABLE t1;
3632
t1 CREATE TABLE `t1` (
3633
`c1` tinyint(4) NOT NULL,
3634
`c2` double NOT NULL,
3635
`c3` int(11) DEFAULT NULL,
3636
`c4` varchar(10) NOT NULL,
3637
PRIMARY KEY (`c1`,`c2`)
3638
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3642
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3646
SHOW CREATE TABLE t1;
3648
t1 CREATE TABLE `t1` (
3649
`c1` smallint(6) NOT NULL,
3650
`c2` double NOT NULL,
3651
`c3` int(11) DEFAULT NULL,
3652
`c4` varchar(10) NOT NULL
3653
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3654
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3658
SHOW CREATE TABLE t1;
3660
t1 CREATE TABLE `t1` (
3661
`c1` smallint(6) NOT NULL,
3662
`c2` double NOT NULL,
3663
`c3` int(11) DEFAULT NULL,
3664
`c4` varchar(10) NOT NULL,
3665
PRIMARY KEY (`c1`,`c2`)
3666
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3670
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3674
SHOW CREATE TABLE t1;
3676
t1 CREATE TABLE `t1` (
3677
`c1` mediumint(9) NOT NULL,
3678
`c2` double NOT NULL,
3679
`c3` int(11) DEFAULT NULL,
3680
`c4` varchar(10) NOT NULL
3681
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3682
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3686
SHOW CREATE TABLE t1;
3688
t1 CREATE TABLE `t1` (
3689
`c1` mediumint(9) NOT NULL,
3690
`c2` double NOT NULL,
3691
`c3` int(11) DEFAULT NULL,
3692
`c4` varchar(10) NOT NULL,
3693
PRIMARY KEY (`c1`,`c2`)
3694
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3698
CREATE TABLE t1(c1 INT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3702
SHOW CREATE TABLE t1;
3704
t1 CREATE TABLE `t1` (
3705
`c1` int(11) NOT NULL,
3706
`c2` double NOT NULL,
3707
`c3` int(11) DEFAULT NULL,
3708
`c4` varchar(10) NOT NULL
3709
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3710
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3714
SHOW CREATE TABLE t1;
3716
t1 CREATE TABLE `t1` (
3717
`c1` int(11) NOT NULL,
3718
`c2` double NOT NULL,
3719
`c3` int(11) DEFAULT NULL,
3720
`c4` varchar(10) NOT NULL,
3721
PRIMARY KEY (`c1`,`c2`)
3722
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3726
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3730
SHOW CREATE TABLE t1;
3732
t1 CREATE TABLE `t1` (
3733
`c1` int(11) NOT NULL,
3734
`c2` double NOT NULL,
3735
`c3` int(11) DEFAULT NULL,
3736
`c4` varchar(10) NOT NULL
3737
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3738
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3742
SHOW CREATE TABLE t1;
3744
t1 CREATE TABLE `t1` (
3745
`c1` int(11) NOT NULL,
3746
`c2` double NOT NULL,
3747
`c3` int(11) DEFAULT NULL,
3748
`c4` varchar(10) NOT NULL,
3749
PRIMARY KEY (`c1`,`c2`)
3750
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3754
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3758
SHOW CREATE TABLE t1;
3760
t1 CREATE TABLE `t1` (
3761
`c1` bigint(20) NOT NULL,
3762
`c2` double NOT NULL,
3763
`c3` int(11) DEFAULT NULL,
3764
`c4` varchar(10) NOT NULL
3765
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3766
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3770
SHOW CREATE TABLE t1;
3772
t1 CREATE TABLE `t1` (
3773
`c1` bigint(20) NOT NULL,
3774
`c2` double NOT NULL,
3775
`c3` int(11) DEFAULT NULL,
3776
`c4` varchar(10) NOT NULL,
3777
PRIMARY KEY (`c1`,`c2`)
3778
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3782
CREATE TABLE t1(c1 REAL NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3786
SHOW CREATE TABLE t1;
3788
t1 CREATE TABLE `t1` (
3789
`c1` double NOT NULL,
3790
`c2` double NOT NULL,
3791
`c3` int(11) DEFAULT NULL,
3792
`c4` varchar(10) NOT NULL
3793
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3794
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3798
SHOW CREATE TABLE t1;
3800
t1 CREATE TABLE `t1` (
3801
`c1` double NOT NULL,
3802
`c2` double NOT NULL,
3803
`c3` int(11) DEFAULT NULL,
3804
`c4` varchar(10) NOT NULL,
3805
PRIMARY KEY (`c1`,`c2`)
3806
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3810
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3814
SHOW CREATE TABLE t1;
3816
t1 CREATE TABLE `t1` (
3817
`c1` double NOT NULL,
3818
`c2` double NOT NULL,
3819
`c3` int(11) DEFAULT NULL,
3820
`c4` varchar(10) NOT NULL
3821
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3822
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3826
SHOW CREATE TABLE t1;
3828
t1 CREATE TABLE `t1` (
3829
`c1` double NOT NULL,
3830
`c2` double NOT NULL,
3831
`c3` int(11) DEFAULT NULL,
3832
`c4` varchar(10) NOT NULL,
3833
PRIMARY KEY (`c1`,`c2`)
3834
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3838
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3842
SHOW CREATE TABLE t1;
3844
t1 CREATE TABLE `t1` (
3845
`c1` float NOT NULL,
3846
`c2` double NOT NULL,
3847
`c3` int(11) DEFAULT NULL,
3848
`c4` varchar(10) NOT NULL
3849
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3850
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3854
SHOW CREATE TABLE t1;
3856
t1 CREATE TABLE `t1` (
3857
`c1` float NOT NULL,
3858
`c2` double NOT NULL,
3859
`c3` int(11) DEFAULT NULL,
3860
`c4` varchar(10) NOT NULL,
3861
PRIMARY KEY (`c1`,`c2`)
3862
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3866
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3870
SHOW CREATE TABLE t1;
3872
t1 CREATE TABLE `t1` (
3873
`c1` decimal(10,0) NOT NULL,
3874
`c2` double NOT NULL,
3875
`c3` int(11) DEFAULT NULL,
3876
`c4` varchar(10) NOT NULL
3877
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3878
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3882
SHOW CREATE TABLE t1;
3884
t1 CREATE TABLE `t1` (
3885
`c1` decimal(10,0) NOT NULL,
3886
`c2` double NOT NULL,
3887
`c3` int(11) DEFAULT NULL,
3888
`c4` varchar(10) NOT NULL,
3889
PRIMARY KEY (`c1`,`c2`)
3890
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3894
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3898
SHOW CREATE TABLE t1;
3900
t1 CREATE TABLE `t1` (
3901
`c1` decimal(10,0) NOT NULL,
3902
`c2` double NOT NULL,
3903
`c3` int(11) DEFAULT NULL,
3904
`c4` varchar(10) NOT NULL
3905
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3906
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3910
SHOW CREATE TABLE t1;
3912
t1 CREATE TABLE `t1` (
3913
`c1` decimal(10,0) NOT NULL,
3914
`c2` double NOT NULL,
3915
`c3` int(11) DEFAULT NULL,
3916
`c4` varchar(10) NOT NULL,
3917
PRIMARY KEY (`c1`,`c2`)
3918
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3922
CREATE TABLE t1(c1 DATE NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3926
SHOW CREATE TABLE t1;
3928
t1 CREATE TABLE `t1` (
3930
`c2` double NOT NULL,
3931
`c3` int(11) DEFAULT NULL,
3932
`c4` varchar(10) NOT NULL
3933
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3934
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3938
SHOW CREATE TABLE t1;
3940
t1 CREATE TABLE `t1` (
3942
`c2` double NOT NULL,
3943
`c3` int(11) DEFAULT NULL,
3944
`c4` varchar(10) NOT NULL,
3945
PRIMARY KEY (`c1`,`c2`)
3946
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3950
CREATE TABLE t1(c1 TIME NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3954
SHOW CREATE TABLE t1;
3956
t1 CREATE TABLE `t1` (
3958
`c2` double NOT NULL,
3959
`c3` int(11) DEFAULT NULL,
3960
`c4` varchar(10) NOT NULL
3961
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3962
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3966
SHOW CREATE TABLE t1;
3968
t1 CREATE TABLE `t1` (
3970
`c2` double NOT NULL,
3971
`c3` int(11) DEFAULT NULL,
3972
`c4` varchar(10) NOT NULL,
3973
PRIMARY KEY (`c1`,`c2`)
3974
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3978
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
3982
SHOW CREATE TABLE t1;
3984
t1 CREATE TABLE `t1` (
3985
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3986
`c2` double NOT NULL,
3987
`c3` int(11) DEFAULT NULL,
3988
`c4` varchar(10) NOT NULL
3989
) ENGINE=ENGINE DEFAULT CHARSET=latin1
3990
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
3994
SHOW CREATE TABLE t1;
3996
t1 CREATE TABLE `t1` (
3997
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3998
`c2` double NOT NULL,
3999
`c3` int(11) DEFAULT NULL,
4000
`c4` varchar(10) NOT NULL,
4001
PRIMARY KEY (`c1`,`c2`)
4002
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4006
CREATE TABLE t1(c1 YEAR NOT NULL, c2 DOUBLE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4010
SHOW CREATE TABLE t1;
4012
t1 CREATE TABLE `t1` (
4013
`c1` year(4) NOT NULL,
4014
`c2` double NOT NULL,
4015
`c3` int(11) DEFAULT NULL,
4016
`c4` varchar(10) NOT NULL
4017
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4018
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4022
SHOW CREATE TABLE t1;
4024
t1 CREATE TABLE `t1` (
4025
`c1` year(4) NOT NULL,
4026
`c2` double NOT NULL,
4027
`c3` int(11) DEFAULT NULL,
4028
`c4` varchar(10) NOT NULL,
4029
PRIMARY KEY (`c1`,`c2`)
4030
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4034
CREATE TABLE t1(c1 BIT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4038
SHOW CREATE TABLE t1;
4040
t1 CREATE TABLE `t1` (
4041
`c1` bit(1) NOT NULL,
4042
`c2` float NOT NULL,
4043
`c3` int(11) DEFAULT NULL,
4044
`c4` varchar(10) NOT NULL
4045
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4046
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4050
SHOW CREATE TABLE t1;
4052
t1 CREATE TABLE `t1` (
4053
`c1` bit(1) NOT NULL,
4054
`c2` float NOT NULL,
4055
`c3` int(11) DEFAULT NULL,
4056
`c4` varchar(10) NOT NULL,
4057
PRIMARY KEY (`c1`,`c2`)
4058
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4062
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4066
SHOW CREATE TABLE t1;
4068
t1 CREATE TABLE `t1` (
4069
`c1` tinyint(4) NOT NULL,
4070
`c2` float NOT NULL,
4071
`c3` int(11) DEFAULT NULL,
4072
`c4` varchar(10) NOT NULL
4073
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4074
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4078
SHOW CREATE TABLE t1;
4080
t1 CREATE TABLE `t1` (
4081
`c1` tinyint(4) NOT NULL,
4082
`c2` float NOT NULL,
4083
`c3` int(11) DEFAULT NULL,
4084
`c4` varchar(10) NOT NULL,
4085
PRIMARY KEY (`c1`,`c2`)
4086
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4090
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4094
SHOW CREATE TABLE t1;
4096
t1 CREATE TABLE `t1` (
4097
`c1` smallint(6) NOT NULL,
4098
`c2` float NOT NULL,
4099
`c3` int(11) DEFAULT NULL,
4100
`c4` varchar(10) NOT NULL
4101
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4102
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4106
SHOW CREATE TABLE t1;
4108
t1 CREATE TABLE `t1` (
4109
`c1` smallint(6) NOT NULL,
4110
`c2` float NOT NULL,
4111
`c3` int(11) DEFAULT NULL,
4112
`c4` varchar(10) NOT NULL,
4113
PRIMARY KEY (`c1`,`c2`)
4114
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4118
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4122
SHOW CREATE TABLE t1;
4124
t1 CREATE TABLE `t1` (
4125
`c1` mediumint(9) NOT NULL,
4126
`c2` float NOT NULL,
4127
`c3` int(11) DEFAULT NULL,
4128
`c4` varchar(10) NOT NULL
4129
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4130
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4134
SHOW CREATE TABLE t1;
4136
t1 CREATE TABLE `t1` (
4137
`c1` mediumint(9) NOT NULL,
4138
`c2` float NOT NULL,
4139
`c3` int(11) DEFAULT NULL,
4140
`c4` varchar(10) NOT NULL,
4141
PRIMARY KEY (`c1`,`c2`)
4142
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4146
CREATE TABLE t1(c1 INT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4150
SHOW CREATE TABLE t1;
4152
t1 CREATE TABLE `t1` (
4153
`c1` int(11) NOT NULL,
4154
`c2` float NOT NULL,
4155
`c3` int(11) DEFAULT NULL,
4156
`c4` varchar(10) NOT NULL
4157
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4158
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4162
SHOW CREATE TABLE t1;
4164
t1 CREATE TABLE `t1` (
4165
`c1` int(11) NOT NULL,
4166
`c2` float NOT NULL,
4167
`c3` int(11) DEFAULT NULL,
4168
`c4` varchar(10) NOT NULL,
4169
PRIMARY KEY (`c1`,`c2`)
4170
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4174
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4178
SHOW CREATE TABLE t1;
4180
t1 CREATE TABLE `t1` (
4181
`c1` int(11) NOT NULL,
4182
`c2` float NOT NULL,
4183
`c3` int(11) DEFAULT NULL,
4184
`c4` varchar(10) NOT NULL
4185
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4186
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4190
SHOW CREATE TABLE t1;
4192
t1 CREATE TABLE `t1` (
4193
`c1` int(11) NOT NULL,
4194
`c2` float NOT NULL,
4195
`c3` int(11) DEFAULT NULL,
4196
`c4` varchar(10) NOT NULL,
4197
PRIMARY KEY (`c1`,`c2`)
4198
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4202
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4206
SHOW CREATE TABLE t1;
4208
t1 CREATE TABLE `t1` (
4209
`c1` bigint(20) NOT NULL,
4210
`c2` float NOT NULL,
4211
`c3` int(11) DEFAULT NULL,
4212
`c4` varchar(10) NOT NULL
4213
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4214
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4218
SHOW CREATE TABLE t1;
4220
t1 CREATE TABLE `t1` (
4221
`c1` bigint(20) NOT NULL,
4222
`c2` float NOT NULL,
4223
`c3` int(11) DEFAULT NULL,
4224
`c4` varchar(10) NOT NULL,
4225
PRIMARY KEY (`c1`,`c2`)
4226
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4230
CREATE TABLE t1(c1 REAL NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4234
SHOW CREATE TABLE t1;
4236
t1 CREATE TABLE `t1` (
4237
`c1` double NOT NULL,
4238
`c2` float NOT NULL,
4239
`c3` int(11) DEFAULT NULL,
4240
`c4` varchar(10) NOT NULL
4241
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4242
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4246
SHOW CREATE TABLE t1;
4248
t1 CREATE TABLE `t1` (
4249
`c1` double NOT NULL,
4250
`c2` float NOT NULL,
4251
`c3` int(11) DEFAULT NULL,
4252
`c4` varchar(10) NOT NULL,
4253
PRIMARY KEY (`c1`,`c2`)
4254
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4258
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4262
SHOW CREATE TABLE t1;
4264
t1 CREATE TABLE `t1` (
4265
`c1` double NOT NULL,
4266
`c2` float NOT NULL,
4267
`c3` int(11) DEFAULT NULL,
4268
`c4` varchar(10) NOT NULL
4269
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4270
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4274
SHOW CREATE TABLE t1;
4276
t1 CREATE TABLE `t1` (
4277
`c1` double NOT NULL,
4278
`c2` float NOT NULL,
4279
`c3` int(11) DEFAULT NULL,
4280
`c4` varchar(10) NOT NULL,
4281
PRIMARY KEY (`c1`,`c2`)
4282
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4286
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4290
SHOW CREATE TABLE t1;
4292
t1 CREATE TABLE `t1` (
4293
`c1` float NOT NULL,
4294
`c2` float NOT NULL,
4295
`c3` int(11) DEFAULT NULL,
4296
`c4` varchar(10) NOT NULL
4297
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4298
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4302
SHOW CREATE TABLE t1;
4304
t1 CREATE TABLE `t1` (
4305
`c1` float NOT NULL,
4306
`c2` float NOT NULL,
4307
`c3` int(11) DEFAULT NULL,
4308
`c4` varchar(10) NOT NULL,
4309
PRIMARY KEY (`c1`,`c2`)
4310
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4314
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4318
SHOW CREATE TABLE t1;
4320
t1 CREATE TABLE `t1` (
4321
`c1` decimal(10,0) NOT NULL,
4322
`c2` float NOT NULL,
4323
`c3` int(11) DEFAULT NULL,
4324
`c4` varchar(10) NOT NULL
4325
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4326
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4330
SHOW CREATE TABLE t1;
4332
t1 CREATE TABLE `t1` (
4333
`c1` decimal(10,0) NOT NULL,
4334
`c2` float NOT NULL,
4335
`c3` int(11) DEFAULT NULL,
4336
`c4` varchar(10) NOT NULL,
4337
PRIMARY KEY (`c1`,`c2`)
4338
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4342
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4346
SHOW CREATE TABLE t1;
4348
t1 CREATE TABLE `t1` (
4349
`c1` decimal(10,0) NOT NULL,
4350
`c2` float NOT NULL,
4351
`c3` int(11) DEFAULT NULL,
4352
`c4` varchar(10) NOT NULL
4353
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4354
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4358
SHOW CREATE TABLE t1;
4360
t1 CREATE TABLE `t1` (
4361
`c1` decimal(10,0) NOT NULL,
4362
`c2` float NOT NULL,
4363
`c3` int(11) DEFAULT NULL,
4364
`c4` varchar(10) NOT NULL,
4365
PRIMARY KEY (`c1`,`c2`)
4366
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4370
CREATE TABLE t1(c1 DATE NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4374
SHOW CREATE TABLE t1;
4376
t1 CREATE TABLE `t1` (
4378
`c2` float NOT NULL,
4379
`c3` int(11) DEFAULT NULL,
4380
`c4` varchar(10) NOT NULL
4381
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4382
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4386
SHOW CREATE TABLE t1;
4388
t1 CREATE TABLE `t1` (
4390
`c2` float NOT NULL,
4391
`c3` int(11) DEFAULT NULL,
4392
`c4` varchar(10) NOT NULL,
4393
PRIMARY KEY (`c1`,`c2`)
4394
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4398
CREATE TABLE t1(c1 TIME NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4402
SHOW CREATE TABLE t1;
4404
t1 CREATE TABLE `t1` (
4406
`c2` float NOT NULL,
4407
`c3` int(11) DEFAULT NULL,
4408
`c4` varchar(10) NOT NULL
4409
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4410
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4414
SHOW CREATE TABLE t1;
4416
t1 CREATE TABLE `t1` (
4418
`c2` float NOT NULL,
4419
`c3` int(11) DEFAULT NULL,
4420
`c4` varchar(10) NOT NULL,
4421
PRIMARY KEY (`c1`,`c2`)
4422
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4426
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4430
SHOW CREATE TABLE t1;
4432
t1 CREATE TABLE `t1` (
4433
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4434
`c2` float NOT NULL,
4435
`c3` int(11) DEFAULT NULL,
4436
`c4` varchar(10) NOT NULL
4437
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4438
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4442
SHOW CREATE TABLE t1;
4444
t1 CREATE TABLE `t1` (
4445
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4446
`c2` float NOT NULL,
4447
`c3` int(11) DEFAULT NULL,
4448
`c4` varchar(10) NOT NULL,
4449
PRIMARY KEY (`c1`,`c2`)
4450
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4454
CREATE TABLE t1(c1 YEAR NOT NULL, c2 FLOAT NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4458
SHOW CREATE TABLE t1;
4460
t1 CREATE TABLE `t1` (
4461
`c1` year(4) NOT NULL,
4462
`c2` float NOT NULL,
4463
`c3` int(11) DEFAULT NULL,
4464
`c4` varchar(10) NOT NULL
4465
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4466
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4470
SHOW CREATE TABLE t1;
4472
t1 CREATE TABLE `t1` (
4473
`c1` year(4) NOT NULL,
4474
`c2` float NOT NULL,
4475
`c3` int(11) DEFAULT NULL,
4476
`c4` varchar(10) NOT NULL,
4477
PRIMARY KEY (`c1`,`c2`)
4478
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4482
CREATE TABLE t1(c1 BIT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4486
SHOW CREATE TABLE t1;
4488
t1 CREATE TABLE `t1` (
4489
`c1` bit(1) NOT NULL,
4490
`c2` decimal(10,0) NOT NULL,
4491
`c3` int(11) DEFAULT NULL,
4492
`c4` varchar(10) NOT NULL
4493
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4494
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4498
SHOW CREATE TABLE t1;
4500
t1 CREATE TABLE `t1` (
4501
`c1` bit(1) NOT NULL,
4502
`c2` decimal(10,0) NOT NULL,
4503
`c3` int(11) DEFAULT NULL,
4504
`c4` varchar(10) NOT NULL,
4505
PRIMARY KEY (`c1`,`c2`)
4506
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4510
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4514
SHOW CREATE TABLE t1;
4516
t1 CREATE TABLE `t1` (
4517
`c1` tinyint(4) NOT NULL,
4518
`c2` decimal(10,0) NOT NULL,
4519
`c3` int(11) DEFAULT NULL,
4520
`c4` varchar(10) NOT NULL
4521
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4522
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4526
SHOW CREATE TABLE t1;
4528
t1 CREATE TABLE `t1` (
4529
`c1` tinyint(4) NOT NULL,
4530
`c2` decimal(10,0) NOT NULL,
4531
`c3` int(11) DEFAULT NULL,
4532
`c4` varchar(10) NOT NULL,
4533
PRIMARY KEY (`c1`,`c2`)
4534
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4538
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4542
SHOW CREATE TABLE t1;
4544
t1 CREATE TABLE `t1` (
4545
`c1` smallint(6) NOT NULL,
4546
`c2` decimal(10,0) NOT NULL,
4547
`c3` int(11) DEFAULT NULL,
4548
`c4` varchar(10) NOT NULL
4549
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4550
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4554
SHOW CREATE TABLE t1;
4556
t1 CREATE TABLE `t1` (
4557
`c1` smallint(6) NOT NULL,
4558
`c2` decimal(10,0) NOT NULL,
4559
`c3` int(11) DEFAULT NULL,
4560
`c4` varchar(10) NOT NULL,
4561
PRIMARY KEY (`c1`,`c2`)
4562
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4566
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4570
SHOW CREATE TABLE t1;
4572
t1 CREATE TABLE `t1` (
4573
`c1` mediumint(9) NOT NULL,
4574
`c2` decimal(10,0) NOT NULL,
4575
`c3` int(11) DEFAULT NULL,
4576
`c4` varchar(10) NOT NULL
4577
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4578
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4582
SHOW CREATE TABLE t1;
4584
t1 CREATE TABLE `t1` (
4585
`c1` mediumint(9) NOT NULL,
4586
`c2` decimal(10,0) NOT NULL,
4587
`c3` int(11) DEFAULT NULL,
4588
`c4` varchar(10) NOT NULL,
4589
PRIMARY KEY (`c1`,`c2`)
4590
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4594
CREATE TABLE t1(c1 INT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4598
SHOW CREATE TABLE t1;
4600
t1 CREATE TABLE `t1` (
4601
`c1` int(11) NOT NULL,
4602
`c2` decimal(10,0) NOT NULL,
4603
`c3` int(11) DEFAULT NULL,
4604
`c4` varchar(10) NOT NULL
4605
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4606
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4610
SHOW CREATE TABLE t1;
4612
t1 CREATE TABLE `t1` (
4613
`c1` int(11) NOT NULL,
4614
`c2` decimal(10,0) NOT NULL,
4615
`c3` int(11) DEFAULT NULL,
4616
`c4` varchar(10) NOT NULL,
4617
PRIMARY KEY (`c1`,`c2`)
4618
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4622
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4626
SHOW CREATE TABLE t1;
4628
t1 CREATE TABLE `t1` (
4629
`c1` int(11) NOT NULL,
4630
`c2` decimal(10,0) NOT NULL,
4631
`c3` int(11) DEFAULT NULL,
4632
`c4` varchar(10) NOT NULL
4633
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4634
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4638
SHOW CREATE TABLE t1;
4640
t1 CREATE TABLE `t1` (
4641
`c1` int(11) NOT NULL,
4642
`c2` decimal(10,0) NOT NULL,
4643
`c3` int(11) DEFAULT NULL,
4644
`c4` varchar(10) NOT NULL,
4645
PRIMARY KEY (`c1`,`c2`)
4646
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4650
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4654
SHOW CREATE TABLE t1;
4656
t1 CREATE TABLE `t1` (
4657
`c1` bigint(20) NOT NULL,
4658
`c2` decimal(10,0) NOT NULL,
4659
`c3` int(11) DEFAULT NULL,
4660
`c4` varchar(10) NOT NULL
4661
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4662
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4666
SHOW CREATE TABLE t1;
4668
t1 CREATE TABLE `t1` (
4669
`c1` bigint(20) NOT NULL,
4670
`c2` decimal(10,0) NOT NULL,
4671
`c3` int(11) DEFAULT NULL,
4672
`c4` varchar(10) NOT NULL,
4673
PRIMARY KEY (`c1`,`c2`)
4674
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4678
CREATE TABLE t1(c1 REAL NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4682
SHOW CREATE TABLE t1;
4684
t1 CREATE TABLE `t1` (
4685
`c1` double NOT NULL,
4686
`c2` decimal(10,0) NOT NULL,
4687
`c3` int(11) DEFAULT NULL,
4688
`c4` varchar(10) NOT NULL
4689
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4690
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4694
SHOW CREATE TABLE t1;
4696
t1 CREATE TABLE `t1` (
4697
`c1` double NOT NULL,
4698
`c2` decimal(10,0) NOT NULL,
4699
`c3` int(11) DEFAULT NULL,
4700
`c4` varchar(10) NOT NULL,
4701
PRIMARY KEY (`c1`,`c2`)
4702
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4706
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4710
SHOW CREATE TABLE t1;
4712
t1 CREATE TABLE `t1` (
4713
`c1` double NOT NULL,
4714
`c2` decimal(10,0) NOT NULL,
4715
`c3` int(11) DEFAULT NULL,
4716
`c4` varchar(10) NOT NULL
4717
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4718
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4722
SHOW CREATE TABLE t1;
4724
t1 CREATE TABLE `t1` (
4725
`c1` double NOT NULL,
4726
`c2` decimal(10,0) NOT NULL,
4727
`c3` int(11) DEFAULT NULL,
4728
`c4` varchar(10) NOT NULL,
4729
PRIMARY KEY (`c1`,`c2`)
4730
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4734
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4738
SHOW CREATE TABLE t1;
4740
t1 CREATE TABLE `t1` (
4741
`c1` float NOT NULL,
4742
`c2` decimal(10,0) NOT NULL,
4743
`c3` int(11) DEFAULT NULL,
4744
`c4` varchar(10) NOT NULL
4745
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4746
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4750
SHOW CREATE TABLE t1;
4752
t1 CREATE TABLE `t1` (
4753
`c1` float NOT NULL,
4754
`c2` decimal(10,0) NOT NULL,
4755
`c3` int(11) DEFAULT NULL,
4756
`c4` varchar(10) NOT NULL,
4757
PRIMARY KEY (`c1`,`c2`)
4758
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4762
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4766
SHOW CREATE TABLE t1;
4768
t1 CREATE TABLE `t1` (
4769
`c1` decimal(10,0) NOT NULL,
4770
`c2` decimal(10,0) NOT NULL,
4771
`c3` int(11) DEFAULT NULL,
4772
`c4` varchar(10) NOT NULL
4773
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4774
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4778
SHOW CREATE TABLE t1;
4780
t1 CREATE TABLE `t1` (
4781
`c1` decimal(10,0) NOT NULL,
4782
`c2` decimal(10,0) NOT NULL,
4783
`c3` int(11) DEFAULT NULL,
4784
`c4` varchar(10) NOT NULL,
4785
PRIMARY KEY (`c1`,`c2`)
4786
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4790
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4794
SHOW CREATE TABLE t1;
4796
t1 CREATE TABLE `t1` (
4797
`c1` decimal(10,0) NOT NULL,
4798
`c2` decimal(10,0) NOT NULL,
4799
`c3` int(11) DEFAULT NULL,
4800
`c4` varchar(10) NOT NULL
4801
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4802
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4806
SHOW CREATE TABLE t1;
4808
t1 CREATE TABLE `t1` (
4809
`c1` decimal(10,0) NOT NULL,
4810
`c2` decimal(10,0) NOT NULL,
4811
`c3` int(11) DEFAULT NULL,
4812
`c4` varchar(10) NOT NULL,
4813
PRIMARY KEY (`c1`,`c2`)
4814
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4818
CREATE TABLE t1(c1 DATE NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4822
SHOW CREATE TABLE t1;
4824
t1 CREATE TABLE `t1` (
4826
`c2` decimal(10,0) NOT NULL,
4827
`c3` int(11) DEFAULT NULL,
4828
`c4` varchar(10) NOT NULL
4829
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4830
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4834
SHOW CREATE TABLE t1;
4836
t1 CREATE TABLE `t1` (
4838
`c2` decimal(10,0) NOT NULL,
4839
`c3` int(11) DEFAULT NULL,
4840
`c4` varchar(10) NOT NULL,
4841
PRIMARY KEY (`c1`,`c2`)
4842
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4846
CREATE TABLE t1(c1 TIME NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4850
SHOW CREATE TABLE t1;
4852
t1 CREATE TABLE `t1` (
4854
`c2` decimal(10,0) NOT NULL,
4855
`c3` int(11) DEFAULT NULL,
4856
`c4` varchar(10) NOT NULL
4857
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4858
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4862
SHOW CREATE TABLE t1;
4864
t1 CREATE TABLE `t1` (
4866
`c2` decimal(10,0) NOT NULL,
4867
`c3` int(11) DEFAULT NULL,
4868
`c4` varchar(10) NOT NULL,
4869
PRIMARY KEY (`c1`,`c2`)
4870
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4874
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4878
SHOW CREATE TABLE t1;
4880
t1 CREATE TABLE `t1` (
4881
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4882
`c2` decimal(10,0) NOT NULL,
4883
`c3` int(11) DEFAULT NULL,
4884
`c4` varchar(10) NOT NULL
4885
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4886
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4890
SHOW CREATE TABLE t1;
4892
t1 CREATE TABLE `t1` (
4893
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4894
`c2` decimal(10,0) NOT NULL,
4895
`c3` int(11) DEFAULT NULL,
4896
`c4` varchar(10) NOT NULL,
4897
PRIMARY KEY (`c1`,`c2`)
4898
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4902
CREATE TABLE t1(c1 YEAR NOT NULL, c2 DECIMAL NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4906
SHOW CREATE TABLE t1;
4908
t1 CREATE TABLE `t1` (
4909
`c1` year(4) NOT NULL,
4910
`c2` decimal(10,0) NOT NULL,
4911
`c3` int(11) DEFAULT NULL,
4912
`c4` varchar(10) NOT NULL
4913
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4914
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4918
SHOW CREATE TABLE t1;
4920
t1 CREATE TABLE `t1` (
4921
`c1` year(4) NOT NULL,
4922
`c2` decimal(10,0) NOT NULL,
4923
`c3` int(11) DEFAULT NULL,
4924
`c4` varchar(10) NOT NULL,
4925
PRIMARY KEY (`c1`,`c2`)
4926
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4930
CREATE TABLE t1(c1 BIT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4934
SHOW CREATE TABLE t1;
4936
t1 CREATE TABLE `t1` (
4937
`c1` bit(1) NOT NULL,
4938
`c2` decimal(10,0) NOT NULL,
4939
`c3` int(11) DEFAULT NULL,
4940
`c4` varchar(10) NOT NULL
4941
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4942
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4946
SHOW CREATE TABLE t1;
4948
t1 CREATE TABLE `t1` (
4949
`c1` bit(1) NOT NULL,
4950
`c2` decimal(10,0) NOT NULL,
4951
`c3` int(11) DEFAULT NULL,
4952
`c4` varchar(10) NOT NULL,
4953
PRIMARY KEY (`c1`,`c2`)
4954
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4958
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4962
SHOW CREATE TABLE t1;
4964
t1 CREATE TABLE `t1` (
4965
`c1` tinyint(4) NOT NULL,
4966
`c2` decimal(10,0) NOT NULL,
4967
`c3` int(11) DEFAULT NULL,
4968
`c4` varchar(10) NOT NULL
4969
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4970
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
4974
SHOW CREATE TABLE t1;
4976
t1 CREATE TABLE `t1` (
4977
`c1` tinyint(4) NOT NULL,
4978
`c2` decimal(10,0) NOT NULL,
4979
`c3` int(11) DEFAULT NULL,
4980
`c4` varchar(10) NOT NULL,
4981
PRIMARY KEY (`c1`,`c2`)
4982
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4986
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
4990
SHOW CREATE TABLE t1;
4992
t1 CREATE TABLE `t1` (
4993
`c1` smallint(6) NOT NULL,
4994
`c2` decimal(10,0) NOT NULL,
4995
`c3` int(11) DEFAULT NULL,
4996
`c4` varchar(10) NOT NULL
4997
) ENGINE=ENGINE DEFAULT CHARSET=latin1
4998
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5002
SHOW CREATE TABLE t1;
5004
t1 CREATE TABLE `t1` (
5005
`c1` smallint(6) NOT NULL,
5006
`c2` decimal(10,0) NOT NULL,
5007
`c3` int(11) DEFAULT NULL,
5008
`c4` varchar(10) NOT NULL,
5009
PRIMARY KEY (`c1`,`c2`)
5010
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5014
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5018
SHOW CREATE TABLE t1;
5020
t1 CREATE TABLE `t1` (
5021
`c1` mediumint(9) NOT NULL,
5022
`c2` decimal(10,0) NOT NULL,
5023
`c3` int(11) DEFAULT NULL,
5024
`c4` varchar(10) NOT NULL
5025
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5026
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5030
SHOW CREATE TABLE t1;
5032
t1 CREATE TABLE `t1` (
5033
`c1` mediumint(9) NOT NULL,
5034
`c2` decimal(10,0) NOT NULL,
5035
`c3` int(11) DEFAULT NULL,
5036
`c4` varchar(10) NOT NULL,
5037
PRIMARY KEY (`c1`,`c2`)
5038
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5042
CREATE TABLE t1(c1 INT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5046
SHOW CREATE TABLE t1;
5048
t1 CREATE TABLE `t1` (
5049
`c1` int(11) NOT NULL,
5050
`c2` decimal(10,0) NOT NULL,
5051
`c3` int(11) DEFAULT NULL,
5052
`c4` varchar(10) NOT NULL
5053
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5054
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5058
SHOW CREATE TABLE t1;
5060
t1 CREATE TABLE `t1` (
5061
`c1` int(11) NOT NULL,
5062
`c2` decimal(10,0) NOT NULL,
5063
`c3` int(11) DEFAULT NULL,
5064
`c4` varchar(10) NOT NULL,
5065
PRIMARY KEY (`c1`,`c2`)
5066
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5070
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5074
SHOW CREATE TABLE t1;
5076
t1 CREATE TABLE `t1` (
5077
`c1` int(11) NOT NULL,
5078
`c2` decimal(10,0) NOT NULL,
5079
`c3` int(11) DEFAULT NULL,
5080
`c4` varchar(10) NOT NULL
5081
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5082
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5086
SHOW CREATE TABLE t1;
5088
t1 CREATE TABLE `t1` (
5089
`c1` int(11) NOT NULL,
5090
`c2` decimal(10,0) NOT NULL,
5091
`c3` int(11) DEFAULT NULL,
5092
`c4` varchar(10) NOT NULL,
5093
PRIMARY KEY (`c1`,`c2`)
5094
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5098
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5102
SHOW CREATE TABLE t1;
5104
t1 CREATE TABLE `t1` (
5105
`c1` bigint(20) NOT NULL,
5106
`c2` decimal(10,0) NOT NULL,
5107
`c3` int(11) DEFAULT NULL,
5108
`c4` varchar(10) NOT NULL
5109
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5110
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5114
SHOW CREATE TABLE t1;
5116
t1 CREATE TABLE `t1` (
5117
`c1` bigint(20) NOT NULL,
5118
`c2` decimal(10,0) NOT NULL,
5119
`c3` int(11) DEFAULT NULL,
5120
`c4` varchar(10) NOT NULL,
5121
PRIMARY KEY (`c1`,`c2`)
5122
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5126
CREATE TABLE t1(c1 REAL NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5130
SHOW CREATE TABLE t1;
5132
t1 CREATE TABLE `t1` (
5133
`c1` double NOT NULL,
5134
`c2` decimal(10,0) NOT NULL,
5135
`c3` int(11) DEFAULT NULL,
5136
`c4` varchar(10) NOT NULL
5137
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5138
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5142
SHOW CREATE TABLE t1;
5144
t1 CREATE TABLE `t1` (
5145
`c1` double NOT NULL,
5146
`c2` decimal(10,0) NOT NULL,
5147
`c3` int(11) DEFAULT NULL,
5148
`c4` varchar(10) NOT NULL,
5149
PRIMARY KEY (`c1`,`c2`)
5150
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5154
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5158
SHOW CREATE TABLE t1;
5160
t1 CREATE TABLE `t1` (
5161
`c1` double NOT NULL,
5162
`c2` decimal(10,0) NOT NULL,
5163
`c3` int(11) DEFAULT NULL,
5164
`c4` varchar(10) NOT NULL
5165
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5166
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5170
SHOW CREATE TABLE t1;
5172
t1 CREATE TABLE `t1` (
5173
`c1` double NOT NULL,
5174
`c2` decimal(10,0) NOT NULL,
5175
`c3` int(11) DEFAULT NULL,
5176
`c4` varchar(10) NOT NULL,
5177
PRIMARY KEY (`c1`,`c2`)
5178
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5182
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5186
SHOW CREATE TABLE t1;
5188
t1 CREATE TABLE `t1` (
5189
`c1` float NOT NULL,
5190
`c2` decimal(10,0) NOT NULL,
5191
`c3` int(11) DEFAULT NULL,
5192
`c4` varchar(10) NOT NULL
5193
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5194
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5198
SHOW CREATE TABLE t1;
5200
t1 CREATE TABLE `t1` (
5201
`c1` float NOT NULL,
5202
`c2` decimal(10,0) NOT NULL,
5203
`c3` int(11) DEFAULT NULL,
5204
`c4` varchar(10) NOT NULL,
5205
PRIMARY KEY (`c1`,`c2`)
5206
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5210
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5214
SHOW CREATE TABLE t1;
5216
t1 CREATE TABLE `t1` (
5217
`c1` decimal(10,0) NOT NULL,
5218
`c2` decimal(10,0) NOT NULL,
5219
`c3` int(11) DEFAULT NULL,
5220
`c4` varchar(10) NOT NULL
5221
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5222
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5226
SHOW CREATE TABLE t1;
5228
t1 CREATE TABLE `t1` (
5229
`c1` decimal(10,0) NOT NULL,
5230
`c2` decimal(10,0) NOT NULL,
5231
`c3` int(11) DEFAULT NULL,
5232
`c4` varchar(10) NOT NULL,
5233
PRIMARY KEY (`c1`,`c2`)
5234
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5238
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5242
SHOW CREATE TABLE t1;
5244
t1 CREATE TABLE `t1` (
5245
`c1` decimal(10,0) NOT NULL,
5246
`c2` decimal(10,0) NOT NULL,
5247
`c3` int(11) DEFAULT NULL,
5248
`c4` varchar(10) NOT NULL
5249
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5250
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5254
SHOW CREATE TABLE t1;
5256
t1 CREATE TABLE `t1` (
5257
`c1` decimal(10,0) NOT NULL,
5258
`c2` decimal(10,0) NOT NULL,
5259
`c3` int(11) DEFAULT NULL,
5260
`c4` varchar(10) NOT NULL,
5261
PRIMARY KEY (`c1`,`c2`)
5262
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5266
CREATE TABLE t1(c1 DATE NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5270
SHOW CREATE TABLE t1;
5272
t1 CREATE TABLE `t1` (
5274
`c2` decimal(10,0) NOT NULL,
5275
`c3` int(11) DEFAULT NULL,
5276
`c4` varchar(10) NOT NULL
5277
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5278
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5282
SHOW CREATE TABLE t1;
5284
t1 CREATE TABLE `t1` (
5286
`c2` decimal(10,0) NOT NULL,
5287
`c3` int(11) DEFAULT NULL,
5288
`c4` varchar(10) NOT NULL,
5289
PRIMARY KEY (`c1`,`c2`)
5290
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5294
CREATE TABLE t1(c1 TIME NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5298
SHOW CREATE TABLE t1;
5300
t1 CREATE TABLE `t1` (
5302
`c2` decimal(10,0) NOT NULL,
5303
`c3` int(11) DEFAULT NULL,
5304
`c4` varchar(10) NOT NULL
5305
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5306
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5310
SHOW CREATE TABLE t1;
5312
t1 CREATE TABLE `t1` (
5314
`c2` decimal(10,0) NOT NULL,
5315
`c3` int(11) DEFAULT NULL,
5316
`c4` varchar(10) NOT NULL,
5317
PRIMARY KEY (`c1`,`c2`)
5318
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5322
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5326
SHOW CREATE TABLE t1;
5328
t1 CREATE TABLE `t1` (
5329
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
5330
`c2` decimal(10,0) NOT NULL,
5331
`c3` int(11) DEFAULT NULL,
5332
`c4` varchar(10) NOT NULL
5333
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5334
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5338
SHOW CREATE TABLE t1;
5340
t1 CREATE TABLE `t1` (
5341
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
5342
`c2` decimal(10,0) NOT NULL,
5343
`c3` int(11) DEFAULT NULL,
5344
`c4` varchar(10) NOT NULL,
5345
PRIMARY KEY (`c1`,`c2`)
5346
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5350
CREATE TABLE t1(c1 YEAR NOT NULL, c2 NUMERIC NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5354
SHOW CREATE TABLE t1;
5356
t1 CREATE TABLE `t1` (
5357
`c1` year(4) NOT NULL,
5358
`c2` decimal(10,0) NOT NULL,
5359
`c3` int(11) DEFAULT NULL,
5360
`c4` varchar(10) NOT NULL
5361
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5362
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5366
SHOW CREATE TABLE t1;
5368
t1 CREATE TABLE `t1` (
5369
`c1` year(4) NOT NULL,
5370
`c2` decimal(10,0) NOT NULL,
5371
`c3` int(11) DEFAULT NULL,
5372
`c4` varchar(10) NOT NULL,
5373
PRIMARY KEY (`c1`,`c2`)
5374
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5378
CREATE TABLE t1(c1 BIT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5382
SHOW CREATE TABLE t1;
5384
t1 CREATE TABLE `t1` (
5385
`c1` bit(1) NOT NULL,
5387
`c3` int(11) DEFAULT NULL,
5388
`c4` varchar(10) NOT NULL
5389
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5390
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5394
SHOW CREATE TABLE t1;
5396
t1 CREATE TABLE `t1` (
5397
`c1` bit(1) NOT NULL,
5399
`c3` int(11) DEFAULT NULL,
5400
`c4` varchar(10) NOT NULL,
5401
PRIMARY KEY (`c1`,`c2`)
5402
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5406
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5410
SHOW CREATE TABLE t1;
5412
t1 CREATE TABLE `t1` (
5413
`c1` tinyint(4) NOT NULL,
5415
`c3` int(11) DEFAULT NULL,
5416
`c4` varchar(10) NOT NULL
5417
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5418
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5422
SHOW CREATE TABLE t1;
5424
t1 CREATE TABLE `t1` (
5425
`c1` tinyint(4) NOT NULL,
5427
`c3` int(11) DEFAULT NULL,
5428
`c4` varchar(10) NOT NULL,
5429
PRIMARY KEY (`c1`,`c2`)
5430
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5434
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5438
SHOW CREATE TABLE t1;
5440
t1 CREATE TABLE `t1` (
5441
`c1` smallint(6) NOT NULL,
5443
`c3` int(11) DEFAULT NULL,
5444
`c4` varchar(10) NOT NULL
5445
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5446
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5450
SHOW CREATE TABLE t1;
5452
t1 CREATE TABLE `t1` (
5453
`c1` smallint(6) NOT NULL,
5455
`c3` int(11) DEFAULT NULL,
5456
`c4` varchar(10) NOT NULL,
5457
PRIMARY KEY (`c1`,`c2`)
5458
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5462
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5466
SHOW CREATE TABLE t1;
5468
t1 CREATE TABLE `t1` (
5469
`c1` mediumint(9) NOT NULL,
5471
`c3` int(11) DEFAULT NULL,
5472
`c4` varchar(10) NOT NULL
5473
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5474
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5478
SHOW CREATE TABLE t1;
5480
t1 CREATE TABLE `t1` (
5481
`c1` mediumint(9) NOT NULL,
5483
`c3` int(11) DEFAULT NULL,
5484
`c4` varchar(10) NOT NULL,
5485
PRIMARY KEY (`c1`,`c2`)
5486
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5490
CREATE TABLE t1(c1 INT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5494
SHOW CREATE TABLE t1;
5496
t1 CREATE TABLE `t1` (
5497
`c1` int(11) NOT NULL,
5499
`c3` int(11) DEFAULT NULL,
5500
`c4` varchar(10) NOT NULL
5501
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5502
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5506
SHOW CREATE TABLE t1;
5508
t1 CREATE TABLE `t1` (
5509
`c1` int(11) NOT NULL,
5511
`c3` int(11) DEFAULT NULL,
5512
`c4` varchar(10) NOT NULL,
5513
PRIMARY KEY (`c1`,`c2`)
5514
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5518
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5522
SHOW CREATE TABLE t1;
5524
t1 CREATE TABLE `t1` (
5525
`c1` int(11) NOT NULL,
5527
`c3` int(11) DEFAULT NULL,
5528
`c4` varchar(10) NOT NULL
5529
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5530
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5534
SHOW CREATE TABLE t1;
5536
t1 CREATE TABLE `t1` (
5537
`c1` int(11) NOT NULL,
5539
`c3` int(11) DEFAULT NULL,
5540
`c4` varchar(10) NOT NULL,
5541
PRIMARY KEY (`c1`,`c2`)
5542
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5546
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5550
SHOW CREATE TABLE t1;
5552
t1 CREATE TABLE `t1` (
5553
`c1` bigint(20) NOT NULL,
5555
`c3` int(11) DEFAULT NULL,
5556
`c4` varchar(10) NOT NULL
5557
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5558
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5562
SHOW CREATE TABLE t1;
5564
t1 CREATE TABLE `t1` (
5565
`c1` bigint(20) NOT NULL,
5567
`c3` int(11) DEFAULT NULL,
5568
`c4` varchar(10) NOT NULL,
5569
PRIMARY KEY (`c1`,`c2`)
5570
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5574
CREATE TABLE t1(c1 REAL NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5578
SHOW CREATE TABLE t1;
5580
t1 CREATE TABLE `t1` (
5581
`c1` double NOT NULL,
5583
`c3` int(11) DEFAULT NULL,
5584
`c4` varchar(10) NOT NULL
5585
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5586
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5590
SHOW CREATE TABLE t1;
5592
t1 CREATE TABLE `t1` (
5593
`c1` double NOT NULL,
5595
`c3` int(11) DEFAULT NULL,
5596
`c4` varchar(10) NOT NULL,
5597
PRIMARY KEY (`c1`,`c2`)
5598
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5602
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5606
SHOW CREATE TABLE t1;
5608
t1 CREATE TABLE `t1` (
5609
`c1` double NOT NULL,
5611
`c3` int(11) DEFAULT NULL,
5612
`c4` varchar(10) NOT NULL
5613
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5614
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5618
SHOW CREATE TABLE t1;
5620
t1 CREATE TABLE `t1` (
5621
`c1` double NOT NULL,
5623
`c3` int(11) DEFAULT NULL,
5624
`c4` varchar(10) NOT NULL,
5625
PRIMARY KEY (`c1`,`c2`)
5626
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5630
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5634
SHOW CREATE TABLE t1;
5636
t1 CREATE TABLE `t1` (
5637
`c1` float NOT NULL,
5639
`c3` int(11) DEFAULT NULL,
5640
`c4` varchar(10) NOT NULL
5641
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5642
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5646
SHOW CREATE TABLE t1;
5648
t1 CREATE TABLE `t1` (
5649
`c1` float NOT NULL,
5651
`c3` int(11) DEFAULT NULL,
5652
`c4` varchar(10) NOT NULL,
5653
PRIMARY KEY (`c1`,`c2`)
5654
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5658
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5662
SHOW CREATE TABLE t1;
5664
t1 CREATE TABLE `t1` (
5665
`c1` decimal(10,0) NOT NULL,
5667
`c3` int(11) DEFAULT NULL,
5668
`c4` varchar(10) NOT NULL
5669
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5670
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5674
SHOW CREATE TABLE t1;
5676
t1 CREATE TABLE `t1` (
5677
`c1` decimal(10,0) NOT NULL,
5679
`c3` int(11) DEFAULT NULL,
5680
`c4` varchar(10) NOT NULL,
5681
PRIMARY KEY (`c1`,`c2`)
5682
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5686
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5690
SHOW CREATE TABLE t1;
5692
t1 CREATE TABLE `t1` (
5693
`c1` decimal(10,0) NOT NULL,
5695
`c3` int(11) DEFAULT NULL,
5696
`c4` varchar(10) NOT NULL
5697
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5698
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5702
SHOW CREATE TABLE t1;
5704
t1 CREATE TABLE `t1` (
5705
`c1` decimal(10,0) NOT NULL,
5707
`c3` int(11) DEFAULT NULL,
5708
`c4` varchar(10) NOT NULL,
5709
PRIMARY KEY (`c1`,`c2`)
5710
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5714
CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5718
SHOW CREATE TABLE t1;
5720
t1 CREATE TABLE `t1` (
5723
`c3` int(11) DEFAULT NULL,
5724
`c4` varchar(10) NOT NULL
5725
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5726
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5730
SHOW CREATE TABLE t1;
5732
t1 CREATE TABLE `t1` (
5735
`c3` int(11) DEFAULT NULL,
5736
`c4` varchar(10) NOT NULL,
5737
PRIMARY KEY (`c1`,`c2`)
5738
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5742
CREATE TABLE t1(c1 TIME NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5746
SHOW CREATE TABLE t1;
5748
t1 CREATE TABLE `t1` (
5751
`c3` int(11) DEFAULT NULL,
5752
`c4` varchar(10) NOT NULL
5753
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5754
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5758
SHOW CREATE TABLE t1;
5760
t1 CREATE TABLE `t1` (
5763
`c3` int(11) DEFAULT NULL,
5764
`c4` varchar(10) NOT NULL,
5765
PRIMARY KEY (`c1`,`c2`)
5766
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5770
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5774
SHOW CREATE TABLE t1;
5776
t1 CREATE TABLE `t1` (
5777
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
5779
`c3` int(11) DEFAULT NULL,
5780
`c4` varchar(10) NOT NULL
5781
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5782
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5786
SHOW CREATE TABLE t1;
5788
t1 CREATE TABLE `t1` (
5789
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
5791
`c3` int(11) DEFAULT NULL,
5792
`c4` varchar(10) NOT NULL,
5793
PRIMARY KEY (`c1`,`c2`)
5794
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5798
CREATE TABLE t1(c1 YEAR NOT NULL, c2 DATE NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5802
SHOW CREATE TABLE t1;
5804
t1 CREATE TABLE `t1` (
5805
`c1` year(4) NOT NULL,
5807
`c3` int(11) DEFAULT NULL,
5808
`c4` varchar(10) NOT NULL
5809
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5810
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5814
SHOW CREATE TABLE t1;
5816
t1 CREATE TABLE `t1` (
5817
`c1` year(4) NOT NULL,
5819
`c3` int(11) DEFAULT NULL,
5820
`c4` varchar(10) NOT NULL,
5821
PRIMARY KEY (`c1`,`c2`)
5822
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5826
CREATE TABLE t1(c1 BIT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5830
SHOW CREATE TABLE t1;
5832
t1 CREATE TABLE `t1` (
5833
`c1` bit(1) NOT NULL,
5835
`c3` int(11) DEFAULT NULL,
5836
`c4` varchar(10) NOT NULL
5837
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5838
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5842
SHOW CREATE TABLE t1;
5844
t1 CREATE TABLE `t1` (
5845
`c1` bit(1) NOT NULL,
5847
`c3` int(11) DEFAULT NULL,
5848
`c4` varchar(10) NOT NULL,
5849
PRIMARY KEY (`c1`,`c2`)
5850
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5854
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5858
SHOW CREATE TABLE t1;
5860
t1 CREATE TABLE `t1` (
5861
`c1` tinyint(4) NOT NULL,
5863
`c3` int(11) DEFAULT NULL,
5864
`c4` varchar(10) NOT NULL
5865
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5866
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5870
SHOW CREATE TABLE t1;
5872
t1 CREATE TABLE `t1` (
5873
`c1` tinyint(4) NOT NULL,
5875
`c3` int(11) DEFAULT NULL,
5876
`c4` varchar(10) NOT NULL,
5877
PRIMARY KEY (`c1`,`c2`)
5878
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5882
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5886
SHOW CREATE TABLE t1;
5888
t1 CREATE TABLE `t1` (
5889
`c1` smallint(6) NOT NULL,
5891
`c3` int(11) DEFAULT NULL,
5892
`c4` varchar(10) NOT NULL
5893
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5894
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5898
SHOW CREATE TABLE t1;
5900
t1 CREATE TABLE `t1` (
5901
`c1` smallint(6) NOT NULL,
5903
`c3` int(11) DEFAULT NULL,
5904
`c4` varchar(10) NOT NULL,
5905
PRIMARY KEY (`c1`,`c2`)
5906
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5910
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5914
SHOW CREATE TABLE t1;
5916
t1 CREATE TABLE `t1` (
5917
`c1` mediumint(9) NOT NULL,
5919
`c3` int(11) DEFAULT NULL,
5920
`c4` varchar(10) NOT NULL
5921
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5922
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5926
SHOW CREATE TABLE t1;
5928
t1 CREATE TABLE `t1` (
5929
`c1` mediumint(9) NOT NULL,
5931
`c3` int(11) DEFAULT NULL,
5932
`c4` varchar(10) NOT NULL,
5933
PRIMARY KEY (`c1`,`c2`)
5934
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5938
CREATE TABLE t1(c1 INT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5942
SHOW CREATE TABLE t1;
5944
t1 CREATE TABLE `t1` (
5945
`c1` int(11) NOT NULL,
5947
`c3` int(11) DEFAULT NULL,
5948
`c4` varchar(10) NOT NULL
5949
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5950
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5954
SHOW CREATE TABLE t1;
5956
t1 CREATE TABLE `t1` (
5957
`c1` int(11) NOT NULL,
5959
`c3` int(11) DEFAULT NULL,
5960
`c4` varchar(10) NOT NULL,
5961
PRIMARY KEY (`c1`,`c2`)
5962
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5966
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5970
SHOW CREATE TABLE t1;
5972
t1 CREATE TABLE `t1` (
5973
`c1` int(11) NOT NULL,
5975
`c3` int(11) DEFAULT NULL,
5976
`c4` varchar(10) NOT NULL
5977
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5978
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
5982
SHOW CREATE TABLE t1;
5984
t1 CREATE TABLE `t1` (
5985
`c1` int(11) NOT NULL,
5987
`c3` int(11) DEFAULT NULL,
5988
`c4` varchar(10) NOT NULL,
5989
PRIMARY KEY (`c1`,`c2`)
5990
) ENGINE=ENGINE DEFAULT CHARSET=latin1
5994
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
5998
SHOW CREATE TABLE t1;
6000
t1 CREATE TABLE `t1` (
6001
`c1` bigint(20) NOT NULL,
6003
`c3` int(11) DEFAULT NULL,
6004
`c4` varchar(10) NOT NULL
6005
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6006
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6010
SHOW CREATE TABLE t1;
6012
t1 CREATE TABLE `t1` (
6013
`c1` bigint(20) NOT NULL,
6015
`c3` int(11) DEFAULT NULL,
6016
`c4` varchar(10) NOT NULL,
6017
PRIMARY KEY (`c1`,`c2`)
6018
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6022
CREATE TABLE t1(c1 REAL NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6026
SHOW CREATE TABLE t1;
6028
t1 CREATE TABLE `t1` (
6029
`c1` double NOT NULL,
6031
`c3` int(11) DEFAULT NULL,
6032
`c4` varchar(10) NOT NULL
6033
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6034
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6038
SHOW CREATE TABLE t1;
6040
t1 CREATE TABLE `t1` (
6041
`c1` double NOT NULL,
6043
`c3` int(11) DEFAULT NULL,
6044
`c4` varchar(10) NOT NULL,
6045
PRIMARY KEY (`c1`,`c2`)
6046
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6050
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6054
SHOW CREATE TABLE t1;
6056
t1 CREATE TABLE `t1` (
6057
`c1` double NOT NULL,
6059
`c3` int(11) DEFAULT NULL,
6060
`c4` varchar(10) NOT NULL
6061
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6062
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6066
SHOW CREATE TABLE t1;
6068
t1 CREATE TABLE `t1` (
6069
`c1` double NOT NULL,
6071
`c3` int(11) DEFAULT NULL,
6072
`c4` varchar(10) NOT NULL,
6073
PRIMARY KEY (`c1`,`c2`)
6074
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6078
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6082
SHOW CREATE TABLE t1;
6084
t1 CREATE TABLE `t1` (
6085
`c1` float NOT NULL,
6087
`c3` int(11) DEFAULT NULL,
6088
`c4` varchar(10) NOT NULL
6089
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6090
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6094
SHOW CREATE TABLE t1;
6096
t1 CREATE TABLE `t1` (
6097
`c1` float NOT NULL,
6099
`c3` int(11) DEFAULT NULL,
6100
`c4` varchar(10) NOT NULL,
6101
PRIMARY KEY (`c1`,`c2`)
6102
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6106
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6110
SHOW CREATE TABLE t1;
6112
t1 CREATE TABLE `t1` (
6113
`c1` decimal(10,0) NOT NULL,
6115
`c3` int(11) DEFAULT NULL,
6116
`c4` varchar(10) NOT NULL
6117
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6118
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6122
SHOW CREATE TABLE t1;
6124
t1 CREATE TABLE `t1` (
6125
`c1` decimal(10,0) NOT NULL,
6127
`c3` int(11) DEFAULT NULL,
6128
`c4` varchar(10) NOT NULL,
6129
PRIMARY KEY (`c1`,`c2`)
6130
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6134
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6138
SHOW CREATE TABLE t1;
6140
t1 CREATE TABLE `t1` (
6141
`c1` decimal(10,0) NOT NULL,
6143
`c3` int(11) DEFAULT NULL,
6144
`c4` varchar(10) NOT NULL
6145
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6146
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6150
SHOW CREATE TABLE t1;
6152
t1 CREATE TABLE `t1` (
6153
`c1` decimal(10,0) NOT NULL,
6155
`c3` int(11) DEFAULT NULL,
6156
`c4` varchar(10) NOT NULL,
6157
PRIMARY KEY (`c1`,`c2`)
6158
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6162
CREATE TABLE t1(c1 DATE NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6166
SHOW CREATE TABLE t1;
6168
t1 CREATE TABLE `t1` (
6171
`c3` int(11) DEFAULT NULL,
6172
`c4` varchar(10) NOT NULL
6173
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6174
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6178
SHOW CREATE TABLE t1;
6180
t1 CREATE TABLE `t1` (
6183
`c3` int(11) DEFAULT NULL,
6184
`c4` varchar(10) NOT NULL,
6185
PRIMARY KEY (`c1`,`c2`)
6186
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6190
CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6194
SHOW CREATE TABLE t1;
6196
t1 CREATE TABLE `t1` (
6199
`c3` int(11) DEFAULT NULL,
6200
`c4` varchar(10) NOT NULL
6201
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6202
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6206
SHOW CREATE TABLE t1;
6208
t1 CREATE TABLE `t1` (
6211
`c3` int(11) DEFAULT NULL,
6212
`c4` varchar(10) NOT NULL,
6213
PRIMARY KEY (`c1`,`c2`)
6214
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6218
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6222
SHOW CREATE TABLE t1;
6224
t1 CREATE TABLE `t1` (
6225
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6227
`c3` int(11) DEFAULT NULL,
6228
`c4` varchar(10) NOT NULL
6229
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6230
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6234
SHOW CREATE TABLE t1;
6236
t1 CREATE TABLE `t1` (
6237
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6239
`c3` int(11) DEFAULT NULL,
6240
`c4` varchar(10) NOT NULL,
6241
PRIMARY KEY (`c1`,`c2`)
6242
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6246
CREATE TABLE t1(c1 YEAR NOT NULL, c2 TIME NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6250
SHOW CREATE TABLE t1;
6252
t1 CREATE TABLE `t1` (
6253
`c1` year(4) NOT NULL,
6255
`c3` int(11) DEFAULT NULL,
6256
`c4` varchar(10) NOT NULL
6257
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6258
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6262
SHOW CREATE TABLE t1;
6264
t1 CREATE TABLE `t1` (
6265
`c1` year(4) NOT NULL,
6267
`c3` int(11) DEFAULT NULL,
6268
`c4` varchar(10) NOT NULL,
6269
PRIMARY KEY (`c1`,`c2`)
6270
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6274
CREATE TABLE t1(c1 BIT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6278
SHOW CREATE TABLE t1;
6280
t1 CREATE TABLE `t1` (
6281
`c1` bit(1) NOT NULL,
6282
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6283
`c3` int(11) DEFAULT NULL,
6284
`c4` varchar(10) NOT NULL
6285
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6286
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6290
SHOW CREATE TABLE t1;
6292
t1 CREATE TABLE `t1` (
6293
`c1` bit(1) NOT NULL,
6294
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6295
`c3` int(11) DEFAULT NULL,
6296
`c4` varchar(10) NOT NULL,
6297
PRIMARY KEY (`c1`,`c2`)
6298
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6302
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6306
SHOW CREATE TABLE t1;
6308
t1 CREATE TABLE `t1` (
6309
`c1` tinyint(4) NOT NULL,
6310
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6311
`c3` int(11) DEFAULT NULL,
6312
`c4` varchar(10) NOT NULL
6313
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6314
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6318
SHOW CREATE TABLE t1;
6320
t1 CREATE TABLE `t1` (
6321
`c1` tinyint(4) NOT NULL,
6322
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6323
`c3` int(11) DEFAULT NULL,
6324
`c4` varchar(10) NOT NULL,
6325
PRIMARY KEY (`c1`,`c2`)
6326
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6330
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6334
SHOW CREATE TABLE t1;
6336
t1 CREATE TABLE `t1` (
6337
`c1` smallint(6) NOT NULL,
6338
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6339
`c3` int(11) DEFAULT NULL,
6340
`c4` varchar(10) NOT NULL
6341
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6342
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6346
SHOW CREATE TABLE t1;
6348
t1 CREATE TABLE `t1` (
6349
`c1` smallint(6) NOT NULL,
6350
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6351
`c3` int(11) DEFAULT NULL,
6352
`c4` varchar(10) NOT NULL,
6353
PRIMARY KEY (`c1`,`c2`)
6354
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6358
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6362
SHOW CREATE TABLE t1;
6364
t1 CREATE TABLE `t1` (
6365
`c1` mediumint(9) NOT NULL,
6366
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6367
`c3` int(11) DEFAULT NULL,
6368
`c4` varchar(10) NOT NULL
6369
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6370
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6374
SHOW CREATE TABLE t1;
6376
t1 CREATE TABLE `t1` (
6377
`c1` mediumint(9) NOT NULL,
6378
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6379
`c3` int(11) DEFAULT NULL,
6380
`c4` varchar(10) NOT NULL,
6381
PRIMARY KEY (`c1`,`c2`)
6382
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6386
CREATE TABLE t1(c1 INT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6390
SHOW CREATE TABLE t1;
6392
t1 CREATE TABLE `t1` (
6393
`c1` int(11) NOT NULL,
6394
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6395
`c3` int(11) DEFAULT NULL,
6396
`c4` varchar(10) NOT NULL
6397
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6398
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6402
SHOW CREATE TABLE t1;
6404
t1 CREATE TABLE `t1` (
6405
`c1` int(11) NOT NULL,
6406
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6407
`c3` int(11) DEFAULT NULL,
6408
`c4` varchar(10) NOT NULL,
6409
PRIMARY KEY (`c1`,`c2`)
6410
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6414
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6418
SHOW CREATE TABLE t1;
6420
t1 CREATE TABLE `t1` (
6421
`c1` int(11) NOT NULL,
6422
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6423
`c3` int(11) DEFAULT NULL,
6424
`c4` varchar(10) NOT NULL
6425
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6426
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6430
SHOW CREATE TABLE t1;
6432
t1 CREATE TABLE `t1` (
6433
`c1` int(11) NOT NULL,
6434
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6435
`c3` int(11) DEFAULT NULL,
6436
`c4` varchar(10) NOT NULL,
6437
PRIMARY KEY (`c1`,`c2`)
6438
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6442
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6446
SHOW CREATE TABLE t1;
6448
t1 CREATE TABLE `t1` (
6449
`c1` bigint(20) NOT NULL,
6450
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6451
`c3` int(11) DEFAULT NULL,
6452
`c4` varchar(10) NOT NULL
6453
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6454
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6458
SHOW CREATE TABLE t1;
6460
t1 CREATE TABLE `t1` (
6461
`c1` bigint(20) NOT NULL,
6462
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6463
`c3` int(11) DEFAULT NULL,
6464
`c4` varchar(10) NOT NULL,
6465
PRIMARY KEY (`c1`,`c2`)
6466
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6470
CREATE TABLE t1(c1 REAL NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6474
SHOW CREATE TABLE t1;
6476
t1 CREATE TABLE `t1` (
6477
`c1` double NOT NULL,
6478
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6479
`c3` int(11) DEFAULT NULL,
6480
`c4` varchar(10) NOT NULL
6481
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6482
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6486
SHOW CREATE TABLE t1;
6488
t1 CREATE TABLE `t1` (
6489
`c1` double NOT NULL,
6490
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6491
`c3` int(11) DEFAULT NULL,
6492
`c4` varchar(10) NOT NULL,
6493
PRIMARY KEY (`c1`,`c2`)
6494
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6498
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6502
SHOW CREATE TABLE t1;
6504
t1 CREATE TABLE `t1` (
6505
`c1` double NOT NULL,
6506
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6507
`c3` int(11) DEFAULT NULL,
6508
`c4` varchar(10) NOT NULL
6509
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6510
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6514
SHOW CREATE TABLE t1;
6516
t1 CREATE TABLE `t1` (
6517
`c1` double NOT NULL,
6518
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6519
`c3` int(11) DEFAULT NULL,
6520
`c4` varchar(10) NOT NULL,
6521
PRIMARY KEY (`c1`,`c2`)
6522
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6526
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6530
SHOW CREATE TABLE t1;
6532
t1 CREATE TABLE `t1` (
6533
`c1` float NOT NULL,
6534
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6535
`c3` int(11) DEFAULT NULL,
6536
`c4` varchar(10) NOT NULL
6537
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6538
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6542
SHOW CREATE TABLE t1;
6544
t1 CREATE TABLE `t1` (
6545
`c1` float NOT NULL,
6546
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6547
`c3` int(11) DEFAULT NULL,
6548
`c4` varchar(10) NOT NULL,
6549
PRIMARY KEY (`c1`,`c2`)
6550
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6554
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6558
SHOW CREATE TABLE t1;
6560
t1 CREATE TABLE `t1` (
6561
`c1` decimal(10,0) NOT NULL,
6562
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6563
`c3` int(11) DEFAULT NULL,
6564
`c4` varchar(10) NOT NULL
6565
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6566
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6570
SHOW CREATE TABLE t1;
6572
t1 CREATE TABLE `t1` (
6573
`c1` decimal(10,0) NOT NULL,
6574
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6575
`c3` int(11) DEFAULT NULL,
6576
`c4` varchar(10) NOT NULL,
6577
PRIMARY KEY (`c1`,`c2`)
6578
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6582
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6586
SHOW CREATE TABLE t1;
6588
t1 CREATE TABLE `t1` (
6589
`c1` decimal(10,0) NOT NULL,
6590
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6591
`c3` int(11) DEFAULT NULL,
6592
`c4` varchar(10) NOT NULL
6593
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6594
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6598
SHOW CREATE TABLE t1;
6600
t1 CREATE TABLE `t1` (
6601
`c1` decimal(10,0) NOT NULL,
6602
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6603
`c3` int(11) DEFAULT NULL,
6604
`c4` varchar(10) NOT NULL,
6605
PRIMARY KEY (`c1`,`c2`)
6606
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6610
CREATE TABLE t1(c1 DATE NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6614
SHOW CREATE TABLE t1;
6616
t1 CREATE TABLE `t1` (
6618
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6619
`c3` int(11) DEFAULT NULL,
6620
`c4` varchar(10) NOT NULL
6621
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6622
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6626
SHOW CREATE TABLE t1;
6628
t1 CREATE TABLE `t1` (
6630
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6631
`c3` int(11) DEFAULT NULL,
6632
`c4` varchar(10) NOT NULL,
6633
PRIMARY KEY (`c1`,`c2`)
6634
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6638
CREATE TABLE t1(c1 TIME NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6642
SHOW CREATE TABLE t1;
6644
t1 CREATE TABLE `t1` (
6646
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6647
`c3` int(11) DEFAULT NULL,
6648
`c4` varchar(10) NOT NULL
6649
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6650
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6654
SHOW CREATE TABLE t1;
6656
t1 CREATE TABLE `t1` (
6658
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6659
`c3` int(11) DEFAULT NULL,
6660
`c4` varchar(10) NOT NULL,
6661
PRIMARY KEY (`c1`,`c2`)
6662
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6666
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6670
SHOW CREATE TABLE t1;
6672
t1 CREATE TABLE `t1` (
6673
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6674
`c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
6675
`c3` int(11) DEFAULT NULL,
6676
`c4` varchar(10) NOT NULL
6677
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6678
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6682
SHOW CREATE TABLE t1;
6684
t1 CREATE TABLE `t1` (
6685
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6686
`c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
6687
`c3` int(11) DEFAULT NULL,
6688
`c4` varchar(10) NOT NULL,
6689
PRIMARY KEY (`c1`,`c2`)
6690
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6694
CREATE TABLE t1(c1 YEAR NOT NULL, c2 TIMESTAMP NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6698
SHOW CREATE TABLE t1;
6700
t1 CREATE TABLE `t1` (
6701
`c1` year(4) NOT NULL,
6702
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6703
`c3` int(11) DEFAULT NULL,
6704
`c4` varchar(10) NOT NULL
6705
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6706
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6710
SHOW CREATE TABLE t1;
6712
t1 CREATE TABLE `t1` (
6713
`c1` year(4) NOT NULL,
6714
`c2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6715
`c3` int(11) DEFAULT NULL,
6716
`c4` varchar(10) NOT NULL,
6717
PRIMARY KEY (`c1`,`c2`)
6718
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6722
CREATE TABLE t1(c1 BIT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6726
SHOW CREATE TABLE t1;
6728
t1 CREATE TABLE `t1` (
6729
`c1` bit(1) NOT NULL,
6730
`c2` year(4) NOT NULL,
6731
`c3` int(11) DEFAULT NULL,
6732
`c4` varchar(10) NOT NULL
6733
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6734
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6738
SHOW CREATE TABLE t1;
6740
t1 CREATE TABLE `t1` (
6741
`c1` bit(1) NOT NULL,
6742
`c2` year(4) NOT NULL,
6743
`c3` int(11) DEFAULT NULL,
6744
`c4` varchar(10) NOT NULL,
6745
PRIMARY KEY (`c1`,`c2`)
6746
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6750
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6754
SHOW CREATE TABLE t1;
6756
t1 CREATE TABLE `t1` (
6757
`c1` tinyint(4) NOT NULL,
6758
`c2` year(4) NOT NULL,
6759
`c3` int(11) DEFAULT NULL,
6760
`c4` varchar(10) NOT NULL
6761
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6762
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6766
SHOW CREATE TABLE t1;
6768
t1 CREATE TABLE `t1` (
6769
`c1` tinyint(4) NOT NULL,
6770
`c2` year(4) NOT NULL,
6771
`c3` int(11) DEFAULT NULL,
6772
`c4` varchar(10) NOT NULL,
6773
PRIMARY KEY (`c1`,`c2`)
6774
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6778
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6782
SHOW CREATE TABLE t1;
6784
t1 CREATE TABLE `t1` (
6785
`c1` smallint(6) NOT NULL,
6786
`c2` year(4) NOT NULL,
6787
`c3` int(11) DEFAULT NULL,
6788
`c4` varchar(10) NOT NULL
6789
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6790
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6794
SHOW CREATE TABLE t1;
6796
t1 CREATE TABLE `t1` (
6797
`c1` smallint(6) NOT NULL,
6798
`c2` year(4) NOT NULL,
6799
`c3` int(11) DEFAULT NULL,
6800
`c4` varchar(10) NOT NULL,
6801
PRIMARY KEY (`c1`,`c2`)
6802
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6806
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6810
SHOW CREATE TABLE t1;
6812
t1 CREATE TABLE `t1` (
6813
`c1` mediumint(9) NOT NULL,
6814
`c2` year(4) NOT NULL,
6815
`c3` int(11) DEFAULT NULL,
6816
`c4` varchar(10) NOT NULL
6817
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6818
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6822
SHOW CREATE TABLE t1;
6824
t1 CREATE TABLE `t1` (
6825
`c1` mediumint(9) NOT NULL,
6826
`c2` year(4) NOT NULL,
6827
`c3` int(11) DEFAULT NULL,
6828
`c4` varchar(10) NOT NULL,
6829
PRIMARY KEY (`c1`,`c2`)
6830
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6834
CREATE TABLE t1(c1 INT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6838
SHOW CREATE TABLE t1;
6840
t1 CREATE TABLE `t1` (
6841
`c1` int(11) NOT NULL,
6842
`c2` year(4) NOT NULL,
6843
`c3` int(11) DEFAULT NULL,
6844
`c4` varchar(10) NOT NULL
6845
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6846
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6850
SHOW CREATE TABLE t1;
6852
t1 CREATE TABLE `t1` (
6853
`c1` int(11) NOT NULL,
6854
`c2` year(4) NOT NULL,
6855
`c3` int(11) DEFAULT NULL,
6856
`c4` varchar(10) NOT NULL,
6857
PRIMARY KEY (`c1`,`c2`)
6858
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6862
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6866
SHOW CREATE TABLE t1;
6868
t1 CREATE TABLE `t1` (
6869
`c1` int(11) NOT NULL,
6870
`c2` year(4) NOT NULL,
6871
`c3` int(11) DEFAULT NULL,
6872
`c4` varchar(10) NOT NULL
6873
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6874
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6878
SHOW CREATE TABLE t1;
6880
t1 CREATE TABLE `t1` (
6881
`c1` int(11) NOT NULL,
6882
`c2` year(4) NOT NULL,
6883
`c3` int(11) DEFAULT NULL,
6884
`c4` varchar(10) NOT NULL,
6885
PRIMARY KEY (`c1`,`c2`)
6886
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6890
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6894
SHOW CREATE TABLE t1;
6896
t1 CREATE TABLE `t1` (
6897
`c1` bigint(20) NOT NULL,
6898
`c2` year(4) NOT NULL,
6899
`c3` int(11) DEFAULT NULL,
6900
`c4` varchar(10) NOT NULL
6901
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6902
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6906
SHOW CREATE TABLE t1;
6908
t1 CREATE TABLE `t1` (
6909
`c1` bigint(20) NOT NULL,
6910
`c2` year(4) NOT NULL,
6911
`c3` int(11) DEFAULT NULL,
6912
`c4` varchar(10) NOT NULL,
6913
PRIMARY KEY (`c1`,`c2`)
6914
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6918
CREATE TABLE t1(c1 REAL NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6922
SHOW CREATE TABLE t1;
6924
t1 CREATE TABLE `t1` (
6925
`c1` double NOT NULL,
6926
`c2` year(4) NOT NULL,
6927
`c3` int(11) DEFAULT NULL,
6928
`c4` varchar(10) NOT NULL
6929
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6930
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6934
SHOW CREATE TABLE t1;
6936
t1 CREATE TABLE `t1` (
6937
`c1` double NOT NULL,
6938
`c2` year(4) NOT NULL,
6939
`c3` int(11) DEFAULT NULL,
6940
`c4` varchar(10) NOT NULL,
6941
PRIMARY KEY (`c1`,`c2`)
6942
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6946
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6950
SHOW CREATE TABLE t1;
6952
t1 CREATE TABLE `t1` (
6953
`c1` double NOT NULL,
6954
`c2` year(4) NOT NULL,
6955
`c3` int(11) DEFAULT NULL,
6956
`c4` varchar(10) NOT NULL
6957
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6958
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6962
SHOW CREATE TABLE t1;
6964
t1 CREATE TABLE `t1` (
6965
`c1` double NOT NULL,
6966
`c2` year(4) NOT NULL,
6967
`c3` int(11) DEFAULT NULL,
6968
`c4` varchar(10) NOT NULL,
6969
PRIMARY KEY (`c1`,`c2`)
6970
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6974
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
6978
SHOW CREATE TABLE t1;
6980
t1 CREATE TABLE `t1` (
6981
`c1` float NOT NULL,
6982
`c2` year(4) NOT NULL,
6983
`c3` int(11) DEFAULT NULL,
6984
`c4` varchar(10) NOT NULL
6985
) ENGINE=ENGINE DEFAULT CHARSET=latin1
6986
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
6990
SHOW CREATE TABLE t1;
6992
t1 CREATE TABLE `t1` (
6993
`c1` float NOT NULL,
6994
`c2` year(4) NOT NULL,
6995
`c3` int(11) DEFAULT NULL,
6996
`c4` varchar(10) NOT NULL,
6997
PRIMARY KEY (`c1`,`c2`)
6998
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7002
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7006
SHOW CREATE TABLE t1;
7008
t1 CREATE TABLE `t1` (
7009
`c1` decimal(10,0) NOT NULL,
7010
`c2` year(4) NOT NULL,
7011
`c3` int(11) DEFAULT NULL,
7012
`c4` varchar(10) NOT NULL
7013
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7014
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7018
SHOW CREATE TABLE t1;
7020
t1 CREATE TABLE `t1` (
7021
`c1` decimal(10,0) NOT NULL,
7022
`c2` year(4) NOT NULL,
7023
`c3` int(11) DEFAULT NULL,
7024
`c4` varchar(10) NOT NULL,
7025
PRIMARY KEY (`c1`,`c2`)
7026
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7030
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7034
SHOW CREATE TABLE t1;
7036
t1 CREATE TABLE `t1` (
7037
`c1` decimal(10,0) NOT NULL,
7038
`c2` year(4) NOT NULL,
7039
`c3` int(11) DEFAULT NULL,
7040
`c4` varchar(10) NOT NULL
7041
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7042
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7046
SHOW CREATE TABLE t1;
7048
t1 CREATE TABLE `t1` (
7049
`c1` decimal(10,0) NOT NULL,
7050
`c2` year(4) NOT NULL,
7051
`c3` int(11) DEFAULT NULL,
7052
`c4` varchar(10) NOT NULL,
7053
PRIMARY KEY (`c1`,`c2`)
7054
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7058
CREATE TABLE t1(c1 DATE NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7062
SHOW CREATE TABLE t1;
7064
t1 CREATE TABLE `t1` (
7066
`c2` year(4) NOT NULL,
7067
`c3` int(11) DEFAULT NULL,
7068
`c4` varchar(10) NOT NULL
7069
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7070
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7074
SHOW CREATE TABLE t1;
7076
t1 CREATE TABLE `t1` (
7078
`c2` year(4) NOT NULL,
7079
`c3` int(11) DEFAULT NULL,
7080
`c4` varchar(10) NOT NULL,
7081
PRIMARY KEY (`c1`,`c2`)
7082
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7086
CREATE TABLE t1(c1 TIME NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7090
SHOW CREATE TABLE t1;
7092
t1 CREATE TABLE `t1` (
7094
`c2` year(4) NOT NULL,
7095
`c3` int(11) DEFAULT NULL,
7096
`c4` varchar(10) NOT NULL
7097
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7098
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7102
SHOW CREATE TABLE t1;
7104
t1 CREATE TABLE `t1` (
7106
`c2` year(4) NOT NULL,
7107
`c3` int(11) DEFAULT NULL,
7108
`c4` varchar(10) NOT NULL,
7109
PRIMARY KEY (`c1`,`c2`)
7110
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7114
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7118
SHOW CREATE TABLE t1;
7120
t1 CREATE TABLE `t1` (
7121
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
7122
`c2` year(4) NOT NULL,
7123
`c3` int(11) DEFAULT NULL,
7124
`c4` varchar(10) NOT NULL
7125
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7126
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7130
SHOW CREATE TABLE t1;
7132
t1 CREATE TABLE `t1` (
7133
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
7134
`c2` year(4) NOT NULL,
7135
`c3` int(11) DEFAULT NULL,
7136
`c4` varchar(10) NOT NULL,
7137
PRIMARY KEY (`c1`,`c2`)
7138
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7142
CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 INT NULL, c4 VARCHAR(10) NOT NULL);
7146
SHOW CREATE TABLE t1;
7148
t1 CREATE TABLE `t1` (
7149
`c1` year(4) NOT NULL,
7150
`c2` year(4) NOT NULL,
7151
`c3` int(11) DEFAULT NULL,
7152
`c4` varchar(10) NOT NULL
7153
) ENGINE=ENGINE DEFAULT CHARSET=latin1
7154
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
7158
SHOW CREATE TABLE t1;
7160
t1 CREATE TABLE `t1` (
7161
`c1` year(4) NOT NULL,
7162
`c2` year(4) NOT NULL,
7163
`c3` int(11) DEFAULT NULL,
7164
`c4` varchar(10) NOT NULL,
7165
PRIMARY KEY (`c1`,`c2`)
7166
) ENGINE=ENGINE DEFAULT CHARSET=latin1