1
drop table if exists `�s�P`;
2
drop table if exists `�s�Q`;
3
drop table if exists `�s�R`;
4
drop table if exists `�s�S`;
5
drop table if exists `�s�T`;
6
drop table if exists `�s�U`;
7
drop table if exists `�s�V`;
8
drop table if exists `�s�W`;
9
drop table if exists `�s�X`;
10
drop table if exists `�s�P�O`;
11
drop table if exists `�s�P�P`;
12
drop table if exists `�s�P�Q`;
14
SET character_set_database = sjis;
15
CREATE TABLE `�s�P` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
16
CREATE TABLE `�s�Q` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
17
CREATE TABLE `�s�R` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
18
CREATE TABLE `�s�S` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
19
CREATE TABLE `�s�T` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
20
CREATE TABLE `�s�U` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
21
CREATE TABLE `�s�V` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
22
CREATE TABLE `�s�W` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
23
CREATE TABLE `�s�X` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
24
CREATE TABLE `�s�P�O` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
25
CREATE TABLE `�s�P�P` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
26
CREATE TABLE `�s�P�Q` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
27
INSERT INTO `�s�P` VALUES ('�'),('�'),('�');
28
INSERT INTO `�s�Q` VALUES ('��'),('��'),('��');
29
INSERT INTO `�s�R` VALUES ('�\'),('�\'),('�\');
30
INSERT INTO `�s�S` VALUES ('�'),('�'),('�');
31
INSERT INTO `�s�T` VALUES ('��'),('��'),('��');
32
INSERT INTO `�s�U` VALUES ('�\'),('�\'),('�\');
33
INSERT INTO `�s�V` VALUES ('�'),('�'),('�');
34
INSERT INTO `�s�W` VALUES ('��'),('��'),('��');
35
INSERT INTO `�s�X` VALUES ('�\'),('�\'),('�\');
36
INSERT INTO `�s�P�O` VALUES ('�'),('�'),('�');
37
INSERT INTO `�s�P�P` VALUES ('��'),('��'),('��');
38
INSERT INTO `�s�P�Q` VALUES ('�\'),('�\'),('�\');
84
SELECT * FROM `�s�P�O`;
89
SELECT * FROM `�s�P�P`;
94
SELECT * FROM `�s�P�Q`;
99
SHOW CREATE TABLE `�s�P`;
101
�s�P CREATE TABLE `�s�P` (
102
`�b�P` enum('�','�','�') default NULL,
104
) ENGINE=InnoDB DEFAULT CHARSET=sjis
105
SHOW CREATE TABLE `�s�Q`;
107
�s�Q CREATE TABLE `�s�Q` (
108
`�b�P` enum('��','��','��') default NULL,
110
) ENGINE=InnoDB DEFAULT CHARSET=sjis
111
SHOW CREATE TABLE `�s�R`;
113
�s�R CREATE TABLE `�s�R` (
114
`�b�P` enum('�\','�\','�\') default NULL,
116
) ENGINE=InnoDB DEFAULT CHARSET=sjis
117
SHOW CREATE TABLE `�s�S`;
119
�s�S CREATE TABLE `�s�S` (
120
`�b�P` enum('�','�','�') default NULL,
122
) ENGINE=MyISAM DEFAULT CHARSET=sjis
123
SHOW CREATE TABLE `�s�T`;
125
�s�T CREATE TABLE `�s�T` (
126
`�b�P` enum('��','��','��') default NULL,
128
) ENGINE=MyISAM DEFAULT CHARSET=sjis
129
SHOW CREATE TABLE `�s�U`;
131
�s�U CREATE TABLE `�s�U` (
132
`�b�P` enum('�\','�\','�\') default NULL,
134
) ENGINE=MyISAM DEFAULT CHARSET=sjis
135
SHOW CREATE TABLE `�s�V`;
137
�s�V CREATE TABLE `�s�V` (
138
`�b�P` enum('�','�','�') default NULL,
140
) ENGINE=HEAP DEFAULT CHARSET=sjis
141
SHOW CREATE TABLE `�s�W`;
143
�s�W CREATE TABLE `�s�W` (
144
`�b�P` enum('��','��','��') default NULL,
146
) ENGINE=HEAP DEFAULT CHARSET=sjis
147
SHOW CREATE TABLE `�s�X`;
149
�s�X CREATE TABLE `�s�X` (
150
`�b�P` enum('�\','�\','�\') default NULL,
152
) ENGINE=HEAP DEFAULT CHARSET=sjis
153
SHOW CREATE TABLE `�s�P�O`;
155
�s�P�O CREATE TABLE `�s�P�O` (
156
`�b�P` enum('�','�','�') default NULL,
158
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
159
SHOW CREATE TABLE `�s�P�P`;
161
�s�P�P CREATE TABLE `�s�P�P` (
162
`�b�P` enum('��','��','��') default NULL,
164
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
165
SHOW CREATE TABLE `�s�P�Q`;
167
�s�P�Q CREATE TABLE `�s�P�Q` (
168
`�b�P` enum('�\','�\','�\') default NULL,
170
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
172
Field Type Null Key Default Extra
173
�b�P enum('�','�','�') YES MUL NULL
175
Field Type Null Key Default Extra
176
�b�P enum('��','��','��') YES MUL NULL
178
Field Type Null Key Default Extra
179
�b�P enum('�\','�\','�\') YES MUL NULL
181
Field Type Null Key Default Extra
182
�b�P enum('�','�','�') YES MUL NULL
184
Field Type Null Key Default Extra
185
�b�P enum('��','��','��') YES MUL NULL
187
Field Type Null Key Default Extra
188
�b�P enum('�\','�\','�\') YES MUL NULL
190
Field Type Null Key Default Extra
191
�b�P enum('�','�','�') YES MUL NULL
193
Field Type Null Key Default Extra
194
�b�P enum('��','��','��') YES MUL NULL
196
Field Type Null Key Default Extra
197
�b�P enum('�\','�\','�\') YES MUL NULL
199
Field Type Null Key Default Extra
200
�b�P enum('�','�','�') YES MUL NULL
202
Field Type Null Key Default Extra
203
�b�P enum('��','��','��') YES MUL NULL
205
Field Type Null Key Default Extra
206
�b�P enum('�\','�\','�\') YES MUL NULL
207
ALTER TABLE `�s�P` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
208
ALTER TABLE `�s�Q` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
209
ALTER TABLE `�s�R` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
210
ALTER TABLE `�s�S` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
211
ALTER TABLE `�s�T` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
212
ALTER TABLE `�s�U` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
213
ALTER TABLE `�s�V` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
214
ALTER TABLE `�s�W` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
215
ALTER TABLE `�s�X` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
216
ALTER TABLE `�s�P�O` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
217
ALTER TABLE `�s�P�P` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
218
ALTER TABLE `�s�P�Q` ADD `�b�Q` CHAR(1) NOT NULL FIRST;
219
SHOW CREATE TABLE `�s�P`;
221
�s�P CREATE TABLE `�s�P` (
222
`�b�Q` char(1) NOT NULL default '',
223
`�b�P` enum('�','�','�') default NULL,
225
) ENGINE=InnoDB DEFAULT CHARSET=sjis
226
SHOW CREATE TABLE `�s�Q`;
228
�s�Q CREATE TABLE `�s�Q` (
229
`�b�Q` char(1) NOT NULL default '',
230
`�b�P` enum('��','��','��') default NULL,
232
) ENGINE=InnoDB DEFAULT CHARSET=sjis
233
SHOW CREATE TABLE `�s�R`;
235
�s�R CREATE TABLE `�s�R` (
236
`�b�Q` char(1) NOT NULL default '',
237
`�b�P` enum('�\','�\','�\') default NULL,
239
) ENGINE=InnoDB DEFAULT CHARSET=sjis
240
SHOW CREATE TABLE `�s�S`;
242
�s�S CREATE TABLE `�s�S` (
243
`�b�Q` char(1) NOT NULL default '',
244
`�b�P` enum('�','�','�') default NULL,
246
) ENGINE=MyISAM DEFAULT CHARSET=sjis
247
SHOW CREATE TABLE `�s�T`;
249
�s�T CREATE TABLE `�s�T` (
250
`�b�Q` char(1) NOT NULL default '',
251
`�b�P` enum('��','��','��') default NULL,
253
) ENGINE=MyISAM DEFAULT CHARSET=sjis
254
SHOW CREATE TABLE `�s�U`;
256
�s�U CREATE TABLE `�s�U` (
257
`�b�Q` char(1) NOT NULL default '',
258
`�b�P` enum('�\','�\','�\') default NULL,
260
) ENGINE=MyISAM DEFAULT CHARSET=sjis
261
SHOW CREATE TABLE `�s�V`;
263
�s�V CREATE TABLE `�s�V` (
264
`�b�Q` char(1) NOT NULL default '',
265
`�b�P` enum('�','�','�') default NULL,
267
) ENGINE=HEAP DEFAULT CHARSET=sjis
268
SHOW CREATE TABLE `�s�W`;
270
�s�W CREATE TABLE `�s�W` (
271
`�b�Q` char(1) NOT NULL default '',
272
`�b�P` enum('��','��','��') default NULL,
274
) ENGINE=HEAP DEFAULT CHARSET=sjis
275
SHOW CREATE TABLE `�s�X`;
277
�s�X CREATE TABLE `�s�X` (
278
`�b�Q` char(1) NOT NULL default '',
279
`�b�P` enum('�\','�\','�\') default NULL,
281
) ENGINE=HEAP DEFAULT CHARSET=sjis
282
SHOW CREATE TABLE `�s�P�O`;
284
�s�P�O CREATE TABLE `�s�P�O` (
285
`�b�Q` char(1) NOT NULL default '',
286
`�b�P` enum('�','�','�') default NULL,
288
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
289
SHOW CREATE TABLE `�s�P�P`;
291
�s�P�P CREATE TABLE `�s�P�P` (
292
`�b�Q` char(1) NOT NULL default '',
293
`�b�P` enum('��','��','��') default NULL,
295
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
296
SHOW CREATE TABLE `�s�P�Q`;
298
�s�P�Q CREATE TABLE `�s�P�Q` (
299
`�b�Q` char(1) NOT NULL default '',
300
`�b�P` enum('�\','�\','�\') default NULL,
302
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
304
Field Type Null Key Default Extra
306
�b�P enum('�','�','�') YES MUL NULL
308
Field Type Null Key Default Extra
310
�b�P enum('��','��','��') YES MUL NULL
312
Field Type Null Key Default Extra
314
�b�P enum('�\','�\','�\') YES MUL NULL
316
Field Type Null Key Default Extra
318
�b�P enum('�','�','�') YES MUL NULL
320
Field Type Null Key Default Extra
322
�b�P enum('��','��','��') YES MUL NULL
324
Field Type Null Key Default Extra
326
�b�P enum('�\','�\','�\') YES MUL NULL
328
Field Type Null Key Default Extra
330
�b�P enum('�','�','�') YES MUL NULL
332
Field Type Null Key Default Extra
334
�b�P enum('��','��','��') YES MUL NULL
336
Field Type Null Key Default Extra
338
�b�P enum('�\','�\','�\') YES MUL NULL
340
Field Type Null Key Default Extra
342
�b�P enum('�','�','�') YES MUL NULL
344
Field Type Null Key Default Extra
346
�b�P enum('��','��','��') YES MUL NULL
348
Field Type Null Key Default Extra
350
�b�P enum('�\','�\','�\') YES MUL NULL