From 53015845597b3e834f30a5c930aea7376db78bd7 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期四, 31 七月 2025 12:10:50 +0800
Subject: [PATCH] biz字典排序
---
doc/sql/mdm/mdm.mysql.all.create.sql | 54 +++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 53 insertions(+), 1 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 308f19a..3bf9113 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -42,6 +42,57 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥';
+DROP TABLE IF EXISTS `mdm_dbbak_config`;
+CREATE TABLE `mdm_dbbak_config` (
+ `id` bigint NOT NULL,
+ `name` varchar(100) NULL COMMENT '鍥惧彿锛岄浂缁勪欢鍙�',
+ `ip_addr` varchar(20) NOT NULL COMMENT '涓撲笟缁勯暱璐﹀彿',
+ `account` varchar(80) NOT NULL COMMENT '鏁版嵁搴撹处鍙�',
+ `passwd` varchar(80) NOT NULL COMMENT '鏁版嵁搴撳瘑鐮�',
+ `db_name` varchar(80) NOT NULL COMMENT '鏁版嵁搴撳悕绉�',
+ `db_port` int NOT NULL COMMENT '鏁版嵁搴撶鍙�',
+ `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+ `is_deleted` int DEFAULT 0,
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏁版嵁搴撳浠介厤缃�';
+
+
+DROP TABLE IF EXISTS `mdm_qinzhe_fgb`;
+CREATE TABLE `mdm_qinzhe_fgb` (
+ `cph` varchar(40) NULL COMMENT '浜у搧鍙�',
+ `ljh` varchar(80) NULL COMMENT '闆朵欢鍙�',
+ `ljmc` varchar(100) NULL COMMENT '闆朵欢鍚嶇О',
+ `zz` varchar(40) NULL COMMENT '涓诲埗',
+ `zzgd` varchar(40) NULL COMMENT '涓诲埗宸ユ',
+ `zggy` varchar(40) NULL COMMENT '涓荤宸ヨ壓',
+ `fg` varchar(40) NULL COMMENT '鍓',
+ `cjjhy` varchar(40) NULL COMMENT '杞﹂棿璁″垝鍛�',
+ `jhy` varchar(40) NULL COMMENT '璁″垝鍛�',
+ update_time datetime null COMMENT '鏇存柊鏃堕棿'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鍕ゅ摬鍒嗗伐琛ㄦ湰鍦颁复鏃惰〃';
+
+DROP TABLE IF EXISTS `v_寮犵珛铏巁2鍘備富鍒跺垎宸ヨ〃`;
+CREATE TABLE `v_寮犵珛铏巁2鍘備富鍒跺垎宸ヨ〃` (
+ `浜у搧鍙穈 varchar(40) NULL COMMENT '浜у搧鍙�',
+ `闆朵欢鍙穈 varchar(80) NULL COMMENT '闆朵欢鍙�',
+ `闆朵欢鍚嶇О` varchar(100) NULL COMMENT '闆朵欢鍚嶇О',
+ `涓诲埗` varchar(40) NULL COMMENT '涓诲埗',
+ `闆朵欢绛夌骇` varchar(40) NULL COMMENT '闆朵欢绛夌骇',
+ `鏈哄瀷` varchar(40) NULL COMMENT '鏈哄瀷',
+ `鍨嬪埆` varchar(40) NULL COMMENT '鍨嬪埆',
+ `渚濇嵁` varchar(40) NULL COMMENT '渚濇嵁',
+ `涓诲埗宸ユ` varchar(40) NULL COMMENT '涓诲埗宸ユ',
+ `涓荤宸ヨ壓` varchar(40) NULL COMMENT '涓荤宸ヨ壓',
+ `鍓` varchar(40) NULL COMMENT '鍓',
+ `鏄惁鍏抽敭浠禶 varchar(40) NULL COMMENT '鏄惁鍏抽敭浠�',
+ `澶囨敞` varchar(40) NULL COMMENT '澶囨敞',
+ `闆朵欢缂栧彿` varchar(40) NULL COMMENT '闆朵欢缂栧彿',
+ `杞﹂棿璁″垝鍛榒 varchar(40) NULL COMMENT '杞﹂棿璁″垝鍛�',
+ `璁″垝鍛榒 varchar(40) NULL COMMENT '璁″垝鍛�'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鍕ゅ摬鍒嗗伐琛ㄨ鍥炬ā鎷�';
+
+
+
DROP TABLE IF EXISTS `mdm_produce_division`;
CREATE TABLE `mdm_produce_division` (
`id` bigint NOT NULL,
@@ -51,7 +102,7 @@
`checker_id` bigint NOT NULL COMMENT '鏍″鍛樿处鍙凤紙宸ヨ壓鍛樿鑹诧級',
`senior_id` bigint NOT NULL COMMENT '瀹℃壒楂樺笀璐﹀彿',
- `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '绉熸埛ID',
+ `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '绉熸埛ID',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
`is_deleted` int DEFAULT 0,
@@ -63,6 +114,7 @@
UNIQUE KEY `uniqueCheckIndex` (`team_leader_id`,`programmer_id`,`checker_id`,`senior_id`,`is_deleted`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='涓诲埗鍒嗗伐琛�';
+
DROP TABLE IF EXISTS `mdm_nc_node`;
CREATE TABLE `mdm_nc_node` (
`id` bigint NOT NULL,
--
Gitblit v1.9.3