Debian Codegraph @

mysql-test/suite/memcached/r/memc286_sdi_create.result

raw
1 INSERT INTO cache_policies VALUES('cache_policy', 'innodb_only',
2 'innodb_only', 'innodb_only', 'innodb_only');
3 INSERT INTO config_options VALUES('separator', '|');
4 INSERT INTO containers VALUES ('desc_t1', 'test', 't1',
5 'c1', 'c2', '0', '0', '0', 'PRIMARY');
6 INSERT INTO containers VALUES ('desc_t2', 'test', 't2',
7 'c1', 'c2', '0', '0', '0', 'PRIMARY');
8 INSERT INTO containers VALUES ('desc_t3', 'test', 't3',
9 'c1', 'c2', '0', '0', '0', 'PRIMARY');
10 INSERT INTO containers VALUES ('desc_t4', 'test', 't4',
11 'c1', 'c2', '0', '0', '0', 'PRIMARY');
12 INSERT INTO containers VALUES ('desc_t5', 'test', 't5',
13 'c1', 'c2', '0', '0', '0', 'PRIMARY');
14 INSERT INTO containers VALUES ('desc_t6', 'test', 't6',
15 'c1', 'c2', '0', '0', '0', 'PRIMARY');
16 INSERT INTO containers VALUES ('desc_t7', 'test', 't7',
17 'c1', 'c2', '0', '0', '0', 'PRIMARY');
18 USE test;
19 SET GLOBAL innodb_file_per_table=OFF;
20 # Case 1. Test with CREATE TABLES
21 CREATE TABLE t1(c1 VARCHAR(32),
22 c2 VARCHAR(1024),
23 c3 TINYBLOB,
24 c4 BLOB,
25 c5 MEDIUMBLOB,
26 c6 LONGBLOB,
27 c7 TEXT,
28 c8 INT,
29 c9 FLOAT,
30 c10 DOUBLE,
31 primary key(c1),
32 KEY idx1(c4(20)),
33 UNIQUE KEY idx2(c6(50)))
34 CHARSET latin1 ENGINE = INNODB;
35 # Create table t2 with large schema (huge number of columns)
36 # Create table with small schema
37 CREATE TABLE t3(c1 VARCHAR(32),
38 c2 VARCHAR(1024),
39 PRIMARY KEY(c1))
40 ENGINE = INNODB;
41 # Create tables with constraints
42 CREATE TABLE t4 (c1 INT PRIMARY KEY,
43 c2 BLOB)
44 ENGINE = INNODB;
45 CREATE TABLE t5 (c1 INT PRIMARY KEY,
46 c2 INT,
47 FOREIGN KEY (c2) REFERENCES t4(c1) ON UPDATE CASCADE)
48 ENGINE = INNODB;
49 # Create table with spatial index
50 CREATE TABLE t7(c1 INT PRIMARY KEY,
51 c2 INT,
52 c3 CHAR(255),
53 c4 GEOMETRY NOT NULL SRID 0,
54 SPATIAL INDEX(c4))
55 ENGINE = INNODB;
56 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
57 Warnings:
58 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
59 Get rec(type:id) is t1 CREATE TABLE `t1` (
60 `c1` varchar(32) NOT NULL,
61 `c2` varchar(1024) DEFAULT NULL,
62 `c3` tinyblob,
63 `c4` blob,
64 `c5` mediumblob,
65 `c6` longblob,
66 `c7` text,
67 `c8` int DEFAULT NULL,
68 `c9` float DEFAULT NULL,
69 `c10` double DEFAULT NULL,
70 PRIMARY KEY (`c1`),
71 UNIQUE KEY `idx2` (`c6`(50)),
72 KEY `idx1` (`c4`(20))
73 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
74 Get rec(type:id) is t2 CREATE TABLE `t2` (
75 `c1` int NOT NULL,
76 `c2` int DEFAULT NULL,
77 `c3` int DEFAULT NULL,
78 `c4` int DEFAULT NULL,
79 `c5` int DEFAULT NULL,
80 `c6` int DEFAULT NULL,
81 `c7` int DEFAULT NULL,
82 `c8` int DEFAULT NULL,
83 `c9` int DEFAULT NULL,
84 `c10` int DEFAULT NULL,
85 `c11` int DEFAULT NULL,
86 `c12` int DEFAULT NULL,
87 `c13` int DEFAULT NULL,
88 `c14` int DEFAULT NULL,
89 `c15` int DEFAULT NULL,
90 `c16` int DEFAULT NULL,
91 `c17` int DEFAULT NULL,
92 `c18` int DEFAULT NULL,
93 `c19` int DEFAULT NULL,
94 `c20` int DEFAULT NULL,
95 `c21` int DEFAULT NULL,
96 `c22` int DEFAULT NULL,
97 `c23` int DEFAULT NULL,
98 `c24` int DEFAULT NULL,
99 `c25` int DEFAULT NULL,
100 `c26` int DEFAULT NULL,
101 `c27` int DEFAULT NULL,
102 `c28` int DEFAULT NULL,
103 `c29` int DEFAULT NULL,
104 `c30` int DEFAULT NULL,
105 `c31` int DEFAULT NULL,
106 `c32` int DEFAULT NULL,
107 `c33` int DEFAULT NULL,
108 `c34` int DEFAULT NULL,
109 `c35` int DEFAULT NULL,
110 `c36` int DEFAULT NULL,
111 `c37` int DEFAULT NULL,
112 `c38` int DEFAULT NULL,
113 `c39` int DEFAULT NULL,
114 `c40` int DEFAULT NULL,
115 `c41` int DEFAULT NULL,
116 `c42` int DEFAULT NULL,
117 `c43` int DEFAULT NULL,
118 `c44` int DEFAULT NULL,
119 `c45` int DEFAULT NULL,
120 `c46` int DEFAULT NULL,
121 `c47` int DEFAULT NULL,
122 `c48` int DEFAULT NULL,
123 `c49` int DEFAULT NULL,
124 `c50` int DEFAULT NULL,
125 `c51` int DEFAULT NULL,
126 `c52` int DEFAULT NULL,
127 `c53` int DEFAULT NULL,
128 `c54` int DEFAULT NULL,
129 `c55` int DEFAULT NULL,
130 `c56` int DEFAULT NULL,
131 `c57` int DEFAULT NULL,
132 `c58` int DEFAULT NULL,
133 `c59` int DEFAULT NULL,
134 `c60` int DEFAULT NULL,
135 `c61` int DEFAULT NULL,
136 `c62` int DEFAULT NULL,
137 `c63` int DEFAULT NULL,
138 `c64` int DEFAULT NULL,
139 `c65` int DEFAULT NULL,
140 `c66` int DEFAULT NULL,
141 `c67` int DEFAULT NULL,
142 `c68` int DEFAULT NULL,
143 `c69` int DEFAULT NULL,
144 `c70` int DEFAULT NULL,
145 `c71` int DEFAULT NULL,
146 `c72` int DEFAULT NULL,
147 `c73` int DEFAULT NULL,
148 `c74` int DEFAULT NULL,
149 `c75` int DEFAULT NULL,
150 `c76` int DEFAULT NULL,
151 `c77` int DEFAULT NULL,
152 `c78` int DEFAULT NULL,
153 `c79` int DEFAULT NULL,
154 `c80` int DEFAULT NULL,
155 `c81` int DEFAULT NULL,
156 `c82` int DEFAULT NULL,
157 `c83` int DEFAULT NULL,
158 `c84` int DEFAULT NULL,
159 `c85` int DEFAULT NULL,
160 `c86` int DEFAULT NULL,
161 `c87` int DEFAULT NULL,
162 `c88` int DEFAULT NULL,
163 `c89` int DEFAULT NULL,
164 `c90` int DEFAULT NULL,
165 `c91` int DEFAULT NULL,
166 `c92` int DEFAULT NULL,
167 `c93` int DEFAULT NULL,
168 `c94` int DEFAULT NULL,
169 `c95` int DEFAULT NULL,
170 `c96` int DEFAULT NULL,
171 `c97` int DEFAULT NULL,
172 `c98` int DEFAULT NULL,
173 `c99` int DEFAULT NULL,
174 `c100` int DEFAULT NULL,
175 `c101` int DEFAULT NULL,
176 `c102` int DEFAULT NULL,
177 `c103` int DEFAULT NULL,
178 `c104` int DEFAULT NULL,
179 `c105` int DEFAULT NULL,
180 `c106` int DEFAULT NULL,
181 `c107` int DEFAULT NULL,
182 `c108` int DEFAULT NULL,
183 `c109` int DEFAULT NULL,
184 `c110` int DEFAULT NULL,
185 `c111` int DEFAULT NULL,
186 `c112` int DEFAULT NULL,
187 `c113` int DEFAULT NULL,
188 `c114` int DEFAULT NULL,
189 `c115` int DEFAULT NULL,
190 `c116` int DEFAULT NULL,
191 `c117` int DEFAULT NULL,
192 `c118` int DEFAULT NULL,
193 `c119` int DEFAULT NULL,
194 `c120` int DEFAULT NULL,
195 `c121` int DEFAULT NULL,
196 `c122` int DEFAULT NULL,
197 `c123` int DEFAULT NULL,
198 `c124` int DEFAULT NULL,
199 `c125` int DEFAULT NULL,
200 `c126` int DEFAULT NULL,
201 `c127` int DEFAULT NULL,
202 `c128` int DEFAULT NULL,
203 `c129` int DEFAULT NULL,
204 `c130` int DEFAULT NULL,
205 `c131` int DEFAULT NULL,
206 `c132` int DEFAULT NULL,
207 `c133` int DEFAULT NULL,
208 `c134` int DEFAULT NULL,
209 `c135` int DEFAULT NULL,
210 `c136` int DEFAULT NULL,
211 `c137` int DEFAULT NULL,
212 `c138` int DEFAULT NULL,
213 `c139` int DEFAULT NULL,
214 `c140` int DEFAULT NULL,
215 `c141` int DEFAULT NULL,
216 `c142` int DEFAULT NULL,
217 `c143` int DEFAULT NULL,
218 `c144` int DEFAULT NULL,
219 `c145` int DEFAULT NULL,
220 `c146` int DEFAULT NULL,
221 `c147` int DEFAULT NULL,
222 `c148` int DEFAULT NULL,
223 `c149` int DEFAULT NULL,
224 `c150` int DEFAULT NULL,
225 `c151` int DEFAULT NULL,
226 `c152` int DEFAULT NULL,
227 `c153` int DEFAULT NULL,
228 `c154` int DEFAULT NULL,
229 `c155` int DEFAULT NULL,
230 `c156` int DEFAULT NULL,
231 `c157` int DEFAULT NULL,
232 `c158` int DEFAULT NULL,
233 `c159` int DEFAULT NULL,
234 `c160` int DEFAULT NULL,
235 `c161` int DEFAULT NULL,
236 `c162` int DEFAULT NULL,
237 `c163` int DEFAULT NULL,
238 `c164` int DEFAULT NULL,
239 `c165` int DEFAULT NULL,
240 `c166` int DEFAULT NULL,
241 `c167` int DEFAULT NULL,
242 `c168` int DEFAULT NULL,
243 `c169` int DEFAULT NULL,
244 `c170` int DEFAULT NULL,
245 `c171` int DEFAULT NULL,
246 `c172` int DEFAULT NULL,
247 `c173` int DEFAULT NULL,
248 `c174` int DEFAULT NULL,
249 `c175` int DEFAULT NULL,
250 `c176` int DEFAULT NULL,
251 `c177` int DEFAULT NULL,
252 `c178` int DEFAULT NULL,
253 `c179` int DEFAULT NULL,
254 `c180` int DEFAULT NULL,
255 `c181` int DEFAULT NULL,
256 `c182` int DEFAULT NULL,
257 `c183` int DEFAULT NULL,
258 `c184` int DEFAULT NULL,
259 `c185` int DEFAULT NULL,
260 `c186` int DEFAULT NULL,
261 `c187` int DEFAULT NULL,
262 `c188` int DEFAULT NULL,
263 `c189` int DEFAULT NULL,
264 `c190` int DEFAULT NULL,
265 `c191` int DEFAULT NULL,
266 `c192` int DEFAULT NULL,
267 `c193` int DEFAULT NULL,
268 `c194` int DEFAULT NULL,
269 `c195` int DEFAULT NULL,
270 `c196` int DEFAULT NULL,
271 `c197` int DEFAULT NULL,
272 `c198` int DEFAULT NULL,
273 `c199` int DEFAULT NULL,
274 `c200` int DEFAULT NULL,
275 `c201` int DEFAULT NULL,
276 `c202` int DEFAULT NULL,
277 `c203` int DEFAULT NULL,
278 `c204` int DEFAULT NULL,
279 `c205` int DEFAULT NULL,
280 `c206` int DEFAULT NULL,
281 `c207` int DEFAULT NULL,
282 `c208` int DEFAULT NULL,
283 `c209` int DEFAULT NULL,
284 `c210` int DEFAULT NULL,
285 `c211` int DEFAULT NULL,
286 `c212` int DEFAULT NULL,
287 `c213` int DEFAULT NULL,
288 `c214` int DEFAULT NULL,
289 `c215` int DEFAULT NULL,
290 `c216` int DEFAULT NULL,
291 `c217` int DEFAULT NULL,
292 `c218` int DEFAULT NULL,
293 `c219` int DEFAULT NULL,
294 `c220` int DEFAULT NULL,
295 `c221` int DEFAULT NULL,
296 `c222` int DEFAULT NULL,
297 `c223` int DEFAULT NULL,
298 `c224` int DEFAULT NULL,
299 `c225` int DEFAULT NULL,
300 `c226` int DEFAULT NULL,
301 `c227` int DEFAULT NULL,
302 `c228` int DEFAULT NULL,
303 `c229` int DEFAULT NULL,
304 `c230` int DEFAULT NULL,
305 `c231` int DEFAULT NULL,
306 `c232` int DEFAULT NULL,
307 `c233` int DEFAULT NULL,
308 `c234` int DEFAULT NULL,
309 `c235` int DEFAULT NULL,
310 `c236` int DEFAULT NULL,
311 `c237` int DEFAULT NULL,
312 `c238` int DEFAULT NULL,
313 `c239` int DEFAULT NULL,
314 `c240` int DEFAULT NULL,
315 `c241` int DEFAULT NULL,
316 `c242` int DEFAULT NULL,
317 `c243` int DEFAULT NULL,
318 `c244` int DEFAULT NULL,
319 `c245` int DEFAULT NULL,
320 `c246` int DEFAULT NULL,
321 `c247` int DEFAULT NULL,
322 `c248` int DEFAULT NULL,
323 `c249` int DEFAULT NULL,
324 `c250` int DEFAULT NULL,
325 `c251` int DEFAULT NULL,
326 `c252` int DEFAULT NULL,
327 `c253` int DEFAULT NULL,
328 `c254` int DEFAULT NULL,
329 `c255` int DEFAULT NULL,
330 `c256` int DEFAULT NULL,
331 `c257` int DEFAULT NULL,
332 `c258` int DEFAULT NULL,
333 `c259` int DEFAULT NULL,
334 `c260` int DEFAULT NULL,
335 `c261` int DEFAULT NULL,
336 `c262` int DEFAULT NULL,
337 `c263` int DEFAULT NULL,
338 `c264` int DEFAULT NULL,
339 `c265` int DEFAULT NULL,
340 `c266` int DEFAULT NULL,
341 `c267` int DEFAULT NULL,
342 `c268` int DEFAULT NULL,
343 `c269` int DEFAULT NULL,
344 `c270` int DEFAULT NULL,
345 `c271` int DEFAULT NULL,
346 `c272` int DEFAULT NULL,
347 `c273` int DEFAULT NULL,
348 `c274` int DEFAULT NULL,
349 `c275` int DEFAULT NULL,
350 `c276` int DEFAULT NULL,
351 `c277` int DEFAULT NULL,
352 `c278` int DEFAULT NULL,
353 `c279` int DEFAULT NULL,
354 `c280` int DEFAULT NULL,
355 `c281` int DEFAULT NULL,
356 `c282` int DEFAULT NULL,
357 `c283` int DEFAULT NULL,
358 `c284` int DEFAULT NULL,
359 `c285` int DEFAULT NULL,
360 `c286` int DEFAULT NULL,
361 `c287` int DEFAULT NULL,
362 `c288` int DEFAULT NULL,
363 `c289` int DEFAULT NULL,
364 `c290` int DEFAULT NULL,
365 `c291` int DEFAULT NULL,
366 `c292` int DEFAULT NULL,
367 `c293` int DEFAULT NULL,
368 `c294` int DEFAULT NULL,
369 `c295` int DEFAULT NULL,
370 `c296` int DEFAULT NULL,
371 `c297` int DEFAULT NULL,
372 `c298` int DEFAULT NULL,
373 `c299` int DEFAULT NULL,
374 `c300` int DEFAULT NULL,
375 `c301` int DEFAULT NULL,
376 `c302` int DEFAULT NULL,
377 `c303` int DEFAULT NULL,
378 `c304` int DEFAULT NULL,
379 `c305` int DEFAULT NULL,
380 `c306` int DEFAULT NULL,
381 `c307` int DEFAULT NULL,
382 `c308` int DEFAULT NULL,
383 `c309` int DEFAULT NULL,
384 `c310` int DEFAULT NULL,
385 `c311` int DEFAULT NULL,
386 `c312` int DEFAULT NULL,
387 `c313` int DEFAULT NULL,
388 `c314` int DEFAULT NULL,
389 `c315` int DEFAULT NULL,
390 `c316` int DEFAULT NULL,
391 `c317` int DEFAULT NULL,
392 `c318` int DEFAULT NULL,
393 `c319` int DEFAULT NULL,
394 `c320` int DEFAULT NULL,
395 `c321` int DEFAULT NULL,
396 `c322` int DEFAULT NULL,
397 `c323` int DEFAULT NULL,
398 `c324` int DEFAULT NULL,
399 `c325` int DEFAULT NULL,
400 `c326` int DEFAULT NULL,
401 `c327` int DEFAULT NULL,
402 `c328` int DEFAULT NULL,
403 `c329` int DEFAULT NULL,
404 `c330` int DEFAULT NULL,
405 `c331` int DEFAULT NULL,
406 `c332` int DEFAULT NULL,
407 `c333` int DEFAULT NULL,
408 `c334` int DEFAULT NULL,
409 `c335` int DEFAULT NULL,
410 `c336` int DEFAULT NULL,
411 `c337` int DEFAULT NULL,
412 `c338` int DEFAULT NULL,
413 `c339` int DEFAULT NULL,
414 `c340` int DEFAULT NULL,
415 `c341` int DEFAULT NULL,
416 `c342` int DEFAULT NULL,
417 `c343` int DEFAULT NULL,
418 `c344` int DEFAULT NULL,
419 `c345` int DEFAULT NULL,
420 `c346` int DEFAULT NULL,
421 `c347` int DEFAULT NULL,
422 `c348` int DEFAULT NULL,
423 `c349` int DEFAULT NULL,
424 `c350` int DEFAULT NULL,
425 `c351` int DEFAULT NULL,
426 `c352` int DEFAULT NULL,
427 `c353` int DEFAULT NULL,
428 `c354` int DEFAULT NULL,
429 `c355` int DEFAULT NULL,
430 `c356` int DEFAULT NULL,
431 `c357` int DEFAULT NULL,
432 `c358` int DEFAULT NULL,
433 `c359` int DEFAULT NULL,
434 `c360` int DEFAULT NULL,
435 `c361` int DEFAULT NULL,
436 `c362` int DEFAULT NULL,
437 `c363` int DEFAULT NULL,
438 `c364` int DEFAULT NULL,
439 `c365` int DEFAULT NULL,
440 `c366` int DEFAULT NULL,
441 `c367` int DEFAULT NULL,
442 `c368` int DEFAULT NULL,
443 `c369` int DEFAULT NULL,
444 `c370` int DEFAULT NULL,
445 `c371` int DEFAULT NULL,
446 `c372` int DEFAULT NULL,
447 `c373` int DEFAULT NULL,
448 `c374` int DEFAULT NULL,
449 `c375` int DEFAULT NULL,
450 `c376` int DEFAULT NULL,
451 `c377` int DEFAULT NULL,
452 `c378` int DEFAULT NULL,
453 `c379` int DEFAULT NULL,
454 `c380` int DEFAULT NULL,
455 `c381` int DEFAULT NULL,
456 `c382` int DEFAULT NULL,
457 `c383` int DEFAULT NULL,
458 `c384` int DEFAULT NULL,
459 `c385` int DEFAULT NULL,
460 `c386` int DEFAULT NULL,
461 `c387` int DEFAULT NULL,
462 `c388` int DEFAULT NULL,
463 `c389` int DEFAULT NULL,
464 `c390` int DEFAULT NULL,
465 `c391` int DEFAULT NULL,
466 `c392` int DEFAULT NULL,
467 `c393` int DEFAULT NULL,
468 `c394` int DEFAULT NULL,
469 `c395` int DEFAULT NULL,
470 `c396` int DEFAULT NULL,
471 `c397` int DEFAULT NULL,
472 `c398` int DEFAULT NULL,
473 `c399` int DEFAULT NULL,
474 `c400` int DEFAULT NULL,
475 `c401` int DEFAULT NULL,
476 `c402` int DEFAULT NULL,
477 `c403` int DEFAULT NULL,
478 `c404` int DEFAULT NULL,
479 `c405` int DEFAULT NULL,
480 `c406` int DEFAULT NULL,
481 `c407` int DEFAULT NULL,
482 `c408` int DEFAULT NULL,
483 `c409` int DEFAULT NULL,
484 `c410` int DEFAULT NULL,
485 `c411` int DEFAULT NULL,
486 `c412` int DEFAULT NULL,
487 `c413` int DEFAULT NULL,
488 `c414` int DEFAULT NULL,
489 `c415` int DEFAULT NULL,
490 `c416` int DEFAULT NULL,
491 `c417` int DEFAULT NULL,
492 `c418` int DEFAULT NULL,
493 `c419` int DEFAULT NULL,
494 `c420` int DEFAULT NULL,
495 `c421` int DEFAULT NULL,
496 `c422` int DEFAULT NULL,
497 `c423` int DEFAULT NULL,
498 `c424` int DEFAULT NULL,
499 `c425` int DEFAULT NULL,
500 `c426` int DEFAULT NULL,
501 `c427` int DEFAULT NULL,
502 `c428` int DEFAULT NULL,
503 `c429` int DEFAULT NULL,
504 `c430` int DEFAULT NULL,
505 `c431` int DEFAULT NULL,
506 `c432` int DEFAULT NULL,
507 `c433` int DEFAULT NULL,
508 `c434` int DEFAULT NULL,
509 `c435` int DEFAULT NULL,
510 `c436` int DEFAULT NULL,
511 `c437` int DEFAULT NULL,
512 `c438` int DEFAULT NULL,
513 `c439` int DEFAULT NULL,
514 `c440` int DEFAULT NULL,
515 `c441` int DEFAULT NULL,
516 `c442` int DEFAULT NULL,
517 `c443` int DEFAULT NULL,
518 `c444` int DEFAULT NULL,
519 `c445` int DEFAULT NULL,
520 `c446` int DEFAULT NULL,
521 `c447` int DEFAULT NULL,
522 `c448` int DEFAULT NULL,
523 `c449` int DEFAULT NULL,
524 `c450` int DEFAULT NULL,
525 `c451` int DEFAULT NULL,
526 `c452` int DEFAULT NULL,
527 `c453` int DEFAULT NULL,
528 `c454` int DEFAULT NULL,
529 `c455` int DEFAULT NULL,
530 `c456` int DEFAULT NULL,
531 `c457` int DEFAULT NULL,
532 `c458` int DEFAULT NULL,
533 `c459` int DEFAULT NULL,
534 `c460` int DEFAULT NULL,
535 `c461` int DEFAULT NULL,
536 `c462` int DEFAULT NULL,
537 `c463` int DEFAULT NULL,
538 `c464` int DEFAULT NULL,
539 `c465` int DEFAULT NULL,
540 `c466` int DEFAULT NULL,
541 `c467` int DEFAULT NULL,
542 `c468` int DEFAULT NULL,
543 `c469` int DEFAULT NULL,
544 `c470` int DEFAULT NULL,
545 `c471` int DEFAULT NULL,
546 `c472` int DEFAULT NULL,
547 `c473` int DEFAULT NULL,
548 `c474` int DEFAULT NULL,
549 `c475` int DEFAULT NULL,
550 `c476` int DEFAULT NULL,
551 `c477` int DEFAULT NULL,
552 `c478` int DEFAULT NULL,
553 `c479` int DEFAULT NULL,
554 `c480` int DEFAULT NULL,
555 `c481` int DEFAULT NULL,
556 `c482` int DEFAULT NULL,
557 `c483` int DEFAULT NULL,
558 `c484` int DEFAULT NULL,
559 `c485` int DEFAULT NULL,
560 `c486` int DEFAULT NULL,
561 `c487` int DEFAULT NULL,
562 `c488` int DEFAULT NULL,
563 `c489` int DEFAULT NULL,
564 `c490` int DEFAULT NULL,
565 `c491` int DEFAULT NULL,
566 `c492` int DEFAULT NULL,
567 `c493` int DEFAULT NULL,
568 `c494` int DEFAULT NULL,
569 `c495` int DEFAULT NULL,
570 `c496` int DEFAULT NULL,
571 `c497` int DEFAULT NULL,
572 `c498` int DEFAULT NULL,
573 `c499` int DEFAULT NULL,
574 `c500` int DEFAULT NULL,
575 `c501` int DEFAULT NULL,
576 `c502` int DEFAULT NULL,
577 `c503` int DEFAULT NULL,
578 `c504` int DEFAULT NULL,
579 `c505` int DEFAULT NULL,
580 `c506` int DEFAULT NULL,
581 `c507` int DEFAULT NULL,
582 `c508` int DEFAULT NULL,
583 `c509` int DEFAULT NULL,
584 `c510` int DEFAULT NULL,
585 `c511` int DEFAULT NULL,
586 `c512` int DEFAULT NULL,
587 `c513` int DEFAULT NULL,
588 `c514` int DEFAULT NULL,
589 `c515` int DEFAULT NULL,
590 `c516` int DEFAULT NULL,
591 `c517` int DEFAULT NULL,
592 `c518` int DEFAULT NULL,
593 `c519` int DEFAULT NULL,
594 `c520` int DEFAULT NULL,
595 `c521` int DEFAULT NULL,
596 `c522` int DEFAULT NULL,
597 `c523` int DEFAULT NULL,
598 `c524` int DEFAULT NULL,
599 `c525` int DEFAULT NULL,
600 `c526` int DEFAULT NULL,
601 `c527` int DEFAULT NULL,
602 `c528` int DEFAULT NULL,
603 `c529` int DEFAULT NULL,
604 `c530` int DEFAULT NULL,
605 `c531` int DEFAULT NULL,
606 `c532` int DEFAULT NULL,
607 `c533` int DEFAULT NULL,
608 `c534` int DEFAULT NULL,
609 `c535` int DEFAULT NULL,
610 `c536` int DEFAULT NULL,
611 `c537` int DEFAULT NULL,
612 `c538` int DEFAULT NULL,
613 `c539` int DEFAULT NULL,
614 `c540` int DEFAULT NULL,
615 `c541` int DEFAULT NULL,
616 `c542` int DEFAULT NULL,
617 `c543` int DEFAULT NULL,
618 `c544` int DEFAULT NULL,
619 `c545` int DEFAULT NULL,
620 `c546` int DEFAULT NULL,
621 `c547` int DEFAULT NULL,
622 `c548` int DEFAULT NULL,
623 `c549` int DEFAULT NULL,
624 `c550` int DEFAULT NULL,
625 `c551` int DEFAULT NULL,
626 `c552` int DEFAULT NULL,
627 `c553` int DEFAULT NULL,
628 `c554` int DEFAULT NULL,
629 `c555` int DEFAULT NULL,
630 `c556` int DEFAULT NULL,
631 `c557` int DEFAULT NULL,
632 `c558` int DEFAULT NULL,
633 `c559` int DEFAULT NULL,
634 `c560` int DEFAULT NULL,
635 `c561` int DEFAULT NULL,
636 `c562` int DEFAULT NULL,
637 `c563` int DEFAULT NULL,
638 `c564` int DEFAULT NULL,
639 `c565` int DEFAULT NULL,
640 `c566` int DEFAULT NULL,
641 `c567` int DEFAULT NULL,
642 `c568` int DEFAULT NULL,
643 `c569` int DEFAULT NULL,
644 `c570` int DEFAULT NULL,
645 `c571` int DEFAULT NULL,
646 `c572` int DEFAULT NULL,
647 `c573` int DEFAULT NULL,
648 `c574` int DEFAULT NULL,
649 `c575` int DEFAULT NULL,
650 `c576` int DEFAULT NULL,
651 `c577` int DEFAULT NULL,
652 `c578` int DEFAULT NULL,
653 `c579` int DEFAULT NULL,
654 `c580` int DEFAULT NULL,
655 `c581` int DEFAULT NULL,
656 `c582` int DEFAULT NULL,
657 `c583` int DEFAULT NULL,
658 `c584` int DEFAULT NULL,
659 `c585` int DEFAULT NULL,
660 `c586` int DEFAULT NULL,
661 `c587` int DEFAULT NULL,
662 `c588` int DEFAULT NULL,
663 `c589` int DEFAULT NULL,
664 `c590` int DEFAULT NULL,
665 `c591` int DEFAULT NULL,
666 `c592` int DEFAULT NULL,
667 `c593` int DEFAULT NULL,
668 `c594` int DEFAULT NULL,
669 `c595` int DEFAULT NULL,
670 `c596` int DEFAULT NULL,
671 `c597` int DEFAULT NULL,
672 `c598` int DEFAULT NULL,
673 `c599` int DEFAULT NULL,
674 `c600` int DEFAULT NULL,
675 `c601` int DEFAULT NULL,
676 `c602` int DEFAULT NULL,
677 `c603` int DEFAULT NULL,
678 `c604` int DEFAULT NULL,
679 `c605` int DEFAULT NULL,
680 `c606` int DEFAULT NULL,
681 `c607` int DEFAULT NULL,
682 `c608` int DEFAULT NULL,
683 `c609` int DEFAULT NULL,
684 `c610` int DEFAULT NULL,
685 `c611` int DEFAULT NULL,
686 `c612` int DEFAULT NULL,
687 `c613` int DEFAULT NULL,
688 `c614` int DEFAULT NULL,
689 `c615` int DEFAULT NULL,
690 `c616` int DEFAULT NULL,
691 `c617` int DEFAULT NULL,
692 `c618` int DEFAULT NULL,
693 `c619` int DEFAULT NULL,
694 `c620` int DEFAULT NULL,
695 `c621` int DEFAULT NULL,
696 `c622` int DEFAULT NULL,
697 `c623` int DEFAULT NULL,
698 `c624` int DEFAULT NULL,
699 `c625` int DEFAULT NULL,
700 `c626` int DEFAULT NULL,
701 `c627` int DEFAULT NULL,
702 `c628` int DEFAULT NULL,
703 `c629` int DEFAULT NULL,
704 `c630` int DEFAULT NULL,
705 `c631` int DEFAULT NULL,
706 `c632` int DEFAULT NULL,
707 `c633` int DEFAULT NULL,
708 `c634` int DEFAULT NULL,
709 `c635` int DEFAULT NULL,
710 `c636` int DEFAULT NULL,
711 `c637` int DEFAULT NULL,
712 `c638` int DEFAULT NULL,
713 `c639` int DEFAULT NULL,
714 `c640` int DEFAULT NULL,
715 `c641` int DEFAULT NULL,
716 `c642` int DEFAULT NULL,
717 `c643` int DEFAULT NULL,
718 `c644` int DEFAULT NULL,
719 `c645` int DEFAULT NULL,
720 `c646` int DEFAULT NULL,
721 `c647` int DEFAULT NULL,
722 `c648` int DEFAULT NULL,
723 `c649` int DEFAULT NULL,
724 `c650` int DEFAULT NULL,
725 `c651` int DEFAULT NULL,
726 `c652` int DEFAULT NULL,
727 `c653` int DEFAULT NULL,
728 `c654` int DEFAULT NULL,
729 `c655` int DEFAULT NULL,
730 `c656` int DEFAULT NULL,
731 `c657` int DEFAULT NULL,
732 `c658` int DEFAULT NULL,
733 `c659` int DEFAULT NULL,
734 `c660` int DEFAULT NULL,
735 `c661` int DEFAULT NULL,
736 `c662` int DEFAULT NULL,
737 `c663` int DEFAULT NULL,
738 `c664` int DEFAULT NULL,
739 `c665` int DEFAULT NULL,
740 `c666` int DEFAULT NULL,
741 `c667` int DEFAULT NULL,
742 `c668` int DEFAULT NULL,
743 `c669` int DEFAULT NULL,
744 `c670` int DEFAULT NULL,
745 `c671` int DEFAULT NULL,
746 `c672` int DEFAULT NULL,
747 `c673` int DEFAULT NULL,
748 `c674` int DEFAULT NULL,
749 `c675` int DEFAULT NULL,
750 `c676` int DEFAULT NULL,
751 `c677` int DEFAULT NULL,
752 `c678` int DEFAULT NULL,
753 `c679` int DEFAULT NULL,
754 `c680` int DEFAULT NULL,
755 `c681` int DEFAULT NULL,
756 `c682` int DEFAULT NULL,
757 `c683` int DEFAULT NULL,
758 `c684` int DEFAULT NULL,
759 `c685` int DEFAULT NULL,
760 `c686` int DEFAULT NULL,
761 `c687` int DEFAULT NULL,
762 `c688` int DEFAULT NULL,
763 `c689` int DEFAULT NULL,
764 `c690` int DEFAULT NULL,
765 `c691` int DEFAULT NULL,
766 `c692` int DEFAULT NULL,
767 `c693` int DEFAULT NULL,
768 `c694` int DEFAULT NULL,
769 `c695` int DEFAULT NULL,
770 `c696` int DEFAULT NULL,
771 `c697` int DEFAULT NULL,
772 `c698` int DEFAULT NULL,
773 `c699` int DEFAULT NULL,
774 `c700` int DEFAULT NULL,
775 `c701` int DEFAULT NULL,
776 `c702` int DEFAULT NULL,
777 `c703` int DEFAULT NULL,
778 `c704` int DEFAULT NULL,
779 `c705` int DEFAULT NULL,
780 `c706` int DEFAULT NULL,
781 `c707` int DEFAULT NULL,
782 `c708` int DEFAULT NULL,
783 `c709` int DEFAULT NULL,
784 `c710` int DEFAULT NULL,
785 `c711` int DEFAULT NULL,
786 `c712` int DEFAULT NULL,
787 `c713` int DEFAULT NULL,
788 `c714` int DEFAULT NULL,
789 `c715` int DEFAULT NULL,
790 `c716` int DEFAULT NULL,
791 `c717` int DEFAULT NULL,
792 `c718` int DEFAULT NULL,
793 `c719` int DEFAULT NULL,
794 `c720` int DEFAULT NULL,
795 `c721` int DEFAULT NULL,
796 `c722` int DEFAULT NULL,
797 `c723` int DEFAULT NULL,
798 `c724` int DEFAULT NULL,
799 `c725` int DEFAULT NULL,
800 `c726` int DEFAULT NULL,
801 `c727` int DEFAULT NULL,
802 `c728` int DEFAULT NULL,
803 `c729` int DEFAULT NULL,
804 `c730` int DEFAULT NULL,
805 `c731` int DEFAULT NULL,
806 `c732` int DEFAULT NULL,
807 `c733` int DEFAULT NULL,
808 `c734` int DEFAULT NULL,
809 `c735` int DEFAULT NULL,
810 `c736` int DEFAULT NULL,
811 `c737` int DEFAULT NULL,
812 `c738` int DEFAULT NULL,
813 `c739` int DEFAULT NULL,
814 `c740` int DEFAULT NULL,
815 `c741` int DEFAULT NULL,
816 `c742` int DEFAULT NULL,
817 `c743` int DEFAULT NULL,
818 `c744` int DEFAULT NULL,
819 `c745` int DEFAULT NULL,
820 `c746` int DEFAULT NULL,
821 `c747` int DEFAULT NULL,
822 `c748` int DEFAULT NULL,
823 `c749` int DEFAULT NULL,
824 `c750` int DEFAULT NULL,
825 `c751` int DEFAULT NULL,
826 `c752` int DEFAULT NULL,
827 `c753` int DEFAULT NULL,
828 `c754` int DEFAULT NULL,
829 `c755` int DEFAULT NULL,
830 `c756` int DEFAULT NULL,
831 `c757` int DEFAULT NULL,
832 `c758` int DEFAULT NULL,
833 `c759` int DEFAULT NULL,
834 `c760` int DEFAULT NULL,
835 `c761` int DEFAULT NULL,
836 `c762` int DEFAULT NULL,
837 `c763` int DEFAULT NULL,
838 `c764` int DEFAULT NULL,
839 `c765` int DEFAULT NULL,
840 `c766` int DEFAULT NULL,
841 `c767` int DEFAULT NULL,
842 `c768` int DEFAULT NULL,
843 `c769` int DEFAULT NULL,
844 `c770` int DEFAULT NULL,
845 `c771` int DEFAULT NULL,
846 `c772` int DEFAULT NULL,
847 `c773` int DEFAULT NULL,
848 `c774` int DEFAULT NULL,
849 `c775` int DEFAULT NULL,
850 `c776` int DEFAULT NULL,
851 `c777` int DEFAULT NULL,
852 `c778` int DEFAULT NULL,
853 `c779` int DEFAULT NULL,
854 `c780` int DEFAULT NULL,
855 `c781` int DEFAULT NULL,
856 `c782` int DEFAULT NULL,
857 `c783` int DEFAULT NULL,
858 `c784` int DEFAULT NULL,
859 `c785` int DEFAULT NULL,
860 `c786` int DEFAULT NULL,
861 `c787` int DEFAULT NULL,
862 `c788` int DEFAULT NULL,
863 `c789` int DEFAULT NULL,
864 `c790` int DEFAULT NULL,
865 `c791` int DEFAULT NULL,
866 `c792` int DEFAULT NULL,
867 `c793` int DEFAULT NULL,
868 `c794` int DEFAULT NULL,
869 `c795` int DEFAULT NULL,
870 `c796` int DEFAULT NULL,
871 `c797` int DEFAULT NULL,
872 `c798` int DEFAULT NULL,
873 `c799` int DEFAULT NULL,
874 `c800` int DEFAULT NULL,
875 `c801` int DEFAULT NULL,
876 `c802` int DEFAULT NULL,
877 `c803` int DEFAULT NULL,
878 `c804` int DEFAULT NULL,
879 `c805` int DEFAULT NULL,
880 `c806` int DEFAULT NULL,
881 `c807` int DEFAULT NULL,
882 `c808` int DEFAULT NULL,
883 `c809` int DEFAULT NULL,
884 `c810` int DEFAULT NULL,
885 `c811` int DEFAULT NULL,
886 `c812` int DEFAULT NULL,
887 `c813` int DEFAULT NULL,
888 `c814` int DEFAULT NULL,
889 `c815` int DEFAULT NULL,
890 `c816` int DEFAULT NULL,
891 `c817` int DEFAULT NULL,
892 `c818` int DEFAULT NULL,
893 `c819` int DEFAULT NULL,
894 `c820` int DEFAULT NULL,
895 `c821` int DEFAULT NULL,
896 `c822` int DEFAULT NULL,
897 `c823` int DEFAULT NULL,
898 `c824` int DEFAULT NULL,
899 `c825` int DEFAULT NULL,
900 `c826` int DEFAULT NULL,
901 `c827` int DEFAULT NULL,
902 `c828` int DEFAULT NULL,
903 `c829` int DEFAULT NULL,
904 `c830` int DEFAULT NULL,
905 `c831` int DEFAULT NULL,
906 `c832` int DEFAULT NULL,
907 `c833` int DEFAULT NULL,
908 `c834` int DEFAULT NULL,
909 `c835` int DEFAULT NULL,
910 `c836` int DEFAULT NULL,
911 `c837` int DEFAULT NULL,
912 `c838` int DEFAULT NULL,
913 `c839` int DEFAULT NULL,
914 `c840` int DEFAULT NULL,
915 `c841` int DEFAULT NULL,
916 `c842` int DEFAULT NULL,
917 `c843` int DEFAULT NULL,
918 `c844` int DEFAULT NULL,
919 `c845` int DEFAULT NULL,
920 `c846` int DEFAULT NULL,
921 `c847` int DEFAULT NULL,
922 `c848` int DEFAULT NULL,
923 `c849` int DEFAULT NULL,
924 `c850` int DEFAULT NULL,
925 `c851` int DEFAULT NULL,
926 `c852` int DEFAULT NULL,
927 `c853` int DEFAULT NULL,
928 `c854` int DEFAULT NULL,
929 `c855` int DEFAULT NULL,
930 `c856` int DEFAULT NULL,
931 `c857` int DEFAULT NULL,
932 `c858` int DEFAULT NULL,
933 `c859` int DEFAULT NULL,
934 `c860` int DEFAULT NULL,
935 `c861` int DEFAULT NULL,
936 `c862` int DEFAULT NULL,
937 `c863` int DEFAULT NULL,
938 `c864` int DEFAULT NULL,
939 `c865` int DEFAULT NULL,
940 `c866` int DEFAULT NULL,
941 `c867` int DEFAULT NULL,
942 `c868` int DEFAULT NULL,
943 `c869` int DEFAULT NULL,
944 `c870` int DEFAULT NULL,
945 `c871` int DEFAULT NULL,
946 `c872` int DEFAULT NULL,
947 `c873` int DEFAULT NULL,
948 `c874` int DEFAULT NULL,
949 `c875` int DEFAULT NULL,
950 `c876` int DEFAULT NULL,
951 `c877` int DEFAULT NULL,
952 `c878` int DEFAULT NULL,
953 `c879` int DEFAULT NULL,
954 `c880` int DEFAULT NULL,
955 `c881` int DEFAULT NULL,
956 `c882` int DEFAULT NULL,
957 `c883` int DEFAULT NULL,
958 `c884` int DEFAULT NULL,
959 `c885` int DEFAULT NULL,
960 `c886` int DEFAULT NULL,
961 `c887` int DEFAULT NULL,
962 `c888` int DEFAULT NULL,
963 `c889` int DEFAULT NULL,
964 `c890` int DEFAULT NULL,
965 `c891` int DEFAULT NULL,
966 `c892` int DEFAULT NULL,
967 `c893` int DEFAULT NULL,
968 `c894` int DEFAULT NULL,
969 `c895` int DEFAULT NULL,
970 `c896` int DEFAULT NULL,
971 `c897` int DEFAULT NULL,
972 `c898` int DEFAULT NULL,
973 `c899` int DEFAULT NULL,
974 `c900` int DEFAULT NULL,
975 `c901` int DEFAULT NULL,
976 `c902` int DEFAULT NULL,
977 `c903` int DEFAULT NULL,
978 `c904` int DEFAULT NULL,
979 `c905` int DEFAULT NULL,
980 `c906` int DEFAULT NULL,
981 `c907` int DEFAULT NULL,
982 `c908` int DEFAULT NULL,
983 `c909` int DEFAULT NULL,
984 `c910` int DEFAULT NULL,
985 `c911` int DEFAULT NULL,
986 `c912` int DEFAULT NULL,
987 `c913` int DEFAULT NULL,
988 `c914` int DEFAULT NULL,
989 `c915` int DEFAULT NULL,
990 `c916` int DEFAULT NULL,
991 `c917` int DEFAULT NULL,
992 `c918` int DEFAULT NULL,
993 `c919` int DEFAULT NULL,
994 `c920` int DEFAULT NULL,
995 `c921` int DEFAULT NULL,
996 `c922` int DEFAULT NULL,
997 `c923` int DEFAULT NULL,
998 `c924` int DEFAULT NULL,
999 `c925` int DEFAULT NULL,
1000 `c926` int DEFAULT NULL,
1001 `c927` int DEFAULT NULL,
1002 `c928` int DEFAULT NULL,
1003 `c929` int DEFAULT NULL,
1004 `c930` int DEFAULT NULL,
1005 `c931` int DEFAULT NULL,
1006 `c932` int DEFAULT NULL,
1007 `c933` int DEFAULT NULL,
1008 `c934` int DEFAULT NULL,
1009 `c935` int DEFAULT NULL,
1010 `c936` int DEFAULT NULL,
1011 `c937` int DEFAULT NULL,
1012 `c938` int DEFAULT NULL,
1013 `c939` int DEFAULT NULL,
1014 `c940` int DEFAULT NULL,
1015 `c941` int DEFAULT NULL,
1016 `c942` int DEFAULT NULL,
1017 `c943` int DEFAULT NULL,
1018 `c944` int DEFAULT NULL,
1019 `c945` int DEFAULT NULL,
1020 `c946` int DEFAULT NULL,
1021 `c947` int DEFAULT NULL,
1022 `c948` int DEFAULT NULL,
1023 `c949` int DEFAULT NULL,
1024 `c950` int DEFAULT NULL,
1025 `c951` int DEFAULT NULL,
1026 `c952` int DEFAULT NULL,
1027 `c953` int DEFAULT NULL,
1028 `c954` int DEFAULT NULL,
1029 `c955` int DEFAULT NULL,
1030 `c956` int DEFAULT NULL,
1031 `c957` int DEFAULT NULL,
1032 `c958` int DEFAULT NULL,
1033 `c959` int DEFAULT NULL,
1034 `c960` int DEFAULT NULL,
1035 `c961` int DEFAULT NULL,
1036 `c962` int DEFAULT NULL,
1037 `c963` int DEFAULT NULL,
1038 `c964` int DEFAULT NULL,
1039 `c965` int DEFAULT NULL,
1040 `c966` int DEFAULT NULL,
1041 `c967` int DEFAULT NULL,
1042 `c968` int DEFAULT NULL,
1043 `c969` int DEFAULT NULL,
1044 `c970` int DEFAULT NULL,
1045 `c971` int DEFAULT NULL,
1046 `c972` int DEFAULT NULL,
1047 `c973` int DEFAULT NULL,
1048 `c974` int DEFAULT NULL,
1049 `c975` int DEFAULT NULL,
1050 `c976` int DEFAULT NULL,
1051 `c977` int DEFAULT NULL,
1052 `c978` int DEFAULT NULL,
1053 `c979` int DEFAULT NULL,
1054 `c980` int DEFAULT NULL,
1055 `c981` int DEFAULT NULL,
1056 `c982` int DEFAULT NULL,
1057 `c983` int DEFAULT NULL,
1058 `c984` int DEFAULT NULL,
1059 `c985` int DEFAULT NULL,
1060 `c986` int DEFAULT NULL,
1061 `c987` int DEFAULT NULL,
1062 `c988` int DEFAULT NULL,
1063 `c989` int DEFAULT NULL,
1064 `c990` int DEFAULT NULL,
1065 `c991` int DEFAULT NULL,
1066 `c992` int DEFAULT NULL,
1067 `c993` int DEFAULT NULL,
1068 `c994` int DEFAULT NULL,
1069 `c995` int DEFAULT NULL,
1070 `c996` int DEFAULT NULL,
1071 `c997` int DEFAULT NULL,
1072 `c998` int DEFAULT NULL,
1073 `c999` int DEFAULT NULL,
1074 PRIMARY KEY (`c1`)
1075 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1076 Get rec(type:id) is t3 CREATE TABLE `t3` (
1077 `c1` varchar(32) NOT NULL,
1078 `c2` varchar(1024) DEFAULT NULL,
1079 PRIMARY KEY (`c1`)
1080 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1081 Get rec(type:id) is t4 CREATE TABLE `t4` (
1082 `c1` int NOT NULL,
1083 `c2` blob,
1084 PRIMARY KEY (`c1`)
1085 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1086 Get rec(type:id) is t5 CREATE TABLE `t5` (
1087 `c1` int NOT NULL,
1088 `c2` int DEFAULT NULL,
1089 PRIMARY KEY (`c1`),
1090 KEY `c2` (`c2`),
1091 CONSTRAINT `t5_ibfk_1` FOREIGN KEY (`c2`) REFERENCES `t4` (`c1`) ON UPDATE CASCADE
1092 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1093 Get rec(type:id) is t7 CREATE TABLE `t7` (
1094 `c1` int NOT NULL,
1095 `c2` int DEFAULT NULL,
1096 `c3` char(255) DEFAULT NULL,
1097 `c4` geometry NOT NULL /*!80003 SRID 0 */,
1098 PRIMARY KEY (`c1`),
1099 SPATIAL KEY `c4` (`c4`)
1100 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1101 # 2. Test with alter table
1102 ALTER TABLE t1 ADD COLUMN c11 INT;
1103 Get rec(type:id) is t1 CREATE TABLE `t1` (
1104 `c1` varchar(32) NOT NULL,
1105 `c2` varchar(1024) DEFAULT NULL,
1106 `c3` tinyblob,
1107 `c4` blob,
1108 `c5` mediumblob,
1109 `c6` longblob,
1110 `c7` text,
1111 `c8` int DEFAULT NULL,
1112 `c9` float DEFAULT NULL,
1113 `c10` double DEFAULT NULL,
1114 `c11` int DEFAULT NULL,
1115 PRIMARY KEY (`c1`),
1116 UNIQUE KEY `idx2` (`c6`(50)),
1117 KEY `idx1` (`c4`(20))
1118 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
1119 ALTER TABLE t3 ADD COLUMN c3 INT;
1120 Get rec(type:id) is t3 CREATE TABLE `t3` (
1121 `c1` varchar(32) NOT NULL,
1122 `c2` varchar(1024) DEFAULT NULL,
1123 `c3` int DEFAULT NULL,
1124 PRIMARY KEY (`c1`)
1125 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1126 ALTER TABLE t2 DROP COLUMN c100;
1127 ALTER TABLE t2 DROP COLUMN c101;
1128 ALTER TABLE t2 DROP COLUMN c102;
1129 ALTER TABLE t2 DROP COLUMN c103;
1130 ALTER TABLE t2 DROP COLUMN c104;
1131 Get rec(type:id) is t2 CREATE TABLE `t2` (
1132 `c1` int NOT NULL,
1133 `c2` int DEFAULT NULL,
1134 `c3` int DEFAULT NULL,
1135 `c4` int DEFAULT NULL,
1136 `c5` int DEFAULT NULL,
1137 `c6` int DEFAULT NULL,
1138 `c7` int DEFAULT NULL,
1139 `c8` int DEFAULT NULL,
1140 `c9` int DEFAULT NULL,
1141 `c10` int DEFAULT NULL,
1142 `c11` int DEFAULT NULL,
1143 `c12` int DEFAULT NULL,
1144 `c13` int DEFAULT NULL,
1145 `c14` int DEFAULT NULL,
1146 `c15` int DEFAULT NULL,
1147 `c16` int DEFAULT NULL,
1148 `c17` int DEFAULT NULL,
1149 `c18` int DEFAULT NULL,
1150 `c19` int DEFAULT NULL,
1151 `c20` int DEFAULT NULL,
1152 `c21` int DEFAULT NULL,
1153 `c22` int DEFAULT NULL,
1154 `c23` int DEFAULT NULL,
1155 `c24` int DEFAULT NULL,
1156 `c25` int DEFAULT NULL,
1157 `c26` int DEFAULT NULL,
1158 `c27` int DEFAULT NULL,
1159 `c28` int DEFAULT NULL,
1160 `c29` int DEFAULT NULL,
1161 `c30` int DEFAULT NULL,
1162 `c31` int DEFAULT NULL,
1163 `c32` int DEFAULT NULL,
1164 `c33` int DEFAULT NULL,
1165 `c34` int DEFAULT NULL,
1166 `c35` int DEFAULT NULL,
1167 `c36` int DEFAULT NULL,
1168 `c37` int DEFAULT NULL,
1169 `c38` int DEFAULT NULL,
1170 `c39` int DEFAULT NULL,
1171 `c40` int DEFAULT NULL,
1172 `c41` int DEFAULT NULL,
1173 `c42` int DEFAULT NULL,
1174 `c43` int DEFAULT NULL,
1175 `c44` int DEFAULT NULL,
1176 `c45` int DEFAULT NULL,
1177 `c46` int DEFAULT NULL,
1178 `c47` int DEFAULT NULL,
1179 `c48` int DEFAULT NULL,
1180 `c49` int DEFAULT NULL,
1181 `c50` int DEFAULT NULL,
1182 `c51` int DEFAULT NULL,
1183 `c52` int DEFAULT NULL,
1184 `c53` int DEFAULT NULL,
1185 `c54` int DEFAULT NULL,
1186 `c55` int DEFAULT NULL,
1187 `c56` int DEFAULT NULL,
1188 `c57` int DEFAULT NULL,
1189 `c58` int DEFAULT NULL,
1190 `c59` int DEFAULT NULL,
1191 `c60` int DEFAULT NULL,
1192 `c61` int DEFAULT NULL,
1193 `c62` int DEFAULT NULL,
1194 `c63` int DEFAULT NULL,
1195 `c64` int DEFAULT NULL,
1196 `c65` int DEFAULT NULL,
1197 `c66` int DEFAULT NULL,
1198 `c67` int DEFAULT NULL,
1199 `c68` int DEFAULT NULL,
1200 `c69` int DEFAULT NULL,
1201 `c70` int DEFAULT NULL,
1202 `c71` int DEFAULT NULL,
1203 `c72` int DEFAULT NULL,
1204 `c73` int DEFAULT NULL,
1205 `c74` int DEFAULT NULL,
1206 `c75` int DEFAULT NULL,
1207 `c76` int DEFAULT NULL,
1208 `c77` int DEFAULT NULL,
1209 `c78` int DEFAULT NULL,
1210 `c79` int DEFAULT NULL,
1211 `c80` int DEFAULT NULL,
1212 `c81` int DEFAULT NULL,
1213 `c82` int DEFAULT NULL,
1214 `c83` int DEFAULT NULL,
1215 `c84` int DEFAULT NULL,
1216 `c85` int DEFAULT NULL,
1217 `c86` int DEFAULT NULL,
1218 `c87` int DEFAULT NULL,
1219 `c88` int DEFAULT NULL,
1220 `c89` int DEFAULT NULL,
1221 `c90` int DEFAULT NULL,
1222 `c91` int DEFAULT NULL,
1223 `c92` int DEFAULT NULL,
1224 `c93` int DEFAULT NULL,
1225 `c94` int DEFAULT NULL,
1226 `c95` int DEFAULT NULL,
1227 `c96` int DEFAULT NULL,
1228 `c97` int DEFAULT NULL,
1229 `c98` int DEFAULT NULL,
1230 `c99` int DEFAULT NULL,
1231 `c105` int DEFAULT NULL,
1232 `c106` int DEFAULT NULL,
1233 `c107` int DEFAULT NULL,
1234 `c108` int DEFAULT NULL,
1235 `c109` int DEFAULT NULL,
1236 `c110` int DEFAULT NULL,
1237 `c111` int DEFAULT NULL,
1238 `c112` int DEFAULT NULL,
1239 `c113` int DEFAULT NULL,
1240 `c114` int DEFAULT NULL,
1241 `c115` int DEFAULT NULL,
1242 `c116` int DEFAULT NULL,
1243 `c117` int DEFAULT NULL,
1244 `c118` int DEFAULT NULL,
1245 `c119` int DEFAULT NULL,
1246 `c120` int DEFAULT NULL,
1247 `c121` int DEFAULT NULL,
1248 `c122` int DEFAULT NULL,
1249 `c123` int DEFAULT NULL,
1250 `c124` int DEFAULT NULL,
1251 `c125` int DEFAULT NULL,
1252 `c126` int DEFAULT NULL,
1253 `c127` int DEFAULT NULL,
1254 `c128` int DEFAULT NULL,
1255 `c129` int DEFAULT NULL,
1256 `c130` int DEFAULT NULL,
1257 `c131` int DEFAULT NULL,
1258 `c132` int DEFAULT NULL,
1259 `c133` int DEFAULT NULL,
1260 `c134` int DEFAULT NULL,
1261 `c135` int DEFAULT NULL,
1262 `c136` int DEFAULT NULL,
1263 `c137` int DEFAULT NULL,
1264 `c138` int DEFAULT NULL,
1265 `c139` int DEFAULT NULL,
1266 `c140` int DEFAULT NULL,
1267 `c141` int DEFAULT NULL,
1268 `c142` int DEFAULT NULL,
1269 `c143` int DEFAULT NULL,
1270 `c144` int DEFAULT NULL,
1271 `c145` int DEFAULT NULL,
1272 `c146` int DEFAULT NULL,
1273 `c147` int DEFAULT NULL,
1274 `c148` int DEFAULT NULL,
1275 `c149` int DEFAULT NULL,
1276 `c150` int DEFAULT NULL,
1277 `c151` int DEFAULT NULL,
1278 `c152` int DEFAULT NULL,
1279 `c153` int DEFAULT NULL,
1280 `c154` int DEFAULT NULL,
1281 `c155` int DEFAULT NULL,
1282 `c156` int DEFAULT NULL,
1283 `c157` int DEFAULT NULL,
1284 `c158` int DEFAULT NULL,
1285 `c159` int DEFAULT NULL,
1286 `c160` int DEFAULT NULL,
1287 `c161` int DEFAULT NULL,
1288 `c162` int DEFAULT NULL,
1289 `c163` int DEFAULT NULL,
1290 `c164` int DEFAULT NULL,
1291 `c165` int DEFAULT NULL,
1292 `c166` int DEFAULT NULL,
1293 `c167` int DEFAULT NULL,
1294 `c168` int DEFAULT NULL,
1295 `c169` int DEFAULT NULL,
1296 `c170` int DEFAULT NULL,
1297 `c171` int DEFAULT NULL,
1298 `c172` int DEFAULT NULL,
1299 `c173` int DEFAULT NULL,
1300 `c174` int DEFAULT NULL,
1301 `c175` int DEFAULT NULL,
1302 `c176` int DEFAULT NULL,
1303 `c177` int DEFAULT NULL,
1304 `c178` int DEFAULT NULL,
1305 `c179` int DEFAULT NULL,
1306 `c180` int DEFAULT NULL,
1307 `c181` int DEFAULT NULL,
1308 `c182` int DEFAULT NULL,
1309 `c183` int DEFAULT NULL,
1310 `c184` int DEFAULT NULL,
1311 `c185` int DEFAULT NULL,
1312 `c186` int DEFAULT NULL,
1313 `c187` int DEFAULT NULL,
1314 `c188` int DEFAULT NULL,
1315 `c189` int DEFAULT NULL,
1316 `c190` int DEFAULT NULL,
1317 `c191` int DEFAULT NULL,
1318 `c192` int DEFAULT NULL,
1319 `c193` int DEFAULT NULL,
1320 `c194` int DEFAULT NULL,
1321 `c195` int DEFAULT NULL,
1322 `c196` int DEFAULT NULL,
1323 `c197` int DEFAULT NULL,
1324 `c198` int DEFAULT NULL,
1325 `c199` int DEFAULT NULL,
1326 `c200` int DEFAULT NULL,
1327 `c201` int DEFAULT NULL,
1328 `c202` int DEFAULT NULL,
1329 `c203` int DEFAULT NULL,
1330 `c204` int DEFAULT NULL,
1331 `c205` int DEFAULT NULL,
1332 `c206` int DEFAULT NULL,
1333 `c207` int DEFAULT NULL,
1334 `c208` int DEFAULT NULL,
1335 `c209` int DEFAULT NULL,
1336 `c210` int DEFAULT NULL,
1337 `c211` int DEFAULT NULL,
1338 `c212` int DEFAULT NULL,
1339 `c213` int DEFAULT NULL,
1340 `c214` int DEFAULT NULL,
1341 `c215` int DEFAULT NULL,
1342 `c216` int DEFAULT NULL,
1343 `c217` int DEFAULT NULL,
1344 `c218` int DEFAULT NULL,
1345 `c219` int DEFAULT NULL,
1346 `c220` int DEFAULT NULL,
1347 `c221` int DEFAULT NULL,
1348 `c222` int DEFAULT NULL,
1349 `c223` int DEFAULT NULL,
1350 `c224` int DEFAULT NULL,
1351 `c225` int DEFAULT NULL,
1352 `c226` int DEFAULT NULL,
1353 `c227` int DEFAULT NULL,
1354 `c228` int DEFAULT NULL,
1355 `c229` int DEFAULT NULL,
1356 `c230` int DEFAULT NULL,
1357 `c231` int DEFAULT NULL,
1358 `c232` int DEFAULT NULL,
1359 `c233` int DEFAULT NULL,
1360 `c234` int DEFAULT NULL,
1361 `c235` int DEFAULT NULL,
1362 `c236` int DEFAULT NULL,
1363 `c237` int DEFAULT NULL,
1364 `c238` int DEFAULT NULL,
1365 `c239` int DEFAULT NULL,
1366 `c240` int DEFAULT NULL,
1367 `c241` int DEFAULT NULL,
1368 `c242` int DEFAULT NULL,
1369 `c243` int DEFAULT NULL,
1370 `c244` int DEFAULT NULL,
1371 `c245` int DEFAULT NULL,
1372 `c246` int DEFAULT NULL,
1373 `c247` int DEFAULT NULL,
1374 `c248` int DEFAULT NULL,
1375 `c249` int DEFAULT NULL,
1376 `c250` int DEFAULT NULL,
1377 `c251` int DEFAULT NULL,
1378 `c252` int DEFAULT NULL,
1379 `c253` int DEFAULT NULL,
1380 `c254` int DEFAULT NULL,
1381 `c255` int DEFAULT NULL,
1382 `c256` int DEFAULT NULL,
1383 `c257` int DEFAULT NULL,
1384 `c258` int DEFAULT NULL,
1385 `c259` int DEFAULT NULL,
1386 `c260` int DEFAULT NULL,
1387 `c261` int DEFAULT NULL,
1388 `c262` int DEFAULT NULL,
1389 `c263` int DEFAULT NULL,
1390 `c264` int DEFAULT NULL,
1391 `c265` int DEFAULT NULL,
1392 `c266` int DEFAULT NULL,
1393 `c267` int DEFAULT NULL,
1394 `c268` int DEFAULT NULL,
1395 `c269` int DEFAULT NULL,
1396 `c270` int DEFAULT NULL,
1397 `c271` int DEFAULT NULL,
1398 `c272` int DEFAULT NULL,
1399 `c273` int DEFAULT NULL,
1400 `c274` int DEFAULT NULL,
1401 `c275` int DEFAULT NULL,
1402 `c276` int DEFAULT NULL,
1403 `c277` int DEFAULT NULL,
1404 `c278` int DEFAULT NULL,
1405 `c279` int DEFAULT NULL,
1406 `c280` int DEFAULT NULL,
1407 `c281` int DEFAULT NULL,
1408 `c282` int DEFAULT NULL,
1409 `c283` int DEFAULT NULL,
1410 `c284` int DEFAULT NULL,
1411 `c285` int DEFAULT NULL,
1412 `c286` int DEFAULT NULL,
1413 `c287` int DEFAULT NULL,
1414 `c288` int DEFAULT NULL,
1415 `c289` int DEFAULT NULL,
1416 `c290` int DEFAULT NULL,
1417 `c291` int DEFAULT NULL,
1418 `c292` int DEFAULT NULL,
1419 `c293` int DEFAULT NULL,
1420 `c294` int DEFAULT NULL,
1421 `c295` int DEFAULT NULL,
1422 `c296` int DEFAULT NULL,
1423 `c297` int DEFAULT NULL,
1424 `c298` int DEFAULT NULL,
1425 `c299` int DEFAULT NULL,
1426 `c300` int DEFAULT NULL,
1427 `c301` int DEFAULT NULL,
1428 `c302` int DEFAULT NULL,
1429 `c303` int DEFAULT NULL,
1430 `c304` int DEFAULT NULL,
1431 `c305` int DEFAULT NULL,
1432 `c306` int DEFAULT NULL,
1433 `c307` int DEFAULT NULL,
1434 `c308` int DEFAULT NULL,
1435 `c309` int DEFAULT NULL,
1436 `c310` int DEFAULT NULL,
1437 `c311` int DEFAULT NULL,
1438 `c312` int DEFAULT NULL,
1439 `c313` int DEFAULT NULL,
1440 `c314` int DEFAULT NULL,
1441 `c315` int DEFAULT NULL,
1442 `c316` int DEFAULT NULL,
1443 `c317` int DEFAULT NULL,
1444 `c318` int DEFAULT NULL,
1445 `c319` int DEFAULT NULL,
1446 `c320` int DEFAULT NULL,
1447 `c321` int DEFAULT NULL,
1448 `c322` int DEFAULT NULL,
1449 `c323` int DEFAULT NULL,
1450 `c324` int DEFAULT NULL,
1451 `c325` int DEFAULT NULL,
1452 `c326` int DEFAULT NULL,
1453 `c327` int DEFAULT NULL,
1454 `c328` int DEFAULT NULL,
1455 `c329` int DEFAULT NULL,
1456 `c330` int DEFAULT NULL,
1457 `c331` int DEFAULT NULL,
1458 `c332` int DEFAULT NULL,
1459 `c333` int DEFAULT NULL,
1460 `c334` int DEFAULT NULL,
1461 `c335` int DEFAULT NULL,
1462 `c336` int DEFAULT NULL,
1463 `c337` int DEFAULT NULL,
1464 `c338` int DEFAULT NULL,
1465 `c339` int DEFAULT NULL,
1466 `c340` int DEFAULT NULL,
1467 `c341` int DEFAULT NULL,
1468 `c342` int DEFAULT NULL,
1469 `c343` int DEFAULT NULL,
1470 `c344` int DEFAULT NULL,
1471 `c345` int DEFAULT NULL,
1472 `c346` int DEFAULT NULL,
1473 `c347` int DEFAULT NULL,
1474 `c348` int DEFAULT NULL,
1475 `c349` int DEFAULT NULL,
1476 `c350` int DEFAULT NULL,
1477 `c351` int DEFAULT NULL,
1478 `c352` int DEFAULT NULL,
1479 `c353` int DEFAULT NULL,
1480 `c354` int DEFAULT NULL,
1481 `c355` int DEFAULT NULL,
1482 `c356` int DEFAULT NULL,
1483 `c357` int DEFAULT NULL,
1484 `c358` int DEFAULT NULL,
1485 `c359` int DEFAULT NULL,
1486 `c360` int DEFAULT NULL,
1487 `c361` int DEFAULT NULL,
1488 `c362` int DEFAULT NULL,
1489 `c363` int DEFAULT NULL,
1490 `c364` int DEFAULT NULL,
1491 `c365` int DEFAULT NULL,
1492 `c366` int DEFAULT NULL,
1493 `c367` int DEFAULT NULL,
1494 `c368` int DEFAULT NULL,
1495 `c369` int DEFAULT NULL,
1496 `c370` int DEFAULT NULL,
1497 `c371` int DEFAULT NULL,
1498 `c372` int DEFAULT NULL,
1499 `c373` int DEFAULT NULL,
1500 `c374` int DEFAULT NULL,
1501 `c375` int DEFAULT NULL,
1502 `c376` int DEFAULT NULL,
1503 `c377` int DEFAULT NULL,
1504 `c378` int DEFAULT NULL,
1505 `c379` int DEFAULT NULL,
1506 `c380` int DEFAULT NULL,
1507 `c381` int DEFAULT NULL,
1508 `c382` int DEFAULT NULL,
1509 `c383` int DEFAULT NULL,
1510 `c384` int DEFAULT NULL,
1511 `c385` int DEFAULT NULL,
1512 `c386` int DEFAULT NULL,
1513 `c387` int DEFAULT NULL,
1514 `c388` int DEFAULT NULL,
1515 `c389` int DEFAULT NULL,
1516 `c390` int DEFAULT NULL,
1517 `c391` int DEFAULT NULL,
1518 `c392` int DEFAULT NULL,
1519 `c393` int DEFAULT NULL,
1520 `c394` int DEFAULT NULL,
1521 `c395` int DEFAULT NULL,
1522 `c396` int DEFAULT NULL,
1523 `c397` int DEFAULT NULL,
1524 `c398` int DEFAULT NULL,
1525 `c399` int DEFAULT NULL,
1526 `c400` int DEFAULT NULL,
1527 `c401` int DEFAULT NULL,
1528 `c402` int DEFAULT NULL,
1529 `c403` int DEFAULT NULL,
1530 `c404` int DEFAULT NULL,
1531 `c405` int DEFAULT NULL,
1532 `c406` int DEFAULT NULL,
1533 `c407` int DEFAULT NULL,
1534 `c408` int DEFAULT NULL,
1535 `c409` int DEFAULT NULL,
1536 `c410` int DEFAULT NULL,
1537 `c411` int DEFAULT NULL,
1538 `c412` int DEFAULT NULL,
1539 `c413` int DEFAULT NULL,
1540 `c414` int DEFAULT NULL,
1541 `c415` int DEFAULT NULL,
1542 `c416` int DEFAULT NULL,
1543 `c417` int DEFAULT NULL,
1544 `c418` int DEFAULT NULL,
1545 `c419` int DEFAULT NULL,
1546 `c420` int DEFAULT NULL,
1547 `c421` int DEFAULT NULL,
1548 `c422` int DEFAULT NULL,
1549 `c423` int DEFAULT NULL,
1550 `c424` int DEFAULT NULL,
1551 `c425` int DEFAULT NULL,
1552 `c426` int DEFAULT NULL,
1553 `c427` int DEFAULT NULL,
1554 `c428` int DEFAULT NULL,
1555 `c429` int DEFAULT NULL,
1556 `c430` int DEFAULT NULL,
1557 `c431` int DEFAULT NULL,
1558 `c432` int DEFAULT NULL,
1559 `c433` int DEFAULT NULL,
1560 `c434` int DEFAULT NULL,
1561 `c435` int DEFAULT NULL,
1562 `c436` int DEFAULT NULL,
1563 `c437` int DEFAULT NULL,
1564 `c438` int DEFAULT NULL,
1565 `c439` int DEFAULT NULL,
1566 `c440` int DEFAULT NULL,
1567 `c441` int DEFAULT NULL,
1568 `c442` int DEFAULT NULL,
1569 `c443` int DEFAULT NULL,
1570 `c444` int DEFAULT NULL,
1571 `c445` int DEFAULT NULL,
1572 `c446` int DEFAULT NULL,
1573 `c447` int DEFAULT NULL,
1574 `c448` int DEFAULT NULL,
1575 `c449` int DEFAULT NULL,
1576 `c450` int DEFAULT NULL,
1577 `c451` int DEFAULT NULL,
1578 `c452` int DEFAULT NULL,
1579 `c453` int DEFAULT NULL,
1580 `c454` int DEFAULT NULL,
1581 `c455` int DEFAULT NULL,
1582 `c456` int DEFAULT NULL,
1583 `c457` int DEFAULT NULL,
1584 `c458` int DEFAULT NULL,
1585 `c459` int DEFAULT NULL,
1586 `c460` int DEFAULT NULL,
1587 `c461` int DEFAULT NULL,
1588 `c462` int DEFAULT NULL,
1589 `c463` int DEFAULT NULL,
1590 `c464` int DEFAULT NULL,
1591 `c465` int DEFAULT NULL,
1592 `c466` int DEFAULT NULL,
1593 `c467` int DEFAULT NULL,
1594 `c468` int DEFAULT NULL,
1595 `c469` int DEFAULT NULL,
1596 `c470` int DEFAULT NULL,
1597 `c471` int DEFAULT NULL,
1598 `c472` int DEFAULT NULL,
1599 `c473` int DEFAULT NULL,
1600 `c474` int DEFAULT NULL,
1601 `c475` int DEFAULT NULL,
1602 `c476` int DEFAULT NULL,
1603 `c477` int DEFAULT NULL,
1604 `c478` int DEFAULT NULL,
1605 `c479` int DEFAULT NULL,
1606 `c480` int DEFAULT NULL,
1607 `c481` int DEFAULT NULL,
1608 `c482` int DEFAULT NULL,
1609 `c483` int DEFAULT NULL,
1610 `c484` int DEFAULT NULL,
1611 `c485` int DEFAULT NULL,
1612 `c486` int DEFAULT NULL,
1613 `c487` int DEFAULT NULL,
1614 `c488` int DEFAULT NULL,
1615 `c489` int DEFAULT NULL,
1616 `c490` int DEFAULT NULL,
1617 `c491` int DEFAULT NULL,
1618 `c492` int DEFAULT NULL,
1619 `c493` int DEFAULT NULL,
1620 `c494` int DEFAULT NULL,
1621 `c495` int DEFAULT NULL,
1622 `c496` int DEFAULT NULL,
1623 `c497` int DEFAULT NULL,
1624 `c498` int DEFAULT NULL,
1625 `c499` int DEFAULT NULL,
1626 `c500` int DEFAULT NULL,
1627 `c501` int DEFAULT NULL,
1628 `c502` int DEFAULT NULL,
1629 `c503` int DEFAULT NULL,
1630 `c504` int DEFAULT NULL,
1631 `c505` int DEFAULT NULL,
1632 `c506` int DEFAULT NULL,
1633 `c507` int DEFAULT NULL,
1634 `c508` int DEFAULT NULL,
1635 `c509` int DEFAULT NULL,
1636 `c510` int DEFAULT NULL,
1637 `c511` int DEFAULT NULL,
1638 `c512` int DEFAULT NULL,
1639 `c513` int DEFAULT NULL,
1640 `c514` int DEFAULT NULL,
1641 `c515` int DEFAULT NULL,
1642 `c516` int DEFAULT NULL,
1643 `c517` int DEFAULT NULL,
1644 `c518` int DEFAULT NULL,
1645 `c519` int DEFAULT NULL,
1646 `c520` int DEFAULT NULL,
1647 `c521` int DEFAULT NULL,
1648 `c522` int DEFAULT NULL,
1649 `c523` int DEFAULT NULL,
1650 `c524` int DEFAULT NULL,
1651 `c525` int DEFAULT NULL,
1652 `c526` int DEFAULT NULL,
1653 `c527` int DEFAULT NULL,
1654 `c528` int DEFAULT NULL,
1655 `c529` int DEFAULT NULL,
1656 `c530` int DEFAULT NULL,
1657 `c531` int DEFAULT NULL,
1658 `c532` int DEFAULT NULL,
1659 `c533` int DEFAULT NULL,
1660 `c534` int DEFAULT NULL,
1661 `c535` int DEFAULT NULL,
1662 `c536` int DEFAULT NULL,
1663 `c537` int DEFAULT NULL,
1664 `c538` int DEFAULT NULL,
1665 `c539` int DEFAULT NULL,
1666 `c540` int DEFAULT NULL,
1667 `c541` int DEFAULT NULL,
1668 `c542` int DEFAULT NULL,
1669 `c543` int DEFAULT NULL,
1670 `c544` int DEFAULT NULL,
1671 `c545` int DEFAULT NULL,
1672 `c546` int DEFAULT NULL,
1673 `c547` int DEFAULT NULL,
1674 `c548` int DEFAULT NULL,
1675 `c549` int DEFAULT NULL,
1676 `c550` int DEFAULT NULL,
1677 `c551` int DEFAULT NULL,
1678 `c552` int DEFAULT NULL,
1679 `c553` int DEFAULT NULL,
1680 `c554` int DEFAULT NULL,
1681 `c555` int DEFAULT NULL,
1682 `c556` int DEFAULT NULL,
1683 `c557` int DEFAULT NULL,
1684 `c558` int DEFAULT NULL,
1685 `c559` int DEFAULT NULL,
1686 `c560` int DEFAULT NULL,
1687 `c561` int DEFAULT NULL,
1688 `c562` int DEFAULT NULL,
1689 `c563` int DEFAULT NULL,
1690 `c564` int DEFAULT NULL,
1691 `c565` int DEFAULT NULL,
1692 `c566` int DEFAULT NULL,
1693 `c567` int DEFAULT NULL,
1694 `c568` int DEFAULT NULL,
1695 `c569` int DEFAULT NULL,
1696 `c570` int DEFAULT NULL,
1697 `c571` int DEFAULT NULL,
1698 `c572` int DEFAULT NULL,
1699 `c573` int DEFAULT NULL,
1700 `c574` int DEFAULT NULL,
1701 `c575` int DEFAULT NULL,
1702 `c576` int DEFAULT NULL,
1703 `c577` int DEFAULT NULL,
1704 `c578` int DEFAULT NULL,
1705 `c579` int DEFAULT NULL,
1706 `c580` int DEFAULT NULL,
1707 `c581` int DEFAULT NULL,
1708 `c582` int DEFAULT NULL,
1709 `c583` int DEFAULT NULL,
1710 `c584` int DEFAULT NULL,
1711 `c585` int DEFAULT NULL,
1712 `c586` int DEFAULT NULL,
1713 `c587` int DEFAULT NULL,
1714 `c588` int DEFAULT NULL,
1715 `c589` int DEFAULT NULL,
1716 `c590` int DEFAULT NULL,
1717 `c591` int DEFAULT NULL,
1718 `c592` int DEFAULT NULL,
1719 `c593` int DEFAULT NULL,
1720 `c594` int DEFAULT NULL,
1721 `c595` int DEFAULT NULL,
1722 `c596` int DEFAULT NULL,
1723 `c597` int DEFAULT NULL,
1724 `c598` int DEFAULT NULL,
1725 `c599` int DEFAULT NULL,
1726 `c600` int DEFAULT NULL,
1727 `c601` int DEFAULT NULL,
1728 `c602` int DEFAULT NULL,
1729 `c603` int DEFAULT NULL,
1730 `c604` int DEFAULT NULL,
1731 `c605` int DEFAULT NULL,
1732 `c606` int DEFAULT NULL,
1733 `c607` int DEFAULT NULL,
1734 `c608` int DEFAULT NULL,
1735 `c609` int DEFAULT NULL,
1736 `c610` int DEFAULT NULL,
1737 `c611` int DEFAULT NULL,
1738 `c612` int DEFAULT NULL,
1739 `c613` int DEFAULT NULL,
1740 `c614` int DEFAULT NULL,
1741 `c615` int DEFAULT NULL,
1742 `c616` int DEFAULT NULL,
1743 `c617` int DEFAULT NULL,
1744 `c618` int DEFAULT NULL,
1745 `c619` int DEFAULT NULL,
1746 `c620` int DEFAULT NULL,
1747 `c621` int DEFAULT NULL,
1748 `c622` int DEFAULT NULL,
1749 `c623` int DEFAULT NULL,
1750 `c624` int DEFAULT NULL,
1751 `c625` int DEFAULT NULL,
1752 `c626` int DEFAULT NULL,
1753 `c627` int DEFAULT NULL,
1754 `c628` int DEFAULT NULL,
1755 `c629` int DEFAULT NULL,
1756 `c630` int DEFAULT NULL,
1757 `c631` int DEFAULT NULL,
1758 `c632` int DEFAULT NULL,
1759 `c633` int DEFAULT NULL,
1760 `c634` int DEFAULT NULL,
1761 `c635` int DEFAULT NULL,
1762 `c636` int DEFAULT NULL,
1763 `c637` int DEFAULT NULL,
1764 `c638` int DEFAULT NULL,
1765 `c639` int DEFAULT NULL,
1766 `c640` int DEFAULT NULL,
1767 `c641` int DEFAULT NULL,
1768 `c642` int DEFAULT NULL,
1769 `c643` int DEFAULT NULL,
1770 `c644` int DEFAULT NULL,
1771 `c645` int DEFAULT NULL,
1772 `c646` int DEFAULT NULL,
1773 `c647` int DEFAULT NULL,
1774 `c648` int DEFAULT NULL,
1775 `c649` int DEFAULT NULL,
1776 `c650` int DEFAULT NULL,
1777 `c651` int DEFAULT NULL,
1778 `c652` int DEFAULT NULL,
1779 `c653` int DEFAULT NULL,
1780 `c654` int DEFAULT NULL,
1781 `c655` int DEFAULT NULL,
1782 `c656` int DEFAULT NULL,
1783 `c657` int DEFAULT NULL,
1784 `c658` int DEFAULT NULL,
1785 `c659` int DEFAULT NULL,
1786 `c660` int DEFAULT NULL,
1787 `c661` int DEFAULT NULL,
1788 `c662` int DEFAULT NULL,
1789 `c663` int DEFAULT NULL,
1790 `c664` int DEFAULT NULL,
1791 `c665` int DEFAULT NULL,
1792 `c666` int DEFAULT NULL,
1793 `c667` int DEFAULT NULL,
1794 `c668` int DEFAULT NULL,
1795 `c669` int DEFAULT NULL,
1796 `c670` int DEFAULT NULL,
1797 `c671` int DEFAULT NULL,
1798 `c672` int DEFAULT NULL,
1799 `c673` int DEFAULT NULL,
1800 `c674` int DEFAULT NULL,
1801 `c675` int DEFAULT NULL,
1802 `c676` int DEFAULT NULL,
1803 `c677` int DEFAULT NULL,
1804 `c678` int DEFAULT NULL,
1805 `c679` int DEFAULT NULL,
1806 `c680` int DEFAULT NULL,
1807 `c681` int DEFAULT NULL,
1808 `c682` int DEFAULT NULL,
1809 `c683` int DEFAULT NULL,
1810 `c684` int DEFAULT NULL,
1811 `c685` int DEFAULT NULL,
1812 `c686` int DEFAULT NULL,
1813 `c687` int DEFAULT NULL,
1814 `c688` int DEFAULT NULL,
1815 `c689` int DEFAULT NULL,
1816 `c690` int DEFAULT NULL,
1817 `c691` int DEFAULT NULL,
1818 `c692` int DEFAULT NULL,
1819 `c693` int DEFAULT NULL,
1820 `c694` int DEFAULT NULL,
1821 `c695` int DEFAULT NULL,
1822 `c696` int DEFAULT NULL,
1823 `c697` int DEFAULT NULL,
1824 `c698` int DEFAULT NULL,
1825 `c699` int DEFAULT NULL,
1826 `c700` int DEFAULT NULL,
1827 `c701` int DEFAULT NULL,
1828 `c702` int DEFAULT NULL,
1829 `c703` int DEFAULT NULL,
1830 `c704` int DEFAULT NULL,
1831 `c705` int DEFAULT NULL,
1832 `c706` int DEFAULT NULL,
1833 `c707` int DEFAULT NULL,
1834 `c708` int DEFAULT NULL,
1835 `c709` int DEFAULT NULL,
1836 `c710` int DEFAULT NULL,
1837 `c711` int DEFAULT NULL,
1838 `c712` int DEFAULT NULL,
1839 `c713` int DEFAULT NULL,
1840 `c714` int DEFAULT NULL,
1841 `c715` int DEFAULT NULL,
1842 `c716` int DEFAULT NULL,
1843 `c717` int DEFAULT NULL,
1844 `c718` int DEFAULT NULL,
1845 `c719` int DEFAULT NULL,
1846 `c720` int DEFAULT NULL,
1847 `c721` int DEFAULT NULL,
1848 `c722` int DEFAULT NULL,
1849 `c723` int DEFAULT NULL,
1850 `c724` int DEFAULT NULL,
1851 `c725` int DEFAULT NULL,
1852 `c726` int DEFAULT NULL,
1853 `c727` int DEFAULT NULL,
1854 `c728` int DEFAULT NULL,
1855 `c729` int DEFAULT NULL,
1856 `c730` int DEFAULT NULL,
1857 `c731` int DEFAULT NULL,
1858 `c732` int DEFAULT NULL,
1859 `c733` int DEFAULT NULL,
1860 `c734` int DEFAULT NULL,
1861 `c735` int DEFAULT NULL,
1862 `c736` int DEFAULT NULL,
1863 `c737` int DEFAULT NULL,
1864 `c738` int DEFAULT NULL,
1865 `c739` int DEFAULT NULL,
1866 `c740` int DEFAULT NULL,
1867 `c741` int DEFAULT NULL,
1868 `c742` int DEFAULT NULL,
1869 `c743` int DEFAULT NULL,
1870 `c744` int DEFAULT NULL,
1871 `c745` int DEFAULT NULL,
1872 `c746` int DEFAULT NULL,
1873 `c747` int DEFAULT NULL,
1874 `c748` int DEFAULT NULL,
1875 `c749` int DEFAULT NULL,
1876 `c750` int DEFAULT NULL,
1877 `c751` int DEFAULT NULL,
1878 `c752` int DEFAULT NULL,
1879 `c753` int DEFAULT NULL,
1880 `c754` int DEFAULT NULL,
1881 `c755` int DEFAULT NULL,
1882 `c756` int DEFAULT NULL,
1883 `c757` int DEFAULT NULL,
1884 `c758` int DEFAULT NULL,
1885 `c759` int DEFAULT NULL,
1886 `c760` int DEFAULT NULL,
1887 `c761` int DEFAULT NULL,
1888 `c762` int DEFAULT NULL,
1889 `c763` int DEFAULT NULL,
1890 `c764` int DEFAULT NULL,
1891 `c765` int DEFAULT NULL,
1892 `c766` int DEFAULT NULL,
1893 `c767` int DEFAULT NULL,
1894 `c768` int DEFAULT NULL,
1895 `c769` int DEFAULT NULL,
1896 `c770` int DEFAULT NULL,
1897 `c771` int DEFAULT NULL,
1898 `c772` int DEFAULT NULL,
1899 `c773` int DEFAULT NULL,
1900 `c774` int DEFAULT NULL,
1901 `c775` int DEFAULT NULL,
1902 `c776` int DEFAULT NULL,
1903 `c777` int DEFAULT NULL,
1904 `c778` int DEFAULT NULL,
1905 `c779` int DEFAULT NULL,
1906 `c780` int DEFAULT NULL,
1907 `c781` int DEFAULT NULL,
1908 `c782` int DEFAULT NULL,
1909 `c783` int DEFAULT NULL,
1910 `c784` int DEFAULT NULL,
1911 `c785` int DEFAULT NULL,
1912 `c786` int DEFAULT NULL,
1913 `c787` int DEFAULT NULL,
1914 `c788` int DEFAULT NULL,
1915 `c789` int DEFAULT NULL,
1916 `c790` int DEFAULT NULL,
1917 `c791` int DEFAULT NULL,
1918 `c792` int DEFAULT NULL,
1919 `c793` int DEFAULT NULL,
1920 `c794` int DEFAULT NULL,
1921 `c795` int DEFAULT NULL,
1922 `c796` int DEFAULT NULL,
1923 `c797` int DEFAULT NULL,
1924 `c798` int DEFAULT NULL,
1925 `c799` int DEFAULT NULL,
1926 `c800` int DEFAULT NULL,
1927 `c801` int DEFAULT NULL,
1928 `c802` int DEFAULT NULL,
1929 `c803` int DEFAULT NULL,
1930 `c804` int DEFAULT NULL,
1931 `c805` int DEFAULT NULL,
1932 `c806` int DEFAULT NULL,
1933 `c807` int DEFAULT NULL,
1934 `c808` int DEFAULT NULL,
1935 `c809` int DEFAULT NULL,
1936 `c810` int DEFAULT NULL,
1937 `c811` int DEFAULT NULL,
1938 `c812` int DEFAULT NULL,
1939 `c813` int DEFAULT NULL,
1940 `c814` int DEFAULT NULL,
1941 `c815` int DEFAULT NULL,
1942 `c816` int DEFAULT NULL,
1943 `c817` int DEFAULT NULL,
1944 `c818` int DEFAULT NULL,
1945 `c819` int DEFAULT NULL,
1946 `c820` int DEFAULT NULL,
1947 `c821` int DEFAULT NULL,
1948 `c822` int DEFAULT NULL,
1949 `c823` int DEFAULT NULL,
1950 `c824` int DEFAULT NULL,
1951 `c825` int DEFAULT NULL,
1952 `c826` int DEFAULT NULL,
1953 `c827` int DEFAULT NULL,
1954 `c828` int DEFAULT NULL,
1955 `c829` int DEFAULT NULL,
1956 `c830` int DEFAULT NULL,
1957 `c831` int DEFAULT NULL,
1958 `c832` int DEFAULT NULL,
1959 `c833` int DEFAULT NULL,
1960 `c834` int DEFAULT NULL,
1961 `c835` int DEFAULT NULL,
1962 `c836` int DEFAULT NULL,
1963 `c837` int DEFAULT NULL,
1964 `c838` int DEFAULT NULL,
1965 `c839` int DEFAULT NULL,
1966 `c840` int DEFAULT NULL,
1967 `c841` int DEFAULT NULL,
1968 `c842` int DEFAULT NULL,
1969 `c843` int DEFAULT NULL,
1970 `c844` int DEFAULT NULL,
1971 `c845` int DEFAULT NULL,
1972 `c846` int DEFAULT NULL,
1973 `c847` int DEFAULT NULL,
1974 `c848` int DEFAULT NULL,
1975 `c849` int DEFAULT NULL,
1976 `c850` int DEFAULT NULL,
1977 `c851` int DEFAULT NULL,
1978 `c852` int DEFAULT NULL,
1979 `c853` int DEFAULT NULL,
1980 `c854` int DEFAULT NULL,
1981 `c855` int DEFAULT NULL,
1982 `c856` int DEFAULT NULL,
1983 `c857` int DEFAULT NULL,
1984 `c858` int DEFAULT NULL,
1985 `c859` int DEFAULT NULL,
1986 `c860` int DEFAULT NULL,
1987 `c861` int DEFAULT NULL,
1988 `c862` int DEFAULT NULL,
1989 `c863` int DEFAULT NULL,
1990 `c864` int DEFAULT NULL,
1991 `c865` int DEFAULT NULL,
1992 `c866` int DEFAULT NULL,
1993 `c867` int DEFAULT NULL,
1994 `c868` int DEFAULT NULL,
1995 `c869` int DEFAULT NULL,
1996 `c870` int DEFAULT NULL,
1997 `c871` int DEFAULT NULL,
1998 `c872` int DEFAULT NULL,
1999 `c873` int DEFAULT NULL,
2000 `c874` int DEFAULT NULL,
2001 `c875` int DEFAULT NULL,
2002 `c876` int DEFAULT NULL,
2003 `c877` int DEFAULT NULL,
2004 `c878` int DEFAULT NULL,
2005 `c879` int DEFAULT NULL,
2006 `c880` int DEFAULT NULL,
2007 `c881` int DEFAULT NULL,
2008 `c882` int DEFAULT NULL,
2009 `c883` int DEFAULT NULL,
2010 `c884` int DEFAULT NULL,
2011 `c885` int DEFAULT NULL,
2012 `c886` int DEFAULT NULL,
2013 `c887` int DEFAULT NULL,
2014 `c888` int DEFAULT NULL,
2015 `c889` int DEFAULT NULL,
2016 `c890` int DEFAULT NULL,
2017 `c891` int DEFAULT NULL,
2018 `c892` int DEFAULT NULL,
2019 `c893` int DEFAULT NULL,
2020 `c894` int DEFAULT NULL,
2021 `c895` int DEFAULT NULL,
2022 `c896` int DEFAULT NULL,
2023 `c897` int DEFAULT NULL,
2024 `c898` int DEFAULT NULL,
2025 `c899` int DEFAULT NULL,
2026 `c900` int DEFAULT NULL,
2027 `c901` int DEFAULT NULL,
2028 `c902` int DEFAULT NULL,
2029 `c903` int DEFAULT NULL,
2030 `c904` int DEFAULT NULL,
2031 `c905` int DEFAULT NULL,
2032 `c906` int DEFAULT NULL,
2033 `c907` int DEFAULT NULL,
2034 `c908` int DEFAULT NULL,
2035 `c909` int DEFAULT NULL,
2036 `c910` int DEFAULT NULL,
2037 `c911` int DEFAULT NULL,
2038 `c912` int DEFAULT NULL,
2039 `c913` int DEFAULT NULL,
2040 `c914` int DEFAULT NULL,
2041 `c915` int DEFAULT NULL,
2042 `c916` int DEFAULT NULL,
2043 `c917` int DEFAULT NULL,
2044 `c918` int DEFAULT NULL,
2045 `c919` int DEFAULT NULL,
2046 `c920` int DEFAULT NULL,
2047 `c921` int DEFAULT NULL,
2048 `c922` int DEFAULT NULL,
2049 `c923` int DEFAULT NULL,
2050 `c924` int DEFAULT NULL,
2051 `c925` int DEFAULT NULL,
2052 `c926` int DEFAULT NULL,
2053 `c927` int DEFAULT NULL,
2054 `c928` int DEFAULT NULL,
2055 `c929` int DEFAULT NULL,
2056 `c930` int DEFAULT NULL,
2057 `c931` int DEFAULT NULL,
2058 `c932` int DEFAULT NULL,
2059 `c933` int DEFAULT NULL,
2060 `c934` int DEFAULT NULL,
2061 `c935` int DEFAULT NULL,
2062 `c936` int DEFAULT NULL,
2063 `c937` int DEFAULT NULL,
2064 `c938` int DEFAULT NULL,
2065 `c939` int DEFAULT NULL,
2066 `c940` int DEFAULT NULL,
2067 `c941` int DEFAULT NULL,
2068 `c942` int DEFAULT NULL,
2069 `c943` int DEFAULT NULL,
2070 `c944` int DEFAULT NULL,
2071 `c945` int DEFAULT NULL,
2072 `c946` int DEFAULT NULL,
2073 `c947` int DEFAULT NULL,
2074 `c948` int DEFAULT NULL,
2075 `c949` int DEFAULT NULL,
2076 `c950` int DEFAULT NULL,
2077 `c951` int DEFAULT NULL,
2078 `c952` int DEFAULT NULL,
2079 `c953` int DEFAULT NULL,
2080 `c954` int DEFAULT NULL,
2081 `c955` int DEFAULT NULL,
2082 `c956` int DEFAULT NULL,
2083 `c957` int DEFAULT NULL,
2084 `c958` int DEFAULT NULL,
2085 `c959` int DEFAULT NULL,
2086 `c960` int DEFAULT NULL,
2087 `c961` int DEFAULT NULL,
2088 `c962` int DEFAULT NULL,
2089 `c963` int DEFAULT NULL,
2090 `c964` int DEFAULT NULL,
2091 `c965` int DEFAULT NULL,
2092 `c966` int DEFAULT NULL,
2093 `c967` int DEFAULT NULL,
2094 `c968` int DEFAULT NULL,
2095 `c969` int DEFAULT NULL,
2096 `c970` int DEFAULT NULL,
2097 `c971` int DEFAULT NULL,
2098 `c972` int DEFAULT NULL,
2099 `c973` int DEFAULT NULL,
2100 `c974` int DEFAULT NULL,
2101 `c975` int DEFAULT NULL,
2102 `c976` int DEFAULT NULL,
2103 `c977` int DEFAULT NULL,
2104 `c978` int DEFAULT NULL,
2105 `c979` int DEFAULT NULL,
2106 `c980` int DEFAULT NULL,
2107 `c981` int DEFAULT NULL,
2108 `c982` int DEFAULT NULL,
2109 `c983` int DEFAULT NULL,
2110 `c984` int DEFAULT NULL,
2111 `c985` int DEFAULT NULL,
2112 `c986` int DEFAULT NULL,
2113 `c987` int DEFAULT NULL,
2114 `c988` int DEFAULT NULL,
2115 `c989` int DEFAULT NULL,
2116 `c990` int DEFAULT NULL,
2117 `c991` int DEFAULT NULL,
2118 `c992` int DEFAULT NULL,
2119 `c993` int DEFAULT NULL,
2120 `c994` int DEFAULT NULL,
2121 `c995` int DEFAULT NULL,
2122 `c996` int DEFAULT NULL,
2123 `c997` int DEFAULT NULL,
2124 `c998` int DEFAULT NULL,
2125 `c999` int DEFAULT NULL,
2126 PRIMARY KEY (`c1`)
2127 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2128 ALTER TABLE t7 MODIFY c2 BIGINT NOT NULL;
2129 Get rec(type:id) is t7 CREATE TABLE `t7` (
2130 `c1` int NOT NULL,
2131 `c2` bigint NOT NULL,
2132 `c3` char(255) DEFAULT NULL,
2133 `c4` geometry NOT NULL /*!80003 SRID 0 */,
2134 PRIMARY KEY (`c1`),
2135 SPATIAL KEY `c4` (`c4`)
2136 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2137 ALTER TABLE t3 ADD FOREIGN KEY(c3) REFERENCES t2(c1);
2138 SHOW CREATE TABLE t3;
2139 Table Create Table
2140 t3 CREATE TABLE `t3` (
2141 `c1` varchar(32) NOT NULL,
2142 `c2` varchar(1024) DEFAULT NULL,
2143 `c3` int DEFAULT NULL,
2144 PRIMARY KEY (`c1`),
2145 KEY `c3` (`c3`),
2146 CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`c3`) REFERENCES `t2` (`c1`)
2147 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2148 Get rec(type:id) is t3 CREATE TABLE `t3` (
2149 `c1` varchar(32) NOT NULL,
2150 `c2` varchar(1024) DEFAULT NULL,
2151 `c3` int DEFAULT NULL,
2152 PRIMARY KEY (`c1`),
2153 KEY `c3` (`c3`),
2154 CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`c3`) REFERENCES `t2` (`c1`)
2155 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2156 ALTER TABLE t5 DROP FOREIGN KEY t5_ibfk_1;
2157 Get rec(type:id) is t5 CREATE TABLE `t5` (
2158 `c1` int NOT NULL,
2159 `c2` int DEFAULT NULL,
2160 PRIMARY KEY (`c1`),
2161 KEY `c2` (`c2`)
2162 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2163 ALTER TABLE t7 ADD INDEX idx3(c2,c3(50));
2164 Get rec(type:id) is t7 CREATE TABLE `t7` (
2165 `c1` int NOT NULL,
2166 `c2` bigint NOT NULL,
2167 `c3` char(255) DEFAULT NULL,
2168 `c4` geometry NOT NULL /*!80003 SRID 0 */,
2169 PRIMARY KEY (`c1`),
2170 SPATIAL KEY `c4` (`c4`),
2171 KEY `idx3` (`c2`,`c3`(50))
2172 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2173 ALTER TABLE t1 DROP PRIMARY KEY, DROP COLUMN c1, ADD c1 BIGINT PRIMARY
2174 KEY;
2175 Get rec(type:id) is t1 CREATE TABLE `t1` (
2176 `c2` varchar(1024) DEFAULT NULL,
2177 `c3` tinyblob,
2178 `c4` blob,
2179 `c5` mediumblob,
2180 `c6` longblob,
2181 `c7` text,
2182 `c8` int DEFAULT NULL,
2183 `c9` float DEFAULT NULL,
2184 `c10` double DEFAULT NULL,
2185 `c11` int DEFAULT NULL,
2186 `c1` bigint NOT NULL,
2187 PRIMARY KEY (`c1`),
2188 UNIQUE KEY `idx2` (`c6`(50)),
2189 KEY `idx1` (`c4`(20))
2190 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
2191 ALTER TABLE t1 ADD FULLTEXT INDEX(c2), ALGORITHM=INPLACE;
2192 Warnings:
2193 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
2194 Get rec(type:id) is t1 CREATE TABLE `t1` (
2195 `c2` varchar(1024) DEFAULT NULL,
2196 `c3` tinyblob,
2197 `c4` blob,
2198 `c5` mediumblob,
2199 `c6` longblob,
2200 `c7` text,
2201 `c8` int DEFAULT NULL,
2202 `c9` float DEFAULT NULL,
2203 `c10` double DEFAULT NULL,
2204 `c11` int DEFAULT NULL,
2205 `c1` bigint NOT NULL,
2206 PRIMARY KEY (`c1`),
2207 UNIQUE KEY `idx2` (`c6`(50)),
2208 KEY `idx1` (`c4`(20)),
2209 FULLTEXT KEY `c2` (`c2`)
2210 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
2211 ALTER TABLE t1 DROP INDEX c2;
2212 Get rec(type:id) is t1 CREATE TABLE `t1` (
2213 `c2` varchar(1024) DEFAULT NULL,
2214 `c3` tinyblob,
2215 `c4` blob,
2216 `c5` mediumblob,
2217 `c6` longblob,
2218 `c7` text,
2219 `c8` int DEFAULT NULL,
2220 `c9` float DEFAULT NULL,
2221 `c10` double DEFAULT NULL,
2222 `c11` int DEFAULT NULL,
2223 `c1` bigint NOT NULL,
2224 PRIMARY KEY (`c1`),
2225 UNIQUE KEY `idx2` (`c6`(50)),
2226 KEY `idx1` (`c4`(20))
2227 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=latin1
2228 TRUNCATE TABLE t7;
2229 Get rec(type:id) is t7 CREATE TABLE `t7` (
2230 `c1` int NOT NULL,
2231 `c2` bigint NOT NULL,
2232 `c3` char(255) DEFAULT NULL,
2233 `c4` geometry NOT NULL /*!80003 SRID 0 */,
2234 PRIMARY KEY (`c1`),
2235 SPATIAL KEY `c4` (`c4`),
2236 KEY `idx3` (`c2`,`c3`(50))
2237 ) /*!50100 TABLESPACE `innodb_system` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2238 DROP TABLE t1, t3, t2, t4, t5, t7;
2239 UNINSTALL PLUGIN daemon_memcached;
2240 SET GLOBAL innodb_file_per_table=ON;
2241 # Case 1. Test with CREATE TABLES
2242 CREATE TABLE t1(c1 VARCHAR(32),
2243 c2 VARCHAR(1024),
2244 c3 TINYBLOB,
2245 c4 BLOB,
2246 c5 MEDIUMBLOB,
2247 c6 LONGBLOB,
2248 c7 TEXT,
2249 c8 INT,
2250 c9 FLOAT,
2251 c10 DOUBLE,
2252 primary key(c1),
2253 KEY idx1(c4(20)),
2254 UNIQUE KEY idx2(c6(50)))
2255 CHARSET latin1 ENGINE = INNODB;
2256 # Create table t2 with large schema (huge number of columns)
2257 # Create table with small schema
2258 CREATE TABLE t3(c1 VARCHAR(32),
2259 c2 VARCHAR(1024),
2260 PRIMARY KEY(c1))
2261 ENGINE = INNODB;
2262 # Create tables with constraints
2263 CREATE TABLE t4 (c1 INT PRIMARY KEY,
2264 c2 BLOB)
2265 ENGINE = INNODB;
2266 CREATE TABLE t5 (c1 INT PRIMARY KEY,
2267 c2 INT,
2268 FOREIGN KEY (c2) REFERENCES t4(c1) ON UPDATE CASCADE)
2269 ENGINE = INNODB;
2270 # Create table with spatial index
2271 CREATE TABLE t7(c1 INT PRIMARY KEY,
2272 c2 INT,
2273 c3 CHAR(255),
2274 c4 GEOMETRY NOT NULL SRID 0,
2275 SPATIAL INDEX(c4))
2276 ENGINE = INNODB;
2277 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
2278 Warnings:
2279 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
2280 Get rec(type:id) is t1 CREATE TABLE `t1` (
2281 `c1` varchar(32) NOT NULL,
2282 `c2` varchar(1024) DEFAULT NULL,
2283 `c3` tinyblob,
2284 `c4` blob,
2285 `c5` mediumblob,
2286 `c6` longblob,
2287 `c7` text,
2288 `c8` int DEFAULT NULL,
2289 `c9` float DEFAULT NULL,
2290 `c10` double DEFAULT NULL,
2291 PRIMARY KEY (`c1`),
2292 UNIQUE KEY `idx2` (`c6`(50)),
2293 KEY `idx1` (`c4`(20))
2294 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
2295 Get rec(type:id) is t2 CREATE TABLE `t2` (
2296 `c1` int NOT NULL,
2297 `c2` int DEFAULT NULL,
2298 `c3` int DEFAULT NULL,
2299 `c4` int DEFAULT NULL,
2300 `c5` int DEFAULT NULL,
2301 `c6` int DEFAULT NULL,
2302 `c7` int DEFAULT NULL,
2303 `c8` int DEFAULT NULL,
2304 `c9` int DEFAULT NULL,
2305 `c10` int DEFAULT NULL,
2306 `c11` int DEFAULT NULL,
2307 `c12` int DEFAULT NULL,
2308 `c13` int DEFAULT NULL,
2309 `c14` int DEFAULT NULL,
2310 `c15` int DEFAULT NULL,
2311 `c16` int DEFAULT NULL,
2312 `c17` int DEFAULT NULL,
2313 `c18` int DEFAULT NULL,
2314 `c19` int DEFAULT NULL,
2315 `c20` int DEFAULT NULL,
2316 `c21` int DEFAULT NULL,
2317 `c22` int DEFAULT NULL,
2318 `c23` int DEFAULT NULL,
2319 `c24` int DEFAULT NULL,
2320 `c25` int DEFAULT NULL,
2321 `c26` int DEFAULT NULL,
2322 `c27` int DEFAULT NULL,
2323 `c28` int DEFAULT NULL,
2324 `c29` int DEFAULT NULL,
2325 `c30` int DEFAULT NULL,
2326 `c31` int DEFAULT NULL,
2327 `c32` int DEFAULT NULL,
2328 `c33` int DEFAULT NULL,
2329 `c34` int DEFAULT NULL,
2330 `c35` int DEFAULT NULL,
2331 `c36` int DEFAULT NULL,
2332 `c37` int DEFAULT NULL,
2333 `c38` int DEFAULT NULL,
2334 `c39` int DEFAULT NULL,
2335 `c40` int DEFAULT NULL,
2336 `c41` int DEFAULT NULL,
2337 `c42` int DEFAULT NULL,
2338 `c43` int DEFAULT NULL,
2339 `c44` int DEFAULT NULL,
2340 `c45` int DEFAULT NULL,
2341 `c46` int DEFAULT NULL,
2342 `c47` int DEFAULT NULL,
2343 `c48` int DEFAULT NULL,
2344 `c49` int DEFAULT NULL,
2345 `c50` int DEFAULT NULL,
2346 `c51` int DEFAULT NULL,
2347 `c52` int DEFAULT NULL,
2348 `c53` int DEFAULT NULL,
2349 `c54` int DEFAULT NULL,
2350 `c55` int DEFAULT NULL,
2351 `c56` int DEFAULT NULL,
2352 `c57` int DEFAULT NULL,
2353 `c58` int DEFAULT NULL,
2354 `c59` int DEFAULT NULL,
2355 `c60` int DEFAULT NULL,
2356 `c61` int DEFAULT NULL,
2357 `c62` int DEFAULT NULL,
2358 `c63` int DEFAULT NULL,
2359 `c64` int DEFAULT NULL,
2360 `c65` int DEFAULT NULL,
2361 `c66` int DEFAULT NULL,
2362 `c67` int DEFAULT NULL,
2363 `c68` int DEFAULT NULL,
2364 `c69` int DEFAULT NULL,
2365 `c70` int DEFAULT NULL,
2366 `c71` int DEFAULT NULL,
2367 `c72` int DEFAULT NULL,
2368 `c73` int DEFAULT NULL,
2369 `c74` int DEFAULT NULL,
2370 `c75` int DEFAULT NULL,
2371 `c76` int DEFAULT NULL,
2372 `c77` int DEFAULT NULL,
2373 `c78` int DEFAULT NULL,
2374 `c79` int DEFAULT NULL,
2375 `c80` int DEFAULT NULL,
2376 `c81` int DEFAULT NULL,
2377 `c82` int DEFAULT NULL,
2378 `c83` int DEFAULT NULL,
2379 `c84` int DEFAULT NULL,
2380 `c85` int DEFAULT NULL,
2381 `c86` int DEFAULT NULL,
2382 `c87` int DEFAULT NULL,
2383 `c88` int DEFAULT NULL,
2384 `c89` int DEFAULT NULL,
2385 `c90` int DEFAULT NULL,
2386 `c91` int DEFAULT NULL,
2387 `c92` int DEFAULT NULL,
2388 `c93` int DEFAULT NULL,
2389 `c94` int DEFAULT NULL,
2390 `c95` int DEFAULT NULL,
2391 `c96` int DEFAULT NULL,
2392 `c97` int DEFAULT NULL,
2393 `c98` int DEFAULT NULL,
2394 `c99` int DEFAULT NULL,
2395 `c100` int DEFAULT NULL,
2396 `c101` int DEFAULT NULL,
2397 `c102` int DEFAULT NULL,
2398 `c103` int DEFAULT NULL,
2399 `c104` int DEFAULT NULL,
2400 `c105` int DEFAULT NULL,
2401 `c106` int DEFAULT NULL,
2402 `c107` int DEFAULT NULL,
2403 `c108` int DEFAULT NULL,
2404 `c109` int DEFAULT NULL,
2405 `c110` int DEFAULT NULL,
2406 `c111` int DEFAULT NULL,
2407 `c112` int DEFAULT NULL,
2408 `c113` int DEFAULT NULL,
2409 `c114` int DEFAULT NULL,
2410 `c115` int DEFAULT NULL,
2411 `c116` int DEFAULT NULL,
2412 `c117` int DEFAULT NULL,
2413 `c118` int DEFAULT NULL,
2414 `c119` int DEFAULT NULL,
2415 `c120` int DEFAULT NULL,
2416 `c121` int DEFAULT NULL,
2417 `c122` int DEFAULT NULL,
2418 `c123` int DEFAULT NULL,
2419 `c124` int DEFAULT NULL,
2420 `c125` int DEFAULT NULL,
2421 `c126` int DEFAULT NULL,
2422 `c127` int DEFAULT NULL,
2423 `c128` int DEFAULT NULL,
2424 `c129` int DEFAULT NULL,
2425 `c130` int DEFAULT NULL,
2426 `c131` int DEFAULT NULL,
2427 `c132` int DEFAULT NULL,
2428 `c133` int DEFAULT NULL,
2429 `c134` int DEFAULT NULL,
2430 `c135` int DEFAULT NULL,
2431 `c136` int DEFAULT NULL,
2432 `c137` int DEFAULT NULL,
2433 `c138` int DEFAULT NULL,
2434 `c139` int DEFAULT NULL,
2435 `c140` int DEFAULT NULL,
2436 `c141` int DEFAULT NULL,
2437 `c142` int DEFAULT NULL,
2438 `c143` int DEFAULT NULL,
2439 `c144` int DEFAULT NULL,
2440 `c145` int DEFAULT NULL,
2441 `c146` int DEFAULT NULL,
2442 `c147` int DEFAULT NULL,
2443 `c148` int DEFAULT NULL,
2444 `c149` int DEFAULT NULL,
2445 `c150` int DEFAULT NULL,
2446 `c151` int DEFAULT NULL,
2447 `c152` int DEFAULT NULL,
2448 `c153` int DEFAULT NULL,
2449 `c154` int DEFAULT NULL,
2450 `c155` int DEFAULT NULL,
2451 `c156` int DEFAULT NULL,
2452 `c157` int DEFAULT NULL,
2453 `c158` int DEFAULT NULL,
2454 `c159` int DEFAULT NULL,
2455 `c160` int DEFAULT NULL,
2456 `c161` int DEFAULT NULL,
2457 `c162` int DEFAULT NULL,
2458 `c163` int DEFAULT NULL,
2459 `c164` int DEFAULT NULL,
2460 `c165` int DEFAULT NULL,
2461 `c166` int DEFAULT NULL,
2462 `c167` int DEFAULT NULL,
2463 `c168` int DEFAULT NULL,
2464 `c169` int DEFAULT NULL,
2465 `c170` int DEFAULT NULL,
2466 `c171` int DEFAULT NULL,
2467 `c172` int DEFAULT NULL,
2468 `c173` int DEFAULT NULL,
2469 `c174` int DEFAULT NULL,
2470 `c175` int DEFAULT NULL,
2471 `c176` int DEFAULT NULL,
2472 `c177` int DEFAULT NULL,
2473 `c178` int DEFAULT NULL,
2474 `c179` int DEFAULT NULL,
2475 `c180` int DEFAULT NULL,
2476 `c181` int DEFAULT NULL,
2477 `c182` int DEFAULT NULL,
2478 `c183` int DEFAULT NULL,
2479 `c184` int DEFAULT NULL,
2480 `c185` int DEFAULT NULL,
2481 `c186` int DEFAULT NULL,
2482 `c187` int DEFAULT NULL,
2483 `c188` int DEFAULT NULL,
2484 `c189` int DEFAULT NULL,
2485 `c190` int DEFAULT NULL,
2486 `c191` int DEFAULT NULL,
2487 `c192` int DEFAULT NULL,
2488 `c193` int DEFAULT NULL,
2489 `c194` int DEFAULT NULL,
2490 `c195` int DEFAULT NULL,
2491 `c196` int DEFAULT NULL,
2492 `c197` int DEFAULT NULL,
2493 `c198` int DEFAULT NULL,
2494 `c199` int DEFAULT NULL,
2495 `c200` int DEFAULT NULL,
2496 `c201` int DEFAULT NULL,
2497 `c202` int DEFAULT NULL,
2498 `c203` int DEFAULT NULL,
2499 `c204` int DEFAULT NULL,
2500 `c205` int DEFAULT NULL,
2501 `c206` int DEFAULT NULL,
2502 `c207` int DEFAULT NULL,
2503 `c208` int DEFAULT NULL,
2504 `c209` int DEFAULT NULL,
2505 `c210` int DEFAULT NULL,
2506 `c211` int DEFAULT NULL,
2507 `c212` int DEFAULT NULL,
2508 `c213` int DEFAULT NULL,
2509 `c214` int DEFAULT NULL,
2510 `c215` int DEFAULT NULL,
2511 `c216` int DEFAULT NULL,
2512 `c217` int DEFAULT NULL,
2513 `c218` int DEFAULT NULL,
2514 `c219` int DEFAULT NULL,
2515 `c220` int DEFAULT NULL,
2516 `c221` int DEFAULT NULL,
2517 `c222` int DEFAULT NULL,
2518 `c223` int DEFAULT NULL,
2519 `c224` int DEFAULT NULL,
2520 `c225` int DEFAULT NULL,
2521 `c226` int DEFAULT NULL,
2522 `c227` int DEFAULT NULL,
2523 `c228` int DEFAULT NULL,
2524 `c229` int DEFAULT NULL,
2525 `c230` int DEFAULT NULL,
2526 `c231` int DEFAULT NULL,
2527 `c232` int DEFAULT NULL,
2528 `c233` int DEFAULT NULL,
2529 `c234` int DEFAULT NULL,
2530 `c235` int DEFAULT NULL,
2531 `c236` int DEFAULT NULL,
2532 `c237` int DEFAULT NULL,
2533 `c238` int DEFAULT NULL,
2534 `c239` int DEFAULT NULL,
2535 `c240` int DEFAULT NULL,
2536 `c241` int DEFAULT NULL,
2537 `c242` int DEFAULT NULL,
2538 `c243` int DEFAULT NULL,
2539 `c244` int DEFAULT NULL,
2540 `c245` int DEFAULT NULL,
2541 `c246` int DEFAULT NULL,
2542 `c247` int DEFAULT NULL,
2543 `c248` int DEFAULT NULL,
2544 `c249` int DEFAULT NULL,
2545 `c250` int DEFAULT NULL,
2546 `c251` int DEFAULT NULL,
2547 `c252` int DEFAULT NULL,
2548 `c253` int DEFAULT NULL,
2549 `c254` int DEFAULT NULL,
2550 `c255` int DEFAULT NULL,
2551 `c256` int DEFAULT NULL,
2552 `c257` int DEFAULT NULL,
2553 `c258` int DEFAULT NULL,
2554 `c259` int DEFAULT NULL,
2555 `c260` int DEFAULT NULL,
2556 `c261` int DEFAULT NULL,
2557 `c262` int DEFAULT NULL,
2558 `c263` int DEFAULT NULL,
2559 `c264` int DEFAULT NULL,
2560 `c265` int DEFAULT NULL,
2561 `c266` int DEFAULT NULL,
2562 `c267` int DEFAULT NULL,
2563 `c268` int DEFAULT NULL,
2564 `c269` int DEFAULT NULL,
2565 `c270` int DEFAULT NULL,
2566 `c271` int DEFAULT NULL,
2567 `c272` int DEFAULT NULL,
2568 `c273` int DEFAULT NULL,
2569 `c274` int DEFAULT NULL,
2570 `c275` int DEFAULT NULL,
2571 `c276` int DEFAULT NULL,
2572 `c277` int DEFAULT NULL,
2573 `c278` int DEFAULT NULL,
2574 `c279` int DEFAULT NULL,
2575 `c280` int DEFAULT NULL,
2576 `c281` int DEFAULT NULL,
2577 `c282` int DEFAULT NULL,
2578 `c283` int DEFAULT NULL,
2579 `c284` int DEFAULT NULL,
2580 `c285` int DEFAULT NULL,
2581 `c286` int DEFAULT NULL,
2582 `c287` int DEFAULT NULL,
2583 `c288` int DEFAULT NULL,
2584 `c289` int DEFAULT NULL,
2585 `c290` int DEFAULT NULL,
2586 `c291` int DEFAULT NULL,
2587 `c292` int DEFAULT NULL,
2588 `c293` int DEFAULT NULL,
2589 `c294` int DEFAULT NULL,
2590 `c295` int DEFAULT NULL,
2591 `c296` int DEFAULT NULL,
2592 `c297` int DEFAULT NULL,
2593 `c298` int DEFAULT NULL,
2594 `c299` int DEFAULT NULL,
2595 `c300` int DEFAULT NULL,
2596 `c301` int DEFAULT NULL,
2597 `c302` int DEFAULT NULL,
2598 `c303` int DEFAULT NULL,
2599 `c304` int DEFAULT NULL,
2600 `c305` int DEFAULT NULL,
2601 `c306` int DEFAULT NULL,
2602 `c307` int DEFAULT NULL,
2603 `c308` int DEFAULT NULL,
2604 `c309` int DEFAULT NULL,
2605 `c310` int DEFAULT NULL,
2606 `c311` int DEFAULT NULL,
2607 `c312` int DEFAULT NULL,
2608 `c313` int DEFAULT NULL,
2609 `c314` int DEFAULT NULL,
2610 `c315` int DEFAULT NULL,
2611 `c316` int DEFAULT NULL,
2612 `c317` int DEFAULT NULL,
2613 `c318` int DEFAULT NULL,
2614 `c319` int DEFAULT NULL,
2615 `c320` int DEFAULT NULL,
2616 `c321` int DEFAULT NULL,
2617 `c322` int DEFAULT NULL,
2618 `c323` int DEFAULT NULL,
2619 `c324` int DEFAULT NULL,
2620 `c325` int DEFAULT NULL,
2621 `c326` int DEFAULT NULL,
2622 `c327` int DEFAULT NULL,
2623 `c328` int DEFAULT NULL,
2624 `c329` int DEFAULT NULL,
2625 `c330` int DEFAULT NULL,
2626 `c331` int DEFAULT NULL,
2627 `c332` int DEFAULT NULL,
2628 `c333` int DEFAULT NULL,
2629 `c334` int DEFAULT NULL,
2630 `c335` int DEFAULT NULL,
2631 `c336` int DEFAULT NULL,
2632 `c337` int DEFAULT NULL,
2633 `c338` int DEFAULT NULL,
2634 `c339` int DEFAULT NULL,
2635 `c340` int DEFAULT NULL,
2636 `c341` int DEFAULT NULL,
2637 `c342` int DEFAULT NULL,
2638 `c343` int DEFAULT NULL,
2639 `c344` int DEFAULT NULL,
2640 `c345` int DEFAULT NULL,
2641 `c346` int DEFAULT NULL,
2642 `c347` int DEFAULT NULL,
2643 `c348` int DEFAULT NULL,
2644 `c349` int DEFAULT NULL,
2645 `c350` int DEFAULT NULL,
2646 `c351` int DEFAULT NULL,
2647 `c352` int DEFAULT NULL,
2648 `c353` int DEFAULT NULL,
2649 `c354` int DEFAULT NULL,
2650 `c355` int DEFAULT NULL,
2651 `c356` int DEFAULT NULL,
2652 `c357` int DEFAULT NULL,
2653 `c358` int DEFAULT NULL,
2654 `c359` int DEFAULT NULL,
2655 `c360` int DEFAULT NULL,
2656 `c361` int DEFAULT NULL,
2657 `c362` int DEFAULT NULL,
2658 `c363` int DEFAULT NULL,
2659 `c364` int DEFAULT NULL,
2660 `c365` int DEFAULT NULL,
2661 `c366` int DEFAULT NULL,
2662 `c367` int DEFAULT NULL,
2663 `c368` int DEFAULT NULL,
2664 `c369` int DEFAULT NULL,
2665 `c370` int DEFAULT NULL,
2666 `c371` int DEFAULT NULL,
2667 `c372` int DEFAULT NULL,
2668 `c373` int DEFAULT NULL,
2669 `c374` int DEFAULT NULL,
2670 `c375` int DEFAULT NULL,
2671 `c376` int DEFAULT NULL,
2672 `c377` int DEFAULT NULL,
2673 `c378` int DEFAULT NULL,
2674 `c379` int DEFAULT NULL,
2675 `c380` int DEFAULT NULL,
2676 `c381` int DEFAULT NULL,
2677 `c382` int DEFAULT NULL,
2678 `c383` int DEFAULT NULL,
2679 `c384` int DEFAULT NULL,
2680 `c385` int DEFAULT NULL,
2681 `c386` int DEFAULT NULL,
2682 `c387` int DEFAULT NULL,
2683 `c388` int DEFAULT NULL,
2684 `c389` int DEFAULT NULL,
2685 `c390` int DEFAULT NULL,
2686 `c391` int DEFAULT NULL,
2687 `c392` int DEFAULT NULL,
2688 `c393` int DEFAULT NULL,
2689 `c394` int DEFAULT NULL,
2690 `c395` int DEFAULT NULL,
2691 `c396` int DEFAULT NULL,
2692 `c397` int DEFAULT NULL,
2693 `c398` int DEFAULT NULL,
2694 `c399` int DEFAULT NULL,
2695 `c400` int DEFAULT NULL,
2696 `c401` int DEFAULT NULL,
2697 `c402` int DEFAULT NULL,
2698 `c403` int DEFAULT NULL,
2699 `c404` int DEFAULT NULL,
2700 `c405` int DEFAULT NULL,
2701 `c406` int DEFAULT NULL,
2702 `c407` int DEFAULT NULL,
2703 `c408` int DEFAULT NULL,
2704 `c409` int DEFAULT NULL,
2705 `c410` int DEFAULT NULL,
2706 `c411` int DEFAULT NULL,
2707 `c412` int DEFAULT NULL,
2708 `c413` int DEFAULT NULL,
2709 `c414` int DEFAULT NULL,
2710 `c415` int DEFAULT NULL,
2711 `c416` int DEFAULT NULL,
2712 `c417` int DEFAULT NULL,
2713 `c418` int DEFAULT NULL,
2714 `c419` int DEFAULT NULL,
2715 `c420` int DEFAULT NULL,
2716 `c421` int DEFAULT NULL,
2717 `c422` int DEFAULT NULL,
2718 `c423` int DEFAULT NULL,
2719 `c424` int DEFAULT NULL,
2720 `c425` int DEFAULT NULL,
2721 `c426` int DEFAULT NULL,
2722 `c427` int DEFAULT NULL,
2723 `c428` int DEFAULT NULL,
2724 `c429` int DEFAULT NULL,
2725 `c430` int DEFAULT NULL,
2726 `c431` int DEFAULT NULL,
2727 `c432` int DEFAULT NULL,
2728 `c433` int DEFAULT NULL,
2729 `c434` int DEFAULT NULL,
2730 `c435` int DEFAULT NULL,
2731 `c436` int DEFAULT NULL,
2732 `c437` int DEFAULT NULL,
2733 `c438` int DEFAULT NULL,
2734 `c439` int DEFAULT NULL,
2735 `c440` int DEFAULT NULL,
2736 `c441` int DEFAULT NULL,
2737 `c442` int DEFAULT NULL,
2738 `c443` int DEFAULT NULL,
2739 `c444` int DEFAULT NULL,
2740 `c445` int DEFAULT NULL,
2741 `c446` int DEFAULT NULL,
2742 `c447` int DEFAULT NULL,
2743 `c448` int DEFAULT NULL,
2744 `c449` int DEFAULT NULL,
2745 `c450` int DEFAULT NULL,
2746 `c451` int DEFAULT NULL,
2747 `c452` int DEFAULT NULL,
2748 `c453` int DEFAULT NULL,
2749 `c454` int DEFAULT NULL,
2750 `c455` int DEFAULT NULL,
2751 `c456` int DEFAULT NULL,
2752 `c457` int DEFAULT NULL,
2753 `c458` int DEFAULT NULL,
2754 `c459` int DEFAULT NULL,
2755 `c460` int DEFAULT NULL,
2756 `c461` int DEFAULT NULL,
2757 `c462` int DEFAULT NULL,
2758 `c463` int DEFAULT NULL,
2759 `c464` int DEFAULT NULL,
2760 `c465` int DEFAULT NULL,
2761 `c466` int DEFAULT NULL,
2762 `c467` int DEFAULT NULL,
2763 `c468` int DEFAULT NULL,
2764 `c469` int DEFAULT NULL,
2765 `c470` int DEFAULT NULL,
2766 `c471` int DEFAULT NULL,
2767 `c472` int DEFAULT NULL,
2768 `c473` int DEFAULT NULL,
2769 `c474` int DEFAULT NULL,
2770 `c475` int DEFAULT NULL,
2771 `c476` int DEFAULT NULL,
2772 `c477` int DEFAULT NULL,
2773 `c478` int DEFAULT NULL,
2774 `c479` int DEFAULT NULL,
2775 `c480` int DEFAULT NULL,
2776 `c481` int DEFAULT NULL,
2777 `c482` int DEFAULT NULL,
2778 `c483` int DEFAULT NULL,
2779 `c484` int DEFAULT NULL,
2780 `c485` int DEFAULT NULL,
2781 `c486` int DEFAULT NULL,
2782 `c487` int DEFAULT NULL,
2783 `c488` int DEFAULT NULL,
2784 `c489` int DEFAULT NULL,
2785 `c490` int DEFAULT NULL,
2786 `c491` int DEFAULT NULL,
2787 `c492` int DEFAULT NULL,
2788 `c493` int DEFAULT NULL,
2789 `c494` int DEFAULT NULL,
2790 `c495` int DEFAULT NULL,
2791 `c496` int DEFAULT NULL,
2792 `c497` int DEFAULT NULL,
2793 `c498` int DEFAULT NULL,
2794 `c499` int DEFAULT NULL,
2795 `c500` int DEFAULT NULL,
2796 `c501` int DEFAULT NULL,
2797 `c502` int DEFAULT NULL,
2798 `c503` int DEFAULT NULL,
2799 `c504` int DEFAULT NULL,
2800 `c505` int DEFAULT NULL,
2801 `c506` int DEFAULT NULL,
2802 `c507` int DEFAULT NULL,
2803 `c508` int DEFAULT NULL,
2804 `c509` int DEFAULT NULL,
2805 `c510` int DEFAULT NULL,
2806 `c511` int DEFAULT NULL,
2807 `c512` int DEFAULT NULL,
2808 `c513` int DEFAULT NULL,
2809 `c514` int DEFAULT NULL,
2810 `c515` int DEFAULT NULL,
2811 `c516` int DEFAULT NULL,
2812 `c517` int DEFAULT NULL,
2813 `c518` int DEFAULT NULL,
2814 `c519` int DEFAULT NULL,
2815 `c520` int DEFAULT NULL,
2816 `c521` int DEFAULT NULL,
2817 `c522` int DEFAULT NULL,
2818 `c523` int DEFAULT NULL,
2819 `c524` int DEFAULT NULL,
2820 `c525` int DEFAULT NULL,
2821 `c526` int DEFAULT NULL,
2822 `c527` int DEFAULT NULL,
2823 `c528` int DEFAULT NULL,
2824 `c529` int DEFAULT NULL,
2825 `c530` int DEFAULT NULL,
2826 `c531` int DEFAULT NULL,
2827 `c532` int DEFAULT NULL,
2828 `c533` int DEFAULT NULL,
2829 `c534` int DEFAULT NULL,
2830 `c535` int DEFAULT NULL,
2831 `c536` int DEFAULT NULL,
2832 `c537` int DEFAULT NULL,
2833 `c538` int DEFAULT NULL,
2834 `c539` int DEFAULT NULL,
2835 `c540` int DEFAULT NULL,
2836 `c541` int DEFAULT NULL,
2837 `c542` int DEFAULT NULL,
2838 `c543` int DEFAULT NULL,
2839 `c544` int DEFAULT NULL,
2840 `c545` int DEFAULT NULL,
2841 `c546` int DEFAULT NULL,
2842 `c547` int DEFAULT NULL,
2843 `c548` int DEFAULT NULL,
2844 `c549` int DEFAULT NULL,
2845 `c550` int DEFAULT NULL,
2846 `c551` int DEFAULT NULL,
2847 `c552` int DEFAULT NULL,
2848 `c553` int DEFAULT NULL,
2849 `c554` int DEFAULT NULL,
2850 `c555` int DEFAULT NULL,
2851 `c556` int DEFAULT NULL,
2852 `c557` int DEFAULT NULL,
2853 `c558` int DEFAULT NULL,
2854 `c559` int DEFAULT NULL,
2855 `c560` int DEFAULT NULL,
2856 `c561` int DEFAULT NULL,
2857 `c562` int DEFAULT NULL,
2858 `c563` int DEFAULT NULL,
2859 `c564` int DEFAULT NULL,
2860 `c565` int DEFAULT NULL,
2861 `c566` int DEFAULT NULL,
2862 `c567` int DEFAULT NULL,
2863 `c568` int DEFAULT NULL,
2864 `c569` int DEFAULT NULL,
2865 `c570` int DEFAULT NULL,
2866 `c571` int DEFAULT NULL,
2867 `c572` int DEFAULT NULL,
2868 `c573` int DEFAULT NULL,
2869 `c574` int DEFAULT NULL,
2870 `c575` int DEFAULT NULL,
2871 `c576` int DEFAULT NULL,
2872 `c577` int DEFAULT NULL,
2873 `c578` int DEFAULT NULL,
2874 `c579` int DEFAULT NULL,
2875 `c580` int DEFAULT NULL,
2876 `c581` int DEFAULT NULL,
2877 `c582` int DEFAULT NULL,
2878 `c583` int DEFAULT NULL,
2879 `c584` int DEFAULT NULL,
2880 `c585` int DEFAULT NULL,
2881 `c586` int DEFAULT NULL,
2882 `c587` int DEFAULT NULL,
2883 `c588` int DEFAULT NULL,
2884 `c589` int DEFAULT NULL,
2885 `c590` int DEFAULT NULL,
2886 `c591` int DEFAULT NULL,
2887 `c592` int DEFAULT NULL,
2888 `c593` int DEFAULT NULL,
2889 `c594` int DEFAULT NULL,
2890 `c595` int DEFAULT NULL,
2891 `c596` int DEFAULT NULL,
2892 `c597` int DEFAULT NULL,
2893 `c598` int DEFAULT NULL,
2894 `c599` int DEFAULT NULL,
2895 `c600` int DEFAULT NULL,
2896 `c601` int DEFAULT NULL,
2897 `c602` int DEFAULT NULL,
2898 `c603` int DEFAULT NULL,
2899 `c604` int DEFAULT NULL,
2900 `c605` int DEFAULT NULL,
2901 `c606` int DEFAULT NULL,
2902 `c607` int DEFAULT NULL,
2903 `c608` int DEFAULT NULL,
2904 `c609` int DEFAULT NULL,
2905 `c610` int DEFAULT NULL,
2906 `c611` int DEFAULT NULL,
2907 `c612` int DEFAULT NULL,
2908 `c613` int DEFAULT NULL,
2909 `c614` int DEFAULT NULL,
2910 `c615` int DEFAULT NULL,
2911 `c616` int DEFAULT NULL,
2912 `c617` int DEFAULT NULL,
2913 `c618` int DEFAULT NULL,
2914 `c619` int DEFAULT NULL,
2915 `c620` int DEFAULT NULL,
2916 `c621` int DEFAULT NULL,
2917 `c622` int DEFAULT NULL,
2918 `c623` int DEFAULT NULL,
2919 `c624` int DEFAULT NULL,
2920 `c625` int DEFAULT NULL,
2921 `c626` int DEFAULT NULL,
2922 `c627` int DEFAULT NULL,
2923 `c628` int DEFAULT NULL,
2924 `c629` int DEFAULT NULL,
2925 `c630` int DEFAULT NULL,
2926 `c631` int DEFAULT NULL,
2927 `c632` int DEFAULT NULL,
2928 `c633` int DEFAULT NULL,
2929 `c634` int DEFAULT NULL,
2930 `c635` int DEFAULT NULL,
2931 `c636` int DEFAULT NULL,
2932 `c637` int DEFAULT NULL,
2933 `c638` int DEFAULT NULL,
2934 `c639` int DEFAULT NULL,
2935 `c640` int DEFAULT NULL,
2936 `c641` int DEFAULT NULL,
2937 `c642` int DEFAULT NULL,
2938 `c643` int DEFAULT NULL,
2939 `c644` int DEFAULT NULL,
2940 `c645` int DEFAULT NULL,
2941 `c646` int DEFAULT NULL,
2942 `c647` int DEFAULT NULL,
2943 `c648` int DEFAULT NULL,
2944 `c649` int DEFAULT NULL,
2945 `c650` int DEFAULT NULL,
2946 `c651` int DEFAULT NULL,
2947 `c652` int DEFAULT NULL,
2948 `c653` int DEFAULT NULL,
2949 `c654` int DEFAULT NULL,
2950 `c655` int DEFAULT NULL,
2951 `c656` int DEFAULT NULL,
2952 `c657` int DEFAULT NULL,
2953 `c658` int DEFAULT NULL,
2954 `c659` int DEFAULT NULL,
2955 `c660` int DEFAULT NULL,
2956 `c661` int DEFAULT NULL,
2957 `c662` int DEFAULT NULL,
2958 `c663` int DEFAULT NULL,
2959 `c664` int DEFAULT NULL,
2960 `c665` int DEFAULT NULL,
2961 `c666` int DEFAULT NULL,
2962 `c667` int DEFAULT NULL,
2963 `c668` int DEFAULT NULL,
2964 `c669` int DEFAULT NULL,
2965 `c670` int DEFAULT NULL,
2966 `c671` int DEFAULT NULL,
2967 `c672` int DEFAULT NULL,
2968 `c673` int DEFAULT NULL,
2969 `c674` int DEFAULT NULL,
2970 `c675` int DEFAULT NULL,
2971 `c676` int DEFAULT NULL,
2972 `c677` int DEFAULT NULL,
2973 `c678` int DEFAULT NULL,
2974 `c679` int DEFAULT NULL,
2975 `c680` int DEFAULT NULL,
2976 `c681` int DEFAULT NULL,
2977 `c682` int DEFAULT NULL,
2978 `c683` int DEFAULT NULL,
2979 `c684` int DEFAULT NULL,
2980 `c685` int DEFAULT NULL,
2981 `c686` int DEFAULT NULL,
2982 `c687` int DEFAULT NULL,
2983 `c688` int DEFAULT NULL,
2984 `c689` int DEFAULT NULL,
2985 `c690` int DEFAULT NULL,
2986 `c691` int DEFAULT NULL,
2987 `c692` int DEFAULT NULL,
2988 `c693` int DEFAULT NULL,
2989 `c694` int DEFAULT NULL,
2990 `c695` int DEFAULT NULL,
2991 `c696` int DEFAULT NULL,
2992 `c697` int DEFAULT NULL,
2993 `c698` int DEFAULT NULL,
2994 `c699` int DEFAULT NULL,
2995 `c700` int DEFAULT NULL,
2996 `c701` int DEFAULT NULL,
2997 `c702` int DEFAULT NULL,
2998 `c703` int DEFAULT NULL,
2999 `c704` int DEFAULT NULL,
3000 `c705` int DEFAULT NULL,
3001 `c706` int DEFAULT NULL,
3002 `c707` int DEFAULT NULL,
3003 `c708` int DEFAULT NULL,
3004 `c709` int DEFAULT NULL,
3005 `c710` int DEFAULT NULL,
3006 `c711` int DEFAULT NULL,
3007 `c712` int DEFAULT NULL,
3008 `c713` int DEFAULT NULL,
3009 `c714` int DEFAULT NULL,
3010 `c715` int DEFAULT NULL,
3011 `c716` int DEFAULT NULL,
3012 `c717` int DEFAULT NULL,
3013 `c718` int DEFAULT NULL,
3014 `c719` int DEFAULT NULL,
3015 `c720` int DEFAULT NULL,
3016 `c721` int DEFAULT NULL,
3017 `c722` int DEFAULT NULL,
3018 `c723` int DEFAULT NULL,
3019 `c724` int DEFAULT NULL,
3020 `c725` int DEFAULT NULL,
3021 `c726` int DEFAULT NULL,
3022 `c727` int DEFAULT NULL,
3023 `c728` int DEFAULT NULL,
3024 `c729` int DEFAULT NULL,
3025 `c730` int DEFAULT NULL,
3026 `c731` int DEFAULT NULL,
3027 `c732` int DEFAULT NULL,
3028 `c733` int DEFAULT NULL,
3029 `c734` int DEFAULT NULL,
3030 `c735` int DEFAULT NULL,
3031 `c736` int DEFAULT NULL,
3032 `c737` int DEFAULT NULL,
3033 `c738` int DEFAULT NULL,
3034 `c739` int DEFAULT NULL,
3035 `c740` int DEFAULT NULL,
3036 `c741` int DEFAULT NULL,
3037 `c742` int DEFAULT NULL,
3038 `c743` int DEFAULT NULL,
3039 `c744` int DEFAULT NULL,
3040 `c745` int DEFAULT NULL,
3041 `c746` int DEFAULT NULL,
3042 `c747` int DEFAULT NULL,
3043 `c748` int DEFAULT NULL,
3044 `c749` int DEFAULT NULL,
3045 `c750` int DEFAULT NULL,
3046 `c751` int DEFAULT NULL,
3047 `c752` int DEFAULT NULL,
3048 `c753` int DEFAULT NULL,
3049 `c754` int DEFAULT NULL,
3050 `c755` int DEFAULT NULL,
3051 `c756` int DEFAULT NULL,
3052 `c757` int DEFAULT NULL,
3053 `c758` int DEFAULT NULL,
3054 `c759` int DEFAULT NULL,
3055 `c760` int DEFAULT NULL,
3056 `c761` int DEFAULT NULL,
3057 `c762` int DEFAULT NULL,
3058 `c763` int DEFAULT NULL,
3059 `c764` int DEFAULT NULL,
3060 `c765` int DEFAULT NULL,
3061 `c766` int DEFAULT NULL,
3062 `c767` int DEFAULT NULL,
3063 `c768` int DEFAULT NULL,
3064 `c769` int DEFAULT NULL,
3065 `c770` int DEFAULT NULL,
3066 `c771` int DEFAULT NULL,
3067 `c772` int DEFAULT NULL,
3068 `c773` int DEFAULT NULL,
3069 `c774` int DEFAULT NULL,
3070 `c775` int DEFAULT NULL,
3071 `c776` int DEFAULT NULL,
3072 `c777` int DEFAULT NULL,
3073 `c778` int DEFAULT NULL,
3074 `c779` int DEFAULT NULL,
3075 `c780` int DEFAULT NULL,
3076 `c781` int DEFAULT NULL,
3077 `c782` int DEFAULT NULL,
3078 `c783` int DEFAULT NULL,
3079 `c784` int DEFAULT NULL,
3080 `c785` int DEFAULT NULL,
3081 `c786` int DEFAULT NULL,
3082 `c787` int DEFAULT NULL,
3083 `c788` int DEFAULT NULL,
3084 `c789` int DEFAULT NULL,
3085 `c790` int DEFAULT NULL,
3086 `c791` int DEFAULT NULL,
3087 `c792` int DEFAULT NULL,
3088 `c793` int DEFAULT NULL,
3089 `c794` int DEFAULT NULL,
3090 `c795` int DEFAULT NULL,
3091 `c796` int DEFAULT NULL,
3092 `c797` int DEFAULT NULL,
3093 `c798` int DEFAULT NULL,
3094 `c799` int DEFAULT NULL,
3095 `c800` int DEFAULT NULL,
3096 `c801` int DEFAULT NULL,
3097 `c802` int DEFAULT NULL,
3098 `c803` int DEFAULT NULL,
3099 `c804` int DEFAULT NULL,
3100 `c805` int DEFAULT NULL,
3101 `c806` int DEFAULT NULL,
3102 `c807` int DEFAULT NULL,
3103 `c808` int DEFAULT NULL,
3104 `c809` int DEFAULT NULL,
3105 `c810` int DEFAULT NULL,
3106 `c811` int DEFAULT NULL,
3107 `c812` int DEFAULT NULL,
3108 `c813` int DEFAULT NULL,
3109 `c814` int DEFAULT NULL,
3110 `c815` int DEFAULT NULL,
3111 `c816` int DEFAULT NULL,
3112 `c817` int DEFAULT NULL,
3113 `c818` int DEFAULT NULL,
3114 `c819` int DEFAULT NULL,
3115 `c820` int DEFAULT NULL,
3116 `c821` int DEFAULT NULL,
3117 `c822` int DEFAULT NULL,
3118 `c823` int DEFAULT NULL,
3119 `c824` int DEFAULT NULL,
3120 `c825` int DEFAULT NULL,
3121 `c826` int DEFAULT NULL,
3122 `c827` int DEFAULT NULL,
3123 `c828` int DEFAULT NULL,
3124 `c829` int DEFAULT NULL,
3125 `c830` int DEFAULT NULL,
3126 `c831` int DEFAULT NULL,
3127 `c832` int DEFAULT NULL,
3128 `c833` int DEFAULT NULL,
3129 `c834` int DEFAULT NULL,
3130 `c835` int DEFAULT NULL,
3131 `c836` int DEFAULT NULL,
3132 `c837` int DEFAULT NULL,
3133 `c838` int DEFAULT NULL,
3134 `c839` int DEFAULT NULL,
3135 `c840` int DEFAULT NULL,
3136 `c841` int DEFAULT NULL,
3137 `c842` int DEFAULT NULL,
3138 `c843` int DEFAULT NULL,
3139 `c844` int DEFAULT NULL,
3140 `c845` int DEFAULT NULL,
3141 `c846` int DEFAULT NULL,
3142 `c847` int DEFAULT NULL,
3143 `c848` int DEFAULT NULL,
3144 `c849` int DEFAULT NULL,
3145 `c850` int DEFAULT NULL,
3146 `c851` int DEFAULT NULL,
3147 `c852` int DEFAULT NULL,
3148 `c853` int DEFAULT NULL,
3149 `c854` int DEFAULT NULL,
3150 `c855` int DEFAULT NULL,
3151 `c856` int DEFAULT NULL,
3152 `c857` int DEFAULT NULL,
3153 `c858` int DEFAULT NULL,
3154 `c859` int DEFAULT NULL,
3155 `c860` int DEFAULT NULL,
3156 `c861` int DEFAULT NULL,
3157 `c862` int DEFAULT NULL,
3158 `c863` int DEFAULT NULL,
3159 `c864` int DEFAULT NULL,
3160 `c865` int DEFAULT NULL,
3161 `c866` int DEFAULT NULL,
3162 `c867` int DEFAULT NULL,
3163 `c868` int DEFAULT NULL,
3164 `c869` int DEFAULT NULL,
3165 `c870` int DEFAULT NULL,
3166 `c871` int DEFAULT NULL,
3167 `c872` int DEFAULT NULL,
3168 `c873` int DEFAULT NULL,
3169 `c874` int DEFAULT NULL,
3170 `c875` int DEFAULT NULL,
3171 `c876` int DEFAULT NULL,
3172 `c877` int DEFAULT NULL,
3173 `c878` int DEFAULT NULL,
3174 `c879` int DEFAULT NULL,
3175 `c880` int DEFAULT NULL,
3176 `c881` int DEFAULT NULL,
3177 `c882` int DEFAULT NULL,
3178 `c883` int DEFAULT NULL,
3179 `c884` int DEFAULT NULL,
3180 `c885` int DEFAULT NULL,
3181 `c886` int DEFAULT NULL,
3182 `c887` int DEFAULT NULL,
3183 `c888` int DEFAULT NULL,
3184 `c889` int DEFAULT NULL,
3185 `c890` int DEFAULT NULL,
3186 `c891` int DEFAULT NULL,
3187 `c892` int DEFAULT NULL,
3188 `c893` int DEFAULT NULL,
3189 `c894` int DEFAULT NULL,
3190 `c895` int DEFAULT NULL,
3191 `c896` int DEFAULT NULL,
3192 `c897` int DEFAULT NULL,
3193 `c898` int DEFAULT NULL,
3194 `c899` int DEFAULT NULL,
3195 `c900` int DEFAULT NULL,
3196 `c901` int DEFAULT NULL,
3197 `c902` int DEFAULT NULL,
3198 `c903` int DEFAULT NULL,
3199 `c904` int DEFAULT NULL,
3200 `c905` int DEFAULT NULL,
3201 `c906` int DEFAULT NULL,
3202 `c907` int DEFAULT NULL,
3203 `c908` int DEFAULT NULL,
3204 `c909` int DEFAULT NULL,
3205 `c910` int DEFAULT NULL,
3206 `c911` int DEFAULT NULL,
3207 `c912` int DEFAULT NULL,
3208 `c913` int DEFAULT NULL,
3209 `c914` int DEFAULT NULL,
3210 `c915` int DEFAULT NULL,
3211 `c916` int DEFAULT NULL,
3212 `c917` int DEFAULT NULL,
3213 `c918` int DEFAULT NULL,
3214 `c919` int DEFAULT NULL,
3215 `c920` int DEFAULT NULL,
3216 `c921` int DEFAULT NULL,
3217 `c922` int DEFAULT NULL,
3218 `c923` int DEFAULT NULL,
3219 `c924` int DEFAULT NULL,
3220 `c925` int DEFAULT NULL,
3221 `c926` int DEFAULT NULL,
3222 `c927` int DEFAULT NULL,
3223 `c928` int DEFAULT NULL,
3224 `c929` int DEFAULT NULL,
3225 `c930` int DEFAULT NULL,
3226 `c931` int DEFAULT NULL,
3227 `c932` int DEFAULT NULL,
3228 `c933` int DEFAULT NULL,
3229 `c934` int DEFAULT NULL,
3230 `c935` int DEFAULT NULL,
3231 `c936` int DEFAULT NULL,
3232 `c937` int DEFAULT NULL,
3233 `c938` int DEFAULT NULL,
3234 `c939` int DEFAULT NULL,
3235 `c940` int DEFAULT NULL,
3236 `c941` int DEFAULT NULL,
3237 `c942` int DEFAULT NULL,
3238 `c943` int DEFAULT NULL,
3239 `c944` int DEFAULT NULL,
3240 `c945` int DEFAULT NULL,
3241 `c946` int DEFAULT NULL,
3242 `c947` int DEFAULT NULL,
3243 `c948` int DEFAULT NULL,
3244 `c949` int DEFAULT NULL,
3245 `c950` int DEFAULT NULL,
3246 `c951` int DEFAULT NULL,
3247 `c952` int DEFAULT NULL,
3248 `c953` int DEFAULT NULL,
3249 `c954` int DEFAULT NULL,
3250 `c955` int DEFAULT NULL,
3251 `c956` int DEFAULT NULL,
3252 `c957` int DEFAULT NULL,
3253 `c958` int DEFAULT NULL,
3254 `c959` int DEFAULT NULL,
3255 `c960` int DEFAULT NULL,
3256 `c961` int DEFAULT NULL,
3257 `c962` int DEFAULT NULL,
3258 `c963` int DEFAULT NULL,
3259 `c964` int DEFAULT NULL,
3260 `c965` int DEFAULT NULL,
3261 `c966` int DEFAULT NULL,
3262 `c967` int DEFAULT NULL,
3263 `c968` int DEFAULT NULL,
3264 `c969` int DEFAULT NULL,
3265 `c970` int DEFAULT NULL,
3266 `c971` int DEFAULT NULL,
3267 `c972` int DEFAULT NULL,
3268 `c973` int DEFAULT NULL,
3269 `c974` int DEFAULT NULL,
3270 `c975` int DEFAULT NULL,
3271 `c976` int DEFAULT NULL,
3272 `c977` int DEFAULT NULL,
3273 `c978` int DEFAULT NULL,
3274 `c979` int DEFAULT NULL,
3275 `c980` int DEFAULT NULL,
3276 `c981` int DEFAULT NULL,
3277 `c982` int DEFAULT NULL,
3278 `c983` int DEFAULT NULL,
3279 `c984` int DEFAULT NULL,
3280 `c985` int DEFAULT NULL,
3281 `c986` int DEFAULT NULL,
3282 `c987` int DEFAULT NULL,
3283 `c988` int DEFAULT NULL,
3284 `c989` int DEFAULT NULL,
3285 `c990` int DEFAULT NULL,
3286 `c991` int DEFAULT NULL,
3287 `c992` int DEFAULT NULL,
3288 `c993` int DEFAULT NULL,
3289 `c994` int DEFAULT NULL,
3290 `c995` int DEFAULT NULL,
3291 `c996` int DEFAULT NULL,
3292 `c997` int DEFAULT NULL,
3293 `c998` int DEFAULT NULL,
3294 `c999` int DEFAULT NULL,
3295 PRIMARY KEY (`c1`)
3296 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3297 Get rec(type:id) is t3 CREATE TABLE `t3` (
3298 `c1` varchar(32) NOT NULL,
3299 `c2` varchar(1024) DEFAULT NULL,
3300 PRIMARY KEY (`c1`)
3301 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3302 Get rec(type:id) is t4 CREATE TABLE `t4` (
3303 `c1` int NOT NULL,
3304 `c2` blob,
3305 PRIMARY KEY (`c1`)
3306 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3307 Get rec(type:id) is t5 CREATE TABLE `t5` (
3308 `c1` int NOT NULL,
3309 `c2` int DEFAULT NULL,
3310 PRIMARY KEY (`c1`),
3311 KEY `c2` (`c2`),
3312 CONSTRAINT `t5_ibfk_1` FOREIGN KEY (`c2`) REFERENCES `t4` (`c1`) ON UPDATE CASCADE
3313 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3314 Get rec(type:id) is t7 CREATE TABLE `t7` (
3315 `c1` int NOT NULL,
3316 `c2` int DEFAULT NULL,
3317 `c3` char(255) DEFAULT NULL,
3318 `c4` geometry NOT NULL /*!80003 SRID 0 */,
3319 PRIMARY KEY (`c1`),
3320 SPATIAL KEY `c4` (`c4`)
3321 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3322 # 2. Test with alter table
3323 ALTER TABLE t1 ADD COLUMN c11 INT;
3324 Get rec(type:id) is t1 CREATE TABLE `t1` (
3325 `c1` varchar(32) NOT NULL,
3326 `c2` varchar(1024) DEFAULT NULL,
3327 `c3` tinyblob,
3328 `c4` blob,
3329 `c5` mediumblob,
3330 `c6` longblob,
3331 `c7` text,
3332 `c8` int DEFAULT NULL,
3333 `c9` float DEFAULT NULL,
3334 `c10` double DEFAULT NULL,
3335 `c11` int DEFAULT NULL,
3336 PRIMARY KEY (`c1`),
3337 UNIQUE KEY `idx2` (`c6`(50)),
3338 KEY `idx1` (`c4`(20))
3339 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
3340 ALTER TABLE t3 ADD COLUMN c3 INT;
3341 Get rec(type:id) is t3 CREATE TABLE `t3` (
3342 `c1` varchar(32) NOT NULL,
3343 `c2` varchar(1024) DEFAULT NULL,
3344 `c3` int DEFAULT NULL,
3345 PRIMARY KEY (`c1`)
3346 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
3347 ALTER TABLE t2 DROP COLUMN c100;
3348 ALTER TABLE t2 DROP COLUMN c101;
3349 ALTER TABLE t2 DROP COLUMN c102;
3350 ALTER TABLE t2 DROP COLUMN c103;
3351 ALTER TABLE t2 DROP COLUMN c104;
3352 Get rec(type:id) is t2 CREATE TABLE `t2` (
3353 `c1` int NOT NULL,
3354 `c2` int DEFAULT NULL,
3355 `c3` int DEFAULT NULL,
3356 `c4` int DEFAULT NULL,
3357 `c5` int DEFAULT NULL,
3358 `c6` int DEFAULT NULL,
3359 `c7` int DEFAULT NULL,
3360 `c8` int DEFAULT NULL,
3361 `c9` int DEFAULT NULL,
3362 `c10` int DEFAULT NULL,
3363 `c11` int DEFAULT NULL,
3364 `c12` int DEFAULT NULL,
3365 `c13` int DEFAULT NULL,
3366 `c14` int DEFAULT NULL,
3367 `c15` int DEFAULT NULL,
3368 `c16` int DEFAULT NULL,
3369 `c17` int DEFAULT NULL,
3370 `c18` int DEFAULT NULL,
3371 `c19` int DEFAULT NULL,
3372 `c20` int DEFAULT NULL,
3373 `c21` int DEFAULT NULL,
3374 `c22` int DEFAULT NULL,
3375 `c23` int DEFAULT NULL,
3376 `c24` int DEFAULT NULL,
3377 `c25` int DEFAULT NULL,
3378 `c26` int DEFAULT NULL,
3379 `c27` int DEFAULT NULL,
3380 `c28` int DEFAULT NULL,
3381 `c29` int DEFAULT NULL,
3382 `c30` int DEFAULT NULL,
3383 `c31` int DEFAULT NULL,
3384 `c32` int DEFAULT NULL,
3385 `c33` int DEFAULT NULL,
3386 `c34` int DEFAULT NULL,
3387 `c35` int DEFAULT NULL,
3388 `c36` int DEFAULT NULL,
3389 `c37` int DEFAULT NULL,
3390 `c38` int DEFAULT NULL,
3391 `c39` int DEFAULT NULL,
3392 `c40` int DEFAULT NULL,
3393 `c41` int DEFAULT NULL,
3394 `c42` int DEFAULT NULL,
3395 `c43` int DEFAULT NULL,
3396 `c44` int DEFAULT NULL,
3397 `c45` int DEFAULT NULL,
3398 `c46` int DEFAULT NULL,
3399 `c47` int DEFAULT NULL,
3400 `c48` int DEFAULT NULL,
3401 `c49` int DEFAULT NULL,
3402 `c50` int DEFAULT NULL,
3403 `c51` int DEFAULT NULL,
3404 `c52` int DEFAULT NULL,
3405 `c53` int DEFAULT NULL,
3406 `c54` int DEFAULT NULL,
3407 `c55` int DEFAULT NULL,
3408 `c56` int DEFAULT NULL,
3409 `c57` int DEFAULT NULL,
3410 `c58` int DEFAULT NULL,
3411 `c59` int DEFAULT NULL,
3412 `c60` int DEFAULT NULL,
3413 `c61` int DEFAULT NULL,
3414 `c62` int DEFAULT NULL,
3415 `c63` int DEFAULT NULL,
3416 `c64` int DEFAULT NULL,
3417 `c65` int DEFAULT NULL,
3418 `c66` int DEFAULT NULL,
3419 `c67` int DEFAULT NULL,
3420 `c68` int DEFAULT NULL,
3421 `c69` int DEFAULT NULL,
3422 `c70` int DEFAULT NULL,
3423 `c71` int DEFAULT NULL,
3424 `c72` int DEFAULT NULL,
3425 `c73` int DEFAULT NULL,
3426 `c74` int DEFAULT NULL,
3427 `c75` int DEFAULT NULL,
3428 `c76` int DEFAULT NULL,
3429 `c77` int DEFAULT NULL,
3430 `c78` int DEFAULT NULL,
3431 `c79` int DEFAULT NULL,
3432 `c80` int DEFAULT NULL,
3433 `c81` int DEFAULT NULL,
3434 `c82` int DEFAULT NULL,
3435 `c83` int DEFAULT NULL,
3436 `c84` int DEFAULT NULL,
3437 `c85` int DEFAULT NULL,
3438 `c86` int DEFAULT NULL,
3439 `c87` int DEFAULT NULL,
3440 `c88` int DEFAULT NULL,
3441 `c89` int DEFAULT NULL,
3442 `c90` int DEFAULT NULL,
3443 `c91` int DEFAULT NULL,
3444 `c92` int DEFAULT NULL,
3445 `c93` int DEFAULT NULL,
3446 `c94` int DEFAULT NULL,
3447 `c95` int DEFAULT NULL,
3448 `c96` int DEFAULT NULL,
3449 `c97` int DEFAULT NULL,
3450 `c98` int DEFAULT NULL,
3451 `c99` int DEFAULT NULL,
3452 `c105` int DEFAULT NULL,
3453 `c106` int DEFAULT NULL,
3454 `c107` int DEFAULT NULL,
3455 `c108` int DEFAULT NULL,
3456 `c109` int DEFAULT NULL,
3457 `c110` int DEFAULT NULL,
3458 `c111` int DEFAULT NULL,
3459 `c112` int DEFAULT NULL,
3460 `c113` int DEFAULT NULL,
3461 `c114` int DEFAULT NULL,
3462 `c115` int DEFAULT NULL,
3463 `c116` int DEFAULT NULL,
3464 `c117` int DEFAULT NULL,
3465 `c118` int DEFAULT NULL,
3466 `c119` int DEFAULT NULL,
3467 `c120` int DEFAULT NULL,
3468 `c121` int DEFAULT NULL,
3469 `c122` int DEFAULT NULL,
3470 `c123` int DEFAULT NULL,
3471 `c124` int DEFAULT NULL,
3472 `c125` int DEFAULT NULL,
3473 `c126` int DEFAULT NULL,
3474 `c127` int DEFAULT NULL,
3475 `c128` int DEFAULT NULL,
3476 `c129` int DEFAULT NULL,
3477 `c130` int DEFAULT NULL,
3478 `c131` int DEFAULT NULL,
3479 `c132` int DEFAULT NULL,
3480 `c133` int DEFAULT NULL,
3481 `c134` int DEFAULT NULL,
3482 `c135` int DEFAULT NULL,
3483 `c136` int DEFAULT NULL,
3484 `c137` int DEFAULT NULL,
3485 `c138` int DEFAULT NULL,
3486 `c139` int DEFAULT NULL,
3487 `c140` int DEFAULT NULL,
3488 `c141` int DEFAULT NULL,
3489 `c142` int DEFAULT NULL,
3490 `c143` int DEFAULT NULL,
3491 `c144` int DEFAULT NULL,
3492 `c145` int DEFAULT NULL,
3493 `c146` int DEFAULT NULL,
3494 `c147` int DEFAULT NULL,
3495 `c148` int DEFAULT NULL,
3496 `c149` int DEFAULT NULL,
3497 `c150` int DEFAULT NULL,
3498 `c151` int DEFAULT NULL,
3499 `c152` int DEFAULT NULL,
3500 `c153` int DEFAULT NULL,
3501 `c154` int DEFAULT NULL,
3502 `c155` int DEFAULT NULL,
3503 `c156` int DEFAULT NULL,
3504 `c157` int DEFAULT NULL,
3505 `c158` int DEFAULT NULL,
3506 `c159` int DEFAULT NULL,
3507 `c160` int DEFAULT NULL,
3508 `c161` int DEFAULT NULL,
3509 `c162` int DEFAULT NULL,
3510 `c163` int DEFAULT NULL,
3511 `c164` int DEFAULT NULL,
3512 `c165` int DEFAULT NULL,
3513 `c166` int DEFAULT NULL,
3514 `c167` int DEFAULT NULL,
3515 `c168` int DEFAULT NULL,
3516 `c169` int DEFAULT NULL,
3517 `c170` int DEFAULT NULL,
3518 `c171` int DEFAULT NULL,
3519 `c172` int DEFAULT NULL,
3520 `c173` int DEFAULT NULL,
3521 `c174` int DEFAULT NULL,
3522 `c175` int DEFAULT NULL,
3523 `c176` int DEFAULT NULL,
3524 `c177` int DEFAULT NULL,
3525 `c178` int DEFAULT NULL,
3526 `c179` int DEFAULT NULL,
3527 `c180` int DEFAULT NULL,
3528 `c181` int DEFAULT NULL,
3529 `c182` int DEFAULT NULL,
3530 `c183` int DEFAULT NULL,
3531 `c184` int DEFAULT NULL,
3532 `c185` int DEFAULT NULL,
3533 `c186` int DEFAULT NULL,
3534 `c187` int DEFAULT NULL,
3535 `c188` int DEFAULT NULL,
3536 `c189` int DEFAULT NULL,
3537 `c190` int DEFAULT NULL,
3538 `c191` int DEFAULT NULL,
3539 `c192` int DEFAULT NULL,
3540 `c193` int DEFAULT NULL,
3541 `c194` int DEFAULT NULL,
3542 `c195` int DEFAULT NULL,
3543 `c196` int DEFAULT NULL,
3544 `c197` int DEFAULT NULL,
3545 `c198` int DEFAULT NULL,
3546 `c199` int DEFAULT NULL,
3547 `c200` int DEFAULT NULL,
3548 `c201` int DEFAULT NULL,
3549 `c202` int DEFAULT NULL,
3550 `c203` int DEFAULT NULL,
3551 `c204` int DEFAULT NULL,
3552 `c205` int DEFAULT NULL,
3553 `c206` int DEFAULT NULL,
3554 `c207` int DEFAULT NULL,
3555 `c208` int DEFAULT NULL,
3556 `c209` int DEFAULT NULL,
3557 `c210` int DEFAULT NULL,
3558 `c211` int DEFAULT NULL,
3559 `c212` int DEFAULT NULL,
3560 `c213` int DEFAULT NULL,
3561 `c214` int DEFAULT NULL,
3562 `c215` int DEFAULT NULL,
3563 `c216` int DEFAULT NULL,
3564 `c217` int DEFAULT NULL,
3565 `c218` int DEFAULT NULL,
3566 `c219` int DEFAULT NULL,
3567 `c220` int DEFAULT NULL,
3568 `c221` int DEFAULT NULL,
3569 `c222` int DEFAULT NULL,
3570 `c223` int DEFAULT NULL,
3571 `c224` int DEFAULT NULL,
3572 `c225` int DEFAULT NULL,
3573 `c226` int DEFAULT NULL,
3574 `c227` int DEFAULT NULL,
3575 `c228` int DEFAULT NULL,
3576 `c229` int DEFAULT NULL,
3577 `c230` int DEFAULT NULL,
3578 `c231` int DEFAULT NULL,
3579 `c232` int DEFAULT NULL,
3580 `c233` int DEFAULT NULL,
3581 `c234` int DEFAULT NULL,
3582 `c235` int DEFAULT NULL,
3583 `c236` int DEFAULT NULL,
3584 `c237` int DEFAULT NULL,
3585 `c238` int DEFAULT NULL,
3586 `c239` int DEFAULT NULL,
3587 `c240` int DEFAULT NULL,
3588 `c241` int DEFAULT NULL,
3589 `c242` int DEFAULT NULL,
3590 `c243` int DEFAULT NULL,
3591 `c244` int DEFAULT NULL,
3592 `c245` int DEFAULT NULL,
3593 `c246` int DEFAULT NULL,
3594 `c247` int DEFAULT NULL,
3595 `c248` int DEFAULT NULL,
3596 `c249` int DEFAULT NULL,
3597 `c250` int DEFAULT NULL,
3598 `c251` int DEFAULT NULL,
3599 `c252` int DEFAULT NULL,
3600 `c253` int DEFAULT NULL,
3601 `c254` int DEFAULT NULL,
3602 `c255` int DEFAULT NULL,
3603 `c256` int DEFAULT NULL,
3604 `c257` int DEFAULT NULL,
3605 `c258` int DEFAULT NULL,
3606 `c259` int DEFAULT NULL,
3607 `c260` int DEFAULT NULL,
3608 `c261` int DEFAULT NULL,
3609 `c262` int DEFAULT NULL,
3610 `c263` int DEFAULT NULL,
3611 `c264` int DEFAULT NULL,
3612 `c265` int DEFAULT NULL,
3613 `c266` int DEFAULT NULL,
3614 `c267` int DEFAULT NULL,
3615 `c268` int DEFAULT NULL,
3616 `c269` int DEFAULT NULL,
3617 `c270` int DEFAULT NULL,
3618 `c271` int DEFAULT NULL,
3619 `c272` int DEFAULT NULL,
3620 `c273` int DEFAULT NULL,
3621 `c274` int DEFAULT NULL,
3622 `c275` int DEFAULT NULL,
3623 `c276` int DEFAULT NULL,
3624 `c277` int DEFAULT NULL,
3625 `c278` int DEFAULT NULL,
3626 `c279` int DEFAULT NULL,
3627 `c280` int DEFAULT NULL,
3628 `c281` int DEFAULT NULL,
3629 `c282` int DEFAULT NULL,
3630 `c283` int DEFAULT NULL,
3631 `c284` int DEFAULT NULL,
3632 `c285` int DEFAULT NULL,
3633 `c286` int DEFAULT NULL,
3634 `c287` int DEFAULT NULL,
3635 `c288` int DEFAULT NULL,
3636 `c289` int DEFAULT NULL,
3637 `c290` int DEFAULT NULL,
3638 `c291` int DEFAULT NULL,
3639 `c292` int DEFAULT NULL,
3640 `c293` int DEFAULT NULL,
3641 `c294` int DEFAULT NULL,
3642 `c295` int DEFAULT NULL,
3643 `c296` int DEFAULT NULL,
3644 `c297` int DEFAULT NULL,
3645 `c298` int DEFAULT NULL,
3646 `c299` int DEFAULT NULL,
3647 `c300` int DEFAULT NULL,
3648 `c301` int DEFAULT NULL,
3649 `c302` int DEFAULT NULL,
3650 `c303` int DEFAULT NULL,
3651 `c304` int DEFAULT NULL,
3652 `c305` int DEFAULT NULL,
3653 `c306` int DEFAULT NULL,
3654 `c307` int DEFAULT NULL,
3655 `c308` int DEFAULT NULL,
3656 `c309` int DEFAULT NULL,
3657 `c310` int DEFAULT NULL,
3658 `c311` int DEFAULT NULL,
3659 `c312` int DEFAULT NULL,
3660 `c313` int DEFAULT NULL,
3661 `c314` int DEFAULT NULL,
3662 `c315` int DEFAULT NULL,
3663 `c316` int DEFAULT NULL,
3664 `c317` int DEFAULT NULL,
3665 `c318` int DEFAULT NULL,
3666 `c319` int DEFAULT NULL,
3667 `c320` int DEFAULT NULL,
3668 `c321` int DEFAULT NULL,
3669 `c322` int DEFAULT NULL,
3670 `c323` int DEFAULT NULL,
3671 `c324` int DEFAULT NULL,
3672 `c325` int DEFAULT NULL,
3673 `c326` int DEFAULT NULL,
3674 `c327` int DEFAULT NULL,
3675 `c328` int DEFAULT NULL,
3676 `c329` int DEFAULT NULL,
3677 `c330` int DEFAULT NULL,
3678 `c331` int DEFAULT NULL,
3679 `c332` int DEFAULT NULL,
3680 `c333` int DEFAULT NULL,
3681 `c334` int DEFAULT NULL,
3682 `c335` int DEFAULT NULL,
3683 `c336` int DEFAULT NULL,
3684 `c337` int DEFAULT NULL,
3685 `c338` int DEFAULT NULL,
3686 `c339` int DEFAULT NULL,
3687 `c340` int DEFAULT NULL,
3688 `c341` int DEFAULT NULL,
3689 `c342` int DEFAULT NULL,
3690 `c343` int DEFAULT NULL,
3691 `c344` int DEFAULT NULL,
3692 `c345` int DEFAULT NULL,
3693 `c346` int DEFAULT NULL,
3694 `c347` int DEFAULT NULL,
3695 `c348` int DEFAULT NULL,
3696 `c349` int DEFAULT NULL,
3697 `c350` int DEFAULT NULL,
3698 `c351` int DEFAULT NULL,
3699 `c352` int DEFAULT NULL,
3700 `c353` int DEFAULT NULL,
3701 `c354` int DEFAULT NULL,
3702 `c355` int DEFAULT NULL,
3703 `c356` int DEFAULT NULL,
3704 `c357` int DEFAULT NULL,
3705 `c358` int DEFAULT NULL,
3706 `c359` int DEFAULT NULL,
3707 `c360` int DEFAULT NULL,
3708 `c361` int DEFAULT NULL,
3709 `c362` int DEFAULT NULL,
3710 `c363` int DEFAULT NULL,
3711 `c364` int DEFAULT NULL,
3712 `c365` int DEFAULT NULL,
3713 `c366` int DEFAULT NULL,
3714 `c367` int DEFAULT NULL,
3715 `c368` int DEFAULT NULL,
3716 `c369` int DEFAULT NULL,
3717 `c370` int DEFAULT NULL,
3718 `c371` int DEFAULT NULL,
3719 `c372` int DEFAULT NULL,
3720 `c373` int DEFAULT NULL,
3721 `c374` int DEFAULT NULL,
3722 `c375` int DEFAULT NULL,
3723 `c376` int DEFAULT NULL,
3724 `c377` int DEFAULT NULL,
3725 `c378` int DEFAULT NULL,
3726 `c379` int DEFAULT NULL,
3727 `c380` int DEFAULT NULL,
3728 `c381` int DEFAULT NULL,
3729 `c382` int DEFAULT NULL,
3730 `c383` int DEFAULT NULL,
3731 `c384` int DEFAULT NULL,
3732 `c385` int DEFAULT NULL,
3733 `c386` int DEFAULT NULL,
3734 `c387` int DEFAULT NULL,
3735 `c388` int DEFAULT NULL,
3736 `c389` int DEFAULT NULL,
3737 `c390` int DEFAULT NULL,
3738 `c391` int DEFAULT NULL,
3739 `c392` int DEFAULT NULL,
3740 `c393` int DEFAULT NULL,
3741 `c394` int DEFAULT NULL,
3742 `c395` int DEFAULT NULL,
3743 `c396` int DEFAULT NULL,
3744 `c397` int DEFAULT NULL,
3745 `c398` int DEFAULT NULL,
3746 `c399` int DEFAULT NULL,
3747 `c400` int DEFAULT NULL,
3748 `c401` int DEFAULT NULL,
3749 `c402` int DEFAULT NULL,
3750 `c403` int DEFAULT NULL,
3751 `c404` int DEFAULT NULL,
3752 `c405` int DEFAULT NULL,
3753 `c406` int DEFAULT NULL,
3754 `c407` int DEFAULT NULL,
3755 `c408` int DEFAULT NULL,
3756 `c409` int DEFAULT NULL,
3757 `c410` int DEFAULT NULL,
3758 `c411` int DEFAULT NULL,
3759 `c412` int DEFAULT NULL,
3760 `c413` int DEFAULT NULL,
3761 `c414` int DEFAULT NULL,
3762 `c415` int DEFAULT NULL,
3763 `c416` int DEFAULT NULL,
3764 `c417` int DEFAULT NULL,
3765 `c418` int DEFAULT NULL,
3766 `c419` int DEFAULT NULL,
3767 `c420` int DEFAULT NULL,
3768 `c421` int DEFAULT NULL,
3769 `c422` int DEFAULT NULL,
3770 `c423` int DEFAULT NULL,
3771 `c424` int DEFAULT NULL,
3772 `c425` int DEFAULT NULL,
3773 `c426` int DEFAULT NULL,
3774 `c427` int DEFAULT NULL,
3775 `c428` int DEFAULT NULL,
3776 `c429` int DEFAULT NULL,
3777 `c430` int DEFAULT NULL,
3778 `c431` int DEFAULT NULL,
3779 `c432` int DEFAULT NULL,
3780 `c433` int DEFAULT NULL,
3781 `c434` int DEFAULT NULL,
3782 `c435` int DEFAULT NULL,
3783 `c436` int DEFAULT NULL,
3784 `c437` int DEFAULT NULL,
3785 `c438` int DEFAULT NULL,
3786 `c439` int DEFAULT NULL,
3787 `c440` int DEFAULT NULL,
3788 `c441` int DEFAULT NULL,
3789 `c442` int DEFAULT NULL,
3790 `c443` int DEFAULT NULL,
3791 `c444` int DEFAULT NULL,
3792 `c445` int DEFAULT NULL,
3793 `c446` int DEFAULT NULL,
3794 `c447` int DEFAULT NULL,
3795 `c448` int DEFAULT NULL,
3796 `c449` int DEFAULT NULL,
3797 `c450` int DEFAULT NULL,
3798 `c451` int DEFAULT NULL,
3799 `c452` int DEFAULT NULL,
3800 `c453` int DEFAULT NULL,
3801 `c454` int DEFAULT NULL,
3802 `c455` int DEFAULT NULL,
3803 `c456` int DEFAULT NULL,
3804 `c457` int DEFAULT NULL,
3805 `c458` int DEFAULT NULL,
3806 `c459` int DEFAULT NULL,
3807 `c460` int DEFAULT NULL,
3808 `c461` int DEFAULT NULL,
3809 `c462` int DEFAULT NULL,
3810 `c463` int DEFAULT NULL,
3811 `c464` int DEFAULT NULL,
3812 `c465` int DEFAULT NULL,
3813 `c466` int DEFAULT NULL,
3814 `c467` int DEFAULT NULL,
3815 `c468` int DEFAULT NULL,
3816 `c469` int DEFAULT NULL,
3817 `c470` int DEFAULT NULL,
3818 `c471` int DEFAULT NULL,
3819 `c472` int DEFAULT NULL,
3820 `c473` int DEFAULT NULL,
3821 `c474` int DEFAULT NULL,
3822 `c475` int DEFAULT NULL,
3823 `c476` int DEFAULT NULL,
3824 `c477` int DEFAULT NULL,
3825 `c478` int DEFAULT NULL,
3826 `c479` int DEFAULT NULL,
3827 `c480` int DEFAULT NULL,
3828 `c481` int DEFAULT NULL,
3829 `c482` int DEFAULT NULL,
3830 `c483` int DEFAULT NULL,
3831 `c484` int DEFAULT NULL,
3832 `c485` int DEFAULT NULL,
3833 `c486` int DEFAULT NULL,
3834 `c487` int DEFAULT NULL,
3835 `c488` int DEFAULT NULL,
3836 `c489` int DEFAULT NULL,
3837 `c490` int DEFAULT NULL,
3838 `c491` int DEFAULT NULL,
3839 `c492` int DEFAULT NULL,
3840 `c493` int DEFAULT NULL,
3841 `c494` int DEFAULT NULL,
3842 `c495` int DEFAULT NULL,
3843 `c496` int DEFAULT NULL,
3844 `c497` int DEFAULT NULL,
3845 `c498` int DEFAULT NULL,
3846 `c499` int DEFAULT NULL,
3847 `c500` int DEFAULT NULL,
3848 `c501` int DEFAULT NULL,
3849 `c502` int DEFAULT NULL,
3850 `c503` int DEFAULT NULL,
3851 `c504` int DEFAULT NULL,
3852 `c505` int DEFAULT NULL,
3853 `c506` int DEFAULT NULL,
3854 `c507` int DEFAULT NULL,
3855 `c508` int DEFAULT NULL,
3856 `c509` int DEFAULT NULL,
3857 `c510` int DEFAULT NULL,
3858 `c511` int DEFAULT NULL,
3859 `c512` int DEFAULT NULL,
3860 `c513` int DEFAULT NULL,
3861 `c514` int DEFAULT NULL,
3862 `c515` int DEFAULT NULL,
3863 `c516` int DEFAULT NULL,
3864 `c517` int DEFAULT NULL,
3865 `c518` int DEFAULT NULL,
3866 `c519` int DEFAULT NULL,
3867 `c520` int DEFAULT NULL,
3868 `c521` int DEFAULT NULL,
3869 `c522` int DEFAULT NULL,
3870 `c523` int DEFAULT NULL,
3871 `c524` int DEFAULT NULL,
3872 `c525` int DEFAULT NULL,
3873 `c526` int DEFAULT NULL,
3874 `c527` int DEFAULT NULL,
3875 `c528` int DEFAULT NULL,
3876 `c529` int DEFAULT NULL,
3877 `c530` int DEFAULT NULL,
3878 `c531` int DEFAULT NULL,
3879 `c532` int DEFAULT NULL,
3880 `c533` int DEFAULT NULL,
3881 `c534` int DEFAULT NULL,
3882 `c535` int DEFAULT NULL,
3883 `c536` int DEFAULT NULL,
3884 `c537` int DEFAULT NULL,
3885 `c538` int DEFAULT NULL,
3886 `c539` int DEFAULT NULL,
3887 `c540` int DEFAULT NULL,
3888 `c541` int DEFAULT NULL,
3889 `c542` int DEFAULT NULL,
3890 `c543` int DEFAULT NULL,
3891 `c544` int DEFAULT NULL,
3892 `c545` int DEFAULT NULL,
3893 `c546` int DEFAULT NULL,
3894 `c547` int DEFAULT NULL,
3895 `c548` int DEFAULT NULL,
3896 `c549` int DEFAULT NULL,
3897 `c550` int DEFAULT NULL,
3898 `c551` int DEFAULT NULL,
3899 `c552` int DEFAULT NULL,
3900 `c553` int DEFAULT NULL,
3901 `c554` int DEFAULT NULL,
3902 `c555` int DEFAULT NULL,
3903 `c556` int DEFAULT NULL,
3904 `c557` int DEFAULT NULL,
3905 `c558` int DEFAULT NULL,
3906 `c559` int DEFAULT NULL,
3907 `c560` int DEFAULT NULL,
3908 `c561` int DEFAULT NULL,
3909 `c562` int DEFAULT NULL,
3910 `c563` int DEFAULT NULL,
3911 `c564` int DEFAULT NULL,
3912 `c565` int DEFAULT NULL,
3913 `c566` int DEFAULT NULL,
3914 `c567` int DEFAULT NULL,
3915 `c568` int DEFAULT NULL,
3916 `c569` int DEFAULT NULL,
3917 `c570` int DEFAULT NULL,
3918 `c571` int DEFAULT NULL,
3919 `c572` int DEFAULT NULL,
3920 `c573` int DEFAULT NULL,
3921 `c574` int DEFAULT NULL,
3922 `c575` int DEFAULT NULL,
3923 `c576` int DEFAULT NULL,
3924 `c577` int DEFAULT NULL,
3925 `c578` int DEFAULT NULL,
3926 `c579` int DEFAULT NULL,
3927 `c580` int DEFAULT NULL,
3928 `c581` int DEFAULT NULL,
3929 `c582` int DEFAULT NULL,
3930 `c583` int DEFAULT NULL,
3931 `c584` int DEFAULT NULL,
3932 `c585` int DEFAULT NULL,
3933 `c586` int DEFAULT NULL,
3934 `c587` int DEFAULT NULL,
3935 `c588` int DEFAULT NULL,
3936 `c589` int DEFAULT NULL,
3937 `c590` int DEFAULT NULL,
3938 `c591` int DEFAULT NULL,
3939 `c592` int DEFAULT NULL,
3940 `c593` int DEFAULT NULL,
3941 `c594` int DEFAULT NULL,
3942 `c595` int DEFAULT NULL,
3943 `c596` int DEFAULT NULL,
3944 `c597` int DEFAULT NULL,
3945 `c598` int DEFAULT NULL,
3946 `c599` int DEFAULT NULL,
3947 `c600` int DEFAULT NULL,
3948 `c601` int DEFAULT NULL,
3949 `c602` int DEFAULT NULL,
3950 `c603` int DEFAULT NULL,
3951 `c604` int DEFAULT NULL,
3952 `c605` int DEFAULT NULL,
3953 `c606` int DEFAULT NULL,
3954 `c607` int DEFAULT NULL,
3955 `c608` int DEFAULT NULL,
3956 `c609` int DEFAULT NULL,
3957 `c610` int DEFAULT NULL,
3958 `c611` int DEFAULT NULL,
3959 `c612` int DEFAULT NULL,
3960 `c613` int DEFAULT NULL,
3961 `c614` int DEFAULT NULL,
3962 `c615` int DEFAULT NULL,
3963 `c616` int DEFAULT NULL,
3964 `c617` int DEFAULT NULL,
3965 `c618` int DEFAULT NULL,
3966 `c619` int DEFAULT NULL,
3967 `c620` int DEFAULT NULL,
3968 `c621` int DEFAULT NULL,
3969 `c622` int DEFAULT NULL,
3970 `c623` int DEFAULT NULL,
3971 `c624` int DEFAULT NULL,
3972 `c625` int DEFAULT NULL,
3973 `c626` int DEFAULT NULL,
3974 `c627` int DEFAULT NULL,
3975 `c628` int DEFAULT NULL,
3976 `c629` int DEFAULT NULL,
3977 `c630` int DEFAULT NULL,
3978 `c631` int DEFAULT NULL,
3979 `c632` int DEFAULT NULL,
3980 `c633` int DEFAULT NULL,
3981 `c634` int DEFAULT NULL,
3982 `c635` int DEFAULT NULL,
3983 `c636` int DEFAULT NULL,
3984 `c637` int DEFAULT NULL,
3985 `c638` int DEFAULT NULL,
3986 `c639` int DEFAULT NULL,
3987 `c640` int DEFAULT NULL,
3988 `c641` int DEFAULT NULL,
3989 `c642` int DEFAULT NULL,
3990 `c643` int DEFAULT NULL,
3991 `c644` int DEFAULT NULL,
3992 `c645` int DEFAULT NULL,
3993 `c646` int DEFAULT NULL,
3994 `c647` int DEFAULT NULL,
3995 `c648` int DEFAULT NULL,
3996 `c649` int DEFAULT NULL,
3997 `c650` int DEFAULT NULL,
3998 `c651` int DEFAULT NULL,
3999 `c652` int DEFAULT NULL,
4000 `c653` int DEFAULT NULL,
4001 `c654` int DEFAULT NULL,
4002 `c655` int DEFAULT NULL,
4003 `c656` int DEFAULT NULL,
4004 `c657` int DEFAULT NULL,
4005 `c658` int DEFAULT NULL,
4006 `c659` int DEFAULT NULL,
4007 `c660` int DEFAULT NULL,
4008 `c661` int DEFAULT NULL,
4009 `c662` int DEFAULT NULL,
4010 `c663` int DEFAULT NULL,
4011 `c664` int DEFAULT NULL,
4012 `c665` int DEFAULT NULL,
4013 `c666` int DEFAULT NULL,
4014 `c667` int DEFAULT NULL,
4015 `c668` int DEFAULT NULL,
4016 `c669` int DEFAULT NULL,
4017 `c670` int DEFAULT NULL,
4018 `c671` int DEFAULT NULL,
4019 `c672` int DEFAULT NULL,
4020 `c673` int DEFAULT NULL,
4021 `c674` int DEFAULT NULL,
4022 `c675` int DEFAULT NULL,
4023 `c676` int DEFAULT NULL,
4024 `c677` int DEFAULT NULL,
4025 `c678` int DEFAULT NULL,
4026 `c679` int DEFAULT NULL,
4027 `c680` int DEFAULT NULL,
4028 `c681` int DEFAULT NULL,
4029 `c682` int DEFAULT NULL,
4030 `c683` int DEFAULT NULL,
4031 `c684` int DEFAULT NULL,
4032 `c685` int DEFAULT NULL,
4033 `c686` int DEFAULT NULL,
4034 `c687` int DEFAULT NULL,
4035 `c688` int DEFAULT NULL,
4036 `c689` int DEFAULT NULL,
4037 `c690` int DEFAULT NULL,
4038 `c691` int DEFAULT NULL,
4039 `c692` int DEFAULT NULL,
4040 `c693` int DEFAULT NULL,
4041 `c694` int DEFAULT NULL,
4042 `c695` int DEFAULT NULL,
4043 `c696` int DEFAULT NULL,
4044 `c697` int DEFAULT NULL,
4045 `c698` int DEFAULT NULL,
4046 `c699` int DEFAULT NULL,
4047 `c700` int DEFAULT NULL,
4048 `c701` int DEFAULT NULL,
4049 `c702` int DEFAULT NULL,
4050 `c703` int DEFAULT NULL,
4051 `c704` int DEFAULT NULL,
4052 `c705` int DEFAULT NULL,
4053 `c706` int DEFAULT NULL,
4054 `c707` int DEFAULT NULL,
4055 `c708` int DEFAULT NULL,
4056 `c709` int DEFAULT NULL,
4057 `c710` int DEFAULT NULL,
4058 `c711` int DEFAULT NULL,
4059 `c712` int DEFAULT NULL,
4060 `c713` int DEFAULT NULL,
4061 `c714` int DEFAULT NULL,
4062 `c715` int DEFAULT NULL,
4063 `c716` int DEFAULT NULL,
4064 `c717` int DEFAULT NULL,
4065 `c718` int DEFAULT NULL,
4066 `c719` int DEFAULT NULL,
4067 `c720` int DEFAULT NULL,
4068 `c721` int DEFAULT NULL,
4069 `c722` int DEFAULT NULL,
4070 `c723` int DEFAULT NULL,
4071 `c724` int DEFAULT NULL,
4072 `c725` int DEFAULT NULL,
4073 `c726` int DEFAULT NULL,
4074 `c727` int DEFAULT NULL,
4075 `c728` int DEFAULT NULL,
4076 `c729` int DEFAULT NULL,
4077 `c730` int DEFAULT NULL,
4078 `c731` int DEFAULT NULL,
4079 `c732` int DEFAULT NULL,
4080 `c733` int DEFAULT NULL,
4081 `c734` int DEFAULT NULL,
4082 `c735` int DEFAULT NULL,
4083 `c736` int DEFAULT NULL,
4084 `c737` int DEFAULT NULL,
4085 `c738` int DEFAULT NULL,
4086 `c739` int DEFAULT NULL,
4087 `c740` int DEFAULT NULL,
4088 `c741` int DEFAULT NULL,
4089 `c742` int DEFAULT NULL,
4090 `c743` int DEFAULT NULL,
4091 `c744` int DEFAULT NULL,
4092 `c745` int DEFAULT NULL,
4093 `c746` int DEFAULT NULL,
4094 `c747` int DEFAULT NULL,
4095 `c748` int DEFAULT NULL,
4096 `c749` int DEFAULT NULL,
4097 `c750` int DEFAULT NULL,
4098 `c751` int DEFAULT NULL,
4099 `c752` int DEFAULT NULL,
4100 `c753` int DEFAULT NULL,
4101 `c754` int DEFAULT NULL,
4102 `c755` int DEFAULT NULL,
4103 `c756` int DEFAULT NULL,
4104 `c757` int DEFAULT NULL,
4105 `c758` int DEFAULT NULL,
4106 `c759` int DEFAULT NULL,
4107 `c760` int DEFAULT NULL,
4108 `c761` int DEFAULT NULL,
4109 `c762` int DEFAULT NULL,
4110 `c763` int DEFAULT NULL,
4111 `c764` int DEFAULT NULL,
4112 `c765` int DEFAULT NULL,
4113 `c766` int DEFAULT NULL,
4114 `c767` int DEFAULT NULL,
4115 `c768` int DEFAULT NULL,
4116 `c769` int DEFAULT NULL,
4117 `c770` int DEFAULT NULL,
4118 `c771` int DEFAULT NULL,
4119 `c772` int DEFAULT NULL,
4120 `c773` int DEFAULT NULL,
4121 `c774` int DEFAULT NULL,
4122 `c775` int DEFAULT NULL,
4123 `c776` int DEFAULT NULL,
4124 `c777` int DEFAULT NULL,
4125 `c778` int DEFAULT NULL,
4126 `c779` int DEFAULT NULL,
4127 `c780` int DEFAULT NULL,
4128 `c781` int DEFAULT NULL,
4129 `c782` int DEFAULT NULL,
4130 `c783` int DEFAULT NULL,
4131 `c784` int DEFAULT NULL,
4132 `c785` int DEFAULT NULL,
4133 `c786` int DEFAULT NULL,
4134 `c787` int DEFAULT NULL,
4135 `c788` int DEFAULT NULL,
4136 `c789` int DEFAULT NULL,
4137 `c790` int DEFAULT NULL,
4138 `c791` int DEFAULT NULL,
4139 `c792` int DEFAULT NULL,
4140 `c793` int DEFAULT NULL,
4141 `c794` int DEFAULT NULL,
4142 `c795` int DEFAULT NULL,
4143 `c796` int DEFAULT NULL,
4144 `c797` int DEFAULT NULL,
4145 `c798` int DEFAULT NULL,
4146 `c799` int DEFAULT NULL,
4147 `c800` int DEFAULT NULL,
4148 `c801` int DEFAULT NULL,
4149 `c802` int DEFAULT NULL,
4150 `c803` int DEFAULT NULL,
4151 `c804` int DEFAULT NULL,
4152 `c805` int DEFAULT NULL,
4153 `c806` int DEFAULT NULL,
4154 `c807` int DEFAULT NULL,
4155 `c808` int DEFAULT NULL,
4156 `c809` int DEFAULT NULL,
4157 `c810` int DEFAULT NULL,
4158 `c811` int DEFAULT NULL,
4159 `c812` int DEFAULT NULL,
4160 `c813` int DEFAULT NULL,
4161 `c814` int DEFAULT NULL,
4162 `c815` int DEFAULT NULL,
4163 `c816` int DEFAULT NULL,
4164 `c817` int DEFAULT NULL,
4165 `c818` int DEFAULT NULL,
4166 `c819` int DEFAULT NULL,
4167 `c820` int DEFAULT NULL,
4168 `c821` int DEFAULT NULL,
4169 `c822` int DEFAULT NULL,
4170 `c823` int DEFAULT NULL,
4171 `c824` int DEFAULT NULL,
4172 `c825` int DEFAULT NULL,
4173 `c826` int DEFAULT NULL,
4174 `c827` int DEFAULT NULL,
4175 `c828` int DEFAULT NULL,
4176 `c829` int DEFAULT NULL,
4177 `c830` int DEFAULT NULL,
4178 `c831` int DEFAULT NULL,
4179 `c832` int DEFAULT NULL,
4180 `c833` int DEFAULT NULL,
4181 `c834` int DEFAULT NULL,
4182 `c835` int DEFAULT NULL,
4183 `c836` int DEFAULT NULL,
4184 `c837` int DEFAULT NULL,
4185 `c838` int DEFAULT NULL,
4186 `c839` int DEFAULT NULL,
4187 `c840` int DEFAULT NULL,
4188 `c841` int DEFAULT NULL,
4189 `c842` int DEFAULT NULL,
4190 `c843` int DEFAULT NULL,
4191 `c844` int DEFAULT NULL,
4192 `c845` int DEFAULT NULL,
4193 `c846` int DEFAULT NULL,
4194 `c847` int DEFAULT NULL,
4195 `c848` int DEFAULT NULL,
4196 `c849` int DEFAULT NULL,
4197 `c850` int DEFAULT NULL,
4198 `c851` int DEFAULT NULL,
4199 `c852` int DEFAULT NULL,
4200 `c853` int DEFAULT NULL,
4201 `c854` int DEFAULT NULL,
4202 `c855` int DEFAULT NULL,
4203 `c856` int DEFAULT NULL,
4204 `c857` int DEFAULT NULL,
4205 `c858` int DEFAULT NULL,
4206 `c859` int DEFAULT NULL,
4207 `c860` int DEFAULT NULL,
4208 `c861` int DEFAULT NULL,
4209 `c862` int DEFAULT NULL,
4210 `c863` int DEFAULT NULL,
4211 `c864` int DEFAULT NULL,
4212 `c865` int DEFAULT NULL,
4213 `c866` int DEFAULT NULL,
4214 `c867` int DEFAULT NULL,
4215 `c868` int DEFAULT NULL,
4216 `c869` int DEFAULT NULL,
4217 `c870` int DEFAULT NULL,
4218 `c871` int DEFAULT NULL,
4219 `c872` int DEFAULT NULL,
4220 `c873` int DEFAULT NULL,
4221 `c874` int DEFAULT NULL,
4222 `c875` int DEFAULT NULL,
4223 `c876` int DEFAULT NULL,
4224 `c877` int DEFAULT NULL,
4225 `c878` int DEFAULT NULL,
4226 `c879` int DEFAULT NULL,
4227 `c880` int DEFAULT NULL,
4228 `c881` int DEFAULT NULL,
4229 `c882` int DEFAULT NULL,
4230 `c883` int DEFAULT NULL,
4231 `c884` int DEFAULT NULL,
4232 `c885` int DEFAULT NULL,
4233 `c886` int DEFAULT NULL,
4234 `c887` int DEFAULT NULL,
4235 `c888` int DEFAULT NULL,
4236 `c889` int DEFAULT NULL,
4237 `c890` int DEFAULT NULL,
4238 `c891` int DEFAULT NULL,
4239 `c892` int DEFAULT NULL,
4240 `c893` int DEFAULT NULL,
4241 `c894` int DEFAULT NULL,
4242 `c895` int DEFAULT NULL,
4243 `c896` int DEFAULT NULL,
4244 `c897` int DEFAULT NULL,
4245 `c898` int DEFAULT NULL,
4246 `c899` int DEFAULT NULL,
4247 `c900` int DEFAULT NULL,
4248 `c901` int DEFAULT NULL,
4249 `c902` int DEFAULT NULL,
4250 `c903` int DEFAULT NULL,
4251 `c904` int DEFAULT NULL,
4252 `c905` int DEFAULT NULL,
4253 `c906` int DEFAULT NULL,
4254 `c907` int DEFAULT NULL,
4255 `c908` int DEFAULT NULL,
4256 `c909` int DEFAULT NULL,
4257 `c910` int DEFAULT NULL,
4258 `c911` int DEFAULT NULL,
4259 `c912` int DEFAULT NULL,
4260 `c913` int DEFAULT NULL,
4261 `c914` int DEFAULT NULL,
4262 `c915` int DEFAULT NULL,
4263 `c916` int DEFAULT NULL,
4264 `c917` int DEFAULT NULL,
4265 `c918` int DEFAULT NULL,
4266 `c919` int DEFAULT NULL,
4267 `c920` int DEFAULT NULL,
4268 `c921` int DEFAULT NULL,
4269 `c922` int DEFAULT NULL,
4270 `c923` int DEFAULT NULL,
4271 `c924` int DEFAULT NULL,
4272 `c925` int DEFAULT NULL,
4273 `c926` int DEFAULT NULL,
4274 `c927` int DEFAULT NULL,
4275 `c928` int DEFAULT NULL,
4276 `c929` int DEFAULT NULL,
4277 `c930` int DEFAULT NULL,
4278 `c931` int DEFAULT NULL,
4279 `c932` int DEFAULT NULL,
4280 `c933` int DEFAULT NULL,
4281 `c934` int DEFAULT NULL,
4282 `c935` int DEFAULT NULL,
4283 `c936` int DEFAULT NULL,
4284 `c937` int DEFAULT NULL,
4285 `c938` int DEFAULT NULL,
4286 `c939` int DEFAULT NULL,
4287 `c940` int DEFAULT NULL,
4288 `c941` int DEFAULT NULL,
4289 `c942` int DEFAULT NULL,
4290 `c943` int DEFAULT NULL,
4291 `c944` int DEFAULT NULL,
4292 `c945` int DEFAULT NULL,
4293 `c946` int DEFAULT NULL,
4294 `c947` int DEFAULT NULL,
4295 `c948` int DEFAULT NULL,
4296 `c949` int DEFAULT NULL,
4297 `c950` int DEFAULT NULL,
4298 `c951` int DEFAULT NULL,
4299 `c952` int DEFAULT NULL,
4300 `c953` int DEFAULT NULL,
4301 `c954` int DEFAULT NULL,
4302 `c955` int DEFAULT NULL,
4303 `c956` int DEFAULT NULL,
4304 `c957` int DEFAULT NULL,
4305 `c958` int DEFAULT NULL,
4306 `c959` int DEFAULT NULL,
4307 `c960` int DEFAULT NULL,
4308 `c961` int DEFAULT NULL,
4309 `c962` int DEFAULT NULL,
4310 `c963` int DEFAULT NULL,
4311 `c964` int DEFAULT NULL,
4312 `c965` int DEFAULT NULL,
4313 `c966` int DEFAULT NULL,
4314 `c967` int DEFAULT NULL,
4315 `c968` int DEFAULT NULL,
4316 `c969` int DEFAULT NULL,
4317 `c970` int DEFAULT NULL,
4318 `c971` int DEFAULT NULL,
4319 `c972` int DEFAULT NULL,
4320 `c973` int DEFAULT NULL,
4321 `c974` int DEFAULT NULL,
4322 `c975` int DEFAULT NULL,
4323 `c976` int DEFAULT NULL,
4324 `c977` int DEFAULT NULL,
4325 `c978` int DEFAULT NULL,
4326 `c979` int DEFAULT NULL,
4327 `c980` int DEFAULT NULL,
4328 `c981` int DEFAULT NULL,
4329 `c982` int DEFAULT NULL,
4330 `c983` int DEFAULT NULL,
4331 `c984` int DEFAULT NULL,
4332 `c985` int DEFAULT NULL,
4333 `c986` int DEFAULT NULL,
4334 `c987` int DEFAULT NULL,
4335 `c988` int DEFAULT NULL,
4336 `c989` int DEFAULT NULL,
4337 `c990` int DEFAULT NULL,
4338 `c991` int DEFAULT NULL,
4339 `c992` int DEFAULT NULL,
4340 `c993` int DEFAULT NULL,
4341 `c994` int DEFAULT NULL,
4342 `c995` int DEFAULT NULL,
4343 `c996` int DEFAULT NULL,
4344 `c997` int DEFAULT NULL,
4345 `c998` int DEFAULT NULL,
4346 `c999` int DEFAULT NULL,
4347 PRIMARY KEY (`c1`)
4348 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4349 ALTER TABLE t7 MODIFY c2 BIGINT NOT NULL;
4350 Get rec(type:id) is t7 CREATE TABLE `t7` (
4351 `c1` int NOT NULL,
4352 `c2` bigint NOT NULL,
4353 `c3` char(255) DEFAULT NULL,
4354 `c4` geometry NOT NULL /*!80003 SRID 0 */,
4355 PRIMARY KEY (`c1`),
4356 SPATIAL KEY `c4` (`c4`)
4357 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4358 ALTER TABLE t3 ADD FOREIGN KEY(c3) REFERENCES t2(c1);
4359 SHOW CREATE TABLE t3;
4360 Table Create Table
4361 t3 CREATE TABLE `t3` (
4362 `c1` varchar(32) NOT NULL,
4363 `c2` varchar(1024) DEFAULT NULL,
4364 `c3` int DEFAULT NULL,
4365 PRIMARY KEY (`c1`),
4366 KEY `c3` (`c3`),
4367 CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`c3`) REFERENCES `t2` (`c1`)
4368 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4369 Get rec(type:id) is t3 CREATE TABLE `t3` (
4370 `c1` varchar(32) NOT NULL,
4371 `c2` varchar(1024) DEFAULT NULL,
4372 `c3` int DEFAULT NULL,
4373 PRIMARY KEY (`c1`),
4374 KEY `c3` (`c3`),
4375 CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`c3`) REFERENCES `t2` (`c1`)
4376 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4377 ALTER TABLE t5 DROP FOREIGN KEY t5_ibfk_1;
4378 Get rec(type:id) is t5 CREATE TABLE `t5` (
4379 `c1` int NOT NULL,
4380 `c2` int DEFAULT NULL,
4381 PRIMARY KEY (`c1`),
4382 KEY `c2` (`c2`)
4383 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4384 ALTER TABLE t7 ADD INDEX idx3(c2,c3(50));
4385 Get rec(type:id) is t7 CREATE TABLE `t7` (
4386 `c1` int NOT NULL,
4387 `c2` bigint NOT NULL,
4388 `c3` char(255) DEFAULT NULL,
4389 `c4` geometry NOT NULL /*!80003 SRID 0 */,
4390 PRIMARY KEY (`c1`),
4391 SPATIAL KEY `c4` (`c4`),
4392 KEY `idx3` (`c2`,`c3`(50))
4393 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4394 ALTER TABLE t1 DROP PRIMARY KEY, DROP COLUMN c1, ADD c1 BIGINT PRIMARY
4395 KEY;
4396 Get rec(type:id) is t1 CREATE TABLE `t1` (
4397 `c2` varchar(1024) DEFAULT NULL,
4398 `c3` tinyblob,
4399 `c4` blob,
4400 `c5` mediumblob,
4401 `c6` longblob,
4402 `c7` text,
4403 `c8` int DEFAULT NULL,
4404 `c9` float DEFAULT NULL,
4405 `c10` double DEFAULT NULL,
4406 `c11` int DEFAULT NULL,
4407 `c1` bigint NOT NULL,
4408 PRIMARY KEY (`c1`),
4409 UNIQUE KEY `idx2` (`c6`(50)),
4410 KEY `idx1` (`c4`(20))
4411 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
4412 ALTER TABLE t1 ADD FULLTEXT INDEX(c2), ALGORITHM=INPLACE;
4413 Warnings:
4414 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
4415 Get rec(type:id) is t1 CREATE TABLE `t1` (
4416 `c2` varchar(1024) DEFAULT NULL,
4417 `c3` tinyblob,
4418 `c4` blob,
4419 `c5` mediumblob,
4420 `c6` longblob,
4421 `c7` text,
4422 `c8` int DEFAULT NULL,
4423 `c9` float DEFAULT NULL,
4424 `c10` double DEFAULT NULL,
4425 `c11` int DEFAULT NULL,
4426 `c1` bigint NOT NULL,
4427 PRIMARY KEY (`c1`),
4428 UNIQUE KEY `idx2` (`c6`(50)),
4429 KEY `idx1` (`c4`(20)),
4430 FULLTEXT KEY `c2` (`c2`)
4431 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
4432 ALTER TABLE t1 DROP INDEX c2;
4433 Get rec(type:id) is t1 CREATE TABLE `t1` (
4434 `c2` varchar(1024) DEFAULT NULL,
4435 `c3` tinyblob,
4436 `c4` blob,
4437 `c5` mediumblob,
4438 `c6` longblob,
4439 `c7` text,
4440 `c8` int DEFAULT NULL,
4441 `c9` float DEFAULT NULL,
4442 `c10` double DEFAULT NULL,
4443 `c11` int DEFAULT NULL,
4444 `c1` bigint NOT NULL,
4445 PRIMARY KEY (`c1`),
4446 UNIQUE KEY `idx2` (`c6`(50)),
4447 KEY `idx1` (`c4`(20))
4448 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
4449 TRUNCATE TABLE t7;
4450 Get rec(type:id) is t7 CREATE TABLE `t7` (
4451 `c1` int NOT NULL,
4452 `c2` bigint NOT NULL,
4453 `c3` char(255) DEFAULT NULL,
4454 `c4` geometry NOT NULL /*!80003 SRID 0 */,
4455 PRIMARY KEY (`c1`),
4456 SPATIAL KEY `c4` (`c4`),
4457 KEY `idx3` (`c2`,`c3`(50))
4458 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4459 DROP TABLE t1, t3, t2, t4, t5, t7;
4460 UNINSTALL PLUGIN daemon_memcached;
4461 # Create compressed table
4462 CREATE TABLE t6 (c1 INT PRIMARY KEY,
4463 c2 VARCHAR(30),
4464 c3 FLOAT,
4465 KEY idx1(c3),
4466 KEY idx2(c2(20)))
4467 ENGINE = INNODB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
4468 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
4469 Warnings:
4470 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
4471 Get rec(type:id) is t6 CREATE TABLE `t6` (
4472 `c1` int NOT NULL,
4473 `c2` varchar(30) DEFAULT NULL,
4474 `c3` float DEFAULT NULL,
4475 PRIMARY KEY (`c1`),
4476 KEY `idx1` (`c3`),
4477 KEY `idx2` (`c2`(20))
4478 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4
4479 DROP TABLE t6;
4480 # Create SDI in General tablespace
4481 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
4482 CREATE TABLE t6 (c1 INT PRIMARY KEY,
4483 c2 VARCHAR(30),
4484 c3 FLOAT,
4485 KEY idx1(c3),
4486 KEY idx2(c2(20)))
4487 ENGINE = INNODB TABLESPACE=ts1;
4488 Get rec(type:id) is t6 CREATE TABLE `t6` (
4489 `c1` int NOT NULL,
4490 `c2` varchar(30) DEFAULT NULL,
4491 `c3` float DEFAULT NULL,
4492 PRIMARY KEY (`c1`),
4493 KEY `idx1` (`c3`),
4494 KEY `idx2` (`c2`(20))
4495 ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
4496 DROP TABLE t6;
4497 DROP TABLESPACE ts1;
4498 DROP DATABASE innodb_memcache;
4499 UNINSTALL PLUGIN daemon_memcached;
4500 SET GLOBAL innodb_file_per_table = default;