/*
 change.sql 说明
 1.数据库相关修改添加到对应的 change.sql 文件，无需调整其他 sql  文件
 2.sql 语句验证正确后再提交
*/
-- jjx 2023-4-24 同步mysql脚本到4月24日
alter table BPM_DEFINITION  add DESIGN_PATTERN_ VARCHAR(20);
comment on column BPM_DEFINITION.DESIGN_PATTERN_ is '设计模式';

create table BPM_CHECK_RECORD(
    ID_             VARCHAR(64)   primary key  unique,
    TENANT_ID_      VARCHAR(64),
    CREATE_TIME_    DATE,
    UPDATE_TIME_    date,
    CREATE_BY_      VARCHAR(64),
    TASK_ID_        VARCHAR(64),
    INST_ID_        VARCHAR(64),
    CREATE_ORG_ID_  VARCHAR(64),
    UPDATE_BY_      VARCHAR(64)
);
comment on table BPM_CHECK_RECORD is '任务阅读记录';
comment on column BPM_CHECK_RECORD.TENANT_ID_ is '租户ID';
comment on column BPM_CHECK_RECORD.CREATE_TIME_ is '创建时间';
comment on column BPM_CHECK_RECORD.UPDATE_TIME_ is '更新时间';
comment on column BPM_CHECK_RECORD.CREATE_BY_ is '创建人';
comment on column BPM_CHECK_RECORD.TASK_ID_ is '任务ID';
comment on column BPM_CHECK_RECORD.INST_ID_ is '实例ID';


UPDATE portal_sys_properties SET NAME = '待办列表字段显示配置', ALIAS = 'taskListFiledConf', GROUP_ = NULL,
                                   VALUE = 'MvLiL4mE1+YRNj4cfPOGzXCMA5F/amaoWCA2iUnRVhcK9aZEof2/M5Ii3zWaCcQBtNG6T6/bDsspNohzSqq8MBg+UkEo+A+fojqBP9nm9s/mxAH5v+HcvPi7H00ryd0W0eMInCQ2rplU+UgHvJNr0D8+1FkL/EyQPsOG5SazUTWOWI14OS+R1tHUvVzGk6jSxrZqAz5Pi5RTNDitHrypfbF9nas8LjVzqrnYGrRimXaSaPX7zmNtlm+NoKRpX0ckQDyjgSvwAgnLtSbyqiTS4AMBxjGgbzHEtD+UwDcyWFD/y99DaWyKe1CkC/kfZ4mr5cRTrOUWsGIHBsHnz+Czx3Ip6tQxeSxFm3A4xn0YWzDENJLO7IPN9bixemLAj38RGZf+/2+uFRZx/WKKiVUHYuBxrvZN/E9Qxxg0JMpXPC4srBSSngEFv72KDwc1t7lpQ8+nOduRG5dkZcl9Do+qRj7JH6CouiXEyXZybr7hItFKZiClQgfDGd5wldTxTZ0apGjFB8lNecOIvY+DelsMAKG5+8VqplSVF3S6zJ6+kxqIt4OcPTIm+MPUgIFeLbm9XJ1Kn0tdEk5PhsiWdYBVrrhFafpPzw/AXsQAYZgh7T1TCnYGUidLOis1G8khS4T7QDyjgSvwAgnLtSbyqiTS4HtJ/Yl9yGzl/94R0THof8UO6B1Ej+GnOnQEFRi2izAf5cRTrOUWsGIHBsHnz+Czx3Ip6tQxeSxFm3A4xn0YWzAa38uRHjrujYZ4pZX1yWAEpGjFB8lNecOIvY+DelsMANq/cufeuL275D7sZygkW0WQ57F5AtPCv6Wki5lAM0CBL25Enrb6+rlNuY32fRM0z7OMt4w6vXJHgjkO4Txe4/srk4QuiRDQvyq9K+wGQLQNuVl7HPlrJDfOPnb2xbCOxzoWCUKQpYW9tKqrx692LMILy5x9J/NfUxSi3gtHMI1RX6LfluBuGRpjhcDsxxaxeuSZGrk7zbVgoGRM49OtyaS/GnH7v+Xskxs4/geWWITXL/QE10IQ2v6ewmFdLAPwdZF2NNzjnuS+GkbyHPVH0bsP/eux6jbu1R2wK9GjI4MP/iYjy9b7jaqbc/XYGtFM6EigZrL18hlemzh/Fvu7/oIQD2Pe+5+2JS2EmXX4zF29VG5OCoeL5VM11eDDbZn4a0A8o4Er8AIJy7Um8qok0uCjZmgZKQ6XiFCyp9UNkumLJA32CqzvKUNEPNLwf+CR7eXEU6zlFrBiBwbB58/gs8dyKerUMXksRZtwOMZ9GFswB3chkFVZb6XCc45/PdrIYfl4c0Vbog/TuxP3MMXBpXbiEGklcBZ0q1FsT2tSEMBwOd6njPSzdZF2cVWQSvZ+IUA8dxrZx2EGWpBF11V6cfBWup6zeRqkyJTBIaVQzubzEs/ZpNz8lKFyCEBsdEgalnVPakFyhb8G0ea5P3CAlreN6TBxepcUHthlX77p5CuPGOA+8yi2NynjMKDXg9Awklca0dcpoMR1Ofat3kj4YuzTzbMrfilpzvg8cWw3e1wpZQtx04v+/jzDBbCC8JXJz7lZexz5ayQ3zj529sWwjsfyIJ/lSzTXRC7Kp1P1uBBn/vFT7Gy1mpBZk9tpUGzLVbuNtUx7/8H2OaeT73vqems4Z5KEjTP+oIX9LWzRxee0UaHFyfk6CgnGeF4CwTIdw0A8o4Er8AIJy7Um8qok0uCjmdwbIcTthJHSl8xgXePabA8lXEkV/j2ESgV5AS/N8lhJyDS5ZqlumY28Bawy49EQD2Pe+5+2JS2EmXX4zF29an1LjdWEv13RH3vqxzFW2+IQaSVwFnSrUWxPa1IQwHB/eigOQncmnJkQFuV61QidQDx3GtnHYQZakEXXVXpx8Fa6nrN5GqTIlMEhpVDO5vMSz9mk3PyUoXIIQGx0SBqWEbFvnZzHRIliGHlLOUY3cA==',
                                   ENCRYPT = 1,
                                   DESCRIPTION = '应用端待办列表字段显示配置',
                                   UPDATE_TIME_ = '2022-11-09 15:53:45',
                                   CREATE_BY_ = '1',
                                   CREATE_TIME_ = '2021-10-14 16:41:40',
                                   CREATE_ORG_ID_ = '',
                                   UPDATE_BY_ = '1',
                                   TENANT_ID_ = NULL
                               WHERE ID = '1448569683989442560';



alter table BPM_DEFINITION add DESIGN_PATTERN_ VARCHAR(20);
comment on column BPM_DEFINITION.DESIGN_PATTERN_ is '设计模式 normal simple';

alter table BPM_DEFINITION add FLOW_TYPE_ int;
comment on column BPM_DEFINITION.FLOW_TYPE_ is '流程类型';


alter table BPM_TASK_REMINDER add TRANSFER_ID_ VARCHAR(64);
comment on column BPM_TASK_REMINDER.TRANSFER_ID_ is '转办人ID';

alter table BPM_TASK_REMINDER add TRANSFER_NAME_ VARCHAR(255);
comment on column BPM_TASK_REMINDER.TRANSFER_NAME_ is '转办人名称';

alter table BPM_TASK_REMINDER add DIRECT_LEADER_ int;
comment on column BPM_TASK_REMINDER.DIRECT_LEADER_ is '催办直接上级';

alter table BPM_TASK_REMINDER add MAIN_ORG_LEADER_ int;
comment on column BPM_TASK_REMINDER.MAIN_ORG_LEADER_ is '催办主组织负责人';

alter table BPM_TASK_REMINDER add DIRECT_USER_IDS_ VARCHAR(1000);
comment on column BPM_TASK_REMINDER.DIRECT_USER_IDS_ is '指定用户ID';

alter table BPM_TASK_REMINDER add DIRECT_USER_NAMES_ VARCHAR(1000);
comment on column BPM_TASK_REMINDER.DIRECT_USER_NAMES_ is '指定用户名称';

alter table BPM_TASK_REMINDER add DIRECT_USER_ int;
comment on column BPM_TASK_REMINDER.DIRECT_USER_ is '催办指定用户';


alter table PORTAL_SYS_LOGS_SETTINGS add FROM_ VARCHAR(1);
comment on column PORTAL_SYS_LOGS_SETTINGS.FROM_ is '1:初始化。2:手动添加';

alter table PORTAL_SYS_LOGS_SETTINGS add MODULE_NAME_ VARCHAR(200);
comment on column PORTAL_SYS_LOGS_SETTINGS.MODULE_NAME_ is '模块名称';


UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1318030354614980608';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338367741324824576';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338375124944031744';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338377219818524672';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338379764150439936';
UPDATE bpm_multi_script SET TENANT_ID_ = '-1' WHERE ID_ = '1338381406014935040';

alter table PORTAL_SYS_DIC add CREATE_TIME_ DATE;
comment on column PORTAL_SYS_DIC.CREATE_TIME_ is '创建时间';

alter table PORTAL_SYS_DIC add CREATE_BY_ VARCHAR(255);
comment on column PORTAL_SYS_DIC.CREATE_BY_ is '创建人ID';


alter table PORTAL_SYS_LOGS add ELAPSED_TIME_ decimal(10, 3);
comment on column PORTAL_SYS_LOGS.ELAPSED_TIME_ is '接口耗时（单位：秒）';

alter table BPM_CALL_LOG add ELAPSED_TIME_ DECIMAL(10, 3);
comment on column BPM_CALL_LOG.ELAPSED_TIME_ is '接口耗时（单位：秒）';

alter table BPM_TASK_SIGNDATA  add FROM_ VARCHAR(64);
comment on column BPM_TASK_SIGNDATA.FROM_ is '来源。assign由指定历史会签处理人产生的';


INSERT INTO portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_, TYPE_) VALUES ('1572106298114183168', '3641025', '简易流程', 'simpleFlowTable', '', '', 1, 2, '', '-1.1.3641025.1572106298114183168.', '', '-1', '{\"path\":\"/simpleFlowTable\",\"component\":\"\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"简易流程\"}}', NULL);



create table FORM_SIMPLE_DESIGN
(
    ID_             VARCHAR(50)   primary key,
    CATEGORY_ID_    VARCHAR(50),
    CATEGORY_NAME_  VARCHAR(255),
    ALIAS_          VARCHAR(50),
    NAME_           VARCHAR(150),
    CREATE_BY_      VARCHAR(50),
    CREATE_TIME_    DATE,
    CREATE_ORG_ID_  VARCHAR(64),
    UPDATE_BY_      VARCHAR(64),
    UPDATE_TIME_    DATE,
    DESC_           VARCHAR(255),
    TENANT_ID_      VARCHAR(64)
);
comment on table FORM_SIMPLE_DESIGN is '简易设计';
comment on column FORM_SIMPLE_DESIGN.CATEGORY_ID_ is '分类ID';
comment on column FORM_SIMPLE_DESIGN.CATEGORY_NAME_ is '分类名称';
comment on column FORM_SIMPLE_DESIGN.ALIAS_ is '别名';
comment on column FORM_SIMPLE_DESIGN.NAME_ is '名称';
comment on column FORM_SIMPLE_DESIGN.CREATE_BY_ is '创建人ID';
comment on column FORM_SIMPLE_DESIGN.CREATE_TIME_ is '创建时间';
comment on column FORM_SIMPLE_DESIGN.UPDATE_BY_ is '更新人ID';
comment on column FORM_SIMPLE_DESIGN.UPDATE_TIME_ is '更新时间';
comment on column FORM_SIMPLE_DESIGN.DESC_ is '描述';
comment on column FORM_SIMPLE_DESIGN.TENANT_ID_ is '租户ID';
create index IDX_FORM_BO_DEF_ALIAS_TENANT_ID_   on FORM_SIMPLE_DESIGN (ALIAS_, TENANT_ID_);



INSERT INTO portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_, TYPE_, IS_REFRESH_, token_Enabled_, TOKEN_TYPE_, TOKEN_KEY_, TOKEN_API_) 
VALUES ('1631183759799828480', '1441341228585766912', '个人信息', 'information', '', '', NULL, 1, '', '-1.3.1441341228585766912.1631183759799828480.', '', '-1', '{\"path\":\"information\",\"component\":\"@/views/personal/information\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"个人信息\",\"isChildren\":true,\"icon\":\"\"}}', 'page', 1, 0, 0, NULL, NULL);

INSERT INTO portal_i18n_message(ID_, TYPE_, KEY_, VALUE_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_) 
VALUES ('1630743663304851456', 'en', 'Personal.center', 'Personal center', '2023-03-01 09:36:02', '1', '', NULL, NULL, '-1');

INSERT INTO portal_i18n_message(ID_, TYPE_, KEY_, VALUE_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_)
 VALUES ('1630743663363571712', 'zh-TW', 'Personal.center', '個人中心', '2023-03-01 09:36:02', '1', '', NULL, NULL, '-1');
 
INSERT INTO portal_i18n_message(ID_, TYPE_, KEY_, VALUE_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_) 
VALUES ('1630743663392931840', 'zh-CN', 'Personal.center', '个人中心', '2023-03-01 09:36:02', '1', '', NULL, NULL, '-1');


alter table FORM_HISTORY_RECORD add FORM_CSS_ CLOB;
comment on column FORM_HISTORY_RECORD.FORM_CSS_ is '表单CSS脚本';

alter table FORM_DEFINITION add FORM_CSS_ CLOB;
comment on column FORM_DEFINITION.FORM_CSS_ is '表单CSS脚本';


create table BPM_FREE_PROCESS_DEF
(
    ID_            	VARCHAR(64)  primary key   unique,
    SOURCE_DEF_ID_ 	VARCHAR(64),
    PROC_INST_ID_  	VARCHAR(255),
    BPMN_XML_      	CLOB,
    TENANT_ID_     	VARCHAR(255)
);
comment on table BPM_FREE_PROCESS_DEF is '自由流程定义备份表';
comment on column BPM_FREE_PROCESS_DEF.ID_ is '新流程定义ID';
comment on column BPM_FREE_PROCESS_DEF.SOURCE_DEF_ID_ is '原流程定义ID';
comment on column BPM_FREE_PROCESS_DEF.PROC_INST_ID_ is '实例ID';
comment on column BPM_FREE_PROCESS_DEF.BPMN_XML_ is 'XML';
comment on column BPM_FREE_PROCESS_DEF.TENANT_ID_ is '租户ID';


create table BPM_SERVICE_LOG(
    ID_           	VARCHAR(64)  primary key  unique,
    SUBJECT_      	VARCHAR(600),
    PROC_DEF_ID_  	VARCHAR(64),
    PROC_INST_ID_ 	VARCHAR(64),
    NODE_ID_      	VARCHAR(64),
    STATUS_       	INT,
    CREATE_TIME_  	DATE,
    TENANT_ID_    	VARCHAR(64)
);
comment on table BPM_SERVICE_LOG is '服务节点执行日志';
comment on column BPM_SERVICE_LOG.SUBJECT_ is '流程标题';
comment on column BPM_SERVICE_LOG.PROC_DEF_ID_ is '流程定义ID';
comment on column BPM_SERVICE_LOG.PROC_INST_ID_ is '流程实例ID';
comment on column BPM_SERVICE_LOG.NODE_ID_ is '节点ID';
comment on column BPM_SERVICE_LOG.STATUS_ is '处理结果：1.处理成功  0.处理失败';
comment on column BPM_SERVICE_LOG.TENANT_ID_ is '租户ID';
create index PROC_INST_ID_  on BPM_SERVICE_LOG (PROC_INST_ID_);



create table BPM_DOCUMENTATION_CONFIG
(
    ID_             VARCHAR(255)   primary key unique,
    DATA_KEY_       VARCHAR(255),
    AUTORUN_        VARCHAR(10),
    AUTORUN_CONFIG_ VARCHAR(255),
    DELETE_DATA_    VARCHAR(10),
    LIMIT_          VARCHAR(10),
    LIMIT_NUMBER_   VARCHAR(255),
    UPDATE_BY_      VARCHAR(255),
    UPDATE_TIME_    DATE,
    BEFORE_MONTH_   VARCHAR(255),
    JOB_NAME_       VARCHAR(255),
    TENANT_ID_      VARCHAR(255)
);
comment on table BPM_DOCUMENTATION_CONFIG is '数据归档配置表';
comment on column BPM_DOCUMENTATION_CONFIG.DATA_KEY_ is '数据源key';
comment on column BPM_DOCUMENTATION_CONFIG.AUTORUN_ is '是否自动执行';
comment on column BPM_DOCUMENTATION_CONFIG.AUTORUN_CONFIG_ is '自动执行配置';
comment on column BPM_DOCUMENTATION_CONFIG.DELETE_DATA_ is '是否删除数据';
comment on column BPM_DOCUMENTATION_CONFIG.LIMIT_ is '是否限制数据';
comment on column BPM_DOCUMENTATION_CONFIG.LIMIT_NUMBER_ is '限制数量';
comment on column BPM_DOCUMENTATION_CONFIG.UPDATE_BY_ is '修改人';
comment on column BPM_DOCUMENTATION_CONFIG.UPDATE_TIME_ is '修改时间';
comment on column BPM_DOCUMENTATION_CONFIG.BEFORE_MONTH_ is '同步时间';
comment on column BPM_DOCUMENTATION_CONFIG.JOB_NAME_ is '定时任务名称';
comment on column BPM_DOCUMENTATION_CONFIG.TENANT_ID_ is '租户ID';

create table BPM_DOCUMENTATION_ERROR_LOG
(
    ID_         VARCHAR(255) primary key unique,
    TABLE_NAME_ VARCHAR(255),
    DATA_ID_    VARCHAR(255),
    DATA_       VARCHAR(1000),
    REASON_     CLOB,
    TABLE_ID_   VARCHAR(255),
    TIME_       date,
    TENANT_ID_  VARCHAR(255)
);
comment on table BPM_DOCUMENTATION_ERROR_LOG is '同步错误日志表';
comment on column BPM_DOCUMENTATION_ERROR_LOG.TABLE_NAME_ is '表名';
comment on column BPM_DOCUMENTATION_ERROR_LOG.DATA_ID_ is '数据ID';
comment on column BPM_DOCUMENTATION_ERROR_LOG.DATA_ is '数据';
comment on column BPM_DOCUMENTATION_ERROR_LOG.REASON_ is '失败原因';
comment on column BPM_DOCUMENTATION_ERROR_LOG.TABLE_ID_ is '数据表ID';
comment on column BPM_DOCUMENTATION_ERROR_LOG.TIME_ is '时间';
comment on column BPM_DOCUMENTATION_ERROR_LOG.TENANT_ID_ is '租户ID';


create table BPM_DOCUMENTATION_TABLE
(
    ID_           VARCHAR(255)   primary key   unique,
    TABLE_NAME_   VARCHAR(255),
    DML_          CLOB,
    DDL_          CLOB,
    SYSTEM_       VARCHAR(10),
    START_        VARCHAR(255),
    INFO_         VARCHAR(255),
    ORDER_        VARCHAR(255),
    UPDATE_BY_    VARCHAR(64),
    PARENT_FIELD_ VARCHAR(255),
    FIELD_        VARCHAR(255),
    TIME_KEY_     VARCHAR(255),
    PARENT_ID_    VARCHAR(255),
    UPDATE_TIME_  DATE,
    TENANT_ID_    VARCHAR(255)
);
comment on table BPM_DOCUMENTATION_TABLE is '同步数据目标表';
comment on column BPM_DOCUMENTATION_TABLE.TABLE_NAME_ is '表名';
comment on column BPM_DOCUMENTATION_TABLE.DML_ is '表查询语句';
comment on column BPM_DOCUMENTATION_TABLE.DDL_ is '表定义语句';
comment on column BPM_DOCUMENTATION_TABLE.SYSTEM_ is '是否系统默认表';
comment on column BPM_DOCUMENTATION_TABLE.START_ is '是否启动';
comment on column BPM_DOCUMENTATION_TABLE.INFO_ is '说明';
comment on column BPM_DOCUMENTATION_TABLE.ORDER_ is '同步顺序';
comment on column BPM_DOCUMENTATION_TABLE.UPDATE_BY_ is '创建人';
comment on column BPM_DOCUMENTATION_TABLE.PARENT_FIELD_ is '主表字段';
comment on column BPM_DOCUMENTATION_TABLE.FIELD_ is '子表字段';
comment on column BPM_DOCUMENTATION_TABLE.TIME_KEY_ is '同步表时间字段';
comment on column BPM_DOCUMENTATION_TABLE.PARENT_ID_ is '父表ID';
comment on column BPM_DOCUMENTATION_TABLE.UPDATE_TIME_ is '创建时间';
comment on column BPM_DOCUMENTATION_TABLE.TENANT_ID_ is '租户';

alter table FORM_DATA_TEMPLATE add SHOW_TYPE_ VARCHAR(20);
comment on column FORM_DATA_TEMPLATE.SHOW_TYPE_ is '展示类型';

alter table FORM_DATA_TEMPLATE add GANTT_CONFIG_ CLOB;
comment on column FORM_DATA_TEMPLATE.GANTT_CONFIG_ is '甘特图独有一些配置';

alter table FORM_DATA_TEMPLATE add KANBAN_CONFIG_ CLOB;
comment on column FORM_DATA_TEMPLATE.KANBAN_CONFIG_ is '看板独有一些配置';

alter table FORM_DATA_TEMPLATE add XMIND_CONFIG_ CLOB;
comment on column FORM_DATA_TEMPLATE.XMIND_CONFIG_ is '思维导图的配置';


