

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `priority` int NOT NULL DEFAULT 0 COMMENT '权值',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间戳',
  `last_edit_time` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间戳',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES (10, '南京', 5, '2022-03-11 12:53:53', '2022-03-11 12:53:53');
INSERT INTO `area` VALUES (11, '北京', 9, '2022-03-11 12:59:38', '2022-03-11 12:59:38');

SET FOREIGN_KEY_CHECKS = 1;
