~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), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
16
CREATE TABLE `£Ô£²` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
17
CREATE TABLE `£Ô£³` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;
18
CREATE TABLE `£Ô£Ž` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
19
CREATE TABLE `£Ô£µ` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
20
CREATE TABLE `£Ô£¶` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;
21
CREATE TABLE `£Ô£·` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = heap;
22
CREATE TABLE `£Ô£ž` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = heap;
23
CREATE TABLE `£Ô£¹` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = heap;
24
CREATE TABLE `£Ô£±£°` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;
25
CREATE TABLE `£Ô£±£±` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;
26
CREATE TABLE `£Ô£±£²` (`£Ã£±` char(5), 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 `£Ã£±`, LPAD(`£Ã£±`,5,'Ž¡') FROM `£Ô£±`;
40
£Ã£±	LPAD(`£Ã£±`,5,'Ž¡')
41
	Ž¡Ž¡Ž¡Ž¡Ž¡
42
Ž±	Ž¡Ž¡Ž¡Ž¡Ž±
43
Ž±Ž²	Ž¡Ž¡Ž¡Ž±Ž²
44
Ž±Ž²Ž³	Ž¡Ž¡Ž±Ž²Ž³
45
Ž±Ž²Ž³ŽŽ	Ž¡Ž±Ž²Ž³ŽŽ
46
Ž±Ž²Ž³ŽŽŽµ	Ž±Ž²Ž³ŽŽŽµ
47
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'£Ø') FROM `£Ô£²`;
48
£Ã£±	LPAD(`£Ã£±`,5,'£Ø')
49
	£Ø£Ø£Ø£Ø£Ø
50
€¢	£Ø£Ø£Ø£Ø€¢
51
€¢€€	£Ø£Ø£Ø€¢€€
52
€¢€€€Š	£Ø£Ø€¢€€€Š
53
€¢€€€Š€š	£Ø€¢€€€Š€š
54
€¢€€€Š€š€ª	€¢€€€Š€š€ª
55
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'°¢') FROM `£Ô£³`;
56
£Ã£±	LPAD(`£Ã£±`,5,'°¢')
57
	°¢°¢°¢°¢°¢
58
íÜ	°¢°¢°¢°¢íÜ
59
í܏íÝ	°¢°¢°¢í܏íÝ
60
í܏íݏíÞ	°¢°¢í܏íݏíÞ
61
í܏íݏíޏíß	°¢í܏íݏíޏíß
62
í܏íݏíޏíߏíà	í܏íݏíޏíߏíà
63
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'Ž¡') FROM `£Ô£Ž`;
64
£Ã£±	LPAD(`£Ã£±`,5,'Ž¡')
65
	Ž¡Ž¡Ž¡Ž¡Ž¡
66
Ž±	Ž¡Ž¡Ž¡Ž¡Ž±
67
Ž±Ž²	Ž¡Ž¡Ž¡Ž±Ž²
68
Ž±Ž²Ž³	Ž¡Ž¡Ž±Ž²Ž³
69
Ž±Ž²Ž³ŽŽ	Ž¡Ž±Ž²Ž³ŽŽ
70
Ž±Ž²Ž³ŽŽŽµ	Ž±Ž²Ž³ŽŽŽµ
71
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'£Ø') FROM `£Ô£µ`;
72
£Ã£±	LPAD(`£Ã£±`,5,'£Ø')
73
	£Ø£Ø£Ø£Ø£Ø
74
€¢	£Ø£Ø£Ø£Ø€¢
75
€¢€€	£Ø£Ø£Ø€¢€€
76
€¢€€€Š	£Ø£Ø€¢€€€Š
77
€¢€€€Š€š	£Ø€¢€€€Š€š
78
€¢€€€Š€š€ª	€¢€€€Š€š€ª
79
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'°¢' ) FROM `£Ô£¶`;
80
£Ã£±	LPAD(`£Ã£±`,5,'°¢' )
81
	°¢°¢°¢°¢°¢
