--整体报送状态
alter table UR_TASK_DW_TOTAL  add PROJ_ID  VARCHAR2(36) default '*';

--界面默认显示风格
Insert into ur_sys_opt (OPT_CODE, USER_ID, OPT_NAME, OPT_VALUE)
 Values ('MAIN_MENU_TYPE', '*', '首页使用左侧菜单', '0');
 
create table UR_SYS_MENU_PROFILE  (
   MOD_ID               VARCHAR2(36)                     not null,
   TYPE_CODE            VARCHAR2(30)                     not null,
   PROFILE_CODE         VARCHAR2(30)                     not null,
   SEQ_NO               INTEGER                        default 0,
   TYPE_NAME            VARCHAR2(120),
   PROFILE_NAME         VARCHAR2(120),
   constraint PK_UR_SYS_MENU_PROFILE primary key (MOD_ID, TYPE_CODE, PROFILE_CODE)
);

create table UR_SYS_ROLE_PROFILE  (
   MOD_ID               VARCHAR2(36)                     not null,
   ROLE_ID              VARCHAR2(36)                     not null,
   TYPE_CODE            VARCHAR2(30)                     not null,
   PROFILE_CODE         VARCHAR2(30),
   IS_ROLE              VARCHAR2(30)                   default '1',
   constraint PK_UR_SYS_ROLE_PROFILE primary key (MOD_ID, ROLE_ID, TYPE_CODE)
); 

--报送管理的风格
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DW_SCOPE', 'DW_NO_SUB', '默认单位范围', '不含下级', 
    1);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DW_SCOPE', 'DW_ALL_SUB', '默认单位范围', '含全部下级', 
    2);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DW_SCOPE', 'DW_DIRECT_SUB', '默认单位范围', '含直接下级', 
    3);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DW_SCOPE', 'DW_LOWEST', '默认单位范围', '仅最末级', 
    4);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'RPT_ALL', '默认显示数据类型', '报送－全部', 
    10);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'RPT_REPORTED', '默认显示数据类型', '报送－我已上报', 
    11);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'RPT_WAIT_REPORT', '默认显示数据类型', '报送－待我上报', 
    12);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'RPT_WAIT_ACCEPT', '默认显示数据类型', '报送－待我接收', 
    13);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'RPT_SUB_NOT_REPORT', '默认显示数据类型', '报送－下级未上报', 
    14);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'RPT_NO_DATA', '默认显示数据类型', '报送－数据未录入', 
    15);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'RPT_CAN_RETURN', '默认显示数据类型', '报送－可退回', 
    16);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'AUDIT_ALL', '默认显示数据类型', '审批－全部', 
    20);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'AUDIT_AUDITED', '默认显示数据类型', '审批－我已审批', 
    21);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'AUDIT_WAIT_AUDIT', '默认显示数据类型', '审批－待我审批', 
    22);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'AUDIT_OTHER', '默认显示数据类型', '审批－其他', 
    23);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'CHECK_ALL', '默认显示数据类型', '公式审核－全部', 
    30);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'CHECK_YES', '默认显示数据类型', '公式审核－已审核', 
    31);
Insert into ur_sys_menu_profile
   (mod_id, type_code, profile_code, type_name, profile_name, seq_no)
 Values
   ('SYS_BAT_REPORT', 'DATA_GRID', 'CHECK_NO', '默认显示数据类型', '公式审核－未审核', 
    32);
