DROP TABLE IF EXISTS `poc_ads`;

CREATE TABLE `poc_ads` (
  `adid` int(8) unsigned NOT NULL auto_increment,
  `adspid` int(8) unsigned NOT NULL default '0',
  `name` varchar(30) NOT NULL,
  `description` varchar(255) NOT NULL,
  `available` tinyint(1) NOT NULL default '0',
  `htmlcode` mediumtext NOT NULL,
  `parameters` mediumtext NOT NULL,
  `starttime` int(10) unsigned NOT NULL default '0',
  `endtime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`adid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_ads_place`;

CREATE TABLE `poc_ads_place` (
  `adspid` int(8) unsigned NOT NULL auto_increment,
  `identifier` varchar(50) NOT NULL,
  `name` varchar(30) NOT NULL,
  `description` varchar(255) NOT NULL,
  `available` tinyint(1) NOT NULL default '0',
  `width` smallint(6) unsigned NOT NULL default '0',
  `height` smallint(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (`adspid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_announce`;

CREATE TABLE `poc_announce` (
  `aid` smallint(6) unsigned NOT NULL auto_increment,
  `vieworder` smallint(6) NOT NULL default '0',
  `author` varchar(15) NOT NULL default '',
  `startdate` varchar(15) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `content` mediumtext NOT NULL,
  PRIMARY KEY  (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_channel`;

CREATE TABLE `poc_channel` (
  `cid` int(8) NOT NULL auto_increment,
  `unionid` int(2) NOT NULL default '0',
  `cname` varchar(30) NOT NULL default '',
  `hotcount` int(10) NOT NULL default '0',
  `vouch` tinyint(1) NOT NULL default '0',
  `upid` int(8) unsigned NOT NULL default '0',
  `description` mediumtext NOT NULL,
  `pic` varchar(255) NOT NULL default '',
  `path` varchar(255) NOT NULL default '',
  `template` varchar(255) NOT NULL default '',
  `orderby` int(8) unsigned NOT NULL default '0',
  `htmldir` tinyint(1) NOT NULL default '0',
  `htmlname` tinyint(1) NOT NULL default '0',
  `color` varchar(7) NOT NULL default '',
  `hidden` tinyint(1) NOT NULL default '0',
  `accept` tinyint(4) NOT NULL default '0',
  `endchild` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_collections`;

CREATE TABLE `poc_collections` (
  `uid` int(8) unsigned NOT NULL,
  `vids` mediumtext,
  `lids` mediumtext,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_lables`;

CREATE TABLE `poc_lables` (
  `lid` int(8) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL default '',
  `option` mediumtext NOT NULL,
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_links`;

CREATE TABLE `poc_links` (
  `linkid` int(8) NOT NULL auto_increment,
  `linkurl` varchar(255) NOT NULL default '',
  `linkimg` varchar(255) NOT NULL default '',
  `linkname` varchar(30) NOT NULL default '',
  `linktext` varchar(255) NOT NULL default '',
  `linksort` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`linkid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_msg`;

CREATE TABLE `poc_msg` (
  `mid` int(8) NOT NULL auto_increment,
  `fromuid` int(8) unsigned NOT NULL default '0',
  `fromname` varchar(20) NOT NULL default '',
  `toid` int(8) unsigned NOT NULL default '0',
  `sendtime` int(10) unsigned NOT NULL default '0',
  `isread` tinytext NOT NULL,
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  PRIMARY KEY  (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_playlist`;

CREATE TABLE `poc_playlist` (
  `lid` int(8) unsigned NOT NULL auto_increment,
  `cid` int(8) unsigned NOT NULL default '0',
  `title` varchar(200) NOT NULL,
  `uid` int(8) NOT NULL default '-1',
  `vid` text NOT NULL,
  `pic` varchar(200) NOT NULL,
  `description` mediumtext NOT NULL,
  `createtime` int(10) NOT NULL default '0',
  `hotcount` int(10) NOT NULL default '0',
  `vouch` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_setting`;

CREATE TABLE `poc_setting` (
  `varname` varchar(30) NOT NULL default '',
  `varvalue` varchar(100) NOT NULL default '',
  UNIQUE KEY `varname` (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_special`;

CREATE TABLE `poc_special` (
  `sid` int(8) NOT NULL auto_increment,
  `sname` varchar(30) NOT NULL default '',
  `hotcount` int(8) NOT NULL default '0',
  `vouch` tinyint(1) NOT NULL default '0',
  `uid` int(8) NOT NULL default '-1',
  `ordbyspecial` mediumtext NOT NULL,
  `pic` varchar(255) NOT NULL default '',
  `description` mediumtext NOT NULL,
  `template` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_tag`;

CREATE TABLE `poc_tag` (
  `tagid` int(8) NOT NULL auto_increment,
  `tagname` varchar(30) NOT NULL default '',
  `taghotcount` int(8) NOT NULL default '0',
  `createtime` int(10) NOT NULL default '0',
  PRIMARY KEY  (`tagid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_trade_log`;

CREATE TABLE `poc_trade_log` (
  `id` int(3) unsigned NOT NULL auto_increment,
  `tid` varchar(32) NOT NULL default '',
  `time` int(10) NOT NULL default '0',
  `type` enum('upload','trade') NOT NULL default 'upload',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_trade_video`;

CREATE TABLE `poc_trade_video` (
  `id` int(3) unsigned NOT NULL auto_increment,
  `tid` varchar(32) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `pic` varchar(255) NOT NULL default '',
  `tags` mediumtext NOT NULL,
  `channel` int(2) NOT NULL default '0',
  `time` int(10) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_user`;

CREATE TABLE `poc_user` (
  `uid` int(8) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `password` varchar(64) NOT NULL default '',
  `adminid` tinyint(1) NOT NULL default '0',
  `pic` varchar(255) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `createtime` int(10) NOT NULL default '0',
  `playcount` int(10) NOT NULL default '0',
  `videocount` int(10) NOT NULL default '0',
  `sign` mediumtext NOT NULL,
  `showcount` int(10) NOT NULL default '0',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_userchannel`;

CREATE TABLE `poc_userchannel` (
  `uid` int(8) unsigned NOT NULL default '0',
  `cid` int(8) unsigned NOT NULL default '0',
  KEY `uid` (`uid`,`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_usercoluser`;

CREATE TABLE `poc_usercoluser` (
  `uid` int(8) unsigned NOT NULL default '0',
  `coluid` int(8) unsigned NOT NULL default '0',
  KEY `uid` (`uid`,`coluid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_usercolvideo`;

CREATE TABLE `poc_usercolvideo` (
  `uid` int(8) unsigned NOT NULL default '0',
  `vid` int(8) unsigned NOT NULL default '0',
  KEY `uid` (`uid`,`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_usersession`;

CREATE TABLE `poc_usersession` (
  `sm` varchar(10) NOT NULL default '',
  `uid` int(10) NOT NULL default '0',
  `authcode` varchar(255) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `adminid` tinyint(1) NOT NULL default '0',
  `lastactivity` int(10) NOT NULL default '0',
  `seccode` varchar(6) NOT NULL default '',
  PRIMARY KEY  (`sm`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_video`;

CREATE TABLE `poc_video` (
  `vid` int(8) NOT NULL auto_increment,
  `uid` int(8) unsigned NOT NULL default '0',
  `cid` int(8) unsigned NOT NULL default '0',
  `pid` tinyint(2) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `ccvid` varchar(255) NOT NULL default '',
  `hotcount` int(8) NOT NULL default '0',
  `topcount` int(8) NOT NULL default '0',
  `createtime` int(10) NOT NULL default '0',
  `autoplay` tinyint(1) NOT NULL default '0',
  `vouch` int(2) NOT NULL default '0',
  `description` mediumtext NOT NULL,
  `timelength` varchar(100) NOT NULL default '',
  `comments` int(8) NOT NULL default '0',
  `filelink` varchar(255) NOT NULL default '',
  `pic` varchar(255) NOT NULL default '',
  `pic2` varchar(255) NOT NULL default '',
  `deltype` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_videocomment`;

CREATE TABLE `poc_videocomment` (
  `vcid` int(8) unsigned NOT NULL auto_increment,
  `uid` int(8) unsigned NOT NULL default '0',
  `vid` int(8) unsigned NOT NULL default '0',
  `createtime` int(10) unsigned NOT NULL default '0',
  `content` text NOT NULL,
  PRIMARY KEY  (`vcid`),
  KEY `uid` (`uid`,`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_videospecial`;

CREATE TABLE `poc_videospecial` (
  `vid` int(8) NOT NULL default '0',
  `sid` int(8) NOT NULL default '0',
  KEY `vid` (`vid`,`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_videotag`;

CREATE TABLE `poc_videotag` (
  `vid` int(8) NOT NULL default '0',
  `tid` int(8) NOT NULL default '0',
  KEY `vid` (`vid`,`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `poc_videotop`;

CREATE TABLE `poc_videotop` (
  `vid` int(8) unsigned NOT NULL default '0',
  `uids` text NOT NULL,
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_actions`;

CREATE TABLE `pw_actions` (
  `id` smallint(6) unsigned NOT NULL auto_increment,
  `images` char(15) NOT NULL default '',
  `name` char(15) NOT NULL default '',
  `descrip` char(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_activity`;

CREATE TABLE `pw_activity` (
  `tid` mediumint(8) unsigned NOT NULL default '0',
  `subject` varchar(80) NOT NULL default '',
  `admin` mediumint(8) 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(1) NOT NULL default '0',
  `costs` int(10) NOT NULL default '0',
  `deadline` int(10) NOT NULL default '0',
  PRIMARY KEY  (`tid`),
  KEY `admin` (`admin`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_actmember`;

CREATE TABLE `pw_actmember` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `actid` mediumint(8) NOT NULL default '0',
  `winduid` mediumint(8) NOT NULL default '0',
  `state` tinyint(1) 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 `actid` (`actid`),
  KEY `winduid` (`winduid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_administrators`;

CREATE TABLE `pw_administrators` (
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `username` varchar(15) NOT NULL default '',
  `groupid` tinyint(3) NOT NULL default '0',
  `groups` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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 `type` (`type`),
  KEY `username1` (`username1`),
  KEY `username2` (`username2`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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=gbk;

DROP TABLE IF EXISTS `pw_advert`;

CREATE TABLE `pw_advert` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(4) NOT NULL default '0',
  `targets` varchar(50) NOT NULL default '',
  `varname` varchar(20) NOT NULL default '1',
  `state` tinyint(1) NOT NULL default '0',
  `vieworder` tinyint(4) NOT NULL default '0',
  `title` varchar(255) default NULL,
  `config` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `type` (`type`),
  KEY `vieworder` (`vieworder`),
  KEY `state` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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',
  `ffid` smallint(6) 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 `ffid` (`ffid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_argument`;

CREATE TABLE `pw_argument` (
  `tid` smallint(6) unsigned NOT NULL auto_increment,
  `tpcid` smallint(6) NOT NULL default '0',
  `gid` smallint(6) unsigned NOT NULL default '0',
  `author` varchar(20) NOT NULL default '',
  `authorid` smallint(6) unsigned NOT NULL default '0',
  `postdate` int(10) unsigned NOT NULL default '0',
  `lastpost` int(10) NOT NULL default '0',
  `subject` varchar(50) NOT NULL default '',
  `content` text NOT NULL,
  PRIMARY KEY  (`tid`),
  KEY `gid` (`gid`,`tpcid`),
  KEY `authorid` (`authorid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_attachs`;

CREATE TABLE `pw_attachs` (
  `aid` mediumint(8) unsigned NOT NULL auto_increment,
  `fid` smallint(6) unsigned NOT NULL default '0',
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `tid` mediumint(8) unsigned NOT NULL default '0',
  `pid` int(10) unsigned NOT NULL default '0',
  `name` char(80) NOT NULL default '',
  `type` char(30) NOT NULL default '',
  `size` int(10) unsigned NOT NULL default '0',
  `attachurl` char(80) NOT NULL default '0',
  `hits` mediumint(8) unsigned NOT NULL default '0',
  `needrvrc` smallint(6) unsigned NOT NULL default '0',
  `uploadtime` int(10) NOT NULL default '0',
  `descrip` char(100) NOT NULL default '',
  `ifthumb` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`aid`),
  KEY `fid` (`fid`),
  KEY `uid` (`uid`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_banuser`;

CREATE TABLE `pw_banuser` (
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  `startdate` int(10) NOT NULL default '0',
  `days` int(4) NOT NULL default '0',
  `admin` char(15) NOT NULL default '',
  `reason` char(80) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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` smallint(6) 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(2) unsigned NOT NULL default '0',
  `birthcontrol` int(10) unsigned NOT NULL default '0',
  `birthman` text NOT NULL,
  `plantime` int(10) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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=gbk;

DROP TABLE IF EXISTS `pw_clientorder`;

CREATE TABLE `pw_clientorder` (
  `id` int(11) NOT NULL auto_increment,
  `order_no` varchar(30) NOT NULL default '',
  `uid` mediumint(8) NOT NULL default '0',
  `subject` varchar(20) NOT NULL default '',
  `body` varchar(100) NOT NULL default '',
  `price` smallint(6) NOT NULL default '0',
  `payemail` varchar(60) NOT NULL default '',
  `number` smallint(6) NOT NULL default '0',
  `date` int(10) NOT NULL default '0',
  `state` tinyint(1) NOT NULL default '0',
  `descrip` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`),
  KEY `order_no` (`order_no`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_cmembers`;

CREATE TABLE `pw_cmembers` (
  `id` mediumint(9) NOT NULL auto_increment,
  `uid` mediumint(9) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  `realname` varchar(20) NOT NULL default '',
  `ifadmin` tinyint(1) NOT NULL default '0',
  `gender` tinyint(1) 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 '',
  `honor` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `colonyid` (`colonyid`,`uid`,`username`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_cnalbum`;

CREATE TABLE `pw_cnalbum` (
  `aid` mediumint(8) NOT NULL auto_increment,
  `aname` varchar(50) NOT NULL default '',
  `aintro` varchar(200) NOT NULL default '',
  `atype` smallint(4) NOT NULL default '0',
  `cyid` mediumint(8) NOT NULL default '0',
  `uid` mediumint(8) NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `photonum` smallint(6) NOT NULL default '0',
  `lastphoto` varchar(100) NOT NULL default '',
  `crtime` int(10) NOT NULL default '0',
  PRIMARY KEY  (`aid`),
  KEY `cyid` (`cyid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_cnclass`;

CREATE TABLE `pw_cnclass` (
  `cid` smallint(6) unsigned NOT NULL auto_increment,
  `cname` char(20) NOT NULL default '',
  `cnsum` int(10) NOT NULL default '0',
  PRIMARY KEY  (`cid`),
  KEY `cname` (`cname`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_cnphoto`;

CREATE TABLE `pw_cnphoto` (
  `pid` smallint(8) NOT NULL auto_increment,
  `aid` smallint(8) NOT NULL default '0',
  `pname` varchar(50) NOT NULL default '',
  `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',
  PRIMARY KEY  (`pid`),
  KEY `aid` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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(1) NOT NULL default '0',
  `ifopen` tinyint(1) NOT NULL default '0',
  `albumopen` tinyint(1) NOT NULL default '0',
  `cmoney` int(10) NOT NULL default '0',
  `cnimg` varchar(100) NOT NULL default '',
  `createtime` int(10) NOT NULL default '0',
  `intomoney` smallint(6) NOT NULL default '0',
  `annouce` varchar(255) NOT NULL default '',
  `albumnum` smallint(6) NOT NULL default '0',
  `annoucesee` smallint(6) NOT NULL default '0',
  `descrip` varchar(255) NOT NULL default '',
  `level` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `cname` (`cname`),
  KEY `admin` (`admin`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_config`;

CREATE TABLE `pw_config` (
  `db_name` varchar(30) NOT NULL default '',
  `db_value` text NOT NULL,
  `decrip` text NOT NULL,
  PRIMARY KEY  (`db_name`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_credits`;

CREATE TABLE `pw_credits` (
  `cid` tinyint(3) unsigned NOT NULL auto_increment,
  `name` char(30) NOT NULL default '',
  `unit` char(30) NOT NULL default '',
  `description` char(255) NOT NULL default '',
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_customfield`;

CREATE TABLE `pw_customfield` (
  `id` smallint(6) NOT NULL auto_increment,
  `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,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_debateclass`;

CREATE TABLE `pw_debateclass` (
  `cid` smallint(6) unsigned NOT NULL auto_increment,
  `cname` char(20) NOT NULL,
  PRIMARY KEY  (`cid`),
  KEY `cname` (`cname`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_debateinfo`;

CREATE TABLE `pw_debateinfo` (
  `uid` int(10) NOT NULL,
  `author` varchar(20) NOT NULL,
  `posts` int(6) NOT NULL,
  `replys` int(6) NOT NULL,
  PRIMARY KEY  (`uid`),
  KEY `posts` (`posts`),
  KEY `replys` (`replys`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_debatereplys`;

CREATE TABLE `pw_debatereplys` (
  `aid` int(10) unsigned NOT NULL auto_increment,
  `did` int(10) unsigned NOT NULL default '0',
  `authorid` int(10) unsigned NOT NULL default '0',
  `author` char(15) NOT NULL,
  `debatetype` enum('0','1','2','3') default '0',
  `parentid` int(10) unsigned NOT NULL default '0',
  `child` int(10) unsigned NOT NULL default '0',
  `vote` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL,
  `content` mediumtext NOT NULL,
  `dateline` int(10) NOT NULL default '0',
  `ip` varchar(40) NOT NULL,
  `isvisible` enum('0','1') NOT NULL default '0',
  `islock` enum('0','1') NOT NULL default '0',
  `isdigest` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_debatethreads`;

CREATE TABLE `pw_debatethreads` (
  `did` int(10) unsigned NOT NULL auto_increment,
  `sortid` tinyint(2) NOT NULL default '0',
  `authorid` int(10) unsigned NOT NULL,
  `author` char(10) NOT NULL,
  `judgment` char(10) NOT NULL,
  `title` varchar(255) NOT NULL,
  `obtitle` varchar(255) NOT NULL,
  `retitle` varchar(255) NOT NULL,
  `content` mediumtext NOT NULL,
  `dateline` int(10) unsigned NOT NULL default '0',
  `endtime` int(10) unsigned NOT NULL default '0',
  `obvote` int(10) unsigned NOT NULL default '0',
  `revote` int(10) unsigned NOT NULL default '0',
  `voteuid` mediumtext NOT NULL,
  `views` int(10) unsigned NOT NULL default '0',
  `ip` varchar(40) NOT NULL,
  `isvisible` tinyint(1) NOT NULL default '0',
  `digest` tinyint(1) NOT NULL,
  `judg` char(8) NOT NULL,
  `judgcontent` varchar(255) NOT NULL,
  PRIMARY KEY  (`did`),
  KEY `dateline` (`dateline`),
  KEY `isvisible` (`isvisible`,`sortid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_draft`;

CREATE TABLE `pw_draft` (
  `did` mediumint(8) unsigned NOT NULL auto_increment,
  `uid` mediumint(8) NOT NULL default '0',
  `content` text NOT NULL,
  PRIMARY KEY  (`did`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_extragroups`;

CREATE TABLE `pw_extragroups` (
  `uid` mediumint(9) NOT NULL default '0',
  `gid` smallint(6) NOT NULL default '0',
  `togid` smallint(6) NOT NULL default '0',
  `startdate` int(10) NOT NULL default '0',
  `days` smallint(6) NOT NULL default '0',
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_favors`;

CREATE TABLE `pw_favors` (
  `uid` mediumint(8) unsigned NOT NULL default '1',
  `tids` text NOT NULL,
  `type` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_forumdata`;

CREATE TABLE `pw_forumdata` (
  `fid` smallint(6) unsigned NOT NULL auto_increment,
  `tpost` mediumint(8) unsigned NOT NULL default '0',
  `topic` mediumint(8) unsigned NOT NULL default '0',
  `article` mediumint(8) 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',
  `lastpost` char(135) NOT NULL default '',
  PRIMARY KEY  (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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 `type` (`type`),
  KEY `username1` (`username1`),
  KEY `username2` (`username2`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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') NOT NULL default 'forum',
  `logo` char(100) NOT NULL default '',
  `name` char(50) NOT NULL default '',
  `descrip` char(255) NOT NULL default '',
  `dirname` char(15) NOT NULL default '',
  `keywords` varchar(50) NOT NULL default '',
  `vieworder` tinyint(3) NOT NULL default '0',
  `forumadmin` char(255) NOT NULL default '',
  `fupadmin` char(255) NOT NULL default '',
  `style` char(12) NOT NULL default '',
  `across` tinyint(4) 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',
  `allowreward` tinyint(1) NOT NULL default '0',
  `copyctrl` tinyint(1) NOT NULL default '0',
  `allowencode` tinyint(1) NOT NULL default '1',
  `password` char(32) NOT NULL default '',
  `viewsub` tinyint(1) NOT NULL default '0',
  `allowvisit` char(120) NOT NULL default '',
  `allowread` char(120) NOT NULL default '',
  `allowpost` char(120) NOT NULL default '',
  `allowrp` char(120) NOT NULL default '',
  `allowdownload` char(120) NOT NULL default '',
  `allowupload` char(120) 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` char(255) NOT NULL default '',
  `cms` tinyint(1) NOT NULL default '0',
  `ifhide` tinyint(1) NOT NULL default '1',
  `showsub` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`fid`),
  KEY `fup` (`fup`),
  KEY `type` (`ifsub`,`vieworder`,`fup`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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,
  PRIMARY KEY  (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_friends`;

CREATE TABLE `pw_friends` (
  `uid` mediumint(8) NOT NULL default '0',
  `friendid` mediumint(8) NOT NULL default '0',
  `joindate` int(10) NOT NULL default '0',
  `descrip` varchar(255) NOT NULL default '',
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_hack`;

CREATE TABLE `pw_hack` (
  `hk_name` varchar(30) NOT NULL default '',
  `hk_value` text NOT NULL,
  `decrip` text NOT NULL,
  PRIMARY KEY  (`hk_name`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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(2) NOT NULL default '0',
  `fathers` varchar(100) NOT NULL default '',
  `ifchild` tinyint(1) NOT NULL default '0',
  `title` varchar(80) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `vieworder` tinyint(3) NOT NULL default '0',
  `ispw` tinyint(1) default '0',
  PRIMARY KEY  (`hid`),
  KEY `hup` (`hup`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_home`;

CREATE TABLE `pw_home` (
  `id` smallint(6) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `title` varchar(20) NOT NULL default '',
  `position` tinyint(3) NOT NULL default '0',
  `vieworder` tinyint(3) NOT NULL default '0',
  `upstep` smallint(6) NOT NULL default '0',
  `lastupdate` int(10) NOT NULL default '0',
  `ifopen` tinyint(1) NOT NULL default '0',
  `config` text NOT NULL,
  `cache` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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` mediumint(8) NOT NULL default '0',
  `receiver` varchar(20) NOT NULL default '',
  `createtime` int(10) NOT NULL default '0',
  `usetime` int(10) NOT NULL default '0',
  `ifused` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`),
  KEY `invcode` (`invcode`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_ipstates`;

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

DROP TABLE IF EXISTS `pw_medalinfo`;

CREATE TABLE `pw_medalinfo` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL default '',
  `intro` varchar(255) NOT NULL default '',
  `picurl` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_medalslogs`;

CREATE TABLE `pw_medalslogs` (
  `id` int(10) NOT NULL auto_increment,
  `awardee` varchar(40) NOT NULL default '',
  `awarder` varchar(40) NOT NULL default '',
  `awardtime` int(10) NOT NULL default '0',
  `timelimit` tinyint(2) NOT NULL default '0',
  `state` tinyint(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  `action` tinyint(1) NOT NULL default '0',
  `why` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_membercredit`;

CREATE TABLE `pw_membercredit` (
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `cid` tinyint(3) NOT NULL default '0',
  `value` mediumint(8) unsigned NOT NULL default '0',
  KEY `uid` (`uid`),
  KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_memberdata`;

CREATE TABLE `pw_memberdata` (
  `uid` mediumint(8) 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',
  `editor` tinyint(1) 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',
  `onlineip` char(30) NOT NULL default '',
  `starttime` int(10) unsigned NOT NULL default '0',
  `postcheck` char(16) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_memberinfo`;

CREATE TABLE `pw_memberinfo` (
  `uid` mediumint(8) unsigned NOT NULL default '1',
  `adsips` mediumtext NOT NULL,
  `credit` varchar(50) NOT NULL default '',
  `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,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_members`;

CREATE TABLE `pw_members` (
  `uid` mediumint(8) 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 '',
  `publicmail` tinyint(1) NOT NULL default '0',
  `groupid` tinyint(3) NOT NULL default '-1',
  `memberid` tinyint(3) NOT NULL default '0',
  `groups` varchar(255) NOT NULL default '',
  `icon` varchar(100) 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 '',
  `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',
  `receivemail` tinyint(1) NOT NULL default '0',
  `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',
  `signchange` tinyint(1) NOT NULL default '0',
  `newpm` tinyint(1) NOT NULL default '0',
  `newrp` tinyint(1) NOT NULL default '0',
  `banpm` text NOT NULL,
  `showsign` tinyint(1) unsigned NOT NULL default '1',
  `msggroups` varchar(255) NOT NULL default '',
  `medals` varchar(255) NOT NULL default '',
  `payemail` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`uid`),
  KEY `username` (`username`),
  KEY `groupid` (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_memo`;

CREATE TABLE `pw_memo` (
  `mid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(15) NOT NULL,
  `postdate` int(10) NOT NULL default '0',
  `content` text NOT NULL,
  `isuser` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`mid`),
  KEY `isuser` (`isuser`,`username`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_modules`;

CREATE TABLE `pw_modules` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(4) NOT NULL default '0',
  `targets` varchar(50) NOT NULL default '',
  `varname` varchar(20) NOT NULL default '',
  `state` tinyint(1) NOT NULL default '0',
  `vieworder` tinyint(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `config` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `type` (`type`),
  KEY `vieworder` (`vieworder`),
  KEY `state` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_msg`;

CREATE TABLE `pw_msg` (
  `mid` int(10) unsigned NOT NULL auto_increment,
  `touid` mediumint(8) unsigned NOT NULL default '0',
  `togroups` varchar(80) NOT NULL default '',
  `fromuid` mediumint(8) unsigned NOT NULL default '0',
  `username` varchar(15) NOT NULL default '',
  `type` enum('rebox','sebox','public') NOT NULL default 'rebox',
  `ifnew` tinyint(1) NOT NULL default '0',
  `title` varchar(130) NOT NULL default '',
  `mdate` int(10) unsigned NOT NULL default '0',
  `content` text NOT NULL,
  PRIMARY KEY  (`mid`),
  KEY `touid` (`touid`),
  KEY `fromuid` (`fromuid`,`mdate`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_nav`;

CREATE TABLE `pw_nav` (
  `nid` smallint(4) NOT NULL auto_increment,
  `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` char(10) NOT NULL default '',
  `target` tinyint(1) NOT NULL default '0',
  `view` smallint(4) NOT NULL default '0',
  PRIMARY KEY  (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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` char(30) NOT NULL default '',
  `fid` smallint(6) NOT NULL default '0',
  `tid` mediumint(8) NOT NULL default '0',
  `groupid` tinyint(3) NOT NULL default '0',
  `action` char(2) NOT NULL default '',
  `ifhide` tinyint(1) NOT NULL default '0',
  `uid` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`olid`),
  KEY `uid` (`uid`),
  KEY `ip` (`ip`)
) ENGINE=MEMORY DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_pidtmp`;

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

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(1) NOT NULL default '0',
  `ifopen` tinyint(1) NOT NULL default '0',
  `filename` varchar(80) NOT NULL default '',
  `config` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_polls`;

CREATE TABLE `pw_polls` (
  `tid` mediumint(8) unsigned NOT NULL,
  `voteopts` mediumtext NOT NULL,
  `state` tinyint(1) NOT NULL default '0',
  `modifiable` tinyint(1) NOT NULL default '0',
  `previewable` tinyint(1) NOT NULL default '0',
  `timelimit` int(3) NOT NULL default '0',
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_posts`;

CREATE TABLE `pw_posts` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `fid` smallint(6) unsigned NOT NULL default '0',
  `tid` mediumint(8) unsigned NOT NULL default '0',
  `aid` text NOT NULL,
  `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(1) 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(30) NOT NULL default '',
  `ifconvert` tinyint(1) NOT NULL default '1',
  `ifwordsfb` tinyint(1) NOT NULL default '1',
  `ifcheck` tinyint(1) NOT NULL default '0',
  `content` mediumtext NOT NULL,
  `ifmark` varchar(255) NOT NULL default '',
  `ifreward` tinyint(1) NOT NULL default '0',
  `ifshield` tinyint(1) unsigned NOT NULL default '0',
  `anonymous` tinyint(1) NOT NULL default '0',
  `ifhide` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`pid`),
  KEY `fid` (`fid`),
  KEY `postdate` (`postdate`),
  KEY `tid` (`tid`,`postdate`),
  KEY `authorid` (`authorid`),
  KEY `ifcheck` (`ifcheck`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_recycle`;

CREATE TABLE `pw_recycle` (
  `tid` int(10) 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 '',
  KEY `tid` (`tid`),
  KEY `fid` (`fid`),
  KEY `deltime` (`deltime`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_report`;

CREATE TABLE `pw_report` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tid` mediumint(8) unsigned NOT NULL default '0',
  `pid` int(10) unsigned NOT NULL default '0',
  `uid` mediumint(9) NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  `reason` char(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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 `schline` (`schline`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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(1) NOT NULL default '0',
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_sharelinks`;

CREATE TABLE `pw_sharelinks` (
  `sid` smallint(6) unsigned NOT NULL auto_increment,
  `threadorder` tinyint(3) NOT NULL default '0',
  `name` char(100) NOT NULL default '',
  `url` char(100) NOT NULL default '',
  `descrip` char(200) NOT NULL default '0',
  `logo` char(100) NOT NULL default '',
  `ifcheck` tinyint(1) NOT NULL default '0',
  `username` char(20) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_singleright`;

CREATE TABLE `pw_singleright` (
  `uid` mediumint(8) 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=gbk;

DROP TABLE IF EXISTS `pw_smiles`;

CREATE TABLE `pw_smiles` (
  `id` smallint(6) unsigned NOT NULL auto_increment,
  `path` varchar(20) NOT NULL default '',
  `name` varchar(20) 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=gbk;

DROP TABLE IF EXISTS `pw_styles`;

CREATE TABLE `pw_styles` (
  `sid` smallint(6) unsigned NOT NULL auto_increment,
  `name` char(50) NOT NULL default '',
  `stylepath` char(50) NOT NULL default '',
  `tplpath` char(50) NOT NULL default '',
  `yeyestyle` char(3) NOT NULL default '',
  `bgcolor` char(100) NOT NULL,
  `linkcolor` char(7) NOT NULL,
  `tablecolor` char(7) NOT NULL default '',
  `tdcolor` char(7) NOT NULL,
  `tablewidth` char(6) NOT NULL,
  `mtablewidth` char(6) NOT NULL,
  `headcolor` char(100) NOT NULL,
  `headborder` char(7) NOT NULL,
  `headfontone` char(7) NOT NULL,
  `headfonttwo` char(7) NOT NULL,
  `cbgcolor` char(100) NOT NULL,
  `cbgborder` char(7) NOT NULL,
  `cbgfont` char(7) NOT NULL,
  `forumcolorone` char(7) NOT NULL default '',
  `forumcolortwo` char(7) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_tagdata`;

CREATE TABLE `pw_tagdata` (
  `tagid` mediumint(8) NOT NULL default '0',
  `tid` mediumint(8) NOT NULL default '0',
  KEY `tagid` (`tagid`),
  KEY `tid` (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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 `num` (`ifhot`,`num`),
  KEY `tagname` (`tagname`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_threads`;

CREATE TABLE `pw_threads` (
  `tid` mediumint(8) unsigned NOT NULL auto_increment,
  `fid` smallint(6) NOT NULL default '0',
  `icon` tinyint(2) NOT NULL default '0',
  `titlefont` char(15) NOT NULL default '',
  `author` char(15) NOT NULL default '',
  `authorid` mediumint(8) unsigned NOT NULL default '0',
  `subject` char(100) NOT NULL default '',
  `toolinfo` char(16) NOT NULL default '',
  `toolfield` varchar(21) NOT NULL default '',
  `ifcheck` tinyint(1) NOT NULL default '0',
  `type` tinyint(2) NOT NULL default '0',
  `postdate` int(10) unsigned NOT NULL default '0',
  `lastpost` int(10) unsigned NOT NULL default '0',
  `lastposter` char(15) NOT NULL default '',
  `hits` int(10) unsigned NOT NULL default '0',
  `replies` int(10) unsigned NOT NULL default '0',
  `topped` smallint(6) NOT NULL default '0',
  `locked` tinyint(1) NOT NULL default '0',
  `digest` tinyint(1) NOT NULL default '0',
  `special` tinyint(1) NOT NULL default '0',
  `ifupload` tinyint(1) NOT NULL default '0',
  `ifmail` tinyint(1) NOT NULL default '0',
  `ifmark` smallint(6) NOT NULL default '0',
  `rewardinfo` varchar(80) NOT NULL default '',
  `ifshield` tinyint(1) NOT NULL default '0',
  `anonymous` tinyint(1) 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(1) NOT NULL default '0',
  `ifhide` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`tid`),
  KEY `authorid` (`authorid`),
  KEY `postdate` (`postdate`),
  KEY `digest` (`digest`),
  KEY `type` (`fid`,`type`,`ifcheck`),
  KEY `special` (`special`),
  KEY `lastpost` (`fid`,`ifcheck`,`topped`,`lastpost`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_tmsgs`;

CREATE TABLE `pw_tmsgs` (
  `tid` mediumint(8) unsigned NOT NULL default '0',
  `aid` text NOT NULL,
  `userip` varchar(15) NOT NULL default '',
  `ifsign` tinyint(1) NOT NULL default '0',
  `buy` text NOT NULL,
  `ipfrom` varchar(80) NOT NULL default '',
  `alterinfo` varchar(50) NOT NULL default '',
  `remindinfo` varchar(150) NOT NULL default '',
  `tags` varchar(100) NOT NULL default '',
  `ifconvert` tinyint(1) NOT NULL default '1',
  `ifwordsfb` tinyint(1) 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,
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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` mediumint(8) 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` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`),
  KEY `touid` (`touid`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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(1) NOT NULL default '0',
  `price` varchar(255) NOT NULL default '',
  `creditype` varchar(10) NOT NULL default '',
  `type` tinyint(1) NOT NULL default '0',
  `stock` smallint(6) NOT NULL default '0',
  `conditions` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `pw_usergroups`;

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

DROP TABLE IF EXISTS `pw_usertool`;

CREATE TABLE `pw_usertool` (
  `uid` mediumint(8) 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 '',
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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(1) NOT NULL default '0',
  `ifopen` tinyint(1) NOT NULL default '0',
  `title` varchar(30) NOT NULL default '',
  `descrip` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

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(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `xe_action_forward`;

CREATE TABLE `xe_action_forward` (
  `act` varchar(80) NOT NULL,
  `module` varchar(60) NOT NULL,
  `type` varchar(15) NOT NULL,
  UNIQUE KEY `idx_foward` (`act`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member`;

CREATE TABLE `xe_member` (
  `member_srl` bigint(11) NOT NULL,
  `user_id` varchar(80) NOT NULL,
  `email_address` varchar(250) NOT NULL,
  `password` varchar(60) NOT NULL,
  `email_id` varchar(80) NOT NULL,
  `email_host` varchar(160) default NULL,
  `user_name` varchar(40) NOT NULL,
  `nick_name` varchar(40) NOT NULL,
  `homepage` varchar(250) default NULL,
  `blog` varchar(250) default NULL,
  `birthday` char(8) default NULL,
  `allow_mailing` char(1) NOT NULL default 'Y',
  `allow_message` char(1) NOT NULL default 'Y',
  `denied` char(1) default 'N',
  `limit_date` varchar(14) default NULL,
  `regdate` varchar(14) default NULL,
  `last_login` varchar(14) default NULL,
  `is_admin` char(1) default 'N',
  `description` text,
  `extra_vars` text,
  PRIMARY KEY  (`member_srl`),
  UNIQUE KEY `unique_user_id` (`user_id`),
  UNIQUE KEY `unique_email_address` (`email_address`),
  UNIQUE KEY `unique_nick_name` (`nick_name`),
  KEY `idx_email_host` (`email_host`),
  KEY `idx_allow_mailing` (`allow_mailing`),
  KEY `idx_is_denied` (`denied`),
  KEY `idx_regdate` (`regdate`),
  KEY `idx_last_login` (`last_login`),
  KEY `idx_is_admin` (`is_admin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_auth_mail`;

CREATE TABLE `xe_member_auth_mail` (
  `auth_key` varchar(60) NOT NULL,
  `member_srl` bigint(11) NOT NULL,
  `user_id` varchar(80) NOT NULL,
  `new_password` varchar(80) NOT NULL,
  `regdate` varchar(14) default NULL,
  UNIQUE KEY `unique_key` (`auth_key`,`member_srl`),
  KEY `idx_regdate` (`regdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_autologin`;

CREATE TABLE `xe_member_autologin` (
  `autologin_key` varchar(80) NOT NULL,
  `member_srl` bigint(11) NOT NULL,
  PRIMARY KEY  (`autologin_key`,`member_srl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_denied_user_id`;

CREATE TABLE `xe_member_denied_user_id` (
  `user_id` varchar(80) NOT NULL,
  `regdate` varchar(14) default NULL,
  `description` text,
  `list_order` bigint(11) NOT NULL,
  PRIMARY KEY  (`user_id`),
  KEY `idx_list_order` (`list_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_friend`;

CREATE TABLE `xe_member_friend` (
  `friend_srl` bigint(11) NOT NULL,
  `friend_group_srl` bigint(11) NOT NULL,
  `member_srl` bigint(11) NOT NULL,
  `target_srl` bigint(11) NOT NULL,
  `list_order` bigint(11) NOT NULL,
  `regdate` varchar(14) default NULL,
  PRIMARY KEY  (`friend_srl`),
  KEY `idx_friend_group_srl` (`friend_group_srl`),
  KEY `idx_member_srl` (`member_srl`),
  KEY `idx_target_srl` (`target_srl`),
  KEY `idx_list_order` (`list_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_friend_group`;

CREATE TABLE `xe_member_friend_group` (
  `friend_group_srl` bigint(11) NOT NULL,
  `member_srl` bigint(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `regdate` varchar(14) default NULL,
  PRIMARY KEY  (`friend_group_srl`),
  KEY `index_owner_member_srl` (`member_srl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_group`;

CREATE TABLE `xe_member_group` (
  `group_srl` bigint(11) NOT NULL,
  `title` varchar(80) NOT NULL,
  `regdate` varchar(14) default NULL,
  `is_default` char(1) default 'N',
  `is_admin` char(1) default 'N',
  `description` text,
  PRIMARY KEY  (`group_srl`),
  UNIQUE KEY `uni_member_group_title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_group_member`;

CREATE TABLE `xe_member_group_member` (
  `group_srl` bigint(11) NOT NULL,
  `member_srl` bigint(11) NOT NULL,
  `regdate` varchar(14) default NULL,
  KEY `idx_group_member` (`group_srl`,`member_srl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_join_form`;

CREATE TABLE `xe_member_join_form` (
  `member_join_form_srl` bigint(11) NOT NULL,
  `column_type` varchar(60) NOT NULL,
  `column_name` varchar(60) NOT NULL,
  `column_title` varchar(60) NOT NULL,
  `required` char(1) NOT NULL default 'N',
  `default_value` text,
  `is_active` char(1) default 'Y',
  `description` text,
  `list_order` bigint(11) NOT NULL default '1',
  `regdate` varchar(14) default NULL,
  PRIMARY KEY  (`member_join_form_srl`),
  KEY `idx_list_order` (`list_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_message`;

CREATE TABLE `xe_member_message` (
  `message_srl` bigint(11) NOT NULL,
  `related_srl` bigint(11) NOT NULL,
  `sender_srl` bigint(11) NOT NULL,
  `receiver_srl` bigint(11) NOT NULL,
  `message_type` char(1) NOT NULL default 'S',
  `title` varchar(250) NOT NULL,
  `content` text NOT NULL,
  `readed` char(1) NOT NULL default 'N',
  `list_order` bigint(11) NOT NULL,
  `regdate` varchar(14) default NULL,
  `readed_date` varchar(14) default NULL,
  PRIMARY KEY  (`message_srl`),
  KEY `idx_related_srl` (`related_srl`),
  KEY `idx_sender_srl` (`sender_srl`),
  KEY `idx_receiver_srl` (`receiver_srl`),
  KEY `idx_list_order` (`list_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_member_scrap`;

CREATE TABLE `xe_member_scrap` (
  `member_srl` bigint(11) NOT NULL,
  `document_srl` bigint(11) NOT NULL,
  `title` varchar(250) default NULL,
  `user_id` varchar(80) default NULL,
  `user_name` varchar(80) NOT NULL,
  `nick_name` varchar(80) NOT NULL,
  `target_member_srl` bigint(11) NOT NULL,
  `regdate` varchar(14) default NULL,
  `list_order` bigint(11) NOT NULL,
  UNIQUE KEY `unique_scrap` (`member_srl`,`document_srl`),
  KEY `idx_regdate` (`regdate`),
  KEY `idx_list_order` (`list_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_module_categories`;

CREATE TABLE `xe_module_categories` (
  `module_category_srl` bigint(11) NOT NULL,
  `title` varchar(250) default NULL,
  `regdate` varchar(14) default NULL,
  PRIMARY KEY  (`module_category_srl`),
  KEY `idx_regdate` (`regdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_module_config`;

CREATE TABLE `xe_module_config` (
  `module` varchar(250) NOT NULL,
  `config` text,
  `regdate` varchar(14) default NULL,
  PRIMARY KEY  (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_module_trigger`;

CREATE TABLE `xe_module_trigger` (
  `trigger_name` varchar(80) NOT NULL,
  `called_position` varchar(15) NOT NULL,
  `module` varchar(80) NOT NULL,
  `type` varchar(15) NOT NULL,
  `called_method` varchar(80) NOT NULL,
  UNIQUE KEY `idx_trigger` (`trigger_name`,`called_position`,`module`,`type`,`called_method`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_modules`;

CREATE TABLE `xe_modules` (
  `module_srl` bigint(11) NOT NULL,
  `module` varchar(80) NOT NULL,
  `module_category_srl` bigint(11) default NULL,
  `layout_srl` bigint(11) default NULL,
  `menu_srl` bigint(11) default NULL,
  `mid` varchar(40) NOT NULL,
  `skin` varchar(250) default NULL,
  `browser_title` varchar(250) NOT NULL,
  `description` text,
  `is_default` char(1) NOT NULL default 'N',
  `extra_vars` text,
  `skin_vars` text,
  `content` longtext,
  `grants` text,
  `admin_id` text,
  `open_rss` char(1) NOT NULL default 'Y',
  `header_text` text,
  `footer_text` text,
  `regdate` varchar(14) default NULL,
  PRIMARY KEY  (`module_srl`),
  UNIQUE KEY `unique_mid` (`mid`),
  KEY `idx_module` (`module`),
  KEY `idx_module_category` (`module_category_srl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `xe_sequence`;

CREATE TABLE `xe_sequence` (
  `seq` bigint(64) NOT NULL auto_increment,
  PRIMARY KEY  (`seq`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

