ALTER TABLE `custom_armor`
MODIFY `item_id` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `name` varchar(120) NOT NULL DEFAULT '',
MODIFY `additionalname` varchar(120) NOT NULL DEFAULT '',
MODIFY `bodypart` varchar(15) NOT NULL DEFAULT 'none',
MODIFY `crystallizable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `armor_type` varchar(5) NOT NULL DEFAULT 'none',
MODIFY `weight` smallint(4) NOT NULL DEFAULT '0',
MODIFY `material` varchar(15) NOT NULL DEFAULT 'wood',
MODIFY `crystal_type` varchar(4) NOT NULL DEFAULT 'none',
MODIFY `avoid_modify` tinyint(2) NOT NULL DEFAULT '0',
MODIFY `duration` mediumint(5) NOT NULL DEFAULT '-1',
MODIFY `time` mediumint(5) NOT NULL DEFAULT '-1',
MODIFY `p_def` smallint(3) NOT NULL DEFAULT '0',
MODIFY `m_def` smallint(3) NOT NULL DEFAULT '0',
MODIFY `mp_bonus` smallint(3) NOT NULL DEFAULT '0',
MODIFY `price` int(10) unsigned NOT NULL DEFAULT '0',
MODIFY `crystal_count` smallint(4) unsigned NOT NULL DEFAULT '0',
MODIFY `sellable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `dropable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `destroyable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `tradeable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `depositable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `enchant4_skill` varchar(8) NOT NULL DEFAULT '0-0',
MODIFY `skill` varchar(70) DEFAULT '0-0;';

ALTER TABLE `custom_armorsets`
MODIFY `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
MODIFY `chest` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `legs` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `head` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `gloves` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `feet` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `skill` varchar(70) NOT NULL DEFAULT '0-0;',
MODIFY `shield` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `shield_skill_id` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `enchant6skill` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `mw_legs` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `mw_head` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `mw_gloves` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `mw_feet` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `mw_shield` smallint(5) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `custom_droplist`
MODIFY `mobId` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `itemId` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `min` int(8) unsigned NOT NULL DEFAULT '0',
MODIFY `max` int(8) unsigned NOT NULL DEFAULT '0',
MODIFY `category` smallint(3) NOT NULL DEFAULT '0',
MODIFY `chance` mediumint(7) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `custom_etcitem`
MODIFY `item_id` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `name` varchar(100) NOT NULL DEFAULT '',
MODIFY `additionalname` varchar(100) NOT NULL DEFAULT '',
MODIFY `crystallizable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `item_type` varchar(14) NOT NULL DEFAULT 'none',
MODIFY `weight` smallint(4) NOT NULL DEFAULT '0',
MODIFY `consume_type` varchar(9) NOT NULL DEFAULT 'normal',
MODIFY `material` varchar(11) NOT NULL DEFAULT 'wood',
MODIFY `crystal_type` varchar(4) NOT NULL DEFAULT 'none',
MODIFY `duration` mediumint(5) NOT NULL DEFAULT '-1',
MODIFY `time` mediumint(5) NOT NULL DEFAULT '-1',
MODIFY `price` int(10) unsigned NOT NULL DEFAULT '0',
MODIFY `crystal_count` smallint(4) unsigned NOT NULL DEFAULT '0',
MODIFY `sellable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `dropable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `destroyable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `tradeable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `depositable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `handler` varchar(70) NOT NULL DEFAULT 'none',
MODIFY `skill` varchar(70) NOT NULL DEFAULT '0-0;';

ALTER TABLE `custom_merchant_buylists`
MODIFY `item_id` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `price` int(10) NOT NULL DEFAULT '0',
MODIFY `shop_id` mediumint(7) unsigned NOT NULL DEFAULT '0',
MODIFY `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
MODIFY `count` tinyint(2) NOT NULL DEFAULT '-1',
MODIFY `currentCount` tinyint(2) NOT NULL DEFAULT '-1',
MODIFY `time` int(11) NOT NULL DEFAULT '0',
MODIFY `savetimer` decimal(20,0) NOT NULL DEFAULT '0';

ALTER TABLE `custom_merchant_shopids`
MODIFY `shop_id` mediumint(7) unsigned NOT NULL DEFAULT '0',
MODIFY `npc_id` varchar(5) DEFAULT NULL;

ALTER TABLE `custom_npc`
MODIFY `id` mediumint(7) unsigned NOT NULL DEFAULT '0',
MODIFY `idTemplate` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `name` varchar(200) NOT NULL DEFAULT '',
MODIFY `serverSideName` tinyint(1) NOT NULL DEFAULT '1',
MODIFY `title` varchar(45) NOT NULL DEFAULT '',
MODIFY `serverSideTitle` tinyint(1) NOT NULL DEFAULT '1',
MODIFY `class` varchar(200) DEFAULT NULL,
MODIFY `collision_radius` decimal(6,2) DEFAULT NULL,
MODIFY `collision_height` decimal(6,2) DEFAULT NULL,
MODIFY `level` tinyint(2) DEFAULT NULL,
MODIFY `sex` varchar(6) DEFAULT NULL,
MODIFY `type` varchar(22) DEFAULT NULL,
MODIFY `attackrange` smallint(4) DEFAULT NULL,
MODIFY `hp` decimal(8,0) DEFAULT NULL,
MODIFY `mp` decimal(8,0) DEFAULT NULL,
MODIFY `hpreg` decimal(6,2) DEFAULT NULL,
MODIFY `mpreg` decimal(6,2) DEFAULT NULL,
MODIFY `str` tinyint(2) NOT NULL DEFAULT '40',
MODIFY `con` tinyint(2) NOT NULL DEFAULT '43',
MODIFY `dex` tinyint(2) NOT NULL DEFAULT '30',
MODIFY `int` tinyint(2) NOT NULL DEFAULT '21',
MODIFY `wit` tinyint(2) NOT NULL DEFAULT '20',
MODIFY `men` tinyint(2) NOT NULL DEFAULT '20',
MODIFY `exp` int(9) NOT NULL DEFAULT '0',
MODIFY `sp` int(9) NOT NULL DEFAULT '0',
MODIFY `patk` mediumint(6) DEFAULT NULL,
MODIFY `pdef` mediumint(6) DEFAULT NULL,
MODIFY `matk` mediumint(6) DEFAULT NULL,
MODIFY `mdef` mediumint(6) DEFAULT NULL,
MODIFY `atkspd` smallint(4) NOT NULL DEFAULT '230',
MODIFY `aggro` smallint(4) NOT NULL DEFAULT '0',
MODIFY `matkspd` smallint(4) NOT NULL DEFAULT '333',
MODIFY `rhand` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `lhand` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `armor` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `enchant` tinyint(1) NOT NULL DEFAULT '0',
MODIFY `walkspd` smallint(3) NOT NULL DEFAULT '60',
MODIFY `runspd` smallint(3) NOT NULL DEFAULT '120',
MODIFY `isUndead` tinyint(1) NOT NULL DEFAULT '0',
MODIFY `dropHerbGroup` tinyint(1) NOT NULL DEFAULT '0',
MODIFY `basestats` tinyint(1) NOT NULL DEFAULT '0';

ALTER TABLE `custom_npcskills`
MODIFY `npcid` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `skillid` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `level` tinyint(2) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `custom_teleport`
MODIFY `Description` varchar(75) DEFAULT NULL,
MODIFY `id` mediumint(7) unsigned NOT NULL DEFAULT '0',
MODIFY `loc_x` mediumint(6) DEFAULT NULL,
MODIFY `loc_y` mediumint(6) DEFAULT NULL,
MODIFY `loc_z` mediumint(6) DEFAULT NULL,
MODIFY `price` int(10) unsigned DEFAULT NULL,
MODIFY `fornoble` tinyint(1) NOT NULL DEFAULT '0',
MODIFY `itemId` smallint(5) unsigned NOT NULL DEFAULT '57';

ALTER TABLE `custom_weapon`
MODIFY `item_id` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `name` varchar(120) NOT NULL DEFAULT '0',
MODIFY `additionalname` varchar(120) NOT NULL DEFAULT '',
MODIFY `bodypart` varchar(15) NOT NULL DEFAULT 'none',
MODIFY `crystallizable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `weight` smallint(4) NOT NULL DEFAULT '0',
MODIFY `soulshots` tinyint(1) unsigned NOT NULL DEFAULT '0',
MODIFY `spiritshots` tinyint(1) unsigned NOT NULL DEFAULT '0',
MODIFY `material` varchar(11) NOT NULL DEFAULT 'wood',
MODIFY `crystal_type` varchar(4) NOT NULL DEFAULT 'none',
MODIFY `p_dam` smallint(4) NOT NULL DEFAULT '0',
MODIFY `rnd_dam` smallint(3) NOT NULL DEFAULT '0',
MODIFY `weaponType` varchar(10) NOT NULL DEFAULT 'none',
MODIFY `critical` smallint(3) NOT NULL DEFAULT '0',
MODIFY `hit_modify` tinyint(2) NOT NULL DEFAULT '0',
MODIFY `avoid_modify` tinyint(2) NOT NULL DEFAULT '0',
MODIFY `shield_def` smallint(4) NOT NULL DEFAULT '0',
MODIFY `shield_def_rate` smallint(3) NOT NULL DEFAULT '0',
MODIFY `atk_speed` smallint(4) NOT NULL DEFAULT '0',
MODIFY `mp_consume` tinyint(1) NOT NULL DEFAULT '0',
MODIFY `m_dam` smallint(4) NOT NULL DEFAULT '0',
MODIFY `duration` mediumint(5) NOT NULL DEFAULT '-1',
MODIFY `time` mediumint(5) NOT NULL DEFAULT '-1',
MODIFY `price` int(10) unsigned NOT NULL DEFAULT '0',
MODIFY `crystal_count` smallint(4) unsigned NOT NULL DEFAULT '0',
MODIFY `sellable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `dropable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `destroyable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `tradeable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `depositable` enum('true','false') NOT NULL DEFAULT 'false',
MODIFY `enchant4_skill_id` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `enchant4_skill_lvl` tinyint(2) unsigned NOT NULL DEFAULT '0',
MODIFY `onCast_skill_id` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `onCast_skill_lvl` tinyint(2) unsigned NOT NULL DEFAULT '0',
MODIFY `onCast_skill_chance` smallint(3) NOT NULL DEFAULT '0',
MODIFY `onCrit_skill_id` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `onCrit_skill_lvl` tinyint(2) unsigned NOT NULL DEFAULT '0',
MODIFY `onCrit_skill_chance` smallint(3) NOT NULL DEFAULT '0',
MODIFY `change_weaponId` smallint(5) unsigned NOT NULL DEFAULT '0',
MODIFY `skill` varchar(70) NOT NULL DEFAULT '0-0;';