install_wind.sql

很好的一套PHP树形论坛程序

INSERT INTO pw_config VALUES('df_Nlen','35','');
INSERT INTO pw_config VALUES('df_allnew','1','');
INSERT INTO pw_config VALUES('df_Anum','5','');
INSERT INTO pw_config VALUES('df_Alen','35','');
INSERT INTO pw_config VALUES('df_Tlen','35','');
INSERT INTO pw_config VALUES('df_Llen','19','');
INSERT INTO pw_config VALUES('df_Lnum','9','');
INSERT INTO pw_config VALUES('df_Rlen','35','');
INSERT INTO pw_config VALUES('df_Rnum','8','');
INSERT INTO pw_config VALUES('df_Flen','35','');
INSERT INTO pw_config VALUES('df_Fnum','8','');
INSERT INTO pw_config VALUES('df_NEW','0	4','');
INSERT INTO pw_config VALUES('df_CMS','0	4','');
INSERT INTO pw_config VALUES('df_FID','0	2','');
INSERT INTO pw_config VALUES('df_cache','postnum	0	1\n2\n1	9\n1\nrvrc	0	1\n2\n1	9\n1\nmoney	0	1\n2\n1	9\n1\ntodaypost	0	1\n2\n1	9\n1\ncredit	0	1\n2\n1	9\n1\ncustom	0	1\n2\n1	9\n1\nreply	0	1\n2\n1	5\n1\nhit	0	1\n2\n1	5\n1\ndigest	0	1\n2\n1	5','');
INSERT INTO pw_config VALUES('df_forumlogo','','');
INSERT INTO pw_config VALUES('db_showcms','0','');
INSERT INTO pw_config VALUES('db_cmsifopen','0','');
INSERT INTO pw_config VALUES('db_whycmsclose','文章系统关闭中,请从顶部链接进入社区','');
INSERT INTO pw_config VALUES('db_union','','');
INSERT INTO pw_config VALUES('db_showcolony','0','');
INSERT INTO pw_config VALUES('db_registercn','1','');
INSERT INTO pw_config VALUES('db_postindex','1','');
INSERT INTO pw_config VALUES('db_forumsup','0','');
INSERT INTO pw_config VALUES('db_readhits','1','');
INSERT INTO pw_config VALUES('db_hitshtml','1','');
INSERT INTO pw_config VALUES('db_rethreadpage','100','');
INSERT INTO pw_config VALUES('db_threadtxt','font-size: 13px; font-weight:bold;','');
INSERT INTO pw_config VALUES('db_replytxt','color: blue;','');
INSERT INTO pw_config VALUES('db_usernametxt','color: red;font-size: 12px; font-weight:bold;','');
INSERT INTO pw_config VALUES('db_mmcatvheader','color: #ff0000;font-size: 16px; ','');
INSERT INTO pw_config VALUES('db_mmcatvforums','color: #008000;font-size: 16px;','');
INSERT INTO pw_config VALUES('db_threadmei','color: #000000;','');
INSERT INTO pw_config VALUES('db_rethreadmei','color: #999999;','');
INSERT INTO pw_config VALUES('db_thusername','color: #FF0000; font-weight:bold;','');
INSERT INTO pw_config VALUES('db_reusername','color: #FF0000;','');

DROP TABLE IF EXISTS pw_credits;
CREATE TABLE pw_credits (
  cid tinyint(3) unsigned NOT NULL auto_increment,
  name char(30) NOT NULL default '',
  unit char(30) NOT NULL default '',
  description char(255) NOT NULL default '',
  PRIMARY KEY  (cid)
) TYPE=MyISAM;

INSERT INTO pw_credits VALUES ('1', '{#credit_name}','{#credit_unit}', '{#credit_descrip}');

