programs_info/三资项目/删除前备份/流程不使用直接上级前的版本备份/doc/sql/2024/12/5/p.sql

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;