-- 第一步：创建允许任何主机连接的 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 ','), '&', '&') 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;