-- MySQL dump 10.13  Distrib 5.6.17, for Win32 (x86)
--
-- Host: localhost    Database: conan_api
-- ------------------------------------------------------
-- Server version	5.6.17

/*!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 `api_accountlogin`
--

DROP TABLE IF EXISTS `api_accountlogin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_accountlogin` (
  `account` varchar(50) NOT NULL,
  `serverid` int(10) NOT NULL,
  `mpf` int(1) NOT NULL,
  `rolename` varchar(64) DEFAULT NULL,
  `level` int(10) DEFAULT NULL,
  `head` varchar(20) DEFAULT NULL,
  `addtime` int(15) NOT NULL,
  `appid` varchar(100) DEFAULT NULL,
  `createtime` varchar(50) DEFAULT NULL,
  `onlyid` bigint(20) DEFAULT NULL,
  KEY `account` (`account`),
  KEY `serverid` (`serverid`),
  KEY `mpf` (`mpf`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_adverid`
--

DROP TABLE IF EXISTS `api_adverid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_adverid` (
  `appid` varchar(20) NOT NULL,
  `guid` varchar(50) NOT NULL,
  `rolename` varchar(50) NOT NULL,
  `ret` varchar(20) NOT NULL,
  `advertid` varchar(50) NOT NULL,
  `event` int(1) DEFAULT NULL,
  `eventtime` varchar(30) DEFAULT NULL,
  `addtime` varchar(30) NOT NULL,
  KEY `advertid` (`advertid`),
  KEY `ret` (`ret`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_coinservice`
--

DROP TABLE IF EXISTS `api_coinservice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_coinservice` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `pt` varchar(50) DEFAULT NULL,
  `ser` text,
  `cver` varchar(30) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `lev` int(3) DEFAULT NULL,
  `rmb` decimal(15,2) DEFAULT NULL,
  `opendays` int(10) DEFAULT NULL,
  `open_date` varchar(23) DEFAULT NULL,
  `close_date` varchar(23) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_controlser`
--

DROP TABLE IF EXISTS `api_controlser`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_controlser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `agent` varchar(50) NOT NULL,
  `serverid` int(11) NOT NULL,
  `logtime` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_deltest_charge`
--

DROP TABLE IF EXISTS `api_deltest_charge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_deltest_charge` (
  `userid` varchar(50) NOT NULL,
  `pt` varchar(60) NOT NULL,
  `coin` int(10) NOT NULL,
  `oid` varchar(20) DEFAULT NULL,
  `taken` int(4) DEFAULT NULL,
  PRIMARY KEY (`userid`,`pt`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_hood_recharge`
--

DROP TABLE IF EXISTS `api_hood_recharge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_hood_recharge` (
  `order_id` varchar(64) NOT NULL,
  `account` varchar(64) DEFAULT NULL,
  `rolename` varchar(100) DEFAULT NULL,
  `imei` varchar(128) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `goods_id` varchar(15) DEFAULT NULL,
  `subid` varchar(15) DEFAULT NULL,
  `zoneid` int(10) DEFAULT NULL,
  `logtime` varchar(23) DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_hoodwx_recharge`
--

DROP TABLE IF EXISTS `api_hoodwx_recharge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_hoodwx_recharge` (
  `order_id` varchar(64) NOT NULL,
  `account` varchar(64) DEFAULT NULL,
  `rolename` varchar(100) DEFAULT NULL,
  `imei` varchar(128) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `goods_id` varchar(15) DEFAULT NULL,
  `subid` varchar(15) DEFAULT NULL,
  `zoneid` int(10) DEFAULT NULL,
  `logtime` varchar(23) DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_imei`
--

DROP TABLE IF EXISTS `api_imei`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_imei` (
  `appid` varchar(50) NOT NULL,
  `serverid` int(10) NOT NULL,
  `imei` varchar(128) NOT NULL,
  `addtime` varchar(50) NOT NULL,
  KEY `appidimei` (`appid`,`imei`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_ip`
--

DROP TABLE IF EXISTS `api_ip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_ip` (
  `appid` varchar(50) NOT NULL,
  `serverid` int(10) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `addtime` varchar(50) NOT NULL,
  KEY `appidip` (`appid`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_language`
--

DROP TABLE IF EXISTS `api_language`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_language` (
  `username` varchar(50) NOT NULL,
  `languagetype` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_offline_charge`
--

DROP TABLE IF EXISTS `api_offline_charge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_offline_charge` (
  `pt` varchar(60) NOT NULL,
  `ser` int(5) NOT NULL,
  `oid` varchar(20) NOT NULL,
  `coin` int(10) DEFAULT NULL,
  `calltime` int(15) DEFAULT '0',
  `buygift` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`pt`,`ser`,`oid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_pay`
--

DROP TABLE IF EXISTS `api_pay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_pay` (
  `gameid` varchar(50) NOT NULL,
  `serverid` varchar(50) NOT NULL,
  `openid` varchar(128) NOT NULL,
  `rolename` varchar(50) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `orderid` varchar(128) NOT NULL,
  `imei` varchar(64) NOT NULL,
  `payip` varchar(64) NOT NULL,
  `mpf` int(1) NOT NULL,
  `paytype` int(2) NOT NULL,
  `addtime` varchar(50) NOT NULL,
  FULLTEXT KEY `openid` (`openid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_pay_tap`
--

DROP TABLE IF EXISTS `api_pay_tap`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_pay_tap` (
  `gameid` varchar(50) CHARACTER SET utf8 NOT NULL,
  `serverid` varchar(50) CHARACTER SET utf8 NOT NULL,
  `openid` varchar(128) CHARACTER SET utf8 NOT NULL,
  `rolename` varchar(50) CHARACTER SET utf8 NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `orderid` varchar(128) CHARACTER SET utf8 NOT NULL,
  `imei` varchar(64) CHARACTER SET utf8 NOT NULL,
  `payip` varchar(64) CHARACTER SET utf8 NOT NULL,
  `mpf` int(1) NOT NULL,
  `paytype` int(2) NOT NULL,
  `addtime` varchar(50) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_point`
--

DROP TABLE IF EXISTS `api_point`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_point` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pf` varchar(20) NOT NULL,
  `sid` int(10) NOT NULL,
  `qid` varchar(50) NOT NULL,
  `event` int(2) NOT NULL,
  `lv` int(10) NOT NULL,
  `fps` int(5) NOT NULL,
  `os` varchar(20) DEFAULT NULL,
  `browser` varchar(50) DEFAULT NULL,
  `seeintro` varchar(50) DEFAULT NULL,
  `addtime` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27987 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_register`
--

DROP TABLE IF EXISTS `api_register`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_register` (
  `account` varchar(128) NOT NULL,
  `openid` varchar(128) NOT NULL,
  `password` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `idcard` varchar(32) DEFAULT NULL,
  `guest` varchar(10) NOT NULL,
  `createtime` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_source`
--

DROP TABLE IF EXISTS `api_source`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_source` (
  `gameid` varchar(50) NOT NULL,
  `serverid` varchar(50) NOT NULL,
  `openid` varchar(128) NOT NULL,
  `rolename` varchar(50) NOT NULL,
  `sourceid` varchar(10) NOT NULL,
  `addtime` varchar(50) NOT NULL,
  FULLTEXT KEY `sourceid` (`sourceid`),
  FULLTEXT KEY `openid` (`openid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_sqbill_no`
--

DROP TABLE IF EXISTS `api_sqbill_no`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_sqbill_no` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `openid` varchar(256) NOT NULL,
  `guid` varchar(128) NOT NULL,
  `bill_no` varchar(128) NOT NULL,
  `o_type` int(1) NOT NULL,
  `amt` int(10) DEFAULT NULL,
  `create_time` varchar(20) NOT NULL,
  `addtime` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_squserdata`
--

DROP TABLE IF EXISTS `api_squserdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_squserdata` (
  `openid` varchar(256) NOT NULL,
  `cur_level` int(2) DEFAULT NULL,
  `cumulative_amt_1` int(10) DEFAULT NULL,
  `receive` text,
  `withdrawal` text,
  `cumulative_amt_2` int(10) DEFAULT NULL,
  `addtime` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`openid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_tappay`
--

DROP TABLE IF EXISTS `api_tappay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_tappay` (
  `openid` varchar(50) NOT NULL,
  `serverid` int(10) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `addtime` varchar(30) NOT NULL,
  `cver` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_tapstate`
--

DROP TABLE IF EXISTS `api_tapstate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_tapstate` (
  `id` int(10) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `state` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `api_vipcustomservice`
--

DROP TABLE IF EXISTS `api_vipcustomservice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `api_vipcustomservice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pt` varchar(50) DEFAULT NULL,
  `ser` text,
  `cver` varchar(20) NOT NULL,
  `img` varchar(255) DEFAULT NULL,
  `amount` decimal(15,2) NOT NULL,
  `lv` smallint(3) DEFAULT NULL,
  `viplv` tinyint(3) DEFAULT NULL,
  `historyRmb` decimal(15,2) DEFAULT NULL,
  `qq` varchar(50) NOT NULL,
  `wx` varchar(20) DEFAULT NULL,
  `goods` varchar(255) DEFAULT NULL,
  `content` varchar(4000) NOT NULL,
  KEY `id` (`id`),
  FULLTEXT KEY `index_cver` (`cver`),
  FULLTEXT KEY `index_pt` (`pt`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `orderidmatch`
--

DROP TABLE IF EXISTS `orderidmatch`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orderidmatch` (
  `gameid` varchar(50) DEFAULT NULL,
  `orderid` varchar(100) NOT NULL,
  PRIMARY KEY (`orderid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2024-08-02  0:08:10
