kkc-go/file/virtual_mall.sql

-- MySQL dump 10.13  Distrib 5.7.43, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: virtual_mall
-- ------------------------------------------------------
-- Server version	5.7.43-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=209 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'),(170,'','/back/base/dictType','GET','1','login,log,authority','2024-05-17 09:41:03'),(171,'','/back/base/dictData','GET','1','login,log,authority','2024-05-17 09:41:03'),(172,'','/back/base/dictType','PUT','1','login,log,authority','2024-05-17 09:41:03'),(173,'','/back/base/dictData','PUT','1','login,log,authority','2024-05-17 09:41:03'),(174,'','/back/base/dictType','POST','1','login,log,authority','2024-05-17 09:41:03'),(175,'','/back/base/dictType/list','POST','1','login,log,authority','2024-05-17 09:41:03'),(176,'','/back/base/dictType/in','POST','1','login,log,authority','2024-05-17 09:41:03'),(177,'','/back/base/dictData','POST','1','login,log,authority','2024-05-17 09:41:03'),(178,'','/back/base/dictData/list','POST','1','login,log,authority','2024-05-17 09:41:03'),(179,'','/back/base/dictData/in','POST','1','login,log,authority','2024-05-17 09:41:03'),(180,'','/back/base/dictType','DELETE','1','login,log,authority','2024-05-17 09:41:03'),(181,'','/back/base/dictData','DELETE','1','login,log,authority','2024-05-17 09:41:03'),(182,'','/back/base/genTable','GET','1','login,log,authority','2024-05-17 23:44:27'),(183,'','/back/base/genTableColumn','GET','1','login,log,authority','2024-05-17 23:44:27'),(184,'','/back/base/genTable','PUT','1','login,log,authority','2024-05-17 23:44:27'),(185,'','/back/base/genTableColumn','PUT','1','login,log,authority','2024-05-17 23:44:27'),(186,'','/back/base/genTable','POST','1','login,log,authority','2024-05-17 23:44:27'),(187,'','/back/base/genTableColumn','POST','1','login,log,authority','2024-05-17 23:44:27'),(188,'','/back/base/genTableColumn/list','POST','1','login,log,authority','2024-05-17 23:44:27'),(189,'','/back/base/genTableColumn/in','POST','1','login,log,authority','2024-05-17 23:44:27'),(190,'','/back/base/genTable/list','POST','1','login,log,authority','2024-05-17 23:44:27'),(191,'','/back/base/genTable/in','POST','1','login,log,authority','2024-05-17 23:44:27'),(192,'','/back/base/genTable','DELETE','1','login,log,authority','2024-05-17 23:44:27'),(193,'','/back/base/genTableColumn','DELETE','1','login,log,authority','2024-05-17 23:44:27'),(194,'','/test/test','POST','1','login,log,authority','2024-05-19 01:21:32'),(195,'','/back/goods/introduction','GET','1','','2024-05-21 21:19:53'),(196,'','/back/goods/:id','GET','1','','2024-05-21 21:19:53'),(197,'','/home/','GET','1','','2024-05-21 21:19:53'),(198,'','/back/goods','PUT','1','','2024-05-21 21:19:53'),(199,'','/back/goods/:id','PUT','1','','2024-05-21 21:19:53'),(200,'','/back/goods','POST','1','','2024-05-21 21:19:53'),(201,'','/back/goods/list','POST','1','','2024-05-21 21:19:53'),(202,'','/back/goods/:id','POST','1','','2024-05-21 21:19:53'),(203,'','/back/goods/:id','HEAD','1','','2024-05-21 21:19:53'),(204,'','/back/goods/:id','PATCH','1','','2024-05-21 21:19:53'),(205,'','/back/goods/:id','OPTIONS','1','','2024-05-21 21:19:53'),(206,'','/back/goods/:id','DELETE','1','','2024-05-21 21:19:53'),(207,'','/back/goods/:id','CONNECT','1','','2024-05-21 21:19:53'),(208,'','/back/goods/:id','TRACE','1','','2024-05-21 21:19:53');
/*!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=29 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,'系统商城',0,0,'Shop','菜单设置','/','1'),(4,'文章',0,4,'Setting','文章','/back/article','1'),(5,'文章标签',0,5,'Setting','文章标签','/back/articleTag','1'),(6,'文章主题',0,6,'Setting','文章主题','/back/articleTopic','1'),(7,'后台权限校验',2,7,'Setting','后台权限校验','/back/backAuthority','1'),(8,'后台菜单',2,8,'Setting','后台菜单','/back/backMenu','1'),(9,'后台角色',2,9,'Setting','后台角色','/back/backRole','1'),(10,'后台角色权限表',2,10,'Setting','后台角色权限表','/back/backRoleAuthority','1'),(11,'后台角色菜单表',2,11,'Setting','后台角色菜单表','/back/backRoleMenu','1'),(12,'字典数据',2,12,'Setting','字典数据','/back/dictData','0'),(13,'字典类型',2,13,'Setting','字典类型','/back/dictType','1'),(14,'表格生成',2,14,'Setting','表格生成','/back/genTable','1'),(15,'表格字段生成',2,15,'Setting','表格字段生成','/back/genTableColumn','1'),(16,'商品表',3,16,'Setting','商品表','/back/goods','1'),(17,'商品属性',3,17,'Setting','商品属性','/back/goodsCommodityArea','1'),(18,'优惠券',3,18,'Setting','优惠券','/back/goodsCoupon','1'),(19,'优惠券领取',3,19,'Setting','优惠券领取','/back/goodsCouponUser','1'),(20,'商品介绍',3,20,'Setting','商品介绍','/back/goodsIntroduction','1'),(21,'商品订单',3,21,'Setting','商品订单','/back/goodsOrder','1'),(22,'商品规格',3,22,'Setting','商品规格','/back/goodsSku','1'),(23,'商品卡号',3,23,'Setting','商品卡号','/back/goodsSkuCard','1'),(24,'商品标签',3,24,'Setting','商品标签','/back/goodsTag','1'),(25,'商品主题',3,25,'Setting','商品主题','/back/goodsTopic','1'),(26,'商品分类',3,26,'Setting','商品分类','/back/goodsType','1'),(27,'用户表',0,27,'Setting','用户表','/back/user','1'),(28,'用户钱包',0,28,'Setting','用户钱包','/back/userWallet','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=195 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),(7,1,7),(8,1,8),(9,1,9),(10,1,10),(11,1,11),(12,1,12),(13,1,13),(14,1,14),(15,1,15),(16,1,16),(17,1,17),(18,1,18),(19,1,19),(20,1,20),(21,1,21),(22,1,22),(23,1,23),(24,1,24),(25,1,25),(26,1,26),(27,1,27),(28,1,28),(29,1,29),(30,1,30),(31,1,31),(32,1,32),(33,1,33),(34,1,34),(35,1,35),(36,1,36),(37,1,37),(38,1,38),(39,1,39),(40,1,40),(41,1,41),(42,1,42),(43,1,43),(44,1,44),(45,1,45),(46,1,46),(47,1,47),(48,1,48),(49,1,49),(50,1,50),(51,1,51),(52,1,52),(53,1,53),(54,1,54),(55,1,55),(56,1,56),(57,1,57),(58,1,58),(59,1,59),(60,1,60),(61,1,61),(62,1,62),(63,1,63),(64,1,64),(65,1,65),(66,1,66),(67,1,67),(68,1,68),(69,1,69),(70,1,70),(71,1,71),(72,1,72),(73,1,73),(74,1,74),(75,1,75),(76,1,76),(77,1,77),(78,1,78),(79,1,79),(80,1,80),(81,1,81),(82,1,82),(83,1,83),(84,1,84),(85,1,85),(86,1,86),(87,1,87),(88,1,88),(89,1,89),(90,1,90),(91,1,91),(92,1,92),(93,1,93),(94,1,94),(95,1,95),(96,1,96),(97,1,97),(98,1,98),(99,1,99),(100,1,100),(101,1,101),(102,1,102),(103,1,103),(104,1,104),(105,1,105),(106,1,106),(107,1,107),(108,1,108),(109,1,109),(110,1,110),(111,1,111),(112,1,112),(113,1,113),(114,1,114),(115,1,115),(116,1,116),(117,1,117),(118,1,118),(119,1,119),(120,1,120),(121,1,121),(122,1,122),(123,1,123),(124,1,124),(125,1,125),(126,1,126),(127,1,127),(128,1,128),(129,1,129),(130,1,130),(131,1,131),(132,1,132),(133,1,133),(134,1,134),(135,1,135),(136,1,136),(137,1,137),(138,1,138),(139,1,139),(140,1,140),(141,1,141),(142,1,142),(143,1,143),(144,1,144),(145,1,145),(146,1,146),(147,1,147),(148,1,148),(149,1,149),(150,1,150),(151,1,151),(152,1,152),(153,1,153),(154,1,154),(155,1,155),(156,1,156),(157,1,157),(158,1,158),(159,1,159),(160,1,160),(161,1,161),(162,1,162),(163,1,163),(164,1,164),(165,1,165),(166,1,166),(167,1,167),(168,1,168),(169,1,169),(170,1,170),(171,1,171),(172,1,172),(173,1,173),(174,1,174),(175,1,175),(176,1,176),(177,1,177),(178,1,178),(179,1,179),(180,1,180),(181,1,181),(182,1,182),(183,1,183),(184,1,184),(185,1,185),(186,1,186),(187,1,187),(188,1,188),(189,1,189),(190,1,190),(191,1,191),(192,1,192),(193,1,193),(194,1,194);
/*!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=29 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),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(10,1,10),(11,1,11),(12,1,12),(13,1,13),(14,1,14),(15,1,15),(16,1,16),(17,1,17),(18,1,18),(19,1,19),(20,1,20),(21,1,21),(22,1,22),(23,1,23),(24,1,24),(25,1,25),(26,1,26),(27,1,27),(28,1,28);
/*!40000 ALTER TABLE `back_role_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dict_data`
--

DROP TABLE IF EXISTS `dict_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dict_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `dict_label` varchar(255) DEFAULT NULL COMMENT '字典标签',
  `dict_value` varchar(255) DEFAULT NULL COMMENT '字典键值',
  `dict_type` varchar(255) DEFAULT NULL COMMENT '字典类型',
  `status` varchar(5) DEFAULT '1' COMMENT '状态',
  `css_style` varchar(50) DEFAULT NULL COMMENT '样式',
  `is_default` varchar(5) DEFAULT 'N' COMMENT '是否默认',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='字典数据';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dict_data`
--

LOCK TABLES `dict_data` WRITE;
/*!40000 ALTER TABLE `dict_data` DISABLE KEYS */;
INSERT INTO `dict_data` VALUES (1,0,'是','Y','sys_yes_no','1','success','Y',NULL),(2,1,'否','N','sys_yes_no','1','danger','N',NULL),(3,0,'启用','1','sys_state','1','success','Y',NULL),(4,0,'停用','0','sys_state','1','danger','N',NULL),(5,0,'字符串','string','go_type','1','','',''),(6,0,'整形','int64','go_type','1','','',''),(10,0,'时间','time.Time','go_type','1','','',''),(11,0,'浮点型','float64','go_type','1','','',''),(12,0,'文本框','input','vue_show_type','1','','',''),(13,0,'文本域','textarea','vue_show_type','1','','',''),(14,0,'下拉框','select','vue_show_type','1','','',''),(15,0,'复选框','checkbox','vue_show_type','1','','',''),(16,0,'单选框','radio','vue_show_type','1','','',''),(17,0,'日期控件','time','vue_show_type','1','','',''),(18,0,'图片上传','image','vue_show_type','1','','',''),(19,0,'富文本编辑器','editor','vue_show_type','1','','',''),(20,0,'=','EQ','query_type','1','','','equal'),(21,0,'!=','NEQ','query_type','1','','','not equal'),(22,0,'>','GT','query_type','1','','','greater than'),(23,0,'<','LT','query_type','1','','','less than'),(24,0,'>=','GTEQ','query_type','1','','',''),(25,0,'<=','LTEQ','query_type','1','','',''),(26,0,'LIKE','like','query_type','1','','',''),(27,0,'BETWEEN','BETWEEN','query_type','1','','','包含'),(28,0,'数字文本框','number','vue_show_type','1','','','');
/*!40000 ALTER TABLE `dict_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dict_type`
--

DROP TABLE IF EXISTS `dict_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dict_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dict_name` varchar(50) DEFAULT NULL COMMENT '字典名称',
  `dict_type` varchar(50) DEFAULT NULL COMMENT '字典类型',
  `status` varchar(5) DEFAULT NULL COMMENT '状态（1正常/0停用）',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='字典类型';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dict_type`
--

LOCK TABLES `dict_type` WRITE;
/*!40000 ALTER TABLE `dict_type` DISABLE KEYS */;
INSERT INTO `dict_type` VALUES (1,'系统是否','sys_yes_no','1','系统是否'),(2,'系统状态','sys_state','1','判断状态'),(3,'生成-Go类型','go_type','1','暂时没用'),(4,'vue显示类型','vue_show_type','1',''),(5,'查询方式','query_type','1','');
/*!40000 ALTER TABLE `dict_type` 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=33 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','用户钱包'),(24,'authority','','Authority','authority',''),(25,'dict_data','字典数据','DictData','dictData','字典数据'),(26,'dict_type','字典类型','DictType','dictType','字典类型'),(27,'manage_user','','ManageUser','manageUser',''),(28,'role','','Role','role',''),(29,'role_authority','','RoleAuthority','roleAuthority',''),(30,'shop_advice_carousel','','ShopAdviceCarousel','shopAdviceCarousel',''),(31,'shop_topic','商品主题','ShopTopic','shopTopic','商品主题'),(32,'shop_topic_sku','','ShopTopicSku','shopTopicSku','');
/*!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=390 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,9,0,'id','id','INT','int64','Id','1','0','0','','input',''),(2,9,1,'table_name','数据库名','VARCHAR','string','TableName','0','0','0','','input',''),(3,9,2,'table_comment','数据库注释','VARCHAR','string','TableComment','0','0','0','','input',''),(4,9,3,'name','名字','VARCHAR','string','Name','0','0','0','','input',''),(5,9,4,'router_name','路由名','VARCHAR','string','RouterName','0','0','0','','input',''),(6,9,5,'remark','备注','VARCHAR','string','Remark','0','0','0','','textarea',''),(7,10,0,'id','id','INT','int64','Id','1','0','0','','input',''),(8,10,1,'table_id','表格id','INT','int64','TableId','0','0','0','','input',''),(9,10,2,'sort','排序','INT','int64','Sort','0','0','0','','number',''),(10,10,3,'column_name','字段名','VARCHAR','string','ColumnName','0','0','0','','input',''),(11,10,4,'column_comment','字段注释','VARCHAR','string','ColumnComment','0','0','0','','input',''),(12,10,5,'column_type','字段类型','VARCHAR','string','ColumnType','0','0','0','','',''),(13,10,6,'go_type','go类型','VARCHAR','string','GoType','0','0','0','','select','go_type'),(14,10,7,'go_field','go字段名','VARCHAR','string','GoField','0','0','0','','input',''),(15,10,8,'is_key','是否主键','CHAR','string','IsKey','0','0','0','','Radio',''),(16,10,9,'is_increment','是否自增','CHAR','string','IsIncrement','0','0','0','','Radio',''),(17,10,10,'is_required','是否未必填','CHAR','string','IsRequired','0','0','0','','Radio',''),(18,10,11,'query_type','查询方式','CHAR','string','QueryType','0','0','0','','select','query_type'),(19,10,12,'vue_show_type','前端显示类型','VARCHAR','string','VueShowType','0','0','0','','select','vue_show_type'),(20,10,13,'dict_type','字典类型','VARCHAR','string','DictType','0','0','0','','select',''),(195,1,0,'id','id','INT','int64','Id','1','0','0','','',''),(196,1,1,'article_title','文章名称','VARCHAR','string','ArticleTitle','0','0','0','','',''),(197,1,2,'article_content','文章内容','LONGBLOB','string','ArticleContent','0','0','0','','',''),(198,1,3,'state','状态','VARCHAR','string','State','0','0','0','','',''),(199,1,4,'article_tag_ids','文章标签','VARCHAR','string','ArticleTagIds','0','0','0','','',''),(200,1,5,'article_topic_id','文章主题id','INT','int64','ArticleTopicId','0','0','0','','',''),(201,1,6,'image','图片','VARCHAR','string','Image','0','0','0','','',''),(202,1,7,'publish_time','发表时间','DATETIME','time.Time','PublishTime','0','0','0','','',''),(203,1,8,'eye_fill','浏览量','INT','int64','EyeFill','0','0','0','','',''),(204,1,9,'like_count','点赞量','INT','int64','LikeCount','0','0','0','','',''),(205,1,10,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(206,1,11,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(207,1,12,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(208,1,13,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','',''),(209,2,0,'id','','INT','int64','Id','1','0','0','','',''),(210,2,1,'tag_name','标签名','VARCHAR','string','TagName','0','0','0','','',''),(211,2,2,'tag_desc','标签描述','VARCHAR','string','TagDesc','0','0','0','','',''),(212,3,0,'id','','INT','int64','Id','1','0','0','','',''),(213,3,1,'image','图片','VARCHAR','string','Image','0','0','0','','',''),(214,3,2,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','','',''),(215,3,3,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','','',''),(216,24,0,'id','','INT','int64','Id','1','0','0','','',''),(217,24,1,'authority_name','','VARCHAR','string','AuthorityName','0','0','0','','',''),(218,24,2,'authority_path','','VARCHAR','string','AuthorityPath','0','0','0','','',''),(219,4,0,'id','id','INT','int64','Id','1','0','0','','',''),(220,4,1,'authority_name','接口名','VARCHAR','string','AuthorityName','0','0','0','','',''),(221,4,2,'authority_path','接口路径','VARCHAR','string','AuthorityPath','0','0','0','','',''),(222,4,3,'method','方法','VARCHAR','string','Method','0','0','0','','',''),(223,4,4,'state','接口是否启用(0关闭，1启用)','VARCHAR','string','State','0','0','0','','',''),(224,4,5,'authority_verification','权限校验','VARCHAR','string','AuthorityVerification','0','0','0','','',''),(225,4,6,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(226,5,0,'id','id','INT','int64','Id','1','0','0','','',''),(227,5,1,'back_menu_name','菜单名称','VARCHAR','string','BackMenuName','0','0','0','','',''),(228,5,2,'back_menu_pater','父级菜单','INT','int64','BackMenuPater','0','0','0','','',''),(229,5,3,'sort','排序','INT','int64','Sort','0','0','0','','',''),(230,5,4,'icon','图标','VARCHAR','string','Icon','0','0','0','','',''),(231,5,5,'remark','备注','VARCHAR','string','Remark','0','0','0','','',''),(232,5,6,'back_router_path','路由路径','VARCHAR','string','BackRouterPath','0','0','0','','',''),(233,5,7,'state','状态','VARCHAR','string','State','0','0','0','','',''),(234,6,0,'id','','INT','int64','Id','1','0','0','','',''),(235,6,1,'role_name','','VARCHAR','string','RoleName','0','0','0','','',''),(236,7,0,'id','','INT','int64','Id','1','0','0','','',''),(237,7,1,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(238,7,2,'authority_id','权限id','INT','int64','AuthorityId','0','0','0','','',''),(239,8,0,'id','','INT','int64','Id','1','0','0','','',''),(240,8,1,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(241,8,2,'menu_id','枚舉id','INT','int64','MenuId','0','0','0','','',''),(242,25,0,'id','字典编码','INT','int64','Id','1','0','0','','',''),(243,25,1,'sort','排序','INT','int64','Sort','0','0','0','','',''),(244,25,2,'dict_label','字典标签','VARCHAR','string','DictLabel','0','0','0','','',''),(245,25,3,'dict_value','字典键值','VARCHAR','string','DictValue','0','0','0','','',''),(246,25,4,'dict_type','字典类型','VARCHAR','string','DictType','0','0','0','','',''),(247,25,5,'status','状态','VARCHAR','string','Status','0','0','0','','','sys_state'),(248,25,6,'css_style','样式','VARCHAR','string','CssStyle','0','0','0','','',''),(249,25,7,'is_default','是否默认','VARCHAR','string','IsDefault','0','0','0','','',''),(250,25,8,'remark','备注','VARCHAR','string','Remark','0','0','0','','',''),(251,26,0,'id','','INT','int64','Id','1','0','0','','',''),(252,26,1,'dict_name','字典名称','VARCHAR','string','DictName','0','0','0','','',''),(253,26,2,'dict_type','字典类型','VARCHAR','string','DictType','0','0','0','','',''),(254,26,3,'status','状态（1正常/0停用）','VARCHAR','string','Status','0','0','0','','',''),(255,26,4,'remark','备注','VARCHAR','string','Remark','0','0','0','','',''),(256,11,0,'id','id','INT','int64','Id','1','0','0','','',''),(257,11,1,'type_id','分类id','INT','int64','TypeId','0','0','0','','',''),(258,11,2,'goods_name','商品名字','VARCHAR','string','GoodsName','0','0','0','','',''),(259,11,3,'introduction_id','商品介绍id','INT','int64','IntroductionId','0','0','0','','',''),(260,11,4,'sales_volume','近30天销量','INT','int64','SalesVolume','0','0','0','','',''),(261,11,5,'tag_ids','商品标签','VARCHAR','string','TagIds','0','0','0','','',''),(262,12,0,'id','id','INT','int64','Id','1','0','0','','',''),(263,12,1,'goods_id','商品id','INT','int64','GoodsId','0','0','0','','',''),(264,12,2,'commodity_area_name','商品属地名称','VARCHAR','string','CommodityAreaName','0','0','0','','',''),(265,12,3,'detail_image','详情图片','VARCHAR','string','DetailImage','0','0','0','','',''),(266,12,4,'detail_introduction_id','相关文本详情id','INT','int64','DetailIntroductionId','0','0','0','','',''),(267,13,0,'id','id','INT','int64','Id','1','0','0','','',''),(268,13,1,'coupon_name','优惠券名称','VARCHAR','string','CouponName','0','0','0','','',''),(269,13,2,'coupon_desc','优惠券描述','VARCHAR','string','CouponDesc','0','0','0','','',''),(270,13,3,'cash_back_point','满x','DECIMAL','float64','CashBackPoint','0','0','0','','',''),(271,13,4,'cash_back_price','减x','DECIMAL','float64','CashBackPrice','0','0','0','','',''),(272,13,5,'condition_by_topic','主题可用，id','VARCHAR','string','ConditionByTopic','0','0','0','','',''),(273,13,6,'condition_by_type','类型可用，id','VARCHAR','string','ConditionByType','0','0','0','','',''),(274,13,7,'condition_by_goods','商品可用，id','VARCHAR','string','ConditionByGoods','0','0','0','','',''),(275,13,8,'grant_count','发放数量','VARCHAR','string','GrantCount','0','0','0','','',''),(276,13,9,'count','优惠券余量','INT','int64','Count','0','0','0','','',''),(277,13,10,'receive_type','领取条件','VARCHAR','string','ReceiveType','0','0','0','','',''),(278,13,11,'validity','有效性，领取开始计时(ClaimTiming)，固定时间(FixedTime)','VARCHAR','string','Validity','0','0','0','','',''),(279,13,12,'validity_period','有效期','DATETIME','time.Time','ValidityPeriod','0','0','0','','',''),(280,14,0,'id','id','INT','int64','Id','1','0','0','','',''),(281,14,1,'user_id','用户id','INT','int64','UserId','0','0','0','','',''),(282,14,2,'coupon_id','优惠券id','INT','int64','CouponId','0','0','0','','',''),(283,14,3,'collection_time','领取时间','DATETIME','time.Time','CollectionTime','0','0','0','','',''),(284,14,4,'state','状态，已使用2，未使用1，已过期0','VARCHAR','string','State','0','0','0','','',''),(285,15,0,'id','文章id','INT','int64','Id','1','0','0','','',''),(286,15,1,'goods_article_name','商品文章名','VARCHAR','string','GoodsArticleName','0','0','0','','',''),(287,15,2,'goods_article','商品文章','LONGBLOB','string','GoodsArticle','0','0','0','','',''),(288,15,3,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(289,15,4,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(290,15,5,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(291,15,6,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','',''),(292,16,0,'id','id','INT','int64','Id','1','0','0','','',''),(293,16,1,'order_name','订单名','VARCHAR','string','OrderName','0','0','0','','',''),(294,16,2,'sku_id','skuid','INT','int64','SkuId','0','0','0','','',''),(295,16,3,'count','购买数量','INT','int64','Count','0','0','0','','',''),(296,16,4,'price','单价','DECIMAL','float64','Price','0','0','0','','',''),(297,16,5,'total_price','总价','DECIMAL','float64','TotalPrice','0','0','0','','',''),(298,16,6,'contact_information','联系方式','VARCHAR','string','ContactInformation','0','0','0','','',''),(299,16,7,'coupon_user_id','使用的优惠券','INT','int64','CouponUserId','0','0','0','','',''),(300,16,8,'state','支付状态，0待支付，1待发货，2已发货，3订单完成，4订单异常','VARCHAR','string','State','0','0','0','','',''),(301,16,9,'create_by','用户id','INT','int64','CreateBy','0','0','0','','',''),(302,16,10,'create_time','订单创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(303,17,0,'id','','INT','int64','Id','1','0','0','','',''),(304,17,1,'sku_image','sku图片','VARCHAR','string','SkuImage','0','0','0','','',''),(305,17,2,'sku_name','商品sku名字','VARCHAR','string','SkuName','0','0','0','','',''),(306,17,3,'price','现在价格','DECIMAL','float64','Price','0','0','0','','',''),(307,17,4,'historical_prices','历史价格','DECIMAL','float64','HistoricalPrices','0','0','0','','',''),(308,17,5,'inventory_number','库存','INT','int64','InventoryNumber','0','0','0','','',''),(309,17,6,'commodity_area_id','属地id','INT','int64','CommodityAreaId','0','0','0','','',''),(310,17,7,'goods_id','商品id','INT','int64','GoodsId','0','0','0','','',''),(311,17,8,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(312,17,9,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(313,18,0,'id','id','INT','int64','Id','1','0','0','','',''),(314,18,1,'card_name','卡种名称','VARCHAR','string','CardName','0','0','0','','',''),(315,18,2,'state','状态，0未使用，1已用，2过期','VARCHAR','string','State','0','0','0','','',''),(316,18,3,'count','库存','INT','int64','Count','0','0','0','','',''),(317,18,4,'total_count','总数','VARCHAR','string','TotalCount','0','0','0','','',''),(318,18,5,'card_key','卡密','VARCHAR','string','CardKey','0','0','0','','',''),(319,18,6,'use','是否已用','VARCHAR','string','Use','0','0','0','','',''),(320,18,7,'upload_time','入库时间','DATETIME','time.Time','UploadTime','0','0','0','','',''),(321,18,8,'sku_id','商品规格绑定','INT','int64','SkuId','0','0','0','','',''),(322,18,9,'sort','排序，出售优先级','VARCHAR','string','Sort','0','0','0','','',''),(323,19,0,'id','id','INT','int64','Id','1','0','0','','',''),(324,19,1,'name','名字','VARCHAR','string','Name','0','0','0','','',''),(325,19,2,'icon_url','图标路径','VARCHAR','string','IconUrl','0','0','0','','',''),(326,19,3,'tag','标签','VARCHAR','string','Tag','0','0','0','','',''),(327,20,0,'id','','INT','int64','Id','1','0','0','','',''),(328,20,1,'topic_page_image','主题首页图片','VARCHAR','string','TopicPageImage','0','0','0','','',''),(329,20,2,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','','',''),(330,20,3,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','','',''),(331,20,4,'type_ids','商品类型id','VARCHAR','string','TypeIds','0','0','0','','',''),(332,21,0,'id','','INT','int64','Id','1','0','0','','',''),(333,21,1,'sort','排序','INT','int64','Sort','0','0','0','','',''),(334,21,2,'type_image','类型图片','VARCHAR','string','TypeImage','0','0','0','','',''),(335,21,3,'type_name','商品类别名称','VARCHAR','string','TypeName','0','0','0','','',''),(336,21,4,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(337,27,0,'id','','INT','int64','Id','1','0','0','','',''),(338,27,1,'name','名称','VARCHAR','string','Name','0','0','0','','',''),(339,27,2,'username','账号','VARCHAR','string','Username','0','0','0','','',''),(340,27,3,'password','密码','VARCHAR','string','Password','0','0','0','','',''),(341,27,4,'creation_time','账号创建时间','INT','int64','CreationTime','0','0','0','','',''),(342,27,5,'login_time','登录时间','INT','int64','LoginTime','0','0','0','','',''),(343,27,6,'status','账号状态','VARCHAR','string','Status','0','0','0','','',''),(344,27,7,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(345,27,8,'phone','手机','VARCHAR','string','Phone','0','0','0','','',''),(346,27,9,'email','邮箱','VARCHAR','string','Email','0','0','0','','',''),(347,27,10,'avatar','头像','VARCHAR','string','Avatar','0','0','0','','',''),(348,28,0,'id','','INT','int64','Id','1','0','0','','',''),(349,28,1,'role_name','','VARCHAR','string','RoleName','0','0','0','','',''),(350,29,0,'authority_id','','INT','int64','AuthorityId','1','0','0','','',''),(351,29,1,'role_id','','INT','int64','RoleId','0','0','0','','',''),(352,22,0,'id','','INT','int64','Id','1','0','0','','',''),(353,22,1,'username','账号','VARCHAR','string','Username','0','0','0','','',''),(354,22,2,'password','密码','VARCHAR','string','Password','0','0','0','','',''),(355,22,3,'creation_time','账号创建时间','INT','int64','CreationTime','0','0','0','','',''),(356,22,4,'login_time','登录时间','INT','int64','LoginTime','0','0','0','','',''),(357,22,5,'status','账号状态','VARCHAR','string','Status','0','0','0','','',''),(358,22,6,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(359,22,7,'phone','手机','VARCHAR','string','Phone','0','0','0','','',''),(360,22,8,'email','邮箱','VARCHAR','string','Email','0','0','0','','',''),(361,22,9,'name','用户名','VARCHAR','string','Name','0','0','0','','',''),(362,22,10,'avatar','头像','VARCHAR','string','Avatar','0','0','0','','',''),(363,22,11,'recommend_code','推荐码','VARCHAR','string','RecommendCode','0','0','0','','',''),(364,23,0,'id','id','INT','int64','Id','1','0','0','','',''),(365,23,1,'user_id','用户id','INT','int64','UserId','0','0','0','','',''),(366,23,2,'balance','余额','DECIMAL','float64','Balance','0','0','0','','',''),(367,23,3,'promotion_amount','推广获取总金额','DECIMAL','float64','PromotionAmount','0','0','0','','',''),(368,23,4,'recharge_amount','充值金额','DECIMAL','float64','RechargeAmount','0','0','0','','',''),(369,30,0,'id','','INT','int64','Id','1','0','0','','',''),(370,30,1,'name','广告名称','VARCHAR','string','Name','0','0','0','','',''),(371,30,2,'to_id','目标id','INT','int64','ToId','0','0','0','','',''),(372,30,3,'advice_type','广告类型，用于跳转到对应的页面','VARCHAR','string','AdviceType','0','0','0','','',''),(373,30,4,'sort','排序','VARCHAR','string','Sort','0','0','0','','',''),(374,30,5,'state','状态','VARCHAR','string','State','0','0','0','','',''),(375,30,6,'show_type','显示类型，carousel轮播图，package，礼包','VARCHAR','string','ShowType','0','0','0','','',''),(376,30,7,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(377,30,8,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(378,30,9,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(379,30,10,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','',''),(380,31,0,'id','','INT','int64','Id','1','0','0','','',''),(381,31,1,'sort','','VARCHAR','string','Sort','0','0','0','','',''),(382,31,2,'parent_id','父级id','INT','int64','ParentId','0','0','0','','',''),(383,31,3,'topic_page_image','主题首页图片','VARCHAR','string','TopicPageImage','0','0','0','','',''),(384,31,4,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','','',''),(385,31,5,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','','',''),(386,31,6,'type_ids','商品类型id','VARCHAR','string','TypeIds','0','0','0','','',''),(387,32,0,'id',' ','INT','int64','Id','1','0','0','','',''),(388,32,1,'topic_id','','INT','int64','TopicId','0','0','0','','',''),(389,32,2,'sku_id','','INT','int64','SkuId','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_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 `shop_advice_carousel`
--

DROP TABLE IF EXISTS `shop_advice_carousel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shop_advice_carousel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '广告名称',
  `to_id` int(11) DEFAULT NULL COMMENT '目标id',
  `advice_type` varchar(255) DEFAULT NULL COMMENT '广告类型，用于跳转到对应的页面',
  `sort` varchar(255) DEFAULT NULL COMMENT '排序',
  `state` varchar(255) DEFAULT NULL COMMENT '状态',
  `show_type` varchar(50) DEFAULT NULL COMMENT '显示类型，carousel轮播图，package，礼包',
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shop_advice_carousel`
--

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

--
-- Table structure for table `shop_topic`
--

DROP TABLE IF EXISTS `shop_topic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shop_topic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sort` varchar(255) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL COMMENT '父级id',
  `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 `shop_topic`
--

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

--
-- Table structure for table `shop_topic_sku`
--

DROP TABLE IF EXISTS `shop_topic_sku`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shop_topic_sku` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT ' ',
  `topic_id` int(11) DEFAULT NULL,
  `sku_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shop_topic_sku`
--

LOCK TABLES `shop_topic_sku` WRITE;
/*!40000 ALTER TABLE `shop_topic_sku` DISABLE KEYS */;
/*!40000 ALTER TABLE `shop_topic_sku` 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','4fef88243e8e49e90007fdfe2df0e53f',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-22  9:15:36