graphql-demo/graphql-demo.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 5446
#
# https://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.26-log)
# Database: graphql-demo
# Generation Time: 2021-06-16 16:03:20 +0000
# ************************************************************


/*!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 */;
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 */;


# Dump of table hibernate_sequence
# ------------------------------------------------------------

DROP TABLE IF EXISTS `hibernate_sequence`;

CREATE TABLE `hibernate_sequence` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `hibernate_sequence` WRITE;
/*!40000 ALTER TABLE `hibernate_sequence` DISABLE KEYS */;

INSERT INTO `hibernate_sequence` (`next_val`)
VALUES
	(13);

/*!40000 ALTER TABLE `hibernate_sequence` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table t_goods
# ------------------------------------------------------------

DROP TABLE IF EXISTS `t_goods`;

CREATE TABLE `t_goods` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `serial_no` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `item_count` int(11) DEFAULT NULL,
  `price` decimal(19,2) DEFAULT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

LOCK TABLES `t_goods` WRITE;
/*!40000 ALTER TABLE `t_goods` DISABLE KEYS */;

INSERT INTO `t_goods` (`id`, `serial_no`, `name`, `description`, `detail`, `img`, `item_count`, `price`, `create_time`, `update_time`)
VALUES
	(1,'66cc70b7-ed48-4de8-98e9-6dcccf3502ee','奶嘴','宝宝使用','宝宝使用','https://www.baidu.com/img',100,32.48,'2021-04-25 16:13:58.855000','2021-04-25 16:13:58.855000'),
	(2,'de7c321e-bdab-456f-a6a4-d6071c9a4624','面包机','很好用的面包机','面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机面包机','http://www.bing.com',10,2999.10,'2021-06-15 16:47:23.766000','2021-06-15 16:47:23.766000'),
	(6,'649f693c-fcd0-4200-a2bc-39975183ba15','咖啡机','德龙意式咖啡机','德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机','http://www.bing.com',16,3999.10,'2021-06-15 16:51:12.206000','2021-06-15 16:51:12.206000'),
	(7,'96ecfa25-e627-4bd1-a0a6-1fc4116c8200','指甲剪','指甲剪','指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪','http://www.bing.com',99,9.99,'2021-06-15 17:12:48.388000','2021-06-15 17:12:48.388000'),
	(8,'JM9Nv3Jj','咖啡机222','德龙意式咖啡机111111','德11w1w1w212121212龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机德龙意式咖啡机','http://www.bing.com',161,3999.11,'2021-06-16 10:57:34.025000','2021-06-16 10:57:34.025000'),
	(9,'RyhPJM2n','指甲剪','指甲剪','指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪指甲剪','http://www.bing.com',99,9.99,'2021-06-16 11:35:04.943000','2021-06-16 11:35:04.943000');

/*!40000 ALTER TABLE `t_goods` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table t_order
# ------------------------------------------------------------

DROP TABLE IF EXISTS `t_order`;

CREATE TABLE `t_order` (
  `id` int(11) unsigned 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

LOCK TABLES `t_order` WRITE;
/*!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`)
VALUES
	(10,'2021-06-16 14:35:26.491000','2021-06-16 14:35:26.491000',0.70,2799.37,'649f693c-fcd0-4200-a2bc-39975183ba15','1XaTLEz6jC',3999.10),
	(11,'2021-06-16 14:37:23.664000','2021-06-16 14:37:23.664000',1.00,3999.10,'649f693c-fcd0-4200-a2bc-39975183ba15','m4XMJ86y9m',3999.10),
	(12,'2021-06-16 14:50:19.134000','2021-06-16 14:50:19.134000',0.85,3399.24,'649f693c-fcd0-4200-a2bc-39975183ba15','7XcJh9SdaS',3999.10);

/*!40000 ALTER TABLE `t_order` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table t_user
# ------------------------------------------------------------

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;