 	user_id int not null,
 	index (token, api_key),
 	index (user_id)
-);
+) default charset=utf8;
 
 create table blog_post (
 	id int not null auto_increment primary key,

	userdata text not null,
	index(email, password),
	index(session_id)
);

insert into user (id, email, password, session_id, expires, name, type, signed_up, updated, userdata) values (1, 'you@example.com', '$2a$07$1QeR9mu2doQxY0uBcpFlrOIfDxq0BwpR8FsImCgWvAL4Fz9jDByxi', null, now(), 'Admin User', 'admin', now(), now(), '[]');

create table user_openid (
	token char(128) primary key,
	user_id int not null
);

create table versions (
	id int not null auto_increment primary key,

	serialized text not null,
	index (class, pkey, ts),
	index (user, ts)
) default charset=utf8;

create table api (
	token char(35) not null primary key,
