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`;
11 SET character_set_database = sjis;
12 CREATE TABLE `‚s‚P` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
13 CREATE TABLE `‚s‚Q` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
14 CREATE TABLE `‚s‚R` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = innodb;
15 CREATE TABLE `‚s‚S` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
16 CREATE TABLE `‚s‚T` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
17 CREATE TABLE `‚s‚U` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = myisam;
18 CREATE TABLE `‚s‚V` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
19 CREATE TABLE `‚s‚W` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
20 CREATE TABLE `‚s‚X` (`‚b‚P` char(5), INDEX(`‚b‚P`)) DEFAULT CHARSET = sjis engine = MEMORY;
21 INSERT INTO `‚s‚P` VALUES ('±²³´µ'),('±²³´'),('±²³'),('±²'),('±'),('');
22 INSERT INTO `‚s‚Q` VALUES ('‚ ‚¢‚¤‚¦‚¨'),('‚ ‚¢‚¤‚¦'),('‚ ‚¢‚¤'),('‚ ‚¢'),('‚ '),('');
23 INSERT INTO `‚s‚R` VALUES ('ƒ\�\•\—\�\'),('ƒ\�\•\—\'),('ƒ\�\•\'),('ƒ\�\'),('ƒ\'),('');
24 INSERT INTO `‚s‚S` VALUES ('±²³´µ'),('±²³´'),('±²³'),('±²'),('±'),('');
25 INSERT INTO `‚s‚T` VALUES ('‚ ‚¢‚¤‚¦‚¨'),('‚ ‚¢‚¤‚¦'),('‚ ‚¢‚¤'),('‚ ‚¢'),('‚ '),('');
26 INSERT INTO `‚s‚U` VALUES ('ƒ\�\•\—\�\'),('ƒ\�\•\—\'),('ƒ\�\•\'),('ƒ\�\'),('ƒ\'),('');
27 INSERT INTO `‚s‚V` VALUES ('±²³´µ'),('±²³´'),('±²³'),('±²'),('±'),('');
28 INSERT INTO `‚s‚W` VALUES ('‚ ‚¢‚¤‚¦‚¨'),('‚ ‚¢‚¤‚¦'),('‚ ‚¢‚¤'),('‚ ‚¢'),('‚ '),('');
29 INSERT INTO `‚s‚X` VALUES ('ƒ\�\•\—\�\'),('ƒ\�\•\—\'),('ƒ\�\•\'),('ƒ\�\'),('ƒ\'),('');
30 SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'¡') FROM `‚s‚P`;
31 ‚b‚P RPAD(`‚b‚P`,5,'¡')
38 SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'‚w') FROM `‚s‚Q`;
39 ‚b‚P RPAD(`‚b‚P`,5,'‚w')
46 SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'–\') FROM `‚s‚R`;
47 ‚b‚P RPAD(`‚b‚P`,5,'–\')
54 SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'¡') FROM `‚s‚S`;
55 ‚b‚P RPAD(`‚b‚P`,5,'¡')
62 SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'‚w') FROM `‚s‚T`;
63 ‚b‚P RPAD(`‚b‚P`,5,'‚w')
70 SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'–\' ) FROM `‚s‚U`;
71 ‚b‚P RPAD(`‚b‚P`,5,'–\' )
78 SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'¡') FROM `‚s‚V`;
79 ‚b‚P RPAD(`‚b‚P`,5,'¡')
86 SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'‚w') FROM `‚s‚W`;
87 ‚b‚P RPAD(`‚b‚P`,5,'‚w')
94 SELECT `‚b‚P`, RPAD(`‚b‚P`,5,'–\' ) FROM `‚s‚X`;
95 ‚b‚P RPAD(`‚b‚P`,5,'–\' )