1
--source include/have_sjis.inc
2
--source include/have_innodb.inc
5
SET character_set_database = sjis;
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 `���`;
12
DROP TABLE IF EXISTS `������`;
13
DROP TABLE IF EXISTS `������`;
14
DROP TABLE IF EXISTS `������`;
15
DROP TABLE IF EXISTS `������`;
16
DROP TABLE IF EXISTS `������`;
17
DROP TABLE IF EXISTS `�\�\�\`;
18
DROP TABLE IF EXISTS `�\�\�\`;
19
DROP TABLE IF EXISTS `�\�\�\`;
20
DROP TABLE IF EXISTS `�\�\�\`;
21
DROP TABLE IF EXISTS `�\�\�\`;
24
CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
25
CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = ujis engine=INNODB;
26
CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
27
CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
28
CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
29
CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
30
# Tables should not be created because table names exist
31
CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
32
CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
33
CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
34
CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
35
CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
36
CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
37
# Tables should be created
38
CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
39
CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
40
CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\`char(1)) DEFAULT CHARSET = sjis engine=INNODB;
41
CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
42
CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
43
CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
44
CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
45
CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
46
CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=INNODB;
64
SHOW CREATE TABLE `���`;
65
SHOW CREATE TABLE `���`;
66
SHOW CREATE TABLE `���`;
67
SHOW CREATE TABLE `���`;
68
SHOW CREATE TABLE `���`;
69
SHOW CREATE TABLE `������`;
70
SHOW CREATE TABLE `������`;
71
SHOW CREATE TABLE `������`;
72
SHOW CREATE TABLE `������`;
73
SHOW CREATE TABLE `������`;
74
SHOW CREATE TABLE `�\�\�\`;
75
SHOW CREATE TABLE `�\�\�\`;
76
SHOW CREATE TABLE `�\�\�\`;
77
SHOW CREATE TABLE `�\�\�\`;
78
SHOW CREATE TABLE `�\�\�\`;
96
CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
97
CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
98
CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
99
CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
100
CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
101
CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
102
# Tables should not be created because table names exist
103
CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
104
CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
105
CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
106
CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
107
CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
108
CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
109
# Tables should be created
110
CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
111
CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
112
CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\`char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
113
CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
114
CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
115
CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
116
CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
117
CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
118
CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MyISAM;
136
SHOW CREATE TABLE `���`;
137
SHOW CREATE TABLE `���`;
138
SHOW CREATE TABLE `���`;
139
SHOW CREATE TABLE `���`;
140
SHOW CREATE TABLE `���`;
141
SHOW CREATE TABLE `������`;
142
SHOW CREATE TABLE `������`;
143
SHOW CREATE TABLE `������`;
144
SHOW CREATE TABLE `������`;
145
SHOW CREATE TABLE `������`;
146
SHOW CREATE TABLE `�\�\�\`;
147
SHOW CREATE TABLE `�\�\�\`;
148
SHOW CREATE TABLE `�\�\�\`;
149
SHOW CREATE TABLE `�\�\�\`;
150
SHOW CREATE TABLE `�\�\�\`;
168
CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
169
CREATE TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
170
CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
171
CREATE TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
172
CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
173
CREATE TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
174
# Tables should not be created because table names exist
175
CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
176
CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
177
CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
178
CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
179
CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
180
CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
181
# Tables should be created
182
CREATE TABLE IF NOT EXISTS `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
183
CREATE TABLE IF NOT EXISTS `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
184
CREATE TABLE IF NOT EXISTS `�\�\�\`(`�\�\�\`char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
185
CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
186
CREATE TEMPORARY TABLE `���`(`���` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
187
CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
188
CREATE TEMPORARY TABLE `������`(`������` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
189
CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
190
CREATE TEMPORARY TABLE `�\�\�\`(`�\�\�\` char(1)) DEFAULT CHARSET = sjis engine=MEMORY;
208
SHOW CREATE TABLE `���`;
209
SHOW CREATE TABLE `���`;
210
SHOW CREATE TABLE `���`;
211
SHOW CREATE TABLE `���`;
212
SHOW CREATE TABLE `���`;
213
SHOW CREATE TABLE `������`;
214
SHOW CREATE TABLE `������`;
215
SHOW CREATE TABLE `������`;
216
SHOW CREATE TABLE `������`;
217
SHOW CREATE TABLE `������`;
218
SHOW CREATE TABLE `�\�\�\`;
219
SHOW CREATE TABLE `�\�\�\`;
220
SHOW CREATE TABLE `�\�\�\`;
221
SHOW CREATE TABLE `�\�\�\`;
222
SHOW CREATE TABLE `�\�\�\`;