查看日志: sanguobw_test_7/role_login_gujian_20_20260826_160510.sql

总行数: 71 当前页: 1/1
下载完整日志
-- MySQL dump 10.13  Distrib 5.7.37, for linux-glibc2.12 (x86_64)
--
-- Host: 172.31.22.142    Database: sanguobw_gujian_20
-- ------------------------------------------------------
-- Server version	5.7.44-53-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 `role_login`
--

DROP TABLE IF EXISTS `role_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_login` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `zone_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分区Id',
  `account` varchar(100) NOT NULL DEFAULT '' COMMENT '平台账户',
  `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '配置平台标识',
  `reg_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `reg_ip` varchar(30) NOT NULL DEFAULT '' COMMENT '注册IP',
  `reg_pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台',
  `source` varchar(100) NOT NULL DEFAULT '' COMMENT '渠道来源',
  `rollmark` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '滚服标识,0-否,1-是',
  `is_market` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否集市用户,0-否,1-是',
  `app_custom` varchar(100) NOT NULL DEFAULT '' COMMENT 'app_custom',
  `via` varchar(100) NOT NULL DEFAULT '' COMMENT 'via',
  `province_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '省份id',
  `zone_aid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分区唯一Id',
  `reg_channel` varchar(255) NOT NULL DEFAULT '' COMMENT '注冊渠道',
  `device_id` varchar(255) NOT NULL DEFAULT '' COMMENT '设备号',
  `dispense` varchar(255) NOT NULL DEFAULT '' COMMENT '分发号',
  `device_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '设备类型',
  PRIMARY KEY (`id`),
  KEY `reg_ip` (`reg_ip`),
  KEY `reg_time` (`reg_time`),
  KEY `account` (`account`),
  KEY `zone_index` (`account`,`zone_aid`)
) ENGINE=InnoDB AUTO_INCREMENT=20000000146 DEFAULT CHARSET=utf8 COMMENT='玩家登陆信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_login`
--

