-- MySQL dump 10.13  Distrib 5.6.50, for Linux (x86_64)
--
-- Host: localhost    Database: globaldata
-- ------------------------------------------------------
-- 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 `item`
--

DROP TABLE IF EXISTS `item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item` (
  `id` int(11) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item`
--

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

--
-- Table structure for table `players`
--

DROP TABLE IF EXISTS `players`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `players` (
  `id` varchar(255) DEFAULT NULL,
  `account` varchar(255) DEFAULT NULL,
  `passwd` varchar(255) DEFAULT NULL,
  `serverindex` varchar(255) DEFAULT NULL,
  `updatetime` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `players`
--

LOCK TABLES `players` WRITE;
/*!40000 ALTER TABLE `players` DISABLE KEYS */;
INSERT INTO `players` VALUES (NULL,'xiao1240','ab27f96d4e68a34eed261a1f38240174',NULL,NULL),(NULL,'xiao','52c69e3a57331081823331c4e69d3f2e',NULL,NULL),(NULL,'w2506659','d440ca5d41df08f6436babfe9e103ebc',NULL,NULL),(NULL,'yrb123456','e10adc3949ba59abbe56e057f20f883e',NULL,NULL),(NULL,'297496079','88f3a60a0bd7753779e6144beed95918',NULL,NULL),(NULL,'12345678','fcea920f7412b5da7be0cf42b8c93759',NULL,NULL),(NULL,'jh524123','a009b8d102d5736ec69fe822e9fca053',NULL,NULL),(NULL,'lou3599','aec60231d83fe6cf81444bc536596887',NULL,NULL),(NULL,'qq729333971','4547e2781bd1d816166766fda702c7d9',NULL,NULL),(NULL,'801067','ad629700393ab351844d2db32bf6aa51',NULL,NULL),(NULL,'zxcvbnm0','02c75fb22c75b23dc963c7eb91a062cc',NULL,NULL),(NULL,'a316248991','7d2ac22c32ed2b7e90046cb4416268df',NULL,NULL),(NULL,'3506050','52dd84cfa857b2da48fee5afa75f6428',NULL,NULL),(NULL,'jb9796','b36b3df5da1f507699a087dc070baeb5',NULL,NULL);
/*!40000 ALTER TABLE `players` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `server`
--

DROP TABLE IF EXISTS `server`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `server` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '服务器名字',
  `ip` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '服务器ip',
  `port` varchar(255) DEFAULT NULL COMMENT '服务器端口',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `server`
--

LOCK TABLES `server` WRITE;
/*!40000 ALTER TABLE `server` DISABLE KEYS */;
INSERT INTO `server` VALUES (1,'1区','1234567.o5x.cn','9001'),(2,'2区','1234567.o5x.cn','9002'),(999,'999区','1234567.o5x.cn','9999');
/*!40000 ALTER TABLE `server` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `serverroute`
--

DROP TABLE IF EXISTS `serverroute`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `serverroute` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `serverid` int(11) DEFAULT NULL COMMENT '服务器id',
  `hostname` varchar(124) DEFAULT NULL COMMENT '网关的ip或者名字',
  `port` int(11) DEFAULT NULL COMMENT '网关的端口',
  `name` varchar(255) DEFAULT '' COMMENT '服务器名',
  `opentime` datetime DEFAULT NULL COMMENT '开服时间',
  `realid` int(11) DEFAULT NULL COMMENT '真实ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='路由数据表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `serverroute`
--

LOCK TABLES `serverroute` WRITE;
/*!40000 ALTER TABLE `serverroute` DISABLE KEYS */;
INSERT INTO `serverroute` VALUES (1,1,'1234567.o5x.cn',9001,'1区',NULL,NULL),(2,2,'1234567.o5x.cn',9002,'2区',NULL,NULL),(999,999,'1234567.o5x.cn',9999,'999区',NULL,NULL);
/*!40000 ALTER TABLE `serverroute` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'globaldata'
--

--
-- Dumping routines for database 'globaldata'
--
/*!50003 DROP PROCEDURE IF EXISTS `loadserverroute` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection  = utf8mb4_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'NO_AUTO_VALUE_ON_ZERO' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `loadserverroute`()
begin
select serverid,hostname,port from serverroute ;
end ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!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:19