-- MySQL dump 10.13  Distrib 5.7.44, for Linux (x86_64)
--
-- Host: localhost    Database: gcustomer_sharea
-- ------------------------------------------------------
-- Server version	5.7.44-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 `qh_kefu_apply`
--

DROP TABLE IF EXISTS `qh_kefu_apply`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_apply` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '客户id',
  `name` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '联系人',
  `phone` varchar(11) CHARACTER SET utf8 NOT NULL COMMENT '电话',
  `type` int(1) NOT NULL DEFAULT '1' COMMENT '类型',
  `content` text CHARACTER SET utf8 NOT NULL COMMENT '内容',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_at` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='留言申请表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_apply`
--

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

--
-- Table structure for table `qh_kefu_banword`
--

DROP TABLE IF EXISTS `qh_kefu_banword`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_banword` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '关键词',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1显示 0不显示',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_banword`
--

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

--
-- Table structure for table `qh_kefu_chats`
--

DROP TABLE IF EXISTS `qh_kefu_chats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_chats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(200) CHARACTER SET utf8 NOT NULL COMMENT '访客id',
  `kefu_id` int(11) NOT NULL COMMENT '客服id',
  `fileType` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'text' COMMENT '消息类型。默认为text文本',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '内容',
  `state` int(1) DEFAULT '1' COMMENT '1是未读，2是已读',
  `direction` int(1) DEFAULT '1' COMMENT '1是发给客服，2是发给用户,3是转接客服',
  `switch_id` int(11) DEFAULT NULL COMMENT '转接客服ID',
  `unstr` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '前端唯一字符串用于撤销使用',
  `created_at` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `visiter_id` (`uid`) USING BTREE,
  KEY `service_id` (`kefu_id`) USING BTREE,
  KEY `unstr` (`unstr`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='消息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_chats`
--

