1 --source include/have_ujis.inc
2 --source include/have_innodb.inc
6 DROP TABLE IF EXISTS `Ž±Ž±Ž±`;
7 DROP TABLE IF EXISTS `Ž²Ž²Ž²`;
8 DROP TABLE IF EXISTS `¤¢¤¢¤¢`;
9 DROP TABLE IF EXISTS `¤¤¤¤¤¤`;
10 DROP TABLE IF EXISTS `�íÝ�íÝ�íÝ`;
11 DROP TABLE IF EXISTS `�íÞ�íÞ�íÞ`;
15 # Test altering table with Japanese characters in ujis encoding
19 SET character_set_database = ujis;
24 CREATE TABLE `Ž±Ž±Ž±`(`Ž·Ž·Ž·` char(5)) DEFAULT CHARSET = ujis engine=INNODB;
25 CREATE TABLE `Ž²Ž²Ž²`(`Ž¹Ž¹Ž¹` char(5)) DEFAULT CHARSET = ujis engine=INNODB;
26 CREATE TABLE `¤¢¤¢¤¢`(`¤¤¤` char(5)) DEFAULT CHARSET = ujis engine=INNODB;
27 CREATE TABLE `¤¤¤¤¤¤`(`¤±¤±¤±` char(5)) DEFAULT CHARSET = ujis engine=INNODB;
28 CREATE TABLE `�íÝ�íÝ�íÝ`(`�°¡�°¡�°¡` char(5)) DEFAULT CHARSET = ujis engine=INNODB;
29 CREATE TABLE `�íÞ�íÞ�íÞ`(`�°´�°´�°´` char(5)) DEFAULT CHARSET = ujis engine=INNODB;
31 INSERT INTO `Ž±Ž±Ž±` VALUES ('Ž±Ž±Ž±Ž±Ž±'),('Ž²Ž²Ž²Ž²Ž²'),('Ž³Ž³Ž³Ž³Ž³');
32 INSERT INTO `¤¢¤¢¤¢` VALUES ('¤¢¤¢¤¢¤¢¤¢'),('¤¤¤¤¤¤¤¤¤¤'),('¤¦¤¦¤¦¤¦¤¦');
33 INSERT INTO `�íÝ�íÝ�íÝ` VALUES ('�°¡�°¡�°¡�°¡�°¡'),('�°¢�°¢�°¢�°¢�°¢'),('�°£�°£�°£�°£�°£');
35 # Test basic alter operation
37 ALTER TABLE `Ž±Ž±Ž±` ADD `Ž¶Ž¶Ž¶` char(1) FIRST;
38 ALTER TABLE `Ž±Ž±Ž±` ADD `Ž¸Ž¸Ž¸` char(1) AFTER `Ž·Ž·Ž·`;
39 ALTER TABLE `Ž±Ž±Ž±` ADD `Ž¹Ž¹Ž¹` char(1);
40 ALTER TABLE `Ž±Ž±Ž±` ADD INDEX (`Ž¶Ž¶Ž¶`);
41 ALTER TABLE `Ž±Ž±Ž±` ADD PRIMARY KEY (`Ž·Ž·Ž·`);
42 ALTER TABLE `Ž±Ž±Ž±` ADD UNIQUE (`Ž¸Ž¸Ž¸`);
43 #Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4
44 #ALTER TABLE `Ž±Ž±Ž±` ADD FOREIGN KEY (`Ž¹Ž¹Ž¹`) REFERENCES `Ž²Ž²Ž²`(`Ž¹Ž¹Ž¹`);
45 ALTER TABLE `Ž±Ž±Ž±` CHANGE `Ž¶Ž¶Ž¶` `Ž¶Ž¶` char(1);
46 ALTER TABLE `Ž±Ž±Ž±` MODIFY `Ž·Ž·Ž·` char(6);
48 SELECT * FROM `Ž±Ž±Ž±`;
50 SHOW CREATE TABLE `Ž±Ž±Ž±`;
52 ALTER TABLE `Ž±Ž±Ž±` DROP INDEX `Ž¶Ž¶Ž¶`;
53 ALTER TABLE `Ž±Ž±Ž±` DROP PRIMARY KEY;
54 ALTER TABLE `Ž±Ž±Ž±` DROP INDEX `Ž¸Ž¸Ž¸`;
55 #ALTER TABLE `Ž±Ž±Ž±` DROP FOREIGN KEY `Ž¹Ž¹Ž¹`;
56 ALTER TABLE `Ž±Ž±Ž±` DROP `Ž¶Ž¶`;
57 ALTER TABLE `Ž±Ž±Ž±` DROP `Ž¸Ž¸Ž¸`;
58 ALTER TABLE `Ž±Ž±Ž±` DROP `Ž¹Ž¹Ž¹`;
59 SELECT * FROM `Ž±Ž±Ž±`;
61 SHOW CREATE TABLE `Ž±Ž±Ž±`;
63 ALTER TABLE `¤¢¤¢¤¢` ADD `¤«¤«¤«` char(1) FIRST;
64 ALTER TABLE `¤¢¤¢¤¢` ADD `¤¯¤¯¤¯` char(1) AFTER `¤¤¤`;
65 ALTER TABLE `¤¢¤¢¤¢` ADD `¤±¤±¤±` char(1);
66 ALTER TABLE `¤¢¤¢¤¢` ADD INDEX (`¤«¤«¤«`);
67 ALTER TABLE `¤¢¤¢¤¢` ADD PRIMARY KEY (`¤¤¤`);
68 ALTER TABLE `¤¢¤¢¤¢` ADD UNIQUE (`¤¯¤¯¤¯`);
69 #Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4
70 #ALTER TABLE `¤¢¤¢¤¢` ADD FOREIGN KEY (`¤±¤±¤±`) REFERENCES `¤¤¤¤¤¤`(`¤±¤±¤±`);
71 ALTER TABLE `¤¢¤¢¤¢` CHANGE `¤«¤«¤«` `¤«¤«` char(1);
72 ALTER TABLE `¤¢¤¢¤¢` MODIFY `¤¤¤` char(6);
74 SELECT * FROM `¤¢¤¢¤¢`;
76 SHOW CREATE TABLE `¤¢¤¢¤¢`;
78 ALTER TABLE `¤¢¤¢¤¢` DROP INDEX `¤«¤«¤«`;
79 ALTER TABLE `¤¢¤¢¤¢` DROP PRIMARY KEY;
80 ALTER TABLE `¤¢¤¢¤¢` DROP INDEX `¤¯¤¯¤¯`;
81 #ALTER TABLE `¤¢¤¢¤¢` DROP FOREIGN KEY `¤±¤±¤±`;
82 ALTER TABLE `¤¢¤¢¤¢` DROP `¤«¤«`;
83 ALTER TABLE `¤¢¤¢¤¢` DROP `¤¯¤¯¤¯`;
84 ALTER TABLE `¤¢¤¢¤¢` DROP `¤±¤±¤±`;
86 SELECT * FROM `¤¢¤¢¤¢`;
88 SHOW CREATE TABLE `¤¢¤¢¤¢`;
90 ALTER TABLE `�íÝ�íÝ�íÝ` ADD `�°¢�°¢�°¢` char(1) FIRST;
91 ALTER TABLE `�íÝ�íÝ�íÝ` ADD `�°£�°£�°£` char(1) AFTER `�°¡�°¡�°¡`;
92 ALTER TABLE `�íÝ�íÝ�íÝ` ADD `�°´�°´�°´` char(1);
93 ALTER TABLE `�íÝ�íÝ�íÝ` ADD INDEX (`�°¢�°¢�°¢`);
94 ALTER TABLE `�íÝ�íÝ�íÝ` ADD PRIMARY KEY (`�°¡�°¡�°¡`);
95 ALTER TABLE `�íÝ�íÝ�íÝ` ADD UNIQUE (`�°£�°£�°£`);
96 #Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4
97 #ALTER TABLE `�íÝ�íÝ�íÝ` ADD FOREIGN KEY (`�°´�°´�°´`) REFERENCES `�íÞ�íÞ�íÞ`(`�°´�°´�°´`);
98 ALTER TABLE `�íÝ�íÝ�íÝ` CHANGE `�°¢�°¢�°¢` `�°¢�°¢` char(1);
99 ALTER TABLE `�íÝ�íÝ�íÝ` MODIFY `�°¡�°¡�°¡` char(6);
101 SELECT * FROM `�íÝ�íÝ�íÝ`;
103 SHOW CREATE TABLE `�íÝ�íÝ�íÝ`;
105 ALTER TABLE `�íÝ�íÝ�íÝ` DROP INDEX `�°¢�°¢�°¢`;
106 ALTER TABLE `�íÝ�íÝ�íÝ` DROP PRIMARY KEY;
107 ALTER TABLE `�íÝ�íÝ�íÝ` DROP INDEX `�°£�°£�°£`;
108 #ALTER TABLE `�íÝ�íÝ�íÝ` DROP FOREIGN KEY `�°´�°´�°´`;
109 ALTER TABLE `�íÝ�íÝ�íÝ` DROP `�°¢�°¢`;
110 ALTER TABLE `�íÝ�íÝ�íÝ` DROP `�°£�°£�°£`;
111 ALTER TABLE `�íÝ�íÝ�íÝ` DROP `�°´�°´�°´`;
113 SELECT * FROM `�íÝ�íÝ�íÝ`;
115 SHOW CREATE TABLE `�íÝ�íÝ�íÝ`;
121 DROP TABLE `�íÝ�íÝ�íÝ`;
122 DROP TABLE `�íÞ�íÞ�íÞ`;
128 CREATE TABLE `Ž±Ž±Ž±`(`Ž·Ž·Ž·` char(5)) DEFAULT CHARSET = ujis engine=MYISAM;
129 CREATE TABLE `Ž²Ž²Ž²`(`Ž¹Ž¹Ž¹` char(5)) DEFAULT CHARSET = ujis engine=MYISAM;
130 CREATE TABLE `¤¢¤¢¤¢`(`¤¤¤` char(5)) DEFAULT CHARSET = ujis engine=MYISAM;
131 CREATE TABLE `¤¤¤¤¤¤`(`¤±¤±¤±` char(5)) DEFAULT CHARSET = ujis engine=MYISAM;
132 CREATE TABLE `�íÝ�íÝ�íÝ`(`�°¡�°¡�°¡` char(5)) DEFAULT CHARSET = ujis engine=MYISAM;
133 CREATE TABLE `�íÞ�íÞ�íÞ`(`�°´�°´�°´` char(5)) DEFAULT CHARSET = ujis engine=MYISAM;
135 INSERT INTO `Ž±Ž±Ž±` VALUES ('Ž±Ž±Ž±Ž±Ž±'),('Ž²Ž²Ž²Ž²Ž²'),('Ž³Ž³Ž³Ž³Ž³');
136 INSERT INTO `¤¢¤¢¤¢` VALUES ('¤¢¤¢¤¢¤¢¤¢'),('¤¤¤¤¤¤¤¤¤¤'),('¤¦¤¦¤¦¤¦¤¦');
137 INSERT INTO `�íÝ�íÝ�íÝ` VALUES ('�°¡�°¡�°¡�°¡�°¡'),('�°¢�°¢�°¢�°¢�°¢'),('�°£�°£�°£�°£�°£');
139 ALTER TABLE `Ž±Ž±Ž±` ADD `Ž¶Ž¶Ž¶` char(1) FIRST;
140 ALTER TABLE `Ž±Ž±Ž±` ADD `Ž¸Ž¸Ž¸` char(1) AFTER `Ž·Ž·Ž·`;
141 ALTER TABLE `Ž±Ž±Ž±` ADD `Ž¹Ž¹Ž¹` char(1);
142 ALTER TABLE `Ž±Ž±Ž±` ADD INDEX (`Ž¶Ž¶Ž¶`);
143 ALTER TABLE `Ž±Ž±Ž±` ADD PRIMARY KEY (`Ž·Ž·Ž·`);
144 ALTER TABLE `Ž±Ž±Ž±` ADD UNIQUE (`Ž¸Ž¸Ž¸`);
145 #ALTER TABLE `Ž±Ž±Ž±` ADD FOREIGN KEY (`Ž¹Ž¹Ž¹`) REFERENCES `Ž²Ž²Ž²`(`Ž¹Ž¹Ž¹`);
146 ALTER TABLE `Ž±Ž±Ž±` CHANGE `Ž¶Ž¶Ž¶` `Ž¶Ž¶` char(1);
147 ALTER TABLE `Ž±Ž±Ž±` MODIFY `Ž·Ž·Ž·` char(6);
149 SELECT * FROM `Ž±Ž±Ž±`;
151 SHOW CREATE TABLE `Ž±Ž±Ž±`;
153 ALTER TABLE `Ž±Ž±Ž±` DROP INDEX `Ž¶Ž¶Ž¶`;
154 ALTER TABLE `Ž±Ž±Ž±` DROP PRIMARY KEY;
155 ALTER TABLE `Ž±Ž±Ž±` DROP INDEX `Ž¸Ž¸Ž¸`;
156 #ALTER TABLE `Ž±Ž±Ž±` DROP FOREIGN KEY `Ž¹Ž¹Ž¹`;
157 ALTER TABLE `Ž±Ž±Ž±` DROP `Ž¶Ž¶`;
158 ALTER TABLE `Ž±Ž±Ž±` DROP `Ž¸Ž¸Ž¸`;
159 ALTER TABLE `Ž±Ž±Ž±` DROP `Ž¹Ž¹Ž¹`;
160 SELECT * FROM `Ž±Ž±Ž±`;
162 SHOW CREATE TABLE `Ž±Ž±Ž±`;
164 ALTER TABLE `¤¢¤¢¤¢` ADD `¤«¤«¤«` char(1) FIRST;
165 ALTER TABLE `¤¢¤¢¤¢` ADD `¤¯¤¯¤¯` char(1) AFTER `¤¤¤`;
166 ALTER TABLE `¤¢¤¢¤¢` ADD `¤±¤±¤±` char(1);
167 ALTER TABLE `¤¢¤¢¤¢` ADD INDEX (`¤«¤«¤«`);
168 ALTER TABLE `¤¢¤¢¤¢` ADD PRIMARY KEY (`¤¤¤`);
169 ALTER TABLE `¤¢¤¢¤¢` ADD UNIQUE (`¤¯¤¯¤¯`);
170 #ALTER TABLE `¤¢¤¢¤¢` ADD FOREIGN KEY (`¤±¤±¤±`) REFERENCES `¤¤¤¤¤¤`(`¤±¤±¤±`);
171 ALTER TABLE `¤¢¤¢¤¢` CHANGE `¤«¤«¤«` `¤«¤«` char(1);
172 ALTER TABLE `¤¢¤¢¤¢` MODIFY `¤¤¤` char(6);
174 SELECT * FROM `¤¢¤¢¤¢`;
176 SHOW CREATE TABLE `¤¢¤¢¤¢`;
178 ALTER TABLE `¤¢¤¢¤¢` DROP INDEX `¤«¤«¤«`;
179 ALTER TABLE `¤¢¤¢¤¢` DROP PRIMARY KEY;
180 ALTER TABLE `¤¢¤¢¤¢` DROP INDEX `¤¯¤¯¤¯`;
181 #ALTER TABLE `¤¢¤¢¤¢` DROP FOREIGN KEY `¤±¤±¤±`;
182 ALTER TABLE `¤¢¤¢¤¢` DROP `¤«¤«`;
183 ALTER TABLE `¤¢¤¢¤¢` DROP `¤¯¤¯¤¯`;
184 ALTER TABLE `¤¢¤¢¤¢` DROP `¤±¤±¤±`;
186 SELECT * FROM `¤¢¤¢¤¢`;
188 SHOW CREATE TABLE `¤¢¤¢¤¢`;
190 ALTER TABLE `�íÝ�íÝ�íÝ` ADD `�°¢�°¢�°¢` char(1) FIRST;
191 ALTER TABLE `�íÝ�íÝ�íÝ` ADD `�°£�°£�°£` char(1) AFTER `�°¡�°¡�°¡`;
192 ALTER TABLE `�íÝ�íÝ�íÝ` ADD `�°´�°´�°´` char(1);
193 ALTER TABLE `�íÝ�íÝ�íÝ` ADD INDEX (`�°¢�°¢�°¢`);
194 ALTER TABLE `�íÝ�íÝ�íÝ` ADD PRIMARY KEY (`�°¡�°¡�°¡`);
195 ALTER TABLE `�íÝ�íÝ�íÝ` ADD UNIQUE (`�°£�°£�°£`);
196 #ALTER TABLE `�íÝ�íÝ�íÝ` ADD FOREIGN KEY (`�°´�°´�°´`) REFERENCES `�íÞ�íÞ�íÞ`(`�°´�°´�°´`);
197 ALTER TABLE `�íÝ�íÝ�íÝ` CHANGE `�°¢�°¢�°¢` `�°¢�°¢` char(1);
198 ALTER TABLE `�íÝ�íÝ�íÝ` MODIFY `�°¡�°¡�°¡` char(6);
200 SELECT * FROM `�íÝ�íÝ�íÝ`;
202 SHOW CREATE TABLE `�íÝ�íÝ�íÝ`;
204 ALTER TABLE `�íÝ�íÝ�íÝ` DROP INDEX `�°¢�°¢�°¢`;
205 ALTER TABLE `�íÝ�íÝ�íÝ` DROP PRIMARY KEY;
206 ALTER TABLE `�íÝ�íÝ�íÝ` DROP INDEX `�°£�°£�°£`;
207 #ALTER TABLE `�íÝ�íÝ�íÝ` DROP FOREIGN KEY `�°´�°´�°´`;
208 ALTER TABLE `�íÝ�íÝ�íÝ` DROP `�°¢�°¢`;
209 ALTER TABLE `�íÝ�íÝ�íÝ` DROP `�°£�°£�°£`;
210 ALTER TABLE `�íÝ�íÝ�íÝ` DROP `�°´�°´�°´`;
212 SELECT * FROM `�íÝ�íÝ�íÝ`;
214 SHOW CREATE TABLE `�íÝ�íÝ�íÝ`;
220 DROP TABLE `�íÝ�íÝ�íÝ`;
221 DROP TABLE `�íÞ�íÞ�íÞ`;
227 CREATE TABLE `Ž±Ž±Ž±`(`Ž·Ž·Ž·` char(5)) DEFAULT CHARSET = ujis engine=MEMORY;
228 CREATE TABLE `Ž²Ž²Ž²`(`Ž¹Ž¹Ž¹` char(5)) DEFAULT CHARSET = ujis engine=MEMORY;
229 CREATE TABLE `¤¢¤¢¤¢`(`¤¤¤` char(5)) DEFAULT CHARSET = ujis engine=MEMORY;
230 CREATE TABLE `¤¤¤¤¤¤`(`¤±¤±¤±` char(5)) DEFAULT CHARSET = ujis engine=MEMORY;
231 CREATE TABLE `�íÝ�íÝ�íÝ`(`�°¡�°¡�°¡` char(5)) DEFAULT CHARSET = ujis engine=MEMORY;
232 CREATE TABLE `�íÞ�íÞ�íÞ`(`�°´�°´�°´` char(5)) DEFAULT CHARSET = ujis engine=MEMORY;
234 INSERT INTO `Ž±Ž±Ž±` VALUES ('Ž±Ž±Ž±Ž±Ž±'),('Ž²Ž²Ž²Ž²Ž²'),('Ž³Ž³Ž³Ž³Ž³');
235 INSERT INTO `¤¢¤¢¤¢` VALUES ('¤¢¤¢¤¢¤¢¤¢'),('¤¤¤¤¤¤¤¤¤¤'),('¤¦¤¦¤¦¤¦¤¦');
236 INSERT INTO `�íÝ�íÝ�íÝ` VALUES ('�°¡�°¡�°¡�°¡�°¡'),('�°¢�°¢�°¢�°¢�°¢'),('�°£�°£�°£�°£�°£');
238 ALTER TABLE `Ž±Ž±Ž±` ADD `Ž¶Ž¶Ž¶` char(1) FIRST;
239 ALTER TABLE `Ž±Ž±Ž±` ADD `Ž¸Ž¸Ž¸` char(1) AFTER `Ž·Ž·Ž·`;
240 ALTER TABLE `Ž±Ž±Ž±` ADD `Ž¹Ž¹Ž¹` char(1);
241 ALTER TABLE `Ž±Ž±Ž±` ADD INDEX (`Ž¶Ž¶Ž¶`);
242 ALTER TABLE `Ž±Ž±Ž±` ADD PRIMARY KEY (`Ž·Ž·Ž·`);
243 ALTER TABLE `Ž±Ž±Ž±` ADD UNIQUE (`Ž¸Ž¸Ž¸`);
244 #ALTER TABLE `Ž±Ž±Ž±` ADD FOREIGN KEY (`Ž¹Ž¹Ž¹`) REFERENCES `Ž²Ž²Ž²`(`Ž¹Ž¹Ž¹`);
245 ALTER TABLE `Ž±Ž±Ž±` CHANGE `Ž¶Ž¶Ž¶` `Ž¶Ž¶` char(1);
246 ALTER TABLE `Ž±Ž±Ž±` MODIFY `Ž·Ž·Ž·` char(6);
248 SELECT * FROM `Ž±Ž±Ž±`;
250 SHOW CREATE TABLE `Ž±Ž±Ž±`;
252 ALTER TABLE `Ž±Ž±Ž±` DROP INDEX `Ž¶Ž¶Ž¶`;
253 ALTER TABLE `Ž±Ž±Ž±` DROP PRIMARY KEY;
254 ALTER TABLE `Ž±Ž±Ž±` DROP INDEX `Ž¸Ž¸Ž¸`;
255 #ALTER TABLE `Ž±Ž±Ž±` DROP FOREIGN KEY `Ž¹Ž¹Ž¹`;
256 ALTER TABLE `Ž±Ž±Ž±` DROP `Ž¶Ž¶`;
257 ALTER TABLE `Ž±Ž±Ž±` DROP `Ž¸Ž¸Ž¸`;
258 ALTER TABLE `Ž±Ž±Ž±` DROP `Ž¹Ž¹Ž¹`;
259 SELECT * FROM `Ž±Ž±Ž±`;
261 SHOW CREATE TABLE `Ž±Ž±Ž±`;
263 ALTER TABLE `¤¢¤¢¤¢` ADD `¤«¤«¤«` char(1) FIRST;
264 ALTER TABLE `¤¢¤¢¤¢` ADD `¤¯¤¯¤¯` char(1) AFTER `¤¤¤`;
265 ALTER TABLE `¤¢¤¢¤¢` ADD `¤±¤±¤±` char(1);
266 ALTER TABLE `¤¢¤¢¤¢` ADD INDEX (`¤«¤«¤«`);
267 ALTER TABLE `¤¢¤¢¤¢` ADD PRIMARY KEY (`¤¤¤`);
268 ALTER TABLE `¤¢¤¢¤¢` ADD UNIQUE (`¤¯¤¯¤¯`);
269 #ALTER TABLE `¤¢¤¢¤¢` ADD FOREIGN KEY (`¤±¤±¤±`) REFERENCES `¤¤¤¤¤¤`(`¤±¤±¤±`);
270 ALTER TABLE `¤¢¤¢¤¢` CHANGE `¤«¤«¤«` `¤«¤«` char(1);
271 ALTER TABLE `¤¢¤¢¤¢` MODIFY `¤¤¤` char(6);
273 SELECT * FROM `¤¢¤¢¤¢`;
275 SHOW CREATE TABLE `¤¢¤¢¤¢`;
277 ALTER TABLE `¤¢¤¢¤¢` DROP INDEX `¤«¤«¤«`;
278 ALTER TABLE `¤¢¤¢¤¢` DROP PRIMARY KEY;
279 ALTER TABLE `¤¢¤¢¤¢` DROP INDEX `¤¯¤¯¤¯`;
280 #ALTER TABLE `¤¢¤¢¤¢` DROP FOREIGN KEY `¤±¤±¤±`;
281 ALTER TABLE `¤¢¤¢¤¢` DROP `¤«¤«`;
282 ALTER TABLE `¤¢¤¢¤¢` DROP `¤¯¤¯¤¯`;
283 ALTER TABLE `¤¢¤¢¤¢` DROP `¤±¤±¤±`;
285 SELECT * FROM `¤¢¤¢¤¢`;
287 SHOW CREATE TABLE `¤¢¤¢¤¢`;
289 ALTER TABLE `�íÝ�íÝ�íÝ` ADD `�°¢�°¢�°¢` char(1) FIRST;
290 ALTER TABLE `�íÝ�íÝ�íÝ` ADD `�°£�°£�°£` char(1) AFTER `�°¡�°¡�°¡`;
291 ALTER TABLE `�íÝ�íÝ�íÝ` ADD `�°´�°´�°´` char(1);
292 ALTER TABLE `�íÝ�íÝ�íÝ` ADD INDEX (`�°¢�°¢�°¢`);
293 ALTER TABLE `�íÝ�íÝ�íÝ` ADD PRIMARY KEY (`�°¡�°¡�°¡`);
294 ALTER TABLE `�íÝ�íÝ�íÝ` ADD UNIQUE (`�°£�°£�°£`);
295 #ALTER TABLE `�íÝ�íÝ�íÝ` ADD FOREIGN KEY (`�°´�°´�°´`) REFERENCES `�íÞ�íÞ�íÞ`(`�°´�°´�°´`);
296 ALTER TABLE `�íÝ�íÝ�íÝ` CHANGE `�°¢�°¢�°¢` `�°¢�°¢` char(1);
297 ALTER TABLE `�íÝ�íÝ�íÝ` MODIFY `�°¡�°¡�°¡` char(6);
299 SELECT * FROM `�íÝ�íÝ�íÝ`;
301 SHOW CREATE TABLE `�íÝ�íÝ�íÝ`;
303 ALTER TABLE `�íÝ�íÝ�íÝ` DROP INDEX `�°¢�°¢�°¢`;
304 ALTER TABLE `�íÝ�íÝ�íÝ` DROP PRIMARY KEY;
305 ALTER TABLE `�íÝ�íÝ�íÝ` DROP INDEX `�°£�°£�°£`;
306 #ALTER TABLE `�íÝ�íÝ�íÝ` DROP FOREIGN KEY `�°´�°´�°´`;
307 ALTER TABLE `�íÝ�íÝ�íÝ` DROP `�°¢�°¢`;
308 ALTER TABLE `�íÝ�íÝ�íÝ` DROP `�°£�°£�°£`;
309 ALTER TABLE `�íÝ�íÝ�íÝ` DROP `�°´�°´�°´`;
311 SELECT * FROM `�íÝ�íÝ�íÝ`;
313 SHOW CREATE TABLE `�íÝ�íÝ�íÝ`;
319 DROP TABLE `�íÝ�íÝ�íÝ`;
320 DROP TABLE `�íÞ�íÞ�íÞ`;