summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/ai_reset_by_truncate.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ai_reset_by_truncate.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/ai_reset_by_truncate.result240
1 files changed, 120 insertions, 120 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ai_reset_by_truncate.result b/mysql-test/suite/engines/funcs/r/ai_reset_by_truncate.result
index 80ad3fefd31..9de7f91b490 100644
--- a/mysql-test/suite/engines/funcs/r/ai_reset_by_truncate.result
+++ b/mysql-test/suite/engines/funcs/r/ai_reset_by_truncate.result
@@ -5,7 +5,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -25,7 +25,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -47,7 +47,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -67,7 +67,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -89,7 +89,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -109,7 +109,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -131,7 +131,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -151,7 +151,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -173,7 +173,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -193,7 +193,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -215,7 +215,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -235,7 +235,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -257,7 +257,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -277,7 +277,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -299,7 +299,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -319,7 +319,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -341,7 +341,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -361,7 +361,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -383,7 +383,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -403,7 +403,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -425,7 +425,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -445,7 +445,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -467,7 +467,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -487,7 +487,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -509,7 +509,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -529,7 +529,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -551,7 +551,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -571,7 +571,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -593,7 +593,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -613,7 +613,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -635,7 +635,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -655,7 +655,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -677,7 +677,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -697,7 +697,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -719,7 +719,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -739,7 +739,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -761,7 +761,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -781,7 +781,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -803,7 +803,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -823,7 +823,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -845,7 +845,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -865,7 +865,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -887,7 +887,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -907,7 +907,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -929,7 +929,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -949,7 +949,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -971,7 +971,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -991,7 +991,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1013,7 +1013,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1033,7 +1033,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1055,7 +1055,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1075,7 +1075,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1097,7 +1097,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1117,7 +1117,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1139,7 +1139,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1159,7 +1159,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1181,7 +1181,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1201,7 +1201,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1223,7 +1223,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1243,7 +1243,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1265,7 +1265,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1285,7 +1285,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1307,7 +1307,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1327,7 +1327,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1349,7 +1349,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1369,7 +1369,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1391,7 +1391,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1411,7 +1411,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1433,7 +1433,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1453,7 +1453,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1475,7 +1475,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1495,7 +1495,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1517,7 +1517,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1537,7 +1537,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1559,7 +1559,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1579,7 +1579,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1601,7 +1601,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1621,7 +1621,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1643,7 +1643,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1663,7 +1663,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1685,7 +1685,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1705,7 +1705,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1727,7 +1727,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1747,7 +1747,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1769,7 +1769,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1789,7 +1789,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1811,7 +1811,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1831,7 +1831,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1853,7 +1853,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1873,7 +1873,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1895,7 +1895,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1915,7 +1915,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1937,7 +1937,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1957,7 +1957,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1979,7 +1979,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -1999,7 +1999,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2021,7 +2021,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2041,7 +2041,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2063,7 +2063,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2083,7 +2083,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2105,7 +2105,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2125,7 +2125,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2147,7 +2147,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2167,7 +2167,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2189,7 +2189,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2209,7 +2209,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2231,7 +2231,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2251,7 +2251,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
UNIQUE KEY `c1` (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2273,7 +2273,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2293,7 +2293,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2315,7 +2315,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2335,7 +2335,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2357,7 +2357,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2377,7 +2377,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2399,7 +2399,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2419,7 +2419,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2441,7 +2441,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2461,7 +2461,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2483,7 +2483,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
@@ -2503,7 +2503,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
+) ENGINE=ENGINE AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);
INSERT INTO t1 VALUES(null);