CREATE TABLE `post` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `text` TEXT NOT NULL , `user_id` INT UNSIGNED NOT NULL, `comment_count` INT UNSIGNED NOT NULL, `last_comment_count` INT UNSIGNED NOT NULL ); CREATE TABLE `comment` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `post_id` INT UNSIGNED NOT NULL, `text` TEXT NOT NULL );