DROP TABLE IF EXISTS pw_favors;
CREATE TABLE pw_favors (
  uid mediumint(8) unsigned NOT NULL default '0',
  tids text NOT NULL default '',
  KEY uid (uid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_forums;
CREATE TABLE pw_forums (
  fid smallint(6) unsigned NOT NULL auto_increment,
  fup smallint(6) unsigned NOT NULL default '0',
  ifsub tinyint(1) NOT NULL default '0',
  childid tinyint(1) NOT NULL default '0',
  type enum('category','forum','sub') NOT NULL default 'forum',
  logo char(100) NOT NULL default '',
  name char(50) NOT NULL default '',
  descrip char(255) NOT NULL default '',
  dirname char(15) NOT NULL default '',
  vieworder tinyint(3) NOT NULL default '0',
  forumadmin char(255) NOT NULL default '',
  style char(12) NOT NULL default '',
  across tinyint(4) NOT NULL default '0',
  allowhtm tinyint(1) NOT NULL default '0',
  allowhide tinyint(1) NOT NULL default '1',
  allowsell tinyint(1) NOT NULL default '1',
  copyctrl tinyint(1) NOT NULL default '0',
  allowencode tinyint(1) NOT NULL default '1',
  password char(32) NOT NULL default '',
  viewsub tinyint(1) NOT NULL default '0',
  allowvisit char(120) NOT NULL default '',
  allowpost char(120) NOT NULL default '',
  allowrp char(120) NOT NULL default '',
  allowdownload char(120) NOT NULL default '',
  allowupload char(120) NOT NULL default '',
  f_type enum('forum','former','hidden','vote') NOT NULL default 'forum',
  f_check tinyint(1) unsigned NOT NULL default '0',
  t_type char(255) NOT NULL default '',
  cms tinyint(1) NOT NULL default '0',
  ifhide tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (fid),
  KEY fup (fup),
  KEY type (ifsub,vieworder,fup)
) TYPE=MyISAM;

INSERT INTO pw_forums VALUES('1','0','0','1','category','','默认分类','','','0','','','0','0','1','1','0','1','','0','','','','','','forum','0','0','0','1');
INSERT INTO pw_forums VALUES('2','1','0','1','forum','','精英主论坛','','','0','','','0','1','1','1','0','1','','0','','','','','','forum','0','0','0','1');
INSERT INTO pw_forums VALUES('3','2','1','0','sub','','回收站','','','0','','0','0','0','1','1','0','1','','0',',3,','','','','','hidden','0','0													','0','1');

DROP TABLE IF EXISTS pw_forumdata;
CREATE TABLE pw_forumdata (
  fid smallint(6) unsigned NOT NULL auto_increment,
  tpost mediumint(8) unsigned NOT NULL default '0',
  topic mediumint(8) unsigned NOT NULL default '0',
  article mediumint(8) unsigned NOT NULL default '0',
  subtopic mediumint(8) unsigned NOT NULL default '0',
  top1 smallint(6) unsigned NOT NULL default '0',
  top2 smallint(6) unsigned NOT NULL default '0',
  lastpost char(135) NOT NULL default '',
  PRIMARY KEY  (fid)
) TYPE=MyISAM;

INSERT INTO pw_forumdata SET fid = 1, tpost = 0, topic = 0, article = 0, subtopic = 0, top1 = 0, top2 = 0, lastpost = '';
INSERT INTO pw_forumdata SET fid = 2, tpost = 0, topic = 0, article = 0, subtopic = 0, top1 = 0, top2 = 0, lastpost = '';
INSERT INTO pw_forumdata SET fid = 3, tpost = 0, topic = 0, article = 0, subtopic = 0, top1 = 0, top2 = 0, lastpost = '';


DROP TABLE IF EXISTS pw_hack;
CREATE TABLE pw_hack (
  hk_name varchar(30) NOT NULL default '',
  hk_value text NOT NULL default '',
  decrip text NOT NULL default '',
  PRIMARY KEY  (hk_name)
) TYPE=MyISAM;

INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_A','a:1:{s:10:"rvrc_money";a:6:{i:0;s:4:"{#rvrc}";i:1;s:4:"{#money}";i:2;s:1:"2";i:3;s:1:"3";i:4;s:1:"1";i:5;i:1;}}','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_ddate','10','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_drate','10','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_num','10','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_open','1','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_per','5','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_rate','5','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_timelimit','2','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_virelimit','10','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_virement','1','');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES('bk_virerate','10','');

INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES ('currrate1', 'a:4:{s:4:"rvrc";i:10;s:5:"money";i:0;s:6:"credit";i:0;i:1;i:2;}', '');
INSERT INTO pw_hack(hk_name,hk_value,decrip) VALUES ('currrate2', '', '');


DROP TABLE IF EXISTS pw_ipstates;
CREATE TABLE pw_ipstates (
day CHAR( 10 ) NOT NULL default '',
month CHAR( 7 ) NOT NULL default '',
nums INT( 10 ) NOT NULL default '0',
PRIMARY KEY (day)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_keyword;
CREATE TABLE pw_keyword (
  kid int(10) NOT NULL auto_increment,
  kname varchar(20) NOT NULL default '',
  PRIMARY KEY  (kid),
  KEY kname (kname)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_ks;
CREATE TABLE pw_ks (
  kid int(10) NOT NULL default '0',
  tid int(10) NOT NULL default '0',
  KEY kid (kid),
  KEY tid (tid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_membercredit;
CREATE TABLE pw_membercredit (
  uid mediumint(8) unsigned NOT NULL default '0',
  cid tinyint(3) NOT NULL default '0',
  value mediumint(8) unsigned NOT NULL default '0',
  KEY uid (uid),
  KEY cid (cid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_memberdata;
CREATE TABLE pw_memberdata (
  uid mediumint(8) unsigned NOT NULL default '1',
  postnum int(10) unsigned NOT NULL default '0',
  digests smallint(6) NOT NULL default '0',
  rvrc int(10) NOT NULL default '0',
  money int(10) NOT NULL default '0',
  credit int(10) NOT NULL default '0',
  currency INT( 10 ) NOT NULL default '0',
  editor tinyint(1) NOT NULL default '0',
  lastvisit int(10) unsigned NOT NULL default '0',
  thisvisit int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  onlinetime int(10) unsigned NOT NULL default '0',
  todaypost smallint(6) unsigned NOT NULL default '0',
  uploadtime int(10) unsigned NOT NULL default '0',
  uploadnum smallint(6) unsigned NOT NULL default '0',
  onlineip char(30) NOT NULL default '',
  starttime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY uid (uid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_memberinfo;
CREATE TABLE pw_memberinfo (
  uid mediumint(8) unsigned NOT NULL default '1',
  adsips mediumtext NOT NULL default '',
  credit varchar(50) NOT NULL default '',
  deposit int(10) NOT NULL default '0',
  startdate int(10) NOT NULL default '0',
  ddeposit int(10) NOT NULL default '0',
  dstartdate int(10) NOT NULL default '0',
  regreason varchar(255) NOT NULL default '',
  customcredit TEXT NOT NULL default '',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_members;
CREATE TABLE pw_members (
  uid mediumint(8) unsigned NOT NULL auto_increment,
  username varchar(20) NOT NULL default '',
  password varchar(40) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  publicmail tinyint(1) NOT NULL default '0',
  groupid tinyint(3) NOT NULL default '-1',
  memberid tinyint(3) NOT NULL default '0',
  groups varchar(255) NOT NULL default '',
  icon varchar(100) NOT NULL default '',
  gender tinyint(1) NOT NULL default '0',
  regdate int(10) unsigned NOT NULL default '0',
  signature text NOT NULL default '',
  introduce text NOT NULL default '',
  oicq varchar(12) NOT NULL default '',
  icq varchar(12) NOT NULL default '',
  msn varchar(35) NOT NULL default '',
  yahoo varchar(35) NOT NULL default '',
  site varchar(75) NOT NULL default '',
  location varchar(36) NOT NULL default '',
  honor varchar(30) NOT NULL default '',
  bday date NOT NULL default '0000-00-00',
  receivemail tinyint(1) NOT NULL default '0',
  yz int(10) NOT NULL default '1',
  timedf varchar(5) NOT NULL default '',
  style varchar(12) NOT NULL default '',
  datefm varchar(15) NOT NULL default '',
  t_num tinyint(3) unsigned NOT NULL default '0',
  p_num tinyint(3) unsigned NOT NULL default '0',
  hack varchar(255) NOT NULL default '0',
  signchange tinyint(1) NOT NULL default '0',
  newpm tinyint(1) NOT NULL default '0',
  banpm text NOT NULL default '',
  msggroups VARCHAR( 255 ) NOT NULL default '',
  showsign tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  medals varchar(255) NOT NULL default '',
  payemail varchar(60) NOT NULL default '',
  PRIMARY KEY  (uid),
  KEY username (username)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_msg;
CREATE TABLE pw_msg (
  mid int(10) unsigned NOT NULL auto_increment,
  touid mediumint(8) unsigned NOT NULL default '0',
  fromuid mediumint(8) unsigned NOT NULL default '0',
  username varchar(15) NOT NULL default '',