-- 2023-04-26 jjx  同步脚本
alter table PORTAL_SYS_COLUMN ADD SNAPSHOT_ID_ VARCHAR(64);
comment on column PORTAL_SYS_COLUMN.SNAPSHOT_ID_ is '快照图片id';

alter table  PORTAL_SYS_COLUMN ADD TEMPLATE_STYLE_ CLOB;
comment on column PORTAL_SYS_COLUMN.TEMPLATE_STYLE_ is '模板样式';

create table PORTAL_RECENTLY_APP
(
    ID_             VARCHAR(64)   primary key   unique,
    APP_ID_         VARCHAR(64),
    ACCOUNT_        VARCHAR(64),
    COUNT_          INT,
    CREATE_TIME_    DATE,
    UPDATE_TIME_    DATE,
    CREATE_BY_      VARCHAR(64),
    CREATE_ORG_ID_  VARCHAR(64),
    UPDATE_BY_      VARCHAR(64),
    TENANT_ID_      int
);
comment on table PORTAL_RECENTLY_APP is '用户最近应用点击记录表';
comment on column PORTAL_RECENTLY_APP.APP_ID_ is '应用ID';
comment on column PORTAL_RECENTLY_APP.ACCOUNT_ is '用户账号';
comment on column PORTAL_RECENTLY_APP.COUNT_ is '点击次数';
comment on column PORTAL_RECENTLY_APP.CREATE_TIME_ is '创建时间';
comment on column PORTAL_RECENTLY_APP.UPDATE_TIME_ is '更新时间';
comment on column PORTAL_RECENTLY_APP.CREATE_BY_ is '创建人';
comment on column PORTAL_RECENTLY_APP.UPDATE_BY_ is '更新人';


-- 2023-05-05 jjx  同步脚本
alter table PORTAL_SYS_LAYOUT_MANAGE add BANNER_TYPE_IDS_ CLOB;
comment on column PORTAL_SYS_LAYOUT_MANAGE.BANNER_TYPE_IDS_ is '轮播图分类IDS';

alter table FORM_DATA_TEMPLATE add MOBILE_DISPLAY_FIELD_ CLOB;
comment on column FORM_DATA_TEMPLATE.MOBILE_DISPLAY_FIELD_ is '移动端显示字段';

alter table FORM_DATA_TEMPLATE add MOBILE_MANAGE_FIELD_ CLOB;
comment on column FORM_DATA_TEMPLATE.MOBILE_MANAGE_FIELD_ is '移动端功能按钮';


-- 2023-05-10 jjx 同步脚本
INSERT INTO portal_sys_column (ID,NAME,ALIAS,CATALOG,COL_TYPE,DATA_MODE,DATA_FROM,DS_ALIAS,DS_NAME,COL_HEIGHT,COL_URL,TEMPLATE_HTML,IS_PUBLIC,SUPPORT_REFESH,REFESH_TIME,
    SHOW_EFFECT,MEMO,DATA_PARAM,NEEDPAGE,ORG_ID,CREATOR,CREATE_BY_,UPDATE_BY_,CREATE_TIME_,UPDATE_TIME_,REQUEST_TYPE,
                                CATALOG_NAME,CREATE_ORG_ID_,TENANT_ID_,SHOW_TITLE_,CONTAIN_COL_,APPID_,
                                SECRET_,TEMPLATE_JAVA_SCRIPT_,STYLE_,is_init_,SNAPSHOT_ID_,
                                TEMPLATE_STYLE_)
VALUES ('1651467475169812480', '个人信息栏目移动端', 'grxxlmydd', NULL, 'HtCustom', NULL, NULL, NULL, NULL, 0, '',
        'ICA8ZGl2IGNsYXNzPSJhbGxIb21lIj4KICAgIDxkaXYgY2xhc3M9ImFsbEhvbWVfaGVhZGVycyI+CiAgICAgIDx0ZW1wbGF0ZSB2LWlmPSJkYXRhLnVzZXIucGhvdG8iPgogICAgICAgIDxpbWcKICAgICAgICAgIDpzcmM9IiRyZXF1ZXN0Q29uZmlnLmdldEltZ1NyYyhkYXRhLnVzZXIucGhvdG8pIgogICAgICAgICAgYWx0PSIiCiAgICAgICAgICB3aWR0aD0iNTIiCiAgICAgICAgICBoZWlnaHQ9IjUyIgogICAgICAgIC8+CiAgICAgIDwvdGVtcGxhdGU+CgogICAgICA8aSB2LWVsc2UgY2xhc3M9Imljb24temhhbmdoYW8iIHN0eWxlPSJmb250LXNpemU6IDM2cHg7IGNvbG9yOiAjZmZmIj48L2k+CiAgICAgIDxkaXYgY2xhc3M9InRpdGxlIj4KICAgICAgICA8ZGl2IGNsYXNzPSJ0aXRsZV90b3AiPgogICAgICAgICAge3sgdGl0bGUgfX0KICAgICAgICA8L2Rpdj4KCiAgICAgICAgPGRpdiBjbGFzcz0idGl0bGVfYm90dG9tIj4KICAgICAgICAgIOS9oOWlve+8gSB7eyBkYXRhLnVzZXIuZnVsbG5hbWUgfX0s56Wd5L2g5byA5b+D5q+P5LiA5aSpCiAgICAgICAgPC9kaXY+CiAgICAgIDwvZGl2PgogICAgPC9kaXY+CiAgICA8ZGl2IGNsYXNzPSJhbGxIb21lX2NvbnRlbnQiPgogICAgICA8ZGl2IHYtZm9yPSIoaXRlbSwgaSkgb2YgbGlzdERhdGEiIDprZXk9ImkiIGNsYXNzPSJhbGxIb21lX2NvbnRlbnRfaXRlbSIgQGNsaWNrPSdjbGlja0l0ZW0oaXRlbSknPgogICAgICAgIDxkaXYgY2xhc3M9ImFsbEhvbWVfY29udGVudF9pdGVtX251bSI+CiAgICAgICAgICB7eyBpdGVtLm51bSA+PSA5OSA/ICI5OSsiIDogaXRlbS5udW0gfX0KICAgICAgICA8L2Rpdj4KICAgICAgICA8ZGl2IGNsYXNzPSJhbGxIb21lX2NvbnRlbnRfaXRlbV9uYW1lIj4KICAgICAgICAgIHt7IGl0ZW0ubmFtZSB9fQogICAgICAgIDwvZGl2PgogICAgICA8L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pg==',
        1, NULL, 10, NULL, '',
        '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"${bpmRunTime}/runtime/instance/v1/getDefaultInfoMap\",\"model\":\"upDown\",\"colHeightType\":\"custom\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\",\"dataMode\":3,\"requestType\":\"GET\"}',
        0, NULL, NULL, '1', '1', '2023-04-27 14:05:04', '2023-05-04 16:08:15', NULL, '', '', '-1', 0, NULL, '', '',
        'ewogIGRhdGEoKSB7CiAgICByZXR1cm4gewogICAgICBuYW1lOiAi6LaF57qn566h55CG5ZGYIiwKICAgICAgdGl0bGU6ICLmrKLov47kvb/nlKjlro/lpKlFSVAiLAogICAgICBpbWc6ICIiLAoKICAgICAgbGlzdERhdGE6IFsKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5b6F5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMCIsCiAgICAgICAgICBpZDogIm15VGFrcyIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5bey5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMSIsCiAgICAgICAgICBpZDogIm15QWxyZWFkeSIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5oiR55qE55Sz6K+3IiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVJlcXVlc3QiLAogICAgICAgICAgaWQ6ICJteVJlcXVlc3QiLAogICAgICAgICAKICAgICAgICB9LAogICAgICAgIHsKICAgICAgICAgIG5hbWU6ICLmiJHnmoTovazlip4iLAogICAgICAgICAgbnVtOiAwLAogICAgICAgICAgdG86ICIvbWF0dGVyL215RGVsZWdhdGUiLAogICAgICAgICAgaWQ6ICJteUFjY29yZGluZ01hdHRlcnMiLAogICAgICAgIH0sCiAgICAgIF0sCiAgICB9OwogIH0sCiAgbW91bnRlZCgpIHsKICAgIAogICAgZm9yIChsZXQgaXRlbT0wOyAgaXRlbSA8IHRoaXMubGlzdERhdGEubGVuZ3RoOyBpdGVtKyspIHsKICAKICAgICAgdGhpcy5saXN0RGF0YVtpdGVtXS5udW0gPSB0aGlzLmRhdGFbdGhpcy5saXN0RGF0YVtpdGVtXS5pZF0uZGF0YVRleHQgfHwgMDsKICAgIH0KICB9LAogIG1ldGhvZHM6IHsKICAgIGNsaWNrSXRlbShpdGVtKSB7CiAgICAgY29uc29sZS5sb2coaXRlbSkKICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS50byk7CiAgICB9LAogIH0sCn0=',
        '', 0, '1654035192534351872',
        'LmFsbEhvbWUgewoKICB3aWR0aDogY2FsYygxMDAlIC0gMjRweCk7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGp1c3RpZnktY29udGVudDogc3BhY2UtYmV0d2VlbjsKICBoZWlnaHQ6IDExOHB4OwogIGJhY2tncm91bmQ6ICNmZmZmZmY7CiAgYm9yZGVyLXJhZGl1czogMTJweCAxMnB4IDEycHggMTJweDsKICBwYWRkaW5nOiAxNnB4IDEycHg7Cn0KIC5hbGxIb21lX2hlYWRlcnMgewogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBmbGV4LXN0YXJ0OwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0KLmFsbEhvbWUgLmFsbEhvbWVfaGVhZGVycyBpbWcgewogIG1hcmdpbi1yaWdodDogOHB4OwogIGJvcmRlci1yYWRpdXM6IDUwJTsKfQouYWxsSG9tZSAuYWxsSG9tZV9oZWFkZXJzIC50aXRsZSAudGl0bGVfdG9wIAp7ICAgIG1hcmdpbi1ib3R0b206IDdweDsKICBjb2xvcjogIzI2MjYyNjsKICBmb250LXdlaWdodDogODAwOwogIGZvbnQtc2l6ZTogMThweDsKfQoKLmFsbEhvbWUgLmFsbEhvbWVfY29udGVudCAuYWxsSG9tZV9jb250ZW50X2l0ZW1fbnVtewogIG1hcmdpbi10b3A6MTZweDsKaGVpZ2h0OiAzMHB4Owpjb2xvcjogIzI2MjYyNjsKZm9udC13ZWlnaHQ6IDkwMDsKZm9udC1zaXplOiAyNHB4OwptYXJnaW4tYm90dG9tOiA2cHg7dGV4dC1hbGlnbjogY2VudGVyOwp9Ci5hbGxIb21lIC5hbGxIb21lX2hlYWRlcnMgLnRpdGxlIC50aXRsZV9ib3R0b20gewogIGNvbG9yOiAjNTg1ODU4OwogIGZvbnQtd2VpZ2h0OiA0MDA7CiAgZm9udC1zaXplOiAxNHB4Owp9Ci5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnQgLmFsbEhvbWVfY29udGVudF9pdGVtX25hbWV7CiAgCmZvbnQtc2l6ZTogMTFweDsKZm9udC13ZWlnaHQ6IDQwMDsKY29sb3I6ICM4QzhDOEM7Cn0KCi5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnR7CgogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBzcGFjZS1iZXR3ZWVuOwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0=');




INSERT INTO portal_sys_column(ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS,
                                DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH,
                                REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR,
                                CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE,
                                CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_, SHOW_TITLE_, CONTAIN_COL_, APPID_,
                                SECRET_, TEMPLATE_JAVA_SCRIPT_, STYLE_, is_init_, SNAPSHOT_ID_,
                                TEMPLATE_STYLE_)
