From 1a2b07f01ba4616fd9e894dddf474b56d020158c Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期一, 07 四月 2025 15:18:51 +0800 Subject: [PATCH] 整理版本 --- pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_user.sql | 38 ++++++++++++++++++++++++++++++++++++++ 1 files changed, 38 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_user.sql b/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_user.sql new file mode 100644 index 0000000..d0bb9a4 --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/resources/sql/ba_user.sql @@ -0,0 +1,38 @@ +/* + 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: 21/10/2023 16:24:42 +*/ + +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +-- ---------------------------- +-- Table structure for bauser +-- ---------------------------- +DROP TABLE IF EXISTS `ba_user`; +CREATE TABLE `ba_user` ( + `id` bigint NOT NULL, + `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鐢ㄦ埛濮撳悕', + `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鎵嬫満鍙凤紝鐢ㄤ簬鐧诲綍绯荤粺', + `password` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '瀵嗙爜锛宮d5鍔犲瘑', + `orgTag` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '鐢ㄦ埛鎵�鏈夋満鏋勬爣绛�', + `supperAdmin` tinyint NULL DEFAULT NULL COMMENT '鏄惁瓒呯骇绠＄悊鍛橈紝1鏄紝0鍚�', + `disabled` tinyint NULL DEFAULT NULL COMMENT '鏄惁绂佺敤锛�1鏄紝0鍚�', + `deleted` tinyint NULL DEFAULT NULL COMMENT '鍒犻櫎鏍囧織锛�1鏄紝0鍚�', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; + +ALTER TABLE ba_user COMMENT '鐢ㄦ埛琛�'; + +SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.8.0