7 lines
867 B
SQL
7 lines
867 B
SQL
-- This migration adds four columns to the `glcc_registration_task` table: `setting_reward_id`, `setting_reward_remark`, `tutor_address`, and `join_cooperative_community`
|
|
ALTER TABLE glcc_registration_task ADD COLUMN `setting_reward_id` INT(11) DEFAULT NULL COMMENT '配置奖励id' AFTER `task_reward`;
|
|
ALTER TABLE glcc_registration_task ADD COLUMN `setting_reward_remark` VARCHAR(500) DEFAULT NULL COMMENT '配置奖励备注' AFTER `setting_reward_id`;
|
|
ALTER TABLE glcc_registration_task ADD COLUMN `tutor_address` VARCHAR(255) DEFAULT NULL COMMENT '导师地址' AFTER `tutor_phone`;
|
|
|
|
-- This migration adds a column to the `glcc_registration_information` table: `join_cooperative_community`
|
|
ALTER TABLE glcc_registration_information ADD COLUMN `join_cooperative_community` TINYINT(1) DEFAULT NULL COMMENT '是否授权加入合作社区' AFTER `project_logo_id`; |