ALTER TABLE `characters`
ADD allyId decimal(11,0) default NULL,
ADD deleteclan decimal(20,0) default NULL,

ALTER TABLE `characters`
DROP `clan_create_expiry_time`;
ALTER TABLE `characters`
DROP `clan_join_expiry_time`;