{% highlight sql %}

create table users (id integer auto_increment, login varchar(31), password varchar(31), primary key(id));

create table profiles (id integer auto_increment, email varchar(255), primary key(id));

create table posts (id integer auto_increment, content text, user_id integer, primary key(id));

create table categories (id integer auto_increment, name varchar(63), primary key(id));

create table category2posts (category_id integer, post_id integer, primary key(category_id, post_id));

create index category2posts_post_id on category2posts (post_id);

create index posts_user_id on posts (user_id);