DROP TABLE IF EXISTS `v4_action`;



CREATE TABLE `v4_action` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `schoolarea` varchar(20) NOT NULL,
  `sendman` varchar(20) NOT NULL DEFAULT '',
  `senddate` date NOT NULL DEFAULT '0000-00-00',
  `content` text NOT NULL,
  `aim` text NOT NULL,
  `company` varchar(50) NOT NULL DEFAULT '',
  `contactman` varchar(20) NOT NULL DEFAULT '',
  `contacttel` varchar(20) NOT NULL DEFAULT '',
  `cost` varchar(20) NOT NULL DEFAULT '',
  `costext` varchar(200) NOT NULL DEFAULT '',
  `startdate` date NOT NULL DEFAULT '0000-00-00',
  `enddate` date NOT NULL DEFAULT '0000-00-00',
  `level` varchar(20) NOT NULL DEFAULT '',
  `state` varchar(20) NOT NULL DEFAULT '',
  `zongjie` text NOT NULL,
  `result` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_action_ext`;



CREATE TABLE `v4_action_ext` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `aid` int(5) NOT NULL DEFAULT '0',
  `msg` varchar(200) NOT NULL DEFAULT '',
  `stuff` varchar(20) NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `contact` varchar(20) NOT NULL,
  `contel` varchar(20) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `state` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_addclass`;



CREATE TABLE `v4_addclass` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `classname` varchar(50) NOT NULL DEFAULT '',
  `extratitle` varchar(30) NOT NULL DEFAULT '',
  `extratitle1` varchar(200) NOT NULL DEFAULT '',
  `extratitle2` varchar(50) NOT NULL DEFAULT '',
  `keshi` varchar(8) NOT NULL DEFAULT '0',
  `testyear` varchar(15) NOT NULL DEFAULT '',
  `typeid` int(5) NOT NULL DEFAULT '0',
  `pid` int(6) NOT NULL DEFAULT '0',
  `code` varchar(20) NOT NULL DEFAULT '',
  `shangke` varchar(50) NOT NULL DEFAULT '',
  `kaike` date NOT NULL DEFAULT '0000-00-00',
  `jiesu` date NOT NULL DEFAULT '0000-00-00',
  `price` varchar(20) NOT NULL DEFAULT '',
  `youhui` varchar(20) NOT NULL DEFAULT '',
  `addr` varchar(200) NOT NULL DEFAULT '',
  `num` tinyint(3) NOT NULL DEFAULT '0',
  `base` tinyint(1) NOT NULL DEFAULT '0',
  `aim` tinyint(1) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `command` tinyint(1) NOT NULL DEFAULT '0',
  `isnew` tinyint(1) NOT NULL DEFAULT '0',
  `color` varchar(10) NOT NULL DEFAULT '',
  `teacher` varchar(10) NOT NULL DEFAULT '',
  `pay` varchar(10) NOT NULL DEFAULT '',
  `calendar` tinytext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_addon17`;



CREATE TABLE `v4_addon17` (
  `aid` int(11) NOT NULL DEFAULT '0',
  `typeid` int(11) NOT NULL DEFAULT '0',
  `redirecturl` varchar(255) NOT NULL DEFAULT '',
  `templet` varchar(30) NOT NULL DEFAULT '',
  `userip` char(15) NOT NULL DEFAULT '',
  `content` mediumtext,
  PRIMARY KEY (`aid`),
  KEY `typeid` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_addonarticle`;



CREATE TABLE `v4_addonarticle` (
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `body` mediumtext,
  `redirecturl` varchar(255) NOT NULL DEFAULT '',
  `templet` varchar(30) NOT NULL DEFAULT '',
  `userip` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`aid`),
  KEY `typeid` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_addonimages`;



CREATE TABLE `v4_addonimages` (
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `pagestyle` smallint(6) NOT NULL DEFAULT '1',
  `maxwidth` smallint(6) NOT NULL DEFAULT '600',
  `imgurls` text,
  `row` smallint(6) NOT NULL DEFAULT '0',
  `col` smallint(6) NOT NULL DEFAULT '0',
  `isrm` smallint(6) NOT NULL DEFAULT '0',
  `ddmaxwidth` smallint(6) NOT NULL DEFAULT '200',
  `pagepicnum` smallint(6) NOT NULL DEFAULT '12',
  `templet` varchar(30) NOT NULL DEFAULT '',
  `userip` varchar(15) NOT NULL DEFAULT '',
  `redirecturl` varchar(255) NOT NULL DEFAULT '',
  `body` mediumtext,
  PRIMARY KEY (`aid`),
  KEY `imagesMain` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_addoninfos`;



