759 lines
125 KiB
SQL
759 lines
125 KiB
SQL
-- 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` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`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 '最小提现',
|
||
`abbreviation` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '缩写',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
||
/*!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,
|
||
`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 '验证码',
|
||
`status` int(11) NOT NULL COMMENT '状态0等待回调1已完成3等待上号',
|
||
`created_at` datetime NOT NULL,
|
||
`updated_at` datetime NOT NULL,
|
||
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='获取验证码暂存表';
|
||
/*!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` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`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
|
||
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
||
/*!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 '是否兑换过奖励',
|
||
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='用户签到表';
|
||
/*!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标识符',
|
||
`phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户手机号（WS手机号）',
|
||
`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 '用户在线时长（单位：秒）',
|
||
`remark` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户备注信息',
|
||
`created_at` datetime NOT NULL,
|
||
`updated_at` datetime NOT NULL,
|
||
`last_time` bigint(20) NOT NULL DEFAULT '0',
|
||
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信息表';
|
||
/*!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 */;
|
||
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);
|
||
/*!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,
|
||
`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
|
||
`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: 不在线）',
|
||
PRIMARY KEY (`id`,`phone`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户手机号在线日志';
|
||
/*!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 */;
|
||
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',59,1),(65,'601162155089','2025-02-18 04:15:02','2025-02-18 04:15:02',58,1),(66,'601162168710','2025-02-18 04:15:03','2025-02-18 04:15:03',59,1),(67,'601162155089','2025-02-18 04:16:02','2025-02-18 04:16:02',58,1),(68,'601162168710','2025-02-18 04:16:03','2025-02-18 04:16:03',59,1),(69,'601162155089','2025-02-18 04:17:01','2025-02-18 04:17:01',58,1),(70,'601162168710','2025-02-18 04:17:03','2025-02-18 04:17:03',59,1),(71,'601162155089','2025-02-18 04:18:01','2025-02-18 04:18:01',59,1),(72,'601162168710','2025-02-18 04:18:03','2025-02-18 04:18:03',58,1),(73,'601162155089','2025-02-18 04:19:01','2025-02-18 04:19:01',59,1),(74,'601162168710','2025-02-18 04:19:02','2025-02-18 04:19:02',58,1),(75,'601162155089','2025-02-18 04:20:01','2025-02-18 04:20:01',59,1),(76,'601162168710','2025-02-18 04:20:03','2025-02-18 04:20:03',59,1),(77,'601162155089','2025-02-18 04:21:01','2025-02-18 04:21:01',59,1),(78,'601162168710','2025-02-18 04:21:03','2025-02-18 04:21:03',58,1),(79,'601162155089','2025-02-18 04:22:01','2025-02-18 04:22:01',59,1),(80,'601162168710','2025-02-18 04:22:03','2025-02-18 04:22:03',58,1),(81,'601162155089','2025-02-18 04:23:02','2025-02-18 04:23:02',59,1),(82,'601162168710','2025-02-18 04:23:03','2025-02-18 04:23:03',59,1),(83,'601162155089','2025-02-18 04:24:01','2025-02-18 04:24:01',58,1),(84,'601162168710','2025-02-18 04:24:03','2025-02-18 04:24:03',58,1),(85,'601162155089','2025-02-18 04:25:01','2025-02-18 04:25:01',59,1),(86,'601162168710','2025-02-18 04:25:03','2025-02-18 04:25:03',58,1),(87,'601162155089','2025-02-18 04:26:01','2025-02-18 04:26:01',59,1),(88,'601162168710','2025-02-18 04:26:03','2025-02-18 04:26:03',58,1),(89,'601162155089','2025-02-18 04:27:01','2025-02-18 04:27:01',59,1),(90,'601162168710','2025-02-18 04:27:03','2025-02-18 04:27:03',58,1),(91,'601162155089','2025-02-18 04:28:01','2025-02-18 04:28:01',59,1),(92,'601162168710','2025-02-18 04:28:03','2025-02-18 04:28:03',58,1),(93,'601162155089','2025-02-18 04:29:01','2025-02-18 04:29:01',59,1),(94,'601162168710','2025-02-18 04:29:03','2025-02-18 04:29:03',58,1),(95,'601162155089','2025-02-18 04:30:01','2025-02-18 04:30:01',59,1),(96,'601162168710','2025-02-18 04:30:03','2025-02-18 04:30:03',59,1),(97,'601162155089','2025-02-18 04:31:01','2025-02-18 04:31:01',59,1),(98,'601162168710','2025-02-18 04:31:03','2025-02-18 04:31:03',59,1),(99,'601162155089','2025-02-18 04:33:01','2025-02-18 04:33:01',119,1),(100,'601162168710','2025-02-18 04:33:04','2025-02-18 04:33:04',119,1),(101,'601162155089','2025-02-18 04:34:02','2025-02-18 04:34:02',59,1),(102,'601162168710','2025-02-18 04:34:03','2025-02-18 04:34:03',58,1),(103,'601162155089','2025-02-18 04:35:02','2025-02-18 04:35:02',58,1),(104,'601162168710','2025-02-18 04:35:03','2025-02-18 04:35:03',59,1),(105,'601162155089','2025-02-18 04:36:01','2025-02-18 04:36:01',58,1),(106,'601162168710','2025-02-18 04:36:03','2025-02-18 04:36:03',59,1),(107,'601162155089','2025-02-18 04:37:02','2025-02-18 04:37:02',59,1),(108,'601162168710','2025-02-18 04:37:03','2025-02-18 04:37:03',59,1);
|
||
/*!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',
|
||
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名称（如手机号码）',
|
||
`money` decimal(10,2) NOT NULL COMMENT '奖励金额',
|
||
`before` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '操作前的余额',
|
||
`after` decimal(10,2) NOT NULL COMMENT '操作后的余额',
|
||
`memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '奖励类型或备注信息',
|
||
`status` int(11) NOT NULL COMMENT '操作状态，标识当前记录的状态（如成功、失败等）',
|
||
`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 '管理员名称（如果管理员操作）',
|
||
`created_at` datetime NOT NULL,
|
||
`updated_at` datetime NOT NULL,
|
||
`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;
|
||
/*!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 */;
|
||
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-17 19:25:11','2025-02-17 19:25:11'),(73,1,0,'1',100.00,348.00,448.00,'挂机收益',6,'1',NULL,'2025-02-17 19:25:12','2025-02-17 19:25:12','2025-02-17 19:25:12'),(74,3,0,'2',4.00,92.00,96.00,'加粉赏金',5,'70203',NULL,'2025-02-17 19:59:10','2025-02-17 19:59:10','2025-02-17 19:59:10'),(75,4,0,'3',2.00,24.00,26.00,'加粉赏金',5,'06192',NULL,'2025-02-17 19:59:11','2025-02-17 19:59:11','2025-02-17 19:59:10'),(76,1,0,'1',20.00,448.00,468.00,'挂机收益',6,'1',NULL,'2025-02-17 19:59:11','2025-02-17 19:59:11','2025-02-17 19:59:11'),(77,3,0,'2',4.00,96.00,100.00,'加粉赏金',5,'70203',NULL,'2025-02-17 21:02:13','2025-02-17 21:02:13','2025-02-17 21:02:12'),(78,4,0,'3',2.00,26.00,28.00,'加粉赏金',5,'06192',NULL,'2025-02-17 21:02:13','2025-02-17 21:02:13','2025-02-17 21:02:13'),(79,1,0,'1',20.00,468.00,488.00,'挂机收益',6,'1',NULL,'2025-02-17 21:02:13','2025-02-17 21:02:13','2025-02-17 21:02:13'),(80,1,0,'1',-10.00,488.00,478.00,'抽奖',9,'1',NULL,'2025-02-17 21:05:47','2025-02-17 21:05:47','2025-02-17 21:05:47'),(81,1,0,'1',1.00,478.00,479.00,'中奖',8,'1',NULL,'2025-02-17 21:05:47','2025-02-17 21:05:47','2025-02-17 21:05:47'),(82,3,0,'2',4.00,100.00,104.00,'加粉赏金',5,'70203',NULL,'2025-02-17 22:04:24','2025-02-17 22:04:24','2025-02-17 22:04:24'),(83,4,0,'3',2.00,28.00,30.00,'加粉赏金',5,'06192',NULL,'2025-02-17 22:04:24','2025-02-17 22:04:24','2025-02-17 22:04:24'),(84,1,0,'1',20.00,479.00,499.00,'挂机收益',6,'1',NULL,'2025-02-17 22:04:24','2025-02-17 22:04:24','2025-02-17 22:04:24'),(85,3,0,'2',1933116.00,104.00,1933220.00,'加粉赏金',5,'70203',NULL,'2025-02-17 23:19:04','2025-02-17 23:19:04','2025-02-17 23:19:03'),(86,4,0,'3',966558.00,30.00,966588.00,'加粉赏金',5,'06192',NULL,'2025-02-17 23:19:04','2025-02-17 23:19:04','2025-02-17 23:19:04'),(87,1,0,'1',9665580.00,499.00,9666079.00,'挂机收益',6,'1',NULL,'2025-02-17 23:19:04','2025-02-17 23:19:04','2025-02-17 23:19:04'),(88,3,0,'2',52.00,1933220.00,1933272.00,'加粉赏金',5,'70203',NULL,'2025-02-18 12:10:01','2025-02-18 12:10:01','2025-02-18 12:10:01'),(89,4,0,'3',26.00,966588.00,966614.00,'加粉赏金',5,'06192',NULL,'2025-02-18 12:10:02','2025-02-18 12:10:02','2025-02-18 12:10:01'),(90,1,0,'1',260.00,9666079.00,9666339.00,'挂机收益',6,'1',NULL,'2025-02-18 12:10:02','2025-02-18 12:10:02','2025-02-18 12:10:02'),(91,3,0,'2',52.00,1933272.00,1933324.00,'加粉赏金',5,'70203',NULL,'2025-02-18 12:10:03','2025-02-18 12:10:03','2025-02-18 12:10:03'),(92,4,0,'3',26.00,966614.00,966640.00,'加粉赏金',5,'06192',NULL,'2025-02-18 12:10:04','2025-02-18 12:10:04','2025-02-18 12:10:04'),(93,1,0,'1',260.00,9666339.00,9666599.00,'挂机收益',6,'1',NULL,'2025-02-18 12:10:04','2025-02-18 12:10:04','2025-02-18 12:10:04'),(94,1,0,'1',-6300.00,9666599.00,9660299.00,'提现',1,'1',NULL,'2025-02-18 12:18:42','2025-02-18 12:18:42','2025-02-18 12:18:42'),(95,1,0,'1',-4800.00,9660299.00,9655499.00,'提现',1,'1',NULL,'2025-02-18 12:19:26','2025-02-18 12:19:26','2025-02-18 12:19:26'),(96,3,0,'2',4.00,1933324.00,1933328.00,'加粉赏金',5,'70203',NULL,'2025-02-18 12:34:02','2025-02-18 12:34:02','2025-02-18 12:34:01'),(97,4,0,'3',2.00,966640.00,966642.00,'加粉赏金',5,'06192',NULL,'2025-02-18 12:34:02','2025-02-18 12:34:02','2025-02-18 12:34:02'),(98,1,0,'1',20.00,9655499.00,9655519.00,'挂机收益',6,'1',NULL,'2025-02-18 12:34:02','2025-02-18 12:34:02','2025-02-18 12:34:02'),(99,1,0,'1',-4800.00,9655519.00,9650719.00,'提现',1,'1',NULL,'2025-02-18 12:35:40','2025-02-18 12:35:40','2025-02-18 12:35:40');
|
||
/*!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` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`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
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1890227411799285764 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `userbank`
|
||
--
|
||
|
||
LOCK TABLES `userbank` WRITE;
|
||
/*!40000 ALTER TABLE `userbank` DISABLE KEYS */;
|
||
INSERT INTO `userbank` VALUES (1890227411799285762,2075840533,'111','INEB','asss',5,'333',NULL,NULL),(1890227411799285763,1,'1','Nagad','ad',5,'',NULL,NULL);
|
||
/*!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时间戳)',
|
||
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
|
||
`today_num` int(11) NOT NULL DEFAULT '0' COMMENT '今天有效人数',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `invite_code` (`invite_code`) USING BTREE,
|
||
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='用户信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `users`
|
||
--
|
||
|
||
LOCK TABLES `users` WRITE;
|
||
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
|
||
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);
|
||
/*!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级别的唯一标识符',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'VIP级别的名称',
|
||
`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 '创建时间（时间戳）',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
|
||
/*!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\":\"登录时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false},\"last_ip\":{\"field\":\"last_ip\",\"_field_id\":\"13\",\"comment\":\"登录ip\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"join_time\":{\"field\":\"join_time\",\"_field_id\":\"14\",\"comment\":\"注册时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false},\"join_ip\":{\"field\":\"join_ip\",\"_field_id\":\"15\",\"comment\":\"注册ip\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"token\":{\"field\":\"token\",\"_field_id\":\"16\",\"comment\":\"token\",\"control\":\"input\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"17\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"18\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"between\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"role\":{\"field\":\"role\",\"_field_id\":\"19\",\"comment\":\"角色\",\"control\":\"inputNumber\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"20\",\"comment\":\"禁用\",\"control\":\"switch\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-12-23 15:28:13'),(3,'table_form_schema_wa_roles','{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"角色组\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"rules\":{\"field\":\"rules\",\"_field_id\":\"2\",\"comment\":\"权限\",\"control\":\"treeSelectMulti\",\"control_args\":\"url:\\/app\\/admin\\/rule\\/get?type=0,1,2\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"3\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"4\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"pid\":{\"field\":\"pid\",\"_field_id\":\"5\",\"comment\":\"父级\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/role\\/select?format=tree\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-12-19 14:24:25'),(4,'table_form_schema_wa_rules','{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"1\",\"comment\":\"标题\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"icon\":{\"field\":\"icon\",\"_field_id\":\"2\",\"comment\":\"图标\",\"control\":\"iconPicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"key\":{\"field\":\"key\",\"_field_id\":\"3\",\"comment\":\"标识\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"pid\":{\"field\":\"pid\",\"_field_id\":\"4\",\"comment\":\"上级菜单\",\"control\":\"treeSelect\",\"control_args\":\"\\/app\\/admin\\/rule\\/select?format=tree&type=0,1\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"5\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"6\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"href\":{\"field\":\"href\",\"_field_id\":\"7\",\"comment\":\"url\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"8\",\"comment\":\"类型\",\"control\":\"select\",\"control_args\":\"data:0:目录,1:菜单,2:权限\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"weight\":{\"field\":\"weight\",\"_field_id\":\"9\",\"comment\":\"排序\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-12-08 11:44:45'),(5,'table_form_schema_wa_admins','{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"ID\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"search_type\":\"between\",\"form_show\":false,\"searchable\":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},\"avatar\":{\"field\":\"avatar\",\"_field_id\":\"4\",\"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\":\"5\",\"comment\":\"邮箱\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"mobile\":{\"field\":\"mobile\",\"_field_id\":\"6\",\"comment\":\"手机\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"7\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"8\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"login_at\":{\"field\":\"login_at\",\"_field_id\":\"9\",\"comment\":\"登录时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"between\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"10\",\"comment\":\"禁用\",\"control\":\"switch\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-12-23 15:36:48'),(6,'table_form_schema_wa_options','{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"键\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"value\":{\"field\":\"value\",\"_field_id\":\"2\",\"comment\":\"值\",\"control\":\"textArea\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"3\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"4\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-12-08 11:36:57'),(7,'table_form_schema_wa_uploads','{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"search_type\":\"normal\",\"form_show\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"名称\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false},\"url\":{\"field\":\"url\",\"_field_id\":\"2\",\"comment\":\"文件\",\"control\":\"upload\",\"control_args\":\"url:\\/app\\/admin\\/upload\\/file\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"admin_id\":{\"field\":\"admin_id\",\"_field_id\":\"3\",\"comment\":\"管理员\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/admin\\/select?format=select\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"file_size\":{\"field\":\"file_size\",\"_field_id\":\"4\",\"comment\":\"文件大小\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"mime_type\":{\"field\":\"mime_type\",\"_field_id\":\"5\",\"comment\":\"mime类型\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"image_width\":{\"field\":\"image_width\",\"_field_id\":\"6\",\"comment\":\"图片宽度\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"image_height\":{\"field\":\"image_height\",\"_field_id\":\"7\",\"comment\":\"图片高度\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"ext\":{\"field\":\"ext\",\"_field_id\":\"8\",\"comment\":\"扩展名\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false},\"storage\":{\"field\":\"storage\",\"_field_id\":\"9\",\"comment\":\"存储位置\",\"control\":\"input\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"10\",\"comment\":\"上传时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"searchable\":true,\"search_type\":\"between\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false},\"category\":{\"field\":\"category\",\"_field_id\":\"11\",\"comment\":\"类别\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/dict\\/get\\/upload\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"12\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-12-08 11:47:45'),(8,'table_form_schema_wa_uploads','{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"search_type\":\"normal\",\"form_show\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"名称\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false},\"url\":{\"field\":\"url\",\"_field_id\":\"2\",\"comment\":\"文件\",\"control\":\"upload\",\"control_args\":\"url:\\/app\\/admin\\/upload\\/file\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"admin_id\":{\"field\":\"admin_id\",\"_field_id\":\"3\",\"comment\":\"管理员\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/admin\\/select?format=select\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"file_size\":{\"field\":\"file_size\",\"_field_id\":\"4\",\"comment\":\"文件大小\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"mime_type\":{\"field\":\"mime_type\",\"_field_id\":\"5\",\"comment\":\"mime类型\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"image_width\":{\"field\":\"image_width\",\"_field_id\":\"6\",\"comment\":\"图片宽度\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"image_height\":{\"field\":\"image_height\",\"_field_id\":\"7\",\"comment\":\"图片高度\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"ext\":{\"field\":\"ext\",\"_field_id\":\"8\",\"comment\":\"扩展名\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false},\"storage\":{\"field\":\"storage\",\"_field_id\":\"9\",\"comment\":\"存储位置\",\"control\":\"input\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"10\",\"comment\":\"上传时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"searchable\":true,\"search_type\":\"between\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false},\"category\":{\"field\":\"category\",\"_field_id\":\"11\",\"comment\":\"类别\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/dict\\/get\\/upload\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"12\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-12-08 11:47:45'),(9,'dict_upload','[{\"value\":\"1\",\"name\":\"分类1\"},{\"value\":\"2\",\"name\":\"分类2\"},{\"value\":\"3\",\"name\":\"分类3\"}]','2022-12-04 16:24:13','2022-12-04 16:24:13'),(10,'dict_sex','[{\"value\":\"0\",\"name\":\"女\"},{\"value\":\"1\",\"name\":\"男\"}]','2022-12-04 15:04:40','2022-12-04 15:04:40'),(11,'dict_status','[{\"value\":\"0\",\"name\":\"正常\"},{\"value\":\"1\",\"name\":\"禁用\"}]','2022-12-04 15:05:09','2022-12-04 15:05:09'),(17,'table_form_schema_wa_admin_roles','{\"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},\"role_id\":{\"field\":\"role_id\",\"_field_id\":\"1\",\"comment\":\"角色id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"admin_id\":{\"field\":\"admin_id\",\"_field_id\":\"2\",\"comment\":\"管理员id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-12-20 19:42:51'),(18,'dict_dict_name','[{\"value\":\"dict_name\",\"name\":\"字典名称\"},{\"value\":\"status\",\"name\":\"启禁用状态\"},{\"value\":\"sex\",\"name\":\"性别\"},{\"value\":\"upload\",\"name\":\"附件分类\"}]','2022-08-15 00:00:00','2022-12-20 19:42:51'),(19,'table_form_schema_carousel','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"img_url\":{\"field\":\"img_url\",\"_field_id\":\"3\",\"comment\":\"图片地址\",\"control\":\"textArea\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-02 18:36:45'),(20,'table_form_schema_project','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"img\":{\"field\":\"img\",\"_field_id\":\"3\",\"comment\":\"首页图\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"start_time\":{\"field\":\"start_time\",\"_field_id\":\"4\",\"comment\":\"开始时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"between\",\"enable_sort\":false,\"searchable\":false},\"end_time\":{\"field\":\"end_time\",\"_field_id\":\"5\",\"comment\":\"结束时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"between\",\"enable_sort\":false,\"searchable\":false},\"address\":{\"field\":\"address\",\"_field_id\":\"6\",\"comment\":\"地址\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"7\",\"comment\":\"标题\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"8\",\"comment\":\"分类\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-02 09:41:35'),(21,'table_form_schema_project_detailed','{\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\"},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"between\",\"enable_sort\":false,\"searchable\":false},\"projectid\":{\"field\":\"projectid\",\"_field_id\":\"3\",\"comment\":\"对应项目id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"serviceduration\":{\"field\":\"serviceduration\",\"_field_id\":\"4\",\"comment\":\"服务时长单位分钟\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"recruitingpersonnel\":{\"field\":\"recruitingpersonnel\",\"_field_id\":\"6\",\"comment\":\"招募人数志愿者\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"registerserve\":{\"field\":\"registerserve\",\"_field_id\":\"7\",\"comment\":\"招募人数被服务者\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"servicedescription\":{\"field\":\"servicedescription\",\"_field_id\":\"8\",\"comment\":\"服务说明\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"totalnumberoftimecoins\":{\"field\":\"totalnumberoftimecoins\",\"_field_id\":\"9\",\"comment\":\"时间币\\/每个人\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"volunteergender\":{\"field\":\"volunteergender\",\"_field_id\":\"10\",\"comment\":\"志愿者性别要求1为男0为女\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"volunteerage\":{\"field\":\"volunteerage\",\"_field_id\":\"11\",\"comment\":\"志愿者年龄\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"registrationisclosed\":{\"field\":\"registrationisclosed\",\"_field_id\":\"12\",\"comment\":\"报名截止日期\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"between\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-08-15 00:00:00'),(22,'table_form_schema_project_register','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"projectid\":{\"field\":\"projectid\",\"_field_id\":\"3\",\"comment\":\"项目id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"4\",\"comment\":\"类型0是志愿者1是被服务者\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"userid\":{\"field\":\"userid\",\"_field_id\":\"5\",\"comment\":\"用户id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-02 09:43:38'),(23,'table_form_schema_carouselad','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"img_url\":{\"field\":\"img_url\",\"_field_id\":\"3\",\"comment\":\"图片url\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-08-15 00:00:00'),(24,'table_form_schema_mechanism','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"3\",\"comment\":\"名称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"level\":{\"field\":\"level\",\"_field_id\":\"4\",\"comment\":\"星级最高五级\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"address\":{\"field\":\"address\",\"_field_id\":\"5\",\"comment\":\"地址\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"bed\":{\"field\":\"bed\",\"_field_id\":\"6\",\"comment\":\"床位数\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"characteristic\":{\"field\":\"characteristic\",\"_field_id\":\"7\",\"comment\":\"特色\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"briefIntroduction\":{\"field\":\"briefIntroduction\",\"_field_id\":\"8\",\"comment\":\"简介\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"imgurl\":{\"field\":\"imgurl\",\"_field_id\":\"9\",\"comment\":\"首页图片地址\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-08-15 00:00:00'),(25,'table_form_schema_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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"cardid\":{\"field\":\"cardid\",\"_field_id\":\"3\",\"comment\":\"身份证号码\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"phone\":{\"field\":\"phone\",\"_field_id\":\"4\",\"comment\":\"手机号码\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"nickname\":{\"field\":\"nickname\",\"_field_id\":\"5\",\"comment\":\"昵称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"timecoin\":{\"field\":\"timecoin\",\"_field_id\":\"6\",\"comment\":\"时间币\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"gender\":{\"field\":\"gender\",\"_field_id\":\"7\",\"comment\":\"性别1男性0女性\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"8\",\"comment\":\"1是启用0是禁止\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"birthday\":{\"field\":\"birthday\",\"_field_id\":\"9\",\"comment\":\"出生日期\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"between\",\"enable_sort\":false,\"searchable\":false},\"avatar\":{\"field\":\"avatar\",\"_field_id\":\"10\",\"comment\":\"头像url地址\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"password\":{\"field\":\"password\",\"_field_id\":\"11\",\"comment\":\"密码\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"acceptmessages\":{\"field\":\"acceptmessages\",\"_field_id\":\"12\",\"comment\":\"是否接受短信1接受0不接受\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-16 10:19:31'),(26,'table_form_schema_bank_log','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"userid\":{\"field\":\"userid\",\"_field_id\":\"3\",\"comment\":\"关联用户id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"money\":{\"field\":\"money\",\"_field_id\":\"4\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"remark\":{\"field\":\"remark\",\"_field_id\":\"5\",\"comment\":\"备注\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-08-15 00:00:00'),(27,'table_form_schema_message','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"3\",\"comment\":\"标题\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"content\":{\"field\":\"content\",\"_field_id\":\"4\",\"comment\":\"内容\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"5\",\"comment\":\"消息类型 0通知1会话\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"userid\":{\"field\":\"userid\",\"_field_id\":\"6\",\"comment\":\"用户id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"parameters\":{\"field\":\"parameters\",\"_field_id\":\"7\",\"comment\":\"携带参数\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-16 15:59:10'),(28,'table_form_schema_volunteerservicecorps','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"leaderid\":{\"field\":\"leaderid\",\"_field_id\":\"3\",\"comment\":\"组长id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"groupname\":{\"field\":\"groupname\",\"_field_id\":\"4\",\"comment\":\"组名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"category\":{\"field\":\"category\",\"_field_id\":\"5\",\"comment\":\"|分割\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"img\":{\"field\":\"img\",\"_field_id\":\"6\",\"comment\":\"主要图\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"briefly\":{\"field\":\"briefly\",\"_field_id\":\"7\",\"comment\":\"队伍简介\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-21 14:03:18'),(29,'table_form_schema_volunteerjoinrequest','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"userid\":{\"field\":\"userid\",\"_field_id\":\"3\",\"comment\":\"申请加入用户id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"5\",\"comment\":\"状态码0提交申请1通过未加入2已完成\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"remark\":{\"field\":\"remark\",\"_field_id\":\"6\",\"comment\":\"用户申请备注\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-16 09:30:33'),(30,'table_form_schema_timecoinreview','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"amount\":{\"field\":\"amount\",\"_field_id\":\"3\",\"comment\":\"金额\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"4\",\"comment\":\"是否同意由该组组长审核0未审1通过2未通过\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"remark\":{\"field\":\"remark\",\"_field_id\":\"5\",\"comment\":\"备注\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-16 09:31:07'),(31,'table_form_schema_volunteerservicecorpsdetailed','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"userid\":{\"field\":\"userid\",\"_field_id\":\"3\",\"comment\":\"用户id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"groupid\":{\"field\":\"groupid\",\"_field_id\":\"4\",\"comment\":\"对应的组id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-08-15 00:00:00'),(32,'table_form_schema_contact','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"userid\":{\"field\":\"userid\",\"_field_id\":\"3\",\"comment\":\"用户id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"relationship\":{\"field\":\"relationship\",\"_field_id\":\"4\",\"comment\":\"亲属关系0父母1子女2配偶3其他\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"5\",\"comment\":\"姓名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"phone\":{\"field\":\"phone\",\"_field_id\":\"6\",\"comment\":\"电话\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-16 16:29:09'),(33,'table_form_schema_dictionary','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"key\":{\"field\":\"key\",\"_field_id\":\"3\",\"comment\":\"key\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"value\":{\"field\":\"value\",\"_field_id\":\"4\",\"comment\":\"value\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2022-08-15 00:00:00'),(34,'table_form_schema_hotinformation','{\"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},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"1\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"between\",\"form_show\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"2\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"3\",\"comment\":\"标题\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"writer\":{\"field\":\"writer\",\"_field_id\":\"4\",\"comment\":\"作者\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"content\":{\"field\":\"content\",\"_field_id\":\"5\",\"comment\":\"内容\",\"control\":\"richText\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"6\",\"comment\":\"类型0是热点资讯1是银龄动态\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"img\":{\"field\":\"img\",\"_field_id\":\"7\",\"comment\":\"图片地址\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"weight\":{\"field\":\"weight\",\"_field_id\":\"8\",\"comment\":\"权重\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}','2022-08-15 00:00:00','2025-01-22 10:24:02');
|
||
/*!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,'分布表单','layui-icon-face-cry','demo2032',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/step.html',1,0),(32,'树形表格','layui-icon-face-cry','demo2033',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/treetable.html',1,0),(33,'树状结构','layui-icon-face-cry','demo2034',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/dtree.html',1,0),(34,'文本编辑','layui-icon-face-cry','demo2035',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/tinymce.html',1,0),(35,'卡片组件','layui-icon-face-cry','demo2036',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/card.html',1,0),(36,'抽屉组件','layui-icon-face-cry','demo2021',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/drawer.html',1,0),(37,'消息通知','layui-icon-face-cry','demo2022',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/notice.html',1,0),(38,'加载组件','layui-icon-face-cry','demo2024',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/loading.html',1,0),(39,'弹层组件','layui-icon-face-cry','demo2023',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/popup.html',1,0),(40,'多选项卡','layui-icon-face-cry','demo60131',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/tab.html',1,0),(41,'数据菜单','layui-icon-face-cry','demo60132',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/menu.html',1,0),(42,'哈希加密','layui-icon-face-cry','demo2041',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/encrypt.html',1,0),(43,'图标选择','layui-icon-face-cry','demo2042',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/iconPicker.html',1,0),(44,'省市级联','layui-icon-face-cry','demo2043',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/area.html',1,0),(45,'数字滚动','layui-icon-face-cry','demo2044',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/count.html',1,0),(46,'顶部返回','layui-icon-face-cry','demo2045',24,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/document/topBar.html',1,0),(47,'结果页面','layui-icon-auz','demo666',18,'2025-01-02 09:20:14','2025-01-02 09:20:14','',0,0),(48,'成功','layui-icon-face-smile','demo667',47,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/result/success.html',1,0),(49,'失败','layui-icon-face-cry','demo668',47,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/result/error.html',1,0),(50,'错误页面','layui-icon-face-cry','demo-error',18,'2025-01-02 09:20:14','2025-01-02 09:20:14','',0,0),(51,'403','layui-icon-face-smile','demo403',50,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/error/403.html',1,0),(52,'404','layui-icon-face-cry','demo404',50,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/error/404.html',1,0),(53,'500','layui-icon-face-cry','demo500',50,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/error/500.html',1,0),(54,'系统管理','layui-icon-set-fill','demo-system',18,'2025-01-02 09:20:14','2025-01-02 09:20:14','',0,0),(55,'用户管理','layui-icon-face-smile','demo601',54,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/system/user.html',1,0),(56,'角色管理','layui-icon-face-cry','demo602',54,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/system/role.html',1,0),(57,'权限管理','layui-icon-face-cry','demo603',54,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/system/power.html',1,0),(58,'部门管理','layui-icon-face-cry','demo604',54,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/system/deptment.html',1,0),(59,'行为日志','layui-icon-face-cry','demo605',54,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/system/log.html',1,0),(60,'数据字典','layui-icon-face-cry','demo606',54,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/system/dict.html',1,0),(61,'常用页面','layui-icon-template-1','demo-common',18,'2025-01-02 09:20:14','2025-01-02 09:20:14','',0,0),(62,'空白页面','layui-icon-face-smile','demo702',61,'2025-01-02 09:20:14','2025-01-02 09:20:14','/app/admin/demos/system/space.html',1,0),(63,'查看表',NULL,'plugin\\admin\\app\\controller\\TableController@view',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(64,'查询表',NULL,'plugin\\admin\\app\\controller\\TableController@show',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(65,'创建表',NULL,'plugin\\admin\\app\\controller\\TableController@create',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(66,'修改表',NULL,'plugin\\admin\\app\\controller\\TableController@modify',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(67,'一键菜单',NULL,'plugin\\admin\\app\\controller\\TableController@crud',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(68,'查询记录',NULL,'plugin\\admin\\app\\controller\\TableController@select',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(69,'插入记录',NULL,'plugin\\admin\\app\\controller\\TableController@insert',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(70,'更新记录',NULL,'plugin\\admin\\app\\controller\\TableController@update',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(71,'删除记录',NULL,'plugin\\admin\\app\\controller\\TableController@delete',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(72,'删除表',NULL,'plugin\\admin\\app\\controller\\TableController@drop',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(73,'表摘要',NULL,'plugin\\admin\\app\\controller\\TableController@schema',2,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(74,'插入',NULL,'plugin\\admin\\app\\controller\\AdminController@insert',4,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(75,'更新',NULL,'plugin\\admin\\app\\controller\\AdminController@update',4,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(76,'删除',NULL,'plugin\\admin\\app\\controller\\AdminController@delete',4,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(77,'插入',NULL,'plugin\\admin\\app\\controller\\RoleController@insert',5,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(78,'更新',NULL,'plugin\\admin\\app\\controller\\RoleController@update',5,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(79,'删除',NULL,'plugin\\admin\\app\\controller\\RoleController@delete',5,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(80,'获取角色权限',NULL,'plugin\\admin\\app\\controller\\RoleController@rules',5,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(81,'查询',NULL,'plugin\\admin\\app\\controller\\RuleController@select',6,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(82,'添加',NULL,'plugin\\admin\\app\\controller\\RuleController@insert',6,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(83,'更新',NULL,'plugin\\admin\\app\\controller\\RuleController@update',6,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(84,'删除',NULL,'plugin\\admin\\app\\controller\\RuleController@delete',6,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(85,'插入',NULL,'plugin\\admin\\app\\controller\\UserController@insert',8,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(86,'更新',NULL,'plugin\\admin\\app\\controller\\UserController@update',8,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(87,'查询',NULL,'plugin\\admin\\app\\controller\\UserController@select',8,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(88,'删除',NULL,'plugin\\admin\\app\\controller\\UserController@delete',8,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(89,'更新',NULL,'plugin\\admin\\app\\controller\\AccountController@update',10,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(90,'修改密码',NULL,'plugin\\admin\\app\\controller\\AccountController@password',10,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(91,'查询',NULL,'plugin\\admin\\app\\controller\\AccountController@select',10,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(92,'添加',NULL,'plugin\\admin\\app\\controller\\AccountController@insert',10,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(93,'删除',NULL,'plugin\\admin\\app\\controller\\AccountController@delete',10,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(94,'浏览附件',NULL,'plugin\\admin\\app\\controller\\UploadController@attachment',11,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(95,'查询附件',NULL,'plugin\\admin\\app\\controller\\UploadController@select',11,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(96,'更新附件',NULL,'plugin\\admin\\app\\controller\\UploadController@update',11,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(97,'添加附件',NULL,'plugin\\admin\\app\\controller\\UploadController@insert',11,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(98,'上传文件',NULL,'plugin\\admin\\app\\controller\\UploadController@file',11,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(99,'上传图片',NULL,'plugin\\admin\\app\\controller\\UploadController@image',11,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(100,'上传头像',NULL,'plugin\\admin\\app\\controller\\UploadController@avatar',11,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(101,'删除附件',NULL,'plugin\\admin\\app\\controller\\UploadController@delete',11,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(102,'查询',NULL,'plugin\\admin\\app\\controller\\DictController@select',12,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(103,'插入',NULL,'plugin\\admin\\app\\controller\\DictController@insert',12,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(104,'更新',NULL,'plugin\\admin\\app\\controller\\DictController@update',12,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(105,'删除',NULL,'plugin\\admin\\app\\controller\\DictController@delete',12,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(106,'更改',NULL,'plugin\\admin\\app\\controller\\ConfigController@update',13,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(107,'列表',NULL,'plugin\\admin\\app\\controller\\PluginController@list',15,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(108,'安装',NULL,'plugin\\admin\\app\\controller\\PluginController@install',15,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(109,'卸载',NULL,'plugin\\admin\\app\\controller\\PluginController@uninstall',15,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(110,'支付',NULL,'plugin\\admin\\app\\controller\\PluginController@pay',15,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(111,'登录官网',NULL,'plugin\\admin\\app\\controller\\PluginController@login',15,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(112,'获取已安装的插件列表',NULL,'plugin\\admin\\app\\controller\\PluginController@getInstalledPlugins',15,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(113,'表单构建',NULL,'plugin\\admin\\app\\controller\\DevController@formBuild',17,'2025-01-02 09:44:23','2025-01-02 09:44:23',NULL,2,0),(114,'轮播图配置','','plugin\\admin\\app\\controller\\CarouselController',134,'2025-01-02 09:44:46','2025-01-02 18:37:06','/app/admin/carousel/index',1,0),(115,'插入',NULL,'plugin\\admin\\app\\controller\\CarouselController@insert',114,'2025-01-02 09:44:50','2025-01-02 09:44:50',NULL,2,0),(116,'更新',NULL,'plugin\\admin\\app\\controller\\CarouselController@update',114,'2025-01-02 09:44:50','2025-01-02 09:44:50',NULL,2,0),(117,'查询',NULL,'plugin\\admin\\app\\controller\\CarouselController@select',114,'2025-01-02 09:44:50','2025-01-02 09:44:50',NULL,2,0),(118,'删除',NULL,'plugin\\admin\\app\\controller\\CarouselController@delete',114,'2025-01-02 09:44:50','2025-01-02 09:44:50',NULL,2,0),(119,'项目列表','layui-icon-app','plugin\\admin\\app\\controller\\ProjectController',134,'2025-01-02 09:45:14','2025-01-02 09:47:44','/app/admin/project/index',1,0),(120,'插入',NULL,'plugin\\admin\\app\\controller\\ProjectController@insert',119,'2025-01-02 09:45:18','2025-01-02 09:45:18',NULL,2,0),(121,'更新',NULL,'plugin\\admin\\app\\controller\\ProjectController@update',119,'2025-01-02 09:45:18','2025-01-02 09:45:18',NULL,2,0),(122,'查询',NULL,'plugin\\admin\\app\\controller\\ProjectController@select',119,'2025-01-02 09:45:18','2025-01-02 09:45:18',NULL,2,0),(123,'删除',NULL,'plugin\\admin\\app\\controller\\ProjectController@delete',119,'2025-01-02 09:45:18','2025-01-02 09:45:18',NULL,2,0),(124,'项目详细信息','layui-icon-tabs','plugin\\admin\\app\\controller\\ProjectDetailedController',134,'2025-01-02 09:45:36','2025-01-02 09:48:01','/app/admin/project-detailed/index',1,0),(125,'插入',NULL,'plugin\\admin\\app\\controller\\ProjectDetailedController@insert',124,'2025-01-02 09:45:40','2025-01-02 09:45:40',NULL,2,0),(126,'更新',NULL,'plugin\\admin\\app\\controller\\ProjectDetailedController@update',124,'2025-01-02 09:45:40','2025-01-02 09:45:40',NULL,2,0),(127,'查询',NULL,'plugin\\admin\\app\\controller\\ProjectDetailedController@select',124,'2025-01-02 09:45:40','2025-01-02 09:45:40',NULL,2,0),(128,'删除',NULL,'plugin\\admin\\app\\controller\\ProjectDetailedController@delete',124,'2025-01-02 09:45:40','2025-01-02 09:45:40',NULL,2,0),(129,'项目报名情况','layui-icon-user','plugin\\admin\\app\\controller\\ProjectRegisterController',134,'2025-01-02 09:45:53','2025-01-02 09:48:17','/app/admin/project-register/index',1,0),(130,'插入',NULL,'plugin\\admin\\app\\controller\\ProjectRegisterController@insert',129,'2025-01-02 09:46:05','2025-01-02 09:46:05',NULL,2,0),(131,'更新',NULL,'plugin\\admin\\app\\controller\\ProjectRegisterController@update',129,'2025-01-02 09:46:05','2025-01-02 09:46:05',NULL,2,0),(132,'查询',NULL,'plugin\\admin\\app\\controller\\ProjectRegisterController@select',129,'2025-01-02 09:46:05','2025-01-02 09:46:05',NULL,2,0),(133,'删除',NULL,'plugin\\admin\\app\\controller\\ProjectRegisterController@delete',129,'2025-01-02 09:46:05','2025-01-02 09:46:05',NULL,2,0),(134,'小程序','layui-icon-login-wechat','小程序',0,'2025-01-02 09:46:40','2025-01-02 09:46:40','',0,0),(135,'广告轮播图','','plugin\\admin\\app\\controller\\CarouseladController',134,'2025-01-03 10:23:23','2025-01-03 10:23:23','/app/admin/carouselad/index',1,0),(136,'插入',NULL,'plugin\\admin\\app\\controller\\CarouseladController@insert',135,'2025-01-03 17:02:40','2025-01-03 17:02:40',NULL,2,0),(137,'更新',NULL,'plugin\\admin\\app\\controller\\CarouseladController@update',135,'2025-01-03 17:02:40','2025-01-03 17:02:40',NULL,2,0),(138,'查询',NULL,'plugin\\admin\\app\\controller\\CarouseladController@select',135,'2025-01-03 17:02:40','2025-01-03 17:02:40',NULL,2,0),(139,'删除',NULL,'plugin\\admin\\app\\controller\\CarouseladController@delete',135,'2025-01-03 17:02:40','2025-01-03 17:02:40',NULL,2,0),(140,'银龄乐园','','plugin\\admin\\app\\controller\\MechanismController',134,'2025-01-04 10:42:02','2025-01-04 10:42:02','/app/admin/mechanism/index',1,0),(141,'插入',NULL,'plugin\\admin\\app\\controller\\MechanismController@insert',140,'2025-01-04 10:51:20','2025-01-04 10:51:20',NULL,2,0),(142,'更新',NULL,'plugin\\admin\\app\\controller\\MechanismController@update',140,'2025-01-04 10:51:20','2025-01-04 10:51:20',NULL,2,0),(143,'查询',NULL,'plugin\\admin\\app\\controller\\MechanismController@select',140,'2025-01-04 10:51:20','2025-01-04 10:51:20',NULL,2,0),(144,'删除',NULL,'plugin\\admin\\app\\controller\\MechanismController@delete',140,'2025-01-04 10:51:20','2025-01-04 10:51:20',NULL,2,0),(145,'消息','layui-icon-release','plugin\\admin\\app\\controller\\MessageController',134,'2025-01-11 19:37:55','2025-01-11 19:42:46','/app/admin/message/index',1,0),(146,'插入',NULL,'plugin\\admin\\app\\controller\\MessageController@insert',145,'2025-01-11 19:42:01','2025-01-11 19:42:01',NULL,2,0),(147,'更新',NULL,'plugin\\admin\\app\\controller\\MessageController@update',145,'2025-01-11 19:42:01','2025-01-11 19:42:01',NULL,2,0),(148,'查询',NULL,'plugin\\admin\\app\\controller\\MessageController@select',145,'2025-01-11 19:42:01','2025-01-11 19:42:01',NULL,2,0),(149,'删除',NULL,'plugin\\admin\\app\\controller\\MessageController@delete',145,'2025-01-11 19:42:01','2025-01-11 19:42:01',NULL,2,0),(150,'志愿者组','','plugin\\admin\\app\\controller\\VolunteerservicecorpController',134,'2025-01-15 17:43:15','2025-01-15 17:43:15','/app/admin/volunteerservicecorp/index',1,0),(151,'插入',NULL,'plugin\\admin\\app\\controller\\VolunteerservicecorpController@insert',150,'2025-01-15 17:43:20','2025-01-15 17:43:20',NULL,2,0),(152,'更新',NULL,'plugin\\admin\\app\\controller\\VolunteerservicecorpController@update',150,'2025-01-15 17:43:20','2025-01-15 17:43:20',NULL,2,0),(153,'查询',NULL,'plugin\\admin\\app\\controller\\VolunteerservicecorpController@select',150,'2025-01-15 17:43:21','2025-01-15 17:43:21',NULL,2,0),(154,'删除',NULL,'plugin\\admin\\app\\controller\\VolunteerservicecorpController@delete',150,'2025-01-15 17:43:21','2025-01-15 17:43:21',NULL,2,0),(155,'时间币记录','','plugin\\admin\\app\\controller\\BankLog',134,'2025-01-15 17:45:15','2025-01-15 17:48:24','/app/admin/banklog/index',1,0),(156,'插入',NULL,'plugin\\admin\\app\\controller\\BankLogController@insert',155,'2025-01-15 17:45:21','2025-01-15 17:45:21',NULL,2,0),(157,'更新',NULL,'plugin\\admin\\app\\controller\\BankLogController@update',155,'2025-01-15 17:45:21','2025-01-15 17:45:21',NULL,2,0),(158,'查询',NULL,'plugin\\admin\\app\\controller\\BankLogController@select',155,'2025-01-15 17:45:22','2025-01-15 17:45:22',NULL,2,0),(159,'删除',NULL,'plugin\\admin\\app\\controller\\BankLogController@delete',155,'2025-01-15 17:45:22','2025-01-15 17:45:22',NULL,2,0),(160,'用户联系人列表','','plugin\\admin\\app\\controller\\Contact',134,'2025-01-16 16:13:50','2025-01-22 09:35:25','/app/admin/contact/index',1,0),(161,'插入',NULL,'plugin\\admin\\app\\controller\\ContactController@insert',160,'2025-01-16 16:13:53','2025-01-16 16:13:53',NULL,2,0),(162,'更新',NULL,'plugin\\admin\\app\\controller\\ContactController@update',160,'2025-01-16 16:13:53','2025-01-16 16:13:53',NULL,2,0),(163,'查询',NULL,'plugin\\admin\\app\\controller\\ContactController@select',160,'2025-01-16 16:13:53','2025-01-16 16:13:53',NULL,2,0),(164,'删除',NULL,'plugin\\admin\\app\\controller\\ContactController@delete',160,'2025-01-16 16:13:53','2025-01-16 16:13:53',NULL,2,0),(165,'文章发布','','plugin\\admin\\app\\controller\\HotinformationController',134,'2025-01-22 09:37:44','2025-01-22 09:37:44','/app/admin/hotinformation/index',1,0),(166,'插入',NULL,'plugin\\admin\\app\\controller\\HotinformationController@insert',165,'2025-01-22 09:37:48','2025-01-22 09:37:48',NULL,2,0),(167,'更新',NULL,'plugin\\admin\\app\\controller\\HotinformationController@update',165,'2025-01-22 09:37:49','2025-01-22 09:37:49',NULL,2,0),(168,'查询',NULL,'plugin\\admin\\app\\controller\\HotinformationController@select',165,'2025-01-22 09:37:49','2025-01-22 09:37:49',NULL,2,0),(169,'删除',NULL,'plugin\\admin\\app\\controller\\HotinformationController@delete',165,'2025-01-22 09:37:49','2025-01-22 09:37:49',NULL,2,0);
|
||
/*!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,
|
||
`status_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
||
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 */;
|
||
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','申请中');
|
||
/*!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 */;
|
||
|
||
-- Dump completed on 2025-02-18 12:37:48
|