VALUES ('1651134508916514816', '常用功能', 'cygnsjd', NULL, 'HtCustom', NULL, NULL, NULL, NULL, NULL, '',
        'PGRpdiBzdHlsZT0icGFkZGluZzoxNnB4IDAiPgogIDxkaXYgY2xhc3M9ImNvbW1vbi1mdW5jdGlvbiIgc3R5bGU9ImRpc3BsYXk6IGZsZXg7IGZsZXgtd3JhcDogd3JhcCI+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0gaG92ZXItZm9sbG93LXRoZW1lLWNvbG9yIgogICAgICBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQub3JnOjg4ODgvY2hhbnpoaS9pbmRleC5waHAvYm9vay91c2UxLzg3OC5odG1sJywnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTIzOTc1NDcxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjM1NiIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNODE4LjAxODk4OCAwLjAwMDUzOUgxMDIuMzA1MzczYTc1LjE4NTA5NyA3NS4xODUwOTcgMCAwIDAtNzUuNDU0NTc4IDc0Ljk0MjU2NHY4MzIuNjk1MTU5YTc1LjIxMjA0NSA3NS4yMTIwNDUgMCAwIDAgNzUuNDU0NTc4IDc0Ljk2OTUxM2gzMjEuNDYzNDQ4bDQ2OS42MjM5MDEtNDY2LjkwMjE0N1Y3NC45NDMxMDNBNzUuMTU4MTQ5IDc1LjE1ODE0OSAwIDAgMCA4MTguMDE4OTg4IDAuMDAwNTM5ek00MTkuNTExMDI3IDY4Mi42NDg4ODFIMjI5Ljk1ODM0OWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTloMTg5LjU1MjY3OGE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAgODAuODQ0MTl6IG0yNzAuNzc0MTQxLTE2Ni43ODE1NjRIMjI5Ljk4NTI5N2E0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTkxaDQ2MC4zMjY4MTlhNDAuNDIyMDk1IDQwLjQyMjA5NSAwIDEgMSAwIDgwLjg0NDE5MXogbTQwLjYzNzY3OS0yMTMuNDU1NjExYTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjM3Njc5IDQwLjQyMjA5NkgyMjkuOTg1Mjk3YTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjEwNzMyLTQwLjQyMjA5NiA0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYxMDczMi00MC40MjIwOTVoNDYwLjMyNjgxOWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYzNzY3OSA0MC40MjIwOTV6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE2MzU3IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MDUuMTYwNDk5IDc2Mi43OTI0MjFMNjYzLjE0ODQ2OCA4MDMuODYxMjdsLTM4Ljc3ODI2MyAzNy43MjcyODktMjkuMDUwMDEzIDI4LjI5NTQ2Ni0xNS4yNzk1NTIgMTQuNDcxMTFhODcuNjg4OTk4IDg3LjY4ODk5OCAwIDAgMC0xOC44NjM2NDQgMjUuNDkyODY4IDE4Mi4wMDcyMiAxODIuMDA3MjIgMCAwIDAtNi41MjE0MzEgMTcuMzgxNTAxbC04Ljg2NTkxMyAyNi4yNzQzNjItOC4wODQ0MTkgMjcuMjcxNDRjLTEuODA1NTIgNi42MDIyNzYtMy4zMTQ2MTIgMTMuMjg1Mzk1LTQuNjM1MDY3IDE5Ljk5NTQ2M2EyMy41Nzk1NTUgMjMuNTc5NTU1IDAgMCAwIDIuMjA5NzQxIDE5LjA3OTIyOWMzLjIzMzc2OCAzLjY5MTg4NSA5LjI0MzE4NiA0Ljg3NzU5OSAxOS4xMDYxNzcgMy42OTE4ODVhMTg5LjkyOTk1MSAxODkuOTI5OTUxIDAgMCAwIDIwLjgwMzkwNS00Ljk4NTM5MiAyNTYuNDkxNjY3IDI1Ni40OTE2NjcgMCAwIDAgMjkuNjQyODctNy44MTQ5MzhjMTAuMTU5NDItMi42OTQ4MDYgMTkuODg3NjcxLTYuMzg2NjkxIDI5LjkzOTI5OC05LjQ4NTcxOWwyNC40MTQ5NDYtMTAuOTk0ODA5IDEzLjg3ODI1Mi04LjA4NDQxOSAxMi44NTQyMjctOS40ODU3MTkgMzkuODAyMjg5LTM5LjE1NTUzNiAzOC45MTMwMDQtMzcuMjY5MTcyIDQxLjk4NTA4My00MC40MjIwOTUgMTEzLjc3NDcyMy0xMDguNzA4NDg3LTk4LjM4NzM3OS05NC41MDY4NTl6IG0yOTEuODQ3NTI2LTEwNC4yMDgxNjFhMTAzLjUwNzUxMiAxMDMuNTA3NTEyIDAgMCAwLTQuNjA4MTE4LTIyLjc3MTExMyA5Mi4zNTEwMTMgOTIuMzUxMDEzIDAgMCAwLTIwLjgwMzkwNS0yOS42NDI4NyA4MC40NjY5MTcgODAuNDY2OTE3IDAgMCAwLTI0LjkyNjk1OS0xOS41OTEyNDIgNjMuNjI0Mzc4IDYzLjYyNDM3OCAwIDAgMC0yNy4zNTIyODQtNy4xOTUxMzMgMzcuNTM4NjUyIDM3LjUzODY1MiAwIDAgMC0zMC4wNDcwOTEgMTAuMzc1MDA0bC0xNC43Njc1MzkgMTIuMzE1MjY1YTE4Ny4wNDY1MDggMTg3LjA0NjUwOCAwIDAgMS0xNS41NzU5OCAxMy42NjI2NjlsOTkuMzg0NDU3IDk0LjUzMzgwNmE1NC40ODg5ODQgNTQuNDg4OTg0IDAgMCAwIDguMjQ2MTA4LTYuNzkwOTEybDguMjQ2MTA3LTguNzA0MjI1IDEwLjUzNjY5My0xMC4zNzUwMDRhMzIuOTg0NDMgMzIuOTg0NDMgMCAwIDAgMTEuNjk1NDU5LTI1LjgxNjI0NXoiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwN0EiCiAgICAgICAgICBwLWlkPSIxNjM1OCIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5bel5pe255m76K6wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL3VzZTEvODgwLmh0bWwnLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ0MTY4NTMiCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDExMzcgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE2NDkyIgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik04NjYuMDE4MTcgNTgxLjI0MjIwMmExMDkuMDgwNjg3IDEwOS4wODA2ODcgMCAwIDEgNS45NzMxMjggMzMuMTM2NjM2djEwMi4zOTY0NzNhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAxLTEwNC41Mjk3MzMgMTAyLjM5NjQ3M2gtMTA3LjUxNjI5NmExMDEuNzk5MTYgMTAxLjc5OTE2IDAgMCAxLTEwNC41Mjk3MzMtMTAyLjM5NjQ3M3YtMTAyLjM5NjQ3M2ExMjkuMDQ3OTk5IDEyOS4wNDc5OTkgMCAwIDEgNS45NzMxMjctMzMuMTM2NjM2Yy0xNTguMjU5NDM4IDQyLjE1MzIxNS0yNjguNzYyMjk4IDE0NC41NDk2ODgtMjY4Ljc2MjI5OCAyNjIuMDIxMTk3VjkyMS41NjgyNTdhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAwIDEwNC41Mjk3MzMgMTAyLjM5NjQ3M2g2MzYuMDgxMjAyYTEwMS43OTkxNiAxMDEuNzk5MTYgMCAwIDAgMTA0LjUyOTczMi0xMDIuMzk2NDczdi03OC4zMDQ4NThjLTIuODQ0MzQ2LTExNy40NDMwNjYtMTEzLjQ4OTQyNC0yMTkuODM5NTM5LTI3MS43NDg4NjItMjYyLjAyMTE5N3pNNzEwLjc3Mzc0IDYxNC4zNzg4MzhhNTMuMTg5Mjc5IDUzLjE4OTI3OSAwIDAgMC01My43NTgxNDggNTEuMTk4MjM3djUxLjE5ODIzNmE1My44MTUwMzUgNTMuODE1MDM1IDAgMCAwIDEwNy41MTYyOTYgMHYtNTEuMTk4MjM2YTUwLjA4ODk0MSA1MC4wODg5NDEgMCAwIDAtMTQuOTMyODE5LTM2LjE1MTY0NCA1Ni41MTcxNjQgNTYuNTE3MTY0IDAgMCAwLTM4LjgyNTMyOS0xNS4wNDY1OTN6IG0wLTUxLjE5ODIzNmEyNzQuMTk1IDI3NC4xOTUgMCAwIDAgMjY1Ljc3NTczNC0yODAuMDgyNzk4YzAtMTUzLjU5NDcxLTExNi40NzU5ODgtMjgzLjA5NzgwNC0yNjIuNzg5MTctMjgzLjA5NzgwNFM0NDcuOTg0NTY5IDEyNi40ODgwODggNDQ3Ljk4NDU2OSAyODMuMDk3ODA0czExOS40MDU2NjUgMjgwLjA4Mjc5NyAyNjIuNzg5MTcxIDI4MC4wODI3OTh6IgogICAgICAgICAgZmlsbD0iI0ZFOUM1NCIKICAgICAgICAgIHAtaWQ9IjE2NDkzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xNzMuMTkyMjU3IDkxMy40NjE4N2ExMDIuNjUyNDY0IDEwMi42NTI0NjQgMCAwIDEtMTQuOTMyODE5LTUxLjM0MDQ1NHYtNzguNTMyNDA2YzAtMTExLjc1NDM3MyAxMDQuNTI5NzMzLTIxMS40MjAyNzMgMjU5LjgwMjYwNy0yNTYuNzAyMjY5YTI5OS44Nzk0NDkgMjk5Ljg3OTQ0OSAwIDAgMS05OC41NTY2MDYtMjI5LjUzODc2MUEzNDUuOTI5NDE4IDM0NS45Mjk0MTggMCAwIDEgMzU4LjM4NzY1NiAxNDMuMzI2NjE5YTIyNC4wMjA3MjggMjI0LjAyMDcyOCAwIDAgMC0xOTcuMDg0NzY4IDIyOS41Mzg3NiAyMzUuNTY4Nzc1IDIzNS41Njg3NzUgMCAwIDAgOTIuNTgzNDc4IDE5MC4yNTgzMzZDMTA3LjUxNjI5NyA1OTMuMzMwNjc0IDAgNjgwLjkwODEwMiAwIDc4MC40NjAyMjlWODU4Ljk5MjYzNWE1My4yNDYxNjYgNTMuMjQ2MTY2IDAgMCAwIDUzLjc1ODE0OCA1MS40NTQyMjd6IgogICAgICAgICAgZmlsbD0iI0ZGQzI5NSIKICAgICAgICAgIHAtaWQ9IjE2NDk0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlrqLmiLc8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svdXNlMS84NzkuaHRtbCcsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDQ0OTUyNyIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTY2MjgiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTQ5OC40MTAyNjMgODIxLjg1Njg1NGEyNjkuNDUyMzQxIDI2OS40NTIzNDEgMCAwIDEgNDE4LjY3NTA0Ny0yMjQuMjkyMTI4VjI2MS40NDk4NzZhMTIyLjI1MDUyNyAxMjIuMjUwNTI3IDAgMCAwLTMwLjA3MDg4MS02NC45MzgwMTRMNzEzLjY3NTczOCAyNS42MjUxODdBMTAxLjY2NDM2OCAxMDEuNjY0MzY4IDAgMCAwIDY0Ni40NDczNzkgMC4wMDAyNjloLTUxNC42NTM5N0E3Ny41NDgzODQgNzcuNTQ4Mzg0IDAgMCAwIDUzLjk3NTU3MyA3Ni45MDE5Njh2ODMwLjk5MTAxOGE3My4wMjE1ODQgNzMuMDIxNTg0IDAgMCAwIDczLjAyMTU4NCA3My4wMjE1ODVoNDIzLjg0ODUzMmEyNjcuNzU0NzkxIDI2Ny43NTQ3OTEgMCAwIDEtNTIuNDM1NDI2LTE1OS4wNTc3MTd6TTI1Ni40MTUxMTYgMjYwLjg4NDAyNmg0NTguMDY4OTc5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAwIDEgMCA4MC44MzU3MDJoLTQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDAgMSAwLTgwLjgzNTcwMnogbTAgMTczLjIzMDkxaDQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDEgMSAwIDgwLjgzNTcwMmgtNDU4LjA2ODk3OWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAtODAuODM1NzAyeiBtMTg4LjYxNjYzOSAyNDcuNzA3NTM2aC0xODguNjE2NjM5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAxIDEgMC04MC44MzU3MDJoMTg4LjYxNjYzOWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAgODAuODM1NzAyeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkYiCiAgICAgICAgICBwLWlkPSIxNjYyOSIKICAgICAgICA+PC9wYXRoPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNzY3LjkxNjQ5NSA2MTkuODIxNDg5YTIwMi4wODkyNTYgMjAyLjA4OTI1NiAwIDEgMCAyMDIuMDg5MjU1IDIwMi4wODkyNTUgMjAyLjA4OTI1NiAyMDIuMDg5MjU2IDAgMCAwLTIwMi4wODkyNTUtMjAyLjA4OTI1NXogbTEzMC4wOTE1OSAxOTEuMzExMTYybC00My43ODYwMDYgMzcuNzIzMzI4YTI0LjI1MDcxMSAyNC4yNTA3MTEgMCAwIDAtNS43MTIzODkgMTYuMTY3MTRsOS41MTE2NjcgNTUuODg0NDE1YTIwLjM0MzY1MiAyMC4zNDM2NTIgMCAwIDEtMjguNTYxOTQ4IDE5LjgzMTY5M2wtNTEuMzg0NTYxLTI2Ljk0NTIzNGExNS4wMDg0OTUgMTUuMDA4NDk1IDAgMCAwLTE3LjEzNzE2OSAwbC01My4yOTc2NzMgMjYuOTQ1MjM0YTE5LjY3MDAyMSAxOS42NzAwMjEgMCAwIDEtMjguNTYxOTQ4LTE5LjgzMTY5M2w5LjUxMTY2Ny01NS44ODQ0MTVhMTcuNTQxMzQ3IDE3LjU0MTM0NyAwIDAgMC01LjcxMjM4OS0xNi4xNjcxNGwtNDMuNzg2MDA2LTM5LjYzNjQ0YTE3LjU0MTM0NyAxNy41NDEzNDcgMCAwIDEgMTEuNDI0NzgtMzAuNjYzNjc2bDU5LjAxMDA2Mi04Ljk5OTcwOGEyNi40ODcxNjUgMjYuNDg3MTY1IDAgMCAwIDE1LjI1MTAwMy05LjAyNjY1NGwyNi42NDg4MzYtNTAuNDQxNDc4YTIwLjIwODkyNiAyMC4yMDg5MjYgMCAwIDEgMzQuMjQ3MzkzIDBsMjYuNjQ4ODM2IDUwLjQ0MTQ3OGEyOS42Mzk3NTcgMjkuNjM5NzU3IDAgMCAwIDE1LjI1MTAwMyAxMC43NzgwOTRsNTkuMDEwMDYyIDguOTk5NzA4YTE4LjQ4NDQzMSAxOC40ODQ0MzEgMCAwIDEgMTEuNDI0NzggMzAuNTgyODQxeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE2NjMwIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlkIjlkIw8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NTM4MzAxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjc2NCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTEwLjg4NzM0MSAxNDAuMTM0OTIybDQwLjQyMDY1OS00OC41MDQ3OTFhNDY5LjA5NTIyMiA0NjkuMDk1MjIyIDAgMCAxIDMyLjMzNjUyOC0zNy43MjU5NDhsMjYuOTQ3MTA2LTI2Ljk0NzEwN2E5Ni43NDAxMTEgOTYuNzQwMTExIDAgMCAxIDI2Ljk0NzEwNi0xOC44NjI5NzQgODUuOTg4MjE1IDg1Ljk4ODIxNSAwIDAgMSAzNy43MjU5NDgtOC4wODQxMzJoNDg0LjcyNDU0NGExNTcuNTU5NzI5IDE1Ny41NTk3MjkgMCAwIDEgMzUuMDMxMjM4IDUuMzg5NDIyIDEyMS4zOTY3MTMgMTIxLjM5NjcxMyAwIDAgMSAzNy43MjU5NDggMjYuOTQ3MTA2IDE5Ni41MjUyNDQgMTk2LjUyNTI0NCAwIDAgMCAyNC4yNTIzOTUgMjkuNjQxODE2IDMwNC45ODczNDYgMzA0Ljk4NzM0NiAwIDAgMSAyNi45NDcxMDYgMzUuMDMxMjM4YzEwLjc3ODg0MiAxMy40NzM1NTMgMjEuNTU3Njg1IDI5LjY0MTgxNyAzMi4zMzY1MjggNDMuMTE1Mzd6IgogICAgICAgICAgZmlsbD0iIzdGQzdGMSIKICAgICAgICAgIHAtaWQ9IjE2NzY1IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xMDIxLjI5NTMxOSAzMzEuMzI0NjM5YTk0LjEyNjI0MSA5NC4xMjYyNDEgMCAwIDAtMjEuNTU3Njg1LTY0LjY3MzA1NCA4My4yNjY1NTggODMuMjY2NTU4IDAgMCAwLTcyLjc1NzE4Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWE5MS40MDQ1ODQgOTEuNDA0NTg0IDAgMCAwLTcyLjc1NzE4NiAyNi45NDcxMDYgODYuMDY5MDU3IDg2LjA2OTA1NyAwIDAgMC0yMS41NTc2ODUgNjQuNjczMDU0djE3Ny44NTA5YTg5Ljg2ODU5OSA4OS44Njg1OTkgMCAwIDAgOTQuMzE0ODcxIDgzLjUzNjAyOWg4MzIuMjg4MzE3YTgwLjQ5MTAwNiA4MC40OTEwMDYgMCAwIDAgNjcuMzY3NzY1LTI2Ljk0NzEwNiA5Ni41Nzg0MjggOTYuNTc4NDI4IDAgMCAwIDI0LjI1MjM5Ni02NC42NzMwNTV6IG0tNDQxLjc3MDg1NiAxMjMuOTU2Njg4aC0xMzQuNzM1NTMxYTQwLjQyMDY1OSA0MC40MjA2NTkgMCAwIDEgMC04MC44NDEzMThoMTM0LjczNTUzMWE0MS40NDQ2NDkgNDEuNDQ0NjQ5IDAgMCAxIDQwLjQyMDY1OSA0MC40MjA2NTkgMzkuNjY2MTQgMzkuNjY2MTQgMCAwIDEtNDAuNDIwNjU5IDQwLjQyMDY1OXoiCiAgICAgICAgICBmaWxsPSIjMkZBQUYyIgogICAgICAgICAgcC1pZD0iMTY3NjYiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTEwMjMuOTkwMDMgNzU2LjgxOTQ0NGE5MS44MDg3OSA5MS44MDg3OSAwIDAgMC0yNC4yNTIzOTYtNjQuNjczMDU1IDg1Ljg1MzQ4IDg1Ljg1MzQ4IDAgMCAwLTcwLjA2MjQ3Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWExMDAuODA5MTI0IDEwMC44MDkxMjQgMCAwIDAtNzUuNDUxODk3IDI2Ljk0NzEwNiAxMDMuNTAzODM0IDEwMy41MDM4MzQgMCAwIDAtMjQuMjUyMzk1IDY3LjM2Nzc2NXYxNjEuNjgyNjM2YTkwLjU5NjE3MSA5MC41OTYxNzEgMCAwIDAgMjkuNjQxODE2IDc1LjQ1MTg5NyA5NC4wNDU0IDk0LjA0NTQgMCAwIDAgNjQuNjczMDU1IDI2Ljk0NzEwNmg4MzIuMjg4MzE3YTkyLjIzOTk0NCA5Mi4yMzk5NDQgMCAwIDAgOTcuMDA5NTgyLTk0LjMxNDg3MXogbS00NDQuNDY1NTY3IDE1OC45ODc5MjVoLTEzNC43MzU1MzFhNDAuNDIwNjU5IDQwLjQyMDY1OSAwIDAgMSAwLTgwLjg0MTMxOGgxMzQuNzM1NTMxYTQxLjQ0NDY0OSA0MS40NDQ2NDkgMCAwIDEgNDAuNDIwNjU5IDQwLjQyMDY1OSAzOC4xODQwNDkgMzguMTg0MDQ5IDAgMCAxLTQwLjQyMDY1OSA0MC40MjA2NTl6IgogICAgICAgICAgZmlsbD0iIzJGQUFGMiIKICAgICAgICAgIHAtaWQ9IjE2NzY3IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rpobnnm648L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0Njc5NTI3IgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMTM3IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzQ0OCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTAzOC4yMjIyMjIgMEExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEgMTEzNy43Nzc3NzggOTkuNTU1NTU2djY2OC4xNmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2IDk5LjU1NTU1NUg1MTQuODQ0NDQ0bC0yMzAuNCAxNTAuNzU1NTU2YTMyLjE5OTExMSAzMi4xOTkxMTEgMCAwIDEtNDUuNTExMTExLTguNTMzMzM0IDQwLjM5MTExMSA0MC4zOTExMTEgMCAwIDEtNS42ODg4ODktMTcuMDY2NjY2di0xMjIuMzExMTExSDk5LjU1NTU1NmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2LTk5LjU1NTU1NlY5OS41NTU1NTZBMTAwLjc3ODY2NyAxMDAuNzc4NjY3IDAgMCAxIDk5LjU1NTU1NiAwaDkzOC42NjY2NjZ6IgogICAgICAgICAgZmlsbD0iIzg1NTBFMSIKICAgICAgICAgIHAtaWQ9IjE3NDQ5IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03NTMuNzc3Nzc4IDMzMi43MTQ2NjdoLTM2OS43Nzc3NzhhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMS00Mi42NjY2NjctNDIuNjY2NjY3IDQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY3LTQyLjY2NjY2N2gzNjkuNzc3Nzc4YTQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY2IDQyLjY2NjY2NyA0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2NiA0Mi42NjY2Njd6IgogICAgICAgICAgZmlsbD0iI0ZGRkZGRjdBIgogICAgICAgICAgcC1pZD0iMTc0NTAiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTU4My4xMTExMTEgNTMxLjc0MDQ0NGgtMTk5LjExMTExMWE0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2Ny00Mi42NjY2NjYgNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjctNDIuNjY2NjY3aDE5OS4xMTExMTFhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjcgNDIuNjY2NjY3IDQxLjg5ODY2NyA0MS44OTg2NjcgMCAwIDEtNDIuNjY2NjY3IDQyLjY2NjY2NnoiCiAgICAgICAgICBmaWxsPSIjRkZGRkZGN0EiCiAgICAgICAgICBwLWlkPSIxNzQ1MSIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5ZSu5YmN5pSv5oyBPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2RlcGxveS82Lmh0bWwsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDY2NDE0MiIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTczMTEiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTUxMi4wMjkyMzYgMTMxLjI0OTczYTI4Mi45MzM3NDMgMjgyLjkzMzc0MyAwIDEgMCAyODguMzIyOTU4IDI4Mi45MzM3NDMgMjgyLjkzMzc0MyAyODIuOTMzNzQzIDAgMCAwLTI4OC4zMjI5NTgtMjgyLjkzMzc0M3oiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwIgogICAgICAgICAgcC1pZD0iMTczMTIiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTE3Ny44OTc5NTkgNTIxLjk2Nzc1NnYtMjYxLjM3Njg4N2gtMTAuNzc4NDI4YTM4MS4zNjc3MzkgMzgxLjM2NzczOSAwIDAgMSA1MDYuNTg2MTMtMTgwLjUzODY3NCAzOTAuODUyNzU2IDM5MC44NTI3NTYgMCAwIDEgMTgwLjUzODY3NCAxODAuNTM4Njc0aC0xMC43Nzg0Mjh2MjYxLjM3Njg4N2ExMjkuOTYwODk5IDEyOS45NjA4OTkgMCAwIDAgMTMyLjAzNTc0Ni0xMjkuMzQxMTQgMTI4LjI2MzI5NyAxMjguMjYzMjk3IDAgMCAwLTY3LjM2NTE3Ni0xMTMuMTczNDk3IDQyMy4wNTMzMTEgNDIzLjA1MzMxMSAwIDAgMC03OTQuOTA5MDg4LTIuNjk0NjA3IDEyNi4xODg0NDkgMTI2LjE4ODQ0OSAwIDAgMC02Ny4zNjUxNzcgMTEzLjE3MzQ5NyAxMzIuMjUxMzE1IDEzMi4yNTEzMTUgMCAwIDAgMTMyLjAzNTc0NyAxMzIuMDM1NzQ3eiIKICAgICAgICAgIGZpbGw9IiMwN0MxNjA3QSIKICAgICAgICAgIHAtaWQ9IjE3MzEzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03OTcuNjU3NTg2IDY3MS4wMDY0NzNhNDI2LjA0NDMyNSA0MjYuMDQ0MzI1IDAgMCAxLTU3My45NTEzMDcgMEEzODEuODc5NzE1IDM4MS44Nzk3MTUgMCAwIDAgMC4wNTM4OTIgMTAyNGgxMDIzLjk1MDY4OWMwLTE2NC4zNzEwMzItODguOTIyMDMzLTI4NS42MjgzNS0yMjYuMzQ2OTk1LTM1Mi45OTM1Mjd6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE3MzE0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7llK7lkI7mlK/mjIE8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svY2p3dC8yNzMuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NjUyMDAyIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzE3NSIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNTEyIDUxMm0tNTEyIDBhNTEyIDUxMiAwIDEgMCAxMDI0IDAgNTEyIDUxMiAwIDEgMC0xMDI0IDBaIgogICAgICAgICAgZmlsbD0iI0VGQTEzQyIKICAgICAgICAgIHAtaWQ9IjE3MTc2IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MjUuNjgzMiAyNjcuNDQzMmE1MS4zMjggNTEuMzI4IDAgMCAwLTM0LjcxMzYgMGwtMjYwLjM3NzYgOTMuNzcyOGExMTUuMiAxMTUuMiAwIDAgMC02OS4zNzYgNjkuMzc2bC05My43NDcyIDI2MC4zNzc2YTUxLjIgNTEuMiAwIDAgMCA2NS41MzYgNjUuNTM2bDI2MC40MDMyLTkzLjc0NzJhMTE1LjIgMTE1LjIgMCAwIDAgNjkuMzUwNC02OS4zNzZsOTMuNzQ3Mi0yNjAuNDAzMmE1MS4yIDUxLjIgMCAwIDAtMzAuODIyNC02NS41MzZ6IG0tMjEzLjY4MzIgMzA4LjUzMTJhNjQgNjQgMCAxIDEgNjQtNjQgNjQgNjQgMCAwIDEtNjQuMDI1NiA2NC4wMjU2eiIKICAgICAgICAgIGZpbGw9IiNGRkRBQUIiCiAgICAgICAgICBwLWlkPSIxNzE3NyIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+57u85ZCI5bmz5Y+wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2V4dGVuZC9qc2NoZWNrLTE1OS5odG1sLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ2MzQ5NzciCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDEwODEgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE3MDM5IgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05My44NzcxMzcgNjQyLjg0MjEyM0gwLjAxMDgwOXYxMTMuNzc3MzY3QTk3LjE5NDMxNiA5Ny4xOTQzMTYgMCAwIDAgOTMuODc3MTM3IDg1My4zMzAyNTJoMzk4LjIyMDc4NHY3Ni43OTk3MjNoLTE0Mi4yMjE3MDlhNDUuNTEwOTQ3IDQ1LjUxMDk0NyAwIDAgMC00NS41MTA5NDcgNDguMzU1MzggNDQuOTQyMDYgNDQuOTQyMDYgMCAwIDAgNDUuNTEwOTQ3IDQ1LjUxMDk0N2gzNzUuNDY1MzExYTQ1LjUxMDk0NyA0NS41MTA5NDcgMCAwIDAgNDUuNTEwOTQ3LTQ4LjM1NTM4MSA0NC45NDIwNiA0NC45NDIwNiAwIDAgMC00NS41MTA5NDctNDUuNTEwOTQ2aC0xNDIuMjIxNzA5Vjg1My4zMzAyNTJoNDAxLjA2NTIxOWE5NS4zMTY5ODkgOTUuMzE2OTg5IDAgMCAwIDkzLjg2NjMyNy05Ni43MTA3NjJ2LTExMy43NzczNjdIOTMuODc3MTM3eiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE3MDQwIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05ODcuMDI5NDY3IDBIOTMuODc3MTM3QTk1LjMxNjk4OSA5NS4zMTY5ODkgMCAwIDAgMC4wMTA4MDkgOTYuNzEwNzYydjQ0OS40MjA1OTloMTA4MC44ODQ5ODZWOTYuNzEwNzYyQTk1LjIwMzIxMiA5NS4yMDMyMTIgMCAwIDAgOTg3LjAyOTQ2NyAwIgogICAgICAgICAgZmlsbD0iIzQwNTNGRiIKICAgICAgICAgIHAtaWQ9IjE3MDQxIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7lkI7lj7DnrqHnkIY8L3NwYW4+CiAgICA8L2Rpdj4KICA8L2Rpdj4KPC9kaXY+Cg==',
        1, NULL, 10, NULL, '',
        '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}',
        0, NULL, NULL, '1', '1', '2023-04-26 16:01:58', '2023-05-05 17:09:33', NULL, '', '', '-1', 1, NULL, '', '',
        'e30=', '', 0, '1654413008396435456',
        'Lm1vYmlsZS1jdXN0b20taXRlbXsKICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBzcGFjZS1hcm91bmQ7CiAgICBoZWlnaHQ6IDgycHg7CiAgICBjb2xvcjogIzI2MjYyNjsKICAgIGZvbnQtc2l6ZTogMTNweDsKICAgIHdpZHRoOiAyNSU7CiAgICBtYXJnaW4tYm90dG9tOiA4cHg7Cn0KICA=');

INSERT INTO portal_sys_column(ID, NAME,ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS,
                                DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH,
                                REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR,
                                CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE,
                                CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_, SHOW_TITLE_, CONTAIN_COL_, APPID_,
                                SECRET_, TEMPLATE_JAVA_SCRIPT_, STYLE_, is_init_, SNAPSHOT_ID_,
                                TEMPLATE_STYLE_)
