/*
MySQL Backup
Source Server Version: 5.1.54
Source Database: mu_serverinfo
Date: 29/05/2018 14:29:12
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
--  Table structure for `t_allow_reject_userlist`
-- ----------------------------
DROP TABLE IF EXISTS `t_allow_reject_userlist`;
CREATE TABLE `t_allow_reject_userlist` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `userId` varchar(50) NOT NULL,
  `flag` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_config`
-- ----------------------------
DROP TABLE IF EXISTS `t_config`;
CREATE TABLE `t_config` (
  `paramname` char(32) NOT NULL,
  `paramvalue` varchar(255) NOT NULL,
  UNIQUE KEY `paramname` (`paramname`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_merchant`
-- ----------------------------
DROP TABLE IF EXISTS `t_merchant`;
CREATE TABLE `t_merchant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `lasttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `fullname` varchar(255) DEFAULT NULL,
  `avatar` varchar(32) NOT NULL DEFAULT '',
  `credit` int(11) unsigned NOT NULL DEFAULT '0',
  `gross` int(11) unsigned NOT NULL DEFAULT '0',
  `status` int(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_merchant_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_merchant_log`;
CREATE TABLE `t_merchant_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `merchant` varchar(32) NOT NULL,
  `user` varchar(32) NOT NULL,
  `amount` int(11) NOT NULL,
  `note` varchar(64) DEFAULT NULL,
  `time` datetime NOT NULL,
  `status` varchar(32) DEFAULT 'success',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_plat_chongzhi`
-- ----------------------------
DROP TABLE IF EXISTS `t_plat_chongzhi`;
CREATE TABLE `t_plat_chongzhi` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ptid` int(11) NOT NULL DEFAULT '0' COMMENT 'ƽ̨ID',
  `serverid` int(11) NOT NULL DEFAULT '0' COMMENT '·þÎñÆ÷±àºÅ',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '³äÖµ½ð¶î',
  `userid` char(64) NOT NULL COMMENT '³äÖµÕ˺Å',
  `inputtime` datetime NOT NULL COMMENT '³äֵʱ¼ä',
  `order_no` char(64) NOT NULL COMMENT '³äÖµ±àºÅ',
  `plat_order_no` char(64) NOT NULL DEFAULT '' COMMENT 'ƽ̨³äÖµÁ÷Ë®ºÅ',
  `state` char(64) NOT NULL COMMENT '±¾µ¥³äֵ״̬',
  `pre_amount` int(11) DEFAULT '0' COMMENT '´ý³äÖµ½ð¶î',
  `ip` varchar(30) DEFAULT '',
  `platname` varchar(30) DEFAULT '',
  `roleid` int(11) DEFAULT NULL,
  `rolename` char(32) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `ix_orderno` (`order_no`),
  KEY `ix_inputtime` (`inputtime`)
) ENGINE=MyISAM AUTO_INCREMENT=344 DEFAULT CHARSET=utf8 COMMENT='ƽ̨³äÖµ×ܱí';

-- ----------------------------
--  Table structure for `t_reload_admin_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_reload_admin_log`;
CREATE TABLE `t_reload_admin_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `admin_username` varchar(32) NOT NULL,
  `buyer_username` varchar(32) NOT NULL,
  `amount` int(11) NOT NULL,
  `method` varchar(64) NOT NULL,
  `time` datetime NOT NULL,
  `status` varchar(32) NOT NULL,
  `note` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_reload_orders`
-- ----------------------------
DROP TABLE IF EXISTS `t_reload_orders`;
CREATE TABLE `t_reload_orders` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL,
  `amount` int(11) NOT NULL,
  `method` varchar(64) NOT NULL,
  `time` datetime NOT NULL,
  `status` char(32) NOT NULL,
  `token` text,
  `itemname` varchar(255) DEFAULT NULL,
  `itemdesc` varchar(255) DEFAULT NULL,
  `qty` int(11) DEFAULT '0',
  `emoney` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_reload_paypal_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_reload_paypal_log`;
CREATE TABLE `t_reload_paypal_log` (
  `id` int(10) NOT NULL,
  `item_name` varchar(64) NOT NULL,
  `payment_type` varchar(64) NOT NULL DEFAULT '',
  `payment_date` varchar(500) NOT NULL DEFAULT '',
  `payment_status` varchar(64) NOT NULL DEFAULT '',
  `payer_status` varchar(64) NOT NULL DEFAULT '',
  `first_name` varchar(64) NOT NULL DEFAULT '',
  `last_name` varchar(64) NOT NULL DEFAULT '',
  `payer_email` varchar(64) NOT NULL,
  `address_name` varchar(64) NOT NULL,
  `address_country` varchar(64) NOT NULL DEFAULT '',
  `address_country_code` varchar(64) NOT NULL DEFAULT '',
  `address_zip` varchar(64) NOT NULL DEFAULT '',
  `address_state` varchar(64) NOT NULL DEFAULT '',
  `address_city` varchar(64) NOT NULL DEFAULT '',
  `address_street` varchar(64) NOT NULL DEFAULT '',
  `mc_currency` varchar(64) NOT NULL DEFAULT '',
  `mc_fee` varchar(64) NOT NULL DEFAULT '',
  `mc_gross` varchar(64) NOT NULL,
  `mc_gross_1` varchar(64) NOT NULL DEFAULT '',
  `custom` text NOT NULL,
  `log_repeat` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_serverdata`
-- ----------------------------
DROP TABLE IF EXISTS `t_serverdata`;
CREATE TABLE `t_serverdata` (
  `Id` int(4) DEFAULT NULL,
  `ServerName` varchar(20) NOT NULL,
  `ServerURL` varchar(15) NOT NULL,
  `DatabaseName` varchar(20) DEFAULT NULL,
  `ServerPort` int(4) NOT NULL,
  `Status` int(4) NOT NULL,
  `OnlineNum` int(11) NOT NULL,
  `StartTime` datetime NOT NULL,
  `MaintainStarTime` datetime DEFAULT NULL,
  `MaintainTerminalTime` datetime DEFAULT NULL,
  `MaintainTxt` text,
  `Capacity` int(11) NOT NULL DEFAULT '100'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_tranlog`
-- ----------------------------
DROP TABLE IF EXISTS `t_tranlog`;
CREATE TABLE `t_tranlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` char(255) NOT NULL,
  `title` char(255) NOT NULL,
  `content` longtext NOT NULL,
  `timecreate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_tranlogadmin`
-- ----------------------------
DROP TABLE IF EXISTS `t_tranlogadmin`;
CREATE TABLE `t_tranlogadmin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` char(255) NOT NULL,
  `title` char(255) NOT NULL,
  `content` longtext NOT NULL,
  `timecreate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_users`
-- ----------------------------
DROP TABLE IF EXISTS `t_users`;
CREATE TABLE `t_users` (
  `userid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` char(32) NOT NULL,
  `userpwd` char(32) NOT NULL,
  `realname` char(32) NOT NULL,
  `uid` char(20) DEFAULT NULL,
  `uquestion` tinyint(4) NOT NULL DEFAULT '0',
  `uanswer` char(32) DEFAULT NULL,
  `regtime` datetime NOT NULL,
  `lasttime` datetime NOT NULL,
  `modtime` datetime DEFAULT NULL,
  `isadult` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `money` int(11) NOT NULL DEFAULT '0',
  `email` char(32) DEFAULT NULL,
  `phone` int(12) DEFAULT NULL,
  `IsFirstGiftcode` bit(1) NOT NULL,
  `CtrlCode` smallint(6) NOT NULL DEFAULT '0',
  `PaypalVerified` smallint(6) NOT NULL DEFAULT '0',
  `merchant_bal` smallint(6) NOT NULL DEFAULT '0',
  `invitecode` varchar(6) DEFAULT '',
  `referrercode` varchar(6) DEFAULT '',
  `referralrebate` int(11) DEFAULT '0',
  PRIMARY KEY (`userid`),
  UNIQUE KEY `username` (`username`),
  KEY `regtime` (`regtime`),
  KEY `lasttime` (`lasttime`),
  KEY `modtime` (`modtime`)
) ENGINE=MyISAM AUTO_INCREMENT=3009 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_users_freebies`
-- ----------------------------
DROP TABLE IF EXISTS `t_users_freebies`;
CREATE TABLE `t_users_freebies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` varchar(256) NOT NULL,
  `type` int(11) NOT NULL,
  `startdate` datetime DEFAULT NULL,
  `enddate` datetime DEFAULT NULL,
  `mailcode` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_users_freebies_record`
-- ----------------------------
DROP TABLE IF EXISTS `t_users_freebies_record`;
CREATE TABLE `t_users_freebies_record` (
  `userid` int(11) NOT NULL,
  `frebiesid` int(11) NOT NULL,
  `claimdate` datetime DEFAULT NULL,
  UNIQUE KEY `datakey` (`userid`,`frebiesid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_users_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_users_log`;
CREATE TABLE `t_users_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `type` varchar(64) NOT NULL,
  `log` longtext NOT NULL,
  `timecreate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=143 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records
-- ----------------------------
INSERT INTO `t_config` VALUES ('BanUserOnPaypalChargeBack','1'), ('DBVersion','7.0'), ('ipn_paypal_business','test@gmail.com'), ('ipn_paypal_cancel_return','http://paypal-ipn-cancel-return'), ('ipn_paypal_currency_code','USD'), ('ipn_paypal_mode','debug'), ('ipn_paypal_notify_url','http://paypal-ipn-notify-url'), ('ipn_paypal_return','http://papal-ipn-url'), ('ipn_paypal_verifieduseronly','1'), ('IsAllPause','0'), ('LoadWalletRate','10'), ('MaintainStarTime','2017-01-20'), ('MaintainTerminalTime','2017-01-23  11:00:00'), ('MaintainTxt','维护好每人可获得40补偿,关注QQ群:456770961'), ('PaypalVirefiedUserOnly','1'), ('RechargeDiamondPackages','50,100,300,500,1000,3000,5000,10000'), ('RechargeMonthCardPrice','1000'), ('RechargeMonthCardValue','45'), ('ServerCount','6'), ('TopUpPackages','4:Platinum Pack:50:50|1:Starter Pack:5:0|2:Silver Pack:10:10|3:Gold Pack:25:20|'), ('TopUpRate','1000');
INSERT INTO `t_serverdata` VALUES ('1','Live Beta','192.95.18.196','mu_game_1','3001','3','10','2017-06-21 02:07:31',NULL,NULL,NULL,'100');
INSERT INTO `t_users` VALUES ('130','zythe','1a60b5052ac43dd0b2cbe9db61b98345','Nitoy Rotidua','192.168.1.250','2','escol','2017-12-13 10:23:41','2018-05-23 19:13:46',NULL,'0','3650','zythe.info@gmail.com',NULL,'\0','9','0','0','F5HZC9','','0');