text: SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for goods_order
  -- ----------------------------
  DROP TABLE IF EXISTS `goods_order`;
  CREATE TABLE `goods_order`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NULL DEFAULT NULL,
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    `price` decimal(10, 2) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;
  
  -- ----------------------------
  -- Records of goods_order
  -- ----------------------------
  BEGIN;
  INSERT INTO `goods_order` VALUES (1, 1, '购买商品1', 10.20), (2, 1, '购买商品2', 20.00), (3, 2, '购买商品3', 30.69);
  COMMIT;
  
  -- ----------------------------
  -- Table structure for idcard
  -- ----------------------------
  DROP TABLE IF EXISTS `idcard`;
  CREATE TABLE `idcard`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `card_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;
  
  -- ----------------------------
  -- Records of idcard
  -- ----------------------------
  BEGIN;
  INSERT INTO `idcard` VALUES (1, '330382198808140923'), (2, '330382198808140924');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for role
  -- ----------------------------
  DROP TABLE IF EXISTS `role`;
  CREATE TABLE `role`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;
  
  -- ----------------------------
  -- Records of role
  -- ----------------------------
  BEGIN;
  INSERT INTO `role` VALUES (1, 'admin'), (2, 'normal'), (3, 'base');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for user
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    `idcard_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;
  
  -- ----------------------------
  -- Records of user
  -- ----------------------------
  BEGIN;
  INSERT INTO `user` VALUES (1, 'Tony1', 'a123', '1'), (2, 'Tony2', 'c123', '2'), (4, 'Tony4', 'e123', NULL), (5, 'Tony5', 'f123', NULL), (6, 'Lilei_new2', NULL, NULL);
  COMMIT;
  
  -- ----------------------------
  -- Table structure for user_role_mapping
  -- ----------------------------
  DROP TABLE IF EXISTS `user_role_mapping`;
  CREATE TABLE `user_role_mapping`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NULL DEFAULT NULL,
    `role_id` int NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;
  
  -- ----------------------------
  -- Records of user_role_mapping
  -- ----------------------------
  BEGIN;
  INSERT INTO `user_role_mapping` VALUES (1, 1, 1), (2, 1, 2), (3, 2, 2);
  COMMIT;
  
  SET FOREIGN_KEY_CHECKS = 1;
  
  
  -- Update_20210908
  ALTER TABLE user ADD create_time datetime;
  ALTER TABLE user ADD update_time datetime;