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`;
12
SET character_set_database = sjis;
13
CREATE TABLE `�s�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
14
CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
15
CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
16
CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
17
CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
18
CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
19
CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
20
CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
21
CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = heap;
22
CREATE TABLE `�s�P�O` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
23
CREATE TABLE `�s�P�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
24
CREATE TABLE `�s�P�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
25
INSERT INTO `�s�P` VALUES ('�����');
26
INSERT INTO `�s�Q` VALUES ('����������');
27
INSERT INTO `�s�R` VALUES ('�\�\�\�\�\');
28
INSERT INTO `�s�S` VALUES ('�����');
29
INSERT INTO `�s�T` VALUES ('����������');
30
INSERT INTO `�s�U` VALUES ('�\�\�\�\�\');
31
INSERT INTO `�s�V` VALUES ('�����');
32
INSERT INTO `�s�W` VALUES ('����������');
33
INSERT INTO `�s�X` VALUES ('�\�\�\�\�\');
34
INSERT INTO `�s�P�O` VALUES ('�����');
35
INSERT INTO `�s�P�P` VALUES ('����������');
36
INSERT INTO `�s�P�Q` VALUES ('�\�\�\�\�\');
37
SELECT LOCATE('�',`�b�P`) from `�s�P`;
40
SELECT LOCATE('�',`�b�P`) from `�s�P`;
43
SELECT LOCATE('�',`�b�P`) from `�s�P`;
46
SELECT LOCATE('�',`�b�P`) from `�s�P`;
49
SELECT LOCATE('�',`�b�P`) from `�s�P`;
52
SELECT LOCATE('�',`�b�P`) from `�s�P`;
55
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
58
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
61
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
64
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
67
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
70
SELECT LOCATE('��',`�b�P`) from `�s�Q`;
73
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
76
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
79
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
82
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
85
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
88
SELECT LOCATE('�\',`�b�P`) from `�s�R`;
91
SELECT LOCATE('�',`�b�P`) from `�s�S`;
94
SELECT LOCATE('�',`�b�P`) from `�s�S`;
97
SELECT LOCATE('�',`�b�P`) from `�s�S`;
100
SELECT LOCATE('�',`�b�P`) from `�s�S`;
103
SELECT LOCATE('�',`�b�P`) from `�s�S`;
106
SELECT LOCATE('�',`�b�P`) from `�s�S`;
109
SELECT LOCATE('��',`�b�P`) from `�s�T`;
112
SELECT LOCATE('��',`�b�P`) from `�s�T`;
115
SELECT LOCATE('��',`�b�P`) from `�s�T`;
118
SELECT LOCATE('��',`�b�P`) from `�s�T`;
121
SELECT LOCATE('��',`�b�P`) from `�s�T`;
124
SELECT LOCATE('��',`�b�P`) from `�s�T`;
127
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
130
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
133
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
136
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
139
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
142
SELECT LOCATE('�\',`�b�P`) from `�s�U`;
145
SELECT LOCATE('�',`�b�P`) from `�s�V`;
148
SELECT LOCATE('�',`�b�P`) from `�s�V`;
151
SELECT LOCATE('�',`�b�P`) from `�s�V`;
154
SELECT LOCATE('�',`�b�P`) from `�s�V`;
157
SELECT LOCATE('�',`�b�P`) from `�s�V`;
160
SELECT LOCATE('�',`�b�P`) from `�s�V`;
163
SELECT LOCATE('��',`�b�P`) from `�s�W`;
166
SELECT LOCATE('��',`�b�P`) from `�s�W`;
169
SELECT LOCATE('��',`�b�P`) from `�s�W`;
172
SELECT LOCATE('��',`�b�P`) from `�s�W`;
175
SELECT LOCATE('��',`�b�P`) from `�s�W`;
178
SELECT LOCATE('��',`�b�P`) from `�s�W`;
181
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
184
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
187
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
190
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
193
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
196
SELECT LOCATE('�\',`�b�P`) from `�s�X`;
199
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
202
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
205
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
208
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
211
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
214
SELECT LOCATE('�',`�b�P`) from `�s�P�O`;
217
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
220
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
223
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
226
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
229
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
232
SELECT LOCATE('��',`�b�P`) from `�s�P�P`;
235
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
238
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
241
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
244
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
247
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;
250
SELECT LOCATE('�\',`�b�P`) from `�s�P�Q`;