l2j-server-datapack/dist/sql/game/updates/20121031update.sql

ALTER TABLE `clan_data` ADD `blood_alliance_count` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `hasCastle`;
ALTER TABLE `clan_data` ADD `blood_oath_count` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `blood_alliance_count`;
ALTER TABLE `castle` DROP `bloodAlliance`;
ALTER TABLE `fort` DROP `blood`;