1CREATE TABLE t1(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
2h blob,i blob,j blob,k blob,l blob,m blob,n blob,
3o blob,p blob,q blob,r blob,s blob,t blob,u blob,
4v blob, w blob, x blob, y blob, z blob,
5aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob,
6ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob,
7oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob,
8va blob, wa blob, xa blob, ya blob, za blob)
9ENGINE=InnoDB ROW_FORMAT=dynamic;
10SET innodb_strict_mode=OFF;
11CREATE TABLE t2(a blob,b blob,c blob,d blob,e blob,f blob,g blob,
12h blob,i blob,j blob,k blob,l blob,m blob,n blob,
13o blob,p blob,q blob,r blob,s blob,t blob,u blob,
14v blob, w blob, x blob, y blob, z blob,
15aa blob,ba blob,ca blob,da blob,ea blob,fa blob,ga blob,
16ha blob,ia blob,ja blob,ka blob,la blob,ma blob,na blob,
17oa blob,pa blob,qa blob,ra blob,sa blob,ta blob,ua blob,
18va blob, wa blob, xa blob, ya blob, za blob)
19ENGINE=InnoDB ROW_FORMAT=compact;
20Warnings:
21Warning	139	Row size too large (> 16318). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
22SET innodb_strict_mode=ON;
23SET @a = repeat('a', 767);
24SET @b = repeat('b', 767);
25SET @c = repeat('c', 767);
26SET @d = repeat('d', 767);
27SET @e = repeat('e', 767);
28SET @f = repeat('f', 767);
29SET @f = repeat('g', 767);
30INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
31INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
32INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
33INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
34INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
35INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
36INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
37INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
38INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
39INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a,@a);
40SET @f = repeat('h', 500);
41SET @f = repeat('i', 500);
42SET @f = repeat('j', 500);
43SET @f = repeat('k', 500);
44SET @f = repeat('l', 500);
45SET @f = repeat('m', 500);
46INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
47INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
48INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
49INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
50INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
51INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
52INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
53INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
54INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
55INSERT INTO t2 VALUES (@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h,@h);
56UPDATE t1 SET a=@b,b=@b,c=@b,d=@b,e=@b,f=@b,g=@b,h=@b,i=@b,j=@b,
57k=@b,l=@b,m=@b,n=@b,o=@b,p=@b,q=@b,r=@b,s=@b,t=@b,u=@b,
58v=@b,w=@b,x=@b,y=@b,z=@b,
59aa=@b,ba=@b,ca=@b,da=@b,ea=@b,fa=@b,ga=@b,ha=@b,ia=@b,ja=@b,
60ka=@b,la=@b,ma=@b,na=@b,oa=@b,pa=@b,qa=@b,ra=@b,sa=@b,ta=@b,ua=@b,
61va=@b,wa=@b,xa=@b,ya=@b,za=@b;
62UPDATE t2 SET a=@i,b=@i,c=@i,d=@i,e=@i,f=@i,g=@i,h=@i,i=@i,j=@i,
63k=@i,l=@i,m=@i,n=@i,o=@i,p=@i,q=@i,r=@i,s=@i,t=@i,u=@i,
64v=@i,w=@i,x=@i,y=@i,z=@i,
65aa=@i,ba=@i,ca=@i,da=@i,ea=@i,fa=@i,ga=@i,ha=@i,ia=@i,ja=@i,
66ka=@i,la=@i,ma=@i,na=@i,oa=@i,pa=@i,qa=@i,ra=@i,sa=@i,ta=@i,ua=@i,
67va=@i,wa=@i,xa=@i,ya=@i,za=@i;
68CREATE INDEX t1a ON t1 (a(767));
69CREATE INDEX t1b ON t1 (b(767));
70CREATE INDEX t1c ON t1 (c(767));
71CREATE INDEX t1d ON t1 (d(767));
72CREATE INDEX t1e ON t1 (e(767));
73CREATE INDEX t1f1 ON t1 (f(767));
74CREATE INDEX t1f2 ON t1 (g(767));
75CREATE INDEX t1f3 ON t1 (h(767));
76CREATE INDEX t1f4 ON t1 (i(767));
77CREATE INDEX t1f5 ON t1 (j(767));
78CREATE INDEX t1a ON t2 (a(767));
79CREATE INDEX t1b ON t2 (b(767));
80CREATE INDEX t1c ON t2 (c(767));
81CREATE INDEX t1d ON t2 (d(767));
82CREATE INDEX t1e ON t2 (e(767));
83CREATE INDEX t1f1 ON t2 (f(767));
84CREATE INDEX t1f2 ON t2 (g(767));
85CREATE INDEX t1f3 ON t2 (h(767));
86UPDATE t1 SET a=@c,b=@c,c=@c,d=@c,e=@c,f=@c,g=@c,h=@c,i=@c,j=@c,
87k=@c,l=@c,m=@c,n=@c,o=@c,p=@c,q=@c,r=@c,s=@c,t=@c,u=@c,
88v=@c,w=@c,x=@b,y=@c,z=@c,
89aa=@c,ba=@c,ca=@c,da=@c,ea=@c,fa=@c,ga=@c,ha=@c,ia=@c,ja=@c,
90ka=@c,la=@c,ma=@c,na=@c,oa=@c,pa=@c,qa=@c,ra=@c,sa=@c,ta=@b,ua=@c,
91va=@c,wa=@c,xa=@c,ya=@c,za=@c;
92UPDATE t2 SET a=@k,b=@k,c=@k,d=@k,e=@k,f=@k,g=@k,h=@k,i=@k,j=@k,
93k=@k,l=@k,m=@k,n=@k,o=@k,p=@k,q=@k,r=@k,s=@k,t=@k,u=@k,
94v=@k,w=@k,x=@b,y=@k,z=@k,
95aa=@k,ba=@k,ca=@k,da=@k,ea=@k,fa=@k,ga=@k,ha=@k,ia=@k,ja=@k,
96ka=@k,la=@k,ma=@k,na=@k,oa=@k,pa=@k,qa=@k,ra=@k,sa=@k,ta=@b,ua=@k,
97va=@k,wa=@k,xa=@k,ya=@k,za=@k;
98BEGIN;
99UPDATE t1 SET a=@d,b=@d,c=@d,d=@d,e=@d;
100UPDATE t1 SET f=@d,g=@d,h=@d,i=@d,j=@d;
101UPDATE t1 SET k=@d,l=@d,m=@d,n=@d,o=@d;
102UPDATE t1 SET p=@d,q=@d,r=@d,s=@d,t=@d,u=@d;
103UPDATE t1 SET v=@d,w=@d,x=@d,y=@d,z=@d;
104UPDATE t1 SET aa=@d,ba=@d,ca=@d,da=@d;
105UPDATE t1 SET ea=@d,fa=@d,ga=@d,ha=@d,ia=@d,ja=@d;
106UPDATE t1 SET ka=@d,la=@d,ma=@d,na=@d,oa=@d,pa=@d;
107UPDATE t1 SET qa=@d,ra=@d,sa=@d,ta=@d,ua=@d;
108UPDATE t1 SET va=@d,wa=@d,xa=@d,ya=@d,za=@d;
109COMMIT;
110BEGIN;
111UPDATE t2 SET a=@l,b=@l,c=@l,d=@l,e=@l;
112UPDATE t2 SET f=@l,g=@l,h=@l,i=@l,j=@l;
113UPDATE t2 SET k=@l,l=@l,m=@l,n=@l,o=@l;
114UPDATE t2 SET p=@l,q=@l,r=@l,s=@l,t=@l,u=@l;
115UPDATE t2 SET v=@l,w=@l,x=@l,y=@l,z=@l;
116UPDATE t2 SET aa=@l,ba=@l,ca=@l,da=@l;
117UPDATE t2 SET ea=@l,fa=@l,ga=@l,ha=@l,ia=@l,ja=@l;
118UPDATE t2 SET ka=@l,la=@l,ma=@l,na=@l,oa=@l,pa=@l;
119UPDATE t2 SET qa=@l,ra=@l,sa=@l,ta=@l,ua=@l;
120UPDATE t2 SET va=@l,wa=@l,xa=@l,ya=@l,za=@l;
121COMMIT;
122BEGIN;
123INSERT INTO t1 SELECT * from t2;
124BEGIN;
125UPDATE t1 SET a=@e,b=@e,c=@e,d=@e,e=@e;
126# restart
127UPDATE t1 SET a=@f,b=@f,c=@f,d=@f,e=@f,f=@f,g=@f,h=@f,i=@f,j=@f,
128k=@f,l=@f,m=@f,n=@f,o=@f,p=@f,q=@f,r=@f,s=@f,t=@f,u=@f,
129v=@f,w=@f,x=@b,y=@f,z=@f,
130aa=@f,ba=@f,ca=@f,da=@f,ea=@f,fa=@f,ga=@f,ha=@f,ia=@f,ja=@f,
131ka=@f,la=@f,ma=@f,na=@f,oa=@f,pa=@f,qa=@f,ra=@f,sa=@f,ta=@b,ua=@f,
132va=@f,wa=@f,xa=@f,ya=@f,za=@f;
133UPDATE t2 SET a=@h,b=@h,c=@h,d=@h,e=@h,f=@h,g=@h,h=@h,i=@h,j=@h,
134k=@h,l=@h,m=@h,n=@h,o=@h,p=@h,q=@h,r=@h,s=@h,t=@h,u=@h,
135v=@h,w=@h,x=@b,y=@h,z=@h,
136aa=@h,ba=@h,ca=@h,da=@h,ea=@h,fa=@h,ga=@h,ha=@h,ia=@h,ja=@h,
137ka=@h,la=@h,ma=@h,na=@h,oa=@h,pa=@h,qa=@h,ra=@h,sa=@h,ta=@b,ua=@h,
138va=@h,wa=@h,xa=@h,ya=@h,za=@h;
139BEGIN;
140UPDATE t1 SET a=@g,b=@g,c=@g,d=@g,e=@g;
141UPDATE t1 SET f=@g,g=@g,h=@g,i=@g,j=@g;
142UPDATE t1 SET k=@g,l=@g,m=@g,n=@g,o=@g;
143UPDATE t1 SET p=@g,q=@g,r=@g,s=@g,t=@g,u=@g;
144UPDATE t1 SET v=@g,w=@g,x=@g,y=@g,z=@g;
145UPDATE t1 SET aa=@g,ba=@g,ca=@g,da=@g;
146UPDATE t1 SET ea=@g,fa=@g,ga=@g,ha=@g,ia=@g,ja=@g;
147UPDATE t1 SET ka=@g,la=@g,ma=@g,na=@g,oa=@g,pa=@g;
148UPDATE t1 SET qa=@g,ra=@g,sa=@g,ta=@g,ua=@g;
149UPDATE t1 SET va=@g,wa=@g,xa=@g,ya=@g,za=@g;
150COMMIT;
151BEGIN;
152UPDATE t2 SET a=@m,b=@m,c=@m,d=@m,e=@m;
153UPDATE t2 SET f=@m,g=@m,h=@m,i=@m,j=@m;
154UPDATE t2 SET k=@m,l=@m,m=@m,n=@m,o=@m;
155UPDATE t2 SET p=@m,q=@m,r=@m,s=@m,t=@m,u=@m;
156UPDATE t2 SET v=@m,w=@m,x=@m,y=@m,z=@m;
157UPDATE t2 SET aa=@m,ba=@m,ca=@m,da=@m;
158UPDATE t2 SET ea=@m,fa=@m,ga=@m,ha=@m,ia=@m,ja=@m;
159UPDATE t2 SET ka=@m,la=@m,ma=@m,na=@m,oa=@m,pa=@m;
160UPDATE t2 SET qa=@m,ra=@m,sa=@m,ta=@m,ua=@m;
161UPDATE t2 SET va=@m,wa=@m,xa=@m,ya=@m,za=@m;
162COMMIT;
163show create table t1;
164Table	Create Table
165t1	CREATE TABLE `t1` (
166  `a` blob DEFAULT NULL,
167  `b` blob DEFAULT NULL,
168  `c` blob DEFAULT NULL,
169  `d` blob DEFAULT NULL,
170  `e` blob DEFAULT NULL,
171  `f` blob DEFAULT NULL,
172  `g` blob DEFAULT NULL,
173  `h` blob DEFAULT NULL,
174  `i` blob DEFAULT NULL,
175  `j` blob DEFAULT NULL,
176  `k` blob DEFAULT NULL,
177  `l` blob DEFAULT NULL,
178  `m` blob DEFAULT NULL,
179  `n` blob DEFAULT NULL,
180  `o` blob DEFAULT NULL,
181  `p` blob DEFAULT NULL,
182  `q` blob DEFAULT NULL,
183  `r` blob DEFAULT NULL,
184  `s` blob DEFAULT NULL,
185  `t` blob DEFAULT NULL,
186  `u` blob DEFAULT NULL,
187  `v` blob DEFAULT NULL,
188  `w` blob DEFAULT NULL,
189  `x` blob DEFAULT NULL,
190  `y` blob DEFAULT NULL,
191  `z` blob DEFAULT NULL,
192  `aa` blob DEFAULT NULL,
193  `ba` blob DEFAULT NULL,
194  `ca` blob DEFAULT NULL,
195  `da` blob DEFAULT NULL,
196  `ea` blob DEFAULT NULL,
197  `fa` blob DEFAULT NULL,
198  `ga` blob DEFAULT NULL,
199  `ha` blob DEFAULT NULL,
200  `ia` blob DEFAULT NULL,
201  `ja` blob DEFAULT NULL,
202  `ka` blob DEFAULT NULL,
203  `la` blob DEFAULT NULL,
204  `ma` blob DEFAULT NULL,
205  `na` blob DEFAULT NULL,
206  `oa` blob DEFAULT NULL,
207  `pa` blob DEFAULT NULL,
208  `qa` blob DEFAULT NULL,
209  `ra` blob DEFAULT NULL,
210  `sa` blob DEFAULT NULL,
211  `ta` blob DEFAULT NULL,
212  `ua` blob DEFAULT NULL,
213  `va` blob DEFAULT NULL,
214  `wa` blob DEFAULT NULL,
215  `xa` blob DEFAULT NULL,
216  `ya` blob DEFAULT NULL,
217  `za` blob DEFAULT NULL,
218  KEY `t1a` (`a`(767)),
219  KEY `t1b` (`b`(767)),
220  KEY `t1c` (`c`(767)),
221  KEY `t1d` (`d`(767)),
222  KEY `t1e` (`e`(767)),
223  KEY `t1f1` (`f`(767)),
224  KEY `t1f2` (`g`(767)),
225  KEY `t1f3` (`h`(767)),
226  KEY `t1f4` (`i`(767)),
227  KEY `t1f5` (`j`(767))
228) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
229show create table t2;
230Table	Create Table
231t2	CREATE TABLE `t2` (
232  `a` blob DEFAULT NULL,
233  `b` blob DEFAULT NULL,
234  `c` blob DEFAULT NULL,
235  `d` blob DEFAULT NULL,
236  `e` blob DEFAULT NULL,
237  `f` blob DEFAULT NULL,
238  `g` blob DEFAULT NULL,
239  `h` blob DEFAULT NULL,
240  `i` blob DEFAULT NULL,
241  `j` blob DEFAULT NULL,
242  `k` blob DEFAULT NULL,
243  `l` blob DEFAULT NULL,
244  `m` blob DEFAULT NULL,
245  `n` blob DEFAULT NULL,
246  `o` blob DEFAULT NULL,
247  `p` blob DEFAULT NULL,
248  `q` blob DEFAULT NULL,
249  `r` blob DEFAULT NULL,
250  `s` blob DEFAULT NULL,
251  `t` blob DEFAULT NULL,
252  `u` blob DEFAULT NULL,
253  `v` blob DEFAULT NULL,
254  `w` blob DEFAULT NULL,
255  `x` blob DEFAULT NULL,
256  `y` blob DEFAULT NULL,
257  `z` blob DEFAULT NULL,
258  `aa` blob DEFAULT NULL,
259  `ba` blob DEFAULT NULL,
260  `ca` blob DEFAULT NULL,
261  `da` blob DEFAULT NULL,
262  `ea` blob DEFAULT NULL,
263  `fa` blob DEFAULT NULL,
264  `ga` blob DEFAULT NULL,
265  `ha` blob DEFAULT NULL,
266  `ia` blob DEFAULT NULL,
267  `ja` blob DEFAULT NULL,
268  `ka` blob DEFAULT NULL,
269  `la` blob DEFAULT NULL,
270  `ma` blob DEFAULT NULL,
271  `na` blob DEFAULT NULL,
272  `oa` blob DEFAULT NULL,
273  `pa` blob DEFAULT NULL,
274  `qa` blob DEFAULT NULL,
275  `ra` blob DEFAULT NULL,
276  `sa` blob DEFAULT NULL,
277  `ta` blob DEFAULT NULL,
278  `ua` blob DEFAULT NULL,
279  `va` blob DEFAULT NULL,
280  `wa` blob DEFAULT NULL,
281  `xa` blob DEFAULT NULL,
282  `ya` blob DEFAULT NULL,
283  `za` blob DEFAULT NULL,
284  KEY `t1a` (`a`(767)),
285  KEY `t1b` (`b`(767)),
286  KEY `t1c` (`c`(767)),
287  KEY `t1d` (`d`(767)),
288  KEY `t1e` (`e`(767)),
289  KEY `t1f1` (`f`(767)),
290  KEY `t1f2` (`g`(767)),
291  KEY `t1f3` (`h`(767))
292) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT
293drop table t1,t2;
294