create schema smconfig;
create schema smapp000;
create schema smapp001;
create schema smapp002;
create schema smapp003;
create schema smapp004;
create schema smapp005;
create schema smapp006;
create schema smapp007;
create schema smapp008;
create schema smapp009;
create schema smapp010;
create schema smapp011;
create schema smapp012;
create schema smapp013;
create schema smapp014;
create schema smapp015;
create schema smapp016;
create schema smapp017;
create schema smapp018;
create schema smapp019;
修改context.xml
创建系统表
CREATE TABLE SYS_TIMER_TASK (
TASKID BIGINT NOT NULL,
TASK_NAME VARCHAR(256) NOT NULL,
APPID VARCHAR(32),
DESCRIPTION VARCHAR(2000),
SETTINGS VARCHAR(20) NOT NULL,
COMMAND VARCHAR(2000) NOT NULL,
TIMES INTEGER NOT NULL,
LAST_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
NEXT_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (TASKID)
);
--应用集定义表 start--
CREATE TABLE SYS_APPLICATION (
APPID VARCHAR(32) NOT NULL,
NAME VARCHAR(256) NOT NULL,
DESCRIPTION VARCHAR(2048),
NAME_1 VARCHAR(256),
DESCRIPTION_1 VARCHAR(2048),
NAME_2 VARCHAR(256),
DESCRIPTION_2 VARCHAR(2048),
NAME_3 VARCHAR(256),
DESCRIPTION_3 VARCHAR(2048),
DATASOURCE VARCHAR(256) NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (APPID)
);
--应用集定义表 end--
--附件表 start--
CREATE TABLE SYS_ATTACHMENT (
HASHCODE VARCHAR(128) NOT NULL,
NAME VARCHAR(2000),
TYPE VARCHAR(256),
LENGTH BIGINT NOT NULL,
DATA TEXT NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
UPLOAD_TIME TIMESTAMP NOT NULL DEFAULT NOW(),
UPLOADER INTEGER NOT NULL,
HASHSUM VARCHAR(256),
PRIMARY KEY (HASHCODE)
);
--附件表 end--
--功能定义表 start--
CREATE TABLE SYS_FEATURE (
FEATUREID BIGINT NOT NULL,
APPID VARCHAR(32),
CODE VARCHAR(64) NOT NULL,
NAME VARCHAR(256) NOT NULL,
DESCRIPTION VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (FEATUREID)
);
--功能定义表 end--
--菜单定义表 start--
CREATE TABLE SYS_MENU (
MENUID INTEGER NOT NULL,
CODE VARCHAR(32) NOT NULL,
APPID VARCHAR(32),
NAME VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(256),
MASK VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (MENUID)
);
CREATE TABLE SYS_MENU_ITEM (
ITEMID BIGINT NOT NULL,
MENUID INTEGER NOT NULL,
APPID VARCHAR(32),
PARENTID BIGINT,
CODE VARCHAR(32) NOT NULL,
CODE_PATH VARCHAR(2000) NOT NULL,
NAME VARCHAR(64) NOT NULL,
MASK VARCHAR(32),
DESCRIPTION VARCHAR(256),
COMMAND VARCHAR(64),
URL VARCHAR(2048),
WEIGHTS INTEGER DEFAULT 99 NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ITEMID)
);
--菜单定义表 end--
--数据模型定义表 start--
CREATE TABLE SYS_MODULE (
MODULEID BIGINT NOT NULL,
APPID VARCHAR(32),
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(256) NOT NULL,
DESCRIPTION VARCHAR(2000),
TABLE_NAME VARCHAR(128) NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (MODULEID)
);
CREATE TABLE SYS_MODULE_FEATURE (
FEATUREID BIGINT NOT NULL,
MODULEID BIGINT NOT NULL,
APPID VARCHAR(32),
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(256) NOT NULL,
DESCRIPTION VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (FEATUREID, MODULEID)
);
CREATE TABLE SYS_MODULE_ITEM (
ITEMID BIGINT NOT NULL,
MODULEID BIGINT NOT NULL,
APPID VARCHAR(32),
COLUMN_NAME VARCHAR(256) NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ITEMID, MODULEID)
);
--数据模型定义表 end--
--权限定义表 start--
CREATE TABLE SYS_ROLE (
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ROLEID)
);
CREATE TABLE SYS_ROLE_FEATURE (
FEATUREID BIGINT NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (FEATUREID, ROLEID)
);
CREATE TABLE SYS_ROLE_MENU (
MENUID INTEGER NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
IDX BIGINT NOT NULL,
PRIMARY KEY (IDX)
);
CREATE TABLE SYS_ROLE_MENU_ITEM (
ITEMID BIGINT NOT NULL,
MENUID INTEGER NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
IDX BIGINT NOT NULL,
PRIMARY KEY (IDX)
);
CREATE TABLE SYS_ROLE_MODULE_RULE (
RULEID BIGINT NOT NULL,
MODULEID BIGINT NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FEATUREID BIGINT NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (RULEID)
);
CREATE TABLE SYS_ROLE_MODULE_RULE_ITEM (
ITEMID BIGINT NOT NULL,
APPID VARCHAR(32),
RULEID BIGINT NOT NULL,
MODULE_ITEMID BIGINT NOT NULL,
ITEM_VALUES VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ITEMID)
);
--权限定义表 end--
--LDAP配置表 start--
CREATE TABLE SYS_LDAP_CONFIG (
AD_NAME VARCHAR(255) NOT NULL ,
SERVICE_TYPE INTEGER NOT NULL ,
IP_ADDRESS VARCHAR(255) NOT NULL ,
PROTOCOL_TYPE INTEGER NOT NULL ,
PORT INTEGER NOT NULL ,
ACCOUNT VARCHAR(255) NOT NULL ,
PASSWORD VARCHAR(255) NOT NULL ,
CATALOG VARCHAR(255) NOT NULL ,
MAPPING_RELATIONSHIP VARCHAR(1024),
FLAGS INTEGER NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW(),
MODIFIER INTEGER NOT NULL ,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
UUID VARCHAR(40) NOT NULL ,
KEYSTORE_PATH VARCHAR(255) ,
KEYSTORE_PASSWORD VARCHAR(255) ,
PATH_FIX_FLAG INTEGER ,
PATH_FIX_SUFFIX VARCHAR(255),
PRIMARY KEY (UUID)
);
--LDAP配置表 end--
--样式定义表 start--
CREATE TABLE SYS_STYLE_DEFINED (
STYLEID BIGINT NOT NULL,
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(256),
STYLECONTENT VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (STYLEID)
);
CREATE TABLE SYS_STYLE_GLOBAL (
GLOBALID BIGINT NOT NULL,
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(256),
FLAGS INTEGER DEFAULT 0,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (GLOBALID)
);
CREATE TABLE SYS_STYLE_SELECTOR (
SELECTORID BIGINT NOT NULL,
GLOBALID BIGINT NOT NULL,
DIRECTION INTEGER NOT NULL,
PLACE INTEGER,
NODETYPE INTEGER,
STYLEID BIGINT NOT NULL,
FLAGS INTEGER NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (SELECTORID)
);
--样式定义表 end--
CREATE TABLE SYS_LOG (
UUID VARCHAR(36) NOT NULL,
TRACKID VARCHAR(36) ,
USERID VARCHAR(36) ,
APPID VARCHAR(36) ,
MODULE VARCHAR(30) ,
OPERATION VARCHAR(10) ,
LOGTITLE VARCHAR(200) ,
LOGEXPLAIN VARCHAR(520) ,
BIZKEY VARCHAR(32),
CLIENTIP VARCHAR(30),
CLIENTTYPE VARCHAR(20),
CLIENTVERSION VARCHAR(30),
PATH VARCHAR(200),
PARAMS VARCHAR(4000) ,
RESULTJSON VARCHAR(2048),
ISEXCEPTION VARCHAR(1) ,
ERRORMESSAGE VARCHAR(1024),
SENDTIME TIMESTAMP,
EXECUTETIME VARCHAR(100),
STATE VARCHAR(2),
SERVERVERSION VARCHAR(100),
FLAGS INTEGER NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW(),
PRIMARY KEY (UUID)
);
--用户表 start--
CREATE TABLE SYS_USER (
USERID INTEGER NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
UUID VARCHAR(36) NOT NULL,
PASSWORD VARCHAR(100) NOT NULL,
LAST_NAME VARCHAR(20),
MIDDLE_NAME VARCHAR(20),
FIRST_NAME VARCHAR(20),
NICKNAME VARCHAR(64),
NICKSN SMALLINT,
IDCARDNO VARCHAR(20),
MOBILE VARCHAR(20),
EMAIL VARCHAR(256),
GENDER SMALLINT,
BIRTHDAY DATE,
ADDRESS VARCHAR(256),
AUTHENTICATE_TYPE VARCHAR(20),
AUTHENTICATE_SERVER VARCHAR(40),
AUTH_USER_NAME VARCHAR(60),
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (USERID)
);
CREATE TABLE SYS_USER_AUTH (
AUTHID BIGINT NOT NULL,
USERID INTEGER NOT NULL,
USERNAME VARCHAR(256) NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
OPENID VARCHAR(256),
PRIMARY KEY (AUTHID)
);
--用户表 end--
--用户角色表 start--
CREATE TABLE SYS_USER_ROLES (
USERID INTEGER NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (USERID, ROLEID)
);
--用户角色表 end--
-- 全局样式引用表关系 start--
CREATE TABLE SYS_REPORT_STYLE
(
ID BIGINT not null,
GLOBALID BIGINT,
APPID VARCHAR(32),
REPORTID BIGINT,
MATRIXCODE VARCHAR(64),
PRIMARY KEY (ID)
);
-- 全局样式引用表关系 end--
--样式文件表 start--
CREATE TABLE SYS_STYLE_FILE (
ID BIGINT NOT NULL ,
CODE VARCHAR(256) NOT NULL ,
content TEXT NOT NULL ,
FLAGS INTEGER DEFAULT 0 NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (id)
);
--样式文件表 end--
-- 多语言表 start-- -
CREATE TABLE SYS_CONFIGURE_VALUES
(
CODE VARCHAR(256) not null,
VALUE VARCHAR(2000),
PRIMARY KEY (CODE)
);
-- 多语言表 end--
--备份导入导出日志表 start--
CREATE TABLE SYS_BACKUP_LOG
(
ID VARCHAR(64) NOT NULL ,
APPID VARCHAR(32) ,
START_TIME TIMESTAMP ,
END_TIME TIMESTAMP ,
FILE_NAME VARCHAR(200) ,
FILE_PATH VARCHAR(200) ,
DB_TYPE VARCHAR(20) ,
STATE VARCHAR(1) ,
BACKUP_TYPE VARCHAR(1) ,
INPUT_DATA VARCHAR(512) ,
FLAGS INTEGER DEFAULT 0 NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP DEFAULT NOW() NOT NULL ,
MODIFIER INTEGER NOT NULL ,
MODIFY_TIME TIMESTAMP DEFAULT NOW() NOT NULL ,
FILE_ID VARCHAR(32) ,
MIGRATION_TYPE VARCHAR(1) ,
ERROR_COUNT INTEGER DEFAULT 0 ,
ERROR_DATA TEXT
);
--备份导入导出日志表 end--
-- 第三方认证信息绑定 start--
CREATE TABLE SYS_USER_AUTHORIZATION_BINDING (
UUID VARCHAR(64) NOT NULL,
PROVIDER VARCHAR(64) NOT NULL,
USERNAME VARCHAR(64) NOT NULL,
AUTHORIZATION_TYPE VARCHAR(64) NOT NULL,
USERID BIGINT NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (UUID)
);
-- 第三方认证信息绑定 end--
-- 用户配置 start--
CREATE TABLE sys_user_configure(
creator INTEGER NOT NULL ,
code VARCHAR(64) NOT NULL ,
data TEXT ,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ,
modifier INTEGER NOT NULL ,
modify_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ,
flags INTEGER DEFAULT 0 NOT NULL ,
type INTEGER NOT NULL ,
userid INTEGER NOT NULL ,
PRIMARY KEY(userid, code )
);
-- 用户配置 end--
--sap操作日志表 start--
CREATE TABLE sys_data_import_oper_log (
ID VARCHAR(64) NOT NULL ,
APPID VARCHAR(32),
PID VARCHAR(64),
OPERATOR_ VARCHAR(64) NOT NULL ,
ETL_NAME VARCHAR(64),
PARAMS VARCHAR(2000),
STATUS_ INTEGER,
COUNT_ BIGINT,
START_TIME TIMESTAMP,
END_TIME TIMESTAMP,
SAP_TABLE_LOG_ID VARCHAR(64),
ERROR_COUNT BIGINT,
FLAGS INTEGER DEFAULT 0 NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL ,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ID)
);
--sap操作日志表 end--
--sap配置信息表 start-
CREATE TABLE SYS_SAP_TABLE_LOG (
ID VARCHAR(64) NOT NULL ,
APPID VARCHAR(32) ,
START_TIME TIMESTAMP ,
END_TIME TIMESTAMP ,
STATE VARCHAR(1) ,
TABLE_NAME VARCHAR(256) NOT NULL ,
GEN_FLAG VARCHAR(1) ,
PARAMS VARCHAR(512) ,
RESULTS VARCHAR(2000) ,
FLAGS INTEGER DEFAULT 0 NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ID)
);
--sap配置信息表 end-
-- 远程资源管理定义表 start--
CREATE TABLE biz_remote_define(
auth_type INTEGER NOT NULL ,
creator INTEGER NOT NULL ,
code VARCHAR(32) NOT NULL ,
address VARCHAR(256) NOT NULL ,
create_time TIMESTAMP DEFAULT now() NOT NULL ,
modifier INTEGER NOT NULL ,
modify_time TIMESTAMP DEFAULT now() NOT NULL ,
flags INTEGER DEFAULT 0 NOT NULL ,
encoding VARCHAR(64) ,
path VARCHAR(2000) ,
protocol VARCHAR(16) NOT NULL ,
password TEXT ,
port INTEGER ,
username VARCHAR(256) ,
PRIMARY KEY(code )
);
-- 远程资源管理定义表 end--
-- 远程资源管理信息绑定表 start--
CREATE TABLE biz_remote_resource_bind(
file_path VARCHAR(2000) NOT NULL ,
creator INTEGER NOT NULL ,
create_time TIMESTAMP DEFAULT now() NOT NULL ,
modifier INTEGER NOT NULL ,
modify_time TIMESTAMP DEFAULT now() NOT NULL ,
flags INTEGER DEFAULT 0 NOT NULL ,
remote_code VARCHAR(32) NOT NULL ,
keyword VARCHAR(2000) NOT NULL
);
-- 远程资源管理信息绑定表 end--
-- 用户最近访问历史 start--
CREATE TABLE sys_user_history(
creator INTEGER NOT NULL ,
action_time TIMESTAMP NOT NULL ,
data TEXT ,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ,
modifier INTEGER NOT NULL ,
modify_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ,
flags INTEGER DEFAULT 0 NOT NULL ,
id INTEGER NOT NULL ,
type VARCHAR(32) NOT NULL ,
userid INTEGER NOT NULL ,
PRIMARY KEY(id )
);
-- 用户最近访问历史 end--
INSERT INTO sys_user_configure VALUES (10000, 'personal.home-page', '{\"10000\":{\"accesshistory\":{\"code\":\"accesshistory\",\"show\":true,\"name\":\"最近访问\",\"_XID\":\"row_13\"},\"menulist\":{\"code\":\"menulist\",\"show\":true,\"name\":\"业务功能\",\"data\":{},\"_XID\":\"row_14\"},\"todos\":{\"code\":\"todos\",\"show\":true,\"name\":\"待办事项\",\"_XID\":\"row_15\"},\"dashboard\":{\"code\":\"dashboard\",\"show\":true,\"name\":\"主要指标\",\"data\":{},\"_XID\":\"row_16\"},\"formtable\":{\"code\":\"formtable\",\"show\":true,\"name\":\"安全审计\",\"_XID\":\"row_17\"}}}', '2021-03-14 14:48:33', 10000, '2021-03-22 14:20:03', 0, 0, 10000);
-- 多语言表初始化 start--
INSERT INTO SYS_CONFIGURE_VALUES (CODE, VALUE)
VALUES ('System.I18n', 'zh-CN;en-US;;');
-- 多语言表初始化 end--
-- 系统用户admin初始化 start--
INSERT INTO SYS_USER(USERID, FLAGS, UUID, PASSWORD, LAST_NAME, MIDDLE_NAME, FIRST_NAME, NICKNAME, NICKSN, IDCARDNO, MOBILE, EMAIL, GENDER, BIRTHDAY, ADDRESS, CREATOR, MODIFIER,AUTHENTICATE_TYPE,AUTHENTICATE_SERVER,AUTH_USER_NAME) VALUES(10000, 32772, 'f4c51272-b84a-4ae4-94e0-0ded76c42352', '3ec751a8e37a8ba39ac8795808e14ce33eef8e443d813844fcc6ff004639c01257068c578efa9f7c', NULL, NULL, 'admin', 'admin', 3512, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0,null,null,null);
INSERT INTO SYS_USER_AUTH(AUTHID, USERID, USERNAME, FLAGS, OPENID) VALUES(1, 10000, 'admin', 0, NULL);
-- 系统用户admin初始化 end--
-- 菜单定义表 start--
INSERT INTO SYS_MENU(MENUID, CODE, APPID, NAME, DESCRIPTION, MASK, FLAGS, CREATOR, MODIFIER) VALUES(1, 'central_main', NULL, '系统菜单', '系统配置菜单', 'C000000000100055', 16384, 10000, 10000);
INSERT INTO SYS_MENU(MENUID, CODE, APPID, NAME, DESCRIPTION, MASK, FLAGS, CREATOR, MODIFIER) VALUES(2, 'main', NULL, '应用菜单', '应用菜单', 'C000000000100056', 16384, 10000, 10000);
-- 菜单定义表 end--
-- 菜单属性定 start--
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (1, 1, NULL, NULL, '1001', '1001', '系统配置', 'C00000000010003E', '设置及管理', 'config_global1', NULL, 1, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:53:19');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (2, 1, NULL, 1, '1002', '1001.1002', '全局', 'C00000000010003F', '参数配置', NULL, NULL, 1, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:53:39');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (3, 1, NULL, 2, '1003', '1001.1002.1003', '详情', 'C000000000100040', '全局配置', 'config_global', '/central/configure', 999999, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:20:35');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (4, 1, NULL, 1, '1004', '1001.1004', '应用集', 'T010900000000004', '应用集', NULL, NULL, 3, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:54:41');
-- INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (5, 1, NULL, 4, '1005', '1001.1004.1005', '模型预设', NULL, NULL, 'modal_preset', '/central/preset', 999981, 0, 10000, '2021-04-24 16:49:35', 10000, '2021-06-23 20:21:54');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (6, 1, NULL, 4, '1006', '1001.1004.1006', '应用维护', 'T01080100002', '应用管理', 'app_list', '/central/application', 999980, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:21:35');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (7, 1, NULL, 1, '1007', '1001.1007', '用户', 'T01050100002', '用户管理', NULL, NULL, 2, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:53:55');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (8, 1, NULL, 7, '1008', '1001.1007.1008', '用户维护', 'T01050100002', '用户管理', 'user_list', '/central/user', 999999, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:25:57');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (10, 1, NULL, 7, '1010', '1001.1007.1010', '在线用户', NULL, '在线用户管理', 'onlineuser', '/central/onlineuser', 960000, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-29 15:22:34');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (11, 1, NULL, 1, '1011', '1001.1011', '权限', 'T010900000000001', '权限管理', NULL, NULL, 4, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:54:54');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (12, 1, NULL, 11, '1012', '1001.1011.1012', '角色权限', 'T01090101002', '角色管理', 'role_list', '/central/permission/role', 999900, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:23:57');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (13, 1, NULL, 11, '1013', '1001.1011.1013', '用户角色', 'T010900000000003', '用户角色', 'user_role', '/central/permission/role/user_role', 999000, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (14, 1, NULL, 11, '1014', '1001.1011.1014', '功能维护', 'T010902000000002', '功能管理', 'feature_list', '/central/permission/feature', 999999, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:24:34');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (15, 1, NULL, 1, '1015', '1001.1015', '数据', 'C000000000100041', '系统备份', NULL, NULL, 5, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:55:13');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (16, 1, NULL, 15, '1016', '1001.1015.1016', '系统附件', 'C000000000100044', '文件管理', 'backup_files', '/central/attachment', 999700, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:25:06');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (17, 1, NULL, 15, '1017', '1001.1015.1017', '数据备份', 'C000000000100042', '数据备份', 'backup_import', '/central/backup_import', 999700, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (20, 1, NULL, 15, '1020', '1001.1015.1020', '外部数据导入', 'C00000000010005D', '数据导入', 'data_import', '/central/data_import', 999700, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:25:29');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (21, 1, NULL, 1, '1021', '1001.1021', '远程资源', 'T01050100053', '资源管理', NULL, NULL, 6, 4, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:59:37');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (22, 1, NULL, 21, '1022', '1001.1021.1022', 'FTP链接维护', 'T01050100054', '远程资源管理', 'remote_define', '/central/api/remote', 0, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:19:20');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (23, 1, NULL, 1, '1023', '1001.1023', '菜单', NULL, '菜单管理', NULL, '/central/menu', 99, 0, 1, '2021-03-08 13:54:49', 10000, '2021-06-25 09:21:41');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (24, 1, NULL, 23, '1024', '1001.1023.1024', '菜单维护', NULL, '菜单配置', 'menu_list', '/central/menu_config', 99, 0, 1, '2021-03-08 13:54:49', 10000, '2021-06-25 09:21:51');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (25, 1, NULL, 1, '1025', '1001.1025', '日志', NULL, NULL, NULL, NULL, 99, 0, 1, '2021-03-13 11:35:13', 10000, '2021-06-25 09:22:58');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (26, 1, NULL, 25, '1026', '1001.1025.1026', '审计日志', NULL, NULL, 'log_list', '/central/logging/bussiness', 99, 0, 1, '2021-03-13 11:35:13', 10000, '2021-06-25 09:23:15');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (27, 2, NULL, NULL, '1027', '1027', '数据模型', 'C00000000010004C', '数据模型', 'datamodel', NULL, 1, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:48:34');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (28, 2, NULL, 27, '1028', '1027.1028', '维度管理', 'T020201000000002', '维度管理', 'dimension', '/application/:appid/dimension', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (29, 2, NULL, 27, '1029', '1027.1029', '关键值管理', 'C00000000010004D', '关键值管理', 'keyfigure', '/application/:appid/keyfigure', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (30, 2, NULL, 27, '1030', '1027.1030', '数据集管理', 'T020F01000000002', '数据集', 'superdataset', '/application/:appid/superdataset', 0, 0, 0, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (31, 2, NULL, NULL, '1031', '1031', 'ETL', 'T020500000000001', 'ETL', 'etl', NULL, 99, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:50:24');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (32, 2, NULL, 31, '1032', '1031.1032', '数据源管理', 'T020501000000001', '数据源管理', 'datasource', '/application/:appid/etl/datasource', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (33, 2, NULL, 31, '1033', '1031.1033', '仓库管理', 'T020502000000003', '仓库管理', 'store', '/application/:appid/etl/storehouse', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (34, 2, NULL, 31, '1034', '1031.1034', '任务管理', 'T020503000000003', '任务管理', 'task', '/application/:appid/etl/task', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (35, 2, NULL, 31, '1035', '1031.1035', '作业管理', 'T020504000000003', '作业管理', 'job', '/application/:appid/etl/job', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (36, 2, NULL, 31, '1036', '1031.1036', '自定义参数', NULL, '自定义参数', 'parameter', '/application/:appid/etl/parameter', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (37, 2, NULL, NULL, '1037', '1037', '报表展示', 'C000000000100037', '报表展示', 'report_view', '/application/:appid/assistance/report_view', 2, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:49:05');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (38, 2, NULL, 37, '1038', '1037.1038', '所有文档', NULL, '所有文档', 'webreport', '/application/:appid/webreport/webreport', 99, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (39, 2, NULL, NULL, '1039', '1039', '工作流管理', NULL, '工作流管理', 'workflow', NULL, 98, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:49:53');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (40, 2, NULL, 39, '1040', '1039.1040', '用户分组', NULL, '用户分组', 'group', 'application/:appid/workflow/group', 960001, 4, 1, '2021-03-08 13:54:49', 10000, '2021-03-11 10:08:56');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (41, 2, NULL, 39, '1041', '1039.1041', '流程管理', NULL, '工作流过程设置', 'manage', 'application/:appid/workflow/manage', 960002, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (42, 2, NULL, 39, '1042', '1039.1042', '我的流程', NULL, '启动某流程', 'start', 'application/:appid/workflow/start', 960004, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (43, 2, NULL, 39, '1043', '1039.1043', '流程办理', NULL, '流程的审批,报表填写等', 'handle', 'application/:appid/workflow/handle', 960005, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (44, 2, NULL, 39, '1044', '1039.1044', '消息模板', NULL, '消息模板', 'messagetemplate', 'application/:appid/workflow/messagetemplate', 960007, 0, 1, '2021-03-08 13:54:49', 1, '2021-03-08 13:54:49');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (45, 2, NULL, 39, '1045', '1039.1045', '流程监控', NULL, '流程监控', 'myprocess', 'application/:appid/workflow/myprocess', 960010, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (46, 2, NULL, NULL, '1046', '1046', '数据锁定', NULL, '数据锁定', 'datalock', NULL, 99, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:49:34');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (47, 2, NULL, 46, '1047', '1046.1047', '锁信息', NULL, '锁信息', 'lockinfo', '/application/:appid/datalock/lockinfo', 960001, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (48, 2, NULL, 46, '1048', '1046.1048', '解锁申请', NULL, '解锁申请', 'unlockapplication', '/application/:appid/datalock/unlockapplication', 960002, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (49, 2, NULL, 46, '1049', '1046.1049', '列定义', NULL, '列定义', 'columndefine', '/application/:appid/datalock/columndefine', 960003, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (50, 2, NULL, 46, '1050', '1046.1050', '归档', NULL, '归档', 'archive', '/application/:appid/datalock/archive', 960004, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (51, 2, NULL, NULL, '1051', '1051', '仪表盘', NULL, '仪表盘', 'dashboard', NULL, 99, 4, 1, '2021-03-08 13:54:50', 10000, '2021-04-13 09:38:39');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (52, 2, NULL, 51, '1052', '1051.1052', '仪表盘', NULL, '仪表盘', 'dashboard', '/application/:appid/dashboard/dashboard', 99, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (53, 2, NULL, 51, '1053', '1051.1053', '图表', NULL, '图表', 'chart', '/application/:appid/dashboard/chart', 99, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (54, 2, NULL, 51, '1054', '1051.1054', '数据源', NULL, '数据源', 'datasources', '/application/:appid/dashboard/datasource', 99, 0, 1, '2021-03-08 13:54:49', 1, '2021-03-08 13:54:49');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (55, 2, NULL, 51, '1055', '1051.1055', '仪表盘查看', NULL, NULL, 'dashboardview', '/application/:appid/dashboard/datasourceview', 99, 0, 10000, '2021-04-15 13:41:56', 10000, '2021-04-15 13:47:19');
-- NSERT INTO sys_menu_item(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (56, 2, NULL, NULL, '1056', '1056', '合并', NULL, NULL, 'eventsmerge', NULL, 99, 4, 10000, '2021-04-15 13:41:56.139', 10000, '2021-04-15 13:41:56.139);
-- NSERT INTO sys_menu_item(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (57, 2, NULL, 56, '1057', '1056.1057', '科目附注映射', '科目附注映射', NULL, 'SubjectsMap', '/application/:appid/EventsMerge/SubjectsMap', 6, 4, 10000, '2021-04-15 13:41:56.139', 10000, '2021-04-15 13:41:56.139');
-- NSERT INTO sys_menu_item(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (58, 2, NULL, NULL, '1058', '1058', '超级表单', NULL, '超级表单', 'forms', NULL, 0, 0, 1, '2021-04-15 13:41:56.139', 1, '2021-04-15 13:41:56.139');
-- 菜单属性 end--
-- 功能定义初始化数据 start--
INSERT INTO SYS_FEATURE(FEATUREID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES(1, NULL, 'Design', '模板制作', 'Excel-制作模式功能', 4, 10000, 10000);
INSERT INTO SYS_FEATURE(FEATUREID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES(2, NULL, 'Navigat', '报表查询', 'Excel-查询模式功能', 4, 10000, 10000);
INSERT INTO SYS_FEATURE(FEATUREID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES(3, NULL, 'Input', '数据输入', 'Excel-输入模式功能', 4, 10000, 10000);
INSERT INTO SYS_FEATURE (FEATUREID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES (4, null, 'Allocation', '分摊', 'Excel-分摊功能', 4, 10000, 10000);
-- 功能定义初始化数据 end--
-- 数据模型定义数据初始化 start--
INSERT INTO SYS_MODULE(MODULEID, APPID, CODE, NAME, DESCRIPTION, TABLE_NAME, FLAGS, CREATOR, MODIFIER) VALUES(1, NULL, 'application', '应用集', '应用集', 'sys_application', 4, 10000, 10000);
INSERT INTO SYS_MODULE_FEATURE(FEATUREID, MODULEID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES(1, 1, NULL, 'READ', '读取', '读取应用集', 4, 10000, 10000);
INSERT INTO SYS_MODULE_ITEM(ITEMID, MODULEID, APPID, COLUMN_NAME, FLAGS, CREATOR, MODIFIER) VALUES(1, 1, NULL, 'appid', 4, 10000, 10000);
-- 数据模型定义数据初始化 end--
CREATE TABLE SYS_USER_PASSWD (
USERID INTEGER NOT NULL,
PASSWORD VARCHAR(100) NOT NULL,
ENABLED_TIME TIMESTAMP NOT NULL DEFAULT NOW(),
FLAGS INTEGER DEFAULT 0 NOT NULL ,
PRIMARY KEY (USERID, PASSWORD)
);
alter table sys_user add PSSWD_MODIFY_TIME TIMESTAMP;
update sys_user set PSSWD_MODIFY_TIME = now();
-- 新增函数--
create or replace function UUID_GENERATE_V4() RETURNS varchar(36)
AS $$
import uuid
return uuid.uuid1()
$$ LANGUAGE plpythonu;
-- 新增函数--
创建业务表
CREATE TABLE SYS_TIMER_TASK (
TASKID BIGINT NOT NULL,
TASK_NAME VARCHAR(256) NOT NULL,
APPID VARCHAR(32),
DESCRIPTION VARCHAR(2000),
SETTINGS VARCHAR(20) NOT NULL,
COMMAND VARCHAR(2000) NOT NULL,
TIMES INTEGER NOT NULL,
LAST_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
NEXT_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (TASKID)
);
--应用集定义表 start--
CREATE TABLE SYS_APPLICATION (
APPID VARCHAR(32) NOT NULL,
NAME VARCHAR(256) NOT NULL,
DESCRIPTION VARCHAR(2048),
NAME_1 VARCHAR(256),
DESCRIPTION_1 VARCHAR(2048),
NAME_2 VARCHAR(256),
DESCRIPTION_2 VARCHAR(2048),
NAME_3 VARCHAR(256),
DESCRIPTION_3 VARCHAR(2048),
DATASOURCE VARCHAR(256) NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (APPID)
);
--应用集定义表 end--
--附件表 start--
CREATE TABLE SYS_ATTACHMENT (
HASHCODE VARCHAR(128) NOT NULL,
NAME VARCHAR(2000),
TYPE VARCHAR(256),
LENGTH BIGINT NOT NULL,
DATA TEXT NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
UPLOAD_TIME TIMESTAMP NOT NULL DEFAULT NOW(),
UPLOADER INTEGER NOT NULL,
HASHSUM VARCHAR(256),
PRIMARY KEY (HASHCODE)
);
--附件表 end--
--功能定义表 start--
CREATE TABLE SYS_FEATURE (
FEATUREID BIGINT NOT NULL,
APPID VARCHAR(32),
CODE VARCHAR(64) NOT NULL,
NAME VARCHAR(256) NOT NULL,
DESCRIPTION VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (FEATUREID)
);
--功能定义表 end--
--菜单定义表 start--
CREATE TABLE SYS_MENU (
MENUID INTEGER NOT NULL,
CODE VARCHAR(32) NOT NULL,
APPID VARCHAR(32),
NAME VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(256),
MASK VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (MENUID)
);
CREATE TABLE SYS_MENU_ITEM (
ITEMID BIGINT NOT NULL,
MENUID INTEGER NOT NULL,
APPID VARCHAR(32),
PARENTID BIGINT,
CODE VARCHAR(32) NOT NULL,
CODE_PATH VARCHAR(2000) NOT NULL,
NAME VARCHAR(64) NOT NULL,
MASK VARCHAR(32),
DESCRIPTION VARCHAR(256),
COMMAND VARCHAR(64),
URL VARCHAR(2048),
WEIGHTS INTEGER DEFAULT 99 NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ITEMID)
);
--菜单定义表 end--
--数据模型定义表 start--
CREATE TABLE SYS_MODULE (
MODULEID BIGINT NOT NULL,
APPID VARCHAR(32),
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(256) NOT NULL,
DESCRIPTION VARCHAR(2000),
TABLE_NAME VARCHAR(128) NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (MODULEID)
);
CREATE TABLE SYS_MODULE_FEATURE (
FEATUREID BIGINT NOT NULL,
MODULEID BIGINT NOT NULL,
APPID VARCHAR(32),
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(256) NOT NULL,
DESCRIPTION VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (FEATUREID, MODULEID)
);
CREATE TABLE SYS_MODULE_ITEM (
ITEMID BIGINT NOT NULL,
MODULEID BIGINT NOT NULL,
APPID VARCHAR(32),
COLUMN_NAME VARCHAR(256) NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ITEMID, MODULEID)
);
--数据模型定义表 end--
--权限定义表 start--
CREATE TABLE SYS_ROLE (
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ROLEID)
);
CREATE TABLE SYS_ROLE_FEATURE (
FEATUREID BIGINT NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (FEATUREID, ROLEID)
);
CREATE TABLE SYS_ROLE_MENU (
MENUID INTEGER NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
IDX BIGINT NOT NULL,
PRIMARY KEY (IDX)
);
CREATE TABLE SYS_ROLE_MENU_ITEM (
ITEMID BIGINT NOT NULL,
MENUID INTEGER NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
IDX BIGINT NOT NULL,
PRIMARY KEY (IDX)
);
CREATE TABLE SYS_ROLE_MODULE_RULE (
RULEID BIGINT NOT NULL,
MODULEID BIGINT NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FEATUREID BIGINT NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (RULEID)
);
CREATE TABLE SYS_ROLE_MODULE_RULE_ITEM (
ITEMID BIGINT NOT NULL,
APPID VARCHAR(32),
RULEID BIGINT NOT NULL,
MODULE_ITEMID BIGINT NOT NULL,
ITEM_VALUES VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ITEMID)
);
--权限定义表 end--
--LDAP配置表 start--
CREATE TABLE SYS_LDAP_CONFIG (
AD_NAME VARCHAR(255) NOT NULL ,
SERVICE_TYPE INTEGER NOT NULL ,
IP_ADDRESS VARCHAR(255) NOT NULL ,
PROTOCOL_TYPE INTEGER NOT NULL ,
PORT INTEGER NOT NULL ,
ACCOUNT VARCHAR(255) NOT NULL ,
PASSWORD VARCHAR(255) NOT NULL ,
CATALOG VARCHAR(255) NOT NULL ,
MAPPING_RELATIONSHIP VARCHAR(1024),
FLAGS INTEGER NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW(),
MODIFIER INTEGER NOT NULL ,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
UUID VARCHAR(40) NOT NULL ,
KEYSTORE_PATH VARCHAR(255) ,
KEYSTORE_PASSWORD VARCHAR(255) ,
PATH_FIX_FLAG INTEGER ,
PATH_FIX_SUFFIX VARCHAR(255),
PRIMARY KEY (UUID)
);
--LDAP配置表 end--
--样式定义表 start--
CREATE TABLE SYS_STYLE_DEFINED (
STYLEID BIGINT NOT NULL,
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(256),
STYLECONTENT VARCHAR(2000),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (STYLEID)
);
CREATE TABLE SYS_STYLE_GLOBAL (
GLOBALID BIGINT NOT NULL,
CODE VARCHAR(32) NOT NULL,
NAME VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(256),
FLAGS INTEGER DEFAULT 0,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (GLOBALID)
);
CREATE TABLE SYS_STYLE_SELECTOR (
SELECTORID BIGINT NOT NULL,
GLOBALID BIGINT NOT NULL,
DIRECTION INTEGER NOT NULL,
PLACE INTEGER,
NODETYPE INTEGER,
STYLEID BIGINT NOT NULL,
FLAGS INTEGER NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (SELECTORID)
);
--样式定义表 end--
CREATE TABLE SYS_LOG (
UUID VARCHAR(36) NOT NULL,
TRACKID VARCHAR(36) ,
USERID VARCHAR(36) ,
APPID VARCHAR(36) ,
MODULE VARCHAR(30) ,
OPERATION VARCHAR(10) ,
LOGTITLE VARCHAR(200) ,
LOGEXPLAIN VARCHAR(520) ,
BIZKEY VARCHAR(32),
CLIENTIP VARCHAR(30),
CLIENTTYPE VARCHAR(20),
CLIENTVERSION VARCHAR(30),
PATH VARCHAR(200),
PARAMS VARCHAR(4000) ,
RESULTJSON VARCHAR(2048),
ISEXCEPTION VARCHAR(1) ,
ERRORMESSAGE VARCHAR(1024),
SENDTIME TIMESTAMP,
EXECUTETIME VARCHAR(100),
STATE VARCHAR(2),
SERVERVERSION VARCHAR(100),
FLAGS INTEGER NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW(),
PRIMARY KEY (UUID)
);
--用户表 start--
CREATE TABLE SYS_USER (
USERID INTEGER NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
UUID VARCHAR(36) NOT NULL,
PASSWORD VARCHAR(100) NOT NULL,
LAST_NAME VARCHAR(20),
MIDDLE_NAME VARCHAR(20),
FIRST_NAME VARCHAR(20),
NICKNAME VARCHAR(64),
NICKSN SMALLINT,
IDCARDNO VARCHAR(20),
MOBILE VARCHAR(20),
EMAIL VARCHAR(256),
GENDER SMALLINT,
BIRTHDAY DATE,
ADDRESS VARCHAR(256),
AUTHENTICATE_TYPE VARCHAR(20),
AUTHENTICATE_SERVER VARCHAR(40),
AUTH_USER_NAME VARCHAR(60),
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (USERID)
);
CREATE TABLE SYS_USER_AUTH (
AUTHID BIGINT NOT NULL,
USERID INTEGER NOT NULL,
USERNAME VARCHAR(256) NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
OPENID VARCHAR(256),
PRIMARY KEY (AUTHID)
);
--用户表 end--
--用户角色表 start--
CREATE TABLE SYS_USER_ROLES (
USERID INTEGER NOT NULL,
ROLEID BIGINT NOT NULL,
APPID VARCHAR(32),
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (USERID, ROLEID)
);
--用户角色表 end--
-- 全局样式引用表关系 start--
CREATE TABLE SYS_REPORT_STYLE
(
ID BIGINT not null,
GLOBALID BIGINT,
APPID VARCHAR(32),
REPORTID BIGINT,
MATRIXCODE VARCHAR(64),
PRIMARY KEY (ID)
);
-- 全局样式引用表关系 end--
--样式文件表 start--
CREATE TABLE SYS_STYLE_FILE (
ID BIGINT NOT NULL ,
CODE VARCHAR(256) NOT NULL ,
content TEXT NOT NULL ,
FLAGS INTEGER DEFAULT 0 NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (id)
);
--样式文件表 end--
-- 多语言表 start-- -
CREATE TABLE SYS_CONFIGURE_VALUES
(
CODE VARCHAR(256) not null,
VALUE VARCHAR(2000),
PRIMARY KEY (CODE)
);
-- 多语言表 end--
--备份导入导出日志表 start--
CREATE TABLE SYS_BACKUP_LOG
(
ID VARCHAR(64) NOT NULL ,
APPID VARCHAR(32) ,
START_TIME TIMESTAMP ,
END_TIME TIMESTAMP ,
FILE_NAME VARCHAR(200) ,
FILE_PATH VARCHAR(200) ,
DB_TYPE VARCHAR(20) ,
STATE VARCHAR(1) ,
BACKUP_TYPE VARCHAR(1) ,
INPUT_DATA VARCHAR(512) ,
FLAGS INTEGER DEFAULT 0 NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP DEFAULT NOW() NOT NULL ,
MODIFIER INTEGER NOT NULL ,
MODIFY_TIME TIMESTAMP DEFAULT NOW() NOT NULL ,
FILE_ID VARCHAR(32) ,
MIGRATION_TYPE VARCHAR(1) ,
ERROR_COUNT INTEGER DEFAULT 0 ,
ERROR_DATA TEXT
);
--备份导入导出日志表 end--
-- 第三方认证信息绑定 start--
CREATE TABLE SYS_USER_AUTHORIZATION_BINDING (
UUID VARCHAR(64) NOT NULL,
PROVIDER VARCHAR(64) NOT NULL,
USERNAME VARCHAR(64) NOT NULL,
AUTHORIZATION_TYPE VARCHAR(64) NOT NULL,
USERID BIGINT NOT NULL,
FLAGS INTEGER DEFAULT 0 NOT NULL,
CREATOR INTEGER NOT NULL,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (UUID)
);
-- 第三方认证信息绑定 end--
-- 用户配置 start--
CREATE TABLE sys_user_configure(
creator INTEGER NOT NULL ,
code VARCHAR(64) NOT NULL ,
data TEXT ,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ,
modifier INTEGER NOT NULL ,
modify_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ,
flags INTEGER DEFAULT 0 NOT NULL ,
type INTEGER NOT NULL ,
userid INTEGER NOT NULL ,
PRIMARY KEY(userid, code )
);
-- 用户配置 end--
--sap操作日志表 start--
CREATE TABLE sys_data_import_oper_log (
ID VARCHAR(64) NOT NULL ,
APPID VARCHAR(32),
PID VARCHAR(64),
OPERATOR_ VARCHAR(64) NOT NULL ,
ETL_NAME VARCHAR(64),
PARAMS VARCHAR(2000),
STATUS_ INTEGER,
COUNT_ BIGINT,
START_TIME TIMESTAMP,
END_TIME TIMESTAMP,
SAP_TABLE_LOG_ID VARCHAR(64),
ERROR_COUNT BIGINT,
FLAGS INTEGER DEFAULT 0 NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL ,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ID)
);
--sap操作日志表 end--
--sap配置信息表 start-
CREATE TABLE SYS_SAP_TABLE_LOG (
ID VARCHAR(64) NOT NULL ,
APPID VARCHAR(32) ,
START_TIME TIMESTAMP ,
END_TIME TIMESTAMP ,
STATE VARCHAR(1) ,
TABLE_NAME VARCHAR(256) NOT NULL ,
GEN_FLAG VARCHAR(1) ,
PARAMS VARCHAR(512) ,
RESULTS VARCHAR(2000) ,
FLAGS INTEGER DEFAULT 0 NOT NULL ,
CREATOR INTEGER NOT NULL ,
CREATE_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
MODIFIER INTEGER NOT NULL,
MODIFY_TIME TIMESTAMP NOT NULL DEFAULT NOW() ,
PRIMARY KEY (ID)
);
--sap配置信息表 end-
-- 远程资源管理定义表 start--
CREATE TABLE biz_remote_define(
auth_type INTEGER NOT NULL ,
creator INTEGER NOT NULL ,
code VARCHAR(32) NOT NULL ,
address VARCHAR(256) NOT NULL ,
create_time TIMESTAMP DEFAULT now() NOT NULL ,
modifier INTEGER NOT NULL ,
modify_time TIMESTAMP DEFAULT now() NOT NULL ,
flags INTEGER DEFAULT 0 NOT NULL ,
encoding VARCHAR(64) ,
path VARCHAR(2000) ,
protocol VARCHAR(16) NOT NULL ,
password TEXT ,
port INTEGER ,
username VARCHAR(256) ,
PRIMARY KEY(code )
);
-- 远程资源管理定义表 end--
-- 远程资源管理信息绑定表 start--
CREATE TABLE biz_remote_resource_bind(
file_path VARCHAR(2000) NOT NULL ,
creator INTEGER NOT NULL ,
create_time TIMESTAMP DEFAULT now() NOT NULL ,
modifier INTEGER NOT NULL ,
modify_time TIMESTAMP DEFAULT now() NOT NULL ,
flags INTEGER DEFAULT 0 NOT NULL ,
remote_code VARCHAR(32) NOT NULL ,
keyword VARCHAR(2000) NOT NULL
);
-- 远程资源管理信息绑定表 end--
-- 用户最近访问历史 start--
CREATE TABLE sys_user_history(
creator INTEGER NOT NULL ,
action_time TIMESTAMP NOT NULL ,
data TEXT ,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ,
modifier INTEGER NOT NULL ,
modify_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ,
flags INTEGER DEFAULT 0 NOT NULL ,
id INTEGER NOT NULL ,
type VARCHAR(32) NOT NULL ,
userid INTEGER NOT NULL ,
PRIMARY KEY(id )
);
-- 用户最近访问历史 end--
INSERT INTO sys_user_configure VALUES (10000, 'personal.home-page', '{\"10000\":{\"accesshistory\":{\"code\":\"accesshistory\",\"show\":true,\"name\":\"最近访问\",\"_XID\":\"row_13\"},\"menulist\":{\"code\":\"menulist\",\"show\":true,\"name\":\"业务功能\",\"data\":{},\"_XID\":\"row_14\"},\"todos\":{\"code\":\"todos\",\"show\":true,\"name\":\"待办事项\",\"_XID\":\"row_15\"},\"dashboard\":{\"code\":\"dashboard\",\"show\":true,\"name\":\"主要指标\",\"data\":{},\"_XID\":\"row_16\"},\"formtable\":{\"code\":\"formtable\",\"show\":true,\"name\":\"安全审计\",\"_XID\":\"row_17\"}}}', '2021-03-14 14:48:33', 10000, '2021-03-22 14:20:03', 0, 0, 10000);
-- 多语言表初始化 start--
INSERT INTO SYS_CONFIGURE_VALUES (CODE, VALUE)
VALUES ('System.I18n', 'zh-CN;en-US;;');
-- 多语言表初始化 end--
-- 系统用户admin初始化 start--
INSERT INTO SYS_USER(USERID, FLAGS, UUID, PASSWORD, LAST_NAME, MIDDLE_NAME, FIRST_NAME, NICKNAME, NICKSN, IDCARDNO, MOBILE, EMAIL, GENDER, BIRTHDAY, ADDRESS, CREATOR, MODIFIER,AUTHENTICATE_TYPE,AUTHENTICATE_SERVER,AUTH_USER_NAME) VALUES(10000, 32772, 'f4c51272-b84a-4ae4-94e0-0ded76c42352', '3ec751a8e37a8ba39ac8795808e14ce33eef8e443d813844fcc6ff004639c01257068c578efa9f7c', NULL, NULL, 'admin', 'admin', 3512, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0,null,null,null);
INSERT INTO SYS_USER_AUTH(AUTHID, USERID, USERNAME, FLAGS, OPENID) VALUES(1, 10000, 'admin', 0, NULL);
-- 系统用户admin初始化 end--
-- 菜单定义表 start--
INSERT INTO SYS_MENU(MENUID, CODE, APPID, NAME, DESCRIPTION, MASK, FLAGS, CREATOR, MODIFIER) VALUES(1, 'central_main', NULL, '系统菜单', '系统配置菜单', 'C000000000100055', 16384, 10000, 10000);
INSERT INTO SYS_MENU(MENUID, CODE, APPID, NAME, DESCRIPTION, MASK, FLAGS, CREATOR, MODIFIER) VALUES(2, 'main', NULL, '应用菜单', '应用菜单', 'C000000000100056', 16384, 10000, 10000);
-- 菜单定义表 end--
-- 菜单属性定 start--
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (1, 1, NULL, NULL, '1001', '1001', '系统配置', 'C00000000010003E', '设置及管理', 'config_global1', NULL, 1, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:53:19');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (2, 1, NULL, 1, '1002', '1001.1002', '全局', 'C00000000010003F', '参数配置', NULL, NULL, 1, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:53:39');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (3, 1, NULL, 2, '1003', '1001.1002.1003', '详情', 'C000000000100040', '全局配置', 'config_global', '/central/configure', 999999, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:20:35');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (4, 1, NULL, 1, '1004', '1001.1004', '应用集', 'T010900000000004', '应用集', NULL, NULL, 3, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:54:41');
-- INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (5, 1, NULL, 4, '1005', '1001.1004.1005', '模型预设', NULL, NULL, 'modal_preset', '/central/preset', 999981, 0, 10000, '2021-04-24 16:49:35', 10000, '2021-06-23 20:21:54');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (6, 1, NULL, 4, '1006', '1001.1004.1006', '应用维护', 'T01080100002', '应用管理', 'app_list', '/central/application', 999980, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:21:35');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (7, 1, NULL, 1, '1007', '1001.1007', '用户', 'T01050100002', '用户管理', NULL, NULL, 2, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:53:55');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (8, 1, NULL, 7, '1008', '1001.1007.1008', '用户维护', 'T01050100002', '用户管理', 'user_list', '/central/user', 999999, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:25:57');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (10, 1, NULL, 7, '1010', '1001.1007.1010', '在线用户', NULL, '在线用户管理', 'onlineuser', '/central/onlineuser', 960000, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-29 15:22:34');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (11, 1, NULL, 1, '1011', '1001.1011', '权限', 'T010900000000001', '权限管理', NULL, NULL, 4, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:54:54');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (12, 1, NULL, 11, '1012', '1001.1011.1012', '角色权限', 'T01090101002', '角色管理', 'role_list', '/central/permission/role', 999900, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:23:57');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (13, 1, NULL, 11, '1013', '1001.1011.1013', '用户角色', 'T010900000000003', '用户角色', 'user_role', '/central/permission/role/user_role', 999000, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (14, 1, NULL, 11, '1014', '1001.1011.1014', '功能维护', 'T010902000000002', '功能管理', 'feature_list', '/central/permission/feature', 999999, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:24:34');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (15, 1, NULL, 1, '1015', '1001.1015', '数据', 'C000000000100041', '系统备份', NULL, NULL, 5, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:55:13');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (16, 1, NULL, 15, '1016', '1001.1015.1016', '系统附件', 'C000000000100044', '文件管理', 'backup_files', '/central/attachment', 999700, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:25:06');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (17, 1, NULL, 15, '1017', '1001.1015.1017', '数据备份', 'C000000000100042', '数据备份', 'backup_import', '/central/backup_import', 999700, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (20, 1, NULL, 15, '1020', '1001.1015.1020', '外部数据导入', 'C00000000010005D', '数据导入', 'data_import', '/central/data_import', 999700, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:25:29');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (21, 1, NULL, 1, '1021', '1001.1021', '远程资源', 'T01050100053', '资源管理', NULL, NULL, 6, 4, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:59:37');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (22, 1, NULL, 21, '1022', '1001.1021.1022', 'FTP链接维护', 'T01050100054', '远程资源管理', 'remote_define', '/central/api/remote', 0, 0, 1, '2021-03-08 13:54:50', 10000, '2021-06-23 20:19:20');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (23, 1, NULL, 1, '1023', '1001.1023', '菜单', NULL, '菜单管理', NULL, '/central/menu', 99, 0, 1, '2021-03-08 13:54:49', 10000, '2021-06-25 09:21:41');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (24, 1, NULL, 23, '1024', '1001.1023.1024', '菜单维护', NULL, '菜单配置', 'menu_list', '/central/menu_config', 99, 0, 1, '2021-03-08 13:54:49', 10000, '2021-06-25 09:21:51');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (25, 1, NULL, 1, '1025', '1001.1025', '日志', NULL, NULL, NULL, NULL, 99, 0, 1, '2021-03-13 11:35:13', 10000, '2021-06-25 09:22:58');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (26, 1, NULL, 25, '1026', '1001.1025.1026', '审计日志', NULL, NULL, 'log_list', '/central/logging/bussiness', 99, 0, 1, '2021-03-13 11:35:13', 10000, '2021-06-25 09:23:15');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (27, 2, NULL, NULL, '1027', '1027', '数据模型', 'C00000000010004C', '数据模型', 'datamodel', NULL, 1, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:48:34');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (28, 2, NULL, 27, '1028', '1027.1028', '维度管理', 'T020201000000002', '维度管理', 'dimension', '/application/:appid/dimension', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (29, 2, NULL, 27, '1029', '1027.1029', '关键值管理', 'C00000000010004D', '关键值管理', 'keyfigure', '/application/:appid/keyfigure', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (30, 2, NULL, 27, '1030', '1027.1030', '数据集管理', 'T020F01000000002', '数据集', 'superdataset', '/application/:appid/superdataset', 0, 0, 0, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (31, 2, NULL, NULL, '1031', '1031', 'ETL', 'T020500000000001', 'ETL', 'etl', NULL, 99, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:50:24');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (32, 2, NULL, 31, '1032', '1031.1032', '数据源管理', 'T020501000000001', '数据源管理', 'datasource', '/application/:appid/etl/datasource', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (33, 2, NULL, 31, '1033', '1031.1033', '仓库管理', 'T020502000000003', '仓库管理', 'store', '/application/:appid/etl/storehouse', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (34, 2, NULL, 31, '1034', '1031.1034', '任务管理', 'T020503000000003', '任务管理', 'task', '/application/:appid/etl/task', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (35, 2, NULL, 31, '1035', '1031.1035', '作业管理', 'T020504000000003', '作业管理', 'job', '/application/:appid/etl/job', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (36, 2, NULL, 31, '1036', '1031.1036', '自定义参数', NULL, '自定义参数', 'parameter', '/application/:appid/etl/parameter', 0, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (37, 2, NULL, NULL, '1037', '1037', '报表展示', 'C000000000100037', '报表展示', 'report_view', '/application/:appid/assistance/report_view', 2, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:49:05');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (38, 2, NULL, 37, '1038', '1037.1038', '所有文档', NULL, '所有文档', 'webreport', '/application/:appid/webreport/webreport', 99, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (39, 2, NULL, NULL, '1039', '1039', '工作流管理', NULL, '工作流管理', 'workflow', NULL, 98, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:49:53');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (40, 2, NULL, 39, '1040', '1039.1040', '用户分组', NULL, '用户分组', 'group', 'application/:appid/workflow/group', 960001, 4, 1, '2021-03-08 13:54:49', 10000, '2021-03-11 10:08:56');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (41, 2, NULL, 39, '1041', '1039.1041', '流程管理', NULL, '工作流过程设置', 'manage', 'application/:appid/workflow/manage', 960002, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (42, 2, NULL, 39, '1042', '1039.1042', '我的流程', NULL, '启动某流程', 'start', 'application/:appid/workflow/start', 960004, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (43, 2, NULL, 39, '1043', '1039.1043', '流程办理', NULL, '流程的审批,报表填写等', 'handle', 'application/:appid/workflow/handle', 960005, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (44, 2, NULL, 39, '1044', '1039.1044', '消息模板', NULL, '消息模板', 'messagetemplate', 'application/:appid/workflow/messagetemplate', 960007, 0, 1, '2021-03-08 13:54:49', 1, '2021-03-08 13:54:49');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (45, 2, NULL, 39, '1045', '1039.1045', '流程监控', NULL, '流程监控', 'myprocess', 'application/:appid/workflow/myprocess', 960010, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (46, 2, NULL, NULL, '1046', '1046', '数据锁定', NULL, '数据锁定', 'datalock', NULL, 99, 0, 1, '2021-03-08 13:54:50', 10000, '2021-07-08 14:49:34');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (47, 2, NULL, 46, '1047', '1046.1047', '锁信息', NULL, '锁信息', 'lockinfo', '/application/:appid/datalock/lockinfo', 960001, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (48, 2, NULL, 46, '1048', '1046.1048', '解锁申请', NULL, '解锁申请', 'unlockapplication', '/application/:appid/datalock/unlockapplication', 960002, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (49, 2, NULL, 46, '1049', '1046.1049', '列定义', NULL, '列定义', 'columndefine', '/application/:appid/datalock/columndefine', 960003, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (50, 2, NULL, 46, '1050', '1046.1050', '归档', NULL, '归档', 'archive', '/application/:appid/datalock/archive', 960004, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (51, 2, NULL, NULL, '1051', '1051', '仪表盘', NULL, '仪表盘', 'dashboard', NULL, 99, 4, 1, '2021-03-08 13:54:50', 10000, '2021-04-13 09:38:39');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (52, 2, NULL, 51, '1052', '1051.1052', '仪表盘', NULL, '仪表盘', 'dashboard', '/application/:appid/dashboard/dashboard', 99, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (53, 2, NULL, 51, '1053', '1051.1053', '图表', NULL, '图表', 'chart', '/application/:appid/dashboard/chart', 99, 0, 1, '2021-03-08 13:54:50', 1, '2021-03-08 13:54:50');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (54, 2, NULL, 51, '1054', '1051.1054', '数据源', NULL, '数据源', 'datasources', '/application/:appid/dashboard/datasource', 99, 0, 1, '2021-03-08 13:54:49', 1, '2021-03-08 13:54:49');
INSERT INTO SYS_MENU_ITEM(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (55, 2, NULL, 51, '1055', '1051.1055', '仪表盘查看', NULL, NULL, 'dashboardview', '/application/:appid/dashboard/datasourceview', 99, 0, 10000, '2021-04-15 13:41:56', 10000, '2021-04-15 13:47:19');
-- NSERT INTO sys_menu_item(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (56, 2, NULL, NULL, '1056', '1056', '合并', NULL, NULL, 'eventsmerge', NULL, 99, 4, 10000, '2021-04-15 13:41:56.139', 10000, '2021-04-15 13:41:56.139);
-- NSERT INTO sys_menu_item(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (57, 2, NULL, 56, '1057', '1056.1057', '科目附注映射', '科目附注映射', NULL, 'SubjectsMap', '/application/:appid/EventsMerge/SubjectsMap', 6, 4, 10000, '2021-04-15 13:41:56.139', 10000, '2021-04-15 13:41:56.139');
-- NSERT INTO sys_menu_item(ITEMID, MENUID, APPID, PARENTID, CODE, CODE_PATH, NAME, MASK, DESCRIPTION, COMMAND, URL, WEIGHTS, FLAGS, CREATOR, CREATE_TIME, MODIFIER, MODIFY_TIME) VALUES (58, 2, NULL, NULL, '1058', '1058', '超级表单', NULL, '超级表单', 'forms', NULL, 0, 0, 1, '2021-04-15 13:41:56.139', 1, '2021-04-15 13:41:56.139');
-- 菜单属性 end--
-- 功能定义初始化数据 start--
INSERT INTO SYS_FEATURE(FEATUREID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES(1, NULL, 'Design', '模板制作', 'Excel-制作模式功能', 4, 10000, 10000);
INSERT INTO SYS_FEATURE(FEATUREID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES(2, NULL, 'Navigat', '报表查询', 'Excel-查询模式功能', 4, 10000, 10000);
INSERT INTO SYS_FEATURE(FEATUREID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES(3, NULL, 'Input', '数据输入', 'Excel-输入模式功能', 4, 10000, 10000);
INSERT INTO SYS_FEATURE (FEATUREID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES (4, null, 'Allocation', '分摊', 'Excel-分摊功能', 4, 10000, 10000);
-- 功能定义初始化数据 end--
-- 数据模型定义数据初始化 start--
INSERT INTO SYS_MODULE(MODULEID, APPID, CODE, NAME, DESCRIPTION, TABLE_NAME, FLAGS, CREATOR, MODIFIER) VALUES(1, NULL, 'application', '应用集', '应用集', 'sys_application', 4, 10000, 10000);
INSERT INTO SYS_MODULE_FEATURE(FEATUREID, MODULEID, APPID, CODE, NAME, DESCRIPTION, FLAGS, CREATOR, MODIFIER) VALUES(1, 1, NULL, 'READ', '读取', '读取应用集', 4, 10000, 10000);
INSERT INTO SYS_MODULE_ITEM(ITEMID, MODULEID, APPID, COLUMN_NAME, FLAGS, CREATOR, MODIFIER) VALUES(1, 1, NULL, 'appid', 4, 10000, 10000);
-- 数据模型定义数据初始化 end--
CREATE TABLE SYS_USER_PASSWD (
USERID INTEGER NOT NULL,
PASSWORD VARCHAR(100) NOT NULL,
ENABLED_TIME TIMESTAMP NOT NULL DEFAULT NOW(),
FLAGS INTEGER DEFAULT 0 NOT NULL ,
PRIMARY KEY (USERID, PASSWORD)
);
alter table sys_user add PSSWD_MODIFY_TIME TIMESTAMP;
update sys_user set PSSWD_MODIFY_TIME = now();
-- 新增函数--
create or replace function UUID_GENERATE_V4() RETURNS varchar(36)
AS $$
import uuid
return uuid.uuid1()
$$ LANGUAGE plpythonu;
-- 新增函数--
网友评论