| | |
|---|
| | | CALL add_column_if_missing('project_management_info','project_leader_name',"varchar(100) DEFAULT NULL COMMENT '项目负责人'"); |
|---|
| | | CALL add_column_if_missing('project_management_info','project_manager_ids',"json DEFAULT NULL COMMENT '项目经理ID数组'"); |
|---|
| | | CALL add_column_if_missing('project_management_info','project_manager_names',"json DEFAULT NULL COMMENT '项目经理名称数组'"); |
|---|
| | | CALL add_column_if_missing('project_management_info','project_executor_ids',"json DEFAULT NULL COMMENT '项目执行人ID数组'"); |
|---|
| | | CALL add_column_if_missing('project_management_info','project_executor_names',"json DEFAULT NULL COMMENT '项目执行人名称数组'"); |
|---|
| | | |
|---|
| | | -- 新版的“立项”是开始前的信息准备活动，开始后统一进入“开发”阶段。 |
|---|
| | | UPDATE project_management_info SET current_phase = '开发' WHERE current_phase = '立项' AND is_delete = 0; |
|---|
| | | CALL add_column_if_missing('project_management_info','follow_cycle',"varchar(20) DEFAULT 'MONTH' COMMENT 'MONTH每月 QUARTER每季度 YEAR每年'"); |
|---|
