补充下表结构
表结构.txt (18.8 KB)
CREATE TABLE `tb_agent_user_project` (
`user_id` bigint(20) NOT NULL,
`project_id` int(10) NOT NULL,
`type` int(1) NOT NULL COMMENT '0: 管理员资源,1:普通用户资源',
`source_type` int(1) DEFAULT NULL COMMENT '0:权限分配,1:下级同步',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`project_id`,`type`,`user_id`) /*T![clustered_index] NONCLUSTERED */,
KEY `project_id` (`project_id`),
KEY `idx_p_user_id` (`user_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin