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` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
16
CREATE TABLE `�s�Q` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
17
CREATE TABLE `�s�R` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb;
18
CREATE TABLE `�s�S` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
19
CREATE TABLE `�s�T` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
20
CREATE TABLE `�s�U` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam;
21
CREATE TABLE `�s�V` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
22
CREATE TABLE `�s�W` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
23
CREATE TABLE `�s�X` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY;
24
CREATE TABLE `�s�P�O` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
25
CREATE TABLE `�s�P�P` (`�b�P` char(5), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = bdb;
26
CREATE TABLE `�s�P�Q` (`�b�P` char(5), 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 ('�\�\�\�\�\'),('�\�\�\�\'),('�\�\�\'),('�\�\'),('�\'),('');
39
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�P`;
47
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�P`;
55
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�P`;
63
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�P`;
71
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�P`;
79
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�P`;
87
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�Q`;
95
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�Q`;
103
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�Q`;
111
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�Q`;
119
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�Q`;
127
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�Q`;
134
���������� ����������
135
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�R`;
143
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�R`;
151
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�R`;
159
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�R`;
167
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�R`;
175
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�R`;
182
�\�\�\�\�\ �\�\�\�\�\
183
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�S`;
191
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�S`;
199
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�S`;
207
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�S`;
215
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�S`;
223
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�S`;
231
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�T`;
239
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�T`;
247
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�T`;
255
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�T`;
263
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�T`;
271
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�T`;
278
���������� ����������
279
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�U`;
287
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�U`;
295
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�U`;
303
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�U`;
311
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�U`;
319
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�U`;
326
�\�\�\�\�\ �\�\�\�\�\
327
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�V`;
335
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�V`;
343
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�V`;
351
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�V`;
359
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�V`;
367
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�V`;
375
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�W`;
383
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�W`;
391
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�W`;
399
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�W`;
407
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�W`;
415
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�W`;
417
���������� ����������
423
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�X`;
431
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�X`;
439
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�X`;
447
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�X`;
455
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�X`;
463
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�X`;
465
�\�\�\�\�\ �\�\�\�\�\
471
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�P�O`;
479
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�P�O`;
487
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�P�O`;
495
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�P�O`;
503
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�P�O`;
511
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�P�O`;
519
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�P�P`;
527
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�P�P`;
535
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�P�P`;
543
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�P�P`;
551
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�P�P`;
559
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�P�P`;
561
���������� ����������
567
SELECT `�b�P`, LEFT(`�b�P`,0) FROM `�s�P�Q`;
575
SELECT `�b�P`, LEFT(`�b�P`,1) FROM `�s�P�Q`;
583
SELECT `�b�P`, LEFT(`�b�P`,2) FROM `�s�P�Q`;
591
SELECT `�b�P`, LEFT(`�b�P`,3) FROM `�s�P�Q`;
599
SELECT `�b�P`, LEFT(`�b�P`,4) FROM `�s�P�Q`;
607
SELECT `�b�P`, LEFT(`�b�P`,5) FROM `�s�P�Q`;
609
�\�\�\�\�\ �\�\�\�\�\