VALUES ('1651056986864828416', '数据台', 'sjt', NULL, 'HtCustom', NULL, NULL, NULL, NULL, NULL, '',
        'PGRpdiBjbGFzcz0ibW9iaWxlLWFwcGx5LWNhcmQiIDpjbGFzcz0ieyAnYm9yZGVyLWJvdHRvbSc6IGlzU2hvd0JvdHRvbU1hcmdpbiB9Ij4KICA8ZGl2CiAgICA6Ym9yZGVyPSJmYWxzZSIKICAgIGNsYXNzPSJtb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCIKICAgIHYtaWY9ImFwcGx5TGlzdCAmJiBhcHBseUxpc3QubGVuZ3RoIgogID4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1hcHBseS1jYXJkLS1pdGVtIgogICAgICB2LWZvcj0iKGl0ZW0sIGluZGV4KSBpbiBhcHBseUxpc3QiCiAgICAgIDprZXk9ImAke2l0ZW0ubmFtZX1fJHtpbmRleH1gIgogICAgICBAY2xpY2s9ImhhbmRsZUNsaWNrKGl0ZW0pIgogICAgPgogICAgICA8ZGl2CiAgICAgICAgY2xhc3M9Iml0ZW0tdG9wLS1pY29uIgogICAgICAgIDpzdHlsZT0ieyBiYWNrZ3JvdW5kOiBpdGVtLmljb25Db2xvciB8fCAnIzQwOUVGRicgfSIKICAgICAgPgogICAgICAgIDxpIGNsYXNzPSJtb2JpbGUtYXBwbHktaWNvbiIgOmNsYXNzPSJpdGVtLmljb24gfHwgJ2ljb24tYXNpZGUtYXBwLWNlbnRlciciPjwvaT4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgY2xhc3M9Im1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSI+e3sgaXRlbS5uYW1lfX08L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pgo8L2Rpdj4=',
        1, NULL, 10, NULL, '',
        '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}',
        0, NULL, NULL, '1', '1', '2023-04-26 10:53:55', '2023-05-05 15:05:57', NULL, '', '', '-1', 1, NULL, '', '',
        'ewogICBkYXRhKCkgewogICAgICByZXR1cm4gewogICAgICAgIGlzU2hvd0JvdHRvbU1hcmdpbjpmYWxzZSwKICAgICAgICBhcHBseUxpc3Q6IFsKICAgICAgICAgIHsKICAgICAgICAgICAgbmFtZTogJ+aWsOW7uua1geeoiycsCiAgICAgICAgICAgIGljb246ICdpY29uLXhpbmppYW5saXVjaGVuZzExJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwOUVGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL25ld01hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5b6F5Yqe5bey5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24tZGFpYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwNTNGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215VGFzaycsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE55Sz6K+3JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXNoZW5xaW5nJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0Y2Qjg1QScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215UmVxdWVzdCcsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE5Lyg6ZiFJywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZWNodWFueXVlJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzg1NTBFMScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL2NpcmN1bGF0ZU1hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE6L2s5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXpodWFuYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0ZGOEE0NicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215RGVsZWdhdGUnLAogICAgICAgICAgfSwKICAgICAgICBdLAogICAgICB9CiAgIH0sCiAgICAgbWV0aG9kczogewogICAgICBoYW5kbGVDbGljayhpdGVtKSB7CiAgICAgICAgaWYgKGl0ZW0ucGF0aCkgewogICAgICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS5wYXRoKQogICAgICAgIH0KICAgICAgfSwKICAgIH0sCn0=',
        '', 0, '1654381902993375232',
        'Lm1vYmlsZS1hcHBseS1jYXJkIHsKICBiYWNrZ3JvdW5kOiAjZmZmOwp9CgoubW9iaWxlLWFwcGx5LWNhcmQtLWNvbnRlbnR7CiAgIGRpc3BsYXk6IGZsZXg7CiAgIGZsZXgtd3JhcDogd3JhcDsKICAgcGFkZGluZy10b3A6IDE2cHg7Cn0KLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbXsKICAgIHdpZHRoOiAyNSU7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgdGV4dC1hbGlnbjogY2VudGVyOwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IHNwYWNlLWFyb3VuZDsKICAgIGhlaWdodDogOTBweDsKICAgIG1hcmdpbi1ib3R0b206OHB4Owp9Ci5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLml0ZW0tdG9wLS1pY29uIHsKICB3aWR0aDogNDBweDsKICBoZWlnaHQ6IDQwcHg7CiAgZGlzcGxheTogZmxleDsKICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICBhbGlnbi1pdGVtczogY2VudGVyOwogIGJvcmRlci1yYWRpdXM6IDhweDsKICBjb2xvcjogI2ZmZjsKfQoKLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbSAuaXRlbS10b3AtLWljb24gLm1vYmlsZS1hcHBseS1pY29uIHsKICBmb250LXNpemU6IDI0cHg7Cn0KCi5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLm1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSB7CiAgaGVpZ2h0OiAzMHB4OwogIGZvbnQtc2l6ZTogMTNweDsKICBjb2xvcjogIzMzMzsKICBwYWRkaW5nLXRvcDogOHB4OwogIHRleHQtYWxpZ246IGNlbnRlcjsKICBvdmVyZmxvdzogaGlkZGVuOwogIHRleHQtb3ZlcmZsb3c6IGVsbGlwc2lzOwogIGRpc3BsYXk6IC13ZWJraXQtYm94OwogIC13ZWJraXQtbGluZS1jbGFtcDogMjsKICAtd2Via2l0LWJveC1vcmllbnQ6IHZlcnRpY2FsOwp9');

INSERT INTO BPM_DOCUMENTATION_config(ID_, DATA_KEY_, AUTORUN_, AUTORUN_CONFIG_, DELETE_DATA_, LIMIT_,
                                          LIMIT_NUMBER_, UPDATE_BY_, UPDATE_TIME_, BEFORE_MONTH_, JOB_NAME_,
                                         TENANT_ID_)
VALUES ('1', NULL, '1', '{\"type\":4,\"timeInterval\":\"MON,TUE,WED,SUN|11:49:20\"}', '2', '1', '500', '1',
        '2023-03-23 15:46:12', '0', '流程归档数据同步', '-1');
		

alter table FORM_DATA_TEMPLATE  add MOBILE_TEMPLATE_ALIAS_ VARCHAR(128);
comment on column FORM_DATA_TEMPLATE.MOBILE_TEMPLATE_ALIAS_ is '移动端数据模板别名';

alter table FORM_DATA_TEMPLATE add MOBILE_TEMPLATE_HTML_ CLOB;
comment on column FORM_DATA_TEMPLATE.MOBILE_TEMPLATE_HTML_ is '移动端数据模板代码'; 
 
ALTER TABLE PORTAL_SYS_APP  ADD ALIAS_ VARCHAR(64);
comment on column PORTAL_SYS_APP.ALIAS_ is '应用别名';

ALTER TABLE PORTAL_SYS_APP_MENU  ADD MENU_TYPE_ VARCHAR(64);
comment on column PORTAL_SYS_APP_MENU.MENU_TYPE_ is '菜单类型';

ALTER TABLE PORTAL_SYS_APP_MENU  ADD ICON_ VARCHAR(64);
comment on column PORTAL_SYS_APP_MENU.ICON_ is '图标';

alter table PORTAL_SYS_APP_MENU modify SN_ INT;
alter table PORTAL_SYS_APP_MENU alter column SN_ set not null;

-- 2023-05-10 jjx 修改PC模块菜单别名	
UPDATE PORTAL_SYS_MENU  SET ALIAS_ = 'pcAppCenter' WHERE ID_ LIKE '1296282423985836032';	
	
-- 2023-05-17 jjx 同步脚本
INSERT INTO portal_sys_auth_user (ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('1656920738508091392', '1651467475169812480', NULL, NULL, 'everyone', 'indexColumn', '-1');
INSERT INTO portal_sys_auth_user (ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('1656921529427996672', '1651134508916514816', NULL, NULL, 'everyone', 'indexColumn', '-1');
INSERT INTO portal_sys_auth_user (ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('1656921540433850368', '1651056986864828416', NULL, NULL, 'everyone', 'indexColumn', '-1');

alter table BPM_DEFINITION  add DEPLOY_DESC_ VARCHAR(500);
comment on column BPM_DEFINITION.DEPLOY_DESC_ is '发布说明';

create table BPM_SHOW_RECORD(
    ID_            VARCHAR(32)	 not null   primary key unique,
    ACCOUNT_       VARCHAR(32)	 not null,
    FULL_NAME_     VARCHAR(32)	 not null,
    SHOW_TIME_     DATE       	 not null,
    TASK_ID_       VARCHAR(32),
    ACTION_        VARCHAR(32),
    SHOW_TYPE_     VARCHAR(20),
    REASONS_       CLOB       	 not null,
    CREATE_BY_     VARCHAR(32),
    CREATE_TIME_   DATE,
    CREATE_ORG_ID_ VARCHAR(32),
    UPDATE_BY_     VARCHAR(32),
    UPDATE_TIME_   DATE,
    TENANT_ID_     VARCHAR(32)
);
comment on table BPM_SHOW_RECORD is '流程实例和流程任务查阅记录';
comment on column BPM_SHOW_RECORD.ID_ is '主键ID';
comment on column BPM_SHOW_RECORD.ACCOUNT_ is '查阅人账号';
comment on column BPM_SHOW_RECORD.FULL_NAME_ is '查阅人名称';
comment on column BPM_SHOW_RECORD.SHOW_TIME_ is '查阅时间';
comment on column BPM_SHOW_RECORD.TASK_ID_ is '流程实例ID或任务ID';
comment on column BPM_SHOW_RECORD.ACTION_ is '流程定义中的动作：发布新版本/保存';
comment on column BPM_SHOW_RECORD.SHOW_TYPE_ is '展示类型：实例/任务/流程定义';
comment on column BPM_SHOW_RECORD.REASONS_ is '查阅原因';
comment on column BPM_SHOW_RECORD.CREATE_BY_ is '创建人';
comment on column BPM_SHOW_RECORD.CREATE_TIME_ is '创建时间';
comment on column BPM_SHOW_RECORD.UPDATE_BY_ is '更新人';
comment on column BPM_SHOW_RECORD.UPDATE_TIME_ is '更新时间';
comment on column BPM_SHOW_RECORD.TENANT_ID_ is '租户ID';
create index SHOW_RECORD_TASK_ID__SHOW_TYPE__INDEX   on BPM_SHOW_RECORD (TASK_ID_, SHOW_TYPE_);

-- 2023-05-18 jjx 同步脚本
alter table FORM_DATA_TEMPLATE  add INNER_BTN_CONFIG_ CLOB;
comment on column FORM_DATA_TEMPLATE.INNER_BTN_CONFIG_ is '页内按钮的配置';


create table BPM_PRO_PUBLICITY_READ
(
    ID_  VARCHAR(64) 	not null   primary key  unique,
    PROC_INST_ID_ 	VARCHAR(64),
    USER_ID_      	VARCHAR(64),
    TENANT_ID_    	VARCHAR(64)
);
comment on table BPM_PRO_PUBLICITY_READ is '流程公示阅读记录';
comment on column BPM_PRO_PUBLICITY_READ.PROC_INST_ID_ is '实例ID';
comment on column BPM_PRO_PUBLICITY_READ.USER_ID_ is '用户ID';
create index IDX_USER_ID_USER_ID   on BPM_PRO_PUBLICITY_READ (USER_ID_);
create index BPM_PRO_PUBLICITY_READ_PROC_INST_ID_   on BPM_PRO_PUBLICITY_READ (PROC_INST_ID_);

-- 2023-05-19 JJX 添加流程归档菜单

INSERT INTO PORTAL_SYS_MENU (ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_, TYPE_, TOKEN_ENABLED_, TOKEN_TYPE_, TOKEN_KEY_, TOKEN_API_, IS_REFRESH_) VALUES ('1643794670103810048', '4291768', '流程归档', 'historyDataConfig', '', '', null, 7, '', '-1.1.3641025.4291768.1643794670103810048.', '', '-1', '{\"path\":\"historyDataConfig\",\"component\":\"MultilevelMenuLayout\",\"redirect\":\"\",\"alwaysShow\":true,\"caseSensitive\":false,\"meta\":{\"title\":\"流程归档\",\"icon\":\"\",\"isChildren\":true}}', 'catalog', 0, 0, null, null, 1);
-- 2023-05-22 删除移动端流程分类菜单
delete from portal_sys_menu where NAME_ = '移动端流程分类';


-- 2023-05-22 lizhenxing 流程归档定时任务初始数据
INSERT INTO qrtz_job_details(SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES ('quartzScheduler', '数据归档定时任务', '-1', '数据归档定时任务', 'com.hotent.job.job.DocumentationJob', '1', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787000737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F40000000000010770800000010000000007800);

-- 2023-05-23 lizhenxing 流程归档初始化表数据
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644250277726375936', 'bpm_pro_inst', '', 'CREATE TABLE bpm_pro_inst (
	ID_ VARCHAR(64) NOT NULL primary key unique,
	SUBJECT_ VARCHAR2(256) NOT NULL,
	PROC_DEF_ID_ VARCHAR(64) NOT NULL,
	BPMN_DEF_ID_ VARCHAR(64) DEFAULT NULL,
	PROC_DEF_KEY_ VARCHAR(128) DEFAULT NULL,
	PROC_DEF_NAME_ VARCHAR(128) NOT NULL,
	BIZ_KEY_ VARCHAR(64) DEFAULT NULL,
	SYS_CODE_ VARCHAR(64) DEFAULT NULL,
	FORM_KEY_ VARCHAR(64) DEFAULT NULL,
	STATUS_ VARCHAR(40) DEFAULT NULL,
	END_TIME_ DATETIME,
	DURATION_ INTEGER DEFAULT NULL,
	TYPE_ID_ VARCHAR(64) DEFAULT NULL,
	RESULT_TYPE_ VARCHAR(40) DEFAULT NULL,
	BPMN_INST_ID_ VARCHAR(64) DEFAULT NULL,
	CREATE_BY_ VARCHAR(64) DEFAULT NULL,
	CREATE_TIME_ DATETIME,
	CREATE_ORG_ID_ VARCHAR(64) DEFAULT NULL,
	UPDATE_BY_ VARCHAR(64) DEFAULT NULL,
	UPDATE_TIME_ DATETIME,
	IS_FORMMAL_ CHAR(1) NOT NULL,
	PARENT_INST_ID_ VARCHAR(64) DEFAULT NULL,
	IS_FORBIDDEN_ SMALLINT DEFAULT NULL,
	DATA_MODE_ VARCHAR(20) DEFAULT NULL,
	CREATOR_ VARCHAR(64) DEFAULT NULL,
	SUPPORT_MOBILE_ INTEGER DEFAULT 0,
	SUPER_NODE_ID_ VARCHAR(64) DEFAULT NULL,
	IS_DELE_ INTEGER DEFAULT 0 NOT NULL,
	URGENT_STATE_ VARCHAR(64) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL,
	CREATE_ORG_PATH_ CLOB,
	PC_INST_URL_ VARCHAR(200),
	MOBILE_INST_URL_ VARCHAR(200),
	CREATE_ACCOUNT_ VARCHAR(64)
);', '1', '1', NULL, '1', '1', NULL, NULL, 'UPDATE_TIME_', '0', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644251197944090624', 'bpm_bus_link', NULL, 'CREATE TABLE bpm_bus_link(
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY  unique,
	DEF_ID_ VARCHAR(64) DEFAULT NULL,
	PROC_INST_ID_ VARCHAR(64) DEFAULT NULL,
	BUSINESSKEY_ INTEGER DEFAULT NULL,
	BUSINESSKEY_STR_ VARCHAR(64) DEFAULT NULL,
	SYS_CODE_ VARCHAR(64) DEFAULT NULL,
	FORM_IDENTIFY_ VARCHAR(64) NOT NULL,
	START_ID_ VARCHAR(64) DEFAULT NULL,
	STARTOR_ VARCHAR(128) DEFAULT NULL,
	CREATE_DATE_ DATETIME,
	START_GROUP_ID_ VARCHAR(64) DEFAULT NULL,
	START_GROUP_ VARCHAR(128) DEFAULT NULL,
	IS_MAIN_ SMALLINT DEFAULT NULL,
	BO_DEF_CODE_ VARCHAR(64) DEFAULT NULL,
	SAVE_MODE_ VARCHAR(50) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL
);', '1', '0', NULL, '1', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644251940189097984', 'bpm_pro_status', NULL, 'CREATE TABLE bpm_pro_status(
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	PROC_INST_ID_ VARCHAR(64) NOT NULL,
	PROC_DEF_ID_ VARCHAR(64) NOT NULL,
	NODE_ID_ VARCHAR(255) NOT NULL,
	NODE_NAME_ VARCHAR(255) DEFAULT NULL,
	STATUS_ VARCHAR(50) NOT NULL,
	LAST_UPDATE_ DATETIME,
	LAST_USERID_ VARCHAR(64) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL,
	RECYCLE_NODE_ VARCHAR2(2) DEFAULT ''''''''''''''''0''''''''''''''''
);', '1', '0', NULL, '2', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644252316812431360', 'bpm_check_opinion', NULL, 'CREATE TABLE bpm_check_opinion(
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	PROC_DEF_ID_ VARCHAR(64) NOT NULL,
	SUP_INST_ID_ VARCHAR(64) DEFAULT NULL,
	PROC_INST_ID_ VARCHAR(64) NOT NULL,
	TASK_ID_ VARCHAR(64) DEFAULT NULL,
	TASK_KEY_ VARCHAR(64) DEFAULT NULL,
	TASK_NAME_ VARCHAR(255) DEFAULT NULL,
	TOKEN_ VARCHAR(64) DEFAULT NULL,
	QUALFIEDS_ CLOB DEFAULT NULL,
	QUALFIED_NAMES_ CLOB DEFAULT NULL,
	AUDITOR_ VARCHAR(64) DEFAULT NULL,
	AUDITOR_NAME_ VARCHAR(64) DEFAULT NULL,
	ORG_ID_ VARCHAR(64) DEFAULT NULL,
	ORG_PATH_ VARCHAR(600) DEFAULT NULL,
	OPINION_ VARCHAR(4000) DEFAULT NULL,
	STATUS_ VARCHAR(40) NOT NULL,
	FORM_DEF_ID_ VARCHAR(64) DEFAULT NULL,
	FORM_NAME_ VARCHAR(64) DEFAULT NULL,
	CREATE_TIME_ DATETIME,
	ASSIGN_TIME_ DATETIME,
	COMPLETE_TIME_ DATETIME,
	DUR_MS_ INTEGER DEFAULT NULL,
	FILES_ VARCHAR(4000) DEFAULT NULL,
	INTERPOSE_ SMALLINT DEFAULT NULL,
	IS_DELE_ INTEGER DEFAULT 0 NOT NULL,
	IS_READ_ INTEGER DEFAULT 0 NOT NULL,
	AGENT_LEADER_ID_ VARCHAR(64) DEFAULT NULL,
	PROP1_ VARCHAR(200) DEFAULT NULL,
	PROP2_ VARCHAR(200) DEFAULT NULL,
	PROP3_ VARCHAR(200) DEFAULT NULL,
	PROP4_ VARCHAR(200) DEFAULT NULL,
	PROP5_ VARCHAR(200) DEFAULT NULL,
	PROP6_ CLOB,
	Z_FILES_ VARCHAR(1000) DEFAULT NULL,
	FORM_DATA_ CLOB,
	PARENT_TASK_ID_ VARCHAR(64) DEFAULT NULL,
	SIGN_TYPE_ VARCHAR(64) DEFAULT NULL,
	SKIP_TYPE_ VARCHAR(64) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL,
	VARS_ CLOB,
	QUALFIEDS_ACCOUNT_ CLOB,
	AUDITOR_ACCOUNT_ VARCHAR(255)
);', '1', '0', NULL, '3', '1', 'id_', 'proc_inst_id_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644253067093725184', 'bpm_exe_stack', NULL, 'CREATE TABLE BPM_EXE_STACK (
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	PRCO_DEF_ID_ VARCHAR(64) DEFAULT NULL,
	NODE_ID_ VARCHAR(64) NOT NULL,
	NODE_NAME_ VARCHAR(128) DEFAULT NULL,
	START_TIME_ DATETIME,
	END_TIME DATETIME,
	IS_MULITI_TASK_ SMALLINT NOT NULL,
	PARENT_ID_ VARCHAR(64) DEFAULT NULL,
	PROC_INST_ID_ VARCHAR(64) DEFAULT NULL,
	NODE_PATH_ VARCHAR(1024) DEFAULT NULL,
	DEPTH_ SMALLINT DEFAULT NULL,
	TASK_TOKEN_ VARCHAR(255) DEFAULT NULL,
	NODE_TYPE_ VARCHAR(255) DEFAULT NULL,
	TARGET_NODE_ VARCHAR2(200) DEFAULT NULL,
	TARGET_TOKEN_ VARCHAR(255) DEFAULT NULL,
	INTERPOSE_ SMALLINT DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL
);', '1', '0', NULL, '4', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644254426346016768', 'bpm_flow_mq_log', NULL, 'CREATE TABLE bpm_flow_mq_log(
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	TYPE_ VARCHAR(40) NOT NULL,
	TITLE_ VARCHAR(300),
	CONTENT_ CLOB,
	STATUS_ INT NOT NULL,
	TRY_TIME_ INT,
	EXCEPTION_ VARCHAR(2000),
	LOG_TIME_ DATE,
	TARGET_ VARCHAR(64),
	PROC_INST_ID_ VARCHAR(64),
	TASK_ID_ VARCHAR(64),
	OWNER_ID_ VARCHAR(64),
	OWNER_NAME_ VARCHAR(64),
	TENANT_ID_ VARCHAR(64),
	YEARS_PARTITION_ INT
);', '1', '0', NULL, '5', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DML_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_)
VALUES('1644254843394052096', 'bpm_read_record', NULL, 'CREATE TABLE bpm_read_record(
	ID_ VARCHAR(255) NOT NULL PRIMARY KEY unique ,
	PROC_DEF_ID_ VARCHAR(255) DEFAULT NULL,
	SUP_INST_ID_ VARCHAR(255) DEFAULT NULL,
	PROC_INST_ID_ VARCHAR(255) DEFAULT NULL,
	TASK_ID_ VARCHAR(255) DEFAULT NULL,
	TASK_KEY_ VARCHAR(255) DEFAULT NULL,
	TASK_NAME_ VARCHAR(255) DEFAULT NULL,
	READER_ VARCHAR(255) DEFAULT NULL,
	READER_NAME_ VARCHAR(255) DEFAULT NULL,
	READ_TIME_ DATETIME,
	ORG_ID_ VARCHAR(255) DEFAULT NULL,
	ORG_PATH_ VARCHAR(255) DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL
);', '1', '0', NULL, '6', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-05-23', '-1');
INSERT INTO BPM_DOCUMENTATION_TABLE
(ID_, TABLE_NAME_, DDL_, SYSTEM_, START_, INFO_, ORDER_, UPDATE_BY_, PARENT_FIELD_, FIELD_, TIME_KEY_, PARENT_ID_, UPDATE_TIME_, TENANT_ID_, DML_)
VALUES('1644272017298935808', 'bpm_exe_stack_executor', 'CREATE TABLE BPM_EXE_STACK_EXECUTOR (
	ID_ VARCHAR(64) NOT NULL PRIMARY KEY unique,
	STACK_ID_ VARCHAR(64) DEFAULT NULL,
	TASK_ID_ VARCHAR(64) DEFAULT NULL,
	ASSIGNEE_ID_ VARCHAR(64) DEFAULT NULL,
	CREATE_TIME_ DATETIME,
	END_TIME_ DATETIME,
	STATUS_ SMALLINT DEFAULT NULL,
	TENANT_ID_ VARCHAR(64) DEFAULT NULL,
	TARGET_NODE_ VARCHAR2(64)
);', NULL, '1', NULL, '7', '1', 'id_', 'STACK_ID_', '', '1644253067093725184', '2023-06-06', '-1', NULL);


