install_wind.sql

自己写的一个网络日志(BLOG)系统

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

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

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

DROP TABLE IF EXISTS pw_share;
CREATE TABLE pw_share (
  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 '',
  ifcheck tinyint(1) NOT NULL default '0',
  linkuid mediumint(8) NOT NULL default '0',
  linktime int(10) NOT NULL default '0',
  PRIMARY KEY  (sid),
  KEY ifcheck (ifcheck)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_style;
CREATE TABLE pw_style (
  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 '',
  i_table tinyint(1) unsigned NOT NULL default '0',
  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),
  KEY `name` (`name`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_taginfo;
CREATE TABLE pw_taginfo (
  tagid mediumint(8) unsigned NOT NULL default '0',
  tagname varchar(50) NOT NULL,
  uid mediumint(8) unsigned NOT NULL default '0',
  author varchar(20) NOT NULL,
  itemid int(10) unsigned NOT NULL default '0',
  tagtype varchar(50) NOT NULL,
  `subject` varchar(130) NOT NULL,
  addtime int(10) NOT NULL default '0',
  KEY itemid (itemid),
  KEY tagname (tagname,tagtype)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_tags;
CREATE TABLE pw_tags (
  tagid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL,
  tagname varchar(50) NOT NULL default '',
  blognum int(10) NOT NULL default '0',
  photonum int(10) NOT NULL default '0',
  goodsnum int(10) unsigned NOT NULL,
  bookmarknum int(10) NOT NULL,
  filenum int(10) NOT NULL,
  musicnum int(10) NOT NULL,
  allnum int(10) NOT NULL,
  PRIMARY KEY  (tagid),
  KEY tagname (tagname)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_tblog;
CREATE TABLE pw_tblog (
  itemid int(10) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  teamid smallint(5) unsigned NOT NULL default '0',
  postdate int(10) unsigned NOT NULL default '0',
  `subject` char(130) NOT NULL default '',
  `type` enum('blog','photo','music','bookmark','goods','file') NOT NULL default 'blog',
  KEY teamid (teamid,postdate)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_team;
CREATE TABLE pw_team (
  teamid mediumint(8) unsigned NOT NULL auto_increment,
  cid smallint(5) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  `name` char(30) NOT NULL default '',
  descrip char(255) NOT NULL default '',
  icon varchar(100) NOT NULL,
  notice mediumtext NOT NULL,
  blogtype char(255) NOT NULL default '',
  `level` tinyint(3) unsigned NOT NULL default '0',
  blogs int(10) unsigned NOT NULL default '0',
  bloggers int(10) unsigned NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  lastid mediumint(8) unsigned NOT NULL default '0',
  commend tinyint(1) NOT NULL default '0',
  ifshow tinyint(1) NOT NULL default '0',
  gbooktype tinyint(1) NOT NULL default '0',
  visitdata text NOT NULL,
  PRIMARY KEY  (teamid),
  KEY cid (cid),
  KEY uid (uid),
  KEY ifshow (ifshow,cid,bloggers)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_tgbook;
CREATE TABLE pw_tgbook (
  id int(10) unsigned NOT NULL auto_increment,
  teamid mediumint(8) NOT NULL,
  uid mediumint(8) NOT NULL,
  `name` varchar(100) NOT NULL,
  content text NOT NULL,
  postdate int(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_tuser;
CREATE TABLE pw_tuser (
  admin mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  teamid mediumint(8) unsigned NOT NULL default '0',
  joindate int(10) unsigned NOT NULL default '0',
  blogs int(10) unsigned NOT NULL default '0',
  ifcheck tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid,teamid),
  KEY teamid (teamid),
  KEY uid (uid,teamid,ifcheck,admin)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_upload;
CREATE TABLE pw_upload (
  aid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  cid smallint(6) NOT NULL default '0',
  itemid int(10) unsigned NOT NULL default '0',
  `name` char(80) NOT NULL default '0',
  `type` char(15) NOT NULL,
  size int(10) unsigned NOT NULL default '0',
  hits int(10) NOT NULL,
  attachurl char(80) NOT NULL default '0',
  uploadtime int(10) unsigned NOT NULL default '0',
  descrip char(100) NOT NULL default '',
  atype varchar(10) NOT NULL,
  state tinyint(1) NOT NULL,
  ifthumb tinyint(1) unsigned NOT NULL,
  PRIMARY KEY  (aid),
  KEY itemid (itemid),
  KEY uid (uid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_user;
CREATE TABLE pw_user (
  uid mediumint(8) unsigned NOT NULL auto_increment,
  username varchar(20) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  blogtitle varchar(30) 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',
  icon varchar(100) NOT NULL default '',
  gender tinyint(1) NOT NULL default '0',
  regdate int(10) unsigned NOT NULL default '0',
  qq varchar(12) NOT NULL default '',
  msn varchar(35) NOT NULL default '',
  yahoo varchar(35) NOT NULL default '',
  site varchar(75) NOT NULL default '',
  province varchar(10) NOT NULL default '',
  city varchar(20) NOT NULL default '',
  honor varchar(30) NOT NULL default '',
  blogs int(10) unsigned NOT NULL default '0',
  comments int(11) NOT NULL default '0',