From f1e8ef7d00fc176d5cba60f3f8b8c10a8541bd71 Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期一, 14 四月 2025 16:07:37 +0800 Subject: [PATCH] 代码优化 --- pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_test.sql | 33 +++++++++++++++++++++++++++++++++ 1 files changed, 33 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_test.sql b/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_test.sql new file mode 100644 index 0000000..8cfb169 --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_test.sql @@ -0,0 +1,33 @@ +/* + Navicat Premium Data Transfer + + Source Server : 鏈満mysql8.0.34 + Source Server Type : MySQL + Source Server Version : 80034 + Source Host : localhost:3306 + Source Schema : pipirr_ym + + Target Server Type : MySQL + Target Server Version : 80034 + File Encoding : 65001 + + Date: 18/10/2023 10:35:54 +*/ + +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +-- ---------------------------- +-- Table structure for ba_test +-- ---------------------------- +DROP TABLE IF EXISTS demo_test; +CREATE TABLE `ba_test` ( + `id` bigint NOT NULL, + `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, + `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, + `nick_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, + `create_dt` varchar(19) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; + +SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.8.0