6 lines
698 B
SQL
6 lines
698 B
SQL
-- 初始化新增客户角色
|
|
INSERT INTO `system_role` (`id`, `name`, `code`, `sort`, `data_scope`, `data_scope_dept_ids`, `status`, `type`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (-999, '客户', 'customer', 3, 1, '', 0, 1, '客户', '1', '2024-08-26 23:09:05', '1', '2024-09-03 23:42:34', b'0', 1);
|
|
-- 初始化新增客户部门
|
|
INSERT INTO `system_dept` (`id`, `name`, `parent_id`, `sort`, `leader_user_id`, `phone`, `email`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (999999, '客户', 0, 1, NULL, NULL, NULL, 0, '113', '2022-03-07 21:44:50', '113', '2024-09-03 00:32:52', b'0', 122);
|
|
|