L2J Server

Code: Select all

 ALTER TABLE `castle` CHANGE `treasury` `treasury` BIGINT NOT NULL default 0;  ALTER TABLE `character_skills` DROP `skill_name`;ALTER TABLE `heroes` DROP `char_name`;  ALTER TABLE `characters` ADD `vitality_points` SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER `bookmarkslot`; ALTER TABLE `custom_armorsets` DROP `skill_id`;ALTER TABLE `custom_armorsets` DROP `skill_lvl`;ALTER TABLE `custom_armorsets` ADD `skill` VARCHAR(70) NOT NULL DEFAULT '0-0;' AFTER `feet`; UPDATE `characters` SET `fame`=50000 WHERE `fame`>50000 ALTER TABLE `character_recipebook` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`,`charId`,`classIndex`) UPDATE character_subclasses SET class_id=128 WHERE class_id=129 AND charId IN (SELECT charId FROM characters where race=5 AND sex=1); -- female main -> male soulbreaker subUPDATE character_subclasses SET class_id=129 WHERE class_id=128 AND charId IN (SELECT charId FROM characters where race=5 AND sex=0); -- male main   -> female soulbreaker subUPDATE character_subclasses SET class_id=132 WHERE class_id=133 AND charId IN (SELECT charId FROM characters where race=5 AND sex=1); -- female main -> male soulhound subUPDATE character_subclasses SET class_id=133 WHERE class_id=132 AND charId IN (SELECT charId FROM characters where race=5 AND sex=0); -- male main   -> female soulhound sub ALTER TABLE `custom_armor` ADD `depositable` varchar(5) NOT NULL default 'false' AFTER `tradeable`;ALTER TABLE `custom_etcitem` ADD `depositable` varchar(5) NOT NULL default 'false' AFTER `tradeable`;ALTER TABLE `custom_weapon` ADD `depositable` varchar(5) NOT NULL default 'false' AFTER `tradeable`;  UPDATE `character_quests` SET `value` = 1 WHERE (`name` = '606_WarWithVarkaSilenos' AND `var` = 'cond' AND `value` > 1); ALTER TABLE `castle` ADD `showNpcCrest` enum('true','false') DEFAULT 'false' NOT NULL AFTER `regTimeEnd`;  ALTER TABLE `characters` ADD `title_color` MEDIUMINT UNSIGNED NOT NULL default '16777079' AFTER `title`; ALTER TABLE `character_friends` DROP PRIMARY KEY, ADD PRIMARY KEY (`charId`, `friendId`),DROP column `friend_name`; ALTER TABLE `character_friends` ADD `relation` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `friendId`  ALTER TABLE `custom_armor` ADD `additionalname` varchar(120) NOT NULL default '' AFTER `name`; ALTER TABLE `custom_etcitem` ADD `additionalname` varchar(100) NOT NULL default '' AFTER `name`; ALTER TABLE `custom_weapon` ADD `additionalname` varchar(120) NOT NULL default '' AFTER `name`; ALTER TABLE `custom_npc` ADD `enchant` INT NOT NULL default 0 after `armor`; UPDATE `items` SET `loc` = 'WAREHOUSE' WHERE `loc` = 'FREIGHT'; ALTER TABLE `characters` ADD `createTime` DECIMAL( 20, 0 ) NOT NULL DEFAULT '0' AFTER `vitality_points` ;