Insert into ur_sys_user
   (user_id, dw_id, user_code, pswd, must_change, valid_days, user_name, is_sys_man, dept_name, sex, addr, 
	fix_phone, mob_no, email, can_filter, scope_type, f_id, crt_user_id, crt_date, is_valid)
 Values
   ('adminBM', NULL, 'bm', NULL, '0',     -1, '主管部门', '0', NULL, NULL, 
    NULL, NULL, NULL, NULL, '0',     'A', NULL, NULL, NULL, '1');
Insert into ur_sys_user
   (user_id, dw_id, user_code, pswd, must_change, valid_days, user_name, is_sys_man, dept_name, sex, addr, 
	fix_phone, mob_no, email, can_filter, scope_type, f_id, crt_user_id, crt_date, is_valid)
 Values
   ('adminCZ', NULL, 'cz', NULL, '0',     -1, '财政部门', '0', NULL, NULL, 
    NULL, NULL, NULL, NULL, '0',     'A', NULL, NULL, NULL, '1');
Insert into ur_sys_user
   (user_id, dw_id, user_code, pswd, must_change, valid_days, user_name, is_sys_man, dept_name, sex, addr, 
	fix_phone, mob_no, email, can_filter, scope_type, f_id, crt_user_id, crt_date, is_valid)
 Values
   ('adminDW', NULL, 'dw', NULL, '0',     -1, '行政事业单位', '0', NULL, NULL, 
    NULL, NULL, NULL, NULL, '0',     'A', NULL, NULL, NULL, '1');
Insert into ur_sys_user
   (user_id, dw_id, user_code, pswd, must_change, valid_days, user_name, is_sys_man, dept_name, sex, addr, 
	fix_phone, mob_no, email, can_filter, scope_type, f_id, crt_user_id, crt_date, is_valid)
 Values
   ('adminGS', NULL, 'gs', NULL, '0',     -1, '融资平台公司', '0', NULL, NULL, 
    NULL, NULL, NULL, NULL, '0',     'A', NULL, NULL, NULL, '1');


Insert into ur_sys_user_func
   (user_id, mod_id, res_id, can_grant)
 Values
   ('adminBM', 'SYS_DESIGN_EXP_IMP', 'FUNC_IMP', '1');
Insert into ur_sys_user_func
   (user_id, mod_id, res_id, can_grant)
 Values
   ('adminBM', 'SYS_DESIGN_EXP_IMP', 'FUNC_SEARCH', '1');
Insert into ur_sys_user_func
   (user_id, mod_id, res_id, can_grant)
 Values
   ('adminCZ', 'SYS_DESIGN_EXP_IMP', 'FUNC_IMP', '1');
Insert into ur_sys_user_func
   (user_id, mod_id, res_id, can_grant)
 Values
   ('adminCZ', 'SYS_DESIGN_EXP_IMP', 'FUNC_SEARCH', '1');
Insert into ur_sys_user_func
   (user_id, mod_id, res_id, can_grant)
 Values
   ('adminDW', 'SYS_DESIGN_EXP_IMP', 'FUNC_IMP', '1');
Insert into ur_sys_user_func
   (user_id, mod_id, res_id, can_grant)
 Values
   ('adminDW', 'SYS_DESIGN_EXP_IMP', 'FUNC_SEARCH', '1');
Insert into ur_sys_user_func
   (user_id, mod_id, res_id, can_grant)
 Values
   ('adminGS', 'SYS_DESIGN_EXP_IMP', 'FUNC_IMP', '1');
Insert into ur_sys_user_func
   (user_id, mod_id, res_id, can_grant)
 Values
   ('adminGS', 'SYS_DESIGN_EXP_IMP', 'FUNC_SEARCH', '1');


Insert into ur_sys_role
   (role_id, role_code, role_name, is_to_self_reg, is_sys)
 Values
   ('adminBM', 'adminBM', '主管部门', '0', '0');
Insert into ur_sys_role
   (role_id, role_code, role_name, is_to_self_reg, is_sys)
 Values
   ('adminCZ', 'adminCZ', '财政部门', '0', '0');
Insert into ur_sys_role
   (role_id, role_code, role_name, is_to_self_reg, is_sys)
 Values
   ('adminDW', 'adminDW', '行政事业单位', '0', '0');
Insert into ur_sys_role
   (role_id, role_code, role_name, is_to_self_reg, is_sys)
 Values
   ('adminGS', 'adminGS', '融资平台公司', '0', '0');


Insert into ur_sys_user_role
   (user_id, role_id, can_grant)
 Values
   ('adminBM', 'adminBM', '1');
Insert into ur_sys_user_role
   (user_id, role_id, can_grant)
 Values
   ('adminCZ', 'adminCZ', '1');
Insert into ur_sys_user_role
   (user_id, role_id, can_grant)
 Values
   ('adminDW', 'adminDW', '1');
Insert into ur_sys_user_role
   (user_id, role_id, can_grant)
 Values
   ('adminGS', 'adminGS', '1');
