SHOW CREATE TABLE alarm;
找到像這樣
CONSTRAINT `server_id_refs_id_34554433` FORIEGN KEY (`server_id`) REFERENCES `server` (`id`)
line.ALTER TABLE `alarm` DROP FOREIGN KEY `server_id_refs_id_34554433`;
ALTER TABLE `alarm` DROP `server_id`
要新增的話
ALTER TABLE
alarm
1. DROP FOREIGN KEY
server_id_refs_id_34554433
,
2.ADD CONSTRAINT FOREIGN KEY (galid) REFERENCES Girls (galid)
ON UPDATE CASCADE
ON DELETE CASCADE;