-- -- 表的结构 `cdb_access` -- DROP TABLE IF EXISTS cdb_access; CREATE TABLE cdb_access ( uid mediumint(8) unsigned NOT NULL default '0', fid smallint(6) unsigned NOT NULL default '0', allowview tinyint(1) NOT NULL default '0', allowpost tinyint(1) NOT NULL default '0', allowreply tinyint(1) NOT NULL default '0', allowgetattach tinyint(1) NOT NULL default '0', allowpostattach tinyint(1) NOT NULL default '0', PRIMARY KEY (uid,fid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_access` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_activities` -- DROP TABLE IF EXISTS cdb_activities; CREATE TABLE cdb_activities ( tid mediumint(8) unsigned NOT NULL default '0', uid mediumint(8) unsigned NOT NULL default '0', cost mediumint(8) unsigned NOT NULL default '0', starttimefrom int(10) unsigned NOT NULL default '0', starttimeto int(10) unsigned NOT NULL default '0', place char(40) NOT NULL default '', class char(20) NOT NULL default '', gender tinyint(1) NOT NULL default '0', number smallint(5) unsigned NOT NULL default '0', expiration int(10) unsigned NOT NULL default '0', PRIMARY KEY (tid), KEY uid (uid,starttimefrom) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_activities` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_activityapplies` -- DROP TABLE IF EXISTS cdb_activityapplies; CREATE TABLE cdb_activityapplies ( applyid int(10) unsigned NOT NULL auto_increment, tid mediumint(8) unsigned NOT NULL default '0', username char(15) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', message char(200) NOT NULL default '', verified tinyint(1) NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', payment mediumint(8) NOT NULL default '0', PRIMARY KEY (applyid), KEY uid (uid), KEY tid (tid), KEY dateline (tid,dateline) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- 导出表中的数据 `cdb_activityapplies` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_adminactions` -- DROP TABLE IF EXISTS cdb_adminactions; CREATE TABLE cdb_adminactions ( admingid smallint(6) unsigned NOT NULL default '0', disabledactions text NOT NULL, PRIMARY KEY (admingid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_adminactions` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_admingroups` -- DROP TABLE IF EXISTS cdb_admingroups; CREATE TABLE cdb_admingroups ( admingid smallint(6) unsigned NOT NULL default '0', alloweditpost tinyint(1) NOT NULL default '0', alloweditpoll tinyint(1) NOT NULL default '0', allowstickthread tinyint(1) NOT NULL default '0', allowmodpost tinyint(1) NOT NULL default '0', allowdelpost tinyint(1) NOT NULL default '0', allowmassprune tinyint(1) NOT NULL default '0', allowrefund tinyint(1) NOT NULL default '0', allowcensorword tinyint(1) NOT NULL default '0', allowviewip tinyint(1) NOT NULL default '0', allowbanip tinyint(1) NOT NULL default '0', allowedituser tinyint(1) NOT NULL default '0', allowmoduser tinyint(1) NOT NULL default '0', allowbanuser tinyint(1) NOT NULL default '0', allowpostannounce tinyint(1) NOT NULL default '0', allowviewlog tinyint(1) NOT NULL default '0', disablepostctrl tinyint(1) NOT NULL default '0', supe_allowpushthread tinyint(1) NOT NULL default '0', PRIMARY KEY (admingid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_admingroups` -- INSERT INTO cdb_admingroups VALUES (1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1); INSERT INTO cdb_admingroups VALUES (2, 1, 0, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0); INSERT INTO cdb_admingroups VALUES (3, 1, 0, 1, 1, 1, 0, 0, 0, 1, 0, 0, 1, 1, 0, 0, 1, 0); -- -------------------------------------------------------- -- -- 表的结构 `cdb_adminnotes` -- DROP TABLE IF EXISTS cdb_adminnotes; CREATE TABLE cdb_adminnotes ( id mediumint(8) unsigned NOT NULL auto_increment, admin varchar(15) NOT NULL default '', access tinyint(3) NOT NULL default '0', adminid tinyint(3) NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', expiration int(10) unsigned NOT NULL default '0', message text NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_adminnotes` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_adminsessions` -- DROP TABLE IF EXISTS cdb_adminsessions; CREATE TABLE cdb_adminsessions ( uid mediumint(8) unsigned NOT NULL default '0', ip char(15) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', errorcount tinyint(1) NOT NULL default '0' ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_adminsessions` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_advertisements` -- DROP TABLE IF EXISTS cdb_advertisements; CREATE TABLE cdb_advertisements ( advid mediumint(8) unsigned NOT NULL auto_increment, available tinyint(1) NOT NULL default '0', `type` varchar(50) NOT NULL default '0', displayorder tinyint(3) NOT NULL default '0', title varchar(50) NOT NULL default '', targets text NOT NULL, parameters text NOT NULL, `code` text NOT NULL, starttime int(10) unsigned NOT NULL default '0', endtime int(10) unsigned NOT NULL default '0', PRIMARY KEY (advid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_advertisements` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_announcements` -- DROP TABLE IF EXISTS cdb_announcements; CREATE TABLE cdb_announcements ( id smallint(6) unsigned NOT NULL auto_increment, author varchar(15) NOT NULL default '', `subject` varchar(250) NOT NULL default '', redirect tinyint(1) NOT NULL default '0', displayorder tinyint(3) NOT NULL default '0', starttime int(10) unsigned NOT NULL default '0', endtime int(10) unsigned NOT NULL default '0', message text NOT NULL, PRIMARY KEY (id), KEY timespan (starttime,endtime) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_announcements` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_attachments` -- DROP TABLE IF EXISTS cdb_attachments; CREATE TABLE cdb_attachments ( aid mediumint(8) unsigned NOT NULL auto_increment, tid mediumint(8) unsigned NOT NULL default '0', pid int(10) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', readperm tinyint(3) unsigned NOT NULL default '0', filename char(100) NOT NULL default '', description char(100) NOT NULL default '', filetype char(50) NOT NULL default '', filesize int(10) unsigned NOT NULL default '0', attachment char(100) NOT NULL default '', downloads mediumint(8) NOT NULL default '0', isimage tinyint(1) unsigned NOT NULL default '0', uid mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (aid), KEY tid (tid), KEY pid (pid,aid), KEY uid (uid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_attachments` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_attachtypes` -- DROP TABLE IF EXISTS cdb_attachtypes; CREATE TABLE cdb_attachtypes ( id smallint(6) unsigned NOT NULL auto_increment, extension char(12) NOT NULL default '', maxsize int(10) unsigned NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_attachtypes` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_banned` -- DROP TABLE IF EXISTS cdb_banned; CREATE TABLE cdb_banned ( id smallint(6) unsigned NOT NULL auto_increment, ip1 smallint(3) NOT NULL default '0', ip2 smallint(3) NOT NULL default '0', ip3 smallint(3) NOT NULL default '0', ip4 smallint(3) NOT NULL default '0', admin varchar(15) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', expiration int(10) unsigned NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_banned` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_bbcodes` -- DROP TABLE IF EXISTS cdb_bbcodes; CREATE TABLE cdb_bbcodes ( id mediumint(8) unsigned NOT NULL auto_increment, available tinyint(1) NOT NULL default '0', tag varchar(100) NOT NULL default '', icon varchar(255) NOT NULL, replacement text NOT NULL, example varchar(255) NOT NULL default '', explanation text NOT NULL, params tinyint(1) unsigned NOT NULL default '1', nest tinyint(3) unsigned NOT NULL default '1', PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=8; -- -- 导出表中的数据 `cdb_bbcodes` -- INSERT INTO cdb_bbcodes VALUES (1, 0, 'fly', 'bb_fly.gif', '{1}', '[fly]This is sample text[/fly]', 'Make text move horizontal, the same effect as html tag . NOTE: Only Internet Explorer supports this feature', 1, 1); INSERT INTO cdb_bbcodes VALUES (2, 0, 'flash', 'bb_flash.gif', '', 'Flash Movie', 'Insert flash movie to thread page', 1, 1); INSERT INTO cdb_bbcodes VALUES (3, 1, 'qq', 'bb_qq.gif', '', '[qq]688888[/qq]', 'Show online status of specified QQ UIN and chat with him/her simply by clicking the icon', 1, 1); INSERT INTO cdb_bbcodes VALUES (4, 0, 'ra', 'bb_ra.gif', '', '[ra]rtsp://your.com/example.ra[/ra]', 'Embed Real Audio in thread page', 1, 1); INSERT INTO cdb_bbcodes VALUES (5, 0, 'rm', 'bb_rm.gif', '
', '[rm]rtsp://your.com/example.rm[/rm]', 'Embed Real Audio/Vidio in thread page', 1, 1); INSERT INTO cdb_bbcodes VALUES (6, 0, 'wma', 'bb_wma.gif', '', '[wma]mms://your.com/example.wma[/wma]', 'Embed Windows media audio in thread page', 1, 1); INSERT INTO cdb_bbcodes VALUES (7, 0, 'wmv', 'bb_wmv.gif', '', '[wmv]mms://your.com/example.wmv[/wmv]', 'Embed Windows media audio/video in thread page', 1, 1); -- -------------------------------------------------------- -- -- 表的结构 `cdb_blogcaches` -- DROP TABLE IF EXISTS cdb_blogcaches; CREATE TABLE cdb_blogcaches ( uid mediumint(8) unsigned NOT NULL default '0', variable varchar(10) NOT NULL default '', `value` text NOT NULL, PRIMARY KEY (uid,variable) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_blogcaches` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_buddys` -- DROP TABLE IF EXISTS cdb_buddys; CREATE TABLE cdb_buddys ( uid mediumint(8) unsigned NOT NULL default '0', buddyid mediumint(8) unsigned NOT NULL default '0', grade tinyint(3) unsigned NOT NULL default '1', dateline int(10) unsigned NOT NULL default '0', description char(255) NOT NULL default '', KEY uid (uid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_buddys` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_creditslog` -- DROP TABLE IF EXISTS cdb_creditslog; CREATE TABLE cdb_creditslog ( uid mediumint(8) unsigned NOT NULL default '0', fromto char(15) NOT NULL default '', sendcredits tinyint(1) NOT NULL default '0', receivecredits tinyint(1) NOT NULL default '0', send int(10) unsigned NOT NULL default '0', receive int(10) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', operation char(3) NOT NULL default '', KEY uid (uid,dateline) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_creditslog` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_crons` -- DROP TABLE IF EXISTS cdb_crons; CREATE TABLE cdb_crons ( cronid smallint(6) unsigned NOT NULL auto_increment, available tinyint(1) NOT NULL default '0', `type` enum('user','system') NOT NULL default 'user', `name` char(50) NOT NULL default '', filename char(50) NOT NULL default '', lastrun int(10) unsigned NOT NULL default '0', nextrun int(10) unsigned NOT NULL default '0', weekday tinyint(1) NOT NULL default '0', `day` tinyint(2) NOT NULL default '0', `hour` tinyint(2) NOT NULL default '0', `minute` char(36) NOT NULL default '', PRIMARY KEY (cronid), KEY nextrun (available,nextrun) ) TYPE=MyISAM AUTO_INCREMENT=12; -- -- 导出表中的数据 `cdb_crons` -- INSERT INTO cdb_crons VALUES (1, 1, 'system', '清空今日发帖数', 'todayposts_daily.inc.php', 0, 1150357741, -1, -1, 0, '0'); INSERT INTO cdb_crons VALUES (2, 1, 'system', '清空本月在线时间', 'onlinetime_monthly.inc.php', 0, 1150357741, -1, 1, 0, '0'); INSERT INTO cdb_crons VALUES (3, 1, 'system', '每日数据清理', 'cleanup_daily.inc.php', 0, 1150357741, -1, -1, 5, '30'); INSERT INTO cdb_crons VALUES (4, 1, 'system', '生日统计与邮件祝福', 'birthdays_daily.inc.php', 0, 1150357741, -1, -1, 0, '0'); INSERT INTO cdb_crons VALUES (5, 1, 'system', '主题回复通知', 'notify_daily.inc.php', 0, 1150357741, -1, -1, 5, '00'); INSERT INTO cdb_crons VALUES (6, 1, 'system', '每日公告清理', 'announcements_daily.inc.php', 0, 1150357741, -1, -1, 0, '0'); INSERT INTO cdb_crons VALUES (7, 1, 'system', '限时操作清理', 'threadexpiries_daily.inc.php', 0, 1150357741, -1, -1, 5, '0'); INSERT INTO cdb_crons VALUES (8, 1, 'system', '论坛推广清理', 'promotions_hourly.inc.php', 0, 1150357741, -1, -1, 0, '00'); INSERT INTO cdb_crons VALUES (9, 1, 'system', '每月主题清理', 'cleanup_monthly.inc.php', 0, 1150357741, -1, 1, 6, '00'); INSERT INTO cdb_crons VALUES (10, 1, 'system', '每日热门 X-Space 用户', 'supe_daily.inc.php', 0, 1150357741, -1, -1, 0, '0'); INSERT INTO cdb_crons VALUES (11, 1, 'system', '每周主题更新', 'pushthreads_weekly.inc.php', 0, 1150357741, 1, -1, 4, '0'); -- -------------------------------------------------------- -- -- 表的结构 `cdb_failedlogins` -- DROP TABLE IF EXISTS cdb_failedlogins; CREATE TABLE cdb_failedlogins ( ip char(15) NOT NULL default '', count tinyint(1) unsigned NOT NULL default '0', lastupdate int(10) unsigned NOT NULL default '0', PRIMARY KEY (ip) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_failedlogins` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_favorites` -- DROP TABLE IF EXISTS cdb_favorites; CREATE TABLE cdb_favorites ( uid mediumint(8) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', fid smallint(6) unsigned NOT NULL default '0', KEY uid (uid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_favorites` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_forumfields` -- DROP TABLE IF EXISTS cdb_forumfields; CREATE TABLE cdb_forumfields ( fid smallint(6) unsigned NOT NULL default '0', description text NOT NULL, `password` varchar(12) NOT NULL default '', icon varchar(255) NOT NULL default '', postcredits varchar(255) NOT NULL default '', replycredits varchar(255) NOT NULL default '', getattachcredits varchar(255) NOT NULL default '', postattachcredits varchar(255) NOT NULL default '', digestcredits varchar(255) NOT NULL default '', redirect varchar(255) NOT NULL default '', attachextensions varchar(255) NOT NULL default '', moderators text NOT NULL, rules text NOT NULL, threadtypes text NOT NULL, viewperm text NOT NULL, postperm text NOT NULL, replyperm text NOT NULL, getattachperm text NOT NULL, postattachperm text NOT NULL, supe_pushsetting text NOT NULL, PRIMARY KEY (fid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_forumfields` -- INSERT INTO cdb_forumfields VALUES (1, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); INSERT INTO cdb_forumfields VALUES (2, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- 表的结构 `cdb_forumlinks` -- DROP TABLE IF EXISTS cdb_forumlinks; CREATE TABLE cdb_forumlinks ( id smallint(6) unsigned NOT NULL auto_increment, displayorder tinyint(3) NOT NULL default '0', `name` varchar(100) NOT NULL default '', url varchar(100) NOT NULL default '', note varchar(200) NOT NULL default '', logo varchar(100) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_forumlinks` -- INSERT INTO cdb_forumlinks VALUES (1, 0, 'Discuz! 官方论坛', 'http://www.discuz.com', '提供最新 Discuz! 产品新闻、软件下载与技术交流', 'images/logo.gif'); -- -------------------------------------------------------- -- -- 表的结构 `cdb_forums` -- DROP TABLE IF EXISTS cdb_forums; CREATE TABLE cdb_forums ( fid smallint(6) unsigned NOT NULL auto_increment, fup smallint(6) unsigned NOT NULL default '0', `type` enum('group','forum','sub') NOT NULL default 'forum', `name` char(50) NOT NULL default '', `status` tinyint(1) NOT NULL default '0', displayorder tinyint(3) NOT NULL default '0', styleid smallint(6) unsigned NOT NULL default '0', threads mediumint(8) unsigned NOT NULL default '0', posts mediumint(8) unsigned NOT NULL default '0', todayposts mediumint(8) unsigned NOT NULL default '0', lastpost char(110) NOT NULL default '', allowsmilies tinyint(1) NOT NULL default '0', allowhtml tinyint(1) NOT NULL default '0', allowbbcode tinyint(1) NOT NULL default '0', allowimgcode tinyint(1) NOT NULL default '0', allowanonymous tinyint(1) NOT NULL default '0', allowshare tinyint(1) NOT NULL default '0', allowpostspecial tinyint(1) NOT NULL default '15', alloweditrules tinyint(1) NOT NULL default '0', recyclebin tinyint(1) NOT NULL default '0', modnewposts tinyint(1) NOT NULL default '0', jammer tinyint(1) NOT NULL default '0', disablewatermark tinyint(1) NOT NULL default '0', inheritedmod tinyint(1) NOT NULL default '0', autoclose smallint(6) NOT NULL default '0', forumcolumns tinyint(3) unsigned NOT NULL default '0', threadcaches tinyint(1) NOT NULL default '0', allowpaytoauthor tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (fid), KEY forum (`status`,`type`,displayorder), KEY fup (fup) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_forums` -- INSERT INTO cdb_forums VALUES (1, 0, 'group', 'Discuz!', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 1, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1); INSERT INTO cdb_forums VALUES (2, 1, 'forum', '默认论坛', 1, 0, 0, 0, 0, 0, '', 1, 0, 1, 1, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1); -- -------------------------------------------------------- -- -- 表的结构 `cdb_medals` -- DROP TABLE IF EXISTS cdb_medals; CREATE TABLE cdb_medals ( medalid smallint(6) unsigned NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', available tinyint(1) NOT NULL default '0', image varchar(30) NOT NULL default '', PRIMARY KEY (medalid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_medals` -- INSERT INTO cdb_medals VALUES (1, 'Medal No.1', 0, 'medal1.gif'); INSERT INTO cdb_medals VALUES (2, 'Medal No.2', 0, 'medal2.gif'); INSERT INTO cdb_medals VALUES (3, 'Medal No.3', 0, 'medal3.gif'); INSERT INTO cdb_medals VALUES (4, 'Medal No.4', 0, 'medal4.gif'); INSERT INTO cdb_medals VALUES (5, 'Medal No.5', 0, 'medal5.gif'); INSERT INTO cdb_medals VALUES (6, 'Medal No.6', 0, 'medal6.gif'); INSERT INTO cdb_medals VALUES (7, 'Medal No.7', 0, 'medal7.gif'); INSERT INTO cdb_medals VALUES (8, 'Medal No.8', 0, 'medal8.gif'); INSERT INTO cdb_medals VALUES (9, 'Medal No.9', 0, 'medal9.gif'); INSERT INTO cdb_medals VALUES (10, 'Medal No.10', 0, 'medal10.gif'); -- -------------------------------------------------------- -- -- 表的结构 `cdb_memberfields` -- DROP TABLE IF EXISTS cdb_memberfields; CREATE TABLE cdb_memberfields ( uid mediumint(8) unsigned NOT NULL default '0', nickname varchar(30) NOT NULL default '', site varchar(75) NOT NULL default '', alipay varchar(50) NOT NULL default '', icq varchar(12) NOT NULL default '', qq varchar(12) NOT NULL default '', yahoo varchar(40) NOT NULL default '', msn varchar(40) NOT NULL default '', taobao varchar(40) NOT NULL default '', location varchar(30) NOT NULL default '', customstatus varchar(30) NOT NULL default '', medals varchar(255) NOT NULL default '', avatar varchar(255) NOT NULL default '', avatarwidth tinyint(3) unsigned NOT NULL default '0', avatarheight tinyint(3) unsigned NOT NULL default '0', bio text NOT NULL, signature text NOT NULL, sightml text NOT NULL, ignorepm text NOT NULL, groupterms text NOT NULL, authstr varchar(20) NOT NULL default '', PRIMARY KEY (uid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_memberfields` -- INSERT INTO cdb_memberfields VALUES (1, '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- 表的结构 `cdb_members` -- DROP TABLE IF EXISTS cdb_members; CREATE TABLE cdb_members ( uid mediumint(8) unsigned NOT NULL auto_increment, username char(15) NOT NULL default '', `password` char(32) NOT NULL default '', secques char(8) NOT NULL default '', gender tinyint(1) NOT NULL default '0', adminid tinyint(1) NOT NULL default '0', groupid smallint(6) unsigned NOT NULL default '0', groupexpiry int(10) unsigned NOT NULL default '0', extgroupids char(60) NOT NULL default '', regip char(15) NOT NULL default '', regdate int(10) unsigned NOT NULL default '0', lastip char(15) NOT NULL default '', lastvisit int(10) unsigned NOT NULL default '0', lastactivity int(10) unsigned NOT NULL default '0', lastpost int(10) unsigned NOT NULL default '0', posts mediumint(8) unsigned NOT NULL default '0', digestposts smallint(6) unsigned NOT NULL default '0', oltime smallint(6) unsigned NOT NULL default '0', pageviews mediumint(8) unsigned NOT NULL default '0', credits int(10) NOT NULL default '0', extcredits1 int(10) NOT NULL default '0', extcredits2 int(10) NOT NULL default '0', extcredits3 int(10) NOT NULL default '0', extcredits4 int(10) NOT NULL default '0', extcredits5 int(10) NOT NULL default '0', extcredits6 int(10) NOT NULL default '0', extcredits7 int(10) NOT NULL default '0', extcredits8 int(10) NOT NULL default '0', avatarshowid int(10) unsigned NOT NULL default '0', email char(50) NOT NULL default '', bday date NOT NULL default '0000-00-00', sigstatus tinyint(1) NOT NULL default '0', tpp tinyint(3) unsigned NOT NULL default '0', ppp tinyint(3) unsigned NOT NULL default '0', styleid smallint(6) unsigned NOT NULL default '0', dateformat char(10) NOT NULL default '', timeformat tinyint(1) NOT NULL default '0', pmsound tinyint(1) NOT NULL default '0', showemail tinyint(1) NOT NULL default '0', newsletter tinyint(1) NOT NULL default '0', invisible tinyint(1) NOT NULL default '0', timeoffset char(4) NOT NULL default '', newpm tinyint(1) NOT NULL default '0', accessmasks tinyint(1) NOT NULL default '0', editormode tinyint(1) unsigned NOT NULL default '2', customshow tinyint(1) unsigned NOT NULL default '26', xspacestatus tinyint(1) NOT NULL default '0', PRIMARY KEY (uid), UNIQUE KEY username (username), KEY email (email) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_members` -- INSERT INTO cdb_members VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', 0, 1, 1, 0, '', 'hidden', 1150355501, '127.0.0.1', 0, 1150355547, 1150355501, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'name@domain.com', '0000-00-00', 0, 0, 0, 0, '', 0, 0, 1, 1, 0, '9999', 0, 0, 2, 0, 26); -- -------------------------------------------------------- -- -- 表的结构 `cdb_moderators` -- DROP TABLE IF EXISTS cdb_moderators; CREATE TABLE cdb_moderators ( uid mediumint(8) unsigned NOT NULL default '0', fid smallint(6) unsigned NOT NULL default '0', displayorder tinyint(3) NOT NULL default '0', inherited tinyint(1) NOT NULL default '0', PRIMARY KEY (uid,fid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_moderators` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_modworks` -- DROP TABLE IF EXISTS cdb_modworks; CREATE TABLE cdb_modworks ( uid mediumint(8) unsigned NOT NULL default '0', modaction char(3) NOT NULL default '', dateline date NOT NULL default '2006-01-01', count smallint(6) unsigned NOT NULL default '0', posts smallint(6) unsigned NOT NULL default '0', KEY uid (uid,dateline) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_modworks` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_myposts` -- DROP TABLE IF EXISTS cdb_myposts; CREATE TABLE cdb_myposts ( uid mediumint(8) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', pid int(10) unsigned NOT NULL default '0', position smallint(6) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', PRIMARY KEY (uid,tid), KEY tid (tid,dateline) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_myposts` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_mythreads` -- DROP TABLE IF EXISTS cdb_mythreads; CREATE TABLE cdb_mythreads ( uid mediumint(8) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', dateline int(10) NOT NULL default '0', PRIMARY KEY (uid,tid), KEY tid (tid,dateline) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_mythreads` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_onlinelist` -- DROP TABLE IF EXISTS cdb_onlinelist; CREATE TABLE cdb_onlinelist ( groupid smallint(6) unsigned NOT NULL default '0', displayorder tinyint(3) NOT NULL default '0', title varchar(30) NOT NULL default '', url varchar(30) NOT NULL default '' ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_onlinelist` -- INSERT INTO cdb_onlinelist VALUES (1, 1, '管理员', 'online_admin.gif'); INSERT INTO cdb_onlinelist VALUES (2, 2, '超级版主', 'online_supermod.gif'); INSERT INTO cdb_onlinelist VALUES (3, 3, '版主', 'online_moderator.gif'); INSERT INTO cdb_onlinelist VALUES (0, 4, '会员', 'online_member.gif'); -- -------------------------------------------------------- -- -- 表的结构 `cdb_onlinetime` -- DROP TABLE IF EXISTS cdb_onlinetime; CREATE TABLE cdb_onlinetime ( uid mediumint(8) unsigned NOT NULL default '0', thismonth smallint(6) unsigned NOT NULL default '0', total mediumint(8) unsigned NOT NULL default '0', lastupdate int(10) unsigned NOT NULL default '0', PRIMARY KEY (uid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_onlinetime` -- INSERT INTO cdb_onlinetime VALUES (1, 30, 30, 0); -- -------------------------------------------------------- -- -- 表的结构 `cdb_orders` -- DROP TABLE IF EXISTS cdb_orders; CREATE TABLE cdb_orders ( orderid char(32) NOT NULL default '', `status` char(3) NOT NULL default '', buyer char(50) NOT NULL default '', admin char(15) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', amount int(10) unsigned NOT NULL default '0', price float(7,2) unsigned NOT NULL default '0.00', submitdate int(10) unsigned NOT NULL default '0', confirmdate int(10) unsigned NOT NULL default '0', UNIQUE KEY orderid (orderid), KEY submitdate (submitdate), KEY uid (uid,submitdate) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_orders` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_paymentlog` -- DROP TABLE IF EXISTS cdb_paymentlog; CREATE TABLE cdb_paymentlog ( uid mediumint(8) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', authorid mediumint(8) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', amount int(10) unsigned NOT NULL default '0', netamount int(10) unsigned NOT NULL default '0', PRIMARY KEY (tid,uid), KEY uid (uid), KEY authorid (authorid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_paymentlog` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_pluginhooks` -- DROP TABLE IF EXISTS cdb_pluginhooks; CREATE TABLE cdb_pluginhooks ( pluginhookid mediumint(8) unsigned NOT NULL auto_increment, pluginid smallint(6) unsigned NOT NULL default '0', available tinyint(1) NOT NULL default '0', title varchar(255) NOT NULL default '', description mediumtext NOT NULL, `code` mediumtext NOT NULL, PRIMARY KEY (pluginhookid), KEY pluginid (pluginid), KEY available (available) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_pluginhooks` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_plugins` -- DROP TABLE IF EXISTS cdb_plugins; CREATE TABLE cdb_plugins ( pluginid smallint(6) unsigned NOT NULL auto_increment, available tinyint(1) NOT NULL default '0', adminid tinyint(1) unsigned NOT NULL default '0', `name` varchar(40) NOT NULL default '', identifier varchar(40) NOT NULL default '', description varchar(255) NOT NULL default '', datatables varchar(255) NOT NULL default '', `directory` varchar(100) NOT NULL default '', copyright varchar(100) NOT NULL default '', modules text NOT NULL, PRIMARY KEY (pluginid), UNIQUE KEY identifier (identifier) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_plugins` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_pluginvars` -- DROP TABLE IF EXISTS cdb_pluginvars; CREATE TABLE cdb_pluginvars ( pluginvarid mediumint(8) unsigned NOT NULL auto_increment, pluginid smallint(6) unsigned NOT NULL default '0', displayorder tinyint(3) NOT NULL default '0', title varchar(100) NOT NULL default '', description varchar(255) NOT NULL default '', variable varchar(40) NOT NULL default '', `type` varchar(20) NOT NULL default 'text', `value` text NOT NULL, extra text NOT NULL, PRIMARY KEY (pluginvarid), KEY pluginid (pluginid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_pluginvars` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_pms` -- DROP TABLE IF EXISTS cdb_pms; CREATE TABLE cdb_pms ( pmid int(10) unsigned NOT NULL auto_increment, msgfrom varchar(15) NOT NULL default '', msgfromid mediumint(8) unsigned NOT NULL default '0', msgtoid mediumint(8) unsigned NOT NULL default '0', folder enum('inbox','outbox') NOT NULL default 'inbox', `new` tinyint(1) NOT NULL default '0', `subject` varchar(75) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', message text NOT NULL, PRIMARY KEY (pmid), KEY msgtoid (msgtoid,folder,dateline), KEY msgfromid (msgfromid,folder,dateline) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_pms` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_pmsearchindex` -- DROP TABLE IF EXISTS cdb_pmsearchindex; CREATE TABLE cdb_pmsearchindex ( searchid int(10) unsigned NOT NULL auto_increment, keywords varchar(255) NOT NULL default '', searchstring varchar(255) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', expiration int(10) unsigned NOT NULL default '0', pms smallint(6) unsigned NOT NULL default '0', pmids text NOT NULL, PRIMARY KEY (searchid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_pmsearchindex` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_polloptions` -- DROP TABLE IF EXISTS cdb_polloptions; CREATE TABLE cdb_polloptions ( polloptionid int(10) unsigned NOT NULL auto_increment, tid mediumint(8) unsigned NOT NULL default '0', votes mediumint(8) unsigned NOT NULL default '0', displayorder tinyint(3) NOT NULL default '0', polloption varchar(80) NOT NULL default '', voterids mediumtext NOT NULL, PRIMARY KEY (polloptionid), KEY tid (tid,displayorder) ) TYPE=MyISAM AUTO_INCREMENT=1; -- -- 导出表中的数据 `cdb_polloptions` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_polls` -- DROP TABLE IF EXISTS cdb_polls; CREATE TABLE cdb_polls ( tid mediumint(8) unsigned NOT NULL default '0', multiple tinyint(1) NOT NULL default '0', visible tinyint(1) NOT NULL default '0', maxchoices tinyint(3) unsigned NOT NULL default '0', expiration int(10) unsigned NOT NULL default '0', PRIMARY KEY (tid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_polls` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_posts` -- DROP TABLE IF EXISTS cdb_posts; CREATE TABLE cdb_posts ( pid int(10) unsigned NOT NULL auto_increment, fid smallint(6) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', `first` tinyint(1) NOT NULL default '0', author varchar(15) NOT NULL default '', authorid mediumint(8) unsigned NOT NULL default '0', `subject` varchar(80) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', message mediumtext NOT NULL, useip varchar(15) NOT NULL default '', invisible tinyint(1) NOT NULL default '0', anonymous tinyint(1) NOT NULL default '0', usesig tinyint(1) NOT NULL default '0', htmlon tinyint(1) NOT NULL default '0', bbcodeoff tinyint(1) NOT NULL default '0', smileyoff tinyint(1) NOT NULL default '0', parseurloff tinyint(1) NOT NULL default '0', attachment tinyint(1) NOT NULL default '0', rate smallint(6) NOT NULL default '0', ratetimes tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (pid), KEY fid (fid), KEY authorid (authorid), KEY dateline (dateline), KEY invisible (invisible), KEY displayorder (tid,invisible,dateline), KEY `first` (tid,`first`) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_posts` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_profilefields` -- DROP TABLE IF EXISTS cdb_profilefields; CREATE TABLE cdb_profilefields ( fieldid smallint(6) unsigned NOT NULL auto_increment, available tinyint(1) NOT NULL default '0', invisible tinyint(1) NOT NULL default '0', title varchar(50) NOT NULL default '', description varchar(255) NOT NULL default '', size tinyint(3) unsigned NOT NULL default '0', displayorder smallint(6) NOT NULL default '0', required tinyint(1) NOT NULL default '0', unchangeable tinyint(1) NOT NULL default '0', showinthread tinyint(1) NOT NULL default '0', selective tinyint(1) NOT NULL default '0', choices text NOT NULL, PRIMARY KEY (fieldid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_profilefields` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_promotions` -- DROP TABLE IF EXISTS cdb_promotions; CREATE TABLE cdb_promotions ( ip char(15) NOT NULL default '', uid mediumint(8) NOT NULL default '0', username char(15) NOT NULL default '', PRIMARY KEY (ip) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_promotions` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_pushedthreads` -- DROP TABLE IF EXISTS cdb_pushedthreads; CREATE TABLE cdb_pushedthreads ( id mediumint(8) unsigned NOT NULL, tid mediumint(8) unsigned NOT NULL default '0', `status` tinyint(1) NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', `subject` char(80) NOT NULL, message text NOT NULL, PRIMARY KEY (id), KEY displayorder (`status`,dateline) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_pushedthreads` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_ranks` -- DROP TABLE IF EXISTS cdb_ranks; CREATE TABLE cdb_ranks ( rankid smallint(6) unsigned NOT NULL auto_increment, ranktitle varchar(30) NOT NULL default '', postshigher mediumint(8) unsigned NOT NULL default '0', stars tinyint(3) NOT NULL default '0', color varchar(7) NOT NULL default '', PRIMARY KEY (rankid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_ranks` -- INSERT INTO cdb_ranks VALUES (1, '新生入学', 0, 1, ''); INSERT INTO cdb_ranks VALUES (2, '小试牛刀', 50, 2, ''); INSERT INTO cdb_ranks VALUES (3, '实习记者', 300, 5, ''); INSERT INTO cdb_ranks VALUES (4, '自由撰稿人', 1000, 4, ''); INSERT INTO cdb_ranks VALUES (5, '特聘作家', 3000, 5, ''); -- -------------------------------------------------------- -- -- 表的结构 `cdb_ratelog` -- DROP TABLE IF EXISTS cdb_ratelog; CREATE TABLE cdb_ratelog ( pid int(10) unsigned NOT NULL default '0', uid mediumint(8) unsigned NOT NULL default '0', username char(15) NOT NULL default '', extcredits tinyint(1) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', score smallint(6) NOT NULL default '0', reason char(40) NOT NULL default '', KEY pid (pid,dateline), KEY dateline (dateline) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_ratelog` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_regips` -- DROP TABLE IF EXISTS cdb_regips; CREATE TABLE cdb_regips ( ip char(15) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', count smallint(6) NOT NULL default '0', KEY ip (ip) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_regips` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_relatedthreads` -- DROP TABLE IF EXISTS cdb_relatedthreads; CREATE TABLE cdb_relatedthreads ( tid mediumint(8) NOT NULL default '0', expiration int(10) NOT NULL default '0', keywords varchar(255) NOT NULL default '', relatedthreads text NOT NULL, PRIMARY KEY (tid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_relatedthreads` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_rewardlog` -- DROP TABLE IF EXISTS cdb_rewardlog; CREATE TABLE cdb_rewardlog ( tid mediumint(8) unsigned NOT NULL default '0', authorid mediumint(8) unsigned NOT NULL default '0', answererid mediumint(8) unsigned NOT NULL default '0', dateline int(10) unsigned default '0', netamount int(10) unsigned NOT NULL default '0', KEY userid (authorid,answererid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_rewardlog` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_rsscaches` -- DROP TABLE IF EXISTS cdb_rsscaches; CREATE TABLE cdb_rsscaches ( lastupdate int(10) unsigned NOT NULL default '0', fid smallint(6) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', forum char(50) NOT NULL default '', author char(15) NOT NULL default '', `subject` char(80) NOT NULL default '', description char(255) NOT NULL default '', KEY fid (fid,dateline) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_rsscaches` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_searchindex` -- DROP TABLE IF EXISTS cdb_searchindex; CREATE TABLE cdb_searchindex ( searchid int(10) unsigned NOT NULL auto_increment, keywords varchar(255) NOT NULL default '', searchstring varchar(255) NOT NULL default '', useip varchar(15) NOT NULL default '', uid mediumint(10) unsigned NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', expiration int(10) unsigned NOT NULL default '0', threads smallint(6) unsigned NOT NULL default '0', tids text NOT NULL, PRIMARY KEY (searchid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_searchindex` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_sessions` -- DROP TABLE IF EXISTS cdb_sessions; CREATE TABLE cdb_sessions ( sid char(6) binary NOT NULL default '', ip1 tinyint(3) unsigned NOT NULL default '0', ip2 tinyint(3) unsigned NOT NULL default '0', ip3 tinyint(3) unsigned NOT NULL default '0', ip4 tinyint(3) unsigned NOT NULL default '0', uid mediumint(8) unsigned NOT NULL default '0', username char(15) NOT NULL default '', groupid smallint(6) unsigned NOT NULL default '0', styleid smallint(6) unsigned NOT NULL default '0', invisible tinyint(1) NOT NULL default '0', `action` tinyint(1) unsigned NOT NULL default '0', lastactivity int(10) unsigned NOT NULL default '0', lastolupdate int(10) unsigned NOT NULL default '0', pageviews smallint(6) unsigned NOT NULL default '0', seccode smallint(6) unsigned NOT NULL default '0', fid smallint(6) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', bloguid mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY sid (sid), KEY uid (uid), KEY bloguid (bloguid) ) TYPE=Heap; -- -- 导出表中的数据 `cdb_sessions` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_settings` -- DROP TABLE IF EXISTS cdb_settings; CREATE TABLE cdb_settings ( variable varchar(32) NOT NULL default '', `value` text NOT NULL, PRIMARY KEY (variable) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_settings` -- INSERT INTO cdb_settings VALUES ('accessemail', ''); INSERT INTO cdb_settings VALUES ('adminipaccess', ''); INSERT INTO cdb_settings VALUES ('allowcsscache', '1'); INSERT INTO cdb_settings VALUES ('archiverstatus', '1'); INSERT INTO cdb_settings VALUES ('attachbanperiods', ''); INSERT INTO cdb_settings VALUES ('attachimgpost', '1'); INSERT INTO cdb_settings VALUES ('attachrefcheck', ''); INSERT INTO cdb_settings VALUES ('attachsave', '0'); INSERT INTO cdb_settings VALUES ('authkey', 'BBsrBEukdwdbmCV'); INSERT INTO cdb_settings VALUES ('avatarshowdefault', '0'); INSERT INTO cdb_settings VALUES ('avatarshowheight', '200'); INSERT INTO cdb_settings VALUES ('avatarshowlink', '1'); INSERT INTO cdb_settings VALUES ('avatarshowpos', '3'); INSERT INTO cdb_settings VALUES ('avatarshowstatus', '1'); INSERT INTO cdb_settings VALUES ('avatarshowwidth', '135'); INSERT INTO cdb_settings VALUES ('bannedmessages', '1'); INSERT INTO cdb_settings VALUES ('bbclosed', ''); INSERT INTO cdb_settings VALUES ('bbinsert', '1'); INSERT INTO cdb_settings VALUES ('bbname', 'Discuz! Board'); INSERT INTO cdb_settings VALUES ('bbrules', ''); INSERT INTO cdb_settings VALUES ('bbrulestxt', ''); INSERT INTO cdb_settings VALUES ('bdaystatus', '0'); INSERT INTO cdb_settings VALUES ('boardlicensed', '0'); INSERT INTO cdb_settings VALUES ('censoremail', ''); INSERT INTO cdb_settings VALUES ('censoruser', ''); INSERT INTO cdb_settings VALUES ('closedreason', ''); INSERT INTO cdb_settings VALUES ('creditsformula', 'extcredits1'); INSERT INTO cdb_settings VALUES ('creditsformulaexp', ''); INSERT INTO cdb_settings VALUES ('creditsnotify', ''); INSERT INTO cdb_settings VALUES ('creditspolicy', 'a:7:{s:4:"post";a:0:{}s:5:"reply";a:0:{}s:6:"digest";a:1:{i:1;i:10;}s:10:"postattach";a:0:{}s:9:"getattach";a:0:{}s:2:"pm";a:0:{}s:6:"search";a:0:{}}'); INSERT INTO cdb_settings VALUES ('creditstax', '0.2'); INSERT INTO cdb_settings VALUES ('creditstrans', '2'); INSERT INTO cdb_settings VALUES ('custombackup', ''); INSERT INTO cdb_settings VALUES ('dateformat', 'Y-n-j'); INSERT INTO cdb_settings VALUES ('debug', '1'); INSERT INTO cdb_settings VALUES ('delayviewcount', '0'); INSERT INTO cdb_settings VALUES ('deletereason', ''); INSERT INTO cdb_settings VALUES ('dotfolders', ''); INSERT INTO cdb_settings VALUES ('doublee', '1'); INSERT INTO cdb_settings VALUES ('dupkarmarate', '0'); INSERT INTO cdb_settings VALUES ('ec_account', ''); INSERT INTO cdb_settings VALUES ('ec_commision', '0'); INSERT INTO cdb_settings VALUES ('ec_id', ''); INSERT INTO cdb_settings VALUES ('ec_maxcredits', '1000'); INSERT INTO cdb_settings VALUES ('ec_maxcreditspermonth', '0'); INSERT INTO cdb_settings VALUES ('ec_mincredits', '0'); INSERT INTO cdb_settings VALUES ('ec_ratio', '0'); INSERT INTO cdb_settings VALUES ('ec_securitycode', ''); INSERT INTO cdb_settings VALUES ('editedby', '1'); INSERT INTO cdb_settings VALUES ('editoroptions', '1'); INSERT INTO cdb_settings VALUES ('edittimelimit', ''); INSERT INTO cdb_settings VALUES ('exchangemincredits', '100'); INSERT INTO cdb_settings VALUES ('extcredits', 'a:2:{i:1;a:3:{s:5:"title";s:4:"威望";s:12:"showinthread";s:0:"";s:9:"available";i:1;}i:2;a:3:{s:5:"title";s:4:"金钱";s:12:"showinthread";s:0:"";s:9:"available";i:1;}}'); INSERT INTO cdb_settings VALUES ('fastpost', '1'); INSERT INTO cdb_settings VALUES ('floodctrl', '15'); INSERT INTO cdb_settings VALUES ('forumjump', '1'); INSERT INTO cdb_settings VALUES ('globalstick', '1'); INSERT INTO cdb_settings VALUES ('gzipcompress', '0'); INSERT INTO cdb_settings VALUES ('hideprivate', '1'); INSERT INTO cdb_settings VALUES ('hottopic', '10'); INSERT INTO cdb_settings VALUES ('icp', ''); INSERT INTO cdb_settings VALUES ('initcredits', '0,0,0,0,0,0,0,0,0'); INSERT INTO cdb_settings VALUES ('ipaccess', ''); INSERT INTO cdb_settings VALUES ('ipregctrl', ''); INSERT INTO cdb_settings VALUES ('jscachelife', '1800'); INSERT INTO cdb_settings VALUES ('jsmenustatus', '15'); INSERT INTO cdb_settings VALUES ('jsrefdomains', ''); INSERT INTO cdb_settings VALUES ('jsstatus', '0'); INSERT INTO cdb_settings VALUES ('karmaratelimit', '0'); INSERT INTO cdb_settings VALUES ('loadctrl', ''); INSERT INTO cdb_settings VALUES ('losslessdel', '365'); INSERT INTO cdb_settings VALUES ('maxavatarpixel', '120'); INSERT INTO cdb_settings VALUES ('maxavatarsize', '20000'); INSERT INTO cdb_settings VALUES ('maxbdays', '0'); INSERT INTO cdb_settings VALUES ('maxchargespan', '0'); INSERT INTO cdb_settings VALUES ('maxfavorites', '100'); INSERT INTO cdb_settings VALUES ('maxincperthread', '0'); INSERT INTO cdb_settings VALUES ('maxmodworksmonths', '3'); INSERT INTO cdb_settings VALUES ('maxonlinelist', '0'); INSERT INTO cdb_settings VALUES ('maxonlines', '5000'); INSERT INTO cdb_settings VALUES ('maxpolloptions', '10'); INSERT INTO cdb_settings VALUES ('maxpostsize', '10000'); INSERT INTO cdb_settings VALUES ('maxsearchresults', '500'); INSERT INTO cdb_settings VALUES ('maxsigrows', '20'); INSERT INTO cdb_settings VALUES ('maxsmilies', '3'); INSERT INTO cdb_settings VALUES ('maxspm', '0'); INSERT INTO cdb_settings VALUES ('maxsubscriptions', '100'); INSERT INTO cdb_settings VALUES ('maxthreadads', '0'); INSERT INTO cdb_settings VALUES ('membermaxpages', '100'); INSERT INTO cdb_settings VALUES ('memberperpage', '25'); INSERT INTO cdb_settings VALUES ('memliststatus', '1'); INSERT INTO cdb_settings VALUES ('minpostsize', '10'); INSERT INTO cdb_settings VALUES ('moddisplay', 'flat'); INSERT INTO cdb_settings VALUES ('modratelimit', '0'); INSERT INTO cdb_settings VALUES ('modreasons', '广告/SPAM\r\n恶意灌水\r\n违规内容\r\n文不对题\r\n重复发帖\r\n\r\n我很赞同\r\n精品文章\r\n原创内容'); INSERT INTO cdb_settings VALUES ('modworkstatus', '0'); INSERT INTO cdb_settings VALUES ('myrecorddays', '30'); INSERT INTO cdb_settings VALUES ('newbiespan', '0'); INSERT INTO cdb_settings VALUES ('newsletter', ''); INSERT INTO cdb_settings VALUES ('nocacheheaders', ''); INSERT INTO cdb_settings VALUES ('oltimespan', '10'); INSERT INTO cdb_settings VALUES ('onlinerecord', '1 1040034649'); INSERT INTO cdb_settings VALUES ('passport_expire', '3600'); INSERT INTO cdb_settings VALUES ('passport_extcredits', '0'); INSERT INTO cdb_settings VALUES ('passport_key', ''); INSERT INTO cdb_settings VALUES ('passport_login_url', ''); INSERT INTO cdb_settings VALUES ('passport_logout_url', ''); INSERT INTO cdb_settings VALUES ('passport_register_url', ''); INSERT INTO cdb_settings VALUES ('passport_status', ''); INSERT INTO cdb_settings VALUES ('passport_url', ''); INSERT INTO cdb_settings VALUES ('postbanperiods', ''); INSERT INTO cdb_settings VALUES ('postmodperiods', ''); INSERT INTO cdb_settings VALUES ('postperpage', '10'); INSERT INTO cdb_settings VALUES ('pvfrequence', '60'); INSERT INTO cdb_settings VALUES ('qihoo_adminemail', ''); INSERT INTO cdb_settings VALUES ('qihoo_jammer', '1'); INSERT INTO cdb_settings VALUES ('qihoo_allsearch', '1'); INSERT INTO cdb_settings VALUES ('qihoo_keywords', ''); INSERT INTO cdb_settings VALUES ('qihoo_location', '1'); INSERT INTO cdb_settings VALUES ('qihoo_maxtopics', '10'); INSERT INTO cdb_settings VALUES ('qihoo_relatedthreads', '5'); INSERT INTO cdb_settings VALUES ('qihoo_relatedsort', '1'); INSERT INTO cdb_settings VALUES ('qihoo_searchbox', '0'); INSERT INTO cdb_settings VALUES ('qihoo_searchboxtxt', '输入关键词，快速搜索本论坛'); INSERT INTO cdb_settings VALUES ('qihoo_status', '0'); INSERT INTO cdb_settings VALUES ('qihoo_summary', '1'); INSERT INTO cdb_settings VALUES ('qihoo_topics', ''); INSERT INTO cdb_settings VALUES ('qihoo_validity', '1'); INSERT INTO cdb_settings VALUES ('qihoo_ustyle', '0'); INSERT INTO cdb_settings VALUES ('ratelogrecord', '5'); INSERT INTO cdb_settings VALUES ('regadvance', '0'); INSERT INTO cdb_settings VALUES ('regctrl', '0'); INSERT INTO cdb_settings VALUES ('regfloodctrl', '0'); INSERT INTO cdb_settings VALUES ('regstatus', '1'); INSERT INTO cdb_settings VALUES ('regverify', '0'); INSERT INTO cdb_settings VALUES ('reportpost', '1'); INSERT INTO cdb_settings VALUES ('rewritestatus', '0'); INSERT INTO cdb_settings VALUES ('rssstatus', '1'); INSERT INTO cdb_settings VALUES ('rssttl', '60'); INSERT INTO cdb_settings VALUES ('runwizard', '1'); INSERT INTO cdb_settings VALUES ('searchbanperiods', ''); INSERT INTO cdb_settings VALUES ('searchctrl', '30'); INSERT INTO cdb_settings VALUES ('seccodestatus', '0'); INSERT INTO cdb_settings VALUES ('seodescription', ''); INSERT INTO cdb_settings VALUES ('seohead', ''); INSERT INTO cdb_settings VALUES ('seokeywords', ''); INSERT INTO cdb_settings VALUES ('seotitle', ''); INSERT INTO cdb_settings VALUES ('showemail', ''); INSERT INTO cdb_settings VALUES ('showsettings', '7'); INSERT INTO cdb_settings VALUES ('sitename', 'Comsenz Inc.'); INSERT INTO cdb_settings VALUES ('siteurl', 'http://www.comsenz.com/'); INSERT INTO cdb_settings VALUES ('smcols', '4'); INSERT INTO cdb_settings VALUES ('smileyinsert', '1'); INSERT INTO cdb_settings VALUES ('starthreshold', '2'); INSERT INTO cdb_settings VALUES ('statscachelife', '180'); INSERT INTO cdb_settings VALUES ('statstatus', ''); INSERT INTO cdb_settings VALUES ('styleid', '1'); INSERT INTO cdb_settings VALUES ('stylejump', '0'); INSERT INTO cdb_settings VALUES ('subforumsindex', ''); INSERT INTO cdb_settings VALUES ('supe_maxupdateusers', '100'); INSERT INTO cdb_settings VALUES ('supe_siteurl', ''); INSERT INTO cdb_settings VALUES ('supe_sitename', ''); INSERT INTO cdb_settings VALUES ('supe_status', '0'); INSERT INTO cdb_settings VALUES ('supe_tablepre', ''); INSERT INTO cdb_settings VALUES ('threadmaxpages', '1000'); INSERT INTO cdb_settings VALUES ('threadsticky', '全局置顶,分类置顶,本版置顶'); INSERT INTO cdb_settings VALUES ('timeformat', 'H:i'); INSERT INTO cdb_settings VALUES ('timeoffset', '8'); INSERT INTO cdb_settings VALUES ('topicperpage', '20'); INSERT INTO cdb_settings VALUES ('transfermincredits', '1000'); INSERT INTO cdb_settings VALUES ('transsidstatus', '0'); INSERT INTO cdb_settings VALUES ('userstatusby', '1'); INSERT INTO cdb_settings VALUES ('visitbanperiods', ''); INSERT INTO cdb_settings VALUES ('visitedforums', '10'); INSERT INTO cdb_settings VALUES ('vtonlinestatus', '1'); INSERT INTO cdb_settings VALUES ('wapcharset', '2'); INSERT INTO cdb_settings VALUES ('wapdateformat', 'n/j'); INSERT INTO cdb_settings VALUES ('wapmps', '500'); INSERT INTO cdb_settings VALUES ('wapppp', '5'); INSERT INTO cdb_settings VALUES ('wapstatus', '1'); INSERT INTO cdb_settings VALUES ('waptpp', '10'); INSERT INTO cdb_settings VALUES ('watermarkquality', '80'); INSERT INTO cdb_settings VALUES ('watermarkstatus', '0'); INSERT INTO cdb_settings VALUES ('watermarktrans', '65'); INSERT INTO cdb_settings VALUES ('welcomemsg', ''); INSERT INTO cdb_settings VALUES ('welcomemsgtxt', ''); INSERT INTO cdb_settings VALUES ('whosonlinestatus', '1'); INSERT INTO cdb_settings VALUES ('indexname', 'index.php'); -- -------------------------------------------------------- -- -- 表的结构 `cdb_smilies` -- DROP TABLE IF EXISTS cdb_smilies; CREATE TABLE cdb_smilies ( id smallint(6) unsigned NOT NULL auto_increment, displayorder tinyint(1) NOT NULL default '0', `type` enum('smiley','icon') NOT NULL default 'smiley', `code` varchar(30) NOT NULL default '', url varchar(30) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_smilies` -- INSERT INTO cdb_smilies VALUES (1, 0, 'smiley', ':)', 'smile.gif'); INSERT INTO cdb_smilies VALUES (2, 0, 'smiley', ':(', 'sad.gif'); INSERT INTO cdb_smilies VALUES (3, 0, 'smiley', ':D', 'biggrin.gif'); INSERT INTO cdb_smilies VALUES (4, 0, 'smiley', ':''(', 'cry.gif'); INSERT INTO cdb_smilies VALUES (5, 0, 'smiley', ':@', 'huffy.gif'); INSERT INTO cdb_smilies VALUES (6, 0, 'smiley', ':o', 'shocked.gif'); INSERT INTO cdb_smilies VALUES (7, 0, 'smiley', ':P', 'tongue.gif'); INSERT INTO cdb_smilies VALUES (8, 0, 'smiley', ':$', 'shy.gif'); INSERT INTO cdb_smilies VALUES (9, 0, 'smiley', ';P', 'titter.gif'); INSERT INTO cdb_smilies VALUES (10, 0, 'smiley', ':L', 'sweat.gif'); INSERT INTO cdb_smilies VALUES (11, 0, 'smiley', ':Q', 'mad.gif'); INSERT INTO cdb_smilies VALUES (12, 0, 'smiley', ':lol', 'lol.gif'); INSERT INTO cdb_smilies VALUES (13, 0, 'smiley', ':hug:', 'hug.gif'); INSERT INTO cdb_smilies VALUES (14, 0, 'smiley', ':victory:', 'victory.gif'); INSERT INTO cdb_smilies VALUES (15, 0, 'smiley', ':time:', 'time.gif'); INSERT INTO cdb_smilies VALUES (16, 0, 'smiley', ':kiss:', 'kiss.gif'); INSERT INTO cdb_smilies VALUES (17, 0, 'smiley', ':handshake', 'handshake.gif'); INSERT INTO cdb_smilies VALUES (18, 0, 'smiley', ':call:', 'call.gif'); INSERT INTO cdb_smilies VALUES (19, 0, 'icon', '', 'icon1.gif'); INSERT INTO cdb_smilies VALUES (20, 0, 'icon', '', 'icon2.gif'); INSERT INTO cdb_smilies VALUES (21, 0, 'icon', '', 'icon3.gif'); INSERT INTO cdb_smilies VALUES (22, 0, 'icon', '', 'icon4.gif'); INSERT INTO cdb_smilies VALUES (23, 0, 'icon', '', 'icon5.gif'); INSERT INTO cdb_smilies VALUES (24, 0, 'icon', '', 'icon6.gif'); INSERT INTO cdb_smilies VALUES (25, 0, 'icon', '', 'icon7.gif'); INSERT INTO cdb_smilies VALUES (26, 0, 'icon', '', 'icon8.gif'); INSERT INTO cdb_smilies VALUES (27, 0, 'icon', '', 'icon9.gif'); INSERT INTO cdb_smilies VALUES (28, 0, 'smiley', ':loveliness:', 'loveliness.gif'); INSERT INTO cdb_smilies VALUES (29, 0, 'smiley', ':funk:', 'funk.gif'); -- -------------------------------------------------------- -- -- 表的结构 `cdb_stats` -- DROP TABLE IF EXISTS cdb_stats; CREATE TABLE cdb_stats ( `type` char(10) NOT NULL default '', variable char(10) NOT NULL default '', count int(10) unsigned NOT NULL default '0', PRIMARY KEY (`type`,variable) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_stats` -- INSERT INTO cdb_stats VALUES ('total', 'hits', 1); INSERT INTO cdb_stats VALUES ('total', 'members', 0); INSERT INTO cdb_stats VALUES ('total', 'guests', 1); INSERT INTO cdb_stats VALUES ('os', 'Windows', 1); INSERT INTO cdb_stats VALUES ('os', 'Mac', 0); INSERT INTO cdb_stats VALUES ('os', 'Linux', 0); INSERT INTO cdb_stats VALUES ('os', 'FreeBSD', 0); INSERT INTO cdb_stats VALUES ('os', 'SunOS', 0); INSERT INTO cdb_stats VALUES ('os', 'OS/2', 0); INSERT INTO cdb_stats VALUES ('os', 'AIX', 0); INSERT INTO cdb_stats VALUES ('os', 'Spiders', 0); INSERT INTO cdb_stats VALUES ('os', 'Other', 0); INSERT INTO cdb_stats VALUES ('browser', 'MSIE', 1); INSERT INTO cdb_stats VALUES ('browser', 'Netscape', 0); INSERT INTO cdb_stats VALUES ('browser', 'Mozilla', 0); INSERT INTO cdb_stats VALUES ('browser', 'Lynx', 0); INSERT INTO cdb_stats VALUES ('browser', 'Opera', 0); INSERT INTO cdb_stats VALUES ('browser', 'Konqueror', 0); INSERT INTO cdb_stats VALUES ('browser', 'Other', 0); INSERT INTO cdb_stats VALUES ('week', '0', 0); INSERT INTO cdb_stats VALUES ('week', '1', 1); INSERT INTO cdb_stats VALUES ('week', '2', 0); INSERT INTO cdb_stats VALUES ('week', '3', 0); INSERT INTO cdb_stats VALUES ('week', '4', 0); INSERT INTO cdb_stats VALUES ('week', '5', 0); INSERT INTO cdb_stats VALUES ('week', '6', 0); INSERT INTO cdb_stats VALUES ('hour', '00', 0); INSERT INTO cdb_stats VALUES ('hour', '01', 0); INSERT INTO cdb_stats VALUES ('hour', '02', 0); INSERT INTO cdb_stats VALUES ('hour', '03', 0); INSERT INTO cdb_stats VALUES ('hour', '04', 0); INSERT INTO cdb_stats VALUES ('hour', '05', 0); INSERT INTO cdb_stats VALUES ('hour', '06', 0); INSERT INTO cdb_stats VALUES ('hour', '07', 0); INSERT INTO cdb_stats VALUES ('hour', '08', 0); INSERT INTO cdb_stats VALUES ('hour', '09', 0); INSERT INTO cdb_stats VALUES ('hour', '10', 1); INSERT INTO cdb_stats VALUES ('hour', '11', 0); INSERT INTO cdb_stats VALUES ('hour', '12', 0); INSERT INTO cdb_stats VALUES ('hour', '13', 0); INSERT INTO cdb_stats VALUES ('hour', '14', 0); INSERT INTO cdb_stats VALUES ('hour', '15', 0); INSERT INTO cdb_stats VALUES ('hour', '16', 0); INSERT INTO cdb_stats VALUES ('hour', '17', 0); INSERT INTO cdb_stats VALUES ('hour', '18', 0); INSERT INTO cdb_stats VALUES ('hour', '19', 0); INSERT INTO cdb_stats VALUES ('hour', '20', 0); INSERT INTO cdb_stats VALUES ('hour', '21', 0); INSERT INTO cdb_stats VALUES ('hour', '22', 0); INSERT INTO cdb_stats VALUES ('hour', '23', 0); -- -------------------------------------------------------- -- -- 表的结构 `cdb_statvars` -- DROP TABLE IF EXISTS cdb_statvars; CREATE TABLE cdb_statvars ( `type` varchar(20) NOT NULL default '', variable varchar(20) NOT NULL default '', `value` mediumtext NOT NULL, PRIMARY KEY (`type`,variable) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_statvars` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_styles` -- DROP TABLE IF EXISTS cdb_styles; CREATE TABLE cdb_styles ( styleid smallint(6) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL default '', available tinyint(1) NOT NULL default '1', templateid smallint(6) unsigned NOT NULL default '0', PRIMARY KEY (styleid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_styles` -- INSERT INTO cdb_styles VALUES (1, '默认风格', 1, 1); -- -------------------------------------------------------- -- -- 表的结构 `cdb_stylevars` -- DROP TABLE IF EXISTS cdb_stylevars; CREATE TABLE cdb_stylevars ( stylevarid smallint(6) unsigned NOT NULL auto_increment, styleid smallint(6) unsigned NOT NULL default '0', variable text NOT NULL, substitute text NOT NULL, PRIMARY KEY (stylevarid), KEY styleid (styleid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_stylevars` -- INSERT INTO cdb_stylevars VALUES ('1','1','boardimg','logo.gif'); INSERT INTO cdb_stylevars VALUES ('2','1','nobold','0'); INSERT INTO cdb_stylevars VALUES ('3','1','msgfontsize','12px'); INSERT INTO cdb_stylevars VALUES ('4','1','fontsize','12px'); INSERT INTO cdb_stylevars VALUES ('5','1','font','Tahoma, Verdana'); INSERT INTO cdb_stylevars VALUES ('6','1','tablespace','4'); INSERT INTO cdb_stylevars VALUES ('7','1','tablewidth','98%'); INSERT INTO cdb_stylevars VALUES ('8','1','borderwidth','1'); INSERT INTO cdb_stylevars VALUES ('9','1','text','#333333'); INSERT INTO cdb_stylevars VALUES ('10','1','tabletext','#333333'); INSERT INTO cdb_stylevars VALUES ('11','1','catcolor','#FFFFD9'); INSERT INTO cdb_stylevars VALUES ('12','1','headertext','#154BA0'); INSERT INTO cdb_stylevars VALUES ('13','1','headercolor','header_bg.gif'); INSERT INTO cdb_stylevars VALUES ('14','1','bordercolor','#86B9D6'); INSERT INTO cdb_stylevars VALUES ('15','1','link','#154BA0'); INSERT INTO cdb_stylevars VALUES ('16','1','altbg2','#FFFFFF'); INSERT INTO cdb_stylevars VALUES ('17','1','altbg1','#F5FBFF'); INSERT INTO cdb_stylevars VALUES ('18','1','bgcolor','#FFFFFF'); INSERT INTO cdb_stylevars VALUES ('19','1','imgdir','images/default'); INSERT INTO cdb_stylevars VALUES ('20','1','smdir','images/smilies'); INSERT INTO cdb_stylevars VALUES ('21','1','cattext','#92A05A'); INSERT INTO cdb_stylevars VALUES ('22','1','smfontsize','11px'); INSERT INTO cdb_stylevars VALUES ('23','1','smfont','Arial, Tahoma'); INSERT INTO cdb_stylevars VALUES ('24','1','maintablewidth','98%'); INSERT INTO cdb_stylevars VALUES ('25','1','maintablecolor','#FFFFFF'); INSERT INTO cdb_stylevars VALUES ('26','1','innerborderwidth','0'); INSERT INTO cdb_stylevars VALUES ('27','1','innerbordercolor','#D6E0EF'); INSERT INTO cdb_stylevars VALUES ('28','1','bgborder','#BBE9FF'); INSERT INTO cdb_stylevars VALUES ('29','1','inputborder','#7AC4EA'); INSERT INTO cdb_stylevars VALUES ('30','1','mainborder','#154BA0'); INSERT INTO cdb_stylevars VALUES ('31','1','catborder','#DEDEB8'); INSERT INTO cdb_stylevars VALUES ('32','1','lighttext','#666666'); INSERT INTO cdb_stylevars VALUES ('33','1','headermenu','menu_bg.gif'); INSERT INTO cdb_stylevars VALUES ('34','1','postnoticebg','#FDFFF2'); INSERT INTO cdb_stylevars VALUES ('35','1','msgheader','#F3F8D7'); INSERT INTO cdb_stylevars VALUES ('36','1','msgheadertext','#000000'); INSERT INTO cdb_stylevars VALUES ('37','1','msgtext','#FDFFF2'); INSERT INTO cdb_stylevars VALUES ('38','1','headermenutext','#154BA0'); INSERT INTO cdb_stylevars VALUES ('39','1','navtext','#154BA0'); INSERT INTO cdb_stylevars VALUES ('40','1','menubg','#D9EEF9'); INSERT INTO cdb_stylevars VALUES ('41','1','menutext','#154BA0'); INSERT INTO cdb_stylevars VALUES ('42','1','menuhltext','#FFFFFF'); INSERT INTO cdb_stylevars VALUES ('43','1','menuhlbg','#7AC4EA'); INSERT INTO cdb_stylevars VALUES ('44','1','calendartext','#000000'); INSERT INTO cdb_stylevars VALUES ('45','1','calendarexpire','#999999'); INSERT INTO cdb_stylevars VALUES ('46','1','calendarchecked','#FF0000'); INSERT INTO cdb_stylevars VALUES ('47','1','calendartoday','#00BB00'); -- -------------------------------------------------------- -- -- 表的结构 `cdb_subscriptions` -- DROP TABLE IF EXISTS cdb_subscriptions; CREATE TABLE cdb_subscriptions ( uid mediumint(8) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', lastpost int(10) unsigned NOT NULL default '0', lastnotify int(10) unsigned NOT NULL default '0', PRIMARY KEY (tid,uid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_subscriptions` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_templates` -- DROP TABLE IF EXISTS cdb_templates; CREATE TABLE cdb_templates ( templateid smallint(6) unsigned NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `directory` varchar(100) NOT NULL default '', copyright varchar(100) NOT NULL default '', PRIMARY KEY (templateid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_templates` -- INSERT INTO cdb_templates VALUES (1, '默认模板套系', './templates/default', '康盛创想（北京）科技有限公司'); -- -------------------------------------------------------- -- -- 表的结构 `cdb_threads` -- DROP TABLE IF EXISTS cdb_threads; CREATE TABLE cdb_threads ( tid mediumint(8) unsigned NOT NULL auto_increment, fid smallint(6) unsigned NOT NULL default '0', iconid smallint(6) unsigned NOT NULL default '0', typeid smallint(6) unsigned NOT NULL default '0', readperm tinyint(3) unsigned NOT NULL default '0', price smallint(6) NOT NULL default '0', author char(15) NOT NULL default '', authorid mediumint(8) unsigned NOT NULL default '0', `subject` char(80) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', lastpost int(10) unsigned NOT NULL default '0', lastposter char(15) NOT NULL default '', views int(10) unsigned NOT NULL default '0', replies mediumint(8) unsigned NOT NULL default '0', displayorder tinyint(1) NOT NULL default '0', highlight tinyint(1) NOT NULL default '0', digest tinyint(1) NOT NULL default '0', rate tinyint(1) NOT NULL default '0', blog tinyint(1) NOT NULL default '0', special tinyint(1) NOT NULL default '0', attachment tinyint(1) NOT NULL default '0', subscribed tinyint(1) NOT NULL default '0', moderated tinyint(1) NOT NULL default '0', closed mediumint(8) unsigned NOT NULL default '0', itemid mediumint(8) unsigned NOT NULL DEFAULT '0', supe_pushstatus tinyint(1) NOT NULL default '0', PRIMARY KEY (tid), KEY digest (digest), KEY displayorder (fid,displayorder,lastpost), KEY blog (blog,authorid,dateline), KEY typeid (fid,typeid,displayorder,lastpost) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_threads` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_threadsmod` -- DROP TABLE IF EXISTS cdb_threadsmod; CREATE TABLE cdb_threadsmod ( tid mediumint(8) unsigned NOT NULL default '0', uid mediumint(8) unsigned NOT NULL default '0', username char(15) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', expiration int(10) unsigned NOT NULL default '0', `action` char(3) NOT NULL default '', `status` tinyint(1) NOT NULL default '0', KEY tid (tid,dateline), KEY expiration (expiration,`status`) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_threadsmod` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_threadtypes` -- DROP TABLE IF EXISTS cdb_threadtypes; CREATE TABLE cdb_threadtypes ( typeid smallint(6) unsigned NOT NULL auto_increment, displayorder tinyint(3) NOT NULL default '0', `name` varchar(255) NOT NULL default '', description varchar(255) NOT NULL default '', PRIMARY KEY (typeid) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_threadtypes` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_tradelog` -- DROP TABLE IF EXISTS cdb_tradelog; CREATE TABLE cdb_tradelog ( tid mediumint(8) unsigned NOT NULL, orderid char(32) NOT NULL, tradeno char(32) NOT NULL, `subject` char(100) NOT NULL, price decimal(6,2) NOT NULL default '0.00', quality tinyint(1) unsigned NOT NULL default '0', itemtype tinyint(1) NOT NULL default '0', number smallint(5) unsigned NOT NULL default '0', tax decimal(6,2) unsigned NOT NULL default '0.00', locus char(100) NOT NULL, sellerid mediumint(8) unsigned NOT NULL, seller char(15) NOT NULL, selleraccount char(50) NOT NULL, buyerid mediumint(8) unsigned NOT NULL, buyer char(15) NOT NULL, buyercontact char(50) NOT NULL, buyercredits smallint(5) unsigned NOT NULL default '0', buyermsg char(200) default NULL, `status` tinyint(1) NOT NULL default '0', lastupdate int(10) unsigned NOT NULL default '0', UNIQUE KEY orderid (orderid), KEY sellerid (sellerid), KEY buyerid (buyerid), KEY tid (tid), KEY `status` (`status`), KEY buyerlog (buyerid,`status`,lastupdate), KEY sellerlog (sellerid,`status`,lastupdate) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_tradelog` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_trades` -- DROP TABLE IF EXISTS cdb_trades; CREATE TABLE cdb_trades ( tid mediumint(8) unsigned NOT NULL, sellerid mediumint(8) unsigned NOT NULL, seller char(15) NOT NULL, account char(50) NOT NULL, `subject` char(100) NOT NULL, price decimal(6,2) NOT NULL, amount smallint(6) unsigned NOT NULL default '1', quality tinyint(1) unsigned NOT NULL default '0', locus char(20) NOT NULL, transport tinyint(1) NOT NULL default '0', ordinaryfee smallint(4) unsigned NOT NULL default '0', expressfee smallint(4) unsigned NOT NULL default '0', emsfee smallint(4) unsigned NOT NULL default '0', itemtype tinyint(1) NOT NULL default '0', dateline int(10) unsigned NOT NULL default '0', expiration int(10) unsigned NOT NULL default '0', lastbuyer char(15) NOT NULL, lastupdate int(10) unsigned NOT NULL default '0', totalitems smallint(5) unsigned NOT NULL default '0', tradesum decimal(8,2) NOT NULL default '0.00', closed tinyint(1) NOT NULL default '0', PRIMARY KEY (tid), KEY sellerid (sellerid), KEY totalitems (totalitems), KEY tradesum (tradesum) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_trades` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_usergroups` -- DROP TABLE IF EXISTS cdb_usergroups; CREATE TABLE cdb_usergroups ( groupid smallint(6) unsigned NOT NULL auto_increment, radminid tinyint(3) NOT NULL default '0', `type` enum('system','special','member') NOT NULL default 'member', system char(8) NOT NULL default 'private', grouptitle char(30) NOT NULL default '', creditshigher int(10) NOT NULL default '0', creditslower int(10) NOT NULL default '0', stars tinyint(3) NOT NULL default '0', color char(7) NOT NULL default '', groupavatar char(60) NOT NULL default '', readaccess tinyint(3) unsigned NOT NULL default '0', allowvisit tinyint(1) NOT NULL default '0', allowpost tinyint(1) NOT NULL default '0', allowreply tinyint(1) NOT NULL default '0', allowpostpoll tinyint(1) NOT NULL default '0', allowpostreward tinyint(1) NOT NULL default '0', allowposttrade tinyint(1) NOT NULL default '0', allowpostactivity tinyint(1) NOT NULL default '0', allowdirectpost tinyint(1) NOT NULL default '0', allowgetattach tinyint(1) NOT NULL default '0', allowpostattach tinyint(1) NOT NULL default '0', allowvote tinyint(1) NOT NULL default '0', allowmultigroups tinyint(1) NOT NULL default '0', allowsearch tinyint(1) NOT NULL default '0', allowavatar tinyint(1) NOT NULL default '0', allowcstatus tinyint(1) NOT NULL default '0', allowuseblog tinyint(1) NOT NULL default '0', allowinvisible tinyint(1) NOT NULL default '0', allowtransfer tinyint(1) NOT NULL default '0', allowsetreadperm tinyint(1) NOT NULL default '0', allowsetattachperm tinyint(1) NOT NULL default '0', allowhidecode tinyint(1) NOT NULL default '0', allowhtml tinyint(1) NOT NULL default '0', allowcusbbcode tinyint(1) NOT NULL default '0', allowanonymous tinyint(1) NOT NULL default '0', allownickname tinyint(1) NOT NULL default '0', allowsigbbcode tinyint(1) NOT NULL default '0', allowsigimgcode tinyint(1) NOT NULL default '0', allowviewpro tinyint(1) NOT NULL default '0', allowviewstats tinyint(1) NOT NULL default '0', disableperiodctrl tinyint(1) NOT NULL default '0', reasonpm tinyint(1) NOT NULL default '0', maxprice smallint(6) unsigned NOT NULL default '0', maxpmnum smallint(6) unsigned NOT NULL default '0', maxsigsize smallint(6) unsigned NOT NULL default '0', maxattachsize mediumint(8) unsigned NOT NULL default '0', maxsizeperday int(10) unsigned NOT NULL default '0', maxpostsperhour tinyint(3) UNSIGNED NOT NULL default '0', attachextensions char(100) NOT NULL default '', raterange char(150) NOT NULL default '', tradetaxtype tinyint(1) NOT NULL default '1', tradetaxs smallint(6) unsigned NOT NULL default '0', mintradeprice smallint(6) unsigned NOT NULL default '1', maxtradeprice smallint(6) unsigned NOT NULL default '0', minrewardprice smallint(6) unsigned NOT NULL default '1', maxrewardprice smallint(6) unsigned NOT NULL default '0', PRIMARY KEY (groupid), KEY creditsrange (creditshigher,creditslower) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_usergroups` -- INSERT INTO cdb_usergroups VALUES (1, 1, 'system', 'private', '管理员', 0, 0, 9, '', '', 200, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 1, 1, 2, 3, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 30, 200, 500, 2048000, 0, 0, '', '1 -30 30 500', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (2, 2, 'system', 'private', '超级版主', 0, 0, 8, '', '', 150, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 0, 20, 120, 300, 2048000, 0, 0, 'chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png', '1 -15 15 50', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (3, 3, 'system', 'private', '版主', 0, 0, 7, '', '', 100, 1, 1, 1, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 3, 1, 1, 0, 1, 1, 1, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 0, 10, 80, 200, 2048000, 0, 0, 'chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png', '1 -10 10 30', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (4, 0, 'system', 'private', '禁止发言', 0, 0, 0, '', '', 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (5, 0, 'system', 'private', '禁止访问', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (6, 0, 'system', 'private', '禁止 IP', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (7, 0, 'system', 'private', '游客', 0, 0, 0, '', '', 1, 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, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (8, 0, 'system', 'private', '等待验证会员', 0, 0, 0, '', '', 0, 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, 1, 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (9, 0, 'member', 'private', '乞丐', -9999999, 0, 0, '', '', 0, 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, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (10, 0, 'member', 'private', '新手上路', 0, 50, 1, '', '', 10, 1, 1, 1, 0, 0, 1, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 20, 80, 0, 0, 0, 'chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png', '', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (11, 0, 'member', 'private', '注册会员', 50, 200, 2, '', '', 20, 1, 1, 1, 1, 0, 1, 0, 0, 1, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 30, 100, 0, 0, 0, 'chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png', '', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (12, 0, 'member', 'private', '中级会员', 200, 500, 3, '', '', 30, 1, 1, 1, 1, 0, 0, 0, 0, 1, 0, 1, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 1, 0, 0, 0, 50, 150, 256000, 0, 0, 'chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png', '0 -6 6 15', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (13, 0, 'member', 'private', '高级会员', 500, 1000, 4, '', '', 50, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 3, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 1, 0, 0, 0, 60, 200, 512000, 0, 0, 'chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png', '1 -10 10 30', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (14, 0, 'member', 'private', '金牌会员', 1000, 3000, 6, '', '', 70, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 3, 1, 0, 0, 0, 1, 1, 0, 0, 1, 0, 1, 1, 1, 1, 1, 0, 0, 0, 80, 300, 1024000, 0, 0, 'chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png', '1 -15 15 40', 1, 0, 1, 0, 1, 0); INSERT INTO cdb_usergroups VALUES (15, 0, 'member', 'private', '论坛元老', 3000, 9999999, 8, '', '', 90, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 3, 1, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 100, 500, 2048000, 0, 0, 'chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png', '1 -20 20 50', 1, 0, 1, 0, 1, 0); -- -------------------------------------------------------- -- -- 表的结构 `cdb_validating` -- DROP TABLE IF EXISTS cdb_validating; CREATE TABLE cdb_validating ( uid mediumint(8) unsigned NOT NULL default '0', submitdate int(10) unsigned NOT NULL default '0', moddate int(10) unsigned NOT NULL default '0', admin varchar(15) NOT NULL default '', submittimes tinyint(3) unsigned NOT NULL default '0', `status` tinyint(1) NOT NULL default '0', message text NOT NULL, remark text NOT NULL, PRIMARY KEY (uid), KEY `status` (`status`) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_validating` -- -- -------------------------------------------------------- -- -- 表的结构 `cdb_words` -- DROP TABLE IF EXISTS cdb_words; CREATE TABLE cdb_words ( id smallint(6) unsigned NOT NULL auto_increment, admin varchar(15) NOT NULL default '', find varchar(255) NOT NULL default '', replacement varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- 导出表中的数据 `cdb_words` --