1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 BIT NULL);
3 CREATE UNIQUE INDEX i1 ON t1(c1);
10 `c1` bit(1) DEFAULT NULL,
11 UNIQUE KEY `i1` (`c1`)
12 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
16 CREATE TABLE t1(c1 TINYINT NULL);
17 CREATE UNIQUE INDEX i1 ON t1(c1);
23 t1 CREATE TABLE `t1` (
24 `c1` tinyint(4) DEFAULT NULL,
25 UNIQUE KEY `i1` (`c1`)
26 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
30 CREATE TABLE t1(c1 SMALLINT NULL);
31 CREATE UNIQUE INDEX i1 ON t1(c1);
37 t1 CREATE TABLE `t1` (
38 `c1` smallint(6) DEFAULT NULL,
39 UNIQUE KEY `i1` (`c1`)
40 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
44 CREATE TABLE t1(c1 MEDIUMINT NULL);
45 CREATE UNIQUE INDEX i1 ON t1(c1);
51 t1 CREATE TABLE `t1` (
52 `c1` mediumint(9) DEFAULT NULL,
53 UNIQUE KEY `i1` (`c1`)
54 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
58 CREATE TABLE t1(c1 INT NULL);
59 CREATE UNIQUE INDEX i1 ON t1(c1);
65 t1 CREATE TABLE `t1` (
66 `c1` int(11) DEFAULT NULL,
67 UNIQUE KEY `i1` (`c1`)
68 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
72 CREATE TABLE t1(c1 INTEGER NULL);
73 CREATE UNIQUE INDEX i1 ON t1(c1);
79 t1 CREATE TABLE `t1` (
80 `c1` int(11) DEFAULT NULL,
81 UNIQUE KEY `i1` (`c1`)
82 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
86 CREATE TABLE t1(c1 BIGINT NULL);
87 CREATE UNIQUE INDEX i1 ON t1(c1);
93 t1 CREATE TABLE `t1` (
94 `c1` bigint(20) DEFAULT NULL,
95 UNIQUE KEY `i1` (`c1`)
96 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
100 CREATE TABLE t1(c1 REAL NULL);
101 CREATE UNIQUE INDEX i1 ON t1(c1);
105 SHOW CREATE TABLE t1;
107 t1 CREATE TABLE `t1` (
108 `c1` double DEFAULT NULL,
109 UNIQUE KEY `i1` (`c1`)
110 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
114 CREATE TABLE t1(c1 DOUBLE NULL);
115 CREATE UNIQUE INDEX i1 ON t1(c1);
119 SHOW CREATE TABLE t1;
121 t1 CREATE TABLE `t1` (
122 `c1` double DEFAULT NULL,
123 UNIQUE KEY `i1` (`c1`)
124 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
128 CREATE TABLE t1(c1 FLOAT NULL);
129 CREATE UNIQUE INDEX i1 ON t1(c1);
133 SHOW CREATE TABLE t1;
135 t1 CREATE TABLE `t1` (
136 `c1` float DEFAULT NULL,
137 UNIQUE KEY `i1` (`c1`)
138 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
142 CREATE TABLE t1(c1 DECIMAL NULL);
143 CREATE UNIQUE INDEX i1 ON t1(c1);
147 SHOW CREATE TABLE t1;
149 t1 CREATE TABLE `t1` (
150 `c1` decimal(10,0) DEFAULT NULL,
151 UNIQUE KEY `i1` (`c1`)
152 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
156 CREATE TABLE t1(c1 NUMERIC NULL);
157 CREATE UNIQUE INDEX i1 ON t1(c1);
161 SHOW CREATE TABLE t1;
163 t1 CREATE TABLE `t1` (
164 `c1` decimal(10,0) DEFAULT NULL,
165 UNIQUE KEY `i1` (`c1`)
166 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
170 CREATE TABLE t1(c1 DATE NULL);
171 CREATE UNIQUE INDEX i1 ON t1(c1);
175 SHOW CREATE TABLE t1;
177 t1 CREATE TABLE `t1` (
178 `c1` date DEFAULT NULL,
179 UNIQUE KEY `i1` (`c1`)
180 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
184 CREATE TABLE t1(c1 TIME NULL);
185 CREATE UNIQUE INDEX i1 ON t1(c1);
189 SHOW CREATE TABLE t1;
191 t1 CREATE TABLE `t1` (
192 `c1` time DEFAULT NULL,
193 UNIQUE KEY `i1` (`c1`)
194 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
198 CREATE TABLE t1(c1 TIMESTAMP NULL);
199 CREATE UNIQUE INDEX i1 ON t1(c1);
203 SHOW CREATE TABLE t1;
205 t1 CREATE TABLE `t1` (
206 `c1` timestamp NULL DEFAULT NULL,
207 UNIQUE KEY `i1` (`c1`)
208 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
212 CREATE TABLE t1(c1 YEAR NULL);
213 CREATE UNIQUE INDEX i1 ON t1(c1);
217 SHOW CREATE TABLE t1;
219 t1 CREATE TABLE `t1` (
220 `c1` year(4) DEFAULT NULL,
221 UNIQUE KEY `i1` (`c1`)
222 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
226 CREATE TABLE t1(c1 BIT NOT NULL);
227 CREATE UNIQUE INDEX i1 ON t1(c1);
231 SHOW CREATE TABLE t1;
233 t1 CREATE TABLE `t1` (
234 `c1` bit(1) NOT NULL,
235 UNIQUE KEY `i1` (`c1`)
236 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
240 CREATE TABLE t1(c1 TINYINT NOT NULL);
241 CREATE UNIQUE INDEX i1 ON t1(c1);
245 SHOW CREATE TABLE t1;
247 t1 CREATE TABLE `t1` (
248 `c1` tinyint(4) NOT NULL,
249 UNIQUE KEY `i1` (`c1`)
250 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
254 CREATE TABLE t1(c1 SMALLINT NOT NULL);
255 CREATE UNIQUE INDEX i1 ON t1(c1);
259 SHOW CREATE TABLE t1;
261 t1 CREATE TABLE `t1` (
262 `c1` smallint(6) NOT NULL,
263 UNIQUE KEY `i1` (`c1`)
264 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
268 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
269 CREATE UNIQUE INDEX i1 ON t1(c1);
273 SHOW CREATE TABLE t1;
275 t1 CREATE TABLE `t1` (
276 `c1` mediumint(9) NOT NULL,
277 UNIQUE KEY `i1` (`c1`)
278 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
282 CREATE TABLE t1(c1 INT NOT NULL);
283 CREATE UNIQUE INDEX i1 ON t1(c1);
287 SHOW CREATE TABLE t1;
289 t1 CREATE TABLE `t1` (
290 `c1` int(11) NOT NULL,
291 UNIQUE KEY `i1` (`c1`)
292 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
296 CREATE TABLE t1(c1 INTEGER NOT NULL);
297 CREATE UNIQUE INDEX i1 ON t1(c1);
301 SHOW CREATE TABLE t1;
303 t1 CREATE TABLE `t1` (
304 `c1` int(11) NOT NULL,
305 UNIQUE KEY `i1` (`c1`)
306 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
310 CREATE TABLE t1(c1 BIGINT NOT NULL);
311 CREATE UNIQUE INDEX i1 ON t1(c1);
315 SHOW CREATE TABLE t1;
317 t1 CREATE TABLE `t1` (
318 `c1` bigint(20) NOT NULL,
319 UNIQUE KEY `i1` (`c1`)
320 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
324 CREATE TABLE t1(c1 REAL NOT NULL);
325 CREATE UNIQUE INDEX i1 ON t1(c1);
329 SHOW CREATE TABLE t1;
331 t1 CREATE TABLE `t1` (
332 `c1` double NOT NULL,
333 UNIQUE KEY `i1` (`c1`)
334 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
338 CREATE TABLE t1(c1 DOUBLE NOT NULL);
339 CREATE UNIQUE INDEX i1 ON t1(c1);
343 SHOW CREATE TABLE t1;
345 t1 CREATE TABLE `t1` (
346 `c1` double NOT NULL,
347 UNIQUE KEY `i1` (`c1`)
348 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
352 CREATE TABLE t1(c1 FLOAT NOT NULL);
353 CREATE UNIQUE INDEX i1 ON t1(c1);
357 SHOW CREATE TABLE t1;
359 t1 CREATE TABLE `t1` (
361 UNIQUE KEY `i1` (`c1`)
362 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
366 CREATE TABLE t1(c1 DECIMAL NOT NULL);
367 CREATE UNIQUE INDEX i1 ON t1(c1);
371 SHOW CREATE TABLE t1;
373 t1 CREATE TABLE `t1` (
374 `c1` decimal(10,0) NOT NULL,
375 UNIQUE KEY `i1` (`c1`)
376 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
380 CREATE TABLE t1(c1 NUMERIC NOT NULL);
381 CREATE UNIQUE INDEX i1 ON t1(c1);
385 SHOW CREATE TABLE t1;
387 t1 CREATE TABLE `t1` (
388 `c1` decimal(10,0) NOT NULL,
389 UNIQUE KEY `i1` (`c1`)
390 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
394 CREATE TABLE t1(c1 DATE NOT NULL);
395 CREATE UNIQUE INDEX i1 ON t1(c1);
399 SHOW CREATE TABLE t1;
401 t1 CREATE TABLE `t1` (
403 UNIQUE KEY `i1` (`c1`)
404 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
408 CREATE TABLE t1(c1 TIME NOT NULL);
409 CREATE UNIQUE INDEX i1 ON t1(c1);
413 SHOW CREATE TABLE t1;
415 t1 CREATE TABLE `t1` (
417 UNIQUE KEY `i1` (`c1`)
418 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
422 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
423 CREATE UNIQUE INDEX i1 ON t1(c1);
427 SHOW CREATE TABLE t1;
429 t1 CREATE TABLE `t1` (
430 `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
431 UNIQUE KEY `i1` (`c1`)
432 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
436 CREATE TABLE t1(c1 YEAR NOT NULL);
437 CREATE UNIQUE INDEX i1 ON t1(c1);
441 SHOW CREATE TABLE t1;
443 t1 CREATE TABLE `t1` (
444 `c1` year(4) NOT NULL,
445 UNIQUE KEY `i1` (`c1`)
446 ) ENGINE=ENGINE DEFAULT CHARSET=latin1