webman/sql/app_hd_20250218123746_backu...

759 lines
125 KiB
MySQL
Raw Permalink Normal View History

2025-02-17 23:26:49 +08:00
-- MySQL dump 10.13 Distrib 8.0.12, for Win64 (x86_64)
--
-- Host: localhost Database: app_hd
-- ------------------------------------------------------
-- Server version 8.0.12
/*!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 */;
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 `dictionary`
--
DROP TABLE IF EXISTS `dictionary`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `dictionary` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime NOT NULL COMMENT '更新时间',
`key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'key',
`value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'value',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='系统词典';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dictionary`
--
LOCK TABLES `dictionary` WRITE;
/*!40000 ALTER TABLE `dictionary` DISABLE KEYS */;
INSERT INTO `dictionary` VALUES (1,'2025-02-13 09:45:08','2025-02-13 10:39:02','service_1','https://whatsapp.com/channel/0029Vaz5zp41NCrYrtnZwv0C11111111111111111111111111111111111111111111111111111'),(2,'2025-02-13 09:45:42','2025-02-13 10:39:26','service_2','https://t.me/+aS9V4u7u-bQ3NDlh1111111111111'),(3,'2025-02-13 09:46:06','2025-02-13 09:46:09','service_3','https://t.me/vip22job'),(4,'2025-02-13 09:46:38','2025-02-13 09:46:40','service_url','https://kzhonl.ocbnyutpfwjs.in/index?key=1559c7bcbc04811399a17b8bcbd077e1'),(5,'2025-02-13 10:46:17','2025-02-13 10:46:52','service_user_url','dxxxxxx11111111111'),(6,'2025-02-20 14:40:23','2025-02-13 14:56:59','points','1');
/*!40000 ALTER TABLE `dictionary` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `exchange_rate`
--
DROP TABLE IF EXISTS `exchange_rate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `exchange_rate` (
2025-02-18 12:38:37 +08:00
`id` int(11) NOT NULL AUTO_INCREMENT,
2025-02-17 23:26:49 +08:00
`points` double(10,2) DEFAULT NULL COMMENT '汇率比例',
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '类型',
`free` int(11) NOT NULL DEFAULT '0' COMMENT '手续费',
`min` int(11) NOT NULL DEFAULT '0' COMMENT '最小提现',
2025-02-18 12:38:37 +08:00
`abbreviation` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '缩写',
2025-02-17 23:26:49 +08:00
PRIMARY KEY (`id`) USING BTREE
2025-02-18 12:38:37 +08:00
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `exchange_rate`
--
LOCK TABLES `exchange_rate` WRITE;
/*!40000 ALTER TABLE `exchange_rate` DISABLE KEYS */;
INSERT INTO `exchange_rate` VALUES (1,1.00,'USDT',0,0,''),(2,2.00,'NGN',0,0,''),(3,3.00,'TRX',0,0,''),(4,4.00,'INR',0,0,'inr'),(5,5.00,'BRL',0,0,'brl'),(6,6.00,'PKR',0,0,'pkr'),(7,1.00,'BDT',0,0,''),(8,2.00,'NRLY',0,0,'');
/*!40000 ALTER TABLE `exchange_rate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `get_code_log`
--
DROP TABLE IF EXISTS `get_code_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `get_code_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
2025-02-18 12:38:37 +08:00
`phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
`code` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '验证码',
2025-02-17 23:26:49 +08:00
`status` int(11) NOT NULL COMMENT '状态0等待回调1已完成3等待上号',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
2025-02-18 12:38:37 +08:00
PRIMARY KEY (`id`) USING BTREE,
KEY `status` (`status`) USING BTREE,
KEY `phone` (`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='获取验证码暂存表';
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `get_code_log`
--
LOCK TABLES `get_code_log` WRITE;
/*!40000 ALTER TABLE `get_code_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `get_code_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message`
--
DROP TABLE IF EXISTS `message`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `message` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`apple` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`createtime` int(11) DEFAULT NULL,
`image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`status_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`updatetime` int(11) DEFAULT NULL,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `message`
--
LOCK TABLES `message` WRITE;
/*!40000 ALTER TABLE `message` DISABLE KEYS */;
INSERT INTO `message` VALUES (2,NULL,1737370611,'<p><img src=\"http://127.0.0.1:8081/uploads/20250120/039faa1fb225ef5814a325218f2e00ee.jpg\" data-filename=\"filename\" style=\"width: 277.516px; height: 275.69px;\"><br></p>','1','Status 1',NULL,'<p><img src=\"https://112233job.com/uploads/20250120/039faa1fb225ef5814a325218f2e00ee.jpg\" data-filename=\"filename\" style=\"width: 277.516px; height: 275.69px;\"><br></p>',0,'Announcement'),(6,'',1732020963,'/uploads/20241119/c817cf8328c739ed87a237394447f573.jpg','1','Status 1','','First-level direct rebate 20%\\r\\n*First-level direct: The registered user through your invitation link is a first-level direct subordinate. You will receive a 20% rebate for the direct subordinate to complete the task. For example, if the direct subordinate completes the task and gets 1,000 points, you will get an additional 200 points.\\r\\nSecond-level subordinate rebate 10%\\r\\n*Second-level subordinates: Registered users invited by your first-level direct subordinates, you will receive 10% rebate for the second-level subordinates to complete tasks. For example, if the second-level subordinates complete tasks and get 1,000 points, you will get an additional 100 points.',NULL,'Agent Notice'),(7,'',1732020998,'/uploads/20241119/0df3c7e105e7565cdb02b23d152d5b7b.jpg','1','Status 1','',NULL,NULL,NULL),(8,'',1732021006,'/uploads/20241119/88acc7638b94f5d2869d3d32e68e57aa.jpg','1','Status 1','',NULL,NULL,NULL),(9,'',1732021014,'/uploads/20241119/895002addbceb4169967599f9f087bb1.jpg','1','Status 1','',NULL,NULL,NULL);
/*!40000 ALTER TABLE `message` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pay`
--
DROP TABLE IF EXISTS `pay`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `pay` (
2025-02-18 12:38:37 +08:00
`id` int(11) NOT NULL AUTO_INCREMENT,
2025-02-17 23:26:49 +08:00
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`status` tinyint(4) NOT NULL,
`type` tinyint(4) NOT NULL,
`createtime` bigint(20) DEFAULT NULL,
`status_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
2025-02-18 12:38:37 +08:00
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pay`
--
LOCK TABLES `pay` WRITE;
/*!40000 ALTER TABLE `pay` DISABLE KEYS */;
INSERT INTO `pay` VALUES (1,'usdt',0,1,0,'Status 0'),(2,'肯尼亚',0,2,0,'Status 0'),(3,'尼日利亚1',0,3,0,'Status 1'),(4,'trx',0,4,0,'Status 0'),(5,'孟加拉国',1,5,0,'Status 1'),(6,'尼日利亚2',0,6,0,'Status 0'),(7,'菲律宾',0,7,0,'Status 0'),(8,'brl',0,8,0,'Status 1');
/*!40000 ALTER TABLE `pay` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `product`
--
DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `product` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`user_count` int(11) NOT NULL,
`first_amount` int(11) DEFAULT '0',
`gift_amount` int(11) NOT NULL,
`createtime` bigint(20) DEFAULT '0',
`type` int(11) DEFAULT NULL,
`code` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `product`
--
LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES (1,'VIP1',5,0,50,0,1,1),(2,'VIP2',100,0,100,0,1,2),(3,'VIP3',1000,0,500,0,1,3),(4,'SVIP',2000,0,5000,0,1,4),(5,'1',3,1500,150,0,2,1),(6,'2',5,4000,380,0,2,2),(7,'3',10,6000,580,0,2,3),(8,'4',20,15000,1080,0,2,4),(9,'5',40,40000,2080,0,2,5),(10,'6',70,75000,3800,0,2,6),(11,'7',200,75000,10800,0,2,7),(12,'8',500,75000,28000,0,2,8),(13,'9',1000,75000,58000,0,2,9);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `signlog`
--
DROP TABLE IF EXISTS `signlog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `signlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL COMMENT '用户id',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime NOT NULL COMMENT '更新时间',
`isexchange` int(11) NOT NULL DEFAULT '0' COMMENT '是否兑换过奖励',
2025-02-18 12:38:37 +08:00
PRIMARY KEY (`id`) USING BTREE,
KEY `userid` (`userid`) USING BTREE,
KEY `created_at` (`created_at`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户签到表';
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `signlog`
--
LOCK TABLES `signlog` WRITE;
/*!40000 ALTER TABLE `signlog` DISABLE KEYS */;
INSERT INTO `signlog` VALUES (1,1,'2025-02-16 10:51:48','2025-02-16 10:51:48',0),(7,2,'2025-02-17 11:29:17','2025-02-17 11:29:17',0);
/*!40000 ALTER TABLE `signlog` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `turntable`
--
DROP TABLE IF EXISTS `turntable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `turntable` (
`id` int(11) NOT NULL,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '赠送金额',
`probability` decimal(5,1) NOT NULL COMMENT '机率',
`stock_num` int(11) NOT NULL COMMENT '库存',
`createtime` bigint(20) NOT NULL,
`updatetime` bigint(20) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `turntable`
--
LOCK TABLES `turntable` WRITE;
/*!40000 ALTER TABLE `turntable` DISABLE KEYS */;
INSERT INTO `turntable` VALUES (1,'1','1.00',76.0,884766,1687242454,1738845729),(2,'2','200.00',0.1,99782,1687242454,1738844305),(3,'2','20.00',26.1,0,1687242454,1735999260),(4,'3','10.00',4.6,68560,1687242454,1738844689),(5,'4','300.00',0.1,99805,1687242454,1738751176),(6,'5','188.00',0.1,99790,1687242454,1738826817),(7,'6','888.00',0.0,99999,1687242454,1736413208),(8,'6','5000.00',0.0,99999,1687242454,1736413202);
/*!40000 ALTER TABLE `turntable` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_phone`
--
DROP TABLE IF EXISTS `user_phone`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `user_phone` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户记录的唯一标识符',
`user_id` int(11) NOT NULL COMMENT '用户的唯一ID标识符',
2025-02-18 12:38:37 +08:00
`phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户手机号WS手机号',
2025-02-17 23:26:49 +08:00
`score` int(11) NOT NULL DEFAULT '0' COMMENT '用户积分',
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '当前在线状态1: 在线0: 不在线)',
`time` int(11) NOT NULL DEFAULT '0' COMMENT '用户在线时长(单位:秒)',
2025-02-18 12:38:37 +08:00
`remark` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户备注信息',
2025-02-17 23:26:49 +08:00
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`last_time` bigint(20) NOT NULL DEFAULT '0',
2025-02-18 12:38:37 +08:00
PRIMARY KEY (`id`) USING BTREE,
KEY `phone` (`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户ws信息表';
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_phone`
--
LOCK TABLES `user_phone` WRITE;
/*!40000 ALTER TABLE `user_phone` DISABLE KEYS */;
2025-02-18 12:38:37 +08:00
INSERT INTO `user_phone` VALUES (24,1,'601162155089',440,1,300,NULL,'2025-02-17 12:25:42','2025-02-18 12:37:02',1739853420),(29,1,'601162168710',260,1,2222,NULL,'2025-02-17 23:17:57','2025-02-18 12:37:03',1739853422);
2025-02-17 23:26:49 +08:00
/*!40000 ALTER TABLE `user_phone` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_phone_log`
--
DROP TABLE IF EXISTS `user_phone_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `user_phone_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
2025-02-18 12:38:37 +08:00
`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
2025-02-17 23:26:49 +08:00
`created_at` timestamp NOT NULL COMMENT '创建时间',
`updated_at` timestamp NOT NULL COMMENT '更新时间',
`time` int(11) NOT NULL COMMENT '在线时长单位秒',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否在线1: 在线0: 不在线)',
2025-02-18 12:38:37 +08:00
PRIMARY KEY (`id`,`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户手机号在线日志';
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_phone_log`
--
LOCK TABLES `user_phone_log` WRITE;
/*!40000 ALTER TABLE `user_phone_log` DISABLE KEYS */;
2025-02-18 12:38:37 +08:00
INSERT INTO `user_phone_log` VALUES (6,'601162155089','2025-02-17 14:33:02','2025-02-17 14:33:02',0,1),(7,'601162155089','2025-02-17 14:34:02','2025-02-17 14:34:02',58,1),(8,'601162155089','2025-02-17 14:35:02','2025-02-17 14:35:02',58,1),(9,'601162155089','2025-02-17 14:36:02','2025-02-17 14:36:02',58,1),(10,'601162155089','2025-02-17 14:37:02','2025-02-17 14:37:02',58,1),(11,'601162155089','2025-02-17 14:38:03','2025-02-17 14:38:03',58,1),(12,'601162155089','2025-02-17 14:39:03','2025-02-17 14:39:03',57,1),(13,'601162155089','2025-02-17 14:40:02','2025-02-17 14:40:02',57,1),(14,'601162155089','2025-02-17 14:41:02','2025-02-17 14:41:02',58,1),(15,'601162155089','2025-02-17 14:42:02','2025-02-17 14:42:02',58,1),(16,'601162155089','2025-02-17 14:43:02','2025-02-17 14:43:02',58,1),(17,'601162155089','2025-02-17 14:44:02','2025-02-17 14:44:02',58,1),(18,'601162155089','2025-02-17 14:45:02','2025-02-17 14:45:02',58,1),(19,'601162155089','2025-02-17 14:46:03','2025-02-17 14:46:03',59,1),(20,'601162155089','2025-02-17 14:47:02','2025-02-17 14:47:02',57,1),(21,'601162155089','2025-02-17 14:48:02','2025-02-17 14:48:02',58,1),(22,'601162155089','2025-02-17 14:49:03','2025-02-17 14:49:03',58,1),(23,'601162155089','2025-02-17 14:50:02','2025-02-17 14:50:02',57,1),(24,'601162155089','2025-02-17 15:04:03','2025-02-17 15:04:03',838,1),(25,'601162155089','2025-02-17 15:05:03','2025-02-17 15:05:03',57,1),(26,'601162155089','2025-02-17 15:06:02','2025-02-17 15:06:02',57,1),(27,'601162155089','2025-02-17 15:07:02','2025-02-17 15:07:02',58,1),(28,'601162155089','2025-02-17 15:08:03','2025-02-17 15:08:03',58,1),(29,'601162155089','2025-02-17 15:09:03','2025-02-17 15:09:03',57,1),(30,'601162155089','2025-02-17 15:10:02','2025-02-17 15:10:02',57,1),(31,'601162155089','2025-02-17 15:11:02','2025-02-17 15:11:02',58,1),(32,'601162155089','2025-02-17 15:12:02','2025-02-17 15:12:02',58,1),(33,'601162155089','2025-02-17 15:13:02','2025-02-17 15:13:02',58,1),(34,'601162155089','2025-02-17 15:14:04','2025-02-17 15:14:04',58,1),(35,'601162155089','2025-02-17 15:15:02','2025-02-17 15:15:02',56,1),(36,'601162155089','2025-02-17 15:16:02','2025-02-17 15:16:02',58,1),(37,'601162155089','2025-02-17 15:17:03','2025-02-17 15:17:03',58,1),(38,'601162155089','2025-02-17 15:18:02','2025-02-17 15:18:02',57,1),(39,'601162168710','2025-02-17 15:18:03','2025-02-17 15:18:03',0,1),(40,'601162155089','2025-02-17 15:19:02','2025-02-17 15:19:02',58,1),(41,'601162168710','2025-02-17 15:19:04','2025-02-17 15:19:04',59,1),(42,'601162155089','2025-02-17 15:20:02','2025-02-17 15:20:02',58,1),(43,'601162168710','2025-02-17 15:20:04','2025-02-17 15:20:04',58,1),(44,'601162155089','2025-02-17 15:21:01','2025-02-17 15:21:01',58,1),(45,'601162168710','2025-02-17 15:21:03','2025-02-17 15:21:03',57,1),(46,'601162155089','2025-02-17 15:23:02','2025-02-17 15:23:02',119,1),(47,'601162168710','2025-02-17 15:23:04','2025-02-17 15:23:04',119,1),(48,'601162155089','2025-02-17 15:24:02','2025-02-17 15:24:02',58,1),(49,'601162168710','2025-02-17 15:24:04','2025-02-17 15:24:04',59,1),(50,'601162155089','2025-02-17 15:25:03','2025-02-17 15:25:03',58,1),(51,'601162168710','2025-02-17 15:25:06','2025-02-17 15:25:06',59,1),(52,'601162155089','2025-02-17 15:26:02','2025-02-17 15:26:02',57,1),(53,'601162155089','2025-02-18 04:09:01','2025-02-18 04:09:01',0,1),(54,'601162168710','2025-02-18 04:09:03','2025-02-18 04:09:03',0,1),(55,'601162155089','2025-02-18 04:10:02','2025-02-18 04:10:02',59,1),(56,'601162168710','2025-02-18 04:10:04','2025-02-18 04:10:04',59,1),(57,'601162155089','2025-02-18 04:11:01','2025-02-18 04:11:01',58,1),(58,'601162168710','2025-02-18 04:11:03','2025-02-18 04:11:03',57,1),(59,'601162155089','2025-02-18 04:12:02','2025-02-18 04:12:02',59,1),(60,'601162168710','2025-02-18 04:12:03','2025-02-18 04:12:03',59,1),(61,'601162155089','2025-02-18 04:13:01','2025-02-18 04:13:01',58,1),(62,'601162168710','2025-02-18 04:13:03','2025-02-18 04:13:03',58,1),(63,'601162155089','2025-02-18 04:14:02','2025-02-18 04:14:02',59,1),(64,'601162168710','2025-02-18 04:14:03','2025-02-18 04:14:03'
2025-02-17 23:26:49 +08:00
/*!40000 ALTER TABLE `user_phone_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_rewards`
--
DROP TABLE IF EXISTS `user_rewards`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `user_rewards` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '奖励记录的唯一标识符',
`user_id` int(11) NOT NULL COMMENT '用户ID',
`order_id` int(11) DEFAULT '0' COMMENT '关联订单ID若无则为0',
2025-02-18 12:38:37 +08:00
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名称(如手机号码)',
2025-02-17 23:26:49 +08:00
`money` decimal(10,2) NOT NULL COMMENT '奖励金额',
`before` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '操作前的余额',
`after` decimal(10,2) NOT NULL COMMENT '操作后的余额',
2025-02-18 12:38:37 +08:00
`memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '奖励类型或备注信息',
2025-02-17 23:26:49 +08:00
`status` int(11) NOT NULL COMMENT '操作状态,标识当前记录的状态(如成功、失败等)',
2025-02-18 12:38:37 +08:00
`uu_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户唯一标识符',
`admin_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '管理员名称(如果管理员操作)',
2025-02-17 23:26:49 +08:00
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
2025-02-18 12:38:37 +08:00
`createtime2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_rewards`
--
LOCK TABLES `user_rewards` WRITE;
/*!40000 ALTER TABLE `user_rewards` DISABLE KEYS */;
2025-02-18 12:38:37 +08:00
INSERT INTO `user_rewards` VALUES (40,1,0,'1',20.00,0.00,20.00,'挂机收益',6,'1',NULL,'2025-02-16 21:13:02','2025-02-16 21:13:02','2025-02-16 21:13:02'),(41,3,0,'2',4.00,0.00,4.00,'加粉赏金',5,'70203',NULL,'2025-02-16 21:57:03','2025-02-16 21:57:03','2025-02-16 21:57:03'),(42,4,0,'3',2.00,0.00,2.00,'加粉赏金',5,'06192',NULL,'2025-02-16 21:57:04','2025-02-16 21:57:04','2025-02-16 21:57:03'),(43,1,0,'1',20.00,20.00,40.00,'挂机收益',6,'1',NULL,'2025-02-16 21:57:04','2025-02-16 21:57:04','2025-02-16 21:57:04'),(44,3,0,'2',4.00,4.00,8.00,'加粉赏金',5,'70203',NULL,'2025-02-16 22:56:03','2025-02-16 22:56:03','2025-02-16 22:56:03'),(45,4,0,'3',2.00,2.00,4.00,'加粉赏金',5,'06192',NULL,'2025-02-16 22:56:03','2025-02-16 22:56:03','2025-02-16 22:56:03'),(46,1,0,'1',20.00,40.00,60.00,'挂机收益',6,'1',NULL,'2025-02-16 22:56:03','2025-02-16 22:56:03','2025-02-16 22:56:03'),(47,3,0,'2',40.00,8.00,48.00,'加粉赏金',5,'70203',NULL,'2025-02-17 09:34:05','2025-02-17 09:34:05','2025-02-17 09:34:05'),(48,4,0,'3',20.00,4.00,24.00,'加粉赏金',5,'06192',NULL,'2025-02-17 09:34:05','2025-02-17 09:34:05','2025-02-17 09:34:05'),(49,1,0,'1',200.00,60.00,260.00,'挂机收益',6,'1',NULL,'2025-02-17 09:34:05','2025-02-17 09:34:05','2025-02-17 09:34:05'),(50,3,0,'2',4.00,48.00,52.00,'加粉赏金',5,'70203',NULL,'2025-02-17 09:56:00','2025-02-17 09:56:00','2025-02-17 09:56:00'),(51,4,0,'3',2.00,24.00,26.00,'加粉赏金',5,'06192',NULL,'2025-02-17 09:56:00','2025-02-17 09:56:00','2025-02-17 09:56:00'),(52,1,0,'1',20.00,260.00,280.00,'挂机收益',6,'1',NULL,'2025-02-17 09:56:01','2025-02-17 09:56:01','2025-02-17 09:56:01'),(53,4,0,'3',-10.00,26.00,16.00,'抽奖',9,'06192',NULL,'2025-02-17 10:46:58','2025-02-17 10:46:58','2025-02-17 10:46:57'),(54,4,0,'3',1.00,16.00,17.00,'中奖',8,'06192',NULL,'2025-02-17 10:46:58','2025-02-17 10:46:58','2025-02-17 10:46:58'),(55,4,0,'3',-10.00,17.00,7.00,'抽奖',9,'06192',NULL,'2025-02-17 10:47:07','2025-02-17 10:47:07','2025-02-17 10:47:07'),(56,4,0,'3',1.00,7.00,8.00,'中奖',8,'06192',NULL,'2025-02-17 10:47:07','2025-02-17 10:47:07','2025-02-17 10:47:07'),(57,3,0,'2',4.00,52.00,56.00,'加粉赏金',5,'70203',NULL,'2025-02-17 10:57:03','2025-02-17 10:57:03','2025-02-17 10:57:02'),(58,4,0,'3',2.00,8.00,10.00,'加粉赏金',5,'06192',NULL,'2025-02-17 10:57:03','2025-02-17 10:57:03','2025-02-17 10:57:03'),(59,1,0,'1',20.00,280.00,300.00,'挂机收益',6,'1',NULL,'2025-02-17 10:57:03','2025-02-17 10:57:03','2025-02-17 10:57:03'),(60,1,0,'1',17.00,300.00,317.00,'加粉赏金',5,'1',NULL,'2025-02-17 11:13:08','2025-02-17 11:13:08','2025-02-17 11:13:08'),(61,3,0,'2',8.00,56.00,64.00,'加粉赏金',5,'70203',NULL,'2025-02-17 11:13:09','2025-02-17 11:13:09','2025-02-17 11:13:08'),(62,7,0,'4',88.00,0.00,88.00,'注册赠送',4,'72644',NULL,'2025-02-17 11:13:09','2025-02-17 11:13:09','2025-02-17 11:13:09'),(63,1,0,'1',-10.00,317.00,307.00,'抽奖',9,'1',NULL,'2025-02-17 11:55:16','2025-02-17 11:55:16','2025-02-17 11:55:16'),(64,1,0,'1',1.00,307.00,308.00,'中奖',8,'1',NULL,'2025-02-17 11:55:16','2025-02-17 11:55:16','2025-02-17 11:55:16'),(65,3,0,'2',4.00,64.00,68.00,'加粉赏金',5,'70203',NULL,'2025-02-17 11:57:11','2025-02-17 11:57:11','2025-02-17 11:57:11'),(66,4,0,'3',2.00,10.00,12.00,'加粉赏金',5,'06192',NULL,'2025-02-17 11:57:11','2025-02-17 11:57:11','2025-02-17 11:57:11'),(67,1,0,'1',20.00,308.00,328.00,'挂机收益',6,'1',NULL,'2025-02-17 11:57:11','2025-02-17 11:57:11','2025-02-17 11:57:11'),(68,3,0,'2',4.00,68.00,72.00,'加粉赏金',5,'70203',NULL,'2025-02-17 12:59:08','2025-02-17 12:59:08','2025-02-17 12:59:08'),(69,4,0,'3',2.00,12.00,14.00,'加粉赏金',5,'06192',NULL,'2025-02-17 12:59:08','2025-02-17 12:59:08','2025-02-17 12:59:08'),(70,1,0,'1',20.00,328.00,348.00,'挂机收益',6,'1',NULL,'2025-02-17 12:59:08','2025-02-17 12:59:08','2025-02-17 12:59:08'),(71,3,0,'2',20.00,72.00,92.00,'加粉赏金',5,'70203',NULL,'2025-02-17 19:25:11','2025-02-17 19:25:11','2025-02-17 19:25:11'),(72,4,0,'3',10.00,14.00,24.00,'加粉赏金',5,'06192',NULL,'2025-02-17 19:25:11','2025-02
2025-02-17 23:26:49 +08:00
/*!40000 ALTER TABLE `user_rewards` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `userbank`
--
DROP TABLE IF EXISTS `userbank`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `userbank` (
2025-02-18 12:38:37 +08:00
`id` bigint(20) NOT NULL AUTO_INCREMENT,
2025-02-17 23:26:49 +08:00
`user_id` bigint(20) NOT NULL,
`account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`bank_username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`type` tinyint(4) NOT NULL,
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`createtime` bigint(20) DEFAULT NULL,
`updatetime` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
2025-02-18 12:38:37 +08:00
) ENGINE=InnoDB AUTO_INCREMENT=1890227411799285764 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `userbank`
--
LOCK TABLES `userbank` WRITE;
/*!40000 ALTER TABLE `userbank` DISABLE KEYS */;
2025-02-18 12:38:37 +08:00
INSERT INTO `userbank` VALUES (1890227411799285762,2075840533,'111','INEB','asss',5,'333',NULL,NULL),(1890227411799285763,1,'1','Nagad','ad',5,'',NULL,NULL);
2025-02-17 23:26:49 +08:00
/*!40000 ALTER TABLE `userbank` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
`invite_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邀请码',
`is_active` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否激活 (0:未激活, 1:已激活)',
`login_ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '最后登录IP',
`join_ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '注册IP',
`login_time` int(11) DEFAULT NULL COMMENT '最后登录时间 (Unix时间戳)',
`prev_time` int(11) DEFAULT NULL COMMENT '上次活动时间 (Unix时间戳)',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 (1: 正常, 0: 禁用)',
`money` int(11) NOT NULL DEFAULT '0' COMMENT '账户积分',
`admin_money` int(11) NOT NULL DEFAULT '0' COMMENT '管理员账户积分',
`all_team_money` int(11) NOT NULL DEFAULT '0' COMMENT '团队总积分',
`task_income_money` int(11) NOT NULL DEFAULT '0' COMMENT '任务收入积分',
`task_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '任务状态 (0: 未完成, 1: 完成)',
`today_task_income` int(11) NOT NULL DEFAULT '0' COMMENT '今天的任务收入',
`today_team_income` int(11) NOT NULL DEFAULT '0' COMMENT '今天的团队收入',
`growth_value` int(11) NOT NULL DEFAULT '0' COMMENT '成长值',
`vip_id` int(11) NOT NULL DEFAULT '0' COMMENT 'VIP等级ID',
`withdraw_money` int(11) NOT NULL DEFAULT '0' COMMENT '可提现积分',
`f_id` int(11) NOT NULL DEFAULT '0' COMMENT '上一级用户ID',
`ff_id` int(11) NOT NULL DEFAULT '0' COMMENT '上上级用户ID',
`fff_id` int(11) NOT NULL DEFAULT '0' COMMENT '上上上级用户ID',
`top_id` int(11) NOT NULL DEFAULT '0' COMMENT '最高层级ID',
`path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '用户路径',
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '备注',
`created_at` datetime NOT NULL COMMENT '创建时间 (Unix时间戳)',
`updated_at` datetime NOT NULL COMMENT '更新时间 (Unix时间戳)',
2025-02-18 12:38:37 +08:00
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
`today_num` int(11) NOT NULL DEFAULT '0' COMMENT '今天有效人数',
2025-02-17 23:26:49 +08:00
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `invite_code` (`invite_code`) USING BTREE,
2025-02-18 12:38:37 +08:00
UNIQUE KEY `username` (`username`) USING BTREE,
KEY `username_2` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户信息表';
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
2025-02-18 12:38:37 +08:00
INSERT INTO `users` VALUES (1,'1','1',0,'192.168.2.143','192.168.2.143',1739791026,NULL,1,9650719,0,0,0,0,0,0,0,0,0,3,4,0,0,NULL,NULL,'2025-02-15 22:26:46','2025-02-18 12:35:40','$2y$10$THGKpTq2.0GTL6W9LB.2zu1UD8IRAxMNBwkbiwmZudGWntzm9L80q',0),(3,'2','70203',0,NULL,'192.168.2.143',NULL,NULL,1,1933328,0,0,0,0,0,0,0,0,0,3,0,0,0,NULL,NULL,'2025-02-15 22:36:56','2025-02-18 12:34:02','$2y$10$dNxa/.CkhOIHRl74h5lFSuGwTH21S/Efj0XY20txqQHP0ZiGtLdDe',0),(4,'3','06192',0,'192.168.2.143','192.168.2.143',1739759552,NULL,1,966642,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,'2025-02-15 22:38:09','2025-02-18 12:34:02','$2y$10$JZ9VbFzsN2ZPoKSuE/4G8OvL.PqnaaIRsyfrp5sPG4uhZnlmjFK8e',0),(7,'4','72644',0,'192.168.2.143','192.168.2.143',1739761992,NULL,1,88,0,0,0,0,0,0,0,0,0,1,3,0,0,NULL,NULL,'2025-02-17 11:13:08','2025-02-17 11:13:12','$2y$10$.DwmuSQNKUs77tEgj/jyaunyZhMSOc3yIksDC6Ijd.07QWY5MHx4y',0);
2025-02-17 23:26:49 +08:00
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vip`
--
DROP TABLE IF EXISTS `vip`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `vip` (
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`id` int(11) NOT NULL,
`status` int(11) NOT NULL,
`user_count` int(11) NOT NULL,
`dollar_user_count` int(11) NOT NULL,
`vip_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vip`
--
LOCK TABLES `vip` WRITE;
/*!40000 ALTER TABLE `vip` DISABLE KEYS */;
INSERT INTO `vip` VALUES ('1',1,0,5,0,1),('1',2,0,100,0,2),('1',3,0,1000,0,3),('1',4,0,2000,0,4),('2',5,0,3,0,1),('2',6,0,5,0,2),('2',7,0,10,0,3),('2',8,0,20,0,4),('2',9,0,40,0,5),('2',10,0,70,0,6),('2',11,0,200,0,7),('2',12,0,500,0,8),('2',13,0,1000,0,9);
/*!40000 ALTER TABLE `vip` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `vip_levels`
--
DROP TABLE IF EXISTS `vip_levels`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `vip_levels` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'VIP级别的唯一标识符',
2025-02-18 12:38:37 +08:00
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'VIP级别的名称',
2025-02-17 23:26:49 +08:00
`user_count` int(11) NOT NULL COMMENT 'VIP级别的用户数量',
`first_amount` int(11) NOT NULL COMMENT '首次充值积分',
`gift_amount` int(11) NOT NULL COMMENT '赠送积分',
`createtime` int(11) NOT NULL COMMENT '创建时间(时间戳)',
2025-02-18 12:38:37 +08:00
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
2025-02-17 23:26:49 +08:00
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `vip_levels`
--
LOCK TABLES `vip_levels` WRITE;
/*!40000 ALTER TABLE `vip_levels` DISABLE KEYS */;
INSERT INTO `vip_levels` VALUES (1,'VIP1',5,0,50,0),(2,'VIP2',100,0,100,0),(3,'VIP3',1000,0,500,0),(4,'SVIP',2000,0,5000,0);
/*!40000 ALTER TABLE `vip_levels` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wa_admin_roles`
--
DROP TABLE IF EXISTS `wa_admin_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `wa_admin_roles` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`role_id` int(11) NOT NULL COMMENT '角色id',
`admin_id` int(11) NOT NULL COMMENT '管理员id',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `role_admin_id` (`role_id`,`admin_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='管理员角色表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wa_admin_roles`
--
LOCK TABLES `wa_admin_roles` WRITE;
/*!40000 ALTER TABLE `wa_admin_roles` DISABLE KEYS */;
INSERT INTO `wa_admin_roles` VALUES (1,1,1);
/*!40000 ALTER TABLE `wa_admin_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wa_admins`
--
DROP TABLE IF EXISTS `wa_admins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `wa_admins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
`nickname` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '昵称',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '/app/admin/avatar.png' COMMENT '头像',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '邮箱',
`mobile` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '手机',
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '更新时间',
`login_at` datetime DEFAULT NULL COMMENT '登录时间',
`status` tinyint(4) DEFAULT NULL COMMENT '禁用',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='管理员表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wa_admins`
--
LOCK TABLES `wa_admins` WRITE;
/*!40000 ALTER TABLE `wa_admins` DISABLE KEYS */;
INSERT INTO `wa_admins` VALUES (1,'lingling','超级管理员','$2y$10$icdjAC/aax268bEMzavzUel0qRdMeW7AbBjfgHlwO.WGjajmYgss.','/app/admin/avatar.png',NULL,NULL,'2025-01-02 09:20:28','2025-02-05 16:38:51','2025-02-05 16:38:51',NULL);
/*!40000 ALTER TABLE `wa_admins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wa_options`
--
DROP TABLE IF EXISTS `wa_options`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `wa_options` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '',
`value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '',
`created_at` datetime NOT NULL DEFAULT '2022-08-15 00:00:00' COMMENT '创建时间',
`updated_at` datetime NOT NULL DEFAULT '2022-08-15 00:00:00' COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='选项表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wa_options`
--
LOCK TABLES `wa_options` WRITE;
/*!40000 ALTER TABLE `wa_options` DISABLE KEYS */;
INSERT INTO `wa_options` VALUES (1,'system_config','{\"logo\":{\"title\":\"Webman Admin\",\"image\":\"\\/app\\/admin\\/admin\\/images\\/logo.png\"},\"menu\":{\"data\":\"\\/app\\/admin\\/rule\\/get\",\"method\":\"GET\",\"accordion\":true,\"collapse\":false,\"control\":false,\"controlWidth\":500,\"select\":\"0\",\"async\":true},\"tab\":{\"enable\":true,\"keepState\":true,\"preload\":false,\"session\":true,\"max\":\"30\",\"index\":{\"id\":\"0\",\"href\":\"\\/app\\/admin\\/index\\/dashboard\",\"title\":\"\\u4eea\\u8868\\u76d8\"}},\"theme\":{\"defaultColor\":\"2\",\"defaultMenu\":\"light-theme\",\"defaultHeader\":\"light-theme\",\"allowCustom\":true,\"banner\":false},\"colors\":[{\"id\":\"1\",\"color\":\"#36b368\",\"second\":\"#f0f9eb\"},{\"id\":\"2\",\"color\":\"#2d8cf0\",\"second\":\"#ecf5ff\"},{\"id\":\"3\",\"color\":\"#f6ad55\",\"second\":\"#fdf6ec\"},{\"id\":\"4\",\"color\":\"#f56c6c\",\"second\":\"#fef0f0\"},{\"id\":\"5\",\"color\":\"#3963bc\",\"second\":\"#ecf5ff\"}],\"other\":{\"keepLoad\":\"500\",\"autoHead\":false,\"footer\":false},\"header\":{\"message\":false}}','2022-12-05 14:49:01','2022-12-08 20:20:28'),(2,'table_form_schema_wa_users','{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false},\"username\":{\"field\":\"username\",\"_field_id\":\"1\",\"comment\":\"用户名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"nickname\":{\"field\":\"nickname\",\"_field_id\":\"2\",\"comment\":\"昵称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"password\":{\"field\":\"password\",\"_field_id\":\"3\",\"comment\":\"密码\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"sex\":{\"field\":\"sex\",\"_field_id\":\"4\",\"comment\":\"性别\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/dict\\/get\\/sex\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"avatar\":{\"field\":\"avatar\",\"_field_id\":\"5\",\"comment\":\"头像\",\"control\":\"uploadImage\",\"control_args\":\"url:\\/app\\/admin\\/upload\\/avatar\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"email\":{\"field\":\"email\",\"_field_id\":\"6\",\"comment\":\"邮箱\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"mobile\":{\"field\":\"mobile\",\"_field_id\":\"7\",\"comment\":\"手机\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"level\":{\"field\":\"level\",\"_field_id\":\"8\",\"comment\":\"等级\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"birthday\":{\"field\":\"birthday\",\"_field_id\":\"9\",\"comment\":\"生日\",\"control\":\"datePicker\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false},\"money\":{\"field\":\"money\",\"_field_id\":\"10\",\"comment\":\"余额(元)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"score\":{\"field\":\"score\",\"_field_id\":\"11\",\"comment\":\"积分\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"last_time\":{\"field\":\"last_time\",\"_field_id\":\"12\",\"comment\":\
/*!40000 ALTER TABLE `wa_options` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wa_roles`
--
DROP TABLE IF EXISTS `wa_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `wa_roles` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色组',
`rules` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '权限',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime NOT NULL COMMENT '更新时间',
`pid` int(10) unsigned DEFAULT NULL COMMENT '父级',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='管理员角色';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wa_roles`
--
LOCK TABLES `wa_roles` WRITE;
/*!40000 ALTER TABLE `wa_roles` DISABLE KEYS */;
INSERT INTO `wa_roles` VALUES (1,'超级管理员','*','2022-08-13 16:15:01','2022-12-23 12:05:07',NULL);
/*!40000 ALTER TABLE `wa_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wa_rules`
--
DROP TABLE IF EXISTS `wa_rules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `wa_rules` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标题',
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '图标',
`key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标识',
`pid` int(10) unsigned DEFAULT '0' COMMENT '上级菜单',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime NOT NULL COMMENT '更新时间',
`href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'url',
`type` int(11) NOT NULL DEFAULT '1' COMMENT '类型',
`weight` int(11) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='权限规则';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wa_rules`
--
LOCK TABLES `wa_rules` WRITE;
/*!40000 ALTER TABLE `wa_rules` DISABLE KEYS */;
INSERT INTO `wa_rules` VALUES (1,'数据库','layui-icon-template-1','database',0,'2025-01-02 09:20:14','2025-01-02 09:20:14',NULL,0,1000),(2,'所有表',NULL,'plugin\\admin\\app\\controller\\TableController',1,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/table/index',1,800),(3,'权限管理','layui-icon-vercode','auth',0,'2025-01-02 09:20:14','2025-01-02 09:20:14',NULL,0,900),(4,'账户管理',NULL,'plugin\\admin\\app\\controller\\AdminController',3,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/admin/index',1,1000),(5,'角色管理',NULL,'plugin\\admin\\app\\controller\\RoleController',3,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/role/index',1,900),(6,'菜单管理',NULL,'plugin\\admin\\app\\controller\\RuleController',3,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/rule/index',1,800),(7,'会员管理','layui-icon-username','user',0,'2025-01-02 09:20:14','2025-01-02 09:20:14',NULL,0,800),(8,'用户管理','layui-icon-username','plugin\\admin\\app\\controller\\UserController',134,'2025-01-02 09:20:14','2025-01-05 16:53:03','/app/admin/user/index',1,800),(9,'通用设置','layui-icon-set','common',0,'2025-01-02 09:20:14','2025-01-02 09:20:14',NULL,0,700),(10,'个人资料',NULL,'plugin\\admin\\app\\controller\\AccountController',9,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/account/index',1,800),(11,'附件管理',NULL,'plugin\\admin\\app\\controller\\UploadController',9,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/upload/index',1,700),(12,'字典设置',NULL,'plugin\\admin\\app\\controller\\DictController',9,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/dict/index',1,600),(13,'系统设置',NULL,'plugin\\admin\\app\\controller\\ConfigController',9,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/config/index',1,500),(14,'插件管理','layui-icon-app','plugin',0,'2025-01-02 09:20:14','2025-01-02 09:20:14',NULL,0,600),(15,'应用插件',NULL,'plugin\\admin\\app\\controller\\PluginController',14,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/plugin/index',1,800),(16,'开发辅助','layui-icon-fonts-code','dev',0,'2025-01-02 09:20:14','2025-01-02 09:20:14',NULL,0,500),(17,'表单构建',NULL,'plugin\\admin\\app\\controller\\DevController',16,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/dev/form-build',1,800),(18,'示例页面','layui-icon-templeate-1','demos',0,'2025-01-02 09:20:14','2025-01-02 09:20:14',NULL,0,400),(19,'工作空间','layui-icon-console','demo1',18,'2025-01-02 09:20:14','2025-01-02 09:20:14','',0,0),(20,'控制后台','layui-icon-console','demo10',19,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/console/console1.html',1,0),(21,'数据分析','layui-icon-console','demo13',19,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/console/console2.html',1,0),(22,'百度一下','layui-icon-console','demo14',19,'2025-01-02 09:20:14','2025-01-02 09:20:14','http://www.baidu.com',1,0),(23,'主题预览','layui-icon-console','demo15',19,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/system/theme.html',1,0),(24,'常用组件','layui-icon-component','demo20',18,'2025-01-02 09:20:14','2025-01-02 09:20:14','',0,0),(25,'功能按钮','layui-icon-face-smile','demo2011',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/button.html',1,0),(26,'表单集合','layui-icon-face-cry','demo2014',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/form.html',1,0),(27,'字体图标','layui-icon-face-cry','demo2010',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/icon.html',1,0),(28,'多选下拉','layui-icon-face-cry','demo2012',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/select.html',1,0),(29,'动态标签','layui-icon-face-cry','demo2013',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/tag.html',1,0),(30,'数据表格','layui-icon-face-cry','demo2031',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/table.html',1,0),(31,'分布表单','lay
/*!40000 ALTER TABLE `wa_rules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wa_uploads`
--
DROP TABLE IF EXISTS `wa_uploads`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `wa_uploads` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '文件',
`admin_id` int(11) DEFAULT NULL COMMENT '管理员',
`file_size` int(11) NOT NULL COMMENT '文件大小',
`mime_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'mime类型',
`image_width` int(11) DEFAULT NULL COMMENT '图片宽度',
`image_height` int(11) DEFAULT NULL COMMENT '图片高度',
`ext` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '扩展名',
`storage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'local' COMMENT '存储位置',
`created_at` date DEFAULT NULL COMMENT '上传时间',
`category` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '类别',
`updated_at` date DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `category` (`category`) USING BTREE,
KEY `admin_id` (`admin_id`) USING BTREE,
KEY `name` (`name`) USING BTREE,
KEY `ext` (`ext`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='附件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wa_uploads`
--
LOCK TABLES `wa_uploads` WRITE;
/*!40000 ALTER TABLE `wa_uploads` DISABLE KEYS */;
INSERT INTO `wa_uploads` VALUES (1,'880.jpg','/app/admin/upload/files/20250103/677798c678bb.jpg',1,342769,'image/jpeg',880,1320,'jpg','local','2025-01-03','1','2025-01-03');
/*!40000 ALTER TABLE `wa_uploads` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wa_users`
--
DROP TABLE IF EXISTS `wa_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `wa_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
`nickname` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '昵称',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
`sex` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1' COMMENT '性别',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '头像',
`email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '邮箱',
`mobile` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '手机',
`level` tinyint(4) NOT NULL DEFAULT '0' COMMENT '等级',
`birthday` date DEFAULT NULL COMMENT '生日',
`money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额(元)',
`score` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
`last_time` datetime DEFAULT NULL COMMENT '登录时间',
`last_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '登录ip',
`join_time` datetime DEFAULT NULL COMMENT '注册时间',
`join_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '注册ip',
`token` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'token',
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '更新时间',
`role` int(11) NOT NULL DEFAULT '1' COMMENT '角色',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '禁用',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `username` (`username`) USING BTREE,
KEY `join_time` (`join_time`) USING BTREE,
KEY `mobile` (`mobile`) USING BTREE,
KEY `email` (`email`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wa_users`
--
LOCK TABLES `wa_users` WRITE;
/*!40000 ALTER TABLE `wa_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `wa_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `withdraw`
--
DROP TABLE IF EXISTS `withdraw`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `withdraw` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`money` bigint(20) NOT NULL,
`status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`createtime2` datetime DEFAULT NULL,
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
2025-02-18 12:38:37 +08:00
`status_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
2025-02-17 23:26:49 +08:00
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1890251748031934466 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `withdraw`
--
LOCK TABLES `withdraw` WRITE;
/*!40000 ALTER TABLE `withdraw` DISABLE KEYS */;
2025-02-18 12:38:37 +08:00
INSERT INTO `withdraw` VALUES (1,1,10000,'2','2025-02-07 10:00:00',NULL,'已到账'),(2,1,200,'1','2025-02-28 11:17:09','cs','申请中'),(3,1,7000,'1','2025-02-14 12:08:31','1','申请中');
2025-02-17 23:26:49 +08:00
/*!40000 ALTER TABLE `withdraw` 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 */;
2025-02-18 12:38:37 +08:00
-- Dump completed on 2025-02-18 12:37:48