install_wind.sql

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

DROP TABLE IF EXISTS pw_advt;
CREATE TABLE pw_advt (
  id int(8) unsigned NOT NULL auto_increment,
  `subject` varchar(100) NOT NULL,
  hits int(10) NOT NULL,
  width int(4) NOT NULL,
  height int(4) NOT NULL,
  postdate int(10) NOT NULL,
  `type` tinyint(1) NOT NULL,
  advdata text NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_bbsclass;
CREATE TABLE pw_bbsclass (
  fid int(10) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  vieworder tinyint(3) NOT NULL,
  _ifshow tinyint(1) NOT NULL default '0',
  cateshow tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (fid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_blog;
CREATE TABLE pw_blog (
  itemid int(10) unsigned NOT NULL default '0',
  tags mediumtext NOT NULL,
  userip varchar(15) NOT NULL default '',
  ifsign tinyint(1) NOT NULL default '0',
  ipfrom varchar(80) NOT NULL default '',
  pushlog varchar(255) NOT NULL default '',
  ifconvert tinyint(1) NOT NULL default '0',
  content mediumtext NOT NULL,
  PRIMARY KEY  (itemid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_blogfriend;
CREATE TABLE pw_blogfriend (
  id int(10) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL,
  fuid mediumint(8) unsigned NOT NULL,
  fdate int(10) NOT NULL,
  ifcheck tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid,fuid),
  KEY ifcheck (ifcheck)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_bloginfo;
CREATE TABLE pw_bloginfo (
  id smallint(3) unsigned NOT NULL auto_increment,
  newmember varchar(15) NOT NULL default '',
  totalmember mediumint(8) unsigned NOT NULL default '0',
  tdtcontrol int(10) unsigned NOT NULL default '0',
  KEY id (id)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_blogvote;
CREATE TABLE pw_blogvote (
  id mediumint(8) unsigned NOT NULL auto_increment,
  `subject` varchar(255) NOT NULL,
  voteitem mediumtext NOT NULL,
  content mediumtext NOT NULL,
  `type` tinyint(1) unsigned NOT NULL,
  votedate int(10) unsigned NOT NULL,
  _ifshow tinyint(1) unsigned NOT NULL,
  maxnum tinyint(3) NOT NULL,
  _ifview tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY _ifshow (_ifshow)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_bookmark;
CREATE TABLE pw_bookmark (
  itemid int(10) unsigned NOT NULL,
  tags mediumtext NOT NULL,
  userip varchar(15) NOT NULL,
  ifsign tinyint(1) NOT NULL default '0',
  ipfrom varchar(80) NOT NULL,
  pushlog varchar(255) NOT NULL,
  bookmarkurl varchar(255) NOT NULL,
  ifconvert tinyint(1) NOT NULL,
  content mediumtext NOT NULL,
  KEY itemid (itemid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_carticle;
CREATE TABLE pw_carticle (
  id int(10) NOT NULL auto_increment,
  itemid int(10) unsigned NOT NULL,
  uid int(10) NOT NULL,
  touid int(10) NOT NULL,
  cdate int(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_categories;
CREATE TABLE pw_categories (
  cid mediumint(8) unsigned NOT NULL auto_increment,
  cup mediumint(8) unsigned NOT NULL default '0',
  `type` tinyint(3) unsigned NOT NULL default '0',
  `name` varchar(100) NOT NULL,
  descrip varchar(255) NOT NULL,
  cupinfo varchar(255) NOT NULL,
  counts int(10) unsigned NOT NULL,
  vieworder tinyint(3) NOT NULL,
  _ifshow tinyint(1) NOT NULL,
  catetype varchar(50) NOT NULL,
  fid int(8) NOT NULL default '0',
  PRIMARY KEY  (cid),
  KEY catetype (catetype),
  KEY cup (cup,catetype)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_collections;
CREATE TABLE pw_collections (
  id int(10) unsigned NOT NULL auto_increment,
  itemid int(10) unsigned NOT NULL,
  uid int(10) NOT NULL,
  `type` varchar(10) NOT NULL,
  adddate int(10) NOT NULL,
  PRIMARY KEY  (id),
  KEY itemid (itemid),
  KEY uid (uid,`type`,itemid,adddate)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_comment;
CREATE TABLE pw_comment (
  id int(10) unsigned NOT NULL auto_increment,
  cid smallint(6) unsigned NOT NULL default '0',
  itemid int(10) unsigned NOT NULL default '0',
  `type` varchar(10) NOT NULL,
  uid mediumint(8) unsigned NOT NULL default '0',
  author varchar(20) NOT NULL,
  authorid mediumint(8) unsigned NOT NULL default '0',
  postdate int(10) unsigned NOT NULL default '0',
  `subject` varchar(130) NOT NULL default '',
  userip varchar(15) NOT NULL default '',
  ipfrom varchar(30) NOT NULL default '',
  ifcheck tinyint(1) NOT NULL default '0',
  ifwordsfb tinyint(1) NOT NULL default '0',
  ifconvert tinyint(1) NOT NULL default '0',
  content mediumtext NOT NULL,
  PRIMARY KEY  (id),
  KEY itemid (itemid),
  KEY authorid (authorid),
  KEY author (author),
  KEY userip (userip,postdate),
  KEY ifcheck (ifcheck,itemid,uid,postdate)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_file;
CREATE TABLE pw_file (
  itemid int(10) unsigned NOT NULL,
  tags mediumtext NOT NULL,
  userip varchar(15) NOT NULL,
  ifsign tinyint(1) NOT NULL default '0',
  ipfrom varchar(80) NOT NULL,
  pushlog varchar(255) NOT NULL,
  absoluteurl mediumtext NOT NULL,
  size smallint(6) NOT NULL,
  unit varchar(10) NOT NULL,
  version varchar(20) NOT NULL,
  updatetime varchar(20) NOT NULL,
  `language` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  os varchar(50) NOT NULL,
  `level` varchar(10) NOT NULL,
  publish varchar(30) NOT NULL,
  publishlink varchar(50) NOT NULL,
  manner varchar(20) NOT NULL,
  ifconvert tinyint(1) NOT NULL,
  content mediumtext NOT NULL,
  PRIMARY KEY  (itemid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_footprint;
CREATE TABLE pw_footprint (
  id int(10) NOT NULL auto_increment,
  itemid int(10) unsigned NOT NULL,
  uid mediumint(8) NOT NULL,
  fdate int(10) NOT NULL,
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY itemid (itemid,uid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_gbook;
CREATE TABLE pw_gbook (
  id int(11) NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  author varchar(20) NOT NULL default '',
  authorid mediumint(8) NOT NULL default '0',
  authoricon varchar(100) NOT NULL,
  `type` tinyint(1) NOT NULL default '0',
  postdate int(10) NOT NULL default '0',
  userip varchar(15) NOT NULL,
  content mediumtext NOT NULL,
  replydate int(10) NOT NULL default '0',
  reply mediumtext NOT NULL,