-- MySQL dump 10.13  Distrib 5.7.44, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: virtual_mall
-- ------------------------------------------------------
-- 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 utf8 */;
/*!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 `article`
--

DROP TABLE IF EXISTS `article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `article_title` varchar(255) DEFAULT NULL COMMENT '文章名称',
  `article_content` longblob COMMENT '文章内容',
  `state` varchar(255) DEFAULT NULL COMMENT '状态',
  `article_tag_ids` varchar(255) DEFAULT NULL COMMENT '文章标签',
  `article_topic_id` int(11) DEFAULT NULL COMMENT '文章主题id',
  `image` varchar(255) DEFAULT NULL COMMENT '图片',
  `publish_time` datetime DEFAULT NULL COMMENT '发表时间',
  `eye_fill` int(11) DEFAULT NULL COMMENT '浏览量',
  `like_count` int(255) DEFAULT NULL COMMENT '点赞量',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文章';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article`
--

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

--
-- Table structure for table `article_tag`
--

DROP TABLE IF EXISTS `article_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_name` varchar(255) DEFAULT NULL COMMENT '标签名',
  `tag_desc` varchar(255) DEFAULT NULL COMMENT '标签描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文章标签';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_tag`
--

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

--
-- Table structure for table `article_topic`
--

DROP TABLE IF EXISTS `article_topic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_topic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(255) NOT NULL COMMENT '图片',
  `topic_name` varchar(255) DEFAULT NULL COMMENT '主题名称',
  `topic_desc` varchar(255) DEFAULT NULL COMMENT '主题描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文章主题';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_topic`
--

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

--
-- Table structure for table `back_authority`
--

DROP TABLE IF EXISTS `back_authority`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `back_authority` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `authority_name` varchar(255) DEFAULT NULL COMMENT '接口名',
  `authority_path` varchar(255) DEFAULT NULL COMMENT '接口路径',
  `method` varchar(8) DEFAULT NULL COMMENT '方法',
  `state` varchar(5) DEFAULT NULL COMMENT '接口是否启用(0关闭，1启用)',
  `authority_verification` varchar(255) DEFAULT 'true' COMMENT '权限校验',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台权限校验';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `back_authority`
--

LOCK TABLES `back_authority` WRITE;
/*!40000 ALTER TABLE `back_authority` DISABLE KEYS */;
INSERT INTO `back_authority` VALUES (1,'获取用户信息','/user/info','GET','1','log','2024-05-11 10:56:28'),(2,'查看用户钱包','/user/wallet','GET','1','log','2024-05-11 10:56:28'),(3,'发送图片验证码','/user/captcha','GET','1','log','2024-05-11 10:56:28'),(4,'搜索商品','/detail/search','GET','1','log','2024-05-11 10:56:28'),(5,'查看商品详情','/detail/:id','GET','1','log','2024-05-11 10:56:28'),(6,'后台验证码','/back/code','GET','0','log','2024-05-11 10:56:28'),(7,'后台状态','/back/state','GET','0','log','2024-05-11 10:56:28'),(8,'调用上传文件','/static/*filepath','GET','1','log','2024-05-11 10:56:28'),(9,'测试-模拟支付','/test/order/pay','GET','1','log','2024-05-11 10:56:28'),(10,'修改用户名称','/user/name','PUT','1','log','2024-05-11 10:56:28'),(11,'用户注册','/user/register','POST','1','log','2024-05-11 10:56:28'),(12,'用户注册验证码-邮箱','/user/registerCode','POST','1','log','2024-05-11 10:56:28'),(13,'用户订单信息','/user/order','POST','1','log','2024-05-11 10:56:28'),(14,'用户登录','/user/login','POST','1','log','2024-05-11 10:56:28'),(15,'发送手机短信验证码','/user/sendSms','POST','1','log','2024-05-11 10:56:28'),(16,'文件上传','/file/upload','POST','1','log','2024-05-11 10:56:28'),(17,'订单提交','/order/submit','POST','1','log','2024-05-11 10:56:28'),(18,'后台系统登录','/back/login','POST','1','log','2024-05-11 10:56:28'),(19,'上传的文件资源','/static/*filepath','HEAD','1','log','2024-05-11 10:56:28'),(39,'获取订单信息','/order/list','POST','1','log','2024-05-11 16:49:13'),(42,'','/back/role/authority','GET','1','login,log,authority','2024-05-13 15:19:31'),(43,'','/back/role/menu','GET','1','login,log,authority','2024-05-13 15:19:31'),(44,'','/back/base/goods','GET','1','login,log,authority','2024-05-14 15:13:52'),(45,'','/back/base/goodsCoupon','GET','1','login,log,authority','2024-05-14 15:13:52'),(46,'','/back/base/goodsCouponUser','GET','1','login,log,authority','2024-05-14 15:13:52'),(47,'','/back/base/goodsCommodityArea','GET','1','login,log,authority','2024-05-14 15:13:52'),(48,'','/back/base/goodsTag','GET','1','login,log,authority','2024-05-14 15:13:52'),(49,'','/back/base/goodsTopic','GET','1','login,log,authority','2024-05-14 15:13:52'),(50,'','/back/base/goodsType','GET','1','login,log,authority','2024-05-14 15:13:52'),(51,'','/back/base/goodsSku','GET','1','login,log,authority','2024-05-14 15:13:52'),(52,'','/back/base/goodsSkuCard','GET','1','login,log,authority','2024-05-14 15:13:52'),(53,'','/back/base/goodsIntroduction','GET','1','login,log,authority','2024-05-14 15:13:52'),(54,'','/back/base/goodsOrder','GET','1','login,log,authority','2024-05-14 15:13:52'),(55,'','/back/base/backRole','GET','1','login,log,authority','2024-05-14 15:13:52'),(56,'','/back/base/backRoleAuthority','GET','1','login,log,authority','2024-05-14 15:13:52'),(57,'','/back/base/backRoleMenu','GET','1','login,log,authority','2024-05-14 15:13:52'),(58,'','/back/base/backAuthority','GET','1','login,log,authority','2024-05-14 15:13:52'),(59,'','/back/base/backMenu','GET','1','login,log,authority','2024-05-14 15:13:52'),(60,'','/back/base/article','GET','1','login,log,authority','2024-05-14 15:13:52'),(61,'','/back/base/articleTag','GET','1','login,log,authority','2024-05-14 15:13:52'),(62,'','/back/base/articleTopic','GET','1','login,log,authority','2024-05-14 15:13:52'),(63,'','/back/base/user','GET','1','login,log,authority','2024-05-14 15:13:52'),(64,'','/back/base/userWallet','GET','1','login,log,authority','2024-05-14 15:13:52'),(65,'','/back/base/goods','PUT','1','login,log,authority','2024-05-14 15:13:52'),(66,'','/back/base/goodsCoupon','PUT','1','login,log,authority','2024-05-14 15:13:52'),(67,'','/back/base/goodsCouponUser','PUT','1','login,log,authority','2024-05-14 15:13:52'),(68,'','/back/base/goodsCommodityArea','PUT','1','login,log,authority','2024-05-14 15:13:52'),(69,'','/back/base/goodsTag','PUT','1','login,log,authority','2024-05-14 15:13:52'),(70,'','/back/base/goodsTopic','PUT','1','login,log,authority','2024-05-14 15:13:52'),(71,'','/back/base/goodsType','PUT','1','login,log,authority','2024-05-14 15:13:52'),(72,'','/back/base/goodsSku','PUT','1','login,log,authority','2024-05-14 15:13:52'),(73,'','/back/base/goodsSkuCard','PUT','1','login,log,authority','2024-05-14 15:13:52'),(74,'','/back/base/goodsIntroduction','PUT','1','login,log,authority','2024-05-14 15:13:52'),(75,'','/back/base/goodsOrder','PUT','1','login,log,authority','2024-05-14 15:13:52'),(76,'','/back/base/backRole','PUT','1','login,log,authority','2024-05-14 15:13:52'),(77,'','/back/base/backRoleAuthority','PUT','1','login,log,authority','2024-05-14 15:13:52'),(78,'','/back/base/backRoleMenu','PUT','1','login,log,authority','2024-05-14 15:13:52'),(79,'','/back/base/backAuthority','PUT','1','login,log,authority','2024-05-14 15:13:52'),(80,'','/back/base/backMenu','PUT','1','login,log,authority','2024-05-14 15:13:52'),(81,'','/back/base/article','PUT','1','login,log,authority','2024-05-14 15:13:52'),(82,'','/back/base/articleTag','PUT','1','login,log,authority','2024-05-14 15:13:52'),(83,'','/back/base/articleTopic','PUT','1','login,log,authority','2024-05-14 15:13:52'),(84,'','/back/base/user','PUT','1','login,log,authority','2024-05-14 15:13:52'),(85,'','/back/base/userWallet','PUT','1','login,log,authority','2024-05-14 15:13:52'),(86,'','/back/base/goods','POST','1','login,log,authority','2024-05-14 15:13:52'),(87,'','/back/base/goodsCoupon','POST','1','login,log,authority','2024-05-14 15:13:52'),(88,'','/back/base/goodsCouponUser','POST','1','login,log,authority','2024-05-14 15:13:52'),(89,'','/back/base/goodsCouponUser/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(90,'','/back/base/goodsCouponUser/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(91,'','/back/base/goodsCoupon/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(92,'','/back/base/goodsCoupon/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(93,'','/back/base/goodsCommodityArea','POST','1','login,log,authority','2024-05-14 15:13:52'),(94,'','/back/base/goodsCommodityArea/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(95,'','/back/base/goodsCommodityArea/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(96,'','/back/base/goodsTag','POST','1','login,log,authority','2024-05-14 15:13:52'),(97,'','/back/base/goodsTag/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(98,'','/back/base/goodsTag/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(99,'','/back/base/goodsTopic','POST','1','login,log,authority','2024-05-14 15:13:52'),(100,'','/back/base/goodsTopic/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(101,'','/back/base/goodsTopic/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(102,'','/back/base/goodsType','POST','1','login,log,authority','2024-05-14 15:13:52'),(103,'','/back/base/goodsType/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(104,'','/back/base/goodsType/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(105,'','/back/base/goodsSku','POST','1','login,log,authority','2024-05-14 15:13:52'),(106,'','/back/base/goodsSkuCard','POST','1','login,log,authority','2024-05-14 15:13:52'),(107,'','/back/base/goodsSkuCard/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(108,'','/back/base/goodsSkuCard/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(109,'','/back/base/goodsSku/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(110,'','/back/base/goodsSku/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(111,'','/back/base/goodsIntroduction','POST','1','login,log,authority','2024-05-14 15:13:52'),(112,'','/back/base/goodsIntroduction/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(113,'','/back/base/goodsIntroduction/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(114,'','/back/base/goodsOrder','POST','1','login,log,authority','2024-05-14 15:13:52'),(115,'','/back/base/goodsOrder/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(116,'','/back/base/goodsOrder/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(117,'','/back/base/goods/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(118,'','/back/base/goods/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(119,'','/back/base/backRole','POST','1','login,log,authority','2024-05-14 15:13:52'),(120,'','/back/base/backRoleAuthority','POST','1','login,log,authority','2024-05-14 15:13:52'),(121,'','/back/base/backRoleAuthority/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(122,'','/back/base/backRoleAuthority/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(123,'','/back/base/backRoleMenu','POST','1','login,log,authority','2024-05-14 15:13:52'),(124,'','/back/base/backRoleMenu/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(125,'','/back/base/backRoleMenu/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(126,'','/back/base/backRole/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(127,'','/back/base/backRole/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(128,'','/back/base/backAuthority','POST','1','login,log,authority','2024-05-14 15:13:52'),(129,'','/back/base/backAuthority/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(130,'','/back/base/backAuthority/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(131,'','/back/base/backMenu','POST','1','login,log,authority','2024-05-14 15:13:52'),(132,'','/back/base/backMenu/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(133,'','/back/base/backMenu/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(134,'','/back/base/article','POST','1','login,log,authority','2024-05-14 15:13:52'),(135,'','/back/base/articleTag','POST','1','login,log,authority','2024-05-14 15:13:52'),(136,'','/back/base/articleTag/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(137,'','/back/base/articleTag/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(138,'','/back/base/articleTopic','POST','1','login,log,authority','2024-05-14 15:13:52'),(139,'','/back/base/articleTopic/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(140,'','/back/base/articleTopic/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(141,'','/back/base/article/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(142,'','/back/base/article/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(143,'','/back/base/user','POST','1','login,log,authority','2024-05-14 15:13:52'),(144,'','/back/base/userWallet','POST','1','login,log,authority','2024-05-14 15:13:52'),(145,'','/back/base/userWallet/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(146,'','/back/base/userWallet/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(147,'','/back/base/user/list','POST','1','login,log,authority','2024-05-14 15:13:52'),(148,'','/back/base/user/in','POST','1','login,log,authority','2024-05-14 15:13:52'),(149,'','/back/base/goods','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(150,'','/back/base/goodsCoupon','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(151,'','/back/base/goodsCouponUser','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(152,'','/back/base/goodsCommodityArea','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(153,'','/back/base/goodsTag','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(154,'','/back/base/goodsTopic','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(155,'','/back/base/goodsType','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(156,'','/back/base/goodsSku','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(157,'','/back/base/goodsSkuCard','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(158,'','/back/base/goodsIntroduction','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(159,'','/back/base/goodsOrder','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(160,'','/back/base/backRole','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(161,'','/back/base/backRoleAuthority','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(162,'','/back/base/backRoleMenu','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(163,'','/back/base/backAuthority','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(164,'','/back/base/backMenu','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(165,'','/back/base/article','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(166,'','/back/base/articleTag','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(167,'','/back/base/articleTopic','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(168,'','/back/base/user','DELETE','1','login,log,authority','2024-05-14 15:13:52'),(169,'','/back/base/userWallet','DELETE','1','login,log,authority','2024-05-14 15:13:52');
/*!40000 ALTER TABLE `back_authority` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `back_menu`
--

DROP TABLE IF EXISTS `back_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `back_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `back_menu_name` varchar(255) DEFAULT NULL COMMENT '菜单名称',
  `back_menu_pater` int(11) DEFAULT NULL COMMENT '父级菜单',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `back_router_path` varchar(255) DEFAULT NULL COMMENT '路由路径',
  `state` varchar(255) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='后台菜单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `back_menu`
--

LOCK TABLES `back_menu` WRITE;
/*!40000 ALTER TABLE `back_menu` DISABLE KEYS */;
INSERT INTO `back_menu` VALUES (1,'首页',0,0,'HomeFilled','首页面','/back/index','1'),(2,'系统设置',0,1,'Setting','系统设置','/','1'),(3,'菜单设置',2,0,'Menu','菜单设置','/back/menu','1');
/*!40000 ALTER TABLE `back_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `back_role`
--

DROP TABLE IF EXISTS `back_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `back_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台角色';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `back_role`
--

LOCK TABLES `back_role` WRITE;
/*!40000 ALTER TABLE `back_role` DISABLE KEYS */;
INSERT INTO `back_role` VALUES (1,'超级管理员'),(2,'普通用户');
/*!40000 ALTER TABLE `back_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `back_role_authority`
--

DROP TABLE IF EXISTS `back_role_authority`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `back_role_authority` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `authority_id` int(11) DEFAULT NULL COMMENT '权限id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台角色权限表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `back_role_authority`
--

LOCK TABLES `back_role_authority` WRITE;
/*!40000 ALTER TABLE `back_role_authority` DISABLE KEYS */;
INSERT INTO `back_role_authority` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6);
/*!40000 ALTER TABLE `back_role_authority` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `back_role_menu`
--

DROP TABLE IF EXISTS `back_role_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `back_role_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  `menu_id` int(11) DEFAULT NULL COMMENT '枚舉id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='后台角色菜单表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `back_role_menu`
--

LOCK TABLES `back_role_menu` WRITE;
/*!40000 ALTER TABLE `back_role_menu` DISABLE KEYS */;
INSERT INTO `back_role_menu` VALUES (1,1,1),(2,1,2),(3,1,3);
/*!40000 ALTER TABLE `back_role_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gen_table`
--

DROP TABLE IF EXISTS `gen_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gen_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `table_name` varchar(255) DEFAULT NULL COMMENT '数据库名',
  `table_comment` varchar(255) DEFAULT NULL COMMENT '数据库注释',
  `name` varchar(255) DEFAULT NULL COMMENT '名字',
  `router_name` varchar(255) DEFAULT NULL COMMENT '路由名',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gen_table`
--

LOCK TABLES `gen_table` WRITE;
/*!40000 ALTER TABLE `gen_table` DISABLE KEYS */;
INSERT INTO `gen_table` VALUES (1,'article','文章','Article','article','文章'),(2,'article_tag','文章标签','ArticleTag','articleTag','文章标签'),(3,'article_topic','文章主题','ArticleTopic','articleTopic','文章主题'),(4,'back_authority','后台权限校验','BackAuthority','backAuthority','后台权限校验'),(5,'back_menu','后台菜单','BackMenu','backMenu','后台菜单'),(6,'back_role','后台角色','BackRole','backRole','后台角色'),(7,'back_role_authority','后台角色权限表','BackRoleAuthority','backRoleAuthority','后台角色权限表'),(8,'back_role_menu','后台角色菜单表','BackRoleMenu','backRoleMenu','后台角色菜单表'),(9,'gen_table','','GenTable','genTable',''),(10,'gen_table_column','','GenTableColumn','genTableColumn',''),(11,'goods','商品表','Goods','goods','商品表'),(12,'goods_commodity_area','商品属性','GoodsCommodityArea','goodsCommodityArea','商品属性'),(13,'goods_coupon','优惠券','GoodsCoupon','goodsCoupon','优惠券'),(14,'goods_coupon_user','优惠券领取','GoodsCouponUser','goodsCouponUser','优惠券领取'),(15,'goods_introduction','商品介绍','GoodsIntroduction','goodsIntroduction','商品介绍'),(16,'goods_order','商品订单','GoodsOrder','goodsOrder','商品订单'),(17,'goods_sku','商品规格','GoodsSku','goodsSku','商品规格'),(18,'goods_sku_card','商品卡号','GoodsSkuCard','goodsSkuCard','商品卡号'),(19,'goods_tag','商品标签','GoodsTag','goodsTag','商品标签'),(20,'goods_topic','商品主题','GoodsTopic','goodsTopic','商品主题'),(21,'goods_type','商品分类','GoodsType','goodsType','商品分类'),(22,'user','用户表','User','user','用户表'),(23,'user_wallet','用户钱包','UserWallet','userWallet','用户钱包');
/*!40000 ALTER TABLE `gen_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gen_table_column`
--

DROP TABLE IF EXISTS `gen_table_column`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gen_table_column` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `table_id` int(11) DEFAULT NULL COMMENT '表格id',
  `sort` int(255) DEFAULT NULL COMMENT '排序',
  `column_name` varchar(255) DEFAULT NULL COMMENT '字段名',
  `column_comment` varchar(255) DEFAULT NULL COMMENT '字段注释',
  `column_type` varchar(255) DEFAULT NULL COMMENT '字段类型',
  `go_type` varchar(255) DEFAULT NULL COMMENT 'go类型',
  `go_field` varchar(255) DEFAULT NULL COMMENT 'go字段名',
  `is_key` char(1) DEFAULT NULL COMMENT '是否主键',
  `is_increment` char(1) DEFAULT NULL COMMENT '是否自增',
  `is_required` char(1) DEFAULT NULL COMMENT '是否未必填',
  `query_type` char(1) DEFAULT NULL COMMENT '查询方式',
  `vue_show_type` varchar(255) DEFAULT NULL COMMENT '前端显示类型',
  `dict_type` varchar(255) DEFAULT NULL COMMENT '字典类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gen_table_column`
--

LOCK TABLES `gen_table_column` WRITE;
/*!40000 ALTER TABLE `gen_table_column` DISABLE KEYS */;
INSERT INTO `gen_table_column` VALUES (1,1,0,'id','id','INT','int64','Id','1','0','0','','',''),(2,1,1,'article_title','文章名称','VARCHAR','string','ArticleTitle','0','0','0','','',''),(3,1,2,'article_content','文章内容','LONGBLOB','string','ArticleContent','0','0','0','','',''),(4,1,3,'state','状态','VARCHAR','string','State','0','0','0','','',''),(5,1,4,'article_tag_ids','文章标签','VARCHAR','string','ArticleTagIds','0','0','0','','',''),(6,1,5,'article_topic_id','文章主题id','INT','int64','ArticleTopicId','0','0','0','','',''),(7,1,6,'image','图片','VARCHAR','string','Image','0','0','0','','',''),(8,1,7,'publish_time','发表时间','DATETIME','time.Time','PublishTime','0','0','0','','',''),(9,1,8,'eye_fill','浏览量','INT','int64','EyeFill','0','0','0','','',''),(10,1,9,'like_count','点赞量','INT','int64','LikeCount','0','0','0','','',''),(11,1,10,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(12,1,11,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(13,1,12,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(14,1,13,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','',''),(15,2,0,'id','','INT','int64','Id','1','0','0','','',''),(16,2,1,'tag_name','标签名','VARCHAR','string','TagName','0','0','0','','',''),(17,2,2,'tag_desc','标签描述','VARCHAR','string','TagDesc','0','0','0','','',''),(18,3,0,'id','','INT','int64','Id','1','0','0','','',''),(19,3,1,'image','图片','VARCHAR','string','Image','0','0','0','','',''),(20,3,2,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','','',''),(21,3,3,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','','',''),(22,4,0,'id','id','INT','int64','Id','1','0','0','','',''),(23,4,1,'authority_name','接口名','VARCHAR','string','AuthorityName','0','0','0','','',''),(24,4,2,'authority_path','接口路径','VARCHAR','string','AuthorityPath','0','0','0','','',''),(25,4,3,'method','方法','VARCHAR','string','Method','0','0','0','','',''),(26,4,4,'state','接口是否启用(0关闭，1启用)','VARCHAR','string','State','0','0','0','','',''),(27,4,5,'authority_verification','权限校验','VARCHAR','string','AuthorityVerification','0','0','0','','',''),(28,4,6,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(29,5,0,'id','id','INT','int64','Id','1','0','0','','',''),(30,5,1,'back_menu_name','菜单名称','VARCHAR','string','BackMenuName','0','0','0','','',''),(31,5,2,'back_menu_pater','父级菜单','INT','int64','BackMenuPater','0','0','0','','',''),(32,5,3,'sort','排序','INT','int64','Sort','0','0','0','','',''),(33,5,4,'icon','图标','VARCHAR','string','Icon','0','0','0','','',''),(34,5,5,'remark','备注','VARCHAR','string','Remark','0','0','0','','',''),(35,5,6,'back_router_path','路由路径','VARCHAR','string','BackRouterPath','0','0','0','','',''),(36,5,7,'state','状态','VARCHAR','string','State','0','0','0','','',''),(37,6,0,'id','','INT','int64','Id','1','0','0','','',''),(38,6,1,'role_name','','VARCHAR','string','RoleName','0','0','0','','',''),(39,7,0,'id','','INT','int64','Id','1','0','0','','',''),(40,7,1,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(41,7,2,'authority_id','权限id','INT','int64','AuthorityId','0','0','0','','',''),(42,8,0,'id','','INT','int64','Id','1','0','0','','',''),(43,8,1,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(44,8,2,'menu_id','枚舉id','INT','int64','MenuId','0','0','0','','',''),(45,9,0,'id','id','INT','int64','Id','1','0','0','','',''),(46,9,1,'table_name','数据库名','VARCHAR','string','TableName','0','0','0','','',''),(47,9,2,'table_comment','数据库注释','VARCHAR','string','TableComment','0','0','0','','',''),(48,9,3,'name','名字','VARCHAR','string','Name','0','0','0','','',''),(49,9,4,'router_name','路由名','VARCHAR','string','RouterName','0','0','0','','',''),(50,9,5,'remark','备注','VARCHAR','string','Remark','0','0','0','','',''),(51,10,0,'id','id','INT','int64','Id','1','0','0','','',''),(52,10,1,'table_id','表格id','INT','int64','TableId','0','0','0','','',''),(53,10,2,'sort','排序','INT','int64','Sort','0','0','0','','',''),(54,10,3,'column_name','字段名','VARCHAR','string','ColumnName','0','0','0','','',''),(55,10,4,'column_comment','字段注释','VARCHAR','string','ColumnComment','0','0','0','','',''),(56,10,5,'column_type','字段类型','VARCHAR','string','ColumnType','0','0','0','','',''),(57,10,6,'go_type','go类型','VARCHAR','string','GoType','0','0','0','','',''),(58,10,7,'go_field','go字段名','VARCHAR','string','GoField','0','0','0','','',''),(59,10,8,'is_key','是否主键','CHAR','string','IsKey','0','0','0','','',''),(60,10,9,'is_increment','是否自增','CHAR','string','IsIncrement','0','0','0','','',''),(61,10,10,'is_required','是否未必填','CHAR','string','IsRequired','0','0','0','','',''),(62,10,11,'query_type','查询方式','CHAR','string','QueryType','0','0','0','','',''),(63,10,12,'vue_show_type','前端显示类型','VARCHAR','string','VueShowType','0','0','0','','',''),(64,10,13,'dict_type','字典类型','VARCHAR','string','DictType','0','0','0','','',''),(65,11,0,'id','id','INT','int64','Id','1','0','0','','',''),(66,11,1,'type_id','分类id','INT','int64','TypeId','0','0','0','','',''),(67,11,2,'goods_name','商品名字','VARCHAR','string','GoodsName','0','0','0','','',''),(68,11,3,'introduction_id','商品介绍id','INT','int64','IntroductionId','0','0','0','','',''),(69,11,4,'sales_volume','近30天销量','INT','int64','SalesVolume','0','0','0','','',''),(70,11,5,'tag_ids','商品标签','VARCHAR','string','TagIds','0','0','0','','',''),(71,12,0,'id','id','INT','int64','Id','1','0','0','','',''),(72,12,1,'goods_id','商品id','INT','int64','GoodsId','0','0','0','','',''),(73,12,2,'commodity_area_name','商品属地名称','VARCHAR','string','CommodityAreaName','0','0','0','','',''),(74,12,3,'detail_image','详情图片','VARCHAR','string','DetailImage','0','0','0','','',''),(75,12,4,'detail_introduction_id','相关文本详情id','INT','int64','DetailIntroductionId','0','0','0','','',''),(76,13,0,'id','id','INT','int64','Id','1','0','0','','',''),(77,13,1,'coupon_name','优惠券名称','VARCHAR','string','CouponName','0','0','0','','',''),(78,13,2,'coupon_desc','优惠券描述','VARCHAR','string','CouponDesc','0','0','0','','',''),(79,13,3,'cash_back_point','满x','DECIMAL','float64','CashBackPoint','0','0','0','','',''),(80,13,4,'cash_back_price','减x','DECIMAL','float64','CashBackPrice','0','0','0','','',''),(81,13,5,'condition_by_topic','主题可用，id','VARCHAR','string','ConditionByTopic','0','0','0','','',''),(82,13,6,'condition_by_type','类型可用，id','VARCHAR','string','ConditionByType','0','0','0','','',''),(83,13,7,'condition_by_goods','商品可用，id','VARCHAR','string','ConditionByGoods','0','0','0','','',''),(84,13,8,'grant_count','发放数量','VARCHAR','string','GrantCount','0','0','0','','',''),(85,13,9,'count','优惠券余量','INT','int64','Count','0','0','0','','',''),(86,13,10,'receive_type','领取条件','VARCHAR','string','ReceiveType','0','0','0','','',''),(87,13,11,'validity','有效性，领取开始计时(ClaimTiming)，固定时间(FixedTime)','VARCHAR','string','Validity','0','0','0','','',''),(88,13,12,'validity_period','有效期','DATETIME','time.Time','ValidityPeriod','0','0','0','','',''),(89,14,0,'id','id','INT','int64','Id','1','0','0','','',''),(90,14,1,'user_id','用户id','INT','int64','UserId','0','0','0','','',''),(91,14,2,'coupon_id','优惠券id','INT','int64','CouponId','0','0','0','','',''),(92,14,3,'collection_time','领取时间','DATETIME','time.Time','CollectionTime','0','0','0','','',''),(93,14,4,'state','状态，已使用2，未使用1，已过期0','VARCHAR','string','State','0','0','0','','',''),(94,15,0,'id','文章id','INT','int64','Id','1','0','0','','',''),(95,15,1,'goods_article_name','商品文章名','VARCHAR','string','GoodsArticleName','0','0','0','','',''),(96,15,2,'goods_article','商品文章','LONGBLOB','string','GoodsArticle','0','0','0','','',''),(97,15,3,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(98,15,4,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(99,15,5,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(100,15,6,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','',''),(101,16,0,'id','id','INT','int64','Id','1','0','0','','',''),(102,16,1,'order_name','订单名','VARCHAR','string','OrderName','0','0','0','','',''),(103,16,2,'sku_id','skuid','INT','int64','SkuId','0','0','0','','',''),(104,16,3,'count','购买数量','INT','int64','Count','0','0','0','','',''),(105,16,4,'price','单价','DECIMAL','float64','Price','0','0','0','','',''),(106,16,5,'total_price','总价','DECIMAL','float64','TotalPrice','0','0','0','','',''),(107,16,6,'contact_information','联系方式','VARCHAR','string','ContactInformation','0','0','0','','',''),(108,16,7,'coupon_user_id','使用的优惠券','INT','int64','CouponUserId','0','0','0','','',''),(109,16,8,'state','支付状态，0待支付，1待发货，2已发货，3订单完成，4订单异常','VARCHAR','string','State','0','0','0','','',''),(110,16,9,'create_by','用户id','INT','int64','CreateBy','0','0','0','','',''),(111,16,10,'create_time','订单创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(112,17,0,'id','','INT','int64','Id','1','0','0','','',''),(113,17,1,'sku_image','sku图片','VARCHAR','string','SkuImage','0','0','0','','',''),(114,17,2,'sku_name','商品sku名字','VARCHAR','string','SkuName','0','0','0','','',''),(115,17,3,'price','现在价格','DECIMAL','float64','Price','0','0','0','','',''),(116,17,4,'historical_prices','历史价格','DECIMAL','float64','HistoricalPrices','0','0','0','','',''),(117,17,5,'inventory_number','库存','INT','int64','InventoryNumber','0','0','0','','',''),(118,17,6,'commodity_area_id','属地id','INT','int64','CommodityAreaId','0','0','0','','',''),(119,17,7,'goods_id','商品id','INT','int64','GoodsId','0','0','0','','',''),(120,17,8,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(121,17,9,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(122,18,0,'id','id','INT','int64','Id','1','0','0','','',''),(123,18,1,'card_name','卡种名称','VARCHAR','string','CardName','0','0','0','','',''),(124,18,2,'state','状态，0未使用，1已用，2过期','VARCHAR','string','State','0','0','0','','',''),(125,18,3,'count','库存','INT','int64','Count','0','0','0','','',''),(126,18,4,'total_count','总数','VARCHAR','string','TotalCount','0','0','0','','',''),(127,18,5,'card_key','卡密','VARCHAR','string','CardKey','0','0','0','','',''),(128,18,6,'use','是否已用','VARCHAR','string','Use','0','0','0','','',''),(129,18,7,'upload_time','入库时间','DATETIME','time.Time','UploadTime','0','0','0','','',''),(130,18,8,'sku_id','商品规格绑定','INT','int64','SkuId','0','0','0','','',''),(131,18,9,'sort','排序，出售优先级','VARCHAR','string','Sort','0','0','0','','',''),(132,19,0,'id','id','INT','int64','Id','1','0','0','','',''),(133,19,1,'name','名字','VARCHAR','string','Name','0','0','0','','',''),(134,19,2,'icon_url','图标路径','VARCHAR','string','IconUrl','0','0','0','','',''),(135,19,3,'tag','标签','VARCHAR','string','Tag','0','0','0','','',''),(136,20,0,'id','','INT','int64','Id','1','0','0','','',''),(137,20,1,'topic_page_image','主题首页图片','VARCHAR','string','TopicPageImage','0','0','0','','',''),(138,20,2,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','','',''),(139,20,3,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','','',''),(140,20,4,'type_ids','商品类型id','VARCHAR','string','TypeIds','0','0','0','','',''),(141,21,0,'id','','INT','int64','Id','1','0','0','','',''),(142,21,1,'sort','排序','INT','int64','Sort','0','0','0','','',''),(143,21,2,'type_image','类型图片','VARCHAR','string','TypeImage','0','0','0','','',''),(144,21,3,'type_name','商品类别名称','VARCHAR','string','TypeName','0','0','0','','',''),(145,21,4,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(146,22,0,'id','','INT','int64','Id','1','0','0','','',''),(147,22,1,'username','账号','VARCHAR','string','Username','0','0','0','','',''),(148,22,2,'password','密码','VARCHAR','string','Password','0','0','0','','',''),(149,22,3,'creation_time','账号创建时间','INT','int64','CreationTime','0','0','0','','',''),(150,22,4,'login_time','登录时间','INT','int64','LoginTime','0','0','0','','',''),(151,22,5,'status','账号状态','VARCHAR','string','Status','0','0','0','','',''),(152,22,6,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(153,22,7,'phone','手机','VARCHAR','string','Phone','0','0','0','','',''),(154,22,8,'email','邮箱','VARCHAR','string','Email','0','0','0','','',''),(155,22,9,'name','用户名','VARCHAR','string','Name','0','0','0','','',''),(156,22,10,'avatar','头像','VARCHAR','string','Avatar','0','0','0','','',''),(157,22,11,'recommend_code','推荐码','VARCHAR','string','RecommendCode','0','0','0','','',''),(158,23,0,'id','id','INT','int64','Id','1','0','0','','',''),(159,23,1,'user_id','用户id','INT','int64','UserId','0','0','0','','',''),(160,23,2,'balance','余额','DECIMAL','float64','Balance','0','0','0','','',''),(161,23,3,'promotion_amount','推广获取总金额','DECIMAL','float64','PromotionAmount','0','0','0','','',''),(162,23,4,'recharge_amount','充值金额','DECIMAL','float64','RechargeAmount','0','0','0','','','');
/*!40000 ALTER TABLE `gen_table_column` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods`
--

DROP TABLE IF EXISTS `goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type_id` int(11) NOT NULL COMMENT '分类id',
  `goods_name` varchar(255) NOT NULL COMMENT '商品名字',
  `introduction_id` int(11) DEFAULT NULL COMMENT '商品介绍id',
  `sales_volume` int(255) DEFAULT NULL COMMENT '近30天销量',
  `tag_ids` varchar(255) DEFAULT NULL COMMENT '商品标签',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品表';
/*!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` VALUES (1,1,'苹果礼品卡特惠包',NULL,NULL,'1,2'),(2,2,'PUBG国际服直充',NULL,NULL,NULL);
/*!40000 ALTER TABLE `goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_commodity_area`
--

DROP TABLE IF EXISTS `goods_commodity_area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_commodity_area` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `goods_id` int(11) DEFAULT NULL COMMENT '商品id',
  `commodity_area_name` varchar(255) NOT NULL COMMENT '商品属地名称',
  `detail_image` varchar(255) DEFAULT NULL COMMENT '详情图片',
  `detail_introduction_id` int(11) DEFAULT NULL COMMENT '相关文本详情id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品属性';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_commodity_area`
--

LOCK TABLES `goods_commodity_area` WRITE;
/*!40000 ALTER TABLE `goods_commodity_area` DISABLE KEYS */;
INSERT INTO `goods_commodity_area` VALUES (1,1,'美国',NULL,1),(2,1,'日本',NULL,2),(3,1,'香港',NULL,1),(4,1,'台湾',NULL,1);
/*!40000 ALTER TABLE `goods_commodity_area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_coupon`
--

DROP TABLE IF EXISTS `goods_coupon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `coupon_name` varchar(255) DEFAULT NULL COMMENT '优惠券名称',
  `coupon_desc` varchar(255) DEFAULT NULL COMMENT '优惠券描述',
  `cash_back_point` decimal(11,2) DEFAULT NULL COMMENT '满x',
  `cash_back_price` decimal(11,2) DEFAULT NULL COMMENT '减x',
  `condition_by_topic` varchar(255) DEFAULT NULL COMMENT '主题可用，id',
  `condition_by_type` varchar(255) DEFAULT NULL COMMENT '类型可用，id',
  `condition_by_goods` varchar(255) DEFAULT NULL COMMENT '商品可用，id',
  `grant_count` varchar(255) DEFAULT NULL COMMENT '发放数量',
  `count` int(255) DEFAULT NULL COMMENT '优惠券余量',
  `receive_type` varchar(255) DEFAULT NULL COMMENT '领取条件',
  `validity` varchar(255) DEFAULT NULL COMMENT '有效性，领取开始计时(ClaimTiming)，固定时间(FixedTime)',
  `validity_period` datetime DEFAULT NULL COMMENT '有效期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='优惠券';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_coupon`
--

LOCK TABLES `goods_coupon` WRITE;
/*!40000 ALTER TABLE `goods_coupon` DISABLE KEYS */;
INSERT INTO `goods_coupon` VALUES (1,'全场优惠','满10减1',10.00,1.00,NULL,NULL,NULL,NULL,50,NULL,'ClaimTiming','2024-05-05 17:09:19');
/*!40000 ALTER TABLE `goods_coupon` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_coupon_user`
--

DROP TABLE IF EXISTS `goods_coupon_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_coupon_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `coupon_id` int(11) DEFAULT NULL COMMENT '优惠券id',
  `collection_time` datetime DEFAULT NULL COMMENT '领取时间',
  `state` varchar(255) DEFAULT '1' COMMENT '状态，已使用2，未使用1，已过期0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='优惠券领取';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_coupon_user`
--

LOCK TABLES `goods_coupon_user` WRITE;
/*!40000 ALTER TABLE `goods_coupon_user` DISABLE KEYS */;
INSERT INTO `goods_coupon_user` VALUES (1,1,1,'2024-05-05 16:30:25','1');
/*!40000 ALTER TABLE `goods_coupon_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_introduction`
--

DROP TABLE IF EXISTS `goods_introduction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_introduction` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章id',
  `goods_article_name` varchar(255) DEFAULT NULL COMMENT '商品文章名',
  `goods_article` longblob COMMENT '商品文章',
  `create_by` varchar(0) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品介绍';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_introduction`
--

LOCK TABLES `goods_introduction` WRITE;
/*!40000 ALTER TABLE `goods_introduction` DISABLE KEYS */;
INSERT INTO `goods_introduction` VALUES (1,'商品介绍',_binary '<div class=\"content\"><p style=\"text-wrap: wrap;\">声明：保护未成年健康，本平台禁止未成年消费</p><p style=\"text-wrap: wrap;\">一、直充说明</p><p style=\"text-wrap: wrap;\">【填写信息】UID直充</p><p style=\"text-wrap: wrap;\">【充值流程】输入UID，选择区服 → 下单支付 → 充值完成</p><p style=\"text-wrap: wrap;\">【充值时长】1~3分钟（高峰期可能晚几分钟）</p><p style=\"text-wrap: wrap;\">二、注意事项</p><p style=\"text-wrap: wrap;\">1.填错充值账号怎么办？能退款吗？</p><p style=\"text-wrap: wrap;\">如果我们按照您填写的信息已完成充值，那么将无法退还，如果因我平台导致充值错误，经核验后，可退还；若不影响二次销售的点卡类商品，联系在线客服可帮忙转卖，但等待时间不定。</p><p style=\"text-wrap: wrap;\">2.支付成功后多久能到账？</p><p style=\"text-wrap: wrap;\">一般情况下，1-2分钟内即可到账。如超过5分钟未到账请及时联系客服咨询</p><p style=\"text-wrap: wrap;\"><img src=\"https://files.kardz.cn/cms/image_$1702884899572057560_$1712557168223077827.png\"></p><div class=\"detail-main__StyledSupplementaryStatement-sc-1971otn-0 hfMgQN\"><span>*</span>本售后政策不叠加【随心换服务】<br>账号类商品：自购买日起售后期3天，商品质量问题免费更换<br>邮箱类商品：自购买日起3天内<br>卡密类商品：因卡密都是正规可囤，无售后期。（如有问题随时联系我们处理）<br>充值类商品：到账后无法售后<br></div><div class=\"desc\">购买说明：原神国际服直充 300+30 Genesis Crystals来自官方渠道，支持极速发货、错误包换，如有需要可关注<a title=\"原神手游（国际服）直充原神国际服直充 300+30 Genesis Crystals充值_原神手游（国际服）直充国际服充值-kardz官网\" href=\"http://kar.kardz.cc/detail/1578289602.html\">http://kar.kardz.cc/detail/1578289602.html</a></div></div>',NULL,NULL,NULL,NULL),(2,'懒得介绍',_binary '<p>666</p>',NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `goods_introduction` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_order`
--

DROP TABLE IF EXISTS `goods_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_name` varchar(255) DEFAULT NULL COMMENT '订单名',
  `sku_id` int(11) DEFAULT NULL COMMENT 'skuid',
  `count` int(11) DEFAULT NULL COMMENT '购买数量',
  `price` decimal(10,2) DEFAULT NULL COMMENT '单价',
  `total_price` decimal(10,2) DEFAULT NULL COMMENT '总价',
  `contact_information` varchar(255) DEFAULT NULL COMMENT '联系方式',
  `coupon_user_id` int(11) DEFAULT NULL COMMENT '使用的优惠券',
  `state` varchar(10) DEFAULT '0' COMMENT '支付状态，0待支付，1待发货，2已发货，3订单完成，4订单异常',
  `create_by` int(255) DEFAULT NULL COMMENT '用户id',
  `create_time` datetime DEFAULT NULL COMMENT '订单创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品订单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_order`
--

LOCK TABLES `goods_order` WRITE;
/*!40000 ALTER TABLE `goods_order` DISABLE KEYS */;
INSERT INTO `goods_order` VALUES (1,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 14:08:31'),(2,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'1',1,'2024-05-04 22:01:55'),(3,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'2',1,'2024-05-04 22:01:55'),(4,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'3',1,'2024-05-04 22:01:55'),(5,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 22:01:55'),(6,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'1',1,'2024-05-04 22:01:55'),(7,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 22:01:55'),(8,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 22:01:55'),(9,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'4',1,'2024-05-04 22:01:55'),(10,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'1',1,'2024-05-04 22:01:55'),(11,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 22:01:55'),(12,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'2',1,'2024-05-04 22:01:55'),(13,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 22:01:55'),(14,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 22:01:55'),(15,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 22:01:55'),(16,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'2',1,'2024-05-04 22:01:55'),(17,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 22:01:55'),(18,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'0',1,'2024-05-04 22:01:55'),(19,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'',1,'2024-05-06 15:11:33'),(20,'特惠包1【苹果礼品卡3美金+精品账号】【x1】',1,1,36.00,36.00,'',0,'',1,'2024-05-06 15:11:46'),(21,'特惠包1【苹果礼品卡100NT+300NT】【x1】',6,1,135.00,135.00,'',0,'',1,'2024-05-09 16:46:50');
/*!40000 ALTER TABLE `goods_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_sku`
--

DROP TABLE IF EXISTS `goods_sku`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_sku` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sku_image` varchar(255) DEFAULT NULL COMMENT 'sku图片',
  `sku_name` varchar(255) NOT NULL COMMENT '商品sku名字',
  `price` decimal(10,2) NOT NULL COMMENT '现在价格',
  `historical_prices` decimal(10,2) NOT NULL COMMENT '历史价格',
  `inventory_number` int(11) NOT NULL COMMENT '库存',
  `commodity_area_id` int(11) NOT NULL COMMENT '属地id',
  `goods_id` int(11) NOT NULL COMMENT '商品id',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品规格';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_sku`
--

LOCK TABLES `goods_sku` WRITE;
/*!40000 ALTER TABLE `goods_sku` DISABLE KEYS */;
INSERT INTO `goods_sku` VALUES (1,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包1【苹果礼品卡3美金+精品账号】',36.00,36.00,50,1,1,NULL,NULL),(2,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包2【苹果礼品卡5美金+精品账号】',52.00,58.80,50,1,1,NULL,NULL),(3,'/api/static/202404231412462.jpg','特惠包3【苹果礼品卡3美金+5美金】',75.00,67.00,50,1,1,NULL,NULL),(4,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包2【苹果礼品卡500日元+精美账号】',48.00,55.00,50,2,1,NULL,NULL),(5,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包1【苹果礼品卡150港元+200港元】',381.00,384.00,50,3,1,NULL,NULL),(6,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包1【苹果礼品卡100NT+300NT】',135.00,139.00,50,4,1,NULL,NULL),(7,'/api/static/20240423094145微信图片_20240416170543.jpg','PUBG国际服(地铁逃生)直充-300+25UC',37.39,41.00,50,0,2,NULL,NULL);
/*!40000 ALTER TABLE `goods_sku` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_sku_card`
--

DROP TABLE IF EXISTS `goods_sku_card`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_sku_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `card_name` varchar(255) DEFAULT NULL COMMENT '卡种名称',
  `state` varchar(255) DEFAULT NULL COMMENT '状态，0未使用，1已用，2过期',
  `count` int(11) DEFAULT NULL COMMENT '库存',
  `total_count` varchar(255) DEFAULT NULL COMMENT '总数',
  `card_key` varchar(255) DEFAULT NULL COMMENT '卡密',
  `use` varchar(5) DEFAULT NULL COMMENT '是否已用',
  `upload_time` datetime DEFAULT NULL COMMENT '入库时间',
  `sku_id` int(11) DEFAULT NULL COMMENT '商品规格绑定',
  `sort` varchar(255) DEFAULT NULL COMMENT '排序，出售优先级',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品卡号';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_sku_card`
--

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

--
-- Table structure for table `goods_tag`
--

DROP TABLE IF EXISTS `goods_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) DEFAULT NULL COMMENT '名字',
  `icon_url` varchar(255) DEFAULT NULL COMMENT '图标路径',
  `tag` varchar(255) DEFAULT NULL COMMENT '标签',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品标签';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_tag`
--

LOCK TABLES `goods_tag` WRITE;
/*!40000 ALTER TABLE `goods_tag` DISABLE KEYS */;
INSERT INTO `goods_tag` VALUES (1,'支持中文','/api/static/20240423094145微信图片_20240416170543.jpg','语言支持'),(2,'支持','','独立密码');
/*!40000 ALTER TABLE `goods_tag` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_topic`
--

DROP TABLE IF EXISTS `goods_topic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_topic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `topic_page_image` varchar(255) DEFAULT NULL COMMENT '主题首页图片',
  `topic_name` varchar(255) DEFAULT NULL COMMENT '主题名称',
  `topic_desc` varchar(255) DEFAULT NULL COMMENT '主题描述',
  `type_ids` varchar(255) DEFAULT NULL COMMENT '商品类型id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品主题';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_topic`
--

LOCK TABLES `goods_topic` WRITE;
/*!40000 ALTER TABLE `goods_topic` DISABLE KEYS */;
INSERT INTO `goods_topic` VALUES (1,NULL,'软件直充','软件在线充值，快速秒到账','1'),(2,NULL,'游戏充值','游戏在线充值，热门游戏尽在其中','2');
/*!40000 ALTER TABLE `goods_topic` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_type`
--

DROP TABLE IF EXISTS `goods_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `type_image` varchar(50) DEFAULT NULL COMMENT '类型图片',
  `type_name` varchar(255) NOT NULL COMMENT '商品类别名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_type`
--

LOCK TABLES `goods_type` WRITE;
/*!40000 ALTER TABLE `goods_type` DISABLE KEYS */;
INSERT INTO `goods_type` VALUES (1,NULL,NULL,'礼品卡',NULL),(2,NULL,NULL,'海外直冲',NULL);
/*!40000 ALTER TABLE `goods_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL COMMENT '账号',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `creation_time` int(11) DEFAULT NULL COMMENT '账号创建时间',
  `login_time` int(11) DEFAULT NULL COMMENT '登录时间',
  `status` varchar(255) DEFAULT NULL COMMENT '账号状态',
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `recommend_code` varchar(255) DEFAULT NULL COMMENT '推荐码',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `usernames` (`username`) USING BTREE COMMENT '用户名'
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'1842520361@qq.com','37bcf5e351f329952fb347edc09f31a1',1,1,'1',1,'13642531323','1842520361@qq.com','老黑猫','/api/static/20240423094145微信图片_20240416170543.jpg','1234567890');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_wallet`
--

DROP TABLE IF EXISTS `user_wallet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_wallet` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `balance` decimal(65,0) DEFAULT '0' COMMENT '余额',
  `promotion_amount` decimal(20,2) DEFAULT '0.00' COMMENT '推广获取总金额',
  `recharge_amount` decimal(20,2) DEFAULT '0.00' COMMENT '充值金额',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `user` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户钱包';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_wallet`
--

LOCK TABLES `user_wallet` WRITE;
/*!40000 ALTER TABLE `user_wallet` DISABLE KEYS */;
INSERT INTO `user_wallet` VALUES (1,1,0,0.00,0.00);
/*!40000 ALTER TABLE `user_wallet` 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 2024-05-16 17:11:24