LOCK TABLES `role_login` WRITE;
/*!40000 ALTER TABLE `role_login` DISABLE KEYS */;
INSERT INTO `role_login` VALUES (20000000001,20,'7063711','gujian',1764527396,'223.74.196.185','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000002,20,'7060671','gujian',1764527427,'111.55.209.64','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000003,20,'7063712','gujian',1764527450,'218.84.87.138','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000004,20,'7063714','gujian',1764527461,'119.126.115.92','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000005,20,'7063715','gujian',1764527509,'122.191.194.73','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000006,20,'7063717','gujian',1764527548,'39.144.250.157','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000007,20,'7063719','gujian',1764527558,'182.118.238.38','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000008,20,'7063720','gujian',1764527569,'39.144.251.251','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000009,20,'7063721','gujian',1764527586,'223.89.16.169','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000010,20,'7063724','gujian',1764527641,'123.55.177.144','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000011,20,'7063725','gujian',1764527641,'112.96.209.210','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000012,20,'7063727','gujian',1764527676,'117.88.161.168','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000013,20,'7063726','gujian',1764527680,'122.96.32.3','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000014,20,'7063730','gujian',1764527750,'36.248.233.212','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000015,20,'7063732','gujian',1764527824,'113.143.252.140','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000016,20,'7063733','gujian',1764527851,'112.45.18.79','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000017,20,'7063734','gujian',1764527861,'183.208.180.221','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000018,20,'7063736','gujian',1764527895,'116.16.16.111','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000019,20,'6714585','gujian',1764527980,'112.97.192.106','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000020,20,'7063739','gujian',1764528451,'117.182.13.238','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000021,20,'7063744','gujian',1764530150,'36.101.119.126','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000022,20,'7063627','gujian',1764530726,'39.144.38.152','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000023,20,'7060359','gujian',1764531841,'116.169.21.4','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000024,20,'7051499','gujian',1764531960,'113.16.88.201','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000025,20,'7063745','gujian',1764532670,'220.197.246.222','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000026,20,'7063746','gujian',1764532717,'222.140.151.20','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000027,20,'7063747','gujian',1764533199,'220.197.246.222','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000028,20,'7062831','gujian',1764536645,'183.219.173.99','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000029,20,'5923410','gujian',1764537757,'223.101.113.166','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000030,20,'7063750','gujian',1764538614,'223.104.194.199','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000031,20,'7050941','gujian',1764540003,'122.242.85.167','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000032,20,'7063752','gujian',1764542315,'223.95.17.30','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000033,20,'5816295','gujian',1764542347,'171.123.193.138','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000034,20,'7063753','gujian',1764544823,'182.102.64.78','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000035,20,'7063754','gujian',1764545797,'39.144.249.7','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000036,20,'7063756','gujian',1764546419,'112.97.171.40','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000037,20,'7063760','gujian',1764546741,'101.90.129.8','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000038,20,'7063762','gujian',1764546809,'223.160.176.20','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000039,20,'7063763','gujian',1764546958,'223.160.140.223','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000040,20,'7060487','gujian',1764547204,'182.149.121.208','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000041,20,'7062901','gujian',1764547294,'223.104.122.130','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000042,20,'7063766','gujian',1764547488,'183.219.194.228','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000043,20,'7063761','gujian',1764547880,'117.136.105.24','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000044,20,'7063767','gujian',1764547917,'58.247.23.96','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000045,20,'7063768','gujian',1764547956,'175.167.155.230','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000046,20,'7063770','gujian',1764548053,'223.104.150.118','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000047,20,'7063769','gujian',1764548242,'223.104.150.118','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000048,20,'7063771','gujian',1764548323,'117.179.246.179','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000049,20,'7063772','gujian',1764548556,'112.230.135.231','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000050,20,'7063774','gujian',1764548674,'223.74.124.23','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000051,20,'7063775','gujian',1764548764,'112.17.237.73','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000052,20,'5532747','gujian',1764548833,'111.0.235.159','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000053,20,'7063777','gujian',1764549075,'106.34.19.61','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000054,20,'7062588','gujian',1764549301,'117.151.124.11','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000055,20,'7063779','gujian',1764549388,'117.40.229.38','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000056,20,'7062737','gujian',1764549521,'111.79.194.47','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000057,20,'7063778','gujian',1764549570,'112.230.135.231','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000058,20,'7063759','gujian',1764549599,'111.55.24.7','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000059,20,'7063780','gujian',1764549852,'123.101.241.44','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000060,20,'7063781','gujian',1764550024,'39.144.86.88','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000061,20,'6240089','gujian',1764550060,'117.179.23.110','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000062,20,'7063224','gujian',1764550651,'36.43.195.136','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000063,20,'7063782','gujian',1764550883,'112.224.198.42','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000064,20,'7063776','gujian',1764550919,'125.44.79.128','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000065,20,'7063785','gujian',1764551162,'39.144.123.145','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000066,20,'7063788','gujian',1764552026,'117.181.150.22','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000067,20,'7056416','gujian',1764552346,'39.144.90.235','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000068,20,'7063790','gujian',1764552450,'223.104.70.68','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000069,20,'7063793','gujian',1764552899,'113.84.82.64','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000070,20,'7036619','gujian',1764553351,'14.19.20.109','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000071,20,'7063797','gujian',1764553873,'39.144.54.67','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000072,20,'5846494','gujian',1764554661,'112.224.166.78','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000073,20,'7051858','gujian',1764555088,'39.144.108.94','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000074,20,'7048137','gujian',1764555748,'123.13.64.153','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000075,20,'7055950','gujian',1764555999,'223.104.132.41','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000076,20,'5133315','gujian',1764556206,'114.239.29.135','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000077,20,'7062439','gujian',1764556778,'223.104.122.158','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000078,20,'7063802','gujian',1764556984,'112.14.77.6','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000079,20,'7063806','gujian',1764557320,'116.77.73.252','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000080,20,'7063807','gujian',1764557485,'49.90.85.69','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000081,20,'7063804','gujian',1764557929,'122.193.198.197','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000082,20,'7063810','gujian',1764557967,'223.104.71.104','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000083,20,'7063803','gujian',1764558011,'182.102.138.248','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000084,20,'7063812','gujian',1764558450,'113.238.206.189','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000085,20,'7063808','gujian',1764558654,'180.143.187.167','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000086,20,'7063813','gujian',1764558754,'223.160.217.46','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000087,20,'7063814','gujian',1764559033,'120.235.128.240','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000088,20,'7063816','gujian',1764559172,'111.55.103.201','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000089,20,'7063819','gujian',1764559347,'182.102.138.248','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000090,20,'7063820','gujian',1764559671,'120.239.199.243','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000091,20,'7063823','gujian',1764560049,'112.48.75.123','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000092,20,'7063831','gujian',1764561090,'182.104.83.244','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000093,20,'7063832','gujian',1764561262,'182.239.87.179','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000094,20,'7063833','gujian',1764561461,'223.104.80.182','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000095,20,'6916542','gujian',1764561695,'221.14.53.75','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000096,20,'7063293','gujian',1764561762,'124.79.112.41','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000097,20,'7063835','gujian',1764561909,'120.235.218.107','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000098,20,'7063836','gujian',1764562493,'171.113.17.57','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000099,20,'7063828','gujian',1764562622,'116.162.66.5','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000100,20,'7063839','gujian',1764563178,'1.182.97.117','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000101,20,'7063840','gujian',1764563286,'111.36.189.116','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000102,20,'6946526','gujian',1764563658,'116.30.136.88','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000103,20,'5826160','gujian',1764564388,'120.37.28.110','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000104,20,'7063849','gujian',1764566190,'120.7.175.55','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000105,20,'7063850','gujian',1764566427,'183.226.119.157','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000106,20,'5842991','gujian',1764569268,'218.87.195.50','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000107,20,'7063847','gujian',1764569335,'39.144.219.24','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000108,20,'7055927','gujian',1764569583,'223.104.134.197','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000109,20,'7063862','gujian',1764569663,'111.38.85.179','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000110,20,'7063863','gujian',1764569744,'220.175.60.102','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000111,20,'7063869','gujian',1764569858,'39.144.38.152','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000112,20,'7063865','gujian',1764569874,'39.144.102.108','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000113,20,'7063859','gujian',1764569876,'113.244.72.108','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000114,20,'7063870','gujian',1764569880,'39.144.231.202','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000115,20,'7063867','gujian',1764569891,'117.62.171.53','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000116,20,'7063874','gujian',1764569979,'220.175.60.102','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000117,20,'7063880','gujian',1764570233,'112.9.193.27','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000118,20,'7063857','gujian',1764570385,'39.149.3.27','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000119,20,'7063885','gujian',1764570433,'117.62.171.53','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000120,20,'7063889','gujian',1764570546,'113.244.72.108','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000121,20,'7063892','gujian',1764570659,'223.104.109.244','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000122,20,'7062646','gujian',1764570740,'39.146.118.138','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000123,20,'7063894','gujian',1764570756,'39.144.249.16','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000124,20,'7063890','gujian',1764571450,'111.55.209.148','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000125,20,'7063844','gujian',1764571656,'223.160.217.46','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000126,20,'7063901','gujian',1764571667,'123.233.7.14','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000127,20,'5925868','gujian',1764571905,'120.87.144.48','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000128,20,'7063856','gujian',1764571959,'111.33.226.61','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000129,20,'7059262','gujian',1764571997,'221.178.95.69','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000130,20,'6757919','gujian',1764572310,'59.51.106.225','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000131,20,'7063837','gujian',1764572509,'39.144.104.248','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000132,20,'7063911','gujian',1764572897,'117.136.105.24','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000133,20,'7063876','gujian',1764572964,'39.144.102.108','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000134,20,'7063913','gujian',1764573144,'125.45.126.100','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000135,20,'7063916','gujian',1764573197,'39.144.230.15','gujian','',0,0,'','',440000,20,'1397','','',0),(20000000136,20,'7218158','gujian',1783533686,'220.200.126.169','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000137,20,'7218285','gujian',1784115117,'59.42.190.32','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000138,20,'7064293','gujian',1784163455,'223.104.80.191','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000139,20,'7192385','gujian',1784251031,'223.104.121.133','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000140,20,'5862746','gujian',1785327380,'39.187.233.206','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000141,20,'7225370','gujian',1785767944,'171.38.220.214','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000142,20,'7225668','gujian',1786020730,'123.161.32.126','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000143,20,'7075554','gujian',1786093238,'27.148.116.230','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000144,20,'7217896','gujian',1786528675,'60.180.251.55','gujian','',0,0,'','',440000,20,'1397','','',1),(20000000145,20,'7217822','gujian',1787129554,'120.231.250.245','gujian','',0,0,'','',440000,20,'1397','','',1);
/*!40000 ALTER TABLE `role_login` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2026-08-26 16:05:10