~drizzle-trunk/drizzle/development

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