programs_info/三资项目/删除前备份/流程不使用直接上级前的版本备份/doc/sql/2023/02/02/cf.sql

ALTER TABLE `acc_payable` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `sys_id`;

ALTER TABLE `acc_receivable` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `adjustexplain`;

ALTER TABLE `announcement_notice_user` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `title`;

ALTER TABLE `ctr_main` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `adjustamount`;

ALTER TABLE `cus_account` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updatedAt`;

ALTER TABLE `cus_contact` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updatedAt`;

ALTER TABLE `cus_main` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updatedAt`;

ALTER TABLE `cus_receipt` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updated_at`;

ALTER TABLE `flow_audit` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `sys_id`;

ALTER TABLE `oa_bug_library` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `batch_id`;

ALTER TABLE `oa_data_sharing` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updated_at`;

ALTER TABLE `oa_directory_management` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updated_at`;

ALTER TABLE `oa_pro_batch` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `upload_other_time`;

ALTER TABLE `oa_pro_check` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `upload_other_time`;

ALTER TABLE `oa_pro_task` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `labor_hours`;

ALTER TABLE `oa_pro_task_enclosure` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updated_at`;

ALTER TABLE `oa_pro_task_relation` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updated_at`;

ALTER TABLE `oa_pro_team` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `second_out`;

ALTER TABLE `oa_read_user` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updated_at`;

ALTER TABLE `oa_task_type` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `task_type_enclosure`;

ALTER TABLE `out_main` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updated_at`;

ALTER TABLE `out_order_main` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `source`;

ALTER TABLE `out_order_pay` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updated_at`;

ALTER TABLE `out_pro_del` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updated_at`;

ALTER TABLE `out_pro_delivery` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `sys_id`;

ALTER TABLE `out_pro_trans` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `git_url`;

ALTER TABLE `out_pro_trans` ADD COLUMN `created_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建' AFTER `group_id`;

ALTER TABLE `out_pro_trans` ADD COLUMN `updated_by`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `created_by`;

ALTER TABLE `out_pro_upgrad` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `server_ip`;

ALTER TABLE `pro_main` ADD COLUMN `group_id`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '集团' AFTER `reqdescription`;

ALTER TABLE `pro_main_phase_task` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updatedAt`;

ALTER TABLE `pro_phase` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updatedAt`;

ALTER TABLE `pro_phase_task` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `updatedAt`;

ALTER TABLE `pro_sys_info` ADD COLUMN `group_id`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团ID' AFTER `remark`;


INSERT INTO `idea_oa`.`frame_permission` (`id`, `name`, `descripion`, `url`, `pid`, `perms`, `type`, `icon`, `order_num`) VALUES ('674815912737505282', '服务部署', '', 'deploy/isView:1', '666132786188386304', '/project/sysInfo_deploy', '1', 'size', '1');