-- 2023-5-25 jjx 修改date类型为datetime
ALTER TABLE ACT_HI_ACTINST MODIFY START_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_ACTINST MODIFY END_TIME_ DATETIME(6);

ALTER TABLE ACT_HI_ATTACHMENT MODIFY TIME_ DATETIME(6);

ALTER TABLE ACT_HI_COMMENT MODIFY TIME_ DATETIME(6);

ALTER TABLE ACT_HI_DETAIL MODIFY TIME_ DATETIME(6);

ALTER TABLE ACT_HI_PROCINST MODIFY START_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_PROCINST MODIFY END_TIME_ DATETIME(6);

ALTER TABLE ACT_HI_TASKINST MODIFY START_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_TASKINST MODIFY CLAIM_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_TASKINST MODIFY END_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_TASKINST MODIFY DUE_DATE_ DATETIME(6);

ALTER TABLE ACT_HI_VARINST MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE ACT_HI_VARINST MODIFY LAST_UPDATED_TIME_ DATETIME(6);

ALTER TABLE ACT_RU_TASK MODIFY DUE_DATE_ DATETIME(6);

ALTER TABLE BPM_AGENT_SETTING MODIFY START_DATE_ DATETIME(6);
ALTER TABLE BPM_AGENT_SETTING MODIFY END_DATE_ DATETIME(6);
ALTER TABLE BPM_AGENT_SETTING MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_AGENT_SETTING MODIFY UPDATE_TIME_ DATETIME(6);


ALTER TABLE BPM_APPROVAL_ITEM MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_APPROVAL_ITEM MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_APPROVAL_ORG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_APPROVAL_ORG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_BUS_LINK MODIFY CREATE_DATE_ DATETIME(6);

ALTER TABLE BPM_CALL_LOG MODIFY CALL_TIME_ DATETIME(6);

ALTER TABLE BPM_CHECK_OPINION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_OPINION MODIFY ASSIGN_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_OPINION MODIFY COMPLETE_TIME_ DATETIME(6);

ALTER TABLE BPM_CHECK_OPINION_HI MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_OPINION_HI MODIFY ASSIGN_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_OPINION_HI MODIFY COMPLETE_TIME_ DATETIME(6);

ALTER TABLE BPM_COMMU_RECEIVER MODIFY RECEIVE_TIME_ DATETIME(6);
ALTER TABLE BPM_COMMU_RECEIVER MODIFY FEEDBACK_TIME_ DATETIME(6);

ALTER TABLE BPM_CPTO_RECEIVER MODIFY READ_TIME_ DATETIME(6);
ALTER TABLE BPM_CPTO_RECEIVER MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_DEF_AUTHORIZE MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_DEFINITION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_DEFINITION MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_EXE_STACK MODIFY START_TIME_ DATETIME(6);
ALTER TABLE BPM_EXE_STACK MODIFY END_TIME DATETIME(6);

ALTER TABLE BPM_EXE_STACK_EXECUTOR MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_EXE_STACK_EXECUTOR MODIFY END_TIME_ DATETIME(6);

ALTER TABLE BPM_EXE_STACK_HIS MODIFY START_TIME_ DATETIME(6);
ALTER TABLE BPM_EXE_STACK_HIS MODIFY END_TIME DATETIME(6);

ALTER TABLE BPM_EXE_STACK_RELATION MODIFY CREATED_TIME_ DATETIME(6);

ALTER TABLE BPM_EXE_STACK_RELATION_HIS MODIFY CREATED_TIME_ DATETIME(6);

ALTER TABLE BPM_EXTEND_JAR MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_EXTEND_JAR MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_FLOW_COLLECT MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_FLOW_MQ_LOG MODIFY LOG_TIME_ DATETIME(6);

ALTER TABLE BPM_FORM_MODIFY_RECORD MODIFY MODIFY_TIME_ DATETIME(6);

ALTER TABLE BPM_INST_DELETE_LOG MODIFY DELETE_TIME_ DATETIME(6);

ALTER TABLE BPM_INTERPOSE_RECORED MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_INTERPOSE_RECORED MODIFY COMPLETE_TIME_ DATETIME(6);

ALTER TABLE BPM_MEETINGROOM_APPOINTMENT MODIFY APPOINTMENT_BEG_TIME_ DATETIME(6);
ALTER TABLE BPM_MEETINGROOM_APPOINTMENT MODIFY APPOINTMENT_END_TIME_ DATETIME(6);

ALTER TABLE BPM_MESSAGE_TYPE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_MESSAGE_TYPE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_MOBILE_CATEGORY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_MOBILE_CATEGORY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_NODE_SETTING MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_NODE_SETTING MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRINT_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_PRINT_RECORD MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_CPTO MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_INST MODIFY END_TIME_ DATETIME(6);
ALTER TABLE BPM_PRO_INST MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_PRO_INST MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_INST_HI MODIFY END_TIME_ DATETIME(6);
ALTER TABLE BPM_PRO_INST_HI MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_PRO_INST_HI MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_STATUS MODIFY LAST_UPDATE_ DATETIME(6);

ALTER TABLE BPM_PRO_STATUS_HI MODIFY LAST_UPDATE_ DATETIME(6);

ALTER TABLE BPM_READ_RECORD MODIFY READ_TIME_ DATETIME(6);

ALTER TABLE BPM_REMINDER_HISTORY MODIFY EXECUTE_DATE_ DATETIME(6);

ALTER TABLE BPM_SAVE_OPINION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_SAVE_OPINION MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_SCRIPT MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_SCRIPT MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK MODIFY DUE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_COMMU MODIFY CREATETIME_ DATETIME(6);

ALTER TABLE BPM_TASK_DUE_TIME MODIFY START_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_DUE_TIME MODIFY EXPIRATION_DATE_ DATETIME(6);
ALTER TABLE BPM_TASK_DUE_TIME MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_NOTICE MODIFY DUE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_NOTICE MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_NOTICE_DONE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_NOTICE_DONE MODIFY ASSIGN_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_NOTICE_DONE MODIFY COMPLETE_TIME_ DATETIME(6);


ALTER TABLE BPM_TASK_REMINDER MODIFY REL_DATE_ DATETIME(6);
ALTER TABLE BPM_TASK_REMINDER MODIFY DUE_DATE_ DATETIME(6);
ALTER TABLE BPM_TASK_REMINDER MODIFY MSG_SEND_DATE_ DATETIME(6);
ALTER TABLE BPM_TASK_REMINDER MODIFY TRIGGER_DATE_ DATETIME(6);

ALTER TABLE BPM_TASK_SIGNDATA MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_SIGNDATA MODIFY VOTE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_TRANS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_TRANS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_TRANS_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_TRANS_RECORD MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_TRANS_RECORD MODIFY TRANS_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_TURN MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TASK_TURN MODIFY FINISH_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_URGENT MODIFY URGRNT_DATE_ DATETIME(6);

ALTER TABLE BPM_TEST_CASE_LOGS MODIFY EXECUTION_TIME_ DATETIME(6);

ALTER TABLE BPM_TRANS_RECEIVER MODIFY RECEIVER_TIME_ DATETIME(6);
ALTER TABLE BPM_TRANS_RECEIVER MODIFY CHECK_TIME_ DATETIME(6);

ALTER TABLE BPM_TRANS_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_TRANS_RECORD MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_WATERMARK MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_WATERMARK MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_BO_DEF MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_BO_DEF MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_BO_INT MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CODEGEN_LOG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CODEGEN_LOG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CUSTOM_CHART MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CUSTOM_CHART MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CUSTOM_COMPONENT MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CUSTOM_COMPONENT MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CUSTOM_DIALOG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CUSTOM_DIALOG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_CUSTOM_QUERY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_CUSTOM_QUERY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_DATA_TEMPLATE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_DATA_TEMPLATE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_DATA_TEMPLATE_DRAFT MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_DATA_TEMPLATE_DRAFT MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_DATA_TEMPLATE_IMPORT_LOG MODIFY IMPORT_TIME_ DATETIME(6);

ALTER TABLE FORM_DEFINITION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_DEFINITION MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_DEFINITION_HI MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_DEFINITION_HI MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_FIELD_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_FIELD_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_HISTORY_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_HISTORY_RECORD MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_META MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_META MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_PRINT_TEMPLATE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_PRINT_TEMPLATE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE FORM_URL_FORM MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_URL_FORM MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_AGENDA_DAY MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_AGENDA_DAY MODIFY END_TIME_ DATETIME(6);
ALTER TABLE PORTAL_AGENDA_DAY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_AGENDA_DAY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_APP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_APP MODIFY UPDATE_TIME_ DATETIME(6);


ALTER TABLE PORTAL_APP_PARAM MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_BIZ_SYSTEM MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_BIZ_SYSTEM MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_BIZ_SYSTEM_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_BIZ_SYSTEM_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_CAL_ABSENCE MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CAL_ABSENCE MODIFY END_TIME_ DATETIME(6);


ALTER TABLE PORTAL_CAL_DATE_TYPE MODIFY YEAR_BEGIN_ DATETIME(6);
ALTER TABLE PORTAL_CAL_DATE_TYPE MODIFY YEAR_END_ DATETIME(6);
ALTER TABLE PORTAL_CAL_DATE_TYPE MODIFY SPECIFY_DATE_ DATETIME(6);

ALTER TABLE PORTAL_CAL_OVERTIME MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CAL_OVERTIME MODIFY END_TIME_ DATETIME(6);

ALTER TABLE PORTAL_CONNECTION_MANAGER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CONNECTION_MANAGER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_DB_INTERFACE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_DB_INTERFACE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_FLOW_UPLOAD_PROPERTIES MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_FLOW_UPLOAD_PROPERTIES MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_I18N_MESSAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_I18N_MESSAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_INTERFACE_MANAGER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_INTERFACE_MANAGER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MEETING_APPLY MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_MEETING_APPLY MODIFY END_TIME_ DATETIME(6);
ALTER TABLE PORTAL_MEETING_APPLY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_MEETING_APPLY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MEETING_CONFIG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_MEETING_CONFIG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MEETING_ROOM MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_BIZ_SYSTEM_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MESSAGE_LOG MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_MSG_SEND_LOG MODIFY SEND_TIME DATETIME(6);

ALTER TABLE PORTAL_MY_SCHEDULE MODIFY DATE_ DATETIME(6);

ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY END_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY PUBLISH_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_NEWS_TAG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_TAG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_NEWS_TREE_ MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_NEWS_TREE_ MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_RESTFUL_INTERFACE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_RESTFUL_INTERFACE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_RESTFUL_MANAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_RESTFUL_MANAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SERVICE_CHOREOGRAPHY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SERVICE_CHOREOGRAPHY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SERVICE_LOG MODIFY CALL_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SHORTURL_MANAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SHORTURL_MANAGE MODIFY LOSE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SHORTURL_MANAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_APP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_APP MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_APP_MENU MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_APP_MENU MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_COLUMN MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_COLUMN MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_DATASOURCE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_DATASOURCE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_EXTERNAL_UNITE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_EXTERNAL_UNITE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_FILE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_FILE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_FILE_CLASSIFY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_FILE_CLASSIFY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_IDENTITY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_IDENTITY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_JOBLOG MODIFY START_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_JOBLOG MODIFY END_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_LAYOUT_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_LAYOUT_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_LAYOUT_MANAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_LAYOUT_MANAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_LOGS MODIFY EXECUTION_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MAIL MODIFY SEND_DATE_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MAIL_LINKMAN MODIFY SENDTIME DATETIME(6);

ALTER TABLE PORTAL_SYS_MAIL_SETTING MODIFY LAST_RECEIVE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MODULE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_MODULE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MSG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_MSG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_MSG_READ MODIFY RECEIVER_TIME_ DATETIME(6);


ALTER TABLE PORTAL_SYS_MSG_TPL MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_MSG_TPL MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_POPUP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_POPUP MODIFY VALIDITY_START_ DATETIME(6);
ALTER TABLE PORTAL_SYS_POPUP MODIFY VALIDITY_END_ DATETIME(6);

ALTER TABLE PORTAL_SYS_PROPERTIES MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_PROPERTIES MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_SIGNET MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_SIGNET MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_TOOLS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_TOOLS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_TYPE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_TYPE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_SYS_TYPE_GROUP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_TYPE_GROUP MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_URL_PERMISSION MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_USER_LAYOUT_CONFIG MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_WEIXIN_MATERIAL MODIFY CREATE_TIME DATETIME(6);
ALTER TABLE PORTAL_WEIXIN_MATERIAL MODIFY UPDATE_TIME DATETIME(6);
ALTER TABLE PORTAL_WEIXIN_MATERIAL MODIFY PULL_TIME DATETIME(6);

ALTER TABLE UC_BATCH_SYNC MODIFY EXECUTE_TIME_ DATETIME(6);
ALTER TABLE UC_BATCH_SYNC MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_BATCH_SYNC MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_DEMENSION MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_DEMENSION MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ELECTRONIC_SEAL MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ELECTRONIC_SEAL MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_GROUP MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE UC_HOLIDAY MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_HOLIDAY MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_HOLIDAY_TIME MODIFY START_TIME_ DATETIME(6);
ALTER TABLE UC_HOLIDAY_TIME MODIFY END_TIME_ DATETIME(6);

ALTER TABLE UC_LOGIN_LOG MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_LOGIN_LOG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_MATRIX MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_MATRIX MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_MATRIX_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_MATRIX_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_MATRIX_COL_DEF MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_MATRIX_COL_DEF MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ONE_TIME_CODE MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE UC_OPERATE_LOG MODIFY START_TIME_ DATETIME(6);
ALTER TABLE UC_OPERATE_LOG MODIFY END_TIME_ DATETIME(6);

ALTER TABLE UC_ORG MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_JOB MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_JOB MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_PARAMS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_PARAMS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_POST MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_POST MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_ROLE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_ROLE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_UNITE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_UNITE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORG_USER MODIFY START_DATE_ DATETIME(6);
ALTER TABLE UC_ORG_USER MODIFY END_DATE_ DATETIME(6);
ALTER TABLE UC_ORG_USER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORG_USER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ORGAN MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ORGAN MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_PARAMS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_PARAMS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_PROPERTIES MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_PROPERTIES MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_REL_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_REL_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_REL_TYPE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_ROLE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_ROLE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_SHIFT_RULE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_SHIFT_RULE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_SHIFT_USER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_SHIFT_USER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_AUTH MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_AUTH MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_IGNORE_MENU MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_IGNORE_MENU MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_LOGS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_LOGS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_MAIL_SERVER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_MAIL_SERVER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_MANAGE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_MANAGE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_PARAMS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_PARAMS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_TENANT_TYPE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_TENANT_TYPE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER MODIFY BIRTHDAY_ DATETIME(6);
ALTER TABLE UC_USER MODIFY ENTRY_DATE_ DATETIME(6);
ALTER TABLE UC_USER MODIFY LEAVE_DATE_ DATETIME(6);
ALTER TABLE UC_USER MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER MODIFY PWD_CREATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_GROUP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_GROUP MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_PARAMS MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_PARAMS MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_REL MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_REL MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_ROLE MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_ROLE MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE UC_USER_UNDER MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE UC_USER_UNDER MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE BPM_PRO_BO MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_TASK_TURNASSIGN MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE BPM_DOCUMENTATION_CONFIG MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_RECORD MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE BPM_CHECK_RECORD MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_DOCUMENTATION_CONFIG MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_DOCUMENTATION_ERROR_LOG MODIFY TIME_ DATETIME(6);
ALTER TABLE BPM_DOCUMENTATION_TABLE MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE BPM_SERVICE_LOG MODIFY CREATE_TIME_ DATETIME(6);

ALTER TABLE FORM_SIMPLE_DESIGN MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE FORM_SIMPLE_DESIGN MODIFY UPDATE_TIME_ DATETIME(6);

ALTER TABLE PORTAL_CUSTOM_TODO MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY COMPLETE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY DEAD_LINE_ DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY REPEAT_START_TIME_ DATETIME(6);

ALTER TABLE PORTAL_RECENTLY_APP MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_RECENTLY_APP MODIFY UPDATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_DIC MODIFY CREATE_TIME_ DATETIME(6);
ALTER TABLE PORTAL_SYS_EXTERNAL_UNITE MODIFY SYNC_STARTING_TIME DATETIME(6);
ALTER TABLE PORTAL_CUSTOM_TODO MODIFY REPEAT_START_TIME_ DATETIME(6);



-- 2023-05-29 jjx 同步脚本
update portal_sys_menu set tabs_style_='' where alias_='demension';

create table FORM_AUTHORIZE
(
    ID_    				VARCHAR(64) not null    primary key unique,
    AUTHORIZE_DESC_  	VARCHAR(255),
    CREATE_BY_       	VARCHAR(64),
    CREATOR_         	VARCHAR(64),
    CREATE_TIME_     	DATETIME(6),
    MULTI_PLE        	VARCHAR(64),
    TENANT_ID_       	VARCHAR(64),
    AUTHORIZE_MODEL_ 	VARCHAR(64)
);
comment on table FORM_AUTHORIZE is '表单模块相关授权主表';
comment on column FORM_AUTHORIZE.AUTHORIZE_DESC_ is '授权说明';
comment on column FORM_AUTHORIZE.CREATE_BY_ is '创建人ID';
comment on column FORM_AUTHORIZE.CREATOR_ is '创建人';
comment on column FORM_AUTHORIZE.AUTHORIZE_MODEL_ is '授权对象';


create table FORM_AUTHORIZE_ACT
(
    ID_    			VARCHAR(64) not null    primary key unique,
    AUTHORIZE_ID_  	VARCHAR(64),
	MODEL_KEY_		VARCHAR(64),
	MODEL_NAME_		VARCHAR(128),
	RIGHT_CONTENT_	VARCHAR(128),
	TYPE_			VARCHAR(64),
	TENANT_ID_ 		VARCHAR(64)
);
comment on table FORM_AUTHORIZE_ACT is '表单相关授权定义';
comment on column FORM_AUTHORIZE_ACT.AUTHORIZE_ID_ is '授权主表ID';
comment on column FORM_AUTHORIZE_ACT.MODEL_KEY_ is '授权KEY';
comment on column FORM_AUTHORIZE_ACT.MODEL_NAME_ is '授权名称';
comment on column FORM_AUTHORIZE_ACT.RIGHT_CONTENT_ is '授权内容';
comment on column FORM_AUTHORIZE_ACT.TYPE_ is '1,对象。2，对象分类';
create index IDX_AUTHDEF_AUTHID_FORM_AUTHORIZE_ACT on FORM_AUTHORIZE_ACT (AUTHORIZE_ID_);

create table  FORM_AUTHORIZE_USER
(
    ID_            VARCHAR(64) not null   primary key  unique,
    AUTHORIZE_ID_  VARCHAR(64),
    OWNER_NAME_    VARCHAR(128),
	OWNER_ID_      VARCHAR(64),
    RIGHT_TYPE_    VARCHAR(20),
    OBJ_TYPE_      VARCHAR(64),
    AUTH_ORG_      VARCHAR(255),
    AUTH_ORG_NAME_ VARCHAR(255),
    TENANT_ID_     VARCHAR(64)
);
comment on table  FORM_AUTHORIZE_USER is '表单相关授权的用户';
comment on column  FORM_AUTHORIZE_USER.ID_ is '流程授权主表ID';
comment on column  FORM_AUTHORIZE_USER.AUTHORIZE_ID_ is '流程授权主表ID';
comment on column  FORM_AUTHORIZE_USER.OWNER_NAME_ is '授权对象名称';
comment on column  FORM_AUTHORIZE_USER.RIGHT_TYPE_ is '授权对象类型(角色,用户,岗位等)';
comment on column  FORM_AUTHORIZE_USER.OWNER_ID_ is '授权对象ID';
create index  IDX_DEFUSER_AUTHID_FORM_AUTHORIZE_USER on  FORM_AUTHORIZE_USER (AUTHORIZE_ID_);
create index  IDX_DEFUSER_OBJTYPE_FORM_AUTHORIZE_USER on  FORM_AUTHORIZE_USER (OBJ_TYPE_);
create index  IDX_DEFUSER_RIGHTTYPE_FORM_AUTHORIZE_USER on  FORM_AUTHORIZE_USER (RIGHT_TYPE_);

