pCaJL5sd

1USE open;
2CREATE TABLE IF NOT EXISTS `post` (
3  `p_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
4  `p_author` varchar(20) NOT NULL,
5  `p_timestamp` timestamp NOT NULL,
6  `p_title` varchar(150) NOT NULL,
7  `p_content` mediumint(9) NOT NULL,
8  `p_tags` text NOT NULL,
9  `r_count` smallint(5) unsigned NOT NULL,
10  `c_count` smallint(5) unsigned NOT NULL,
11  PRIMARY KEY (`p_id`),
12  KEY `p_author` (`p_author`),
13  KEY `p_timestamp` (`p_timestamp'),
14  KEY `r_count` ('r_count'),
15  FULLTEXT KEY `p_tags` (`p_tags`)
16) ENGINE=MyISAM DEFAULT CHARSET=utf8;