← Back to branch summary

~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(20)) DEFAULT CHARSET = ujis engine = innodb;

16
 
CREATE TABLE `£Ô£²` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = innodb;

17
 
CREATE TABLE `£Ô£³` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = innodb;

18
 
CREATE TABLE `£Ô£Ž` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = myisam;

19
 
CREATE TABLE `£Ô£µ` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = myisam;

20
 
CREATE TABLE `£Ô£¶` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = myisam;

21
 
CREATE TABLE `£Ô£·` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = heap;

22
 
CREATE TABLE `£Ô£ž` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = heap;

23
 
CREATE TABLE `£Ô£¹` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = heap;

24
 
CREATE TABLE `£Ô£±£°` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = bdb;

25
 
CREATE TABLE `£Ô£±£±` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = bdb;

26
 
CREATE TABLE `£Ô£±£²` (`£Ã£±` char(20)) DEFAULT CHARSET = ujis engine = bdb;

27
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£±`;

28
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£²`;

29
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£³`;

30
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£Ž`;

31
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£µ`;

32
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£¶`;

33
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£·`;

34
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£ž`;

35
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£¹`;

36
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_ujis.dat' INTO TABLE `£Ô£±£°`;

37
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_ujis.dat' INTO TABLE `£Ô£±£±`;

38
 
LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_ujis.dat' INTO TABLE `£Ô£±£²`;

39
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£±`;

40
 
CHARSET(`£Ã£±`)

41
 
ujis

42
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£²`;

43
 
CHARSET(`£Ã£±`)

44
 
ujis

45
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£³`;

46
 
CHARSET(`£Ã£±`)

47
 
ujis

48
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£±`;

49
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

50
 
utf8

51
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£±`;

52
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

53
 
ucs2

54
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£±`;

55
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

56
 
sjis

57
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£±`;

58
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

59
 
ujis

60
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£²`;

61
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

62
 
utf8

63
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£²`;

64
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

65
 
ucs2

66
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£²`;

67
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

68
 
sjis

69
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£²`;

70
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

71
 
ujis

72
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£³`;

73
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

74
 
utf8

75
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£³`;

76
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

77
 
ucs2

78
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£³`;

79
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

80
 
sjis

81
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£³`;

82
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

83
 
ujis

84
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£Ž`;

85
 
CHARSET(`£Ã£±`)

86
 
ujis

87
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£µ`;

88
 
CHARSET(`£Ã£±`)

89
 
ujis

90
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£¶`;

91
 
CHARSET(`£Ã£±`)

92
 
ujis

93
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£Ž`;

94
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

95
 
utf8

96
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£Ž`;

97
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

98
 
ucs2

99
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£Ž`;

100
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

101
 
sjis

102
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£Ž`;

103
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

104
 
ujis

105
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£µ`;

106
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

107
 
utf8

108
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£µ`;

109
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

110
 
ucs2

111
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£µ`;

112
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

113
 
sjis

114
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£µ`;

115
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

116
 
ujis

117
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£¶`;

118
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

119
 
utf8

120
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£¶`;

121
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

122
 
ucs2

123
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£¶`;

124
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

125
 
sjis

126
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£¶`;

127
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

128
 
ujis

129
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£·`;

130
 
CHARSET(`£Ã£±`)

131
 
ujis

132
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£ž`;

133
 
CHARSET(`£Ã£±`)

134
 
ujis

135
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£¹`;

136
 
CHARSET(`£Ã£±`)

137
 
ujis

138
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£·`;

139
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

140
 
utf8

141
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£·`;

142
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

143
 
ucs2

144
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£·`;

145
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

146
 
sjis

147
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£·`;

148
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

149
 
ujis

150
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£ž`;

151
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

152
 
utf8

153
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£ž`;

154
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

155
 
ucs2

156
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£ž`;

157
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

158
 
sjis

159
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£ž`;

160
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

161
 
ujis

162
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£¹`;

163
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

164
 
utf8

165
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£¹`;

166
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

167
 
ucs2

168
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£¹`;

169
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

170
 
sjis

171
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£¹`;

172
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

173
 
ujis

174
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£±£°`;

175
 
CHARSET(`£Ã£±`)

176
 
ujis

177
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£±£±`;

178
 
CHARSET(`£Ã£±`)

179
 
ujis

180
 
SELECT DISTINCT CHARSET(`£Ã£±`) FROM `£Ô£±£²`;

181
 
CHARSET(`£Ã£±`)

182
 
ujis

183
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£±£°`;

184
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

185
 
utf8

186
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£±£°`;

187
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

188
 
ucs2

189
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£±£°`;

190
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

191
 
sjis

192
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£±£°`;

193
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

194
 
ujis

195
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£±£±`;

196
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

197
 
utf8

198
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£±£±`;

199
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

200
 
ucs2

201
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£±£±`;

202
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

203
 
sjis

204
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£±£±`;

205
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

206
 
ujis

207
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING utf8)) FROM `£Ô£±£²`;

208
 
CHARSET(CONVERT(`£Ã£±` USING utf8))

209
 
utf8

210
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ucs2)) FROM `£Ô£±£²`;

211
 
CHARSET(CONVERT(`£Ã£±` USING ucs2))

212
 
ucs2

213
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING sjis)) FROM `£Ô£±£²`;

214
 
CHARSET(CONVERT(`£Ã£±` USING sjis))

215
 
sjis

216
 
SELECT DISTINCT CHARSET(CONVERT(`£Ã£±` USING ujis)) FROM `£Ô£±£²`;

217
 
CHARSET(CONVERT(`£Ã£±` USING ujis))

218
 
ujis

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 `£Ô£±£²`;