--
-- Table structure for table `xy_shopconfig`
--

DROP TABLE IF EXISTS `xy_shopconfig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xy_shopconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `paynum` decimal(10,2) DEFAULT 0.00 COMMENT '价格',
  `item` varchar(999) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `desc` varchar(655) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xy_shopconfig`
--

LOCK TABLES `xy_shopconfig` WRITE;
/*!40000 ALTER TABLE `xy_shopconfig` DISABLE KEYS */;
INSERT INTO `xy_shopconfig` VALUES (1,'月卡',30.00,'[{\"id\":\"230000301\",\"num\":\"1\"} ]','直接售卖','1','月卡×1'),(2,'理财卡',198.00,'[{\"id\":\"230000304\",\"num\":\"1\"}]','终身限购','1','理财卡×1'),(3,'60级飞升药水',30.00,'[{\"id\":\"800001535\",\"num\":\"1\"}]','终身限购','1','60级飞升药水×1'),(4,'5000点券',30.00,'[{\"id\":\"600000354\",\"num\":\"1\"}]','直接售卖','1','5000点券'),(5,'王者通行证',98.00,'[{\"id\":\"330000251\",\"num\":\"1\"}]','直接售卖','1','王者通行证×1'),(6,'1元礼包',1.00,'[{\"id\":\"600000001\",\"num\":\"5000\"},{\"id\":\"300000106\",\"num\":\"50\"},{\"id\":\"200110002\",\"num\":\"2\"},{\"id\":\"200000002\",\"num\":\"100\"},{\"id\":\"330000189\",\"num\":\"1\"}]','直接售卖','1','5000金币，50个透明晶石，2个洗炼盒，100张深渊票(绑)，1张米亚的普通抽奖券'),(7,'3元礼包',3.00,'[{\"id\":\"600000001\",\"num\":\"10000\"},{\"id\":\"300000106\",\"num\":\"100\"},{\"id\":\"200110002\",\"num\":\"5\"},{\"id\":\"200000002\",\"num\":\"200\"},{\"id\":\"330000190\",\"num\":\"1\"}]','直接售卖','1','1万金币，100个透明晶石，5个洗炼盒，200张深渊票(绑)，1张米亚的高级抽奖券'),(8,'6元礼包',6.00,'[{\"id\":\"600000001\",\"num\":\"20000\"},{\"id\":\"300000106\",\"num\":\"200\"},{\"id\":\"200110002\",\"num\":\"10\"},{\"id\":\"200000002\",\"num\":\"400\"},{\"id\":\"330000191\",\"num\":\"1\"}]','直接售卖','1','2万金币，200个透明晶石，10个洗炼盒，400张深渊票(绑)，1张米亚的稀有抽奖券');
/*!40000 ALTER TABLE `xy_shopconfig` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xy_tequan`
--

DROP TABLE IF EXISTS `xy_tequan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xy_tequan` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一编码',
  `name` varchar(255) NOT NULL COMMENT '角色姓名',
  `account` varchar(255) NOT NULL COMMENT '账号ID',
  `server` varchar(11) NOT NULL COMMENT '区服ID',
  `role` bigint(20) NOT NULL COMMENT '角色ID',
  `type` int(11) NOT NULL COMMENT '权限ID',
  `time` varchar(255) NOT NULL COMMENT '领取时间判断',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `xy_leichongconfig`
--

DROP TABLE IF EXISTS `xy_leichongconfig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xy_leichongconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `item` varchar(999) DEFAULT NULL,
  `paynum` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `desc` varchar(655) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xy_leichongconfig`
--

LOCK TABLES `xy_leichongconfig` WRITE;
/*!40000 ALTER TABLE `xy_leichongconfig` DISABLE KEYS */;
INSERT INTO `xy_leichongconfig` VALUES (1,'充值满100元','[{\"id\":\"810000043\",\"num\":\"1\"},{\"id\":\"300000214\",\"num\":\"20\"},{\"id\":\"130193165\",\"num\":\"1\"},{\"id\":\"531003021\",\"num\":\"1\"},{\"id\":\"230000916\",\"num\":\"1\"}]','100','1','最终兵器彼女宠物蛋x1,激化保护券x20,天无之境,龙的传人,校园时光腰饰,尤蒙刚德'),(2,'充值满200元','[{\"id\":\"200100332\",\"num\":\"20\"},{\"id\":\"300000214\",\"num\":\"30\"},{\"id\":\"531003018\",\"num\":\"1\"}]','200','1','+15激化券x20，激化保护券x30，校园时光衣服'),(3,'充值满500元','[{\"id\":\"200100333\",\"num\":\"5\"},{\"id\":\"200100332\",\"num\":\"30\"},{\"id\":\"300000214\",\"num\":\"50\"},{\"id\":\"330000144\",\"num\":\"1\"},{\"id\":\"167293001\",\"num\":\"1\"},{\"id\":\"531003017\",\"num\":\"1\"}]','500','1','+16激化券x5，+15激化券x30，激化保护券x50，60级转移石，元素激变，校园时光头饰'),(4,'充值满1000元','[{\"id\":\"200100334\",\"num\":\"1\"},{\"id\":\"200100333\",\"num\":\"5\"},{\"id\":\"300000214\",\"num\":\"80\"},{\"id\":\"330000144\",\"num\":\"1\"},{\"id\":\"167290001\",\"num\":\"1\"},{\"id\":\"167292001\",\"num\":\"1\"},{\"id\":\"167291001\",\"num\":\"1\"},{\"id\":\"531003006\",\"num\":\"1\"}]','1000','1','+17激化券*1 +16激化券*5 激化保护卷*80、60级转移石、堕落天使之魂、堕落天使之环、堕落天使之瞳、魔界之翼'),(5,'充值满2000元','[{\"id\":\"200100334\",\"num\":\"3\"},{\"id\":\"200100333\",\"num\":\"10\"},{\"id\":\"300000214\",\"num\":\"50\"},{\"id\":\"331020564\",\"num\":\"1\"},{\"id\":\"331020244\",\"num\":\"1\"}]','2000','1','+17激化券*3、+16激化券*10 激化保护卷*50 荣耀史诗卡片自选宝箱*1 荣耀史诗宝珠自选宝箱*1'),(6,'充值满5000元','[{\"id\":\"200100335\",\"num\":\"3\"},{\"id\":\"200100334\",\"num\":\"5\"},{\"id\":\"300000214\",\"num\":\"50\"},{\"id\":\"331020564\",\"num\":\"2\"},{\"id\":\"331020244\",\"num\":\"2\"}]','5000','1','+18激化券*3、+17激化券*5 激化保护卷*50 荣耀史诗卡片自选宝箱*2 荣耀史诗宝珠自选宝箱*2'),(7,'充值满10000元','[{\"id\":\"200100336\",\"num\":\"3\"},{\"id\":\"200100335\",\"num\":\"5\"},{\"id\":\"300000214\",\"num\":\"50\"},{\"id\":\"331020224\",\"num\":\"1\"},{\"id\":\"331020555\",\"num\":\"800\"},{\"id\":\"331020564\",\"num\":\"3\"},{\"id\":\"331020244\",\"num\":\"3\"}]','10000','1','+19激化券*3 +18激化券*5 激化保护卷*50、神·荣耀光环自选礼盒*1 荣耀史诗卡片自选宝箱*3 荣耀史诗宝珠自选宝箱*3 荣耀宝物*800'),(8,'充值满20000元','[{\"id\":\"200100336\",\"num\":\"5\"},{\"id\":\"300000214\",\"num\":\"100\"},{\"id\":\"331020225\",\"num\":\"5\"},{\"id\":\"331020555\",\"num\":\"2500\"},{\"id\":\"331020564\",\"num\":\"5\"},{\"id\":\"331020244\",\"num\":\"5\"}]','20000','1','+19激化券*5 荣耀·透明时装自选礼盒*5 激化保护卷*100、荣耀史诗卡片自选宝箱*5 荣耀史诗宝珠自选宝箱*5 荣耀宝物*2500'),(9,'充值满50000元','[{\"id\":\"200100337\",\"num\":\"20\"},{\"id\":\"300000214\",\"num\":\"150\"},{\"id\":\"331020555\",\"num\":\"9999\"},{\"id\":\"331020564\",\"num\":\"5\"},{\"id\":\"331020244\",\"num\":\"5\"}]','50000','1','+20激化卷*20 激化保护券*150 荣耀宝物*9999 荣耀史诗附魔卡包*5 荣耀史诗宝珠自选箱*5');
/*!40000 ALTER TABLE `xy_leichongconfig` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xy_leichong`
--

DROP TABLE IF EXISTS `xy_leichong`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xy_leichong` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一编码',
  `name` varchar(255) NOT NULL COMMENT '角色姓名',
  `account` varchar(255) NOT NULL COMMENT '账号ID',
  `server` varchar(11) NOT NULL COMMENT '区服ID',
  `role` bigint(20) NOT NULL COMMENT '角色ID',
  `type` int(11) NOT NULL COMMENT '权限ID',
  `time` varchar(255) NOT NULL COMMENT '领取时间判断',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `xy_meirilcconfig`
--

DROP TABLE IF EXISTS `xy_meirilcconfig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xy_meirilcconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `item` varchar(999) DEFAULT NULL,
  `paynum` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `desc` varchar(655) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xy_meirilcconfig`
--

LOCK TABLES `xy_meirilcconfig` WRITE;
/*!40000 ALTER TABLE `xy_meirilcconfig` DISABLE KEYS */;
INSERT INTO `xy_meirilcconfig` VALUES (1,'今日100元充值','[{\"id\":\"820010201\",\"num\":\"3\"},{\"id\":\"800001424\",\"num\":\"1\"}]','100','1','超级刮刮乐x3,时装自选包x1'),(2,'今日200元充值    ','[{\"id\":\"820010201\",\"num\":\"6\"},{\"id\":\"800001424\",\"num\":\"2\"}]','200','1','超级刮刮乐x6,时装自选包x2'),(3,'今日500元充值    ','[{\"id\":\"820010201\",\"num\":\"10\"},{\"id\":\"800001424\",\"num\":\"3\"},{\"id\":\"331020564\",\"num\":\"1\"}]','500','1','超级刮刮乐x10,时装自选包x3,荣耀★附魔卡包x1'),(4,'今日1000元充值','[{\"id\":\"820010201\",\"num\":\"12\"},{\"id\":\"800001523\",\"num\":\"1\"}]','1000','1','超级刮刮乐x12,争霸赛光环x1'),(5,'今日2000元充值','[{\"id\":\"820010201\",\"num\":\"25\"}]','2000','1','超级刮刮乐x25'),(6,'今日5000元充值','[{\"id\":\"820010201\",\"num\":\"65\"}]','5000','1','超级刮刮乐x65'),(7,'今日10000元充值','[{\"id\":\"820010201\",\"num\":\"100\"},{\"id\":\"300000214\",\"num\":\"10\"}]','10000','1','超级刮刮乐x100,激化保护券x10');
/*!40000 ALTER TABLE `xy_meirilcconfig` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xy_meiri`
--

DROP TABLE IF EXISTS `xy_meiri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xy_meiri` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一编码',
  `name` varchar(255) NOT NULL COMMENT '角色姓名',
  `account` varchar(255) NOT NULL COMMENT '账号ID',
  `server` varchar(11) NOT NULL COMMENT '区服ID',
  `role` bigint(20) NOT NULL COMMENT '角色ID',
  `type` int(11) NOT NULL COMMENT '权限ID',
  `time` varchar(255) NOT NULL COMMENT '领取时间判断',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `xy_fuli`
--

DROP TABLE IF EXISTS `xy_fuli`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xy_fuli` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一编码',
  `name` varchar(255) NOT NULL COMMENT '角色姓名',
  `account` varchar(255) NOT NULL COMMENT '账号ID',
  `server` varchar(11) NOT NULL COMMENT '区服ID',
  `role` bigint(20) NOT NULL COMMENT '角色ID',
  `time` varchar(255) NOT NULL COMMENT '领取时间判断',
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `xy_gameorder`
--

DROP TABLE IF EXISTS `xy_gameorder`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xy_gameorder` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `sorder` varchar(255) DEFAULT NULL,
  `gorder` varchar(255) DEFAULT NULL,
  `account` varchar(255) DEFAULT NULL,
  `server` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `rolename` varchar(255) DEFAULT NULL,
  `agent` varchar(255) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `uptime` datetime DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `money` decimal(10,2) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `cmda` varchar(255) DEFAULT NULL,
  `cmdb` varchar(255) DEFAULT NULL,
  `merchant` varchar(255) DEFAULT NULL,
  `servername` varchar(255) DEFAULT NULL,
  `agentall` varchar(255) DEFAULT NULL,
  `itemname` varchar(255) DEFAULT NULL,
  `paytape` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

-- ----------------------------
-- Table structure for `xy_payconfig`
-- ----------------------------
DROP TABLE IF EXISTS `xy_payconfig`;
CREATE TABLE `xy_payconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `miaoshu` varchar(255) DEFAULT NULL,
  `price` int(10) DEFAULT NULL,
  `limitType` int(255) DEFAULT NULL,
  `limitNumber` int(11) DEFAULT NULL,
  `goods` varchar(255) DEFAULT NULL,
  `firstAdd` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of xy_payconfig
-- ----------------------------
INSERT INTO `xy_payconfig` VALUES ('1', '60泰拉币', '购买可获得60泰拉币', '6', '0', '0', '900000303,1', '900000304,1');
INSERT INTO `xy_payconfig` VALUES ('2', '300泰拉币', '购买可获得300泰拉币', '30', '0', '0', '900000305,1', '900000306,1');
INSERT INTO `xy_payconfig` VALUES ('3', '20000泰拉币', '购买可获得20000泰拉币', '60', '0', '0', '900000307,1', '900000308,1');
INSERT INTO `xy_payconfig` VALUES ('4', '1980泰拉币', '购买可获得1980泰拉币', '198', '0', '0', '900000309,1', '900000310,1');
INSERT INTO `xy_payconfig` VALUES ('5', '50000泰拉币', '购买可获得50000泰拉币', '328', '0', '0', '900000311,1', '900000312,1');
INSERT INTO `xy_payconfig` VALUES ('6', '6480泰拉币', '购买可获得6480泰拉币', '648', '0', '0', '900000313,1', '900000314,1');
INSERT INTO `xy_payconfig` VALUES ('7', '月卡', '购买后享受月卡福利', '30', '0', '0', '900000319,1', null);
INSERT INTO `xy_payconfig` VALUES ('8', '980泰拉币', '购买可获得980泰拉币', '98', '0', '0', '900000315,1', '900000316,1');
INSERT INTO `xy_payconfig` VALUES ('9', '4480泰拉币', '购买可获4480泰拉币', '488', '0', '0', '900000317,1', '900000318,1');
INSERT INTO `xy_payconfig` VALUES ('10', '理财卡', '购买后享受理财卡特权', '198', '2', '1', '900009009,1', null);
INSERT INTO `xy_payconfig` VALUES ('11', '1元礼包', '1元礼包', '1', '1', '1', '900000321,1', null);
INSERT INTO `xy_payconfig` VALUES ('12', '3元礼包', '3元礼包', '3', '1', '1', '900000322,1', null);
INSERT INTO `xy_payconfig` VALUES ('13', '6元礼包', '6元礼包', '6', '1', '1', '900000323,1', null);
INSERT INTO `xy_payconfig` VALUES ('14', '王者版通行证', '王者版通行证', '98', '2', '1', '900000320,1', null);

-- ----------------------------
-- Table structure for `xy_gamebuy_log`
-- ----------------------------
DROP TABLE IF EXISTS `xy_gamebuy_log`;
CREATE TABLE `xy_gamebuy_log` (
  `id` int(11) NOT NULL,
  `account` varchar(255) CHARACTER SET utf8 NOT NULL,
  `server` int(10) NOT NULL,
  `guid` bigint(20) NOT NULL,
  `productId` int(11) NOT NULL,
  `productName` varchar(255) CHARACTER SET utf8 NOT NULL,
  `time` datetime NOT NULL,
  `status` int(10) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `agent` varchar(50) DEFAULT NULL,
  `orderId` varchar(100) NOT NULL COMMENT '订单编号',
  `payNo` varchar(255) DEFAULT NULL COMMENT '第三方交易流水号',
  `payType` varchar(50) DEFAULT '',
  `payTime` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of xy_gamebuy_log