1--source include/have_sjis.inc
2--source include/have_innodb.inc
3--character_set sjis
4SET NAMES sjis;
5SET character_set_database = sjis;
6--disable_warnings
7DROP TABLE IF EXISTS `���`;
8DROP TABLE IF EXISTS `���`;
9DROP TABLE IF EXISTS `���`;
10DROP TABLE IF EXISTS `���`;
11DROP TABLE IF EXISTS `���`;
12DROP TABLE IF EXISTS `������`;
13DROP TABLE IF EXISTS `������`;
14DROP TABLE IF EXISTS `������`;
15DROP TABLE IF EXISTS `������`;
16DROP TABLE IF EXISTS `������`;
17DROP TABLE IF EXISTS `�\�\�\`;
18DROP TABLE IF EXISTS `�\�\�\`;
19DROP TABLE IF EXISTS `�\�\�\`;
20DROP TABLE IF EXISTS `�\�\�\`;
21DROP TABLE IF EXISTS `�\�\�\`;
22--enable_warnings
23
24CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
25CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
26CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
27CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
28CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
29CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
30# Tables should not be created because table names exist
31CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
32CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
33CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
34CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
35CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
36CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
37# Tables should be created
38CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
39CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
40CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\`char(1)) DEFAULT CHARSET = sjis engine=INNODB;
41CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
42CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
43CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
44CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
45CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
46CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
47
48DESC `���`;
49DESC `���`;
50DESC `���`;
51DESC `���`;
52DESC `���`;
53DESC `������`;
54DESC `������`;
55DESC `������`;
56DESC `������`;
57DESC `������`;
58DESC `�\�\�\`;
59DESC `�\�\�\`;
60DESC `�\�\�\`;
61DESC `�\�\�\`;
62DESC `�\�\�\`;
63
64SHOW CREATE TABLE `���`;
65SHOW CREATE TABLE `���`;
66SHOW CREATE TABLE `���`;
67SHOW CREATE TABLE `���`;
68SHOW CREATE TABLE `���`;
69SHOW CREATE TABLE `������`;
70SHOW CREATE TABLE `������`;
71SHOW CREATE TABLE `������`;
72SHOW CREATE TABLE `������`;
73SHOW CREATE TABLE `������`;
74SHOW CREATE TABLE `�\�\�\`;
75SHOW CREATE TABLE `�\�\�\`;
76SHOW CREATE TABLE `�\�\�\`;
77SHOW CREATE TABLE `�\�\�\`;
78SHOW CREATE TABLE `�\�\�\`;
79
80DROP TABLE `���`;
81DROP TABLE `���`;
82DROP TABLE `���`;
83DROP TABLE `���`;
84DROP TABLE `���`;
85DROP TABLE `������`;
86DROP TABLE `������`;
87DROP TABLE `������`;
88DROP TABLE `������`;
89DROP TABLE `������`;
90DROP TABLE `�\�\�\`;
91DROP TABLE `�\�\�\`;
92DROP TABLE `�\�\�\`;
93DROP TABLE `�\�\�\`;
94DROP TABLE `�\�\�\`;
95
96CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
97CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
98CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
99CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
100CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
101CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
102# Tables should not be created because table names exist
103CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
104CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
105CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
106CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
107CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
108CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
109# Tables should be created
110CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
111CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
112CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\`char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
113CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
114CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
115CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
116CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
117CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
118CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
119
120DESC `���`;
121DESC `���`;
122DESC `���`;
123DESC `���`;
124DESC `���`;
125DESC `������`;
126DESC `������`;
127DESC `������`;
128DESC `������`;
129DESC `������`;
130DESC `�\�\�\`;
131DESC `�\�\�\`;
132DESC `�\�\�\`;
133DESC `�\�\�\`;
134DESC `�\�\�\`;
135
136SHOW CREATE TABLE `���`;
137SHOW CREATE TABLE `���`;
138SHOW CREATE TABLE `���`;
139SHOW CREATE TABLE `���`;
140SHOW CREATE TABLE `���`;
141SHOW CREATE TABLE `������`;
142SHOW CREATE TABLE `������`;
143SHOW CREATE TABLE `������`;
144SHOW CREATE TABLE `������`;
145SHOW CREATE TABLE `������`;
146SHOW CREATE TABLE `�\�\�\`;
147SHOW CREATE TABLE `�\�\�\`;
148SHOW CREATE TABLE `�\�\�\`;
149SHOW CREATE TABLE `�\�\�\`;
150SHOW CREATE TABLE `�\�\�\`;
151
152DROP TABLE `���`;
153DROP TABLE `���`;
154DROP TABLE `���`;
155DROP TABLE `���`;
156DROP TABLE `���`;
157DROP TABLE `������`;
158DROP TABLE `������`;
159DROP TABLE `������`;
160DROP TABLE `������`;
161DROP TABLE `������`;
162DROP TABLE `�\�\�\`;
163DROP TABLE `�\�\�\`;
164DROP TABLE `�\�\�\`;
165DROP TABLE `�\�\�\`;
166DROP TABLE `�\�\�\`;
167
168CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
169CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
170CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
171CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
172CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
173CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
174# Tables should not be created because table names exist
175CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
176CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
177CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
178CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
179CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
180CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
181# Tables should be created
182CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
183CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
184CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\`char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
185CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
186CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
187CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
188CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
189CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
190CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
191
192DESC `���`;
193DESC `���`;
194DESC `���`;
195DESC `���`;
196DESC `���`;
197DESC `������`;
198DESC `������`;
199DESC `������`;
200DESC `������`;
201DESC `������`;
202DESC `�\�\�\`;
203DESC `�\�\�\`;
204DESC `�\�\�\`;
205DESC `�\�\�\`;
206DESC `�\�\�\`;
207
208SHOW CREATE TABLE `���`;
209SHOW CREATE TABLE `���`;
210SHOW CREATE TABLE `���`;
211SHOW CREATE TABLE `���`;
212SHOW CREATE TABLE `���`;
213SHOW CREATE TABLE `������`;
214SHOW CREATE TABLE `������`;
215SHOW CREATE TABLE `������`;
216SHOW CREATE TABLE `������`;
217SHOW CREATE TABLE `������`;
218SHOW CREATE TABLE `�\�\�\`;
219SHOW CREATE TABLE `�\�\�\`;
220SHOW CREATE TABLE `�\�\�\`;
221SHOW CREATE TABLE `�\�\�\`;
222SHOW CREATE TABLE `�\�\�\`;
223
224DROP TABLE `���`;
225DROP TABLE `���`;
226DROP TABLE `���`;
227DROP TABLE `���`;
228DROP TABLE `���`;
229DROP TABLE `������`;
230DROP TABLE `������`;
231DROP TABLE `������`;
232DROP TABLE `������`;
233DROP TABLE `������`;
234DROP TABLE `�\�\�\`;
235DROP TABLE `�\�\�\`;
236DROP TABLE `�\�\�\`;
237DROP TABLE `�\�\�\`;
238DROP TABLE `�\�\�\`;
239