Livelog

Client should be able to request all lines after a certain timestamp
Keep last 1000 lines in memory

Remember

We repurposed the signup callbacks for streamer login, probably worth combining those two pages regardless.

Database schema

user

id bigint unsigned unique auto_increment not null
username varchar(32) character set utf8 not null
password_character varchar(1) character set latin1 not null
password_color varchar(7) character set latin1 not null
token varchar(16000) character set utf8

annotate

id bigint unsigned unique auto_increment not null
user_id bigint unsigned not null
data json

sokoban

id bigint unsigned unique auto_increment not null
user_id bigint unsigned not null
turn_count int unsigned not null
time_seconds int unsigned not null
soko_level tinyint unsigned not null
soko_sublevel tinyint unsigned not null
soko_path json