MySql数据表创建并新增数据

-- ----------------------------
-- Table structure for bs002h
-- ----------------------------
DROP TABLE IF EXISTS `bs002h`;
CREATE TABLE `bs002h`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cr_time` datetime(6) NOT NULL,
  `rg_time` datetime(6) NOT NULL,
  `cr_user` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `rg_user` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `code` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `rmk` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `order` smallint(5) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `code`(`code`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of bs002h
-- ----------------------------
INSERT INTO `bs002h` VALUES (1, '2020-12-04 05:25:55.000000', '2021-04-26 01:51:50.000000', NULL, NULL, '1', '月结', NULL, 1);
INSERT INTO `bs002h` VALUES (2, '2021-04-26 01:51:39.000000', '2021-04-26 01:51:39.000000', NULL, NULL, '2', '日结', NULL, 2);