--用户类型
alter table UR_SYS_USER add USER_TYPE VARCHAR2(1);

Insert into ur_sys_base_col_set
   (fld_id, inf_type, seq_no, fld_code, idx_code, fld_name, is_ext_fld, data_type, data_len, dict_id, is_not_null, is_valid, is_man_filter)
 Values
   ('USER_TYPE', 'U', 10, 'USER_TYPE', 'USER_TYPE', 
    '用户类型', '1', 'E', 20, 'SYS_USER_TYPE', 
    '0', '1', '1');

--枚举
Insert into ur_sys_dict
   (ver_id, dict_id, dw_id, dict_code, dict_name, code_struct, mark, is_fix_len, is_sel_end, is_sel_multi, can_extend, is_used, is_sys)
 Values
   ('*', 'SYS_USER_TYPE', '*', 'SYS_USER_TYPE', '用户类型', 
    NULL, NULL, '1', '0', '0', 
    '0', '0', '1');


Insert into ur_sys_dict_val
   (ver_id, enum_id, dict_id, enum_code, enum_name, p_code, l_code, is_end, can_extend, dw_id, is_used)
 Values
   ('*', 'SYS_USER_TYPE_B', 'SYS_USER_TYPE', 'B', '基层单位用户', 
    NULL, '0003', '1', '0', '*', 
    NULL);
Insert into ur_sys_dict_val
   (ver_id, enum_id, dict_id, enum_code, enum_name, p_code, l_code, is_end, can_extend, dw_id, is_used)
 Values
   ('*', 'SYS_USER_TYPE_M', 'SYS_USER_TYPE', 'M', '主管单位用户', 
    NULL, '0002', '1', '0', '*', 
    NULL);
Insert into ur_sys_dict_val
   (ver_id, enum_id, dict_id, enum_code, enum_name, p_code, l_code, is_end, can_extend, dw_id, is_used)
 Values
   ('*', 'SYS_USER_TYPE_T', 'SYS_USER_TYPE', 'T', '顶级单位领导', 
    NULL, '0001', '1', '0', '*', 
    NULL);

