-- 第一步：创建允许任何主机连接的 root 用户
CREATE USER 'root'@'%' IDENTIFIED BY 'Dip@2026Va03';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;


-- 第二步：创建DIP配置数据库
CREATE DATABASE `dip_db` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */


-- 第三步：还原DIP配置数据库结构
/*
 Navicat Premium Data Transfer

 Source Server         : 菲斯科开发环境192.168.11.130
 Source Server Type    : MySQL
 Source Server Version : 80020 (8.0.20)
 Source Host           : 192.168.11.130:3306
 Source Schema         : dip_db

 Target Server Type    : MySQL
 Target Server Version : 80020 (8.0.20)
 File Encoding         : 65001

 Date: 12/03/2026 17:32:36
*/
Use dip_db;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for aaduserormlocaluser
-- ----------------------------
DROP TABLE IF EXISTS `aaduserormlocaluser`;
CREATE TABLE `aaduserormlocaluser`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LocalUserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `AADUserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `AADUserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for accountapplication
-- ----------------------------
DROP TABLE IF EXISTS `accountapplication`;
CREATE TABLE `accountapplication`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CNCompanyName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ENCompanyName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CompanyAddress` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Department` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Count` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Position` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Surname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `BusinessEmail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Phone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Account` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PowerBiVersions` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PowerBiApplicationID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PowerBiApplicationPwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PowerBiApplicationSecretKey` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PowerBiCloudWorkspace` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PowerBiUserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PowerBiPwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for adsynchronizationplantaskrulesconfig
-- ----------------------------
DROP TABLE IF EXISTS `adsynchronizationplantaskrulesconfig`;
CREATE TABLE `adsynchronizationplantaskrulesconfig`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FrequencyType` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Week` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Interval` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `startBoundary` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for adsynchronizatonuserinfo
-- ----------------------------
DROP TABLE IF EXISTS `adsynchronizatonuserinfo`;
CREATE TABLE `adsynchronizatonuserinfo`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ConnectADConfigID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AdUserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alarmlog
-- ----------------------------
DROP TABLE IF EXISTS `alarmlog`;
CREATE TABLE `alarmlog`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Source` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Action` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Msg` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Levels` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for apiinfo
-- ----------------------------
DROP TABLE IF EXISTS `apiinfo`;
CREATE TABLE `apiinfo`  (
  `Id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for apiinfo_copy1
-- ----------------------------
DROP TABLE IF EXISTS `apiinfo_copy1`;
CREATE TABLE `apiinfo_copy1`  (
  `Id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for batch_insert_user_role
-- ----------------------------
DROP TABLE IF EXISTS `batch_insert_user_role`;
CREATE TABLE `batch_insert_user_role`  (
  `RoleName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for collectionreport
-- ----------------------------
DROP TABLE IF EXISTS `collectionreport`;
CREATE TABLE `collectionreport`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdaterTime` datetime NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for connectadconfig
-- ----------------------------
DROP TABLE IF EXISTS `connectadconfig`;
CREATE TABLE `connectadconfig`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ADPath` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `ADUser` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ADPassword` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ADOuPath` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `WhetherSyncAllUser` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cube_attributeconfig
-- ----------------------------
DROP TABLE IF EXISTS `cube_attributeconfig`;
CREATE TABLE `cube_attributeconfig`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DimensionId` int NULL DEFAULT NULL,
  `Attribute_Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Attribute_PageName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `InterfaceType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 133 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cube_catalogconfig
-- ----------------------------
DROP TABLE IF EXISTS `cube_catalogconfig`;
CREATE TABLE `cube_catalogconfig`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DataSourceId` int NULL DEFAULT NULL,
  `Catalog` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Catalog_PageName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cube_cubeconfig
-- ----------------------------
DROP TABLE IF EXISTS `cube_cubeconfig`;
CREATE TABLE `cube_cubeconfig`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `CatalogId` int NULL DEFAULT NULL,
  `Cube_Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Cube_CodeName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Cube_PageName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cube_datasourceconfig
-- ----------------------------
DROP TABLE IF EXISTS `cube_datasourceconfig`;
CREATE TABLE `cube_datasourceconfig`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DataSource` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataSource_PageName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataSource_Account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataSource_Password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataSource_IsOpenAccount` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cube_dimensionconfig
-- ----------------------------
DROP TABLE IF EXISTS `cube_dimensionconfig`;
CREATE TABLE `cube_dimensionconfig`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `CubeId` int NULL DEFAULT NULL,
  `Dimension_Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Dimension_PageName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1055 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cube_security_access
-- ----------------------------
DROP TABLE IF EXISTS `cube_security_access`;
CREATE TABLE `cube_security_access`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `RoleId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `MEMBER_UNIQUE_NAME` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Dimension_Name` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Attribute_Name` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Member_Key` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Status_ID` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `NodeStatus` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LevelID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ParentKey` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SSASDBID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3427 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cube_settingallpermissions
-- ----------------------------
DROP TABLE IF EXISTS `cube_settingallpermissions`;
CREATE TABLE `cube_settingallpermissions`  (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Instance` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DataBases` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Cube` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cube_validuserallowset
-- ----------------------------
DROP TABLE IF EXISTS `cube_validuserallowset`;
CREATE TABLE `cube_validuserallowset`  (
  `ID` int NOT NULL,
  `UserAccount` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataSource` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Catalog` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Cube` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Dimension` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Attribute` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Desc` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `AllowSet` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cube_validuserallowset_tosqlreport
-- ----------------------------
DROP TABLE IF EXISTS `cube_validuserallowset_tosqlreport`;
CREATE TABLE `cube_validuserallowset_tosqlreport`  (
  `ID` int NOT NULL,
  `UserAccount` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataSource` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Catalog` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Cube` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Dimension` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Attribute` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Desc` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `AllowSet` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for custom_tabular_security_access
-- ----------------------------
DROP TABLE IF EXISTS `custom_tabular_security_access`;
CREATE TABLE `custom_tabular_security_access`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Instance` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataBases` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Tables` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Data` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_bsc_sh
-- ----------------------------
DROP TABLE IF EXISTS `dc_bsc_sh`;
CREATE TABLE `dc_bsc_sh`  (
  `Year` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `KPI_Key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `KPI_Name` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Action_Definition` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Data_Collector` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Target` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `YTD` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Jan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Feb` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Mar` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Apr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `May` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Jun` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Jul` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Aug` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Sep` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Oct` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Nov` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Dec` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Problem` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Problem_types` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Solutions` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Follow_up_person` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `BatchTag` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_changerule
-- ----------------------------
DROP TABLE IF EXISTS `dc_changerule`;
CREATE TABLE `dc_changerule`  (
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `naem` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` decimal(18, 0) NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `BatchTag` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_createsql
-- ----------------------------
DROP TABLE IF EXISTS `dc_createsql`;
CREATE TABLE `dc_createsql`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `FileNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateSql` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `IsBuild` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4696 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_datafile
-- ----------------------------
DROP TABLE IF EXISTS `dc_datafile`;
CREATE TABLE `dc_datafile`  (
  `FileNo` int NOT NULL AUTO_INCREMENT,
  `DataSourceID` int NULL DEFAULT NULL,
  `FileName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SheetName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TableName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `STableName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdType` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TemplateUrl` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `IsBuild` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `BusinessTypeCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ProcName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`FileNo`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3345 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_datafiledetail
-- ----------------------------
DROP TABLE IF EXISTS `dc_datafiledetail`;
CREATE TABLE `dc_datafiledetail`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `FileNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SheetName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Required` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileFieldName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DBFieldName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataLength` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `DataDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PK` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4108 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_datafilefilter
-- ----------------------------
DROP TABLE IF EXISTS `dc_datafilefilter`;
CREATE TABLE `dc_datafilefilter`  (
  `ID` int NOT NULL,
  `FileNo` int NULL DEFAULT NULL,
  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ExcelName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ExcelField` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_datafilelog
-- ----------------------------
DROP TABLE IF EXISTS `dc_datafilelog`;
CREATE TABLE `dc_datafilelog`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `BatchTag` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileSize` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ImportDate` datetime NULL DEFAULT NULL,
  `ImportType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5373 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_datafiletemp
-- ----------------------------
DROP TABLE IF EXISTS `dc_datafiletemp`;
CREATE TABLE `dc_datafiletemp`  (
  `ID` int NOT NULL,
  `FileNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileFieldName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DBFieldName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataVerify` int NULL DEFAULT NULL,
  `DataContent` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_datasource
-- ----------------------------
DROP TABLE IF EXISTS `dc_datasource`;
CREATE TABLE `dc_datasource`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `DataSourceName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataSource` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CataLog` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LoginUser` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PassWord` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataBaseType` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dc_validateprocinfo
-- ----------------------------
DROP TABLE IF EXISTS `dc_validateprocinfo`;
CREATE TABLE `dc_validateprocinfo`  (
  `ID` int NOT NULL,
  `ValidateProcName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ValidateProcContent` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `FileNo` int NOT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dingtalkconfiguration
-- ----------------------------
DROP TABLE IF EXISTS `dingtalkconfiguration`;
CREATE TABLE `dingtalkconfiguration`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `AppServersAddress` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CorpID` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `AppKey` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `AgentId` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `AppSecret` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dingtalkusermapping
-- ----------------------------
DROP TABLE IF EXISTS `dingtalkusermapping`;
CREATE TABLE `dingtalkusermapping`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DDUserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DDUserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ef_cpb
-- ----------------------------
DROP TABLE IF EXISTS `ef_cpb`;
CREATE TABLE `ef_cpb`  (
  `cNo` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cCardName` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cMaker` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dMakeDateEx` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dMakeDate` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cMender` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dModifyDateEx` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dModifyDate` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cfcode` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cfname` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cinvcode` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ID` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `iswfcontrolled` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `iverifystate` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ireturncount` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UAPRuntime_RowNO` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ccode` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cCode_ZY` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cInvStd_TJ` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Exit` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for folderinfo
-- ----------------------------
DROP TABLE IF EXISTS `folderinfo`;
CREATE TABLE `folderinfo`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FolderName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `OrderID` int NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for folderreportassignment
-- ----------------------------
DROP TABLE IF EXISTS `folderreportassignment`;
CREATE TABLE `folderreportassignment`  (
  `ID` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FolderID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for folderroleassignment
-- ----------------------------
DROP TABLE IF EXISTS `folderroleassignment`;
CREATE TABLE `folderroleassignment`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FolderID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for isaadconsistents
-- ----------------------------
DROP TABLE IF EXISTS `isaadconsistents`;
CREATE TABLE `isaadconsistents`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IsAADConsistent` tinyint NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for iscustomtabular
-- ----------------------------
DROP TABLE IF EXISTS `iscustomtabular`;
CREATE TABLE `iscustomtabular`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Instance` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DataBases` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Tables` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IsCustomize` tinyint NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for isenablesite
-- ----------------------------
DROP TABLE IF EXISTS `isenablesite`;
CREATE TABLE `isenablesite`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Site` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CompanyID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for kpiinfo
-- ----------------------------
DROP TABLE IF EXISTS `kpiinfo`;
CREATE TABLE `kpiinfo`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `KPIName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `KPIDescription` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for kpireportassigment
-- ----------------------------
DROP TABLE IF EXISTS `kpireportassigment`;
CREATE TABLE `kpireportassigment`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `KPIID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for larkconfiguration
-- ----------------------------
DROP TABLE IF EXISTS `larkconfiguration`;
CREATE TABLE `larkconfiguration`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `AppServersAddress` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CorpID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AppKey` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AgentId` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `AppSecret` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for larkusermapping
-- ----------------------------
DROP TABLE IF EXISTS `larkusermapping`;
CREATE TABLE `larkusermapping`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LarkUserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LarkUserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for logoinfo
-- ----------------------------
DROP TABLE IF EXISTS `logoinfo`;
CREATE TABLE `logoinfo`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ConfigType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LogoText` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `LogoColor` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LogoSize` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LogoType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mdp_interface_hrempinfo
-- ----------------------------
DROP TABLE IF EXISTS `mdp_interface_hrempinfo`;
CREATE TABLE `mdp_interface_hrempinfo`  (
  `Id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `EmployeeNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ChineseName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `EnglishName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Gender` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CompanyEmail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IDNumber` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MobileNum` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `BirthDay` datetime NULL DEFAULT NULL,
  `StructureId` int NULL DEFAULT NULL,
  `DeptShortName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CostCenter` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `EmpType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportTo` int NULL DEFAULT NULL,
  `ReportEmpNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PositionLevel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PositionNo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PositionNameCN` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ADAccount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `JoinGroupDate` datetime NULL DEFAULT NULL,
  `EntryProperty` int NULL DEFAULT NULL,
  `IsOverDirector` int NULL DEFAULT NULL,
  `NCCompany` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `GroupCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LastWorkDay` datetime NULL DEFAULT NULL,
  `IsDelete_Ext` int NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mdp_interface_hrhotelmanagementposition
-- ----------------------------
DROP TABLE IF EXISTS `mdp_interface_hrhotelmanagementposition`;
CREATE TABLE `mdp_interface_hrhotelmanagementposition`  (
  `Id` int NOT NULL,
  `HotelUnifyNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `HotelNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `HotelCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IsRealDZ` int NULL DEFAULT NULL,
  `EmpNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `EmpName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `BeginTime` datetime NULL DEFAULT NULL,
  `Endtime` datetime NULL DEFAULT NULL,
  `ManagerTypeCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IsValid` int NULL DEFAULT NULL,
  `IsDelete_Ext` int NULL DEFAULT NULL,
  `JobCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for messagesubscription
-- ----------------------------
DROP TABLE IF EXISTS `messagesubscription`;
CREATE TABLE `messagesubscription`  (
  `SubscriptionID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SubscriptionName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ExportFileType` int NULL DEFAULT NULL,
  `ImagePath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MessageCover` int NULL DEFAULT NULL,
  `FileTemplate` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `PushType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PushContent` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `MessageType` int NULL DEFAULT NULL,
  `Frequency` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Report` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Months` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Weeks` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PlanTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LinkView` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ViewType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `BeginTime` datetime NULL DEFAULT NULL,
  `EndTime` datetime NULL DEFAULT NULL,
  `ReportPage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UrlParameters` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`SubscriptionID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for notification
-- ----------------------------
DROP TABLE IF EXISTS `notification`;
CREATE TABLE `notification`  (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `NoticeContent` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `StartTime` datetime NOT NULL,
  `EndTime` datetime NOT NULL,
  `PopType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MsgType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for notifiedperson
-- ----------------------------
DROP TABLE IF EXISTS `notifiedperson`;
CREATE TABLE `notifiedperson`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `NotificationID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Validity` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for notifiedreport
-- ----------------------------
DROP TABLE IF EXISTS `notifiedreport`;
CREATE TABLE `notifiedreport`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `NotificationID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for processapply
-- ----------------------------
DROP TABLE IF EXISTS `processapply`;
CREATE TABLE `processapply`  (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `ProcessID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Applicant` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ApplicationTime` datetime NULL DEFAULT NULL,
  `State` int NULL DEFAULT NULL,
  `ApproverNode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `OperationType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `BatchTag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `OpreationState` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for processapplynote
-- ----------------------------
DROP TABLE IF EXISTS `processapplynote`;
CREATE TABLE `processapplynote`  (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ProcessApplyID` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `ProcessNodeID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Approver` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `State` int NULL DEFAULT NULL,
  `Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for processinfo
-- ----------------------------
DROP TABLE IF EXISTS `processinfo`;
CREATE TABLE `processinfo`  (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileNo` int NULL DEFAULT NULL,
  `ExceptionHandling` int NULL DEFAULT NULL,
  `AutoApproal` int NULL DEFAULT NULL,
  `Enable` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for processnode
-- ----------------------------
DROP TABLE IF EXISTS `processnode`;
CREATE TABLE `processnode`  (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ProcessID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Levels` int NULL DEFAULT NULL,
  `SetType` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for processnodeuserinfo
-- ----------------------------
DROP TABLE IF EXISTS `processnodeuserinfo`;
CREATE TABLE `processnodeuserinfo`  (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ProcessNodeID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `URID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for report_export_log
-- ----------------------------
DROP TABLE IF EXISTS `report_export_log`;
CREATE TABLE `report_export_log`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `ReportID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IP` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for report_userrole_rowlevel
-- ----------------------------
DROP TABLE IF EXISTS `report_userrole_rowlevel`;
CREATE TABLE `report_userrole_rowlevel`  (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportannotation
-- ----------------------------
DROP TABLE IF EXISTS `reportannotation`;
CREATE TABLE `reportannotation`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserID` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Image` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Annotation` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportconfig
-- ----------------------------
DROP TABLE IF EXISTS `reportconfig`;
CREATE TABLE `reportconfig`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Sort` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportUrl` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `ReportGroupID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportDesc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportDataSourceID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IsShowMobile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IsRefresh` int NULL DEFAULT NULL,
  `RefreshTime` int NULL DEFAULT NULL,
  `RefreshTimeUnit` int NULL DEFAULT NULL,
  `ReportServerConfigID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Visit` int NULL DEFAULT NULL,
  `Type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Thumbnail` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `NavigationBar` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UUID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportconnectionconfiguration
-- ----------------------------
DROP TABLE IF EXISTS `reportconnectionconfiguration`;
CREATE TABLE `reportconnectionconfiguration`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportServiceName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportServiceType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AuthorUrl` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ResouceUrl` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ApplicationID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AccountName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `APIUrl` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `AuthMode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ClientSecret` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TenantId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ClientId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AllowableDomain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `RSAPublicKey` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '帆软报表后台单点登录RSA公钥',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportdatasourceconfig
-- ----------------------------
DROP TABLE IF EXISTS `reportdatasourceconfig`;
CREATE TABLE `reportdatasourceconfig`  (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataSourceType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ConnectionString` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PrivacyLevel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ServerAddress` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `InstanceName` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataBaseName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Pwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportdatasourcetype
-- ----------------------------
DROP TABLE IF EXISTS `reportdatasourcetype`;
CREATE TABLE `reportdatasourcetype`  (
  `Id` int NOT NULL,
  `ReportType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DisplayName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportpageconfig
-- ----------------------------
DROP TABLE IF EXISTS `reportpageconfig`;
CREATE TABLE `reportpageconfig`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportPageName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DisplayName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Order` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportsharewithrole
-- ----------------------------
DROP TABLE IF EXISTS `reportsharewithrole`;
CREATE TABLE `reportsharewithrole`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SharingRoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportsharewithuser
-- ----------------------------
DROP TABLE IF EXISTS `reportsharewithuser`;
CREATE TABLE `reportsharewithuser`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SharingUserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportsubscription
-- ----------------------------
DROP TABLE IF EXISTS `reportsubscription`;
CREATE TABLE `reportsubscription`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ExportedFileType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SubscriptionUserEmail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Frequency` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Week` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Hour` int NOT NULL,
  `Minute` int NOT NULL,
  `IsEnabled` tinyint NOT NULL,
  `StartTime` datetime NOT NULL,
  `EndTime` datetime NOT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportviewhistory
-- ----------------------------
DROP TABLE IF EXISTS `reportviewhistory`;
CREATE TABLE `reportviewhistory`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Viewer` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ViewTime` datetime NOT NULL,
  `ViewerIP` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Browser` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Source` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Operation` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31022 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for reportviewhistorybak
-- ----------------------------
DROP TABLE IF EXISTS `reportviewhistorybak`;
CREATE TABLE `reportviewhistorybak`  (
  `ID` int NOT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Viewer` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ViewTime` datetime NOT NULL,
  `ViewerIP` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Browser` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Source` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Operation` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for roleuploadassignment
-- ----------------------------
DROP TABLE IF EXISTS `roleuploadassignment`;
CREATE TABLE `roleuploadassignment`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FolderID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for rollback_file_system_userinfo
-- ----------------------------
DROP TABLE IF EXISTS `rollback_file_system_userinfo`;
CREATE TABLE `rollback_file_system_userinfo`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ADID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserAccount` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserPwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Salt` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ICon` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for rollback_sysad_system_userinfo
-- ----------------------------
DROP TABLE IF EXISTS `rollback_sysad_system_userinfo`;
CREATE TABLE `rollback_sysad_system_userinfo`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ADID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserAccount` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserPwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Salt` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ICon` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CubeType` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for rs_isenablesubscription
-- ----------------------------
DROP TABLE IF EXISTS `rs_isenablesubscription`;
CREATE TABLE `rs_isenablesubscription`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `IsEnable` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Subscriber` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SubscriberID` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27513 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for rs_subscribepushlog
-- ----------------------------
DROP TABLE IF EXISTS `rs_subscribepushlog`;
CREATE TABLE `rs_subscribepushlog`  (
  `ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SubscriptionID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileName` int NULL DEFAULT NULL,
  `Status` tinyint NULL DEFAULT NULL,
  `ErrorMsg` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for rs_subscriber
-- ----------------------------
DROP TABLE IF EXISTS `rs_subscriber`;
CREATE TABLE `rs_subscriber`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `SubscriptionID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SubscriberType` int NULL DEFAULT NULL,
  `Subscriber` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for searchoperatorinfo
-- ----------------------------
DROP TABLE IF EXISTS `searchoperatorinfo`;
CREATE TABLE `searchoperatorinfo`  (
  `ID` int NOT NULL,
  `Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Operator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UseType` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IsEnable` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sqljobconfiguration
-- ----------------------------
DROP TABLE IF EXISTS `sqljobconfiguration`;
CREATE TABLE `sqljobconfiguration`  (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ServerAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DisplayName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UserAccount` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Pwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Updater` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sqljobexecutionrecord
-- ----------------------------
DROP TABLE IF EXISTS `sqljobexecutionrecord`;
CREATE TABLE `sqljobexecutionrecord`  (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UserID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JobID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Result` tinyint NOT NULL,
  `Message` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sqljobmanagement
-- ----------------------------
DROP TABLE IF EXISTS `sqljobmanagement`;
CREATE TABLE `sqljobmanagement`  (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JobConfigID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JobsID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `OriginalTaskName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DisplayName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sqljobroleassignment
-- ----------------------------
DROP TABLE IF EXISTS `sqljobroleassignment`;
CREATE TABLE `sqljobroleassignment`  (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JobID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ssiserrorlog
-- ----------------------------
DROP TABLE IF EXISTS `ssiserrorlog`;
CREATE TABLE `ssiserrorlog`  (
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `execution_id` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `folder_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `project_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `package_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `executed_as_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `created_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `start_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `end_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `machine_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `isRead` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ssoconfigurationurl
-- ----------------------------
DROP TABLE IF EXISTS `ssoconfigurationurl`;
CREATE TABLE `ssoconfigurationurl`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Url` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CompleteUrl` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ssoconfigurationurlparam
-- ----------------------------
DROP TABLE IF EXISTS `ssoconfigurationurlparam`;
CREATE TABLE `ssoconfigurationurlparam`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SSOConfigurationUrlID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PKey` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PValue` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for stg_changerule
-- ----------------------------
DROP TABLE IF EXISTS `stg_changerule`;
CREATE TABLE `stg_changerule`  (
  `id` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `naem` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `age` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `BatchTag` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ErrorMsg` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for synctasklog
-- ----------------------------
DROP TABLE IF EXISTS `synctasklog`;
CREATE TABLE `synctasklog`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Success` tinyint NULL DEFAULT NULL,
  `Message` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sysdiagrams
-- ----------------------------
DROP TABLE IF EXISTS `sysdiagrams`;
CREATE TABLE `sysdiagrams`  (
  `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `principal_id` int NOT NULL,
  `diagram_id` int NOT NULL,
  `version` int NULL DEFAULT NULL,
  `definition` longblob NULL,
  PRIMARY KEY (`diagram_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_announcement
-- ----------------------------
DROP TABLE IF EXISTS `system_announcement`;
CREATE TABLE `system_announcement`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `AnnouncementTitle` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AnnouncementContent` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `AnnouncementStartTime` datetime NULL DEFAULT NULL,
  `AnnouncementEndTime` datetime NULL DEFAULT NULL,
  `AnnouncementType` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_business
-- ----------------------------
DROP TABLE IF EXISTS `system_business`;
CREATE TABLE `system_business`  (
  `ID` int NOT NULL,
  `TypeCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TypeName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `TypeDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MenuDistinction` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ParentTypeCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SequenceNo` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Validity` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_email_config
-- ----------------------------
DROP TABLE IF EXISTS `system_email_config`;
CREATE TABLE `system_email_config`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID',
  `EmailType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮件类型：SyncIAMUserEmail',
  `EmailTO` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人',
  `EmailCC` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '抄送人',
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '有效性：1 有效、0 无效',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_email_log
-- ----------------------------
DROP TABLE IF EXISTS `system_email_log`;
CREATE TABLE `system_email_log`  (
  `ID` int NOT NULL AUTO_INCREMENT COMMENT '主键标识',
  `EmailType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮件类型：SyncIAMUserEmail',
  `EmailTO` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收件人，多个逗号分隔',
  `EmailCC` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '抄送人，多个逗号分隔',
  `Title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮件标题',
  `Content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '邮件正文',
  `Status` int NOT NULL COMMENT '邮件发送状态：1 成功  0 失败',
  `CreateTime` datetime NOT NULL COMMENT '邮件发送时间',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_globalexception_log
-- ----------------------------
DROP TABLE IF EXISTS `system_globalexception_log`;
CREATE TABLE `system_globalexception_log`  (
  `ID` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Controller` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Action` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ErrorMsg` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `IP` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_log
-- ----------------------------
DROP TABLE IF EXISTS `system_log`;
CREATE TABLE `system_log`  (
  `Id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UserAccount` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Tkey` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ActionName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ControllerName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Parameters` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `OperateResult` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UserHostAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `BrowserInformation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_navigation
-- ----------------------------
DROP TABLE IF EXISTS `system_navigation`;
CREATE TABLE `system_navigation`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `NavCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CNNavName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ENNavName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `JPNavName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `NavDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ParentNavCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `NavURL` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `IconStr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `SequenceNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `NavType` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Grade` int NULL DEFAULT NULL,
  `MenuIdentity` int NULL DEFAULT NULL,
  `ConfirmDelete` int NULL DEFAULT NULL,
  `FolderType` int NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3184 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_privacy_agreement
-- ----------------------------
DROP TABLE IF EXISTS `system_privacy_agreement`;
CREATE TABLE `system_privacy_agreement`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号',
  `user_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户机器IP',
  `confirm_time` datetime NULL DEFAULT NULL COMMENT '确认时间',
  `confirm_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认内容1',
  `confirm_content2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认内容2',
  `confirm_content3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认内容3',
  `confirm_content4` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确认内容4',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_reportroleassignment_exportedit
-- ----------------------------
DROP TABLE IF EXISTS `system_reportroleassignment_exportedit`;
CREATE TABLE `system_reportroleassignment_exportedit`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `RoleID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IsExport` tinyint NULL DEFAULT NULL,
  `IsEdit` tinyint NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updeter` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2235 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_reportroleassignment_rowlevel
-- ----------------------------
DROP TABLE IF EXISTS `system_reportroleassignment_rowlevel`;
CREATE TABLE `system_reportroleassignment_rowlevel`  (
  `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FilterID` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_reportroleinfo_rowlevel
-- ----------------------------
DROP TABLE IF EXISTS `system_reportroleinfo_rowlevel`;
CREATE TABLE `system_reportroleinfo_rowlevel`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_roleattribute
-- ----------------------------
DROP TABLE IF EXISTS `system_roleattribute`;
CREATE TABLE `system_roleattribute`  (
  `ID` int NOT NULL,
  `AttributeID` int NULL DEFAULT NULL,
  `RoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_roledatafile
-- ----------------------------
DROP TABLE IF EXISTS `system_roledatafile`;
CREATE TABLE `system_roledatafile`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `RoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FileNo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12102 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_roledatarowassignment
-- ----------------------------
DROP TABLE IF EXISTS `system_roledatarowassignment`;
CREATE TABLE `system_roledatarowassignment`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `RoleID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FilterID` int NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2321 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_roleinfo
-- ----------------------------
DROP TABLE IF EXISTS `system_roleinfo`;
CREATE TABLE `system_roleinfo`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `RoleDesc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CubeType` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IsAdministrator` tinyint NULL DEFAULT NULL,
  `IsDevOps` tinyint NULL DEFAULT NULL,
  `DevOpsRoleId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_rolenavassignment
-- ----------------------------
DROP TABLE IF EXISTS `system_rolenavassignment`;
CREATE TABLE `system_rolenavassignment`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `RoleID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `NavCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12415 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_rolereportassignment
-- ----------------------------
DROP TABLE IF EXISTS `system_rolereportassignment`;
CREATE TABLE `system_rolereportassignment`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `RoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Creater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `FolderID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18399 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_rolereportdatasetassignment
-- ----------------------------
DROP TABLE IF EXISTS `system_rolereportdatasetassignment`;
CREATE TABLE `system_rolereportdatasetassignment`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `ConnectionConfigID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `GroupID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `DataSetID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `RoleID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 91 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_rolereportsheetassignment
-- ----------------------------
DROP TABLE IF EXISTS `system_rolereportsheetassignment`;
CREATE TABLE `system_rolereportsheetassignment`  (
  `ID` int NOT NULL AUTO_INCREMENT,
  `RoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ReportPageID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creator` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 402 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_syncqywxuserinfo
-- ----------------------------
DROP TABLE IF EXISTS `system_syncqywxuserinfo`;
CREATE TABLE `system_syncqywxuserinfo`  (
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `userId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `fullname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `batchno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `createtime` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_userinfo
-- ----------------------------
DROP TABLE IF EXISTS `system_userinfo`;
CREATE TABLE `system_userinfo`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ADID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserAccount` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserPwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Salt` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ICon` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `NSNID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CubeType` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LegalEntity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Platform` varchar(54) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Department` varchar(54) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Team` varchar(54) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0 删除、1 启用、2 禁用',
  `PwdUpdateTime` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_userinfo_back20260109
-- ----------------------------
DROP TABLE IF EXISTS `system_userinfo_back20260109`;
CREATE TABLE `system_userinfo_back20260109`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ADID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserAccount` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserPwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Salt` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ICon` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `NSNID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CubeType` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LegalEntity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Platform` varchar(54) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Department` varchar(54) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Team` varchar(54) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0 删除、1 启用、2 禁用',
  `PwdUpdateTime` datetime NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_userloginattempts
-- ----------------------------
DROP TABLE IF EXISTS `system_userloginattempts`;
CREATE TABLE `system_userloginattempts`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `FailedCount` int NULL DEFAULT NULL,
  `LockoutEndTime` datetime NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_userroleassignment
-- ----------------------------
DROP TABLE IF EXISTS `system_userroleassignment`;
CREATE TABLE `system_userroleassignment`  (
  `ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tabular_security_access
-- ----------------------------
DROP TABLE IF EXISTS `tabular_security_access`;
CREATE TABLE `tabular_security_access`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Instance` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DataBases` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Tables` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Field` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Data` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tabularpowerinfo
-- ----------------------------
DROP TABLE IF EXISTS `tabularpowerinfo`;
CREATE TABLE `tabularpowerinfo`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Tabular_Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Tabular_PageName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Tabular_Account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Tabular_Password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Tabular_IsOpenAccount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for test_table
-- ----------------------------
DROP TABLE IF EXISTS `test_table`;
CREATE TABLE `test_table`  (
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for third_party_system
-- ----------------------------
DROP TABLE IF EXISTS `third_party_system`;
CREATE TABLE `third_party_system`  (
  `Id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `SystemName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `AppSecret` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Status` int NOT NULL,
  `CreateTime` datetime(3) NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UpdateTime` datetime(3) NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportAccessType` int NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tps_api_assignment
-- ----------------------------
DROP TABLE IF EXISTS `tps_api_assignment`;
CREATE TABLE `tps_api_assignment`  (
  `Id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ApiId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TPSId` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CreateTime` datetime NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for tps_report_assignment
-- ----------------------------
DROP TABLE IF EXISTS `tps_report_assignment`;
CREATE TABLE `tps_report_assignment`  (
  `Id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TPSId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportId` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for usercommunicationfeedback
-- ----------------------------
DROP TABLE IF EXISTS `usercommunicationfeedback`;
CREATE TABLE `usercommunicationfeedback`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CommunicationFeedbackContent` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `Type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for useruploadreport
-- ----------------------------
DROP TABLE IF EXISTS `useruploadreport`;
CREATE TABLE `useruploadreport`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UserAccount` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ReportID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FolderID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NOT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for watermarkmanage
-- ----------------------------
DROP TABLE IF EXISTS `watermarkmanage`;
CREATE TABLE `watermarkmanage`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `WatermarkContent` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `WatermarkContentType` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `WatermarkAlpha` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `WatermarkColor` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `WatermarkType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MobileShow` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for wechatconfiguration
-- ----------------------------
DROP TABLE IF EXISTS `wechatconfiguration`;
CREATE TABLE `wechatconfiguration`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `AgentID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `AppServersAddress` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CorpID` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `APPSecret` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ContactSecret` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Validity` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for wechatusermapping
-- ----------------------------
DROP TABLE IF EXISTS `wechatusermapping`;
CREATE TABLE `wechatusermapping`  (
  `ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `WeChatUserName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `WeChatUserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UserID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Creater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CreateTime` datetime NULL DEFAULT NULL,
  `Updater` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `UpdateTime` datetime NULL DEFAULT NULL,
  `Validity` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- View structure for view_cube_allpermissionsinfo
-- ----------------------------
DROP VIEW IF EXISTS `view_cube_allpermissionsinfo`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `view_cube_allpermissionsinfo` AS select `r`.`RoleName` AS `RoleName`,`cu`.`Instance` AS `Instance`,`cu`.`DataBases` AS `DataBases`,`cu`.`Cube` AS `Cube` from (`cube_settingallpermissions` `cu` join `system_roleinfo` `r` on((`cu`.`RoleID` = `r`.`ID`))) where ((`r`.`Validity` = '1') and (`cu`.`Validity` = '1'));

-- ----------------------------
-- View structure for view_cube_config
-- ----------------------------
DROP VIEW IF EXISTS `view_cube_config`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `view_cube_config` AS select `a`.`Id` AS `DataSourceID`,`b`.`Id` AS `CatalogID`,`c`.`Id` AS `CubeID`,`d`.`Id` AS `DimensionID`,`e`.`Id` AS `AttributeID`,`c`.`Cube_CodeName` AS `Cube_CodeName`,`a`.`DataSource` AS `DataSource`,`a`.`DataSource_PageName` AS `DataSource_PageName`,`b`.`Catalog` AS `Catalog`,`b`.`Catalog_PageName` AS `Catalog_PageName`,`c`.`Cube_Name` AS `Cube_Name`,`c`.`Cube_PageName` AS `Cube_PageName`,`d`.`Dimension_Name` AS `Dimension_Name`,`d`.`Dimension_PageName` AS `Dimension_PageName`,`e`.`Attribute_Name` AS `Attribute_Name`,`e`.`InterfaceType` AS `InterfaceType`,'1' AS `Validity`,`e`.`CreateTime` AS `CreateTime`,`e`.`Creater` AS `Creater`,`e`.`UpdateTime` AS `UpdateTime`,`e`.`Updater` AS `Updater` from ((((`cube_datasourceconfig` `a` join `cube_catalogconfig` `b` on((`a`.`Id` = `b`.`DataSourceId`))) join `cube_cubeconfig` `c` on((`b`.`Id` = `c`.`CatalogId`))) join `cube_dimensionconfig` `d` on((`c`.`Id` = `d`.`CubeId`))) join `cube_attributeconfig` `e` on((`d`.`Id` = `e`.`DimensionId`)));

-- ----------------------------
-- View structure for view_cube_permissionsinfo
-- ----------------------------
DROP VIEW IF EXISTS `view_cube_permissionsinfo`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `view_cube_permissionsinfo` AS select `r`.`RoleName` AS `RoleName`,`cu`.`DataSource` AS `DataSource`,`cu`.`Catalog` AS `Catalog`,`cu`.`Cube_Name` AS `Cube_Name`,`cu`.`Dimension_Name` AS `Dimension_Name`,`cu`.`Attribute_Name` AS `Attribute_Name`,`per`.`Description` AS `Description` from ((`view_cube_config` `cu` join `cube_security_access` `per` on((`cu`.`AttributeID` = `per`.`SSASDBID`))) join `system_roleinfo` `r` on((`per`.`RoleId` = `r`.`ID`))) where ((`per`.`Validity` = '1') and (`r`.`Validity` = '1') and (`cu`.`Validity` = '1'));

-- ----------------------------
-- View structure for view_dc_datafilelog
-- ----------------------------
DROP VIEW IF EXISTS `view_dc_datafilelog`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `view_dc_datafilelog` AS select distinct `b`.`ID` AS `ID`,`b`.`BatchTag` AS `BatchTag`,`b`.`FileName` AS `FileName`,`b`.`FileType` AS `FileType`,`b`.`FileSize` AS `FileSize`,`b`.`ImportDate` AS `ImportDate`,`b`.`ImportType` AS `ImportType`,`b`.`CreateTime` AS `CreateTime`,`b`.`Creater` AS `Creater`,`b`.`UpdateTime` AS `UpdateTime`,`b`.`Updater` AS `Updater`,`b`.`Validity` AS `Validity`,`a`.`FileNo` AS `FileNo` from (`dc_datafile` `a` join `dc_datafilelog` `b` on((`a`.`FileType` = `b`.`FileType`))) where ((`a`.`Validity` = '1') and (`b`.`Validity` = '1'));

-- ----------------------------
-- View structure for view_report_permissionsinfo
-- ----------------------------
DROP VIEW IF EXISTS `view_report_permissionsinfo`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `view_report_permissionsinfo` AS select `r`.`RoleName` AS `RoleName`,`rc`.`ReportName` AS `ReportName` from ((`reportconfig` `rc` join `system_rolereportassignment` `per` on((`rc`.`ID` = `per`.`ReportID`))) join `system_roleinfo` `r` on((`per`.`RoleID` = `r`.`ID`))) where ((`per`.`Validity` = '1') and (`r`.`Validity` = '1') and (`rc`.`Validity` = '1'));

-- ----------------------------
-- View structure for viw_reportconfig
-- ----------------------------
DROP VIEW IF EXISTS `viw_reportconfig`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `viw_reportconfig` AS select `a`.`ID` AS `ID`,`a`.`ReportGroupID` AS `ReportGroupID`,`a`.`ReportID` AS `ReportID`,`a`.`ReportName` AS `ReportName`,`a`.`ReportUrl` AS `ReportUrl`,`a`.`ReportDesc` AS `ReportDesc`,`a`.`ReportType` AS `ReportType`,`a`.`Visit` AS `Visit`,`c`.`FolderName` AS `FolderName`,`c`.`PID` AS `PID`,`c`.`ID` AS `FolderID`,(case when (`c`.`PID` = '1') then `c`.`FolderName` else `d`.`FolderName` end) AS `ParentFolderName`,`d`.`PID` AS `ParentFolderCode`,`d`.`ID` AS `ParentFolderID` from (((`reportconfig` `a` join `folderreportassignment` `b` on((`a`.`ID` = `b`.`ReportID`))) join `folderinfo` `c` on((`b`.`FolderID` = `c`.`ID`))) left join (select `folderinfo`.`ID` AS `ID`,`folderinfo`.`PID` AS `PID`,`folderinfo`.`FolderName` AS `FolderName`,`folderinfo`.`Creater` AS `Creater`,`folderinfo`.`CreateTime` AS `CreateTime`,`folderinfo`.`UpdateTime` AS `UpdateTime`,`folderinfo`.`Updater` AS `Updater`,`folderinfo`.`Validity` AS `Validity`,`folderinfo`.`OrderID` AS `OrderID` from `folderinfo` where (`folderinfo`.`Validity` = 1)) `d` on((`c`.`PID` = `d`.`ID`))) where ((`a`.`Validity` = 1) and (`b`.`Validity` = 1) and (`c`.`Validity` = 1));

-- ----------------------------
-- View structure for viw_reportviewhistory
-- ----------------------------
DROP VIEW IF EXISTS `viw_reportviewhistory`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `viw_reportviewhistory` AS select `rh`.`ID` AS `ID`,`rh`.`ReportID` AS `ReportID`,`rh`.`Viewer` AS `Viewer`,`rh`.`ViewTime` AS `ViewTime`,`rh`.`ViewerIP` AS `ViewerIP`,`r`.`ReportName` AS `ReportName` from (`reportviewhistory` `rh` join `viw_reportconfig` `r` on((`rh`.`ReportID` = `r`.`ID`)));

-- ----------------------------
-- View structure for viw_system_userinfo
-- ----------------------------
DROP VIEW IF EXISTS `viw_system_userinfo`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `viw_system_userinfo` AS select `system_userinfo`.`ID` AS `ID`,`system_userinfo`.`UserAccount` AS `UserAccount`,`system_userinfo`.`UserName` AS `UserName`,`system_userinfo`.`UserAccount` AS `Viewer` from `system_userinfo` where (`system_userinfo`.`Validity` = 1);

-- ----------------------------
-- Procedure structure for Cube_STGIntoODS
-- ----------------------------
DROP PROCEDURE IF EXISTS `Cube_STGIntoODS`;
delimiter ;;
CREATE PROCEDURE `Cube_STGIntoODS`()
BEGIN
    -- Truncate the target table
    TRUNCATE TABLE Cube_ValidUserAllowSet;

    -- Temporary tables to hold data
    DROP TEMPORARY TABLE IF EXISTS CubeRoleUser;
    DROP TEMPORARY TABLE IF EXISTS OLD_MH;
    DROP TEMPORARY TABLE IF EXISTS NEW_MH;
    DROP TEMPORARY TABLE IF EXISTS MH;
    DROP TEMPORARY TABLE IF EXISTS AllMembersTemp;
    DROP TEMPORARY TABLE IF EXISTS tab;
		DROP TEMPORARY TABLE IF EXISTS tab2;
		DROP TEMPORARY TABLE IF EXISTS tab3;
		DROP TEMPORARY TABLE IF EXISTS tab4;
		DROP TEMPORARY TABLE IF EXISTS taball;
		DROP TEMPORARY TABLE IF EXISTS TEMP;

    -- Create CubeRoleUser temporary table
    CREATE TEMPORARY TABLE CubeRoleUser AS
    SELECT c.UserAccount
    FROM System_RoleInfo AS a
    JOIN System_UserRoleAssignment AS b ON a.ID = b.RoleID
    JOIN System_UserInfo AS c ON b.UserID = c.ID
    WHERE a.CubeType = 1
    GROUP BY c.UserAccount;

    -- Create OLD_MH temporary table
    CREATE TEMPORARY TABLE OLD_MH AS
    SELECT DISTINCT b.ID, d.RoleId, a.UserAccount, d.MEMBER_UNIQUE_NAME, d.SSASDBID, f.DataSource, f.Catalog, f.Cube_Name, f.Dimension_Name, f.Attribute_Name
    FROM System_UserInfo AS a
    JOIN System_UserRoleAssignment AS b ON a.ID = b.UserID AND b.Validity = '1' AND a.Validity = '1'
    JOIN System_RoleInfo AS c ON b.RoleID = c.ID AND c.Validity = '1'
    JOIN Cube_Security_Access AS d ON c.ID = d.RoleId AND d.Validity = '1' AND NodeStatus = '1'
    JOIN View_Cube_Config AS f ON d.SSASDBID = f.AttributeID
    WHERE a.CubeType = 1
    UNION ALL
    SELECT DISTINCT b.ID, d.RoleId, a.UserAccount, d.MEMBER_UNIQUE_NAME, d.SSASDBID, f.DataSource, f.Catalog, f.Cube_Name, f.Dimension_Name, f.Attribute_Name
    FROM CubeRoleUser AS e
    JOIN System_UserInfo AS a ON a.UserAccount = e.UserAccount
    JOIN System_UserRoleAssignment AS b ON a.ID = b.UserID AND b.Validity = '1' AND a.Validity = '1'
    JOIN System_RoleInfo AS c ON b.RoleID = c.ID AND c.Validity = '1'
    JOIN Cube_Security_Access AS d ON c.ID = d.RoleId AND d.Validity = '1' AND NodeStatus = '1'
    JOIN View_Cube_Config AS f ON d.SSASDBID = f.AttributeID;

    -- Create NEW_MH temporary table
    CREATE TEMPORARY TABLE NEW_MH AS
    SELECT DISTINCT b.ID, d.RoleId, a.UserAccount, d.MEMBER_UNIQUE_NAME, d.SSASDBID, f.DataSource, f.Catalog, f.Cube_Name, f.Dimension_Name, f.Attribute_Name
    FROM System_UserInfo AS a
    JOIN System_UserRoleAssignment AS b ON a.ID = b.UserID AND b.Validity = '1' AND a.Validity = '1'
    JOIN System_RoleInfo AS c ON b.RoleID = c.ID AND c.Validity = '1'
    JOIN Cube_Security_Access AS d ON c.ID = d.RoleId AND d.Validity = '1' AND NodeStatus = '1'
    JOIN View_Cube_Config AS f ON d.SSASDBID = f.AttributeID
    WHERE c.CubeType = 1 OR a.CubeType = 1;

    -- Create MH temporary table
    CREATE TEMPORARY TABLE MH AS
    SELECT DISTINCT
        COALESCE(b.RoleId, a.RoleId) AS RoleId,
        COALESCE(b.UserAccount, a.UserAccount) AS UserAccount,
        COALESCE(b.MEMBER_UNIQUE_NAME, 'DELETE') AS MEMBER_UNIQUE_NAME,
        a.SSASDBID, a.DataSource, a.Catalog, a.Cube_Name, a.Dimension_Name, a.Attribute_Name
    FROM OLD_MH AS a
    LEFT JOIN NEW_MH AS b ON a.UserAccount = b.UserAccount AND a.SSASDBID = b.SSASDBID;

    -- Create AllMembersTemp temporary table
    CREATE TEMPORARY TABLE AllMembersTemp AS
    SELECT RoleId, SSASDBID, UserAccount
    FROM MH
    GROUP BY RoleId, SSASDBID, UserAccount;
		

		-- 创建 AllMembersTemp1 临时表
		CREATE TEMPORARY TABLE tab AS (
				SELECT DISTINCT RoleId, UserAccount
				FROM AllMemberstemp
		);

		CREATE TEMPORARY TABLE tab2 AS (
				SELECT UserAccount, COUNT(RoleId) AS RoleCounts
				FROM tab
				GROUP BY UserAccount
		);

		CREATE TEMPORARY TABLE tab3 AS (
				SELECT RoleId, SSASDBID, UserAccount,
							 ROW_NUMBER() OVER(PARTITION BY UserAccount, SSASDBID ORDER BY RoleId) AS num
				FROM AllMemberstemp
		);

		CREATE TEMPORARY TABLE tab4 AS (
				SELECT UserAccount, SSASDBID, MAX(num) AS num
				FROM tab3
				GROUP BY UserAccount, SSASDBID
		);

		-- 创建最终的临时表 AllMemberstemp1
		CREATE TEMPORARY TABLE AllMemberstemp1 AS
		SELECT a.RoleCounts, b.*
		FROM tab2 a
		JOIN tab4 b ON a.UserAccount = b.UserAccount
		WHERE a.RoleCounts <> b.num;

    -- Create taball temporary table
 CREATE TEMPORARY TABLE taball AS 
    SELECT 
        MEMBER_UNIQUE_NAME AS AllowSet,
        DataSource,
        Catalog,
        REPLACE(REPLACE(Cube_Name, '[', ''), ']', '') AS Cube_Name,
        REPLACE(REPLACE(Dimension_Name, '[', ''), ']', '') AS Dimension_Name,
        REPLACE(REPLACE(Attribute_Name, '[', ''), ']', '') AS Attribute_Name,
        UserAccount AS ADAccount
    FROM MH;

		CREATE TEMPORARY TABLE TEMP AS
		SELECT 
				DataSource,
				Catalog,
				Cube_Name,
				Dimension_Name,
				Attribute_Name,
				ADAccount,
				REPLACE(GROUP_CONCAT(AllowSet SEPARATOR ','), '&amp;', '&') AS AllowSet
		FROM taball t1
		GROUP BY 
				DataSource,
				Catalog,
				Cube_Name,
				Dimension_Name,
				Attribute_Name,
				ADAccount
				;

    -- Update AllowSet values
    UPDATE TEMP AS T
    JOIN View_Cube_Config AS C ON T.DataSource = C.DataSource
                                 AND T.Catalog = C.Catalog
                                 AND CONCAT('[', T.Cube_Name, ']') = C.Cube_Name
                                 AND CONCAT('[', T.Dimension_Name, ']') = C.Dimension_Name
                                 AND CONCAT('[', T.Attribute_Name, ']') = C.Attribute_Name
    JOIN AllMembersTemp1 AS M ON M.SSASDBID = C.AttributeID
                               AND CONCAT('SQLAD\\', M.UserAccount) = T.ADAccount
    SET T.AllowSet = CONCAT(C.Dimension_Name, '.', C.Attribute_Name, '.ALLMEMBERS');

    -- Merge into Cube_ValidUserAllowSet
    INSERT INTO Cube_ValidUserAllowSet (`UserAccount`, `DataSource`, `Catalog`, `Cube`, `Dimension`, `Attribute`, `Desc`, `AllowSet`, `CreateTime`, `UpdateTime`, `Creater`, `Updater`, `Validity`)
    SELECT S.AdAccount, S.DataSource, S.Catalog, S.Cube_Name, S.Dimension_Name, S.Attribute_Name, S.AllowSet, S.AllowSet, NOW(), NOW(), 'system', 'system', 0
    FROM TEMP AS S
    LEFT JOIN Cube_ValidUserAllowSet AS T ON T.UserAccount = S.AdAccount
                                             AND T.DataSource = S.DataSource
                                             AND T.Catalog = S.Catalog
                                             AND T.Cube = S.Cube_Name
                                             AND T.Dimension = S.Dimension_Name
                                             AND T.Attribute = S.Attribute_Name
    WHERE T.UserAccount IS NULL;

    -- Additional updates and deletes
    UPDATE Cube_ValidUserAllowSet
    SET `Desc` = CONCAT('[', Dimension, '].', '[', Attribute, '].ALLMEMBERS'),
        AllowSet = CONCAT('[', Dimension, '].', '[', Attribute, '].ALLMEMBERS')
    WHERE AllowSet IS NULL OR AllowSet LIKE '%.[All]%';

    DELETE FROM Cube_ValidUserAllowSet WHERE UserAccount IS NULL;

END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for InsertUsers
-- ----------------------------
DROP PROCEDURE IF EXISTS `InsertUsers`;
delimiter ;;
CREATE PROCEDURE `InsertUsers`()
BEGIN
    DECLARE i INT DEFAULT 0;
    DECLARE userAccount VARCHAR(255);
    DECLARE userName VARCHAR(255);

    -- 开始循环
    WHILE i < 10000 DO
        -- 拼接 UserAccount 和 UserName
        SET userAccount = CONCAT('admin', i);
        SET userName = CONCAT('admin', i);

        -- 插入数据
        INSERT INTO `dip_db`.`system_userinfo`(
            `ID`, `Type`, `ADID`, `UserAccount`, `UserName`, `UserPwd`, `Salt`, `Email`, `ICon`, `CubeType`, `LegalEntity`, `Platform`, `Department`, `Team`, `CreateTime`, `Creater`, `UpdateTime`, `Updater`, `Validity`
        ) VALUES (
            UUID(), 'Local', NULL, userAccount, userName, '', '91d5dd43-9780-4965-98cb-b26a2bfd915f', 'admin', NULL, '0', NULL, NULL, NULL, NULL, '2020-03-03 18:23:03', 'yhxu', '2024-10-22 15:23:11', 'admin', '1'
        );

        -- 递增下标
        SET i = i + 1;
    END WHILE;
END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for insert_million_rows
-- ----------------------------
DROP PROCEDURE IF EXISTS `insert_million_rows`;
delimiter ;;
CREATE PROCEDURE `insert_million_rows`()
BEGIN
    DECLARE i INT DEFAULT 0;
    WHILE i < 1000000 DO
        INSERT INTO test_table (name,code) VALUES (CONCAT('n',i),CONCAT('c',i));
        SET i = i + 1;
        -- 每1000条提交一次
        IF i % 1000 = 0 THEN
            COMMIT;
            START TRANSACTION;
        END IF;
    END WHILE;
    COMMIT;
END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for sp_SyncUserRoles
-- ----------------------------
DROP PROCEDURE IF EXISTS `sp_SyncUserRoles`;
delimiter ;;
CREATE PROCEDURE `sp_SyncUserRoles`()
BEGIN
	#Routine body goes here...
    -- 声明变量
    DECLARE done INT DEFAULT FALSE;
    DECLARE role_name VARCHAR(255);
    DECLARE user_email VARCHAR(255);
    DECLARE role_id VARCHAR(255);
    DECLARE user_id VARCHAR(255);
		DECLARE ii INT DEFAULT 0;
    -- 定义游标
    DECLARE userRoleCursor CURSOR FOR 
    SELECT RoleName, Email FROM dip_db.batch_insert_user_role;

    -- 定义结束处理程序
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    -- 开启事务
    START TRANSACTION;

    -- 打开游标
    OPEN userRoleCursor;

    -- 循环处理每条数据
		read_loop: LOOP
				-- 从游标中获取第一条数据
				FETCH userRoleCursor INTO role_name, user_email;
		    IF done THEN
            LEAVE read_loop;
        END IF;
				
				-- 判断角色是否存在不存咋则创建
				SELECT ID INTO role_id FROM dip_db.system_roleinfo WHERE RoleName = role_name;
        IF role_id IS NULL THEN
						SET role_id = UUID();
            INSERT INTO system_roleinfo (ID, RoleName, RoleDesc, Creater, CreateTime, Validity) 
            VALUES (role_id, role_name, role_name, 'SP', NOW(), '1');
				ELSE
						SET ii = ii+1;
        END IF;
				
				-- 判断用户是否存在，不存在则不添加
				SELECT ID INTO user_id FROM dip_db.system_userinfo as a  WHERE a.Email = user_email;
        IF user_id IS NOT NULL THEN
            IF NOT EXISTS (SELECT 1 FROM dip_db.system_userroleassignment as ur WHERE ur.RoleID = role_id AND ur.UserID = user_id AND ur.Validity ='1') THEN 
							INSERT INTO dip_db.system_userroleassignment (ID, RoleID, UserID, Creater, CreateTime, Validity) 
							VALUES (UUID(), role_id, user_id, 'SP', NOW(), '1');
						END IF;
        END IF;
				
				-- 清空role_id 和user_id  SELECT ID INTO role_id 如果找不到行 不会给role_id 复制
				SET role_id = NULL;
				SET user_id = NULL;
				
    END LOOP read_loop;

    -- 关闭游标
    CLOSE userRoleCursor;

    -- 提交事务
    COMMIT;
		SELECT ii;

END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for sp_SyncUserRolesV2
-- ----------------------------
DROP PROCEDURE IF EXISTS `sp_SyncUserRolesV2`;
delimiter ;;
CREATE PROCEDURE `sp_SyncUserRolesV2`()
BEGIN
	    -- 声明变量
    DECLARE done INT DEFAULT FALSE;
    DECLARE role_name VARCHAR(255);
    DECLARE user_email VARCHAR(255);
    DECLARE role_id VARCHAR(255);
    DECLARE user_id VARCHAR(255);
    DECLARE ii INT DEFAULT 0;
		DECLARE total_records INT DEFAULT 0;
		DECLARE current_row INT DEFAULT 0;
    
    -- 创建临时表存储查询结果
    CREATE TEMPORARY TABLE IF NOT EXISTS temp_user_roles (
        RoleName VARCHAR(255),
        Email VARCHAR(255)
    );

    -- 将数据插入临时表
    INSERT INTO temp_user_roles (RoleName, Email)
    SELECT RoleName, Email FROM dip_db.batch_insert_user_role;

    -- 获取记录数
    SELECT COUNT(*) INTO total_records FROM temp_user_roles;

		-- 开始事务
    START TRANSACTION;

		WHILE current_row < total_records DO
        -- 获取当前记录
        SELECT RoleName, Email INTO role_name, user_email
        FROM temp_user_roles
        LIMIT current_row, 1;
				select current_row;

        -- 判断角色是否存在，不存在则创建
        SELECT ID INTO role_id FROM dip_db.system_roleinfo WHERE RoleName = role_name;
        IF role_id IS NULL THEN
            SET role_id = UUID();
            INSERT INTO system_roleinfo (ID, RoleName, RoleDesc, Creater, CreateTime, Validity) 
            VALUES (role_id, role_name, role_name, 'SP', NOW(), '1');
        END IF;

        -- 判断用户是否存在，不存在则不添加
        SELECT ID INTO user_id FROM dip_db.system_userinfo WHERE Email = user_email;
        IF user_id IS NOT NULL THEN
            IF NOT EXISTS (SELECT 1 FROM dip_db.system_userroleassignment WHERE RoleID = role_id AND UserID = user_id AND Validity = '1') THEN
                INSERT INTO dip_db.system_userroleassignment (ID, RoleID, UserID, Creater, CreateTime, Validity)
                VALUES (UUID(), role_id, user_id, 'SP', NOW(), '1');
            END IF;
        END IF;

				-- 清空user_id 和role_id
				SET user_id = null;
				SET role_id = null;
				
				
        -- 增加计数器
        SET current_row = current_row + 1;
    END WHILE;

		-- 提交事务
    COMMIT;

    -- 删除临时表
    DROP TEMPORARY TABLE IF EXISTS temp_user_roles;

END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;