LOCK TABLES `qh_kefu_chats` WRITE;
/*!40000 ALTER TABLE `qh_kefu_chats` DISABLE KEYS */;
INSERT INTO `qh_kefu_chats` VALUES (1,'673edafaiu65u5xbz38',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732172538),(2,'673edafaiu65u5xbz38',2,'text','1111',2,2,NULL,'NAFpi5kO0ZCfAwM0U2Ci',1732172556),(3,'673edafaiu65u5xbz38',2,'text','2222',2,1,NULL,NULL,1732172560),(4,'673edafaiu65u5xbz38',2,'text','3333',2,1,NULL,NULL,1732172767),(5,'673edafaiu65u5xbz38',2,'text','3333',2,2,NULL,'eeVS78yeueo5hhfk5OqH',1732172776),(6,'673edafaiu65u5xbz38',2,'text','55',2,1,NULL,NULL,1732172807),(7,'6732f4e0796iltu3wd6',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',2,2,NULL,NULL,1732172954),(8,'6732f4e0796iltu3wd6',2,'text','3333',2,1,NULL,NULL,1732172960),(9,'6732f4e0796iltu3wd6',2,'text','999',2,2,NULL,'I7jOlAfVtT062e3eTzWZ',1732172981),(10,'6732f4e0796iltu3wd6',2,'text','999',2,2,NULL,'8tqm49R1QaSPt0X1E90D',1732173031),(11,'6732f4e0796iltu3wd6',2,'text','777',2,1,NULL,NULL,1732173112),(12,'6732f4e0796iltu3wd6',2,'text','99',2,2,NULL,'LHFZhTVywhMrfZcLDa09',1732173119),(13,'6732f4e0796iltu3wd6',2,'text','99',2,2,NULL,'NYijIySJg06XDhNLUJbw',1732173130),(14,'673edd66oce1bocj5c8',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732173158),(15,'673edd66oce1bocj5c8',2,'text','666',2,2,NULL,'DhfHtR81DtTQMNzFL8oM',1732173166),(16,'673edd66oce1bocj5c8',2,'text','999',2,1,NULL,NULL,1732173255),(17,'673edd66oce1bocj5c8',2,'text','6666',2,2,NULL,'PePbruo5ZD5ySQAbwjID',1732173259),(18,'673edd66oce1bocj5c8',2,'text','highjack',2,1,NULL,NULL,1732173273),(19,'6732f4e0796iltu3wd6',2,'text','3333',2,1,NULL,NULL,1732173316),(20,'6732f4e0796iltu3wd6',2,'text','4444',2,2,NULL,'l2y0pfEqRJEf3L5jwl2Z',1732173322),(21,'6732f4e0796iltu3wd6',2,'text','3333',2,2,NULL,'QYtH9HukGvgjrLq1WajI',1732173350),(22,'6732f4e0796iltu3wd6',2,'text','111111',2,2,NULL,'KeJDMVOolnmcusnp51Gt',1732174519),(23,'6732f4e0796iltu3wd6',2,'text','5555',2,2,NULL,'PioAge85LJmjfDlIfpZm',1732174542),(24,'673edd66oce1bocj5c8',2,'text','111',2,1,NULL,NULL,1732178801),(25,'673edd66oce1bocj5c8',2,'text','222',2,2,NULL,'PmkkCNsX7Mw6zvESkgfJ',1732178802),(26,'673edd66oce1bocj5c8',2,'text','再发一i啊',2,1,NULL,NULL,1732178817),(27,'673edd66oce1bocj5c8',2,'text','666',2,2,NULL,'c0sNlx8Hwqsja4lI8dvT',1732178815),(28,'673edd66oce1bocj5c8',2,'text','777',2,2,NULL,'2Kfga9C8d6GGgpdAmLaX',1732178822),(29,'673edd66oce1bocj5c8',2,'text','888',2,2,NULL,'tA4bScXUtJk2JJ9qVxWP',1732178827),(30,'673edd66oce1bocj5c8',2,'text','999',2,2,NULL,'XehbpdBoYGdLi2lVySjr',1732178831),(31,'673edd66oce1bocj5c8',2,'text','123',2,2,NULL,'87zei0Z2Bfs0mwjLNLNc',1732178835),(32,'673edd66oce1bocj5c8',2,'text','654.',2,2,NULL,'UdNNXePyHJ1m6hzV9Ly1',1732178840),(33,'673edd66oce1bocj5c8',2,'text','4555',2,2,NULL,'nwGaP21wC7ewrcilUe83',1732179069),(34,'673edd66oce1bocj5c8',2,'text','8888',2,2,NULL,'BcIIDwmNH0V78xDPc3eZ',1732179072),(35,'673edd66oce1bocj5c8',2,'text','在发一个',2,1,NULL,NULL,1732179092),(36,'673edd66oce1bocj5c8',2,'text','666',2,2,NULL,'nOyp3qZLc0k29Xvt0cRk',1732179092),(37,'673edd66oce1bocj5c8',2,'text','1',2,2,NULL,'2baK2zS7jgDEFJcGClBF',1732179207),(38,'673edd66oce1bocj5c8',2,'text','3',2,2,NULL,'XxyMZXoSEOtQz5uVS9G9',1732179262),(39,'673edd66oce1bocj5c8',2,'text','99',2,2,NULL,'HL05ItDW2ZsYiHvDj5s8',1732179300),(40,'673edd66oce1bocj5c8',2,'text','3333',2,2,NULL,'tBSgX6b5eo83gHZ2K0et',1732179550),(41,'673edd66oce1bocj5c8',2,'text','沙发沙发',2,2,NULL,'c2Fh1rIKgGBXoIjDt6EC',1732179568),(42,'673edd66oce1bocj5c8',2,'text','啊大苏打从',2,2,NULL,'KqiMOJSBnhiql4Enml3x',1732179597),(43,'673edd66oce1bocj5c8',2,'text','3333',2,2,NULL,'9grS6RaD6Yh7jIWWyk3X',1732179694),(44,'673edd66oce1bocj5c8',2,'text','二二杠',2,2,NULL,'kULEsYHWANIC1HsxzsZu',1732179698),(45,'673edd66oce1bocj5c8',2,'text','的方法',2,2,NULL,'SoiKpvDgjfKXSjNrG2sy',1732179703),(46,'673edd66oce1bocj5c8',2,'text','1',2,2,NULL,'NYq5rGm9JrgXYv4hkq4q',1732179710),(47,'673edd66oce1bocj5c8',2,'text','实打实大大',2,2,NULL,'gGV7t68r7S01mNZBwiyR',1732179887),(48,'673edd66oce1bocj5c8',2,'text','111',2,2,NULL,'VQMPttVOai4KfUZCODMz',1732179893),(49,'673edd66oce1bocj5c8',2,'text','3五3',2,2,NULL,'1G95Rw2NplvskwRcNaC1',1732179924),(50,'673edd66oce1bocj5c8',2,'text','3333',2,2,NULL,'85vohsyE1YgCFLzWcOms',1732180022),(51,'673edd66oce1bocj5c8',2,'text','333',2,2,NULL,'ES8lrqCMM2DyOjTJWq9H',1732180026),(52,'673edd66oce1bocj5c8',2,'text','111',2,2,NULL,'bmY5IJFHe0qbVtWAzK5k',1732180031),(53,'673edd66oce1bocj5c8',2,'text','3333',2,2,NULL,'VLDwlJpobDp36BejPK1C',1732180293),(54,'673edd66oce1bocj5c8',2,'text','333',2,2,NULL,'zDFNahglDOSbTH9nZ77I',1732180298),(55,'673edd66oce1bocj5c8',2,'text','333',2,2,NULL,'7eHkAlyJUyANWl0zHgkS',1732180387),(56,'673edd66oce1bocj5c8',2,'text','3',2,2,NULL,'Y3Jhdso4EkGHykyyoPJU',1732180401),(57,'673edd66oce1bocj5c8',2,'text','3',2,2,NULL,'h4MYX2bLKGv2pfckR4h9',1732180489),(58,'673edd66oce1bocj5c8',2,'text','3',2,2,NULL,'g6UoYs3METw7xxAiAGk3',1732180490),(59,'673edd66oce1bocj5c8',2,'text','3',2,2,NULL,'2lCUTZw2LRKJzEE4u0lY',1732180491),(60,'673edd66oce1bocj5c8',2,'text','3',2,2,NULL,'xeE1dkpOfSrw0XlpEMtA',1732180497),(61,'673edd66oce1bocj5c8',2,'text','5555',2,2,NULL,'7Yzc1GZX1ROWKe2RgSFb',1732180578),(62,'673edd66oce1bocj5c8',2,'text','6666',2,2,NULL,'nzWXAPgfphWYlEb1TZgJ',1732180584),(63,'673edd66oce1bocj5c8',2,'text','555',2,2,NULL,'T0L2AeiOCtzP5HEDgTQy',1732180621),(64,'673edd66oce1bocj5c8',2,'text','666',2,2,NULL,'AuCDif07NI605EJgp12D',1732180623),(65,'673edd66oce1bocj5c8',2,'text','777',2,2,NULL,'PIriL94nTvVyj67UOnn2',1732180625),(66,'673edd66oce1bocj5c8',2,'text','888',2,2,NULL,'J73UfRP4JTM2ZbFwfCLQ',1732180627),(67,'673edd66oce1bocj5c8',2,'text','999',2,2,NULL,'4z0RC9aARPCAJlQuHluO',1732180629),(68,'673edd66oce1bocj5c8',2,'text','333',2,2,NULL,'Me2ARV4OR6jETzNTUnH5',1732180982),(69,'673edd66oce1bocj5c8',2,'text','333',2,2,NULL,'vfFXbNeKk5rH4xRUqFPw',1732182489),(70,'673edd66oce1bocj5c8',2,'text','333沙发沙发',2,2,NULL,'xshPR3y9OQEkDavQmAxZ',1732182514),(71,'673edd66oce1bocj5c8',2,'text','666',2,2,NULL,'oaWphq2SyaJmo1iQs0H6',1732182560),(72,'673edd66oce1bocj5c8',2,'text','666',2,2,NULL,'uzGLrRsL0VEuMywnu6p3',1732182580),(73,'673edd66oce1bocj5c8',2,'text','147',2,2,NULL,'ITt6JYnNxKwEDquwAGJz',1732182583),(74,'673edd66oce1bocj5c8',2,'text','258',2,2,NULL,'ot1Lz28EzgmAvCxActpP',1732182636),(75,'673edd66oce1bocj5c8',2,'text','369',2,2,NULL,'ZjeGbV91C7K7a2MEGo61',1732182639),(76,'673edd66oce1bocj5c8',2,'text','789',2,2,NULL,'3MBoCbZS5xdnZT2GahPE',1732182689),(77,'673edd66oce1bocj5c8',2,'text','654.',2,2,NULL,'ZOCwmA2UlSaJIfo5aBIh',1732182690),(78,'673edd66oce1bocj5c8',2,'text','321',2,2,NULL,'zg0RT4aK64lreGhQl10b',1732182692),(79,'673edd66oce1bocj5c8',2,'text','222555',2,2,NULL,'LGs2KjuQyyfTwPBQ44Tv',1732182703),(80,'673f0672x6ia6z5a636',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732183666),(81,'673fecb0fniz76g0lw8',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',2,2,NULL,NULL,1732242608),(82,'673fecb0fniz76g0lw8',2,'text','111',2,1,NULL,NULL,1732244492),(83,'673fecb0fniz76g0lw8',2,'text','555',2,1,NULL,NULL,1732244503),(84,'673fecb0fniz76g0lw8',2,'text','666',2,1,NULL,NULL,1732245150),(85,'673f0672x6ia6z5a636',2,'text','wdsf',2,2,NULL,'gDwHmQ9NZJoVsynNg54b',1732245716),(86,'673ffc65bcdf620iie9',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',2,2,NULL,NULL,1732246648),(87,'673ffc65bcdf620iie9',0,'text','333',1,1,NULL,NULL,1732247290),(88,'673ffc65bcdf620iie9',0,'text','s1dsadadd',1,1,NULL,NULL,1732247490),(89,'673ffc65bcdf620iie9',2,'text','33',2,1,NULL,NULL,1732257393),(90,'673ffc65bcdf620iie9',2,'text','3333',2,1,NULL,NULL,1732257477),(91,'673ffc65bcdf620iie9',2,'text','3333',2,1,NULL,NULL,1732257505),(92,'673ffc65bcdf620iie9',2,'text','987',2,1,NULL,NULL,1732257522),(93,'673fecb0fniz76g0lw8',2,'text','haode1',2,1,NULL,NULL,1732258839),(94,'673fecb0fniz76g0lw8',2,'text','你号',2,2,NULL,'tHLFk74a9GXoXhWPD5CK',1732259364),(95,'673fecb0fniz76g0lw8',2,'text','好呀！',2,2,NULL,'sj7bmr6UaBzJjlSpYkb3',1732259368),(96,'67402e41oag70h369z3',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',2,2,NULL,NULL,1732259393),(97,'67402e41oag70h369z3',2,'text','你号',2,1,NULL,NULL,1732259396),(98,'67402e41oag70h369z3',2,'text','在的',2,1,NULL,NULL,1732259427),(99,'67402e41oag70h369z3',2,'text','哈哈',2,1,NULL,NULL,1732259436),(100,'67402e41oag70h369z3',2,'text','123',2,1,NULL,NULL,1732259465),(101,'673fecb0fniz76g0lw8',2,'text','websocket 正在已debug模式启动中',2,1,NULL,NULL,1732259467),(102,'67402e41oag70h369z3',2,'text','体吉里吉里吉里吉里',2,1,NULL,NULL,1732259469),(103,'67402e41oag70h369z3',2,'text','回来',2,2,NULL,'4XkB0zZVdQALuUOaGiZ5',1732259477),(104,'67402e41oag70h369z3',2,'text','吉里吉里',2,1,NULL,NULL,1732259483),(105,'67402fac37yuf05kb86',0,'text','哈啊哈',1,1,NULL,NULL,1732259790),(106,'67402fac37yuf05kb86',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732260220),(107,'6740327cdel4dt4f7x6',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732260476),(108,'673ee7b8yczarj8mq00',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732260646),(109,'673ee7b8yczarj8mq00',2,'text','666',1,1,NULL,NULL,1732260661),(110,'674033bbxci79nsegm5',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732260795),(111,'674033d2vab8t10gug8',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732260818),(112,'6740342db9ztm4n0vj9',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732260909),(113,'6740342eibpa91ky9k0',2,'text','您好，很高兴为您服务，您有什么需要咨询的吗？',1,2,NULL,NULL,1732260911),(114,'6740342eibpa91ky9k0',2,'text','电动车',1,1,NULL,NULL,1732260934),(115,'6740342eibpa91ky9k0',2,'text','对的对的',1,1,NULL,NULL,1732260949),(116,'6740342db9ztm4n0vj9',2,'text','333',1,1,NULL,NULL,1732261003),(117,'6740342db9ztm4n0vj9',2,'text','7',1,1,NULL,NULL,1732261006),(118,'6740342db9ztm4n0vj9',2,'text','q',1,1,NULL,NULL,1732261010),(119,'6740342db9ztm4n0vj9',2,'pic','http://gcustomer.shareadd.cn/uploads/thumbnails/20241122/202411221537058cb8c2565.jpg',1,1,NULL,NULL,1732261026);
/*!40000 ALTER TABLE `qh_kefu_chats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_kefu_comment`
--

DROP TABLE IF EXISTS `qh_kefu_comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kefu_id` int(11) DEFAULT NULL COMMENT '客服ID',
  `uid` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户ID',
  `rate` int(1) DEFAULT NULL COMMENT '几颗星',
  `content` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '评论内容',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1显示 0不显示',
  `created_at` int(11) DEFAULT NULL COMMENT '评论时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_comment`
--

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

--
-- Table structure for table `qh_kefu_group`
--

DROP TABLE IF EXISTS `qh_kefu_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(1) NOT NULL DEFAULT '1' COMMENT '1是客服，2是用户',
  `groupname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `created_at` int(11) DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_group`
--

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

--
-- Table structure for table `qh_kefu_product`
--

DROP TABLE IF EXISTS `qh_kefu_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL COMMENT '用户ID',
  `product_id` int(11) DEFAULT NULL COMMENT '商品ID',
  `created_at` int(11) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='常见问题表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_product`
--

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

--
-- Table structure for table `qh_kefu_robot`
--

DROP TABLE IF EXISTS `qh_kefu_robot`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_robot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(1) NOT NULL DEFAULT '1' COMMENT '默认为1,1是问题答案，2是快捷回复',
  `kefu_id` int(11) DEFAULT NULL COMMENT '客服ID',
  `qustion` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '常见问题',
  `keyword` varchar(12) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '关键词',
  `reply` longtext CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='常见问题表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_robot`
--

LOCK TABLES `qh_kefu_robot` WRITE;
/*!40000 ALTER TABLE `qh_kefu_robot` DISABLE KEYS */;
INSERT INTO `qh_kefu_robot` VALUES (1,1,2,'测试','','测试'),(2,1,2,'哈啊哈','','公安'),(3,1,2,'哈哈理解','','自己看'),(4,1,2,'体吉里吉里吉里吉里','','魄力理'),(5,1,2,'提提特级教师','','自己');
/*!40000 ALTER TABLE `qh_kefu_robot` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_kefu_sentence`
--

DROP TABLE IF EXISTS `qh_kefu_sentence`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_sentence` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text CHARACTER SET utf8 NOT NULL COMMENT '内容',
  `kefu_id` int(11) NOT NULL COMMENT '所属客服id',
  `state` enum('using','unuse') CHARACTER SET utf8 NOT NULL DEFAULT 'using' COMMENT 'unuse: 未使用 ，using：使用中',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `se` (`kefu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_sentence`
--

LOCK TABLES `qh_kefu_sentence` WRITE;
/*!40000 ALTER TABLE `qh_kefu_sentence` DISABLE KEYS */;
INSERT INTO `qh_kefu_sentence` VALUES (3,'您好，很高兴为您服务，您有什么需要咨询的吗？',2,'using');
/*!40000 ALTER TABLE `qh_kefu_sentence` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_kefu_setting`
--

DROP TABLE IF EXISTS `qh_kefu_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '网站名称',
  `logo` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '网站logo',
  `domain` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `ws_url` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `file_path` varchar(150) CHARACTER SET utf8 DEFAULT NULL COMMENT '文件路径',
  `is_off` int(1) DEFAULT '1' COMMENT '1是开启，2是关闭',
  `worktime` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '在线时间',
  `is_auto` int(11) NOT NULL DEFAULT '1' COMMENT '默认为1,1是智能分配，2是进入排队',
  `is_content` int(1) DEFAULT NULL COMMENT '1是开启，2是关闭',
  `is_window` int(1) NOT NULL DEFAULT '1' COMMENT '窗口设置，1是小窗口，2是大窗口',
  `is_float` int(1) NOT NULL DEFAULT '1' COMMENT '悬浮位置，1是底部悬浮，2是右侧悬浮	',
  `float_color` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '悬浮条背景色',
  `home_color` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '主题色',
  `sms_config` text CHARACTER SET utf8 COMMENT '短信配置',
  `sms_default` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '默认阿里云短信',
  `email_config` text CHARACTER SET utf8 COMMENT '邮箱配置',
  `is_email` int(1) DEFAULT '1' COMMENT '默认为1,1是关闭，2是开启',
  `version` varchar(100) CHARACTER SET utf8 DEFAULT '1.0.0' COMMENT '版本号',
  `secret_key` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '秘钥',
  `ws_type` int(1) NOT NULL DEFAULT '1' COMMENT 'ws连接类型',
  `switch_apply` int(1) NOT NULL DEFAULT '1' COMMENT '留言弹窗 开关',
  `switch_sound` int(1) NOT NULL DEFAULT '0' COMMENT '是否开启提示音,默认不开启',
  `sound` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '提示音',
  `font_color` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT '字体颜色',
  `name_type` int(11) NOT NULL DEFAULT '2' COMMENT '客户名称显示方式',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='商家表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_setting`
--

LOCK TABLES `qh_kefu_setting` WRITE;
/*!40000 ALTER TABLE `qh_kefu_setting` DISABLE KEYS */;
INSERT INTO `qh_kefu_setting` VALUES (1,'客服系统','','http://gcustomer.shareadd.cn','ws://gcustomer.shareadd.cn:2346','http://gcustomer.shareadd.cn/',1,'',1,2,1,1,NULL,'#BE2525',NULL,'smsbao','{\"status\":false,\"is_email\":1,\"mail_smtp_host\":\"1\",\"mail_smtp_port\":\"23\",\"mail_smtp_user\":\"4\",\"mail_smtp_pass\":\"4\"}',1,'1.1.6','',1,2,1,'admin/static/xiaoxi.mp3',NULL,2);
/*!40000 ALTER TABLE `qh_kefu_setting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_kefu_user`
--

DROP TABLE IF EXISTS `qh_kefu_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_kefu_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '访客id',
  `kefu_id` int(11) DEFAULT NULL COMMENT '客服ID',
  `group_id` int(11) DEFAULT NULL COMMENT '分组ID',
  `avatar` varchar(1024) CHARACTER SET utf8 DEFAULT NULL COMMENT '头像',
  `name` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '用户自己填写的姓名',
  `tel` varchar(32) CHARACTER SET utf8 DEFAULT '' COMMENT '用户自己填写的电话',
  `login_num` int(11) DEFAULT '1' COMMENT '登录次数',
  `connect` text CHARACTER SET utf8 COMMENT '联系方式',
  `comment` text CHARACTER SET utf8 COMMENT '备注',
  `extends` text CHARACTER SET utf8 COMMENT '浏览器扩展',
  `ip` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '访客ip',
  `from_url` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '访客浏览地址',
  `msg_time` timestamp NULL DEFAULT NULL,
  `created_at` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '访问时间',
  `state` int(1) DEFAULT '1' COMMENT '1：正常接入,2:已经解决，3:黑名单',
  `is_top` tinyint(3) unsigned DEFAULT '0' COMMENT '1置顶展示0未置顶',
  `is_online` int(1) DEFAULT '1' COMMENT '1是在线，0是离线',
  `product` text CHARACTER SET utf8 COMMENT '商品信息',
  `read_num` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `id` (`uid`) USING BTREE,
  KEY `visiter` (`uid`) USING BTREE,
  KEY `time` (`created_at`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_kefu_user`
--

LOCK TABLES `qh_kefu_user` WRITE;
/*!40000 ALTER TABLE `qh_kefu_user` DISABLE KEYS */;
INSERT INTO `qh_kefu_user` VALUES (1,'673edafaiu65u5xbz38',2,NULL,NULL,'','',4,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732172538',1,0,0,'{}',0),(2,'6732f4e0796iltu3wd6',2,NULL,NULL,'','',8,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732172954',1,0,0,'{}',0),(3,'673edd66oce1bocj5c8',2,NULL,NULL,'','',16,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732173158',1,0,0,'{}',0),(4,'673ee7b8yczarj8mq00',2,NULL,NULL,'','',3,NULL,NULL,NULL,'119.103.21.143',NULL,NULL,'1732175800',1,0,0,'{}',1),(5,'673f0672x6ia6z5a636',2,NULL,NULL,'','',1,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732183666',1,0,1,'{}',0),(6,'673fecb0fniz76g0lw8',2,NULL,NULL,'','',13,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732242608',1,0,1,'{}',0),(7,'673ffc65bcdf620iie9',2,NULL,NULL,'','',16,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732246629',1,0,1,'{}',0),(8,'67402e41oag70h369z3',2,NULL,NULL,'','',1,NULL,NULL,NULL,'101.28.136.40',NULL,NULL,'1732259393',1,0,0,'{}',0),(9,'67402fac37yuf05kb86',2,NULL,NULL,'','',7,NULL,NULL,NULL,'101.28.136.40',NULL,NULL,'1732259756',1,0,1,'{}',1),(10,'6740327cdel4dt4f7x6',2,NULL,NULL,'','',4,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732260476',1,0,1,'{}',0),(11,'674033bbxci79nsegm5',2,NULL,NULL,'','',3,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732260795',1,0,0,'{}',0),(12,'674033d2vab8t10gug8',2,NULL,NULL,'','',3,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732260818',1,0,0,'{}',0),(13,'6740342db9ztm4n0vj9',2,NULL,NULL,'','',2,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732260909',1,0,0,'{}',4),(14,'6740342eibpa91ky9k0',2,NULL,NULL,'','',1,NULL,NULL,NULL,'58.48.130.168',NULL,NULL,'1732260910',1,0,0,'{}',2);
/*!40000 ALTER TABLE `qh_kefu_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_dept`
--

DROP TABLE IF EXISTS `qh_system_dept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_dept` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` int(11) DEFAULT '0' COMMENT '上级ID',
  `label` varchar(100) DEFAULT NULL COMMENT '部门名称',
  `name` varchar(30) NOT NULL COMMENT '名称',
  `intro` varchar(255) DEFAULT NULL COMMENT '简介',
  `leader` varchar(50) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态 (0正常 1停用)',
  `sort` tinyint(3) unsigned DEFAULT '1' COMMENT '排序',
  `created_by` varchar(30) DEFAULT NULL COMMENT '创建者',
  `updated_by` varchar(30) DEFAULT NULL COMMENT '更新者',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管理员分组';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_dept`
--

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

--
-- Table structure for table `qh_system_dic_data`
--

DROP TABLE IF EXISTS `qh_system_dic_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_dic_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type_id` bigint(20) unsigned NOT NULL COMMENT '字典类型ID',
  `data_type` varchar(10) DEFAULT 'text' COMMENT '数据类型：text文本、image图片',
  `label` varchar(50) DEFAULT NULL COMMENT '字典标签',
  `value` varchar(100) DEFAULT NULL COMMENT '字典值',
  `code` varchar(100) DEFAULT NULL COMMENT '字典标示',
  `sort` tinyint(3) unsigned DEFAULT '0' COMMENT '排序',
  `created_by` varchar(25) DEFAULT NULL COMMENT '创建者',
  `updated_by` varchar(25) DEFAULT NULL COMMENT '更新者',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `system_dict_data_type_id_index` (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='字典数据表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_dic_data`
--

LOCK TABLES `qh_system_dic_data` WRITE;
/*!40000 ALTER TABLE `qh_system_dic_data` DISABLE KEYS */;
INSERT INTO `qh_system_dic_data` VALUES (1,2,'text','1','2','system_items',1,'superAdmin','superAdmin','1','2024-01-30 17:50:10','2024-02-22 17:02:50');
/*!40000 ALTER TABLE `qh_system_dic_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_dic_type`
--

DROP TABLE IF EXISTS `qh_system_dic_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_dic_type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` bigint(20) unsigned DEFAULT '0' COMMENT '上级ID',
  `name` varchar(50) DEFAULT NULL COMMENT '字典名称',
  `code` varchar(100) DEFAULT NULL COMMENT '字典编码',
  `sort` tinyint(3) unsigned DEFAULT '0' COMMENT '排序',
  `created_by` varchar(25) DEFAULT NULL COMMENT '创建者',
  `updated_by` varchar(25) DEFAULT NULL COMMENT '更新者',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='字典类型表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_dic_type`
--

LOCK TABLES `qh_system_dic_type` WRITE;
/*!40000 ALTER TABLE `qh_system_dic_type` DISABLE KEYS */;
INSERT INTO `qh_system_dic_type` VALUES (1,0,'文件存储','files_storage',1,'superAdmin',NULL,'2023-07-17 20:14:06','2023-07-17 20:14:06'),(2,0,'系统配置','system_items',1,'superAdmin',NULL,'2023-07-17 20:18:32','2023-07-17 20:18:32'),(3,0,'测试后','test',1,'superAdmin',NULL,'2024-01-30 17:51:55','2024-01-30 17:51:55');
/*!40000 ALTER TABLE `qh_system_dic_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_group`
--

DROP TABLE IF EXISTS `qh_system_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_group` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` int(11) DEFAULT '0' COMMENT '上级ID',
  `label` varchar(100) DEFAULT NULL COMMENT '部门名称',
  `name` varchar(30) DEFAULT NULL COMMENT '名称',
  `leader` varchar(50) DEFAULT NULL COMMENT '负责人',
  `remark` text COMMENT '备注',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态 (0正常 1停用)',
  `sort` tinyint(3) unsigned DEFAULT '1' COMMENT '排序',
  `created_by` varchar(30) DEFAULT NULL COMMENT '创建者',
  `updated_by` varchar(30) DEFAULT NULL COMMENT '更新者',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COMMENT='管理员分组';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_group`
--

LOCK TABLES `qh_system_group` WRITE;
/*!40000 ALTER TABLE `qh_system_group` DISABLE KEYS */;
INSERT INTO `qh_system_group` VALUES (19,0,'客服部门',NULL,'test',NULL,'13988888888',1,100,NULL,NULL,'2024-07-05 18:47:42','2024-07-05 18:47:42');
/*!40000 ALTER TABLE `qh_system_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_logger`
--

DROP TABLE IF EXISTS `qh_system_logger`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_logger` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `module` varchar(20) NOT NULL DEFAULT 'default' COMMENT '日志模块：1默认',
  `level` enum('notice','error','warning') NOT NULL DEFAULT 'notice' COMMENT '日志等级： notice、warning、error',
  `param` json DEFAULT NULL COMMENT '操作参数',
  `message` text COMMENT '日志信息',
  `tag` varchar(64) DEFAULT '' COMMENT '日志标签',
  `router` varchar(50) NOT NULL DEFAULT '' COMMENT '请求路由',
  `method` varchar(20) NOT NULL DEFAULT '' COMMENT '请求方式',
  `uid` bigint(20) unsigned DEFAULT '0' COMMENT '操作用户',
  `port` enum('u','m') DEFAULT 'u' COMMENT '端口：u=服务端 m=客户端',
  `created_at` datetime DEFAULT NULL COMMENT '生成时间',
  `time_stamp` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_logger`
--

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

--
-- Table structure for table `qh_system_logger_login`
--

DROP TABLE IF EXISTS `qh_system_logger_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_logger_login` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(30) NOT NULL COMMENT '账户',
  `ip` varchar(30) DEFAULT NULL COMMENT '登录IP地址',
  `ip_location` varchar(180) DEFAULT NULL COMMENT 'IP所属地',
  `os` varchar(50) DEFAULT NULL COMMENT '操作系统',
  `browser` varchar(50) DEFAULT NULL COMMENT '浏览器',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '登录状态 (0成功 1失败)',
  `message` varchar(50) DEFAULT NULL COMMENT '提示消息',
  `login_time` timestamp NOT NULL COMMENT '登录时间',
  `remark` varchar(160) DEFAULT NULL COMMENT '备注',
  `time_stamp` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COMMENT='登录日志表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_logger_login`
--

LOCK TABLES `qh_system_logger_login` WRITE;
/*!40000 ALTER TABLE `qh_system_logger_login` DISABLE KEYS */;
INSERT INTO `qh_system_logger_login` VALUES (2,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-19 03:30:22','',1731987022),(3,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-19 03:35:49','',1731987349),(4,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-19 08:58:17','',1732006697),(5,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-20 01:22:41','',1732065761),(6,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-20 06:55:32','',1732085732),(7,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 07:01:35','',1732172495),(8,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 07:11:32','',1732173092),(9,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 07:14:00','',1732173240),(10,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 07:15:08','',1732173308),(11,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 08:01:43','',1732176103),(12,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 08:03:16','',1732176196),(13,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 08:45:45','',1732178745),(14,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 08:53:20','',1732179200),(15,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 09:16:18','',1732180578),(16,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 09:24:08','',1732181048),(17,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 09:39:08','',1732181948),(18,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 09:39:33','',1732181973),(19,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 09:40:51','',1732182051),(20,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 09:49:18','',1732182558),(21,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-21 09:53:07','',1732182787),(22,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 02:05:37','',1732241137),(23,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 02:05:55','',1732241155),(24,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 02:06:43','',1732241203),(25,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 02:06:56','',1732241216),(26,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 02:07:09','',1732241229),(27,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 02:07:24','',1732241244),(28,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 02:26:36','',1732242396),(29,'admin','58.48.130.168',NULL,'Linux','谷歌',1,'登录成功','2024-11-22 02:34:55','',1732242895),(30,'admin','58.48.130.168',NULL,'Mac','苹果',1,'登录成功','2024-11-22 02:40:01','',1732243201),(31,'admin','58.48.130.168',NULL,'Linux','谷歌',1,'登录成功','2024-11-22 02:40:34','',1732243234),(32,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 02:49:48','',1732243788),(33,'admin','58.48.130.168',NULL,'Linux','谷歌',1,'登录成功','2024-11-22 06:35:35','',1732257335),(34,'admin','58.48.130.168',NULL,'Mac','苹果',1,'登录成功','2024-11-22 06:36:59','',1732257419),(35,'admin','58.48.130.168',NULL,'Linux','谷歌',1,'登录成功','2024-11-22 06:38:33','',1732257513),(36,'admin','58.48.130.168',NULL,'Mac','苹果',1,'登录成功','2024-11-22 06:42:15','',1732257735),(37,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 06:54:36','',1732258476),(38,'admin','101.28.136.40',NULL,'Linux','谷歌',1,'登录成功','2024-11-22 06:55:08','',1732258508),(39,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 06:55:11','',1732258511),(40,'admin','101.28.136.40',NULL,'Linux','谷歌',1,'登录成功','2024-11-22 06:55:28','',1732258528),(41,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 06:59:33','',1732258773),(42,'admin','101.28.136.40',NULL,'Linux','谷歌',1,'登录成功','2024-11-22 07:08:59','',1732259339),(43,'admin','101.28.136.40',NULL,'Linux','谷歌',1,'登录成功','2024-11-22 07:12:25','',1732259545),(44,'admin','101.28.136.40',NULL,'Linux','谷歌',1,'登录成功','2024-11-22 07:12:38','',1732259558),(45,'admin','58.48.130.168',NULL,'Windows 10','谷歌',1,'登录成功','2024-11-22 08:44:30','',1732265070);
/*!40000 ALTER TABLE `qh_system_logger_login` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_logger_oper`
--

DROP TABLE IF EXISTS `qh_system_logger_oper`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_logger_oper` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(20) NOT NULL COMMENT '用户名',
  `method` varchar(20) NOT NULL COMMENT '请求方式',
  `router` varchar(255) NOT NULL COMMENT '请求路由',
  `service_name` varchar(30) NOT NULL COMMENT '业务名称',
  `ip` varchar(30) DEFAULT NULL COMMENT '请求IP地址',
  `ip_location` varchar(180) DEFAULT NULL COMMENT 'IP所属地',
  `request_data` json DEFAULT NULL COMMENT '请求数据',
  `response_code` varchar(5) DEFAULT NULL COMMENT '响应状态码',
  `response_data` json DEFAULT NULL COMMENT '响应数据',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `time_stamp` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作日志表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_logger_oper`
--

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

--
-- Table structure for table `qh_system_menu`
--

DROP TABLE IF EXISTS `qh_system_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_menu` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` bigint(20) unsigned DEFAULT '0' COMMENT '父ID',
  `title` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `name` varchar(100) DEFAULT NULL COMMENT '菜单别名',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `component` varchar(200) DEFAULT NULL COMMENT '组件路径',
  `path` varchar(255) DEFAULT NULL COMMENT '路由地址',
  `redirect` varchar(255) DEFAULT NULL COMMENT '跳转地址',
  `hidden` tinyint(4) NOT NULL DEFAULT '0' COMMENT '隐藏菜单 (1是 0否)',
  `type` char(10) NOT NULL DEFAULT '' COMMENT '菜单类型, (menu菜单 button按钮 link链接 iframe iframe)',
  `color` varchar(100) DEFAULT NULL COMMENT '颜色',
  `active` varchar(100) DEFAULT NULL COMMENT '菜单高亮',
  `hidden_breadcrumb` varchar(100) DEFAULT NULL COMMENT '隐藏面包屑 (1是 0否)',
  `affix` tinyint(4) DEFAULT '0' COMMENT '是否固定 (1是 0否)',
  `fullpage` tinyint(4) DEFAULT '0' COMMENT '是否整页打开路由(1是 0否)',
  `sort` tinyint(3) unsigned DEFAULT '1' COMMENT '排序',
  `updated_by` varchar(25) DEFAULT NULL COMMENT '更新者',
  `created_by` varchar(25) DEFAULT NULL COMMENT '创建者',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COMMENT='菜单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_menu`
--

LOCK TABLES `qh_system_menu` WRITE;
/*!40000 ALTER TABLE `qh_system_menu` DISABLE KEYS */;
INSERT INTO `qh_system_menu` VALUES (1,0,'首页','home','el-icon-ticket','home','/dashboard','',0,'menu','','','0',1,0,1,'systemAdmin',NULL,'2022-08-02 14:03:40','2024-04-10 18:42:54'),(2,1,'统计分析','dashboard','el-icon-menu','home','/dashboard','',0,'menu','','','0',1,0,1,'superAdmin',NULL,'2022-08-02 14:03:40','2024-05-30 15:48:42'),(4,0,'系统','setting','el-icon-setting','setting','/setting','',0,'menu','','','0',0,0,100,'systemAdmin',NULL,'2022-08-02 14:03:40','2024-04-10 18:37:58'),(5,4,'短信配置','system','el-icon-message','setting/system','/setting/system','',0,'menu','','','0',0,0,6,'systemAdmin',NULL,'2022-08-02 14:03:40','2024-05-21 15:42:22'),(6,4,'客服管理','user','el-icon-user-filled','setting/user','/setting/user','',0,'menu','','','0',0,0,2,'systemAdmin',NULL,'2022-08-02 14:03:40','2024-04-18 18:08:50'),(7,4,'角色管理','role','el-icon-notebook','setting/role','/setting/role','',0,'menu','','','0',0,0,5,'systemAdmin',NULL,'2022-08-02 14:03:40','2024-04-10 10:06:03'),(8,4,'部门管理','usergroup','sc-icon-organization','setting/usergroup','/setting/usergroup','',0,'menu','','','0',0,0,3,'systemAdmin',NULL,'2022-08-02 14:03:40','2024-04-10 10:06:06'),(9,4,'菜单管理','settingMenu','el-icon-fold','setting/menu','/setting/menu','',0,'menu','','','0',0,0,7,'systemAdmin',NULL,'2022-08-02 14:03:40','2024-04-10 10:06:08'),(10,22,'系统日志','systemlog','el-icon-warning','setting/systemlog','/setting/systemlog','',0,'menu','','','0',0,0,12,'systemAdmin',NULL,'2022-08-02 14:03:40','2024-04-10 10:05:56'),(13,22,'登录日志','loginlog','el-icon-ice-cream','setting/loginlog','/setting/loginlog','',0,'menu','','','0',0,0,10,'systemAdmin','superAdmin','2022-08-03 17:26:16','2024-04-10 10:05:51'),(14,22,'操作日志','operlog','el-icon-edit-pen','setting/operlog','/setting/operlog','',0,'menu','','','0',0,0,11,'systemAdmin','superAdmin','2022-08-03 17:26:36','2024-04-10 10:05:54'),(20,4,'文件管理','resource','el-icon-document','setting/resource','/setting/resource','',0,'menu','','','0',0,0,5,'systemAdmin','superAdmin','2022-08-22 22:24:51','2024-04-10 10:06:11'),(22,0,'日志','develop','el-icon-home-filled','develop','/develop','',0,'menu','','','0',0,0,99,'systemAdmin','','2022-08-28 15:45:02','2024-04-10 18:37:47'),(38,6,'新增/修改','useredit','','','','',0,'button','','','0',0,0,1,NULL,'superAdmin','2022-10-10 21:30:24','2022-10-10 21:30:24'),(39,4,'存储管理','storage','el-icon-connection','setting/storage','/setting/storage','',0,'menu','','','0',0,0,1,NULL,'systemAdmin','2024-04-10 10:10:28','2024-04-10 10:10:28'),(47,0,'客服','server','el-icon-avatar','server','/server','',0,'menu','','','0',0,0,1,NULL,'systemAdmin','2024-04-16 10:53:26','2024-04-16 10:53:26'),(50,47,'客户','consumer','el-icon-avatar','server/consumer','/server/consumer','',0,'menu','','','0',0,0,9,'开发者2344444','systemAdmin','2024-04-16 14:10:15','2024-06-14 11:30:45'),(51,47,'违禁词','banword','el-icon-delete','server/banword','/server/banword','',0,'menu','','','0',0,0,110,'开发者2344444','systemAdmin','2024-04-16 16:54:28','2024-06-14 11:33:06'),(52,47,'快捷回复','robot','el-icon-clock','server/robot','/server/robot','',0,'menu','','','0',0,0,80,'开发者2344444','systemAdmin','2024-04-16 17:26:02','2024-06-14 11:33:02'),(53,47,'问候语','sentence','el-icon-headset','server/sentence','/server/sentence','',0,'menu','','','0',0,0,12,'开发者2344444','systemAdmin','2024-04-17 09:41:09','2024-06-14 11:33:44'),(56,47,'聊天记录','chats','el-icon-chat-line-square','server/chats','/server/chats','',0,'menu','','','0',0,0,11,'开发者2344444','systemAdmin','2024-04-18 11:22:11','2024-06-14 11:33:41'),(57,47,'评价','comment','el-icon-chat-line-round','server/comment','/server/comment','',0,'menu','','','0',0,0,10,'开发者2344444','systemAdmin','2024-04-18 17:03:14','2024-06-14 11:30:32'),(58,4,'网站设置','setting','el-icon-setting','setting/setting','/setting/setting','',0,'menu','','','0',0,0,1,'systemAdmin','systemAdmin','2024-04-18 18:38:42','2024-06-04 16:23:48'),(59,0,'聊天','chat','el-icon-user','chat','/chat','',0,'menu','','','0',0,0,1,NULL,'systemAdmin','2024-04-23 09:45:34','2024-04-23 09:45:34'),(60,4,'邮箱配置','email','el-icon-promotion','setting/email','/setting/email','',0,'menu','','','0',0,0,1,NULL,'systemAdmin','2024-05-21 15:47:41','2024-05-21 15:47:41'),(66,1,'帐号信息','userCenter','el-icon-user','userCenter','/usercenter','',0,'menu','','','1',0,0,1,'systemAdmin','superAdmin','2024-05-30 16:00:08','2024-06-12 12:02:56'),(67,47,'常见问题','question','el-icon-bell','server/question','/server/question','',0,'menu','','','0',0,0,100,'开发者2344444','systemAdmin','2024-06-11 11:38:45','2024-06-14 11:30:15'),(69,4,'客服设置','service','el-icon-headset','setting/service','/setting/service','',0,'menu','','','0',0,0,1,NULL,'开发者2344444','2024-06-13 17:41:18','2024-06-13 17:41:18'),(75,47,'留言','serverApply','el-icon-chat-dot-square','server/apply','/server/apply','',0,'menu','','','0',0,0,1,NULL,'systemAdmin','2024-06-18 18:00:33','2024-06-18 18:00:33');
/*!40000 ALTER TABLE `qh_system_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_menu_api`
--

DROP TABLE IF EXISTS `qh_system_menu_api`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_menu_api` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `menu_id` bigint(20) unsigned NOT NULL COMMENT '菜单ID',
  `code` varchar(128) NOT NULL COMMENT '标识',
  `url` varchar(64) NOT NULL COMMENT '接口url',
  `api_method` varchar(8) NOT NULL DEFAULT 'ALL' COMMENT '请求方式 (ALL所有 POST GET PUT DELETE)',
  `is_record` tinyint(4) DEFAULT '0' COMMENT '是否记录: 0=否 1是',
  PRIMARY KEY (`id`),
  KEY `system_api_group_id_index` (`menu_id`),
  KEY `o_system_menu_api_api_method_IDX` (`api_method`,`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='接口信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_menu_api`
--

LOCK TABLES `qh_system_menu_api` WRITE;
/*!40000 ALTER TABLE `qh_system_menu_api` DISABLE KEYS */;
INSERT INTO `qh_system_menu_api` VALUES (4,38,':system.user:edit','/system.user/edit','POST',1),(7,23,'user:id','user/id','GET',0);
/*!40000 ALTER TABLE `qh_system_menu_api` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_notice`
--

DROP TABLE IF EXISTS `qh_system_notice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_notice` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(255) NOT NULL COMMENT '标题',
  `type` tinyint(4) NOT NULL COMMENT '公告类型（1通知 2公告）',
  `content` text COMMENT '公告内容',
  `read_num` int(11) DEFAULT '0' COMMENT '阅览次数',
  `created_by` varchar(25) DEFAULT NULL COMMENT '创建者',
  `updated_by` varchar(25) DEFAULT NULL COMMENT '更新者',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统公告表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_notice`
--

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

--
-- Table structure for table `qh_system_notice_read`
--

DROP TABLE IF EXISTS `qh_system_notice_read`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_notice_read` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_id` int(11) NOT NULL COMMENT '系统公告id',
  `user_id` int(11) NOT NULL COMMENT '管理员id',
  `is_read` enum('y','n') DEFAULT 'n' COMMENT '查阅: y=已查阅  n=未查阅',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统公告查阅';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_notice_read`
--

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

--
-- Table structure for table `qh_system_resource`
--

DROP TABLE IF EXISTS `qh_system_resource`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group` char(5) NOT NULL COMMENT '分组：A=服务端  B=客户端',
  `account_id` int(11) DEFAULT NULL COMMENT '账号id',
  `type` enum('image','video','audio','other') NOT NULL DEFAULT 'image' COMMENT '类型',
  `name` varchar(200) NOT NULL COMMENT '名称',
  `size` varchar(20) DEFAULT NULL COMMENT '文件大小',
  `path` varchar(120) DEFAULT NULL COMMENT '保存路径',
  `ip` varchar(20) DEFAULT NULL COMMENT '上传ip地址',
  `notes` varchar(100) DEFAULT NULL COMMENT '备注',
  `deletable` tinyint(1) DEFAULT '0' COMMENT '可删除: 1=是，0=否',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='文件资源';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_resource`
--

LOCK TABLES `qh_system_resource` WRITE;
/*!40000 ALTER TABLE `qh_system_resource` DISABLE KEYS */;
INSERT INTO `qh_system_resource` VALUES (1,'A',0,'image','Screenshot_20241106_143407.jpg','0.077MB','uploads/thumbnails/20241122/202411221537058cb8c2565.jpg','58.48.130.168',NULL,0,'2024-11-22 15:37:06');
/*!40000 ALTER TABLE `qh_system_resource` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_role`
--

DROP TABLE IF EXISTS `qh_system_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键，角色ID',
  `name` varchar(30) NOT NULL COMMENT '角色名称',
  `alias` varchar(100) NOT NULL COMMENT '角色别名',
  `data_scope` tinyint(4) DEFAULT '0' COMMENT '数据范围（0：全部数据权限 1：自定义数据权限 2：本部门数据权限 3：本部门及以下数据权限 4：本人数据权限）',
  `status` varchar(2) DEFAULT '0' COMMENT '状态 (0正常 1停用)',
  `sort` tinyint(3) unsigned DEFAULT '1' COMMENT '排序',
  `remark` varchar(250) DEFAULT NULL COMMENT '备注',
  `created_by` varchar(30) DEFAULT NULL COMMENT '创建者',
  `updated_by` varchar(30) DEFAULT NULL COMMENT '更新者',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_role`
--

LOCK TABLES `qh_system_role` WRITE;
/*!40000 ALTER TABLE `qh_system_role` DISABLE KEYS */;
INSERT INTO `qh_system_role` VALUES (1,'超级管理员','superAdmin',0,'1',1,'系统内置角色，不可删除','18397724129440','systemAdmin','2022-07-05 21:48:05','2024-05-28 16:00:48',NULL),(2,'普通管理员','ordinaryAdmin',2,'0',1,'6','superAdmin','systemAdmin','2022-09-26 17:33:51','2024-02-23 14:55:22',NULL);
/*!40000 ALTER TABLE `qh_system_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_role_dept`
--

DROP TABLE IF EXISTS `qh_system_role_dept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_role_dept` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) unsigned NOT NULL COMMENT '角色主键',
  `dept_id` bigint(20) unsigned NOT NULL COMMENT '部门主键',
  PRIMARY KEY (`id`),
  KEY `o_system_role_dept_role_id_IDX` (`role_id`,`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色与部门关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_role_dept`
--

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

--
-- Table structure for table `qh_system_role_menu`
--

DROP TABLE IF EXISTS `qh_system_role_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_role_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) unsigned NOT NULL COMMENT '角色主键',
  `menu_id` bigint(20) unsigned NOT NULL COMMENT '菜单主键',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COMMENT='角色与菜单关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_role_menu`
--

LOCK TABLES `qh_system_role_menu` WRITE;
/*!40000 ALTER TABLE `qh_system_role_menu` DISABLE KEYS */;
INSERT INTO `qh_system_role_menu` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(10,1,10),(11,1,11),(13,1,13),(14,1,14),(15,1,15),(16,1,16),(18,1,18),(19,1,19),(20,1,20),(21,1,21),(22,1,22),(23,1,23),(24,1,24),(25,1,25),(26,1,26),(27,1,27),(28,1,28),(29,1,29),(30,1,30),(31,1,31),(32,1,38),(33,1,39),(34,2,1),(35,2,2),(36,2,3),(41,2,20),(43,2,22),(44,2,4),(45,2,15),(46,2,6),(47,2,38),(48,2,39),(49,2,8),(50,2,7),(51,2,5),(52,2,9),(53,2,13),(54,2,14),(55,2,10),(56,2,11),(97,1,44),(98,2,44),(99,1,42),(100,1,41),(103,1,46),(104,1,47),(105,1,48),(106,1,49),(107,1,50),(108,1,51),(109,1,52),(110,1,53),(111,1,54),(112,1,55),(113,1,56),(114,1,57),(115,1,58),(116,1,59),(138,4,41),(139,4,58),(140,4,48),(141,4,47),(142,4,46),(143,4,42),(144,4,57),(145,4,52),(146,4,59),(147,4,56),(148,4,55),(149,4,54),(150,4,53),(151,1,64),(152,1,65),(153,1,66),(154,1,67),(155,1,68),(156,1,69),(157,1,70),(158,1,40),(159,1,43),(160,1,45),(161,1,60),(162,1,61),(163,1,62),(164,1,63),(165,1,71),(167,1,74),(168,1,75);
/*!40000 ALTER TABLE `qh_system_role_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_storage`
--

DROP TABLE IF EXISTS `qh_system_storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_storage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT '名称',
  `tags` varchar(20) DEFAULT NULL COMMENT '标签',
  `bucket` varchar(100) DEFAULT NULL COMMENT '存储空间名',
  `access_key` varchar(100) NOT NULL COMMENT 'access_key',
  `secret_key` varchar(100) NOT NULL COMMENT 'secret_key',
  `domain` varchar(100) NOT NULL COMMENT '域名',
  `region` varchar(100) NOT NULL COMMENT 'region',
  `status` varchar(1) NOT NULL DEFAULT '0' COMMENT '1启用0关闭',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  `delete_at` datetime NOT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='存储设置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_storage`
--

LOCK TABLES `qh_system_storage` WRITE;
/*!40000 ALTER TABLE `qh_system_storage` DISABLE KEYS */;
INSERT INTO `qh_system_storage` VALUES (1,'本地存储','local',NULL,'','','','','1','2024-04-10 11:12:08','2024-06-14 11:23:31','2024-04-10 11:12:08'),(2,'qiniu','qiniuTags',NULL,'','','','','0','2024-04-10 11:12:08','2024-09-13 10:53:46','2024-04-10 11:12:08'),(3,'阿里云存储','aliyun',NULL,'','','','','0','2024-04-10 11:12:08','2024-06-14 10:55:37','2024-04-10 11:12:08'),(4,'腾讯云存储','qcloud',NULL,'','','','','0','2024-04-10 11:12:08','2024-04-10 14:55:42','2024-04-10 11:12:08');
/*!40000 ALTER TABLE `qh_system_storage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_user`
--

DROP TABLE IF EXISTS `qh_system_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(20) NOT NULL COMMENT '用户名',
  `nickname` varchar(30) DEFAULT NULL COMMENT '用户昵称',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `phone` varchar(11) DEFAULT NULL COMMENT '手机',
  `email` varchar(50) DEFAULT NULL COMMENT '用户邮箱',
  `avatar` varchar(255) DEFAULT 'storage/temp/202401/8158474eced3316d8074cbf68a8cb8a1.jpg' COMMENT '用户头像',
  `signed` varchar(255) DEFAULT NULL COMMENT '个人签名',
  `dashboard` varchar(100) DEFAULT NULL COMMENT '后台首页类型',
  `role_id` varchar(100) DEFAULT '0' COMMENT '角色ID',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门id',
  `group_id` varchar(100) DEFAULT NULL COMMENT '管理员分组id',
  `gid` varchar(100) DEFAULT NULL COMMENT '部门ID',
  `sex` tinyint(4) DEFAULT '0' COMMENT '性别：0保密 1男 2女',
  `login_ip` varchar(20) DEFAULT NULL COMMENT '登录ip',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态 (0正常 1停用)',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_by` varchar(25) DEFAULT NULL COMMENT '创建者',
  `updated_by` varchar(25) DEFAULT NULL COMMENT '更新者',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_at` int(11) DEFAULT NULL COMMENT '软删除',
  `is_reply` int(1) DEFAULT '1' COMMENT '	1是第一条，2是随机，3是关闭',
  `state` int(1) DEFAULT '2' COMMENT '1是在线，2是离线',
  PRIMARY KEY (`id`),
  UNIQUE KEY `system_user_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='管理员';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_user`
--

LOCK TABLES `qh_system_user` WRITE;
/*!40000 ALTER TABLE `qh_system_user` DISABLE KEYS */;
INSERT INTO `qh_system_user` VALUES (2,'admin','系统超管账号','e10adc3949ba59abbe56e057f20f883e','13800000000','','admin/img/avatar.jpg','你好','','[1]',NULL,'1','1',2,'58.48.130.168',1,'','superAdmin','superAdmin','2022-10-09 20:19:40','2024-11-22 16:44:30',NULL,1,2);
/*!40000 ALTER TABLE `qh_system_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_user_group`
--

DROP TABLE IF EXISTS `qh_system_user_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_user_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL COMMENT '用户主键',
  `group_id` bigint(20) unsigned NOT NULL COMMENT '角色主键',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `o_system_role_dept_role_id_IDX` (`user_id`,`group_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COMMENT='角色与部门关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_user_group`
--

LOCK TABLES `qh_system_user_group` WRITE;
/*!40000 ALTER TABLE `qh_system_user_group` DISABLE KEYS */;
INSERT INTO `qh_system_user_group` VALUES (22,24,8,'2024-04-29 16:10:26'),(23,24,4,'2024-04-29 16:10:26'),(24,24,9,'2024-04-29 16:10:26'),(27,25,1,'2024-05-27 16:51:40'),(29,27,8,'2024-05-27 16:58:03'),(33,26,8,'2024-05-27 17:00:31'),(34,29,1,'2024-05-28 15:38:50'),(35,29,6,'2024-05-28 15:38:50'),(36,30,1,'2024-05-28 15:43:09'),(37,30,6,'2024-05-28 15:43:09'),(41,32,8,'2024-05-30 15:43:56'),(43,33,1,'2024-05-30 15:47:52'),(44,34,1,'2024-05-30 16:37:20'),(45,34,6,'2024-05-30 16:37:20'),(48,35,8,'2024-05-30 17:42:05'),(54,22,1,'2024-05-31 14:36:43'),(58,31,1,'2024-05-31 15:20:48'),(59,36,1,'2024-05-31 15:58:46'),(61,39,1,'2024-06-07 09:47:57'),(63,28,1,'2024-06-07 18:20:52'),(64,4,19,'2024-07-31 17:57:43');
/*!40000 ALTER TABLE `qh_system_user_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qh_system_user_role`
--

DROP TABLE IF EXISTS `qh_system_user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qh_system_user_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL COMMENT '用户主键',
  `role_id` bigint(20) unsigned NOT NULL COMMENT '角色主键',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `o_system_role_dept_role_id_IDX` (`user_id`,`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COMMENT='角色与部门关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `qh_system_user_role`
--

LOCK TABLES `qh_system_user_role` WRITE;
/*!40000 ALTER TABLE `qh_system_user_role` DISABLE KEYS */;
INSERT INTO `qh_system_user_role` VALUES (4,1,1,NULL),(22,2,1,'2024-04-29 16:10:26'),(23,2,2,'2024-04-29 16:10:26'),(24,2,4,'2024-04-29 16:10:26'),(27,3,1,'2024-05-15 16:30:03'),(28,25,1,'2024-05-27 16:51:40'),(30,27,4,'2024-05-27 16:58:03'),(34,26,2,'2024-05-27 17:00:31'),(35,29,1,'2024-05-28 15:38:50'),(36,29,2,'2024-05-28 15:38:50'),(37,30,1,'2024-05-28 15:43:09'),(38,30,2,'2024-05-28 15:43:09'),(42,32,2,'2024-05-30 15:43:56'),(44,33,2,'2024-05-30 15:47:52'),(45,34,1,'2024-05-30 16:37:20'),(46,34,2,'2024-05-30 16:37:20'),(49,35,2,'2024-05-30 17:42:05'),(55,23,1,'2024-05-31 14:36:02'),(56,23,2,'2024-05-31 14:36:02'),(58,22,2,'2024-05-31 14:36:43'),(62,31,1,'2024-05-31 15:20:48'),(63,36,4,'2024-05-31 15:58:46'),(65,39,2,'2024-06-07 09:47:57'),(69,11,2,'2024-06-07 18:20:18'),(70,28,7,'2024-06-07 18:20:52'),(71,12,2,'2024-06-07 18:21:58'),(72,12,4,'2024-06-07 18:21:58'),(73,4,2,'2024-07-31 17:57:43');
/*!40000 ALTER TABLE `qh_system_user_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'gcustomer_sharea'
--

--
-- Dumping routines for database 'gcustomer_sharea'
--
/*!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 2024-11-22 17:04:23