82
íÜ	°¢°¢°¢°¢íÜ
83
í܏íÝ	°¢°¢°¢í܏íÝ
84
í܏íݏíÞ	°¢°¢í܏íݏíÞ
85
í܏íݏíޏíß	°¢í܏íݏíޏíß
86
í܏íݏíޏíߏíà	í܏íݏíޏíߏíà
87
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'Ž¡') FROM `£Ô£·`;
88
£Ã£±	LPAD(`£Ã£±`,5,'Ž¡')
89
Ž±Ž²Ž³ŽŽŽµ	Ž±Ž²Ž³ŽŽŽµ
90
Ž±Ž²Ž³ŽŽ	Ž¡Ž±Ž²Ž³ŽŽ
91
Ž±Ž²Ž³	Ž¡Ž¡Ž±Ž²Ž³
92
Ž±Ž²	Ž¡Ž¡Ž¡Ž±Ž²
93
Ž±	Ž¡Ž¡Ž¡Ž¡Ž±
94
	Ž¡Ž¡Ž¡Ž¡Ž¡
95
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'£Ø') FROM `£Ô£ž`;
96
£Ã£±	LPAD(`£Ã£±`,5,'£Ø')
97
€¢€€€Š€š€ª	€¢€€€Š€š€ª
98
€¢€€€Š€š	£Ø€¢€€€Š€š
99
€¢€€€Š	£Ø£Ø€¢€€€Š
100
€¢€€	£Ø£Ø£Ø€¢€€
101
€¢	£Ø£Ø£Ø£Ø€¢
102
	£Ø£Ø£Ø£Ø£Ø
103
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'°¢' ) FROM `£Ô£¹`;
104
£Ã£±	LPAD(`£Ã£±`,5,'°¢' )
105
í܏íݏíޏíߏíà	í܏íݏíޏíߏíà
106
í܏íݏíޏíß	°¢í܏íݏíޏíß
107
í܏íݏíÞ	°¢°¢í܏íݏíÞ
108
í܏íÝ	°¢°¢°¢í܏íÝ
109
íÜ	°¢°¢°¢°¢íÜ
110
	°¢°¢°¢°¢°¢
111
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'Ž¡') FROM `£Ô£±£°`;
112
£Ã£±	LPAD(`£Ã£±`,5,'Ž¡')
113
Ž±Ž²Ž³ŽŽŽµ	Ž±Ž²Ž³ŽŽŽµ
114
Ž±Ž²Ž³ŽŽ	Ž¡Ž±Ž²Ž³ŽŽ
115
Ž±Ž²Ž³	Ž¡Ž¡Ž±Ž²Ž³
116
Ž±Ž²	Ž¡Ž¡Ž¡Ž±Ž²
117
Ž±	Ž¡Ž¡Ž¡Ž¡Ž±
118
	Ž¡Ž¡Ž¡Ž¡Ž¡
119
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'£Ø') FROM `£Ô£±£±`;
120
£Ã£±	LPAD(`£Ã£±`,5,'£Ø')
121
€¢€€€Š€š€ª	€¢€€€Š€š€ª
122
€¢€€€Š€š	£Ø€¢€€€Š€š
123
€¢€€€Š	£Ø£Ø€¢€€€Š
124
€¢€€	£Ø£Ø£Ø€¢€€
125
€¢	£Ø£Ø£Ø£Ø€¢
126
	£Ø£Ø£Ø£Ø£Ø
127
SELECT `£Ã£±`, LPAD(`£Ã£±`,5,'°¢' ) FROM `£Ô£±£²`;
128
£Ã£±	LPAD(`£Ã£±`,5,'°¢' )
129
í܏íݏíޏíߏíà	í܏íݏíޏíߏíà
130
í܏íݏíޏíß	°¢í܏íݏíޏíß
131
í܏íݏíÞ	°¢°¢í܏íݏíÞ
132
í܏íÝ	°¢°¢°¢í܏íÝ
133
íÜ	°¢°¢°¢°¢íÜ
134
	°¢°¢°¢°¢°¢
135
DROP TABLE `£Ô£±`;
136
DROP TABLE `£Ô£²`;
137
DROP TABLE `£Ô£³`;
138
DROP TABLE `£Ô£Ž`;
139
DROP TABLE `£Ô£µ`;
140
DROP TABLE `£Ô£¶`;
141
DROP TABLE `£Ô£·`;
142
DROP TABLE `£Ô£ž`;
143
DROP TABLE `£Ô£¹`;
144
DROP TABLE `£Ô£±£°`;
145
DROP TABLE `£Ô£±£±`;
146
DROP TABLE `£Ô£±£²`;