-- MySQL dump 10.13  Distrib 5.6.50, for Linux (x86_64)
--
-- Host: localhost    Database: center
-- ------------------------------------------------------
-- Server version	5.6.50-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `code_log`
--

DROP TABLE IF EXISTS `code_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `code_log` (
  `idx` bigint(20) NOT NULL AUTO_INCREMENT,
  `cdkey` varchar(32) DEFAULT NULL COMMENT '激活码',
  `gift` varchar(16) DEFAULT NULL COMMENT '配置编号',
  `account` varchar(80) DEFAULT NULL COMMENT '账户名',
  `updatetime` datetime DEFAULT '2019-01-01 00:00:00',
  PRIMARY KEY (`idx`),
  KEY `index_cdkey` (`cdkey`),
  KEY `index_account` (`account`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `code_log`
--

LOCK TABLES `code_log` WRITE;
/*!40000 ALTER TABLE `code_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `code_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `giftcode`
--

DROP TABLE IF EXISTS `giftcode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `giftcode` (
  `idx` bigint(20) NOT NULL AUTO_INCREMENT,
  `cdkey` varchar(32) DEFAULT NULL COMMENT '激活码',
  `gift` varchar(16) DEFAULT NULL COMMENT '配置编号',
  `status` int(11) DEFAULT '0' COMMENT '使用情况',
  `amount` int(11) DEFAULT '0' COMMENT ' 兑换码金额',
  `updatetime` datetime DEFAULT '2019-01-01 00:00:00',
  PRIMARY KEY (`idx`),
  KEY `index_cdkey` (`cdkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `giftcode`
--

LOCK TABLES `giftcode` WRITE;
/*!40000 ALTER TABLE `giftcode` DISABLE KEYS */;
/*!40000 ALTER TABLE `giftcode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recharge`
--

DROP TABLE IF EXISTS `recharge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recharge` (
  `idx` bigint(20) NOT NULL AUTO_INCREMENT,
  `account` varchar(80) DEFAULT NULL COMMENT '账户名',
  `payno` varchar(128) DEFAULT NULL COMMENT '对公代付商户订单号',
  `orderno` varchar(128) DEFAULT NULL COMMENT '订单号',
  `amount` int(11) DEFAULT '0' COMMENT '充值数目',
  `charged` int(11) DEFAULT '0' COMMENT '是否到账',
  `server` int(11) DEFAULT '0' COMMENT '服务器编号',
  `platform` varchar(32) DEFAULT NULL COMMENT '平台',
  `rechargetime` datetime DEFAULT '2019-01-01 00:00:00',
  `actorid` int(11) DEFAULT '0' COMMENT '角色编号',
  PRIMARY KEY (`idx`),
  KEY `index_orderno` (`orderno`),
  KEY `index_orderpf` (`orderno`,`platform`),
  KEY `index_account` (`account`),
  KEY `index_platform` (`platform`),
  KEY `index_server` (`server`),
  KEY `index_time` (`rechargetime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recharge`
--

LOCK TABLES `recharge` WRITE;
/*!40000 ALTER TABLE `recharge` DISABLE KEYS */;
/*!40000 ALTER TABLE `recharge` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `serverlist`
--

DROP TABLE IF EXISTS `serverlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `serverlist` (
  `idx` bigint(20) NOT NULL AUTO_INCREMENT,
  `account` varchar(80) DEFAULT NULL COMMENT '账户名',
  `srvid` varchar(16) DEFAULT NULL COMMENT '服务器编号',
  `updatetime` datetime DEFAULT '2019-01-01 00:00:00',
  PRIMARY KEY (`idx`),
  UNIQUE KEY `idxunique_acount_srvid` (`account`,`srvid`),
  KEY `index_account` (`account`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `serverlist`
--

LOCK TABLES `serverlist` WRITE;
/*!40000 ALTER TABLE `serverlist` DISABLE KEYS */;
INSERT INTO `serverlist` VALUES (1,'xiao1240','1','2021-08-12 12:33:26'),(2,'xiao','2','2021-08-09 15:37:05'),(3,'w2506659','2','2021-08-09 16:44:39'),(4,'yrb123456','1','2021-08-09 16:36:54'),(5,'297496079','2','2021-08-09 21:43:32'),(6,'12345678','1','2021-08-11 00:05:18'),(7,'xiao1240','2','2021-08-11 01:27:59'),(8,'jh524123','2','2021-08-11 10:35:14'),(9,'lou3599','2','2021-08-12 14:08:10'),(10,'qq729333971','1','2021-08-12 19:06:07'),(11,'801067','1','2021-08-12 15:30:28'),(12,'zxcvbnm0','1','2021-08-12 18:35:45'),(13,'qq729333971','2','2021-08-12 19:16:17'),(14,'a316248991','2','2021-08-13 04:21:58'),(15,'3506050','2','2021-08-13 20:13:59'),(16,'jb9796','2','2021-08-14 14:02:20');
/*!40000 ALTER TABLE `serverlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'center'
--

--
-- Dumping routines for database 'center'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-08-15 18:12:24