db/clothes_order_system.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : mydb
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : clothes_order_system

Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001

Date: 2017-07-31 17:34:00
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1e20c739-b307-40da-946e-db4a73523333', '裙子', '女孩子穿的');
INSERT INTO `category` VALUES ('34764acf-0579-484e-b160-3eb2adc681c7', '帽子', '头戴的');
INSERT INTO `category` VALUES ('893a179e-3e9b-4c62-aa40-e327152e4cbb', '短袖', '短袖子的上衣');
INSERT INTO `category` VALUES ('ac42ce46-21a2-45a8-8893-5c2ab431a7bb', '裤子', '下身的衣服');

-- ----------------------------
-- Table structure for clothes
-- ----------------------------
DROP TABLE IF EXISTS `clothes`;
CREATE TABLE `clothes` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `brand` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `price` double NOT NULL,
  `image` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_id` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `category_id_FK` (`category_id`),
  CONSTRAINT `category_id_FK` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of clothes
-- ----------------------------
INSERT INTO `clothes` VALUES ('00a434ca-8136-4313-888d-422e986b8384', '短袖2', '中国造', '150', '4b03f4ed-6bf5-449f-967c-aa0d46d991fe.jpg', '中国造短袖2', '893a179e-3e9b-4c62-aa40-e327152e4cbb');
INSERT INTO `clothes` VALUES ('3a588112-5dad-4523-9c32-7a16ea0cbc19', '帽子1', '中国造', '20', '1126d842-7f6c-4bd7-a9e8-ebb2e3caa923.jpg', '中国造帽子1', '34764acf-0579-484e-b160-3eb2adc681c7');