个人数据,请勿留言, 非常感谢!

[luozhangwen]

/*
MySQL Data Transfer
Source Host: localhost
Source Database: vg2000
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `t_biz_buy_buyer`;
CREATE TABLE `t_biz_buy_buyer` (
  `id` int(11) NOT NULL auto_increment,
  `buyid` int(11) default NULL,
  `uid` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `t_biz_buy_seller`;
CREATE TABLE `t_biz_buy_seller` (
  `id` int(11) NOT NULL auto_increment,
  `gameid` int(11) default NULL,
  `regionid` int(11) default NULL,
  `serverid` int(11) default NULL,
  `uid` int(11) default NULL,
  `goodsName` varchar(100) default NULL,
  `goodsDeccribe` varchar(400) default NULL,
  `goodsImg` varchar(200) default NULL,
  `gameRoleName` varchar(50) default NULL,
  `QQ` varchar(15) default NULL,
  `email` varchar(50) default NULL,
  `phoneRegionNum` varchar(10) default NULL COMMENT '电话地址ID, 先放一下',
  `phone` varchar(15) default NULL,
  `isOpen` int(11) NOT NULL COMMENT '是否直接公开联系方式,1.是,2.否',
  `buytype` int(11) default NULL COMMENT '购求类型:1.一口价 2.面谈',
  `oncePrice` int(11) default NULL COMMENT ' 一口价',
  `currStatus` int(11) default NULL COMMENT '1.求购中,2.已过期,3.已解决',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `t_biz_sale_buyer`;
CREATE TABLE `t_biz_sale_buyer` (
  `id` int(11) NOT NULL auto_increment,
  `saleid` int(11) default NULL,
  `uid` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `t_biz_sale_seller`;
CREATE TABLE `t_biz_sale_seller` (
  `id` int(11) NOT NULL auto_increment,
  `gameid` int(11) default NULL,
  `regionid` int(11) default NULL,
  `serverid` int(11) default NULL,
  `uid` int(11) default NULL,
  `goodsName` varchar(100) default NULL,
  `goodsDeccriber` varchar(400) default NULL,
  `goodsImg` varchar(200) default NULL,
  `gameRoleName` varchar(50) default NULL,
  `QQ` varchar(15) default NULL,
  `email` varchar(50) default NULL,
  `phoneRegionNum` varchar(10) default NULL,
  `phone` varchar(15) default NULL,
  `isOpen` int(11) default NULL,
  `saletype` int(11) default NULL COMMENT '出售类型:1.一口价 2.面谈',
  `oncePrice` int(11) default NULL,
  `currStatus` int(11) default NULL COMMENT '1.出售中,2.已过期,3.已卖出',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `t_gameinfo`;
CREATE TABLE `t_gameinfo` (
  `id` int(11) NOT NULL auto_increment,
  `gameName` varchar(50) default NULL COMMENT '游戏名字',
  `SP` varchar(50) default NULL COMMENT '运营商',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `t_gameregion`;
CREATE TABLE `t_gameregion` (
  `id` int(11) NOT NULL auto_increment,
  `gameId` int(11) default NULL,
  `regionName` varchar(50) default NULL COMMENT '游戏区名',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `t_gameserver`;
CREATE TABLE `t_gameserver` (
  `id` int(11) NOT NULL,
  `gameId` int(11) default NULL,
  `regionId` int(11) NOT NULL COMMENT '区ID',
  `ServerName` varchar(50) NOT NULL COMMENT '服名',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[luozhangwen]

/*
MySQL Data Transfer
Source Database: vg2000
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_um_userpower
-- ----------------------------
DROP TABLE IF EXISTS `t_um_userpower`;
CREATE TABLE `t_um_userpower` (
  `id` int(11) NOT NULL auto_increment,
  `uid` int(11) NOT NULL,
  `powerid` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_um_usertable
-- ----------------------------
DROP TABLE IF EXISTS `t_um_usertable`;
CREATE TABLE `t_um_usertable` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL,
  `password` varchar(50) NOT NULL,
  `lastlogintime` datetime default NULL,
  `score` int(11) default NULL COMMENT '积分',
  `email` varchar(50) NOT NULL,
  `islock` int(11) default NULL COMMENT '0.未锁定 1.锁定',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_ghgame
-- ----------------------------
DROP TABLE IF EXISTS `t_gh_game`;  
CREATE TABLE `t_ghgame` (
  `id` int(11) NOT NULL auto_increment,
  `gameid` int(11) NOT NULL,     --game_ID
  `ghid` int(11) NOT NULL,       --gh_ID
  `type` int(11) default NULL,   --所属类型, 1.进驻, 2.推荐
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_ghinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_gh_info`;
CREATE TABLE `t_ghinfo` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,        --名字
  `regTime` datetime default NULL,    --注册时间
  `PeopleNum` int(11) default NULL,   --人数
  `browseNum` int(11) default NULL,   --浏览次数
  `totalSignInNum` int(11) default NULL, --签到次数
  `weekActiveNum` int(11) default NULL,  --每周活跃度
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_gh_notice
-- ----------------------------
DROP TABLE IF EXISTS `t_ghnotice`;
CREATE TABLE `t_ghnotice` ( 
  `id` int(11) NOT NULL auto_increment, 
  `ghNoticeContent` varchar(4000) default NULL,   --公告
  `ghid` int(11) default NULL,  --ID
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_gh_team
-- ----------------------------
DROP TABLE IF EXISTS `t_team`;
CREATE TABLE `t_team` (
  `id` int(11) NOT NULL,
  `ghid` int(11) NOT NULL,
  `teamName` varchar(40) default NULL,
  `teamNum` int(11) default NULL,
  `gameid` int(11) NOT NULL,
  `headManUid` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_um_sysuser
-- ----------------------------
DROP TABLE IF EXISTS `t_um_sysuser`;
CREATE TABLE `t_um_sysuser` (
  `id` int(11) NOT NULL auto_increment,
  `sysuser` varchar(20) NOT NULL,
  `syspwd` varchar(50) NOT NULL,
  `lastloginTime` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_um_power
-- ----------------------------
DROP TABLE IF EXISTS `t_um_power`;
CREATE TABLE `t_um_power` (
  `id` int(11) NOT NULL auto_increment,
  `position` varchar(20) NOT NULL,
  `powerLevel` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;