226 lines
20 KiB
SQL
226 lines
20 KiB
SQL
-- MySQL dump 10.13 Distrib 8.0.31, for Win64 (x86_64)
|
||
--
|
||
-- Host: 192.168.101.68 Database: jzo2o-market
|
||
-- ------------------------------------------------------
|
||
-- Server version 8.0.26
|
||
|
||
/*!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 */;
|
||
|
||
--
|
||
-- Current Database: `jzo2o-market`
|
||
--
|
||
|
||
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jzo2o-market` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
|
||
|
||
USE `jzo2o-market`;
|
||
|
||
--
|
||
-- Table structure for table `activity`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `activity`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `activity` (
|
||
`id` bigint NOT NULL COMMENT '活动id',
|
||
`name` varchar(100) NOT NULL DEFAULT '0' COMMENT '活动名称',
|
||
`type` int NOT NULL COMMENT '优惠券类型，1：满减，2：折扣',
|
||
`amount_condition` decimal(10,2) NOT NULL COMMENT '使用条件，0：表示无门槛，其他值：最低消费金额',
|
||
`discount_rate` int NOT NULL DEFAULT '0' COMMENT '折扣率，折扣类型的折扣率，8折就是存80',
|
||
`discount_amount` decimal(10,2) DEFAULT NULL COMMENT '优惠金额，满减或无门槛的优惠金额',
|
||
`validity_days` int NOT NULL DEFAULT '0' COMMENT '优惠券有效期天数，0：表示有效期是指定有效期的',
|
||
`distribute_start_time` datetime NOT NULL COMMENT '发放开始时间',
|
||
`distribute_end_time` datetime NOT NULL COMMENT '发放结束时间',
|
||
`status` int NOT NULL COMMENT '活动状态，1：待生效，2：进行中，3：已失效 4：作废',
|
||
`total_num` int NOT NULL DEFAULT '0' COMMENT '发放数量，0：表示无限量，其他正数表示最大发放量',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`create_by` bigint DEFAULT NULL COMMENT '创建人',
|
||
`update_by` bigint DEFAULT NULL COMMENT '更新人',
|
||
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除',
|
||
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 `activity`
|
||
--
|
||
|
||
LOCK TABLES `activity` WRITE;
|
||
/*!40000 ALTER TABLE `activity` DISABLE KEYS */;
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706183021040336896,'测试活动测试1',2,1.00,10,20.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 13:45:06','2023-10-13 12:23:35',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706183503305605120,'测试活动02',2,1.00,10,NULL,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 13:47:01','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706190059321524224,'测试活动02',2,1.00,10,100.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 14:13:04','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706191283810828288,'测试活动02',2,1.00,10,NULL,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 14:17:56','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706191734941777920,'测试活动02',2,1.00,10,20.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 14:19:43','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706192483608264704,'测试活动02',2,1.00,10,40.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 14:22:42','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706217591922974720,'测试活动02',2,1.00,10,100.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 16:02:28','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706220087122812928,'测试活动02',2,1.00,10,100.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 16:12:23','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706233323863891968,'测试活动02',2,1.00,10,NULL,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 17:04:59','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706233782053855232,'测试活动02',2,1.00,10,NULL,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 17:06:48','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706234166671532032,'测试活动02',2,1.00,10,NULL,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 17:08:20','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706235631427346432,'测试活动02',2,1.00,10,100.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-25 17:14:09','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706501272482832384,'测试活动02',2,1.00,10,NULL,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-26 10:49:43','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706502468744470528,'测试活动02',2,1.00,10,NULL,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-26 10:54:28','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706511155529736192,'测试活动02',2,1.00,10,0.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-26 11:28:59','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706550497505665024,'测试活动02',2,1.00,10,20.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-26 14:05:19','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706661702914801664,'测试活动02',2,1.00,10,10.00,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-26 13:28:05','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
INSERT INTO `activity` (`id`, `name`, `type`, `amount_condition`, `discount_rate`, `discount_amount`, `validity_days`, `distribute_start_time`, `distribute_end_time`, `status`, `total_num`, `create_time`, `update_time`, `create_by`, `update_by`, `is_deleted`) VALUES (1706662031551102976,'测试活动02',2,1.00,10,NULL,1,'2023-09-30 00:00:01','2023-10-29 00:00:02',2,11,'2023-09-26 13:29:23','2023-10-10 06:56:33',1674350264389750786,NULL,0);
|
||
/*!40000 ALTER TABLE `activity` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `coupon`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `coupon`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `coupon` (
|
||
`id` bigint NOT NULL COMMENT '优惠券id',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '优惠券名称',
|
||
`user_id` bigint NOT NULL COMMENT '优惠券的拥有者',
|
||
`user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户姓名',
|
||
`user_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户手机号',
|
||
`activity_id` bigint NOT NULL COMMENT '活动id',
|
||
`type` int NOT NULL COMMENT '使用类型，1：满减，2：折扣',
|
||
`discount_rate` int DEFAULT '0' COMMENT '折扣',
|
||
`discount_amount` decimal(10,2) DEFAULT NULL COMMENT '优惠金额',
|
||
`amount_condition` decimal(10,2) NOT NULL COMMENT '满减金额',
|
||
`validity_time` datetime DEFAULT NULL COMMENT '有效期',
|
||
`use_time` datetime DEFAULT NULL COMMENT '使用时间',
|
||
`status` tinyint NOT NULL COMMENT '优惠券状态，1:未使用，2:已使用，3:已过期',
|
||
`orders_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '订单id',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '逻辑删除',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `user_my_query_index` (`user_id`,`status`) USING BTREE COMMENT '用户查询我的优惠券快捷索引'
|
||
) 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 `coupon`
|
||
--
|
||
|
||
LOCK TABLES `coupon` WRITE;
|
||
/*!40000 ALTER TABLE `coupon` DISABLE KEYS */;
|
||
INSERT INTO `coupon` (`id`, `name`, `user_id`, `user_name`, `user_phone`, `activity_id`, `type`, `discount_rate`, `discount_amount`, `amount_condition`, `validity_time`, `use_time`, `status`, `orders_id`, `create_time`, `update_time`, `is_deleted`) VALUES (1706572794252230656,'双12五折大促a',1701074772546342912,'微信用户','18703810075',1706502468744470528,2,50,NULL,1.00,'2023-09-27 15:33:55',NULL,4,NULL,'2023-09-26 07:34:47','2023-09-26 08:40:00',0);
|
||
INSERT INTO `coupon` (`id`, `name`, `user_id`, `user_name`, `user_phone`, `activity_id`, `type`, `discount_rate`, `discount_amount`, `amount_condition`, `validity_time`, `use_time`, `status`, `orders_id`, `create_time`, `update_time`, `is_deleted`) VALUES (1706573370457325568,'个人测试活动，请勿撤销a',1701074772546342912,'微信用户','18703810075',1706501272482832384,2,60,NULL,100.00,'2023-10-06 15:36:13',NULL,1,NULL,'2023-09-26 07:37:05','2023-09-26 07:37:05',0);
|
||
INSERT INTO `coupon` (`id`, `name`, `user_id`, `user_name`, `user_phone`, `activity_id`, `type`, `discount_rate`, `discount_amount`, `amount_condition`, `validity_time`, `use_time`, `status`, `orders_id`, `create_time`, `update_time`, `is_deleted`) VALUES (1706574712655577088,'尊享双十一活动',1701074772546342912,'微信用户','18703810075',1706234166671532032,2,80,NULL,1.00,'2023-10-16 15:41:33','2023-09-26 15:45:40',2,'2309260000000000064','2023-09-26 07:42:25','2023-09-26 07:46:31',0);
|
||
INSERT INTO `coupon` (`id`, `name`, `user_id`, `user_name`, `user_phone`, `activity_id`, `type`, `discount_rate`, `discount_amount`, `amount_condition`, `validity_time`, `use_time`, `status`, `orders_id`, `create_time`, `update_time`, `is_deleted`) VALUES (1712807553873780736,'测试活动测试1',1695339358949949440,'微信用户','18810966207',1706183021040336896,2,10,20.00,1.00,'2023-10-14 20:28:38',NULL,1,NULL,'2023-10-13 12:29:33','2023-10-13 12:29:33',0);
|
||
INSERT INTO `coupon` (`id`, `name`, `user_id`, `user_name`, `user_phone`, `activity_id`, `type`, `discount_rate`, `discount_amount`, `amount_condition`, `validity_time`, `use_time`, `status`, `orders_id`, `create_time`, `update_time`, `is_deleted`) VALUES (1712808672419160064,'测试活动测试1',1694250327664218112,'微信用户','18860355196',1706183021040336896,2,10,20.00,1.00,'2023-10-14 20:33:05',NULL,1,NULL,'2023-10-13 12:34:00','2023-10-13 12:34:00',0);
|
||
/*!40000 ALTER TABLE `coupon` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `coupon_use_back`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `coupon_use_back`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `coupon_use_back` (
|
||
`id` bigint NOT NULL COMMENT '回退记录id',
|
||
`coupon_id` bigint NOT NULL COMMENT '优惠券id',
|
||
`user_id` bigint NOT NULL COMMENT '用户id',
|
||
`use_back_time` datetime NOT NULL COMMENT '回退时间',
|
||
`write_off_time` datetime DEFAULT NULL COMMENT '核销时间',
|
||
PRIMARY KEY (`id`) 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 `coupon_use_back`
|
||
--
|
||
|
||
LOCK TABLES `coupon_use_back` WRITE;
|
||
/*!40000 ALTER TABLE `coupon_use_back` DISABLE KEYS */;
|
||
INSERT INTO `coupon_use_back` (`id`, `coupon_id`, `user_id`, `use_back_time`, `write_off_time`) VALUES (1706573094639894528,1706572794252230656,1701074772546342912,'2023-09-26 15:35:07','2023-09-26 15:34:40');
|
||
INSERT INTO `coupon_use_back` (`id`, `coupon_id`, `user_id`, `use_back_time`, `write_off_time`) VALUES (1706575665811161088,1706574712655577088,1701074772546342912,'2023-09-26 15:45:20','2023-09-26 15:44:02');
|
||
/*!40000 ALTER TABLE `coupon_use_back` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `coupon_write_off`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `coupon_write_off`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `coupon_write_off` (
|
||
`id` bigint NOT NULL,
|
||
`coupon_id` bigint NOT NULL COMMENT '优惠券id',
|
||
`user_id` bigint NOT NULL COMMENT '用户id',
|
||
`orders_id` bigint NOT NULL COMMENT '核销时使用的订单号',
|
||
`activity_id` bigint NOT NULL COMMENT '活动id',
|
||
`write_off_time` datetime NOT NULL COMMENT '核销时间',
|
||
`write_off_man_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '核销人手机号',
|
||
`write_off_man_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '核销人姓名',
|
||
PRIMARY KEY (`id`) 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 `coupon_write_off`
|
||
--
|
||
|
||
LOCK TABLES `coupon_write_off` WRITE;
|
||
/*!40000 ALTER TABLE `coupon_write_off` DISABLE KEYS */;
|
||
INSERT INTO `coupon_write_off` (`id`, `coupon_id`, `user_id`, `orders_id`, `activity_id`, `write_off_time`, `write_off_man_phone`, `write_off_man_name`) VALUES (1706572983394369536,1706572794252230656,1701074772546342912,2309260000000000062,1706502468744470528,'2023-09-26 15:34:40','18703810075','微信用户');
|
||
INSERT INTO `coupon_write_off` (`id`, `coupon_id`, `user_id`, `orders_id`, `activity_id`, `write_off_time`, `write_off_man_phone`, `write_off_man_name`) VALUES (1706575339234263040,1706574712655577088,1701074772546342912,2309260000000000063,1706234166671532032,'2023-09-26 15:44:02','18703810075','微信用户');
|
||
INSERT INTO `coupon_write_off` (`id`, `coupon_id`, `user_id`, `orders_id`, `activity_id`, `write_off_time`, `write_off_man_phone`, `write_off_man_name`) VALUES (1706575747860135936,1706574712655577088,1701074772546342912,2309260000000000064,1706234166671532032,'2023-09-26 15:45:40','18703810075','微信用户');
|
||
/*!40000 ALTER TABLE `coupon_write_off` ENABLE KEYS */;
|
||
UNLOCK TABLES;
|
||
|
||
--
|
||
-- Table structure for table `undo_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `undo_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `undo_log` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT,
|
||
`branch_id` bigint NOT NULL,
|
||
`xid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
||
`context` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
|
||
`rollback_info` longblob NOT NULL,
|
||
`log_status` int NOT NULL,
|
||
`log_created` datetime NOT NULL,
|
||
`log_modified` datetime NOT NULL,
|
||
`ext` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping data for table `undo_log`
|
||
--
|
||
|
||
LOCK TABLES `undo_log` WRITE;
|
||
/*!40000 ALTER TABLE `undo_log` DISABLE KEYS */;
|
||
/*!40000 ALTER TABLE `undo_log` 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-11-04 11:19:07
|