mysql 加字段 改类型 加索引

ALTER TABLE `wrs_plan_lk` 
MODIFY COLUMN `lk_id` bigint(10) NOT NULL COMMENT '湖泊id' AFTER `yc_id`,
ADD CONSTRAINT `fk_lk` FOREIGN KEY (`lk_id`) REFERENCES `wrs_rel_sp` (`id`);