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