abb-manage/db/批量用户.sql

INSERT INTO `t_sys_dict`(`id`, `value`, `label`, `type`, `description`, `sort`, `created_time`,
                         `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
                         `created_user_name`, `update_user_name`, `child_flag`, `parent_id`, `code`,
                         `type_name`, `value_type`)
VALUES ('5ffd65750b5bbe6aec7ca981', '51', '分公司总经理', 'SYS_USER_JOB_TYPE', '分公司总经理', 51, '2021-01-12 17:01:42',
        '2021-01-12 17:01:42', '0', '1', NULL, '超级管理员', NULL, '0', '5fc0576982a5005090800128', 'FGS_ZJL_51', '用户职务', 2);

INSERT INTO `t_sys_dict`(`id`, `value`, `label`, `type`, `description`, `sort`, `created_time`,
                         `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
                         `created_user_name`, `update_user_name`, `child_flag`, `parent_id`, `code`,
                         `type_name`, `value_type`)
VALUES ('5ffd65c30b5bbe6aec7ca983', '52', '分公司设备分管领导', 'SYS_USER_JOB_TYPE', '', 52, '2021-01-12 17:02:59',
        '2021-01-12 17:02:59', '0', '1', NULL, '超级管理员', NULL, '0', '5fc0576982a5005090800128', 'FGSSBFGLD_52', '用户职务',
        2);

INSERT INTO t_sys_dict (id, code, value, value_type, label, type_name, type, description, sort, created_time,
                        update_time, created_user_id, created_user_name)
VALUES ('6005a58bb3cf7f014053c8ac', 'XM_FJL', '33', 2, '项目副经理', '用户身份', 'SYS_USER_IDENTITY_TYPE', '项目副经理', 33,
        '2021-01-18 23:13:15.491', '2021-01-18 23:13:15.491', '1', '超级管理员');

INSERT INTO t_sys_dict (id, code, value, value_type, label, type_name, type, description, sort, created_time,
                        update_time, child_flag, parent_id, created_user_id, created_user_name)
VALUES ('6005a972b3cf7f014053c8f8', 'XTGLY_51', '51', 2, '水泥拌合楼操作手', '用户职务', 'SYS_USER_JOB_TYPE', '', 71,
        '2021-01-18 23:29:54.445', '2021-01-18 23:29:54.445', '0', '5fc0576982a5005090800128', '1', '超级管理员');