CREATE TABLE `v4_addoninfos` (
  `aid` int(11) NOT NULL DEFAULT '0',
  `typeid` int(11) NOT NULL DEFAULT '0',
  `channel` smallint(6) NOT NULL DEFAULT '0',
  `arcrank` smallint(6) NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `click` int(10) unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL DEFAULT '',
  `litpic` varchar(60) NOT NULL DEFAULT '',
  `userip` varchar(15) NOT NULL DEFAULT '',
  `senddate` int(11) NOT NULL DEFAULT '0',
  `flag` set('c','h','p','f','s','j','a','b') DEFAULT NULL,
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `scores` mediumint(8) NOT NULL DEFAULT '0',
  `goodpost` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `badpost` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `nativeplace` smallint(5) unsigned NOT NULL DEFAULT '0',
  `infotype` smallint(5) unsigned NOT NULL DEFAULT '0',
  `body` mediumtext,
  `endtime` int(11) NOT NULL DEFAULT '0',
  `tel` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `address` varchar(100) NOT NULL DEFAULT '',
  `linkman` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`aid`),
  KEY `typeid` (`typeid`,`nativeplace`,`infotype`),
  KEY `channel` (`channel`,`arcrank`,`mid`,`click`,`title`,`litpic`,`senddate`,`flag`,`endtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_addonshop`;



CREATE TABLE `v4_addonshop` (
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `body` mediumtext,
  `templet` varchar(30) NOT NULL DEFAULT '',
  `userip` varchar(15) NOT NULL DEFAULT '',
  `redirecturl` varchar(255) NOT NULL DEFAULT '',
  `groups` varchar(250) NOT NULL DEFAULT '',
  `tese` mediumtext,
  `aim` mediumtext,
  `teacher` mediumtext,
  `book` mediumtext,
  `base` enum('日语','英语','韩语','法语','德语') DEFAULT NULL,
  `aimlevel` enum('初级','中级','考级','N1N2考级','商务日语','职场日语','实用日语','J.test','出国日语','新概念','中学英语','四六级','雅思','托福','职场英语','BEC','出国英语','外教口语') DEFAULT NULL,
  PRIMARY KEY (`aid`),
  KEY `typeid` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_addonsoft`;



CREATE TABLE `v4_addonsoft` (
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `filetype` varchar(10) NOT NULL DEFAULT '',
  `language` varchar(10) NOT NULL DEFAULT '',
  `softtype` varchar(10) NOT NULL DEFAULT '',
  `accredit` varchar(10) NOT NULL DEFAULT '',
  `os` varchar(30) NOT NULL DEFAULT '',
  `softrank` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `officialUrl` varchar(30) NOT NULL DEFAULT '',
  `officialDemo` varchar(50) NOT NULL DEFAULT '',
  `softsize` varchar(10) NOT NULL DEFAULT '',
  `softlinks` text,
  `introduce` text,
  `daccess` smallint(5) NOT NULL DEFAULT '0',
  `needmoney` smallint(5) NOT NULL DEFAULT '0',
  `templet` varchar(30) NOT NULL DEFAULT '',
  `userip` varchar(15) NOT NULL DEFAULT '',
  `redirecturl` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`aid`),
  KEY `softMain` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_addonspec`;



CREATE TABLE `v4_addonspec` (
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `note` text,
  `templet` varchar(30) NOT NULL DEFAULT '',
  `userip` varchar(15) NOT NULL DEFAULT '',
  `redirecturl` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`aid`),
  KEY `typeid` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_admin`;



CREATE TABLE `v4_admin` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `usertype` float unsigned DEFAULT '0',
  `userid` varchar(30) NOT NULL DEFAULT '',
  `pwd` varchar(32) NOT NULL DEFAULT '',
  `uname` varchar(20) NOT NULL DEFAULT '',
  `tname` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(30) NOT NULL DEFAULT '',
  `typeid` text,
  `logintime` int(10) unsigned NOT NULL DEFAULT '0',
  `loginip` varchar(20) NOT NULL DEFAULT '',
  `state` varchar(20) NOT NULL,
  `schoolarea` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_admintype`;



CREATE TABLE `v4_admintype` (
  `rank` float NOT NULL DEFAULT '1',
  `typename` varchar(30) NOT NULL DEFAULT '',
  `system` smallint(6) NOT NULL DEFAULT '0',
  `purviews` text,
  PRIMARY KEY (`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_advancedsearch`;



CREATE TABLE `v4_advancedsearch` (
  `mid` int(11) NOT NULL DEFAULT '0',
  `maintable` varchar(255) NOT NULL DEFAULT '',
  `mainfields` text,
  `addontable` varchar(255) DEFAULT NULL,
  `addonfields` text,
  `forms` text,
  `template` varchar(255) NOT NULL DEFAULT '',
  UNIQUE KEY `mid` (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_arcatt`;



CREATE TABLE `v4_arcatt` (
  `sortid` smallint(6) NOT NULL DEFAULT '0',
  `att` char(10) NOT NULL DEFAULT '',
  `attname` char(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`att`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_arccache`;



CREATE TABLE `v4_arccache` (
  `md5hash` varchar(32) NOT NULL DEFAULT '',
  `uptime` int(11) NOT NULL DEFAULT '0',
  `cachedata` mediumtext,
  PRIMARY KEY (`md5hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_archives`;



CREATE TABLE `v4_archives` (
  `id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `typeid2` varchar(90) NOT NULL DEFAULT '0',
  `sortrank` int(10) unsigned NOT NULL DEFAULT '0',
  `flag` set('c','h','p','f','s','j','a','b') DEFAULT NULL,
  `ismake` smallint(6) NOT NULL DEFAULT '0',
  `channel` smallint(6) NOT NULL DEFAULT '1',
  `arcrank` smallint(6) NOT NULL DEFAULT '0',
  `click` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `money` smallint(6) NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL DEFAULT '',
  `shorttitle` varchar(36) NOT NULL DEFAULT '',
  `color` varchar(7) NOT NULL DEFAULT '',
  `writer` varchar(20) NOT NULL DEFAULT '',
  `source` varchar(30) NOT NULL DEFAULT '',
  `litpic` varchar(100) NOT NULL DEFAULT '',
  `pubdate` int(10) unsigned NOT NULL DEFAULT '0',
  `senddate` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `keywords` varchar(30) NOT NULL DEFAULT '',
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `scores` mediumint(8) NOT NULL DEFAULT '0',
  `goodpost` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `badpost` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `notpost` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `description` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(40) NOT NULL DEFAULT '',
  `dutyadmin` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `tackid` int(10) NOT NULL DEFAULT '0',
  `mtype` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `weight` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sortrank` (`sortrank`),
  KEY `mainindex` (`arcrank`,`typeid`,`channel`,`flag`,`mid`),
  KEY `lastpost` (`lastpost`,`scores`,`goodpost`,`badpost`,`notpost`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_arcmulti`;



CREATE TABLE `v4_arcmulti` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `tagid` varchar(60) NOT NULL DEFAULT '',
  `uptime` int(11) NOT NULL DEFAULT '0',
  `innertext` varchar(255) NOT NULL DEFAULT '',
  `pagesize` int(11) NOT NULL DEFAULT '0',
  `arcids` text NOT NULL,
  `ordersql` varchar(255) DEFAULT '',
  `addfieldsSql` varchar(255) DEFAULT '',
  `addfieldsSqlJoin` varchar(255) DEFAULT '',
  `attstr` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_arcrank`;



CREATE TABLE `v4_arcrank` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `rank` smallint(6) NOT NULL DEFAULT '0',
  `membername` varchar(20) NOT NULL DEFAULT '',
  `adminrank` smallint(6) NOT NULL DEFAULT '0',
  `money` smallint(8) unsigned NOT NULL DEFAULT '500',
  `scores` mediumint(8) NOT NULL DEFAULT '0',
  `purviews` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_arctiny`;



CREATE TABLE `v4_arctiny` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `typeid2` varchar(90) NOT NULL DEFAULT '0',
  `arcrank` smallint(6) NOT NULL DEFAULT '0',
  `channel` smallint(5) NOT NULL DEFAULT '1',
  `senddate` int(10) unsigned NOT NULL DEFAULT '0',
  `sortrank` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sortrank` (`sortrank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_arctype`;



CREATE TABLE `v4_arctype` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `reid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `topid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `sortrank` smallint(5) unsigned NOT NULL DEFAULT '50',
  `typename` varchar(30) NOT NULL DEFAULT '',
  `typedir` varchar(60) NOT NULL DEFAULT '',
  `isdefault` smallint(6) NOT NULL DEFAULT '0',
  `defaultname` varchar(15) NOT NULL DEFAULT 'index.html',
  `issend` smallint(6) NOT NULL DEFAULT '0',
  `channeltype` smallint(6) DEFAULT '1',
  `maxpage` smallint(6) NOT NULL DEFAULT '-1',
  `ispart` smallint(6) NOT NULL DEFAULT '0',
  `corank` smallint(6) NOT NULL DEFAULT '0',
  `tempindex` varchar(50) NOT NULL DEFAULT '',
  `templist` varchar(50) NOT NULL DEFAULT '',
  `temparticle` varchar(50) NOT NULL DEFAULT '',
  `namerule` varchar(50) NOT NULL DEFAULT '',
  `namerule2` varchar(50) NOT NULL DEFAULT '',
  `modname` varchar(20) NOT NULL DEFAULT '',
  `description` varchar(150) NOT NULL DEFAULT '',
  `keywords` varchar(60) NOT NULL DEFAULT '',
  `seotitle` varchar(80) NOT NULL DEFAULT '',
  `moresite` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sitepath` varchar(60) NOT NULL DEFAULT '',
  `siteurl` varchar(50) NOT NULL DEFAULT '',
  `ishidden` smallint(6) NOT NULL DEFAULT '0',
  `cross` tinyint(1) NOT NULL DEFAULT '0',
  `crossid` text,
  `content` text,
  `smalltypes` text,
  PRIMARY KEY (`id`),
  KEY `reid` (`reid`,`isdefault`,`channeltype`,`ispart`,`corank`,`topid`,`ishidden`),
  KEY `sortrank` (`sortrank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_area`;



CREATE TABLE `v4_area` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL DEFAULT '',
  `reid` int(10) unsigned NOT NULL DEFAULT '0',
  `disorder` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_baoming`;



CREATE TABLE `v4_baoming` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userno` varchar(10) NOT NULL DEFAULT '',
  `name` varchar(20) NOT NULL DEFAULT '',
  `mobile` varchar(40) NOT NULL DEFAULT '',
  `addr` varchar(200) NOT NULL DEFAULT '',
  `classname` varchar(50) NOT NULL DEFAULT '',
  `shangke` varchar(30) NOT NULL DEFAULT '',
  `aid` int(9) NOT NULL DEFAULT '0',
  `pid` int(5) NOT NULL DEFAULT '0',
  `email` varchar(200) NOT NULL DEFAULT '',
  `sex` varchar(4) NOT NULL DEFAULT '',
  `im` varchar(60) NOT NULL DEFAULT '',
  `adddate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updatedate` datetime NOT NULL,
  `memo` mediumtext NOT NULL,
  `ip` varchar(15) NOT NULL DEFAULT '',
  `getInfo` varchar(100) NOT NULL DEFAULT '',
  `agent` varchar(10) NOT NULL DEFAULT '',
  `stuff` varchar(10) NOT NULL DEFAULT '',
  `stuffed` varchar(20) NOT NULL DEFAULT '',
  `project` varchar(20) NOT NULL DEFAULT '',
  `aim` varchar(20) NOT NULL DEFAULT '',
  `sendurl` varchar(200) NOT NULL DEFAULT '',
  `schoolarea` varchar(20) NOT NULL,
  `isok` int(11) NOT NULL,
  `base` varchar(200) NOT NULL,
  `getInfomain` varchar(200) NOT NULL,
  `fromtype` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_baoming_ext`;



CREATE TABLE `v4_baoming_ext` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `bid` int(10) NOT NULL DEFAULT '0',
  `stuff` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `msg` tinytext COLLATE utf8_bin NOT NULL,
  `lastday` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `v4_bm`;



CREATE TABLE `v4_bm` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userno` varchar(10) NOT NULL DEFAULT '',
  `name` varchar(20) NOT NULL DEFAULT '',
  `name_x` varchar(10) NOT NULL DEFAULT '',
  `name_m` varchar(20) NOT NULL DEFAULT '',
  `photo` varchar(200) NOT NULL DEFAULT '',
  `pwd` varchar(60) NOT NULL DEFAULT 'jiahe2011',
  `xing` varchar(10) NOT NULL DEFAULT '',
  `ming` varchar(10) NOT NULL DEFAULT '',
  `code` varchar(20) NOT NULL DEFAULT '',
  `mobile` varchar(40) NOT NULL DEFAULT '',
  `addr` varchar(200) NOT NULL DEFAULT '',
  `email` varchar(200) NOT NULL DEFAULT '',
  `sex` varchar(4) NOT NULL DEFAULT '',
  `jlpt` varchar(10) DEFAULT NULL,
  `im` varchar(60) NOT NULL DEFAULT '',
  `adddate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `memo` mediumtext NOT NULL,
  `ip` varchar(15) NOT NULL DEFAULT '',
  `getInfo` varchar(100) NOT NULL DEFAULT '',
  `school` varchar(30) NOT NULL DEFAULT '',
  `idno` varchar(18) NOT NULL DEFAULT '',
  `cardtype` varchar(20) NOT NULL,
  `appdate` date NOT NULL DEFAULT '0000-00-00',
  `idtype` varchar(10) NOT NULL DEFAULT '',
  `idyear` varchar(4) NOT NULL DEFAULT '',
  `idmonth` varchar(6) NOT NULL DEFAULT '',
  `idday` varchar(6) NOT NULL DEFAULT '',
  `agent` varchar(10) NOT NULL DEFAULT '',
  `stuff` varchar(10) NOT NULL DEFAULT '',
  `stuffed` varchar(20) NOT NULL DEFAULT '',
  `schoolarea` varchar(20) NOT NULL DEFAULT '',
  `netname` varchar(40) NOT NULL DEFAULT '',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `credit` double NOT NULL,
  `isliuxue` varchar(20) NOT NULL,
  `qianfei` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idno` (`idno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_car`;



CREATE TABLE `v4_bm_car` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `schoolarea` varchar(10) NOT NULL,
  `name` varchar(50) NOT NULL,
  `price` varchar(10) NOT NULL,
  `stuff` varchar(30) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `driver` varchar(60) NOT NULL,
  `memo` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_card`;



CREATE TABLE `v4_bm_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(15) NOT NULL,
  `cardno` varchar(6) NOT NULL,
  `type` varchar(20) NOT NULL,
  `senddate` date NOT NULL,
  `opendate` date NOT NULL,
  `overdate` date NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `agent` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_coursetype`;



CREATE TABLE `v4_bm_coursetype` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `tid` int(10) NOT NULL,
  `uid` int(10) NOT NULL,
  `dateline` datetime NOT NULL,
  `stuff` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_credit`;



CREATE TABLE `v4_bm_credit` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` varchar(10) NOT NULL,
  `uidno` varchar(20) NOT NULL,
  `num` varchar(5) NOT NULL,
  `dateline` datetime NOT NULL,
  `goods` varchar(100) NOT NULL,
  `code` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_credit_goods`;



CREATE TABLE `v4_bm_credit_goods` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `credit` int(20) NOT NULL,
  `memo` varchar(200) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `users` int(5) NOT NULL,
  `num` int(3) NOT NULL,
  `type` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_credit_goods_code`;



CREATE TABLE `v4_bm_credit_goods_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(5) NOT NULL,
  `code` varchar(20) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `type` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_djlpt_201012`;



CREATE TABLE `v4_bm_djlpt_201012` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `uidno` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `remains` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT '',
  `payed` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksCsrq` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `bkjb` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksXing` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '',
  `bkkd` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksImgSrc` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksLoginFlag` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksMing` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksPXing` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksIdType` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `bkkdmc` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksXb` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksid` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ksPMing` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `errorNum` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '',
  `retVal` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `year` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `level` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '',
  `wishp` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `wishCity1` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `wishCity2` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `wishCity3` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `tiaoji` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '',
  `islogin` tinyint(1) NOT NULL DEFAULT '0',
  `zkz` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  `usercheck` tinyint(1) NOT NULL DEFAULT '0',
  `checktime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `isindm` tinyint(1) NOT NULL DEFAULT '0',
  `changekd` tinyint(1) NOT NULL DEFAULT '0',
  `updates` date NOT NULL DEFAULT '0000-00-00',
  `sort` varchar(20) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uidno` (`uidno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `v4_bm_djlpt_201107`;



CREATE TABLE `v4_bm_djlpt_201107` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `uidno` varchar(20) NOT NULL DEFAULT '',
  `remains` varchar(2) NOT NULL DEFAULT '',
  `payed` varchar(2) NOT NULL DEFAULT '',
  `ksCsrq` varchar(20) NOT NULL DEFAULT '',
  `bkjb` varchar(5) CHARACTER SET ucs2 NOT NULL DEFAULT '',
  `ksXing` varchar(5) NOT NULL DEFAULT '',
  `bkkd` varchar(5) NOT NULL DEFAULT '',
  `ksImgSrc` varchar(200) NOT NULL DEFAULT '',
  `ksLoginFlag` varchar(200) NOT NULL DEFAULT '',
  `ksMing` varchar(20) NOT NULL DEFAULT '',
  `ksPXing` varchar(20) NOT NULL DEFAULT '',
  `ksIdType` varchar(20) NOT NULL DEFAULT '',
  `bkkdmc` varchar(20) NOT NULL DEFAULT '',
  `ksXb` varchar(5) NOT NULL DEFAULT '',
  `ksid` varchar(10) NOT NULL DEFAULT '',
  `ksPMing` varchar(20) NOT NULL DEFAULT '',
  `errorNum` varchar(5) NOT NULL DEFAULT '',
  `retVal` varchar(5) NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `year` varchar(10) NOT NULL DEFAULT '',
  `level` varchar(5) NOT NULL DEFAULT '',
  `wishp` varchar(20) NOT NULL DEFAULT '',
  `wishCity1` varchar(100) NOT NULL DEFAULT '',
  `wishCity2` varchar(100) NOT NULL DEFAULT '',
  `wishCity3` varchar(100) NOT NULL DEFAULT '',
  `tiaoji` varchar(5) NOT NULL DEFAULT '',
  `islogin` tinyint(1) NOT NULL DEFAULT '0',
  `zkz` varchar(200) NOT NULL DEFAULT '',
  `usercheck` tinyint(1) NOT NULL DEFAULT '0',
  `checktime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `isindm` tinyint(1) NOT NULL DEFAULT '0',
  `isdmstate` varchar(5) NOT NULL,
  `bubao` int(1) NOT NULL,
  `changekd` tinyint(1) NOT NULL DEFAULT '0',
  `updates` date NOT NULL DEFAULT '0000-00-00',
  `agent` varchar(20) NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `kd09` varchar(30) NOT NULL,
  `kd10` varchar(20) NOT NULL,
  `pwd` varchar(20) NOT NULL,
  `sn` varchar(50) NOT NULL,
  `name` varchar(30) NOT NULL,
  `word` varchar(20) NOT NULL,
  `listing` varchar(20) NOT NULL,
  `reading` varchar(20) NOT NULL,
  `sort` varchar(20) NOT NULL,
  `s1` varchar(20) NOT NULL,
  `s2` varchar(20) NOT NULL,
  `s3` varchar(20) NOT NULL,
  `s4` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uidno` (`uidno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_djlpt_201112`;



CREATE TABLE `v4_bm_djlpt_201112` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `uidno` varchar(20) NOT NULL DEFAULT '',
  `remains` varchar(2) NOT NULL DEFAULT '',
  `payed` varchar(2) NOT NULL DEFAULT '',
  `ksCsrq` varchar(20) NOT NULL DEFAULT '',
  `bkjb` varchar(5) CHARACTER SET ucs2 NOT NULL DEFAULT '',
  `ksXing` varchar(5) NOT NULL DEFAULT '',
  `bkkd` varchar(5) NOT NULL DEFAULT '',
  `ksImgSrc` varchar(200) NOT NULL DEFAULT '',
  `ksLoginFlag` varchar(200) NOT NULL DEFAULT '',
  `ksMing` varchar(20) NOT NULL DEFAULT '',
  `ksPXing` varchar(20) NOT NULL DEFAULT '',
  `ksIdType` varchar(20) NOT NULL DEFAULT '',
  `bkkdmc` varchar(20) NOT NULL DEFAULT '',
  `ksXb` varchar(5) NOT NULL DEFAULT '',
  `ksid` varchar(10) NOT NULL DEFAULT '',
  `ksPMing` varchar(20) NOT NULL DEFAULT '',
  `errorNum` varchar(5) NOT NULL DEFAULT '',
  `retVal` varchar(5) NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `year` varchar(10) NOT NULL DEFAULT '',
  `level` varchar(5) NOT NULL DEFAULT '',
  `wishp` varchar(20) NOT NULL DEFAULT '',
  `wishCity1` varchar(100) NOT NULL DEFAULT '',
  `wishCity2` varchar(100) NOT NULL DEFAULT '',
  `wishCity3` varchar(100) NOT NULL DEFAULT '',
  `tiaoji` varchar(5) NOT NULL DEFAULT '',
  `islogin` tinyint(1) NOT NULL DEFAULT '0',
  `zkz` varchar(200) NOT NULL DEFAULT '',
  `usercheck` tinyint(1) NOT NULL DEFAULT '0',
  `checktime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `isindm` tinyint(1) NOT NULL DEFAULT '0',
  `isdmstate` varchar(5) NOT NULL,
  `bubao` int(1) NOT NULL,
  `changekd` tinyint(1) NOT NULL DEFAULT '0',
  `updates` date NOT NULL DEFAULT '0000-00-00',
  `agent` varchar(20) NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `kd09` varchar(30) NOT NULL,
  `kd10` varchar(20) NOT NULL,
  `pwd` varchar(20) NOT NULL,
  `sn` varchar(50) NOT NULL,
  `name` varchar(20) NOT NULL,
  `word` varchar(20) NOT NULL,
  `listing` varchar(20) NOT NULL,
  `reading` varchar(20) NOT NULL,
  `sort` varchar(20) NOT NULL,
  `s1` varchar(20) NOT NULL,
  `s2` varchar(20) NOT NULL,
  `s3` varchar(20) NOT NULL,
  `s4` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uidno` (`uidno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_djlpt_201112_0905`;



CREATE TABLE `v4_bm_djlpt_201112_0905` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `uidno` varchar(20) NOT NULL DEFAULT '',
  `remains` varchar(2) NOT NULL DEFAULT '',
  `payed` varchar(2) NOT NULL DEFAULT '',
  `ksCsrq` varchar(20) NOT NULL DEFAULT '',
  `bkjb` varchar(5) CHARACTER SET ucs2 NOT NULL DEFAULT '',
  `ksXing` varchar(5) NOT NULL DEFAULT '',
  `bkkd` varchar(5) NOT NULL DEFAULT '',
  `ksImgSrc` varchar(200) NOT NULL DEFAULT '',
  `ksLoginFlag` varchar(200) NOT NULL DEFAULT '',
  `ksMing` varchar(20) NOT NULL DEFAULT '',
  `ksPXing` varchar(20) NOT NULL DEFAULT '',
  `ksIdType` varchar(20) NOT NULL DEFAULT '',
  `bkkdmc` varchar(20) NOT NULL DEFAULT '',
  `ksXb` varchar(5) NOT NULL DEFAULT '',
  `ksid` varchar(10) NOT NULL DEFAULT '',
  `ksPMing` varchar(20) NOT NULL DEFAULT '',
  `errorNum` varchar(5) NOT NULL DEFAULT '',
  `retVal` varchar(5) NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `year` varchar(10) NOT NULL DEFAULT '',
  `level` varchar(5) NOT NULL DEFAULT '',
  `wishp` varchar(20) NOT NULL DEFAULT '',
  `wishCity1` varchar(100) NOT NULL DEFAULT '',
  `wishCity2` varchar(100) NOT NULL DEFAULT '',
  `wishCity3` varchar(100) NOT NULL DEFAULT '',
  `tiaoji` varchar(5) NOT NULL DEFAULT '',
  `islogin` tinyint(1) NOT NULL DEFAULT '0',
  `zkz` varchar(200) NOT NULL DEFAULT '',
  `usercheck` tinyint(1) NOT NULL DEFAULT '0',
  `checktime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `isindm` tinyint(1) NOT NULL DEFAULT '0',
  `isdmstate` varchar(5) NOT NULL,
  `bubao` int(1) NOT NULL,
  `changekd` tinyint(1) NOT NULL DEFAULT '0',
  `updates` date NOT NULL DEFAULT '0000-00-00',
  `agent` varchar(20) NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `kd09` varchar(30) NOT NULL,
  `kd10` varchar(20) NOT NULL,
  `pwd` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uidno` (`uidno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_djlpt_201207`;



CREATE TABLE `v4_bm_djlpt_201207` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `uidno` varchar(20) NOT NULL DEFAULT '',
  `remains` varchar(2) NOT NULL DEFAULT '',
  `payed` varchar(2) NOT NULL DEFAULT '',
  `ksCsrq` varchar(20) NOT NULL DEFAULT '',
  `bkjb` varchar(5) CHARACTER SET ucs2 NOT NULL DEFAULT '',
  `ksXing` varchar(5) NOT NULL DEFAULT '',
  `bkkd` varchar(5) NOT NULL DEFAULT '',
  `ksImgSrc` varchar(200) NOT NULL DEFAULT '',
  `ksLoginFlag` varchar(200) NOT NULL DEFAULT '',
  `ksMing` varchar(20) NOT NULL DEFAULT '',
  `ksPXing` varchar(20) NOT NULL DEFAULT '',
  `ksIdType` varchar(20) NOT NULL DEFAULT '',
  `bkkdmc` varchar(20) NOT NULL DEFAULT '',
  `ksXb` varchar(5) NOT NULL DEFAULT '',
  `ksid` varchar(10) NOT NULL DEFAULT '',
  `ksPMing` varchar(20) NOT NULL DEFAULT '',
  `errorNum` varchar(5) NOT NULL DEFAULT '',
  `retVal` varchar(5) NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `year` varchar(10) NOT NULL DEFAULT '',
  `level` varchar(5) NOT NULL DEFAULT '',
  `wishp` varchar(20) NOT NULL DEFAULT '',
  `wishCity1` varchar(100) NOT NULL DEFAULT '',
  `wishCity2` varchar(100) NOT NULL DEFAULT '',
  `wishCity3` varchar(100) NOT NULL DEFAULT '',
  `tiaoji` varchar(5) NOT NULL DEFAULT '',
  `islogin` tinyint(1) NOT NULL DEFAULT '0',
  `zkz` varchar(200) NOT NULL DEFAULT '',
  `usercheck` tinyint(1) NOT NULL DEFAULT '0',
  `checktime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `isindm` tinyint(1) NOT NULL DEFAULT '0',
  `isdmstate` varchar(5) NOT NULL,
  `bubao` int(1) NOT NULL,
  `changekd` tinyint(1) NOT NULL DEFAULT '0',
  `updates` date NOT NULL DEFAULT '0000-00-00',
  `agent` varchar(20) NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `kd09` varchar(30) NOT NULL,
  `kd10` varchar(20) NOT NULL,
  `pwd` varchar(20) NOT NULL,
  `sn` varchar(50) NOT NULL,
  `name` varchar(20) NOT NULL,
  `word` varchar(20) NOT NULL,
  `listing` varchar(20) NOT NULL,
  `reading` varchar(20) NOT NULL,
  `sort` varchar(20) NOT NULL,
  `s1` varchar(20) NOT NULL,
  `s2` varchar(20) NOT NULL,
  `s3` varchar(20) NOT NULL,
  `s4` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uidno` (`uidno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_djlpt_201207_sms`;



CREATE TABLE `v4_bm_djlpt_201207_sms` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `idno` varchar(20) NOT NULL,
  `sms` varchar(200) NOT NULL,
  `dateline` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_djlpt_201212`;



CREATE TABLE `v4_bm_djlpt_201212` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `uidno` varchar(20) NOT NULL DEFAULT '',
  `remains` varchar(2) NOT NULL DEFAULT '',
  `payed` varchar(2) NOT NULL DEFAULT '',
  `ksCsrq` varchar(20) NOT NULL DEFAULT '',
  `bkjb` varchar(5) CHARACTER SET ucs2 NOT NULL DEFAULT '',
  `ksXing` varchar(5) NOT NULL DEFAULT '',
  `bkkd` varchar(5) NOT NULL DEFAULT '',
  `ksImgSrc` varchar(200) NOT NULL DEFAULT '',
  `ksLoginFlag` varchar(200) NOT NULL DEFAULT '',
  `ksMing` varchar(20) NOT NULL DEFAULT '',
  `ksPXing` varchar(20) NOT NULL DEFAULT '',
  `ksIdType` varchar(20) NOT NULL DEFAULT '',
  `bkkdmc` varchar(20) NOT NULL DEFAULT '',
  `ksXb` varchar(5) NOT NULL DEFAULT '',
  `ksid` varchar(10) NOT NULL DEFAULT '',
  `ksPMing` varchar(20) NOT NULL DEFAULT '',
  `errorNum` varchar(5) NOT NULL DEFAULT '',
  `retVal` varchar(5) NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `year` varchar(10) NOT NULL DEFAULT '',
  `level` varchar(5) NOT NULL DEFAULT '',
  `wishp` varchar(20) NOT NULL DEFAULT '',
  `wishCity1` varchar(100) NOT NULL DEFAULT '',
  `wishCity2` varchar(100) NOT NULL DEFAULT '',
  `wishCity3` varchar(100) NOT NULL DEFAULT '',
  `tiaoji` varchar(5) NOT NULL DEFAULT '',
  `islogin` tinyint(1) NOT NULL DEFAULT '0',
  `zkz` varchar(200) NOT NULL DEFAULT '',
  `usercheck` tinyint(1) NOT NULL DEFAULT '0',
  `checktime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `isindm` tinyint(1) NOT NULL DEFAULT '0',
  `isdmstate` varchar(5) NOT NULL,
  `bubao` int(1) NOT NULL,
  `changekd` tinyint(1) NOT NULL DEFAULT '0',
  `updates` date NOT NULL DEFAULT '0000-00-00',
  `agent` varchar(20) NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `kd09` varchar(30) NOT NULL,
  `kd10` varchar(20) NOT NULL,
  `pwd` varchar(20) NOT NULL,
  `sn` varchar(50) NOT NULL,
  `name` varchar(20) NOT NULL,
  `word` varchar(20) NOT NULL,
  `listing` varchar(20) NOT NULL,
  `reading` varchar(20) NOT NULL,
  `sort` varchar(20) NOT NULL,
  `s1` varchar(20) NOT NULL,
  `s2` varchar(20) NOT NULL,
  `s3` varchar(20) NOT NULL,
  `s4` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uidno` (`uidno`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_djlpt_201212_sms`;



CREATE TABLE `v4_bm_djlpt_201212_sms` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `idno` varchar(20) NOT NULL,
  `sms` varchar(200) NOT NULL,
  `dateline` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_ext`;



CREATE TABLE `v4_bm_ext` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT '0',
  `stuff` varchar(20) NOT NULL DEFAULT '',
  `dateline` varchar(20) NOT NULL DEFAULT '0',
  `action` varchar(50) NOT NULL DEFAULT '',
  `method` varchar(20) NOT NULL DEFAULT '',
  `msg` tinytext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_login_log`;



CREATE TABLE `v4_bm_login_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `dateline` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `name` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `pwd` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  `idno` varchar(18) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `v4_bm_msg`;



CREATE TABLE `v4_bm_msg` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `uid` varchar(20) NOT NULL,
  `msg` varchar(200) NOT NULL,
  `dateline` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_pay`;



CREATE TABLE `v4_bm_pay` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT '0',
  `agent` varchar(20) NOT NULL DEFAULT '',
  `stuff` varchar(20) NOT NULL DEFAULT '',
  `stuffed` varchar(20) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT '',
  `channel` varchar(20) NOT NULL DEFAULT '',
  `num` decimal(30,0) NOT NULL DEFAULT '0',
  `dateline` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` varchar(20) NOT NULL DEFAULT '',
  `memo` varchar(200) NOT NULL DEFAULT '',
  `code` varchar(30) NOT NULL DEFAULT '',
  `schoolarea` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_pay_2012328`;



CREATE TABLE `v4_bm_pay_2012328` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT '0',
  `agent` varchar(20) NOT NULL DEFAULT '',
  `stuff` varchar(20) NOT NULL DEFAULT '',
  `stuffed` varchar(20) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT '',
  `channel` varchar(20) NOT NULL DEFAULT '',
  `num` varchar(30) NOT NULL DEFAULT '',
  `dateline` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` varchar(20) NOT NULL DEFAULT '',
  `memo` varchar(200) NOT NULL DEFAULT '',
  `code` varchar(30) NOT NULL DEFAULT '',
  `schoolarea` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_pro`;



CREATE TABLE `v4_bm_pro` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` varchar(20) NOT NULL,
  `uidno` varchar(20) NOT NULL,
  `work` varchar(200) NOT NULL,
  `level` int(1) NOT NULL,
  `record` varchar(5) NOT NULL,
  `dateline` date NOT NULL,
  `needs` varchar(200) NOT NULL,
  `memo` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_sorcer`;



CREATE TABLE `v4_bm_sorcer` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `fid` int(10) NOT NULL,
  `uid` int(10) NOT NULL,
  `dateline` datetime NOT NULL,
  `sorcer` int(20) NOT NULL,
  `memo` varchar(200) NOT NULL,
  `stuff` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_sorcer_bk`;



CREATE TABLE `v4_bm_sorcer_bk` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `fid` int(10) NOT NULL,
  `uid` int(10) NOT NULL,
  `item` varchar(20) NOT NULL,
  `dateline` datetime NOT NULL,
  `classid` int(5) NOT NULL,
  `sorcer` int(20) NOT NULL,
  `memo` varchar(200) NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `testdate` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_sorcer_index`;



CREATE TABLE `v4_bm_sorcer_index` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `classid` int(5) NOT NULL,
  `cat` varchar(20) NOT NULL,
  `item` varchar(20) NOT NULL,
  `testdate` date NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `sorcer` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_bm_tips`;



CREATE TABLE `v4_bm_tips` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `tipdate` date NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `dateline` datetime NOT NULL,
  `memo` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_channeltype`;



CREATE TABLE `v4_channeltype` (
  `id` smallint(6) NOT NULL DEFAULT '0',
  `nid` varchar(20) NOT NULL DEFAULT '',
  `typename` varchar(30) NOT NULL DEFAULT '',
  `maintable` varchar(50) NOT NULL DEFAULT 'v4_archives',
  `addtable` varchar(50) NOT NULL DEFAULT '',
  `addcon` varchar(30) NOT NULL DEFAULT '',
  `mancon` varchar(30) NOT NULL DEFAULT '',
  `editcon` varchar(30) NOT NULL DEFAULT '',
  `useraddcon` varchar(30) NOT NULL DEFAULT '',
  `usermancon` varchar(30) NOT NULL DEFAULT '',
  `usereditcon` varchar(30) NOT NULL DEFAULT '',
  `fieldset` text,
  `listfields` text,
  `allfields` text,
  `issystem` smallint(6) NOT NULL DEFAULT '0',
  `isshow` smallint(6) NOT NULL DEFAULT '1',
  `issend` smallint(6) NOT NULL DEFAULT '0',
  `arcsta` smallint(6) NOT NULL DEFAULT '-1',
  `usertype` varchar(10) NOT NULL DEFAULT '',
  `sendrank` smallint(6) NOT NULL DEFAULT '10',
  `isdefault` smallint(6) NOT NULL DEFAULT '0',
  `needdes` tinyint(1) NOT NULL DEFAULT '1',
  `needpic` tinyint(1) NOT NULL DEFAULT '1',
  `titlename` varchar(20) NOT NULL DEFAULT '标题',
  `onlyone` smallint(6) NOT NULL DEFAULT '0',
  `dfcid` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `nid` (`nid`,`isshow`,`arcsta`,`sendrank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_class_feedback`;



CREATE TABLE `v4_class_feedback` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  `arctitle` varchar(60) NOT NULL DEFAULT '',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `ischeck` smallint(6) NOT NULL DEFAULT '0',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `im` varchar(20) DEFAULT NULL,
  `isnotice` tinyint(1) NOT NULL DEFAULT '0',
  `msg` text,
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`,`ischeck`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_co_htmls`;



CREATE TABLE `v4_co_htmls` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `nid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL DEFAULT '',
  `litpic` varchar(100) NOT NULL DEFAULT '',
  `url` varchar(100) NOT NULL DEFAULT '',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `isdown` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `isexport` tinyint(1) NOT NULL DEFAULT '0',
  `result` mediumtext,
  PRIMARY KEY (`aid`),
  KEY `nid` (`nid`),
  KEY `typeid` (`typeid`,`title`,`url`,`dtime`,`isdown`,`isexport`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_co_mediaurls`;



CREATE TABLE `v4_co_mediaurls` (
  `nid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `hash` char(32) NOT NULL DEFAULT '',
  `tofile` char(60) NOT NULL DEFAULT '',
  KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_co_note`;



CREATE TABLE `v4_co_note` (
  `nid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `channelid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `notename` varchar(50) NOT NULL DEFAULT '',
  `sourcelang` varchar(10) NOT NULL DEFAULT 'gb2312',
  `uptime` int(10) unsigned NOT NULL DEFAULT '0',
  `cotime` int(10) unsigned NOT NULL DEFAULT '0',
  `pnum` smallint(5) unsigned NOT NULL DEFAULT '0',
  `isok` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `usemore` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `listconfig` text,
  `itemconfig` text,
  PRIMARY KEY (`nid`),
  KEY `isok` (`isok`,`channelid`,`cotime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_co_onepage`;



CREATE TABLE `v4_co_onepage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(60) NOT NULL DEFAULT '',
  `title` varchar(60) NOT NULL DEFAULT '',
  `issource` smallint(6) NOT NULL DEFAULT '1',
  `lang` varchar(10) NOT NULL DEFAULT 'gb2312',
  `rule` text,
  PRIMARY KEY (`id`),
  KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_co_urls`;



CREATE TABLE `v4_co_urls` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hash` varchar(32) NOT NULL DEFAULT '',
  `nid` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_diyforms`;



CREATE TABLE `v4_diyforms` (
  `diyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `posttemplate` varchar(50) NOT NULL DEFAULT '',
  `viewtemplate` varchar(50) NOT NULL DEFAULT '',
  `listtemplate` varchar(50) NOT NULL DEFAULT '',
  `table` varchar(50) NOT NULL DEFAULT '',
  `info` text,
  `public` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`diyid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_downloads`;



CREATE TABLE `v4_downloads` (
  `hash` char(32) NOT NULL DEFAULT '',
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `downloads` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_erradd`;



CREATE TABLE `v4_erradd` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned DEFAULT NULL,
  `title` varchar(60) NOT NULL DEFAULT '',
  `type` smallint(6) NOT NULL DEFAULT '0',
  `errtxt` mediumtext,
  `oktxt` mediumtext,
  `sendtime` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_feedback`;



CREATE TABLE `v4_feedback` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  `arctitle` varchar(60) NOT NULL DEFAULT '',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `ischeck` smallint(6) NOT NULL DEFAULT '0',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `bad` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `good` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ftype` set('feedback','good','bad') NOT NULL DEFAULT 'feedback',
  `face` smallint(5) unsigned NOT NULL DEFAULT '0',
  `msg` text,
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`,`ischeck`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_flink`;



CREATE TABLE `v4_flink` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `sortrank` smallint(6) NOT NULL DEFAULT '0',
  `url` char(60) NOT NULL DEFAULT '',
  `webname` char(30) NOT NULL DEFAULT '',
  `msg` char(200) NOT NULL DEFAULT '',
  `email` char(50) NOT NULL DEFAULT '',
  `logo` char(60) NOT NULL DEFAULT '',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `ischeck` smallint(6) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_flinktype`;



CREATE TABLE `v4_flinktype` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `typename` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_freelist`;



CREATE TABLE `v4_freelist` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '',
  `namerule` varchar(50) NOT NULL DEFAULT '',
  `listdir` varchar(60) NOT NULL DEFAULT '',
  `defaultpage` varchar(20) NOT NULL DEFAULT '',
  `nodefault` smallint(6) NOT NULL DEFAULT '0',
  `templet` varchar(50) NOT NULL DEFAULT '',
  `edtime` int(11) NOT NULL DEFAULT '0',
  `maxpage` smallint(5) unsigned NOT NULL DEFAULT '100',
  `click` int(11) NOT NULL DEFAULT '1',
  `listtag` mediumtext,
  `keywords` varchar(100) NOT NULL DEFAULT '',
  `description` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_guestbook`;



CREATE TABLE `v4_guestbook` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(60) NOT NULL DEFAULT '',
  `tid` mediumint(8) NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned DEFAULT '0',
  `posttime` int(10) unsigned NOT NULL DEFAULT '0',
  `uname` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `homepage` varchar(50) NOT NULL DEFAULT '',
  `qq` varchar(15) NOT NULL DEFAULT '',
  `face` varchar(10) NOT NULL DEFAULT '',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `ischeck` smallint(6) NOT NULL DEFAULT '1',
  `msg` text,
  PRIMARY KEY (`id`),
  KEY `ischeck` (`ischeck`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_homepageset`;



CREATE TABLE `v4_homepageset` (
  `templet` char(50) NOT NULL DEFAULT '',
  `position` char(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_keywords`;



CREATE TABLE `v4_keywords` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `keyword` char(16) NOT NULL DEFAULT '',
  `rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `sta` smallint(6) NOT NULL DEFAULT '1',
  `rpurl` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`aid`),
  KEY `keyword` (`keyword`,`rank`,`sta`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_log`;



CREATE TABLE `v4_log` (
  `lid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `adminid` smallint(8) unsigned NOT NULL DEFAULT '0',
  `filename` char(60) NOT NULL DEFAULT '',
  `method` char(10) NOT NULL DEFAULT '',
  `query` char(200) NOT NULL DEFAULT '',
  `cip` char(15) NOT NULL DEFAULT '',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member`;



CREATE TABLE `v4_member` (
  `mid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `mtype` varchar(20) NOT NULL DEFAULT '个人',
  `userid` varchar(20) NOT NULL DEFAULT '',
  `pwd` varchar(32) NOT NULL DEFAULT '',
  `uname` varchar(36) NOT NULL DEFAULT '',
  `sex` enum('男','女','保密') NOT NULL DEFAULT '保密',
  `rank` smallint(5) unsigned NOT NULL DEFAULT '0',
  `uptime` int(11) NOT NULL DEFAULT '0',
  `exptime` smallint(6) NOT NULL DEFAULT '0',
  `money` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `email` varchar(50) NOT NULL DEFAULT '',
  `scores` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `matt` smallint(5) unsigned NOT NULL DEFAULT '0',
  `spacesta` smallint(6) NOT NULL DEFAULT '0',
  `face` varchar(50) NOT NULL DEFAULT '',
  `safequestion` smallint(5) unsigned NOT NULL DEFAULT '0',
  `safeanswer` varchar(30) NOT NULL DEFAULT '',
  `jointime` int(10) unsigned NOT NULL DEFAULT '0',
  `joinip` varchar(16) NOT NULL DEFAULT '',
  `logintime` int(10) unsigned NOT NULL DEFAULT '0',
  `loginip` varchar(16) NOT NULL DEFAULT '',
  PRIMARY KEY (`mid`),
  KEY `userid` (`userid`,`sex`),
  KEY `logintime` (`logintime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_company`;



CREATE TABLE `v4_member_company` (
  `mid` mediumint(8) NOT NULL AUTO_INCREMENT,
  `company` varchar(36) NOT NULL DEFAULT '',
  `product` varchar(50) NOT NULL DEFAULT '',
  `place` smallint(5) unsigned NOT NULL DEFAULT '0',
  `vocation` smallint(5) unsigned NOT NULL DEFAULT '0',
  `cosize` smallint(5) unsigned NOT NULL DEFAULT '0',
  `tel` varchar(30) NOT NULL DEFAULT '',
  `fax` varchar(30) NOT NULL DEFAULT '',
  `linkman` varchar(20) NOT NULL DEFAULT '',
  `address` varchar(50) NOT NULL DEFAULT '',
  `mobile` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `url` varchar(50) NOT NULL DEFAULT '',
  `uptime` int(10) unsigned NOT NULL DEFAULT '0',
  `checked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `introduce` text,
  `comface` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_feed`;



CREATE TABLE `v4_member_feed` (
  `fid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `mid` smallint(8) unsigned NOT NULL DEFAULT '0',
  `userid` char(20) NOT NULL DEFAULT '',
  `uname` char(36) NOT NULL DEFAULT '',
  `type` char(20) CHARACTER SET gb2312 NOT NULL DEFAULT '0',
  `aid` mediumint(8) NOT NULL DEFAULT '0',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `title` char(253) NOT NULL DEFAULT '',
  `note` char(200) NOT NULL DEFAULT '',
  `ischeck` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_flink`;



CREATE TABLE `v4_member_flink` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(30) NOT NULL DEFAULT '',
  `url` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_friends`;



CREATE TABLE `v4_member_friends` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `floginid` varchar(20) NOT NULL DEFAULT '',
  `funame` varchar(36) NOT NULL DEFAULT '',
  `mid` mediumint(8) NOT NULL DEFAULT '0',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `ftype` tinyint(4) NOT NULL DEFAULT '0',
  `groupid` int(8) NOT NULL DEFAULT '1',
  `description` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fid` (`fid`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_group`;



CREATE TABLE `v4_member_group` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `groupname` varchar(50) NOT NULL DEFAULT '',
  `mid` int(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_guestbook`;



CREATE TABLE `v4_member_guestbook` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `gid` varchar(20) NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL DEFAULT '',
  `uname` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `qq` varchar(50) NOT NULL DEFAULT '',
  `tel` varchar(50) NOT NULL DEFAULT '',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `msg` text,
  PRIMARY KEY (`aid`),
  KEY `mid` (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_model`;



CREATE TABLE `v4_member_model` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL DEFAULT '',
  `table` varchar(30) NOT NULL DEFAULT '',
  `description` varchar(50) NOT NULL DEFAULT '',
  `state` int(2) NOT NULL DEFAULT '0',
  `issystem` int(2) NOT NULL DEFAULT '0',
  `info` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_msg`;



CREATE TABLE `v4_member_msg` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `userid` varchar(20) NOT NULL DEFAULT '',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `ischeck` smallint(6) NOT NULL DEFAULT '0',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `msg` text,
  PRIMARY KEY (`id`),
  KEY `id` (`ischeck`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_operation`;



CREATE TABLE `v4_member_operation` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `buyid` varchar(80) NOT NULL DEFAULT '',
  `pname` varchar(50) NOT NULL DEFAULT '',
  `product` varchar(10) NOT NULL DEFAULT '',
  `money` int(11) NOT NULL DEFAULT '0',
  `mtime` int(11) NOT NULL DEFAULT '0',
  `pid` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL DEFAULT '0',
  `sta` int(11) NOT NULL DEFAULT '0',
  `oldinfo` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`aid`),
  KEY `buyid` (`buyid`),
  KEY `pid` (`pid`,`mid`,`sta`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_person`;



CREATE TABLE `v4_member_person` (
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `onlynet` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `sex` enum('男','女','保密') NOT NULL DEFAULT '男',
  `uname` varchar(30) NOT NULL DEFAULT '',
  `qq` varchar(12) NOT NULL DEFAULT '',
  `msn` varchar(50) NOT NULL DEFAULT '',
  `tel` varchar(15) NOT NULL DEFAULT '',
  `mobile` varchar(15) NOT NULL DEFAULT '',
  `place` smallint(5) unsigned NOT NULL DEFAULT '0',
  `oldplace` smallint(5) unsigned NOT NULL DEFAULT '0',
  `birthday` date NOT NULL DEFAULT '1980-01-01',
  `star` smallint(6) unsigned NOT NULL DEFAULT '1',
  `income` smallint(6) NOT NULL DEFAULT '0',
  `education` smallint(6) NOT NULL DEFAULT '0',
  `height` smallint(5) unsigned NOT NULL DEFAULT '160',
  `bodytype` smallint(6) NOT NULL DEFAULT '0',
  `blood` smallint(6) NOT NULL DEFAULT '0',
  `vocation` smallint(6) NOT NULL DEFAULT '0',
  `smoke` smallint(6) NOT NULL DEFAULT '0',
  `marital` smallint(6) NOT NULL DEFAULT '0',
  `house` smallint(6) NOT NULL DEFAULT '0',
  `drink` smallint(6) NOT NULL DEFAULT '0',
  `datingtype` smallint(6) NOT NULL DEFAULT '0',
  `language` set('普通话','上海话','广东话','英语','日语','韩语','法语','意大利语','德语','西班牙语','俄语','阿拉伯语') DEFAULT NULL,
  `nature` set('性格外向','性格内向','活泼开朗','豪放不羁','患得患失','冲动','幽默','稳重','轻浮','沉默寡言','多愁善感','时喜时悲','附庸风雅','能说会道','坚强','脆弱','幼稚','成熟','快言快语','损人利己','狡猾善变','交际广泛','优柔寡断','自私','真诚','独立','依赖','难以琢磨','悲观消极','郁郁寡欢','胆小怕事','乐观向上','任性','自负','自卑','拜金','温柔体贴','小心翼翼','暴力倾向','逆来顺受','不拘小节','暴躁','倔强','豪爽','害羞','婆婆妈妈','敢做敢当','助人为乐','耿直','虚伪','孤僻','老实','守旧','敏感','迟钝','婆婆妈妈','武断','果断','刻薄') DEFAULT NULL,
  `lovemsg` varchar(100) NOT NULL DEFAULT '',
  `address` varchar(50) NOT NULL DEFAULT '',
  `uptime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_pms`;



CREATE TABLE `v4_member_pms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `floginid` varchar(20) NOT NULL DEFAULT '',
  `fromid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `toid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `tologinid` varchar(20) NOT NULL DEFAULT '',
  `folder` enum('inbox','outbox') DEFAULT 'inbox',
  `subject` varchar(60) NOT NULL DEFAULT '',
  `sendtime` int(10) unsigned NOT NULL DEFAULT '0',
  `writetime` int(10) unsigned NOT NULL DEFAULT '0',
  `hasview` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `isadmin` tinyint(1) NOT NULL DEFAULT '0',
  `message` text,
  PRIMARY KEY (`id`),
  KEY `sendtime` (`sendtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_snsmsg`;



CREATE TABLE `v4_member_snsmsg` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `userid` varchar(20) NOT NULL DEFAULT '',
  `sendtime` int(10) unsigned NOT NULL DEFAULT '0',
  `msg` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_space`;



CREATE TABLE `v4_member_space` (
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `pagesize` smallint(5) unsigned NOT NULL DEFAULT '10',
  `matt` smallint(6) NOT NULL DEFAULT '0',
  `spacename` varchar(50) NOT NULL DEFAULT '',
  `spacelogo` varchar(50) NOT NULL DEFAULT '',
  `spacestyle` varchar(20) NOT NULL DEFAULT '',
  `sign` varchar(100) NOT NULL DEFAULT '没签名',
  `spacenews` text,
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_stow`;



CREATE TABLE `v4_member_stow` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL DEFAULT '',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `type` varchar(20) NOT NULL DEFAULT 'sys',
  PRIMARY KEY (`id`),
  KEY `uid` (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_stowtype`;



CREATE TABLE `v4_member_stowtype` (
  `stowname` varchar(30) NOT NULL DEFAULT '',
  `indexname` varchar(30) NOT NULL DEFAULT '',
  `indexurl` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`stowname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_tj`;



CREATE TABLE `v4_member_tj` (
  `mid` mediumint(8) NOT NULL AUTO_INCREMENT,
  `article` smallint(5) unsigned NOT NULL DEFAULT '0',
  `album` smallint(5) unsigned NOT NULL DEFAULT '0',
  `archives` smallint(5) unsigned NOT NULL DEFAULT '0',
  `homecount` int(10) unsigned NOT NULL DEFAULT '0',
  `pagecount` int(10) unsigned NOT NULL DEFAULT '0',
  `feedback` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `friend` smallint(5) unsigned NOT NULL DEFAULT '0',
  `stow` smallint(5) unsigned NOT NULL DEFAULT '0',
  `soft` int(10) NOT NULL DEFAULT '0',
  `info` int(10) NOT NULL DEFAULT '0',
  `shop` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_type`;



CREATE TABLE `v4_member_type` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `rank` int(11) NOT NULL DEFAULT '0',
  `pname` varchar(50) NOT NULL DEFAULT '',
  `money` int(11) NOT NULL DEFAULT '0',
  `exptime` int(11) NOT NULL DEFAULT '30',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_member_vhistory`;



CREATE TABLE `v4_member_vhistory` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `loginid` char(20) NOT NULL DEFAULT '',
  `vid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `vloginid` char(20) NOT NULL DEFAULT '',
  `count` smallint(5) unsigned NOT NULL DEFAULT '0',
  `vip` char(15) NOT NULL DEFAULT '',
  `vtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `vtime` (`vtime`),
  KEY `mid` (`mid`,`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_moneycard_record`;



CREATE TABLE `v4_moneycard_record` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `ctid` int(11) NOT NULL DEFAULT '0',
  `cardid` varchar(50) NOT NULL DEFAULT '',
  `uid` int(11) NOT NULL DEFAULT '0',
  `isexp` smallint(6) NOT NULL DEFAULT '0',
  `mtime` int(11) NOT NULL DEFAULT '0',
  `utime` int(11) NOT NULL DEFAULT '0',
  `money` int(11) NOT NULL DEFAULT '0',
  `num` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`),
  KEY `ctid` (`ctid`),
  KEY `cardid` (`cardid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_moneycard_type`;



CREATE TABLE `v4_moneycard_type` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `num` int(11) NOT NULL DEFAULT '500',
  `money` int(11) NOT NULL DEFAULT '50',
  `pname` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_mtypes`;



CREATE TABLE `v4_mtypes` (
  `mtypeid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `mtypename` char(40) NOT NULL DEFAULT '',
  `channelid` smallint(6) NOT NULL DEFAULT '1',
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`mtypeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_multiserv_config`;



CREATE TABLE `v4_multiserv_config` (
  `remoteuploads` smallint(6) NOT NULL DEFAULT '0',
  `remoteupUrl` text NOT NULL,
  `rminfo` text,
  `servinfo` mediumtext,
  PRIMARY KEY (`remoteuploads`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_myad`;



CREATE TABLE `v4_myad` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `tagname` varchar(30) NOT NULL DEFAULT '',
  `adname` varchar(60) NOT NULL DEFAULT '',
  `timeset` smallint(6) NOT NULL DEFAULT '0',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `normbody` text,
  `expbody` text,
  PRIMARY KEY (`aid`),
  KEY `tagname` (`tagname`,`typeid`,`timeset`,`endtime`,`starttime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_mytag`;



CREATE TABLE `v4_mytag` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `tagname` varchar(30) NOT NULL DEFAULT '',
  `timeset` smallint(6) NOT NULL DEFAULT '0',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `normbody` text,
  `expbody` text,
  PRIMARY KEY (`aid`),
  KEY `tagname` (`tagname`,`typeid`,`timeset`,`endtime`,`starttime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_payment`;



CREATE TABLE `v4_payment` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(120) NOT NULL DEFAULT '',
  `fee` varchar(10) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `config` text NOT NULL,
  `enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cod` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `online` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_plus`;



CREATE TABLE `v4_plus` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `plusname` varchar(30) NOT NULL DEFAULT '',
  `menustring` varchar(200) NOT NULL DEFAULT '',
  `mainurl` varchar(50) NOT NULL DEFAULT '',
  `writer` varchar(30) NOT NULL DEFAULT '',
  `isshow` smallint(6) NOT NULL DEFAULT '1',
  `filelist` text,
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_pwd_tmp`;



CREATE TABLE `v4_pwd_tmp` (
  `mid` mediumint(8) NOT NULL DEFAULT '0',
  `membername` char(16) NOT NULL DEFAULT '',
  `pwd` char(32) NOT NULL DEFAULT '',
  `mailtime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_ratings`;



CREATE TABLE `v4_ratings` (
  `id` varchar(11) NOT NULL DEFAULT '',
  `total_votes` int(11) NOT NULL DEFAULT '0',
  `total_value` int(11) NOT NULL DEFAULT '0',
  `used_ips` longtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_scores`;



CREATE TABLE `v4_scores` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `titles` char(15) NOT NULL DEFAULT '',
  `icon` smallint(6) unsigned DEFAULT '0',
  `integral` int(10) NOT NULL DEFAULT '0',
  `isdefault` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `integral` (`integral`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_search_cache`;



CREATE TABLE `v4_search_cache` (
  `hash` varchar(32) NOT NULL DEFAULT '',
  `lasttime` int(10) unsigned NOT NULL DEFAULT '0',
  `rsnum` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ids` mediumtext,
  PRIMARY KEY (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_search_keywords`;



CREATE TABLE `v4_search_keywords` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `keyword` char(30) NOT NULL DEFAULT '',
  `spwords` char(50) NOT NULL DEFAULT '',
  `count` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `result` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `lasttime` int(10) unsigned NOT NULL DEFAULT '0',
  `channelid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_sgpage`;



CREATE TABLE `v4_sgpage` (
  `aid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(60) NOT NULL DEFAULT '',
  `ismake` smallint(6) NOT NULL DEFAULT '1',
  `filename` varchar(60) NOT NULL DEFAULT '',
  `keywords` varchar(30) NOT NULL DEFAULT '',
  `template` varchar(30) NOT NULL DEFAULT '',
  `likeid` varchar(20) NOT NULL DEFAULT '',
  `description` varchar(250) NOT NULL DEFAULT '',
  `uptime` int(10) unsigned NOT NULL DEFAULT '0',
  `body` mediumtext,
  PRIMARY KEY (`aid`),
  KEY `ismake` (`ismake`,`uptime`),
  KEY `likeid` (`likeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_shops_delivery`;



CREATE TABLE `v4_shops_delivery` (
  `pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dname` char(80) NOT NULL DEFAULT '',
  `price` float(13,2) NOT NULL DEFAULT '0.00',
  `des` char(255) DEFAULT NULL,
  `orders` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pid`),
  KEY `orders` (`orders`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_shops_orders`;



CREATE TABLE `v4_shops_orders` (
  `oid` varchar(80) NOT NULL DEFAULT '',
  `userid` int(10) NOT NULL DEFAULT '0',
  `pid` int(10) NOT NULL DEFAULT '0',
  `paytype` tinyint(2) NOT NULL DEFAULT '1',
  `cartcount` int(10) NOT NULL DEFAULT '0',
  `dprice` float(13,2) NOT NULL DEFAULT '0.00',
  `price` float(13,2) NOT NULL DEFAULT '0.00',
  `priceCount` float(13,2) NOT NULL DEFAULT '0.00',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `stime` int(10) NOT NULL DEFAULT '0',
  KEY `stime` (`stime`),
  KEY `userid` (`userid`),
  KEY `oid` (`oid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_shops_products`;



CREATE TABLE `v4_shops_products` (
  `aid` mediumint(8) NOT NULL DEFAULT '0',
  `oid` varchar(80) NOT NULL DEFAULT '',
  `userid` int(10) NOT NULL DEFAULT '0',
  `title` varchar(80) NOT NULL DEFAULT '',
  `price` float(13,2) NOT NULL DEFAULT '0.00',
  `buynum` int(10) NOT NULL DEFAULT '9',
  KEY `oid` (`oid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_shops_userinfo`;



CREATE TABLE `v4_shops_userinfo` (
  `userid` int(10) NOT NULL DEFAULT '0',
  `oid` varchar(80) NOT NULL DEFAULT '',
  `consignee` varchar(15) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `zip` int(10) NOT NULL DEFAULT '0',
  `tel` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `des` varchar(255) NOT NULL DEFAULT '',
  KEY `oid` (`oid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_softconfig`;



CREATE TABLE `v4_softconfig` (
  `downtype` smallint(6) NOT NULL DEFAULT '0',
  `ismoresite` smallint(6) NOT NULL DEFAULT '0',
  `gotojump` smallint(6) NOT NULL DEFAULT '0',
  `islocal` smallint(5) unsigned NOT NULL DEFAULT '1',
  `sites` text,
  `downmsg` text,
  `moresitedo` smallint(5) unsigned NOT NULL DEFAULT '1',
  `dfrank` smallint(5) unsigned NOT NULL DEFAULT '0',
  `dfywboy` smallint(5) unsigned NOT NULL DEFAULT '0',
  `argrange` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`downtype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_stepselect`;



CREATE TABLE `v4_stepselect` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `itemname` char(30) DEFAULT '',
  `egroup` char(20) DEFAULT '',
  `issign` tinyint(1) unsigned DEFAULT '0',
  `issystem` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_sys_enum`;



CREATE TABLE `v4_sys_enum` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `ename` char(30) NOT NULL DEFAULT '',
  `evalue` smallint(6) NOT NULL DEFAULT '0',
  `egroup` char(20) NOT NULL DEFAULT '',
  `disorder` smallint(5) unsigned NOT NULL DEFAULT '0',
  `issign` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_sys_module`;



CREATE TABLE `v4_sys_module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hashcode` varchar(32) NOT NULL DEFAULT '',
  `modname` varchar(30) NOT NULL DEFAULT '',
  `indexname` varchar(20) NOT NULL DEFAULT '',
  `indexurl` varchar(30) NOT NULL DEFAULT '',
  `ismember` tinyint(4) NOT NULL DEFAULT '1',
  `menustring` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_sys_set`;



CREATE TABLE `v4_sys_set` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `sname` varchar(20) NOT NULL DEFAULT '',
  `items` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_sys_task`;



CREATE TABLE `v4_sys_task` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `taskname` varchar(50) NOT NULL DEFAULT '',
  `dourl` varchar(100) NOT NULL DEFAULT '',
  `islock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `runtype` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `runtime` varchar(10) DEFAULT '0000',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `freq` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `lastrun` int(10) unsigned NOT NULL DEFAULT '0',
  `description` varchar(250) NOT NULL DEFAULT '',
  `parameter` text,
  `settime` int(10) unsigned NOT NULL DEFAULT '0',
  `sta` enum('运行','成功','失败') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_sysconfig`;



CREATE TABLE `v4_sysconfig` (
  `aid` smallint(8) unsigned NOT NULL DEFAULT '0',
  `varname` varchar(20) NOT NULL DEFAULT '',
  `info` varchar(100) NOT NULL DEFAULT '',
  `groupid` smallint(6) NOT NULL DEFAULT '1',
  `type` varchar(10) NOT NULL DEFAULT 'string',
  `value` text,
  PRIMARY KEY (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_tagindex`;



CREATE TABLE `v4_tagindex` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tag` char(12) NOT NULL DEFAULT '',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `total` int(10) unsigned NOT NULL DEFAULT '0',
  `weekcc` int(10) unsigned NOT NULL DEFAULT '0',
  `monthcc` int(10) unsigned NOT NULL DEFAULT '0',
  `weekup` int(10) unsigned NOT NULL DEFAULT '0',
  `monthup` int(10) unsigned NOT NULL DEFAULT '0',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_taglist`;



CREATE TABLE `v4_taglist` (
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `aid` int(10) unsigned NOT NULL DEFAULT '0',
  `arcrank` smallint(6) NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `tag` varchar(12) NOT NULL DEFAULT '',
  PRIMARY KEY (`tid`,`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_uploads`;



CREATE TABLE `v4_uploads` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `arcid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` char(60) NOT NULL DEFAULT '',
  `url` char(80) NOT NULL DEFAULT '',
  `mediatype` smallint(6) NOT NULL DEFAULT '1',
  `width` char(10) NOT NULL DEFAULT '',
  `height` char(10) NOT NULL DEFAULT '',
  `playtime` char(10) NOT NULL DEFAULT '',
  `filesize` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `uptime` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`),
  KEY `memberid` (`mid`),
  KEY `arcid` (`arcid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_verifies`;



CREATE TABLE `v4_verifies` (
  `nameid` varchar(32) NOT NULL DEFAULT '',
  `cthash` varchar(32) NOT NULL DEFAULT '',
  `method` enum('local','official') NOT NULL DEFAULT 'official',
  `filename` varchar(254) NOT NULL DEFAULT '',
  PRIMARY KEY (`nameid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `v4_vote`;



CREATE TABLE `v4_vote` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `votename` varchar(50) NOT NULL DEFAULT '',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `totalcount` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ismore` tinyint(6) NOT NULL DEFAULT '0',
  `votenote` text,
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `a_bank`;



CREATE TABLE `a_bank` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `value` varchar(10) NOT NULL,
  `date` date NOT NULL,
  `bank` varchar(20) NOT NULL,
  `mob` varchar(20) NOT NULL,
  `zj` varchar(20) NOT NULL,
  `idno` varchar(20) NOT NULL,
  `memo` text NOT NULL,
  `oid` varchar(30) NOT NULL,
  `agent` varchar(20) NOT NULL,
  `pwd` varchar(20) NOT NULL,
  `state` int(1) NOT NULL,
  `paymemo` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_choujiang`;



CREATE TABLE `jh_choujiang` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT '0',
  `updatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `item` varchar(200) NOT NULL,
  `level` tinyint(1) NOT NULL,
  `username` varchar(30) NOT NULL,
  `mobile` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_choujiang_no2`;



CREATE TABLE `jh_choujiang_no2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT '0',
  `updatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `item` varchar(200) NOT NULL,
  `level` tinyint(1) NOT NULL,
  `username` varchar(30) NOT NULL,
  `mobile` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_choujiang_no2_code`;



CREATE TABLE `jh_choujiang_no2_code` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `uid` int(10) NOT NULL,
  `dateline` datetime NOT NULL,
  `state` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_choujiang_no3`;



CREATE TABLE `jh_choujiang_no3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT '0',
  `updatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `item` varchar(200) NOT NULL,
  `level` tinyint(1) NOT NULL,
  `username` varchar(30) NOT NULL,
  `mobile` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_choujiang_no3_code`;



CREATE TABLE `jh_choujiang_no3_code` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `uid` int(10) NOT NULL,
  `dateline` datetime NOT NULL,
  `state` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_choujiang_no4`;



CREATE TABLE `jh_choujiang_no4` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT '0',
  `updatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `item` varchar(200) NOT NULL,
  `level` tinyint(1) NOT NULL,
  `username` varchar(30) NOT NULL,
  `mobile` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_choujiang_no4_code`;



CREATE TABLE `jh_choujiang_no4_code` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `uid` int(10) NOT NULL,
  `dateline` datetime NOT NULL,
  `state` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_choujing_no2_code_tmp`;



CREATE TABLE `jh_choujing_no2_code_tmp` (
  `bonus_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `bonus_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bonus_sn` bigint(20) unsigned NOT NULL DEFAULT '0',
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `used_time` int(10) unsigned NOT NULL DEFAULT '0',
  `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `emailed` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`bonus_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=FIXED;



DROP TABLE IF EXISTS `jh_erp_post`;



CREATE TABLE `jh_erp_post` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `tid` int(10) NOT NULL,
  `uid` int(5) NOT NULL,
  `messages` varchar(200) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `dateline` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_erp_thread`;



CREATE TABLE `jh_erp_thread` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(5) NOT NULL,
  `company` varchar(30) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `dateline` datetime NOT NULL,
  `keyword` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_erp_user`;



CREATE TABLE `jh_erp_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `password` varchar(64) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `logindate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_jhstuff`;



CREATE TABLE `jh_jhstuff` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL DEFAULT '',
  `mobile` varchar(20) NOT NULL DEFAULT '',
  `mobile2` varchar(20) NOT NULL DEFAULT '',
  `hometel` varchar(20) NOT NULL DEFAULT '',
  `school` varchar(100) NOT NULL DEFAULT '',
  `major` varchar(50) NOT NULL DEFAULT '',
  `biyedate` varchar(10) NOT NULL DEFAULT '',
  `ruzhidate` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `jh_renren_stuff`;



CREATE TABLE `jh_renren_stuff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `mobile` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `qq` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `school` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `dept` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `class` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `grade` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `friendnum` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `uid` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `pwd` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `gw` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `company` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `memo` text CHARACTER SET utf8 NOT NULL,
  `idno` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `bank` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `state` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `bankno` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `addr` varchar(200) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `jh_teacher`;



CREATE TABLE `jh_teacher` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(15) NOT NULL DEFAULT '',
  `sex` varchar(5) NOT NULL DEFAULT '',
  `tel` varchar(10) NOT NULL DEFAULT '',
  `mobile` varchar(15) NOT NULL DEFAULT '',
  `email` varchar(60) NOT NULL DEFAULT '',
  `bank` varchar(15) NOT NULL DEFAULT '',
  `bankno` varchar(50) NOT NULL DEFAULT '',
  `addr` varchar(50) NOT NULL DEFAULT '',
  `edu` varchar(10) NOT NULL DEFAULT '',
  `memo` varchar(200) NOT NULL DEFAULT '',
  `adddate` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_actattachs`;



CREATE TABLE `pw_actattachs` (
  `aid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `actid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(30) NOT NULL DEFAULT '',
  `size` int(10) unsigned NOT NULL DEFAULT '0',
  `attachurl` varchar(255) NOT NULL DEFAULT '',
  `hits` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `uploadtime` int(10) NOT NULL DEFAULT '0',
  `descrip` varchar(100) NOT NULL DEFAULT '',
  `ifthumb` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`),
  KEY `idx_actid` (`actid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_actions`;



CREATE TABLE `pw_actions` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `images` varchar(15) NOT NULL DEFAULT '',
  `name` varchar(15) NOT NULL DEFAULT '',
  `descrip` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_active`;



CREATE TABLE `pw_active` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `title` varchar(120) NOT NULL DEFAULT '',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0',
  `begintime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `deadline` int(10) unsigned NOT NULL DEFAULT '0',
  `address` varchar(255) NOT NULL DEFAULT '',
  `objecter` tinyint(3) NOT NULL DEFAULT '0',
  `limitnum` tinyint(3) NOT NULL DEFAULT '0',
  `price` decimal(8,2) NOT NULL,
  `introduction` varchar(255) NOT NULL DEFAULT '',
  `poster` varchar(60) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `members` int(10) unsigned NOT NULL DEFAULT '0',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_cid` (`cid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activity`;



CREATE TABLE `pw_activity` (
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(100) NOT NULL DEFAULT '',
  `admin` int(10) NOT NULL DEFAULT '0',
  `starttime` int(10) NOT NULL DEFAULT '0',
  `endtime` int(10) NOT NULL DEFAULT '0',
  `location` varchar(20) NOT NULL DEFAULT '',
  `num` smallint(6) NOT NULL DEFAULT '0',
  `sexneed` tinyint(3) NOT NULL DEFAULT '0',
  `costs` int(10) NOT NULL DEFAULT '0',
  `deadline` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`),
  KEY `idx_admin` (`admin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activitycate`;



CREATE TABLE `pw_activitycate` (
  `actid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `ifable` tinyint(3) NOT NULL DEFAULT '1',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `ifdel` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`actid`),
  KEY `idx_vieworder` (`vieworder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activitydefaultvalue`;



CREATE TABLE `pw_activitydefaultvalue` (
  `tid` int(10) unsigned NOT NULL,
  `actmid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  `iscertified` tinyint(3) NOT NULL DEFAULT '1',
  `iscancel` tinyint(3) NOT NULL DEFAULT '0',
  `out_biz_no` varchar(255) DEFAULT '',
  `batch_no` varchar(255) NOT NULL DEFAULT '',
  `user_id` varchar(255) NOT NULL DEFAULT '',
  `recommend` tinyint(1) NOT NULL DEFAULT '0',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `location` varchar(255) NOT NULL DEFAULT '',
  `contact` varchar(255) NOT NULL DEFAULT '',
  `telephone` varchar(255) NOT NULL DEFAULT '',
  `picture1` varchar(255) NOT NULL DEFAULT '',
  `picture2` varchar(255) NOT NULL DEFAULT '',
  `picture3` varchar(255) NOT NULL DEFAULT '',
  `picture4` varchar(255) NOT NULL DEFAULT '',
  `picture5` varchar(255) NOT NULL DEFAULT '',
  `signupstarttime` int(10) unsigned NOT NULL DEFAULT '0',
  `signupendtime` int(10) unsigned NOT NULL DEFAULT '0',
  `minparticipant` int(10) unsigned NOT NULL DEFAULT '0',
  `maxparticipant` int(10) unsigned NOT NULL DEFAULT '0',
  `userlimit` tinyint(3) NOT NULL DEFAULT '0',
  `specificuserlimit` varchar(255) NOT NULL DEFAULT '',
  `genderlimit` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `fees` varchar(255) NOT NULL DEFAULT '',
  `feesdetail` varchar(255) NOT NULL DEFAULT '',
  `paymethod` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `pushtime` int(10) NOT NULL DEFAULT '0',
  `updatetime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`),
  KEY `idx_actmid_fid` (`actmid`,`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityfield`;



CREATE TABLE `pw_activityfield` (
  `fieldid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `fieldname` varchar(30) NOT NULL DEFAULT '',
  `actmid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `type` varchar(20) NOT NULL DEFAULT '',
  `rules` mediumtext NOT NULL,
  `ifable` tinyint(3) NOT NULL DEFAULT '1',
  `ifsearch` tinyint(3) NOT NULL DEFAULT '0',
  `ifasearch` tinyint(3) NOT NULL DEFAULT '0',
  `issearchable` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `threadshow` tinyint(3) NOT NULL DEFAULT '0',
  `allowthreadshow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `ifmust` tinyint(3) NOT NULL DEFAULT '1',
  `ifdel` tinyint(3) NOT NULL DEFAULT '1',
  `mustenable` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `textwidth` tinyint(3) NOT NULL DEFAULT '0',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `sectionname` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`fieldid`),
  KEY `idx_actmid` (`actmid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activitymembers`;



CREATE TABLE `pw_activitymembers` (
  `actuid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fupid` mediumint(8) NOT NULL DEFAULT '0',
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `actmid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `signupdetail` varchar(255) NOT NULL DEFAULT '',
  `signupnum` smallint(6) unsigned NOT NULL DEFAULT '0',
  `nickname` varchar(255) NOT NULL DEFAULT '',
  `totalcash` varchar(255) NOT NULL DEFAULT '',
  `mobile` varchar(15) NOT NULL DEFAULT '',
  `telephone` varchar(15) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `ifanonymous` tinyint(3) NOT NULL DEFAULT '0',
  `ifpay` tinyint(3) NOT NULL DEFAULT '0',
  `signuptime` int(10) unsigned DEFAULT '0',
  `fromuid` int(10) unsigned NOT NULL DEFAULT '0',
  `fromusername` varchar(15) NOT NULL DEFAULT '',
  `issubstitute` tinyint(3) NOT NULL DEFAULT '0',
  `isadditional` tinyint(3) NOT NULL DEFAULT '0',
  `isrefund` tinyint(3) NOT NULL DEFAULT '0',
  `refundcost` varchar(255) NOT NULL DEFAULT '',
  `refundreason` varchar(255) NOT NULL DEFAULT '',
  `additionalreason` varchar(255) NOT NULL DEFAULT '',
  `out_trade_no` varchar(255) NOT NULL DEFAULT '0',
  `batch_detail_no` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`actuid`),
  KEY `idx_tid_uid` (`tid`,`uid`),
  KEY `idx_uid` (`uid`),
  KEY `idx_fupid` (`fupid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activitymodel`;



CREATE TABLE `pw_activitymodel` (
  `actmid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `actid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ifable` tinyint(3) NOT NULL DEFAULT '1',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `ifdel` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`actmid`),
  KEY `idx_actid` (`actid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activitypaylog`;



CREATE TABLE `pw_activitypaylog` (
  `actpid` mediumint(8) NOT NULL AUTO_INCREMENT,
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `actuid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `authorid` int(10) unsigned NOT NULL DEFAULT '0',
  `author` varchar(15) NOT NULL DEFAULT '',
  `fromuid` int(10) unsigned NOT NULL DEFAULT '0',
  `fromusername` varchar(15) NOT NULL DEFAULT '',
  `cost` varchar(255) NOT NULL DEFAULT '',
  `costtype` tinyint(3) NOT NULL DEFAULT '0',
  `status` tinyint(3) NOT NULL DEFAULT '0',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(100) NOT NULL DEFAULT '',
  `wherefrom` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`actpid`),
  KEY `idx_uid` (`uid`),
  KEY `idx_authorid` (`authorid`),
  KEY `idx_tid` (`tid`),
  KEY `idx_actuid_costtype` (`actuid`,`costtype`),
  KEY `idx_fromuid` (`fromuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue1`;



CREATE TABLE `pw_activityvalue1` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue10`;



CREATE TABLE `pw_activityvalue10` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue11`;



CREATE TABLE `pw_activityvalue11` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue12`;



CREATE TABLE `pw_activityvalue12` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue13`;



CREATE TABLE `pw_activityvalue13` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue14`;



CREATE TABLE `pw_activityvalue14` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue15`;



CREATE TABLE `pw_activityvalue15` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue16`;



CREATE TABLE `pw_activityvalue16` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue17`;



CREATE TABLE `pw_activityvalue17` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue2`;



CREATE TABLE `pw_activityvalue2` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue3`;



CREATE TABLE `pw_activityvalue3` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue4`;



CREATE TABLE `pw_activityvalue4` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue5`;



CREATE TABLE `pw_activityvalue5` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue6`;



CREATE TABLE `pw_activityvalue6` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue7`;



CREATE TABLE `pw_activityvalue7` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue8`;



CREATE TABLE `pw_activityvalue8` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_activityvalue9`;



CREATE TABLE `pw_activityvalue9` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_actmember`;



CREATE TABLE `pw_actmember` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `actid` int(10) unsigned NOT NULL DEFAULT '0',
  `winduid` int(10) unsigned NOT NULL DEFAULT '0',
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `applydate` int(10) NOT NULL DEFAULT '0',
  `contact` varchar(20) NOT NULL DEFAULT '',
  `message` varchar(80) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_actid` (`actid`),
  KEY `idx_winduid` (`winduid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_actmembers`;



CREATE TABLE `pw_actmembers` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `actid` int(10) unsigned NOT NULL DEFAULT '0',
  `realname` varchar(30) NOT NULL DEFAULT '',
  `phone` varchar(15) NOT NULL DEFAULT '',
  `mobile` varchar(15) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `anonymous` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_actid` (`actid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_administrators`;



CREATE TABLE `pw_administrators` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `groupid` tinyint(3) NOT NULL DEFAULT '0',
  `groups` varchar(255) NOT NULL DEFAULT '',
  `slog` varchar(255) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_adminlog`;



CREATE TABLE `pw_adminlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL DEFAULT '',
  `username1` varchar(30) NOT NULL DEFAULT '',
  `username2` varchar(30) NOT NULL DEFAULT '',
  `field1` varchar(30) NOT NULL DEFAULT '',
  `field2` varchar(30) NOT NULL DEFAULT '',
  `field3` varchar(255) NOT NULL DEFAULT '',
  `descrip` text NOT NULL,
  `timestamp` int(10) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_type_timestamp` (`type`,`timestamp`),
  KEY `idx_username1` (`username1`),
  KEY `idx_username2` (`username2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_adminset`;



CREATE TABLE `pw_adminset` (
  `gid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `value` text NOT NULL,
  PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_advert`;



CREATE TABLE `pw_advert` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `ckey` varchar(32) NOT NULL DEFAULT '',
  `stime` int(10) unsigned NOT NULL DEFAULT '0',
  `etime` int(10) unsigned NOT NULL DEFAULT '0',
  `ifshow` tinyint(3) NOT NULL DEFAULT '0',
  `orderby` tinyint(3) NOT NULL DEFAULT '0',
  `descrip` varchar(255) NOT NULL,
  `config` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_announce`;



CREATE TABLE `pw_announce` (
  `aid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) NOT NULL DEFAULT '-1',
  `ifopen` tinyint(3) NOT NULL DEFAULT '0',
  `ifconvert` tinyint(3) NOT NULL DEFAULT '0',
  `vieworder` smallint(6) NOT NULL DEFAULT '0',
  `author` varchar(15) NOT NULL DEFAULT '',
  `startdate` varchar(15) NOT NULL DEFAULT '',
  `url` varchar(80) NOT NULL DEFAULT '',
  `enddate` varchar(15) NOT NULL DEFAULT '',
  `subject` varchar(100) NOT NULL DEFAULT '',
  `content` mediumtext NOT NULL,
  PRIMARY KEY (`aid`),
  KEY `idx_vieworder_startdate` (`vieworder`,`startdate`),
  KEY `idx_fid` (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_area_level`;



CREATE TABLE `pw_area_level` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `hasedit` tinyint(3) NOT NULL DEFAULT '0',
  `hasattr` tinyint(3) NOT NULL DEFAULT '0',
  `super` tinyint(3) NOT NULL DEFAULT '0',
  `level` text,
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_areas`;



CREATE TABLE `pw_areas` (
  `areaid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `joinname` varchar(150) NOT NULL DEFAULT '',
  `parentid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `vieworder` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`areaid`),
  KEY `idx_name` (`name`),
  KEY `idx_parentid_vieworder` (`parentid`,`vieworder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_argument`;



CREATE TABLE `pw_argument` (
  `tid` int(10) unsigned NOT NULL,
  `cyid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `topped` tinyint(3) unsigned NOT NULL,
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `digest` tinyint(1) NOT NULL DEFAULT '0',
  `titlefont` varchar(15) NOT NULL DEFAULT '',
  `toolfield` varchar(21) NOT NULL DEFAULT '',
  PRIMARY KEY (`tid`),
  KEY `idx_cyid_topped_lastpost` (`cyid`,`topped`,`lastpost`),
  KEY `idx_lastpost` (`lastpost`),
  KEY `idx_postdate` (`postdate`),
  KEY `idx_digest` (`digest`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_attachbuy`;



CREATE TABLE `pw_attachbuy` (
  `aid` mediumint(8) unsigned NOT NULL,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `ctype` varchar(20) NOT NULL DEFAULT '',
  `cost` smallint(6) unsigned NOT NULL,
  `createdtime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_attachdownload`;



CREATE TABLE `pw_attachdownload` (
  `aid` int(10) unsigned NOT NULL,
  `uid` int(10) unsigned NOT NULL,
  `ctype` varchar(20) NOT NULL DEFAULT '0',
  `cost` smallint(6) unsigned NOT NULL DEFAULT '0',
  `createdtime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_attachs`;



CREATE TABLE `pw_attachs` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `did` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(30) NOT NULL DEFAULT '',
  `size` int(10) unsigned NOT NULL DEFAULT '0',
  `attachurl` varchar(80) NOT NULL DEFAULT '0',
  `hits` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `needrvrc` smallint(6) unsigned NOT NULL DEFAULT '0',
  `special` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ctype` varchar(20) NOT NULL DEFAULT '',
  `uploadtime` int(10) NOT NULL DEFAULT '0',
  `descrip` varchar(100) NOT NULL DEFAULT '',
  `ifthumb` tinyint(3) NOT NULL DEFAULT '0',
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`),
  KEY `idx_fid` (`fid`),
  KEY `idx_uid` (`uid`),
  KEY `idx_did` (`did`),
  KEY `idx_type` (`type`),
  KEY `idx_tid_pid` (`tid`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_attention`;



CREATE TABLE `pw_attention` (
  `uid` int(10) NOT NULL DEFAULT '0',
  `friendid` int(10) NOT NULL DEFAULT '0',
  `joindate` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`friendid`,`uid`),
  KEY `idx_joindate` (`joindate`),
  KEY `idx_uid_joindate` (`uid`,`joindate`),
  KEY `idx_friendid_joindate` (`friendid`,`joindate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_attention_blacklist`;



CREATE TABLE `pw_attention_blacklist` (
  `uid` int(10) unsigned NOT NULL,
  `touid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`uid`,`touid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_auth_certificate`;



CREATE TABLE `pw_auth_certificate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT '0',
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `number` char(32) NOT NULL DEFAULT '',
  `attach1` varchar(80) NOT NULL DEFAULT '',
  `attach2` varchar(80) NOT NULL DEFAULT '',
  `createtime` int(10) NOT NULL DEFAULT '0',
  `admintime` int(10) NOT NULL DEFAULT '0',
  `state` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_uid` (`uid`),
  KEY `idx_state` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ban`;



CREATE TABLE `pw_ban` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `admin` varchar(15) NOT NULL DEFAULT '',
  `reason` varchar(100) NOT NULL DEFAULT '',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_type_uid` (`type`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_banuser`;



CREATE TABLE `pw_banuser` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `startdate` int(10) NOT NULL DEFAULT '0',
  `days` smallint(6) NOT NULL DEFAULT '0',
  `admin` varchar(15) NOT NULL DEFAULT '',
  `reason` varchar(80) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_uid_fid` (`uid`,`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_bbsinfo`;



CREATE TABLE `pw_bbsinfo` (
  `id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
  `newmember` varchar(15) NOT NULL DEFAULT '',
  `totalmember` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `higholnum` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `higholtime` int(10) unsigned NOT NULL DEFAULT '0',
  `tdtcontrol` int(10) unsigned NOT NULL DEFAULT '0',
  `yposts` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `hposts` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `hit_tdtime` int(10) unsigned NOT NULL DEFAULT '0',
  `hit_control` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `plantime` int(10) NOT NULL DEFAULT '0',
  `o_post` int(10) unsigned NOT NULL DEFAULT '0',
  `o_tpost` int(10) unsigned NOT NULL DEFAULT '0',
  `last_statistictime` int(11) NOT NULL DEFAULT '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_buyadvert`;



CREATE TABLE `pw_buyadvert` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `ifcheck` tinyint(3) NOT NULL DEFAULT '0',
  `lasttime` int(10) NOT NULL DEFAULT '0',
  `config` text NOT NULL,
  PRIMARY KEY (`id`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cache`;



CREATE TABLE `pw_cache` (
  `name` varchar(20) NOT NULL DEFAULT '',
  `cache` mediumtext NOT NULL,
  `time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cache_distribute`;



CREATE TABLE `pw_cache_distribute` (
  `ckey` char(32) NOT NULL DEFAULT '',
  `cvalue` text NOT NULL,
  `typeid` tinyint(3) NOT NULL DEFAULT '0',
  `expire` int(10) unsigned NOT NULL DEFAULT '0',
  `extra` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ckey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cache_members`;



CREATE TABLE `pw_cache_members` (
  `ckey` char(32) NOT NULL DEFAULT '',
  `cvalue` text NOT NULL,
  `expire` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ckey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cachedata`;



CREATE TABLE `pw_cachedata` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `invokepieceid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `loopid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `data` text NOT NULL,
  `cachetime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_invokepieceid_fid_loopid` (`invokepieceid`,`fid`,`loopid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_channel`;



CREATE TABLE `pw_channel` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL DEFAULT '',
  `alias` varchar(20) NOT NULL DEFAULT '',
  `queue` smallint(6) NOT NULL DEFAULT '0',
  `relate_theme` varchar(20) NOT NULL DEFAULT 'default',
  `domain_band` varchar(50) NOT NULL DEFAULT '',
  `metatitle` varchar(255) NOT NULL DEFAULT '',
  `metadescrip` varchar(255) NOT NULL DEFAULT '',
  `metakeywords` varchar(255) NOT NULL DEFAULT '',
  `statictime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_alias` (`alias`),
  KEY `idx_relatetheme` (`relate_theme`),
  KEY `idx_queue` (`queue`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_clientorder`;



CREATE TABLE `pw_clientorder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(30) NOT NULL DEFAULT '',
  `type` tinyint(3) unsigned NOT NULL,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `paycredit` varchar(15) NOT NULL DEFAULT '',
  `price` decimal(8,2) NOT NULL DEFAULT '0.00',
  `payemail` varchar(60) NOT NULL DEFAULT '',
  `number` smallint(6) NOT NULL DEFAULT '0',
  `date` int(10) NOT NULL DEFAULT '0',
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `extra_1` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_uid` (`uid`),
  KEY `idx_orderno` (`order_no`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cmembers`;



CREATE TABLE `pw_cmembers` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  `realname` varchar(20) NOT NULL DEFAULT '',
  `ifadmin` tinyint(3) NOT NULL DEFAULT '0',
  `gender` tinyint(3) NOT NULL DEFAULT '0',
  `tel` varchar(15) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `colonyid` smallint(6) NOT NULL DEFAULT '0',
  `address` varchar(255) NOT NULL DEFAULT '',
  `introduce` varchar(255) NOT NULL DEFAULT '',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_colonyid_uid` (`colonyid`,`uid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cms_article`;



CREATE TABLE `pw_cms_article` (
  `article_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `subject` varchar(100) NOT NULL DEFAULT '',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `author` varchar(15) NOT NULL DEFAULT '',
  `username` varchar(15) NOT NULL DEFAULT '',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `jumpurl` varchar(255) NOT NULL DEFAULT '',
  `frominfo` varchar(100) NOT NULL DEFAULT '',
  `fromurl` varchar(255) NOT NULL DEFAULT '',
  `column_id` smallint(6) NOT NULL DEFAULT '0',
  `ifcheck` tinyint(3) NOT NULL DEFAULT '1',
  `postdate` int(10) NOT NULL DEFAULT '0',
  `modifydate` int(10) NOT NULL DEFAULT '0',
  `ifattach` tinyint(3) NOT NULL DEFAULT '0',
  `sourcetype` varchar(30) NOT NULL DEFAULT '',
  `sourceid` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`article_id`),
  KEY `idx_columnid` (`column_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cms_articlecontent`;



CREATE TABLE `pw_cms_articlecontent` (
  `article_id` mediumint(8) NOT NULL,
  `content` text NOT NULL,
  `relatearticle` text NOT NULL,
  PRIMARY KEY (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cms_articleextend`;



CREATE TABLE `pw_cms_articleextend` (
  `article_id` mediumint(8) NOT NULL,
  `hits` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cms_attach`;



CREATE TABLE `pw_cms_attach` (
  `attach_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `article_id` mediumint(8) NOT NULL DEFAULT '0',
  `type` varchar(10) NOT NULL DEFAULT '',
  `size` int(10) NOT NULL DEFAULT '0',
  `uploadtime` int(10) NOT NULL DEFAULT '0',
  `attachurl` varchar(255) NOT NULL DEFAULT '',
  `ifthumb` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`attach_id`),
  KEY `idx_articleid` (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cms_column`;



CREATE TABLE `pw_cms_column` (
  `column_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `parent_id` smallint(6) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `order` smallint(6) NOT NULL DEFAULT '0',
  `allowoffer` tinyint(1) NOT NULL DEFAULT '0',
  `seotitle` varchar(255) NOT NULL DEFAULT '',
  `seodesc` varchar(255) NOT NULL DEFAULT '',
  `seokeywords` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`column_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cms_comment`;



CREATE TABLE `pw_cms_comment` (
  `commentid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `article_id` int(10) unsigned NOT NULL DEFAULT '0',
  `content` varchar(255) NOT NULL DEFAULT '',
  `replynum` smallint(6) unsigned NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`commentid`),
  KEY `idx_articleid_postdate` (`article_id`,`postdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cms_commentreply`;



CREATE TABLE `pw_cms_commentreply` (
  `replyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `commentid` int(10) unsigned NOT NULL DEFAULT '0',
  `content` varchar(255) NOT NULL DEFAULT '',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`replyid`),
  KEY `idx_commentid_postdate` (`commentid`,`postdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cms_purview`;



CREATE TABLE `pw_cms_purview` (
  `purview_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL DEFAULT '',
  `super` tinyint(3) NOT NULL DEFAULT '0',
  `columns` text NOT NULL,
  PRIMARY KEY (`purview_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cnalbum`;



CREATE TABLE `pw_cnalbum` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aname` varchar(50) NOT NULL DEFAULT '',
  `aintro` varchar(200) NOT NULL DEFAULT '',
  `atype` smallint(6) NOT NULL DEFAULT '0',
  `private` tinyint(3) unsigned NOT NULL,
  `albumpwd` varchar(40) NOT NULL DEFAULT '',
  `ownerid` int(10) unsigned NOT NULL DEFAULT '0',
  `owner` varchar(15) NOT NULL DEFAULT '',
  `photonum` smallint(6) NOT NULL DEFAULT '0',
  `lastphoto` varchar(100) NOT NULL DEFAULT '',
  `lasttime` int(10) unsigned NOT NULL DEFAULT '0',
  `lastpid` varchar(100) NOT NULL DEFAULT '',
  `crtime` int(10) NOT NULL DEFAULT '0',
  `memopen` tinyint(3) NOT NULL DEFAULT '1',
  `isdefault` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`),
  KEY `idx_atype_ownerid` (`atype`,`ownerid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cnclass`;



CREATE TABLE `pw_cnclass` (
  `fid` smallint(6) unsigned NOT NULL,
  `cname` varchar(20) NOT NULL DEFAULT '',
  `ifopen` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `cnsum` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cnlevel`;



CREATE TABLE `pw_cnlevel` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `ltype` enum('common','special') NOT NULL DEFAULT 'common',
  `ltitle` varchar(60) NOT NULL DEFAULT '',
  `lpoint` int(10) unsigned NOT NULL DEFAULT '0',
  `albumnum` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `maxphotonum` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `maxmember` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `bbsmode` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `allowmerge` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `allowattorn` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `allowdisband` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `pictopic` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `allowstyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `topicadmin` text NOT NULL,
  `modeset` text NOT NULL,
  `layout` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cnphoto`;



CREATE TABLE `pw_cnphoto` (
  `pid` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0',
  `pintro` varchar(200) NOT NULL DEFAULT '',
  `path` varchar(200) NOT NULL DEFAULT '',
  `uploader` varchar(50) NOT NULL DEFAULT '',
  `uptime` int(10) NOT NULL DEFAULT '0',
  `hits` smallint(6) NOT NULL DEFAULT '0',
  `ifthumb` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `c_num` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`pid`),
  KEY `idx_aid_uptime` (`aid`,`uptime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cnskin`;



CREATE TABLE `pw_cnskin` (
  `dir` varchar(20) NOT NULL,
  `name` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`dir`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cnstyles`;



CREATE TABLE `pw_cnstyles` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `cname` varchar(20) NOT NULL DEFAULT '',
  `ifopen` tinyint(3) NOT NULL DEFAULT '1',
  `csum` int(10) NOT NULL DEFAULT '0',
  `upid` smallint(10) NOT NULL DEFAULT '0',
  `vieworder` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_cname` (`cname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_collection`;



CREATE TABLE `pw_collection` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL DEFAULT '',
  `typeid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `content` text NOT NULL,
  `ifhidden` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `c_num` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ctid` int(10) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`),
  KEY `idx_uid_postdate` (`uid`,`postdate`),
  KEY `idx_ctid` (`ctid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_collectiontype`;



CREATE TABLE `pw_collectiontype` (
  `ctid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ctid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_colonys`;



CREATE TABLE `pw_colonys` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `classid` smallint(6) NOT NULL DEFAULT '0',
  `cname` varchar(20) NOT NULL DEFAULT '',
  `admin` varchar(20) NOT NULL DEFAULT '',
  `members` int(10) NOT NULL DEFAULT '0',
  `ifcheck` tinyint(3) NOT NULL DEFAULT '0',
  `ifopen` tinyint(3) NOT NULL DEFAULT '1',
  `cnimg` varchar(100) NOT NULL DEFAULT '',
  `banner` varchar(100) NOT NULL DEFAULT '',
  `createtime` int(10) NOT NULL DEFAULT '0',
  `annouce` text NOT NULL,
  `albumnum` smallint(6) NOT NULL DEFAULT '0',
  `photonum` int(10) unsigned NOT NULL DEFAULT '0',
  `writenum` int(10) unsigned NOT NULL DEFAULT '0',
  `activitynum` int(10) NOT NULL DEFAULT '0',
  `iftopicshowinforum` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `annoucesee` smallint(6) NOT NULL DEFAULT '0',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `commonlevel` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `speciallevel` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `tnum` int(10) NOT NULL DEFAULT '0',
  `pnum` int(10) unsigned NOT NULL DEFAULT '0',
  `todaypost` int(10) NOT NULL DEFAULT '0',
  `styleid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `visit` int(10) NOT NULL DEFAULT '0',
  `ifshow` tinyint(3) NOT NULL DEFAULT '0',
  `ifshowpic` tinyint(3) NOT NULL DEFAULT '0',
  `colonystyle` varchar(40) NOT NULL DEFAULT '',
  `ifwriteopen` tinyint(3) NOT NULL DEFAULT '1',
  `ifmemberopen` tinyint(3) NOT NULL DEFAULT '1',
  `ifannouceopen` tinyint(3) NOT NULL DEFAULT '1',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `titlefont` varchar(255) NOT NULL DEFAULT '',
  `viewtype` tinyint(3) NOT NULL DEFAULT '0',
  `visitor` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_cname` (`cname`),
  KEY `idx_admin` (`admin`),
  KEY `idx_classid` (`classid`),
  KEY `idx_classid_vieworder` (`classid`,`vieworder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_comment`;



CREATE TABLE `pw_comment` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(10) NOT NULL DEFAULT '',
  `typeid` mediumint(8) NOT NULL DEFAULT '0',
  `upid` mediumint(8) NOT NULL DEFAULT '0',
  `postdate` int(10) NOT NULL DEFAULT '0',
  `ifwordsfb` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_type_typeid` (`type`,`typeid`),
  KEY `idx_upid` (`upid`),
  KEY `idx_postdate` (`postdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_company`;



CREATE TABLE `pw_company` (
  `companyid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `companyname` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`companyid`),
  UNIQUE KEY `idx_companyname` (`companyname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_config`;



CREATE TABLE `pw_config` (
  `db_name` varchar(30) NOT NULL DEFAULT '',
  `vtype` enum('string','array') NOT NULL DEFAULT 'string',
  `db_value` text NOT NULL,
  `decrip` text NOT NULL,
  PRIMARY KEY (`db_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_creditlog`;



CREATE TABLE `pw_creditlog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `ctype` varchar(8) NOT NULL DEFAULT '',
  `affect` int(10) NOT NULL DEFAULT '0',
  `adddate` int(10) NOT NULL DEFAULT '0',
  `logtype` varchar(20) NOT NULL DEFAULT '',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_uid` (`uid`),
  KEY `idx_adddate` (`adddate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_credits`;



CREATE TABLE `pw_credits` (
  `cid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `unit` varchar(30) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `type` enum('main','group') NOT NULL,
  PRIMARY KEY (`cid`),
  KEY `idx_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_customfield`;



CREATE TABLE `pw_customfield` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `category` enum('basic','contact','education','other') NOT NULL DEFAULT 'basic',
  `title` varchar(50) NOT NULL DEFAULT '',
  `maxlen` smallint(6) NOT NULL DEFAULT '0',
  `vieworder` smallint(6) NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `viewinread` tinyint(1) NOT NULL DEFAULT '0',
  `editable` tinyint(1) NOT NULL DEFAULT '0',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `viewright` varchar(255) NOT NULL DEFAULT '',
  `options` text NOT NULL,
  `complement` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ifsys` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `fieldname` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_cwritedata`;



CREATE TABLE `pw_cwritedata` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `touid` int(10) unsigned NOT NULL DEFAULT '0',
  `cyid` int(10) unsigned NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `replay_time` int(10) unsigned NOT NULL DEFAULT '0',
  `isshare` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `c_num` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `moodfirst` tinyint(1) NOT NULL DEFAULT '0',
  `source` varchar(10) NOT NULL DEFAULT '',
  `content` varchar(255) NOT NULL DEFAULT '',
  `mood` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_uid` (`uid`),
  KEY `idx_mood_moodfirst` (`mood`,`moodfirst`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_datanalyse`;



CREATE TABLE `pw_datanalyse` (
  `tag` int(10) NOT NULL,
  `action` varchar(30) NOT NULL,
  `timeunit` int(10) NOT NULL,
  `num` int(10) NOT NULL DEFAULT '0',
  UNIQUE KEY `idx_action_timeunit_tag` (`action`,`tag`,`timeunit`),
  KEY `idx_tag_action` (`tag`,`action`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_datastate`;



CREATE TABLE `pw_datastate` (
  `year` smallint(4) NOT NULL DEFAULT '0',
  `month` tinyint(2) NOT NULL DEFAULT '0',
  `day` tinyint(2) NOT NULL DEFAULT '0',
  `topic` mediumint(8) NOT NULL DEFAULT '0',
  `reply` mediumint(8) NOT NULL DEFAULT '0',
  `regmen` mediumint(8) NOT NULL DEFAULT '0',
  `postmen` mediumint(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`year`,`month`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_datastore`;



CREATE TABLE `pw_datastore` (
  `skey` varchar(32) NOT NULL,
  `expire` int(10) unsigned NOT NULL DEFAULT '0',
  `vhash` char(32) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`skey`),
  KEY `idx_expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_debatedata`;



CREATE TABLE `pw_debatedata` (
  `pid` int(10) unsigned NOT NULL,
  `tid` int(10) unsigned NOT NULL,
  `authorid` int(10) unsigned NOT NULL,
  `standpoint` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `vote` int(10) unsigned NOT NULL DEFAULT '0',
  `voteids` text NOT NULL,
  PRIMARY KEY (`pid`,`tid`,`authorid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_debates`;



CREATE TABLE `pw_debates` (
  `tid` int(10) unsigned NOT NULL,
  `authorid` int(10) unsigned NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `obtitle` varchar(255) NOT NULL DEFAULT '',
  `retitle` varchar(255) NOT NULL DEFAULT '',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `obvote` int(10) unsigned NOT NULL DEFAULT '0',
  `revote` int(10) unsigned NOT NULL DEFAULT '0',
  `obposts` int(10) unsigned NOT NULL DEFAULT '0',
  `reposts` int(10) unsigned NOT NULL DEFAULT '0',
  `umpire` varchar(16) NOT NULL DEFAULT '',
  `umpirepoint` varchar(255) NOT NULL DEFAULT '',
  `debater` varchar(16) NOT NULL DEFAULT '',
  `judge` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_delta_diarys`;



CREATE TABLE `pw_delta_diarys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_delta_members`;



CREATE TABLE `pw_delta_members` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_delta_posts`;



CREATE TABLE `pw_delta_posts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_delta_threads`;



CREATE TABLE `pw_delta_threads` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_diary`;



CREATE TABLE `pw_diary` (
  `did` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `dtid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `aid` text NOT NULL,
  `username` varchar(15) NOT NULL DEFAULT '',
  `privacy` tinyint(1) NOT NULL DEFAULT '0',
  `subject` varchar(150) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `ifcopy` tinyint(1) NOT NULL DEFAULT '0',
  `copyurl` varchar(100) NOT NULL DEFAULT '',
  `ifconvert` tinyint(1) NOT NULL DEFAULT '0',
  `ifwordsfb` tinyint(1) NOT NULL DEFAULT '0',
  `ifupload` tinyint(1) NOT NULL DEFAULT '0',
  `r_num` int(10) NOT NULL DEFAULT '0',
  `c_num` int(10) NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`did`),
  KEY `idx_uid` (`uid`),
  KEY `idx_postdate` (`postdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_diarytype`;



CREATE TABLE `pw_diarytype` (
  `dtid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(20) NOT NULL DEFAULT '',
  `num` mediumint(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`dtid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_draft`;



CREATE TABLE `pw_draft` (
  `did` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `content` text NOT NULL,
  PRIMARY KEY (`did`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_elements`;



CREATE TABLE `pw_elements` (
  `eid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL DEFAULT '',
  `mark` varchar(30) NOT NULL DEFAULT '',
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `value` int(10) NOT NULL DEFAULT '0',
  `addition` varchar(255) NOT NULL DEFAULT '',
  `special` tinyint(1) NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`eid`),
  UNIQUE KEY `idx_type_mark_id` (`type`,`mark`,`id`),
  KEY `idx_type_value` (`type`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_erp_item`;



CREATE TABLE `pw_erp_item` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `cat` varchar(20) NOT NULL,
  `url` varchar(200) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `dateline` datetime NOT NULL,
  `keyword` varchar(200) NOT NULL,
  `type` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_extragroups`;



CREATE TABLE `pw_extragroups` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `gid` smallint(6) NOT NULL DEFAULT '0',
  `togid` smallint(6) NOT NULL DEFAULT '0',
  `startdate` int(10) unsigned NOT NULL DEFAULT '0',
  `days` smallint(6) NOT NULL DEFAULT '0',
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_favors`;



CREATE TABLE `pw_favors` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `tids` text NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_feed`;



CREATE TABLE `pw_feed` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `type` varchar(20) NOT NULL DEFAULT '',
  `descrip` text,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `typeid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_filter`;



CREATE TABLE `pw_filter` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `filter` mediumtext,
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `assessor` varchar(15) NOT NULL DEFAULT '',
  `created_at` int(10) unsigned NOT NULL DEFAULT '0',
  `updated_at` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_filter_class`;



CREATE TABLE `pw_filter_class` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(16) NOT NULL DEFAULT '',
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_filter_dictionary`;



CREATE TABLE `pw_filter_dictionary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `bin` varchar(255) NOT NULL DEFAULT '',
  `source` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_focus`;



CREATE TABLE `pw_focus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pushto` varchar(30) NOT NULL DEFAULT '',
  `pushtime` int(10) NOT NULL DEFAULT '0',
  `fid` smallint(6) NOT NULL DEFAULT '0',
  `tid` int(10) NOT NULL DEFAULT '0',
  `subject` varchar(100) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `postdate` int(10) NOT NULL DEFAULT '0',
  `url` varchar(100) NOT NULL DEFAULT '',
  `imgurl` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_pushto` (`pushto`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_forumdata`;



CREATE TABLE `pw_forumdata` (
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `tpost` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `topic` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `article` int(10) 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',
  `topthreads` text NOT NULL,
  `aid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `aidcache` int(10) unsigned NOT NULL DEFAULT '0',
  `aids` varchar(135) NOT NULL DEFAULT '',
  `lastpost` varchar(135) NOT NULL DEFAULT '',
  PRIMARY KEY (`fid`),
  KEY `idx_aid` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_forumlog`;



CREATE TABLE `pw_forumlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL DEFAULT '',
  `username1` varchar(30) NOT NULL DEFAULT '',
  `username2` varchar(30) NOT NULL DEFAULT '',
  `field1` varchar(30) NOT NULL DEFAULT '',
  `field2` varchar(30) NOT NULL DEFAULT '',
  `field3` varchar(255) NOT NULL DEFAULT '',
  `descrip` text NOT NULL,
  `timestamp` int(10) NOT NULL DEFAULT '0',
  `ip` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_type` (`type`),
  KEY `idx_username1` (`username1`),
  KEY `idx_username2` (`username2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_forummsg`;



CREATE TABLE `pw_forummsg` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `toname` varchar(200) NOT NULL DEFAULT '',
  `msgtype` tinyint(1) NOT NULL DEFAULT '0',
  `posttime` int(10) NOT NULL DEFAULT '0',
  `savetime` int(10) NOT NULL DEFAULT '0',
  `message` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_fid` (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



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','sub2') NOT NULL DEFAULT 'forum',
  `logo` varchar(100) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `descrip` text NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `dirname` varchar(30) NOT NULL DEFAULT '',
  `metadescrip` varchar(255) NOT NULL DEFAULT '',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `vieworder` smallint(6) NOT NULL DEFAULT '0',
  `forumadmin` varchar(255) NOT NULL DEFAULT '',
  `fupadmin` varchar(255) NOT NULL DEFAULT '',
  `style` varchar(12) NOT NULL DEFAULT '',
  `across` tinyint(1) 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',
  `allowtype` tinyint(3) NOT NULL DEFAULT '1',
  `copyctrl` tinyint(1) NOT NULL DEFAULT '0',
  `allowencode` tinyint(1) NOT NULL DEFAULT '1',
  `password` varchar(32) NOT NULL DEFAULT '',
  `viewsub` tinyint(1) NOT NULL DEFAULT '0',
  `allowvisit` varchar(255) NOT NULL DEFAULT '',
  `allowread` varchar(255) NOT NULL DEFAULT '',
  `allowpost` varchar(255) NOT NULL DEFAULT '',
  `allowrp` varchar(255) NOT NULL DEFAULT '',
  `allowdownload` varchar(255) NOT NULL DEFAULT '',
  `allowupload` varchar(255) NOT NULL DEFAULT '',
  `modelid` varchar(255) NOT NULL DEFAULT '',
  `forumsell` varchar(15) NOT NULL DEFAULT '',
  `pcid` varchar(50) NOT NULL DEFAULT '',
  `actmids` varchar(255) 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` tinyint(1) NOT NULL DEFAULT '0',
  `cms` tinyint(1) NOT NULL DEFAULT '0',
  `ifhide` tinyint(1) NOT NULL DEFAULT '1',
  `showsub` tinyint(1) NOT NULL DEFAULT '0',
  `ifcms` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `allowrob` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`fid`),
  KEY `idx_fup` (`fup`),
  KEY `idx_ifsub_vieworder_fup` (`ifsub`,`vieworder`,`fup`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_forumsell`;



CREATE TABLE `pw_forumsell` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '1',
  `buydate` int(10) unsigned NOT NULL DEFAULT '0',
  `overdate` int(10) unsigned NOT NULL DEFAULT '0',
  `credit` varchar(8) NOT NULL DEFAULT '',
  `cost` decimal(8,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_fid` (`fid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_forumsextra`;



CREATE TABLE `pw_forumsextra` (
  `fid` smallint(6) NOT NULL DEFAULT '0',
  `creditset` text NOT NULL,
  `forumset` text NOT NULL,
  `commend` text NOT NULL,
  `appinfo` text NOT NULL,
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_friends`;



CREATE TABLE `pw_friends` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `friendid` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) NOT NULL DEFAULT '0',
  `attention` tinyint(3) NOT NULL DEFAULT '0',
  `joindate` int(10) NOT NULL DEFAULT '0',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `ftid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `iffeed` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`uid`,`friendid`),
  KEY `idx_joindate` (`joindate`),
  KEY `idx_ftid` (`ftid`),
  KEY `idx_uid_joindate` (`uid`,`joindate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_friendtype`;



CREATE TABLE `pw_friendtype` (
  `ftid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`ftid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_group_replay`;



CREATE TABLE `pw_group_replay` (
  `uid` int(10) NOT NULL DEFAULT '0',
  `tid` int(10) NOT NULL DEFAULT '0',
  `cyid` int(10) NOT NULL DEFAULT '0',
  `is_read` smallint(2) NOT NULL DEFAULT '0',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `num` int(10) NOT NULL,
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_hack`;



CREATE TABLE `pw_hack` (
  `hk_name` varchar(30) NOT NULL DEFAULT '',
  `vtype` enum('string','array') NOT NULL,
  `hk_value` text NOT NULL,
  `decrip` text NOT NULL,
  PRIMARY KEY (`hk_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_help`;



CREATE TABLE `pw_help` (
  `hid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `hup` smallint(6) unsigned NOT NULL DEFAULT '0',
  `lv` tinyint(3) NOT NULL DEFAULT '0',
  `fathers` varchar(100) NOT NULL DEFAULT '',
  `ifchild` tinyint(3) NOT NULL DEFAULT '0',
  `title` varchar(80) NOT NULL DEFAULT '',
  `url` varchar(80) NOT NULL DEFAULT '',
  `content` mediumtext NOT NULL,
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `ispw` tinyint(3) DEFAULT '0',
  PRIMARY KEY (`hid`),
  KEY `idx_hup` (`hup`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_hits_threads`;



CREATE TABLE `pw_hits_threads` (
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_invitecode`;



CREATE TABLE `pw_invitecode` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `invcode` varchar(40) NOT NULL DEFAULT '',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `receiver` varchar(20) NOT NULL DEFAULT '',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0',
  `usetime` int(10) unsigned NOT NULL DEFAULT '0',
  `ifused` tinyint(3) NOT NULL DEFAULT '0',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_uid` (`uid`),
  KEY `idx_invcode` (`invcode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_inviterecord`;



CREATE TABLE `pw_inviterecord` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `unit` varchar(15) NOT NULL DEFAULT '',
  `reward` int(10) NOT NULL DEFAULT '0',
  `ip` varchar(16) NOT NULL DEFAULT '',
  `typeid` tinyint(3) NOT NULL DEFAULT '0',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_uid_ip` (`uid`,`ip`),
  KEY `idx_typeid` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_invoke`;



CREATE TABLE `pw_invoke` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `tplid` smallint(6) NOT NULL DEFAULT '0',
  `tagcode` text NOT NULL,
  `parsecode` text NOT NULL,
  `title` varchar(80) NOT NULL DEFAULT '',
  `ifapi` tinyint(1) NOT NULL DEFAULT '0',
  `scr` varchar(25) NOT NULL DEFAULT '',
  `sign` varchar(25) NOT NULL DEFAULT '',
  `pieces` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `ifverify` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`),
  KEY `idx_title` (`title`),
  KEY `idx_scr_sign` (`scr`,`sign`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_invokepiece`;



CREATE TABLE `pw_invokepiece` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `invokename` varchar(50) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL DEFAULT '',
  `action` varchar(30) NOT NULL DEFAULT '',
  `config` text NOT NULL,
  `num` smallint(6) NOT NULL DEFAULT '0',
  `param` text NOT NULL,
  `cachetime` int(10) unsigned NOT NULL DEFAULT '0',
  `ifpushonly` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_invokename` (`invokename`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ipstates`;



CREATE TABLE `pw_ipstates` (
  `day` varchar(10) NOT NULL DEFAULT '',
  `month` varchar(7) NOT NULL DEFAULT '',
  `nums` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_job`;



CREATE TABLE `pw_job` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT '',
  `description` text,
  `icon` varchar(255) DEFAULT '',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `period` smallint(6) unsigned NOT NULL DEFAULT '0',
  `reward` text,
  `sequence` smallint(3) NOT NULL DEFAULT '0',
  `usergroup` varchar(255) NOT NULL DEFAULT '',
  `prepose` int(10) unsigned NOT NULL DEFAULT '0',
  `number` int(10) NOT NULL DEFAULT '0',
  `member` tinyint(3) NOT NULL DEFAULT '0',
  `auto` tinyint(3) NOT NULL DEFAULT '0',
  `finish` tinyint(3) NOT NULL DEFAULT '0',
  `display` tinyint(3) NOT NULL DEFAULT '0',
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `job` varchar(255) NOT NULL DEFAULT '',
  `factor` text,
  `isopen` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `isuserguide` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_jober`;



CREATE TABLE `pw_jober` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jobid` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `current` tinyint(1) NOT NULL DEFAULT '0',
  `step` smallint(6) NOT NULL DEFAULT '0',
  `last` int(10) unsigned NOT NULL DEFAULT '0',
  `next` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `creattime` int(10) unsigned NOT NULL DEFAULT '0',
  `total` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_jobid_userid` (`jobid`,`userid`),
  KEY `idx_userid_status` (`userid`,`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_kmd_info`;



CREATE TABLE `pw_kmd_info` (
  `kid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`kid`),
  KEY `idx_tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_kmd_paylog`;



CREATE TABLE `pw_kmd_paylog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kid` int(10) unsigned NOT NULL DEFAULT '0',
  `fid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `money` decimal(14,2) unsigned NOT NULL DEFAULT '0.00',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_fid` (`fid`),
  KEY `idx_uid` (`uid`),
  KEY `idx_createtime` (`createtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_kmd_spread`;



CREATE TABLE `pw_kmd_spread` (
  `sid` int(10) NOT NULL AUTO_INCREMENT,
  `displayorder` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `day` smallint(3) unsigned NOT NULL DEFAULT '0',
  `price` decimal(14,2) unsigned NOT NULL DEFAULT '0.00',
  `discount` decimal(2,1) unsigned NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_kmd_user`;



CREATE TABLE `pw_kmd_user` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `phone` varchar(15) DEFAULT NULL,
  `realname` varchar(15) NOT NULL DEFAULT '',
  `invoice` varchar(100) NOT NULL DEFAULT '',
  `address` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_aggregate`;



CREATE TABLE `pw_log_aggregate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `operate` tinyint(3) NOT NULL DEFAULT '1',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sid_type_operate` (`sid`,`type`,`operate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_attachs`;



CREATE TABLE `pw_log_attachs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `operate` tinyint(3) NOT NULL DEFAULT '1',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sid_operate` (`sid`,`operate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_colonys`;



CREATE TABLE `pw_log_colonys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `operate` tinyint(3) NOT NULL DEFAULT '1',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sid_operate` (`sid`,`operate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_diary`;



CREATE TABLE `pw_log_diary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `operate` tinyint(3) NOT NULL DEFAULT '1',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sid_operate` (`sid`,`operate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_forums`;



CREATE TABLE `pw_log_forums` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `operate` tinyint(3) NOT NULL DEFAULT '1',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sid_operate` (`sid`,`operate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_members`;



CREATE TABLE `pw_log_members` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `operate` tinyint(3) NOT NULL DEFAULT '1',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sid_operate` (`sid`,`operate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_postdefend`;



CREATE TABLE `pw_log_postdefend` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_posts`;



CREATE TABLE `pw_log_posts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `operate` tinyint(3) NOT NULL DEFAULT '1',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sid_operate` (`sid`,`operate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_postverify`;



CREATE TABLE `pw_log_postverify` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` int(10) unsigned NOT NULL DEFAULT '0',
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_tid_pid` (`tid`,`pid`),
  KEY `idx_modifiedtime` (`modified_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_setting`;



CREATE TABLE `pw_log_setting` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `vector` varchar(255) NOT NULL DEFAULT '',
  `cipher` varchar(255) NOT NULL DEFAULT '',
  `field1` varchar(255) NOT NULL DEFAULT '',
  `field2` varchar(255) NOT NULL DEFAULT '',
  `field3` int(10) unsigned NOT NULL DEFAULT '0',
  `field4` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_threads`;



CREATE TABLE `pw_log_threads` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `operate` tinyint(3) NOT NULL DEFAULT '1',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sid_operate` (`sid`,`operate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_userdefend`;



CREATE TABLE `pw_log_userdefend` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_log_weibos`;



CREATE TABLE `pw_log_weibos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` int(10) unsigned NOT NULL DEFAULT '0',
  `operate` tinyint(3) NOT NULL DEFAULT '1',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sid_operate` (`sid`,`operate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_medal_apply`;



CREATE TABLE `pw_medal_apply` (
  `apply_id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT '0',
  `medal_id` smallint(6) NOT NULL DEFAULT '0',
  `timestamp` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`apply_id`),
  KEY `idx_uid` (`uid`),
  KEY `idx_medal_id` (`medal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_medal_award`;



CREATE TABLE `pw_medal_award` (
  `award_id` int(10) NOT NULL AUTO_INCREMENT,
  `medal_id` smallint(6) NOT NULL DEFAULT '0',
  `uid` int(10) NOT NULL DEFAULT '0',
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `timestamp` int(10) NOT NULL DEFAULT '0',
  `deadline` int(10) NOT NULL,
  PRIMARY KEY (`award_id`),
  UNIQUE KEY `idx_medalid_uid` (`medal_id`,`uid`),
  KEY `idx_deadline` (`deadline`),
  KEY `idx_uid` (`uid`),
  KEY `idx_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_medal_info`;



CREATE TABLE `pw_medal_info` (
  `medal_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `identify` varchar(30) NOT NULL DEFAULT '',
  `name` varchar(80) NOT NULL DEFAULT '',
  `descrip` varchar(255) NOT NULL,
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `image` varchar(255) NOT NULL DEFAULT '',
  `sortorder` int(10) NOT NULL DEFAULT '0',
  `is_apply` tinyint(3) NOT NULL DEFAULT '1',
  `is_open` tinyint(3) NOT NULL DEFAULT '1',
  `allow_group` text NOT NULL,
  `associate` varchar(30) NOT NULL DEFAULT '',
  `confine` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`medal_id`),
  UNIQUE KEY `idx_identify` (`identify`),
  KEY `idx_type` (`type`),
  KEY `idx_sortorder` (`sortorder`),
  KEY `idx_associate` (`associate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_medal_log`;



CREATE TABLE `pw_medal_log` (
  `log_id` int(10) NOT NULL AUTO_INCREMENT,
  `award_id` int(10) NOT NULL DEFAULT '0',
  `medal_id` smallint(6) NOT NULL DEFAULT '0',
  `timestamp` int(10) NOT NULL,
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_member_behavior_statistic`;



CREATE TABLE `pw_member_behavior_statistic` (
  `uid` int(10) NOT NULL,
  `behavior` tinyint(3) NOT NULL DEFAULT '0',
  `lastday` int(10) NOT NULL,
  `num` int(10) NOT NULL,
  UNIQUE KEY `idx_uid_behavior` (`uid`,`behavior`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_membercredit`;



CREATE TABLE `pw_membercredit` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `cid` tinyint(3) NOT NULL DEFAULT '0',
  `value` mediumint(8) NOT NULL DEFAULT '0',
  KEY `idx_uid` (`uid`),
  KEY `idx_cid` (`cid`),
  KEY `idx_cid_value` (`cid`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_memberdata`;



CREATE TABLE `pw_memberdata` (
  `uid` int(10) 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',
  `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',
  `monoltime` int(10) unsigned NOT NULL DEFAULT '0',
  `todaypost` smallint(6) unsigned NOT NULL DEFAULT '0',
  `monthpost` smallint(6) unsigned NOT NULL DEFAULT '0',
  `uploadtime` int(10) unsigned NOT NULL DEFAULT '0',
  `uploadnum` smallint(6) unsigned NOT NULL DEFAULT '0',
  `follows` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `fans` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `newfans` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `newreferto` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `newcomment` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `onlineip` varchar(30) NOT NULL DEFAULT '',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `postcheck` varchar(255) NOT NULL DEFAULT '',
  `pwdctime` int(10) unsigned NOT NULL DEFAULT '0',
  `f_num` int(10) unsigned NOT NULL DEFAULT '0',
  `creditpop` varchar(150) NOT NULL DEFAULT '',
  `jobnum` smallint(3) unsigned NOT NULL DEFAULT '0',
  `lastmsg` int(10) unsigned NOT NULL DEFAULT '0',
  `lastgrab` int(10) unsigned NOT NULL DEFAULT '0',
  `punch` int(10) unsigned NOT NULL DEFAULT '0',
  `shafa` mediumint(8) NOT NULL DEFAULT '0',
  `newnotice` mediumint(8) NOT NULL DEFAULT '0',
  `newrequest` mediumint(8) NOT NULL DEFAULT '0',
  `bubble` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`),
  KEY `idx_postnum` (`postnum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_memberinfo`;



CREATE TABLE `pw_memberinfo` (
  `uid` int(10) unsigned NOT NULL DEFAULT '1',
  `adsips` mediumtext NOT NULL,
  `credit` text NOT NULL,
  `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 '',
  `readmsg` mediumtext NOT NULL,
  `delmsg` mediumtext NOT NULL,
  `tooltime` varchar(42) NOT NULL DEFAULT '',
  `replyinfo` varchar(81) NOT NULL DEFAULT '',
  `lasttime` int(10) NOT NULL DEFAULT '0',
  `digtid` text NOT NULL,
  `customdata` text NOT NULL,
  `tradeinfo` text NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_members`;



CREATE TABLE `pw_members` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL DEFAULT '',
  `password` varchar(40) NOT NULL DEFAULT '',
  `safecv` varchar(10) NOT NULL DEFAULT '',
  `email` varchar(60) NOT NULL DEFAULT '',
  `groupid` tinyint(3) NOT NULL DEFAULT '-1',
  `memberid` tinyint(3) NOT NULL DEFAULT '0',
  `groups` varchar(255) NOT NULL DEFAULT '',
  `icon` varchar(255) NOT NULL DEFAULT '',
  `gender` tinyint(1) NOT NULL DEFAULT '0',
  `regdate` int(10) unsigned NOT NULL DEFAULT '0',
  `signature` text NOT NULL,
  `introduce` text NOT NULL,
  `oicq` varchar(12) NOT NULL DEFAULT '',
  `aliww` varchar(30) NOT NULL,
  `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(100) NOT NULL DEFAULT '',
  `bday` date NOT NULL DEFAULT '0000-00-00',
  `lastaddrst` varchar(255) NOT NULL DEFAULT '',
  `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',
  `attach` varchar(50) NOT NULL DEFAULT '',
  `hack` varchar(255) NOT NULL DEFAULT '0',
  `newpm` smallint(6) unsigned NOT NULL DEFAULT '0',
  `banpm` text NOT NULL,
  `msggroups` varchar(255) NOT NULL DEFAULT '',
  `medals` varchar(255) NOT NULL DEFAULT '',
  `userstatus` int(10) unsigned NOT NULL DEFAULT '0',
  `shortcut` varchar(255) NOT NULL DEFAULT '',
  `authmobile` char(16) NOT NULL DEFAULT '',
  `realname` varchar(16) NOT NULL DEFAULT '',
  `apartment` int(10) unsigned NOT NULL DEFAULT '0',
  `home` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_groupid` (`groupid`),
  KEY `idx_email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_membertags`;



CREATE TABLE `pw_membertags` (
  `tagid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tagname` varchar(32) NOT NULL DEFAULT '',
  `num` int(10) unsigned NOT NULL DEFAULT '0',
  `ifhot` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`tagid`),
  UNIQUE KEY `idx_tagname` (`tagname`),
  KEY `idx_ifhot_num` (`ifhot`,`num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_membertags_relations`;



CREATE TABLE `pw_membertags_relations` (
  `tagid` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `crtime` int(10) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `idx_tagid_userid` (`tagid`,`userid`),
  KEY `idx_userid` (`userid`),
  KEY `idx_crtime` (`crtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_memo`;



CREATE TABLE `pw_memo` (
  `mid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL DEFAULT '',
  `postdate` int(10) NOT NULL DEFAULT '0',
  `content` text NOT NULL,
  `isuser` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mid`),
  KEY `idx_isuser_username` (`isuser`,`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_modehot`;



CREATE TABLE `pw_modehot` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned DEFAULT '0',
  `sort` tinyint(3) NOT NULL DEFAULT '1',
  `tag` varchar(20) DEFAULT '',
  `type_name` varchar(100) NOT NULL DEFAULT '',
  `filter_type` text NOT NULL,
  `filter_time` text NOT NULL,
  `display` tinyint(3) NOT NULL DEFAULT '0',
  `active` tinyint(3) NOT NULL DEFAULT '0',
  `remark` varchar(100) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_mpageconfig`;



CREATE TABLE `pw_mpageconfig` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `mode` varchar(20) NOT NULL DEFAULT '',
  `scr` varchar(20) NOT NULL DEFAULT '',
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `invokes` text NOT NULL,
  `config` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_mode_scr_fid` (`mode`,`scr`,`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ms_attachs`;



CREATE TABLE `pw_ms_attachs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `aid` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  `rid` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) NOT NULL DEFAULT '0',
  `created_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_mid` (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ms_configs`;



CREATE TABLE `pw_ms_configs` (
  `uid` int(10) unsigned NOT NULL,
  `blacklist` text,
  `blackcolony` text,
  `blackgroup` text,
  `categories` text,
  `statistics` text,
  `shieldinfo` text,
  `sms_num` int(10) unsigned NOT NULL DEFAULT '0',
  `notice_num` int(10) unsigned NOT NULL DEFAULT '0',
  `request_num` int(10) unsigned NOT NULL DEFAULT '0',
  `groupsms_num` int(10) unsigned NOT NULL DEFAULT '0',
  `field1` text,
  `field2` text,
  `num1` int(10) unsigned NOT NULL DEFAULT '0',
  `num2` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ms_messages`;



CREATE TABLE `pw_ms_messages` (
  `mid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `create_uid` int(10) unsigned NOT NULL DEFAULT '0',
  `create_username` varchar(15) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `content` text,
  `extra` text,
  `expand` varchar(255) NOT NULL DEFAULT '',
  `attach` tinyint(1) NOT NULL DEFAULT '0',
  `created_time` int(10) NOT NULL DEFAULT '0',
  `modified_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ms_relations`;



CREATE TABLE `pw_ms_relations` (
  `rid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  `categoryid` smallint(3) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(3) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `isown` tinyint(1) NOT NULL DEFAULT '0',
  `created_time` int(10) NOT NULL DEFAULT '0',
  `actived_time` int(10) NOT NULL DEFAULT '0',
  `modified_time` int(10) NOT NULL DEFAULT '0',
  `relation` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`rid`),
  KEY `idx_uid_categoryid_typeid_modifiedtime` (`uid`,`categoryid`,`typeid`,`modified_time`),
  KEY `idx_uid_categoryid_modifiedtime` (`uid`,`categoryid`,`modified_time`),
  KEY `idx_uid_status_modifiedtime` (`uid`,`status`,`modified_time`),
  KEY `idx_uid_isown_modifiedtime` (`uid`,`isown`,`modified_time`),
  KEY `idx_mid` (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ms_replies`;



CREATE TABLE `pw_ms_replies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parentid` int(10) unsigned NOT NULL DEFAULT '0',
  `create_uid` int(10) unsigned NOT NULL DEFAULT '0',
  `create_username` varchar(15) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `content` text,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_time` int(10) NOT NULL DEFAULT '0',
  `modified_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_parentid_createdtime` (`parentid`,`created_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ms_searchs`;



CREATE TABLE `pw_ms_searchs` (
  `rid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(3) unsigned NOT NULL DEFAULT '0',
  `create_uid` int(10) unsigned NOT NULL DEFAULT '0',
  `created_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rid`),
  KEY `idx_uid_createuid_createdtime` (`uid`,`create_uid`,`created_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ms_tasks`;



CREATE TABLE `pw_ms_tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `oid` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  `created_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_createdtime` (`created_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_nav`;



CREATE TABLE `pw_nav` (
  `nid` smallint(6) NOT NULL AUTO_INCREMENT,
  `nkey` varchar(32) NOT NULL DEFAULT '',
  `type` varchar(32) NOT NULL DEFAULT '',
  `title` char(50) NOT NULL DEFAULT '',
  `style` char(50) NOT NULL DEFAULT '',
  `link` char(100) NOT NULL DEFAULT '',
  `alt` char(50) NOT NULL DEFAULT '',
  `pos` varchar(255) NOT NULL,
  `target` tinyint(3) NOT NULL DEFAULT '0',
  `view` smallint(6) NOT NULL DEFAULT '0',
  `upid` smallint(6) NOT NULL DEFAULT '0',
  `isshow` tinyint(3) NOT NULL DEFAULT '0',
  `floattype` varchar(10) NOT NULL DEFAULT '',
  `listtype` varchar(10) NOT NULL DEFAULT '',
  `selflisttype` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_oboard`;



CREATE TABLE `pw_oboard` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `touid` int(10) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `postdate` int(10) NOT NULL DEFAULT '0',
  `c_num` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ifwordsfb` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_touid` (`touid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_online`;



CREATE TABLE `pw_online` (
  `olid` int(10) NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `lastvisit` int(10) NOT NULL DEFAULT '0',
  `ip` varchar(30) NOT NULL DEFAULT '',
  `fid` smallint(6) NOT NULL DEFAULT '0',
  `tid` int(10) NOT NULL DEFAULT '0',
  `groupid` tinyint(3) NOT NULL DEFAULT '0',
  `action` varchar(16) NOT NULL DEFAULT '',
  `ifhide` tinyint(1) NOT NULL DEFAULT '0',
  `uid` int(10) NOT NULL DEFAULT '0',
  `rand` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`olid`),
  KEY `idx_uid` (`uid`),
  KEY `idx_ip` (`ip`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_online_guest`;



CREATE TABLE `pw_online_guest` (
  `ip` int(10) NOT NULL DEFAULT '0',
  `token` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `lastvisit` int(10) NOT NULL DEFAULT '0',
  `fid` smallint(6) NOT NULL DEFAULT '0',
  `tid` int(10) NOT NULL DEFAULT '0',
  `action` tinyint(3) NOT NULL DEFAULT '0',
  `ifhide` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ip`,`token`),
  KEY `idx_ip` (`ip`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_online_statistics`;



CREATE TABLE `pw_online_statistics` (
  `name` char(30) NOT NULL DEFAULT '',
  `value` int(10) unsigned NOT NULL DEFAULT '0',
  `lastupdate` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_online_user`;



CREATE TABLE `pw_online_user` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` char(15) NOT NULL DEFAULT '',
  `lastvisit` int(10) NOT NULL DEFAULT '0',
  `ip` int(10) NOT NULL DEFAULT '0',
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `groupid` tinyint(3) NOT NULL DEFAULT '0',
  `action` tinyint(3) NOT NULL DEFAULT '0',
  `ifhide` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`),
  KEY `idx_fid` (`fid`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ouserdata`;



CREATE TABLE `pw_ouserdata` (
  `uid` int(10) unsigned NOT NULL,
  `index_privacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `profile_privacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `info_privacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `credit_privacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `owrite_privacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `msgboard_privacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `photos_privacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `diary_privacy` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `article_isfeed` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `diary_isfeed` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `photos_isfeed` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `group_isfeed` tinyint(3) unsigned DEFAULT '1',
  `visits` int(10) unsigned NOT NULL DEFAULT '0',
  `tovisits` int(10) unsigned NOT NULL DEFAULT '0',
  `tovisit` varchar(255) NOT NULL DEFAULT '',
  `whovisit` varchar(255) NOT NULL DEFAULT '',
  `diarynum` int(10) unsigned NOT NULL DEFAULT '0',
  `photonum` int(10) unsigned NOT NULL DEFAULT '0',
  `owritenum` int(10) unsigned NOT NULL DEFAULT '0',
  `groupnum` int(10) unsigned NOT NULL DEFAULT '0',
  `sharenum` int(10) unsigned NOT NULL DEFAULT '0',
  `diary_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `photo_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `owrite_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `group_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `share_lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `self_isfollow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `friend_isfollow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `cnlesp_isfollow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `article_isfollow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `diary_isfollow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `photos_isfollow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `group_isfollow` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `sinaweibo_isfollow` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `at_isfeed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_overprint`;



CREATE TABLE `pw_overprint` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(30) DEFAULT '',
  `icon` varchar(255) DEFAULT '',
  `related` tinyint(3) NOT NULL DEFAULT '0',
  `total` smallint(6) unsigned NOT NULL DEFAULT '0',
  `createtime` int(10) NOT NULL DEFAULT '0',
  `isopen` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_owritedata`;



CREATE TABLE `pw_owritedata` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `touid` int(10) unsigned NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `isshare` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `source` varchar(10) NOT NULL DEFAULT '',
  `content` varchar(255) NOT NULL DEFAULT '',
  `c_num` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_pagecache`;



CREATE TABLE `pw_pagecache` (
  `sign` char(32) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT '',
  `data` text NOT NULL,
  `cachetime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`sign`),
  KEY `idx_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_pageinvoke`;



CREATE TABLE `pw_pageinvoke` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scr` varchar(20) NOT NULL DEFAULT '',
  `sign` varchar(20) NOT NULL DEFAULT '',
  `invokename` varchar(50) NOT NULL DEFAULT '',
  `pieces` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ifverify` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_scr_sign_invokename` (`scr`,`sign`,`invokename`),
  KEY `idx_invokename` (`invokename`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_pcfield`;



CREATE TABLE `pw_pcfield` (
  `fieldid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `fieldname` varchar(30) NOT NULL DEFAULT '',
  `pcid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `type` varchar(20) NOT NULL DEFAULT '',
  `rules` mediumtext NOT NULL,
  `ifable` tinyint(3) NOT NULL DEFAULT '1',
  `ifsearch` tinyint(3) NOT NULL DEFAULT '0',
  `ifasearch` tinyint(3) NOT NULL DEFAULT '0',
  `threadshow` tinyint(3) NOT NULL DEFAULT '0',
  `ifmust` tinyint(3) NOT NULL DEFAULT '1',
  `ifdel` tinyint(3) NOT NULL DEFAULT '0',
  `textsize` tinyint(3) NOT NULL DEFAULT '0',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`fieldid`),
  KEY `idx_pcid` (`pcid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_pcmember`;



CREATE TABLE `pw_pcmember` (
  `pcmid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `pcid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `zip` varchar(255) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `nums` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `totalcash` varchar(20) NOT NULL DEFAULT '',
  `phone` varchar(15) NOT NULL DEFAULT '',
  `mobile` varchar(15) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `extra` tinyint(3) NOT NULL DEFAULT '0',
  `jointime` int(10) NOT NULL DEFAULT '0',
  `ifpay` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pcmid`),
  KEY `idx_tid_uid` (`tid`,`uid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_pcvalue1`;



CREATE TABLE `pw_pcvalue1` (
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifrecycle` tinyint(3) NOT NULL DEFAULT '0',
  `pctype` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `begintime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `limitnum` int(10) unsigned NOT NULL DEFAULT '0',
  `objecter` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `price` varchar(255) NOT NULL DEFAULT '',
  `deposit` varchar(255) NOT NULL DEFAULT '',
  `payway` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `contacter` varchar(255) NOT NULL DEFAULT '',
  `tel` varchar(255) NOT NULL DEFAULT '',
  `phone` varchar(255) NOT NULL DEFAULT '',
  `mobile` varchar(255) NOT NULL DEFAULT '',
  `pcattach` varchar(255) NOT NULL DEFAULT '',
  `mprice` varchar(255) NOT NULL DEFAULT '',
  `wangwang` varchar(255) NOT NULL DEFAULT '',
  `qq` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`tid`),
  KEY `idx_fid` (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_permission`;



CREATE TABLE `pw_permission` (
  `uid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `gid` smallint(6) unsigned NOT NULL,
  `rkey` varchar(20) NOT NULL DEFAULT '',
  `type` enum('basic','special','system','systemforum') NOT NULL,
  `rvalue` text NOT NULL,
  PRIMARY KEY (`uid`,`fid`,`gid`,`rkey`),
  KEY `idx_rkey` (`rkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_pidtmp`;



CREATE TABLE `pw_pidtmp` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_pinglog`;



CREATE TABLE `pw_pinglog` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) NOT NULL DEFAULT '0',
  `tid` int(10) NOT NULL DEFAULT '0',
  `pid` int(10) NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(15) NOT NULL DEFAULT '',
  `point` varchar(10) NOT NULL DEFAULT '',
  `pinger` varchar(15) NOT NULL DEFAULT '',
  `record` mediumtext NOT NULL,
  `pingdate` int(10) NOT NULL DEFAULT '0',
  `ifhide` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_tid_pid` (`tid`,`pid`),
  KEY `idx_pid` (`pid`),
  KEY `idx_fid_tid_pid` (`fid`,`tid`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_plan`;



CREATE TABLE `pw_plan` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(80) NOT NULL DEFAULT '',
  `month` varchar(2) NOT NULL DEFAULT '',
  `week` varchar(1) NOT NULL DEFAULT '',
  `day` varchar(2) NOT NULL DEFAULT '',
  `hour` varchar(80) NOT NULL DEFAULT '',
  `usetime` int(10) NOT NULL DEFAULT '0',
  `nexttime` int(10) NOT NULL DEFAULT '0',
  `ifsave` tinyint(3) NOT NULL DEFAULT '0',
  `ifopen` tinyint(3) NOT NULL DEFAULT '0',
  `filename` varchar(80) NOT NULL DEFAULT '',
  `config` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_polls`;



CREATE TABLE `pw_polls` (
  `pollid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `voteopts` mediumtext NOT NULL,
  `modifiable` tinyint(3) NOT NULL DEFAULT '0',
  `previewable` tinyint(3) NOT NULL DEFAULT '0',
  `multiple` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `mostvotes` smallint(6) unsigned NOT NULL DEFAULT '0',
  `voters` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `timelimit` int(10) NOT NULL DEFAULT '0',
  `leastvotes` int(10) unsigned NOT NULL DEFAULT '0',
  `regdatelimit` int(10) unsigned NOT NULL DEFAULT '0',
  `creditlimit` varchar(255) NOT NULL DEFAULT '',
  `postnumlimit` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`pollid`),
  KEY `idx_tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_portalpage`;



CREATE TABLE `pw_portalpage` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sign` varchar(50) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_sign` (`sign`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_postcate`;



CREATE TABLE `pw_postcate` (
  `pcid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `sign` enum('basic','buy') NOT NULL DEFAULT 'basic',
  `name` varchar(30) NOT NULL DEFAULT '',
  `ifable` tinyint(3) NOT NULL DEFAULT '1',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `viewright` varchar(255) NOT NULL DEFAULT '',
  `adminright` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`pcid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



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` smallint(6) unsigned NOT NULL DEFAULT '0',
  `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(100) NOT NULL DEFAULT '',
  `userip` varchar(15) NOT NULL DEFAULT '',
  `ifsign` tinyint(3) NOT NULL DEFAULT '0',
  `buy` text NOT NULL,
  `alterinfo` varchar(50) NOT NULL DEFAULT '',
  `remindinfo` varchar(150) NOT NULL DEFAULT '',
  `leaveword` varchar(255) NOT NULL DEFAULT '',
  `ipfrom` varchar(255) NOT NULL DEFAULT '',
  `ifconvert` tinyint(3) NOT NULL DEFAULT '1',
  `ifwordsfb` tinyint(3) NOT NULL DEFAULT '1',
  `ifcheck` tinyint(3) NOT NULL DEFAULT '0',
  `content` mediumtext NOT NULL,
  `ifmark` varchar(255) NOT NULL DEFAULT '',
  `ifreward` tinyint(3) NOT NULL DEFAULT '0',
  `ifshield` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `anonymous` tinyint(3) NOT NULL DEFAULT '0',
  `ifhide` tinyint(3) NOT NULL DEFAULT '0',
  `frommob` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`pid`),
  KEY `idx_fid` (`fid`),
  KEY `idx_postdate` (`postdate`),
  KEY `idx_tid` (`tid`,`postdate`),
  KEY `idx_authorid` (`authorid`),
  KEY `idx_ifcheck` (`ifcheck`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_postsfloor`;



CREATE TABLE `pw_postsfloor` (
  `tid` int(10) NOT NULL,
  `floor` int(10) NOT NULL AUTO_INCREMENT,
  `pid` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`,`floor`),
  UNIQUE KEY `idx_pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_poststopped`;



CREATE TABLE `pw_poststopped` (
  `fid` smallint(6) unsigned NOT NULL,
  `tid` int(10) unsigned NOT NULL,
  `pid` int(10) unsigned NOT NULL,
  `floor` int(10) unsigned NOT NULL,
  `uptime` int(10) unsigned NOT NULL DEFAULT '0',
  `overtime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`fid`,`tid`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_privacy`;



CREATE TABLE `pw_privacy` (
  `uid` mediumint(8) NOT NULL,
  `ptype` varchar(15) NOT NULL,
  `pkey` varchar(15) NOT NULL,
  `value` tinyint(3) NOT NULL,
  PRIMARY KEY (`uid`,`ptype`,`pkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_proclock`;



CREATE TABLE `pw_proclock` (
  `uid` mediumint(8) unsigned NOT NULL,
  `action` varchar(50) NOT NULL,
  `time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`,`action`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_pushdata`;



CREATE TABLE `pw_pushdata` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `invokepieceid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `editor` varchar(15) NOT NULL DEFAULT '',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `vieworder` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `titlecss` varchar(255) NOT NULL DEFAULT '',
  `pushtime` int(10) unsigned NOT NULL DEFAULT '0',
  `ifverify` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `data` text NOT NULL,
  `ifbusiness` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_ifverify_invokepieceid_vieworder_starttime` (`ifverify`,`invokepieceid`,`vieworder`,`starttime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_pushpic`;



CREATE TABLE `pw_pushpic` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(255) NOT NULL DEFAULT '',
  `invokepieceid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `creator` varchar(20) NOT NULL DEFAULT '',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_rate`;



CREATE TABLE `pw_rate` (
  `objectid` int(10) NOT NULL DEFAULT '0',
  `optionid` smallint(6) NOT NULL DEFAULT '0',
  `typeid` smallint(6) NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `created_at` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  KEY `idx_typeid_objectid_uid` (`typeid`,`objectid`,`uid`),
  KEY `idx_typeid_createdat_optionid_objectid` (`typeid`,`created_at`,`optionid`,`objectid`),
  KEY `idx_uid_createdat` (`uid`,`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_rateconfig`;



CREATE TABLE `pw_rateconfig` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(12) NOT NULL DEFAULT '',
  `icon` varchar(75) NOT NULL DEFAULT '',
  `isopen` tinyint(1) NOT NULL DEFAULT '1',
  `isdefault` tinyint(1) NOT NULL DEFAULT '0',
  `typeid` tinyint(1) NOT NULL DEFAULT '0',
  `creditset` tinyint(1) NOT NULL DEFAULT '0',
  `voternum` tinyint(1) NOT NULL DEFAULT '0',
  `authornum` tinyint(1) NOT NULL DEFAULT '0',
  `creator` varchar(20) DEFAULT '',
  `created_at` int(10) DEFAULT '0',
  `updater` varchar(20) DEFAULT '',
  `update_at` int(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_typeid` (`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_rateresult`;



CREATE TABLE `pw_rateresult` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `objectid` int(10) unsigned NOT NULL DEFAULT '0',
  `optionid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `typeid` tinyint(3) NOT NULL DEFAULT '0',
  `num` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_optionid_objectid` (`optionid`,`objectid`),
  KEY `idx_typeid_objectid` (`typeid`,`objectid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_recycle`;



CREATE TABLE `pw_recycle` (
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `deltime` int(10) unsigned NOT NULL DEFAULT '0',
  `admin` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`pid`,`tid`),
  KEY `idx_tid` (`tid`),
  KEY `idx_fid_pid` (`fid`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_replyreward`;



CREATE TABLE `pw_replyreward` (
  `tid` int(10) unsigned NOT NULL,
  `credittype` varchar(30) NOT NULL DEFAULT '',
  `creditnum` int(10) unsigned NOT NULL DEFAULT '0',
  `rewardtimes` smallint(5) unsigned NOT NULL DEFAULT '0',
  `repeattimes` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `chance` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `lefttimes` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_replyrewardrecord`;



CREATE TABLE `pw_replyrewardrecord` (
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `credittype` varchar(30) NOT NULL DEFAULT '',
  `creditnum` int(10) unsigned NOT NULL DEFAULT '0',
  `rewardtime` int(10) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `idx_tid_pid` (`tid`,`pid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_report`;



CREATE TABLE `pw_report` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `type` varchar(50) NOT NULL DEFAULT '',
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `reason` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_reward`;



CREATE TABLE `pw_reward` (
  `tid` int(10) unsigned NOT NULL,
  `cbtype` varchar(20) NOT NULL DEFAULT '',
  `catype` varchar(20) NOT NULL DEFAULT '',
  `cbval` int(10) NOT NULL DEFAULT '0',
  `caval` int(10) NOT NULL DEFAULT '0',
  `timelimit` int(10) NOT NULL DEFAULT '0',
  `author` varchar(30) NOT NULL DEFAULT '',
  `pid` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`),
  KEY `idx_timelimit` (`timelimit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_robbuild`;



CREATE TABLE `pw_robbuild` (
  `tid` int(10) unsigned NOT NULL,
  `authorid` int(10) unsigned NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `endbuild` smallint(6) unsigned NOT NULL DEFAULT '0',
  `awardbuilds` varchar(255) NOT NULL DEFAULT '',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_robbuildfloor`;



CREATE TABLE `pw_robbuildfloor` (
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `floor` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`,`floor`),
  UNIQUE KEY `idx_pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_schcache`;



CREATE TABLE `pw_schcache` (
  `sid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `sorderby` varchar(13) NOT NULL DEFAULT '',
  `schline` varchar(32) NOT NULL DEFAULT '',
  `schtime` int(10) unsigned NOT NULL DEFAULT '0',
  `total` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `schedid` text NOT NULL,
  PRIMARY KEY (`sid`),
  KEY `idx_schline` (`schline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_school`;



CREATE TABLE `pw_school` (
  `schoolid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `schoolname` varchar(32) NOT NULL DEFAULT '',
  `areaid` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`schoolid`),
  KEY `idx_areaid_type` (`areaid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_searchadvert`;



CREATE TABLE `pw_searchadvert` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `keyword` varchar(32) NOT NULL DEFAULT '',
  `code` text NOT NULL,
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `ifshow` tinyint(3) NOT NULL DEFAULT '0',
  `orderby` tinyint(3) NOT NULL DEFAULT '0',
  `config` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_keyword` (`keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_searchforum`;



CREATE TABLE `pw_searchforum` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `vieworder` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_searchhotwords`;



CREATE TABLE `pw_searchhotwords` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `keyword` varchar(32) NOT NULL DEFAULT '',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `fromtype` enum('custom','auto') NOT NULL DEFAULT 'custom',
  `posttime` int(10) unsigned NOT NULL DEFAULT '0',
  `expire` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_searchstatistic`;



CREATE TABLE `pw_searchstatistic` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `keyword` varchar(32) NOT NULL DEFAULT '',
  `num` mediumint(8) NOT NULL DEFAULT '0',
  `created_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_created_time` (`created_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_setform`;



CREATE TABLE `pw_setform` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `ifopen` tinyint(3) NOT NULL DEFAULT '0',
  `value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



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` varchar(100) NOT NULL DEFAULT '',
  `url` varchar(100) NOT NULL DEFAULT '',
  `descrip` varchar(200) NOT NULL DEFAULT '0',
  `logo` varchar(100) NOT NULL DEFAULT '',
  `ifcheck` tinyint(3) NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_sharelinksrelation`;



CREATE TABLE `pw_sharelinksrelation` (
  `sid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `stid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `idx_stid_sid` (`stid`,`sid`),
  KEY `idx_sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_sharelinkstype`;



CREATE TABLE `pw_sharelinkstype` (
  `stid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `vieworder` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifable` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`stid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_singleright`;



CREATE TABLE `pw_singleright` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `visit` varchar(80) NOT NULL DEFAULT '',
  `post` varchar(80) NOT NULL DEFAULT '',
  `reply` varchar(80) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_smiles`;



CREATE TABLE `pw_smiles` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `descipt` varchar(100) NOT NULL DEFAULT '',
  `vieworder` tinyint(2) NOT NULL DEFAULT '0',
  `type` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_space`;



CREATE TABLE `pw_space` (
  `uid` int(10) unsigned NOT NULL,
  `name` varchar(80) NOT NULL DEFAULT '',
  `domain` varchar(20) NOT NULL DEFAULT '',
  `spacetype` tinyint(1) NOT NULL DEFAULT '0',
  `banner` varchar(50) NOT NULL DEFAULT '',
  `skin` varchar(15) NOT NULL DEFAULT '',
  `visits` int(10) unsigned NOT NULL DEFAULT '0',
  `tovisits` int(10) unsigned NOT NULL DEFAULT '0',
  `visitors` varchar(255) NOT NULL DEFAULT '',
  `tovisitors` varchar(255) NOT NULL DEFAULT '',
  `layout` text NOT NULL,
  `modelset` text NOT NULL,
  `descript` varchar(255) NOT NULL DEFAULT '',
  `spacestyle` tinyint(3) unsigned NOT NULL DEFAULT '2',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_sqlcv`;



CREATE TABLE `pw_sqlcv` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `var` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_statistics_daily`;



CREATE TABLE `pw_statistics_daily` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(32) NOT NULL DEFAULT '',
  `typeid` int(6) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `value` int(11) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name_date_typeid` (`name`,`date`,`typeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_stopic`;



CREATE TABLE `pw_stopic` (
  `stopic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0',
  `bg_id` int(10) NOT NULL DEFAULT '0',
  `copy_from` int(10) unsigned NOT NULL DEFAULT '0',
  `layout` varchar(20) NOT NULL DEFAULT '',
  `create_date` int(10) unsigned NOT NULL DEFAULT '0',
  `start_date` int(10) unsigned NOT NULL DEFAULT '0',
  `end_date` int(10) unsigned NOT NULL DEFAULT '0',
  `used_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `view_count` int(10) unsigned NOT NULL DEFAULT '0',
  `banner_url` varchar(100) NOT NULL DEFAULT '',
  `seo_keyword` varchar(255) NOT NULL DEFAULT '',
  `seo_desc` varchar(255) NOT NULL DEFAULT '',
  `block_config` text NOT NULL,
  `layout_config` text NOT NULL,
  `nav_config` text NOT NULL,
  `file_name` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`stopic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_stopic_comment`;



CREATE TABLE `pw_stopic_comment` (
  `commentid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `stopic_id` int(10) unsigned NOT NULL DEFAULT '0',
  `content` varchar(255) NOT NULL DEFAULT '',
  `replynum` smallint(6) unsigned NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`commentid`),
  KEY `idx_stopicid_postdate` (`stopic_id`,`postdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_stopic_commentreply`;



CREATE TABLE `pw_stopic_commentreply` (
  `replyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `commentid` int(10) unsigned NOT NULL DEFAULT '0',
  `content` varchar(255) NOT NULL DEFAULT '',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`replyid`),
  KEY `idx_commentid_postdate` (`commentid`,`postdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_stopicblock`;



CREATE TABLE `pw_stopicblock` (
  `block_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `tagcode` text NOT NULL,
  `begin` text NOT NULL,
  `loops` text NOT NULL,
  `end` text NOT NULL,
  `config` varchar(255) NOT NULL DEFAULT '',
  `replacetag` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`block_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_stopiccategory`;



CREATE TABLE `pw_stopiccategory` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL DEFAULT '',
  `status` tinyint(3) NOT NULL DEFAULT '0',
  `num` smallint(6) NOT NULL DEFAULT '0',
  `creator` varchar(20) DEFAULT '',
  `createtime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_stopicpictures`;



CREATE TABLE `pw_stopicpictures` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `categoryid` smallint(6) NOT NULL DEFAULT '0',
  `title` varchar(45) NOT NULL DEFAULT '',
  `path` varchar(255) NOT NULL DEFAULT '',
  `num` smallint(6) NOT NULL DEFAULT '0',
  `creator` varchar(20) DEFAULT '',
  `createtime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_stopicunit`;



CREATE TABLE `pw_stopicunit` (
  `unit_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stopic_id` int(10) unsigned NOT NULL DEFAULT '0',
  `html_id` varchar(50) NOT NULL DEFAULT '',
  `block_id` smallint(6) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `data` text NOT NULL,
  PRIMARY KEY (`unit_id`),
  UNIQUE KEY `idx_stopicid_htmlid` (`stopic_id`,`html_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_styles`;



CREATE TABLE `pw_styles` (
  `sid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `customname` varchar(50) NOT NULL DEFAULT '',
  `createtime` int(10) NOT NULL DEFAULT '0',
  `lastmodify` int(10) NOT NULL DEFAULT '0',
  `ifopen` tinyint(1) NOT NULL DEFAULT '0',
  `stylepath` varchar(50) NOT NULL DEFAULT '',
  `tplpath` varchar(50) NOT NULL DEFAULT '',
  `yeyestyle` varchar(3) NOT NULL DEFAULT '',
  `bgcolor` varchar(100) NOT NULL DEFAULT '',
  `linkcolor` varchar(7) NOT NULL DEFAULT '',
  `tablecolor` varchar(7) NOT NULL DEFAULT '',
  `tdcolor` varchar(7) NOT NULL DEFAULT '',
  `tablewidth` varchar(7) NOT NULL DEFAULT '',
  `mtablewidth` varchar(7) NOT NULL DEFAULT '',
  `headcolor` varchar(100) NOT NULL DEFAULT '',
  `headborder` varchar(7) NOT NULL DEFAULT '',
  `headfontone` varchar(7) NOT NULL DEFAULT '',
  `headfonttwo` varchar(7) NOT NULL DEFAULT '',
  `cbgcolor` varchar(100) NOT NULL DEFAULT '',
  `cbgborder` varchar(7) NOT NULL DEFAULT '',
  `cbgfont` varchar(7) NOT NULL DEFAULT '',
  `forumcolorone` varchar(7) NOT NULL DEFAULT '',
  `forumcolortwo` varchar(7) NOT NULL DEFAULT '',
  `extcss` text NOT NULL,
  PRIMARY KEY (`sid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_tagdata`;



CREATE TABLE `pw_tagdata` (
  `tagid` mediumint(8) NOT NULL DEFAULT '0',
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `idx_tagid` (`tagid`),
  KEY `idx_tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_tags`;



CREATE TABLE `pw_tags` (
  `tagid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `tagname` varchar(15) NOT NULL DEFAULT '',
  `num` mediumint(8) NOT NULL DEFAULT '0',
  `ifhot` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tagid`),
  KEY `idx_ifhot_num` (`ifhot`,`num`),
  KEY `idx_tagname` (`tagname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_task`;



CREATE TABLE `pw_task` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(20) DEFAULT '',
  `task` varchar(255) DEFAULT '',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `last` int(10) unsigned NOT NULL DEFAULT '0',
  `next` int(10) unsigned NOT NULL DEFAULT '0',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_next` (`next`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_temp_keywords`;



CREATE TABLE `pw_temp_keywords` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `keyword` varchar(32) NOT NULL DEFAULT '',
  `created_time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_threads`;



CREATE TABLE `pw_threads` (
  `tid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `icon` tinyint(3) NOT NULL DEFAULT '0',
  `titlefont` varchar(15) NOT NULL DEFAULT '',
  `author` varchar(15) NOT NULL DEFAULT '',
  `authorid` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(100) NOT NULL DEFAULT '',
  `toolinfo` varchar(16) NOT NULL DEFAULT '',
  `toolfield` varchar(21) NOT NULL DEFAULT '',
  `ifcheck` tinyint(3) NOT NULL DEFAULT '0',
  `type` smallint(6) NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `lastposter` varchar(15) NOT NULL DEFAULT '',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  `replies` int(10) unsigned NOT NULL DEFAULT '0',
  `favors` int(10) NOT NULL DEFAULT '0',
  `modelid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `shares` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `topped` smallint(6) NOT NULL DEFAULT '0',
  `topreplays` smallint(6) NOT NULL DEFAULT '0',
  `locked` tinyint(3) NOT NULL DEFAULT '0',
  `digest` tinyint(3) NOT NULL DEFAULT '0',
  `special` tinyint(3) NOT NULL DEFAULT '0',
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `ifupload` tinyint(3) NOT NULL DEFAULT '0',
  `ifmail` tinyint(3) NOT NULL DEFAULT '0',
  `ifmark` smallint(6) NOT NULL DEFAULT '0',
  `ifshield` tinyint(3) NOT NULL DEFAULT '0',
  `anonymous` tinyint(3) NOT NULL DEFAULT '0',
  `dig` int(10) NOT NULL DEFAULT '0',
  `fight` int(10) NOT NULL DEFAULT '0',
  `ptable` tinyint(3) NOT NULL DEFAULT '0',
  `ifmagic` tinyint(3) NOT NULL DEFAULT '0',
  `ifhide` tinyint(3) NOT NULL DEFAULT '0',
  `inspect` varchar(30) NOT NULL DEFAULT '',
  `frommob` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `tpcstatus` int(10) unsigned NOT NULL DEFAULT '0',
  `specialsort` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`),
  KEY `idx_authorid` (`authorid`),
  KEY `idx_postdate` (`postdate`),
  KEY `idx_digest` (`digest`),
  KEY `idx_fid_type_ifcheck` (`fid`,`type`,`ifcheck`),
  KEY `idx_special` (`special`),
  KEY `idx_fid_ifcheck_specialsort_lastpost` (`fid`,`ifcheck`,`specialsort`,`lastpost`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_threads_at`;



CREATE TABLE `pw_threads_at` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_tid_pid_uid` (`tid`,`pid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_threads_img`;



CREATE TABLE `pw_threads_img` (
  `tid` int(10) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `tpcnum` smallint(5) unsigned NOT NULL DEFAULT '0',
  `totalnum` smallint(5) unsigned NOT NULL DEFAULT '0',
  `collectnum` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `cover` varchar(80) NOT NULL DEFAULT '',
  `ifcheck` tinyint(3) NOT NULL DEFAULT '1',
  `topped` smallint(6) NOT NULL DEFAULT '0',
  `ifthumb` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`),
  KEY `idx_fid_topped_tid` (`fid`,`topped`,`tid`),
  KEY `idx_fid_topped_totalnum` (`fid`,`topped`,`totalnum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_tmsgs`;



CREATE TABLE `pw_tmsgs` (
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `aid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `userip` varchar(15) NOT NULL DEFAULT '',
  `ifsign` tinyint(3) NOT NULL DEFAULT '0',
  `buy` text NOT NULL,
  `ipfrom` varchar(255) NOT NULL DEFAULT '',
  `alterinfo` varchar(50) NOT NULL DEFAULT '',
  `remindinfo` varchar(150) NOT NULL DEFAULT '',
  `tags` varchar(100) NOT NULL DEFAULT '',
  `ifconvert` tinyint(3) NOT NULL DEFAULT '1',
  `ifwordsfb` tinyint(3) NOT NULL DEFAULT '1',
  `content` mediumtext NOT NULL,
  `form` varchar(30) NOT NULL DEFAULT '',
  `ifmark` varchar(255) NOT NULL DEFAULT '',
  `c_from` varchar(30) NOT NULL DEFAULT '',
  `magic` varchar(50) NOT NULL DEFAULT '',
  `overprint` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_toollog`;



CREATE TABLE `pw_toollog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL DEFAULT '',
  `nums` smallint(6) NOT NULL DEFAULT '0',
  `money` smallint(6) NOT NULL DEFAULT '0',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `ip` varchar(15) NOT NULL DEFAULT '',
  `time` int(10) NOT NULL DEFAULT '0',
  `filename` varchar(20) NOT NULL DEFAULT '',
  `touid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_uid` (`uid`),
  KEY `idx_touid` (`touid`),
  KEY `idx_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_tools`;



CREATE TABLE `pw_tools` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL DEFAULT '',
  `filename` varchar(20) NOT NULL DEFAULT '',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `logo` varchar(100) NOT NULL DEFAULT '',
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `price` varchar(255) NOT NULL DEFAULT '',
  `creditype` varchar(10) NOT NULL DEFAULT '',
  `rmb` decimal(8,2) NOT NULL,
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `stock` smallint(6) NOT NULL DEFAULT '0',
  `conditions` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topiccate`;



CREATE TABLE `pw_topiccate` (
  `cateid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `ifable` tinyint(3) NOT NULL DEFAULT '1',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `ifdel` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cateid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicfield`;



CREATE TABLE `pw_topicfield` (
  `fieldid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `fieldname` varchar(30) NOT NULL DEFAULT '',
  `modelid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `type` varchar(20) NOT NULL DEFAULT '0',
  `rules` mediumtext NOT NULL,
  `ifable` tinyint(3) NOT NULL DEFAULT '1',
  `ifsearch` tinyint(3) NOT NULL DEFAULT '0',
  `ifasearch` tinyint(3) NOT NULL DEFAULT '0',
  `threadshow` tinyint(3) NOT NULL DEFAULT '0',
  `ifmust` tinyint(3) NOT NULL DEFAULT '1',
  `textsize` tinyint(3) NOT NULL DEFAULT '0',
  `descrip` varchar(255) NOT NULL,
  PRIMARY KEY (`fieldid`),
  KEY `idx_modelid` (`modelid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicmodel`;



CREATE TABLE `pw_topicmodel` (
  `modelid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `cateid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ifable` tinyint(3) NOT NULL DEFAULT '1',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`modelid`),
  KEY `idx_cateid` (`cateid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topictype`;



CREATE TABLE `pw_topictype` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `logo` varchar(255) NOT NULL DEFAULT '',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0',
  `upid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `ifsys` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `isdefault` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicvalue1`;



CREATE TABLE `pw_topicvalue1` (
  `tid` mediumint(8) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `ifrecycle` tinyint(1) NOT NULL DEFAULT '0',
  `field1` varchar(255) NOT NULL,
  `field2` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field3` varchar(255) NOT NULL,
  `field4` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field5` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field6` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field7` int(10) unsigned NOT NULL DEFAULT '0',
  `field8` int(10) unsigned NOT NULL DEFAULT '0',
  `field9` int(10) unsigned NOT NULL DEFAULT '0',
  `field10` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field11` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field12` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field13` varchar(255) NOT NULL,
  `field14` varchar(255) NOT NULL,
  `field15` varchar(255) NOT NULL,
  `field16` varchar(255) NOT NULL,
  `field17` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field18` varchar(255) NOT NULL,
  `field19` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field20` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field21` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field22` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field23` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicvalue2`;



CREATE TABLE `pw_topicvalue2` (
  `tid` mediumint(8) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `ifrecycle` tinyint(1) NOT NULL DEFAULT '0',
  `field24` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field25` varchar(255) NOT NULL,
  `field26` varchar(255) NOT NULL,
  `field27` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field28` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field29` int(10) unsigned NOT NULL DEFAULT '0',
  `field30` int(10) unsigned NOT NULL DEFAULT '0',
  `field31` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field32` int(10) unsigned NOT NULL DEFAULT '0',
  `field33` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field34` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field35` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field36` int(10) unsigned NOT NULL DEFAULT '0',
  `field37` int(10) unsigned NOT NULL DEFAULT '0',
  `field38` varchar(255) NOT NULL,
  `field39` varchar(255) NOT NULL,
  `field40` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field41` varchar(255) NOT NULL,
  `field42` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field43` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field44` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field45` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicvalue3`;



CREATE TABLE `pw_topicvalue3` (
  `tid` mediumint(8) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `ifrecycle` tinyint(1) NOT NULL DEFAULT '0',
  `field46` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field47` varchar(255) NOT NULL,
  `field48` varchar(255) NOT NULL,
  `field49` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field50` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field51` int(10) unsigned NOT NULL DEFAULT '0',
  `field52` int(10) unsigned NOT NULL DEFAULT '0',
  `field53` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field54` int(10) unsigned NOT NULL DEFAULT '0',
  `field55` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field56` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field57` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field58` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field59` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field60` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field61` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field62` int(10) unsigned NOT NULL DEFAULT '0',
  `field63` int(10) unsigned NOT NULL DEFAULT '0',
  `field64` varchar(255) NOT NULL,
  `field65` varchar(255) NOT NULL,
  `field66` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field67` varchar(255) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicvalue4`;



CREATE TABLE `pw_topicvalue4` (
  `tid` mediumint(8) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `ifrecycle` tinyint(1) NOT NULL DEFAULT '0',
  `field68` varchar(255) NOT NULL,
  `field69` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field70` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field71` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field72` varchar(255) NOT NULL,
  `field73` varchar(255) NOT NULL,
  `field74` varchar(255) NOT NULL,
  `field75` varchar(255) NOT NULL,
  `field76` varchar(255) NOT NULL,
  `field77` varchar(255) NOT NULL,
  `field78` varchar(255) NOT NULL,
  `field79` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field80` varchar(255) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicvalue5`;



CREATE TABLE `pw_topicvalue5` (
  `tid` mediumint(8) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `ifrecycle` tinyint(1) NOT NULL DEFAULT '0',
  `field81` varchar(255) NOT NULL,
  `field82` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field83` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field84` varchar(255) NOT NULL,
  `field85` varchar(255) NOT NULL,
  `field86` varchar(255) NOT NULL,
  `field87` varchar(255) NOT NULL,
  `field88` varchar(255) NOT NULL,
  `field89` varchar(255) NOT NULL,
  `field90` varchar(255) NOT NULL,
  `field91` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field92` varchar(255) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicvalue6`;



CREATE TABLE `pw_topicvalue6` (
  `tid` mediumint(8) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `ifrecycle` tinyint(1) NOT NULL DEFAULT '0',
  `field93` varchar(255) NOT NULL,
  `field94` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field95` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field96` varchar(255) NOT NULL,
  `field97` varchar(255) NOT NULL,
  `field98` varchar(255) NOT NULL,
  `field99` varchar(255) NOT NULL,
  `field100` varchar(255) NOT NULL,
  `field101` varchar(255) NOT NULL,
  `field102` varchar(255) NOT NULL,
  `field103` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field104` varchar(255) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicvalue7`;



CREATE TABLE `pw_topicvalue7` (
  `tid` mediumint(8) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `ifrecycle` tinyint(1) NOT NULL DEFAULT '0',
  `field105` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field106` varchar(255) NOT NULL,
  `field107` varchar(255) NOT NULL,
  `field108` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field109` int(10) unsigned NOT NULL DEFAULT '0',
  `field110` varchar(255) NOT NULL,
  `field111` varchar(255) NOT NULL,
  `field112` varchar(255) NOT NULL,
  `field113` varchar(255) NOT NULL,
  `field114` varchar(255) NOT NULL,
  `field115` varchar(255) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_topicvalue8`;



CREATE TABLE `pw_topicvalue8` (
  `tid` mediumint(8) unsigned NOT NULL,
  `fid` smallint(6) unsigned NOT NULL,
  `ifrecycle` tinyint(1) NOT NULL DEFAULT '0',
  `field116` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `field117` varchar(255) NOT NULL,
  `field118` varchar(255) NOT NULL,
  `field119` varchar(255) NOT NULL,
  `field120` varchar(255) NOT NULL,
  `field121` varchar(255) NOT NULL,
  `field122` varchar(255) NOT NULL,
  `field123` varchar(255) NOT NULL,
  `field124` varchar(255) NOT NULL,
  `field125` varchar(255) NOT NULL,
  `field126` varchar(255) NOT NULL,
  `field127` varchar(255) NOT NULL,
  `field128` varchar(255) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_tpl`;



CREATE TABLE `pw_tpl` (
  `tplid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `tagcode` text NOT NULL,
  `image` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`tplid`),
  KEY `idx_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_trade`;



CREATE TABLE `pw_trade` (
  `tid` int(10) unsigned NOT NULL,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(80) NOT NULL DEFAULT '',
  `icon` varchar(80) NOT NULL DEFAULT '',
  `degree` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `type` smallint(6) unsigned NOT NULL DEFAULT '0',
  `num` smallint(6) unsigned NOT NULL DEFAULT '0',
  `salenum` smallint(6) unsigned NOT NULL DEFAULT '0',
  `price` decimal(8,2) NOT NULL DEFAULT '0.00',
  `costprice` decimal(8,2) NOT NULL DEFAULT '0.00',
  `locus` varchar(30) NOT NULL DEFAULT '',
  `paymethod` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `transport` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `mailfee` decimal(6,2) NOT NULL DEFAULT '0.00',
  `expressfee` decimal(6,2) NOT NULL DEFAULT '0.00',
  `emsfee` decimal(6,2) NOT NULL DEFAULT '0.00',
  `deadline` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_tradeorder`;



CREATE TABLE `pw_tradeorder` (
  `oid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `order_no` varchar(30) NOT NULL DEFAULT '0',
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(80) NOT NULL DEFAULT '',
  `buyer` int(10) unsigned NOT NULL DEFAULT '0',
  `seller` int(10) unsigned NOT NULL DEFAULT '0',
  `price` decimal(6,2) NOT NULL DEFAULT '0.00',
  `quantity` smallint(6) unsigned NOT NULL DEFAULT '0',
  `transportfee` decimal(6,2) NOT NULL DEFAULT '0.00',
  `transport` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `buydate` int(10) unsigned NOT NULL DEFAULT '0',
  `tradedate` int(10) unsigned NOT NULL DEFAULT '0',
  `ifpay` tinyint(3) NOT NULL DEFAULT '0',
  `address` varchar(80) NOT NULL DEFAULT '',
  `consignee` varchar(15) NOT NULL DEFAULT '',
  `tel` varchar(15) NOT NULL DEFAULT '',
  `zip` varchar(15) NOT NULL DEFAULT '',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `payment` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `tradeinfo` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`oid`),
  UNIQUE KEY `idx_orderno` (`order_no`),
  KEY `idx_tid` (`tid`),
  KEY `idx_buyer` (`buyer`),
  KEY `idx_seller` (`seller`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ucapp`;



CREATE TABLE `pw_ucapp` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `siteurl` varchar(50) NOT NULL DEFAULT '',
  `secretkey` varchar(40) NOT NULL DEFAULT '',
  `interface` varchar(30) NOT NULL DEFAULT '',
  `uc` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ucnotify`;



CREATE TABLE `pw_ucnotify` (
  `nid` mediumint(8) NOT NULL AUTO_INCREMENT,
  `action` varchar(20) NOT NULL DEFAULT '',
  `param` text NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `complete` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `priority` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_ucsyncredit`;



CREATE TABLE `pw_ucsyncredit` (
  `uid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_user_career`;



CREATE TABLE `pw_user_career` (
  `careerid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `companyid` int(11) unsigned NOT NULL DEFAULT '0',
  `starttime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`careerid`),
  KEY `idx_uid_companyid` (`uid`,`companyid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_user_education`;



CREATE TABLE `pw_user_education` (
  `educationid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `schoolid` int(11) unsigned NOT NULL DEFAULT '0',
  `educationlevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `starttime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`educationid`),
  KEY `idx_uid_schoolid` (`uid`,`schoolid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_userapp`;



CREATE TABLE `pw_userapp` (
  `uid` int(10) unsigned NOT NULL,
  `appid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `appname` varchar(20) NOT NULL DEFAULT '',
  `appinfo` text NOT NULL,
  `appevent` text NOT NULL,
  PRIMARY KEY (`uid`,`appid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_userbinding`;



CREATE TABLE `pw_userbinding` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `password` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`,`uid`),
  UNIQUE KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_usercache`;



CREATE TABLE `pw_usercache` (
  `uid` int(10) unsigned NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT '',
  `typeid` int(10) unsigned NOT NULL DEFAULT '0',
  `expire` int(10) unsigned NOT NULL DEFAULT '0',
  `num` smallint(6) unsigned NOT NULL DEFAULT '0',
  `value` text NOT NULL,
  PRIMARY KEY (`uid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



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',
  `ifdefault` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`gid`),
  KEY `idx_gptype` (`gptype`),
  KEY `idx_grouppost` (`grouppost`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_usertool`;



CREATE TABLE `pw_usertool` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `toolid` smallint(6) NOT NULL DEFAULT '0',
  `nums` smallint(6) NOT NULL DEFAULT '0',
  `sellnums` smallint(6) NOT NULL DEFAULT '0',
  `sellprice` varchar(255) NOT NULL DEFAULT '',
  `sellstatus` tinyint(3) unsigned NOT NULL DEFAULT '1',
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_voter`;



CREATE TABLE `pw_voter` (
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `vote` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `idx_tid` (`tid`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_wappush`;



CREATE TABLE `pw_wappush` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(200) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `typeid` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_wappushtype`;



CREATE TABLE `pw_wappushtype` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `sort` smallint(6) unsigned NOT NULL DEFAULT '0',
  `typename` varchar(50) NOT NULL DEFAULT '',
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_bind`;



CREATE TABLE `pw_weibo_bind` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `weibotype` varchar(20) NOT NULL,
  `info` text NOT NULL,
  UNIQUE KEY `uid_weibotype` (`uid`,`weibotype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_cmrelations`;



CREATE TABLE `pw_weibo_cmrelations` (
  `cid` int(10) unsigned NOT NULL,
  `uid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`cid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_cnrelations`;



CREATE TABLE `pw_weibo_cnrelations` (
  `cyid` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cyid`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_comment`;



CREATE TABLE `pw_weibo_comment` (
  `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  `content` varchar(250) NOT NULL DEFAULT '',
  `extra` text NOT NULL,
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`),
  KEY `idx_mid_postdate` (`mid`,`postdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_content`;



CREATE TABLE `pw_weibo_content` (
  `mid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(15) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `extra` text NOT NULL,
  `contenttype` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `objectid` int(10) unsigned NOT NULL DEFAULT '0',
  `replies` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `transmit` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`mid`),
  KEY `idx_uid_postdate` (`uid`,`postdate`),
  KEY `idx_type_objectid` (`type`,`objectid`),
  KEY `idx_postdate` (`postdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_login_session`;



CREATE TABLE `pw_weibo_login_session` (
  `sessionid` varchar(32) NOT NULL DEFAULT '',
  `expire` int(10) unsigned NOT NULL DEFAULT '0',
  `sessiondata` text NOT NULL,
  PRIMARY KEY (`sessionid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_login_user`;



CREATE TABLE `pw_weibo_login_user` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `hasresetpwd` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0',
  `extra` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_referto`;



CREATE TABLE `pw_weibo_referto` (
  `uid` int(10) unsigned NOT NULL,
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_relations`;



CREATE TABLE `pw_weibo_relations` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  `authorid` int(10) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `idx_mid` (`mid`),
  KEY `idx_uid_postdate` (`uid`,`postdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_topicattention`;



CREATE TABLE `pw_weibo_topicattention` (
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `topicid` int(10) unsigned NOT NULL DEFAULT '0',
  `crtime` int(10) unsigned NOT NULL DEFAULT '0',
  `lasttime` int(10) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `idx_userid_topicid` (`userid`,`topicid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_topicrelations`;



CREATE TABLE `pw_weibo_topicrelations` (
  `topicid` int(10) unsigned NOT NULL DEFAULT '0',
  `mid` int(10) unsigned NOT NULL DEFAULT '0',
  `crtime` int(10) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `idx_topicid_mid` (`topicid`,`mid`),
  KEY `idx_mid` (`mid`),
  KEY `idx_crtime` (`crtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_weibo_topics`;



CREATE TABLE `pw_weibo_topics` (
  `topicid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topicname` varchar(255) NOT NULL DEFAULT '',
  `num` int(10) unsigned NOT NULL DEFAULT '0',
  `ifhot` tinyint(3) NOT NULL DEFAULT '1',
  `crtime` int(10) NOT NULL DEFAULT '0',
  `lasttime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`topicid`),
  UNIQUE KEY `idx_topicname` (`topicname`),
  KEY `idx_crtime_ifhot` (`crtime`,`ifhot`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_windcode`;



CREATE TABLE `pw_windcode` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(15) NOT NULL DEFAULT '',
  `icon` varchar(30) NOT NULL DEFAULT '',
  `pattern` varchar(30) NOT NULL DEFAULT '',
  `replacement` text NOT NULL,
  `param` tinyint(3) NOT NULL DEFAULT '0',
  `ifopen` tinyint(3) NOT NULL DEFAULT '0',
  `title` varchar(30) NOT NULL DEFAULT '',
  `descrip` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_wordfb`;



CREATE TABLE `pw_wordfb` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `word` varchar(100) NOT NULL DEFAULT '',
  `wordreplace` varchar(100) NOT NULL DEFAULT '',
  `type` tinyint(3) NOT NULL DEFAULT '0',
  `wordtime` int(10) unsigned NOT NULL DEFAULT '0',
  `custom` tinyint(3) NOT NULL DEFAULT '0',
  `classid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_write_smiles`;



CREATE TABLE `pw_write_smiles` (
  `smileid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `typeid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `vieworder` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `path` varchar(20) NOT NULL DEFAULT '',
  `name` varchar(20) NOT NULL DEFAULT '',
  `tag` varchar(30) NOT NULL DEFAULT '',
  `desciption` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`smileid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `pw_yun_setting`;



CREATE TABLE `pw_yun_setting` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `setting` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_abord_apply`;



CREATE TABLE `school_abord_apply` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `idno` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `mobile` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `im` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_lang` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `minzoku` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `gakureki` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ima_school` varchar(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ima_sub` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ima_gra` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `email` varchar(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `pwd` varchar(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `j_lang` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `e_lang1` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `e_lang2` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `e_lang3` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `e_lang4` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `e_lang5` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `o_lang` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `nopass` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `nopass_country` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `aim_lv` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  `aim_area` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  `aim_school` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `aim_sub` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `mon` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `syomei` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
  `gk_college1` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `college1` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `gk_college1_kikan` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `gk_college2` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `college2` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `gk_college2_kikan` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `hi_school1` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `hi_school_kikan1` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_school` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_school_kikan` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `p_school` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `p_school_kikan` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `f_name` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `f_work` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `f_job` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_name` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_work` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_job` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `jyusyo` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  `postcode` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `memo` text COLLATE utf8_bin NOT NULL,
  `ip` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `appdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pinggu` text COLLATE utf8_bin NOT NULL,
  `pinggudate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pinggustate` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idno` (`idno`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `school_abord_teacher`;



CREATE TABLE `school_abord_teacher` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `schoolname` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `cname` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `jname` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `email` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `site` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `jmobile` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `cmobile` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `addr` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
  `fax` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `zhiwu` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `qq` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `msn` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `skpye` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `adddate` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `school_action_mb`;



CREATE TABLE `school_action_mb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `actionname` varchar(50) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `name` varchar(20) NOT NULL,
  `memo` text NOT NULL,
  `state` int(1) NOT NULL,
  `dateline` date NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `im` varchar(60) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_app_teachers`;



CREATE TABLE `school_app_teachers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `position` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `number` varchar(20) DEFAULT NULL,
  `height` varchar(20) DEFAULT NULL,
  `weight` varchar(20) DEFAULT NULL,
  `sex` varchar(20) DEFAULT NULL,
  `birthday` varchar(20) DEFAULT NULL,
  `birth` varchar(20) DEFAULT NULL,
  `polity` varchar(20) DEFAULT NULL,
  `school` varchar(20) DEFAULT NULL,
  `speciality` varchar(20) DEFAULT NULL,
  `degree` varchar(20) DEFAULT NULL,
  `byrq` varchar(20) DEFAULT NULL,
  `wy` varchar(20) DEFAULT NULL,
  `sj` varchar(20) DEFAULT NULL,
  `treatment` varchar(20) DEFAULT NULL,
  `adept` varchar(20) DEFAULT NULL,
  `intrest` varchar(20) DEFAULT NULL,
  `direction` varchar(20) DEFAULT NULL,
  `other` varchar(20) DEFAULT NULL,
  `tel` varchar(20) DEFAULT NULL,
  `email` varchar(20) DEFAULT NULL,
  `address` varchar(20) DEFAULT NULL,
  `a1begin` varchar(20) DEFAULT NULL,
  `a1end` varchar(20) DEFAULT NULL,
  `a1school` varchar(20) DEFAULT NULL,
  `a1degree` varchar(20) DEFAULT NULL,
  `a2begin` varchar(20) DEFAULT NULL,
  `a2end` varchar(20) DEFAULT NULL,
  `a2school` varchar(202) DEFAULT NULL,
  `a2degree` varchar(20) DEFAULT NULL,
  `b1begin` varchar(20) DEFAULT NULL,
  `b1end` varchar(20) DEFAULT NULL,
  `b1com` varchar(20) DEFAULT NULL,
  `b1position` varchar(20) DEFAULT NULL,
  `b1treatment` varchar(20) DEFAULT NULL,
  `b2begin` varchar(20) DEFAULT NULL,
  `b2end` varchar(20) DEFAULT NULL,
  `b2com` varchar(20) DEFAULT NULL,
  `b2position` varchar(20) DEFAULT NULL,
  `b2treatment` varchar(20) DEFAULT NULL,
  `b3begin` varchar(20) DEFAULT NULL,
  `b3end` varchar(20) DEFAULT NULL,
  `b3com` varchar(20) DEFAULT NULL,
  `b3position` varchar(20) DEFAULT NULL,
  `b3treatment` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_bankinfo`;



CREATE TABLE `school_bankinfo` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `schoolarea` varchar(20) NOT NULL DEFAULT '',
  `num` varchar(10) NOT NULL DEFAULT '',
  `type` varchar(10) NOT NULL DEFAULT '',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `stuff` varchar(10) NOT NULL DEFAULT '',
  `bank` varchar(20) NOT NULL DEFAULT '',
  `memo` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_birthday`;



CREATE TABLE `school_birthday` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `stuff` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `num` int(10) NOT NULL DEFAULT '0',
  `msg` text CHARACTER SET utf8 NOT NULL,
  `time` varchar(20) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `school_cj`;



CREATE TABLE `school_cj` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL DEFAULT '0000-00-00',
  `c500` tinyint(1) NOT NULL DEFAULT '0',
  `c300` tinyint(1) NOT NULL DEFAULT '0',
  `c100` tinyint(2) NOT NULL DEFAULT '0',
  `c50` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



DROP TABLE IF EXISTS `school_cj_info`;



CREATE TABLE `school_cj_info` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `cx` varchar(5) NOT NULL DEFAULT '',
  `code` varchar(30) NOT NULL DEFAULT '',
  `name` varchar(10) NOT NULL DEFAULT '',
  `mobile` varchar(20) NOT NULL DEFAULT '',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `dateline` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_faq`;



CREATE TABLE `school_faq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat0` varchar(20) NOT NULL,
  `cat` varchar(20) NOT NULL,
  `sort` int(3) NOT NULL,
  `f` text NOT NULL,
  `a` text NOT NULL,
  `q` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_lession`;



CREATE TABLE `school_lession` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `area` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `classname` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `teacher` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `state` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `sdate` date NOT NULL DEFAULT '0000-00-00',
  `edate` date NOT NULL DEFAULT '0000-00-00',
  `memo` longtext CHARACTER SET utf8 NOT NULL,
  `name` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `content` text CHARACTER SET utf8 NOT NULL,
  `shangke` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `stuff` varchar(20) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `school_reportday`;



CREATE TABLE `school_reportday` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `stuff` varchar(20) NOT NULL,
  `ftel` varchar(5) NOT NULL,
  `fnet` varchar(5) NOT NULL,
  `fschool` varchar(5) NOT NULL,
  `schoolarea` varchar(20) NOT NULL,
  `memo` text NOT NULL,
  `dateline` datetime NOT NULL,
  `adddate` date NOT NULL,
  `state` varchar(10) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `open` int(1) NOT NULL,
  `replay` varchar(5) NOT NULL,
  `plan` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_resms`;



CREATE TABLE `school_resms` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `SendNum` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `RecvNum` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `RecvTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `RecvMsg` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `school_sakura`;



CREATE TABLE `school_sakura` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `item` varchar(50) NOT NULL,
  `name` varchar(20) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `memo` text NOT NULL,
  `dateline` datetime NOT NULL,
  `photo` varchar(100) NOT NULL,
  `votes` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_sakura_vote`;



CREATE TABLE `school_sakura_vote` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `dateline` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_scholarship`;



CREATE TABLE `school_scholarship` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `mobile` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `idno` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `zkz` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
  `result` text COLLATE utf8_bin NOT NULL,
  `classtype` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `dateline` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `memo` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `school_sendsms`;



CREATE TABLE `school_sendsms` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `msg` varchar(200) NOT NULL DEFAULT '',
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_stuff_income`;



CREATE TABLE `school_stuff_income` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `agentname` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `enddate` date NOT NULL DEFAULT '0000-00-00',
  `income` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `paydate` date NOT NULL DEFAULT '0000-00-00',
  `paymethod` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `stuff` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `school_stuff_memo`;



CREATE TABLE `school_stuff_memo` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `fid` int(10) NOT NULL DEFAULT '0',
  `tostuff` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `msg` text COLLATE utf8_bin NOT NULL,
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `state` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `stuff` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  `sdate` date NOT NULL DEFAULT '0000-00-00',
  `edate` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `school_stuff_memo_replay`;



CREATE TABLE `school_stuff_memo_replay` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `fid` int(10) NOT NULL DEFAULT '0',
  `tostuff` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `msg` text COLLATE utf8_bin NOT NULL,
  `dateline` date NOT NULL DEFAULT '0000-00-00',
  `state` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `stuff` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
  `sdate` date NOT NULL DEFAULT '0000-00-00',
  `edate` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



DROP TABLE IF EXISTS `school_test_error`;



CREATE TABLE `school_test_error` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `creatdate` int(10) NOT NULL,
  `uid` int(10) NOT NULL,
  `cat` varchar(20) NOT NULL,
  `tid` int(10) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `userok` varchar(5) NOT NULL,
  `istitle` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_test_msg`;



CREATE TABLE `school_test_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat` varchar(30) NOT NULL,
  `fid` int(5) NOT NULL,
  `content` text NOT NULL,
  `mp3` varchar(200) NOT NULL,
  `a` text NOT NULL,
  `b` text NOT NULL,
  `c` text NOT NULL,
  `d` text NOT NULL,
  `ok` varchar(5) NOT NULL,
  `stuff` varchar(20) NOT NULL,
  `dateline` date NOT NULL,
  `memo` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_test_statistics`;



CREATE TABLE `school_test_statistics` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `creatdate` int(10) NOT NULL,
  `uid` int(10) NOT NULL,
  `cat` varchar(20) NOT NULL,
  `tid` int(5) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `userok` varchar(5) NOT NULL,
  `istitle` int(5) NOT NULL,
  `one` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_test_userdo`;



CREATE TABLE `school_test_userdo` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `creatdate` int(10) NOT NULL,
  `uid` int(20) NOT NULL,
  `cat` varchar(20) NOT NULL,
  `tid` int(5) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `userok` varchar(5) NOT NULL,
  `istitle` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `school_test_userdo_bak`;



CREATE TABLE `school_test_userdo_bak` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `creatdate` date NOT NULL,
  `uid` int(20) NOT NULL,
  `cat` varchar(20) NOT NULL,
  `tid` int(5) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `userok` varchar(5) NOT NULL,
  `istitle` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS `vote`;



CREATE TABLE `vote` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `no` int(10) NOT NULL,
  `votes` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;