     approved tinyint not null default 0,
     foreign key post_id references post(id),
     foreign key moderator_id references user_profile(id)  
-);
+) engine=innodb;

    accepted_answer tinyint , -- weather answer was accepted
    url varchar(255), -- used for post with linkouts
    sticky int not null default 0 -- stickiness of the post
);

create table if not exists post_view (
    ip varchar(50),

    target_id int,
    foreign key post_id references post(id),
    foreign key target_id references post(id),
) engine=innodb;

create table if not exists post_revision (
    id int not null auto_increment primary key,
