1alter table account character set utf8mb4 collate utf8mb4_unicode_ci,
2change username username varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci not null,
3change password password  varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci,
4change status status char(8) character set utf8mb4 collate utf8mb4_unicode_ci not null default 'active';
5
6
7DROP INDEX i_characters_charname ON characters;
8alter table characters character set utf8mb4 collate utf8mb4_unicode_ci,
9change charname charname varchar(50) character set utf8mb4 collate utf8mb4_unicode_ci  not null,
10change status status char(8) character set utf8mb4 collate utf8mb4_unicode_ci not null default 'active';
11
12alter table rpobject character set utf8mb4 collate utf8mb4_unicode_ci;
13
14alter table rpzone character set utf8mb4 collate utf8mb4_unicode_ci,
15change zone_id zone_id varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci not null;
16
17
18alter table loginEvent character set utf8mb4 collate utf8mb4_unicode_ci,
19change address address varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
20change service service char(20) character set utf8mb4 collate utf8mb4_unicode_ci,
21change seed seed varchar(120) character set utf8mb4 collate utf8mb4_unicode_ci;
22-- too slow
23
24
25alter table passwordChange character set utf8mb4 collate utf8mb4_unicode_ci,
26change address address varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
27change service service char(20) character set utf8mb4 collate utf8mb4_unicode_ci,
28change oldpassword oldpassword varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci;
29
30alter table statistics character set utf8mb4 collate utf8mb4_unicode_ci;
31-- maybe too slow
32
33alter table gameEvents character set utf8mb4 collate utf8mb4_unicode_ci,
34change source source varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
35change event event  varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
36change param1 param1 varchar(128) character set utf8mb4 collate utf8mb4_unicode_ci,
37change param2 param2 varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci;
38-- too slow
39
40alter table loginseed character set utf8mb4 collate utf8mb4_unicode_ci,
41change seed seed varchar(120) character set utf8mb4 collate utf8mb4_unicode_ci,
42change address address varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci;
43
44
45alter table banlist character set utf8mb4 collate utf8mb4_unicode_ci,
46change address address varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
47change mask mask    varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
48change reason reason  varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci;
49
50alter table accountban character set utf8mb4 collate utf8mb4_unicode_ci,
51change reason reason varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci;
52
53alter table accountLink character set utf8mb4 collate utf8mb4_unicode_ci,
54change type type char(10) character set utf8mb4 collate utf8mb4_unicode_ci,
55change username username varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci,
56change nickname nickname varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci,
57change email email varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci,
58change secret secret varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci;
59
60UPDATE email SET confirmed='1999-01-01' WHERE confirmed<'1999-01-01';
61alter table email character set utf8mb4 collate utf8mb4_unicode_ci,
62change email email varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
63change token token varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
64change address address  varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
65change confirmed confirmed timestamp NULL;
66UPDATE email SET confirmed=null WHERE confirmed='1999-01-01';
67
68UPDATE character_stats SET lastseen='1999-01-01' WHERE lastseen<'1999-01-01';
69alter table character_stats character set utf8mb4 collate utf8mb4_unicode_ci,
70change name name varchar(50) character set utf8mb4 collate utf8mb4_unicode_ci  not null,
71change married married varchar(50) character set utf8mb4 collate utf8mb4_unicode_ci,
72change sentence sentence varchar(256) character set utf8mb4 collate utf8mb4_unicode_ci,
73change outfit outfit varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
74change head head varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
75change armor armor varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
76change lhand lhand varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
77change rhand rhand varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
78change legs legs varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
79change feet feet varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
80change cloak cloak varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
81change finger finger varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
82change outfit_colors outfit_colors varchar(100) character set utf8mb4 collate utf8mb4_unicode_ci,
83change zone zone varchar(50) character set utf8mb4 collate utf8mb4_unicode_ci
84change lastseen lasstseen timestamp null;
85UPDATE character_stats SET lastseen=null WHERE lastseen='1999-01-01';
86
87
88alter table halloffame character set utf8mb4 collate utf8mb4_unicode_ci,
89change charname charname varchar(50) character set utf8mb4 collate utf8mb4_unicode_ci not null,
90change fametype fametype char(1) character set utf8mb4 collate utf8mb4_unicode_ci not null;
91
92alter table halloffame_archive_recent character set utf8mb4 collate utf8mb4_unicode_ci,
93change charname charname varchar(50) character set utf8mb4 collate utf8mb4_unicode_ci not null,
94change fametype fametype char(1) character set utf8mb4 collate utf8mb4_unicode_ci not null;
95
96alter table halloffame_archive_alltimes character set utf8mb4 collate utf8mb4_unicode_ci,
97change charname charname varchar(50) character set utf8mb4 collate utf8mb4_unicode_ci not null,
98change fametype fametype char(1) character set utf8mb4 collate utf8mb4_unicode_ci not null;
99
100
101alter table item character set utf8mb4 collate utf8mb4_unicode_ci,
102change name name VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci;
103
104alter table itemlog character set utf8mb4 collate utf8mb4_unicode_ci,
105change source source VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
106change event event VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
107change param1 param1 VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
108change param2 param2 VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
109change param3 param3 VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
110change param4 param4 VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci;
111-- too slow
112
113-- -----------------------------------------
114
115alter table kills character set utf8mb4 collate utf8mb4_unicode_ci,
116change killed killed VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
117change killer killer VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
118change killed_type killed_type CHAR(1) character set utf8mb4 collate utf8mb4_unicode_ci,
119change killer_type killer_type CHAR(1) character set utf8mb4 collate utf8mb4_unicode_ci;
120-- too slow
121
122alter table npcs character set utf8mb4 collate utf8mb4_unicode_ci,
123change name name VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
124change title title VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
125change class class VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
126change outfit outfit VARCHAR(32) character set utf8mb4 collate utf8mb4_unicode_ci,
127change image image VARCHAR(255) character set utf8mb4 collate utf8mb4_unicode_ci,
128change zone zone VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
129change description description VARCHAR(1000) character set utf8mb4 collate utf8mb4_unicode_ci,
130change job job VARCHAR(1000) character set utf8mb4 collate utf8mb4_unicode_ci;
131
132alter table zoneinfo character set utf8mb4 collate utf8mb4_unicode_ci,
133change name name VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
134change readableName readableName VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
135change description description VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
136change colorMethod colorMethod VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
137change color color VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
138change blendMethod blendMethod VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
139change weather weather VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci;
140
141alter table postman character set utf8mb4 collate utf8mb4_unicode_ci,
142change source source VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
143change target target VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
144change message message TEXT character set utf8mb4 collate utf8mb4_unicode_ci,
145change deleted deleted CHAR (1) character set utf8mb4 collate utf8mb4_unicode_ci DEFAULT 'N';
146
147alter table buddy character set utf8mb4,
148change buddy buddy varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
149change charname charname varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
150change relationtype relationtype varchar(64) character set utf8mb4 default 'buddy';
151
152alter table openid_associations character set utf8mb4 collate utf8mb4_unicode_ci,
153change handle handle VARCHAR(255) character set utf8mb4 collate utf8mb4_unicode_ci,
154change data data TEXT character set utf8mb4 collate utf8mb4_unicode_ci NOT NULL;
155
156alter table achievement character set utf8mb4 collate utf8mb4_unicode_ci,
157change identifier identifier VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
158change title title VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
159change category category VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
160change description description VARCHAR(254) character set utf8mb4 collate utf8mb4_unicode_ci;
161
162alter table reached_achievement character set utf8mb4 collate utf8mb4_unicode_ci,
163change charname charname VARCHAR(32) character set utf8mb4 collate utf8mb4_unicode_ci;
164
165alter table pending_achievement character set utf8mb4 collate utf8mb4_unicode_ci,
166change charname charname VARCHAR(32) character set utf8mb4 collate utf8mb4_unicode_ci,
167change param param VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci;
168
169alter table statistics_archive character set utf8mb4 collate utf8mb4_unicode_ci,
170change name name varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci not null;
171
172alter table trade character set utf8mb4 collate utf8mb4_unicode_ci,
173change charname charname  varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
174change itemname itemname  varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci,
175change stats stats varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci;
176
177alter table searchindex character set utf8mb4 collate utf8mb4_unicode_ci,
178change searchterm searchterm VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci,
179change entitytype entitytype CHAR(1) character set utf8mb4 collate utf8mb4_unicode_ci,
180change entityname entityname VARCHAR(64) character set utf8mb4 collate utf8mb4_unicode_ci;
181
182
183
184alter table cid character set utf8mb4 collate utf8mb4_unicode_ci,
185change charname charname varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci NOT NULL,
186change address address varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci NOT NULL,
187change cid cid varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci NOT NULL,
188change version version varchar(50) character set utf8mb4 collate utf8mb4_unicode_ci DEFAULT NULL,
189change dist dist varchar(100) character set utf8mb4 collate utf8mb4_unicode_ci DEFAULT NULL,
190change build build varchar(50) character set utf8mb4 collate utf8mb4_unicode_ci DEFAULT NULL;
191-- too slow
192
193alter table actions character set utf8mb4 collate utf8mb4_unicode_ci,
194change charname charname varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci NOT NULL,
195change zone zone varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
196change action action varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
197change details details varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci;
198-- too slow
199
200alter table webactions character set utf8mb4 collate utf8mb4_unicode_ci,
201change charname charname varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci NOT NULL,
202change zone zone varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
203change action action varchar(64) character set utf8mb4 collate utf8mb4_unicode_ci,
204change useragent useragent varchar(255) character set utf8mb4 collate utf8mb4_unicode_ci;
205-- too slow
206
207