`myblogvoice`.CREATE DATABASE `myblogvoice` /*!40100 DEFAULT CHARACTER SET latin1 */;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_user_templates`;
CREATE TABLE  `myblogvoice`.`mbv_user_templates`
(`user_template_id` int(10) unsigned NOT NULL auto_increment,
 `template_html` text NOT NULL,PRIMARY KEY  (`user_template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_user_info`;
CREATE TABLE  `myblogvoice`.`mbv_user_info` 
(`user_id` int(10) unsigned NOT NULL auto_increment,
 `user_name` varchar(40) NOT NULL default '',
 `password` varchar(40) NOT NULL default '',
 `secret_question` varchar(40) NOT NULL default '',
 `secret_answer` varchar(40) NOT NULL default '',
 `last_login_time` datetime NOT NULL default '0000-00-00 00:00:00',
 `user_status` int(10) unsigned NOT NULL default '0',
 `user_role` int(10) unsigned NOT NULL default '0',
 `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user_id`),
  KEY `Index_2` (`user_status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_user_profile`;
CREATE TABLE  `myblogvoice`.`mbv_user_profile`
(`user_id` int(10) unsigned NOT NULL default '0',
 `allow_comments` int(10) unsigned NOT NULL default '0',
 `allow_ping_blogs` int(10) unsigned NOT NULL default '0',
 `alow_html_in_comments` int(10) unsigned NOT NULL default '0',
  KEY `Index_1` (`user_id`),
  CONSTRAINT `FK_mbv_user_profile_1` FOREIGN KEY (`user_id`) REFERENCES `mbv_user_info` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_blog_category`;
