-- MySQL dump 10.13 Distrib 5.7.43, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: virtual_mall
-- ------------------------------------------------------
-- Server version 5.7.43-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `article`
--
DROP TABLE IF EXISTS `article`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`article_title` varchar(255) DEFAULT NULL COMMENT '文章名称',
`article_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 '别看了，这个文章没什么好看的
','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 '别看了，这个文章没什么好看的
','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 '别看了，这个文章没什么好看的
','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 '别看了，这个文章没什么好看的
','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 '别看了，这个文章没什么好看的
','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 '别看了，这个文章没什么好看的
','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 '别看了，这个文章没什么好看的
','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=258 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'),(234,'','/test/home','GET','1','','2024-07-04 17:12:09'),(235,'','/test/topic','GET','1','','2024-07-04 17:12:09'),(236,'','/test/detail','GET','1','','2024-07-04 17:12:09'),(237,'','/test/search','GET','1','','2024-07-04 17:12:09'),(238,'','/test/info/:infoName','GET','1','','2024-07-04 17:12:09'),(239,'','/assets/*filepath','GET','1','','2024-07-04 17:12:09'),(240,'','/assets/*filepath','HEAD','1','','2024-07-04 17:12:09'),(241,'','/back/goodsSku/list','PUT','1','','2024-07-04 17:12:09'),(242,'','/user/loginCode','POST','1','','2024-07-04 17:12:10'),(243,'','/back/goodsSku/commodityArea/:id','DELETE','1','','2024-07-15 16:46:03'),(244,'','/back/goods/sort','POST','1','','2024-07-19 14:59:32'),(245,'','/file','DELETE','1','','2024-07-25 23:53:48'),(246,'','/file/upload/type','POST','1','','2024-08-14 23:32:07'),(247,'','/order/pay','POST','1','','2024-09-11 21:18:27'),(248,'','/test','POST','1','','2024-09-11 21:18:27'),(249,'','/home','GET','1','','2024-09-11 21:18:27'),(250,'','/topic','GET','1','','2024-09-11 21:18:27'),(251,'','/detail','GET','1','','2024-09-11 21:18:27'),(252,'','/search','GET','1','','2024-09-11 21:18:27'),(253,'','/info/:infoName','GET','1','','2024-09-11 21:18:27'),(254,'','/','GET','1','','2024-09-11 21:19:18'),(255,'','/category','GET','1','','2024-10-11 19:23:57'),(256,'','/category/:category','GET','1','','2024-10-11 19:23:57'),(257,'','/category/goods','POST','1','','2024-10-11 22:30:06');
/*!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=36 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,2,'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,22,'Setting','商品属性','/back/goodsCommodityArea','1'),(18,'优惠券',35,17,'Setting','优惠券','/back/goodsCoupon','1'),(19,'优惠券领取',35,18,'Setting','优惠券领取','/back/goodsCouponUser','1'),(20,'商品介绍',3,19,'Setting','商品介绍','/back/goodsIntroduction','1'),(21,'商品订单',3,20,'Setting','商品订单','/back/goodsOrder','1'),(22,'商品规格',3,21,'Setting','商品规格','/back/goodsSku','1'),(23,'商品卡号',35,23,'Setting','商品卡号','/back/goodsSkuCard','1'),(24,'商品标签',3,24,'Setting','商品标签','/back/goodsTag','1'),(25,'商品主题',3,25,'Setting','商品主题','/back/shopTopic','0'),(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,'商城广告',34,28,'Setting','商城广告','/back/shopAdviceCarousel','1'),(32,'商城主题',34,29,'Setting','商品主题','/back/shopTopic','1'),(33,'商城主题商品',34,30,'Setting','商城主题商品','/back/shopTopicSku','1'),(34,'商城首页',0,34,'Shop','商城首页','/','1'),(35,'商城管理',0,3,'Shop','商城管理','/','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','用户钱包'),(25,'dict_data','字典数据','DictData','dictData','字典数据'),(26,'dict_type','字典类型','DictType','dictType','字典类型'),(32,'shop_topic','商品主题','ShopTopic','shopTopic','商品主题'),(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=492 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','like','input',''),(3,9,2,'table_comment','数据库注释','VARCHAR','string','TableComment','0','0','0','like','input',''),(4,9,3,'name','名字','VARCHAR','string','Name','0','0','0','like','input',''),(5,9,4,'router_name','路由名','VARCHAR','string','RouterName','0','0','0','like','input',''),(6,9,5,'remark','备注','VARCHAR','string','Remark','0','0','0','like','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',''),(11,10,4,'column_comment','字段注释','VARCHAR','string','ColumnComment','0','0','0','like','input',''),(12,10,5,'column_type','字段类型','VARCHAR','string','ColumnType','0','0','0','like','input',''),(13,10,6,'go_type','go类型','VARCHAR','string','GoType','0','0','0','like','select','go_type'),(14,10,7,'go_field','go字段名','VARCHAR','string','GoField','0','0','0','like','input',''),(15,10,8,'is_key','是否主键','CHAR','string','IsKey','0','0','0','EQ','Radio',''),(16,10,9,'is_increment','是否自增','CHAR','string','IsIncrement','0','0','0','EQ','Radio',''),(17,10,10,'is_required','是否未必填','CHAR','string','IsRequired','0','0','0','EQ','Radio',''),(18,10,11,'query_type','查询方式','CHAR','string','QueryType','0','0','0','EQ','select','query_type'),(19,10,12,'vue_show_type','前端显示类型','VARCHAR','string','VueShowType','0','0','0','EQ','select','vue_show_type'),(20,10,13,'dict_type','字典类型','VARCHAR','string','DictType','0','0','0','like','select',''),(21,1,0,'id','id','INT','int64','Id','1','1','1','EQ','text',''),(22,1,1,'article_title','文章名称','VARCHAR','string','ArticleTitle','0','0','0','like','input',''),(23,1,2,'article_content','文章内容','LONGBLOB','string','ArticleContent','0','0','0','like','editor',''),(24,1,3,'state','状态','VARCHAR','string','State','0','0','0','EQ','select','sys_state'),(25,1,4,'article_tag_ids','文章标签','VARCHAR','string','ArticleTagIds','0','0','0','','',''),(26,1,5,'article_topic_id','文章主题id','INT','int64','ArticleTopicId','0','0','0','','',''),(27,1,6,'image','图片','VARCHAR','string','Image','0','0','0','','image',''),(28,1,7,'publish_time','发表时间','DATETIME','time.Time','PublishTime','0','0','0','BETWEEN','time',''),(29,1,8,'eye_fill','浏览量','INT','int64','EyeFill','0','0','0','BETWEEN','number',''),(30,1,9,'like_count','点赞量','INT','int64','LikeCount','0','0','0','BETWEEN','number',''),(31,1,10,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(32,1,11,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','time',''),(33,1,12,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(34,1,13,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','time',''),(35,2,0,'id','','INT','int64','Id','1','0','0','','text',''),(36,2,1,'tag_name','标签名','VARCHAR','string','TagName','0','0','0','EQ','input',''),(37,2,2,'tag_desc','标签描述','VARCHAR','string','TagDesc','0','0','0','like','input',''),(38,3,0,'id','','INT','int64','Id','1','0','0','','',''),(39,3,1,'image','图片','VARCHAR','string','Image','0','0','0','','image',''),(40,3,2,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','like','input',''),(41,3,3,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','like','textarea',''),(45,4,0,'id','id','INT','int64','Id','1','0','0','EQ','',''),(46,4,1,'authority_name','接口名','VARCHAR','string','AuthorityName','0','0','0','like','input',''),(47,4,2,'authority_path','接口路径','VARCHAR','string','AuthorityPath','0','0','0','like','input',''),(48,4,3,'method','方法','VARCHAR','string','Method','0','0','0','EQ','input',''),(49,4,4,'state','接口是否启用(0关闭，1启用)','VARCHAR','string','State','0','0','0','EQ','select','sys_state'),(50,4,5,'authority_verification','权限校验','VARCHAR','string','AuthorityVerification','0','0','0','like','input',''),(51,4,6,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','BETWEEN','time',''),(52,5,0,'id','id','INT','int64','Id','1','0','0','','',''),(53,5,1,'back_menu_name','菜单名称','VARCHAR','string','BackMenuName','0','0','0','like','input',''),(54,5,2,'back_menu_pater','父级菜单','INT','int64','BackMenuPater','0','0','0','','number',''),(55,5,3,'sort','排序','INT','int64','Sort','0','0','0','','number',''),(56,5,4,'icon','图标','VARCHAR','string','Icon','0','0','0','','image',''),(57,5,5,'remark','备注','VARCHAR','string','Remark','0','0','0','like','textarea',''),(58,5,6,'back_router_path','路由路径','VARCHAR','string','BackRouterPath','0','0','0','like','input',''),(59,5,7,'state','状态','VARCHAR','string','State','0','0','0','EQ','select','sys_state'),(60,6,0,'id','','INT','int64','Id','1','0','0','','',''),(61,6,1,'role_name','','VARCHAR','string','RoleName','0','0','0','like','input',''),(62,7,0,'id','','INT','int64','Id','1','0','0','','',''),(63,7,1,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(64,7,2,'authority_id','权限id','INT','int64','AuthorityId','0','0','0','','',''),(65,8,0,'id','','INT','int64','Id','1','0','0','','',''),(66,8,1,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(67,8,2,'menu_id','枚舉id','INT','int64','MenuId','0','0','0','','',''),(68,25,0,'id','字典编码','INT','int64','Id','1','0','0','','',''),(69,25,1,'sort','排序','INT','int64','Sort','0','0','0','','',''),(70,25,2,'dict_label','字典标签','VARCHAR','string','DictLabel','0','0','0','like','input',''),(71,25,3,'dict_value','字典键值','VARCHAR','string','DictValue','0','0','0','like','input',''),(72,25,4,'dict_type','字典类型','VARCHAR','string','DictType','0','0','0','like','input',''),(73,25,5,'status','状态','VARCHAR','string','Status','0','0','0','EQ','select','sys_state'),(74,25,6,'css_style','样式','VARCHAR','string','CssStyle','0','0','0','EQ','input',''),(75,25,7,'is_default','是否默认','VARCHAR','string','IsDefault','0','0','0','EQ','radio','sys_yes_no'),(76,25,8,'remark','备注','VARCHAR','string','Remark','0','0','0','like','textarea',''),(77,26,0,'id','','INT','int64','Id','1','0','0','','',''),(78,26,1,'dict_name','字典名称','VARCHAR','string','DictName','0','0','0','like','input',''),(79,26,2,'dict_type','字典类型','VARCHAR','string','DictType','0','0','0','like','input',''),(80,26,3,'status','状态（1正常/0停用）','VARCHAR','string','Status','0','0','0','EQ','select','sys _state'),(81,26,4,'remark','备注','VARCHAR','string','Remark','0','0','0','like','textarea',''),(82,11,0,'id','id','INT','int64','Id','1','0','0','','',''),(83,11,1,'type_id','分类id','INT','int64','TypeId','0','0','0','','select',''),(84,11,2,'goods_name','商品名字','VARCHAR','string','GoodsName','0','0','0','like','input',''),(85,11,3,'introduction_id','商品介绍id','INT','int64','IntroductionId','0','0','0','','',''),(86,11,4,'sales_volume','近30天销量','INT','int64','SalesVolume','0','0','0','BETWEEN','number',''),(87,11,5,'tag_ids','商品标签','VARCHAR','string','TagIds','0','0','0','','',''),(88,12,0,'id','id','INT','int64','Id','1','0','0','','',''),(89,12,1,'goods_id','商品id','INT','int64','GoodsId','0','0','0','','',''),(90,12,2,'commodity_area_name','商品属地名称','VARCHAR','string','CommodityAreaName','0','0','0','like','input',''),(91,12,3,'detail_image','详情图片','VARCHAR','string','DetailImage','0','0','0','','image',''),(92,12,4,'detail_introduction_id','相关文本详情id','INT','int64','DetailIntroductionId','0','0','0','','select',''),(93,13,0,'id','id','INT','int64','Id','1','0','0','','',''),(94,13,1,'coupon_name','优惠券名称','VARCHAR','string','CouponName','0','0','0','like','input',''),(95,13,2,'coupon_desc','优惠券描述','VARCHAR','string','CouponDesc','0','0','0','like','textarea',''),(96,13,3,'cash_back_point','满x','DECIMAL','float64','CashBackPoint','0','0','0','','number',''),(97,13,4,'cash_back_price','减x','DECIMAL','float64','CashBackPrice','0','0','0','','number',''),(98,13,5,'condition_by_topic','主题可用，id','VARCHAR','string','ConditionByTopic','0','0','0','','select',''),(99,13,6,'condition_by_type','类型可用，id','VARCHAR','string','ConditionByType','0','0','0','','select',''),(100,13,7,'condition_by_goods','商品可用，id','VARCHAR','string','ConditionByGoods','0','0','0','','select',''),(101,13,8,'grant_count','发放数量','VARCHAR','string','GrantCount','0','0','0','EQ','number',''),(102,13,9,'count','优惠券余量','INT','int64','Count','0','0','0','','',''),(103,13,10,'receive_type','领取条件','VARCHAR','string','ReceiveType','0','0','0','','input',''),(104,13,11,'validity','有效性，领取开始计时(ClaimTiming)，固定时间(FixedTime)','VARCHAR','string','Validity','0','0','0','EQ','select','coupon_validity'),(105,13,12,'validity_period','有效期','DATETIME','time.Time','ValidityPeriod','0','0','0','BETWEEN','time',''),(106,14,0,'id','id','INT','int64','Id','1','0','0','','',''),(107,14,1,'user_id','用户id','INT','int64','UserId','0','0','0','','',''),(108,14,2,'coupon_id','优惠券id','INT','int64','CouponId','0','0','0','','',''),(109,14,3,'collection_time','领取时间','DATETIME','time.Time','CollectionTime','0','0','0','','',''),(110,14,4,'state','状态，已使用2，未使用1，已过期0','VARCHAR','string','State','0','0','0','EQ','select','sys_state'),(111,15,0,'id','文章id','INT','int64','Id','1','0','0','','',''),(112,15,1,'goods_article_name','商品文章名','VARCHAR','string','GoodsArticleName','0','0','0','like','input',''),(113,15,2,'goods_article','商品文章','LONGBLOB','string','GoodsArticle','0','0','0','','editor',''),(114,15,3,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','text',''),(115,15,4,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','time',''),(116,15,5,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','text',''),(117,15,6,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','time',''),(118,16,0,'id','id','INT','int64','Id','1','0','0','','',''),(119,16,1,'order_name','订单名','VARCHAR','string','OrderName','0','0','0','like','input',''),(120,16,2,'sku_id','skuid','INT','int64','SkuId','0','0','0','','',''),(121,16,3,'count','购买数量','INT','int64','Count','0','0','0','BETWEEN','number',''),(122,16,4,'price','单价','DECIMAL','float64','Price','0','0','0','BETWEEN','number',''),(123,16,5,'total_price','总价','DECIMAL','float64','TotalPrice','0','0','0','BETWEEN','number',''),(124,16,6,'contact_information','联系方式','VARCHAR','string','ContactInformation','0','0','0','like','input',''),(125,16,7,'coupon_user_id','使用的优惠券','INT','int64','CouponUserId','0','0','0','','',''),(126,16,8,'state','支付状态，0待支付，1待发货，2已发货，3订单完成，4订单异常','VARCHAR','string','State','0','0','0','','',''),(127,16,9,'create_by','用户id','INT','int64','CreateBy','0','0','0','','',''),(128,16,10,'create_time','订单创建时间','DATETIME','time.Time','CreateTime','0','0','0','','',''),(129,17,0,'id','','INT','int64','Id','1','0','0','','',''),(130,17,1,'sku_image','sku图片','VARCHAR','string','SkuImage','0','0','0','','image',''),(131,17,2,'sku_name','商品sku名字','VARCHAR','string','SkuName','0','0','0','like','input',''),(132,17,3,'price','现在价格','DECIMAL','float64','Price','0','0','0','','number',''),(133,17,4,'historical_prices','历史价格','DECIMAL','float64','HistoricalPrices','0','0','0','','number',''),(134,17,5,'inventory_number','库存','INT','int64','InventoryNumber','0','0','0','','number',''),(135,17,6,'commodity_area_id','属地id','INT','int64','CommodityAreaId','0','0','0','','select',''),(136,17,7,'goods_id','商品id','INT','int64','GoodsId','0','0','0','','select',''),(137,17,8,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(138,17,9,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','BETWEEN','time',''),(139,18,0,'id','id','INT','int64','Id','1','0','0','','',''),(140,18,1,'card_name','卡种名称','VARCHAR','string','CardName','0','0','0','like','input',''),(141,18,2,'state','状态，0未使用，1已用，2过期','VARCHAR','string','State','0','0','0','EQ','select','sys_state'),(142,18,3,'count','库存','INT','int64','Count','0','0','0','','number',''),(143,18,4,'total_count','总数','VARCHAR','string','TotalCount','0','0','0','','number',''),(144,18,5,'card_key','卡密','VARCHAR','string','CardKey','0','0','0','like','input',''),(145,18,6,'use','是否已用','VARCHAR','string','Use','0','0','0','EQ','select','sys_yes_no'),(146,18,7,'upload_time','入库时间','DATETIME','time.Time','UploadTime','0','0','0','BETWEEN','time',''),(147,18,8,'sku_id','商品规格绑定','INT','int64','SkuId','0','0','0','','text',''),(148,18,9,'sort','排序，出售优先级','VARCHAR','string','Sort','0','0','0','','',''),(149,19,0,'id','id','INT','int64','Id','1','0','0','','',''),(150,19,1,'name','名字','VARCHAR','string','Name','0','0','0','like','input',''),(151,19,2,'icon_url','图标路径','VARCHAR','string','IconUrl','0','0','0','','image',''),(152,19,3,'tag','标签','VARCHAR','string','Tag','0','0','0','','input',''),(158,21,0,'id','','INT','int64','Id','1','0','0','','',''),(159,21,1,'sort','排序','INT','int64','Sort','0','0','0','','',''),(160,21,2,'type_image','类型图片','VARCHAR','string','TypeImage','0','0','0','','image',''),(161,21,3,'type_name','商品类别名称','VARCHAR','string','TypeName','0','0','0','like','input',''),(162,21,4,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','BETWEEN','time',''),(178,22,0,'id','','INT','int64','Id','1','0','0','','',''),(179,22,1,'username','账号','VARCHAR','string','Username','0','0','0','like','input',''),(180,22,2,'password','密码','VARCHAR','string','Password','0','0','0','','text',''),(181,22,3,'creation_time','账号创建时间','INT','int64','CreationTime','0','0','0','','time',''),(182,22,4,'login_time','登录时间','INT','int64','LoginTime','0','0','0','','time',''),(183,22,5,'status','账号状态','VARCHAR','string','Status','0','0','0','EQ','select','sys_ste'),(184,22,6,'role_id','角色id','INT','int64','RoleId','0','0','0','','',''),(185,22,7,'phone','手机','VARCHAR','string','Phone','0','0','0','like','input',''),(186,22,8,'email','邮箱','VARCHAR','string','Email','0','0','0','like','input',''),(187,22,9,'name','用户名','VARCHAR','string','Name','0','0','0','like','input',''),(188,22,10,'avatar','头像','VARCHAR','string','Avatar','0','0','0','','image',''),(189,22,11,'recommend_code','推荐码','VARCHAR','string','RecommendCode','0','0','0','EQ','text',''),(190,23,0,'id','id','INT','int64','Id','1','0','0','','',''),(191,23,1,'user_id','用户id','INT','int64','UserId','0','0','0','','',''),(192,23,2,'balance','余额','DECIMAL','float64','Balance','0','0','0','BETWEEN','number',''),(193,23,3,'promotion_amount','推广获取总金额','DECIMAL','float64','PromotionAmount','0','0','0','BETWEEN','number',''),(194,23,4,'recharge_amount','充值金额','DECIMAL','float64','RechargeAmount','0','0','0','BETWEEN','number',''),(219,32,0,'id','','INT','int64','Id','1','0','0','','',''),(220,32,1,'sort','排序','VARCHAR','string','Sort','0','0','0','','number',''),(221,32,2,'parent_id','父级id','INT','int64','ParentId','0','0','0','','',''),(222,32,3,'topic_page_image','主题首页图片','VARCHAR','string','TopicPageImage','0','0','0','','image',''),(223,32,4,'topic_name','主题名称','VARCHAR','string','TopicName','0','0','0','like','input',''),(224,32,5,'topic_desc','主题描述','VARCHAR','string','TopicDesc','0','0','0','like','input',''),(225,32,6,'type_ids','商品类型id','VARCHAR','string','TypeIds','0','0','0','','',''),(229,34,0,'id','','INT','int64','Id','1','0','0','','',''),(230,34,1,'name','广告名称','VARCHAR','string','Name','0','0','0','like','input',''),(231,34,2,'to_id','目标id','INT','int64','ToId','0','0','0','','input',''),(232,34,3,'advice_type','广告类型，用于跳转到对应的页面','VARCHAR','string','AdviceType','0','0','0','EQ','select','advice_type'),(233,34,4,'sort','排序','VARCHAR','string','Sort','0','0','0','','number',''),(234,34,5,'state','状态','VARCHAR','string','State','0','0','0','EQ','radio','sys_state'),(235,34,6,'show_type','显示类型，carousel轮播图，package，礼包','VARCHAR','string','ShowType','0','0','0','EQ','select','show_type'),(236,34,7,'create_by','创建人','VARCHAR','string','CreateBy','0','0','0','','',''),(237,34,8,'create_time','创建时间','DATETIME','time.Time','CreateTime','0','0','0','','time',''),(238,34,9,'update_by','更新人','VARCHAR','string','UpdateBy','0','0','0','','',''),(239,34,10,'update_time','更新时间','DATETIME','time.Time','UpdateTime','0','0','0','','time',''),(240,35,0,'id',' ','INT','int64','Id','1','0','0','','',''),(241,35,1,'topic_id','','INT','int64','TopicId','0','0','0','','',''),(242,35,2,'sku_id','','INT','int64','SkuId','0','0','0','','',''),(243,34,2,'image_url','图片','VARCHAR','string','ImageUrl','0','0','0','','image',''),(244,34,3,'to_type','目标类型','VARCHAR','string','ToType','0','0','0','EQ','select','to_type'),(467,2,0,'tag_text_color','标签字体颜色','varchar','string','TagTextColor','0','0','0','','input',''),(468,2,0,'tag_background_color','标签背景颜色','varchar','string','TagBackgroundColor','0','0','0','','input',''),(469,16,0,'other_data','其他数据','varchar','string','OtherData','0','0','0','','',''),(472,22,0,'inviter_by','邀请人','int','int64','InviterBy','0','0','0','','',''),(473,10,0,'column_name','字段名','varchar','string','ColumnName','0','0','0','like','input',''),(474,1,3,'article_desc','文章简介','varchar','string','ArticleDesc','0','0','0','like','',''),(476,0,0,'id','','int','int64','Id','','','','','',''),(477,0,0,'name','名称','varchar','string','Name','0','0','0','','',''),(478,0,0,'username','账号','varchar','string','Username','0','0','0','','',''),(479,0,0,'password','密码','varchar','string','Password','0','0','0','','',''),(480,0,0,'creation_time','账号创建时间','int','int64','CreationTime','0','0','0','','',''),(481,0,0,'login_time','登录时间','int','int64','LoginTime','0','0','0','','',''),(482,0,0,'status','账号状态','varchar','string','Status','0','0','0','','',''),(483,0,0,'role_id','角色id','int','int64','RoleId','0','0','0','','',''),(484,0,0,'phone','手机','varchar','string','Phone','0','0','0','','',''),(485,0,0,'email','邮箱','varchar','string','Email','0','0','0','','',''),(486,0,0,'avatar','头像','varchar','string','Avatar','0','0','0','','',''),(487,17,0,'sort','排序','int','int64','Sort','0','0','0','EQ','number',''),(488,17,0,'seo_title','seo_标题','varchar','string','SeoTitle','','','','','',''),(489,17,0,'seo_keywords','seo_关键字','varchar','string','SeoKeywords','','','','','',''),(490,17,0,'seo_description','seo_描述','varchar','string','SeoDescription','','','','','',''),(491,11,0,'image_url','商品图标','varchar','string','ImageUrl','','','','','image','');
/*!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',
`image_url` varchar(255) DEFAULT NULL COMMENT '商品图标',
`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,'/api/static/20241011200200yqOp-fynnnsc8452611.jpg','苹果礼品卡特惠包',1,0,'1,2'),(2,2,NULL,'PUBG国际服直充',2,0,'2'),(11,3,NULL,'Steam全球号',11,172602,NULL),(12,4,NULL,'IOS全球卡密【直降5%】',13,4147,NULL),(13,5,NULL,'Netflix（奈飞）会员账号',15,1447,NULL),(14,1,NULL,'谷歌礼品卡 【直降5%】',17,2150,NULL),(15,4,NULL,'Steam（美国）充值卡',18,919,NULL),(16,4,NULL,'Razer全球卡密【直降3%】',19,333,NULL),(17,4,NULL,'Roblox充值卡',20,254,NULL),(18,4,NULL,'eBay（美国）充值卡',21,300,NULL),(19,5,NULL,'苹果全球ID',22,48163,NULL),(20,4,NULL,'xbox（全球）充值卡',24,510,NULL),(21,4,NULL,'任天堂充值卡【直降4%】',25,4762,NULL),(22,6,NULL,'Steam（阿根廷）余额代充',27,410,NULL),(23,5,NULL,'推特全球ID',28,9021,NULL),(24,5,NULL,'Ins全球账号',30,1911,NULL),(25,5,NULL,'TikTok账号',31,2893,NULL),(26,5,NULL,'YouTube账号',32,2264,NULL),(27,5,NULL,'Nexon账号',33,1911,NULL),(28,5,NULL,'Discord账号',34,1646,NULL),(29,5,NULL,'亚马逊游戏会员账号',35,1559,NULL),(30,5,NULL,'twitch账号',36,1050,NULL),(31,5,NULL,'ESPN会员账号',37,1121,NULL),(32,5,NULL,'迪士尼Plus会员账号',39,1650,NULL),(33,5,NULL,'暴雪战网账号',41,1545,NULL),(34,5,NULL,'EPIC账号',42,3281,NULL),(35,4,NULL,'Netflix（美国）充值卡',43,105,NULL),(36,4,NULL,'Steam（美国）余额代充',44,1560,NULL),(37,4,NULL,'steam（土耳其）充值卡',45,3660,NULL),(38,4,NULL,'steam（韩国）充值卡',46,1771,NULL),(39,4,NULL,'BitCash（日本）充值卡',47,1871,NULL),(40,1,NULL,'Nexon（美国）礼品卡',48,1556,NULL),(41,4,NULL,'GoCash（全球）充值卡',49,1209,NULL),(42,6,NULL,'Steam（新西兰）余额代充',50,1499,NULL),(43,8,NULL,'普雷卡Pcard',51,761,NULL),(44,4,NULL,'Nexon（韩国）充值卡',52,1666,NULL),(45,4,NULL,'刀塔自走棋糖果兑换码',53,898,NULL),(46,4,NULL,'webmoney（日本）充值卡',54,721,NULL),(47,4,NULL,'香港GC充值卡',55,764,NULL),(48,4,NULL,'任天堂（澳洲）充值卡',56,1499,NULL),(49,4,NULL,'任天堂（巴西）充值卡',57,1444,NULL),(50,1,NULL,'苹果礼品卡特惠包',58,473,NULL),(51,6,NULL,'steam点卡特惠包',59,823,NULL),(52,1,NULL,'谷歌礼品卡特惠包',60,1,NULL),(53,8,NULL,'暴雪战网（阿根廷）点数',61,1125,NULL),(54,6,NULL,'steam（俄罗斯）余额代充',62,1029,NULL),(55,4,NULL,'任天堂（英国）充值卡',63,1136,NULL),(56,5,NULL,'雅虎邮箱账号',64,476,NULL),(57,5,NULL,'谷歌（全球）邮箱账号',65,3847,NULL),(58,5,NULL,'微软（全球）邮箱账号',66,782,NULL),(59,5,NULL,'俄罗斯邮箱账号',67,1,NULL),(60,5,NULL,'美国邮箱账号',68,601,NULL),(61,5,NULL,'Midjourney会员账号',69,182,NULL),(62,7,NULL,'求生之路2【steam版】',71,102,NULL),(63,7,NULL,'壁纸引擎【steam版】',72,1,NULL),(64,7,NULL,'城市：天际线【steam版】',73,82,NULL),(65,7,NULL,'植物大战僵尸：年度版【steam版】',75,148,NULL),(66,7,NULL,'方舟：生存进化【steam版】',76,148,NULL),(67,7,NULL,'木筏求生【steam版】',77,101,NULL),(68,7,NULL,'模拟人生4【steam版】',78,1,NULL),(69,7,NULL,'饥荒联机版【steam版】',79,456,NULL),(70,7,NULL,'反恐精英1.6【steam版】',80,359,NULL),(71,7,NULL,'太空狼人杀Among Us【steam版】',81,77,NULL),(72,7,NULL,'人类一败涂地【steam版】',83,1648,NULL),(73,5,NULL,'APP安装包下载',88,8308,NULL),(74,5,NULL,'facebook账号',91,1,NULL),(75,4,NULL,'PSN（全球）充值卡',92,1,NULL),(76,7,NULL,'任天堂游戏CDK',94,140,NULL),(77,2,NULL,'幻塔（国际服）直充',95,309,NULL),(78,6,NULL,'GoPay钱包代充',96,12,NULL),(79,2,NULL,'PUBG国际服直充',98,1482,NULL),(80,6,NULL,'PayNow钱包代充',99,1,NULL),(81,6,NULL,'Grabpay钱包代充',100,1,NULL),(82,8,NULL,'Windows正版系统激活码',104,130,NULL),(83,2,NULL,'LOL国际手游（直充）',106,302,NULL),(84,2,NULL,'卡通农场（国际服）直充',107,250,NULL),(85,2,NULL,'皇室战争（国际服）直充',108,275,NULL),(86,2,NULL,'部落冲突（国际服）直充',109,221,NULL),(87,2,NULL,'荒野乱斗（国际服）直充',110,264,NULL),(88,2,NULL,'胜利女神（国际服）手游直充',111,211,NULL),(89,2,NULL,'暗区突围（国际服）直充',112,222,NULL),(90,2,NULL,'蛋仔派对（国际服）直充',113,308,NULL),(91,5,NULL,'HBO鼎级剧场 会员账号',114,1524,NULL),(92,2,NULL,'原神手游（国际服）直充',115,246,NULL),(93,2,NULL,'WeTV 会员直充',116,235,NULL),(94,5,NULL,'hulu会员账号',117,0,NULL),(95,2,NULL,'PUBG：未来之役（国际服）直充',118,129,NULL),(96,2,NULL,'第五人格（国际服）直充',119,129,NULL),(97,2,NULL,'瓦罗兰特（马来西亚）直充',120,294,NULL),(98,2,NULL,'漫威：瞬战超能（国际服）直充',121,25,NULL),(99,2,NULL,'明日之后（国际服）直充',122,14,NULL),(100,2,NULL,'Mobile Legends 无尽对决充值',123,279,NULL),(101,2,NULL,'王者荣耀（国际服）直充',124,305,NULL),(102,5,NULL,'谷歌全球ID',125,6885,NULL),(103,7,NULL,'符文大地传说手游',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=59 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),(35,1,'俄罗斯','',0),(37,18,'123','',0),(38,17,'123','',0),(55,18,'1223','',0),(56,18,'332','',0),(57,18,'123','',0),(58,18,'2323','',0);
/*!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 '声明：保护未成年健康，本平台禁止未成年消费一、直充说明【填写信息】UID直充【充值流程】输入UID，选择区服 → 下单支付 → 充值完成【充值时长】1~3分钟（高峰期可能晚几分钟）二、注意事项1.填错充值账号怎么办？能退款吗？如果我们按照您填写的信息已完成充值，那么将无法退还，如果因我平台导致充值错误，经核验后，可退还；若不影响二次销售的点卡类商品，联系在线客服可帮忙转卖，但等待时间不定。2.支付成功后多久能到账？一般情况下，1-2分钟内即可到账。如超过5分钟未到账请及时联系客服咨询*本售后政策不叠加【随心换服务】账号类商品：自购买日起售后期3天，商品质量问题免费更换邮箱类商品：自购买日起3天内卡密类商品：因卡密都是正规可囤，无售后期。（如有问题随时联系我们处理）充值类商品：到账后无法售后购买说明：原神国际服直充 300+30 Genesis Crystals来自官方渠道，支持极速发货、错误包换，如有需要可关注http://kar.kardz.cc/detail/1578289602.html
============
图片![\"\"](\"/api/static/image/20240816235931Icon.png\")
============
视频
\n\n
+===========
',NULL,NULL,'1','2024-08-17 00:04:12'),(2,'懒得介绍',_binary '666
',NULL,NULL,NULL,NULL),(11,'Steam全球号',_binary 'Steam全球号
',NULL,NULL,NULL,NULL),(12,'steam空白账号',_binary 'steam空白账号
',NULL,NULL,NULL,NULL),(13,'IOS全球卡密【直降5%】',_binary 'IOS全球卡密【直降5%】
',NULL,NULL,NULL,NULL),(14,'美国',_binary '美国
',NULL,NULL,NULL,NULL),(15,'Netflix（奈飞）会员账号',_binary 'Netflix（奈飞）会员账号
',NULL,NULL,NULL,NULL),(16,'共享（5人）',_binary '共享（5人）
',NULL,NULL,NULL,NULL),(17,'谷歌礼品卡 【直降5%】',_binary '谷歌礼品卡 【直降5%】
',NULL,NULL,NULL,NULL),(18,'Steam（美国）充值卡',_binary 'Steam（美国）充值卡
',NULL,NULL,NULL,NULL),(19,'Razer全球卡密【直降3%】',_binary 'Razer全球卡密【直降3%】
',NULL,NULL,NULL,NULL),(20,'Roblox充值卡',_binary 'Roblox充值卡
',NULL,NULL,NULL,NULL),(21,'eBay（美国）充值卡',_binary 'eBay（美国）充值卡
',NULL,NULL,NULL,NULL),(22,'苹果全球ID',_binary '苹果全球ID
',NULL,NULL,NULL,NULL),(23,'苹果ID账号（未开通iCloud）',_binary '苹果ID账号（未开通iCloud）
',NULL,NULL,NULL,NULL),(24,'xbox（全球）充值卡',_binary 'xbox（全球）充值卡
',NULL,NULL,NULL,NULL),(25,'任天堂充值卡【直降4%】',_binary '任天堂充值卡【直降4%】
',NULL,NULL,NULL,NULL),(26,'香港',_binary '香港
',NULL,NULL,NULL,NULL),(27,'Steam（阿根廷）余额代充',_binary 'Steam（阿根廷）余额代充
',NULL,NULL,NULL,NULL),(28,'推特全球ID',_binary '推特全球ID
',NULL,NULL,NULL,NULL),(29,'账号',_binary '账号
',NULL,NULL,NULL,NULL),(30,'Ins全球账号',_binary 'Ins全球账号
',NULL,NULL,NULL,NULL),(31,'TikTok账号',_binary 'TikTok账号
',NULL,NULL,NULL,NULL),(32,'YouTube账号',_binary 'YouTube账号
',NULL,NULL,NULL,NULL),(33,'Nexon账号',_binary 'Nexon账号
',NULL,NULL,NULL,NULL),(34,'Discord账号',_binary 'Discord账号
',NULL,NULL,NULL,NULL),(35,'亚马逊游戏会员账号',_binary '亚马逊游戏会员账号
',NULL,NULL,NULL,NULL),(36,'twitch账号',_binary 'twitch账号
',NULL,NULL,NULL,NULL),(37,'ESPN会员账号',_binary 'ESPN会员账号
',NULL,NULL,NULL,NULL),(38,'独享',_binary '独享
',NULL,NULL,NULL,NULL),(39,'迪士尼Plus会员账号',_binary '迪士尼Plus会员账号
',NULL,NULL,NULL,NULL),(40,'独享（1人）',_binary '独享（1人）
',NULL,NULL,NULL,NULL),(41,'暴雪战网账号',_binary '暴雪战网账号
',NULL,NULL,NULL,NULL),(42,'EPIC账号',_binary 'EPIC账号
',NULL,NULL,NULL,NULL),(43,'Netflix（美国）充值卡',_binary 'Netflix（美国）充值卡
',NULL,NULL,NULL,NULL),(44,'Steam（美国）余额代充',_binary 'Steam（美国）余额代充
',NULL,NULL,NULL,NULL),(45,'steam（土耳其）充值卡',_binary 'steam（土耳其）充值卡
',NULL,NULL,NULL,NULL),(46,'steam（韩国）充值卡',_binary 'steam（韩国）充值卡
',NULL,NULL,NULL,NULL),(47,'BitCash（日本）充值卡',_binary 'BitCash（日本）充值卡
',NULL,NULL,NULL,NULL),(48,'Nexon（美国）礼品卡',_binary 'Nexon（美国）礼品卡
',NULL,NULL,NULL,NULL),(49,'GoCash（全球）充值卡',_binary 'GoCash（全球）充值卡
',NULL,NULL,NULL,NULL),(50,'Steam（新西兰）余额代充',_binary 'Steam（新西兰）余额代充
',NULL,NULL,NULL,NULL),(51,'普雷卡Pcard',_binary '普雷卡Pcard
',NULL,NULL,NULL,NULL),(52,'Nexon（韩国）充值卡',_binary 'Nexon（韩国）充值卡
',NULL,NULL,NULL,NULL),(53,'刀塔自走棋糖果兑换码',_binary '刀塔自走棋糖果兑换码
',NULL,NULL,NULL,NULL),(54,'webmoney（日本）充值卡',_binary 'webmoney（日本）充值卡
',NULL,NULL,NULL,NULL),(55,'香港GC充值卡',_binary '香港GC充值卡
',NULL,NULL,NULL,NULL),(56,'任天堂（澳洲）充值卡',_binary '任天堂（澳洲）充值卡
',NULL,NULL,NULL,NULL),(57,'任天堂（巴西）充值卡',_binary '任天堂（巴西）充值卡
',NULL,NULL,NULL,NULL),(58,'苹果礼品卡特惠包',_binary '苹果礼品卡特惠包
',NULL,NULL,NULL,NULL),(59,'steam点卡特惠包',_binary 'steam点卡特惠包
',NULL,NULL,NULL,NULL),(60,'谷歌礼品卡特惠包',_binary '谷歌礼品卡特惠包
',NULL,NULL,NULL,NULL),(61,'暴雪战网（阿根廷）点数',_binary '暴雪战网（阿根廷）点数
',NULL,NULL,NULL,NULL),(62,'steam（俄罗斯）余额代充',_binary 'steam（俄罗斯）余额代充
',NULL,NULL,NULL,NULL),(63,'任天堂（英国）充值卡',_binary '任天堂（英国）充值卡
',NULL,NULL,NULL,NULL),(64,'雅虎邮箱账号',_binary '雅虎邮箱账号
',NULL,NULL,NULL,NULL),(65,'谷歌（全球）邮箱账号',_binary '谷歌（全球）邮箱账号
',NULL,NULL,NULL,NULL),(66,'微软（全球）邮箱账号',_binary '微软（全球）邮箱账号
',NULL,NULL,NULL,NULL),(67,'俄罗斯邮箱账号',_binary '俄罗斯邮箱账号
',NULL,NULL,NULL,NULL),(68,'美国邮箱账号',_binary '美国邮箱账号
',NULL,NULL,NULL,NULL),(69,'Midjourney会员账号',_binary 'Midjourney会员账号
',NULL,NULL,NULL,NULL),(70,'独享账号',_binary '独享账号
',NULL,NULL,NULL,NULL),(71,'求生之路2【steam版】',_binary '求生之路2【steam版】
',NULL,NULL,NULL,NULL),(72,'壁纸引擎【steam版】',_binary '壁纸引擎【steam版】
',NULL,NULL,NULL,NULL),(73,'城市：天际线【steam版】',_binary '城市：天际线【steam版】
',NULL,NULL,NULL,NULL),(74,'激活码',_binary '激活码
',NULL,NULL,NULL,NULL),(75,'植物大战僵尸：年度版【steam版】',_binary '植物大战僵尸：年度版【steam版】
',NULL,NULL,NULL,NULL),(76,'方舟：生存进化【steam版】',_binary '方舟：生存进化【steam版】
',NULL,NULL,NULL,NULL),(77,'木筏求生【steam版】',_binary '木筏求生【steam版】
',NULL,NULL,NULL,NULL),(78,'模拟人生4【steam版】',_binary '模拟人生4【steam版】
',NULL,NULL,NULL,NULL),(79,'饥荒联机版【steam版】',_binary '饥荒联机版【steam版】
',NULL,NULL,NULL,NULL),(80,'反恐精英1.6【steam版】',_binary '反恐精英1.6【steam版】
',NULL,NULL,NULL,NULL),(81,'太空狼人杀Among Us【steam版】',_binary '太空狼人杀Among Us【steam版】
',NULL,NULL,NULL,NULL),(82,'成品账号',_binary '成品账号
',NULL,NULL,NULL,NULL),(83,'人类一败涂地【steam版】',_binary '人类一败涂地【steam版】
',NULL,NULL,NULL,NULL),(84,'中国香港',_binary '中国香港
',NULL,NULL,NULL,NULL),(85,'日本',_binary '日本
',NULL,NULL,NULL,NULL),(86,'欧洲',_binary '欧洲
',NULL,NULL,NULL,NULL),(87,'巴西',_binary '巴西
',NULL,NULL,NULL,NULL),(88,'APP安装包下载',_binary 'APP安装包下载
',NULL,NULL,NULL,NULL),(89,'不带账号',_binary '不带账号
',NULL,NULL,NULL,NULL),(90,'APP',_binary 'APP
',NULL,NULL,NULL,NULL),(91,'facebook账号',_binary 'facebook账号
',NULL,NULL,NULL,NULL),(92,'PSN（全球）充值卡',_binary 'PSN（全球）充值卡
',NULL,NULL,NULL,NULL),(93,'steam安卓APP',_binary 'steam安卓APP
',NULL,NULL,NULL,NULL),(94,'任天堂游戏CDK',_binary '任天堂游戏CDK
',NULL,NULL,NULL,NULL),(95,'幻塔（国际服）直充',_binary '幻塔（国际服）直充
',NULL,NULL,NULL,NULL),(96,'GoPay钱包代充',_binary 'GoPay钱包代充
',NULL,NULL,NULL,NULL),(97,'印尼',_binary '印尼
',NULL,NULL,NULL,NULL),(98,'PUBG国际服直充',_binary 'PUBG国际服直充
',NULL,NULL,NULL,NULL),(99,'PayNow钱包代充',_binary 'PayNow钱包代充
',NULL,NULL,NULL,NULL),(100,'Grabpay钱包代充',_binary 'Grabpay钱包代充
',NULL,NULL,NULL,NULL),(101,'新加坡',_binary '新加坡
',NULL,NULL,NULL,NULL),(102,'马来西亚',_binary '马来西亚
',NULL,NULL,NULL,NULL),(103,'泰国',_binary '泰国
',NULL,NULL,NULL,NULL),(104,'Windows正版系统激活码',_binary 'Windows正版系统激活码
',NULL,NULL,NULL,NULL),(105,'一次性',_binary '一次性
',NULL,NULL,NULL,NULL),(106,'LOL国际手游（直充）',_binary 'LOL国际手游（直充）
',NULL,NULL,NULL,NULL),(107,'卡通农场（国际服）直充',_binary '卡通农场（国际服）直充
',NULL,NULL,NULL,NULL),(108,'皇室战争（国际服）直充',_binary '皇室战争（国际服）直充
',NULL,NULL,NULL,NULL),(109,'部落冲突（国际服）直充',_binary '部落冲突（国际服）直充
',NULL,NULL,NULL,NULL),(110,'荒野乱斗（国际服）直充',_binary '荒野乱斗（国际服）直充
',NULL,NULL,NULL,NULL),(111,'胜利女神（国际服）手游直充',_binary '胜利女神（国际服）手游直充
',NULL,NULL,NULL,NULL),(112,'暗区突围（国际服）直充',_binary '暗区突围（国际服）直充
',NULL,NULL,NULL,NULL),(113,'蛋仔派对（国际服）直充',_binary '蛋仔派对（国际服）直充
',NULL,NULL,NULL,NULL),(114,'HBO鼎级剧场 会员账号',_binary 'HBO鼎级剧场 会员账号
',NULL,NULL,NULL,NULL),(115,'原神手游（国际服）直充',_binary '原神手游（国际服）直充
',NULL,NULL,NULL,NULL),(116,'WeTV 会员直充',_binary 'WeTV 会员直充
',NULL,NULL,NULL,NULL),(117,'hulu会员账号',_binary 'hulu会员账号
',NULL,NULL,NULL,NULL),(118,'PUBG：未来之役（国际服）直充',_binary 'PUBG：未来之役（国际服）直充
',NULL,NULL,NULL,NULL),(119,'第五人格（国际服）直充',_binary '第五人格（国际服）直充
',NULL,NULL,NULL,NULL),(120,'瓦罗兰特（马来西亚）直充',_binary '瓦罗兰特（马来西亚）直充
',NULL,NULL,NULL,NULL),(121,'漫威：瞬战超能（国际服）直充',_binary '漫威：瞬战超能（国际服）直充
',NULL,NULL,NULL,NULL),(122,'明日之后（国际服）直充',_binary '明日之后（国际服）直充
',NULL,NULL,NULL,NULL),(123,'Mobile Legends 无尽对决充值',_binary 'Mobile Legends 无尽对决充值
',NULL,NULL,NULL,NULL),(124,'王者荣耀（国际服）直充',_binary '王者荣耀（国际服）直充
',NULL,NULL,NULL,NULL),(125,'谷歌全球ID',_binary '谷歌全球ID
',NULL,NULL,NULL,NULL),(126,'符文大地传说手游',_binary '符文大地传说手游
',NULL,NULL,NULL,NULL),(127,'美国/加拿大',_binary '美国/加拿大
',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,
`seo_title` varchar(255) DEFAULT NULL COMMENT 'seo_标题',
`seo_keywords` varchar(255) DEFAULT NULL COMMENT 'seo_关键字',
`seo_description` varchar(255) DEFAULT NULL COMMENT 'seo_描述',
`sku_image` varchar(255) DEFAULT NULL COMMENT 'sku图片',
`sku_name` varchar(255) NOT NULL COMMENT '商品sku名字',
`sort` int(11) DEFAULT '0' COMMENT '排序',
`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=153 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,'seo大标题:苹果礼品卡3美金+精品账号','特惠,特惠包,苹果,ipone,apple,礼品卡,3美金,$3,精品账号,账号','first描述','https://cdn.wwads.cn/creatives/jEZ0oCz8drAL8FzyzIxFx8IkNxYc3gF82Fxle7aq.png','特惠包1【苹果礼品卡3美金+精品账号】',0,36.00,36.00,50,1,1,NULL,NULL),(2,NULL,NULL,NULL,'https://cdn.wwads.cn/creatives/jEZ0oCz8drAL8FzyzIxFx8IkNxYc3gF82Fxle7aq.png','特惠包2【苹果礼品卡5美金+精品账号】',1,52.00,58.80,50,1,1,NULL,NULL),(3,NULL,NULL,NULL,'/api/static/202404231412462.jpg','特惠包3【苹果礼品卡3美金+5美金】',2,75.00,67.00,50,1,1,NULL,'2024-05-20 04:03:45'),(4,NULL,NULL,NULL,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包2【苹果礼品卡500日元+精美账号】',NULL,48.00,55.00,50,2,1,NULL,'2024-05-20 04:03:45'),(5,NULL,NULL,NULL,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包1【苹果礼品卡150港元+200港元】',NULL,381.00,384.00,50,3,1,NULL,'2024-05-20 04:03:45'),(6,NULL,NULL,NULL,'/api/static/20240423094145微信图片_20240416170543.jpg','特惠包1【苹果礼品卡100NT+300NT】',NULL,135.00,139.00,50,4,1,NULL,'2024-05-20 04:03:45'),(8,NULL,NULL,NULL,'/api/static/17170534845528.jpg','Steam（中国）白号',NULL,19.00,19.00,172602,11,11,'1','2024-05-30 09:08:01'),(9,NULL,NULL,NULL,'/api/static/17170534845679.png','苹果iTunes礼品卡-2美金',NULL,42.00,42.00,4147,12,12,'1','2024-05-30 09:08:01'),(10,NULL,NULL,NULL,'/api/static/171705348458310.png','苹果iTunes礼品卡-3美金',NULL,49.00,49.00,2773,12,12,'1','2024-05-30 09:08:01'),(11,NULL,NULL,NULL,'/api/static/20240726203050微信图片_20240619220703.jpg','奈飞Netflix TV - 30天会员',0,30.00,30.00,1447,13,13,NULL,NULL),(14,NULL,NULL,NULL,'/api/static/171705348459914.png','Razer Gold（美国）充值卡-5美元',NULL,58.00,58.00,333,12,16,'1','2024-05-30 09:08:01'),(15,NULL,NULL,NULL,'/api/static/171705348461315.png','Razer Gold（美国）充值卡-10美元',NULL,87.00,87.00,333,12,16,'1','2024-05-30 09:08:01'),(16,NULL,NULL,NULL,'/api/static/171705412073716.png','Roblox（美国）充值卡-10美元',NULL,80.00,80.00,254,12,17,'1','2024-05-30 09:08:01'),(18,NULL,NULL,NULL,'/api/static/171705348462918.png','苹果（美国）ID',NULL,36.00,36.00,48163,14,19,'1','2024-05-30 09:08:01'),(19,NULL,NULL,NULL,'/api/static/171705348464419.png','Xbox（美国）充值卡-5美元',NULL,40.00,40.00,510,12,20,'1','2024-05-30 09:08:01'),(20,NULL,NULL,NULL,'/api/static/171705348465920.png','Xbox（美国）充值卡-10美元',NULL,72.00,72.00,510,12,20,'1','2024-05-30 09:08:01'),(21,NULL,NULL,NULL,'/api/static/171705348467521.png','Xbox（美国）充值卡-15美元',NULL,108.00,108.00,510,12,20,'1','2024-05-30 09:08:01'),(22,NULL,NULL,NULL,'/api/static/171705412075222.png','任天堂（中国香港）充值卡-100港币',NULL,110.00,110.00,4762,15,21,'1','2024-05-30 09:08:01'),(23,NULL,NULL,NULL,'/api/static/171705412076723.png','任天堂（中国香港）充值卡-300港币',NULL,351.00,351.00,4762,15,21,'1','2024-05-30 09:08:01'),(25,NULL,NULL,NULL,'/api/static/171705348469025.jpg','推特（新号）ID',NULL,25.00,25.00,9021,16,23,'1','2024-05-30 09:08:01'),(27,NULL,NULL,NULL,'/api/static/171705348472127.png','TikTok新号',NULL,35.00,35.00,2893,16,25,'1','2024-05-30 09:08:01'),(28,NULL,NULL,NULL,'/api/static/171705348473628.jpg','YouTube（新号）账号',NULL,38.00,38.00,2264,16,26,'1','2024-05-30 09:08:01'),(33,NULL,NULL,NULL,'/api/static/171705348479733.png','ESPN会员账号-1年会员',NULL,406.80,406.80,1121,17,31,'1','2024-05-30 09:08:01'),(34,NULL,NULL,NULL,'/api/static/171705348481334.png','迪士尼Plus会员（独享）账号-30天会员',NULL,54.00,54.00,1650,18,32,'1','2024-05-30 09:08:01'),(53,NULL,NULL,NULL,'/api/static/171705348490453.png','特惠包1【苹果礼品卡3美金+精品账号】',NULL,36.00,36.00,473,12,50,'1','2024-05-30 09:08:01'),(71,NULL,NULL,NULL,'/api/static/171705348504171.jpg','Midjourney独享账号（高级会员）1个月',NULL,380.00,380.00,182,19,61,'1','2024-05-30 09:08:01'),(74,NULL,NULL,NULL,'/api/static/171705407204374.png','城市：天际线【标准版】激活码',NULL,88.00,88.00,82,20,64,'1','2024-05-30 09:08:01'),(81,NULL,NULL,NULL,'/api/static/171705348516381.png','太空狼人杀Among Us【成品账号】',NULL,35.00,35.00,77,21,71,'1','2024-05-30 09:08:01'),(83,NULL,NULL,NULL,'/api/static/171705348517883.png','苹果（中国香港）iTunes礼品卡-50港元',NULL,79.00,79.00,5150,22,72,'1','2024-05-30 09:08:01'),(84,NULL,NULL,NULL,'/api/static/171705348519484.png','任天堂（美国）充值卡-10美元',NULL,80.00,80.00,4762,12,72,'1','2024-05-30 09:08:01'),(85,NULL,NULL,NULL,'/api/static/171705348521085.png','任天堂（日本）充值卡-1000日元',NULL,69.00,69.00,4762,23,72,'1','2024-05-30 09:08:01'),(86,NULL,NULL,NULL,'/api/static/171705348522586.png','Xbox (中国香港) 充值卡-150港币',NULL,192.00,192.00,510,22,72,'1','2024-05-30 09:08:01'),(87,NULL,NULL,NULL,'/api/static/171705348522787.png','Xbox (中国香港) 充值卡-300港币',NULL,382.00,382.00,510,22,72,'1','2024-05-30 09:08:01'),(88,NULL,NULL,NULL,'/api/static/171705348524088.png','Xbox (欧洲）充值卡-5欧元',NULL,34.50,34.50,510,24,72,'1','2024-05-30 09:08:01'),(89,NULL,NULL,NULL,'/api/static/171705348525689.png','Xbox（日本）充值卡-1000日元',NULL,63.00,63.00,510,23,72,'1','2024-05-30 09:08:01'),(90,NULL,NULL,NULL,'/api/static/171705348527190.png','Xbox（巴西）充值卡-50雷亚尔',NULL,118.00,118.00,510,25,72,'1','2024-05-30 09:08:01'),(91,NULL,NULL,NULL,'/api/static/171705348528691.png','【推特】安卓APP',NULL,25.00,25.00,8308,26,73,'1','2024-05-30 09:08:01'),(92,NULL,NULL,NULL,'/api/static/171705348530292.jpg','【推特】安卓APP',NULL,35.00,35.00,9021,27,73,'1','2024-05-30 09:08:01'),(94,NULL,NULL,NULL,'/api/static/171705348533394.jpg','【油管】安卓APP',NULL,25.00,25.00,2264,27,73,'1','2024-05-30 09:08:01'),(95,NULL,NULL,NULL,'/api/static/171705348534895.png','【TikTok】安卓APP',NULL,28.00,28.00,2893,27,73,'1','2024-05-30 09:08:01'),(96,NULL,NULL,NULL,'/api/static/171705348536396.jpg','【facebook】安卓APP',NULL,35.00,35.00,1,27,74,'1','2024-05-30 09:08:01'),(97,NULL,NULL,NULL,'/api/static/171705348537997.jpg','PSN充值卡-10美金',NULL,69.00,69.00,1,12,75,'1','2024-05-30 09:08:01'),(98,NULL,NULL,NULL,'/api/static/171705348539498.jpg','PSN充值卡-20美金',NULL,140.00,140.00,1,12,75,'1','2024-05-30 09:08:01'),(99,NULL,NULL,NULL,'/api/static/171705348540999.jpg','PSN（中国香港）充值卡-80港币',NULL,80.00,80.00,1,15,75,'1','2024-05-30 09:08:01'),(100,NULL,NULL,NULL,'/api/static/1717053485425100.jpg','PSN（中国香港）充值卡-150港币',NULL,165.00,165.00,1,15,75,'1','2024-05-30 09:08:01'),(101,NULL,NULL,NULL,'/api/static/1717053485440101.jpg','PSN（日本）充值卡-1000日元',NULL,81.00,81.00,1,23,75,'1','2024-05-30 09:08:01'),(102,NULL,NULL,NULL,'/api/static/1717053485455102.jpg','PSN（日本）充值卡-3000日元',NULL,227.00,227.00,1,23,75,'1','2024-05-30 09:08:01'),(103,NULL,NULL,NULL,'/api/static/1717053485471103.png','【Steam】安卓APP',NULL,25.00,25.00,686892,28,75,'1','2024-05-30 09:08:01'),(104,NULL,NULL,NULL,'/api/static/1717053485486104.png','【任天堂游戏】破败王者：英雄联盟传奇',NULL,259.00,259.00,140,12,76,'1','2024-05-30 09:08:01'),(105,NULL,NULL,NULL,'/api/static/1717053485488105.png','【任天堂游戏】怪物猎人：崛起',NULL,569.00,569.00,140,24,76,'1','2024-05-30 09:08:01'),(106,NULL,NULL,NULL,'/api/static/1717053485502106.png','【任天堂游戏】NBA2K23',NULL,159.00,159.00,140,24,76,'1','2024-05-30 09:08:01'),(107,NULL,NULL,NULL,'/api/static/1717053485517107.png','【任天堂游戏】小小梦魇捆绑包',NULL,199.00,199.00,140,24,76,'1','2024-05-30 09:08:01'),(108,NULL,NULL,NULL,'/api/static/1717053485532108.png','【任天堂游戏】塞尔达传说：旷野之息',NULL,430.00,430.00,140,12,76,'1','2024-05-30 09:08:01'),(109,NULL,NULL,NULL,'/api/static/1717053485548109.png','【任天堂游戏】我的世界【美国】',NULL,199.00,199.00,140,12,76,'1','2024-05-30 09:08:01'),(111,NULL,NULL,NULL,'/api/static/1717053485578111.png','GoPay钱包代充（印尼）10万盾',NULL,60.00,60.00,12,29,78,'1','2024-05-30 09:08:01'),(112,NULL,NULL,NULL,'/api/static/1717053485594112.png','GoPay钱包代充（印尼）50万盾',NULL,285.00,285.00,12,29,78,'1','2024-05-30 09:08:01'),(115,NULL,NULL,NULL,'/api/static/1717053485640115.jpg','Grabpay钱包代充（新加坡）50新币',NULL,313.00,313.00,1,30,81,'1','2024-05-30 09:08:01'),(116,NULL,NULL,NULL,'/api/static/1717053485655116.jpg','Grabpay钱包代充（马来西亚）50林吉特',NULL,90.00,90.00,1,31,81,'1','2024-05-30 09:08:01'),(117,NULL,NULL,NULL,'/api/static/1717053485670117.jpg','Grabpay钱包代充（泰国）500泰铢',NULL,120.00,120.00,1,32,81,'1','2024-05-30 09:08:01'),(118,NULL,NULL,NULL,'/api/static/1717053485685118.jpg','Windows激活密钥【win7普通版 】一次性密钥',NULL,69.00,69.00,130,33,82,'1','2024-05-30 09:08:01'),(119,NULL,NULL,NULL,'/api/static/1717053485700119.jpg','Windows激活密钥【win10教育版】一次性密钥',NULL,79.00,79.00,130,33,82,'1','2024-05-30 09:08:01'),(120,NULL,NULL,NULL,'/api/static/1717053485715120.jpg','Windows激活密钥【win10专业版】一次性密钥',NULL,89.00,89.00,130,33,82,'1','2024-05-30 09:08:01'),(121,NULL,NULL,NULL,'/api/static/1717053485731121.jpg','Windows激活密钥【win11企业版】一次性密钥',NULL,93.00,93.00,130,33,82,'1','2024-05-30 09:08:01'),(122,NULL,NULL,NULL,'/api/static/1717053485746122.jpg','Windows激活密钥【win11专业版】一次性密钥',NULL,99.00,99.00,130,33,82,'1','2024-05-30 09:08:01'),(134,NULL,NULL,NULL,'/api/static/1717053485914134.jpg','hulu会员号【有广告】1个月',NULL,99.00,99.00,0,17,94,'1','2024-05-30 09:08:01'),(143,NULL,NULL,NULL,'/api/static/1717054148300143.jpg','usa/cad-475金币',NULL,50.00,50.00,1629,34,103,'1','2024-05-30 09:08:01'),(152,NULL,NULL,NULL,'','123',0,22.00,12.00,2,37,18,'1','2024-07-19 23:18:56');
/*!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 `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-10-11 23:05:21