graphql-demo/graphql-demo.sql

-- --------------------------------------------------------
-- 主机:                           127.0.0.1
-- 服务器版本:                        5.7.28-log - MySQL Community Server (GPL)
-- 服务器操作系统:                      Win64
-- HeidiSQL 版本:                  11.2.0.6213
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 */;

-- 导出  表 graphql-demo.t_goods 结构
CREATE TABLE IF NOT EXISTS `t_goods` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `create_time` datetime(6) DEFAULT NULL,
    `update_time` datetime(6) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `detail` varchar(255) DEFAULT NULL,
    `img` varchar(255) DEFAULT NULL,
    `item_count` int(11) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `price` decimal(19,2) DEFAULT NULL,
    `serial_no` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

-- 正在导出表  graphql-demo.t_goods 的数据：~6 rows (大约)
/*!40000 ALTER TABLE `t_goods` DISABLE KEYS */;
INSERT INTO `t_goods` (`id`, `create_time`, `update_time`, `description`, `detail`, `img`, `item_count`, `name`, `price`, `serial_no`) VALUES
(1, '2021-06-21 16:49:12.094000', '2021-06-21 16:49:12.094000', 'GU女装起居套装（短袖）', 'GU女装起居套装（短袖）', 'https://graphql.cn/img/logo.svg', 99, 'GU女装', 74.00, 'pYmhjY58'),
(2, '2021-06-21 16:52:30.200000', '2021-06-21 16:52:30.200000', '九阳电热饭盒可插电加热蒸煮便携', '九阳电热饭盒可插电加热蒸煮便携', 'https://graphql.cn/img/logo.svg', 125, '九阳电热饭盒', 159.00, '3qlihuWg'),
(3, '2021-06-21 18:45:11.646000', '2021-06-21 18:45:11.646000', '斐尔可67键minila蓝牙无线机械键盘', '斐尔可67键minila蓝牙无线机械键盘', 'https://graphql.cn/img/logo.svg', 48, 'Minila67', 899.00, '5gqeGUEO'),
(4, '2021-06-21 18:46:53.305000', '2021-06-21 18:46:53.305000', '现货德国WMF福滕宝实木盖研磨器2件装', '现货德国WMF福滕宝实木盖研磨器2件装', 'https://graphql.cn/img/logo.svg', 99, 'WMF调料瓶2件装', 288.00, 'vdjvwNjW'),
(5, '2021-06-21 18:48:31.944000', '2021-06-21 18:48:31.944000', '现货德国WMF福滕宝实木盖研磨器2件装', 'Apple/苹果 iPhone 12', 'https://graphql.cn/img/logo.svg', 20, 'iPhone 12', 6299.00, 'INEnt8OV'),
(6, '2021-06-21 18:52:05.178000', '2021-06-21 18:52:05.178000', '现货原版The Watercolorist\'s Essential Notebook水彩画家的必备笔记', '现货原版The Watercolorist\'s Essential Notebook水彩画家的必备笔记', 'https://graphql.cn/img/logo.svg', 66, 'Essential Notebook', 118.00, 'H5JJjJSj'),
(7, '2021-06-21 18:53:48.153000', '2021-06-21 18:53:48.153000', 'LEGO乐高机械族42125 法拉利488GTE赛车拼搭积木男孩女孩收藏', 'LEGO乐高机械族42125 法拉利488GTE赛车拼搭积木男孩女孩收藏', 'https://graphql.cn/img/logo.svg', 66, '乐高法拉利488', 1869.00, '1K7gdmNM');
/*!40000 ALTER TABLE `t_goods` ENABLE KEYS */;

-- 导出  表 graphql-demo.t_order 结构
CREATE TABLE IF NOT EXISTS `t_order` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `create_time` datetime(6) DEFAULT NULL,
    `update_time` datetime(6) DEFAULT NULL,
    `discount` decimal(19,2) DEFAULT NULL,
    `discount_amount` decimal(19,2) DEFAULT NULL,
    `goods_serial_no` varchar(255) DEFAULT NULL,
    `order_no` varchar(255) DEFAULT NULL,
    `original_amount` decimal(19,2) DEFAULT NULL,
    `userid` bigint(20) DEFAULT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4;

