打印

《Discuz!6.0数据字典》非官方不完美版

本主题由 Clwarm 于 2007-11-19 22:56 加入精华

习明

注册会员

Rank: 2

帖子: 6
积分: 161
威望: 11
金币: 45
注册时间: 2007-5-26

11^# 大中小发表于 2008-1-2 14:16 只看该作者

引用:

原帖由 renothing 于 2008-1-2 08:42 发表
我只是随便看了下settings表结构.......一个字段都没有。。

这位兄弟搞笑呢吧 settings表一共就俩字段.....

TOP

renothing

keeper

金牌会员

Rank: 6 Rank: 6

EDsicuz! Team

帖子: 328
积分: 1249
威望: 50
金币: 421
注册时间: 2005-1-10

12^# 大中小发表于 2008-1-2 17:27 只看该作者

哦,是字段里的值

复制内容到剪贴板

代码:

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','0');

INSERT INTO cdb_settings VALUES ('attachsave','3');

INSERT INTO cdb_settings VALUES ('authkey','CrVSXaKzoyJb4Rd');

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','0');

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 ('doublee','1');

INSERT INTO cdb_settings VALUES ('dupkarmarate','0');

INSERT INTO cdb_settings VALUES ('ec_account','');

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 ('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','0');

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','0');

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','100');

INSERT INTO cdb_settings VALUES ('maxsmilies','10');

INSERT INTO cdb_settings VALUES ('maxspm','0');

INSERT INTO cdb_settings VALUES ('maxsubscriptions','100');

INSERT INTO cdb_settings VALUES ('notice','1');

