代码拉取完成，页面将自动刷新
-- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64)
--
-- Host: localhost Database: back_system
-- ------------------------------------------------------
-- Server version 8.0.39
/*!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 */;
/*!50503 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 `files`
--
DROP TABLE IF EXISTS `files`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `files` (
`id` int NOT NULL AUTO_INCREMENT,
`file_name` varchar(255) DEFAULT NULL,
`file_url` varchar(255) DEFAULT NULL,
`file_size` varchar(255) DEFAULT NULL,
`upload_person` varchar(255) DEFAULT NULL,
`upload_time` varchar(255) DEFAULT NULL,
`download_number` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `files`
--
/*!40000 ALTER TABLE `files` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `image`
--
DROP TABLE IF EXISTS `image`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `image` (
`id` int NOT NULL AUTO_INCREMENT,
`image_url` varchar(255) DEFAULT NULL,
`account` int DEFAULT NULL,
`onlyId` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `image`
--
LOCK TABLES `image` WRITE;
/*!40000 ALTER TABLE `image` DISABLE KEYS */;
INSERT INTO `image` VALUES (13,'http://127.0.0.1:3007/upload/avatar.jpg',123666,'b8df7fcd-15b7-40be-8e9e-76d72b1ed84b'),(14,'http://127.0.0.1:3007/upload/6.jpg',123456,'da0c304b-19a1-41be-bf06-050d21fbeae6');
LOCK TABLES `login_log` WRITE;
/*!40000 ALTER TABLE `login_log` DISABLE KEYS */;
INSERT INTO `login_log` VALUES (8,123456,NULL,NULL,'2024-08-28 19:56:59.209'),(9,123456,'张三','[email protected]','2024-08-29 19:20:26.153'),(10,123456,'张三','[email protected]','2024-08-29 19:26:07.857'),(11,123111,'李四','[email protected]','2024-08-29 21:13:46.818'),(12,123456,'张四','[email protected]','2024-08-31 13:05:51.517'),(13,123456,'张四','[email protected]','2024-08-31 19:32:11.792'),(14,123456,'张四','[email protected]','2024-08-31 21:51:13.100'),(15,123456,'张四','[email protected]','2024-08-31 22:17:25.319'),(16,123456,'张四','[email protected]','2024-08-31 22:26:27.781'),(17,123456,'张四','[email protected]','2024-09-01 09:23:20.937'),(18,123666,'张三','[email protected]','2024-09-01 13:22:13.526'),(19,123456,'张四','[email protected]','2024-09-01 19:08:51.074'),(20,123456,'张四','[email protected]','2024-09-01 19:09:27.839');
/*!40000 ALTER TABLE `login_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message`
--
DROP TABLE IF EXISTS `message`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `message` (
`id` int NOT NULL AUTO_INCREMENT,
`message_title` varchar(255) DEFAULT NULL,
`message_category` varchar(255) DEFAULT NULL,
`message_publish_department` varchar(255) DEFAULT NULL,
`message_publish_name` varchar(255) DEFAULT NULL,
`message_receipt_object` varchar(255) DEFAULT NULL,
`message_click_number` int DEFAULT NULL,
`message_content` varchar(255) DEFAULT NULL,
`message_publish_time` varchar(255) DEFAULT NULL,
`message_update_time` varchar(255) DEFAULT NULL,
`message_level` varchar(255) DEFAULT NULL,
`message_status` int DEFAULT NULL,
`message_delete_time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb3;
/*!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 (36,'测试','公司公告','总裁办','null','全体成员',0,'','2024-08-28 20:07:43.986','2024-08-31 19:01:50.924','一般',0,'2024-08-31 13:12:40.815'),(37,'放假','公司公告','总裁办','张三','总裁办',0,'<p><br></p>','2024-08-29 19:21:05.740','2024-08-31 19:23:03.576','一般',0,'2024-08-31 19:14:05.112'),(38,'加班','公司公告','总裁办','张三','组织部',0,'<p><br></p>','2024-08-29 19:26:35.185',NULL,'一般',0,NULL),(39,'吃鸡','公司公告','总裁办','张三','总裁办',0,'<p><br></p>','2024-08-29 19:27:10.515','2024-08-31 21:30:22.557','重要',0,'2024-08-31 21:30:13.927'),(40,'吃鸡','公司公告','总裁办','张三','组织部',0,'<p><br></p>','2024-08-29 19:30:59.056','2024-08-31 23:14:25.580','重要',0,'2024-08-31 19:33:05.669'),(44,'大吉大利','公司公告','组织部','李四','总裁办',0,'<p>12</p>','2024-08-29 21:14:16.092','2024-08-31 23:16:25.784','一般',0,'2024-08-31 19:14:53.806'),(45,'昨天','公司公告','组织部','李四','组织部',0,'','2024-08-29 21:15:56.426','2024-08-31 19:52:26.572','一般',0,'2024-08-31 19:46:14.993'),(47,'消息发布测试','公司公告','总裁办','张四','总裁办',0,'<p>测试</p>','2024-08-31 19:18:45.952','2024-08-31 21:42:57.035','一般',0,'2024-08-31 21:42:45.909'),(49,'组织部','公司公告','组织部','张四','组织部',0,'','2024-08-31 19:56:52.875',NULL,'一般',0,NULL),(50,'发布公告测试','公司公告','组织部','张四','组织部',0,'','2024-08-31 20:02:13.756',NULL,'一般',0,NULL),(59,'系统版本1.0','系统消息','','张四','',0,'<p>初次发布</p>','2024-08-31 21:51:50.375',NULL,'',0,NULL);
LOCK TABLES `operation_log` WRITE;
/*!40000 ALTER TABLE `operation_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `operation_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `outproduct`
--
DROP TABLE IF EXISTS `outproduct`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `outproduct` (
`id` int NOT NULL AUTO_INCREMENT,
`product_out_id` int DEFAULT NULL,
`product_out_number` int DEFAULT NULL,
`product_out_price` int DEFAULT NULL,
`product_out_apply_person` varchar(255) DEFAULT NULL,
`product_audit_time` varchar(255) DEFAULT NULL,
`product_out_audit_person` varchar(255) DEFAULT NULL,
`audit_memo` varchar(255) DEFAULT NULL,
`product_apply_time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `outproduct`
--
LOCK TABLES `outproduct` WRITE;
/*!40000 ALTER TABLE `outproduct` DISABLE KEYS */;
LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES (10,1001,'苹果','食品类','个',200,3,600,NULL,'张三','2024-08-28 20:16:48.555',NULL,NULL,10001,10,30,'张三','2024-09-01 13:45:25.626','','申请出库',NULL,NULL,NULL),(11,1002,'香蕉','食品类','个',600,2,1200,NULL,'李四','2024-08-28 20:17:22.967',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,1003,'太阳帽','服装类','件',300,15,4500,NULL,'张三','2024-09-01 13:46:42.470',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `setting`
--
DROP TABLE IF EXISTS `setting`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `setting` (
`id` int NOT NULL,
`set_name` varchar(255) DEFAULT NULL,
`set_value` varchar(255) DEFAULT NULL,
`set_text` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `setting`
--
LOCK TABLES `setting` WRITE;
/*!40000 ALTER TABLE `setting` DISABLE KEYS */;
INSERT INTO `setting` VALUES (1,'swiper1','http://127.0.0.1:3007/upload/11.jpg',NULL),(2,'swiper2','http://127.0.0.1:3007/upload/12.jpg',NULL),(3,'swiper3','http://127.0.0.1:3007/upload/13.jpg',NULL),(4,'swiper4','http://127.0.0.1:3007/upload/15.jpg',NULL),(5,'swiper5','http://127.0.0.1:3007/upload/16.jpg',NULL),(6,'swiper6','http://127.0.0.1:3007/upload/00.jpg',NULL),(7,'公司名称','广东省梅州市兴宁市',NULL),(8,'公司介绍',NULL,'<p>欢迎关注前端小王hs</p>'),(9,'公司架构',NULL,'<p>前端小王hs</p>'),(10,'公司战略',NULL,'<p>前端小王hs是清华大学出版社签约作者</p>'),(11,'公司高层',NULL,'<p>敬请期待小王hs的nest+uniapp项目</p>'),(12,'部门设置','[\"总裁办\",\"组织部\",\"技术部\"]',NULL),(13,'产品设置','[\"食品类\",\"服装类\"]',NULL);
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (43,123666,'$2a$10$TyJm48diZ6VgnsjxSdEKBOR9rfAiH/pcVjrH/RjUKzVWkakNFPBcu','超级管理员','总裁办','张三','男','[email protected]','http://127.0.0.1:3007/upload/avatar.jpg','2024-01-31 10:44:18.102',NULL,'0','[38,36,44]',1),(49,123456,'$2b$10$nK4CKn.sCG8b7aYGD2Y33.JnX5cJEZvuMFdbOllGEduERZ8djeDTq','用户','总裁办','张四','男','[email protected]','http://127.0.0.1:3007/upload/6.jpg','2024-08-28 19:56:35.595','2024-08-28 20:17:47.504','0','[44]',1),(50,123111,'$2b$10$MCq69ivyWVj87HCraOZqwOmE/5rGJFqh3Q8bbQos/dwx0MWO.aGeG','产品管理员','组织部','李三','男','[email protected]',NULL,'2024-08-28 20:18:24.986','2024-08-31 23:28:02.182','0','[38,48,47,40]',1),(51,123222,'$2b$10$gUTz5P0oI8vHq6SJgqmECeXX7d2LGhT3jR61mNq2ivmElfOq.uJ2S','消息管理员','组织部','张无忌','男','[email protected]',NULL,'2024-08-28 20:21:41.095',NULL,'0',NULL,0);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping routines for database 'back_system'
--
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手