INSERT INTO portal_sys_menu(ID_,PARENT_ID_,NAME_,ALIAS_,ACTIVE_TAB_,MENU_ICON_,OPENED_,SN_,TABS_STYLE_,PATH_,HREF_,TENANT_ID_,ROUTE_EXTEND_,TYPE_,IS_REFRESH_,token_Enabled_,TOKEN_TYPE_,TOKEN_KEY_,TOKEN_API_) VALUES ('1660521382890016768', '3391046', '资源授权', 'formAuthorizeManager', '', '', NULL, 6, '', '-1.1.3441002.3391046.1660521382890016768.', '', '-1', '{\"path\":\"formAuthorizeManager\",\"component\":\"\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"资源授权\",\"isChildren\":true,\"icon\":\"\"}}', 'catalog', 1, 0, 0, NULL, NULL);
-- 2023-06-02 jjx 同步脚本
UPDATE portal_sys_column SET NAME = '数据台', ALIAS = 'sjt', CATALOG = NULL, COL_TYPE = 'HtCustom', DATA_MODE = NULL, DATA_FROM = NULL, DS_ALIAS = NULL, DS_NAME = NULL, COL_HEIGHT = NULL, COL_URL = '', TEMPLATE_HTML = 'PGRpdiBjbGFzcz0ibW9iaWxlLWFwcGx5LWNhcmQiIDpjbGFzcz0ieyAnYm9yZGVyLWJvdHRvbSc6IGlzU2hvd0JvdHRvbU1hcmdpbiB9Ij4KICA8ZGl2CiAgICA6Ym9yZGVyPSJmYWxzZSIKICAgIGNsYXNzPSJtb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCIKICAgIHYtaWY9ImFwcGx5TGlzdCAmJiBhcHBseUxpc3QubGVuZ3RoIgogID4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1hcHBseS1jYXJkLS1pdGVtIgogICAgICB2LWZvcj0iKGl0ZW0sIGluZGV4KSBpbiBhcHBseUxpc3QiCiAgICAgIDprZXk9ImAke2l0ZW0ubmFtZX1fJHtpbmRleH1gIgogICAgICBAY2xpY2s9ImhhbmRsZUNsaWNrKGl0ZW0pIgogICAgPgogICAgICA8ZGl2CiAgICAgICAgY2xhc3M9Iml0ZW0tdG9wLS1pY29uIgogICAgICAgIDpzdHlsZT0ieyBiYWNrZ3JvdW5kOiBpdGVtLmljb25Db2xvciB8fCAnIzQwOUVGRicgfSIKICAgICAgPgogICAgICAgIDxpIGNsYXNzPSJtb2JpbGUtYXBwbHktaWNvbiIgOmNsYXNzPSJpdGVtLmljb24gfHwgJ2ljb24tYXNpZGUtYXBwLWNlbnRlciciPjwvaT4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgY2xhc3M9Im1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSI+e3sgaXRlbS5uYW1lfX08L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pgo8L2Rpdj4=', IS_PUBLIC = 1, SUPPORT_REFESH = NULL, REFESH_TIME = 10, SHOW_EFFECT = NULL, MEMO = '', DATA_PARAM = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}', NEEDPAGE = 0, ORG_ID = NULL, CREATOR = NULL, CREATE_BY_ = '1', UPDATE_BY_ = '1', CREATE_TIME_ = '2023-04-26 10:53:55', UPDATE_TIME_ = '2023-06-01 17:16:52', REQUEST_TYPE = NULL, CATALOG_NAME = '', CREATE_ORG_ID_ = '', TENANT_ID_ = '-1', SHOW_TITLE_ = 1, CONTAIN_COL_ = NULL, APPID_ = '', SECRET_ = '', TEMPLATE_JAVA_SCRIPT_ = 'ewogICBkYXRhKCkgewogICAgICByZXR1cm4gewogICAgICAgIGlzU2hvd0JvdHRvbU1hcmdpbjpmYWxzZSwKICAgICAgICBhcHBseUxpc3Q6IFsKICAgICAgICAgIHsKICAgICAgICAgICAgbmFtZTogJ+aWsOW7uua1geeoiycsCiAgICAgICAgICAgIGljb246ICdpY29uLXhpbmppYW5saXVjaGVuZzExJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwOUVGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL25ld01hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5b6F5Yqe5bey5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24tZGFpYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwNTNGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215VGFzaycsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE55Sz6K+3JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXNoZW5xaW5nJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0Y2Qjg1QScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215UmVxdWVzdCcsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5Lyg6ZiF5LqL6aG5JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZWNodWFueXVlJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzg1NTBFMScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL2NpcmN1bGF0ZU1hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE6L2s5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXpodWFuYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0ZGOEE0NicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215RGVsZWdhdGUnLAogICAgICAgICAgfSwKICAgICAgICBdLAogICAgICB9CiAgIH0sCiAgICAgbWV0aG9kczogewogICAgICBoYW5kbGVDbGljayhpdGVtKSB7CiAgICAgICAgaWYgKGl0ZW0ucGF0aCkgewogICAgICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS5wYXRoKQogICAgICAgIH0KICAgICAgfSwKICAgIH0sCn0=', STYLE_ = '', is_init_ = 0, SNAPSHOT_ID_ = '1664199322310361088', TEMPLATE_STYLE_ = 'Lm1vYmlsZS1hcHBseS1jYXJkIHsKICBiYWNrZ3JvdW5kOiAjZmZmOwp9CgoubW9iaWxlLWFwcGx5LWNhcmQtLWNvbnRlbnR7CiAgIGRpc3BsYXk6IGZsZXg7CiAgIGZsZXgtd3JhcDogd3JhcDsKICAgcGFkZGluZy10b3A6IDE2cHg7Cn0KLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbXsKICAgIHdpZHRoOiAyNSU7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgdGV4dC1hbGlnbjogY2VudGVyOwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIGhlaWdodDogOTBweDsKICAgIG1hcmdpbi1ib3R0b206OHB4Owp9Ci5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLml0ZW0tdG9wLS1pY29uIHsKICB3aWR0aDogNDBweDsKICBoZWlnaHQ6IDQwcHg7CiAgZGlzcGxheTogZmxleDsKICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICBhbGlnbi1pdGVtczogY2VudGVyOwogIGJvcmRlci1yYWRpdXM6IDhweDsKICBjb2xvcjogI2ZmZjsKfQoKLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbSAuaXRlbS10b3AtLWljb24gLm1vYmlsZS1hcHBseS1pY29uIHsKICBmb250LXNpemU6IDI0cHg7Cn0KCi5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLm1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSB7CiAgaGVpZ2h0OiAzMHB4OwogIGZvbnQtc2l6ZTogMTNweDsKICBjb2xvcjogIzMzMzsKICBwYWRkaW5nLXRvcDogOHB4OwogIHRleHQtYWxpZ246IGNlbnRlcjsKICBvdmVyZmxvdzogaGlkZGVuOwogIHRleHQtb3ZlcmZsb3c6IGVsbGlwc2lzOwogIGRpc3BsYXk6IC13ZWJraXQtYm94OwogIC13ZWJraXQtbGluZS1jbGFtcDogMjsKICAtd2Via2l0LWJveC1vcmllbnQ6IHZlcnRpY2FsOwp9' WHERE ID = '1651056986864828416';

UPDATE portal_sys_column SET NAME = '常用功能', ALIAS = 'cygnsjd', CATALOG = NULL, COL_TYPE = 'HtCustom', DATA_MODE = NULL, DATA_FROM = NULL, DS_ALIAS = NULL, DS_NAME = NULL, COL_HEIGHT = NULL, COL_URL = '', TEMPLATE_HTML = 'PGRpdiBzdHlsZT0icGFkZGluZzoxNnB4IDAiPgogIDxkaXYgY2xhc3M9ImNvbW1vbi1mdW5jdGlvbiIgc3R5bGU9ImRpc3BsYXk6IGZsZXg7IGZsZXgtd3JhcDogd3JhcCI+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0gaG92ZXItZm9sbG93LXRoZW1lLWNvbG9yIgogICAgICBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQub3JnOjg4ODgvY2hhbnpoaS9pbmRleC5waHAvYm9vay91c2UxLzg3OC5odG1sJywnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTIzOTc1NDcxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjM1NiIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNODE4LjAxODk4OCAwLjAwMDUzOUgxMDIuMzA1MzczYTc1LjE4NTA5NyA3NS4xODUwOTcgMCAwIDAtNzUuNDU0NTc4IDc0Ljk0MjU2NHY4MzIuNjk1MTU5YTc1LjIxMjA0NSA3NS4yMTIwNDUgMCAwIDAgNzUuNDU0NTc4IDc0Ljk2OTUxM2gzMjEuNDYzNDQ4bDQ2OS42MjM5MDEtNDY2LjkwMjE0N1Y3NC45NDMxMDNBNzUuMTU4MTQ5IDc1LjE1ODE0OSAwIDAgMCA4MTguMDE4OTg4IDAuMDAwNTM5ek00MTkuNTExMDI3IDY4Mi42NDg4ODFIMjI5Ljk1ODM0OWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTloMTg5LjU1MjY3OGE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAgODAuODQ0MTl6IG0yNzAuNzc0MTQxLTE2Ni43ODE1NjRIMjI5Ljk4NTI5N2E0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTkxaDQ2MC4zMjY4MTlhNDAuNDIyMDk1IDQwLjQyMjA5NSAwIDEgMSAwIDgwLjg0NDE5MXogbTQwLjYzNzY3OS0yMTMuNDU1NjExYTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjM3Njc5IDQwLjQyMjA5NkgyMjkuOTg1Mjk3YTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjEwNzMyLTQwLjQyMjA5NiA0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYxMDczMi00MC40MjIwOTVoNDYwLjMyNjgxOWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYzNzY3OSA0MC40MjIwOTV6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE2MzU3IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MDUuMTYwNDk5IDc2Mi43OTI0MjFMNjYzLjE0ODQ2OCA4MDMuODYxMjdsLTM4Ljc3ODI2MyAzNy43MjcyODktMjkuMDUwMDEzIDI4LjI5NTQ2Ni0xNS4yNzk1NTIgMTQuNDcxMTFhODcuNjg4OTk4IDg3LjY4ODk5OCAwIDAgMC0xOC44NjM2NDQgMjUuNDkyODY4IDE4Mi4wMDcyMiAxODIuMDA3MjIgMCAwIDAtNi41MjE0MzEgMTcuMzgxNTAxbC04Ljg2NTkxMyAyNi4yNzQzNjItOC4wODQ0MTkgMjcuMjcxNDRjLTEuODA1NTIgNi42MDIyNzYtMy4zMTQ2MTIgMTMuMjg1Mzk1LTQuNjM1MDY3IDE5Ljk5NTQ2M2EyMy41Nzk1NTUgMjMuNTc5NTU1IDAgMCAwIDIuMjA5NzQxIDE5LjA3OTIyOWMzLjIzMzc2OCAzLjY5MTg4NSA5LjI0MzE4NiA0Ljg3NzU5OSAxOS4xMDYxNzcgMy42OTE4ODVhMTg5LjkyOTk1MSAxODkuOTI5OTUxIDAgMCAwIDIwLjgwMzkwNS00Ljk4NTM5MiAyNTYuNDkxNjY3IDI1Ni40OTE2NjcgMCAwIDAgMjkuNjQyODctNy44MTQ5MzhjMTAuMTU5NDItMi42OTQ4MDYgMTkuODg3NjcxLTYuMzg2NjkxIDI5LjkzOTI5OC05LjQ4NTcxOWwyNC40MTQ5NDYtMTAuOTk0ODA5IDEzLjg3ODI1Mi04LjA4NDQxOSAxMi44NTQyMjctOS40ODU3MTkgMzkuODAyMjg5LTM5LjE1NTUzNiAzOC45MTMwMDQtMzcuMjY5MTcyIDQxLjk4NTA4My00MC40MjIwOTUgMTEzLjc3NDcyMy0xMDguNzA4NDg3LTk4LjM4NzM3OS05NC41MDY4NTl6IG0yOTEuODQ3NTI2LTEwNC4yMDgxNjFhMTAzLjUwNzUxMiAxMDMuNTA3NTEyIDAgMCAwLTQuNjA4MTE4LTIyLjc3MTExMyA5Mi4zNTEwMTMgOTIuMzUxMDEzIDAgMCAwLTIwLjgwMzkwNS0yOS42NDI4NyA4MC40NjY5MTcgODAuNDY2OTE3IDAgMCAwLTI0LjkyNjk1OS0xOS41OTEyNDIgNjMuNjI0Mzc4IDYzLjYyNDM3OCAwIDAgMC0yNy4zNTIyODQtNy4xOTUxMzMgMzcuNTM4NjUyIDM3LjUzODY1MiAwIDAgMC0zMC4wNDcwOTEgMTAuMzc1MDA0bC0xNC43Njc1MzkgMTIuMzE1MjY1YTE4Ny4wNDY1MDggMTg3LjA0NjUwOCAwIDAgMS0xNS41NzU5OCAxMy42NjI2NjlsOTkuMzg0NDU3IDk0LjUzMzgwNmE1NC40ODg5ODQgNTQuNDg4OTg0IDAgMCAwIDguMjQ2MTA4LTYuNzkwOTEybDguMjQ2MTA3LTguNzA0MjI1IDEwLjUzNjY5My0xMC4zNzUwMDRhMzIuOTg0NDMgMzIuOTg0NDMgMCAwIDAgMTEuNjk1NDU5LTI1LjgxNjI0NXoiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwN0EiCiAgICAgICAgICBwLWlkPSIxNjM1OCIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5bel5pe255m76K6wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL3VzZTEvODgwLmh0bWwnLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ0MTY4NTMiCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDExMzcgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE2NDkyIgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik04NjYuMDE4MTcgNTgxLjI0MjIwMmExMDkuMDgwNjg3IDEwOS4wODA2ODcgMCAwIDEgNS45NzMxMjggMzMuMTM2NjM2djEwMi4zOTY0NzNhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAxLTEwNC41Mjk3MzMgMTAyLjM5NjQ3M2gtMTA3LjUxNjI5NmExMDEuNzk5MTYgMTAxLjc5OTE2IDAgMCAxLTEwNC41Mjk3MzMtMTAyLjM5NjQ3M3YtMTAyLjM5NjQ3M2ExMjkuMDQ3OTk5IDEyOS4wNDc5OTkgMCAwIDEgNS45NzMxMjctMzMuMTM2NjM2Yy0xNTguMjU5NDM4IDQyLjE1MzIxNS0yNjguNzYyMjk4IDE0NC41NDk2ODgtMjY4Ljc2MjI5OCAyNjIuMDIxMTk3VjkyMS41NjgyNTdhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAwIDEwNC41Mjk3MzMgMTAyLjM5NjQ3M2g2MzYuMDgxMjAyYTEwMS43OTkxNiAxMDEuNzk5MTYgMCAwIDAgMTA0LjUyOTczMi0xMDIuMzk2NDczdi03OC4zMDQ4NThjLTIuODQ0MzQ2LTExNy40NDMwNjYtMTEzLjQ4OTQyNC0yMTkuODM5NTM5LTI3MS43NDg4NjItMjYyLjAyMTE5N3pNNzEwLjc3Mzc0IDYxNC4zNzg4MzhhNTMuMTg5Mjc5IDUzLjE4OTI3OSAwIDAgMC01My43NTgxNDggNTEuMTk4MjM3djUxLjE5ODIzNmE1My44MTUwMzUgNTMuODE1MDM1IDAgMCAwIDEwNy41MTYyOTYgMHYtNTEuMTk4MjM2YTUwLjA4ODk0MSA1MC4wODg5NDEgMCAwIDAtMTQuOTMyODE5LTM2LjE1MTY0NCA1Ni41MTcxNjQgNTYuNTE3MTY0IDAgMCAwLTM4LjgyNTMyOS0xNS4wNDY1OTN6IG0wLTUxLjE5ODIzNmEyNzQuMTk1IDI3NC4xOTUgMCAwIDAgMjY1Ljc3NTczNC0yODAuMDgyNzk4YzAtMTUzLjU5NDcxLTExNi40NzU5ODgtMjgzLjA5NzgwNC0yNjIuNzg5MTctMjgzLjA5NzgwNFM0NDcuOTg0NTY5IDEyNi40ODgwODggNDQ3Ljk4NDU2OSAyODMuMDk3ODA0czExOS40MDU2NjUgMjgwLjA4Mjc5NyAyNjIuNzg5MTcxIDI4MC4wODI3OTh6IgogICAgICAgICAgZmlsbD0iI0ZFOUM1NCIKICAgICAgICAgIHAtaWQ9IjE2NDkzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xNzMuMTkyMjU3IDkxMy40NjE4N2ExMDIuNjUyNDY0IDEwMi42NTI0NjQgMCAwIDEtMTQuOTMyODE5LTUxLjM0MDQ1NHYtNzguNTMyNDA2YzAtMTExLjc1NDM3MyAxMDQuNTI5NzMzLTIxMS40MjAyNzMgMjU5LjgwMjYwNy0yNTYuNzAyMjY5YTI5OS44Nzk0NDkgMjk5Ljg3OTQ0OSAwIDAgMS05OC41NTY2MDYtMjI5LjUzODc2MUEzNDUuOTI5NDE4IDM0NS45Mjk0MTggMCAwIDEgMzU4LjM4NzY1NiAxNDMuMzI2NjE5YTIyNC4wMjA3MjggMjI0LjAyMDcyOCAwIDAgMC0xOTcuMDg0NzY4IDIyOS41Mzg3NiAyMzUuNTY4Nzc1IDIzNS41Njg3NzUgMCAwIDAgOTIuNTgzNDc4IDE5MC4yNTgzMzZDMTA3LjUxNjI5NyA1OTMuMzMwNjc0IDAgNjgwLjkwODEwMiAwIDc4MC40NjAyMjlWODU4Ljk5MjYzNWE1My4yNDYxNjYgNTMuMjQ2MTY2IDAgMCAwIDUzLjc1ODE0OCA1MS40NTQyMjd6IgogICAgICAgICAgZmlsbD0iI0ZGQzI5NSIKICAgICAgICAgIHAtaWQ9IjE2NDk0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlrqLmiLc8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svdXNlMS84NzkuaHRtbCcsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDQ0OTUyNyIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTY2MjgiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTQ5OC40MTAyNjMgODIxLjg1Njg1NGEyNjkuNDUyMzQxIDI2OS40NTIzNDEgMCAwIDEgNDE4LjY3NTA0Ny0yMjQuMjkyMTI4VjI2MS40NDk4NzZhMTIyLjI1MDUyNyAxMjIuMjUwNTI3IDAgMCAwLTMwLjA3MDg4MS02NC45MzgwMTRMNzEzLjY3NTczOCAyNS42MjUxODdBMTAxLjY2NDM2OCAxMDEuNjY0MzY4IDAgMCAwIDY0Ni40NDczNzkgMC4wMDAyNjloLTUxNC42NTM5N0E3Ny41NDgzODQgNzcuNTQ4Mzg0IDAgMCAwIDUzLjk3NTU3MyA3Ni45MDE5Njh2ODMwLjk5MTAxOGE3My4wMjE1ODQgNzMuMDIxNTg0IDAgMCAwIDczLjAyMTU4NCA3My4wMjE1ODVoNDIzLjg0ODUzMmEyNjcuNzU0NzkxIDI2Ny43NTQ3OTEgMCAwIDEtNTIuNDM1NDI2LTE1OS4wNTc3MTd6TTI1Ni40MTUxMTYgMjYwLjg4NDAyNmg0NTguMDY4OTc5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAwIDEgMCA4MC44MzU3MDJoLTQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDAgMSAwLTgwLjgzNTcwMnogbTAgMTczLjIzMDkxaDQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDEgMSAwIDgwLjgzNTcwMmgtNDU4LjA2ODk3OWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAtODAuODM1NzAyeiBtMTg4LjYxNjYzOSAyNDcuNzA3NTM2aC0xODguNjE2NjM5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAxIDEgMC04MC44MzU3MDJoMTg4LjYxNjYzOWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAgODAuODM1NzAyeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkYiCiAgICAgICAgICBwLWlkPSIxNjYyOSIKICAgICAgICA+PC9wYXRoPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNzY3LjkxNjQ5NSA2MTkuODIxNDg5YTIwMi4wODkyNTYgMjAyLjA4OTI1NiAwIDEgMCAyMDIuMDg5MjU1IDIwMi4wODkyNTUgMjAyLjA4OTI1NiAyMDIuMDg5MjU2IDAgMCAwLTIwMi4wODkyNTUtMjAyLjA4OTI1NXogbTEzMC4wOTE1OSAxOTEuMzExMTYybC00My43ODYwMDYgMzcuNzIzMzI4YTI0LjI1MDcxMSAyNC4yNTA3MTEgMCAwIDAtNS43MTIzODkgMTYuMTY3MTRsOS41MTE2NjcgNTUuODg0NDE1YTIwLjM0MzY1MiAyMC4zNDM2NTIgMCAwIDEtMjguNTYxOTQ4IDE5LjgzMTY5M2wtNTEuMzg0NTYxLTI2Ljk0NTIzNGExNS4wMDg0OTUgMTUuMDA4NDk1IDAgMCAwLTE3LjEzNzE2OSAwbC01My4yOTc2NzMgMjYuOTQ1MjM0YTE5LjY3MDAyMSAxOS42NzAwMjEgMCAwIDEtMjguNTYxOTQ4LTE5LjgzMTY5M2w5LjUxMTY2Ny01NS44ODQ0MTVhMTcuNTQxMzQ3IDE3LjU0MTM0NyAwIDAgMC01LjcxMjM4OS0xNi4xNjcxNGwtNDMuNzg2MDA2LTM5LjYzNjQ0YTE3LjU0MTM0NyAxNy41NDEzNDcgMCAwIDEgMTEuNDI0NzgtMzAuNjYzNjc2bDU5LjAxMDA2Mi04Ljk5OTcwOGEyNi40ODcxNjUgMjYuNDg3MTY1IDAgMCAwIDE1LjI1MTAwMy05LjAyNjY1NGwyNi42NDg4MzYtNTAuNDQxNDc4YTIwLjIwODkyNiAyMC4yMDg5MjYgMCAwIDEgMzQuMjQ3MzkzIDBsMjYuNjQ4ODM2IDUwLjQ0MTQ3OGEyOS42Mzk3NTcgMjkuNjM5NzU3IDAgMCAwIDE1LjI1MTAwMyAxMC43NzgwOTRsNTkuMDEwMDYyIDguOTk5NzA4YTE4LjQ4NDQzMSAxOC40ODQ0MzEgMCAwIDEgMTEuNDI0NzggMzAuNTgyODQxeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE2NjMwIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlkIjlkIw8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NTM4MzAxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjc2NCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTEwLjg4NzM0MSAxNDAuMTM0OTIybDQwLjQyMDY1OS00OC41MDQ3OTFhNDY5LjA5NTIyMiA0NjkuMDk1MjIyIDAgMCAxIDMyLjMzNjUyOC0zNy43MjU5NDhsMjYuOTQ3MTA2LTI2Ljk0NzEwN2E5Ni43NDAxMTEgOTYuNzQwMTExIDAgMCAxIDI2Ljk0NzEwNi0xOC44NjI5NzQgODUuOTg4MjE1IDg1Ljk4ODIxNSAwIDAgMSAzNy43MjU5NDgtOC4wODQxMzJoNDg0LjcyNDU0NGExNTcuNTU5NzI5IDE1Ny41NTk3MjkgMCAwIDEgMzUuMDMxMjM4IDUuMzg5NDIyIDEyMS4zOTY3MTMgMTIxLjM5NjcxMyAwIDAgMSAzNy43MjU5NDggMjYuOTQ3MTA2IDE5Ni41MjUyNDQgMTk2LjUyNTI0NCAwIDAgMCAyNC4yNTIzOTUgMjkuNjQxODE2IDMwNC45ODczNDYgMzA0Ljk4NzM0NiAwIDAgMSAyNi45NDcxMDYgMzUuMDMxMjM4YzEwLjc3ODg0MiAxMy40NzM1NTMgMjEuNTU3Njg1IDI5LjY0MTgxNyAzMi4zMzY1MjggNDMuMTE1Mzd6IgogICAgICAgICAgZmlsbD0iIzdGQzdGMSIKICAgICAgICAgIHAtaWQ9IjE2NzY1IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xMDIxLjI5NTMxOSAzMzEuMzI0NjM5YTk0LjEyNjI0MSA5NC4xMjYyNDEgMCAwIDAtMjEuNTU3Njg1LTY0LjY3MzA1NCA4My4yNjY1NTggODMuMjY2NTU4IDAgMCAwLTcyLjc1NzE4Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWE5MS40MDQ1ODQgOTEuNDA0NTg0IDAgMCAwLTcyLjc1NzE4NiAyNi45NDcxMDYgODYuMDY5MDU3IDg2LjA2OTA1NyAwIDAgMC0yMS41NTc2ODUgNjQuNjczMDU0djE3Ny44NTA5YTg5Ljg2ODU5OSA4OS44Njg1OTkgMCAwIDAgOTQuMzE0ODcxIDgzLjUzNjAyOWg4MzIuMjg4MzE3YTgwLjQ5MTAwNiA4MC40OTEwMDYgMCAwIDAgNjcuMzY3NzY1LTI2Ljk0NzEwNiA5Ni41Nzg0MjggOTYuNTc4NDI4IDAgMCAwIDI0LjI1MjM5Ni02NC42NzMwNTV6IG0tNDQxLjc3MDg1NiAxMjMuOTU2Njg4aC0xMzQuNzM1NTMxYTQwLjQyMDY1OSA0MC40MjA2NTkgMCAwIDEgMC04MC44NDEzMThoMTM0LjczNTUzMWE0MS40NDQ2NDkgNDEuNDQ0NjQ5IDAgMCAxIDQwLjQyMDY1OSA0MC40MjA2NTkgMzkuNjY2MTQgMzkuNjY2MTQgMCAwIDEtNDAuNDIwNjU5IDQwLjQyMDY1OXoiCiAgICAgICAgICBmaWxsPSIjMkZBQUYyIgogICAgICAgICAgcC1pZD0iMTY3NjYiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTEwMjMuOTkwMDMgNzU2LjgxOTQ0NGE5MS44MDg3OSA5MS44MDg3OSAwIDAgMC0yNC4yNTIzOTYtNjQuNjczMDU1IDg1Ljg1MzQ4IDg1Ljg1MzQ4IDAgMCAwLTcwLjA2MjQ3Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWExMDAuODA5MTI0IDEwMC44MDkxMjQgMCAwIDAtNzUuNDUxODk3IDI2Ljk0NzEwNiAxMDMuNTAzODM0IDEwMy41MDM4MzQgMCAwIDAtMjQuMjUyMzk1IDY3LjM2Nzc2NXYxNjEuNjgyNjM2YTkwLjU5NjE3MSA5MC41OTYxNzEgMCAwIDAgMjkuNjQxODE2IDc1LjQ1MTg5NyA5NC4wNDU0IDk0LjA0NTQgMCAwIDAgNjQuNjczMDU1IDI2Ljk0NzEwNmg4MzIuMjg4MzE3YTkyLjIzOTk0NCA5Mi4yMzk5NDQgMCAwIDAgOTcuMDA5NTgyLTk0LjMxNDg3MXogbS00NDQuNDY1NTY3IDE1OC45ODc5MjVoLTEzNC43MzU1MzFhNDAuNDIwNjU5IDQwLjQyMDY1OSAwIDAgMSAwLTgwLjg0MTMxOGgxMzQuNzM1NTMxYTQxLjQ0NDY0OSA0MS40NDQ2NDkgMCAwIDEgNDAuNDIwNjU5IDQwLjQyMDY1OSAzOC4xODQwNDkgMzguMTg0MDQ5IDAgMCAxLTQwLjQyMDY1OSA0MC40MjA2NTl6IgogICAgICAgICAgZmlsbD0iIzJGQUFGMiIKICAgICAgICAgIHAtaWQ9IjE2NzY3IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rpobnnm648L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0Njc5NTI3IgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMTM3IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzQ0OCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTAzOC4yMjIyMjIgMEExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEgMTEzNy43Nzc3NzggOTkuNTU1NTU2djY2OC4xNmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2IDk5LjU1NTU1NUg1MTQuODQ0NDQ0bC0yMzAuNCAxNTAuNzU1NTU2YTMyLjE5OTExMSAzMi4xOTkxMTEgMCAwIDEtNDUuNTExMTExLTguNTMzMzM0IDQwLjM5MTExMSA0MC4zOTExMTEgMCAwIDEtNS42ODg4ODktMTcuMDY2NjY2di0xMjIuMzExMTExSDk5LjU1NTU1NmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2LTk5LjU1NTU1NlY5OS41NTU1NTZBMTAwLjc3ODY2NyAxMDAuNzc4NjY3IDAgMCAxIDk5LjU1NTU1NiAwaDkzOC42NjY2NjZ6IgogICAgICAgICAgZmlsbD0iIzg1NTBFMSIKICAgICAgICAgIHAtaWQ9IjE3NDQ5IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03NTMuNzc3Nzc4IDMzMi43MTQ2NjdoLTM2OS43Nzc3NzhhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMS00Mi42NjY2NjctNDIuNjY2NjY3IDQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY3LTQyLjY2NjY2N2gzNjkuNzc3Nzc4YTQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY2IDQyLjY2NjY2NyA0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2NiA0Mi42NjY2Njd6IgogICAgICAgICAgZmlsbD0iI0ZGRkZGRjdBIgogICAgICAgICAgcC1pZD0iMTc0NTAiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTU4My4xMTExMTEgNTMxLjc0MDQ0NGgtMTk5LjExMTExMWE0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2Ny00Mi42NjY2NjYgNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjctNDIuNjY2NjY3aDE5OS4xMTExMTFhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjcgNDIuNjY2NjY3IDQxLjg5ODY2NyA0MS44OTg2NjcgMCAwIDEtNDIuNjY2NjY3IDQyLjY2NjY2NnoiCiAgICAgICAgICBmaWxsPSIjRkZGRkZGN0EiCiAgICAgICAgICBwLWlkPSIxNzQ1MSIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5ZSu5YmN5pSv5oyBPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2RlcGxveS82Lmh0bWwsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDY2NDE0MiIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTczMTEiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTUxMi4wMjkyMzYgMTMxLjI0OTczYTI4Mi45MzM3NDMgMjgyLjkzMzc0MyAwIDEgMCAyODguMzIyOTU4IDI4Mi45MzM3NDMgMjgyLjkzMzc0MyAyODIuOTMzNzQzIDAgMCAwLTI4OC4zMjI5NTgtMjgyLjkzMzc0M3oiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwIgogICAgICAgICAgcC1pZD0iMTczMTIiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTE3Ny44OTc5NTkgNTIxLjk2Nzc1NnYtMjYxLjM3Njg4N2gtMTAuNzc4NDI4YTM4MS4zNjc3MzkgMzgxLjM2NzczOSAwIDAgMSA1MDYuNTg2MTMtMTgwLjUzODY3NCAzOTAuODUyNzU2IDM5MC44NTI3NTYgMCAwIDEgMTgwLjUzODY3NCAxODAuNTM4Njc0aC0xMC43Nzg0Mjh2MjYxLjM3Njg4N2ExMjkuOTYwODk5IDEyOS45NjA4OTkgMCAwIDAgMTMyLjAzNTc0Ni0xMjkuMzQxMTQgMTI4LjI2MzI5NyAxMjguMjYzMjk3IDAgMCAwLTY3LjM2NTE3Ni0xMTMuMTczNDk3IDQyMy4wNTMzMTEgNDIzLjA1MzMxMSAwIDAgMC03OTQuOTA5MDg4LTIuNjk0NjA3IDEyNi4xODg0NDkgMTI2LjE4ODQ0OSAwIDAgMC02Ny4zNjUxNzcgMTEzLjE3MzQ5NyAxMzIuMjUxMzE1IDEzMi4yNTEzMTUgMCAwIDAgMTMyLjAzNTc0NyAxMzIuMDM1NzQ3eiIKICAgICAgICAgIGZpbGw9IiMwN0MxNjA3QSIKICAgICAgICAgIHAtaWQ9IjE3MzEzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03OTcuNjU3NTg2IDY3MS4wMDY0NzNhNDI2LjA0NDMyNSA0MjYuMDQ0MzI1IDAgMCAxLTU3My45NTEzMDcgMEEzODEuODc5NzE1IDM4MS44Nzk3MTUgMCAwIDAgMC4wNTM4OTIgMTAyNGgxMDIzLjk1MDY4OWMwLTE2NC4zNzEwMzItODguOTIyMDMzLTI4NS42MjgzNS0yMjYuMzQ2OTk1LTM1Mi45OTM1Mjd6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE3MzE0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7llK7lkI7mlK/mjIE8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svY2p3dC8yNzMuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NjUyMDAyIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzE3NSIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNTEyIDUxMm0tNTEyIDBhNTEyIDUxMiAwIDEgMCAxMDI0IDAgNTEyIDUxMiAwIDEgMC0xMDI0IDBaIgogICAgICAgICAgZmlsbD0iI0VGQTEzQyIKICAgICAgICAgIHAtaWQ9IjE3MTc2IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MjUuNjgzMiAyNjcuNDQzMmE1MS4zMjggNTEuMzI4IDAgMCAwLTM0LjcxMzYgMGwtMjYwLjM3NzYgOTMuNzcyOGExMTUuMiAxMTUuMiAwIDAgMC02OS4zNzYgNjkuMzc2bC05My43NDcyIDI2MC4zNzc2YTUxLjIgNTEuMiAwIDAgMCA2NS41MzYgNjUuNTM2bDI2MC40MDMyLTkzLjc0NzJhMTE1LjIgMTE1LjIgMCAwIDAgNjkuMzUwNC02OS4zNzZsOTMuNzQ3Mi0yNjAuNDAzMmE1MS4yIDUxLjIgMCAwIDAtMzAuODIyNC02NS41MzZ6IG0tMjEzLjY4MzIgMzA4LjUzMTJhNjQgNjQgMCAxIDEgNjQtNjQgNjQgNjQgMCAwIDEtNjQuMDI1NiA2NC4wMjU2eiIKICAgICAgICAgIGZpbGw9IiNGRkRBQUIiCiAgICAgICAgICBwLWlkPSIxNzE3NyIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+57u85ZCI5bmz5Y+wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2V4dGVuZC9qc2NoZWNrLTE1OS5odG1sLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ2MzQ5NzciCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDEwODEgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE3MDM5IgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05My44NzcxMzcgNjQyLjg0MjEyM0gwLjAxMDgwOXYxMTMuNzc3MzY3QTk3LjE5NDMxNiA5Ny4xOTQzMTYgMCAwIDAgOTMuODc3MTM3IDg1My4zMzAyNTJoMzk4LjIyMDc4NHY3Ni43OTk3MjNoLTE0Mi4yMjE3MDlhNDUuNTEwOTQ3IDQ1LjUxMDk0NyAwIDAgMC00NS41MTA5NDcgNDguMzU1MzggNDQuOTQyMDYgNDQuOTQyMDYgMCAwIDAgNDUuNTEwOTQ3IDQ1LjUxMDk0N2gzNzUuNDY1MzExYTQ1LjUxMDk0NyA0NS41MTA5NDcgMCAwIDAgNDUuNTEwOTQ3LTQ4LjM1NTM4MSA0NC45NDIwNiA0NC45NDIwNiAwIDAgMC00NS41MTA5NDctNDUuNTEwOTQ2aC0xNDIuMjIxNzA5Vjg1My4zMzAyNTJoNDAxLjA2NTIxOWE5NS4zMTY5ODkgOTUuMzE2OTg5IDAgMCAwIDkzLjg2NjMyNy05Ni43MTA3NjJ2LTExMy43NzczNjdIOTMuODc3MTM3eiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE3MDQwIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05ODcuMDI5NDY3IDBIOTMuODc3MTM3QTk1LjMxNjk4OSA5NS4zMTY5ODkgMCAwIDAgMC4wMTA4MDkgOTYuNzEwNzYydjQ0OS40MjA1OTloMTA4MC44ODQ5ODZWOTYuNzEwNzYyQTk1LjIwMzIxMiA5NS4yMDMyMTIgMCAwIDAgOTg3LjAyOTQ2NyAwIgogICAgICAgICAgZmlsbD0iIzQwNTNGRiIKICAgICAgICAgIHAtaWQ9IjE3MDQxIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7lkI7lj7DnrqHnkIY8L3NwYW4+CiAgICA8L2Rpdj4KICA8L2Rpdj4KPC9kaXY+Cg==', IS_PUBLIC = 1, SUPPORT_REFESH = NULL, REFESH_TIME = 10, SHOW_EFFECT = NULL, MEMO = '', DATA_PARAM = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}', NEEDPAGE = 0, ORG_ID = NULL, CREATOR = NULL, CREATE_BY_ = '1', UPDATE_BY_ = '1', CREATE_TIME_ = '2023-04-26 16:01:58', UPDATE_TIME_ = '2023-06-01 17:20:53', REQUEST_TYPE = NULL, CATALOG_NAME = '', CREATE_ORG_ID_ = '', TENANT_ID_ = '-1', SHOW_TITLE_ = 1, CONTAIN_COL_ = NULL, APPID_ = '', SECRET_ = '', TEMPLATE_JAVA_SCRIPT_ = 'e30=', STYLE_ = '', is_init_ = 0, SNAPSHOT_ID_ = '', TEMPLATE_STYLE_ = 'Lm1vYmlsZS1jdXN0b20taXRlbXsKICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBjZW50ZXI7CiAgICBoZWlnaHQ6IDgycHg7CiAgICBjb2xvcjogIzI2MjYyNjsKICAgIGZvbnQtc2l6ZTogMTNweDsKICAgIHdpZHRoOiAyNSU7CiAgICBtYXJnaW4tYm90dG9tOiA4cHg7Cn0KLm1vYmlsZS1jdXN0b20taXRlbSBzcGFuewogIHBhZGRpbmctdG9wOjhweDsKfQogIA==' WHERE ID = '1651134508916514816';

