text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 10.82.27.177_3306
   Source Server Type    : MySQL
   Source Server Version : 50725
   Source Host           : 10.82.27.177:3306
   Source Schema         : ds0
  
   Target Server Type    : MySQL
   Target Server Version : 50725
   File Encoding         : 65001
  
   Date: 26/03/2019 14:37:22
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for dictionary
  -- ----------------------------
  DROP TABLE IF EXISTS `dictionary`;
  CREATE TABLE `dictionary`  (
    `dictionaryId` bigint(20) NOT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    PRIMARY KEY (`dictionaryId`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for order0
  -- ----------------------------
  DROP TABLE IF EXISTS `order0`;
  CREATE TABLE `order0`  (
    `orderId` bigint(32) NOT NULL,
    `userId` bigint(32) NOT NULL,
    `createTime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
    `totalPrice` int(10) NOT NULL,
    PRIMARY KEY (`orderId`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for order1
  -- ----------------------------
  DROP TABLE IF EXISTS `order1`;
  CREATE TABLE `order1`  (
    `orderId` bigint(32) NOT NULL,
    `userId` bigint(32) NOT NULL,
    `createTime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
    `totalPrice` int(10) NOT NULL,
    PRIMARY KEY (`orderId`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for order_item0
  -- ----------------------------
  DROP TABLE IF EXISTS `order_item0`;
  CREATE TABLE `order_item0`  (
    `orderItemId` bigint(32) NOT NULL,
    `orderId` bigint(32) NOT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `price` int(10) NOT NULL,
    `userId` bigint(20) NOT NULL DEFAULT 0,
    PRIMARY KEY (`orderItemId`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for order_item1
  -- ----------------------------
  DROP TABLE IF EXISTS `order_item1`;
  CREATE TABLE `order_item1`  (
    `orderItemId` bigint(32) NOT NULL,
    `orderId` bigint(32) NOT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `price` int(10) NOT NULL,
    `userId` bigint(20) NOT NULL DEFAULT 0,
    PRIMARY KEY (`orderItemId`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for user
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user`  (
    `userId` bigint(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `age` int(11) NOT NULL,
    PRIMARY KEY (`userId`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 317302985916940289 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  SET FOREIGN_KEY_CHECKS = 1;
  