-- 正在导出表  graphql-demo.t_order 的数据：~12 rows (大约)
/*!40000 ALTER TABLE `t_order` DISABLE KEYS */;
INSERT INTO `t_order` (`id`, `create_time`, `update_time`, `discount`, `discount_amount`, `goods_serial_no`, `order_no`, `original_amount`, `userid`) VALUES
(13, '2021-06-22 10:23:06.601000', '2021-06-22 10:23:06.601000', 0.90, 66.60, 'pYmhjY58', '4bvd9i9pte', 74.00, 3),
(14, '2021-06-22 10:23:38.583000', '2021-06-22 10:23:38.583000', 0.90, 143.10, '3qlihuWg', 'jnZ5nnHiK1', 159.00, 3),
(15, '2021-06-22 10:23:45.893000', '2021-06-22 10:23:45.893000', 0.90, 259.20, 'vdjvwNjW', 'tFAyZo8DYE', 288.00, 3),
(16, '2021-06-22 10:23:54.562000', '2021-06-22 10:23:54.562000', 0.90, 5669.10, 'INEnt8OV', 'OlkhJzLUej', 6299.00, 3),
(17, '2021-06-22 10:24:01.914000', '2021-06-22 10:24:01.914000', 0.90, 1682.10, '1K7gdmNM', 'siSxjPn356', 1869.00, 3),
(18, '2021-06-22 10:24:09.921000', '2021-06-22 10:24:09.921000', 0.85, 100.30, 'H5JJjJSj', 'rbLhAgyCUa', 118.00, 4),
(19, '2021-06-22 10:24:15.119000', '2021-06-22 10:24:15.119000', 0.85, 135.15, '3qlihuWg', 'VbIwCbeI3O', 159.00, 4),
(20, '2021-06-22 10:24:20.419000', '2021-06-22 10:24:20.419000', 0.85, 62.90, 'pYmhjY58', 'oL7ddUvrnP', 74.00, 4),
(21, '2021-06-22 10:24:44.915000', '2021-06-22 10:24:44.915000', 0.80, 127.20, '3qlihuWg', 'H6snS9Nyv1', 159.00, 5),
(22, '2021-06-22 10:24:51.826000', '2021-06-22 10:24:51.826000', 0.80, 127.20, '3qlihuWg', 'RpuQA5ospX', 159.00, 5),
(23, '2021-06-22 10:24:57.448000', '2021-06-22 10:24:57.448000', 0.80, 59.20, 'pYmhjY58', 'wo9irE1ykw', 74.00, 5),
(24, '2021-06-22 10:25:02.539000', '2021-06-22 10:25:02.539000', 0.80, 94.40, 'H5JJjJSj', 'RWLr4PxacG', 118.00, 5),
(25, '2021-06-22 10:25:15.570000', '2021-06-22 10:25:15.570000', 0.80, 719.20, '5gqeGUEO', 'GivJBRVA7f', 899.00, 5);
/*!40000 ALTER TABLE `t_order` ENABLE KEYS */;

-- 导出  表 graphql-demo.t_user 结构
CREATE TABLE IF NOT EXISTS `t_user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `create_time` datetime(6) DEFAULT NULL,
    `update_time` datetime(6) DEFAULT NULL,
    `age` int(11) DEFAULT NULL,
    `birthday` date DEFAULT NULL,
    `gender` varchar(255) DEFAULT NULL,
    `img` varchar(255) DEFAULT NULL,
    `level` int(11) DEFAULT NULL,
    `nickname` varchar(255) DEFAULT NULL,
    `password` varchar(255) DEFAULT NULL,
    `username` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `UK_jhib4legehrm4yscx9t3lirqi` (`username`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- 正在导出表  graphql-demo.t_user 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;
INSERT INTO `t_user` (`id`, `create_time`, `update_time`, `age`, `birthday`, `gender`, `img`, `level`, `nickname`, `password`, `username`) VALUES
(3, '2021-06-18 10:26:10.914000', '2021-06-18 10:26:10.914000', 30, '1985-02-22', 'MALE', 'https://www.baidu.com', 1, '小明', '3A548574B23819E3AF577B795AB8A147', 'remylee'),
(4, '2021-06-21 19:02:34.540000', '2021-06-21 19:02:34.540000', 22, '1999-12-21', 'MALE', 'https://graphql.cn/img/logo.svg', 2, '杰克', '4D81FF7831351A0AEB58CC1719429002', 'jack'),
(5, '2021-06-21 19:03:18.924000', '2021-06-21 19:03:18.924000', 21, '2000-02-12', 'FEMALE', 'https://graphql.cn/img/logo.svg', 3, '柔丝', '08DF54DA47C5E343DA8ABD541FEF87F6', 'rose');
/*!40000 ALTER TABLE `t_user` ENABLE KEYS */;

-- 导出  表 graphql-demo.user_addresses 结构
CREATE TABLE IF NOT EXISTS `user_addresses` (
    `user_id` bigint(20) NOT NULL,
    `addresses` varchar(255) DEFAULT NULL,
    KEY `FKpws20r8ion9y4yrp5828uad38` (`user_id`),
    CONSTRAINT `FKpws20r8ion9y4yrp5828uad38` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 正在导出表  graphql-demo.user_addresses 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `user_addresses` DISABLE KEYS */;
INSERT INTO `user_addresses` (`user_id`, `addresses`) VALUES
(3, '上海'),
(3, '北京'),
(3, '重庆');
/*!40000 ALTER TABLE `user_addresses` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;