pipIrr-SV.git - Gitblit

New file
			@@ -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 '密码，md5加密',
			`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;