1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT NOT NULL);
11
) ENGINE=ENGINE DEFAULT CHARSET=latin1
12
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
18
t1 CREATE TABLE `t1` (
21
PRIMARY KEY (`c1`,`c2`)
22
) ENGINE=ENGINE DEFAULT CHARSET=latin1
26
CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT NOT NULL);
32
t1 CREATE TABLE `t1` (
33
`c1` tinyint(4) NOT NULL,
34
`c2` tinyint(4) NOT NULL
35
) ENGINE=ENGINE DEFAULT CHARSET=latin1
36
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
42
t1 CREATE TABLE `t1` (
43
`c1` tinyint(4) NOT NULL,
44
`c2` tinyint(4) NOT NULL,
45
PRIMARY KEY (`c1`,`c2`)
46
) ENGINE=ENGINE DEFAULT CHARSET=latin1
50
CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT NOT NULL);
56
t1 CREATE TABLE `t1` (
57
`c1` smallint(6) NOT NULL,
58
`c2` smallint(6) NOT NULL
59
) ENGINE=ENGINE DEFAULT CHARSET=latin1
60
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
66
t1 CREATE TABLE `t1` (
67
`c1` smallint(6) NOT NULL,
68
`c2` smallint(6) NOT NULL,
69
PRIMARY KEY (`c1`,`c2`)
70
) ENGINE=ENGINE DEFAULT CHARSET=latin1
74
CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT NOT NULL);
80
t1 CREATE TABLE `t1` (
81
`c1` mediumint(9) NOT NULL,
82
`c2` mediumint(9) NOT NULL
83
) ENGINE=ENGINE DEFAULT CHARSET=latin1
84
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
90
t1 CREATE TABLE `t1` (
91
`c1` mediumint(9) NOT NULL,
92
`c2` mediumint(9) NOT NULL,
93
PRIMARY KEY (`c1`,`c2`)
94
) ENGINE=ENGINE DEFAULT CHARSET=latin1
98
CREATE TABLE t1(c1 INT NOT NULL, c2 INT NOT NULL);
102
SHOW CREATE TABLE t1;
104
t1 CREATE TABLE `t1` (
105
`c1` int(11) NOT NULL,
106
`c2` int(11) NOT NULL
107
) ENGINE=ENGINE DEFAULT CHARSET=latin1
108
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
112
SHOW CREATE TABLE t1;
114
t1 CREATE TABLE `t1` (
115
`c1` int(11) NOT NULL,
116
`c2` int(11) NOT NULL,
117
PRIMARY KEY (`c1`,`c2`)
118
) ENGINE=ENGINE DEFAULT CHARSET=latin1
122
CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER NOT NULL);
126
SHOW CREATE TABLE t1;
128
t1 CREATE TABLE `t1` (
129
`c1` int(11) NOT NULL,
130
`c2` int(11) NOT NULL
131
) ENGINE=ENGINE DEFAULT CHARSET=latin1
132
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
136
SHOW CREATE TABLE t1;
138
t1 CREATE TABLE `t1` (
139
`c1` int(11) NOT NULL,
140
`c2` int(11) NOT NULL,
141
PRIMARY KEY (`c1`,`c2`)
142
) ENGINE=ENGINE DEFAULT CHARSET=latin1
146
CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT NOT NULL);
150
SHOW CREATE TABLE t1;
152
t1 CREATE TABLE `t1` (
153
`c1` bigint(20) NOT NULL,
154
`c2` bigint(20) NOT NULL
155
) ENGINE=ENGINE DEFAULT CHARSET=latin1
156
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
160
SHOW CREATE TABLE t1;
162
t1 CREATE TABLE `t1` (
163
`c1` bigint(20) NOT NULL,
164
`c2` bigint(20) NOT NULL,
165
PRIMARY KEY (`c1`,`c2`)
166
) ENGINE=ENGINE DEFAULT CHARSET=latin1
170
CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL NOT NULL);
174
SHOW CREATE TABLE t1;
176
t1 CREATE TABLE `t1` (
177
`c1` double NOT NULL,
179
) ENGINE=ENGINE DEFAULT CHARSET=latin1
180
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
184
SHOW CREATE TABLE t1;
186
t1 CREATE TABLE `t1` (
187
`c1` double NOT NULL,
188
`c2` double NOT NULL,
189
PRIMARY KEY (`c1`,`c2`)
190
) ENGINE=ENGINE DEFAULT CHARSET=latin1
194
CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE NOT NULL);
198
SHOW CREATE TABLE t1;
200
t1 CREATE TABLE `t1` (
201
`c1` double NOT NULL,
203
) ENGINE=ENGINE DEFAULT CHARSET=latin1
204
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
208
SHOW CREATE TABLE t1;
210
t1 CREATE TABLE `t1` (
211
`c1` double NOT NULL,
212
`c2` double NOT NULL,
213
PRIMARY KEY (`c1`,`c2`)
214
) ENGINE=ENGINE DEFAULT CHARSET=latin1
218
CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT NOT NULL);
222
SHOW CREATE TABLE t1;
224
t1 CREATE TABLE `t1` (
227
) ENGINE=ENGINE DEFAULT CHARSET=latin1
228
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
232
SHOW CREATE TABLE t1;
234
t1 CREATE TABLE `t1` (
237
PRIMARY KEY (`c1`,`c2`)
238
) ENGINE=ENGINE DEFAULT CHARSET=latin1
242
CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL NOT NULL);
246
SHOW CREATE TABLE t1;
248
t1 CREATE TABLE `t1` (
249
`c1` decimal(10,0) NOT NULL,
250
`c2` decimal(10,0) NOT NULL
251
) ENGINE=ENGINE DEFAULT CHARSET=latin1
252
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
256
SHOW CREATE TABLE t1;
258
t1 CREATE TABLE `t1` (
259
`c1` decimal(10,0) NOT NULL,
260
`c2` decimal(10,0) NOT NULL,
261
PRIMARY KEY (`c1`,`c2`)
262
) ENGINE=ENGINE DEFAULT CHARSET=latin1
266
CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC NOT NULL);
270
SHOW CREATE TABLE t1;
272
t1 CREATE TABLE `t1` (
273
`c1` decimal(10,0) NOT NULL,
274
`c2` decimal(10,0) NOT NULL
275
) ENGINE=ENGINE DEFAULT CHARSET=latin1
276
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
280
SHOW CREATE TABLE t1;
282
t1 CREATE TABLE `t1` (
283
`c1` decimal(10,0) NOT NULL,
284
`c2` decimal(10,0) NOT NULL,
285
PRIMARY KEY (`c1`,`c2`)
286
) ENGINE=ENGINE DEFAULT CHARSET=latin1
290
CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL);
294
SHOW CREATE TABLE t1;
296
t1 CREATE TABLE `t1` (
299
) ENGINE=ENGINE DEFAULT CHARSET=latin1
300
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
304
SHOW CREATE TABLE t1;
306
t1 CREATE TABLE `t1` (
309
PRIMARY KEY (`c1`,`c2`)
310
) ENGINE=ENGINE DEFAULT CHARSET=latin1
314
CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL);
318
SHOW CREATE TABLE t1;
320
t1 CREATE TABLE `t1` (
323
) ENGINE=ENGINE DEFAULT CHARSET=latin1
324
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
328
SHOW CREATE TABLE t1;
330
t1 CREATE TABLE `t1` (
333
PRIMARY KEY (`c1`,`c2`)
334
) ENGINE=ENGINE DEFAULT CHARSET=latin1
338
CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL);
342
SHOW CREATE TABLE t1;
344
t1 CREATE TABLE `t1` (
345
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
346
`c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
347
) ENGINE=ENGINE DEFAULT CHARSET=latin1
348
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
352
SHOW CREATE TABLE t1;
354
t1 CREATE TABLE `t1` (
355
`c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
356
`c2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
357
PRIMARY KEY (`c1`,`c2`)
358
) ENGINE=ENGINE DEFAULT CHARSET=latin1
362
CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL);
366
SHOW CREATE TABLE t1;
368
t1 CREATE TABLE `t1` (
369
`c1` year(4) NOT NULL,
370
`c2` year(4) NOT NULL
371
) ENGINE=ENGINE DEFAULT CHARSET=latin1
372
ALTER TABLE t1 ADD PRIMARY KEY (c1,c2);
376
SHOW CREATE TABLE t1;
378
t1 CREATE TABLE `t1` (
379
`c1` year(4) NOT NULL,
380
`c2` year(4) NOT NULL,
381
PRIMARY KEY (`c1`,`c2`)
382
) ENGINE=ENGINE DEFAULT CHARSET=latin1