drop index IDX_UR_ARPT_L;
create index IDX_UR_ARPT_L on UR_ARPT (
   L_CODE ASC
);

drop index IDX_UR_DS_L;
create index IDX_UR_DS_L on UR_DS (
   L_CODE ASC
);

drop index IDX_UR_MAP_L;
create index IDX_UR_MAP_L on UR_MAP (
   L_CODE ASC
);

drop index IDX_UR_SYS_MENU_L;
create index IDX_UR_SYS_MENU_L on UR_SYS_MENU (
   L_CODE ASC
);

drop index IDX_UR_SYS_MENU_REFORM_L;
create index IDX_UR_SYS_MENU_REFORM_L on UR_SYS_MENU_REFORM (
   L_CODE ASC
);


--系统资料导出、加载
--菜单
Insert into ur_sys_menu
   (mod_id, l_code, is_end, mod_code, mod_name, mod_type, form_name, pack_name, param, user_id, mod_tag)
 Values
   ('SYS_DESIGN_EXP_IMP', '00020003', '1', 'SYS_DESIGN_EXP_IMP', '系统资料导出和加载', 
    'MOD', 'TF_ExpImp', 'RptDesign.exe', NULL, '*', 
    1);


Insert into ur_sys_menu_reform
   (menu_id, l_code, is_end, disp_name, mod_type, mod_id, seq_no)
 Values
   ('SYS_DESIGN_EXP_IMP', '00020003', '1', '导出和加载', 'MOD', 
    'SYS_DESIGN_EXP_IMP', 3);


Insert into ur_sys_res
   (mod_id, res_id, res_type, seq_no, org_name, disp_name, mark, lang_type)
 Values
   ('SYS_DESIGN_EXP_IMP', 'FUNC_SEARCH', 'F', 1, '查询', 
    '查询', '查询', 'chi');
Insert into ur_sys_res
   (mod_id, res_id, res_type, seq_no, org_name, disp_name, mark, lang_type)
 Values
   ('SYS_DESIGN_EXP_IMP', 'FUNC_EXP', 'F', 2, '导出', 
    '导出', '导出', 'chi');
Insert into ur_sys_res
   (mod_id, res_id, res_type, seq_no, org_name, disp_name, mark, lang_type)
 Values
   ('SYS_DESIGN_EXP_IMP', 'FUNC_IMP', 'F', 3, '加载', 
    '加载', '加载', 'chi');
Insert into ur_sys_res
   (mod_id, res_id, res_type, seq_no, org_name, disp_name, mark, lang_type)
 Values
   ('SYS_DESIGN_EXP_IMP', 'MOD', 'R', 1, '系统资料导出和加载', 
    '系统资料导出和加载', '系统资料导出和加载', 'chi');

