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