l2j-server-datapack/L2J_DataPack_BETA/dist/sql/game/updates/20110316update.sql

ALTER TABLE `auction`
MODIFY `endDate` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `auction_bid`
MODIFY `time_bid` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `castle`
MODIFY `siegeDate` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `regTimeEnd` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `castle_functions`
MODIFY `endTime` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `character_instance_time`
MODIFY `time` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `character_offline_trade`
MODIFY `time` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `character_skills_save`
MODIFY `systime` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `character_reco_bonus`
MODIFY `time_left` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `characters`
MODIFY `deletetime` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `lastAccess` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `clan_join_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `clan_create_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `createTime` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `clan_data`
MODIFY `ally_penalty_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `char_penalty_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `dissolving_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `clanhall`
MODIFY `paidUntil` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `clanhall_functions`
MODIFY `endTime` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `cursed_weapons`
MODIFY `endTime` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `fort`
MODIFY `siegeDate` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `lastOwnedTime` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `fort_functions`
MODIFY `endTime` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `grandboss_data`
MODIFY `respawn_time` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `games`
MODIFY `enddate` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `global_tasks`
MODIFY `last_activation` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `heroes_diary`
MODIFY `time` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `item_auction`
MODIFY `startingTime` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `endingTime` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `itemsonground`
MODIFY `drop_time` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `messages`
MODIFY `expiration` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `merchant_buylists`
MODIFY `savetimer` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `olympiad_data`
MODIFY `olympiad_end` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `validation_end` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `next_weekly_change` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `olympiad_fights`
MODIFY `start` bigint(13) unsigned NOT NULL DEFAULT '0',
MODIFY `time` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `posts`
MODIFY `post_date` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `raidboss_spawnlist`
MODIFY `respawn_time` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `seven_signs_festival`
MODIFY `date` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `seven_signs_status`
MODIFY `date` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `topic`
MODIFY `topic_date` bigint(13) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `custom_merchant_buylists`
MODIFY `savetimer` bigint(13) unsigned NOT NULL DEFAULT '0';