-- 2023-06-14 liangjc 修复portal_sys_dic旧数据字典排序sn_为空的数据
UPDATE portal_sys_dic SET sn_ = ROWNUM WHERE sn_ IS NULL;

-- 2023-06-16 jjx 更新个人信息栏目mobile和数据台栏目的初始化脚本
UPDATE portal_sys_column SET NAME = '个人信息栏目mobile', ALIAS = 'grxxlmmobile', CATALOG = NULL, COL_TYPE = 'HtCustom',
UPDATE portal_sys_column SET NAME = '个人信息栏目mobile', ALIAS = 'grxxlmmobile', CATALOG = NULL, COL_TYPE = 'HtCustom',
                             DATA_MODE = NULL, DATA_FROM = NULL, DS_ALIAS = NULL, DS_NAME = NULL, COL_HEIGHT = NULL,
                             COL_URL = NULL,
                             TEMPLATE_HTML = 'ICA8ZGl2IGNsYXNzPSJhbGxIb21lIj4KICAgIDxkaXYgY2xhc3M9ImFsbEhvbWVfaGVhZGVycyI+CiAgICAgIDx0ZW1wbGF0ZSB2LWlmPSJkYXRhLnVzZXIucGhvdG8iPgogICAgICAgIDxpbWcKICAgICAgICAgIDpzcmM9ImltZyIKICAgICAgICAgIGFsdD0iIgogICAgICAgICAgd2lkdGg9IjUyIgogICAgICAgICAgaGVpZ2h0PSI1MiIKICAgICAgICAvPgogICAgICA8L3RlbXBsYXRlPgoKICAgICAgPGkgdi1lbHNlIGNsYXNzPSJpY29uLXpoYW5naGFvIiBzdHlsZT0iZm9udC1zaXplOiAzNnB4OyBjb2xvcjogI2ZmZiI+PC9pPgogICAgICA8ZGl2IGNsYXNzPSJ0aXRsZSI+CiAgICAgICAgPGRpdiBjbGFzcz0idGl0bGVfdG9wIj4KICAgICAgICAgIHt7IHRpdGxlIH19CiAgICAgICAgPC9kaXY+CgogICAgICAgIDxkaXYgY2xhc3M9InRpdGxlX2JvdHRvbSI+CiAgICAgICAgICDkvaDlpb3vvIEge3sgZGF0YS51c2VyLmZ1bGxuYW1lIH19LOelneS9oOW8gOW/g+avj+S4gOWkqQogICAgICAgIDwvZGl2PgogICAgICA8L2Rpdj4KICAgIDwvZGl2PgogICAgPGRpdiBjbGFzcz0iYWxsSG9tZV9jb250ZW50Ij4KICAgICAgPGRpdiB2LWZvcj0iKGl0ZW0sIGkpIG9mIGxpc3REYXRhIiA6a2V5PSJpIiBjbGFzcz0iYWxsSG9tZV9jb250ZW50X2l0ZW0iIEBjbGljaz0nY2xpY2tJdGVtKGl0ZW0pJz4KICAgICAgICA8ZGl2IGNsYXNzPSJhbGxIb21lX2NvbnRlbnRfaXRlbV9udW0iPgogICAgICAgICAge3sgaXRlbS5udW0gPj0gOTkgPyAiOTkrIiA6IGl0ZW0ubnVtIH19CiAgICAgICAgPC9kaXY+CiAgICAgICAgPGRpdiBjbGFzcz0iYWxsSG9tZV9jb250ZW50X2l0ZW1fbmFtZSI+CiAgICAgICAgICB7eyBpdGVtLm5hbWUgfX0KICAgICAgICA8L2Rpdj4KICAgICAgPC9kaXY+CiAgICA8L2Rpdj4KICA8L2Rpdj4=',
                             IS_PUBLIC = 1, SUPPORT_REFESH = NULL, REFESH_TIME = 10, SHOW_EFFECT = NULL, MEMO = '',
                             DATA_PARAM = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"${bpmRunTime}/runtime/instance/v1/getDefaultInfoMap\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"formTable\",\"dataType\":\"\",\"dataMode\":3,\"requestType\":\"GET\"}',
                             NEEDPAGE = 0, ORG_ID = NULL, CREATOR = NULL, CREATE_BY_ = '1', UPDATE_BY_ = '1', CREATE_TIME_ = '2023-05-12 14:07:38',
                             UPDATE_TIME_ = '2023-06-16 10:42:06', REQUEST_TYPE = NULL, CATALOG_NAME = '', CREATE_ORG_ID_ = '', TENANT_ID_ = '-1', SHOW_TITLE_ = 0, CONTAIN_COL_ = NULL,
                             APPID_ = '', SECRET_ = '', TEMPLATE_JAVA_SCRIPT_ = 'ewogIGRhdGEoKSB7CiAgICByZXR1cm4gewogICAgICBuYW1lOiAi6LaF57qn566h55CG5ZGYIiwKICAgICAgdGl0bGU6ICLmrKLov47kvb/nlKjlro/lpKlFSVAiLAogICAgICBpbWc6ICIiLAoKICAgICAgbGlzdERhdGE6IFsKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5b6F5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMCIsCiAgICAgICAgICBpZDogIm15VGFrcyIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5bey5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMSIsCiAgICAgICAgICBpZDogIm15QWxyZWFkeSIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5oiR55qE55Sz6K+3IiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVJlcXVlc3QiLAogICAgICAgICAgaWQ6ICJteVJlcXVlc3QiLAogICAgICAgIH0sCiAgICAgICAgewogICAgICAgICAgbmFtZTogIuaIkeeahOi9rOWKniIsCiAgICAgICAgICBudW06IDAsCiAgICAgICAgICB0bzogIi9tYXR0ZXIvbXlUYXNrLzMiLAogICAgICAgICAgaWQ6ICJteUFjY29yZGluZ01hdHRlcnMiLAogICAgICAgIH0sCiAgICAgIF0sCiAgICB9OwogIH0sCiAgbW91bnRlZCgpIHsKICAgIGZvciAobGV0IGl0ZW0gPSAwOyBpdGVtIDwgdGhpcy5saXN0RGF0YS5sZW5ndGg7IGl0ZW0rKykgewogICAgICB0aGlzLmxpc3REYXRhW2l0ZW1dLm51bSA9IHRoaXMuZGF0YVt0aGlzLmxpc3REYXRhW2l0ZW1dLmlkXS5kYXRhVGV4dCB8fCAwOwogICAgfQogIH0sCiAgd2F0Y2g6IHsKICAgIGRhdGE6IHsKICAgICAgaGFuZGxlcih2YWwpIHsKICAgICAgIAogICAgICAgIGlmICh2YWwgJiYgdmFsLnVzZXIgJiYgdmFsLnVzZXIucGhvdG8pIHsKICAgICAgICAKICAgICAgICAgICB0aGlzLmltZyA9ICB0aGlzLiRyZXF1ZXN0Q29uZmlnLmdldEltZ1NyYyh2YWwudXNlci5waG90bykKICAgICAgICB9CiAgICAgIH0sCiAgICBkZWVwOnRydWUgLCBpbW1lZGlhdGU6dHJ1ZSwKICAgIH0sCiAgfSwKICBtZXRob2RzOiB7CiAgICBjbGlja0l0ZW0oaXRlbSkgewogICAgICBjb25zb2xlLmxvZyhpdGVtKTsKICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS50byk7CiAgICB9LAogIH0sCn0=',
                             STYLE_ = '', is_init_ = 0, SNAPSHOT_ID_ = '',
                             TEMPLATE_STYLE_ = 'LmFsbEhvbWUgewoKICB3aWR0aDogY2FsYygxMDAlIC0gMjRweCk7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGp1c3RpZnktY29udGVudDogc3BhY2UtYmV0d2VlbjsKICBoZWlnaHQ6IDExOHB4OwogIGJhY2tncm91bmQ6ICNmZmZmZmY7CiAgYm9yZGVyLXJhZGl1czogMTJweCAxMnB4IDEycHggMTJweDsKICBwYWRkaW5nOiAxNnB4IDEycHg7Cn0KIC5hbGxIb21lX2hlYWRlcnMgewogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBmbGV4LXN0YXJ0OwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0KLmFsbEhvbWUgLmFsbEhvbWVfaGVhZGVycyBpbWcgewogIG1hcmdpbi1yaWdodDogOHB4OwogIGJvcmRlci1yYWRpdXM6IDUwJTsKfQouYWxsSG9tZSAuYWxsSG9tZV9oZWFkZXJzIC50aXRsZSAudGl0bGVfdG9wIAp7ICAgIG1hcmdpbi1ib3R0b206IDdweDsKICBjb2xvcjogIzI2MjYyNjsKICBmb250LXdlaWdodDogODAwOwogIGZvbnQtc2l6ZTogMThweDsKfQoKLmFsbEhvbWUgLmFsbEhvbWVfY29udGVudCAuYWxsSG9tZV9jb250ZW50X2l0ZW1fbnVtewogIG1hcmdpbi10b3A6MTZweDsKaGVpZ2h0OiAzMHB4Owpjb2xvcjogIzI2MjYyNjsKZm9udC13ZWlnaHQ6IDkwMDsKZm9udC1zaXplOiAyNHB4OwptYXJnaW4tYm90dG9tOiA2cHg7dGV4dC1hbGlnbjogY2VudGVyOwp9Ci5hbGxIb21lIC5hbGxIb21lX2hlYWRlcnMgLnRpdGxlIC50aXRsZV9ib3R0b20gewogIGNvbG9yOiAjNTg1ODU4OwogIGZvbnQtd2VpZ2h0OiA0MDA7CiAgZm9udC1zaXplOiAxNHB4Owp9Ci5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnQgLmFsbEhvbWVfY29udGVudF9pdGVtX25hbWV7CiAgCmZvbnQtc2l6ZTogMTFweDsKZm9udC13ZWlnaHQ6IDQwMDsKY29sb3I6ICM4QzhDOEM7Cn0KCi5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnR7CgogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBzcGFjZS1iZXR3ZWVuOwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0=' WHERE ALIAS = 'grxxlmmobile';

