4Y 2M4 years and 2 months ago
Wednesday 3:53 pm
12th February 2020 ·
Wednesday 3:53 pm
12th February 2020 ·
samjanis1@mirrorisland.com
Behind the Scenes Updates
The latest update has brought a more visually consistent user interface, as well as the ability to store emoji and other extended characters by updating the database to use utf8mb4
for storage. Full source is available on GitLab.
Existing databases can be updated with the following SQL commands:
(just remember to select the database first, then replace {DATABASE_NAME}
with the actual name of the database)
alter database {DATABASE_NAME} character set = utf8mb4 collate = utf8mb4_unicode_ci;
alter table accounts convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change fullname fullname text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change username username varchar(191) character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change address address text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change address2 address2 text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change town town text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change state state text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change postcode postcode text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change country country text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change email email text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change website website text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change interests interests longtext character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change about about longtext character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change license license text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change termsofuse termsofuse longtext character set utf8mb4 collate utf8mb4_unicode_ci;
alter table accounts change messagetypingstatustype messagetypingstatustype text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table approvals convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table approvals change tablename tablename text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table bookmarks convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table contacts convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table files convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table files change fileindex fileindex text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table files change filename filename text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table files change filemime filemime text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table flags convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table flags change tablename tablename text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table flags change flagreason flagreason text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table members convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table membertree convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table passwords convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table passwords change password password text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table pins convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table posts convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table posts change emaildisplayname emaildisplayname text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table posts change emailusername emailusername text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table posts change emailserver emailserver text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table posts change emailinbox emailinbox text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table posts change description description longtext character set utf8mb4 collate utf8mb4_unicode_ci;
alter table posts change title title text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table posts change searchcache searchcache text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table recipients convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table recipients change tablename tablename text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table recipients change emaildisplayname emaildisplayname text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table recipients change emailusername emailusername text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table recipients change emailserver emailserver text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table searchindex convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table searchindex change tablename tablename text character set utf8mb4 collate utf8mb4_unicode_ci;
alter table searchkeywords convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table searchkeywords change keyword keyword text character set utf8mb4 collate utf8mb4_unicode_ci;
Cancel esc
Cancel esc