⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 install_wind.sql

📁 很好的一套PHP树形论坛程序
💻 SQL
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
DROP TABLE IF EXISTS pw_actions;
CREATE TABLE pw_actions (
  id smallint(6) unsigned NOT NULL auto_increment,
  images char(15) NOT NULL default '',
  name char(15) NOT NULL default '',
  descrip char(100) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pw_actions(images,name,descrip) VALUES ('1.gif', '{#action_1}', '{#act_1}');
INSERT INTO pw_actions(images,name,descrip) VALUES ('2.gif', '{#action_2}', '{#act_2}');
INSERT INTO pw_actions(images,name,descrip) VALUES ('3.gif', '{#action_3}', '{#act_3}');
INSERT INTO pw_actions(images,name,descrip) VALUES ('4.gif', '{#action_4}', '{#act_4}');
INSERT INTO pw_actions(images,name,descrip) VALUES ('5.gif', '{#action_5}', '{#act_5}');

DROP TABLE IF EXISTS pw_adminset;
CREATE TABLE pw_adminset (
  gid tinyint(3) unsigned NOT NULL default '0',
  value text NOT NULL default '',
  PRIMARY KEY  (gid)
) TYPE=MyISAM;

INSERT INTO pw_adminset VALUES (3, 'settings	1\n1\nupdatecache	1\n1\npostcache	1\n1\ncredit	1\n1\nsetforum	1\n1\nuniteforum	1\n1\ncreathtm	1\n1\nsetuser	1\n1\nipsearch	1\n1\nuserstats	1\n1\nupgrade	1\n1\neditgroup	1\n1\nlevel	1\n1\narticle	1\n1\nmember	1\n1\nmessage	1\n1\nbanuser	1\n1\nviewban	1\n1\nipban	1\n1\nsetbwd	1\n1\ntpccheck	1\n1\npostcheck	1\n1\nreport	1\n1\ncheckemail	1\n1\ncheckreg	1\n1\nannouncement	1\n1\nmailuser	1\n1\nsend_msg	1\n1\ngiveuser	1\n1\nattachment	1\n1\nattachstats	1\n1\nattachrenew	1\n1\nadminlog	1\n1\nforumlog	1\n1\ncreditlog	1\n1\nuserlog	1\n1\nsetads	1\n1\nipstates	1\n1\nshare	1\n1\nviewtody	1\n1\nc_set	1\n1\nc_forum	1\n1\nc_unite	1\n1\nc_htm	1\n1\naddatc	1\n1\nschatc	1\n1\nbakout	0\n1\nbakin	0\n1\nrepair	0\n1\nsetstyles	1');
INSERT INTO pw_adminset VALUES (4, 'settings	0\n1\nupdatecache	0\n1\npostcache	1\n1\ncredit	0\n1\nsetforum	0\n1\nuniteforum	0\n1\ncreathtm	0\n1\nsetuser	0\n1\nipsearch	1\n1\nuserstats	1\n1\nupgrade	0\n1\neditgroup	1\n1\nlevel	0\n1\narticle	0\n1\nmember	0\n1\nmessage	1\n1\nbanuser	1\n1\nviewban	1\n1\nipban	1\n1\nsetbwd	1\n1\ntpccheck	1\n1\npostcheck	1\n1\nreport	1\n1\ncheckemail	1\n1\ncheckreg	1\n1\nannouncement	1\n1\nmailuser	0\n1\nsend_msg	0\n1\ngiveuser	1\n1\nattachment	1\n1\nattachstats	1\n1\nattachrenew	1\n1\nadminlog	0\n1\nforumlog	1\n1\ncreditlog	1\n1\nuserlog	1\n1\nsetads	1\n1\nipstates	0\n1\nshare	1\n1\nviewtody	1\n1\nc_set	0\n1\nc_forum	0\n1\nc_unite	0\n1\nc_htm	0\n1\naddatc	0\n1\nschatc	0\n1\nbakout	0\n1\nbakin	0\n1\nrepair	0\n1\nsetstyles	0');
INSERT INTO pw_adminset VALUES (5, 'settings	0\n1\nupdatecache	0\n1\npostcache	0\n1\ncredit	0\n1\nsetforum	0\n1\nuniteforum	0\n1\ncreathtm	0\n1\nsetuser	0\n1\nipsearch	0\n1\nuserstats	0\n1\nupgrade	0\n1\neditgroup	0\n1\nlevel	0\n1\narticle	0\n1\nmember	0\n1\nmessage	0\n1\nbanuser	1\n1\nviewban	1\n1\nipban	0\n1\nsetbwd	0\n1\ntpccheck	0\n1\npostcheck	0\n1\nreport	1\n1\ncheckemail	0\n1\ncheckreg	0\n1\nannouncement	1\n1\nmailuser	0\n1\nsend_msg	0\n1\ngiveuser	0\n1\nattachment	0\n1\nattachstats	0\n1\nattachrenew	0\n1\nadminlog	0\n1\nforumlog	1\n1\ncreditlog	1\n1\nuserlog	0\n1\nsetads	0\n1\nipstates	0\n1\nshare	0\n1\nviewtody	0\n1\nc_set	0\n1\nc_forum	0\n1\nc_unite	0\n1\nc_htm	0\n1\naddatc	0\n1\nschatc	0\n1\nbakout	0\n1\nbakin	0\n1\nrepair	0\n1\nsetstyles	0');

DROP TABLE IF EXISTS pw_announce;
CREATE TABLE pw_announce (
  aid smallint(6) unsigned NOT NULL auto_increment,
  fid smallint(6) NOT NULL default '-1',
  ffid smallint(6) NOT NULL default '0',
  vieworder smallint(6) NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  startdate varchar(15) NOT NULL default '',
  enddate varchar(15) NOT NULL default '',
  subject varchar(100) NOT NULL default '',
  content mediumtext NOT NULL default '',
  PRIMARY KEY  (aid),
  KEY ffid (ffid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_attachs;
CREATE TABLE pw_attachs (
  aid mediumint(8) unsigned NOT NULL auto_increment,
  fid smallint(6) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  pid int(10) unsigned NOT NULL default '0',
  name char(80) NOT NULL default '',
  type char(30) NOT NULL default '',
  size int(10) unsigned NOT NULL default '0',
  attachurl char(80) NOT NULL default '0',
  hits mediumint(8) unsigned NOT NULL default '0',
  needrvrc smallint(6) unsigned NOT NULL default '0',
  uploadtime int(10) NOT NULL default '0',
  descrip char(100) NOT NULL default '',
  PRIMARY KEY  (aid),
  KEY  (fid),
  KEY  (uid),
  KEY  (type)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_banuser;
CREATE TABLE pw_banuser (
  uid mediumint(8) unsigned NOT NULL default '0',
  type tinyint(1) NOT NULL default '0',
  startdate int(10) NOT NULL default '0',
  days int(4) NOT NULL default '0',
  admin char(15) NOT NULL default '',
  reason char(80) NOT NULL default '',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_bbsinfo;
CREATE TABLE pw_bbsinfo (
  id smallint(3) unsigned NOT NULL auto_increment,
  newmember varchar(15) NOT NULL default '',
  totalmember mediumint(8) unsigned NOT NULL default '0',
  higholnum smallint(6) unsigned NOT NULL default '0',
  higholtime int(10) unsigned NOT NULL default '0',
  tdtcontrol int(10) unsigned NOT NULL default '0',
  yposts mediumint(8) unsigned NOT NULL default '0',
  hposts mediumint(8) unsigned NOT NULL default '0',
  hit_tdtime int(10) unsigned NOT NULL default '0',
  hit_control tinyint(2) unsigned NOT NULL default '0',
  birthcontrol int(10) unsigned NOT NULL default '0',
  birthman text NOT NULL default '',
  KEY id (id)
) TYPE=MyISAM;

INSERT INTO pw_bbsinfo VALUES (1,'',0,0,0,0,0,0,0,0,0,'');

DROP TABLE IF EXISTS pw_config;
CREATE TABLE pw_config (
  db_name varchar(30) NOT NULL default '',
  db_value text NOT NULL default '',
  decrip text NOT NULL default '',
  PRIMARY KEY  (db_name)
) TYPE=MyISAM;

INSERT INTO pw_config VALUES('db_hour','20','');
INSERT INTO pw_config VALUES('db_http','N','');
INSERT INTO pw_config VALUES('db_autochange','0','');
INSERT INTO pw_config VALUES('db_bbsifopen','1','');
INSERT INTO pw_config VALUES('db_whybbsclose','论坛升级中... 请等候 15分钟','');
INSERT INTO pw_config VALUES('db_bbsname','金枫科技 Board','');
INSERT INTO pw_config VALUES('db_bbsurl','http://www.vxbbs.com','');
INSERT INTO pw_config VALUES('db_wwwname','金枫科技 Studio','');
INSERT INTO pw_config VALUES('db_wwwurl','http://www.vxbbs.com','');
INSERT INTO pw_config VALUES('db_ceoconnect','','');
INSERT INTO pw_config VALUES('db_ceoemail','mmcatv@hotmail.com','');
INSERT INTO pw_config VALUES('db_newtime','3600','');
INSERT INTO pw_config VALUES('db_signwindcode','1','');
INSERT INTO pw_config VALUES('db_windpic[\'pic\']','1','');
INSERT INTO pw_config VALUES('db_windpic[\'flash\']','0','');
INSERT INTO pw_config VALUES('db_windpic[\'picwidth\']','700','');
INSERT INTO pw_config VALUES('db_windpic[\'picheight\']','200','');
INSERT INTO pw_config VALUES('db_windpic[\'size\']','3','');
INSERT INTO pw_config VALUES('db_cvtime','0','');
INSERT INTO pw_config VALUES('db_timedf','8','');
INSERT INTO pw_config VALUES('db_perpage','50','');
INSERT INTO pw_config VALUES('db_readperpage','1','');
INSERT INTO pw_config VALUES('db_replysendmail','0','');
INSERT INTO pw_config VALUES('db_postmax','50000','');
INSERT INTO pw_config VALUES('db_windpost[\'pic\']','1','');
INSERT INTO pw_config VALUES('db_windpost[\'picwidth\']','700','');
INSERT INTO pw_config VALUES('db_windpost[\'picheight\']','','');
INSERT INTO pw_config VALUES('db_windpost[\'size\']','5','');
INSERT INTO pw_config VALUES('db_windpost[\'flash\']','0','');
INSERT INTO pw_config VALUES('db_indexnotice','1','');
INSERT INTO pw_config VALUES('db_showreplynum','5','');
INSERT INTO pw_config VALUES('db_windreply[\'pic\']','1','');
INSERT INTO pw_config VALUES('db_windreply[\'flash\']','0','');
INSERT INTO pw_config VALUES('db_dtreplyrvrc','1','');
INSERT INTO pw_config VALUES('db_refreshtime','0','');
INSERT INTO pw_config VALUES('db_onlinetime','3600','');
INSERT INTO pw_config VALUES('db_footertime','1','');
INSERT INTO pw_config VALUES('db_threadonline','0','');
INSERT INTO pw_config VALUES('db_uploadmaxsize','2048000','');
INSERT INTO pw_config VALUES('db_uploadfiletype','gif jpg rar txt zip swf jqf','');
INSERT INTO pw_config VALUES('db_attachdir','3','');
INSERT INTO pw_config VALUES('db_attachnum','4','');
INSERT INTO pw_config VALUES('db_windpost[\'mpeg\']','1','');
INSERT INTO pw_config VALUES('db_windpost[\'iframe\']','0','');
INSERT INTO pw_config VALUES('db_dtpostrvrc','10','');
INSERT INTO pw_config VALUES('db_dtpostmoney','5','');
INSERT INTO pw_config VALUES('db_dtjhrvrc','50','');
INSERT INTO pw_config VALUES('db_dtjhmoney','5','');
INSERT INTO pw_config VALUES('db_onlinelmt','0','');
INSERT INTO pw_config VALUES('db_dtdelrvrc','10','');
INSERT INTO pw_config VALUES('db_dtdelrprvrc','10','');
INSERT INTO pw_config VALUES('db_dtdelmoney','5','');
INSERT INTO pw_config VALUES('db_indexonline','0','');
INSERT INTO pw_config VALUES('db_ifjump','1','');
INSERT INTO pw_config VALUES('db_regpopup','0','');
INSERT INTO pw_config VALUES('db_ifonlinetime','0','');
INSERT INTO pw_config VALUES('db_showguest','0','');
INSERT INTO pw_config VALUES('db_recycle','3','');
INSERT INTO pw_config VALUES('db_indexshowbirth','0','');
INSERT INTO pw_config VALUES('db_obstart','1','');
INSERT INTO pw_config VALUES('db_indexlink','1','');
INSERT INTO pw_config VALUES('db_indexmqshare','0','');
INSERT INTO pw_config VALUES('db_defaultstyle','wind','');
INSERT INTO pw_config VALUES('db_ckpath','/','');
INSERT INTO pw_config VALUES('db_ckdomain','','');
INSERT INTO pw_config VALUES('db_windreadable','1','');
INSERT INTO pw_config VALUES('db_schpernum','10000','');
INSERT INTO pw_config VALUES('db_threademotion','0','');
INSERT INTO pw_config VALUES('db_todaypost','0','');
INSERT INTO pw_config VALUES('db_threadshowpost','1','');
INSERT INTO pw_config VALUES('db_indexfmlogo','2','');
INSERT INTO pw_config VALUES('db_autoimg','1','');
INSERT INTO pw_config VALUES('db_postmin','0','');
INSERT INTO pw_config VALUES('db_selcount','15','');
INSERT INTO pw_config VALUES('db_ipfrom','0','');
INSERT INTO pw_config VALUES('db_dtreplymoney','1','');
INSERT INTO pw_config VALUES('db_ipcheck','0','');
INSERT INTO pw_config VALUES('db_today','0','');
INSERT INTO pw_config VALUES('db_postallowtime','0','');
INSERT INTO pw_config VALUES('db_showonline','0','');
INSERT INTO pw_config VALUES('db_ipban','','');
INSERT INTO pw_config VALUES('db_ifcheck','1','');
INSERT INTO pw_config VALUES('db_ads','1','');
INSERT INTO pw_config VALUES('db_hithour','0','');
INSERT INTO pw_config VALUES('db_upgrade','1','');
INSERT INTO pw_config VALUES('db_lp','0','');
INSERT INTO pw_config VALUES('db_topped','0','');
INSERT INTO pw_config VALUES('db_msgsound','0','');
INSERT INTO pw_config VALUES('db_datefm','Y-m-d H:i','');
INSERT INTO pw_config VALUES('db_lgck','0','');
INSERT INTO pw_config VALUES('db_bfn','index.php','');
INSERT INTO pw_config VALUES('db_hfn','bbs','');
INSERT INTO pw_config VALUES('db_cfn','c_index.php','');
INSERT INTO pw_config VALUES('db_showgroup',',3,4,5,16,','');
INSERT INTO pw_config VALUES('db_upload','1	200	180	20480','');
INSERT INTO pw_config VALUES('db_allowupload','0','');
INSERT INTO pw_config VALUES('db_adminshow','0','');
INSERT INTO pw_config VALUES('db_maxpage','1000','');
INSERT INTO pw_config VALUES('db_maxmember','1000','');
INSERT INTO pw_config VALUES('db_titlemax','100','');
INSERT INTO pw_config VALUES('db_credits','金钱	RMB	威望	点	贡献值	点','');
INSERT INTO pw_config VALUES('db_savecheck','1','');
INSERT INTO pw_config VALUES('db_hash','%iRE^6NIeT','');
INSERT INTO pw_config VALUES('db_maxresult','500','');
INSERT INTO pw_config VALUES('db_creditset','a:3:{s:4:\"rvrc\";a:6:{s:6:\"Digest\";i:20;s:4:\"Post\";i:10;s:5:\"Reply\";i:10;s:8:\"Undigest\";i:20;s:6:\"Delete\";i:10;s:8:\"Deleterp\";i:10;}s:5:\"money\";a:6:{s:6:\"Digest\";i:20;s:4:\"Post\";i:10;s:5:\"Reply\";i:10;s:8:\"Undigest\";i:20;s:6:\"Delete\";i:10;s:8:\"Deleterp\";i:10;}i:1;a:6:{s:6:\"Digest\";i:0;s:4:\"Post\";i:0;s:5:\"Reply\";i:0;s:8:\"Undigest\";i:0;s:6:\"Delete\";i:0;s:8:\"Deleterp\";i:0;}}','');
INSERT INTO pw_config VALUES('db_ajaxsubject','0','');
INSERT INTO pw_config VALUES('db_ajaxcontent','0','');
INSERT INTO pw_config VALUES('db_debug','0','');
INSERT INTO pw_config VALUES('db_gdcheck','0	0	0	0	0	0','');
INSERT INTO pw_config VALUES('db_signmoney','0','');
INSERT INTO pw_config VALUES('db_signgroup',',5,6,7,16,8,9,10,11,12,13,14,15,','');
INSERT INTO pw_config VALUES('db_watermark','0','');
INSERT INTO pw_config VALUES('db_waterpos','1','');
INSERT INTO pw_config VALUES('db_waterimg','mark.gif','');
INSERT INTO pw_config VALUES('db_watertext','http://www.vxbbs.com','');
INSERT INTO pw_config VALUES('db_waterfont','5','');
INSERT INTO pw_config VALUES('db_watercolor','#0000FF','');
INSERT INTO pw_config VALUES('db_waterpct','85','');
INSERT INTO pw_config VALUES('db_cvtimes','-1','');
INSERT INTO pw_config VALUES('db_forumdir','0','');
INSERT INTO pw_config VALUES('db_attachurl','N','');
INSERT INTO pw_config VALUES('db_kijiji','1','');
INSERT INTO pw_config VALUES('db_adminreason','广告帖\n恶意灌水\n非法内容\n与版规不符\n重复发帖\n\n优秀文章\n原创内容','');
INSERT INTO pw_config VALUES('db_charset','gbk','');
INSERT INTO pw_config VALUES('db_cc','0','');
INSERT INTO pw_config VALUES('db_jsifopen','0','');
INSERT INTO pw_config VALUES('db_jsper','600','');
INSERT INTO pw_config VALUES('db_bindurl','','');
INSERT INTO pw_config VALUES('ml_mailifopen','1','');
INSERT INTO pw_config VALUES('ml_mailmethod','1','');
INSERT INTO pw_config VALUES('ml_smtpauth','1','');
INSERT INTO pw_config VALUES('ml_smtpfrom','','');
INSERT INTO pw_config VALUES('ml_smtphost','','');
INSERT INTO pw_config VALUES('ml_smtppass','','');
INSERT INTO pw_config VALUES('ml_smtpport','','');
INSERT INTO pw_config VALUES('ml_smtpuser','','');
INSERT INTO pw_config VALUES('rg_whyregclose','管理员关闭了注册!','');
INSERT INTO pw_config VALUES('rg_allowregister','1','');
INSERT INTO pw_config VALUES('rg_reg','1','');
INSERT INTO pw_config VALUES('rg_regdetail','0','');
INSERT INTO pw_config VALUES('rg_regsendemail','1','');
INSERT INTO pw_config VALUES('rg_emailcheck','0','');
INSERT INTO pw_config VALUES('rg_regminname','3','');
INSERT INTO pw_config VALUES('rg_regmaxname','12','');
INSERT INTO pw_config VALUES('rg_regsendmsg','0','');
INSERT INTO pw_config VALUES('rg_regrvrc','10','');
INSERT INTO pw_config VALUES('rg_regmoney','0','');
INSERT INTO pw_config VALUES('rg_ifcheck','0','');
INSERT INTO pw_config VALUES('rg_allowsameip','1','');
INSERT INTO pw_config VALUES('rg_welcomemsg','感谢您的注册，欢迎您的到来，希望这里能给您带来快乐！多多发言吧！本站全体管理人员向您问好\n您的注册名为:$rg_name\n您的密码已设置保密\n请尽快删除此信息，以免别人偷看到你的密码.','');
INSERT INTO pw_config VALUES('rg_rgpermit','当您申请用户时，表示您已经同意遵守本规章。 \n\n欢迎您加入本站点参加交流和讨论，本站点为公共论坛，为维护网上公共秩序和社会稳定，请您自觉遵守以下条款： \n\n一、不得利用本站危害国家安全、泄露国家秘密，不得侵犯国家社会集体的和公民的合法权益，不得利用本站制作、复制和传播下列信息：\n　 （一）煽动抗拒、破坏宪法和法律、行政法规实施的；\n　（二）煽动颠覆国家政权，推翻社会主义制度的；\n　（三）煽动分裂国家、破坏国家统一的；\n　（四）煽动民族仇恨、民族歧视，破坏民族团结的；\n　（五）捏造或者歪曲事实，散布谣言，扰乱社会秩序的；\n　（六）宣扬封建迷信、淫秽、色情、赌博、暴力、凶杀、恐怖、教唆犯罪的；\n　（七）公然侮辱他人或者捏造事实诽谤他人的，或者进行其他恶意攻击的；\n　（八）损害国家机关信誉的；\n　（九）其他违反宪法和法律行政法规的；\n　（十）进行商业广告行为的。\n\n二、互相尊重，对自己的言论和行为负责。\n三、禁止在申请用户时使用相关本站的词汇，或是带有侮辱、毁谤、造谣类的或是有其含义的各种语言进行注册用户，否则我们会将其删除。\n四、禁止以任何方式对本站进行各种破坏行为。\n五、如果您有违反国家相关法律法规的行为，本站概不负责，您的登录论坛信息均被记录无疑，必要时，我们会向相关的国家管理部门提供此类信息。 ','');
INSERT INTO pw_config VALUES('db_editthreads','0','');
INSERT INTO pw_config VALUES('db_gfont','0','');
INSERT INTO pw_config VALUES('rg_rglower','0','');
INSERT INTO pw_config VALUES('rg_banname','版主,管理员,admin,斑竹','');
INSERT INTO pw_config VALUES('ol_onlinepay','0','');
INSERT INTO pw_config VALUES('ol_whycolse','系统没有开启网上支付功能!','');
INSERT INTO pw_config VALUES('df_per','6','');
INSERT INTO pw_config VALUES('df_notice','1','');
INSERT INTO pw_config VALUES('df_Nnum','5','');
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -