~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
UPDATE `£Ô£±` SET `£Ã£±` = ('Ž¶Ž·ŽžŽ¹Žº');
40
UPDATE `£Ô£²` SET `£Ã£±` = ('€«€­€¯€±€³');
41
UPDATE `£Ô£³` SET `£Ã£±` = ('íȏíɏíʏíˏíÌ');
42
UPDATE `£Ô£Ž` SET `£Ã£±` = ('Ž¶Ž·ŽžŽ¹Žº');
43
UPDATE `£Ô£µ` SET `£Ã£±` = ('€«€­€¯€±€³');
44
UPDATE `£Ô£¶` SET `£Ã£±` = ('íȏíɏíʏíˏíÌ');
45
UPDATE `£Ô£·` SET `£Ã£±` = ('Ž¶Ž·ŽžŽ¹Žº');
46
UPDATE `£Ô£ž` SET `£Ã£±` = ('€«€­€¯€±€³');
47
UPDATE `£Ô£¹` SET `£Ã£±` = ('íȏíɏíʏíˏíÌ');
48
UPDATE `£Ô£±£°` SET `£Ã£±` = ('Ž¶Ž·ŽžŽ¹Žº');
49
UPDATE `£Ô£±£±` SET `£Ã£±` = ('€«€­€¯€±€³');
50
UPDATE `£Ô£±£²` SET `£Ã£±` = ('íȏíɏíʏíˏíÌ');
51
SELECT * FROM `£Ô£±`;
52
£Ã£±
53
Ž¶Ž·ŽžŽ¹Žº
54
SELECT * FROM `£Ô£²`;
55
£Ã£±
56
€«€­€¯€±€³
57
SELECT * FROM `£Ô£³`;
58
£Ã£±
59
íȏíɏíʏíˏíÌ
60
SELECT * FROM `£Ô£Ž`;
61
£Ã£±
62
Ž¶Ž·ŽžŽ¹Žº
63
SELECT * FROM `£Ô£µ`;
64
£Ã£±
65
€«€­€¯€±€³
66
SELECT * FROM `£Ô£¶`;
67
£Ã£±
68
íȏíɏíʏíˏíÌ
69
SELECT * FROM `£Ô£·`;
70
£Ã£±
71
Ž¶Ž·ŽžŽ¹Žº
72
SELECT * FROM `£Ô£ž`;
73
£Ã£±
74
€«€­€¯€±€³
75
SELECT * FROM `£Ô£¹`;
76
£Ã£±
77
íȏíɏíʏíˏíÌ
78
SELECT * FROM `£Ô£±£°`;
79
£Ã£±
80
Ž¶Ž·ŽžŽ¹Žº
81
SELECT * FROM `£Ô£±£±`;
82
£Ã£±
83
€«€­€¯€±€³
84
SELECT * FROM `£Ô£±£²`;
85
£Ã£±
86
íȏíɏíʏíˏíÌ
87
DROP TABLE `£Ô£±`;
88
DROP TABLE `£Ô£²`;
89
DROP TABLE `£Ô£³`;
90
DROP TABLE `£Ô£Ž`;
91
DROP TABLE `£Ô£µ`;
92
DROP TABLE `£Ô£¶`;
93
DROP TABLE `£Ô£·`;
94
DROP TABLE `£Ô£ž`;
95
DROP TABLE `£Ô£¹`;
96
DROP TABLE `£Ô£±£°`;
97
DROP TABLE `£Ô£±£±`;
98
DROP TABLE `£Ô£±£²`;