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

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

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

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

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

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

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

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