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`);
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`);