 	modified datetime not null,
 	index (user),
 	index (resource, resource_id, expires)
-);
+) default charset=utf8;
 
 create table filemanager_prop (
 	file char(128) not null primary key,
 	prop char(32) not null,
 	value char(255) not null,
 	index (prop)
-);
+) default charset=utf8;
 
 create table apps (
 	name char(48) not null primary key,
 	version char(16) not null
-);
+) default charset=utf8;
 
 insert into apps (name, version) values ('blog', '1.1.3-stable');
 insert into apps (name, version) values ('user', '1.1.3-stable');

	extra text not null,
	index (ts),
	index (ts, published)
);

create table blog_tag (
	id char(24) not null primary key
);

create table blog_post_tag (
	tag_id char(24) not null,
	post_id int not null,
	primary key (tag_id, post_id)
);

create table `lock` (
	id int not null auto_increment primary key,

	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,