INSERT INTO cdb_settings VALUES ('backupdir','uXDPv6');

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','0');

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 ('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 ('showimages','1');

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','1');

INSERT INTO cdb_settings VALUES ('subforumsindex','');

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','尊敬的{username}，您已经注册成为{sitename}的会员，请您在发表言论时，遵守当地法律法规。\r\n如果您有什么疑问可以联系管理员，Email: {adminemail}。\r\n\r\n\r\n{bbname}\r\n{time}');

INSERT INTO cdb_settings VALUES ('whosonlinestatus','1');

INSERT INTO cdb_settings VALUES ('indexname','index.php');

INSERT INTO cdb_settings VALUES ('spacedata','a:9:{s:9:\"cachelife\";s:3:\"900\";s:14:\"limitmythreads\";s:1:\"5\";s:14:\"limitmyreplies\";s:1:\"5\";s:14:\"limitmyrewards\";s:1:\"5\";s:12:\"limitmyblogs\";s:1:\"8\";s:14:\"limitmyfriends\";s:1:\"0\";s:16:\"limitmyfavforums\";s:1:\"5\";s:17:\"limitmyfavthreads\";s:1:\"0\";s:10:\"textlength\";s:3:\"300\";}');

INSERT INTO cdb_settings VALUES ('thumbstatus','0');

INSERT INTO cdb_settings VALUES ('thumbwidth','400');

INSERT INTO cdb_settings VALUES ('thumbheight','300');

INSERT INTO cdb_settings VALUES ('forumlinkstatus','1');

INSERT INTO cdb_settings VALUES ('pluginjsmenu','插件');

INSERT INTO cdb_settings VALUES ('ftp','a:10:{s:2:\"on\";s:1:\"0\";s:3:\"ssl\";s:1:\"0\";s:4:\"host\";s:0:\"\";s:4:\"port\";s:2:\"21\";s:8:\"username\";s:0:\"\";s:8:\"password\";s:0:\"\";s:9:\"attachdir\";s:1:\".\";s:9:\"attachurl\";s:0:\"\";s:7:\"hideurl\";s:1:\"0\";s:7:\"timeout\";s:1:\"0\";}');

INSERT INTO cdb_settings VALUES ('wapregister','0');

INSERT INTO cdb_settings VALUES ('jswizard','');

INSERT INTO cdb_settings VALUES ('seccodeanimator','1');

INSERT INTO cdb_settings VALUES ('welcomemsgtitle','{username}，您好，感谢您的注册，请阅读以下内容。');

INSERT INTO cdb_settings VALUES ('cacheindexlife','0');

INSERT INTO cdb_settings VALUES ('cachethreadlife','0');

INSERT INTO cdb_settings VALUES ('cachethreaddir','forumdata/threadcaches');

INSERT INTO cdb_settings VALUES ('jsdateformat','');

INSERT INTO cdb_settings VALUES ('seccodedata','a:13:{s:8:\"minposts\";s:0:\"\";s:16:\"loginfailedcount\";i:0;s:5:\"width\";i:150;s:6:\"height\";i:60;s:4:\"type\";s:1:\"0\";s:10:\"background\";s:1:\"1\";s:10:\"adulterate\";s:1:\"1\";s:3:\"ttf\";s:1:\"0\";s:5:\"angle\";s:1:\"0\";s:5:\"color\";s:1:\"1\";s:4:\"size\";s:1:\"0\";s:6:\"shadow\";s:1:\"1\";s:8:\"animator\";s:1:\"0\";}');

INSERT INTO cdb_settings VALUES ('frameon','0');

INSERT INTO cdb_settings VALUES ('framewidth','180');

INSERT INTO cdb_settings VALUES ('smrows','4');

INSERT INTO cdb_settings VALUES ('watermarktype','0');

INSERT INTO cdb_settings VALUES ('secqaa','a:2:{s:8:\"minposts\";s:1:\"1\";s:6:\"status\";i:0;}');

INSERT INTO cdb_settings VALUES ('supe_circlestatus','0');

INSERT INTO cdb_settings VALUES ('spacestatus','1');

INSERT INTO cdb_settings VALUES ('whosonline_contract','0');

INSERT INTO cdb_settings VALUES ('attachdir','./attachments');

INSERT INTO cdb_settings VALUES ('attachurl','attachments');

INSERT INTO cdb_settings VALUES ('onlinehold','15');

INSERT INTO cdb_settings VALUES ('msgforward', 'a:3:{s:11:\"refreshtime\";i:3;s:5:\"quick\";i:1;s:8:\"messages\";a:13:{i:0;s:19:\"thread_poll_succeed\";i:1;s:19:\"thread_rate_succeed\";i:2;s:23:\"usergroups_join_succeed\";i:3;s:23:\"usergroups_exit_succeed\";i:4;s:25:\"usergroups_update_succeed\";i:5;s:20:\"buddy_update_succeed\";i:6;s:17:\"post_edit_succeed\";i:7;s:18:\"post_reply_succeed\";i:8;s:24:\"post_edit_delete_succeed\";i:9;s:22:\"post_newthread_succeed\";i:10;s:13:\"admin_succeed\";i:11;s:17:\"pm_delete_succeed\";i:12;s:15:\"search_redirect\";}}');

INSERT INTO cdb_settings VALUES ('smthumb','20');

INSERT INTO cdb_settings VALUES ('tagstatus', 1);

INSERT INTO cdb_settings VALUES ('hottags', 20);

INSERT INTO cdb_settings VALUES ('viewthreadtags', 100);

INSERT INTO cdb_settings VALUES ('rewritecompatible', '');

INSERT INTO cdb_settings VALUES ('imagelib', '0');

INSERT INTO cdb_settings VALUES ('imageimpath', '');

INSERT INTO cdb_settings VALUES ('regname', 'register.php');

INSERT INTO cdb_settings VALUES ('reglinkname', '注册');

INSERT INTO cdb_settings VALUES ('userdateformat','Y-n-j\r\nY/n/j\r\nj-n-Y\r\nj/n/Y');

INSERT INTO cdb_settings VALUES ('customauthorinfo', 'a:1:{i:0;a:9:{s:3:\"uid\";a:1:{s:4:\"menu\";s:1:\"1\";}s:5:\"posts\";a:1:{s:4:\"menu\";s:1:\"1\";}s:6:\"digest\";a:1:{s:4:\"menu\";s:1:\"1\";}s:7:\"credits\";a:1:{s:4:\"menu\";s:1:\"1\";}s:8:\"readperm\";a:1:{s:4:\"menu\";s:1:\"1\";}s:8:\"location\";a:1:{s:4:\"menu\";s:1:\"1\";}s:6:\"oltime\";a:1:{s:4:\"menu\";s:1:\"1\";}s:7:\"regtime\";a:1:{s:4:\"menu\";s:1:\"1\";}s:8:\"lastdate\";a:1:{s:4:\"menu\";s:1:\"1\";}}}');

INSERT INTO cdb_settings VALUES ('ec_credit', 'a:2:{s:18:"maxcreditspermonth";i:6;s:4:"rank";a:15:{i:1;i:4;i:2;i:11;i:3;i:41;i:4;i:91;i:5;i:151;i:6;i:251;i:7;i:501;i:8;i:1001;i:9;i:2001;i:10;i:5001;i:11;i:10001;i:12;i:20001;i:13;i:50001;i:14;i:100001;i:15;i:200001;}}');

INSERT INTO cdb_settings VALUES ('mail', 'a:10:{s:8:"mailsend";s:1:"1";s:6:"server";s:13:"smtp.21cn.com";s:4:"port";s:2:"25";s:4:"auth";s:1:"1";s:4:"from";s:26:"Discuz <username@21cn.com>";s:13:"auth_username";s:17:"username@21cn.com";s:13:"auth_password";s:8:"password";s:13:"maildelimiter";s:1:"0";s:12:"mailusername";s:1:"1";s:15:"sendmail_silent";s:1:"1";}');

INSERT INTO cdb_settings VALUES ('watermarktext', '');

INSERT INTO cdb_settings VALUES ('watermarkminwidth', '0');

INSERT INTO cdb_settings VALUES ('watermarkminheight', '0');

INSERT INTO cdb_settings VALUES ('inviteconfig', '');

INSERT INTO cdb_settings VALUES ('historyposts', '0        0');

INSERT INTO cdb_settings VALUES ('zoomstatus', '1');

INSERT INTO cdb_settings VALUES ('postno', '#');

INSERT INTO cdb_settings VALUES ('postnocustom', '');

INSERT INTO cdb_settings VALUES ('google','');

INSERT INTO cdb_settings VALUES ('baidusitemap','1');

INSERT INTO cdb_settings VALUES ('baidusitemap_life','12');