-- MySQL dump 10.13  Distrib 8.0.20, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: teasale
-- ------------------------------------------------------
-- Server version	8.0.20

/*!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 `goods`
--

DROP TABLE IF EXISTS `goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `goods` (
  `goods_id` int NOT NULL AUTO_INCREMENT COMMENT '商品编号',
  `goods_name` varchar(11) NOT NULL COMMENT '商品名称',
  `goods_num` int NOT NULL COMMENT '数量',
  `goods_price` double(5,0) NOT NULL COMMENT '商品价格',
  `goods_imgurl` varchar(225) DEFAULT NULL COMMENT '商品图片',
  `goods_des` varchar(225) DEFAULT NULL COMMENT '商品描述',
  `goods_out_id` varchar(225) NOT NULL,
  PRIMARY KEY (`goods_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods`
--

LOCK TABLES `goods` WRITE;
/*!40000 ALTER TABLE `goods` DISABLE KEYS */;
INSERT INTO `goods` (`goods_id`, `goods_name`, `goods_num`, `goods_price`, `goods_imgurl`, `goods_des`, `goods_out_id`) VALUES (1,'白牡丹茶叶',1,168,'https://www.chali.com/assets/images/1-little.9011b2a.jpg','①福鼎白牡丹，福建茗茶，是白茶中的上乘佳品\n\n②富含多种维生素、微量元素，是当今公认安全又营养的茶品','25245254'),(2,'铁观音茶叶',1,168,'https://www.chali.com/assets/images/1-little.e271aea.jpg','①福建安溪铁观音，属乌龙茶极品，中国名茶之一；\n\n②滋味醇厚甘鲜，稍带蜜味，鲜爽回甘；','4567867867'),(3,'大红袍茶叶',1,168,'https://www.chali.com/assets/images/1-little.766d408.jpg','①产自福建武夷山，素有“茶中状元”之美誉，乃岩茶之王；\n\n②兼有红茶的甘醇、绿茶的清香；回甘明显，回味足；','7867375354'),(4,'普洱茶叶',1,168,'https://www.chali.com/assets/images/1-little.dd6cec2.jpg','①云南普洱，收藏价值颇高；\n\n②普洱陈酽、透润；茶味整体醇和爽滑，陈香平稳；\n\n③商务男士，年长老茶客钟爱此款口味。','786378373'),(5,'绿茶叶',1,68,'https://www.chali.com/assets/images/1-little.e298198.jpg','①产自“仙茶之乡”蒙顶山毛峰；\n\n②茶香清香持久，滋味鲜醇甘爽；','78367342'),(6,'普洱茶叶',1,68,'https://www.chali.com/assets/images/1-little.ac188bb.jpg','①4年熟普，产自普洱市茶区，普洱陈酽、透润\n\n②茶味醇和爽滑，陈香平稳；','786373');
/*!40000 ALTER TABLE `goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_goods`
--

DROP TABLE IF EXISTS `order_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_goods` (
  `og_id` int NOT NULL AUTO_INCREMENT COMMENT '订单商品唯一标识',
  `goods_out_id` varchar(225) NOT NULL COMMENT '商品编号',
  `order_out_id` varchar(225) NOT NULL COMMENT '订单编号',
  `og_num` int NOT NULL COMMENT '购买数量',
  `og_price` double(5,0) NOT NULL COMMENT '总价',
  PRIMARY KEY (`og_id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='订单商品表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_goods`
--

LOCK TABLES `order_goods` WRITE;
/*!40000 ALTER TABLE `order_goods` DISABLE KEYS */;
INSERT INTO `order_goods` (`og_id`, `goods_out_id`, `order_out_id`, `og_num`, `og_price`) VALUES (36,'4567867867','2023061219501514195900001',2,2),(37,'25245254','2023061219502253249400001',2,2),(38,'25245254','2023061219592992884100003',2,168),(39,'4567867867','2023061219593644847200003',1,168),(40,'4567867867','2023061220002595866300003',2,7),(41,'4567867867','2023061220002595866300003',2,7),(42,'7867375354','2023061220043046634400003',1,168),(43,'4567867867','2023061220044034478600003',1,168),(44,'78367342','2023061220052243228200003',1,1),(45,'78367342','2023061220053510512700003',1,1),(46,'78367342','2023061220053510512700003',1,1);
/*!40000 ALTER TABLE `order_goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `s_order`
--

DROP TABLE IF EXISTS `s_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `s_order` (
  `order_id` int NOT NULL AUTO_INCREMENT COMMENT '订单编号',
  `order_time` datetime NOT NULL COMMENT '创建时间',
  `order_statu` tinyint(1) NOT NULL COMMENT '订单发货状态',
  `order_pay` tinyint(1) NOT NULL COMMENT '订单支付状态',
  `order_price` double NOT NULL COMMENT '订单总价',
  `user_id` int DEFAULT NULL,
  `order_out_id` varchar(225) NOT NULL,
  PRIMARY KEY (`order_id`),
  KEY `s_order_s_user_user_id_fk` (`user_id`),
  CONSTRAINT `s_order_s_user_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `s_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `s_order`
--

LOCK TABLES `s_order` WRITE;
/*!40000 ALTER TABLE `s_order` DISABLE KEYS */;
INSERT INTO `s_order` (`order_id`, `order_time`, `order_statu`, `order_pay`, `order_price`, `user_id`, `order_out_id`) VALUES (27,'2023-06-12 19:43:41',0,0,4567867904,1,'2023061219434053192500001'),(28,'2023-06-12 19:44:06',0,0,4567867904,1,'2023061219440609341100001'),(29,'2023-06-12 19:44:30',0,0,4567867904,1,'2023061219442960411100001'),(30,'2023-06-12 19:46:27',0,0,4567867904,1,'2023061219462667497900001'),(31,'2023-06-12 19:46:42',0,0,7867375104,1,'2023061219464150577100001'),(32,'2023-06-12 19:48:32',0,0,7867375104,1,'2023061219483237158400001'),(33,'2023-06-12 19:49:35',0,0,7867375104,1,'2023061219493483541400001'),(34,'2023-06-12 19:50:15',0,0,4567867904,1,'2023061219501514195900001'),(35,'2023-06-12 19:50:23',0,0,25245254,1,'2023061219502253249400001'),(36,'2023-06-12 19:59:30',0,0,1,3,'2023061219592992884100003'),(37,'2023-06-12 19:59:36',0,0,2,3,'2023061219593644847200003'),(38,'2023-06-12 20:00:26',0,0,786378368,3,'2023061220002595866300003'),(39,'2023-06-12 20:04:30',0,0,3,3,'2023061220043046634400003'),(40,'2023-06-12 20:04:40',0,0,2,3,'2023061220044034478600003'),(41,'2023-06-12 20:05:22',0,0,78367344,3,'2023061220052243228200003'),(42,'2023-06-12 20:05:35',0,0,786373,3,'2023061220053510512700003');
/*!40000 ALTER TABLE `s_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `s_role`
--

DROP TABLE IF EXISTS `s_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `s_role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `s_role`
--

LOCK TABLES `s_role` WRITE;
/*!40000 ALTER TABLE `s_role` DISABLE KEYS */;
INSERT INTO `s_role` (`id`, `name`) VALUES (1,'manager'),(2,'personnel');
/*!40000 ALTER TABLE `s_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `s_user`
--

DROP TABLE IF EXISTS `s_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `s_user` (
  `user_name` varchar(12) NOT NULL COMMENT '用户名',
  `user_password` varchar(15) NOT NULL COMMENT '密码',
  `user_phone` char(11) DEFAULT NULL COMMENT '手机',
  `user_adderss` varchar(20) DEFAULT NULL COMMENT '地址',
  `user_sex` tinyint(1) NOT NULL COMMENT '性别',
  `user_id` int NOT NULL AUTO_INCREMENT,
  `user_out_id` varchar(225) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `s_user`
--

LOCK TABLES `s_user` WRITE;
/*!40000 ALTER TABLE `s_user` DISABLE KEYS */;
INSERT INTO `s_user` (`user_name`, `user_password`, `user_phone`, `user_adderss`, `user_sex`, `user_id`, `user_out_id`) VALUES ('water003','010505','131888888','广东',1,1,NULL),('water004','123456','131888888','深圳',1,2,NULL),('admin','admin','13188888888','深圳',1,3,'11');
/*!40000 ALTER TABLE `s_user` 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 2023-06-19 20:16:41