/**
* Create post table
*
* @access private
*/
private function create_post()
{
$sql = 'CREATE TABLE `' . $this->_db_prefix . 'post` (
`POST_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`post_title` tinytext NOT NULL,
`post_content` text NOT NULL,
`post_allow_comment` varchar(6) NOT NULL DEFAULT \'closed\',
`post_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`post_author` int(11) NOT NULL,
`post_status` varchar(7) NOT NULL DEFAULT \'draft\',
`post_category` varchar(29) NOT NULL,
`post_tags` tinytext NOT NULL,
`post_permalink` tinytext NOT NULL,
`post_updated` varchar(3) NOT NULL DEFAULT \'no\',
`post_update_author` int(11) DEFAULT NULL,
PRIMARY KEY (`POST_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;';
$create = $this->_db->prepare($sql);
$create->execute();
if ($create->errorCode() != '00000') {
throw new Exception('false create');
} else {
$post = new Post();
$post->_title = 'Hello World!';
$post->_content = "Welcome\n";
$post->_content .= "\n";
$post->_content .= "This is your first post on Lynxpress. You can edit or delete this one to start blogging.\n";
$post->_content .= "\n";
$post->_content .= "I hope you'll like this new CMS.";
$post->_allow_comment = 'open';
$post->_author = 1;
$post->_status = 'publish';
$post->_category = 1;
$post->_tags = 'hello, world';
$post->_permalink = 'hello-world';
$post->create();
}
}
