UPDATE `frame_permission` SET `name` = '团队商机跟进', `descripion` = '(NULL)', `url` = 'bizMainProgressTeam', `pid` = '666131429226184704', `perms` = '/crm/bizMainProgressTeam', `type` = 1, `icon` = 'list', `order_num` = 7, `description` = '(NULL)' WHERE `id` = '1083677576934719488'; INSERT INTO `frame_permission` (`id`, `name`, `descripion`, `url`, `pid`, `perms`, `type`, `icon`, `order_num`, `description`) VALUES ('108367757693478461', '商机分配', NULL, 'bizMainProgressTwo', '666131429226184704', '/crm/bizMainProgressTwo', 1, 'list', 7, NULL); INSERT INTO `frame_permission` (`id`, `name`, `descripion`, `url`, `pid`, `perms`, `type`, `icon`, `order_num`, `description`) VALUES ('106924579035584697', '资源计划', NULL, 'resourcePlanView', '106924579035545666', '/resourcePlan/resourcePlanView', 1, 'wechat', 15, NULL); alter table pro_main add expected_pay_money double null comment '预投入限额'; CREATE TABLE `frame_role_mobile_user` ( `id` varchar(255) NOT NULL, `user_id` varchar(255) DEFAULT NULL, `role_mobile_id` varchar(255) DEFAULT NULL COMMENT '数据角色ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='移动端菜单角色-用户关联表'; create index oa_task_created_by_index on oa_task_review (create_user); create index oa_task_hour_id_index on oa_task_review (task_hour_id); create index oa_task_review_state on oa_task_review (review_state); create index oa_task_review_user_role_index on oa_task_review (review_user_role) alter table frame_data add thumbnail_path varchar(255) null;