install_wind.sql

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

  type enum('rebox','sebox') NOT NULL default 'rebox',
  ifnew tinyint(1) NOT NULL default '0',
  title varchar(130) NOT NULL default '',
  mdate int(10) unsigned NOT NULL default '0',
  content text NOT NULL default '',
  PRIMARY KEY  (mid),
  KEY touid (touid),
  KEY fromuid (fromuid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_polls;
CREATE TABLE pw_polls (
  pollid int(10) unsigned NOT NULL auto_increment,
  voteopts mediumtext NOT NULL default '',
  PRIMARY KEY  (pollid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_posts;
CREATE TABLE pw_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',
  aid text NOT NULL default '',
  author varchar(15) NOT NULL default '',
  authorid mediumint(8) unsigned NOT NULL default '0',
  icon tinyint(2) NOT NULL default '0',
  postdate int(10) unsigned NOT NULL default '0',
  subject varchar(200) NOT NULL default '',
  userip varchar(15) NOT NULL default '',
  ifsign tinyint(1) NOT NULL default '0',
  buy text NOT NULL default '',
  alterinfo varchar(50) NOT NULL default '',
  ipfrom varchar(30) NOT NULL default '',
  ifconvert tinyint(1) NOT NULL default '0',
  ifcheck tinyint(1) NOT NULL default '0',
  content mediumtext NOT NULL default '',
  ifmark varchar(255) NOT NULL default '',
  PRIMARY KEY  (pid),
  KEY fid (fid),
  KEY tid (tid),
  KEY authorid (authorid),
  KEY ifcheck (ifcheck)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_report;
CREATE TABLE pw_report (
  id int(10) unsigned NOT NULL auto_increment,
  tid mediumint(8) unsigned NOT NULL default '0',
  pid int(10) unsigned NOT NULL default '0',
  uid mediumint(9) NOT NULL default '0',
  type tinyint(1) NOT NULL default '0',
  reason char(255) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY type (type)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_schcache;
CREATE TABLE pw_schcache (
  sid int(10) unsigned NOT NULL auto_increment,
  schline varchar(255) NOT NULL default '',
  schtime int(10) unsigned NOT NULL default '0',
  total mediumint(8) unsigned NOT NULL default '0',
  schedid text NOT NULL default '',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_sharelinks;
CREATE TABLE pw_sharelinks (
  sid smallint(6) unsigned NOT NULL auto_increment,
  threadorder tinyint(3) NOT NULL default '0',
  name char(100) NOT NULL default '',
  url char(100) NOT NULL default '',
  descrip char(200) NOT NULL default '0',
  logo char(100) NOT NULL default '',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;

INSERT INTO pw_sharelinks (threadorder ,name ,url ,descrip ,logo ) VALUES ('0', '园园科技论坛', 'http://php.mmcatv.cn', '{#sharelinks}', 'http://php.mmcatv.cn/images/logo.gif');

DROP TABLE IF EXISTS pw_smiles;
CREATE TABLE pw_smiles (
  id smallint(6) unsigned NOT NULL auto_increment,
  image varchar(15) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pw_smiles (image) VALUES ('smile.gif');
INSERT INTO pw_smiles (image) VALUES ('mrgreen.gif');
INSERT INTO pw_smiles (image) VALUES ('question.gif');
INSERT INTO pw_smiles (image) VALUES ('wink.gif');
INSERT INTO pw_smiles (image) VALUES ('redface.gif');
INSERT INTO pw_smiles (image) VALUES ('sad.gif');
INSERT INTO pw_smiles (image) VALUES ('cool.gif');
INSERT INTO pw_smiles (image) VALUES ('crazy.gif');

DROP TABLE IF EXISTS pw_styles;
CREATE TABLE pw_styles (
  sid smallint(6) unsigned NOT NULL auto_increment,
  name char(50) NOT NULL default '',
  stylepath char(50) NOT NULL default '',
  tplpath char(50) NOT NULL default '',
  yeyestyle char(3) NOT NULL default '',
  tablecolor char(7) NOT NULL default '',
  tablewidth char(4) NOT NULL default '',
  mtablewidth char(4) NOT NULL default '',
  forumcolorone char(7) NOT NULL default '',
  forumcolortwo char(7) NOT NULL default '',
  threadcolorone char(7) NOT NULL default '',
  threadcolortwo char(7) NOT NULL default '',
  readcolorone char(7) NOT NULL default '',
  readcolortwo char(7) NOT NULL default '',
  maincolor char(7) NOT NULL default '',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;

INSERT INTO pw_styles VALUES('1','wind','wind','wind','yes','#86B9D6','98%','760','#F5FBFF','#E4EAF2','#FFFFFF','#F7F8F8','#FFFFFF','#FFFFFF','#E5E8EA');

DROP TABLE IF EXISTS pw_threads;
CREATE TABLE pw_threads (
  tid mediumint(8) unsigned NOT NULL auto_increment,
  fid smallint(6) NOT NULL default '0',
  icon tinyint(2) NOT NULL default '0',
  titlefont char(15) NOT NULL default '',
  author char(15) NOT NULL default '',
  authorid mediumint(8) unsigned NOT NULL default '0',
  subject char(200) NOT NULL default '',
  toolinfo char(16) NOT NULL default '',
  toolfield int(10) unsigned NOT NULL default '0',
  ifcheck tinyint(1) NOT NULL default '0',
  type tinyint(2) NOT NULL default '0',
  postdate int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  lastposter char(15) NOT NULL default '',
  hits int(10) unsigned NOT NULL default '0',
  replies int(10)  unsigned NOT NULL default '0',
  topped smallint(6) NOT NULL default '0',
  locked tinyint(1) NOT NULL default '0',
  digest tinyint(1) NOT NULL default '0',
  ifupload tinyint(1) NOT NULL default '0',
  pollid int(10) NOT NULL default '0',
  ifmail tinyint(1) NOT NULL default '0',
  ifmark smallint(6) NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY authorid (authorid),
  KEY digest   (digest),
  KEY topped   (topped),
  KEY ifcheck  (ifcheck),
  KEY lastpost (fid,topped,lastpost)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_tmsgs;
CREATE TABLE pw_tmsgs (
  tid mediumint(8) unsigned NOT NULL default '0',
  aid text NOT NULL default '',
  userip varchar(15) NOT NULL default '',
  ifsign tinyint(1) NOT NULL default '0',
  buy text NOT NULL default '',
  ipfrom varchar(80) NOT NULL default '',
  alterinfo varchar(50) NOT NULL default '',
  ifconvert tinyint(1) NOT NULL default '1',
  content mediumtext NOT NULL default '',
  form varchar(30) NOT NULL default '',
  ifmark varchar(255) NOT NULL default '',
  c_from varchar(30) NOT NULL default '',
  PRIMARY KEY  (tid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS pw_usergroups;
CREATE TABLE pw_usergroups (
  gid smallint(5) unsigned NOT NULL auto_increment,
  gptype enum('default','member','system','special') NOT NULL default 'member',
  grouptitle varchar(60) NOT NULL default '',
  groupimg varchar(15) NOT NULL default '',
  grouppost int(10) NOT NULL default '0',
  maxmsg int(10) NOT NULL default '10',
  allowhide tinyint(1) NOT NULL default '0',
  allowread tinyint(1) NOT NULL default '0',
  allowportait tinyint(1) NOT NULL default '0',
  upload tinyint(1) NOT NULL default '0',
  allowrp tinyint(1) NOT NULL default '0',
  allowhonor tinyint(1) NOT NULL default '0',
  allowdelatc tinyint(1) NOT NULL default '0',
  allowpost tinyint(1) NOT NULL default '0',
  allownewvote tinyint(1) NOT NULL default '0',
  allowvote tinyint(1) NOT NULL default '0',
  htmlcode tinyint(1) NOT NULL default '0',
  wysiwyg tinyint(1) unsigned NOT NULL default '1',
  allowhidden tinyint(1) NOT NULL default '0',
  allowencode tinyint(1) NOT NULL default '0',
  allowsell tinyint(1) NOT NULL default '0',
  allowsearch tinyint(1) NOT NULL default '0',
  allowmember tinyint(1) NOT NULL default '0',
  allowprofile tinyint(1) NOT NULL default '0',
  allowreport tinyint(1) NOT NULL default '0',
  allowmessege tinyint(1) NOT NULL default '0',
  allowsort tinyint(1) NOT NULL default '0',
  alloworder tinyint(1) NOT NULL default '0',
  allowupload tinyint(1) NOT NULL default '0',
  allowdownload tinyint(1) NOT NULL default '0',
  allowloadrvrc tinyint(1) NOT NULL default '0',
  allownum int(10) NOT NULL default '10',
  edittime mediumint(6) NOT NULL default '0',
  postpertime mediumint(6) NOT NULL default '0',
  searchtime mediumint(6) NOT NULL default '0',
  signnum mediumint(6) NOT NULL default '0',
  uploadmoney mediumint(6) NOT NULL default '0',
  mright text NOT NULL,
  ifdefault tinyint(1) unsigned NOT NULL default '1',
  allowadmincp tinyint(1) NOT NULL default '0',
  visithide tinyint(1) NOT NULL default '0',
  delatc tinyint(1) NOT NULL default '0',
  moveatc tinyint(1) NOT NULL default '0',
  copyatc tinyint(1) NOT NULL default '0',
  typeadmin tinyint(1) NOT NULL default '0',
  viewcheck tinyint(1) NOT NULL default '0',
  viewclose tinyint(1) NOT NULL default '0',
  attachper tinyint(1) NOT NULL default '0',
  delattach tinyint(1) NOT NULL default '0',
  viewip tinyint(1) NOT NULL default '0',
  markable tinyint(1) NOT NULL default '0',
  maxcredit smallint(6) NOT NULL default '0',
  credittype varchar(255) NOT NULL default '',
  creditlimit varchar(30) NOT NULL default '',
  banuser tinyint(1) NOT NULL default '0',
  bantype tinyint(1) NOT NULL default '0',
  banmax mediumint(6) NOT NULL default '0',
  viewhide tinyint(1) NOT NULL default '0',
  postpers tinyint(1) NOT NULL default '0',
  atccheck tinyint(1) NOT NULL default '0',
  replylock tinyint(1) NOT NULL default '0',
  modown tinyint(1) NOT NULL default '0',
  modother tinyint(1) NOT NULL default '0',
  deltpcs tinyint(1) NOT NULL default '0',
  sright text NOT NULL,
  PRIMARY KEY  (gid),
  KEY gptype (gptype),
  KEY grouppost (grouppost)
) TYPE=MyISAM;

INSERT INTO pw_usergroups VALUES('1','default','default','8','0','10','0','1','1','0','1','0','1','1','1','1','0','0','0','1','1','1','1','1','1','1','0','1','1','1','0','50','0','0','10','100','0','atclog	0\n1\nshow	1\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	1\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	Array|||','1','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('2','default','游客','8','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','10','10','0','0','show	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nshowsign	\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb				','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('3','system','管理员','3','0','100','1','1','1','1','1','1','1','1','1','1','1','0','1','1','1','2','1','1','1','1','1','1','1','1','0','50','0','0','0','1000','0','atclog	1\n1\nshow	1\n1\nviewipfrom	1\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	1\n1\nmaxfavor	100\n1\nviewvote	1\n1\natccheck	1\n1\nmarkable	1\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	300|-20|20|,rvrc,money,credit,1,','0','1','0','1','1','1','1','1','1','0','1','1','0','0','','','1','1','30','1','1','0','1','0','1','1','topped	3\n1\ntpctype	1\n1\ntpccheck	1');
INSERT INTO pw_usergroups VALUES('4','system','总版主','4','0','30','0','1','1','1','1','1','1','1','1','1','1','0','0','1','1','2','1','1','1','1','1','1','1','1','0','50','0','0','10','1000','0','atclog	0\n1\nshow	1\n1\nviewipfrom	1\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	1\n1\nmaxfavor	100\n1\nviewvote	1\n1\natccheck	1\n1\nmarkable	1\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	100|-10|10|,rvrc,money,','0','1','0','1','1','1','1','1','1','0','1','1','0','0','','','1','1','20','1','1','0','1','0','1','1','topped	3\n1\ntpctype	1\n1\ntpccheck	1');
INSERT INTO pw_usergroups VALUES('5','system','论坛版主','5','0','40','0','1','1','1','1','1','1','1','1','1','0','0','0','1','1','2','1','1','1','1','1','1','1','1','0','50','0','0','10','500','0','atclog	0\n1\nshow	1\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	1\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	50|-5|5|,money,','0','1','0','0','0','0','0','0','0','0','0','2','0','0','','','0','0','10','0','0','0','1','0','0','0','');
INSERT INTO pw_usergroups VALUES('6','system','禁止发言','8','0','10','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','50','0','15','10','100','0','show	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','topped	0\n1\ntpctype	0\n1\ntpccheck	0');
INSERT INTO pw_usergroups VALUES('7','system','未验证会员','8','0','10','0','1','1','0','1','0','1','1','1','1','0','0','1','1','1','1','1','0','0','0','0','1','1','1','0','50','0','15','10','100','0','show	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','topped	0\n1\ntpctype	0\n1\ntpccheck	0');
INSERT INTO pw_usergroups VALUES('8','member','新手上路','8','0','10','0','1','0','0','1','0','1','1','0','1','0','0','0','0','0','1','0','0','1','1','0','1','1','1','0','50','0','0','10','30','0','atclog	0\n1\nshow	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	3\n1\nmsggroup	0\n1\nmaxfavor	50\n1\nviewvote	0\n1\natccheck	1\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('9','member','侠客','9','100','10','0','1','0','0','1','0','1','1','1','1','0','0','0','0','0','1','1','0','1','1','1','0','1','1','0','50','0','10','10','50','0','atclog	0\n1\nshow	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('10','member','骑士','10','300','10','0','1','0','0','1','0','1','1','1','1','0','0','0','0','1','1','1','0','1','1','1','1','1','1','0','50','0','15','10','100','0','atclog	0\n1\nshow	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('11','member','圣骑士','11','600','10','0','1','1','1','1','0','1','1','1','1','0','0','0','0','1','1','1','0','1','1','1','1','1','1','0','50','0','15','10','150','0','atclog	0\n1\nshow	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('12','member','精灵王','12','1000','10','0','1','1','1','1','0','1','1','1','1','0','0','0','1','1','2','1','1','1','1','1','1','1','1','0','50','0','15','10','200','0','atclog	0\n1\nshow	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('13','member','风云使者','13','5000','10','0','1','1','1','1','0','1','1','1','1','0','0','0','1','1','2','1','1','1','1','1','1','1','1','0','50','0','15','10','200','0','atclog	0\n1\nshow	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('14','member','光明使者','14','10000','10','0','1','1','1','1','0','1','1','1','1','0','0','0','1','1','2','1','1','1','1','1','1','1','1','0','50','0','15','10','200','0','atclog	0\n1\nshow	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('15','member','天使','14','50000','10','0','1','1','1','1','0','1','1','1','1','0','0','0','1','1','2','1','1','1','1','1','1','1','1','0','50','0','15','10','200','0','atclog	0\n1\nshow	0\n1\nviewipfrom	0\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	0\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	0\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','');
INSERT INTO pw_usergroups VALUES('16','special','荣誉会员','5','0','20','0','1','1','1','1','1','1','1','1','1','0','0','0','1','1','1','1','1','1','1','1','1','1','1','0','50','0','0','10','200','0','atclog	0\n1\nshow	1\n1\nviewipfrom	1\n1\nimgwidth	\n1\nimgheight	\n1\nfontsize	\n1\nmsggroup	1\n1\nmaxfavor	100\n1\nviewvote	0\n1\natccheck	1\n1\nmarkable	0\n1\npostlimit	\n1\nuploadmaxsize	0\n1\nuploadtype	\n1\nmarkdb	|||','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','0','0','topped	0\n1\ntpctype	0\n1\ntpccheck	0');