95
95
DROP TABLE IF EXISTS `t1`;
96
SET @saved_cs_client = @@character_set_client;
97
SET character_set_client = utf8;
96
/*!40101 SET @saved_cs_client = @@character_set_client */;
97
/*!40101 SET character_set_client = utf8 */;
98
98
CREATE TABLE `t1` (
99
99
`id` int(8) DEFAULT NULL,
100
100
`name` varchar(32) DEFAULT NULL
101
101
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
102
SET character_set_client = @saved_cs_client;
102
/*!40101 SET character_set_client = @saved_cs_client */;
104
104
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
105
105
INSERT DELAYED IGNORE INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
106
106
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
107
107
DROP TABLE IF EXISTS `t2`;
108
SET @saved_cs_client = @@character_set_client;
109
SET character_set_client = utf8;
108
/*!40101 SET @saved_cs_client = @@character_set_client */;
109
/*!40101 SET character_set_client = utf8 */;
110
110
CREATE TABLE `t2` (
111
111
`id` int(8) DEFAULT NULL,
112
112
`name` varchar(32) DEFAULT NULL
113
113
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
114
SET character_set_client = @saved_cs_client;
114
/*!40101 SET character_set_client = @saved_cs_client */;
116
116
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
117
117
INSERT DELAYED IGNORE INTO `t2` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
118
118
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
119
119
DROP TABLE IF EXISTS `t3`;
120
SET @saved_cs_client = @@character_set_client;
121
SET character_set_client = utf8;
120
/*!40101 SET @saved_cs_client = @@character_set_client */;
121
/*!40101 SET character_set_client = utf8 */;
122
122
CREATE TABLE `t3` (
123
123
`id` int(8) DEFAULT NULL,
124
124
`name` varchar(32) DEFAULT NULL
125
125
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
126
SET character_set_client = @saved_cs_client;
126
/*!40101 SET character_set_client = @saved_cs_client */;
128
128
/*!40000 ALTER TABLE `t3` DISABLE KEYS */;
129
129
INSERT DELAYED IGNORE INTO `t3` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
130
130
/*!40000 ALTER TABLE `t3` ENABLE KEYS */;
131
131
DROP TABLE IF EXISTS `t4`;
132
SET @saved_cs_client = @@character_set_client;
133
SET character_set_client = utf8;
132
/*!40101 SET @saved_cs_client = @@character_set_client */;
133
/*!40101 SET character_set_client = utf8 */;
134
134
CREATE TABLE `t4` (
135
135
`id` int(8) DEFAULT NULL,
136
136
`name` varchar(32) DEFAULT NULL
137
137
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
138
SET character_set_client = @saved_cs_client;
138
/*!40101 SET character_set_client = @saved_cs_client */;
140
140
/*!40000 ALTER TABLE `t4` DISABLE KEYS */;
141
141
INSERT DELAYED IGNORE INTO `t4` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
142
142
/*!40000 ALTER TABLE `t4` ENABLE KEYS */;
143
143
DROP TABLE IF EXISTS `t5`;
144
SET @saved_cs_client = @@character_set_client;
145
SET character_set_client = utf8;
144
/*!40101 SET @saved_cs_client = @@character_set_client */;
145
/*!40101 SET character_set_client = utf8 */;
146
146
CREATE TABLE `t5` (
147
147
`id` int(8) DEFAULT NULL,
148
148
`name` varchar(32) DEFAULT NULL
149
149
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
150
SET character_set_client = @saved_cs_client;
150
/*!40101 SET character_set_client = @saved_cs_client */;
152
152
/*!40000 ALTER TABLE `t5` DISABLE KEYS */;
153
153
INSERT DELAYED IGNORE INTO `t5` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
154
154
/*!40000 ALTER TABLE `t5` ENABLE KEYS */;
155
155
DROP TABLE IF EXISTS `t6`;
156
SET @saved_cs_client = @@character_set_client;
157
SET character_set_client = utf8;
156
/*!40101 SET @saved_cs_client = @@character_set_client */;
157
/*!40101 SET character_set_client = utf8 */;
158
158
CREATE TABLE `t6` (
159
159
`id` int(8) DEFAULT NULL,
160
160
`name` varchar(32) DEFAULT NULL
161
161
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
162
SET character_set_client = @saved_cs_client;
162
/*!40101 SET character_set_client = @saved_cs_client */;
164
164
/*!40000 ALTER TABLE `t6` DISABLE KEYS */;
165
165
INSERT IGNORE INTO `t6` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
192
192
DROP TABLE IF EXISTS `t1`;
193
SET @saved_cs_client = @@character_set_client;
194
SET character_set_client = utf8;
193
/*!40101 SET @saved_cs_client = @@character_set_client */;
194
/*!40101 SET character_set_client = utf8 */;
195
195
CREATE TABLE `t1` (
196
196
`id` int(8) DEFAULT NULL,
197
197
`name` varchar(32) DEFAULT NULL
198
198
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
199
SET character_set_client = @saved_cs_client;
199
/*!40101 SET character_set_client = @saved_cs_client */;
201
201
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
202
202
INSERT DELAYED INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
203
203
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
204
204
DROP TABLE IF EXISTS `t2`;
205
SET @saved_cs_client = @@character_set_client;
206
SET character_set_client = utf8;
205
/*!40101 SET @saved_cs_client = @@character_set_client */;
206
/*!40101 SET character_set_client = utf8 */;
207
207
CREATE TABLE `t2` (
208
208
`id` int(8) DEFAULT NULL,
209
209
`name` varchar(32) DEFAULT NULL
210
210
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
211
SET character_set_client = @saved_cs_client;
211
/*!40101 SET character_set_client = @saved_cs_client */;
213
213
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
214
214
INSERT DELAYED INTO `t2` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
215
215
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
216
216
DROP TABLE IF EXISTS `t3`;
217
SET @saved_cs_client = @@character_set_client;
218
SET character_set_client = utf8;
217
/*!40101 SET @saved_cs_client = @@character_set_client */;
218
/*!40101 SET character_set_client = utf8 */;
219
219
CREATE TABLE `t3` (
220
220
`id` int(8) DEFAULT NULL,
221
221
`name` varchar(32) DEFAULT NULL
222
222
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
223
SET character_set_client = @saved_cs_client;
223
/*!40101 SET character_set_client = @saved_cs_client */;
225
225
/*!40000 ALTER TABLE `t3` DISABLE KEYS */;
226
226
INSERT DELAYED INTO `t3` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
227
227
/*!40000 ALTER TABLE `t3` ENABLE KEYS */;
228
228
DROP TABLE IF EXISTS `t4`;
229
SET @saved_cs_client = @@character_set_client;
230
SET character_set_client = utf8;
229
/*!40101 SET @saved_cs_client = @@character_set_client */;
230
/*!40101 SET character_set_client = utf8 */;
231
231
CREATE TABLE `t4` (
232
232
`id` int(8) DEFAULT NULL,
233
233
`name` varchar(32) DEFAULT NULL
234
234
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
235
SET character_set_client = @saved_cs_client;
235
/*!40101 SET character_set_client = @saved_cs_client */;
237
237
/*!40000 ALTER TABLE `t4` DISABLE KEYS */;
238
238
INSERT DELAYED INTO `t4` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
239
239
/*!40000 ALTER TABLE `t4` ENABLE KEYS */;
240
240
DROP TABLE IF EXISTS `t5`;
241
SET @saved_cs_client = @@character_set_client;
242
SET character_set_client = utf8;
241
/*!40101 SET @saved_cs_client = @@character_set_client */;
242
/*!40101 SET character_set_client = utf8 */;
243
243
CREATE TABLE `t5` (
244
244
`id` int(8) DEFAULT NULL,
245
245
`name` varchar(32) DEFAULT NULL
246
246
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
247
SET character_set_client = @saved_cs_client;
247
/*!40101 SET character_set_client = @saved_cs_client */;
249
249
/*!40000 ALTER TABLE `t5` DISABLE KEYS */;
250
250
INSERT DELAYED INTO `t5` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
251
251
/*!40000 ALTER TABLE `t5` ENABLE KEYS */;
252
252
DROP TABLE IF EXISTS `t6`;
253
SET @saved_cs_client = @@character_set_client;
254
SET character_set_client = utf8;
253
/*!40101 SET @saved_cs_client = @@character_set_client */;
254
/*!40101 SET character_set_client = utf8 */;
255
255
CREATE TABLE `t6` (
256
256
`id` int(8) DEFAULT NULL,
257
257
`name` varchar(32) DEFAULT NULL
258
258
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
259
SET character_set_client = @saved_cs_client;
259
/*!40101 SET character_set_client = @saved_cs_client */;
261
261
/*!40000 ALTER TABLE `t6` DISABLE KEYS */;
262
262
INSERT INTO `t6` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');