

-- --------------------------------------------------------

-- 
-- Ľṹ `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_decrip`, `s_msg`) VALUES (19, 'e_port', '25', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (75, 'sercah_num', '10', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (21, 're_content_size', '3', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (22, 'e_conetnt_siae_s', '50000', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (23, 'video_swith', '0', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (24, 'upload_file', 'upload', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (25, 'longin_integral', '2', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (26, 're_post_integral', '10', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (27, 'post_integral', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (28, 'reg_insider', '10', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (29, 'userface_size', '200000', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (30, 'sms_type_url', 'http://sms.86055.com/sms_api.php', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (31, 'sms_switch', '0', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (32, 'Copyright', 'Copyright 2007 - 2008 <a href=''http://production.86055.com'' target=''_blank''>86055.com</a>. ', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (33, 'hotspot', '10', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (34, 'del_userWealth', '100', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (35, 'pink_integral', '10000', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (36, 'email_awoke', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (37, 'scrip_awoke', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (69, 'content_Most', '20000', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (39, 'vote_integral', '10', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (40, 'mencoder', 'D:/mplayer/mplayer/mencoder.exe', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (41, 'cgi_files', 'E:/xmapp/xampp/htdocs/zbbs/', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (42, 'ffmpg_cgi', 'D:/mplayer/mplayer/ffmpeg.exe', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (44, 'waterImage', 'images/vildo.gif', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (45, 'replace_txt', '"ַ"', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (89, 'mobile_sms_user', '', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (68, 'content_least', '8', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (49, 'bank_v_mid', '', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (50, 'bank_md5', '', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (51, 'bank_v_url', '/pay/Receive.php', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (53, 'bank_swith', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (56, 'SmsneedMoney', '0.2', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (57, 'SMSneedIntegral', '20000', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (58, 'Smsleast', '10', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (59, 'is_modetosms', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (60, 'is_ingtosms', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (61, 'is_integral_mode', '0.02', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (62, 'is_moneytointegral', '0', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (63, 'is_integral_am', '10', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (64, 'is_integral_most', '100', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (65, 'integral_pay_Number', '2', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (66, 'is_sms_most', '20', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (67, 'sms_pay_Number', '8', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (70, 'title_Most', '24', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (71, 'title_least', '4', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (72, 'content_least', '8', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (73, 'content_Most', '20000', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (74, 'UP_Remind', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (76, 'Replacement', '****>>', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (77, 'reg_upUserSex', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (78, 'reg_upuserage', '1', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (79, 'Post_Notice_filetype', 'jpg|gif|png', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (80, 'Post_Notice_size', '50000000', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (81, 'Chief_email', 'mmg7@Chief_email.com', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (82, 'stystem_pic', 'images/log.jpg', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (83, 'stystem_swith', '0', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (85, 'textFont', '4', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (84, 'Location_txt', '5', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (90, 'mobile_sms_md5', '', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (91, 'mail_content', '𾴵ûӭ[=stys_name]ǽ߳Ϊ<br />[=mail_url]', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (92, 'reg_cerway', '0', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (94, 'mobile_sms_mandom', '', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (106, 'mobile_sms_umber', '', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (107, 'sms_switch', '0', '', '');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (108, 'wap_log', 'images/waplogo.gif', NULL, 'WAPͼ');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (109, 'wap_switch', '0', NULL, 'Ƿwap?1');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (111, 'wap_user_login', '0', NULL, 'ǷԱ¼,1');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (112, 'Wap_Equipment_browse', '0', NULL, 'Ƿֻ,0п,1ֻֻ');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (113, 'Wap_content_page', '10', NULL, 'ÿٸظΪһҳ');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (114, 'Wap_class_page', '6', NULL, 'ÿٱΪһҳ');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (115, 'wap_images_w', '180', NULL, 'wapͼ');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (116, 'wap_images_h', '200', NULL, 'wapͼ');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (117, 'Wap_reguser', '0', NULL, '01ע');
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (118, 'keywords', 'lisvbbsǿ󣬸Ч̳', NULL, NULL);
INSERT INTO `list_config` (`s_id`, `s_name`, `s_value`, `s_decrip`, `s_msg`) VALUES (119, 'description', 'lisvbbsǿ󣬸Ч', NULL, NULL);

-- --------------------------------------------------------

-- 
-- Ľṹ `list_data_grab`
-- 

CREATE TABLE `list_data_grab` (
  `id` int(9) NOT NULL,
  `project_name` varchar(225) character set gb2312 NOT NULL,
  `website_name` varchar(225) character set gb2312 NOT NULL,
  `website_coding` varchar(225) collate latin1_general_ci NOT NULL,
  `project_add_time` datetime NOT NULL,
  `project_grab_lasttime` datetime NOT NULL,
  `project_bbs_type` int(9) NOT NULL,
  `grab_content_list_url` varchar(225) character set gb2312 NOT NULL,
  `list_start_code` mediumtext character set gb2312 NOT NULL,
  `list_end_code` mediumtext character set gb2312 NOT NULL,
  `link_start_code` mediumtext character set gb2312 NOT NULL,
  `link_end_code` mediumtext character set gb2312 NOT NULL,
  `grab_list_pag` int(9) NOT NULL,
  `title_start_code` mediumtext character set gb2312 NOT NULL,
  `title_end_code` mediumtext character set gb2312 NOT NULL,
  `content_start_code` mediumtext character set gb2312 NOT NULL,
  `content_end_code` mediumtext character set gb2312 NOT NULL,
  `content_link_url_prefix` varchar(225) character set gb2312 NOT NULL default '0',
  `boardid` int(9) NOT NULL,
  `note` mediumtext character set gb2312 NOT NULL,
  `isgroom` int(2) NOT NULL default '0',
  `Ispith` int(2) NOT NULL default '0',
  `filtering_iframe` int(2) NOT NULL default '0',
  `filtering_script` int(2) NOT NULL default '0',
  `filtering_obj` int(2) NOT NULL default '0',
  `filtering_pic` int(2) NOT NULL default '0',
  `filtering_link` int(2) NOT NULL default '0',
  `save_remote_img` int(2) NOT NULL default '0',
  `save_remote_img_directory` varchar(225) collate latin1_general_ci NOT NULL default '0',
  `grab_entries_stop` int(9) NOT NULL default '0',
  `grab_entries_stop_seconds` int(9) NOT NULL,
  `grab_sorting` int(2) NOT NULL default '0',
  `grab_add_time` datetime NOT NULL,
  `grab_add_time_random` int(2) NOT NULL default '1',
  `grab_add_user` varchar(225) character set gb2312 NOT NULL,
  `grab_add_user_random` int(2) NOT NULL default '0',
  `list_page_start` mediumtext character set gb2312 NOT NULL,
  `list_page_end` mediumtext character set gb2312 NOT NULL,
  `list_page_url` varchar(225) character set gb2312 NOT NULL,
  `list_page_id_start` int(9) NOT NULL,
  `list_page_id_end` int(9) NOT NULL,
  `grab_data_table` varchar(225) collate latin1_general_ci NOT NULL,
  `audit` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- 
-- е `list_data_grab`
-- 

INSERT INTO `list_data_grab` (`id`, `project_name`, `website_name`, `website_coding`, `project_add_time`, `project_grab_lasttime`, `project_bbs_type`, `grab_content_list_url`, `list_start_code`, `list_end_code`, `link_start_code`, `link_end_code`, `grab_list_pag`, `title_start_code`, `title_end_code`, `content_start_code`, `content_end_code`, `content_link_url_prefix`, `boardid`, `note`, `isgroom`, `Ispith`, `filtering_iframe`, `filtering_script`, `filtering_obj`, `filtering_pic`, `filtering_link`, `save_remote_img`, `save_remote_img_directory`, `grab_entries_stop`, `grab_entries_stop_seconds`, `grab_sorting`, `grab_add_time`, `grab_add_time_random`, `grab_add_user`, `grab_add_user_random`, `list_page_start`, `list_page_end`, `list_page_url`, `list_page_id_start`, `list_page_id_end`, `grab_data_table`, `audit`) VALUES (2, 'ɼϾѧԺ', 'ϾѧԺ', 'GB2312', '2009-08-11 16:14:54', '2009-08-11 17:03:34', 0, 'http://dept.njarti.edu.cn/sxw/art_list.asp?cat_id=14', '״̬', '<tr><td colspan="4"', '<a href=''0', ''' Title', 2, '600;"><b>', '</b></font></div><br>', '</span>]</div>', '<td><table width="96%" align="center">', 'http://dept.njarti.edu.cn/sxw/', 2, '0', 1, 0, 1, 1, 1, 0, 1, 0, '../upload/grab_pic/', 10, 2, 0, '2009-08-11 11:20:19', 1, '0', 1, '5</a> <a href="', '">һҳ', 'http://dept.njarti.edu.cn/sxw/art_list.asp?cat_id=14&fd=uuy&cc=8&page={ID}&yp=4&hb=3', 1, 2, 'list_bbs_content', 0);
INSERT INTO `list_data_grab` (`id`, `project_name`, `website_name`, `website_coding`, `project_add_time`, `project_grab_lasttime`, `project_bbs_type`, `grab_content_list_url`, `list_start_code`, `list_end_code`, `link_start_code`, `link_end_code`, `grab_list_pag`, `title_start_code`, `title_end_code`, `content_start_code`, `content_end_code`, `content_link_url_prefix`, `boardid`, `note`, `isgroom`, `Ispith`, `filtering_iframe`, `filtering_script`, `filtering_obj`, `filtering_pic`, `filtering_link`, `save_remote_img`, `save_remote_img_directory`, `grab_entries_stop`, `grab_entries_stop_seconds`, `grab_sorting`, `grab_add_time`, `grab_add_time_random`, `grab_add_user`, `grab_add_user_random`, `list_page_start`, `list_page_end`, `list_page_url`, `list_page_id_start`, `list_page_id_end`, `grab_data_table`, `audit`) VALUES (4, 'ɼڴ', 'ڴ', 'GB2312', '2009-08-15 16:25:40', '2009-08-15 16:34:46', 0, 'http://k.pdafans.com/', 'herder_r1_c1.jpg', 'һҳ', '<a href="', '" class="text_25_blue">', 0, '<title>', '-ڴѧ-K.pdafans.com-ڴֻ</title>', '<p class="text_20">', 'Ŀ¼', 'http://k.pdafans.com/', 2, '0', 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, '0000-00-00 00:00:00', 1, '0', 1, '0', '0', '0', 0, 0, 'list_bbs_content', 0);

-- --------------------------------------------------------

-- 
-- Ľṹ `list_disadmin`
-- 

CREATE TABLE `list_disadmin` (
  `id` int(11) NOT NULL auto_increment,
  `admin_name` varchar(225) default NULL,
  `come_pwd` int(2) default '0',
  `come_shooting` int(2) default '0',
  `come_hiding` int(2) default '0' COMMENT 'ʹ',
  `come_sex` int(2) default '0' COMMENT 'ʹ',
  `come_integ` int(2) default '0' COMMENT 'ʹ',
  `come_money` int(2) default '0',
  `is_topic` int(2) default '0',
  `is_MobSms` int(2) default '0',
  `come_tissue` int(2) default '0',
  `come_blacklist` int(2) default '0',
  `come_yes` int(2) default '0',
  `is_Open` int(2) default '0',
  `is_Age` int(11) default '0',
  `is_update` int(2) default '0',
  `is_Slogan` int(2) default '0',
  `is_time_Ban` int(2) default '0',
  `is_Aud` int(2) default '0' COMMENT '',
  `is_noip` int(2) default '0',
  `LockTopic` int(2) default '0',
  `is_delect` int(2) default '0' COMMENT '',
  `is_move` int(2) default '0',
  `is_pith` int(2) default '0',
  `is_pate` int(2) default '0',
  `is_place` int(2) default '0',
  `is_groom` int(2) default '0',
  `BoardMaster` int(2) default '0',
  `is_upreadme` int(2) default '0',
  `is_Reduction` int(2) default '0' COMMENT '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 AUTO_INCREMENT=4 ;

-- 
-- е `list_disadmin`
-- 

INSERT INTO `list_disadmin` (`id`, `admin_name`, `come_pwd`, `come_shooting`, `come_hiding`, `come_sex`, `come_integ`, `come_money`, `is_topic`, `is_MobSms`, `come_tissue`, `come_blacklist`, `come_yes`, `is_Open`, `is_Age`, `is_update`, `is_Slogan`, `is_time_Ban`, `is_Aud`, `is_noip`, `LockTopic`, `is_delect`, `is_move`, `is_pith`, `is_pate`, `is_place`, `is_groom`, `BoardMaster`, `is_upreadme`, `is_Reduction`) VALUES (1, 'ǰ̨Ա', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0);
INSERT INTO `list_disadmin` (`id`, `admin_name`, `come_pwd`, `come_shooting`, `come_hiding`, `come_sex`, `come_integ`, `come_money`, `is_topic`, `is_MobSms`, `come_tissue`, `come_blacklist`, `come_yes`, `is_Open`, `is_Age`, `is_update`, `is_Slogan`, `is_time_Ban`, `is_Aud`, `is_noip`, `LockTopic`, `is_delect`, `is_move`, `is_pith`, `is_pate`, `is_place`, `is_groom`, `BoardMaster`, `is_upreadme`, `is_Reduction`) VALUES (2, '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0);
INSERT INTO `list_disadmin` (`id`, `admin_name`, `come_pwd`, `come_shooting`, `come_hiding`, `come_sex`, `come_integ`, `come_money`, `is_topic`, `is_MobSms`, `come_tissue`, `come_blacklist`, `come_yes`, `is_Open`, `is_Age`, `is_update`, `is_Slogan`, `is_time_Ban`, `is_Aud`, `is_noip`, `LockTopic`, `is_delect`, `is_move`, `is_pith`, `is_pate`, `is_place`, `is_groom`, `BoardMaster`, `is_upreadme`, `is_Reduction`) VALUES (3, '', 1, 1, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 0, 0, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0);

-- --------------------------------------------------------

-- 
-- Ľṹ `list_downlog`
-- 

CREATE TABLE `list_downlog` (
  `id` int(11) NOT NULL auto_increment,
  `topid` int(12) default NULL,
  `boardid` int(12) default NULL,
  `username` varchar(225) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ;

-- 
-- е `list_downlog`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_formula`
-- 

CREATE TABLE `list_formula` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(225) default NULL,
  `integral` int(9) default NULL,
  `affix_integral` int(9) default NULL,
  `crip_integral` int(9) default NULL,
  `integral_s` int(9) default NULL,
  `is_post_audit` int(2) default '0',
  `is_re_audit` int(2) default '0',
  `is_post` int(2) default '1',
  `post_code` int(2) default '1',
  `is_Stealth` int(2) default '1',
  `out_time` int(12) default '10',
  `is_Browse` int(2) default '1',
  `is_Search` int(2) default '1',
  `show_user` int(2) default '1',
  `show_user_Information` int(2) default '1',
  `is_up_head` int(2) default '1',
  `is_Custom_head` int(2) default '1',
  `is_user_Signed` int(2) default '1',
  `is_mobile_sms` int(2) default '1',
  `is_post_mcrip` int(2) default '1',
  `is_post_mycrip_re` int(2) default '1',
  `is_post_mobsms_re` int(2) default '1',
  `is_post_email_re` int(2) default '1',
  `is_Support` int(2) default '1',
  `is_Report` int(2) default '0',
  `is_Opposition` int(2) default '1',
  `quit_cite_email` int(2) default '0',
  `quit_cite_crip` int(2) default '0',
  `quit_hide_UserAvaSetting` int(2) default '0',
  `quit_scarch_ing` int(2) default '0',
  `quit_isaltitude` int(2) default '0',
  `quit_re_code` int(2) default '0',
  `Search_Interval` int(9) default '10',
  `is_Reply` int(2) default '1',
  `is_Vote` int(2) default '1',
  `is_Vote_Participation` int(2) default '1',
  `is_Vote_View` int(2) default '0',
  `Encryption` int(2) default '1',
  `is_Money` int(2) default '1',
  `is_Money_cs` float default '10',
  `vote_Most` int(9) default '10',
  `is_Reply_show` int(2) default '1',
  `is_Anonymous` int(2) default '0',
  `is_reguser` int(2) default '1',
  `del_Own_Posts` int(2) default '0' COMMENT '',
  `up_Own_Posts` int(2) default '1',
  `Most_post` int(12) default '0',
  `is_Upload` int(2) default '1',
  `is_Download` int(2) default '1',
  `is_up_type` varchar(225) default NULL,
  `is_Gender` int(2) default NULL,
  `up_mose` int(12) default '50',
  `Money_is_show` int(2) default '0',
  `type` int(9) default '0',
  `group_img` varchar(225) default '1.gif',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 AUTO_INCREMENT=14 ;

-- 
-- е `list_formula`
-- 

INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (1, 'ο', 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 4, '1.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (7, 'ǰ̨Ա', 0, 0, 0, 0, 0, 0, 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 10, 10, 1, 1, 1, 0, 1, 0, 1, 1, '0', 0, 0, 1, 3, '7.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (2, 'ľ', 10, 100000000, 150, 0, 0, 0, 1, 1, 0, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 10, 1, 1, 1, 0, 1, 1, 10, 10, 1, 0, 1, 0, 1, 0, 1, 1, 'png|jpg', 0, 0, 0, 0, '1.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (3, 'ľ', 500, 1000000000, 200, 0, 0, 0, 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 10, 1, 1, 1, 0, 1, 1, 10, 10, 1, 0, 1, 0, 1, 0, 1, 1, '', 0, 0, 0, 0, '2.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (4, 'ľ޴', 5000, 2147483647, 2000, 0, 0, 0, 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 10, 1, 1, 1, 0, 1, 1, 10, 10, 1, 0, 1, 0, 1, 0, 1, 1, '', 0, 0, 0, 0, '3.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (10, 'ľ޻', 50000, 2147483647, 0, 0, 0, 0, 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 10, 1, 1, 1, 0, 1, 1, 10, 10, 1, 0, 1, 0, 1, 0, 1, 1, '', 0, 0, 0, 0, '4.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (6, 'ľ־', 500000, 0, 200, 0, 0, 0, 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 10, 1, 1, 1, 0, 1, 1, 10, 10, 0, 0, 1, 0, 1, 0, 1, 1, 'jpg|gif', 0, 0, 0, 0, '5.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (8, '', 0, 0, 0, 0, 0, 0, 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 10, 1, 1, 1, 0, 1, 1, 10, 10, 1, 0, 1, 0, 1, 0, 1, 1, '', 0, 0, 0, 1, '11.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (9, '', 0, 2147483647, 0, 0, 0, 0, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 10, 1, 1, 1, 0, 1, 1, 0, 10, 1, 0, 1, 0, 1, 0, 1, 1, '', 0, 0, 0, 2, '6.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (12, 'ľ', 5000000, 0, 0, 0, 0, 0, 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 10, 1, 1, 1, 0, 1, 1, 10, 10, 1, 0, 1, 0, 1, 0, 1, 1, '', 0, 50, 0, 0, '6.gif');
INSERT INTO `list_formula` (`id`, `name`, `integral`, `affix_integral`, `crip_integral`, `integral_s`, `is_post_audit`, `is_re_audit`, `is_post`, `post_code`, `is_Stealth`, `out_time`, `is_Browse`, `is_Search`, `show_user`, `show_user_Information`, `is_up_head`, `is_Custom_head`, `is_user_Signed`, `is_mobile_sms`, `is_post_mcrip`, `is_post_mycrip_re`, `is_post_mobsms_re`, `is_post_email_re`, `is_Support`, `is_Report`, `is_Opposition`, `quit_cite_email`, `quit_cite_crip`, `quit_hide_UserAvaSetting`, `quit_scarch_ing`, `quit_isaltitude`, `quit_re_code`, `Search_Interval`, `is_Reply`, `is_Vote`, `is_Vote_Participation`, `is_Vote_View`, `Encryption`, `is_Money`, `is_Money_cs`, `vote_Most`, `is_Reply_show`, `is_Anonymous`, `is_reguser`, `del_Own_Posts`, `up_Own_Posts`, `Most_post`, `is_Upload`, `is_Download`, `is_up_type`, `is_Gender`, `up_mose`, `Money_is_show`, `type`, `group_img`) VALUES (13, 'ľ֮', 50000000, 0, 0, 0, 0, 0, 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 10, 1, 1, 1, 0, 1, 1, 10, 10, 1, 0, 1, 0, 1, 0, 1, 1, '', 0, 50, 0, 0, '7.gif');

-- --------------------------------------------------------

-- 
-- Ľṹ `list_friend`
-- 

CREATE TABLE `list_friend` (
  `F_id` int(10) NOT NULL auto_increment,
  `F_username` varchar(50) default NULL,
  `F_friend` varchar(50) default NULL,
  `F_addtime` datetime default NULL,
  `F_userid` int(10) default NULL,
  `F_Mod` int(3) default '0' COMMENT '0Ϊδ֤ͨ1ΪѾ֤ͨʽΪ',
  PRIMARY KEY  (`F_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 ROW_FORMAT=FIXED AUTO_INCREMENT=1 ;

-- 
-- е `list_friend`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_grab_list_url`
-- 

CREATE TABLE `list_grab_list_url` (
  `id` int(11) NOT NULL auto_increment,
  `gab_project_id` int(225) NOT NULL,
  `list_url` text collate latin1_general_ci NOT NULL,
  `add_time` datetime NOT NULL,
  `grab_state` int(2) NOT NULL default '0',
  `grab_list_pag` int(9) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

-- 
-- е `list_grab_list_url`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_help`
-- 

CREATE TABLE `list_help` (
  `hid` smallint(6) unsigned NOT NULL auto_increment,
  `hup` smallint(6) unsigned default '0',
  `lv` tinyint(2) default '0',
  `fathers` varchar(100) default '',
  `ifchild` tinyint(1) default '0',
  `title` varchar(80) default '',
  `content` mediumtext,
  `vieworder` tinyint(3) default '0',
  `ispw` tinyint(1) default '0',
  `type` varchar(225) default NULL,
  PRIMARY KEY  (`hid`),
  KEY `hup` (`hup`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;

-- 
-- е `list_help`
-- 

INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (28, 0, 0, 'post_vote', 0, 'ͶƱ', '<p>ҪͶƱϵĲͶƱťԸʽн͡</p>\r\n<p>һ ѡ..', 0, 0, 'content');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (29, 0, 0, 'post_title', 0, '', '<p>Ҫз⣬ע¼</p>\r\n<p>һ⣬Ҳӵ⣬ܳ...\r\n                                       ', 0, 0, 'content');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (30, 0, 0, 'command', 0, '', 'ӭ棬ѡӦĲĿв\r\n			  					  ', 0, 0, 'command');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (31, 0, 0, 'mycrip', 0, '', '					  <p>ֽǱϵͳڸԱͨŵһַʽڴ˲鿴㷢͸˵ֽ˸㷢͵ֽ...				  ', 0, 0, 'command');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (32, 0, 0, 'mobile_sms', 0, '', ' <p>ֻŹϵͳṩһֻԱϵķʽڴ˲鿴صݡ<br>', 0, 0, 'command');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (33, 0, 0, 'mytitle', 0, '', '<p>ⶼڴʾ״̬⣩</p>		  					  ', 0, 0, 'command');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (34, 0, 0, 'my_retitle', 0, '', '<p>Ļظڴʾ״̬Ļظ</p>				  					  ', 0, 0, 'command');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (35, 0, 0, 'myaffix', 0, '', '<br>ϴĸڴ˲鿴ϴĸָʱͨϴܵļ		  					  ', 0, 0, 'command');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (36, 0, 0, 'myinformation', 0, '', '					  <br>\r\nԲ鿴͹ĸϣΪ˸õΪǽдʵϡ					  ', 0, 0, 'command');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (37, 0, 0, 'bbsFriends', 0, '', '<br>\r\nڴ˴鿴ĺѡ<br>\r\n<br>			  					  ', 0, 0, 'command');
INSERT INTO `list_help` (`hid`, `hup`, `lv`, `fathers`, `ifchild`, `title`, `content`, `vieworder`, `ispw`, `type`) VALUES (38, 0, 0, 'Integral', 0, '', '<br>\r\nڴ˴鿴ӵеĲƸǮֻ֡ŵȡ<br>\r\n<br>			  					  ', 0, 0, 'command');

-- --------------------------------------------------------

-- 
-- Ľṹ `list_key`
-- 

CREATE TABLE `list_key` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(150) default NULL,
  `key_body` varchar(225) default NULL,
  `key_type` int(2) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 AUTO_INCREMENT=19 ;

-- 
-- е `list_key`
-- 

INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (9, '', '', 0);
INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (6, '', '', 0);
INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (7, '', '', 1);
INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (8, '', '', 1);
INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (10, '', '', 0);
INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (11, '', '', 0);
INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (12, '', 'ë', 0);
INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (13, '', 'ƨ', 0);
INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (17, '', 'ǿ', 1);
INSERT INTO `list_key` (`id`, `name`, `key_body`, `key_type`) VALUES (18, '', 'ɫ', 1);

-- --------------------------------------------------------

-- 
-- Ľṹ `list_log`
-- 

CREATE TABLE `list_log` (
  `l_id` int(10) NOT NULL auto_increment,
  `l_announceid` varchar(225) default NULL,
  `l_boardid` int(10) default NULL,
  `l_touser` varchar(225) default NULL,
  `l_username` varchar(50) default NULL,
  `l_content` longtext,
  `l_addtime` datetime default NULL,
  `l_ip` varchar(40) default NULL,
  `l_type` tinyint(3) unsigned default NULL,
  `topid` int(12) default NULL,
  PRIMARY KEY  (`l_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 ROW_FORMAT=FIXED AUTO_INCREMENT=1 ;

-- 
-- е `list_log`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_menu`
-- 

CREATE TABLE `list_menu` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `parent_id` int(10) default NULL,
  `ParentStr` varchar(255) default NULL,
  `Depth` smallint(5) default NULL,
  `RootID` int(10) default NULL,
  `Child` smallint(5) default NULL,
  `readme` mediumtext,
  `BoardMaster` varchar(250) default NULL,
  `PostNum` int(10) default NULL,
  `TopicNum` int(10) default NULL,
  `indexIMG` varchar(255) default NULL,
  `del_integral` int(10) default '0',
  `pink_integral` int(10) default '10',
  `boarduser` longtext,
  `Orders` int(10) default NULL,
  `sid` int(10) default NULL,
  `user_integral` int(10) default '0',
  `post_integral` int(200) default '0',
  `re_post_integral` int(10) default '0',
  `CID` tinyint(3) unsigned default NULL,
  `down_affix_integral` int(2) default '0',
  `up_affix_integral` int(12) default '0',
  `poll_purview` int(9) default '0',
  `post_anonymity` int(2) default '0',
  `repost_anonymity` int(12) default '10',
  `is_Open` int(2) default '0',
  `is_password` varchar(225) default NULL,
  `Come_Issue` varchar(225) default NULL,
  `Come_Answer` varchar(225) default NULL,
  `Come_Gender` int(2) default '0',
  `Come_Posts` int(12) default NULL,
  `Come_Money` float default NULL,
  `Come_Sms` int(12) default '0',
  `Come_Age_s` datetime default NULL,
  `Come_Age_y` datetime default NULL,
  `Come_Group` varchar(225) default NULL,
  `Come_Blacklist` mediumtext,
  `Come_IP_Restrictions` mediumtext,
  `Slogan` varchar(16) default NULL COMMENT 'ں',
  `time_Ban_post` varchar(225) default NULL,
  `comment_open` int(2) NOT NULL default '0' COMMENT 'ģʽǷ0',
  `comment_certification_url` varchar(225) default NULL COMMENT 'Դַ֤',
  `comment_certification_ur_integral` int(9) default '10' COMMENT 'ҪĻ',
  `comment_audit_tourists` int(9) NOT NULL default '1' COMMENT 'ǷҪˣο',
  `comment_audit_user` int(9) NOT NULL default '0' COMMENT 'ǷҪˣԻԱ0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 ROW_FORMAT=FIXED AUTO_INCREMENT=9 ;

-- 
-- е `list_menu`
-- 

INSERT INTO `list_menu` (`id`, `name`, `parent_id`, `ParentStr`, `Depth`, `RootID`, `Child`, `readme`, `BoardMaster`, `PostNum`, `TopicNum`, `indexIMG`, `del_integral`, `pink_integral`, `boarduser`, `Orders`, `sid`, `user_integral`, `post_integral`, `re_post_integral`, `CID`, `down_affix_integral`, `up_affix_integral`, `poll_purview`, `post_anonymity`, `repost_anonymity`, `is_Open`, `is_password`, `Come_Issue`, `Come_Answer`, `Come_Gender`, `Come_Posts`, `Come_Money`, `Come_Sms`, `Come_Age_s`, `Come_Age_y`, `Come_Group`, `Come_Blacklist`, `Come_IP_Restrictions`, `Slogan`, `time_Ban_post`, `comment_open`, `comment_certification_url`, `comment_certification_ur_integral`, `comment_audit_tourists`, `comment_audit_user`) VALUES (1, 'ĬϷ', 0, '0', 0, 1, NULL, NULL, 'admin', NULL, NULL, NULL, 0, 10, NULL, NULL, NULL, 0, 0, 0, NULL, 0, 0, 0, 0, 10, 0, '', '', '', 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '', '', '', 0, NULL, NULL, 1, 0);
INSERT INTO `list_menu` (`id`, `name`, `parent_id`, `ParentStr`, `Depth`, `RootID`, `Child`, `readme`, `BoardMaster`, `PostNum`, `TopicNum`, `indexIMG`, `del_integral`, `pink_integral`, `boarduser`, `Orders`, `sid`, `user_integral`, `post_integral`, `re_post_integral`, `CID`, `down_affix_integral`, `up_affix_integral`, `poll_purview`, `post_anonymity`, `repost_anonymity`, `is_Open`, `is_password`, `Come_Issue`, `Come_Answer`, `Come_Gender`, `Come_Posts`, `Come_Money`, `Come_Sms`, `Come_Age_s`, `Come_Age_y`, `Come_Group`, `Come_Blacklist`, `Come_IP_Restrictions`, `Slogan`, `time_Ban_post`, `comment_open`, `comment_certification_url`, `comment_certification_ur_integral`, `comment_audit_tourists`, `comment_audit_user`) VALUES (2, 'Ĭϰ', 1, '1', 1, 0, NULL, 'Ĭϰ,,뷢Ϣ', 'ceiba', NULL, NULL, 'images/lisvbbs_3/2.jpg', 10, 10, NULL, 1, NULL, 0, 2, 1, 0, 0, 1, 0, 0, 10, 0, '', '', '', 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '', '', '', 1, 'http://www.86055.com', 12, 1, 0);

-- --------------------------------------------------------

-- 
-- Ľṹ `list_message`
-- 

CREATE TABLE `list_message` (
  `id` int(10) NOT NULL auto_increment,
  `sender` varchar(50) default NULL,
  `incept` varchar(50) default NULL,
  `title` varchar(225) default NULL,
  `content` mediumtext,
  `flag` int(10) default NULL,
  `sendtime` datetime default NULL,
  `sms_type` int(10) default '0',
  `delS` int(10) default NULL,
  `isSend` int(2) default '0',
  `is_Click` int(2) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 ROW_FORMAT=FIXED AUTO_INCREMENT=1 ;

-- 
-- е `list_message`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_online`
-- 

CREATE TABLE `list_online` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) default NULL,
  `userclass` varchar(20) default NULL,
  `stats` varchar(250) default NULL,
  `ip` varchar(20) default NULL,
  `is_Online` int(3) default '0',
  `startime` datetime default NULL,
  `lastimebk` varchar(225) default NULL,
  `boardid` int(10) default NULL,
  `browser` varchar(200) default NULL,
  `UserGroupID` int(10) default NULL,
  `actCome` varchar(50) default NULL,
  `userhidden` int(10) default NULL,
  `userid` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 ROW_FORMAT=FIXED AUTO_INCREMENT=107 ;

-- 
-- е `list_online`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_pay`
-- 

CREATE TABLE `list_pay` (
  `id` int(9) NOT NULL auto_increment,
  `bank_name` varchar(225) default NULL,
  `bank_url` longtext,
  `bank_as` int(9) default NULL,
  `bank_time` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 AUTO_INCREMENT=3 ;

-- 
-- е `list_pay`
-- 

INSERT INTO `list_pay` (`id`, `bank_name`, `bank_url`, `bank_as`, `bank_time`) VALUES (1, '', '../pay/Send.php', 1, '2008-05-31 15:21:29');
INSERT INTO `list_pay` (`id`, `bank_name`, `bank_url`, `bank_as`, `bank_time`) VALUES (2, '֧', '', 2, '2008-05-31 15:31:32');

-- --------------------------------------------------------

-- 
-- Ľṹ `list_poll`
-- 

CREATE TABLE `list_poll` (
  `ID` int(11) NOT NULL auto_increment,
  `pid` int(11) default '0',
  `tptitle` varchar(250) default NULL,
  `tpnl` char(255) default NULL,
  `piaoshu` int(11) default '0',
  `username` char(50) default NULL,
  `pttime` datetime default NULL,
  `bgtime` int(9) default NULL,
  `edtime` datetime default NULL,
  `tptype` int(3) default '1',
  `is_delete` int(2) default '0',
  `vote_is_show` int(2) default '0',
  `upvote_Own` int(2) default '0',
  `vote_Most` int(9) default '0',
  PRIMARY KEY  (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `list_poll`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_poll_ip`
-- 

CREATE TABLE `list_poll_ip` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(11) default '0',
  `poll_user` char(15) default NULL,
  `poll_user_ip` char(18) default NULL,
  `poll_date` datetime default NULL,
  `mid` int(12) default NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `list_poll_ip`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_regcontrol`
-- 

CREATE TABLE `list_regcontrol` (
  `s_id` int(11) NOT NULL auto_increment,
  `s_name` varchar(225) default NULL,
  `s_value` int(2) default NULL,
  `s_msg` varchar(225) default NULL,
  PRIMARY KEY  (`s_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 AUTO_INCREMENT=12 ;

-- 
-- е `list_regcontrol`
-- 

INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (1, 'reg_swith', 1, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (2, 'mobile_no', 0, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (3, 'IDcard', 0, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (4, 'Age', 0, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (5, 'Gender', 1, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (6, 'email', 1, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (7, 'Protection_Issue', 1, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (8, 'qq', 0, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (9, 'Bank', 0, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (10, 'msn', 0, '');
INSERT INTO `list_regcontrol` (`s_id`, `s_name`, `s_value`, `s_msg`) VALUES (11, 'url', 0, '');

-- --------------------------------------------------------

-- 
-- Ľṹ `list_reply_tag`
-- 

CREATE TABLE `list_reply_tag` (
  `id` int(11) NOT NULL auto_increment,
  `re_user` varchar(225) default NULL,
  `post_user` varchar(225) default NULL,
  `re_datime` varchar(225) default NULL,
  `topid` int(12) default NULL,
  `sid` int(12) default NULL,
  `boardid` int(12) default NULL,
  `tbale_name` varchar(225) default NULL,
  `is_Audit` int(2) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ;

-- 
-- е `list_reply_tag`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_report`
-- 

CREATE TABLE `list_report` (
  `id` int(11) NOT NULL auto_increment,
  `topid` int(11) default NULL,
  `sid` int(12) default NULL COMMENT 'ID',
  `boardid` int(11) default NULL,
  `username` varchar(225) default NULL,
  `time` datetime default NULL,
  `content` longtext,
  `Emergency` int(2) default NULL,
  `type` int(11) default NULL,
  `topic_type` int(2) default '0',
  `is_Audit` int(2) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ;

-- 
-- е `list_report`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_safety`
-- 

CREATE TABLE `list_safety` (
  `id` int(11) NOT NULL auto_increment,
  `safety_name` text,
  `safety_type` int(2) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 AUTO_INCREMENT=3 ;

-- 
-- е `list_safety`
-- 

INSERT INTO `list_safety` (`id`, `safety_name`, `safety_type`) VALUES (1, '123.7.9.5\r\n2233', 0);
INSERT INTO `list_safety` (`id`, `safety_name`, `safety_type`) VALUES (2, '125.33.69.00\r\n555', 1);

-- --------------------------------------------------------

-- 
-- Ľṹ `list_stencil`
-- 

CREATE TABLE `list_stencil` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(250) default NULL,
  `body` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 AUTO_INCREMENT=2 ;

-- 
-- е `list_stencil`
-- 

INSERT INTO `list_stencil` (`id`, `title`, `body`) VALUES (1, '̳Ĭ', '<table width="100%" height="24" border="0" align="center" cellspacing="1" bgcolor="#85AFFE">\r\n  <tr>\r\n    <td width="7%" align="center" bgcolor="#DEE4FE">׳̬</td>\r\n    <td width="45%" align="center" bgcolor="#DEE4FE"><span class=infodata_title>$rt[4]</span></td>\r\n    <td width="18%" align="center" bgcolor="#DEE4FE"></td>\r\n    <td width="5%" align="center" bgcolor="#DEE4FE">ظ</td>\r\n    <td width="4%" align="center" bgcolor="#DEE4FE"></td>\r\n    <td width="21%" align="center" bgcolor="#DEE4FE">ظ</td>\r\n  </tr>\r\n</table>');

-- --------------------------------------------------------

-- 
-- Ľṹ `list_title`
-- 

CREATE TABLE `list_title` (
  `TopicID` int(10) NOT NULL default '0',
  `Title` varchar(255) default NULL,
  `Boardid` int(10) default NULL,
  `PollID` int(10) default NULL,
  `LockTopic` int(10) default NULL,
  `Child` int(10) default '0',
  `PostUsername` varchar(50) default NULL,
  `PostUserid` int(10) default NULL,
  `DateAndTime` datetime default NULL,
  `hits` int(10) default '1',
  `Expression` varchar(100) default NULL,
  `VoteTotal` int(10) default NULL,
  `LastPostTime` datetime default NULL,
  `resposes_name` varchar(225) default NULL,
  `is_pic` int(2) default '0',
  `is_play` int(2) default '0',
  `is_accessories` int(2) default '0',
  `is_swf` int(2) default '0',
  `istop` tinyint(3) unsigned default NULL,
  `isvote` tinyint(3) unsigned default NULL,
  `isbest` tinyint(3) unsigned default NULL,
  `PostTable` varchar(125) default NULL,
  `isgroom` int(11) default '0',
  `Ispith` int(3) default '0',
  `is_ballot` int(9) default '0',
  `LastSmsTime` datetime default NULL,
  `TopicMode` tinyint(3) unsigned default NULL,
  `Mode` smallint(5) default '0',
  `GetMoneyType` tinyint(3) unsigned default NULL,
  `HideName` tinyint(3) unsigned default NULL,
  `titlecolor` varchar(150) default NULL,
  `post_breast` varchar(200) default NULL,
  `police` int(12) default NULL,
  `IP` varchar(225) default NULL,
  `comment_id` varchar(225) NOT NULL COMMENT 'ģʽ£µΨһID֧ģΨһֵظ',
  PRIMARY KEY  (`TopicID`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 ROW_FORMAT=FIXED;

-- 
-- е `list_title`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_upload`
-- 

CREATE TABLE `list_upload` (
  `id` int(11) NOT NULL auto_increment,
  `upload_pic` char(80) default NULL,
  `indate` datetime default NULL,
  `file_type` int(11) default '0',
  `upload_size` int(11) default '0',
  `upload_ext` char(10) default NULL,
  `userid` varchar(225) default NULL,
  `upload_htm` char(80) default NULL,
  `sign` int(11) default '0',
  `pic_note` char(200) default NULL,
  `photo_name` char(20) default NULL,
  `photo_bg_blog` int(11) default '0',
  `photo_pl_num` int(11) default '0',
  `bbs_blog_type` int(11) default '0',
  `clubuser_id` int(11) default '0',
  `flv_fileid` int(9) default '0',
  `boardid` int(12) default NULL,
  PRIMARY KEY  (`id`),
  KEY `clubuser_id` (`clubuser_id`),
  KEY `id` (`id`),
  KEY `photo_pl_num` (`photo_pl_num`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

-- 
-- е `list_upload`
-- 


-- --------------------------------------------------------

-- 
-- Ľṹ `list_user`
-- 

CREATE TABLE `list_user` (
  `UserID` int(10) NOT NULL auto_increment,
  `UserName` varchar(50) default NULL,
  `UserPassword` varchar(20) default NULL,
  `UserEmail` varchar(255) default NULL,
  `UserPost` int(10) default NULL,
  `UserTopic` int(10) default NULL,
  `UserSign` int(2) default '0',
  `UserSex` tinyint(3) unsigned default NULL,
  `UserFace` varchar(255) default NULL,
  `UserWidth` int(10) default NULL,
  `UserHeight` int(10) default NULL,
  `JoinDate` datetime default NULL,
  `LastLogin` datetime default NULL,
  `UserLogins` int(10) default NULL,
  `UserViews` int(10) default NULL,
  `LockUser` tinyint(3) unsigned default NULL,
  `UserClass` varchar(20) default NULL,
  `UserGroup` varchar(50) default NULL,
  `UserMoney` float default NULL,
  `UserTicket` int(10) default NULL,
  `userWealth` int(10) default NULL,
  `user_sms` int(10) default '0',
  `userCP` int(10) default NULL,
  `UserPower` int(10) default NULL,
  `UserDel` int(10) default NULL,
  `UserIsBest` int(10) default '0',
  `UserTitle` varchar(50) default NULL,
  `UserBirthday` varchar(50) default NULL,
  `UserQuesion` varchar(50) default NULL,
  `UserAnswer` varchar(225) default NULL,
  `UserLastIP` varchar(30) default NULL,
  `is_friend` int(2) default '0',
  `userIssue` varchar(255) default NULL,
  `friendAudit` int(2) default '0',
  `UserInfo` varchar(225) default NULL,
  `UserSetting` varchar(255) default NULL,
  `UserGroupID` int(10) default NULL,
  `TitlePic` varchar(50) default NULL,
  `UserHidden` tinyint(3) unsigned default NULL,
  `UserMsg` varchar(100) default NULL,
  `IsChallenge` tinyint(3) unsigned default NULL,
  `UserMobile` varchar(20) default NULL,
  `is_mobilesms` int(2) default '0',
  `TruePassWord` varchar(225) default NULL,
  `UserToday` varchar(250) default NULL,
  `UserAliases` varchar(25) default NULL,
  `UserAvaSetting` longtext,
  `FollowMsgID` longtext,
  `Vip_StarTime` datetime default NULL,
  `IDcard` int(60) default NULL,
  `user_ismycript` int(2) default '1',
  `user_ismobile` int(2) default '0',
  `userqq` int(16) default NULL,
  `usermsn` varchar(225) default NULL,
  `UserUrl` varchar(250) default NULL,
  `UserAudit` int(2) default '0',
  `Including_msg_txt` mediumtext,
  `Reply_quantity` int(12) default NULL COMMENT ' ',
  `Friends_msgtxt` int(2) default NULL,
  `userbank` varchar(225) default NULL,
  `bankname` varchar(225) default NULL,
  `Random_str` varchar(225) default NULL,
  PRIMARY KEY  (`UserID`)
) ENGINE=MyISAM  DEFAULT CHARSET=gb2312 ROW_FORMAT=FIXED AUTO_INCREMENT=4 ;

-- 
-- е `list_user`
-- 

INSERT INTO `list_user` (`UserID`, `UserName`, `UserPassword`, `UserEmail`, `UserPost`, `UserTopic`, `UserSign`, `UserSex`, `UserFace`, `UserWidth`, `UserHeight`, `JoinDate`, `LastLogin`, `UserLogins`, `UserViews`, `LockUser`, `UserClass`, `UserGroup`, `UserMoney`, `UserTicket`, `userWealth`, `user_sms`, `userCP`, `UserPower`, `UserDel`, `UserIsBest`, `UserTitle`, `UserBirthday`, `UserQuesion`, `UserAnswer`, `UserLastIP`, `is_friend`, `userIssue`, `friendAudit`, `UserInfo`, `UserSetting`, `UserGroupID`, `TitlePic`, `UserHidden`, `UserMsg`, `IsChallenge`, `UserMobile`, `is_mobilesms`, `TruePassWord`, `UserToday`, `UserAliases`, `UserAvaSetting`, `FollowMsgID`, `Vip_StarTime`, `IDcard`, `user_ismycript`, `user_ismobile`, `userqq`, `usermsn`, `UserUrl`, `UserAudit`, `Including_msg_txt`, `Reply_quantity`, `Friends_msgtxt`, `userbank`, `bankname`, `Random_str`) VALUES (1, 'user_name_name', 'pass_word_469e80d32c0559f8', '0', 0, NULL, 0, 1, '/user/userface/upface/ceiba_face.jpg', NULL, NULL, 'p_add_time', 'p_add_time', 0, NULL, NULL, '3', NULL, NULL, NULL, 673, 0, NULL, NULL, NULL, 3, NULL, '--', '0', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 0, 'eNMb4F7FD', NULL, '0', '0', NULL, NULL, 0, 1, 0, 0, '0', '0', 0, '', 0, 0, '', '', '');
