From 46a31eb418eba03911fce1c19530a8deaa917d05 Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期三, 24 六月 2026 11:15:30 +0800 Subject: [PATCH] 初始化项目 --- docs/database_schema.sql | 1726 +++++++++++++++++++++++++++++----------------------------- 1 files changed, 863 insertions(+), 863 deletions(-) diff --git a/docs/database_schema.sql b/docs/database_schema.sql index 3e7b25f..e5b76dd 100644 --- a/docs/database_schema.sql +++ b/docs/database_schema.sql @@ -19,869 +19,869 @@ -- ===================================================== -- 1.1 绠＄悊鍚庡彴鐢ㄦ埛琛� -CREATE TABLE `system_users` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鐢ㄦ埛ID', - `username` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛璐﹀彿', - `password` varchar(100) DEFAULT NULL COMMENT '鍔犲瘑鍚庣殑瀵嗙爜', - `nickname` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛鏄电О', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `dept_id` bigint DEFAULT NULL COMMENT '閮ㄩ棬ID', - `post_ids` json DEFAULT NULL COMMENT '宀椾綅缂栧彿鏁扮粍', - `email` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛閭', - `mobile` varchar(100) DEFAULT NULL COMMENT '鎵嬫満鍙风爜', - `sex` tinyint DEFAULT NULL COMMENT '鐢ㄦ埛鎬у埆', - `avatar` varchar(255) DEFAULT NULL COMMENT '鐢ㄦ埛澶村儚', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '甯愬彿鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `login_ip` varchar(50) DEFAULT NULL COMMENT '鏈�鍚庣櫥褰旾P', - `login_date` datetime DEFAULT NULL COMMENT '鏈�鍚庣櫥褰曟椂闂�', - `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='绠＄悊鍚庡彴鐢ㄦ埛琛�'; - --- 1.2 閮ㄩ棬琛� -CREATE TABLE `system_dept` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '閮ㄩ棬ID', - `name` varchar(100) DEFAULT NULL COMMENT '閮ㄩ棬鍚嶇О', - `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '鐖堕儴闂↖D', - `sort` int NOT NULL DEFAULT '0' COMMENT '鏄剧ず椤哄簭', - `leader_user_id` bigint DEFAULT NULL COMMENT '璐熻矗浜�', - `phone` varchar(50) DEFAULT NULL COMMENT '鑱旂郴鐢佃瘽', - `email` varchar(100) DEFAULT NULL COMMENT '閭', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '閮ㄩ棬鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='閮ㄩ棬琛�'; - --- 1.3 宀椾綅琛� -CREATE TABLE `system_post` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '宀椾綅搴忓彿', - `name` varchar(100) DEFAULT NULL COMMENT '宀椾綅鍚嶇О', - `code` varchar(100) DEFAULT NULL COMMENT '宀椾綅缂栫爜', - `sort` int NOT NULL DEFAULT '0' COMMENT '宀椾綅鎺掑簭', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='宀椾綅琛�'; - --- 1.4 鐢ㄦ埛宀椾綅鍏宠仈琛� -CREATE TABLE `system_user_post` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛ID', - `post_id` bigint NOT NULL COMMENT '宀椾綅ID', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='鐢ㄦ埛宀椾綅鍏宠仈琛�'; - --- 1.5 瀛楀吀绫诲瀷琛� -CREATE TABLE `system_dict_type` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '瀛楀吀涓婚敭', - `name` varchar(100) DEFAULT NULL COMMENT '瀛楀吀鍚嶇О', - `type` varchar(100) DEFAULT NULL COMMENT '瀛楀吀绫诲瀷', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `deleted_time` datetime DEFAULT NULL COMMENT '鍒犻櫎鏃堕棿', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='瀛楀吀绫诲瀷琛�'; - --- 1.6 瀛楀吀鏁版嵁琛� -CREATE TABLE `system_dict_data` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '瀛楀吀鏁版嵁缂栧彿', - `sort` int NOT NULL DEFAULT '0' COMMENT '瀛楀吀鎺掑簭', - `label` varchar(100) DEFAULT NULL COMMENT '瀛楀吀鏍囩', - `value` varchar(100) DEFAULT NULL COMMENT '瀛楀吀鍊�', - `dict_type` varchar(100) DEFAULT NULL COMMENT '瀛楀吀绫诲瀷', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `color_type` varchar(50) DEFAULT NULL COMMENT '棰滆壊绫诲瀷', - `css_class` varchar(100) DEFAULT NULL COMMENT 'css鏍峰紡', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='瀛楀吀鏁版嵁琛�'; - --- 1.7 鐧诲綍鏃ュ織琛� -CREATE TABLE `system_login_log` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鏃ュ織涓婚敭', - `log_type` tinyint NOT NULL COMMENT '鏃ュ織绫诲瀷', - `trace_id` varchar(64) DEFAULT NULL COMMENT '閾捐矾杩借釜缂栧彿', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', - `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `username` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛璐﹀彿', - `result` tinyint NOT NULL COMMENT '鐧诲綍缁撴灉', - `user_ip` varchar(50) DEFAULT NULL COMMENT '鐢ㄦ埛IP', - `user_agent` varchar(512) DEFAULT NULL COMMENT '娴忚鍣║A', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='鐧诲綍鏃ュ織琛�'; - --- 1.8 鎿嶄綔鏃ュ織琛� -CREATE TABLE `system_operate_log` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鏃ュ織涓婚敭', - `trace_id` varchar(64) DEFAULT NULL COMMENT '閾捐矾杩借釜缂栧彿', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', - `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `type` varchar(100) DEFAULT NULL COMMENT '鎿嶄綔妯″潡绫诲瀷', - `sub_type` varchar(100) DEFAULT NULL COMMENT '鎿嶄綔鍚�', - `biz_id` bigint DEFAULT NULL COMMENT '鎿嶄綔妯″潡涓氬姟缂栧彿', - `action` varchar(2000) DEFAULT NULL COMMENT '鏃ュ織鍐呭', - `extra` varchar(2000) DEFAULT NULL COMMENT '鎷撳睍瀛楁', - `request_method` varchar(50) DEFAULT NULL COMMENT '璇锋眰鏂规硶鍚�', - `request_url` varchar(255) DEFAULT NULL COMMENT '璇锋眰鍦板潃', - `user_ip` varchar(50) DEFAULT NULL COMMENT '鐢ㄦ埛IP', - `user_agent` varchar(512) DEFAULT NULL COMMENT '娴忚鍣║A', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='鎿嶄綔鏃ュ織琛�'; - --- 1.9 閫氱煡鍏憡琛� -CREATE TABLE `system_notice` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鍏憡ID', - `title` varchar(200) DEFAULT NULL COMMENT '鍏憡鏍囬', - `type` tinyint NOT NULL COMMENT '鍏憡绫诲瀷', - `content` text COMMENT '鍏憡鍐呭', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鍏憡鐘舵�侊紙0姝ｅ父 1鍏抽棴锛�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='閫氱煡鍏憡琛�'; - --- 1.10 鑿滃崟琛� -CREATE TABLE `system_menu` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑿滃崟缂栧彿', - `name` varchar(100) DEFAULT NULL COMMENT '鑿滃崟鍚嶇О', - `permission` varchar(100) DEFAULT NULL COMMENT '鏉冮檺鏍囪瘑', - `type` tinyint NOT NULL COMMENT '鑿滃崟绫诲瀷', - `sort` int NOT NULL DEFAULT '0' COMMENT '鏄剧ず椤哄簭', - `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '鐖惰彍鍗旾D', - `path` varchar(255) DEFAULT NULL COMMENT '璺敱鍦板潃', - `icon` varchar(100) DEFAULT NULL COMMENT '鑿滃崟鍥炬爣', - `component` varchar(255) DEFAULT NULL COMMENT '缁勪欢璺緞', - `component_name` varchar(100) DEFAULT NULL COMMENT '缁勪欢鍚�', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `visible` bit(1) DEFAULT b'1' COMMENT '鏄惁鍙', - `keep_alive` bit(1) DEFAULT b'1' COMMENT '鏄惁缂撳瓨', - `always_show` bit(1) DEFAULT b'1' COMMENT '鏄惁鎬绘槸鏄剧ず', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='鑿滃崟琛�'; - --- 1.11 瑙掕壊琛� -CREATE TABLE `system_role` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '瑙掕壊ID', - `name` varchar(100) DEFAULT NULL COMMENT '瑙掕壊鍚嶇О', - `code` varchar(100) DEFAULT NULL COMMENT '瑙掕壊鏍囪瘑', - `sort` int NOT NULL DEFAULT '0' COMMENT '瑙掕壊鎺掑簭', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '瑙掕壊鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `type` tinyint NOT NULL COMMENT '瑙掕壊绫诲瀷', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `data_scope` tinyint DEFAULT NULL COMMENT '鏁版嵁鑼冨洿', - `data_scope_dept_ids` json DEFAULT NULL COMMENT '鏁版嵁鑼冨洿(鎸囧畾閮ㄩ棬鏁扮粍)', - `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='瑙掕壊琛�'; - --- 1.12 瑙掕壊鑿滃崟鍏宠仈琛� -CREATE TABLE `system_role_menu` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭', - `role_id` bigint NOT NULL COMMENT '瑙掕壊ID', - `menu_id` bigint NOT NULL COMMENT '鑿滃崟ID', - `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='瑙掕壊鑿滃崟鍏宠仈琛�'; - --- 1.13 鐢ㄦ埛瑙掕壊鍏宠仈琛� -CREATE TABLE `system_user_role` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛ID', - `role_id` bigint NOT NULL COMMENT '瑙掕壊ID', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='鐢ㄦ埛瑙掕壊鍏宠仈琛�'; - --- 1.14 鐭俊娓犻亾琛� -CREATE TABLE `system_sms_channel` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '娓犻亾缂栧彿', - `signature` varchar(100) DEFAULT NULL COMMENT '鐭俊绛惧悕', - `code` varchar(100) DEFAULT NULL COMMENT '娓犻亾缂栫爜', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鍚敤鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `api_key` varchar(255) DEFAULT NULL COMMENT '鐭俊API鐨勮处鍙�', - `api_secret` varchar(255) DEFAULT NULL COMMENT '鐭俊API鐨勫瘑閽�', - `callback_url` varchar(255) DEFAULT NULL COMMENT '鐭俊鍙戦�佸洖璋僓RL', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='鐭俊娓犻亾琛�'; - --- 1.15 鎵嬫満楠岃瘉鐮佽〃 -CREATE TABLE `system_sms_code` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `mobile` varchar(20) DEFAULT NULL COMMENT '鎵嬫満鍙�', - `code` varchar(20) DEFAULT NULL COMMENT '楠岃瘉鐮�', - `scene` tinyint NOT NULL COMMENT '鍙戦�佸満鏅�', - `create_ip` varchar(50) DEFAULT NULL COMMENT '鍒涘缓IP', - `today_index` int DEFAULT NULL COMMENT '浠婃棩鍙戦�佺殑绗嚑鏉�', - `used` bit(1) DEFAULT b'0' COMMENT '鏄惁浣跨敤', - `used_time` datetime DEFAULT NULL COMMENT '浣跨敤鏃堕棿', - `used_ip` varchar(50) DEFAULT NULL COMMENT '浣跨敤IP', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`), - KEY `idx_mobile` (`mobile`) -) ENGINE=InnoDB COMMENT='鎵嬫満楠岃瘉鐮佽〃'; - --- 1.16 鐭俊妯℃澘琛� -CREATE TABLE `system_sms_template` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷缂栧彿', - `type` tinyint NOT NULL COMMENT '鐭俊绫诲瀷', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鍚敤鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `code` varchar(100) DEFAULT NULL COMMENT '妯℃澘缂栫爜', - `name` varchar(100) DEFAULT NULL COMMENT '妯℃澘鍚嶇О', - `content` varchar(500) DEFAULT NULL COMMENT '妯℃澘鍐呭', - `params` json DEFAULT NULL COMMENT '鍙傛暟鏁扮粍', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `api_template_id` varchar(100) DEFAULT NULL COMMENT '鐭俊API鐨勬ā鏉跨紪鍙�', - `channel_id` bigint DEFAULT NULL COMMENT '鐭俊娓犻亾缂栧彿', - `channel_code` varchar(100) DEFAULT NULL COMMENT '鐭俊娓犻亾缂栫爜', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='鐭俊妯℃澘琛�'; - --- 1.17 鐭俊鏃ュ織琛� -CREATE TABLE `system_sms_log` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷缂栧彿', - `channel_id` bigint DEFAULT NULL COMMENT '鐭俊娓犻亾缂栧彿', - `channel_code` varchar(100) DEFAULT NULL COMMENT '鐭俊娓犻亾缂栫爜', - `template_id` bigint DEFAULT NULL COMMENT '妯℃澘缂栧彿', - `template_code` varchar(100) DEFAULT NULL COMMENT '妯℃澘缂栫爜', - `template_type` tinyint DEFAULT NULL COMMENT '鐭俊绫诲瀷', - `template_content` varchar(500) DEFAULT NULL COMMENT '妯℃澘鍐呭', - `template_params` json DEFAULT NULL COMMENT '妯℃澘鍙傛暟', - `api_template_id` varchar(100) DEFAULT NULL COMMENT '鐭俊API鐨勬ā鏉跨紪鍙�', - `mobile` varchar(20) DEFAULT NULL COMMENT '鎵嬫満鍙�', - `user_id` bigint DEFAULT NULL COMMENT '鐢ㄦ埛缂栧彿', - `user_type` tinyint DEFAULT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `send_status` tinyint NOT NULL DEFAULT '0' COMMENT '鍙戦�佺姸鎬�', - `send_time` datetime DEFAULT NULL COMMENT '鍙戦�佹椂闂�', - `api_send_code` varchar(100) DEFAULT NULL COMMENT '鐭俊API鍙戦�佺粨鏋滅殑缂栫爜', - `api_send_msg` varchar(500) DEFAULT NULL COMMENT '鐭俊API鍙戦�佸け璐ョ殑鎻愮ず', - `api_request_id` varchar(100) DEFAULT NULL COMMENT '鐭俊API鍙戦�佽繑鍥炵殑鍞竴璇锋眰ID', - `api_serial_no` varchar(100) DEFAULT NULL COMMENT '鐭俊API鍙戦�佽繑鍥炵殑搴忓彿', - `receive_status` tinyint NOT NULL DEFAULT '0' COMMENT '鎺ユ敹鐘舵��', - `receive_time` datetime DEFAULT NULL COMMENT '鎺ユ敹鏃堕棿', - `api_receive_code` varchar(100) DEFAULT NULL COMMENT '鐭俊API鎺ユ敹缁撴灉鐨勭紪鐮�', - `api_receive_msg` varchar(500) DEFAULT NULL COMMENT '鐭俊API鎺ユ敹缁撴灉鐨勬彁绀�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='鐭俊鏃ュ織琛�'; - --- 1.18 绀句氦瀹㈡埛绔〃 -CREATE TABLE `system_social_client` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `name` varchar(100) DEFAULT NULL COMMENT '搴旂敤鍚�', - `social_type` tinyint NOT NULL COMMENT '绀句氦绫诲瀷', - `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `client_id` varchar(255) DEFAULT NULL COMMENT '瀹㈡埛绔痠d', - `client_secret` varchar(255) DEFAULT NULL COMMENT '瀹㈡埛绔疭ecret', - `agent_id` varchar(100) DEFAULT NULL COMMENT '浠ｇ悊缂栧彿', - `public_key` varchar(512) DEFAULT NULL COMMENT 'publicKey鍏挜', - `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='绀句氦瀹㈡埛绔〃'; - --- 1.19 绀句氦鐢ㄦ埛琛� -CREATE TABLE `system_social_user` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭', - `type` tinyint NOT NULL COMMENT '绀句氦骞冲彴鐨勭被鍨�', - `openid` varchar(100) DEFAULT NULL COMMENT '绀句氦openid', - `token` varchar(255) DEFAULT NULL COMMENT '绀句氦token', - `raw_token_info` text COMMENT '鍘熷Token鏁版嵁', - `nickname` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛鏄电О', - `avatar` varchar(255) DEFAULT NULL COMMENT '鐢ㄦ埛澶村儚', - `raw_user_info` text COMMENT '鍘熷鐢ㄦ埛鏁版嵁', - `code` varchar(100) DEFAULT NULL COMMENT '鏈�鍚庝竴娆＄殑璁よ瘉code', - `state` varchar(100) DEFAULT NULL COMMENT '鏈�鍚庝竴娆＄殑璁よ瘉state', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='绀句氦鐢ㄦ埛琛�'; - --- 1.20 绀句氦鐢ㄦ埛缁戝畾琛� -CREATE TABLE `system_social_user_bind` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `user_id` bigint NOT NULL COMMENT '鍏宠仈鐨勭敤鎴风紪鍙�', - `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `social_user_id` bigint NOT NULL COMMENT '绀句氦骞冲彴鐨勭敤鎴风紪鍙�', - `social_type` tinyint NOT NULL COMMENT '绀句氦骞冲彴鐨勭被鍨�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='绀句氦鐢ㄦ埛缁戝畾琛�'; - --- 1.21 绉熸埛琛� -CREATE TABLE `system_tenant` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '绉熸埛缂栧彿', - `name` varchar(100) DEFAULT NULL COMMENT '绉熸埛鍚�', - `contact_user_id` bigint DEFAULT NULL COMMENT '鑱旂郴浜虹殑鐢ㄦ埛缂栧彿', - `contact_name` varchar(100) DEFAULT NULL COMMENT '鑱旂郴浜�', - `contact_mobile` varchar(50) DEFAULT NULL COMMENT '鑱旂郴鎵嬫満', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '绉熸埛鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `websites` json DEFAULT NULL COMMENT '缁戝畾鍩熷悕鍒楄〃', - `package_id` bigint DEFAULT NULL COMMENT '绉熸埛濂楅缂栧彿', - `expire_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', - `account_count` int DEFAULT NULL COMMENT '璐﹀彿鏁伴噺', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='绉熸埛琛�'; - --- 1.22 绉熸埛濂楅琛� -CREATE TABLE `system_tenant_package` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '濂楅缂栧彿', - `name` varchar(100) DEFAULT NULL COMMENT '濂楅鍚�', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '绉熸埛濂楅鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `menu_ids` json DEFAULT NULL COMMENT '鍏宠仈鐨勮彍鍗曠紪鍙�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='绉熸埛濂楅琛�'; - --- 1.23 閭璐﹀彿琛� -CREATE TABLE `system_mail_account` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', - `mail` varchar(100) DEFAULT NULL COMMENT '閭', - `username` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛鍚�', - `password` varchar(100) DEFAULT NULL COMMENT '瀵嗙爜', - `host` varchar(100) DEFAULT NULL COMMENT 'SMTP鏈嶅姟鍣ㄥ煙鍚�', - `port` int DEFAULT NULL COMMENT 'SMTP鏈嶅姟鍣ㄧ鍙�', - `ssl_enable` bit(1) DEFAULT b'0' COMMENT '鏄惁寮�鍚疭SL', - `starttls_enable` bit(1) DEFAULT b'0' COMMENT '鏄惁寮�鍚疭TARTTLS', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='閭璐﹀彿琛�'; - --- 1.24 閭欢妯＄増琛� -CREATE TABLE `system_mail_template` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', - `name` varchar(100) DEFAULT NULL COMMENT '妯＄増鍚嶇О', - `code` varchar(100) DEFAULT NULL COMMENT '妯＄増缂栧彿', - `account_id` bigint DEFAULT NULL COMMENT '鍙戦�佺殑閭璐﹀彿缂栧彿', - `nickname` varchar(100) DEFAULT NULL COMMENT '鍙戦�佷汉鍚嶇О', - `title` varchar(255) DEFAULT NULL COMMENT '鏍囬', - `content` text COMMENT '鍐呭', - `params` json DEFAULT NULL COMMENT '鍙傛暟鏁扮粍', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='閭欢妯＄増琛�'; - --- 1.25 閭鏃ュ織琛� -CREATE TABLE `system_mail_log` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鏃ュ織缂栧彿', - `user_id` bigint DEFAULT NULL COMMENT '鐢ㄦ埛缂栫爜', - `user_type` tinyint DEFAULT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `to_mails` json DEFAULT NULL COMMENT '鎺ユ敹閭鍦板潃', - `cc_mails` json DEFAULT NULL COMMENT '鎶勯�侀偖绠卞湴鍧�', - `bcc_mails` json DEFAULT NULL COMMENT '瀵嗛�侀偖绠卞湴鍧�', - `account_id` bigint DEFAULT NULL COMMENT '閭璐﹀彿缂栧彿', - `from_mail` varchar(100) DEFAULT NULL COMMENT '鍙戦�侀偖绠卞湴鍧�', - `template_id` bigint DEFAULT NULL COMMENT '妯＄増缂栧彿', - `template_code` varchar(100) DEFAULT NULL COMMENT '妯＄増缂栫爜', - `template_nickname` varchar(100) DEFAULT NULL COMMENT '妯＄増鍙戦�佷汉鍚嶇О', - `template_title` varchar(255) DEFAULT NULL COMMENT '妯＄増鏍囬', - `template_content` text COMMENT '妯＄増鍐呭', - `template_params` json DEFAULT NULL COMMENT '妯＄増鍙傛暟', - `send_status` tinyint NOT NULL DEFAULT '0' COMMENT '鍙戦�佺姸鎬�', - `send_time` datetime DEFAULT NULL COMMENT '鍙戦�佹椂闂�', - `send_message_id` varchar(255) DEFAULT NULL COMMENT '鍙戦�佽繑鍥炵殑娑堟伅ID', - `send_exception` varchar(500) DEFAULT NULL COMMENT '鍙戦�佸紓甯�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='閭鏃ュ織琛�'; - --- 1.26 绔欏唴淇℃ā鐗堣〃 -CREATE TABLE `system_notify_template` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID', - `name` varchar(100) DEFAULT NULL COMMENT '妯＄増鍚嶇О', - `code` varchar(100) DEFAULT NULL COMMENT '妯＄増缂栫爜', - `type` tinyint NOT NULL COMMENT '妯＄増绫诲瀷', - `nickname` varchar(100) DEFAULT NULL COMMENT '鍙戦�佷汉鍚嶇О', - `content` varchar(500) DEFAULT NULL COMMENT '妯＄増鍐呭', - `params` json DEFAULT NULL COMMENT '鍙傛暟鏁扮粍', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='绔欏唴淇℃ā鐗堣〃'; - --- 1.27 绔欏唴淇¤〃 -CREATE TABLE `system_notify_message` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '绔欏唴淇＄紪鍙�', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', - `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `template_id` bigint DEFAULT NULL COMMENT '妯＄増缂栧彿', - `template_code` varchar(100) DEFAULT NULL COMMENT '妯＄増缂栫爜', - `template_type` tinyint DEFAULT NULL COMMENT '妯＄増绫诲瀷', - `template_nickname` varchar(100) DEFAULT NULL COMMENT '妯＄増鍙戦�佷汉鍚嶇О', - `template_content` varchar(500) DEFAULT NULL COMMENT '妯＄増鍐呭', - `template_params` json DEFAULT NULL COMMENT '妯＄増鍙傛暟', - `read_status` bit(1) DEFAULT b'0' COMMENT '鏄惁宸茶', - `read_time` datetime DEFAULT NULL COMMENT '闃呰鏃堕棿', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='绔欏唴淇¤〃'; - --- 1.28 OAuth2瀹㈡埛绔〃 -CREATE TABLE `system_oauth2_client` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', - `secret` varchar(255) DEFAULT NULL COMMENT '瀹㈡埛绔瘑閽�', - `name` varchar(100) DEFAULT NULL COMMENT '搴旂敤鍚�', - `logo` varchar(255) DEFAULT NULL COMMENT '搴旂敤鍥炬爣', - `description` varchar(500) DEFAULT NULL COMMENT '搴旂敤鎻忚堪', - `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', - `access_token_validity_seconds` int DEFAULT NULL COMMENT '璁块棶浠ょ墝鐨勬湁鏁堟湡', - `refresh_token_validity_seconds` int DEFAULT NULL COMMENT '鍒锋柊浠ょ墝鐨勬湁鏁堟湡', - `redirect_uris` json DEFAULT NULL COMMENT '鍙噸瀹氬悜鐨刄RI鍦板潃', - `authorized_grant_types` json DEFAULT NULL COMMENT '鎺堟潈绫诲瀷', - `scopes` json DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', - `auto_approve_scopes` json DEFAULT NULL COMMENT '鑷姩鎺堟潈鐨凷cope', - `authorities` json DEFAULT NULL COMMENT '鏉冮檺', - `resource_ids` json DEFAULT NULL COMMENT '璧勬簮', - `additional_information` varchar(2000) DEFAULT NULL COMMENT '闄勫姞淇℃伅', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='OAuth2瀹㈡埛绔〃'; - --- 1.29 OAuth2鎺堟潈鐮佽〃 -CREATE TABLE `system_oauth2_code` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `code` varchar(255) DEFAULT NULL COMMENT '鎺堟潈鐮�', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', - `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', - `scopes` json DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', - `redirect_uri` varchar(255) DEFAULT NULL COMMENT '閲嶅畾鍚戝湴鍧�', - `state` varchar(100) DEFAULT NULL COMMENT '鐘舵��', - `expires_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='OAuth2鎺堟潈鐮佽〃'; - --- 1.30 OAuth2璁块棶浠ょ墝琛� -CREATE TABLE `system_oauth2_access_token` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `access_token` varchar(255) DEFAULT NULL COMMENT '璁块棶浠ょ墝', - `refresh_token` varchar(255) DEFAULT NULL COMMENT '鍒锋柊浠ょ墝', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', - `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `user_info` json DEFAULT NULL COMMENT '鐢ㄦ埛淇℃伅', - `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', - `scopes` json DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', - `expires_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', - `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='OAuth2璁块棶浠ょ墝琛�'; - --- 1.31 OAuth2鍒锋柊浠ょ墝琛� -CREATE TABLE `system_oauth2_refresh_token` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `refresh_token` varchar(255) DEFAULT NULL COMMENT '鍒锋柊浠ょ墝', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', - `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', - `scopes` json DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', - `expires_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', - `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='OAuth2鍒锋柊浠ょ墝琛�'; - --- 1.32 OAuth2鎵瑰噯琛� -CREATE TABLE `system_oauth2_approve` ( - `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', - `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', - `scope` varchar(255) DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', - `approved` bit(1) DEFAULT b'0' COMMENT '鏄惁鎺ュ彈', - `expires_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', - `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', - `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB COMMENT='OAuth2鎵瑰噯琛�'; - - --- ===================================================== --- 绗簩閮ㄥ垎: yudao-module-infra 鍩虹璁炬柦妯″潡 (11 寮犺〃) --- ===================================================== - --- 2.1 浠ｇ爜鐢熸垚瀛楁瀹氫箟琛� -CREATE TABLE `infra_codegen_column` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID 缂栧彿', - `table_id` BIGINT NOT NULL COMMENT '琛ㄧ紪鍙�', - `column_name` VARCHAR(200) NOT NULL COMMENT '瀛楁鍚�', - `data_type` VARCHAR(200) NOT NULL COMMENT '鏁版嵁搴撳瓧娈电被鍨�', - `column_comment` VARCHAR(500) DEFAULT NULL COMMENT '瀛楁鎻忚堪', - `nullable` TINYINT(1) NOT NULL COMMENT '鏄惁鍏佽涓虹┖', - `primary_key` TINYINT(1) NOT NULL COMMENT '鏄惁涓婚敭', - `ordinal_position` INT NOT NULL COMMENT '鎺掑簭', - `java_type` VARCHAR(200) NOT NULL COMMENT 'Java 灞炴�х被鍨�', - `java_field` VARCHAR(200) NOT NULL COMMENT 'Java 灞炴�у悕', - `dict_type` VARCHAR(200) DEFAULT NULL COMMENT '瀛楀吀绫诲瀷', - `example` VARCHAR(500) DEFAULT NULL COMMENT '鏁版嵁绀轰緥', - `create_operation` TINYINT(1) NOT NULL COMMENT '鏄惁涓� Create 鍒涘缓鎿嶄綔鐨勫瓧娈�', - `update_operation` TINYINT(1) NOT NULL COMMENT '鏄惁涓� Update 鏇存柊鎿嶄綔鐨勫瓧娈�', - `list_operation` TINYINT(1) NOT NULL COMMENT '鏄惁涓� List 鏌ヨ鎿嶄綔鐨勫瓧娈�', - `list_operation_condition` VARCHAR(200) NOT NULL COMMENT 'List 鏌ヨ鎿嶄綔鐨勬潯浠剁被鍨�', - `list_operation_result` TINYINT(1) NOT NULL COMMENT '鏄惁涓� List 鏌ヨ鎿嶄綔鐨勮繑鍥炲瓧娈�', - `html_type` VARCHAR(200) NOT NULL COMMENT '鏄剧ず绫诲瀷', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浠ｇ爜鐢熸垚瀛楁瀹氫箟琛�'; - --- 2.2 浠ｇ爜鐢熸垚琛ㄥ畾涔夎〃 -CREATE TABLE `infra_codegen_table` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID 缂栧彿', - `data_source_config_id` BIGINT NOT NULL COMMENT '鏁版嵁婧愮紪鍙�', - `scene` INT NOT NULL COMMENT '鐢熸垚鍦烘櫙', - `table_name` VARCHAR(200) NOT NULL COMMENT '琛ㄥ悕绉�', - `table_comment` VARCHAR(500) DEFAULT NULL COMMENT '琛ㄦ弿杩�', - `remark` VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞', - `module_name` VARCHAR(100) NOT NULL COMMENT '妯″潡鍚嶏紝鍗充竴绾х洰褰�', - `business_name` VARCHAR(100) NOT NULL COMMENT '涓氬姟鍚嶏紝鍗充簩绾х洰褰�', - `class_name` VARCHAR(100) NOT NULL COMMENT '绫诲悕绉帮紙棣栧瓧姣嶅ぇ鍐欙級', - `class_comment` VARCHAR(500) DEFAULT NULL COMMENT '绫绘弿杩�', - `author` VARCHAR(100) DEFAULT NULL COMMENT '浣滆��', - `template_type` INT NOT NULL COMMENT '妯℃澘绫诲瀷', - `front_type` INT NOT NULL COMMENT '浠ｇ爜鐢熸垚鐨勫墠绔被鍨�', - `parent_menu_id` BIGINT DEFAULT NULL COMMENT '鐖惰彍鍗曠紪鍙�', - `master_table_id` BIGINT DEFAULT NULL COMMENT '涓昏〃鐨勭紪鍙�', - `sub_join_column_id` BIGINT DEFAULT NULL COMMENT '瀛愯〃鍏宠仈涓昏〃鐨勫瓧娈电紪鍙�', - `sub_join_many` TINYINT(1) DEFAULT NULL COMMENT '涓昏〃涓庡瓙琛ㄦ槸鍚︿竴瀵瑰', - `tree_parent_column_id` BIGINT DEFAULT NULL COMMENT '鏍戣〃鐨勭埗瀛楁缂栧彿', - `tree_name_column_id` BIGINT DEFAULT NULL COMMENT '鏍戣〃鐨勫悕瀛楀瓧娈电紪鍙�', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浠ｇ爜鐢熸垚琛ㄥ畾涔夎〃'; - --- 2.3 鍙傛暟閰嶇疆琛� -CREATE TABLE `infra_config` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '鍙傛暟涓婚敭', - `category` VARCHAR(100) NOT NULL COMMENT '鍙傛暟鍒嗙被', - `name` VARCHAR(100) NOT NULL COMMENT '鍙傛暟鍚嶇О', - `config_key` VARCHAR(100) NOT NULL COMMENT '鍙傛暟閿悕', - `value` VARCHAR(500) NOT NULL COMMENT '鍙傛暟閿��', - `type` INT NOT NULL COMMENT '鍙傛暟绫诲瀷', - `visible` TINYINT(1) NOT NULL COMMENT '鏄惁鍙', - `remark` VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鍙傛暟閰嶇疆琛�'; - --- 2.4 鏁版嵁婧愰厤缃〃 -CREATE TABLE `infra_data_source_config` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '涓婚敭缂栧彿', - `name` VARCHAR(100) NOT NULL COMMENT '杩炴帴鍚�', - `url` VARCHAR(1024) NOT NULL COMMENT '鏁版嵁婧愯繛鎺�', - `username` VARCHAR(255) NOT NULL COMMENT '鐢ㄦ埛鍚�', - `password` VARCHAR(255) NOT NULL COMMENT '瀵嗙爜', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鏁版嵁婧愰厤缃〃'; - --- 2.5 鏂囦欢鍐呭琛� -CREATE TABLE `infra_file_content` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿锛屾暟鎹簱鑷', - `config_id` BIGINT NOT NULL COMMENT '閰嶇疆缂栧彿', - `path` VARCHAR(512) NOT NULL COMMENT '璺緞锛屽嵆鏂囦欢鍚�', - `content` LONGBLOB NOT NULL COMMENT '鏂囦欢鍐呭', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鏂囦欢鍐呭琛�'; - --- 2.6 鏂囦欢琛� -CREATE TABLE `infra_file` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿锛屾暟鎹簱鑷', - `config_id` BIGINT NOT NULL COMMENT '閰嶇疆缂栧彿', - `name` VARCHAR(256) DEFAULT NULL COMMENT '鍘熸枃浠跺悕', - `path` VARCHAR(512) NOT NULL COMMENT '璺緞锛屽嵆鏂囦欢鍚�', - `url` VARCHAR(1024) NOT NULL COMMENT '璁块棶鍦板潃', - `type` VARCHAR(128) DEFAULT NULL COMMENT '鏂囦欢鐨� MIME 绫诲瀷', - `size` BIGINT NOT NULL COMMENT '鏂囦欢澶у皬', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鏂囦欢琛�'; - --- 2.7 鏂囦欢閰嶇疆琛� -CREATE TABLE `infra_file_config` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '閰嶇疆缂栧彿锛屾暟鎹簱鑷', - `name` VARCHAR(100) NOT NULL COMMENT '閰嶇疆鍚�', - `storage` INT NOT NULL COMMENT '瀛樺偍鍣�', - `remark` VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞', - `master` TINYINT(1) NOT NULL COMMENT '鏄惁涓轰富閰嶇疆', - `config` VARCHAR(4000) NOT NULL COMMENT '鏂囦欢瀹㈡埛绔厤缃�', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鏂囦欢閰嶇疆琛�'; - --- 2.8 瀹氭椂浠诲姟琛� -CREATE TABLE `infra_job` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '浠诲姟缂栧彿', - `name` VARCHAR(100) NOT NULL COMMENT '浠诲姟鍚嶇О', - `status` INT NOT NULL COMMENT '浠诲姟鐘舵��', - `handler_name` VARCHAR(100) NOT NULL COMMENT '澶勭悊鍣ㄧ殑鍚嶅瓧', - `handler_param` VARCHAR(500) DEFAULT NULL COMMENT '澶勭悊鍣ㄧ殑鍙傛暟', - `cron_expression` VARCHAR(100) NOT NULL COMMENT 'CRON 琛ㄨ揪寮�', - `retry_count` INT NOT NULL DEFAULT 0 COMMENT '閲嶈瘯娆℃暟', - `retry_interval` INT NOT NULL DEFAULT 0 COMMENT '閲嶈瘯闂撮殧锛屽崟浣嶏細姣', - `monitor_timeout` INT DEFAULT NULL COMMENT '鐩戞帶瓒呮椂鏃堕棿锛屽崟浣嶏細姣', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='瀹氭椂浠诲姟琛�'; - --- 2.9 瀹氭椂浠诲姟鎵ц鏃ュ織琛� -CREATE TABLE `infra_job_log` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '鏃ュ織缂栧彿', - `job_id` BIGINT NOT NULL COMMENT '浠诲姟缂栧彿', - `handler_name` VARCHAR(100) NOT NULL COMMENT '澶勭悊鍣ㄧ殑鍚嶅瓧', - `handler_param` VARCHAR(500) DEFAULT NULL COMMENT '澶勭悊鍣ㄧ殑鍙傛暟', - `execute_index` INT NOT NULL COMMENT '绗嚑娆℃墽琛�', - `begin_time` DATETIME NOT NULL COMMENT '寮�濮嬫墽琛屾椂闂�', - `end_time` DATETIME DEFAULT NULL COMMENT '缁撴潫鎵ц鏃堕棿', - `duration` INT DEFAULT NULL COMMENT '鎵ц鏃堕暱锛屽崟浣嶏細姣', - `status` INT NOT NULL COMMENT '鐘舵��', - `result` VARCHAR(4000) DEFAULT NULL COMMENT '缁撴灉鏁版嵁', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='瀹氭椂浠诲姟鎵ц鏃ュ織琛�'; - --- 2.10 API 璁块棶鏃ュ織琛� -CREATE TABLE `infra_api_access_log` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `trace_id` VARCHAR(64) DEFAULT NULL COMMENT '閾捐矾杩借釜缂栧彿', - `user_id` BIGINT DEFAULT NULL COMMENT '鐢ㄦ埛缂栧彿', - `user_type` INT DEFAULT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `application_name` VARCHAR(100) NOT NULL COMMENT '搴旂敤鍚�', - `request_method` VARCHAR(16) NOT NULL COMMENT '璇锋眰鏂规硶鍚�', - `request_url` VARCHAR(512) NOT NULL COMMENT '璁块棶鍦板潃', - `request_params` TEXT COMMENT '璇锋眰鍙傛暟', - `response_body` TEXT COMMENT '鍝嶅簲缁撴灉', - `user_ip` VARCHAR(64) NOT NULL COMMENT '鐢ㄦ埛 IP', - `user_agent` VARCHAR(512) DEFAULT NULL COMMENT '娴忚鍣� UA', - `operate_module` VARCHAR(100) DEFAULT NULL COMMENT '鎿嶄綔妯″潡', - `operate_name` VARCHAR(100) DEFAULT NULL COMMENT '鎿嶄綔鍚�', - `operate_type` INT DEFAULT NULL COMMENT '鎿嶄綔鍒嗙被', - `begin_time` DATETIME NOT NULL COMMENT '寮�濮嬭姹傛椂闂�', - `end_time` DATETIME NOT NULL COMMENT '缁撴潫璇锋眰鏃堕棿', - `duration` INT NOT NULL COMMENT '鎵ц鏃堕暱锛屽崟浣嶏細姣', - `result_code` INT NOT NULL COMMENT '缁撴灉鐮�', - `result_msg` VARCHAR(512) DEFAULT NULL COMMENT '缁撴灉鎻愮ず', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API 璁块棶鏃ュ織琛�'; - --- 2.11 API 寮傚父鏃ュ織琛� -CREATE TABLE `infra_api_error_log` ( - `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', - `user_id` BIGINT DEFAULT NULL COMMENT '鐢ㄦ埛缂栧彿', - `trace_id` VARCHAR(64) DEFAULT NULL COMMENT '閾捐矾杩借釜缂栧彿', - `user_type` INT DEFAULT NULL COMMENT '鐢ㄦ埛绫诲瀷', - `application_name` VARCHAR(100) NOT NULL COMMENT '搴旂敤鍚�', - `request_method` VARCHAR(16) NOT NULL COMMENT '璇锋眰鏂规硶鍚�', - `request_url` VARCHAR(512) NOT NULL COMMENT '璁块棶鍦板潃', - `request_params` TEXT COMMENT '璇锋眰鍙傛暟', - `user_ip` VARCHAR(64) NOT NULL COMMENT '鐢ㄦ埛 IP', - `user_agent` VARCHAR(512) DEFAULT NULL COMMENT '娴忚鍣� UA', - `exception_time` DATETIME NOT NULL COMMENT '寮傚父鍙戠敓鏃堕棿', - `exception_name` VARCHAR(256) DEFAULT NULL COMMENT '寮傚父鍚�', - `exception_message` TEXT COMMENT '寮傚父瀵艰嚧鐨勬秷鎭�', - `exception_root_cause_message` TEXT COMMENT '寮傚父瀵艰嚧鐨勬牴娑堟伅', - `exception_stack_trace` TEXT COMMENT '寮傚父鐨勬爤杞ㄨ抗', - `exception_class_name` VARCHAR(512) DEFAULT NULL COMMENT '寮傚父鍙戠敓鐨勭被鍏ㄥ悕', - `exception_file_name` VARCHAR(256) DEFAULT NULL COMMENT '寮傚父鍙戠敓鐨勭被鏂囦欢', - `exception_method_name` VARCHAR(128) DEFAULT NULL COMMENT '寮傚父鍙戠敓鐨勬柟娉曞悕', - `exception_line_number` INT DEFAULT NULL COMMENT '寮傚父鍙戠敓鐨勬柟娉曟墍鍦ㄨ', - `process_status` INT NOT NULL COMMENT '澶勭悊鐘舵��', - `process_time` DATETIME DEFAULT NULL COMMENT '澶勭悊鏃堕棿', - `process_user_id` BIGINT DEFAULT NULL COMMENT '澶勭悊鐢ㄦ埛缂栧彿', - `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', - `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', - `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', - `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', - `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API 寮傚父鏃ュ織琛�'; +-- CREATE TABLE `system_users` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鐢ㄦ埛ID', +-- `username` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛璐﹀彿', +-- `password` varchar(100) DEFAULT NULL COMMENT '鍔犲瘑鍚庣殑瀵嗙爜', +-- `nickname` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛鏄电О', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `dept_id` bigint DEFAULT NULL COMMENT '閮ㄩ棬ID', +-- `post_ids` json DEFAULT NULL COMMENT '宀椾綅缂栧彿鏁扮粍', +-- `email` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛閭', +-- `mobile` varchar(100) DEFAULT NULL COMMENT '鎵嬫満鍙风爜', +-- `sex` tinyint DEFAULT NULL COMMENT '鐢ㄦ埛鎬у埆', +-- `avatar` varchar(255) DEFAULT NULL COMMENT '鐢ㄦ埛澶村儚', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '甯愬彿鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `login_ip` varchar(50) DEFAULT NULL COMMENT '鏈�鍚庣櫥褰旾P', +-- `login_date` datetime DEFAULT NULL COMMENT '鏈�鍚庣櫥褰曟椂闂�', +-- `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='绠＄悊鍚庡彴鐢ㄦ埛琛�'; +-- +-- -- 1.2 閮ㄩ棬琛� +-- CREATE TABLE `system_dept` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '閮ㄩ棬ID', +-- `name` varchar(100) DEFAULT NULL COMMENT '閮ㄩ棬鍚嶇О', +-- `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '鐖堕儴闂↖D', +-- `sort` int NOT NULL DEFAULT '0' COMMENT '鏄剧ず椤哄簭', +-- `leader_user_id` bigint DEFAULT NULL COMMENT '璐熻矗浜�', +-- `phone` varchar(50) DEFAULT NULL COMMENT '鑱旂郴鐢佃瘽', +-- `email` varchar(100) DEFAULT NULL COMMENT '閭', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '閮ㄩ棬鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='閮ㄩ棬琛�'; +-- +-- -- 1.3 宀椾綅琛� +-- CREATE TABLE `system_post` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '宀椾綅搴忓彿', +-- `name` varchar(100) DEFAULT NULL COMMENT '宀椾綅鍚嶇О', +-- `code` varchar(100) DEFAULT NULL COMMENT '宀椾綅缂栫爜', +-- `sort` int NOT NULL DEFAULT '0' COMMENT '宀椾綅鎺掑簭', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='宀椾綅琛�'; +-- +-- -- 1.4 鐢ㄦ埛宀椾綅鍏宠仈琛� +-- CREATE TABLE `system_user_post` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭', +-- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛ID', +-- `post_id` bigint NOT NULL COMMENT '宀椾綅ID', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='鐢ㄦ埛宀椾綅鍏宠仈琛�'; +-- +-- -- 1.5 瀛楀吀绫诲瀷琛� +-- CREATE TABLE `system_dict_type` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '瀛楀吀涓婚敭', +-- `name` varchar(100) DEFAULT NULL COMMENT '瀛楀吀鍚嶇О', +-- `type` varchar(100) DEFAULT NULL COMMENT '瀛楀吀绫诲瀷', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `deleted_time` datetime DEFAULT NULL COMMENT '鍒犻櫎鏃堕棿', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='瀛楀吀绫诲瀷琛�'; +-- +-- -- 1.6 瀛楀吀鏁版嵁琛� +-- CREATE TABLE `system_dict_data` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '瀛楀吀鏁版嵁缂栧彿', +-- `sort` int NOT NULL DEFAULT '0' COMMENT '瀛楀吀鎺掑簭', +-- `label` varchar(100) DEFAULT NULL COMMENT '瀛楀吀鏍囩', +-- `value` varchar(100) DEFAULT NULL COMMENT '瀛楀吀鍊�', +-- `dict_type` varchar(100) DEFAULT NULL COMMENT '瀛楀吀绫诲瀷', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `color_type` varchar(50) DEFAULT NULL COMMENT '棰滆壊绫诲瀷', +-- `css_class` varchar(100) DEFAULT NULL COMMENT 'css鏍峰紡', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='瀛楀吀鏁版嵁琛�'; +-- +-- -- 1.7 鐧诲綍鏃ュ織琛� +-- CREATE TABLE `system_login_log` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鏃ュ織涓婚敭', +-- `log_type` tinyint NOT NULL COMMENT '鏃ュ織绫诲瀷', +-- `trace_id` varchar(64) DEFAULT NULL COMMENT '閾捐矾杩借釜缂栧彿', +-- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `username` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛璐﹀彿', +-- `result` tinyint NOT NULL COMMENT '鐧诲綍缁撴灉', +-- `user_ip` varchar(50) DEFAULT NULL COMMENT '鐢ㄦ埛IP', +-- `user_agent` varchar(512) DEFAULT NULL COMMENT '娴忚鍣║A', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='鐧诲綍鏃ュ織琛�'; +-- +-- -- 1.8 鎿嶄綔鏃ュ織琛� +-- CREATE TABLE `system_operate_log` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鏃ュ織涓婚敭', +-- `trace_id` varchar(64) DEFAULT NULL COMMENT '閾捐矾杩借釜缂栧彿', +-- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `type` varchar(100) DEFAULT NULL COMMENT '鎿嶄綔妯″潡绫诲瀷', +-- `sub_type` varchar(100) DEFAULT NULL COMMENT '鎿嶄綔鍚�', +-- `biz_id` bigint DEFAULT NULL COMMENT '鎿嶄綔妯″潡涓氬姟缂栧彿', +-- `action` varchar(2000) DEFAULT NULL COMMENT '鏃ュ織鍐呭', +-- `extra` varchar(2000) DEFAULT NULL COMMENT '鎷撳睍瀛楁', +-- `request_method` varchar(50) DEFAULT NULL COMMENT '璇锋眰鏂规硶鍚�', +-- `request_url` varchar(255) DEFAULT NULL COMMENT '璇锋眰鍦板潃', +-- `user_ip` varchar(50) DEFAULT NULL COMMENT '鐢ㄦ埛IP', +-- `user_agent` varchar(512) DEFAULT NULL COMMENT '娴忚鍣║A', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='鎿嶄綔鏃ュ織琛�'; +-- +-- -- 1.9 閫氱煡鍏憡琛� +-- CREATE TABLE `system_notice` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鍏憡ID', +-- `title` varchar(200) DEFAULT NULL COMMENT '鍏憡鏍囬', +-- `type` tinyint NOT NULL COMMENT '鍏憡绫诲瀷', +-- `content` text COMMENT '鍏憡鍐呭', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鍏憡鐘舵�侊紙0姝ｅ父 1鍏抽棴锛�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='閫氱煡鍏憡琛�'; +-- +-- -- 1.10 鑿滃崟琛� +-- CREATE TABLE `system_menu` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑿滃崟缂栧彿', +-- `name` varchar(100) DEFAULT NULL COMMENT '鑿滃崟鍚嶇О', +-- `permission` varchar(100) DEFAULT NULL COMMENT '鏉冮檺鏍囪瘑', +-- `type` tinyint NOT NULL COMMENT '鑿滃崟绫诲瀷', +-- `sort` int NOT NULL DEFAULT '0' COMMENT '鏄剧ず椤哄簭', +-- `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '鐖惰彍鍗旾D', +-- `path` varchar(255) DEFAULT NULL COMMENT '璺敱鍦板潃', +-- `icon` varchar(100) DEFAULT NULL COMMENT '鑿滃崟鍥炬爣', +-- `component` varchar(255) DEFAULT NULL COMMENT '缁勪欢璺緞', +-- `component_name` varchar(100) DEFAULT NULL COMMENT '缁勪欢鍚�', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `visible` bit(1) DEFAULT b'1' COMMENT '鏄惁鍙', +-- `keep_alive` bit(1) DEFAULT b'1' COMMENT '鏄惁缂撳瓨', +-- `always_show` bit(1) DEFAULT b'1' COMMENT '鏄惁鎬绘槸鏄剧ず', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='鑿滃崟琛�'; +-- +-- -- 1.11 瑙掕壊琛� +-- CREATE TABLE `system_role` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '瑙掕壊ID', +-- `name` varchar(100) DEFAULT NULL COMMENT '瑙掕壊鍚嶇О', +-- `code` varchar(100) DEFAULT NULL COMMENT '瑙掕壊鏍囪瘑', +-- `sort` int NOT NULL DEFAULT '0' COMMENT '瑙掕壊鎺掑簭', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '瑙掕壊鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `type` tinyint NOT NULL COMMENT '瑙掕壊绫诲瀷', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `data_scope` tinyint DEFAULT NULL COMMENT '鏁版嵁鑼冨洿', +-- `data_scope_dept_ids` json DEFAULT NULL COMMENT '鏁版嵁鑼冨洿(鎸囧畾閮ㄩ棬鏁扮粍)', +-- `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='瑙掕壊琛�'; +-- +-- -- 1.12 瑙掕壊鑿滃崟鍏宠仈琛� +-- CREATE TABLE `system_role_menu` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭', +-- `role_id` bigint NOT NULL COMMENT '瑙掕壊ID', +-- `menu_id` bigint NOT NULL COMMENT '鑿滃崟ID', +-- `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='瑙掕壊鑿滃崟鍏宠仈琛�'; +-- +-- -- 1.13 鐢ㄦ埛瑙掕壊鍏宠仈琛� +-- CREATE TABLE `system_user_role` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭', +-- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛ID', +-- `role_id` bigint NOT NULL COMMENT '瑙掕壊ID', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='鐢ㄦ埛瑙掕壊鍏宠仈琛�'; +-- +-- -- 1.14 鐭俊娓犻亾琛� +-- CREATE TABLE `system_sms_channel` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '娓犻亾缂栧彿', +-- `signature` varchar(100) DEFAULT NULL COMMENT '鐭俊绛惧悕', +-- `code` varchar(100) DEFAULT NULL COMMENT '娓犻亾缂栫爜', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鍚敤鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `api_key` varchar(255) DEFAULT NULL COMMENT '鐭俊API鐨勮处鍙�', +-- `api_secret` varchar(255) DEFAULT NULL COMMENT '鐭俊API鐨勫瘑閽�', +-- `callback_url` varchar(255) DEFAULT NULL COMMENT '鐭俊鍙戦�佸洖璋僓RL', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='鐭俊娓犻亾琛�'; +-- +-- -- 1.15 鎵嬫満楠岃瘉鐮佽〃 +-- CREATE TABLE `system_sms_code` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `mobile` varchar(20) DEFAULT NULL COMMENT '鎵嬫満鍙�', +-- `code` varchar(20) DEFAULT NULL COMMENT '楠岃瘉鐮�', +-- `scene` tinyint NOT NULL COMMENT '鍙戦�佸満鏅�', +-- `create_ip` varchar(50) DEFAULT NULL COMMENT '鍒涘缓IP', +-- `today_index` int DEFAULT NULL COMMENT '浠婃棩鍙戦�佺殑绗嚑鏉�', +-- `used` bit(1) DEFAULT b'0' COMMENT '鏄惁浣跨敤', +-- `used_time` datetime DEFAULT NULL COMMENT '浣跨敤鏃堕棿', +-- `used_ip` varchar(50) DEFAULT NULL COMMENT '浣跨敤IP', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`), +-- KEY `idx_mobile` (`mobile`) +-- ) ENGINE=InnoDB COMMENT='鎵嬫満楠岃瘉鐮佽〃'; +-- +-- -- 1.16 鐭俊妯℃澘琛� +-- CREATE TABLE `system_sms_template` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷缂栧彿', +-- `type` tinyint NOT NULL COMMENT '鐭俊绫诲瀷', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鍚敤鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `code` varchar(100) DEFAULT NULL COMMENT '妯℃澘缂栫爜', +-- `name` varchar(100) DEFAULT NULL COMMENT '妯℃澘鍚嶇О', +-- `content` varchar(500) DEFAULT NULL COMMENT '妯℃澘鍐呭', +-- `params` json DEFAULT NULL COMMENT '鍙傛暟鏁扮粍', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `api_template_id` varchar(100) DEFAULT NULL COMMENT '鐭俊API鐨勬ā鏉跨紪鍙�', +-- `channel_id` bigint DEFAULT NULL COMMENT '鐭俊娓犻亾缂栧彿', +-- `channel_code` varchar(100) DEFAULT NULL COMMENT '鐭俊娓犻亾缂栫爜', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='鐭俊妯℃澘琛�'; +-- +-- -- 1.17 鐭俊鏃ュ織琛� +-- CREATE TABLE `system_sms_log` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷缂栧彿', +-- `channel_id` bigint DEFAULT NULL COMMENT '鐭俊娓犻亾缂栧彿', +-- `channel_code` varchar(100) DEFAULT NULL COMMENT '鐭俊娓犻亾缂栫爜', +-- `template_id` bigint DEFAULT NULL COMMENT '妯℃澘缂栧彿', +-- `template_code` varchar(100) DEFAULT NULL COMMENT '妯℃澘缂栫爜', +-- `template_type` tinyint DEFAULT NULL COMMENT '鐭俊绫诲瀷', +-- `template_content` varchar(500) DEFAULT NULL COMMENT '妯℃澘鍐呭', +-- `template_params` json DEFAULT NULL COMMENT '妯℃澘鍙傛暟', +-- `api_template_id` varchar(100) DEFAULT NULL COMMENT '鐭俊API鐨勬ā鏉跨紪鍙�', +-- `mobile` varchar(20) DEFAULT NULL COMMENT '鎵嬫満鍙�', +-- `user_id` bigint DEFAULT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `user_type` tinyint DEFAULT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `send_status` tinyint NOT NULL DEFAULT '0' COMMENT '鍙戦�佺姸鎬�', +-- `send_time` datetime DEFAULT NULL COMMENT '鍙戦�佹椂闂�', +-- `api_send_code` varchar(100) DEFAULT NULL COMMENT '鐭俊API鍙戦�佺粨鏋滅殑缂栫爜', +-- `api_send_msg` varchar(500) DEFAULT NULL COMMENT '鐭俊API鍙戦�佸け璐ョ殑鎻愮ず', +-- `api_request_id` varchar(100) DEFAULT NULL COMMENT '鐭俊API鍙戦�佽繑鍥炵殑鍞竴璇锋眰ID', +-- `api_serial_no` varchar(100) DEFAULT NULL COMMENT '鐭俊API鍙戦�佽繑鍥炵殑搴忓彿', +-- `receive_status` tinyint NOT NULL DEFAULT '0' COMMENT '鎺ユ敹鐘舵��', +-- `receive_time` datetime DEFAULT NULL COMMENT '鎺ユ敹鏃堕棿', +-- `api_receive_code` varchar(100) DEFAULT NULL COMMENT '鐭俊API鎺ユ敹缁撴灉鐨勭紪鐮�', +-- `api_receive_msg` varchar(500) DEFAULT NULL COMMENT '鐭俊API鎺ユ敹缁撴灉鐨勬彁绀�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='鐭俊鏃ュ織琛�'; +-- +-- -- 1.18 绀句氦瀹㈡埛绔〃 +-- CREATE TABLE `system_social_client` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `name` varchar(100) DEFAULT NULL COMMENT '搴旂敤鍚�', +-- `social_type` tinyint NOT NULL COMMENT '绀句氦绫诲瀷', +-- `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `client_id` varchar(255) DEFAULT NULL COMMENT '瀹㈡埛绔痠d', +-- `client_secret` varchar(255) DEFAULT NULL COMMENT '瀹㈡埛绔疭ecret', +-- `agent_id` varchar(100) DEFAULT NULL COMMENT '浠ｇ悊缂栧彿', +-- `public_key` varchar(512) DEFAULT NULL COMMENT 'publicKey鍏挜', +-- `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='绀句氦瀹㈡埛绔〃'; +-- +-- -- 1.19 绀句氦鐢ㄦ埛琛� +-- CREATE TABLE `system_social_user` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭', +-- `type` tinyint NOT NULL COMMENT '绀句氦骞冲彴鐨勭被鍨�', +-- `openid` varchar(100) DEFAULT NULL COMMENT '绀句氦openid', +-- `token` varchar(255) DEFAULT NULL COMMENT '绀句氦token', +-- `raw_token_info` text COMMENT '鍘熷Token鏁版嵁', +-- `nickname` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛鏄电О', +-- `avatar` varchar(255) DEFAULT NULL COMMENT '鐢ㄦ埛澶村儚', +-- `raw_user_info` text COMMENT '鍘熷鐢ㄦ埛鏁版嵁', +-- `code` varchar(100) DEFAULT NULL COMMENT '鏈�鍚庝竴娆＄殑璁よ瘉code', +-- `state` varchar(100) DEFAULT NULL COMMENT '鏈�鍚庝竴娆＄殑璁よ瘉state', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='绀句氦鐢ㄦ埛琛�'; +-- +-- -- 1.20 绀句氦鐢ㄦ埛缁戝畾琛� +-- CREATE TABLE `system_social_user_bind` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `user_id` bigint NOT NULL COMMENT '鍏宠仈鐨勭敤鎴风紪鍙�', +-- `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `social_user_id` bigint NOT NULL COMMENT '绀句氦骞冲彴鐨勭敤鎴风紪鍙�', +-- `social_type` tinyint NOT NULL COMMENT '绀句氦骞冲彴鐨勭被鍨�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='绀句氦鐢ㄦ埛缁戝畾琛�'; +-- +-- -- 1.21 绉熸埛琛� +-- CREATE TABLE `system_tenant` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '绉熸埛缂栧彿', +-- `name` varchar(100) DEFAULT NULL COMMENT '绉熸埛鍚�', +-- `contact_user_id` bigint DEFAULT NULL COMMENT '鑱旂郴浜虹殑鐢ㄦ埛缂栧彿', +-- `contact_name` varchar(100) DEFAULT NULL COMMENT '鑱旂郴浜�', +-- `contact_mobile` varchar(50) DEFAULT NULL COMMENT '鑱旂郴鎵嬫満', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '绉熸埛鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `websites` json DEFAULT NULL COMMENT '缁戝畾鍩熷悕鍒楄〃', +-- `package_id` bigint DEFAULT NULL COMMENT '绉熸埛濂楅缂栧彿', +-- `expire_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', +-- `account_count` int DEFAULT NULL COMMENT '璐﹀彿鏁伴噺', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='绉熸埛琛�'; +-- +-- -- 1.22 绉熸埛濂楅琛� +-- CREATE TABLE `system_tenant_package` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '濂楅缂栧彿', +-- `name` varchar(100) DEFAULT NULL COMMENT '濂楅鍚�', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '绉熸埛濂楅鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `menu_ids` json DEFAULT NULL COMMENT '鍏宠仈鐨勮彍鍗曠紪鍙�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='绉熸埛濂楅琛�'; +-- +-- -- 1.23 閭璐﹀彿琛� +-- CREATE TABLE `system_mail_account` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', +-- `mail` varchar(100) DEFAULT NULL COMMENT '閭', +-- `username` varchar(100) DEFAULT NULL COMMENT '鐢ㄦ埛鍚�', +-- `password` varchar(100) DEFAULT NULL COMMENT '瀵嗙爜', +-- `host` varchar(100) DEFAULT NULL COMMENT 'SMTP鏈嶅姟鍣ㄥ煙鍚�', +-- `port` int DEFAULT NULL COMMENT 'SMTP鏈嶅姟鍣ㄧ鍙�', +-- `ssl_enable` bit(1) DEFAULT b'0' COMMENT '鏄惁寮�鍚疭SL', +-- `starttls_enable` bit(1) DEFAULT b'0' COMMENT '鏄惁寮�鍚疭TARTTLS', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='閭璐﹀彿琛�'; +-- +-- -- 1.24 閭欢妯＄増琛� +-- CREATE TABLE `system_mail_template` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', +-- `name` varchar(100) DEFAULT NULL COMMENT '妯＄増鍚嶇О', +-- `code` varchar(100) DEFAULT NULL COMMENT '妯＄増缂栧彿', +-- `account_id` bigint DEFAULT NULL COMMENT '鍙戦�佺殑閭璐﹀彿缂栧彿', +-- `nickname` varchar(100) DEFAULT NULL COMMENT '鍙戦�佷汉鍚嶇О', +-- `title` varchar(255) DEFAULT NULL COMMENT '鏍囬', +-- `content` text COMMENT '鍐呭', +-- `params` json DEFAULT NULL COMMENT '鍙傛暟鏁扮粍', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='閭欢妯＄増琛�'; +-- +-- -- 1.25 閭鏃ュ織琛� +-- CREATE TABLE `system_mail_log` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鏃ュ織缂栧彿', +-- `user_id` bigint DEFAULT NULL COMMENT '鐢ㄦ埛缂栫爜', +-- `user_type` tinyint DEFAULT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `to_mails` json DEFAULT NULL COMMENT '鎺ユ敹閭鍦板潃', +-- `cc_mails` json DEFAULT NULL COMMENT '鎶勯�侀偖绠卞湴鍧�', +-- `bcc_mails` json DEFAULT NULL COMMENT '瀵嗛�侀偖绠卞湴鍧�', +-- `account_id` bigint DEFAULT NULL COMMENT '閭璐﹀彿缂栧彿', +-- `from_mail` varchar(100) DEFAULT NULL COMMENT '鍙戦�侀偖绠卞湴鍧�', +-- `template_id` bigint DEFAULT NULL COMMENT '妯＄増缂栧彿', +-- `template_code` varchar(100) DEFAULT NULL COMMENT '妯＄増缂栫爜', +-- `template_nickname` varchar(100) DEFAULT NULL COMMENT '妯＄増鍙戦�佷汉鍚嶇О', +-- `template_title` varchar(255) DEFAULT NULL COMMENT '妯＄増鏍囬', +-- `template_content` text COMMENT '妯＄増鍐呭', +-- `template_params` json DEFAULT NULL COMMENT '妯＄増鍙傛暟', +-- `send_status` tinyint NOT NULL DEFAULT '0' COMMENT '鍙戦�佺姸鎬�', +-- `send_time` datetime DEFAULT NULL COMMENT '鍙戦�佹椂闂�', +-- `send_message_id` varchar(255) DEFAULT NULL COMMENT '鍙戦�佽繑鍥炵殑娑堟伅ID', +-- `send_exception` varchar(500) DEFAULT NULL COMMENT '鍙戦�佸紓甯�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='閭鏃ュ織琛�'; +-- +-- -- 1.26 绔欏唴淇℃ā鐗堣〃 +-- CREATE TABLE `system_notify_template` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID', +-- `name` varchar(100) DEFAULT NULL COMMENT '妯＄増鍚嶇О', +-- `code` varchar(100) DEFAULT NULL COMMENT '妯＄増缂栫爜', +-- `type` tinyint NOT NULL COMMENT '妯＄増绫诲瀷', +-- `nickname` varchar(100) DEFAULT NULL COMMENT '鍙戦�佷汉鍚嶇О', +-- `content` varchar(500) DEFAULT NULL COMMENT '妯＄増鍐呭', +-- `params` json DEFAULT NULL COMMENT '鍙傛暟鏁扮粍', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='绔欏唴淇℃ā鐗堣〃'; +-- +-- -- 1.27 绔欏唴淇¤〃 +-- CREATE TABLE `system_notify_message` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '绔欏唴淇＄紪鍙�', +-- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `template_id` bigint DEFAULT NULL COMMENT '妯＄増缂栧彿', +-- `template_code` varchar(100) DEFAULT NULL COMMENT '妯＄増缂栫爜', +-- `template_type` tinyint DEFAULT NULL COMMENT '妯＄増绫诲瀷', +-- `template_nickname` varchar(100) DEFAULT NULL COMMENT '妯＄増鍙戦�佷汉鍚嶇О', +-- `template_content` varchar(500) DEFAULT NULL COMMENT '妯＄増鍐呭', +-- `template_params` json DEFAULT NULL COMMENT '妯＄増鍙傛暟', +-- `read_status` bit(1) DEFAULT b'0' COMMENT '鏄惁宸茶', +-- `read_time` datetime DEFAULT NULL COMMENT '闃呰鏃堕棿', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='绔欏唴淇¤〃'; +-- +-- -- 1.28 OAuth2瀹㈡埛绔〃 +-- CREATE TABLE `system_oauth2_client` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', +-- `secret` varchar(255) DEFAULT NULL COMMENT '瀹㈡埛绔瘑閽�', +-- `name` varchar(100) DEFAULT NULL COMMENT '搴旂敤鍚�', +-- `logo` varchar(255) DEFAULT NULL COMMENT '搴旂敤鍥炬爣', +-- `description` varchar(500) DEFAULT NULL COMMENT '搴旂敤鎻忚堪', +-- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', +-- `access_token_validity_seconds` int DEFAULT NULL COMMENT '璁块棶浠ょ墝鐨勬湁鏁堟湡', +-- `refresh_token_validity_seconds` int DEFAULT NULL COMMENT '鍒锋柊浠ょ墝鐨勬湁鏁堟湡', +-- `redirect_uris` json DEFAULT NULL COMMENT '鍙噸瀹氬悜鐨刄RI鍦板潃', +-- `authorized_grant_types` json DEFAULT NULL COMMENT '鎺堟潈绫诲瀷', +-- `scopes` json DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', +-- `auto_approve_scopes` json DEFAULT NULL COMMENT '鑷姩鎺堟潈鐨凷cope', +-- `authorities` json DEFAULT NULL COMMENT '鏉冮檺', +-- `resource_ids` json DEFAULT NULL COMMENT '璧勬簮', +-- `additional_information` varchar(2000) DEFAULT NULL COMMENT '闄勫姞淇℃伅', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='OAuth2瀹㈡埛绔〃'; +-- +-- -- 1.29 OAuth2鎺堟潈鐮佽〃 +-- CREATE TABLE `system_oauth2_code` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `code` varchar(255) DEFAULT NULL COMMENT '鎺堟潈鐮�', +-- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', +-- `scopes` json DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', +-- `redirect_uri` varchar(255) DEFAULT NULL COMMENT '閲嶅畾鍚戝湴鍧�', +-- `state` varchar(100) DEFAULT NULL COMMENT '鐘舵��', +-- `expires_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='OAuth2鎺堟潈鐮佽〃'; +-- +-- -- 1.30 OAuth2璁块棶浠ょ墝琛� +-- CREATE TABLE `system_oauth2_access_token` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `access_token` varchar(255) DEFAULT NULL COMMENT '璁块棶浠ょ墝', +-- `refresh_token` varchar(255) DEFAULT NULL COMMENT '鍒锋柊浠ょ墝', +-- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `user_info` json DEFAULT NULL COMMENT '鐢ㄦ埛淇℃伅', +-- `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', +-- `scopes` json DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', +-- `expires_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', +-- `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='OAuth2璁块棶浠ょ墝琛�'; +-- +-- -- 1.31 OAuth2鍒锋柊浠ょ墝琛� +-- CREATE TABLE `system_oauth2_refresh_token` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `refresh_token` varchar(255) DEFAULT NULL COMMENT '鍒锋柊浠ょ墝', +-- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', +-- `scopes` json DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', +-- `expires_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', +-- `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '澶氱鎴风紪鍙�', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='OAuth2鍒锋柊浠ょ墝琛�'; +-- +-- -- 1.32 OAuth2鎵瑰噯琛� +-- CREATE TABLE `system_oauth2_approve` ( +-- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `user_type` tinyint NOT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `client_id` varchar(100) DEFAULT NULL COMMENT '瀹㈡埛绔紪鍙�', +-- `scope` varchar(255) DEFAULT NULL COMMENT '鎺堟潈鑼冨洿', +-- `approved` bit(1) DEFAULT b'0' COMMENT '鏄惁鎺ュ彈', +-- `expires_time` datetime DEFAULT NULL COMMENT '杩囨湡鏃堕棿', +-- `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏈�鍚庢洿鏂版椂闂�', +-- `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB COMMENT='OAuth2鎵瑰噯琛�'; +-- +-- +-- -- ===================================================== +-- -- 绗簩閮ㄥ垎: yudao-module-infra 鍩虹璁炬柦妯″潡 (11 寮犺〃) +-- -- ===================================================== +-- +-- -- 2.1 浠ｇ爜鐢熸垚瀛楁瀹氫箟琛� +-- CREATE TABLE `infra_codegen_column` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID 缂栧彿', +-- `table_id` BIGINT NOT NULL COMMENT '琛ㄧ紪鍙�', +-- `column_name` VARCHAR(200) NOT NULL COMMENT '瀛楁鍚�', +-- `data_type` VARCHAR(200) NOT NULL COMMENT '鏁版嵁搴撳瓧娈电被鍨�', +-- `column_comment` VARCHAR(500) DEFAULT NULL COMMENT '瀛楁鎻忚堪', +-- `nullable` TINYINT(1) NOT NULL COMMENT '鏄惁鍏佽涓虹┖', +-- `primary_key` TINYINT(1) NOT NULL COMMENT '鏄惁涓婚敭', +-- `ordinal_position` INT NOT NULL COMMENT '鎺掑簭', +-- `java_type` VARCHAR(200) NOT NULL COMMENT 'Java 灞炴�х被鍨�', +-- `java_field` VARCHAR(200) NOT NULL COMMENT 'Java 灞炴�у悕', +-- `dict_type` VARCHAR(200) DEFAULT NULL COMMENT '瀛楀吀绫诲瀷', +-- `example` VARCHAR(500) DEFAULT NULL COMMENT '鏁版嵁绀轰緥', +-- `create_operation` TINYINT(1) NOT NULL COMMENT '鏄惁涓� Create 鍒涘缓鎿嶄綔鐨勫瓧娈�', +-- `update_operation` TINYINT(1) NOT NULL COMMENT '鏄惁涓� Update 鏇存柊鎿嶄綔鐨勫瓧娈�', +-- `list_operation` TINYINT(1) NOT NULL COMMENT '鏄惁涓� List 鏌ヨ鎿嶄綔鐨勫瓧娈�', +-- `list_operation_condition` VARCHAR(200) NOT NULL COMMENT 'List 鏌ヨ鎿嶄綔鐨勬潯浠剁被鍨�', +-- `list_operation_result` TINYINT(1) NOT NULL COMMENT '鏄惁涓� List 鏌ヨ鎿嶄綔鐨勮繑鍥炲瓧娈�', +-- `html_type` VARCHAR(200) NOT NULL COMMENT '鏄剧ず绫诲瀷', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浠ｇ爜鐢熸垚瀛楁瀹氫箟琛�'; +-- +-- -- 2.2 浠ｇ爜鐢熸垚琛ㄥ畾涔夎〃 +-- CREATE TABLE `infra_codegen_table` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID 缂栧彿', +-- `data_source_config_id` BIGINT NOT NULL COMMENT '鏁版嵁婧愮紪鍙�', +-- `scene` INT NOT NULL COMMENT '鐢熸垚鍦烘櫙', +-- `table_name` VARCHAR(200) NOT NULL COMMENT '琛ㄥ悕绉�', +-- `table_comment` VARCHAR(500) DEFAULT NULL COMMENT '琛ㄦ弿杩�', +-- `remark` VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞', +-- `module_name` VARCHAR(100) NOT NULL COMMENT '妯″潡鍚嶏紝鍗充竴绾х洰褰�', +-- `business_name` VARCHAR(100) NOT NULL COMMENT '涓氬姟鍚嶏紝鍗充簩绾х洰褰�', +-- `class_name` VARCHAR(100) NOT NULL COMMENT '绫诲悕绉帮紙棣栧瓧姣嶅ぇ鍐欙級', +-- `class_comment` VARCHAR(500) DEFAULT NULL COMMENT '绫绘弿杩�', +-- `author` VARCHAR(100) DEFAULT NULL COMMENT '浣滆��', +-- `template_type` INT NOT NULL COMMENT '妯℃澘绫诲瀷', +-- `front_type` INT NOT NULL COMMENT '浠ｇ爜鐢熸垚鐨勫墠绔被鍨�', +-- `parent_menu_id` BIGINT DEFAULT NULL COMMENT '鐖惰彍鍗曠紪鍙�', +-- `master_table_id` BIGINT DEFAULT NULL COMMENT '涓昏〃鐨勭紪鍙�', +-- `sub_join_column_id` BIGINT DEFAULT NULL COMMENT '瀛愯〃鍏宠仈涓昏〃鐨勫瓧娈电紪鍙�', +-- `sub_join_many` TINYINT(1) DEFAULT NULL COMMENT '涓昏〃涓庡瓙琛ㄦ槸鍚︿竴瀵瑰', +-- `tree_parent_column_id` BIGINT DEFAULT NULL COMMENT '鏍戣〃鐨勭埗瀛楁缂栧彿', +-- `tree_name_column_id` BIGINT DEFAULT NULL COMMENT '鏍戣〃鐨勫悕瀛楀瓧娈电紪鍙�', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浠ｇ爜鐢熸垚琛ㄥ畾涔夎〃'; +-- +-- -- 2.3 鍙傛暟閰嶇疆琛� +-- CREATE TABLE `infra_config` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '鍙傛暟涓婚敭', +-- `category` VARCHAR(100) NOT NULL COMMENT '鍙傛暟鍒嗙被', +-- `name` VARCHAR(100) NOT NULL COMMENT '鍙傛暟鍚嶇О', +-- `config_key` VARCHAR(100) NOT NULL COMMENT '鍙傛暟閿悕', +-- `value` VARCHAR(500) NOT NULL COMMENT '鍙傛暟閿��', +-- `type` INT NOT NULL COMMENT '鍙傛暟绫诲瀷', +-- `visible` TINYINT(1) NOT NULL COMMENT '鏄惁鍙', +-- `remark` VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鍙傛暟閰嶇疆琛�'; +-- +-- -- 2.4 鏁版嵁婧愰厤缃〃 +-- CREATE TABLE `infra_data_source_config` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '涓婚敭缂栧彿', +-- `name` VARCHAR(100) NOT NULL COMMENT '杩炴帴鍚�', +-- `url` VARCHAR(1024) NOT NULL COMMENT '鏁版嵁婧愯繛鎺�', +-- `username` VARCHAR(255) NOT NULL COMMENT '鐢ㄦ埛鍚�', +-- `password` VARCHAR(255) NOT NULL COMMENT '瀵嗙爜', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鏁版嵁婧愰厤缃〃'; +-- +-- -- 2.5 鏂囦欢鍐呭琛� +-- CREATE TABLE `infra_file_content` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿锛屾暟鎹簱鑷', +-- `config_id` BIGINT NOT NULL COMMENT '閰嶇疆缂栧彿', +-- `path` VARCHAR(512) NOT NULL COMMENT '璺緞锛屽嵆鏂囦欢鍚�', +-- `content` LONGBLOB NOT NULL COMMENT '鏂囦欢鍐呭', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鏂囦欢鍐呭琛�'; +-- +-- -- 2.6 鏂囦欢琛� +-- CREATE TABLE `infra_file` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿锛屾暟鎹簱鑷', +-- `config_id` BIGINT NOT NULL COMMENT '閰嶇疆缂栧彿', +-- `name` VARCHAR(256) DEFAULT NULL COMMENT '鍘熸枃浠跺悕', +-- `path` VARCHAR(512) NOT NULL COMMENT '璺緞锛屽嵆鏂囦欢鍚�', +-- `url` VARCHAR(1024) NOT NULL COMMENT '璁块棶鍦板潃', +-- `type` VARCHAR(128) DEFAULT NULL COMMENT '鏂囦欢鐨� MIME 绫诲瀷', +-- `size` BIGINT NOT NULL COMMENT '鏂囦欢澶у皬', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鏂囦欢琛�'; +-- +-- -- 2.7 鏂囦欢閰嶇疆琛� +-- CREATE TABLE `infra_file_config` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '閰嶇疆缂栧彿锛屾暟鎹簱鑷', +-- `name` VARCHAR(100) NOT NULL COMMENT '閰嶇疆鍚�', +-- `storage` INT NOT NULL COMMENT '瀛樺偍鍣�', +-- `remark` VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞', +-- `master` TINYINT(1) NOT NULL COMMENT '鏄惁涓轰富閰嶇疆', +-- `config` VARCHAR(4000) NOT NULL COMMENT '鏂囦欢瀹㈡埛绔厤缃�', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鏂囦欢閰嶇疆琛�'; +-- +-- -- 2.8 瀹氭椂浠诲姟琛� +-- CREATE TABLE `infra_job` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '浠诲姟缂栧彿', +-- `name` VARCHAR(100) NOT NULL COMMENT '浠诲姟鍚嶇О', +-- `status` INT NOT NULL COMMENT '浠诲姟鐘舵��', +-- `handler_name` VARCHAR(100) NOT NULL COMMENT '澶勭悊鍣ㄧ殑鍚嶅瓧', +-- `handler_param` VARCHAR(500) DEFAULT NULL COMMENT '澶勭悊鍣ㄧ殑鍙傛暟', +-- `cron_expression` VARCHAR(100) NOT NULL COMMENT 'CRON 琛ㄨ揪寮�', +-- `retry_count` INT NOT NULL DEFAULT 0 COMMENT '閲嶈瘯娆℃暟', +-- `retry_interval` INT NOT NULL DEFAULT 0 COMMENT '閲嶈瘯闂撮殧锛屽崟浣嶏細姣', +-- `monitor_timeout` INT DEFAULT NULL COMMENT '鐩戞帶瓒呮椂鏃堕棿锛屽崟浣嶏細姣', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='瀹氭椂浠诲姟琛�'; +-- +-- -- 2.9 瀹氭椂浠诲姟鎵ц鏃ュ織琛� +-- CREATE TABLE `infra_job_log` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '鏃ュ織缂栧彿', +-- `job_id` BIGINT NOT NULL COMMENT '浠诲姟缂栧彿', +-- `handler_name` VARCHAR(100) NOT NULL COMMENT '澶勭悊鍣ㄧ殑鍚嶅瓧', +-- `handler_param` VARCHAR(500) DEFAULT NULL COMMENT '澶勭悊鍣ㄧ殑鍙傛暟', +-- `execute_index` INT NOT NULL COMMENT '绗嚑娆℃墽琛�', +-- `begin_time` DATETIME NOT NULL COMMENT '寮�濮嬫墽琛屾椂闂�', +-- `end_time` DATETIME DEFAULT NULL COMMENT '缁撴潫鎵ц鏃堕棿', +-- `duration` INT DEFAULT NULL COMMENT '鎵ц鏃堕暱锛屽崟浣嶏細姣', +-- `status` INT NOT NULL COMMENT '鐘舵��', +-- `result` VARCHAR(4000) DEFAULT NULL COMMENT '缁撴灉鏁版嵁', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='瀹氭椂浠诲姟鎵ц鏃ュ織琛�'; +-- +-- -- 2.10 API 璁块棶鏃ュ織琛� +-- CREATE TABLE `infra_api_access_log` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `trace_id` VARCHAR(64) DEFAULT NULL COMMENT '閾捐矾杩借釜缂栧彿', +-- `user_id` BIGINT DEFAULT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `user_type` INT DEFAULT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `application_name` VARCHAR(100) NOT NULL COMMENT '搴旂敤鍚�', +-- `request_method` VARCHAR(16) NOT NULL COMMENT '璇锋眰鏂规硶鍚�', +-- `request_url` VARCHAR(512) NOT NULL COMMENT '璁块棶鍦板潃', +-- `request_params` TEXT COMMENT '璇锋眰鍙傛暟', +-- `response_body` TEXT COMMENT '鍝嶅簲缁撴灉', +-- `user_ip` VARCHAR(64) NOT NULL COMMENT '鐢ㄦ埛 IP', +-- `user_agent` VARCHAR(512) DEFAULT NULL COMMENT '娴忚鍣� UA', +-- `operate_module` VARCHAR(100) DEFAULT NULL COMMENT '鎿嶄綔妯″潡', +-- `operate_name` VARCHAR(100) DEFAULT NULL COMMENT '鎿嶄綔鍚�', +-- `operate_type` INT DEFAULT NULL COMMENT '鎿嶄綔鍒嗙被', +-- `begin_time` DATETIME NOT NULL COMMENT '寮�濮嬭姹傛椂闂�', +-- `end_time` DATETIME NOT NULL COMMENT '缁撴潫璇锋眰鏃堕棿', +-- `duration` INT NOT NULL COMMENT '鎵ц鏃堕暱锛屽崟浣嶏細姣', +-- `result_code` INT NOT NULL COMMENT '缁撴灉鐮�', +-- `result_msg` VARCHAR(512) DEFAULT NULL COMMENT '缁撴灉鎻愮ず', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API 璁块棶鏃ュ織琛�'; +-- +-- -- 2.11 API 寮傚父鏃ュ織琛� +-- CREATE TABLE `infra_api_error_log` ( +-- `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', +-- `user_id` BIGINT DEFAULT NULL COMMENT '鐢ㄦ埛缂栧彿', +-- `trace_id` VARCHAR(64) DEFAULT NULL COMMENT '閾捐矾杩借釜缂栧彿', +-- `user_type` INT DEFAULT NULL COMMENT '鐢ㄦ埛绫诲瀷', +-- `application_name` VARCHAR(100) NOT NULL COMMENT '搴旂敤鍚�', +-- `request_method` VARCHAR(16) NOT NULL COMMENT '璇锋眰鏂规硶鍚�', +-- `request_url` VARCHAR(512) NOT NULL COMMENT '璁块棶鍦板潃', +-- `request_params` TEXT COMMENT '璇锋眰鍙傛暟', +-- `user_ip` VARCHAR(64) NOT NULL COMMENT '鐢ㄦ埛 IP', +-- `user_agent` VARCHAR(512) DEFAULT NULL COMMENT '娴忚鍣� UA', +-- `exception_time` DATETIME NOT NULL COMMENT '寮傚父鍙戠敓鏃堕棿', +-- `exception_name` VARCHAR(256) DEFAULT NULL COMMENT '寮傚父鍚�', +-- `exception_message` TEXT COMMENT '寮傚父瀵艰嚧鐨勬秷鎭�', +-- `exception_root_cause_message` TEXT COMMENT '寮傚父瀵艰嚧鐨勬牴娑堟伅', +-- `exception_stack_trace` TEXT COMMENT '寮傚父鐨勬爤杞ㄨ抗', +-- `exception_class_name` VARCHAR(512) DEFAULT NULL COMMENT '寮傚父鍙戠敓鐨勭被鍏ㄥ悕', +-- `exception_file_name` VARCHAR(256) DEFAULT NULL COMMENT '寮傚父鍙戠敓鐨勭被鏂囦欢', +-- `exception_method_name` VARCHAR(128) DEFAULT NULL COMMENT '寮傚父鍙戠敓鐨勬柟娉曞悕', +-- `exception_line_number` INT DEFAULT NULL COMMENT '寮傚父鍙戠敓鐨勬柟娉曟墍鍦ㄨ', +-- `process_status` INT NOT NULL COMMENT '澶勭悊鐘舵��', +-- `process_time` DATETIME DEFAULT NULL COMMENT '澶勭悊鏃堕棿', +-- `process_user_id` BIGINT DEFAULT NULL COMMENT '澶勭悊鐢ㄦ埛缂栧彿', +-- `creator` VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', +-- `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', +-- `updater` VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', +-- `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', +-- `deleted` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', +-- PRIMARY KEY (`id`) +-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API 寮傚父鏃ュ織琛�'; -- ===================================================== -- Gitblit v1.9.3