CREATE TABLE  `myblogvoice`.`mbv_blog_category`
(`category_id` int(10) unsigned NOT NULL auto_increment,
 `category_name` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`category_id`),
  UNIQUE KEY `Index_2` (`category_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_user_agents`;
CREATE TABLE  `myblogvoice`.`mbv_user_agents`
(`user_agent_id` int(10) unsigned NOT NULL auto_increment,
 `user_agent_name` varchar(200) character set latin1 collate latin1_bin NOT NULL default '',
  PRIMARY KEY  (`user_agent_id`),
  UNIQUE KEY `Index_2` (`user_agent_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_blog_stats`;
CREATE TABLE  `myblogvoice`.`mbv_blog_stats`
(`stat_id` int(10) unsigned NOT NULL auto_increment,
 `blog_id` int(10) unsigned NOT NULL default '0',
 `referrer` varchar(200) NOT NULL default '',
 `user_agent_id` int(10) unsigned NOT NULL default 0,
 `date_visited` datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (`stat_id`),
 CONSTRAINT `FK_mbv_blog_stats_1` FOREIGN KEY (`user_agent_id`) REFERENCES `mbv_user_agents` (`user_agent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_blogs`;
CREATE TABLE  `myblogvoice`.`mbv_blogs`
(`blog_id` int(10) unsigned NOT NULL auto_increment,
 `user_id` int(10) unsigned NOT NULL default '0',
 `category_id` int(10) unsigned NOT NULL default '0',
 `blog_title` varchar(150) NOT NULL default '',
 `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
 `template_id` int(10) unsigned NOT NULL default '0',
 `blog_status` int(10) unsigned NOT NULL default '0',
 `blog_description` varchar(250) NOT NULL default '',
 `blog_url` varchar(150) NOT NULL default '',
 `allow_comments` smallint(1) unsigned NOT NULL default '0',
 `allow_trackbacks` smallint(1) unsigned NOT NULL default '0',
 `password` varchar(40) NOT NULL default '',
 PRIMARY KEY  (`blog_id`),
 UNIQUE KEY `Index_6` (`blog_url`),
 KEY `Index_2` (`user_id`),
 KEY `Index_4` (`template_id`),
 KEY `Index_3` (`category_id`),
 KEY `Index_7` (`blog_title`),
 CONSTRAINT `FK_mbv_blogs_1` FOREIGN KEY (`user_id`) REFERENCES `mbv_user_info` (`user_id`),
 CONSTRAINT `FK_mbv_blogs_3` FOREIGN KEY (`template_id`) REFERENCES `mbv_blog_templates` (`template_id`),
 CONSTRAINT `FK_mbv_blogs_4` FOREIGN KEY (`category_id`) REFERENCES `mbv_blog_category` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_blog_ranking`;
CREATE TABLE  `myblogvoice`.`mbv_blog_ranking`
(`blog_id` int(10) unsigned NOT NULL default '0',
 `rank` int(10) unsigned NOT NULL default '0',
 KEY `Index_1` (`blog_id`),
 CONSTRAINT `FK_mbv_blog_ranking_1` FOREIGN KEY (`blog_id`) REFERENCES `mbv_blogs` (`blog_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_posts`;
CREATE TABLE  `myblogvoice`.`mbv_posts`
(`post_id` int(10) unsigned NOT NULL auto_increment,
 `blog_id` int(10) unsigned NOT NULL default '0',
 `is_published` int(10) unsigned NOT NULL default '0',
 `date_published` datetime NOT NULL default '0000-00-00 00:00:00',
 `post_title` varchar(150) NOT NULL default '',
 `post_text` text NOT NULL,
 `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
 `post_url` varchar(150) NOT NULL default '',
 PRIMARY KEY  (`post_id`),
 KEY `Index_3` (`date_created`),
 KEY `Index_4` (`blog_id`),
 KEY `Index_5` (`post_url`),
 CONSTRAINT `FK_mbv_posts_1` FOREIGN KEY (`blog_id`) REFERENCES `mbv_blogs` (`blog_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_comments`;
CREATE TABLE  `myblogvoice`.`mbv_comments`
(`comment_id` bigint(20) unsigned NOT NULL auto_increment,
 `post_id` int(10) unsigned NOT NULL default '0',
 `comment_title` varchar(40) NOT NULL default '',
 `comment_text` text NOT NULL,
 `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
 `creator_id` int(10) unsigned default NULL,
 `trackback_url` varchar(100) default NULL,
 PRIMARY KEY  (`comment_id`),
 KEY `Index_2` (`post_id`),
 KEY `Index_3` (`creator_id`),
 KEY `Index_4` (`date_created`),
 KEY `Index_5` (`trackback_url`),
 CONSTRAINT `FK_mbv_comments_1` FOREIGN KEY (`post_id`) REFERENCES `mbv_posts` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1  PACK_KEYS=1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_trackbacks`;
CREATE TABLE  `myblogvoice`.`mbv_trackbacks`
(`trackback_id` bigint(20) unsigned NOT NULL auto_increment,
 `post_id` int(10) unsigned NOT NULL default '0',
 `trackback_url` varchar(100) NOT NULL default '',
 `trackback_title` varchar(40) NOT NULL default '',
 `trackback_snippet` varchar(200) NOT NULL default '',
 `trackback_name` varchar(40) NOT NULL default '',
 `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (`trackback_id`),
 KEY `Index_2` (`post_id`),
 CONSTRAINT `FK_mbv_trackbacks_1` FOREIGN KEY (`post_id`) REFERENCES `mbv_posts` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_outgoing_trackbacks`;
CREATE TABLE  `myblogvoice`.`mbv_outgoing_trackbacks`
(`trackback_id` int(10) unsigned NOT NULL auto_increment,
 `trackback_url` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`trackback_id`),
 UNIQUE KEY `Index_2` (`trackback_url`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_faq_category`;
CREATE TABLE  `myblogvoice`.`mbv_faq_category`
(`faq_category_id` int(10) unsigned NOT NULL auto_increment,
 `faq_category_desc` varchar(40) NOT NULL default '',
 PRIMARY KEY  (`faq_category_id`),
 UNIQUE KEY `Index_2` (`faq_category_desc`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_faqs`;
CREATE TABLE  `myblogvoice`.`mbv_faqs`
(`faq_id` int(10) unsigned NOT NULL auto_increment,
 `faq_category_id` int(10) unsigned NOT NULL default '0',
 `faq_question` varchar(80) NOT NULL default '',
 `faq_answer` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`faq_id`),
  KEY `FK_mbv_faqs_1` (`faq_category_id`),
  CONSTRAINT `FK_mbv_faqs_1` FOREIGN KEY (`faq_category_id`) REFERENCES `mbv_faq_category` (`faq_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_forbidden_user_names`;
CREATE TABLE  `myblogvoice`.`mbv_forbidden_user_names`
(`forbidden_user_name` varchar(40) NOT NULL default '',
 PRIMARY KEY  (`forbidden_user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `myblogvoice`.`mbv_log`;
CREATE TABLE  `myblogvoice`.`mbv_log`
(`log_id` int(10) unsigned NOT NULL auto_increment,
 `logged_at` datetime NOT NULL default '0000-00-00 00:00:00',
 `function_name` varchar(40) NOT NULL default '',
 `command_text` text NOT NULL,
 `error_text` text NOT NULL,
 `file_name` varchar(40) NOT NULL default '',
 PRIMARY KEY  (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;