kkc-go/file/virtual_mall.sql

-- MySQL dump 10.13  Distrib 5.7.44, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: virtual_mall
-- ------------------------------------------------------
-- Server version	5.7.44-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `authority`
--

DROP TABLE IF EXISTS `authority`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `authority` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `authority_name` varchar(255) DEFAULT NULL,
  `authority_path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `authority`
--

LOCK TABLES `authority` WRITE;
/*!40000 ALTER TABLE `authority` DISABLE KEYS */;
INSERT INTO `authority` VALUES (1,'登录','/api/ping');
/*!40000 ALTER TABLE `authority` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type_id` int(11) NOT NULL COMMENT '分类id',
  `goods_name` varchar(255) NOT NULL COMMENT '商品名字',
  `introduction_id` int(11) DEFAULT NULL COMMENT '商品介绍id',
  `sales_volume` varchar(255) DEFAULT NULL COMMENT '近30天销量',
  `tag_ids` varchar(255) DEFAULT NULL COMMENT '商品标签',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods`
--

LOCK TABLES `goods` WRITE;
/*!40000 ALTER TABLE `goods` DISABLE KEYS */;
INSERT INTO `goods` VALUES (1,1,'苹果礼品卡特惠包',NULL,NULL,'1,2'),(2,2,'PUBG国际服直充',NULL,NULL,NULL);
/*!40000 ALTER TABLE `goods` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

--
-- Table structure for table `goods_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`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='商品介绍';
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

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

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

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

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

--
-- Table structure for table `goods_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`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

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

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

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

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

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

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

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

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

--
-- Table structure for table `role`
--

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

--
-- Dumping data for table `role`
--

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

--
-- Table structure for table `role_authority`
--

DROP TABLE IF EXISTS `role_authority`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_authority` (
  `authority_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`authority_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_authority`
--

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

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

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL COMMENT '账号',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `creation_time` int(11) DEFAULT NULL COMMENT '账号创建时间',
  `login_time` int(11) DEFAULT NULL COMMENT '登录时间',
  `status` varchar(255) DEFAULT NULL COMMENT '账号状态',
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `recommend_code` varchar(255) DEFAULT NULL COMMENT '推荐码',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `usernames` (`username`) USING BTREE COMMENT '用户名'
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!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,'516702882@qq.com','37bcf5e351f329952fb347edc09f31a1',1711168151,NULL,'0',1,'15537351020','516702882@qq.com','大名鼎鼎',NULL,NULL),(2,'875182750@qq.com','37bcf5e351f329952fb347edc09f31a1',1711168151,NULL,'0',2,'13233826561','875182750@qq.com',NULL,NULL,NULL);
/*!40000 ALTER TABLE `user` 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-04-26 17:16:41