UPDATE portal_sys_column SET NAME = '数据台', ALIAS = 'sjt', CATALOG = NULL, COL_TYPE = 'HtCustom', DATA_MODE = NULL, DATA_FROM = NULL,
                               DS_ALIAS = NULL, DS_NAME = NULL, COL_HEIGHT = NULL, COL_URL = '',
                               TEMPLATE_HTML = 'PGRpdiBjbGFzcz0ibW9iaWxlLWFwcGx5LWNhcmQiIDpjbGFzcz0ieyAnYm9yZGVyLWJvdHRvbSc6IGlzU2hvd0JvdHRvbU1hcmdpbiB9Ij4KICA8ZGl2CiAgICA6Ym9yZGVyPSJmYWxzZSIKICAgIGNsYXNzPSJtb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCIKICAgIHYtaWY9ImFwcGx5TGlzdCAmJiBhcHBseUxpc3QubGVuZ3RoIgogID4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1hcHBseS1jYXJkLS1pdGVtIgogICAgICB2LWZvcj0iKGl0ZW0sIGluZGV4KSBpbiBhcHBseUxpc3QiCiAgICAgIDprZXk9ImAke2l0ZW0ubmFtZX1fJHtpbmRleH1gIgogICAgICBAY2xpY2s9ImhhbmRsZUNsaWNrKGl0ZW0pIgogICAgPgogICAgICA8ZGl2CiAgICAgICAgY2xhc3M9Iml0ZW0tdG9wLS1pY29uIgogICAgICAgIDpzdHlsZT0ieyBiYWNrZ3JvdW5kOiBpdGVtLmljb25Db2xvciB8fCAnIzQwOUVGRicgfSIKICAgICAgPgogICAgICAgIDxpIGNsYXNzPSJtb2JpbGUtYXBwbHktaWNvbiIgOmNsYXNzPSJpdGVtLmljb24gfHwgJ2ljb24tYXNpZGUtYXBwLWNlbnRlciciPjwvaT4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgY2xhc3M9Im1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSI+e3sgaXRlbS5uYW1lfX08L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pgo8L2Rpdj4=',
                               IS_PUBLIC = 1, SUPPORT_REFESH = NULL, REFESH_TIME = 10, SHOW_EFFECT = NULL, MEMO = '',
                               DATA_PARAM = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}',
                               NEEDPAGE = 0, ORG_ID = NULL, CREATOR = NULL, CREATE_BY_ = '1', UPDATE_BY_ = '1', CREATE_TIME_ = '2023-04-26 10:53:55',
                               UPDATE_TIME_ = '2023-06-16 10:43:09', REQUEST_TYPE = NULL, CATALOG_NAME = '',CREATE_ORG_ID_ = '', TENANT_ID_ = '-1', SHOW_TITLE_ = 1,
                               CONTAIN_COL_ = NULL, APPID_ = '', SECRET_ = '', TEMPLATE_JAVA_SCRIPT_ = 'ewogICBkYXRhKCkgewogICAgICByZXR1cm4gewogICAgICAgIGlzU2hvd0JvdHRvbU1hcmdpbjpmYWxzZSwKICAgICAgICBhcHBseUxpc3Q6IFsKICAgICAgICAgIHsKICAgICAgICAgICAgbmFtZTogJ+aWsOW7uua1geeoiycsCiAgICAgICAgICAgIGljb246ICdpY29uLXhpbmppYW5saXVjaGVuZzExJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwOUVGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL25ld01hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE5Lu75YqhJywKICAgICAgICAgICAgaWNvbjogJ2ljb24tZGFpYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwNTNGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215VGFzaycsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE55Sz6K+3JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXNoZW5xaW5nJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0Y2Qjg1QScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215UmVxdWVzdCcsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5Lyg6ZiF5LqL6aG5JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZWNodWFueXVlJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzg1NTBFMScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL2NpcmN1bGF0ZU1hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgIF0sCiAgICAgIH0KICAgfSwKICAgICBtZXRob2RzOiB7CiAgICAgIGhhbmRsZUNsaWNrKGl0ZW0pIHsKICAgICAgICBpZiAoaXRlbS5wYXRoKSB7CiAgICAgICAgICB0aGlzLiRyb3V0ZXIucHVzaChpdGVtLnBhdGgpCiAgICAgICAgfQogICAgICB9LAogICAgfSwKfQ==',
                               STYLE_ = '', is_init_ = 0, SNAPSHOT_ID_ = '', TEMPLATE_STYLE_ = 'Lm1vYmlsZS1hcHBseS1jYXJkIHsKICBiYWNrZ3JvdW5kOiAjZmZmOwp9CgoubW9iaWxlLWFwcGx5LWNhcmQtLWNvbnRlbnR7CiAgIGRpc3BsYXk6IGZsZXg7CiAgIGZsZXgtd3JhcDogd3JhcDsKICAgcGFkZGluZy10b3A6IDE2cHg7Cn0KLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbXsKICAgIHdpZHRoOiAyNSU7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgdGV4dC1hbGlnbjogY2VudGVyOwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIGhlaWdodDogOTBweDsKICAgIG1hcmdpbi1ib3R0b206OHB4Owp9Ci5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLml0ZW0tdG9wLS1pY29uIHsKICB3aWR0aDogNDBweDsKICBoZWlnaHQ6IDQwcHg7CiAgZGlzcGxheTogZmxleDsKICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICBhbGlnbi1pdGVtczogY2VudGVyOwogIGJvcmRlci1yYWRpdXM6IDhweDsKICBjb2xvcjogI2ZmZjsKfQoKLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbSAuaXRlbS10b3AtLWljb24gLm1vYmlsZS1hcHBseS1pY29uIHsKICBmb250LXNpemU6IDI0cHg7Cn0KCi5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLm1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSB7CiAgaGVpZ2h0OiAzMHB4OwogIGZvbnQtc2l6ZTogMTNweDsKICBjb2xvcjogIzMzMzsKICBwYWRkaW5nLXRvcDogOHB4OwogIHRleHQtYWxpZ246IGNlbnRlcjsKICBvdmVyZmxvdzogaGlkZGVuOwogIHRleHQtb3ZlcmZsb3c6IGVsbGlwc2lzOwogIGRpc3BsYXk6IC13ZWJraXQtYm94OwogIC13ZWJraXQtbGluZS1jbGFtcDogMjsKICAtd2Via2l0LWJveC1vcmllbnQ6IHZlcnRpY2FsOwp9'
                           WHERE ALIAS = 'sjt';


-- 2023-6-20 jjx 更新我的申请国际化内容
update portal_i18n_message set VALUE_ = '流程编号' where ID_ = '1613098875580936192';
update portal_i18n_message set VALUE_ = 'Process number' where ID_ = '1613099384089964544';
update portal_i18n_message set VALUE_ = '流程編號' where ID_ = '1613352041601921024';

-- 2023-6-20 jjx 更新门户配置椒，解决初始化图片加载失败问题
UPDATE portal_sys_layout_manage SET DESIGN_HTML = 'eyJ0b3BCb3R0b21MYXlvdXQiOltdLCJoZWFkZXIiOltdLCJtYWluIjp7ImxlZnQiOltdLCJjZW50ZXIiOltdLCJyaWdodCI6W10sImxheW91dENvbCI6InR3byJ9LCJib3R0b20iOltdLCJtb2JpbGVMaXN0IjpbXSwibGlzdCI6W3sidHlwZSI6Im9uZSIsIm5hbWUiOiLkuIDooYzkuIDliJciLCJpY29uIjoiaWNvbi15aWhhbmd5aWxpZSIsImNvbHVtbnMiOlt7InNwYW4iOjI0LCJsaXN0IjpbeyJuYW1lIjoi5Liq5Lq65L+h5oGv5qCP55uu566h55CG56uvIiwiYWxpYXMiOiJncnh4bG1nbGQiLCJrZXkiOiIxNjY3NDYwMjE4MDAwXzY3ODI5NDciLCJzbmFwc2hvdElkIjoiIn1dfV0sImtleSI6IjE2Njc0NTk4NDIwMDBfOTE4Mzk0OCJ9LHsidHlwZSI6Im9uZSIsIm5hbWUiOiLkuIDooYzkuIDliJciLCJpY29uIjoiaWNvbi15aWhhbmd5aWxpZSIsImNvbHVtbnMiOlt7InNwYW4iOjI0LCJsaXN0IjpbeyJuYW1lIjoi5Lu75Yqh6Z2i5p2/566h55CG56uvIiwiYWxpYXMiOiJyd21iZ2xkIiwia2V5IjoiMTY2NzQ2MDIyMjAwMF82NzYzMTIwIiwic25hcHNob3RJZCI6IiJ9XX1dLCJrZXkiOiIxNjY3NDYwMjIxMDAwXzgzMDk3MTcifSx7InR5cGUiOiJvbmUiLCJuYW1lIjoi5LiA6KGM5LiA5YiXIiwiaWNvbiI6Imljb24teWloYW5neWlsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sibmFtZSI6IuWFs+S6juaIkeS7rOeuoeeQhuerryIsImFsaWFzIjoiZ3l3bWdsZCIsImtleSI6IjE2Njc0NjAyMjUwMDBfMjUzMDM1NiIsInNuYXBzaG90SWQiOiIifV19XSwia2V5IjoiMTY2NzQ2MDIyMzAwMF8xNzEyMDk0In1dLCJjb25maWciOnsibGFiZWxXaWR0aCI6MTAwLCJsYWJlbFBvc2l0aW9uIjoicmlnaHQiLCJzaXplIjoic21hbGwifX0K' WHERE ID = '0';

UPDATE portal_sys_layout_manage SET  DESIGN_HTML = 'eyJ0b3BCb3R0b21MYXlvdXQiOltdLCJoZWFkZXIiOltdLCJtYWluIjp7ImxlZnQiOltdLCJjZW50ZXIiOltdLCJyaWdodCI6W10sImxheW91dENvbCI6InR3byJ9LCJib3R0b20iOltdLCJtb2JpbGVMaXN0IjpbeyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuaVsOaNruWPsCIsImFsaWFzIjoic2p0Iiwia2V5IjoiMTY4NjIxOTY3MTAwMF85NzA4ODU0In0seyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuW4uOeUqOWKn+iDvSIsImFsaWFzIjoiY3lnbnNqZCIsImtleSI6IjE2ODYyMTk2ODAwMDBfMTExNjQxNSJ9LHsic25hcHNob3RJZCI6IiIsIm5hbWUiOiLlvoXlip7liIbmnpAiLCJhbGlhcyI6InlkZGRiZngiLCJrZXkiOiIxNjg2MjIwMzU1MDAwXzk0NDA4MTUifSx7InNuYXBzaG90SWQiOiIiLCJuYW1lIjoi5paw6Ze75Lit5b+DIiwiYWxpYXMiOiJ5ZGR4d3p4Iiwia2V5IjoiMTY4NzE0NTc5MTAwMF85MTkwNDg4In1dLCJsaXN0IjpbXSwiY29uZmlnIjp7ImxhYmVsV2lkdGgiOjEwMCwibGFiZWxQb3NpdGlvbiI6InJpZ2h0Iiwic2l6ZSI6InNtYWxsIn19Cg==' WHERE ID = '1';

UPDATE portal_sys_layout_manage SET  DESIGN_HTML = 'eyJ0b3BCb3R0b21MYXlvdXQiOltdLCJoZWFkZXIiOltdLCJtYWluIjp7ImxlZnQiOlt7Im5hbWUiOiLkuKrkurrkv6Hmga/moI/nm64iLCJhbGlhcyI6ImdyeHhsbSJ9LHsibmFtZSI6IuW4uOeUqOa1geeoiyIsImFsaWFzIjoidnVlT2Z0ZW5GbG93In0seyJuYW1lIjoi5Lu75Yqh6Z2i5p2/IiwiYWxpYXMiOiJyd21idnVlIn1dLCJjZW50ZXIiOltdLCJyaWdodCI6W3sibmFtZSI6IuaIkeeahOW+heWKniIsImFsaWFzIjoidnVlVG9kbyJ9LHsibmFtZSI6IuaIkeeahOivt+axgiIsImFsaWFzIjoidnVlTXlyZXF1ZXN0In0seyJuYW1lIjoi5pyA5paw6aG555uuIiwiYWxpYXMiOiJ6eHhtdnVlIn1dLCJsYXlvdXRDb2wiOiJ0d28ifSwiYm90dG9tIjpbXSwibW9iaWxlTGlzdCI6W10sImxpc3QiOlt7InR5cGUiOiJvbmUiLCJuYW1lIjoi5LiA6KGM5LiA5YiXIiwiaWNvbiI6Imljb24teWloYW5neWlsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sic25hcHNob3RJZCI6IiIsIm5hbWUiOiLova7mkq3lm74iLCJhbGlhcyI6ImxidCIsImtleSI6IjE2ODcxNDEzMzEwMDBfNjM1MDcyNyJ9XX1dLCJrZXkiOiIxNjg3MTQxMzI3MDAwXzI2Nzg4NTIifSx7InR5cGUiOiJ0d28iLCJuYW1lIjoi5LiA6KGM5Lik5YiXIiwiaWNvbiI6Imljb24teWloYW5nbGlhbmdsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoxNiwibGlzdCI6W3sibmFtZSI6IuS4quS6uuS/oeaBr+agj+ebriIsImFsaWFzIjoiZ3J4eGxtIiwia2V5IjoiMTY2NTI5OTk3MDAwMF8xMTQ5NzY0Iiwic25hcHNob3RJZCI6IiJ9LHsibmFtZSI6IuW+heWKniIsImFsaWFzIjoiZGIiLCJrZXkiOiIxNjg2MjEyOTIyMDAwXzY0ODMzIiwic25hcHNob3RJZCI6IiJ9LHsic25hcHNob3RJZCI6IiIsIm5hbWUiOiLmtYHnqIvkuK3lv4MiLCJhbGlhcyI6ImxjengiLCJrZXkiOiIxNjg2MjIwNTM1MDAwXzcxNDM3MDMifSx7Im5hbWUiOiLml6XnqIsiLCJhbGlhcyI6InJjIiwia2V5IjoiMTY4NjIyMDU1NTAwMF81NzI1NTkyIiwic25hcHNob3RJZCI6IiJ9LHsibmFtZSI6IuS8muiuriIsImFsaWFzIjoiaHkiLCJrZXkiOiIxNjg2MjEyOTc4MDAwXzgxMjg1MzUiLCJzbmFwc2hvdElkIjoiIn1dfSx7InNwYW4iOjgsImxpc3QiOlt7Im5hbWUiOiLluLjnlKjlip/og70iLCJhbGlhcyI6ImN5Z24iLCJrZXkiOiIxNjg2MjEyOTQwMDAwXzQ3NzMzNDAiLCJzbmFwc2hvdElkIjoiIn0seyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuS8geS4muaWsOmXuyIsImFsaWFzIjoicXl4dyIsImtleSI6IjE2ODYyMTQ1OTEwMDBfNDQ2NDg4OSJ9LHsic25hcHNob3RJZCI6IiIsIm5hbWUiOiLluLjnlKjmtYHnqIsiLCJhbGlhcyI6ImN5bGMiLCJrZXkiOiIxNjg2MjIwMzk5MDAwXzQwMDk4NTIifSx7InNuYXBzaG90SWQiOiIiLCJuYW1lIjoi5Liq5Lq65LqL6aG5IiwiYWxpYXMiOiJncnN4Iiwia2V5IjoiMTY4NjIyMDU0NzAwMF81ODgxMzk2In0seyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuW+heWKnuWIhuaekCIsImFsaWFzIjoiZGJmeCIsImtleSI6IjE2ODYyMTI5NTAwMDBfOTQ1ODUxNiJ9XX1dLCJrZXkiOiIxNjY1Mjk5MjA4MDAwXzYwNjA0MjEifSx7InR5cGUiOiJvbmUiLCJuYW1lIjoi5LiA6KGM5LiA5YiXIiwiaWNvbiI6Imljb24teWloYW5neWlsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sibmFtZSI6IuS7u+WKoemdouadv+W6lOeUqOerryIsImFsaWFzIjoicndtYnl5ZCIsImtleSI6IjE2Njc0NTkyNjQwMDBfMTE5NTkyNyIsInNuYXBzaG90SWQiOiIifV19XSwia2V5IjoiMTY2NzQ1OTI1OTAwMF81NzEyMTgyIn0seyJ0eXBlIjoib25lIiwibmFtZSI6IuS4gOihjOS4gOWIlyIsImljb24iOiJpY29uLXlpaGFuZ3lpbGllIiwiY29sdW1ucyI6W3sic3BhbiI6MjQsImxpc3QiOlt7Im5hbWUiOiLlhbPkuo7miJHku6wiLCJhbGlhcyI6Imd5d20iLCJrZXkiOiIxNjY3NDU5MjcwMDAwXzYwMjUwODkiLCJzbmFwc2hvdElkIjoiIn1dfV0sImtleSI6IjE2Njc0NTkyNjcwMDBfMjM3NDY4MSJ9XSwiY29uZmlnIjp7ImxhYmVsV2lkdGgiOjEwMCwibGFiZWxQb3NpdGlvbiI6InJpZ2h0Iiwic2l6ZSI6InNtYWxsIn19Cg==' WHERE ID = '2';

-- 2023-6-25 jjx 更新维度菜单接口
UPDATE portal_sys_method SET REQUEST_URL_ = '/api/demension/v1/dem/deleteDemByIds' WHERE ALIAS_ = 'uc_demension_del';

-- 2023-6-26 liangjc 默认平台的给人事管理员和系统管理员授权
INSERT INTO portal_sys_method(id_, ALIAS_, NAME_, MENU_ALIAS_, REQUEST_URL_, PATH_, TENANT_ID_) select '1666702693495816192', 'updateUserPsw', '修改密码接口权限', ALIAS_, '/api/user/v1/user/updateUserPsw', PATH_, TENANT_ID_ from portal_sys_menu where ALIAS_='ucManager' and TENANT_ID_='-1';
INSERT INTO portal_sys_role_auth(id_, ROLE_ALIAS_, METHOD_ALIAS_, TENANT_ID_)  select '1666702693495816192', 'rsgly',  ALIAS_,  '-1' from portal_sys_method where MENU_ALIAS_='ucManager' and TENANT_ID_='-1';
INSERT INTO portal_sys_role_auth(ID_, ROLE_ALIAS_, METHOD_ALIAS_, TENANT_ID_)  select '1666702693495816193', 'xtgly',  ALIAS_,  '-1' from portal_sys_method where MENU_ALIAS_='ucManager' and TENANT_ID_='-1';

-- 2023-7-3 jjx 修改字段长度
ALTER TABLE PORTAL_SYS_TAG MODIFY KEY_ VARCHAR(128);