install_wind.sql

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

  ifwordsfb tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_goods;
CREATE TABLE pw_goods (
  itemid int(10) unsigned NOT NULL auto_increment,
  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,
  quality varchar(10) NOT NULL,
  price float NOT NULL,
  feemode tinyint(1) NOT NULL,
  maillfee smallint(6) unsigned NOT NULL,
  expressfee smallint(6) unsigned NOT NULL,
  emsfee smallint(6) unsigned NOT NULL,
  province varchar(10) NOT NULL,
  city varchar(10) NOT NULL,
  alipay varchar(50) NOT NULL,
  paypal varchar(50) NOT NULL,
  pay99bill varchar(50) NOT NULL,
  ifconvert tinyint(1) NOT NULL,
  content mediumtext NOT NULL,
  PRIMARY KEY  (itemid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_group;
CREATE TABLE pw_group (
  gid tinyint(3) unsigned NOT NULL auto_increment,
  `type` varchar(10) NOT NULL default 'member',
  title varchar(30) NOT NULL default '',
  img varchar(15) NOT NULL default '',
  creditneed int(10) NOT NULL default '0',
  ifdefault tinyint(1) NOT NULL default '0',
  mright text NOT NULL,
  admincp tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (gid),
  KEY admincp (admincp),
  KEY ifdefault (ifdefault)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_hobby;
CREATE TABLE pw_hobby (
  id mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  vieworder tinyint(3) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_hobbyitem;
CREATE TABLE pw_hobbyitem (
  id mediumint(8) unsigned NOT NULL auto_increment,
  hid mediumint(8) NOT NULL,
  `name` varchar(100) NOT NULL,
  vieworder tinyint(3) NOT NULL,
  ifcheck tinyint(1) NOT NULL,
  PRIMARY KEY  (id),
  KEY hid (hid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_itemnav;
CREATE TABLE pw_itemnav (
  id int(8) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  url varchar(255) NOT NULL,
  vieworder int(4) NOT NULL,
  _ifblank tinyint(1) NOT NULL,
  _ifshow tinyint(1) NOT NULL,
  `type` varchar(20) NOT NULL,
  PRIMARY KEY  (id),
  KEY ifshow (_ifshow)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_items;
CREATE TABLE pw_items (
  itemid int(10) unsigned NOT NULL auto_increment,
  cid smallint(6) unsigned NOT NULL,
  bbsfid mediumint(8) unsigned NOT NULL,
  dirid mediumint(8) unsigned NOT NULL,
  uid mediumint(8) unsigned NOT NULL,
  author varchar(20) NOT NULL,
  `type` varchar(10) NOT NULL,
  icon tinyint(3) NOT NULL,
  `subject` varchar(130) NOT NULL,
  postdate int(10) NOT NULL,
  lastpost int(10) NOT NULL,
  lastreplies int(10) NOT NULL default '0',
  hits int(10) NOT NULL,
  replies int(10) NOT NULL,
  topped tinyint(1) NOT NULL,
  digest tinyint(1) NOT NULL,
  locked tinyint(1) NOT NULL,
  allowreply tinyint(1) NOT NULL,
  folder tinyint(1) NOT NULL,
  ifcheck tinyint(1) NOT NULL default '1',
  ifwordsfb tinyint(1) NOT NULL default '0',
  ifhide tinyint(1) NOT NULL,
  footprints int(10) NOT NULL,
  uploads mediumtext NOT NULL,
  cmttext mediumtext NOT NULL,
  PRIMARY KEY  (itemid),
  KEY cid (cid),
  KEY uid (uid,`type`,ifcheck,dirid,postdate),
  KEY ifcheck (ifcheck,ifhide,`type`,cid,postdate)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_itemtype;
CREATE TABLE pw_itemtype (
  typeid int(10) NOT NULL auto_increment,
  uid mediumint(8) NOT NULL,
  `type` varchar(10) NOT NULL,
  `name` varchar(50) NOT NULL,
  vieworder tinyint(3) NOT NULL,
  PRIMARY KEY  (typeid),
  KEY uid (uid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_lcustom;
CREATE TABLE pw_lcustom (
  id mediumint(8) unsigned NOT NULL auto_increment,
  authorid mediumint(8) NOT NULL,
  sign varchar(30) NOT NULL,
  setdate int(10) unsigned NOT NULL,
  `subject` varchar(130) NOT NULL default '',
  content mediumtext NOT NULL,
  PRIMARY KEY  (id),
  KEY authorid (authorid,sign)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_module;
CREATE TABLE pw_module (
  id mediumint(8) unsigned NOT NULL auto_increment,
  funcname varchar(13) NOT NULL,
  uid mediumint(8) NOT NULL default '0',
  `name` varchar(20) NOT NULL,
  everycache int(10) NOT NULL default '0',
  lastcache int(10) NOT NULL default '0',
  limitnum tinyint(4) NOT NULL default '0',
  shownum varchar(10) NOT NULL,
  ifshow tinyint(1) NOT NULL,
  cachetext tinytext NOT NULL,
  PRIMARY KEY  (id),
  KEY uid (uid,lastcache,everycache,ifshow),
  KEY funcname (funcname)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_music;
CREATE TABLE pw_music (
  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,
  singer varchar(50) NOT NULL,
  musicurl text NOT NULL,
  ifconvert tinyint(1) NOT NULL,
  content mediumtext NOT NULL,
  PRIMARY KEY  (itemid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_notice;
CREATE TABLE pw_notice (
  aid smallint(6) unsigned NOT NULL auto_increment,
  vieworder smallint(6) NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  startdate varchar(15) NOT NULL default '',
  url varchar(80) NOT NULL,
  `subject` varchar(130) NOT NULL default '',
  content mediumtext NOT NULL,
  PRIMARY KEY  (aid),
  KEY vieworder (vieworder,startdate)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_photo;
CREATE TABLE pw_photo (
  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 text NOT NULL,
  ifconvert tinyint(1) NOT NULL,
  content mediumtext NOT NULL,
  PRIMARY KEY  (itemid)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS pw_replace;
CREATE TABLE pw_replace (
  id smallint(6) unsigned NOT NULL auto_increment,
  word varchar(100) NOT NULL default '',
  wordreplace varchar(100) NOT NULL default '',
  `type` enum('replace','forbid') NOT NULL default 'replace',
  PRIMARY KEY  (id),
  KEY `type` (`type`)
) ENGINE=MyISAM;