TBWeb正式稳定版V3.4.0+AI+MJ绘画+免授权无后门+详细安装教程.zip

-- MySQL dump 10.13 Distrib 5.7.43, for Linux (x86_64) -- -- Host: localhost Database: zyecc -- ------------------------------------------------------ -- Server version 5.7.43-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!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 `account_log` -- DROP TABLE IF EXISTS `account_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `account_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间', `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间', `deletedAt` datetime(6) DEFAULT NULL COMMENT '删除时间', `userId` int(11) NOT NULL COMMENT '用户ID', `pkgName` varchar(255) DEFAULT NULL COMMENT '会员套餐名称', `rebateUserId` int(11) DEFAULT NULL COMMENT '推荐人ID、返佣用户ID', `packageId` int(11) DEFAULT NULL COMMENT '充值套餐ID', `memberDays` int(11) DEFAULT NULL COMMENT '会员有效天数', `rechargeType` int(11) NOT NULL COMMENT '账户充值类型', `model3Count` int(11) NOT NULL COMMENT '模型3对话次数', `model4Count` int(11) NOT NULL COMMENT '模型4对话次数', `drawMjCount` int(11) NOT NULL COMMENT 'MJ绘画次数', `days` int(11) NOT NULL COMMENT '套餐有效期', `uid` varchar(255) NOT NULL COMMENT '随机订单uid', `extent` varchar(255) DEFAULT NULL COMMENT '扩展字段', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_log` -- LOCK TABLES `account_log` WRITE; /*!40000 ALTER TABLE `account_log` DISABLE KEYS */; INSERT INTO `account_log` VALUES (1,'2024-03-10 01:48:55.552596','2024-03-10 01:48:55.552596',NULL,3,'',NULL,NULL,NULL,1,50,5,6,-1,'434eac409',''),(2,'2024-03-10 01:54:22.032359','2024-03-10 01:54:22.032359',NULL,3,'',NULL,NULL,NULL,5,1000,100,1000,-1,'dc8971957',''),(3,'2024-03-10 02:16:06.422872','2024-03-10 02:16:06.422872',NULL,3,'测试',NULL,NULL,NULL,6,10,10,10,1,'a1d1808ff',''),(4,'2024-03-10 02:30:52.531024','2024-03-10 02:30:52.531024',NULL,3,'测试',NULL,NULL,NULL,6,10,10,10,1,'fd120bc8b',''),(5,'2024-03-10 10:12:28.997693','2024-03-10 10:12:28.997693',NULL,4,'',NULL,NULL,NULL,1,50,7,7,-1,'8e1e4631d',''),(6,'2024-03-10 15:25:27.403689','2024-03-10 15:25:27.403689',NULL,5,'',NULL,NULL,NULL,1,50,7,7,-1,'febde171c',''),(7,'2024-03-13 01:52:06.129089','2024-03-13 01:52:06.129089',NULL,7,'',NULL,NULL,NULL,1,50,7,7,-1,'eeadb27a3',''),(8,'2024-03-13 11:14:12.462107','2024-03-13 11:14:12.462107',NULL,3,'',NULL,NULL,NULL,7,0,0,1,0,'dfbb884f7',''),(9,'2024-05-07 14:51:19.566342','2024-05-07 14:51:19.566342',NULL,8,'',NULL,NULL,NULL,1,30,5,1,-1,'01fe24de3',''),(10,'2024-05-07 14:51:40.037159','2024-05-07 14:51:40.037159',NULL,8,'',NULL,NULL,NULL,5,10000,10000,10000,-1,'8d03c4e05',''),(11,'2024-05-07 15:35:17.687129','2024-05-07 15:35:17.687129',NULL,9,'',NULL,NULL,NULL,1,30,5,1,-1,'408f59389',''),(12,'2024-05-07 15:42:12.109693','2024-05-07 15:42:12.109693',NULL,9,'',NULL,NULL,NULL,5,10000,2000,1000,-1,'cbd7447b6',''),(13,'2024-05-09 15:30:57.392510','2024-05-09 15:30:57.392510',NULL,10,'',NULL,NULL,NULL,1,30,5,1,-1,'d91c5a9ae',''),(14,'2024-05-09 15:54:56.908528','2024-05-09 15:54:56.908528',NULL,11,'',NULL,NULL,NULL,1,30,5,1,-1,'b578df0ff',''),(15,'2024-05-09 15:56:04.706288','2024-05-09 15:56:04.706288',NULL,11,'',NULL,NULL,NULL,5,10000,10000,10000,-1,'568950714',''),(16,'2024-05-16 14:04:24.295997','2024-05-16 14:04:24.295997',NULL,12,'',NULL,NULL,NULL,1,30,5,1,-1,'5a77c7cae',''),(17,'2024-05-17 09:51:40.904376','2024-05-17 09:51:40.904376',NULL,12,'',NULL,NULL,NULL,5,5000,1000,500,-1,'6d30c65bb',''),(18,'2024-05-19 09:03:01.942233','2024-05-19 09:03:01.942233',NULL,13,'',NULL,NULL,NULL,1,30,5,1,-1,'e3818020d',''),(19,'2024-05-19 09:25:16.369468','2024-05-19 09:25:16.369468',NULL,13,'',NULL,NULL,NULL,5,999999,999999,999999,-1,'2969364a3',''),(20,'2024-05-25 22:47:15.634211','2024-05-25 22:47:15.634211',NULL,14,'',NULL,NULL,NULL,1,30,5,1,-1,'66b5cb7c1',''),(21,'2024-05-30 09:49:35.783373','2024-05-30 09:49:35.783373',NULL,14,'',NULL,NULL,NULL,5,1000,1000,1000,-1,'081ac2af9',''),(22,'2024-06-03 14:47:22.417400','2024-06-03 14:47:22.417400',NULL,15,'',NULL,NULL,NULL,1,30,5,1,-1,'c8d08d5bf',''),(23,'2024-06-03 14:49:51.242911','2024-06-03 14:49:51.242911',NULL,15,'',NULL,NULL,NULL,5,999999,999999,999999,-1,'aeabdd65b',''),(24,'2024-06-26 17:24:46.671208','2024-06-26 17:24:46.671208',NULL,16,'',NULL,NULL,NULL,1,30,5,1,-1,'fbfa3e251',''),(25,'2024-06-26 17:25:03.331388','2024-06-26 17:25:03.331388',NULL,16,'',NULL,NULL,NULL,5,99999,99999,99999,-1,'8607b0fdb',''),(26,'2024-07-18 14:11:26.383499','2024-07-18 14:11:26.383499',NULL,17,'',NULL,NULL,NULL,1,30,5,1,-1,'0abb551be',''),(27,'2024-07-18 14:13:22.311165','2024-07-18 14:13:22.311165',NULL,17,'',NULL,NULL,NULL,5,999999,999999,999999,-1,'e773ff3fd',''); /*!40000 ALTER TABLE `account_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `app` -- DROP TABLE IF EXISTS `app`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `app` ( `id` int(11) NOT NULL AUTO_INCREMENT, `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间', `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更新时间', `deletedAt` datetime(6) DEFAULT NULL COMMENT '删除时间', `name` varchar(255) NOT NULL COMMENT 'App应用名称', `catId` int(11) NOT NULL COMMENT 'App分类Id', `des` varchar(255) NOT NULL COMMENT 'App应用描述信息', `preset` text COMMENT 'App应用预设场景信息', `coverImg` varchar(255) DEFAULT NULL COMMENT 'App应用封面图片', `gptsImg` text COMMENT 'gpts应用封面图片 来源网络的地址很长、兼容一下', `order` int(11) NOT NULL DEFAULT '100' COMMENT 'App应用排序、数字越大越靠前', `status` int(11) NOT NULL DEFAULT '1' COMMENT 'App应用是否启用中 0：禁用 1：启用', `demoData` text COMMENT 'App示例数据', `role` varchar(255) NOT NULL DEFAULT 'system' COMMENT 'App应用角色 system user', `public` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'App是否共享到应用广场', `userId` int(11) DEFAULT NULL COMMENT '用户Id', `modelTypeId` int(11) DEFAULT NULL COMMENT '绑定调用的模型id', `isGpts` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否是gpts应用', `gptsId` varchar(255) DEFAULT NULL COMMENT 'gpts应用id', PRIMARY KEY (`id`), UNIQUE KEY `IDX_f36adbb7b096ceeb6f3e80ad14` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `app` -- LOCK TABLES `app` WRITE; /*!40000 ALTER TABLE `app` DISABLE KEYS */; INSERT INTO `app` VALUES (82,'2024-02-02 05:24:38.174123','2024-02-02 05:24:38.174123',NULL,'诗人绘画',0,'您输入绘画基本主题（或者上传一张简单的图片），我会帮您补充场景、构图、服装、动作、情绪、光影、氛围、意境等细节，并生成高质量绘图提示词',NULL,NULL,'https://files.oaiusercontent.com/file-HZCvygBrBz3QgvyTkyPkntU6?se=2123-10-20T10%3A24%3A20Z&sp=r&sv=2021-08-06&sr=b&rscc=max-age%3D31536000%2C%20imm