~drizzle-trunk/drizzle/development : contents of mysql-test/suite/jp/r/jp_enum

~drizzle-trunk/drizzle/development : (revision 33)

drop table if exists `sP`;
drop table if exists `sQ`;
drop table if exists `sR`;
drop table if exists `sS`;
drop table if exists `sT`;
drop table if exists `sU`;
drop table if exists `sV`;
drop table if exists `sW`;
drop table if exists `sX`;
drop table if exists `sPO`;
drop table if exists `sPP`;
drop table if exists `sPQ`;
SET NAMES sjis;
SET character_set_database = sjis;
CREATE TABLE `sP` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sQ` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sR` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sS` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sT` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sU` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sV` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sW` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sX` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
CREATE TABLE `sPO` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPP` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPQ` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
INSERT INTO `sP` VALUES ('±'),('²'),('³');
INSERT INTO `sQ` VALUES (' '),('¢'),('€');
INSERT INTO `sR` VALUES ('\'),('\'),('\');
INSERT INTO `sS` VALUES ('±'),('²'),('³');
INSERT INTO `sT` VALUES (' '),('¢'),('€');
INSERT INTO `sU` VALUES ('\'),('\'),('\');
INSERT INTO `sV` VALUES ('±'),('²'),('³');
INSERT INTO `sW` VALUES (' '),('¢'),('€');
INSERT INTO `sX` VALUES ('\'),('\'),('\');
INSERT INTO `sPO` VALUES ('±'),('²'),('³');
INSERT INTO `sPP` VALUES (' '),('¢'),('€');
INSERT INTO `sPQ` VALUES ('\'),('\'),('\');
SELECT * FROM `sP`;
bP
±
²
³
SELECT * FROM `sQ`;
bP
 
¢
€
SELECT * FROM `sR`;
bP
\
\
\
SELECT * FROM `sS`;
bP
±
²
³
SELECT * FROM `sT`;
bP
 
¢
€
SELECT * FROM `sU`;
bP
\
\
\
SELECT * FROM `sV`;
bP
±
²
³
SELECT * FROM `sW`;
bP
 
¢
€
SELECT * FROM `sX`;
bP
\
\
\
SELECT * FROM `sPO`;
bP
±
²
³
SELECT * FROM `sPP`;
bP
 
¢
€
SELECT * FROM `sPQ`;
bP
\
\
\
SHOW CREATE TABLE `sP`;
Table	Create Table
sP	CREATE TABLE `sP` (
  `bP` enum('±','²','³') default NULL,
  KEY `bP` (`bP`)
) ENGINE=InnoDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sQ`;
Table	Create Table
sQ	CREATE TABLE `sQ` (
  `bP` enum(' ','¢','€') default NULL,
  KEY `bP` (`bP`)
) ENGINE=InnoDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sR`;
Table	Create Table
sR	CREATE TABLE `sR` (
  `bP` enum('\','\','\') default NULL,
  KEY `bP` (`bP`)
) ENGINE=InnoDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sS`;
Table	Create Table
sS	CREATE TABLE `sS` (
  `bP` enum('±','²','³') default NULL,
  KEY `bP` (`bP`)
) ENGINE=MyISAM DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sT`;
Table	Create Table
sT	CREATE TABLE `sT` (
  `bP` enum(' ','¢','€') default NULL,
  KEY `bP` (`bP`)
) ENGINE=MyISAM DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sU`;
Table	Create Table
sU	CREATE TABLE `sU` (
  `bP` enum('\','\','\') default NULL,
  KEY `bP` (`bP`)
) ENGINE=MyISAM DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sV`;
Table	Create Table
sV	CREATE TABLE `sV` (
  `bP` enum('±','²','³') default NULL,
  KEY `bP` (`bP`)
) ENGINE=HEAP DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sW`;
Table	Create Table
sW	CREATE TABLE `sW` (
  `bP` enum(' ','¢','€') default NULL,
  KEY `bP` (`bP`)
) ENGINE=HEAP DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sX`;
Table	Create Table
sX	CREATE TABLE `sX` (
  `bP` enum('\','\','\') default NULL,
  KEY `bP` (`bP`)
) ENGINE=HEAP DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sPO`;
Table	Create Table
sPO	CREATE TABLE `sPO` (
  `bP` enum('±','²','³') default NULL,
  KEY `bP` (`bP`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sPP`;
Table	Create Table
sPP	CREATE TABLE `sPP` (
  `bP` enum(' ','¢','€') default NULL,
  KEY `bP` (`bP`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sPQ`;
Table	Create Table
sPQ	CREATE TABLE `sPQ` (
  `bP` enum('\','\','\') default NULL,
  KEY `bP` (`bP`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
DESC `sP`;
Field	Type	Null	Key	Default	Extra
bP	enum('±','²','³')	YES	MUL	NULL	
DESC `sQ`;
Field	Type	Null	Key	Default	Extra
bP	enum(' ','¢','€')	YES	MUL	NULL	
DESC `sR`;
Field	Type	Null	Key	Default	Extra
bP	enum('\','\','\')	YES	MUL	NULL	
DESC `sS`;
Field	Type	Null	Key	Default	Extra
bP	enum('±','²','³')	YES	MUL	NULL	
DESC `sT`;
Field	Type	Null	Key	Default	Extra
bP	enum(' ','¢','€')	YES	MUL	NULL	
DESC `sU`;
Field	Type	Null	Key	Default	Extra
bP	enum('\','\','\')	YES	MUL	NULL	
DESC `sV`;
Field	Type	Null	Key	Default	Extra
bP	enum('±','²','³')	YES	MUL	NULL	
DESC `sW`;
Field	Type	Null	Key	Default	Extra
bP	enum(' ','¢','€')	YES	MUL	NULL	
DESC `sX`;
Field	Type	Null	Key	Default	Extra
bP	enum('\','\','\')	YES	MUL	NULL	
DESC `sPO`;
Field	Type	Null	Key	Default	Extra
bP	enum('±','²','³')	YES	MUL	NULL	
DESC `sPP`;
Field	Type	Null	Key	Default	Extra
bP	enum(' ','¢','€')	YES	MUL	NULL	
DESC `sPQ`;
Field	Type	Null	Key	Default	Extra
bP	enum('\','\','\')	YES	MUL	NULL	
ALTER TABLE `sP` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sQ` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sR` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sS` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sT` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sU` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sV` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sW` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sX` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sPO` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sPP` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sPQ` ADD `bQ` CHAR(1) NOT NULL FIRST;
SHOW CREATE TABLE `sP`;
Table	Create Table
sP	CREATE TABLE `sP` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum('±','²','³') default NULL,
  KEY `bP` (`bP`)
) ENGINE=InnoDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sQ`;
Table	Create Table
sQ	CREATE TABLE `sQ` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum(' ','¢','€') default NULL,
  KEY `bP` (`bP`)
) ENGINE=InnoDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sR`;
Table	Create Table
sR	CREATE TABLE `sR` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum('\','\','\') default NULL,
  KEY `bP` (`bP`)
) ENGINE=InnoDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sS`;
Table	Create Table
sS	CREATE TABLE `sS` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum('±','²','³') default NULL,
  KEY `bP` (`bP`)
) ENGINE=MyISAM DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sT`;
Table	Create Table
sT	CREATE TABLE `sT` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum(' ','¢','€') default NULL,
  KEY `bP` (`bP`)
) ENGINE=MyISAM DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sU`;
Table	Create Table
sU	CREATE TABLE `sU` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum('\','\','\') default NULL,
  KEY `bP` (`bP`)
) ENGINE=MyISAM DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sV`;
Table	Create Table
sV	CREATE TABLE `sV` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum('±','²','³') default NULL,
  KEY `bP` (`bP`)
) ENGINE=HEAP DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sW`;
Table	Create Table
sW	CREATE TABLE `sW` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum(' ','¢','€') default NULL,
  KEY `bP` (`bP`)
) ENGINE=HEAP DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sX`;
Table	Create Table
sX	CREATE TABLE `sX` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum('\','\','\') default NULL,
  KEY `bP` (`bP`)
) ENGINE=HEAP DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sPO`;
Table	Create Table
sPO	CREATE TABLE `sPO` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum('±','²','³') default NULL,
  KEY `bP` (`bP`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sPP`;
Table	Create Table
sPP	CREATE TABLE `sPP` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum(' ','¢','€') default NULL,
  KEY `bP` (`bP`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
SHOW CREATE TABLE `sPQ`;
Table	Create Table
sPQ	CREATE TABLE `sPQ` (
  `bQ` char(1) NOT NULL default '',
  `bP` enum('\','\','\') default NULL,
  KEY `bP` (`bP`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
DESC `sP`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum('±','²','³')	YES	MUL	NULL	
DESC `sQ`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum(' ','¢','€')	YES	MUL	NULL	
DESC `sR`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum('\','\','\')	YES	MUL	NULL	
DESC `sS`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum('±','²','³')	YES	MUL	NULL	
DESC `sT`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum(' ','¢','€')	YES	MUL	NULL	
DESC `sU`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum('\','\','\')	YES	MUL	NULL	
DESC `sV`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum('±','²','³')	YES	MUL	NULL	
DESC `sW`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum(' ','¢','€')	YES	MUL	NULL	
DESC `sX`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum('\','\','\')	YES	MUL	NULL	
DESC `sPO`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum('±','²','³')	YES	MUL	NULL	
DESC `sPP`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum(' ','¢','€')	YES	MUL	NULL	
DESC `sPQ`;
Field	Type	Null	Key	Default	Extra
bQ	char(1)				
bP	enum('\','\','\')	YES	MUL	NULL	
DROP TABLE `sP`;
DROP TABLE `sQ`;
DROP TABLE `sR`;
DROP TABLE `sS`;
DROP TABLE `sT`;
DROP TABLE `sU`;
DROP TABLE `sV`;
DROP TABLE `sW`;
DROP TABLE `sX`;
DROP TABLE `sPO`;
DROP TABLE `sPP`;
DROP TABLE `sPQ`;

1 by brian clean slate	1	drop table if exists `sP`;
	2	drop table if exists `sQ`;
	3	drop table if exists `sR`;
	4	drop table if exists `sS`;
	5	drop table if exists `sT`;
	6	drop table if exists `sU`;
	7	drop table if exists `sV`;
	8	drop table if exists `sW`;
	9	drop table if exists `sX`;
	10	drop table if exists `sPO`;
	11	drop table if exists `sPP`;
	12	drop table if exists `sPQ`;
	13	SET NAMES sjis;
	14	SET character_set_database = sjis;
	15	CREATE TABLE `sP` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	16	CREATE TABLE `sQ` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	17	CREATE TABLE `sR` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	18	CREATE TABLE `sS` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	19	CREATE TABLE `sT` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	20	CREATE TABLE `sU` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	21	CREATE TABLE `sV` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	22	CREATE TABLE `sW` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	23	CREATE TABLE `sX` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	24	CREATE TABLE `sPO` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	25	CREATE TABLE `sPP` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	26	CREATE TABLE `sPQ` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	27	INSERT INTO `sP` VALUES ('±'),('²'),('³');
	28	INSERT INTO `sQ` VALUES (' '),('¢'),('€');
	29	INSERT INTO `sR` VALUES ('\'),('\'),('\');
	30	INSERT INTO `sS` VALUES ('±'),('²'),('³');
	31	INSERT INTO `sT` VALUES (' '),('¢'),('€');
	32	INSERT INTO `sU` VALUES ('\'),('\'),('\');
	33	INSERT INTO `sV` VALUES ('±'),('²'),('³');
	34	INSERT INTO `sW` VALUES (' '),('¢'),('€');
	35	INSERT INTO `sX` VALUES ('\'),('\'),('\');
	36	INSERT INTO `sPO` VALUES ('±'),('²'),('³');
	37	INSERT INTO `sPP` VALUES (' '),('¢'),('€');
	38	INSERT INTO `sPQ` VALUES ('\'),('\'),('\');
	39	SELECT * FROM `sP`;
	40	bP
	41	±
	42	²
	43	³
	44	SELECT * FROM `sQ`;
	45	bP
	46
	47	¢
	48	€
	49	SELECT * FROM `sR`;
	50	bP
	51	\
	52	\
	53	\
	54	SELECT * FROM `sS`;
	55	bP
	56	±
	57	²
	58	³
	59	SELECT * FROM `sT`;
	60	bP
	61
	62	¢
	63	€
	64	SELECT * FROM `sU`;
65	bP
66	\
67	\
68	\
69	SELECT * FROM `sV`;
70	bP
71	±
72	²
73	³
74	SELECT * FROM `sW`;
75	bP
76
77	¢
78	€
79	SELECT * FROM `sX`;
80	bP
81	\
82	\
83	\
84	SELECT * FROM `sPO`;
85	bP
86	±
87	²
88	³
89	SELECT * FROM `sPP`;
90	bP
91
92	¢
93	€
94	SELECT * FROM `sPQ`;
95	bP
96	\
97	\
98	\
99	SHOW CREATE TABLE `sP`;
100	Table Create Table
101	sP CREATE TABLE `sP` (
102	`bP` enum('±','²','³') default NULL,
103	KEY `bP` (`bP`)
104	) ENGINE=InnoDB DEFAULT CHARSET=sjis
105	SHOW CREATE TABLE `sQ`;
106	Table Create Table
107	sQ CREATE TABLE `sQ` (
108	`bP` enum(' ','¢','€') default NULL,
109	KEY `bP` (`bP`)
110	) ENGINE=InnoDB DEFAULT CHARSET=sjis
111	SHOW CREATE TABLE `sR`;
112	Table Create Table
113	sR CREATE TABLE `sR` (
114	`bP` enum('\','\','\') default NULL,
115	KEY `bP` (`bP`)
116	) ENGINE=InnoDB DEFAULT CHARSET=sjis
117	SHOW CREATE TABLE `sS`;
118	Table Create Table
119	sS CREATE TABLE `sS` (
120	`bP` enum('±','²','³') default NULL,
121	KEY `bP` (`bP`)
122	) ENGINE=MyISAM DEFAULT CHARSET=sjis
123	SHOW CREATE TABLE `sT`;
124	Table Create Table
125	sT CREATE TABLE `sT` (
126	`bP` enum(' ','¢','€') default NULL,
127	KEY `bP` (`bP`)
128	) ENGINE=MyISAM DEFAULT CHARSET=sjis
129	SHOW CREATE TABLE `sU`;
130	Table Create Table
131	sU CREATE TABLE `sU` (
132	`bP` enum('\','\','\') default NULL,
133	KEY `bP` (`bP`)
134	) ENGINE=MyISAM DEFAULT CHARSET=sjis
135	SHOW CREATE TABLE `sV`;
136	Table Create Table
137	sV CREATE TABLE `sV` (
138	`bP` enum('±','²','³') default NULL,
139	KEY `bP` (`bP`)
140	) ENGINE=HEAP DEFAULT CHARSET=sjis
141	SHOW CREATE TABLE `sW`;
142	Table Create Table
143	sW CREATE TABLE `sW` (
144	`bP` enum(' ','¢','€') default NULL,
145	KEY `bP` (`bP`)
146	) ENGINE=HEAP DEFAULT CHARSET=sjis
147	SHOW CREATE TABLE `sX`;
148	Table Create Table
149	sX CREATE TABLE `sX` (
150	`bP` enum('\','\','\') default NULL,
151	KEY `bP` (`bP`)
152	) ENGINE=HEAP DEFAULT CHARSET=sjis
153	SHOW CREATE TABLE `sPO`;
154	Table Create Table
155	sPO CREATE TABLE `sPO` (
156	`bP` enum('±','²','³') default NULL,
157	KEY `bP` (`bP`)
158	) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
159	SHOW CREATE TABLE `sPP`;
160	Table Create Table
161	sPP CREATE TABLE `sPP` (
162	`bP` enum(' ','¢','€') default NULL,
163	KEY `bP` (`bP`)
164	) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
165	SHOW CREATE TABLE `sPQ`;
166	Table Create Table
167	sPQ CREATE TABLE `sPQ` (
168	`bP` enum('\','\','\') default NULL,
169	KEY `bP` (`bP`)
170	) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
171	DESC `sP`;
172	Field Type Null Key Default Extra
173	bP enum('±','²','³') YES MUL NULL
174	DESC `sQ`;
175	Field Type Null Key Default Extra
176	bP enum(' ','¢','€') YES MUL NULL
177	DESC `sR`;
178	Field Type Null Key Default Extra
179	bP enum('\','\','\') YES MUL NULL
180	DESC `sS`;
181	Field Type Null Key Default Extra
182	bP enum('±','²','³') YES MUL NULL
183	DESC `sT`;
184	Field Type Null Key Default Extra
185	bP enum(' ','¢','€') YES MUL NULL
186	DESC `sU`;
187	Field Type Null Key Default Extra
188	bP enum('\','\','\') YES MUL NULL
189	DESC `sV`;
190	Field Type Null Key Default Extra
191	bP enum('±','²','³') YES MUL NULL
192	DESC `sW`;
193	Field Type Null Key Default Extra
194	bP enum(' ','¢','€') YES MUL NULL
195	DESC `sX`;
196	Field Type Null Key Default Extra
197	bP enum('\','\','\') YES MUL NULL
198	DESC `sPO`;
199	Field Type Null Key Default Extra
200	bP enum('±','²','³') YES MUL NULL
201	DESC `sPP`;
202	Field Type Null Key Default Extra
203	bP enum(' ','¢','€') YES MUL NULL
204	DESC `sPQ`;
205	Field Type Null Key Default Extra
206	bP enum('\','\','\') YES MUL NULL
207	ALTER TABLE `sP` ADD `bQ` CHAR(1) NOT NULL FIRST;
208	ALTER TABLE `sQ` ADD `bQ` CHAR(1) NOT NULL FIRST;
209	ALTER TABLE `sR` ADD `bQ` CHAR(1) NOT NULL FIRST;
210	ALTER TABLE `sS` ADD `bQ` CHAR(1) NOT NULL FIRST;
211	ALTER TABLE `sT` ADD `bQ` CHAR(1) NOT NULL FIRST;
212	ALTER TABLE `sU` ADD `bQ` CHAR(1) NOT NULL FIRST;
213	ALTER TABLE `sV` ADD `bQ` CHAR(1) NOT NULL FIRST;
214	ALTER TABLE `sW` ADD `bQ` CHAR(1) NOT NULL FIRST;
215	ALTER TABLE `sX` ADD `bQ` CHAR(1) NOT NULL FIRST;
216	ALTER TABLE `sPO` ADD `bQ` CHAR(1) NOT NULL FIRST;
217	ALTER TABLE `sPP` ADD `bQ` CHAR(1) NOT NULL FIRST;
218	ALTER TABLE `sPQ` ADD `bQ` CHAR(1) NOT NULL FIRST;
219	SHOW CREATE TABLE `sP`;
220	Table Create Table
221	sP CREATE TABLE `sP` (
222	`bQ` char(1) NOT NULL default '',
223	`bP` enum('±','²','³') default NULL,
224	KEY `bP` (`bP`)
225	) ENGINE=InnoDB DEFAULT CHARSET=sjis
226	SHOW CREATE TABLE `sQ`;
227	Table Create Table
228	sQ CREATE TABLE `sQ` (
229	`bQ` char(1) NOT NULL default '',
230	`bP` enum(' ','¢','€') default NULL,
231	KEY `bP` (`bP`)
232	) ENGINE=InnoDB DEFAULT CHARSET=sjis
233	SHOW CREATE TABLE `sR`;
234	Table Create Table
235	sR CREATE TABLE `sR` (
236	`bQ` char(1) NOT NULL default '',
237	`bP` enum('\','\','\') default NULL,
238	KEY `bP` (`bP`)
239	) ENGINE=InnoDB DEFAULT CHARSET=sjis
240	SHOW CREATE TABLE `sS`;
241	Table Create Table
242	sS CREATE TABLE `sS` (
243	`bQ` char(1) NOT NULL default '',
244	`bP` enum('±','²','³') default NULL,
245	KEY `bP` (`bP`)
246	) ENGINE=MyISAM DEFAULT CHARSET=sjis
247	SHOW CREATE TABLE `sT`;
248	Table Create Table
249	sT CREATE TABLE `sT` (
250	`bQ` char(1) NOT NULL default '',
251	`bP` enum(' ','¢','€') default NULL,
252	KEY `bP` (`bP`)
253	) ENGINE=MyISAM DEFAULT CHARSET=sjis
254	SHOW CREATE TABLE `sU`;
255	Table Create Table
256	sU CREATE TABLE `sU` (
257	`bQ` char(1) NOT NULL default '',
258	`bP` enum('\','\','\') default NULL,
259	KEY `bP` (`bP`)
260	) ENGINE=MyISAM DEFAULT CHARSET=sjis
261	SHOW CREATE TABLE `sV`;
262	Table Create Table
263	sV CREATE TABLE `sV` (
264	`bQ` char(1) NOT NULL default '',
265	`bP` enum('±','²','³') default NULL,
266	KEY `bP` (`bP`)
267	) ENGINE=HEAP DEFAULT CHARSET=sjis
268	SHOW CREATE TABLE `sW`;
269	Table Create Table
270	sW CREATE TABLE `sW` (
271	`bQ` char(1) NOT NULL default '',
272	`bP` enum(' ','¢','€') default NULL,
273	KEY `bP` (`bP`)
274	) ENGINE=HEAP DEFAULT CHARSET=sjis
275	SHOW CREATE TABLE `sX`;
276	Table Create Table
277	sX CREATE TABLE `sX` (
278	`bQ` char(1) NOT NULL default '',
279	`bP` enum('\','\','\') default NULL,
280	KEY `bP` (`bP`)
281	) ENGINE=HEAP DEFAULT CHARSET=sjis
282	SHOW CREATE TABLE `sPO`;
283	Table Create Table
284	sPO CREATE TABLE `sPO` (
285	`bQ` char(1) NOT NULL default '',
286	`bP` enum('±','²','³') default NULL,
287	KEY `bP` (`bP`)
288	) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
289	SHOW CREATE TABLE `sPP`;
290	Table Create Table
291	sPP CREATE TABLE `sPP` (
292	`bQ` char(1) NOT NULL default '',
293	`bP` enum(' ','¢','€') default NULL,
294	KEY `bP` (`bP`)
295	) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
296	SHOW CREATE TABLE `sPQ`;
297	Table Create Table
298	sPQ CREATE TABLE `sPQ` (
299	`bQ` char(1) NOT NULL default '',
300	`bP` enum('\','\','\') default NULL,
301	KEY `bP` (`bP`)
302	) ENGINE=BerkeleyDB DEFAULT CHARSET=sjis
303	DESC `sP`;
304	Field Type Null Key Default Extra
305	bQ char(1)
306	bP enum('±','²','³') YES MUL NULL
307	DESC `sQ`;
308	Field Type Null Key Default Extra
309	bQ char(1)
310	bP enum(' ','¢','€') YES MUL NULL
311	DESC `sR`;
312	Field Type Null Key Default Extra
313	bQ char(1)
314	bP enum('\','\','\') YES MUL NULL
315	DESC `sS`;
316	Field Type Null Key Default Extra
317	bQ char(1)
318	bP enum('±','²','³') YES MUL NULL
319	DESC `sT`;
320	Field Type Null Key Default Extra
321	bQ char(1)
322	bP enum(' ','¢','€') YES MUL NULL
323	DESC `sU`;
324	Field Type Null Key Default Extra
325	bQ char(1)
326	bP enum('\','\','\') YES MUL NULL
327	DESC `sV`;
328	Field Type Null Key Default Extra
329	bQ char(1)
330	bP enum('±','²','³') YES MUL NULL
331	DESC `sW`;
332	Field Type Null Key Default Extra
333	bQ char(1)
334	bP enum(' ','¢','€') YES MUL NULL
335	DESC `sX`;
336	Field Type Null Key Default Extra
337	bQ char(1)
338	bP enum('\','\','\') YES MUL NULL
339	DESC `sPO`;
340	Field Type Null Key Default Extra
341	bQ char(1)
342	bP enum('±','²','³') YES MUL NULL
343	DESC `sPP`;
344	Field Type Null Key Default Extra
345	bQ char(1)
346	bP enum(' ','¢','€') YES MUL NULL
347	DESC `sPQ`;
348	Field Type Null Key Default Extra
349	bQ char(1)
350	bP enum('\','\','\') YES MUL NULL
351	DROP TABLE `sP`;
352	DROP TABLE `sQ`;
353	DROP TABLE `sR`;
354	DROP TABLE `sS`;
355	DROP TABLE `sT`;
356	DROP TABLE `sU`;
357	DROP TABLE `sV`;
358	DROP TABLE `sW`;
359	DROP TABLE `sX`;
360	DROP TABLE `sPO`;
361	DROP TABLE `sPP`;
362	DROP TABLE `sPQ`;