l2j-freya-fork/L2J_DataPack/dist/sql/game/updates/20100908update.sql

ALTER TABLE `clan_skills` ADD COLUMN `sub_pledge_id` INT NOT NULL default '-2';
ALTER TABLE `clan_skills` DROP PRIMARY KEY, ADD PRIMARY KEY (`clan_id`,`skill_id`,`sub_pledge_id`);