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;