1 # Embedded server doesn't support external clients
2 --source include/not_embedded.inc
3 --source include/have_innodb.inc
4 --source include/have_archive.inc
7 drop table if exists t1, t2, t3, t4, t5, t6;
10 create table t1 (id int(8), name varchar(32));
11 create table t2 (id int(8), name varchar(32)) ENGINE="MyISAM";
12 create table t3 (id int(8), name varchar(32)) ENGINE="MEMORY";
13 create table t4 (id int(8), name varchar(32)) ENGINE="HEAP";
14 create table t5 (id int(8), name varchar(32)) ENGINE="ARCHIVE";
15 create table t6 (id int(8), name varchar(32)) ENGINE="InnoDB";
17 insert into t1 values (1, 'first value');
18 insert into t1 values (2, 'first value');
19 insert into t1 values (3, 'first value');
20 insert into t1 values (4, 'first value');
21 insert into t1 values (5, 'first value');
23 insert into t2 values (1, 'first value');
24 insert into t2 values (2, 'first value');
25 insert into t2 values (3, 'first value');
26 insert into t2 values (4, 'first value');
27 insert into t2 values (5, 'first value');
29 insert into t3 values (1, 'first value');
30 insert into t3 values (2, 'first value');
31 insert into t3 values (3, 'first value');
32 insert into t3 values (4, 'first value');
33 insert into t3 values (5, 'first value');
35 insert into t4 values (1, 'first value');
36 insert into t4 values (2, 'first value');
37 insert into t4 values (3, 'first value');
38 insert into t4 values (4, 'first value');
39 insert into t4 values (5, 'first value');
41 insert into t5 values (1, 'first value');
42 insert into t5 values (2, 'first value');
43 insert into t5 values (3, 'first value');
44 insert into t5 values (4, 'first value');
45 insert into t5 values (5, 'first value');
47 insert into t6 values (1, 'first value');
48 insert into t6 values (2, 'first value');
49 insert into t6 values (3, 'first value');
50 insert into t6 values (4, 'first value');
51 insert into t6 values (5, 'first value');
60 --exec $MYSQL_DUMP --skip-comments --delayed-insert --insert-ignore --databases test
61 --exec $MYSQL_DUMP --skip-comments --delayed-insert --databases test
72 # Bug#31434 - mysqldump dumps view as table
75 # Show that mysqldump's stand-in tables for views are always of MyISAM
76 # type to avoid Inno's column-number limits (~1000 columns) etc.
77 # Here because it needs Inno-engine.
79 SELECT @@global.storage_engine INTO @old_engine;
80 SET GLOBAL storage_engine=InnoDB;
84 `col_0` tinyint(1) default NULL,
85 `col_1` tinyint(1) default NULL,
86 `col_2` tinyint(1) default NULL,
87 `col_3` tinyint(1) default NULL,
88 `col_4` tinyint(1) default NULL,
89 `col_5` tinyint(1) default NULL,
90 `col_6` tinyint(1) default NULL,
91 `col_7` tinyint(1) default NULL,
92 `col_8` tinyint(1) default NULL,
93 `col_9` tinyint(1) default NULL,
94 `col_10` tinyint(1) default NULL,
95 `col_11` tinyint(1) default NULL,
96 `col_12` tinyint(1) default NULL,
97 `col_13` tinyint(1) default NULL,
98 `col_14` tinyint(1) default NULL,
99 `col_15` tinyint(1) default NULL,
100 `col_16` tinyint(1) default NULL,
101 `col_17` tinyint(1) default NULL,
102 `col_18` tinyint(1) default NULL,
103 `col_19` tinyint(1) default NULL,
104 `col_20` tinyint(1) default NULL,
105 `col_21` tinyint(1) default NULL,
106 `col_22` tinyint(1) default NULL,
107 `col_23` tinyint(1) default NULL,
108 `col_24` tinyint(1) default NULL,
109 `col_25` tinyint(1) default NULL,
110 `col_26` tinyint(1) default NULL,
111 `col_27` tinyint(1) default NULL,
112 `col_28` tinyint(1) default NULL,
113 `col_29` tinyint(1) default NULL,
114 `col_30` tinyint(1) default NULL,
115 `col_31` tinyint(1) default NULL,
116 `col_32` tinyint(1) default NULL,
117 `col_33` tinyint(1) default NULL,
118 `col_34` tinyint(1) default NULL,
119 `col_35` tinyint(1) default NULL,
120 `col_36` tinyint(1) default NULL,
121 `col_37` tinyint(1) default NULL,
122 `col_38` tinyint(1) default NULL,
123 `col_39` tinyint(1) default NULL,
124 `col_40` tinyint(1) default NULL,
125 `col_41` tinyint(1) default NULL,
126 `col_42` tinyint(1) default NULL,
127 `col_43` tinyint(1) default NULL,
128 `col_44` tinyint(1) default NULL,
129 `col_45` tinyint(1) default NULL,
130 `col_46` tinyint(1) default NULL,
131 `col_47` tinyint(1) default NULL,
132 `col_48` tinyint(1) default NULL,
133 `col_49` tinyint(1) default NULL,
134 `col_50` tinyint(1) default NULL,
135 `col_51` tinyint(1) default NULL,
136 `col_52` tinyint(1) default NULL,
137 `col_53` tinyint(1) default NULL,
138 `col_54` tinyint(1) default NULL,
139 `col_55` tinyint(1) default NULL,
140 `col_56` tinyint(1) default NULL,
141 `col_57` tinyint(1) default NULL,
142 `col_58` tinyint(1) default NULL,
143 `col_59` tinyint(1) default NULL,
144 `col_60` tinyint(1) default NULL,
145 `col_61` tinyint(1) default NULL,
146 `col_62` tinyint(1) default NULL,
147 `col_63` tinyint(1) default NULL,
148 `col_64` tinyint(1) default NULL,
149 `col_65` tinyint(1) default NULL,
150 `col_66` tinyint(1) default NULL,
151 `col_67` tinyint(1) default NULL,
152 `col_68` tinyint(1) default NULL,
153 `col_69` tinyint(1) default NULL,
154 `col_70` tinyint(1) default NULL,
155 `col_71` tinyint(1) default NULL,
156 `col_72` tinyint(1) default NULL,
157 `col_73` tinyint(1) default NULL,
158 `col_74` tinyint(1) default NULL,
159 `col_75` tinyint(1) default NULL,
160 `col_76` tinyint(1) default NULL,
161 `col_77` tinyint(1) default NULL,
162 `col_78` tinyint(1) default NULL,
163 `col_79` tinyint(1) default NULL,
164 `col_80` tinyint(1) default NULL,
165 `col_81` tinyint(1) default NULL,
166 `col_82` tinyint(1) default NULL,
167 `col_83` tinyint(1) default NULL,
168 `col_84` tinyint(1) default NULL,
169 `col_85` tinyint(1) default NULL,
170 `col_86` tinyint(1) default NULL,
171 `col_87` tinyint(1) default NULL,
172 `col_88` tinyint(1) default NULL,
173 `col_89` tinyint(1) default NULL,
174 `col_90` tinyint(1) default NULL,
175 `col_91` tinyint(1) default NULL,
176 `col_92` tinyint(1) default NULL,
177 `col_93` tinyint(1) default NULL,
178 `col_94` tinyint(1) default NULL,
179 `col_95` tinyint(1) default NULL,
180 `col_96` tinyint(1) default NULL,
181 `col_97` tinyint(1) default NULL,
182 `col_98` tinyint(1) default NULL,
183 `col_99` tinyint(1) default NULL,
184 `col_100` tinyint(1) default NULL,
185 `col_101` tinyint(1) default NULL,
186 `col_102` tinyint(1) default NULL,
187 `col_103` tinyint(1) default NULL,
188 `col_104` tinyint(1) default NULL,
189 `col_105` tinyint(1) default NULL,
190 `col_106` tinyint(1) default NULL,
191 `col_107` tinyint(1) default NULL,
192 `col_108` tinyint(1) default NULL,
193 `col_109` tinyint(1) default NULL,
194 `col_110` tinyint(1) default NULL,
195 `col_111` tinyint(1) default NULL,
196 `col_112` tinyint(1) default NULL,
197 `col_113` tinyint(1) default NULL,
198 `col_114` tinyint(1) default NULL,
199 `col_115` tinyint(1) default NULL,
200 `col_116` tinyint(1) default NULL,
201 `col_117` tinyint(1) default NULL,
202 `col_118` tinyint(1) default NULL,
203 `col_119` tinyint(1) default NULL,
204 `col_120` tinyint(1) default NULL,
205 `col_121` tinyint(1) default NULL,
206 `col_122` tinyint(1) default NULL,
207 `col_123` tinyint(1) default NULL,
208 `col_124` tinyint(1) default NULL,
209 `col_125` tinyint(1) default NULL,
210 `col_126` tinyint(1) default NULL,
211 `col_127` tinyint(1) default NULL,
212 `col_128` tinyint(1) default NULL,
213 `col_129` tinyint(1) default NULL,
214 `col_130` tinyint(1) default NULL,
215 `col_131` tinyint(1) default NULL,
216 `col_132` tinyint(1) default NULL,
217 `col_133` tinyint(1) default NULL,
218 `col_134` tinyint(1) default NULL,
219 `col_135` tinyint(1) default NULL,
220 `col_136` tinyint(1) default NULL,
221 `col_137` tinyint(1) default NULL,
222 `col_138` tinyint(1) default NULL,
223 `col_139` tinyint(1) default NULL,
224 `col_140` tinyint(1) default NULL,
225 `col_141` tinyint(1) default NULL,
226 `col_142` tinyint(1) default NULL,
227 `col_143` tinyint(1) default NULL,
228 `col_144` tinyint(1) default NULL,
229 `col_145` tinyint(1) default NULL,
230 `col_146` tinyint(1) default NULL,
231 `col_147` tinyint(1) default NULL,
232 `col_148` tinyint(1) default NULL,
233 `col_149` tinyint(1) default NULL,
234 `col_150` tinyint(1) default NULL,
235 `col_151` tinyint(1) default NULL,
236 `col_152` tinyint(1) default NULL,
237 `col_153` tinyint(1) default NULL,
238 `col_154` tinyint(1) default NULL,
239 `col_155` tinyint(1) default NULL,
240 `col_156` tinyint(1) default NULL,
241 `col_157` tinyint(1) default NULL,
242 `col_158` tinyint(1) default NULL,
243 `col_159` tinyint(1) default NULL,
244 `col_160` tinyint(1) default NULL,
245 `col_161` tinyint(1) default NULL,
246 `col_162` tinyint(1) default NULL,
247 `col_163` tinyint(1) default NULL,
248 `col_164` tinyint(1) default NULL,
249 `col_165` tinyint(1) default NULL,
250 `col_166` tinyint(1) default NULL,
251 `col_167` tinyint(1) default NULL,
252 `col_168` tinyint(1) default NULL,
253 `col_169` tinyint(1) default NULL,
254 `col_170` tinyint(1) default NULL,
255 `col_171` tinyint(1) default NULL,
256 `col_172` tinyint(1) default NULL,
257 `col_173` tinyint(1) default NULL,
258 `col_174` tinyint(1) default NULL,
259 `col_175` tinyint(1) default NULL,
260 `col_176` tinyint(1) default NULL,
261 `col_177` tinyint(1) default NULL,
262 `col_178` tinyint(1) default NULL,
263 `col_179` tinyint(1) default NULL,
264 `col_180` tinyint(1) default NULL,
265 `col_181` tinyint(1) default NULL,
266 `col_182` tinyint(1) default NULL,
267 `col_183` tinyint(1) default NULL,
268 `col_184` tinyint(1) default NULL,
269 `col_185` tinyint(1) default NULL,
270 `col_186` tinyint(1) default NULL,
271 `col_187` tinyint(1) default NULL,
272 `col_188` tinyint(1) default NULL,
273 `col_189` tinyint(1) default NULL,
274 `col_190` tinyint(1) default NULL,
275 `col_191` tinyint(1) default NULL,
276 `col_192` tinyint(1) default NULL,
277 `col_193` tinyint(1) default NULL,
278 `col_194` tinyint(1) default NULL,
279 `col_195` tinyint(1) default NULL,
280 `col_196` tinyint(1) default NULL,
281 `col_197` tinyint(1) default NULL,
282 `col_198` tinyint(1) default NULL,
283 `col_199` tinyint(1) default NULL,
284 `col_200` tinyint(1) default NULL,
285 `col_201` tinyint(1) default NULL,
286 `col_202` tinyint(1) default NULL,
287 `col_203` tinyint(1) default NULL,
288 `col_204` tinyint(1) default NULL,
289 `col_205` tinyint(1) default NULL,
290 `col_206` tinyint(1) default NULL,
291 `col_207` tinyint(1) default NULL,
292 `col_208` tinyint(1) default NULL,
293 `col_209` tinyint(1) default NULL,
294 `col_210` tinyint(1) default NULL,
295 `col_211` tinyint(1) default NULL,
296 `col_212` tinyint(1) default NULL,
297 `col_213` tinyint(1) default NULL,
298 `col_214` tinyint(1) default NULL,
299 `col_215` tinyint(1) default NULL,
300 `col_216` tinyint(1) default NULL,
301 `col_217` tinyint(1) default NULL,
302 `col_218` tinyint(1) default NULL,
303 `col_219` tinyint(1) default NULL,
304 `col_220` tinyint(1) default NULL,
305 `col_221` tinyint(1) default NULL,
306 `col_222` tinyint(1) default NULL,
307 `col_223` tinyint(1) default NULL,
308 `col_224` tinyint(1) default NULL,
309 `col_225` tinyint(1) default NULL,
310 `col_226` tinyint(1) default NULL,
311 `col_227` tinyint(1) default NULL,
312 `col_228` tinyint(1) default NULL,
313 `col_229` tinyint(1) default NULL,
314 `col_230` tinyint(1) default NULL,
315 `col_231` tinyint(1) default NULL,
316 `col_232` tinyint(1) default NULL,
317 `col_233` tinyint(1) default NULL,
318 `col_234` tinyint(1) default NULL,
319 `col_235` tinyint(1) default NULL,
320 `col_236` tinyint(1) default NULL,
321 `col_237` tinyint(1) default NULL,
322 `col_238` tinyint(1) default NULL,
323 `col_239` tinyint(1) default NULL,
324 `col_240` tinyint(1) default NULL,
325 `col_241` tinyint(1) default NULL,
326 `col_242` tinyint(1) default NULL,
327 `col_243` tinyint(1) default NULL,
328 `col_244` tinyint(1) default NULL,
329 `col_245` tinyint(1) default NULL,
330 `col_246` tinyint(1) default NULL,
331 `col_247` tinyint(1) default NULL,
332 `col_248` tinyint(1) default NULL,
333 `col_249` tinyint(1) default NULL,
334 `col_250` tinyint(1) default NULL,
335 `col_251` tinyint(1) default NULL,
336 `col_252` tinyint(1) default NULL,
337 `col_253` tinyint(1) default NULL,
338 `col_254` tinyint(1) default NULL,
339 `col_255` tinyint(1) default NULL,
340 `col_256` tinyint(1) default NULL,
341 `col_257` tinyint(1) default NULL,
342 `col_258` tinyint(1) default NULL,
343 `col_259` tinyint(1) default NULL,
344 `col_260` tinyint(1) default NULL,
345 `col_261` tinyint(1) default NULL,
346 `col_262` tinyint(1) default NULL,
347 `col_263` tinyint(1) default NULL,
348 `col_264` tinyint(1) default NULL,
349 `col_265` tinyint(1) default NULL,
350 `col_266` tinyint(1) default NULL,
351 `col_267` tinyint(1) default NULL,
352 `col_268` tinyint(1) default NULL,
353 `col_269` tinyint(1) default NULL,
354 `col_270` tinyint(1) default NULL,
355 `col_271` tinyint(1) default NULL,
356 `col_272` tinyint(1) default NULL,
357 `col_273` tinyint(1) default NULL,
358 `col_274` tinyint(1) default NULL,
359 `col_275` tinyint(1) default NULL,
360 `col_276` tinyint(1) default NULL,
361 `col_277` tinyint(1) default NULL,
362 `col_278` tinyint(1) default NULL,
363 `col_279` tinyint(1) default NULL,
364 `col_280` tinyint(1) default NULL,
365 `col_281` tinyint(1) default NULL,
366 `col_282` tinyint(1) default NULL,
367 `col_283` tinyint(1) default NULL,
368 `col_284` tinyint(1) default NULL,
369 `col_285` tinyint(1) default NULL,
370 `col_286` tinyint(1) default NULL,
371 `col_287` tinyint(1) default NULL,
372 `col_288` tinyint(1) default NULL,
373 `col_289` tinyint(1) default NULL,
374 `col_290` tinyint(1) default NULL,
375 `col_291` tinyint(1) default NULL,
376 `col_292` tinyint(1) default NULL,
377 `col_293` tinyint(1) default NULL,
378 `col_294` tinyint(1) default NULL,
379 `col_295` tinyint(1) default NULL,
380 `col_296` tinyint(1) default NULL,
381 `col_297` tinyint(1) default NULL,
382 `col_298` tinyint(1) default NULL,
383 `col_299` tinyint(1) default NULL,
384 `col_300` tinyint(1) default NULL,
385 `col_301` tinyint(1) default NULL,
386 `col_302` tinyint(1) default NULL,
387 `col_303` tinyint(1) default NULL,
388 `col_304` tinyint(1) default NULL,
389 `col_305` tinyint(1) default NULL,
390 `col_306` tinyint(1) default NULL,
391 `col_307` tinyint(1) default NULL,
392 `col_308` tinyint(1) default NULL,
393 `col_309` tinyint(1) default NULL,
394 `col_310` tinyint(1) default NULL,
395 `col_311` tinyint(1) default NULL,
396 `col_312` tinyint(1) default NULL,
397 `col_313` tinyint(1) default NULL,
398 `col_314` tinyint(1) default NULL,
399 `col_315` tinyint(1) default NULL,
400 `col_316` tinyint(1) default NULL,
401 `col_317` tinyint(1) default NULL,
402 `col_318` tinyint(1) default NULL,
403 `col_319` tinyint(1) default NULL,
404 `col_320` tinyint(1) default NULL,
405 `col_321` tinyint(1) default NULL,
406 `col_322` tinyint(1) default NULL,
407 `col_323` tinyint(1) default NULL,
408 `col_324` tinyint(1) default NULL,
409 `col_325` tinyint(1) default NULL,
410 `col_326` tinyint(1) default NULL,
411 `col_327` tinyint(1) default NULL,
412 `col_328` tinyint(1) default NULL,
413 `col_329` tinyint(1) default NULL,
414 `col_330` tinyint(1) default NULL,
415 `col_331` tinyint(1) default NULL,
416 `col_332` tinyint(1) default NULL,
417 `col_333` tinyint(1) default NULL,
418 `col_334` tinyint(1) default NULL,
419 `col_335` tinyint(1) default NULL,
420 `col_336` tinyint(1) default NULL,
421 `col_337` tinyint(1) default NULL,
422 `col_338` tinyint(1) default NULL,
423 `col_339` tinyint(1) default NULL,
424 `col_340` tinyint(1) default NULL,
425 `col_341` tinyint(1) default NULL,
426 `col_342` tinyint(1) default NULL,
427 `col_343` tinyint(1) default NULL,
428 `col_344` tinyint(1) default NULL,
429 `col_345` tinyint(1) default NULL,
430 `col_346` tinyint(1) default NULL,
431 `col_347` tinyint(1) default NULL,
432 `col_348` tinyint(1) default NULL,
433 `col_349` tinyint(1) default NULL,
434 `col_350` tinyint(1) default NULL,
435 `col_351` tinyint(1) default NULL,
436 `col_352` tinyint(1) default NULL,
437 `col_353` tinyint(1) default NULL,
438 `col_354` tinyint(1) default NULL,
439 `col_355` tinyint(1) default NULL,
440 `col_356` tinyint(1) default NULL,
441 `col_357` tinyint(1) default NULL,
442 `col_358` tinyint(1) default NULL,
443 `col_359` tinyint(1) default NULL,
444 `col_360` tinyint(1) default NULL,
445 `col_361` tinyint(1) default NULL,
446 `col_362` tinyint(1) default NULL,
447 `col_363` tinyint(1) default NULL,
448 `col_364` tinyint(1) default NULL,
449 `col_365` tinyint(1) default NULL,
450 `col_366` tinyint(1) default NULL,
451 `col_367` tinyint(1) default NULL,
452 `col_368` tinyint(1) default NULL,
453 `col_369` tinyint(1) default NULL,
454 `col_370` tinyint(1) default NULL,
455 `col_371` tinyint(1) default NULL,
456 `col_372` tinyint(1) default NULL,
457 `col_373` tinyint(1) default NULL,
458 `col_374` tinyint(1) default NULL,
459 `col_375` tinyint(1) default NULL,
460 `col_376` tinyint(1) default NULL,
461 `col_377` tinyint(1) default NULL,
462 `col_378` tinyint(1) default NULL,
463 `col_379` tinyint(1) default NULL,
464 `col_380` tinyint(1) default NULL,
465 `col_381` tinyint(1) default NULL,
466 `col_382` tinyint(1) default NULL,
467 `col_383` tinyint(1) default NULL,
468 `col_384` tinyint(1) default NULL,
469 `col_385` tinyint(1) default NULL,
470 `col_386` tinyint(1) default NULL,
471 `col_387` tinyint(1) default NULL,
472 `col_388` tinyint(1) default NULL,
473 `col_389` tinyint(1) default NULL,
474 `col_390` tinyint(1) default NULL,
475 `col_391` tinyint(1) default NULL,
476 `col_392` tinyint(1) default NULL,
477 `col_393` tinyint(1) default NULL,
478 `col_394` tinyint(1) default NULL,
479 `col_395` tinyint(1) default NULL,
480 `col_396` tinyint(1) default NULL,
481 `col_397` tinyint(1) default NULL,
482 `col_398` tinyint(1) default NULL,
483 `col_399` tinyint(1) default NULL,
484 `col_400` tinyint(1) default NULL,
485 `col_401` tinyint(1) default NULL,
486 `col_402` tinyint(1) default NULL,
487 `col_403` tinyint(1) default NULL,
488 `col_404` tinyint(1) default NULL,
489 `col_405` tinyint(1) default NULL,
490 `col_406` tinyint(1) default NULL,
491 `col_407` tinyint(1) default NULL,
492 `col_408` tinyint(1) default NULL,
493 `col_409` tinyint(1) default NULL,
494 `col_410` tinyint(1) default NULL,
495 `col_411` tinyint(1) default NULL,
496 `col_412` tinyint(1) default NULL,
497 `col_413` tinyint(1) default NULL,
498 `col_414` tinyint(1) default NULL,
499 `col_415` tinyint(1) default NULL,
500 `col_416` tinyint(1) default NULL,
501 `col_417` tinyint(1) default NULL,
502 `col_418` tinyint(1) default NULL,
503 `col_419` tinyint(1) default NULL,
504 `col_420` tinyint(1) default NULL,
505 `col_421` tinyint(1) default NULL,
506 `col_422` tinyint(1) default NULL,
507 `col_423` tinyint(1) default NULL,
508 `col_424` tinyint(1) default NULL,
509 `col_425` tinyint(1) default NULL,
510 `col_426` tinyint(1) default NULL,
511 `col_427` tinyint(1) default NULL,
512 `col_428` tinyint(1) default NULL,
513 `col_429` tinyint(1) default NULL,
514 `col_430` tinyint(1) default NULL,
515 `col_431` tinyint(1) default NULL,
516 `col_432` tinyint(1) default NULL,
517 `col_433` tinyint(1) default NULL,
518 `col_434` tinyint(1) default NULL,
519 `col_435` tinyint(1) default NULL,
520 `col_436` tinyint(1) default NULL,
521 `col_437` tinyint(1) default NULL,
522 `col_438` tinyint(1) default NULL,
523 `col_439` tinyint(1) default NULL,
524 `col_440` tinyint(1) default NULL,
525 `col_441` tinyint(1) default NULL,
526 `col_442` tinyint(1) default NULL,
527 `col_443` tinyint(1) default NULL,
528 `col_444` tinyint(1) default NULL,
529 `col_445` tinyint(1) default NULL,
530 `col_446` tinyint(1) default NULL,
531 `col_447` tinyint(1) default NULL,
532 `col_448` tinyint(1) default NULL,
533 `col_449` tinyint(1) default NULL,
534 `col_450` tinyint(1) default NULL,
535 `col_451` tinyint(1) default NULL,
536 `col_452` tinyint(1) default NULL,
537 `col_453` tinyint(1) default NULL,
538 `col_454` tinyint(1) default NULL,
539 `col_455` tinyint(1) default NULL,
540 `col_456` tinyint(1) default NULL,
541 `col_457` tinyint(1) default NULL,
542 `col_458` tinyint(1) default NULL,
543 `col_459` tinyint(1) default NULL,
544 `col_460` tinyint(1) default NULL,
545 `col_461` tinyint(1) default NULL,
546 `col_462` tinyint(1) default NULL,
547 `col_463` tinyint(1) default NULL,
548 `col_464` tinyint(1) default NULL,
549 `col_465` tinyint(1) default NULL,
550 `col_466` tinyint(1) default NULL,
551 `col_467` tinyint(1) default NULL,
552 `col_468` tinyint(1) default NULL,
553 `col_469` tinyint(1) default NULL,
554 `col_470` tinyint(1) default NULL,
555 `col_471` tinyint(1) default NULL,
556 `col_472` tinyint(1) default NULL,
557 `col_473` tinyint(1) default NULL,
558 `col_474` tinyint(1) default NULL,
559 `col_475` tinyint(1) default NULL,
560 `col_476` tinyint(1) default NULL,
561 `col_477` tinyint(1) default NULL,
562 `col_478` tinyint(1) default NULL,
563 `col_479` tinyint(1) default NULL,
564 `col_480` tinyint(1) default NULL,
565 `col_481` tinyint(1) default NULL,
566 `col_482` tinyint(1) default NULL,
567 `col_483` tinyint(1) default NULL,
568 `col_484` tinyint(1) default NULL,
569 `col_485` tinyint(1) default NULL,
570 `col_486` tinyint(1) default NULL,
571 `col_487` tinyint(1) default NULL,
572 `col_488` tinyint(1) default NULL,
573 `col_489` tinyint(1) default NULL,
574 `col_490` tinyint(1) default NULL,
575 `col_491` tinyint(1) default NULL,
576 `col_492` tinyint(1) default NULL,
577 `col_493` tinyint(1) default NULL,
578 `col_494` tinyint(1) default NULL,
579 `col_495` tinyint(1) default NULL,
580 `col_496` tinyint(1) default NULL,
581 `col_497` tinyint(1) default NULL,
582 `col_498` tinyint(1) default NULL,
583 `col_499` tinyint(1) default NULL,
584 `col_500` tinyint(1) default NULL,
585 `col_501` tinyint(1) default NULL,
586 `col_502` tinyint(1) default NULL,
587 `col_503` tinyint(1) default NULL,
588 `col_504` tinyint(1) default NULL,
589 `col_505` tinyint(1) default NULL,
590 `col_506` tinyint(1) default NULL,
591 `col_507` tinyint(1) default NULL,
592 `col_508` tinyint(1) default NULL,
593 `col_509` tinyint(1) default NULL,
594 `col_510` tinyint(1) default NULL,
595 `col_511` tinyint(1) default NULL,
596 `col_512` tinyint(1) default NULL,
597 `col_513` tinyint(1) default NULL,
598 `col_514` tinyint(1) default NULL,
599 `col_515` tinyint(1) default NULL,
600 `col_516` tinyint(1) default NULL,
601 `col_517` tinyint(1) default NULL,
602 `col_518` tinyint(1) default NULL,
603 `col_519` tinyint(1) default NULL,
604 `col_520` tinyint(1) default NULL,
605 `col_521` tinyint(1) default NULL,
606 `col_522` tinyint(1) default NULL,
607 `col_523` tinyint(1) default NULL,
608 `col_524` tinyint(1) default NULL,
609 `col_525` tinyint(1) default NULL,
610 `col_526` tinyint(1) default NULL,
611 `col_527` tinyint(1) default NULL,
612 `col_528` tinyint(1) default NULL,
613 `col_529` tinyint(1) default NULL,
614 `col_530` tinyint(1) default NULL,
615 `col_531` tinyint(1) default NULL,
616 `col_532` tinyint(1) default NULL,
617 `col_533` tinyint(1) default NULL,
618 `col_534` tinyint(1) default NULL,
619 `col_535` tinyint(1) default NULL,
620 `col_536` tinyint(1) default NULL,
621 `col_537` tinyint(1) default NULL,
622 `col_538` tinyint(1) default NULL,
623 `col_539` tinyint(1) default NULL,
624 `col_540` tinyint(1) default NULL,
625 `col_541` tinyint(1) default NULL,
626 `col_542` tinyint(1) default NULL,
627 `col_543` tinyint(1) default NULL,
628 `col_544` tinyint(1) default NULL,
629 `col_545` tinyint(1) default NULL,
630 `col_546` tinyint(1) default NULL,
631 `col_547` tinyint(1) default NULL,
632 `col_548` tinyint(1) default NULL,
633 `col_549` tinyint(1) default NULL,
634 `col_550` tinyint(1) default NULL,
635 `col_551` tinyint(1) default NULL,
636 `col_552` tinyint(1) default NULL,
637 `col_553` tinyint(1) default NULL,
638 `col_554` tinyint(1) default NULL,
639 `col_555` tinyint(1) default NULL,
640 `col_556` tinyint(1) default NULL,
641 `col_557` tinyint(1) default NULL,
642 `col_558` tinyint(1) default NULL,
643 `col_559` tinyint(1) default NULL,
644 `col_560` tinyint(1) default NULL,
645 `col_561` tinyint(1) default NULL,
646 `col_562` tinyint(1) default NULL,
647 `col_563` tinyint(1) default NULL,
648 `col_564` tinyint(1) default NULL,
649 `col_565` tinyint(1) default NULL,
650 `col_566` tinyint(1) default NULL,
651 `col_567` tinyint(1) default NULL,
652 `col_568` tinyint(1) default NULL,
653 `col_569` tinyint(1) default NULL,
654 `col_570` tinyint(1) default NULL,
655 `col_571` tinyint(1) default NULL,
656 `col_572` tinyint(1) default NULL,
657 `col_573` tinyint(1) default NULL,
658 `col_574` tinyint(1) default NULL,
659 `col_575` tinyint(1) default NULL,
660 `col_576` tinyint(1) default NULL,
661 `col_577` tinyint(1) default NULL,
662 `col_578` tinyint(1) default NULL,
663 `col_579` tinyint(1) default NULL,
664 `col_580` tinyint(1) default NULL,
665 `col_581` tinyint(1) default NULL,
666 `col_582` tinyint(1) default NULL,
667 `col_583` tinyint(1) default NULL,
668 `col_584` tinyint(1) default NULL,
669 `col_585` tinyint(1) default NULL,
670 `col_586` tinyint(1) default NULL,
671 `col_587` tinyint(1) default NULL,
672 `col_588` tinyint(1) default NULL,
673 `col_589` tinyint(1) default NULL,
674 `col_590` tinyint(1) default NULL,
675 `col_591` tinyint(1) default NULL,
676 `col_592` tinyint(1) default NULL,
677 `col_593` tinyint(1) default NULL,
678 `col_594` tinyint(1) default NULL,
679 `col_595` tinyint(1) default NULL,
680 `col_596` tinyint(1) default NULL,
681 `col_597` tinyint(1) default NULL,
682 `col_598` tinyint(1) default NULL,
683 `col_599` tinyint(1) default NULL,
684 `col_600` tinyint(1) default NULL,
685 `col_601` tinyint(1) default NULL,
686 `col_602` tinyint(1) default NULL,
687 `col_603` tinyint(1) default NULL,
688 `col_604` tinyint(1) default NULL,
689 `col_605` tinyint(1) default NULL,
690 `col_606` tinyint(1) default NULL,
691 `col_607` tinyint(1) default NULL,
692 `col_608` tinyint(1) default NULL,
693 `col_609` tinyint(1) default NULL,
694 `col_610` tinyint(1) default NULL,
695 `col_611` tinyint(1) default NULL,
696 `col_612` tinyint(1) default NULL,
697 `col_613` tinyint(1) default NULL,
698 `col_614` tinyint(1) default NULL,
699 `col_615` tinyint(1) default NULL,
700 `col_616` tinyint(1) default NULL,
701 `col_617` tinyint(1) default NULL,
702 `col_618` tinyint(1) default NULL,
703 `col_619` tinyint(1) default NULL,
704 `col_620` tinyint(1) default NULL,
705 `col_621` tinyint(1) default NULL,
706 `col_622` tinyint(1) default NULL,
707 `col_623` tinyint(1) default NULL,
708 `col_624` tinyint(1) default NULL,
709 `col_625` tinyint(1) default NULL,
710 `col_626` tinyint(1) default NULL,
711 `col_627` tinyint(1) default NULL,
712 `col_628` tinyint(1) default NULL,
713 `col_629` tinyint(1) default NULL,
714 `col_630` tinyint(1) default NULL,
715 `col_631` tinyint(1) default NULL,
716 `col_632` tinyint(1) default NULL,
717 `col_633` tinyint(1) default NULL,
718 `col_634` tinyint(1) default NULL,
719 `col_635` tinyint(1) default NULL,
720 `col_636` tinyint(1) default NULL,
721 `col_637` tinyint(1) default NULL,
722 `col_638` tinyint(1) default NULL,
723 `col_639` tinyint(1) default NULL,
724 `col_640` tinyint(1) default NULL,
725 `col_641` tinyint(1) default NULL,
726 `col_642` tinyint(1) default NULL,
727 `col_643` tinyint(1) default NULL,
728 `col_644` tinyint(1) default NULL,
729 `col_645` tinyint(1) default NULL,
730 `col_646` tinyint(1) default NULL,
731 `col_647` tinyint(1) default NULL,
732 `col_648` tinyint(1) default NULL,
733 `col_649` tinyint(1) default NULL,
734 `col_650` tinyint(1) default NULL,
735 `col_651` tinyint(1) default NULL,
736 `col_652` tinyint(1) default NULL,
737 `col_653` tinyint(1) default NULL,
738 `col_654` tinyint(1) default NULL,
739 `col_655` tinyint(1) default NULL,
740 `col_656` tinyint(1) default NULL,
741 `col_657` tinyint(1) default NULL,
742 `col_658` tinyint(1) default NULL,
743 `col_659` tinyint(1) default NULL,
744 `col_660` tinyint(1) default NULL,
745 `col_661` tinyint(1) default NULL,
746 `col_662` tinyint(1) default NULL,
747 `col_663` tinyint(1) default NULL,
748 `col_664` tinyint(1) default NULL,
749 `col_665` tinyint(1) default NULL,
750 `col_666` tinyint(1) default NULL,
751 `col_667` tinyint(1) default NULL,
752 `col_668` tinyint(1) default NULL,
753 `col_669` tinyint(1) default NULL,
754 `col_670` tinyint(1) default NULL,
755 `col_671` tinyint(1) default NULL,
756 `col_672` tinyint(1) default NULL,
757 `col_673` tinyint(1) default NULL,
758 `col_674` tinyint(1) default NULL,
759 `col_675` tinyint(1) default NULL,
760 `col_676` tinyint(1) default NULL,
761 `col_677` tinyint(1) default NULL,
762 `col_678` tinyint(1) default NULL,
763 `col_679` tinyint(1) default NULL,
764 `col_680` tinyint(1) default NULL,
765 `col_681` tinyint(1) default NULL,
766 `col_682` tinyint(1) default NULL,
767 `col_683` tinyint(1) default NULL,
768 `col_684` tinyint(1) default NULL,
769 `col_685` tinyint(1) default NULL,
770 `col_686` tinyint(1) default NULL,
771 `col_687` tinyint(1) default NULL,
772 `col_688` tinyint(1) default NULL,
773 `col_689` tinyint(1) default NULL,
774 `col_690` tinyint(1) default NULL,
775 `col_691` tinyint(1) default NULL,
776 `col_692` tinyint(1) default NULL,
777 `col_693` tinyint(1) default NULL,
778 `col_694` tinyint(1) default NULL,
779 `col_695` tinyint(1) default NULL,
780 `col_696` tinyint(1) default NULL,
781 `col_697` tinyint(1) default NULL,
782 `col_698` tinyint(1) default NULL,
783 `col_699` tinyint(1) default NULL,
784 `col_700` tinyint(1) default NULL,
785 `col_701` tinyint(1) default NULL,
786 `col_702` tinyint(1) default NULL,
787 `col_703` tinyint(1) default NULL,
788 `col_704` tinyint(1) default NULL,
789 `col_705` tinyint(1) default NULL,
790 `col_706` tinyint(1) default NULL,
791 `col_707` tinyint(1) default NULL,
792 `col_708` tinyint(1) default NULL,
793 `col_709` tinyint(1) default NULL,
794 `col_710` tinyint(1) default NULL,
795 `col_711` tinyint(1) default NULL,
796 `col_712` tinyint(1) default NULL,
797 `col_713` tinyint(1) default NULL,
798 `col_714` tinyint(1) default NULL,
799 `col_715` tinyint(1) default NULL,
800 `col_716` tinyint(1) default NULL,
801 `col_717` tinyint(1) default NULL,
802 `col_718` tinyint(1) default NULL,
803 `col_719` tinyint(1) default NULL,
804 `col_720` tinyint(1) default NULL,
805 `col_721` tinyint(1) default NULL,
806 `col_722` tinyint(1) default NULL,
807 `col_723` tinyint(1) default NULL,
808 `col_724` tinyint(1) default NULL,
809 `col_725` tinyint(1) default NULL,
810 `col_726` tinyint(1) default NULL,
811 `col_727` tinyint(1) default NULL,
812 `col_728` tinyint(1) default NULL,
813 `col_729` tinyint(1) default NULL,
814 `col_730` tinyint(1) default NULL,
815 `col_731` tinyint(1) default NULL,
816 `col_732` tinyint(1) default NULL,
817 `col_733` tinyint(1) default NULL,
818 `col_734` tinyint(1) default NULL,
819 `col_735` tinyint(1) default NULL,
820 `col_736` tinyint(1) default NULL,
821 `col_737` tinyint(1) default NULL,
822 `col_738` tinyint(1) default NULL,
823 `col_739` tinyint(1) default NULL,
824 `col_740` tinyint(1) default NULL,
825 `col_741` tinyint(1) default NULL,
826 `col_742` tinyint(1) default NULL,
827 `col_743` tinyint(1) default NULL,
828 `col_744` tinyint(1) default NULL,
829 `col_745` tinyint(1) default NULL,
830 `col_746` tinyint(1) default NULL,
831 `col_747` tinyint(1) default NULL,
832 `col_748` tinyint(1) default NULL,
833 `col_749` tinyint(1) default NULL,
834 `col_750` tinyint(1) default NULL,
835 `col_751` tinyint(1) default NULL,
836 `col_752` tinyint(1) default NULL,
837 `col_753` tinyint(1) default NULL,
838 `col_754` tinyint(1) default NULL,
839 `col_755` tinyint(1) default NULL,
840 `col_756` tinyint(1) default NULL,
841 `col_757` tinyint(1) default NULL,
842 `col_758` tinyint(1) default NULL,
843 `col_759` tinyint(1) default NULL,
844 `col_760` tinyint(1) default NULL,
845 `col_761` tinyint(1) default NULL,
846 `col_762` tinyint(1) default NULL,
847 `col_763` tinyint(1) default NULL,
848 `col_764` tinyint(1) default NULL,
849 `col_765` tinyint(1) default NULL,
850 `col_766` tinyint(1) default NULL,
851 `col_767` tinyint(1) default NULL,
852 `col_768` tinyint(1) default NULL,
853 `col_769` tinyint(1) default NULL,
854 `col_770` tinyint(1) default NULL,
855 `col_771` tinyint(1) default NULL,
856 `col_772` tinyint(1) default NULL,
857 `col_773` tinyint(1) default NULL,
858 `col_774` tinyint(1) default NULL,
859 `col_775` tinyint(1) default NULL,
860 `col_776` tinyint(1) default NULL,
861 `col_777` tinyint(1) default NULL,
862 `col_778` tinyint(1) default NULL,
863 `col_779` tinyint(1) default NULL,
864 `col_780` tinyint(1) default NULL,
865 `col_781` tinyint(1) default NULL,
866 `col_782` tinyint(1) default NULL,
867 `col_783` tinyint(1) default NULL,
868 `col_784` tinyint(1) default NULL,
869 `col_785` tinyint(1) default NULL,
870 `col_786` tinyint(1) default NULL,
871 `col_787` tinyint(1) default NULL,
872 `col_788` tinyint(1) default NULL,
873 `col_789` tinyint(1) default NULL,
874 `col_790` tinyint(1) default NULL,
875 `col_791` tinyint(1) default NULL,
876 `col_792` tinyint(1) default NULL,
877 `col_793` tinyint(1) default NULL,
878 `col_794` tinyint(1) default NULL,
879 `col_795` tinyint(1) default NULL,
880 `col_796` tinyint(1) default NULL,
881 `col_797` tinyint(1) default NULL,
882 `col_798` tinyint(1) default NULL,
883 `col_799` tinyint(1) default NULL,
884 `col_800` tinyint(1) default NULL,
885 `col_801` tinyint(1) default NULL,
886 `col_802` tinyint(1) default NULL,
887 `col_803` tinyint(1) default NULL,
888 `col_804` tinyint(1) default NULL,
889 `col_805` tinyint(1) default NULL,
890 `col_806` tinyint(1) default NULL,
891 `col_807` tinyint(1) default NULL,
892 `col_808` tinyint(1) default NULL,
893 `col_809` tinyint(1) default NULL,
894 `col_810` tinyint(1) default NULL,
895 `col_811` tinyint(1) default NULL,
896 `col_812` tinyint(1) default NULL,
897 `col_813` tinyint(1) default NULL,
898 `col_814` tinyint(1) default NULL,
899 `col_815` tinyint(1) default NULL,
900 `col_816` tinyint(1) default NULL,
901 `col_817` tinyint(1) default NULL,
902 `col_818` tinyint(1) default NULL,
903 `col_819` tinyint(1) default NULL,
904 `col_820` tinyint(1) default NULL,
905 `col_821` tinyint(1) default NULL,
906 `col_822` tinyint(1) default NULL,
907 `col_823` tinyint(1) default NULL,
908 `col_824` tinyint(1) default NULL,
909 `col_825` tinyint(1) default NULL,
910 `col_826` tinyint(1) default NULL,
911 `col_827` tinyint(1) default NULL,
912 `col_828` tinyint(1) default NULL,
913 `col_829` tinyint(1) default NULL,
914 `col_830` tinyint(1) default NULL,
915 `col_831` tinyint(1) default NULL,
916 `col_832` tinyint(1) default NULL,
917 `col_833` tinyint(1) default NULL,
918 `col_834` tinyint(1) default NULL,
919 `col_835` tinyint(1) default NULL,
920 `col_836` tinyint(1) default NULL,
921 `col_837` tinyint(1) default NULL,
922 `col_838` tinyint(1) default NULL,
923 `col_839` tinyint(1) default NULL,
924 `col_840` tinyint(1) default NULL,
925 `col_841` tinyint(1) default NULL,
926 `col_842` tinyint(1) default NULL,
927 `col_843` tinyint(1) default NULL,
928 `col_844` tinyint(1) default NULL,
929 `col_845` tinyint(1) default NULL,
930 `col_846` tinyint(1) default NULL,
931 `col_847` tinyint(1) default NULL,
932 `col_848` tinyint(1) default NULL,
933 `col_849` tinyint(1) default NULL,
934 `col_850` tinyint(1) default NULL,
935 `col_851` tinyint(1) default NULL,
936 `col_852` tinyint(1) default NULL,
937 `col_853` tinyint(1) default NULL,
938 `col_854` tinyint(1) default NULL,
939 `col_855` tinyint(1) default NULL,
940 `col_856` tinyint(1) default NULL,
941 `col_857` tinyint(1) default NULL,
942 `col_858` tinyint(1) default NULL,
943 `col_859` tinyint(1) default NULL,
944 `col_860` tinyint(1) default NULL,
945 `col_861` tinyint(1) default NULL,
946 `col_862` tinyint(1) default NULL,
947 `col_863` tinyint(1) default NULL,
948 `col_864` tinyint(1) default NULL,
949 `col_865` tinyint(1) default NULL,
950 `col_866` tinyint(1) default NULL,
951 `col_867` tinyint(1) default NULL,
952 `col_868` tinyint(1) default NULL,
953 `col_869` tinyint(1) default NULL,
954 `col_870` tinyint(1) default NULL,
955 `col_871` tinyint(1) default NULL,
956 `col_872` tinyint(1) default NULL,
957 `col_873` tinyint(1) default NULL,
958 `col_874` tinyint(1) default NULL,
959 `col_875` tinyint(1) default NULL,
960 `col_876` tinyint(1) default NULL,
961 `col_877` tinyint(1) default NULL,
962 `col_878` tinyint(1) default NULL,
963 `col_879` tinyint(1) default NULL,
964 `col_880` tinyint(1) default NULL,
965 `col_881` tinyint(1) default NULL,
966 `col_882` tinyint(1) default NULL,
967 `col_883` tinyint(1) default NULL,
968 `col_884` tinyint(1) default NULL,
969 `col_885` tinyint(1) default NULL,
970 `col_886` tinyint(1) default NULL,
971 `col_887` tinyint(1) default NULL,
972 `col_888` tinyint(1) default NULL,
973 `col_889` tinyint(1) default NULL,
974 `col_890` tinyint(1) default NULL,
975 `col_891` tinyint(1) default NULL,
976 `col_892` tinyint(1) default NULL,
977 `col_893` tinyint(1) default NULL,
978 `col_894` tinyint(1) default NULL,
979 `col_895` tinyint(1) default NULL,
980 `col_896` tinyint(1) default NULL,
981 `col_897` tinyint(1) default NULL,
982 `col_898` tinyint(1) default NULL,
983 `col_899` tinyint(1) default NULL,
984 `col_900` tinyint(1) default NULL,
985 `col_901` tinyint(1) default NULL,
986 `col_902` tinyint(1) default NULL,
987 `col_903` tinyint(1) default NULL,
988 `col_904` tinyint(1) default NULL,
989 `col_905` tinyint(1) default NULL,
990 `col_906` tinyint(1) default NULL,
991 `col_907` tinyint(1) default NULL,
992 `col_908` tinyint(1) default NULL,
993 `col_909` tinyint(1) default NULL,
994 `col_910` tinyint(1) default NULL,
995 `col_911` tinyint(1) default NULL,
996 `col_912` tinyint(1) default NULL,
997 `col_913` tinyint(1) default NULL,
998 `col_914` tinyint(1) default NULL,
999 `col_915` tinyint(1) default NULL,
1000 `col_916` tinyint(1) default NULL,
1001 `col_917` tinyint(1) default NULL,
1002 `col_918` tinyint(1) default NULL,
1003 `col_919` tinyint(1) default NULL,
1004 `col_920` tinyint(1) default NULL,
1005 `col_921` tinyint(1) default NULL,
1006 `col_922` tinyint(1) default NULL,
1007 `col_923` tinyint(1) default NULL,
1008 `col_924` tinyint(1) default NULL,
1009 `col_925` tinyint(1) default NULL,
1010 `col_926` tinyint(1) default NULL,
1011 `col_927` tinyint(1) default NULL,
1012 `col_928` tinyint(1) default NULL,
1013 `col_929` tinyint(1) default NULL,
1014 `col_930` tinyint(1) default NULL,
1015 `col_931` tinyint(1) default NULL,
1016 `col_932` tinyint(1) default NULL,
1017 `col_933` tinyint(1) default NULL,
1018 `col_934` tinyint(1) default NULL,
1019 `col_935` tinyint(1) default NULL,
1020 `col_936` tinyint(1) default NULL,
1021 `col_937` tinyint(1) default NULL,
1022 `col_938` tinyint(1) default NULL,
1023 `col_939` tinyint(1) default NULL,
1024 `col_940` tinyint(1) default NULL,
1025 `col_941` tinyint(1) default NULL,
1026 `col_942` tinyint(1) default NULL,
1027 `col_943` tinyint(1) default NULL,
1028 `col_944` tinyint(1) default NULL,
1029 `col_945` tinyint(1) default NULL,
1030 `col_946` tinyint(1) default NULL,
1031 `col_947` tinyint(1) default NULL,
1032 `col_948` tinyint(1) default NULL,
1033 `col_949` tinyint(1) default NULL,
1034 `col_950` tinyint(1) default NULL,
1035 `col_951` tinyint(1) default NULL,
1036 `col_952` tinyint(1) default NULL,
1037 `col_953` tinyint(1) default NULL,
1038 `col_954` tinyint(1) default NULL,
1039 `col_955` tinyint(1) default NULL,
1040 `col_956` tinyint(1) default NULL,
1041 `col_957` tinyint(1) default NULL,
1042 `col_958` tinyint(1) default NULL,
1043 `col_959` tinyint(1) default NULL,
1044 `col_960` tinyint(1) default NULL,
1045 `col_961` tinyint(1) default NULL,
1046 `col_962` tinyint(1) default NULL,
1047 `col_963` tinyint(1) default NULL,
1048 `col_964` tinyint(1) default NULL,
1049 `col_965` tinyint(1) default NULL,
1050 `col_966` tinyint(1) default NULL,
1051 `col_967` tinyint(1) default NULL,
1052 `col_968` tinyint(1) default NULL,
1053 `col_969` tinyint(1) default NULL,
1054 `col_970` tinyint(1) default NULL,
1055 `col_971` tinyint(1) default NULL,
1056 `col_972` tinyint(1) default NULL,
1057 `col_973` tinyint(1) default NULL,
1058 `col_974` tinyint(1) default NULL,
1059 `col_975` tinyint(1) default NULL,
1060 `col_976` tinyint(1) default NULL,
1061 `col_977` tinyint(1) default NULL,
1062 `col_978` tinyint(1) default NULL,
1063 `col_979` tinyint(1) default NULL,
1064 `col_980` tinyint(1) default NULL,
1065 `col_981` tinyint(1) default NULL,
1066 `col_982` tinyint(1) default NULL,
1067 `col_983` tinyint(1) default NULL,
1068 `col_984` tinyint(1) default NULL,
1069 `col_985` tinyint(1) default NULL,
1070 `col_986` tinyint(1) default NULL,
1071 `col_987` tinyint(1) default NULL,
1072 `col_988` tinyint(1) default NULL,
1073 `col_989` tinyint(1) default NULL,
1074 `col_990` tinyint(1) default NULL,
1075 `col_991` tinyint(1) default NULL,
1076 `col_992` tinyint(1) default NULL,
1077 `col_993` tinyint(1) default NULL,
1078 `col_994` tinyint(1) default NULL,
1079 `col_995` tinyint(1) default NULL,
1080 `col_996` tinyint(1) default NULL,
1081 `col_997` tinyint(1) default NULL,
1082 `col_998` tinyint(1) default NULL,
1083 `col_999` tinyint(1) default NULL,
1084 `col_1000` tinyint(1) default NULL,
1085 `col_1001` tinyint(1) default NULL,
1086 `col_1002` tinyint(1) default NULL,
1087 `col_1003` tinyint(1) default NULL,
1088 `col_1004` tinyint(1) default NULL,
1089 `col_1005` tinyint(1) default NULL,
1090 `col_1006` tinyint(1) default NULL,
1091 `col_1007` tinyint(1) default NULL,
1092 `col_1008` tinyint(1) default NULL,
1093 `col_1009` tinyint(1) default NULL,
1094 `col_1010` tinyint(1) default NULL,
1095 `col_1011` tinyint(1) default NULL,
1096 `col_1012` tinyint(1) default NULL,
1097 `col_1013` tinyint(1) default NULL,
1098 `col_1014` tinyint(1) default NULL,
1099 `col_1015` tinyint(1) default NULL,
1100 `col_1016` tinyint(1) default NULL,
1101 `col_1017` tinyint(1) default NULL,
1102 `col_1018` tinyint(1) default NULL,
1103 `col_1019` tinyint(1) default NULL,
1104 `col_1020` tinyint(1) default NULL,
1105 `col_1021` tinyint(1) default NULL,
1106 `col_1022` tinyint(1) default NULL,
1107 `col_1023` tinyint(1) default NULL,
1108 `col_1024` tinyint(1) default NULL,
1109 `col_1025` tinyint(1) default NULL
1110 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1112 CREATE VIEW v1 AS SELECT * FROM t1;
1114 INSERT INTO t1 VALUES();
1115 SELECT COUNT(*) FROM v1;
1117 --exec $MYSQL_DUMP --allow-keywords --single-transaction --quick --verbose test --result-file $MYSQLTEST_VARDIR/tmp/bug31434.sql
1118 --exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/bug31434.sql
1119 --remove_file $MYSQLTEST_VARDIR/tmp/bug31434.sql
1121 SELECT COUNT(*) FROM v1;
1126 SET GLOBAL storage_engine=@old_engine;