~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
SET NAMES ujis;
12
SET character_set_database = ucs2;
13
SET collation_connection = ucs2_general_ci;
14
CREATE TABLE `£Ô£±` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
15
CREATE TABLE `£Ô£²` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
16
CREATE TABLE `£Ô£³` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
17
CREATE TABLE `£Ô£Ž` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
18
CREATE TABLE `£Ô£µ` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
19
CREATE TABLE `£Ô£¶` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
20
CREATE TABLE `£Ô£·` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = heap;
21
CREATE TABLE `£Ô£ž` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = heap;
22
CREATE TABLE `£Ô£¹` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = heap;
23
CREATE TABLE `£Ô£±£°` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
24
CREATE TABLE `£Ô£±£±` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
25
CREATE TABLE `£Ô£±£²` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
26
INSERT INTO `£Ô£±` VALUES ('Ž±Ž²Ž³ŽŽŽµ');
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
INSERT INTO `£Ô£²` VALUES ('€¢€€€Š€š€ª¡¡¡¡¡¡');
40
INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà');
41
INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà ');
42
INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà  ');
43
INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà   ');
44
INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà¡¡');
45
INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà¡¡¡¡');
46
INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà¡¡¡¡¡¡');
47
INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ');
48
INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ ');
49
INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ  ');
50
INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ   ');
51
INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ¡¡');
52
INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ¡¡¡¡');
53
INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ¡¡¡¡¡¡');
54
INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª');
55
INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª ');
56
INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª  ');
57
INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª   ');
58
INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª¡¡');
59
INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª¡¡¡¡');
60
INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª¡¡¡¡¡¡');
61
INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà');
62
INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà ');
63
INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà  ');
64
INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà   ');
65
INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà¡¡');
66
INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà¡¡¡¡');
67
INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà¡¡¡¡¡¡');
68
INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ');
69
INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ ');
70
INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ  ');
71
INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ   ');
72
INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ¡¡');
73
INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ¡¡¡¡');
74
INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ¡¡¡¡¡¡');
75
INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª');
76
INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª ');
77
INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª  ');
78
INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª   ');
79
INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª¡¡');
80
INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª¡¡¡¡');
81
INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª¡¡¡¡¡¡');
82
INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà');
83
INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà ');
84
INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà  ');
85
INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà   ');
86
INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà¡¡');
87
INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà¡¡¡¡');
88
INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà¡¡¡¡¡¡');
89
INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ');
90
INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ ');
91
INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ  ');
92
INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ   ');
93
INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ¡¡');
94
INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ¡¡¡¡');
95
INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ¡¡¡¡¡¡');
96
INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª');
97
INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª ');
98
INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª  ');
99
INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª   ');
100
INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª¡¡');
101
INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª¡¡¡¡');
102
INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª¡¡¡¡¡¡');
103
INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà');
104
INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà ');
105
INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà  ');
106
INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà   ');
107
INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà¡¡');
108
INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà¡¡¡¡');
109
INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà¡¡¡¡¡¡');
110
SELECT RTRIM(`£Ã£±`) from `£Ô£±`;
111
RTRIM(`£Ã£±`)
112
Ž±Ž²Ž³ŽŽŽµ
113
Ž±Ž²Ž³ŽŽŽµ
114
Ž±Ž²Ž³ŽŽŽµ
115
Ž±Ž²Ž³ŽŽŽµ
116
Ž±Ž²Ž³ŽŽŽµ¡¡
117
Ž±Ž²Ž³ŽŽŽµ¡¡¡¡
118
Ž±Ž²Ž³ŽŽŽµ¡¡¡¡¡¡
119
SELECT RTRIM(`£Ã£±`) from `£Ô£²`;
120
RTRIM(`£Ã£±`)
121
€¢€€€Š€š€ª
122
€¢€€€Š€š€ª
123
€¢€€€Š€š€ª
124
€¢€€€Š€š€ª
125
€¢€€€Š€š€ª¡¡
126
€¢€€€Š€š€ª¡¡¡¡
127
€¢€€€Š€š€ª¡¡¡¡¡¡
128
SELECT RTRIM(`£Ã£±`) from `£Ô£³`;
129
RTRIM(`£Ã£±`)
130
í܏íݏíޏíߏíà
131
í܏íݏíޏíߏíà
132
í܏íݏíޏíߏíà
133
í܏íݏíޏíߏíà
134
í܏íݏíޏíߏíà¡¡
135
í܏íݏíޏíߏíà¡¡¡¡
136
í܏íݏíޏíߏíà¡¡¡¡¡¡
137
SELECT RTRIM(`£Ã£±`) from `£Ô£Ž`;
138
RTRIM(`£Ã£±`)
139
Ž±Ž²Ž³ŽŽŽµ
140
Ž±Ž²Ž³ŽŽŽµ
141
Ž±Ž²Ž³ŽŽŽµ
142
Ž±Ž²Ž³ŽŽŽµ
143
Ž±Ž²Ž³ŽŽŽµ¡¡
144
Ž±Ž²Ž³ŽŽŽµ¡¡¡¡
145
Ž±Ž²Ž³ŽŽŽµ¡¡¡¡¡¡
146
SELECT RTRIM(`£Ã£±`) from `£Ô£µ`;
147
RTRIM(`£Ã£±`)
148
€¢€€€Š€š€ª
149
€¢€€€Š€š€ª
150
€¢€€€Š€š€ª
151
€¢€€€Š€š€ª
152
€¢€€€Š€š€ª¡¡
153
€¢€€€Š€š€ª¡¡¡¡
154
€¢€€€Š€š€ª¡¡¡¡¡¡
155
SELECT RTRIM(`£Ã£±`) from `£Ô£¶`;
156
RTRIM(`£Ã£±`)
157
í܏íݏíޏíߏíà
158
í܏íݏíޏíߏíà
159
í܏íݏíޏíߏíà
160
í܏íݏíޏíߏíà
161
í܏íݏíޏíߏíà¡¡
162
í܏íݏíޏíߏíà¡¡¡¡
163
í܏íݏíޏíߏíà¡¡¡¡¡¡
164
SELECT RTRIM(`£Ã£±`) from `£Ô£·`;
165
RTRIM(`£Ã£±`)
166
Ž±Ž²Ž³ŽŽŽµ
167
Ž±Ž²Ž³ŽŽŽµ
168
Ž±Ž²Ž³ŽŽŽµ
169
Ž±Ž²Ž³ŽŽŽµ
170
Ž±Ž²Ž³ŽŽŽµ¡¡
171
Ž±Ž²Ž³ŽŽŽµ¡¡¡¡
172
Ž±Ž²Ž³ŽŽŽµ¡¡¡¡¡¡
173
SELECT RTRIM(`£Ã£±`) from `£Ô£ž`;
174
RTRIM(`£Ã£±`)
175
€¢€€€Š€š€ª
176
€¢€€€Š€š€ª
177
€¢€€€Š€š€ª
178
€¢€€€Š€š€ª
179
€¢€€€Š€š€ª¡¡
180
€¢€€€Š€š€ª¡¡¡¡
181
€¢€€€Š€š€ª¡¡¡¡¡¡
182
SELECT RTRIM(`£Ã£±`) from `£Ô£¹`;
183
RTRIM(`£Ã£±`)
184
í܏íݏíޏíߏíà
185
í܏íݏíޏíߏíà
186
í܏íݏíޏíߏíà
187
í܏íݏíޏíߏíà
188
í܏íݏíޏíߏíà¡¡
189
í܏íݏíޏíߏíà¡¡¡¡
190
í܏íݏíޏíߏíà¡¡¡¡¡¡
191
SELECT RTRIM(`£Ã£±`) from `£Ô£±£°`;
192
RTRIM(`£Ã£±`)
193
Ž±Ž²Ž³ŽŽŽµ
194
Ž±Ž²Ž³ŽŽŽµ
195
Ž±Ž²Ž³ŽŽŽµ
196
Ž±Ž²Ž³ŽŽŽµ
197
Ž±Ž²Ž³ŽŽŽµ¡¡
198
Ž±Ž²Ž³ŽŽŽµ¡¡¡¡
199
Ž±Ž²Ž³ŽŽŽµ¡¡¡¡¡¡
200
SELECT RTRIM(`£Ã£±`) from `£Ô£±£±`;
201
RTRIM(`£Ã£±`)
202
€¢€€€Š€š€ª
203
€¢€€€Š€š€ª
204
€¢€€€Š€š€ª
205
€¢€€€Š€š€ª
206
€¢€€€Š€š€ª¡¡
207
€¢€€€Š€š€ª¡¡¡¡
208
€¢€€€Š€š€ª¡¡¡¡¡¡
209
SELECT RTRIM(`£Ã£±`) from `£Ô£±£²`;
210
RTRIM(`£Ã£±`)
211
í܏íݏíޏíߏíà
212
í܏íݏíޏíߏíà
213
í܏íݏíޏíߏíà
214
í܏íݏíޏíߏíà
215
í܏íݏíޏíߏíà¡¡
216
í܏íݏíޏíߏíà¡¡¡¡
217
í܏íݏíޏíߏíà¡¡¡¡¡¡
218
DROP TABLE `£Ô£±`;
219
DROP TABLE `£Ô£²`;
220
DROP TABLE `£Ô£³`;
221
DROP TABLE `£Ô£Ž`;
222
DROP TABLE `£Ô£µ`;
223
DROP TABLE `£Ô£¶`;
224
DROP TABLE `£Ô£·`;
225
DROP TABLE `£Ô£ž`;
226
DROP TABLE `£Ô£¹`;
227
DROP TABLE `£Ô£±£°`;
228
DROP TABLE `£Ô£±£±`;
229
DROP TABLE `£Ô£±£²`;