kkc-go/file/virtual_mall-2024-07-05.sql

-- 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_desc` 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 AUTO_INCREMENT=8 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 */;
INSERT INTO `article` VALUES (1,'文章测试1','1.本商品为美国地区的苹果iTunes充值卡，如果您是国区的账号请勿下单。如果没有美国地区账号可以选择在【带账号】类型内下单。\r\n\r\n2.以上面值能拍的都有货，直接下单即可。\r\n\r\n3.充值卡就是钱，请一定要保管好手里的充值卡，不要相信除平台工作人员以外和您有联系的任何人。\r\n\r\n4.兑换充值卡时会自动从卡余额内扣除一定税，如遇余额不足等情况不属于平台售后政策内。',_binary '<p><span style=\"font-family: 黑体;\">别</span><span style=\"font-family: 仿宋;\"><strong>看</strong></span><u>了</u><em>，这</em><s>个</s><code>文</code><sup>章</sup><sub>没</sub><span style=\"font-size: 12px;\">什</span><span style=\"font-size: 40px; font-family: 标楷体;\">么</span><span style=\"font-size: 24px;\">好</span><span style=\"font-size: 14px;\">看</span><span style=\"font-size: 48px; font-family: 楷体;\">的</span></p>','1','1',1,'/api/static/202405201111165c8a0eec19d9a.jpg','2024-05-20 14:02:47',996,56,'1','2024-05-20 14:02:47','',NULL),(2,'文章测试2','1.本商品为美国地区的苹果iTunes充值卡，如果您是国区的账号请勿下单。如果没有美国地区账号可以选择在【带账号】类型内下单。\r\n\r\n2.以上面值能拍的都有货，直接下单即可。\r\n\r\n3.充值卡就是钱，请一定要保管好手里的充值卡，不要相信除平台工作人员以外和您有联系的任何人。\r\n\r\n4.兑换充值卡时会自动从卡余额内扣除一定税，如遇余额不足等情况不属于平台售后政策内。',_binary '<p><span style=\"font-family: 黑体;\">别</span><span style=\"font-family: 仿宋;\"><strong>看</strong></span><u>了</u><em>，这</em><s>个</s><code>文</code><sup>章</sup><sub>没</sub><span style=\"font-size: 12px;\">什</span><span style=\"font-size: 40px; font-family: 标楷体;\">么</span><span style=\"font-size: 24px;\">好</span><span style=\"font-size: 14px;\">看</span><span style=\"font-size: 48px; font-family: 楷体;\">的</span></p>','1','1',1,'/api/static/202405201111165c8a0eec19d9a.jpg','2024-05-20 14:02:47',122665,655,'1','2024-05-20 14:02:47','',NULL),(3,'文章测试3','1.本商品为美国地区的苹果iTunes充值卡，如果您是国区的账号请勿下单。如果没有美国地区账号可以选择在【带账号】类型内下单。\r\n\r\n2.以上面值能拍的都有货，直接下单即可。\r\n\r\n3.充值卡就是钱，请一定要保管好手里的充值卡，不要相信除平台工作人员以外和您有联系的任何人。\r\n\r\n4.兑换充值卡时会自动从卡余额内扣除一定税，如遇余额不足等情况不属于平台售后政策内。',_binary '<p><span style=\"font-family: 黑体;\">别</span><span style=\"font-family: 仿宋;\"><strong>看</strong></span><u>了</u><em>，这</em><s>个</s><code>文</code><sup>章</sup><sub>没</sub><span style=\"font-size: 12px;\">什</span><span style=\"font-size: 40px; font-family: 标楷体;\">么</span><span style=\"font-size: 24px;\">好</span><span style=\"font-size: 14px;\">看</span><span style=\"font-size: 48px; font-family: 楷体;\">的</span></p>','1','2',1,'/api/static/202405201111165c8a0eec19d9a.jpg','2024-05-20 14:02:47',452,20,'1','2024-05-20 14:02:47','',NULL),(4,'文章测试4',NULL,_binary '<p><span style=\"font-family: 黑体;\">别</span><span style=\"font-family: 仿宋;\"><strong>看</strong></span><u>了</u><em>，这</em><s>个</s><code>文</code><sup>章</sup><sub>没</sub><span style=\"font-size: 12px;\">什</span><span style=\"font-size: 40px; font-family: 标楷体;\">么</span><span style=\"font-size: 24px;\">好</span><span style=\"font-size: 14px;\">看</span><span style=\"font-size: 48px; font-family: 楷体;\">的</span></p>','1','1',1,'/api/static/202405201111165c8a0eec19d9a.jpg','2024-05-10 14:02:47',0,0,'1','2024-05-20 14:02:47','',NULL),(5,'文章测试5',NULL,_binary '<p><span style=\"font-family: 黑体;\">别</span><span style=\"font-family: 仿宋;\"><strong>看</strong></span><u>了</u><em>，这</em><s>个</s><code>文</code><sup>章</sup><sub>没</sub><span style=\"font-size: 12px;\">什</span><span style=\"font-size: 40px; font-family: 标楷体;\">么</span><span style=\"font-size: 24px;\">好</span><span style=\"font-size: 14px;\">看</span><span style=\"font-size: 48px; font-family: 楷体;\">的</span></p>','1','2',1,'/api/static/202405201111165c8a0eec19d9a.jpg','2023-05-20 14:02:47',7043,300,'1','2024-05-20 14:02:47','',NULL),(6,'文章测试6',NULL,_binary '<p><span style=\"font-family: 黑体;\">别</span><span style=\"font-family: 仿宋;\"><strong>看</strong></span><u>了</u><em>，这</em><s>个</s><code>文</code><sup>章</sup><sub>没</sub><span style=\"font-size: 12px;\">什</span><span style=\"font-size: 40px; font-family: 标楷体;\">么</span><span style=\"font-size: 24px;\">好</span><span style=\"font-size: 14px;\">看</span><span style=\"font-size: 48px; font-family: 楷体;\">的</span></p>','1','2',1,'/api/static/202405201111165c8a0eec19d9a.jpg','2024-05-23 22:33:59',5637898,10008,'1','2024-05-23 22:31:59','',NULL),(7,'文章测试7',NULL,_binary '<p><span style=\"font-family: 黑体;\">别</span><span style=\"font-family: 仿宋;\"><strong>看</strong></span><u>了</u><em>，这</em><s>个</s><code>文</code><sup>章</sup><sub>没</sub><span style=\"font-size: 12px;\">什</span><span style=\"font-size: 40px; font-family: 标楷体;\">么</span><span style=\"font-size: 24px;\">好</span><span style=\"font-size: 14px;\">看</span><span style=\"font-size: 48px; font-family: 楷体;\">的</span></p>','1','2',2,'/api/static/202405201111165c8a0eec19d9a.jpg','2024-05-23 22:30:59',2,1,'1','2024-05-23 22:31:59','',NULL);
/*!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 '标签描述',
  `tag_text_color` varchar(10) DEFAULT NULL COMMENT '标签字体颜色',
  `tag_background_color` varchar(10) 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 `article_tag`
--

LOCK TABLES `article_tag` WRITE;
/*!40000 ALTER TABLE `article_tag` DISABLE KEYS */;
INSERT INTO `article_tag` VALUES (1,'B2主题教程','测试用','#e04a1c','#fcede8'),(2,'主题更新','简单的更新','#8224e3','#a254f3');
/*!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 AUTO_INCREMENT=3 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 */;
INSERT INTO `article_topic` VALUES (1,'/api/static/202405231043235c8a0eec19d9a.jpg','六月新品有什么？','本月的新品发布会全都在这里：realme V5、vivo S7、谷歌 Pixel 4a、Nokia C3、27 英寸 iMac、三星 Note 20、小米 10 Pro+….八月的新品发布会中，你最期待哪一场？'),(2,'/api/static/202405231043235c8a0eec19d9a.jpg','六月新品有什么？','本月的新品发布会全都在这里：realme V5、vivo S7、谷歌 Pixel 4a、Nokia C3、27 英寸 iMac、三星 Note 20、小米 10 Pro+….八月的新品发布会中，你最期待哪一场？');
/*!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=234 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','log','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,'','/home/','GET','1','','2024-05-21 10:52:57'),(196,'','/back/goods/introduction','GET','1','','2024-05-21 15:00:55'),(197,'','/back/goods/:id','GET','1','','2024-05-21 15:00:55'),(198,'','/back/goods','PUT','1','','2024-05-21 15:00:55'),(199,'','/back/goods/:id','PUT','1','','2024-05-21 15:00:55'),(200,'','/back/goods','POST','1','','2024-05-21 15:00:55'),(201,'','/back/goods/list','POST','1','','2024-05-21 15:00:55'),(202,'','/back/goods/:id','POST','1','','2024-05-21 15:00:55'),(203,'','/back/goods/:id','HEAD','1','','2024-05-21 15:00:55'),(204,'','/back/goods/:id','PATCH','1','','2024-05-21 15:00:55'),(205,'','/back/goods/:id','OPTIONS','1','','2024-05-21 15:00:55'),(206,'','/back/goods/:id','DELETE','1','','2024-05-21 15:00:55'),(207,'','/back/goods/:id','CONNECT','1','','2024-05-21 15:00:55'),(208,'','/back/goods/:id','TRACE','1','','2024-05-21 15:00:55'),(209,'','/back/base/shopTopic','GET','1','','2024-05-22 09:38:45'),(210,'','/back/base/shopTopicSku','GET','1','','2024-05-22 09:38:45'),(211,'','/back/base/shopAdviceCarousel','GET','1','','2024-05-22 09:38:45'),(212,'','/back/base/shopTopic','PUT','1','','2024-05-22 09:38:45'),(213,'','/back/base/shopTopicSku','PUT','1','','2024-05-22 09:38:45'),(214,'','/back/base/shopAdviceCarousel','PUT','1','','2024-05-22 09:38:45'),(215,'','/back/base/shopTopic','POST','1','','2024-05-22 09:38:45'),(216,'','/back/base/shopTopicSku','POST','1','','2024-05-22 09:38:45'),(217,'','/back/base/shopTopicSku/list','POST','1','','2024-05-22 09:38:45'),(218,'','/back/base/shopTopicSku/in','POST','1','','2024-05-22 09:38:45'),(219,'','/back/base/shopTopic/list','POST','1','','2024-05-22 09:38:45'),(220,'','/back/base/shopTopic/in','POST','1','','2024-05-22 09:38:45'),(221,'','/back/base/shopAdviceCarousel','POST','1','','2024-05-22 09:38:45'),(222,'','/back/base/shopAdviceCarousel/list','POST','1','','2024-05-22 09:38:45'),(223,'','/back/base/shopAdviceCarousel/in','POST','1','','2024-05-22 09:38:45'),(224,'','/back/base/shopTopic','DELETE','1','','2024-05-22 09:38:45'),(225,'','/back/base/shopTopicSku','DELETE','1','','2024-05-22 09:38:45'),(226,'','/back/base/shopAdviceCarousel','DELETE','1','','2024-05-22 09:38:45'),(227,'','/back/gen/column','POST','1','','2024-05-22 10:36:43'),(228,'','/home/banner','GET','1','','2024-05-22 15:20:03'),(229,'','/article/collection','GET','1','','2024-05-23 10:32:06'),(230,'','/user/base/info','GET','1','','2024-05-23 15:13:15'),(231,'','/article/topic','GET','1','','2024-05-23 16:17:09'),(232,'','/home/index','GET','1','','2024-05-26 23:24:08'),(233,'','/home/topic','GET','1','','2024-05-26 23:24:08');
/*!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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC 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','1'),(2,'系统设置',0,1,'Setting','系统设置','/','1'),(3,'系统商城',0,0,'Shop','菜单设置','/','1'),(4,'文章',29,4,'Setting','文章','/back/article','1'),(5,'文章标签',29,5,'Setting','文章标签','/back/articleTag','1'),(6,'文章主题',29,6,'Setting','文章主题','/back/articleTopic','1'),(7,'后台权限校验',30,7,'Setting','后台权限校验','/back/backAuthority','1'),(8,'后台菜单',30,8,'Setting','后台菜单','/back/backMenu','1'),(9,'后台角色',30,9,'Setting','后台角色','/back/backRole','1'),(10,'后台角色权限表',30,10,'Setting','后台角色权限表','/back/backRoleAuthority','1'),(11,'后台角色菜单表',30,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','0'),(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,'用户表',30,27,'Setting','用户表','/back/user','1'),(28,'用户钱包',30,28,'Setting','用户钱包','/back/userWallet','1'),(29,'文章管理',0,29,'Setting','文章管理系统','/','1'),(30,'用户管理',0,30,'Setting','用户管理','/','1'),(31,'商城广告',3,28,'Setting','商城广告','/back/shopAdviceCarousel','1'),(32,'商城主题',3,29,'Setting','商品主题','/back/shopTopic','1'),(33,'商城主题商品',3,30,'Setting','商城主题商品','/back/shopTopicSku','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=4 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,'普通用户'),(3,'管理员');
/*!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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=174 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC 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),(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,3,1),(142,3,2),(143,3,3),(144,3,4),(145,3,5),(146,3,6),(147,3,7),(148,3,8),(149,3,9),(150,3,10),(151,3,11),(152,3,12),(153,3,13),(156,3,16),(157,3,17),(158,3,18),(159,3,19),(160,3,20),(161,3,21),(162,3,22),(163,3,23),(164,3,24),(165,3,25),(166,3,26),(167,3,27),(168,3,28),(169,3,29),(170,3,30),(171,3,31),(172,3,32),(173,3,33);
/*!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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC 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','','',''),(29,0,'纯文本显示','text','vue_show_type','1','','',''),(30,0,'主题','topic','advice_type','1','','',''),(31,0,'商品规格','sku','advice_type','1','','',''),(32,0,'商品规格','sku_type','to_type','1','','',''),(33,0,'商品主题','topic_type','to_type','1','','',''),(34,0,'轮播图','carousel','show_type','1','','',''),(35,0,'特惠礼包','package','show_type','1','','',''),(36,0,'领取开始计时','ClaimTiming','coupon_validity','1','','',''),(37,0,'固定时间','FixedTime','coupon_validity','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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC 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',''),(6,'广告类型','advice_type','1',''),(7,'显示类型','show_type','1',''),(8,'跳转目标类型','to_type','1',''),(9,'优惠券有效性','coupon_validity','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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!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','商品标签'),(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',''),(31,'shop_advice_carousel','','ShopAdviceCarousel','shopAdviceCarousel',''),(32,'shop_topic','商品主题','ShopTopic','shopTopic','商品主题'),(33,'shop_topic_sku','','ShopTopicSku','shopTopicSku',''),(34,'shop_advice_carousel','商城广告','ShopAdviceCarousel','shopAdviceCarousel','商城广告'),(35,'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` varchar(255) DEFAULT NULL COMMENT '查询方式',
  `vue_show_type` varchar(255) DEFAULT NULL COMMENT '前端显示类型',
  `dict_type` varchar(255) DEFAULT NULL COMMENT '字典类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=466 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!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','1','1','EQ','text',''),(196,1,1,'article_title','文章名称','VARCHAR','string','ArticleTitle','0','0','0','like','input',''),(197,1,2,'article_content','文章内容','LONGBLOB','string','ArticleContent','0','0','0','like','editor',''),(198,1,3,'state','状态','VARCHAR','string','State','0','0','0','EQ','select','sys_state'),(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','','image',''),(202,1,7,'publish_time','发表时间','DATETIME','time.Time','PublishTime','0','0','0','','time',''),(203,1,8,'eye_fill','浏览量','INT','int64','EyeFill','0','0','0','','number',''),(204,1,9,'like_count','点赞量','INT','int64','LikeCount','0','0','0','','number',''),(205,1,10,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(206,1,11,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','time',''),(207,1,12,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(208,1,13,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','time',''),(209,2,0,'id','','INT','int64','Id','1','0','0','','',''),(210,2,1,'tag_name','标签名','VARCHAR','string','TagName','0','0','0','EQ','input',''),(211,2,2,'tag_desc','标签描述','VARCHAR','string','TagDesc','0','0','0','','input',''),(212,3,0,'id','','INT','int64','Id','1','0','0','','',''),(213,3,1,'image','图片','VARCHAR','string','Image','0','0','0','','image',''),(214,3,2,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','','input',''),(215,3,3,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','','textarea',''),(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','','select',''),(258,11,2,'goods_name','商品名字','VARCHAR','string','GoodsName','0','0','0','like','input',''),(259,11,3,'introduction_id','商品介绍id','INT','int64','IntroductionId','0','0','0','','',''),(260,11,4,'sales_volume','近30天销量','INT','int64','SalesVolume','0','0','0','BETWEEN','number',''),(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','','input',''),(265,12,3,'detail_image','详情图片','VARCHAR','string','DetailImage','0','0','0','','image',''),(266,12,4,'detail_introduction_id','相关文本详情id','INT','int64','DetailIntroductionId','0','0','0','','select',''),(267,13,0,'id','id','INT','int64','Id','1','0','0','','',''),(268,13,1,'coupon_name','优惠券名称','VARCHAR','string','CouponName','0','0','0','like','input',''),(269,13,2,'coupon_desc','优惠券描述','VARCHAR','string','CouponDesc','0','0','0','','textarea',''),(270,13,3,'cash_back_point','满x','DECIMAL','float64','CashBackPoint','0','0','0','','number',''),(271,13,4,'cash_back_price','减x','DECIMAL','float64','CashBackPrice','0','0','0','','number',''),(272,13,5,'condition_by_topic','主题可用，id','VARCHAR','string','ConditionByTopic','0','0','0','','select',''),(273,13,6,'condition_by_type','类型可用，id','VARCHAR','string','ConditionByType','0','0','0','','select',''),(274,13,7,'condition_by_goods','商品可用，id','VARCHAR','string','ConditionByGoods','0','0','0','','select',''),(275,13,8,'grant_count','发放数量','VARCHAR','string','GrantCount','0','0','0','','number',''),(276,13,9,'count','优惠券余量','INT','int64','Count','0','0','0','','',''),(277,13,10,'receive_type','领取条件','VARCHAR','string','ReceiveType','0','0','0','','input',''),(278,13,11,'validity','有效性，领取开始计时(ClaimTiming)，固定时间(FixedTime)','VARCHAR','string','Validity','0','0','0','','select','coupon_validity'),(279,13,12,'validity_period','有效期','DATETIME','time.Time','ValidityPeriod','0','0','0','','time',''),(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','','input',''),(287,15,2,'goods_article','商品文章','LONGBLOB','string','GoodsArticle','0','0','0','','editor',''),(288,15,3,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(289,15,4,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','time',''),(290,15,5,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(291,15,6,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','time',''),(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','','image',''),(305,17,2,'sku_name','商品sku名字','VARCHAR','string','SkuName','0','0','0','','input',''),(306,17,3,'price','现在价格','DECIMAL','float64','Price','0','0','0','','input',''),(307,17,4,'historical_prices','历史价格','DECIMAL','float64','HistoricalPrices','0','0','0','','input',''),(308,17,5,'inventory_number','库存','INT','int64','InventoryNumber','0','0','0','','number',''),(309,17,6,'commodity_area_id','属地id','INT','int64','CommodityAreaId','0','0','0','','select',''),(310,17,7,'goods_id','商品id','INT','int64','GoodsId','0','0','0','','select',''),(311,17,8,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(312,17,9,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','time',''),(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','like','input',''),(325,19,2,'icon_url','图标路径','VARCHAR','string','IconUrl','0','0','0','','image',''),(326,19,3,'tag','标签','VARCHAR','string','Tag','0','0','0','','input',''),(327,20,0,'id','','INT','int64','Id','1','0','0','','',''),(328,20,1,'topic_page_image','主题首页图片','VARCHAR','string','TopicPageImage','0','0','0','','image',''),(329,20,2,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','','input',''),(330,20,3,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','','textarea',''),(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','','image',''),(335,21,3,'type_name','商品类别名称','VARCHAR','string','TypeName','0','0','0','','input',''),(336,21,4,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','time',''),(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','','image',''),(363,22,11,'recommend_code','推荐码','VARCHAR','string','RecommendCode','0','0','0','','text',''),(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','','',''),(370,10,11,'query_type','查询方式','VARCHAR','string','QueryType','0','0','0','','',''),(372,1,0,'id','id','INT','int64','Id','1','0','0','','',''),(373,30,0,'id','','INT','int64','Id','1','0','0','','',''),(374,30,1,'sort','排序','VARCHAR','string','Sort','0','0','0','','',''),(375,30,2,'image_url','图片','VARCHAR','string','ImageUrl','0','0','0','','',''),(376,30,3,'sku_id','商品规格','INT','int64','SkuId','0','0','0','','',''),(377,30,4,'show','显示','VARCHAR','string','Show','0','0','0','','',''),(378,30,5,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(379,30,6,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(380,30,7,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(381,30,8,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','',''),(382,31,0,'id','','INT','int64','Id','1','0','0','','',''),(383,31,1,'name','广告名称','VARCHAR','string','Name','0','0','0','','input',''),(384,31,2,'to_id','目标id','INT','int64','ToId','0','0','0','','input',''),(385,31,3,'advice_type','广告类型','VARCHAR','string','AdviceType','0','0','0','','select','advice_type'),(386,31,4,'sort','排序','VARCHAR','string','Sort','0','0','0','','number',''),(387,31,5,'state','状态','VARCHAR','string','State','0','0','0','','radio',''),(388,31,6,'show_type','显示类型','VARCHAR','string','ShowType','0','0','0','','select','show_type'),(389,31,7,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(390,31,8,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(391,31,9,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(392,31,10,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','',''),(393,32,0,'id','','INT','int64','Id','1','0','0','','',''),(394,32,1,'sort','','VARCHAR','string','Sort','0','0','0','','number',''),(395,32,2,'parent_id','父级id','INT','int64','ParentId','0','0','0','','',''),(396,32,3,'topic_page_image','主题首页图片','VARCHAR','string','TopicPageImage','0','0','0','','image',''),(397,32,4,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','','input',''),(398,32,5,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','','input',''),(399,32,6,'type_ids','商品类型id','VARCHAR','string','TypeIds','0','0','0','','',''),(400,33,0,'id',' ','INT','int64','Id','1','0','0','','',''),(401,33,1,'topic_id','','INT','int64','TopicId','0','0','0','','',''),(402,33,2,'sku_id','','INT','int64','SkuId','0','0','0','','',''),(403,34,0,'id','','INT','int64','Id','1','0','0','','',''),(404,34,1,'name','广告名称','VARCHAR','string','Name','0','0','0','','input',''),(405,34,2,'to_id','目标id','INT','int64','ToId','0','0','0','','input',''),(406,34,3,'advice_type','广告类型，用于跳转到对应的页面','VARCHAR','string','AdviceType','0','0','0','','select','advice_type'),(407,34,4,'sort','排序','VARCHAR','string','Sort','0','0','0','','number',''),(408,34,5,'state','状态','VARCHAR','string','State','0','0','0','','radio',''),(409,34,6,'show_type','显示类型，carousel轮播图，package，礼包','VARCHAR','string','ShowType','0','0','0','','select','show_type'),(410,34,7,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(411,34,8,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(412,34,9,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(413,34,10,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','',''),(414,35,0,'id',' ','INT','int64','Id','1','0','0','','',''),(415,35,1,'topic_id','','INT','int64','TopicId','0','0','0','','',''),(416,35,2,'sku_id','','INT','int64','SkuId','0','0','0','','',''),(417,34,2,'image_url','图片','VARCHAR','string','ImageUrl','0','0','0','','image',''),(465,34,3,'to_type','目标类型','VARCHAR','string','ToType','0','0','0',NULL,'select','to_type');
/*!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) DEFAULT NULL COMMENT '分类id',
  `goods_name` varchar(255) DEFAULT 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=104 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,'苹果礼品卡特惠包',1,0,'1,2'),(2,2,'PUBG国际服直充',2,0,'2'),(11,3,'Steam全球号',11,172602,NULL),(12,4,'IOS全球卡密【直降5%】',13,4147,NULL),(13,5,'Netflix（奈飞）会员账号',15,1447,NULL),(14,1,'谷歌礼品卡 【直降5%】',17,2150,NULL),(15,4,'Steam（美国）充值卡',18,919,NULL),(16,4,'Razer全球卡密【直降3%】',19,333,NULL),(17,4,'Roblox充值卡',20,254,NULL),(18,4,'eBay（美国）充值卡',21,300,NULL),(19,5,'苹果全球ID',22,48163,NULL),(20,4,'xbox（全球）充值卡',24,510,NULL),(21,4,'任天堂充值卡【直降4%】',25,4762,NULL),(22,6,'Steam（阿根廷）余额代充',27,410,NULL),(23,5,'推特全球ID',28,9021,NULL),(24,5,'Ins全球账号',30,1911,NULL),(25,5,'TikTok账号',31,2893,NULL),(26,5,'YouTube账号',32,2264,NULL),(27,5,'Nexon账号',33,1911,NULL),(28,5,'Discord账号',34,1646,NULL),(29,5,'亚马逊游戏会员账号',35,1559,NULL),(30,5,'twitch账号',36,1050,NULL),(31,5,'ESPN会员账号',37,1121,NULL),(32,5,'迪士尼Plus会员账号',39,1650,NULL),(33,5,'暴雪战网账号',41,1545,NULL),(34,5,'EPIC账号',42,3281,NULL),(35,4,'Netflix（美国）充值卡',43,105,NULL),(36,4,'Steam（美国）余额代充',44,1560,NULL),(37,4,'steam（土耳其）充值卡',45,3660,NULL),(38,4,'steam（韩国）充值卡',46,1771,NULL),(39,4,'BitCash（日本）充值卡',47,1871,NULL),(40,1,'Nexon（美国）礼品卡',48,1556,NULL),(41,4,'GoCash（全球）充值卡',49,1209,NULL),(42,6,'Steam（新西兰）余额代充',50,1499,NULL),(43,8,'普雷卡Pcard',51,761,NULL),(44,4,'Nexon（韩国）充值卡',52,1666,NULL),(45,4,'刀塔自走棋糖果兑换码',53,898,NULL),(46,4,'webmoney（日本）充值卡',54,721,NULL),(47,4,'香港GC充值卡',55,764,NULL),(48,4,'任天堂（澳洲）充值卡',56,1499,NULL),(49,4,'任天堂（巴西）充值卡',57,1444,NULL),(50,1,'苹果礼品卡特惠包',58,473,NULL),(51,6,'steam点卡特惠包',59,823,NULL),(52,1,'谷歌礼品卡特惠包',60,1,NULL),(53,8,'暴雪战网（阿根廷）点数',61,1125,NULL),(54,6,'steam（俄罗斯）余额代充',62,1029,NULL),(55,4,'任天堂（英国）充值卡',63,1136,NULL),(56,5,'雅虎邮箱账号',64,476,NULL),(57,5,'谷歌（全球）邮箱账号',65,3847,NULL),(58,5,'微软（全球）邮箱账号',66,782,NULL),(59,5,'俄罗斯邮箱账号',67,1,NULL),(60,5,'美国邮箱账号',68,601,NULL),(61,5,'Midjourney会员账号',69,182,NULL),(62,7,'求生之路2【steam版】',71,102,NULL),(63,7,'壁纸引擎【steam版】',72,1,NULL),(64,7,'城市：天际线【steam版】',73,82,NULL),(65,7,'植物大战僵尸：年度版【steam版】',75,148,NULL),(66,7,'方舟：生存进化【steam版】',76,148,NULL),(67,7,'木筏求生【steam版】',77,101,NULL),(68,7,'模拟人生4【steam版】',78,1,NULL),(69,7,'饥荒联机版【steam版】',79,456,NULL),(70,7,'反恐精英1.6【steam版】',80,359,NULL),(71,7,'太空狼人杀Among Us【steam版】',81,77,NULL),(72,7,'人类一败涂地【steam版】',83,1648,NULL),(73,5,'APP安装包下载',88,8308,NULL),(74,5,'facebook账号',91,1,NULL),(75,4,'PSN（全球）充值卡',92,1,NULL),(76,7,'任天堂游戏CDK',94,140,NULL),(77,2,'幻塔（国际服）直充',95,309,NULL),(78,6,'GoPay钱包代充',96,12,NULL),(79,2,'PUBG国际服直充',98,1482,NULL),(80,6,'PayNow钱包代充',99,1,NULL),(81,6,'Grabpay钱包代充',100,1,NULL),(82,8,'Windows正版系统激活码',104,130,NULL),(83,2,'LOL国际手游（直充）',106,302,NULL),(84,2,'卡通农场（国际服）直充',107,250,NULL),(85,2,'皇室战争（国际服）直充',108,275,NULL),(86,2,'部落冲突（国际服）直充',109,221,NULL),(87,2,'荒野乱斗（国际服）直充',110,264,NULL),(88,2,'胜利女神（国际服）手游直充',111,211,NULL),(89,2,'暗区突围（国际服）直充',112,222,NULL),(90,2,'蛋仔派对（国际服）直充',113,308,NULL),(91,5,'HBO鼎级剧场 会员账号',114,1524,NULL),(92,2,'原神手游（国际服）直充',115,246,NULL),(93,2,'WeTV 会员直充',116,235,NULL),(94,5,'hulu会员账号',117,0,NULL),(95,2,'PUBG：未来之役（国际服）直充',118,129,NULL),(96,2,'第五人格（国际服）直充',119,129,NULL),(97,2,'瓦罗兰特（马来西亚）直充',120,294,NULL),(98,2,'漫威：瞬战超能（国际服）直充',121,25,NULL),(99,2,'明日之后（国际服）直充',122,14,NULL),(100,2,'Mobile Legends 无尽对决充值',123,279,NULL),(101,2,'王者荣耀（国际服）直充',124,305,NULL),(102,5,'谷歌全球ID',125,6885,NULL),(103,7,'符文大地传说手游',126,1629,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=35 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),(11,11,'steam空白账号',NULL,12),(12,12,'美国',NULL,14),(13,13,'共享（5人）',NULL,16),(14,19,'苹果ID账号（未开通iCloud）',NULL,23),(15,21,'香港',NULL,26),(16,23,'账号',NULL,29),(17,31,'独享',NULL,38),(18,32,'独享（1人）',NULL,40),(19,61,'独享账号',NULL,70),(20,64,'激活码',NULL,74),(21,71,'成品账号',NULL,82),(22,72,'中国香港',NULL,84),(23,72,'日本',NULL,85),(24,72,'欧洲',NULL,86),(25,72,'巴西',NULL,87),(26,73,'不带账号',NULL,89),(27,73,'APP',NULL,90),(28,75,'steam安卓APP',NULL,93),(29,78,'印尼',NULL,97),(30,81,'新加坡',NULL,101),(31,81,'马来西亚',NULL,102),(32,81,'泰国',NULL,103),(33,82,'一次性',NULL,105),(34,103,'美国/加拿大',NULL,127);
/*!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=128 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),(11,'Steam全球号',_binary '<p>Steam全球号</p>',NULL,NULL,NULL,NULL),(12,'steam空白账号',_binary '<p>steam空白账号</p>',NULL,NULL,NULL,NULL),(13,'IOS全球卡密【直降5%】',_binary '<p>IOS全球卡密【直降5%】</p>',NULL,NULL,NULL,NULL),(14,'美国',_binary '<p>美国</p>',NULL,NULL,NULL,NULL),(15,'Netflix（奈飞）会员账号',_binary '<p>Netflix（奈飞）会员账号</p>',NULL,NULL,NULL,NULL),(16,'共享（5人）',_binary '<p>共享（5人）</p>',NULL,NULL,NULL,NULL),(17,'谷歌礼品卡 【直降5%】',_binary '<p>谷歌礼品卡 【直降5%】</p>',NULL,NULL,NULL,NULL),(18,'Steam（美国）充值卡',_binary '<p>Steam（美国）充值卡</p>',NULL,NULL,NULL,NULL),(19,'Razer全球卡密【直降3%】',_binary '<p>Razer全球卡密【直降3%】</p>',NULL,NULL,NULL,NULL),(20,'Roblox充值卡',_binary '<p>Roblox充值卡</p>',NULL,NULL,NULL,NULL),(21,'eBay（美国）充值卡',_binary '<p>eBay（美国）充值卡</p>',NULL,NULL,NULL,NULL),(22,'苹果全球ID',_binary '<p>苹果全球ID</p>',NULL,NULL,NULL,NULL),(23,'苹果ID账号（未开通iCloud）',_binary '<p>苹果ID账号（未开通iCloud）</p>',NULL,NULL,NULL,NULL),(24,'xbox（全球）充值卡',_binary '<p>xbox（全球）充值卡</p>',NULL,NULL,NULL,NULL),(25,'任天堂充值卡【直降4%】',_binary '<p>任天堂充值卡【直降4%】</p>',NULL,NULL,NULL,NULL),(26,'香港',_binary '<p>香港</p>',NULL,NULL,NULL,NULL),(27,'Steam（阿根廷）余额代充',_binary '<p>Steam（阿根廷）余额代充</p>',NULL,NULL,NULL,NULL),(28,'推特全球ID',_binary '<p>推特全球ID</p>',NULL,NULL,NULL,NULL),(29,'账号',_binary '<p>账号</p>',NULL,NULL,NULL,NULL),(30,'Ins全球账号',_binary '<p>Ins全球账号</p>',NULL,NULL,NULL,NULL),(31,'TikTok账号',_binary '<p>TikTok账号</p>',NULL,NULL,NULL,NULL),(32,'YouTube账号',_binary '<p>YouTube账号</p>',NULL,NULL,NULL,NULL),(33,'Nexon账号',_binary '<p>Nexon账号</p>',NULL,NULL,NULL,NULL),(34,'Discord账号',_binary '<p>Discord账号</p>',NULL,NULL,NULL,NULL),(35,'亚马逊游戏会员账号',_binary '<p>亚马逊游戏会员账号</p>',NULL,NULL,NULL,NULL),(36,'twitch账号',_binary '<p>twitch账号</p>',NULL,NULL,NULL,NULL),(37,'ESPN会员账号',_binary '<p>ESPN会员账号</p>',NULL,NULL,NULL,NULL),(38,'独享',_binary '<p>独享</p>',NULL,NULL,NULL,NULL),(39,'迪士尼Plus会员账号',_binary '<p>迪士尼Plus会员账号</p>',NULL,NULL,NULL,NULL),(40,'独享（1人）',_binary '<p>独享（1人）</p>',NULL,NULL,NULL,NULL),(41,'暴雪战网账号',_binary '<p>暴雪战网账号</p>',NULL,NULL,NULL,NULL),(42,'EPIC账号',_binary '<p>EPIC账号</p>',NULL,NULL,NULL,NULL),(43,'Netflix（美国）充值卡',_binary '<p>Netflix（美国）充值卡</p>',NULL,NULL,NULL,NULL),(44,'Steam（美国）余额代充',_binary '<p>Steam（美国）余额代充</p>',NULL,NULL,NULL,NULL),(45,'steam（土耳其）充值卡',_binary '<p>steam（土耳其）充值卡</p>',NULL,NULL,NULL,NULL),(46,'steam（韩国）充值卡',_binary '<p>steam（韩国）充值卡</p>',NULL,NULL,NULL,NULL),(47,'BitCash（日本）充值卡',_binary '<p>BitCash（日本）充值卡</p>',NULL,NULL,NULL,NULL),(48,'Nexon（美国）礼品卡',_binary '<p>Nexon（美国）礼品卡</p>',NULL,NULL,NULL,NULL),(49,'GoCash（全球）充值卡',_binary '<p>GoCash（全球）充值卡</p>',NULL,NULL,NULL,NULL),(50,'Steam（新西兰）余额代充',_binary '<p>Steam（新西兰）余额代充</p>',NULL,NULL,NULL,NULL),(51,'普雷卡Pcard',_binary '<p>普雷卡Pcard</p>',NULL,NULL,NULL,NULL),(52,'Nexon（韩国）充值卡',_binary '<p>Nexon（韩国）充值卡</p>',NULL,NULL,NULL,NULL),(53,'刀塔自走棋糖果兑换码',_binary '<p>刀塔自走棋糖果兑换码</p>',NULL,NULL,NULL,NULL),(54,'webmoney（日本）充值卡',_binary '<p>webmoney（日本）充值卡</p>',NULL,NULL,NULL,NULL),(55,'香港GC充值卡',_binary '<p>香港GC充值卡</p>',NULL,NULL,NULL,NULL),(56,'任天堂（澳洲）充值卡',_binary '<p>任天堂（澳洲）充值卡</p>',NULL,NULL,NULL,NULL),(57,'任天堂（巴西）充值卡',_binary '<p>任天堂（巴西）充值卡</p>',NULL,NULL,NULL,NULL),(58,'苹果礼品卡特惠包',_binary '<p>苹果礼品卡特惠包</p>',NULL,NULL,NULL,NULL),(59,'steam点卡特惠包',_binary '<p>steam点卡特惠包</p>',NULL,NULL,NULL,NULL),(60,'谷歌礼品卡特惠包',_binary '<p>谷歌礼品卡特惠包</p>',NULL,NULL,NULL,NULL),(61,'暴雪战网（阿根廷）点数',_binary '<p>暴雪战网（阿根廷）点数</p>',NULL,NULL,NULL,NULL),(62,'steam（俄罗斯）余额代充',_binary '<p>steam（俄罗斯）余额代充</p>',NULL,NULL,NULL,NULL),(63,'任天堂（英国）充值卡',_binary '<p>任天堂（英国）充值卡</p>',NULL,NULL,NULL,NULL),(64,'雅虎邮箱账号',_binary '<p>雅虎邮箱账号</p>',NULL,NULL,NULL,NULL),(65,'谷歌（全球）邮箱账号',_binary '<p>谷歌（全球）邮箱账号</p>',NULL,NULL,NULL,NULL),(66,'微软（全球）邮箱账号',_binary '<p>微软（全球）邮箱账号</p>',NULL,NULL,NULL,NULL),(67,'俄罗斯邮箱账号',_binary '<p>俄罗斯邮箱账号</p>',NULL,NULL,NULL,NULL),(68,'美国邮箱账号',_binary '<p>美国邮箱账号</p>',NULL,NULL,NULL,NULL),(69,'Midjourney会员账号',_binary '<p>Midjourney会员账号</p>',NULL,NULL,NULL,NULL),(70,'独享账号',_binary '<p>独享账号</p>',NULL,NULL,NULL,NULL),(71,'求生之路2【steam版】',_binary '<p>求生之路2【steam版】</p>',NULL,NULL,NULL,NULL),(72,'壁纸引擎【steam版】',_binary '<p>壁纸引擎【steam版】</p>',NULL,NULL,NULL,NULL),(73,'城市：天际线【steam版】',_binary '<p>城市：天际线【steam版】</p>',NULL,NULL,NULL,NULL),(74,'激活码',_binary '<p>激活码</p>',NULL,NULL,NULL,NULL),(75,'植物大战僵尸：年度版【steam版】',_binary '<p>植物大战僵尸：年度版【steam版】</p>',NULL,NULL,NULL,NULL),(76,'方舟：生存进化【steam版】',_binary '<p>方舟：生存进化【steam版】</p>',NULL,NULL,NULL,NULL),(77,'木筏求生【steam版】',_binary '<p>木筏求生【steam版】</p>',NULL,NULL,NULL,NULL),(78,'模拟人生4【steam版】',_binary '<p>模拟人生4【steam版】</p>',NULL,NULL,NULL,NULL),(79,'饥荒联机版【steam版】',_binary '<p>饥荒联机版【steam版】</p>',NULL,NULL,NULL,NULL),(80,'反恐精英1.6【steam版】',_binary '<p>反恐精英1.6【steam版】</p>',NULL,NULL,NULL,NULL),(81,'太空狼人杀Among Us【steam版】',_binary '<p>太空狼人杀Among Us【steam版】</p>',NULL,NULL,NULL,NULL),(82,'成品账号',_binary '<p>成品账号</p>',NULL,NULL,NULL,NULL),(83,'人类一败涂地【steam版】',_binary '<p>人类一败涂地【steam版】</p>',NULL,NULL,NULL,NULL),(84,'中国香港',_binary '<p>中国香港</p>',NULL,NULL,NULL,NULL),(85,'日本',_binary '<p>日本</p>',NULL,NULL,NULL,NULL),(86,'欧洲',_binary '<p>欧洲</p>',NULL,NULL,NULL,NULL),(87,'巴西',_binary '<p>巴西</p>',NULL,NULL,NULL,NULL),(88,'APP安装包下载',_binary '<p>APP安装包下载</p>',NULL,NULL,NULL,NULL),(89,'不带账号',_binary '<p>不带账号</p>',NULL,NULL,NULL,NULL),(90,'APP',_binary '<p>APP</p>',NULL,NULL,NULL,NULL),(91,'facebook账号',_binary '<p>facebook账号</p>',NULL,NULL,NULL,NULL),(92,'PSN（全球）充值卡',_binary '<p>PSN（全球）充值卡</p>',NULL,NULL,NULL,NULL),(93,'steam安卓APP',_binary '<p>steam安卓APP</p>',NULL,NULL,NULL,NULL),(94,'任天堂游戏CDK',_binary '<p>任天堂游戏CDK</p>',NULL,NULL,NULL,NULL),(95,'幻塔（国际服）直充',_binary '<p>幻塔（国际服）直充</p>',NULL,NULL,NULL,NULL),(96,'GoPay钱包代充',_binary '<p>GoPay钱包代充</p>',NULL,NULL,NULL,NULL),(97,'印尼',_binary '<p>印尼</p>',NULL,NULL,NULL,NULL),(98,'PUBG国际服直充',_binary '<p>PUBG国际服直充</p>',NULL,NULL,NULL,NULL),(99,'PayNow钱包代充',_binary '<p>PayNow钱包代充</p>',NULL,NULL,NULL,NULL),(100,'Grabpay钱包代充',_binary '<p>Grabpay钱包代充</p>',NULL,NULL,NULL,NULL),(101,'新加坡',_binary '<p>新加坡</p>',NULL,NULL,NULL,NULL),(102,'马来西亚',_binary '<p>马来西亚</p>',NULL,NULL,NULL,NULL),(103,'泰国',_binary '<p>泰国</p>',NULL,NULL,NULL,NULL),(104,'Windows正版系统激活码',_binary '<p>Windows正版系统激活码</p>',NULL,NULL,NULL,NULL),(105,'一次性',_binary '<p>一次性</p>',NULL,NULL,NULL,NULL),(106,'LOL国际手游（直充）',_binary '<p>LOL国际手游（直充）</p>',NULL,NULL,NULL,NULL),(107,'卡通农场（国际服）直充',_binary '<p>卡通农场（国际服）直充</p>',NULL,NULL,NULL,NULL),(108,'皇室战争（国际服）直充',_binary '<p>皇室战争（国际服）直充</p>',NULL,NULL,NULL,NULL),(109,'部落冲突（国际服）直充',_binary '<p>部落冲突（国际服）直充</p>',NULL,NULL,NULL,NULL),(110,'荒野乱斗（国际服）直充',_binary '<p>荒野乱斗（国际服）直充</p>',NULL,NULL,NULL,NULL),(111,'胜利女神（国际服）手游直充',_binary '<p>胜利女神（国际服）手游直充</p>',NULL,NULL,NULL,NULL),(112,'暗区突围（国际服）直充',_binary '<p>暗区突围（国际服）直充</p>',NULL,NULL,NULL,NULL),(113,'蛋仔派对（国际服）直充',_binary '<p>蛋仔派对（国际服）直充</p>',NULL,NULL,NULL,NULL),(114,'HBO鼎级剧场 会员账号',_binary '<p>HBO鼎级剧场 会员账号</p>',NULL,NULL,NULL,NULL),(115,'原神手游（国际服）直充',_binary '<p>原神手游（国际服）直充</p>',NULL,NULL,NULL,NULL),(116,'WeTV 会员直充',_binary '<p>WeTV 会员直充</p>',NULL,NULL,NULL,NULL),(117,'hulu会员账号',_binary '<p>hulu会员账号</p>',NULL,NULL,NULL,NULL),(118,'PUBG：未来之役（国际服）直充',_binary '<p>PUBG：未来之役（国际服）直充</p>',NULL,NULL,NULL,NULL),(119,'第五人格（国际服）直充',_binary '<p>第五人格（国际服）直充</p>',NULL,NULL,NULL,NULL),(120,'瓦罗兰特（马来西亚）直充',_binary '<p>瓦罗兰特（马来西亚）直充</p>',NULL,NULL,NULL,NULL),(121,'漫威：瞬战超能（国际服）直充',_binary '<p>漫威：瞬战超能（国际服）直充</p>',NULL,NULL,NULL,NULL),(122,'明日之后（国际服）直充',_binary '<p>明日之后（国际服）直充</p>',NULL,NULL,NULL,NULL),(123,'Mobile Legends 无尽对决充值',_binary '<p>Mobile Legends 无尽对决充值</p>',NULL,NULL,NULL,NULL),(124,'王者荣耀（国际服）直充',_binary '<p>王者荣耀（国际服）直充</p>',NULL,NULL,NULL,NULL),(125,'谷歌全球ID',_binary '<p>谷歌全球ID</p>',NULL,NULL,NULL,NULL),(126,'符文大地传说手游',_binary '<p>符文大地传说手游</p>',NULL,NULL,NULL,NULL),(127,'美国/加拿大',_binary '<p>美国/加拿大</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订单异常',
  `other_data` varchar(255) DEFAULT NULL COMMENT '其他数据',
  `create_by` longblob COMMENT '用户id',
  `create_time` datetime DEFAULT NULL COMMENT '订单创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34 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 (25,'特惠包2【苹果礼品卡500日元+精美账号】【x1】',4,1,48.00,48.00,'',0,'1','',_binary '1','2024-05-31 14:19:49'),(26,'特惠包2【苹果礼品卡500日元+精美账号】【x1】',4,1,48.00,48.00,'',0,'1','',_binary '1','2024-05-31 16:11:25'),(27,'特惠包2【苹果礼品卡500日元+精美账号】【x1】',4,1,48.00,48.00,'',0,'1','',_binary '1','2024-05-31 16:17:51'),(28,'特惠包2【苹果礼品卡500日元+精美账号】【x1】',4,1,48.00,48.00,'',0,'1','',_binary '1','2024-05-31 16:19:01'),(29,'特惠包2【苹果礼品卡500日元+精美账号】【x1】',4,1,48.00,48.00,'',0,'1','',_binary '1','2024-05-31 16:19:47'),(30,'特惠包2【苹果礼品卡500日元+精美账号】【x1】',4,1,48.00,48.00,'',0,'','',_binary '1','2024-05-31 16:20:01'),(31,'特惠包2【苹果礼品卡500日元+精美账号】【x1】',4,1,48.00,48.00,'',0,'1','',_binary '1','2024-05-31 16:20:07'),(32,'特惠包2【苹果礼品卡500日元+精美账号】【x1】',4,1,48.00,48.00,'',0,'','',_binary '1','2024-05-31 16:20:24'),(33,'特惠包2【苹果礼品卡500日元+精美账号】【x1】',4,1,48.00,48.00,'',0,'1','',_binary '1','2024-05-31 16:20:26');
/*!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=144 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,'','2024-05-20 04:03:45'),(2,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包2【苹果礼品卡5美金+精品账号】',52.00,58.80,50,1,1,NULL,'2024-05-20 04:03:45'),(3,'/api/static/202404231412462.jpg','特惠包3【苹果礼品卡3美金+5美金】',75.00,67.00,50,1,1,NULL,'2024-05-20 04:03:45'),(4,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包2【苹果礼品卡500日元+精美账号】',48.00,55.00,50,2,1,NULL,'2024-05-20 04:03:45'),(5,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包1【苹果礼品卡150港元+200港元】',381.00,384.00,50,3,1,NULL,'2024-05-20 04:03:45'),(6,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包1【苹果礼品卡100NT+300NT】',135.00,139.00,50,4,1,NULL,'2024-05-20 04:03:45'),(7,'/api/static/20240423094145微信图片_20240416170543.jpg','PUBG国际服(地铁逃生)直充-300+25UC',37.39,41.00,50,0,2,NULL,'2024-05-20 04:03:45'),(8,'/api/static/17170534845528.jpg','Steam（中国）白号',19.00,19.00,172602,11,11,'1','2024-05-30 09:08:01'),(9,'/api/static/17170534845679.png','苹果iTunes礼品卡-2美金',42.00,42.00,4147,12,12,'1','2024-05-30 09:08:01'),(10,'/api/static/171705348458310.png','苹果iTunes礼品卡-3美金',49.00,49.00,2773,12,12,'1','2024-05-30 09:08:01'),(11,'/api/static/171705348458411.png','奈飞Netflix TV - 30天会员',30.00,30.00,1447,13,13,'1','2024-05-30 09:08:01'),(12,'/api/static/171705348459812.png','谷歌（美国）礼品卡-5美金',68.00,68.00,2150,0,14,'1','2024-05-30 09:08:01'),(13,'/api/static/171705412072113.png','steam（美国）充值卡-20美金',160.00,160.00,919,0,15,'1','2024-05-30 09:08:01'),(14,'/api/static/171705348459914.png','Razer Gold（美国）充值卡-5美元',58.00,58.00,333,12,16,'1','2024-05-30 09:08:01'),(15,'/api/static/171705348461315.png','Razer Gold（美国）充值卡-10美元',87.00,87.00,333,12,16,'1','2024-05-30 09:08:01'),(16,'/api/static/171705412073716.png','Roblox（美国）充值卡-10美元',80.00,80.00,254,12,17,'1','2024-05-30 09:08:01'),(17,'/api/static/171705407178217.png','eBay（美国）充值卡-5美金',40.00,40.00,300,0,18,'1','2024-05-30 09:08:01'),(18,'/api/static/171705348462918.png','苹果（美国）ID',36.00,36.00,48163,14,19,'1','2024-05-30 09:08:01'),(19,'/api/static/171705348464419.png','Xbox（美国）充值卡-5美元',40.00,40.00,510,12,20,'1','2024-05-30 09:08:01'),(20,'/api/static/171705348465920.png','Xbox（美国）充值卡-10美元',72.00,72.00,510,12,20,'1','2024-05-30 09:08:01'),(21,'/api/static/171705348467521.png','Xbox（美国）充值卡-15美元',108.00,108.00,510,12,20,'1','2024-05-30 09:08:01'),(22,'/api/static/171705412075222.png','任天堂（中国香港）充值卡-100港币',110.00,110.00,4762,15,21,'1','2024-05-30 09:08:01'),(23,'/api/static/171705412076723.png','任天堂（中国香港）充值卡-300港币',351.00,351.00,4762,15,21,'1','2024-05-30 09:08:01'),(24,'/api/static/171705407179824.png','STEAM（阿根廷）余额代充-2000比索',120.00,120.00,410,0,22,'1','2024-05-30 09:08:01'),(25,'/api/static/171705348469025.jpg','推特（新号）ID',25.00,25.00,9021,16,23,'1','2024-05-30 09:08:01'),(26,'/api/static/171705348470626.png','Instagram（新手）账号',34.00,34.00,1911,0,24,'1','2024-05-30 09:08:01'),(27,'/api/static/171705348472127.png','TikTok新号',35.00,35.00,2893,16,25,'1','2024-05-30 09:08:01'),(28,'/api/static/171705348473628.jpg','YouTube（新号）账号',38.00,38.00,2264,16,26,'1','2024-05-30 09:08:01'),(29,'/api/static/171705348475129.jpg','Nexon（美服）账号',35.00,35.00,1911,0,27,'1','2024-05-30 09:08:01'),(30,'/api/static/171705348476630.png','Discord账号',38.00,38.00,1646,0,28,'1','2024-05-30 09:08:01'),(31,'/api/static/171705407181331.png','Prime Gaming会员账号',18.00,18.00,1559,0,29,'1','2024-05-30 09:08:01'),(32,'/api/static/171705348478232.png','twitch账号',24.00,24.00,1050,0,30,'1','2024-05-30 09:08:01'),(33,'/api/static/171705348479733.png','ESPN会员账号-1年会员',406.80,406.80,1121,17,31,'1','2024-05-30 09:08:01'),(34,'/api/static/171705348481334.png','迪士尼Plus会员（独享）账号-30天会员',54.00,54.00,1650,18,32,'1','2024-05-30 09:08:01'),(35,'/api/static/171705348482835.png','暴雪战网（台服）账号',22.00,22.00,1545,0,33,'1','2024-05-30 09:08:01'),(36,'/api/static/171705348484336.png','EPIC（中国）白号',19.00,19.00,3281,0,34,'1','2024-05-30 09:08:01'),(37,'/api/static/171705348485837.jpg','Netflix（美国）充值卡-30美元',328.00,328.00,105,0,35,'1','2024-05-30 09:08:01'),(38,'/api/static/171705407182838.png','STEAM（美国）余额代充-50美元',400.00,400.00,1560,0,36,'1','2024-05-30 09:08:01'),(39,'/api/static/171705348486239.png','Steam（土耳其）充值卡-50里拉',22.00,22.00,3660,0,37,'1','2024-05-30 09:08:01'),(40,'/api/static/171705348486440.png','steam（韩国）充值卡-5000韩元',32.00,32.00,1771,0,38,'1','2024-05-30 09:08:01'),(41,'/api/static/171705412078341.png','BitCash（日本）dmm充值卡-500日元',35.00,35.00,1871,0,39,'1','2024-05-30 09:08:01'),(42,'/api/static/171705412079842.png','BitCash（日本）dmm充值卡-2000日元',131.00,131.00,1871,0,39,'1','2024-05-30 09:08:01'),(43,'/api/static/171705348487343.jpg','Nexon（美国）充值卡 - 20美金',155.00,155.00,1556,0,40,'1','2024-05-30 09:08:01'),(44,'/api/static/171705407184444.png','GoCash（全球）充值卡-10美金',77.00,77.00,1209,0,41,'1','2024-05-30 09:08:01'),(45,'/api/static/171705407186045.png','steam（新西兰）余额代充-50新西兰',250.00,250.00,1499,0,42,'1','2024-05-30 09:08:01'),(46,'/api/static/171705407187546.png','普雷卡Pcard-300点',78.00,78.00,761,0,43,'1','2024-05-30 09:08:01'),(47,'/api/static/171705348488947.jpg','Nexon（韩国）充值卡-10000点券',67.00,67.00,1666,0,44,'1','2024-05-30 09:08:01'),(48,'/api/static/171705407189048.png','刀塔自走棋兑换码-40糖果',30.00,30.00,898,0,45,'1','2024-05-30 09:08:01'),(49,'/api/static/171705407190549.png','webmoney（日本）充值卡-10000日元',692.00,692.00,721,0,46,'1','2024-05-30 09:08:01'),(50,'/api/static/171705407192150.png','香港GC充值卡-600点',136.00,136.00,764,0,47,'1','2024-05-30 09:08:01'),(51,'/api/static/171705407192451.png','任天堂（澳洲）充值卡-15澳元',89.00,89.00,1499,0,48,'1','2024-05-30 09:08:01'),(52,'/api/static/171705407193652.png','任天堂（巴西）-50雷亚尔',77.00,77.00,1444,0,49,'1','2024-05-30 09:08:01'),(53,'/api/static/171705348490453.png','特惠包1【苹果礼品卡3美金+精品账号】',36.00,36.00,473,12,50,'1','2024-05-30 09:08:01'),(54,'/api/static/171705407195154.png','特惠包1【充值卡-5美金+游戏慈善包CDK】',56.00,56.00,823,0,51,'1','2024-05-30 09:08:01'),(55,'/api/static/171705407196755.jpg','美金特惠包【谷歌礼品卡5美金+10美金】',120.00,120.00,1,0,52,'1','2024-05-30 09:08:01'),(56,'/api/static/171705407198256.png','暴雪战网（阿根廷）点数-1000ARS',44.00,44.00,1125,0,53,'1','2024-05-30 09:08:01'),(57,'/api/static/171705407198557.png','steam（俄罗斯）余额代充-300卢布',38.50,38.50,1029,0,54,'1','2024-05-30 09:08:01'),(58,'/api/static/171705407199758.png','任天堂（英国）充值卡-15英镑',122.00,122.00,1136,0,55,'1','2024-05-30 09:08:01'),(59,'/api/static/171705407201359.png','雅虎（网页版带密保）邮箱账号',15.00,15.00,476,0,56,'1','2024-05-30 09:08:01'),(60,'/api/static/171705412081360.jpg','谷歌（日本）邮箱账号',42.00,42.00,3847,0,57,'1','2024-05-30 09:08:01'),(61,'/api/static/171705412082961.jpg','谷歌（英国）邮箱账号',42.00,42.00,3847,0,57,'1','2024-05-30 09:08:01'),(62,'/api/static/171705412084462.jpg','谷歌（法国）邮箱账号',42.00,42.00,3847,0,57,'1','2024-05-30 09:08:01'),(63,'/api/static/171705348491963.png','微软（美国）邮箱账号',18.00,18.00,782,0,58,'1','2024-05-30 09:08:01'),(64,'/api/static/171705348493564.png','微软（日本）邮箱账号',18.00,18.00,782,0,58,'1','2024-05-30 09:08:01'),(65,'/api/static/171705348495065.png','微软（韩国）邮箱账号',18.00,18.00,782,0,58,'1','2024-05-30 09:08:01'),(66,'/api/static/171705348496566.png','俄罗斯mail.ru邮箱账号',15.00,15.00,1,0,59,'1','2024-05-30 09:08:01'),(67,'/api/static/171705348498067.png','俄罗斯inbox.ru邮箱账号',15.00,15.00,1,0,59,'1','2024-05-30 09:08:01'),(68,'/api/static/171705348499568.png','俄罗斯bk.ru邮箱账号',15.00,15.00,1,0,59,'1','2024-05-30 09:08:01'),(69,'/api/static/171705348501169.png','美国mail.com（仅网页）邮箱账号',15.00,15.00,601,0,60,'1','2024-05-30 09:08:01'),(70,'/api/static/171705348502670.png','美国gmx.com（开通POP）邮箱账号',15.00,15.00,601,0,60,'1','2024-05-30 09:08:01'),(71,'/api/static/171705348504171.jpg','Midjourney独享账号（高级会员）1个月',380.00,380.00,182,19,61,'1','2024-05-30 09:08:01'),(72,'/api/static/171705348505672.png','求生之路2【成品账号】',40.00,40.00,102,0,62,'1','2024-05-30 09:08:01'),(73,'/api/static/171705407202873.png','壁纸引擎【成品账号】',30.00,30.00,1,0,63,'1','2024-05-30 09:08:01'),(74,'/api/static/171705407204374.png','城市：天际线【标准版】激活码',88.00,88.00,82,20,64,'1','2024-05-30 09:08:01'),(75,'/api/static/171705348507175.png','植物大战僵尸：年度版【成品账号】',28.00,28.00,148,0,65,'1','2024-05-30 09:08:01'),(76,'/api/static/171705348508776.png','方舟：生存进化【成品账号】',69.00,69.00,148,0,66,'1','2024-05-30 09:08:01'),(77,'/api/static/171705348510277.png','木筏求生【全球】激活码',60.00,60.00,101,0,67,'1','2024-05-30 09:08:01'),(78,'/api/static/171705348511778.jpg','模拟人生4【成品账号】',49.00,49.00,1,0,68,'1','2024-05-30 09:08:01'),(79,'/api/static/171705348513279.jpg','饥荒联机版【成品账号】',35.00,35.00,456,0,69,'1','2024-05-30 09:08:01'),(80,'/api/static/171705348514880.png','反恐精英1.6【成品账号】',45.00,45.00,359,0,70,'1','2024-05-30 09:08:01'),(81,'/api/static/171705348516381.png','太空狼人杀Among Us【成品账号】',35.00,35.00,77,21,71,'1','2024-05-30 09:08:01'),(82,'/api/static/171705407205982.png','人类一败涂地【成品账号】',53.00,53.00,1648,0,72,'1','2024-05-30 09:08:01'),(83,'/api/static/171705348517883.png','苹果（中国香港）iTunes礼品卡-50港元',79.00,79.00,5150,22,72,'1','2024-05-30 09:08:01'),(84,'/api/static/171705348519484.png','任天堂（美国）充值卡-10美元',80.00,80.00,4762,12,72,'1','2024-05-30 09:08:01'),(85,'/api/static/171705348521085.png','任天堂（日本）充值卡-1000日元',69.00,69.00,4762,23,72,'1','2024-05-30 09:08:01'),(86,'/api/static/171705348522586.png','Xbox (中国香港) 充值卡-150港币',192.00,192.00,510,22,72,'1','2024-05-30 09:08:01'),(87,'/api/static/171705348522787.png','Xbox (中国香港) 充值卡-300港币',382.00,382.00,510,22,72,'1','2024-05-30 09:08:01'),(88,'/api/static/171705348524088.png','Xbox (欧洲）充值卡-5欧元',34.50,34.50,510,24,72,'1','2024-05-30 09:08:01'),(89,'/api/static/171705348525689.png','Xbox（日本）充值卡-1000日元',63.00,63.00,510,23,72,'1','2024-05-30 09:08:01'),(90,'/api/static/171705348527190.png','Xbox（巴西）充值卡-50雷亚尔',118.00,118.00,510,25,72,'1','2024-05-30 09:08:01'),(91,'/api/static/171705348528691.png','【推特】安卓APP',25.00,25.00,8308,26,73,'1','2024-05-30 09:08:01'),(92,'/api/static/171705348530292.jpg','【推特】安卓APP',35.00,35.00,9021,27,73,'1','2024-05-30 09:08:01'),(93,'/api/static/171705348531793.png','【INS】安卓APP',28.00,28.00,1911,0,73,'1','2024-05-30 09:08:01'),(94,'/api/static/171705348533394.jpg','【油管】安卓APP',25.00,25.00,2264,27,73,'1','2024-05-30 09:08:01'),(95,'/api/static/171705348534895.png','【TikTok】安卓APP',28.00,28.00,2893,27,73,'1','2024-05-30 09:08:01'),(96,'/api/static/171705348536396.jpg','【facebook】安卓APP',35.00,35.00,1,27,74,'1','2024-05-30 09:08:01'),(97,'/api/static/171705348537997.jpg','PSN充值卡-10美金',69.00,69.00,1,12,75,'1','2024-05-30 09:08:01'),(98,'/api/static/171705348539498.jpg','PSN充值卡-20美金',140.00,140.00,1,12,75,'1','2024-05-30 09:08:01'),(99,'/api/static/171705348540999.jpg','PSN（中国香港）充值卡-80港币',80.00,80.00,1,15,75,'1','2024-05-30 09:08:01'),(100,'/api/static/1717053485425100.jpg','PSN（中国香港）充值卡-150港币',165.00,165.00,1,15,75,'1','2024-05-30 09:08:01'),(101,'/api/static/1717053485440101.jpg','PSN（日本）充值卡-1000日元',81.00,81.00,1,23,75,'1','2024-05-30 09:08:01'),(102,'/api/static/1717053485455102.jpg','PSN（日本）充值卡-3000日元',227.00,227.00,1,23,75,'1','2024-05-30 09:08:01'),(103,'/api/static/1717053485471103.png','【Steam】安卓APP',25.00,25.00,686892,28,75,'1','2024-05-30 09:08:01'),(104,'/api/static/1717053485486104.png','【任天堂游戏】破败王者：英雄联盟传奇',259.00,259.00,140,12,76,'1','2024-05-30 09:08:01'),(105,'/api/static/1717053485488105.png','【任天堂游戏】怪物猎人：崛起',569.00,569.00,140,24,76,'1','2024-05-30 09:08:01'),(106,'/api/static/1717053485502106.png','【任天堂游戏】NBA2K23',159.00,159.00,140,24,76,'1','2024-05-30 09:08:01'),(107,'/api/static/1717053485517107.png','【任天堂游戏】小小梦魇捆绑包',199.00,199.00,140,24,76,'1','2024-05-30 09:08:01'),(108,'/api/static/1717053485532108.png','【任天堂游戏】塞尔达传说：旷野之息',430.00,430.00,140,12,76,'1','2024-05-30 09:08:01'),(109,'/api/static/1717053485548109.png','【任天堂游戏】我的世界【美国】',199.00,199.00,140,12,76,'1','2024-05-30 09:08:01'),(110,'/api/static/1717053485563110.jpg','幻塔（国际服）直充-月票',0.00,0.00,309,0,77,'1','2024-05-30 09:08:01'),(111,'/api/static/1717053485578111.png','GoPay钱包代充（印尼）10万盾',60.00,60.00,12,29,78,'1','2024-05-30 09:08:01'),(112,'/api/static/1717053485594112.png','GoPay钱包代充（印尼）50万盾',285.00,285.00,12,29,78,'1','2024-05-30 09:08:01'),(113,'/api/static/1717053485609113.png','PUBG国际服(地铁逃生)直充-300+25UC',31.42,31.42,1482,0,79,'1','2024-05-30 09:08:01'),(114,'/api/static/1717053485624114.jpg','PayNow钱包代充（新加坡）50新币',313.00,313.00,1,0,80,'1','2024-05-30 09:08:01'),(115,'/api/static/1717053485640115.jpg','Grabpay钱包代充（新加坡）50新币',313.00,313.00,1,30,81,'1','2024-05-30 09:08:01'),(116,'/api/static/1717053485655116.jpg','Grabpay钱包代充（马来西亚）50林吉特',90.00,90.00,1,31,81,'1','2024-05-30 09:08:01'),(117,'/api/static/1717053485670117.jpg','Grabpay钱包代充（泰国）500泰铢',120.00,120.00,1,32,81,'1','2024-05-30 09:08:01'),(118,'/api/static/1717053485685118.jpg','Windows激活密钥【win7普通版 】一次性密钥',69.00,69.00,130,33,82,'1','2024-05-30 09:08:01'),(119,'/api/static/1717053485700119.jpg','Windows激活密钥【win10教育版】一次性密钥',79.00,79.00,130,33,82,'1','2024-05-30 09:08:01'),(120,'/api/static/1717053485715120.jpg','Windows激活密钥【win10专业版】一次性密钥',89.00,89.00,130,33,82,'1','2024-05-30 09:08:01'),(121,'/api/static/1717053485731121.jpg','Windows激活密钥【win11企业版】一次性密钥',93.00,93.00,130,33,82,'1','2024-05-30 09:08:01'),(122,'/api/static/1717053485746122.jpg','Windows激活密钥【win11专业版】一次性密钥',99.00,99.00,130,33,82,'1','2024-05-30 09:08:01'),(123,'/api/static/1717053485761123.png','LOL国际手游 235 Wild Cores',0.00,0.00,302,0,83,'1','2024-05-30 09:08:01'),(124,'/api/static/1717053485777124.png','卡通农场（国际服）直充 130钻石',0.00,0.00,250,0,84,'1','2024-05-30 09:08:01'),(125,'/api/static/1717053485792125.jpg','皇室战争（国际服）直充-500宝石',0.00,0.00,275,0,85,'1','2024-05-30 09:08:01'),(126,'/api/static/1717053485807126.jpg','部落冲突（国际服）直充 500宝石',0.00,0.00,221,0,86,'1','2024-05-30 09:08:01'),(127,'/api/static/1717053485822127.jpg','荒野乱斗（国际服）直充-Brawl Pass Bundle',0.00,0.00,264,0,87,'1','2024-05-30 09:08:01'),(128,'/api/static/1717053485838128.png','胜利女神国际服直充-320珠宝',36.00,36.00,211,0,88,'1','2024-05-30 09:08:01'),(129,'/api/static/1717053485853129.png','暗区突围（国际服）直充-310+25 Bonds',0.00,0.00,222,0,89,'1','2024-05-30 09:08:01'),(130,'/api/static/1717054072074130.png','蛋仔派对（国际服）直充 300 蛋币',0.00,0.00,308,0,90,'1','2024-05-30 09:08:01'),(131,'/api/static/1717053485868131.png','HBO会员账号-30天会员',39.00,39.00,1524,0,91,'1','2024-05-30 09:08:01'),(132,'/api/static/1717053485884132.png','原神国际服直充 300+30 Genesis Crystals',35.00,35.00,246,0,92,'1','2024-05-30 09:08:01'),(133,'/api/static/1717053485899133.jpg','腾讯视频海外版 299 Coins',0.00,0.00,235,0,93,'1','2024-05-30 09:08:01'),(134,'/api/static/1717053485914134.jpg','hulu会员号【有广告】1个月',99.00,99.00,0,17,94,'1','2024-05-30 09:08:01'),(135,'/api/static/1717053485929135.png','PUBG未来之役（国际服）直充 - 1580 NC',0.00,0.00,129,0,95,'1','2024-05-30 09:08:01'),(136,'/api/static/1717053485945136.jpg','第五人格（国际服）直充 305 Echoes',0.00,0.00,129,0,96,'1','2024-05-30 09:08:01'),(137,'/api/static/1717053485960137.jpg','Valorant（马来西亚）PC直充 625 Points',0.00,0.00,294,0,97,'1','2024-05-30 09:08:01'),(138,'/api/static/1717053485976138.jpg','漫威：瞬战超能（国际服）直充 1450 Gold (250 Bonus)',0.00,0.00,25,0,98,'1','2024-05-30 09:08:01'),(139,'/api/static/1717053485991139.jpg','明日之后（国际服）直充 330 Credits',26.51,26.51,14,0,99,'1','2024-05-30 09:08:01'),(140,'/api/static/1717053486006140.png','无尽对决 253 + 25 Diamonds',0.00,0.00,279,0,100,'1','2024-05-30 09:08:01'),(141,'/api/static/1717053486022141.png','王者荣耀（国际服）直充 400+24 点券',0.00,0.00,305,0,101,'1','2024-05-30 09:08:01'),(142,'/api/static/1717053486037142.jpg','谷歌（全区服）ID-3星质量',36.00,36.00,6885,0,102,'1','2024-05-30 09:08:01'),(143,'/api/static/1717054148300143.jpg','usa/cad-475金币',50.00,50.00,1629,34,103,'1','2024-05-30 09:08:01');
/*!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=9 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,'/api/static/202404231441402 - 副本.jpg','礼品卡',NULL),(2,NULL,'/api/static/202404231441402 - 副本.jpg','海外直冲',NULL),(3,NULL,NULL,'游戏账号',NULL),(4,NULL,NULL,'充值卡',NULL),(5,NULL,NULL,'app账号',NULL),(6,NULL,NULL,'游戏代充',NULL),(7,NULL,NULL,'游戏',NULL),(8,NULL,NULL,'其他',NULL);
/*!40000 ALTER TABLE `goods_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `manage_user`
--

DROP TABLE IF EXISTS `manage_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `manage_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `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 '邮箱',
  `avatar` 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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `manage_user`
--

LOCK TABLES `manage_user` WRITE;
/*!40000 ALTER TABLE `manage_user` DISABLE KEYS */;
INSERT INTO `manage_user` VALUES (1,'大名鼎鼎','admin','4fef88243e8e49e90007fdfe2df0e53f',NULL,0,'1',1,'13123456789','516702882@qq.com',NULL);
/*!40000 ALTER TABLE `manage_user` 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 COMMENT '目标id',
  `name` varchar(255) DEFAULT NULL COMMENT '广告名称',
  `image_url` varchar(255) DEFAULT NULL COMMENT '图片',
  `to_id` int(11) DEFAULT NULL COMMENT '目标id',
  `to_type` varchar(255) DEFAULT NULL COMMENT '目标类型',
  `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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商城广告';
/*!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 */;
INSERT INTO `shop_advice_carousel` VALUES (1,'辐射广告','/api/static/20240522145006fallout-pc.png',1,'sku_type','sku','0','1','carousel',NULL,NULL,'1','2024-05-22 16:14:05'),(3,'大学生特惠','/api/static/20240522145457WechatIMG2868.jpg',1,'topic_type','topic','0','1','carousel',NULL,NULL,'1','2024-05-22 16:19:09'),(4,'gpt车队','/api/static/20240522145547车队pc.jpg',2,'sku_type','topic','','1','carousel',NULL,NULL,'1','2024-05-22 16:16:44'),(5,'游戏点券美元充值3','/api/static/20240522162720giftpack.jpg',3,'sku_type','','','1','package',NULL,NULL,'1','2024-05-22 16:27:20'),(6,'游戏点券美元充值3','/api/static/20240522145457WechatIMG2868.jpg',3,'sku_type','','','1','package',NULL,NULL,'1','2024-05-22 16:27:20'),(7,'游戏点券美元充值3','/api/static/20240522145457WechatIMG2868.jpg',3,'sku_type','','','1','package',NULL,NULL,'1','2024-05-22 16:27:20'),(8,'游戏点券美元充值3','/api/static/20240522145457WechatIMG2868.jpg',3,'sku_type','','','1','package',NULL,NULL,'1','2024-05-22 16:27:20'),(9,'游戏点券美元充值3','/api/static/20240522145457WechatIMG2868.jpg',3,'sku_type','','','1','package',NULL,NULL,'1','2024-05-22 16:27:20');
/*!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=9 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,'1',NULL,'/api/static/202405231043235c8a0eec19d9a.jpg','软件直充','软件在线充值，快速秒到账','1'),(2,'2',NULL,'/api/static/202405231043235c8a0eec19d9a.jpg','游戏充值','游戏在线充值，热门游戏尽在其中','2'),(3,'3',NULL,'/api/static/202405231043235c8a0eec19d9a.jpg','游戏账号','游戏账号','3'),(4,'4',NULL,'/api/static/202405231043235c8a0eec19d9a.jpg','充值卡','充值卡','4'),(5,'5',NULL,'/api/static/202405231043235c8a0eec19d9a.jpg','app账号','app账号','5'),(6,'6',NULL,'/api/static/202405231043235c8a0eec19d9a.jpg','游戏代充','游戏代充','6'),(7,'7',NULL,'/api/static/202405231043235c8a0eec19d9a.jpg','游戏','游戏','7'),(8,'8',NULL,'/api/static/202405231043235c8a0eec19d9a.jpg','其他','其他','8');
/*!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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商城主题商品';
/*!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 '头像',
  `inviter_by` int(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=5 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','老黑猫1','/api/static/20240423094145微信图片_20240416170543.jpg',NULL,'1234567890'),(4,'2629606487@qq.com','4fef88243e8e49e90007fdfe2df0e53f',1717471531,0,'0',2,'13123456789','2629606487@qq.com','2629606487@qq.com','',0,'665e892bKZq1uvzxiGWbO');
/*!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 NULL COMMENT '余额',
  `promotion_amount` decimal(20,2) DEFAULT NULL COMMENT '推广获取总金额',
  `recharge_amount` decimal(20,2) DEFAULT NULL COMMENT '充值金额',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `user` (`user_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 `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),(4,4,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-06-17 17:12:39