








SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";











CREATE TABLE IF NOT EXISTS `twp_blog` (
  `id` bigint(20) NOT NULL auto_increment,
  `type` varchar(4) NOT NULL,
  `title` varchar(500) NOT NULL,
  `posttime` datetime NOT NULL,
  `realposttime` datetime NOT NULL,
  `content` longtext NOT NULL,
  `category` mediumint(9) NOT NULL,
  `tags` varchar(255) NOT NULL,
  `parentid` bigint(20) NOT NULL,
  `excerpt` text NOT NULL,
  `istop` tinyint(1) NOT NULL,
  `ishighlight` tinyint(1) NOT NULL,
  `comment_status` tinyint(1) NOT NULL,
  `modifiedtime` datetime NOT NULL,
  `blog_status` tinyint(4) NOT NULL,
  `count_read` bigint(20) NOT NULL,
  `comment_count` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;





INSERT INTO `twp_blog` (`id`, `type`, `title`, `posttime`, `realposttime`, `content`, `category`, `tags`, `parentid`, `excerpt`, `istop`, `ishighlight`, `comment_status`, `modifiedtime`, `blog_status`, `count_read`, `comment_count`) VALUES
(1, 'blog', 'Welcome to the world of Twinklous', '2008-08-26 22:17:06', '2008-08-26 22:17:06', '<p>感谢使用Twinklous VBlog，您的支持是我们前进的动力。如果有什么问题或者建议，可以到我们论坛提出。</p>\n<p>我们的官方站点是：<a set="yes" linkindex="9" href="http://twinklous.net/">http://twinklous.net/</a></p>', 1, '', 0, '<p>感谢使用Twinklous VBlog，您的支持是我们前进的动力。如果有什么问题或者建议，可以到我们论坛提出。</p>\n<p>我们的官方站点是：<a set="yes" linkindex="9" href="http://twinklous.net/">http://twinklous.net/</a></p>', 0, 0, 1, '2008-08-26 22:17:06', 1, 0, 0),
(2, 'page', '关于', '2008-08-26 22:19:47', '2008-08-26 22:19:47', '<p>这是页面，它和一般日志没什么特别，惟一不同点是页面与导航显示在一起，这样更容易引起注意。</p>', 1, '', 0, '<p>这是页面，它和一般日志没什么特别，惟一不同点是页面与导航显示在一起，这样更容易引起注意。</p>', 0, 0, 1, '2008-08-26 22:19:47', 1, 0, 0);







CREATE TABLE IF NOT EXISTS `twp_cate` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `description` varchar(500) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `order` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;





INSERT INTO `twp_cate` (`id`, `title`, `description`, `count`, `order`) VALUES
(1, '未分类', '还没有分类的日志', 2, 1);







CREATE TABLE IF NOT EXISTS `twp_config` (
  `id` smallint(6) NOT NULL,
  `key` varchar(100) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;





INSERT INTO `twp_config` (`id`, `key`, `value`) VALUES
(1, 'blogname', 'Strongwillow''s Voyage'),
(2, 'blogdescription', 'A brand-new world.'),
(3, 'spamlimit1', '5'),
(4, 'currTheme', 'default'),
(5, 'currSBcate', '一栏全开'),
(6, '切割正文行数作默认excerpt', '3'),
(7, 'tongji', ''),
(8, '备案', '');







CREATE TABLE IF NOT EXISTS `twp_link` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `logo` varchar(200) NOT NULL,
  `count` bigint(20) NOT NULL,
  `order` tinyint(4) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `verified` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;












CREATE TABLE IF NOT EXISTS `twp_post` (
  `id` bigint(20) NOT NULL auto_increment,
  `uid` bigint(20) NOT NULL,
  `blogid` bigint(20) NOT NULL,
  `content` text NOT NULL,
  `reply` text NOT NULL,
  `posttime` datetime NOT NULL,
  `ip` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL default '1',
  `reported` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;












CREATE TABLE IF NOT EXISTS `twp_sbconfig` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `portion` smallint(6) NOT NULL,
  `sbid` mediumint(9) NOT NULL,
  `order` int(11) NOT NULL,
  `isopen` tinyint(1) NOT NULL,
  `disabled` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;





INSERT INTO `twp_sbconfig` (`id`, `name`, `portion`, `sbid`, `order`, `isopen`, `disabled`) VALUES
(1, '一栏全开', 1, 1, 3, 1, 0),
(2, '一栏全开', 1, 2, 5, 1, 0),
(3, '一栏全开', 1, 3, 4, 1, 0),
(4, '一栏全开', 1, 4, 10, 1, 0),
(5, '一栏全开', 1, 5, 2, 1, 0),
(6, '一栏全开', 1, 6, 1, 1, 0),
(7, '一栏全开', 1, 7, 0, 1, 0);







CREATE TABLE IF NOT EXISTS `twp_sidebar` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `html` text NOT NULL,
  `filepath` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;





INSERT INTO `twp_sidebar` (`id`, `name`, `html`, `filepath`) VALUES
(1, 'User Panel', '<p>{{USERPANEL}}</p>', 'plugins/default/sidebar.php'),
(2, 'Recent Post', '<p>{{RECENTPOST}}</p>', 'plugins/default/sidebar.php'),
(3, 'Recent Comments', '<p>{{RECENTCOMMENT}}</p>', 'plugins/default/sidebar.php'),
(4, 'Category', '<p>{{CATEGORY}}</p>', 'plugins/default/sidebar.php'),
(5, 'Statistic', '<p>{{STATISTIC}}</p>', 'plugins/default/sidebar.php'),
(6, 'Link', '<p>{{LINK}}<a href="plugins/link/submit.php">提交链接</a></p>', 'plugins/link/sidebar.php '),
(7, 'Access', '<p><a target="_blank" href="wap.php"><img alt="" src="images/wap.png" /></a> <a target="_blank" href="rss2.php"><img alt="" src="images/rss.png" /></a>  </p>', '');







CREATE TABLE IF NOT EXISTS `twp_statistic` (
  `id` bigint(20) NOT NULL auto_increment,
  `key` varchar(10) NOT NULL,
  `value` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;





INSERT INTO `twp_statistic` (`id`, `key`, `value`) VALUES
(1, 'blog_count', 2),
(2, 'cmt_count', 0),
(3, 'msg_count', 0),
(4, 'usr_count', 0),
(5, 'v_cunt', 0);







CREATE TABLE IF NOT EXISTS `twp_tag` (
  `id` bigint(20) NOT NULL auto_increment,
  `tag` varchar(30) NOT NULL,
  `style` varchar(100) NOT NULL,
  `count` bigint(20) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;












CREATE TABLE IF NOT EXISTS `twp_user` (
  `id` bigint(20) NOT NULL auto_increment,
  `usn` varchar(14) NOT NULL,
  `pwd` varchar(40) NOT NULL,
  `head` varchar(250) NOT NULL,
  `sex` varchar(1) NOT NULL,
  `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `regtime` datetime NOT NULL,
  `logintimes` bigint(20) NOT NULL default '0',
  `comment_count` bigint(20) NOT NULL default '0',
  `message_count` bigint(20) NOT NULL default '0',
  `email` varchar(100) NOT NULL,
  `website` varchar(100) NOT NULL,
  `birthday` varchar(10) NOT NULL,
  `spm` float NOT NULL,
  `addition` varchar(500) NOT NULL,
  `qq` varchar(12) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `usn` (`usn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;





