-- --------------------------------------------------------
--
-- 表的结构 `list_ad_content`
--
CREATE TABLE `list_ad_content` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(225) NOT NULL,
`ad_content` mediumtext NOT NULL,
`ad_addtime` datetime NOT NULL,
`ad_link` varchar(225) NOT NULL,
`likn_clew` varchar(225) NOT NULL,
`LinkTarget` int(9) NOT NULL default '1',
`ad_type` int(9) NOT NULL default '0' COMMENT '1为图片,2flas,3文本,4代码,5页面',
`ad_img` varchar(225) NOT NULL,
`CountClick` varchar(225) NOT NULL,
`ad_click` int(9) NOT NULL default '0' COMMENT '点击',
`CountView` varchar(225) NOT NULL,
`info_number` int(9) NOT NULL default '0',
`ad_width` varchar(225) NOT NULL,
`ad_height` varchar(225) NOT NULL,
`FlashWmode` int(9) NOT NULL default '0',
`ad_project_id` int(9) NOT NULL default '0',
`Priority` int(9) NOT NULL,
`ad_audit_audit` int(9) NOT NULL default '0' COMMENT '1为审核,0为未审核',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=29 ;
--
-- 导出表中的数据 `list_ad_content`
--
-- --------------------------------------------------------
--
-- 表的结构 `list_ad_project`
--
CREATE TABLE `list_ad_project` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(225) character set gb2312 NOT NULL,
`ad_type` int(9) NOT NULL,
`ad_note` mediumtext character set gb2312 NOT NULL,
`ad_width` int(9) NOT NULL default '0',
`ad_height` int(9) NOT NULL default '0',
`ad_addtime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ;
--
-- 导出表中的数据 `list_ad_project`
--
INSERT INTO `list_ad_project` (`id`, `title`, `ad_type`, `ad_note`, `ad_width`, `ad_height`, `ad_addtime`) VALUES (9, '系统右下角广告', 4, '0', 0, 0, '2009-08-13 01:29:26');
-- --------------------------------------------------------
--
-- 表的结构 `list_admin`
--
CREATE TABLE `list_admin` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(225) default NULL,
`password` varchar(225) default NULL,
`user_name` varchar(225) default NULL,
`type` int(2) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=2 ;
--
-- 导出表中的数据 `list_admin`
--
INSERT INTO `list_admin` (`id`, `name`, `password`, `user_name`, `type`) VALUES (1, 'admin_username', '7fef6171469e80d32c0559f88b377245', 'corresponding_user', 0);
-- --------------------------------------------------------
--
-- 表的结构 `list_bbs_content`
--
CREATE TABLE `list_bbs_content` (
`AnnounceID` int(10) NOT NULL auto_increment,
`ParentID` int(10) default NULL,
`BoardID` int(10) default NULL,
`UserName` varchar(50) default NULL,
`Topic` varchar(255) default NULL,
`Body` longtext,
`DateAndTime` datetime default NULL,
`length` int(10) default NULL,
`RootID` int(10) default NULL,
`layer` smallint(5) default NULL,
`orders` int(10) default NULL,
`isbest` tinyint(3) unsigned default NULL,
`ip` varchar(40) default NULL,
`Expression` varchar(100) default NULL,
`locktopic` int(10) default NULL,
`signflag` tinyint(3) unsigned default NULL,
`emailflag` tinyint(3) unsigned default NULL,
`isagree` varchar(50) default NULL,
`PostUserID` int(10) default NULL,
`IsAudit` tinyint(2) unsigned default '0',
`IsUpload` tinyint(3) unsigned default NULL,
`PostBuyUser` longtext,
`amend_msg` varchar(255) default NULL,
`GetMoney` int(10) default NULL,
`bear` int(9) default '0',
`police` int(9) default '0',
`depreciate` int(9) default '0',
`re_message_type` int(9) default '0',
`restore_inform_email` int(2) default '0',
`restore_inform_scrip` int(2) default '0',
`hide_idiograph` int(2) default '0',
`forbid_search` int(2) default '0',
`is_reguser` int(2) default '0',
`Encryption` int(12) default '0',
`is_Money` float default '0' COMMENT ' ',
`cl_id` varchar(100) character set latin1 collate latin1_general_ci default NULL,
PRIMARY KEY (`AnnounceID`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 ROW_FORMAT=FIXED COMMENT='论坛主贴表' AUTO_INCREMENT=1 ;
--
-- 导出表中的数据 `list_bbs_content`
--
-- --------------------------------------------------------
--
-- 表的结构 `list_collection`
--
CREATE TABLE `list_collection` (
`id` int(9) NOT NULL auto_increment,
`boardid` int(12) default NULL,
`topid` int(12) default NULL,
`titleid` int(12) default NULL,
`username` varchar(225) default NULL,
`type` int(2) default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ;
--
-- 导出表中的数据 `list_collection`
--
-- --------------------------------------------------------
--
-- 表的结构 `list_comudgement`
--
CREATE TABLE `list_comudgement` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) default NULL,
`Pay_Need` float default '0',
`boardid` int(12) default NULL,
`topic_id` int(12) default NULL COMMENT '帖子ID',
`is_delect` int(2) default '0',
`Pay_username` varchar(225) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ;
--
-- 导出表中的数据 `list_comudgement`
--
-- --------------------------------------------------------
--
-- 表的结构 `list_config`
--
CREATE TABLE `list_config` (
`s_id` int(11) NOT NULL auto_increment,
`s_name` varchar(225) default NULL,
`s_value` varchar(225) default '0',
`s_decrip` varchar(225) default NULL,
`s_msg` varchar(225) default NULL,
PRIMARY KEY (`s_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=120 ;
--
-- 导出表中的数据 `list_config`
--
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (1, 'style_name', 'style_name_bbs', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (2, 'bbs_name', 'list_bbs_content', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (3, 'bbs_smtp', 'mail.163.com', '', ' .');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (4, 'bbs_email', 'mmg7@163.com', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (5, 'pagesize', '20', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (6, 'email_user', '', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (7, 'email_pwd', '', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (8, 'watermark_txt', 'bbs.86055.com/', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (10, 'watermark_off', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (11, 'file_type', 'jpg|gif|rar|zip|swf|wmv|3gp|mp3|mp4|rm|', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (12, 'file_size', '20000000', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (13, 'reg_email', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (14, 'cache_time', '43800', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (15, 'cen_pagesize', '5', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (16, 'url', 'http://localhost/zbbs', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (17, 'watermark_type', '0', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (18, 'watermark_color', '#000000', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_d