Core/Misc: Change all unix time columns in character database to bigint (signed)

2 files changed, 140 insertions, 47 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 98bee12f448..7cdf50285d4 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -25,7 +25,7 @@ DROP TABLE IF EXISTS `account_data`;
 CREATE TABLE `account_data` (
   `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
   `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `time` int(10) unsigned NOT NULL DEFAULT '0',
+  `time` bigint(20) NOT NULL DEFAULT '0',
   `data` blob NOT NULL,
   PRIMARY KEY (`accountId`,`type`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -221,8 +221,8 @@ CREATE TABLE `auctionhouse` (
   `buyoutOrUnitPrice` bigint(20) unsigned NOT NULL DEFAULT '0',
   `deposit` bigint(20) unsigned NOT NULL DEFAULT '0',
   `bidAmount` bigint(20) unsigned NOT NULL DEFAULT '0',
-  `startTime` int(10) unsigned NOT NULL DEFAULT '0',
-  `endTime` int(10) unsigned NOT NULL DEFAULT '0',
+  `startTime` bigint(20) NOT NULL DEFAULT '0',
+  `endTime` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -246,7 +246,7 @@ DROP TABLE IF EXISTS `blackmarket_auctions`;
 CREATE TABLE `blackmarket_auctions` (
   `marketId` int(10) NOT NULL DEFAULT '0',
   `currentBid` bigint(20) unsigned NOT NULL DEFAULT '0',
-  `time` int(10) NOT NULL DEFAULT '0',
+  `time` bigint(20) NOT NULL DEFAULT '0',
   `numBids` int(10) NOT NULL DEFAULT '0',
   `bidder` bigint(20) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`marketId`)
@@ -300,9 +300,9 @@ CREATE TABLE `calendar_events` (
   `Description` varchar(255) NOT NULL DEFAULT '',
   `EventType` tinyint(1) unsigned NOT NULL DEFAULT '4',
   `TextureID` int(10) NOT NULL DEFAULT '-1',
-  `Date` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date` bigint(20) NOT NULL DEFAULT '0',
   `Flags` int(10) unsigned NOT NULL DEFAULT '0',
-  `LockDate` int(10) unsigned NOT NULL DEFAULT '0',
+  `LockDate` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`EventID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -329,7 +329,7 @@ CREATE TABLE `calendar_invites` (
   `Invitee` bigint(20) unsigned NOT NULL DEFAULT '0',
   `Sender` bigint(20) unsigned NOT NULL DEFAULT '0',
   `Status` tinyint(1) unsigned NOT NULL DEFAULT '0',
-  `ResponseTime` int(10) unsigned NOT NULL DEFAULT '0',
+  `ResponseTime` bigint(20) NOT NULL DEFAULT '0',
   `ModerationRank` tinyint(1) unsigned NOT NULL DEFAULT '0',
   `Note` varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`InviteID`)
@@ -359,7 +359,7 @@ CREATE TABLE `channels` (
   `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',
   `password` varchar(32) DEFAULT NULL,
   `bannedList` text,
-  `lastUsed` int(10) unsigned NOT NULL,
+  `lastUsed` bigint(20) unsigned NOT NULL,
   PRIMARY KEY (`name`,`team`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Channel System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -383,7 +383,7 @@ DROP TABLE IF EXISTS `character_account_data`;
 CREATE TABLE `character_account_data` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
   `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `time` int(10) unsigned NOT NULL DEFAULT '0',
+  `time` bigint(20) NOT NULL DEFAULT '0',
   `data` blob NOT NULL,
   PRIMARY KEY (`guid`,`type`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -408,7 +408,7 @@ DROP TABLE IF EXISTS `character_achievement`;
 CREATE TABLE `character_achievement` (
   `guid` bigint(20) unsigned NOT NULL,
   `achievement` int(10) unsigned NOT NULL,
-  `date` int(10) unsigned NOT NULL DEFAULT '0',
+  `date` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`achievement`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -433,7 +433,7 @@ CREATE TABLE `character_achievement_progress` (
   `guid` bigint(20) unsigned NOT NULL,
   `criteria` int(10) unsigned NOT NULL,
   `counter` bigint(20) unsigned NOT NULL,
-  `date` int(10) unsigned NOT NULL DEFAULT '0',
+  `date` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`criteria`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -597,8 +597,8 @@ DROP TABLE IF EXISTS `character_banned`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_banned` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `bandate` int(10) unsigned NOT NULL DEFAULT '0',
-  `unbandate` int(10) unsigned NOT NULL DEFAULT '0',
+  `bandate` bigint(20) NOT NULL DEFAULT '0',
+  `unbandate` bigint(20) NOT NULL DEFAULT '0',
   `bannedby` varchar(50) NOT NULL,
   `banreason` varchar(255) NOT NULL,
   `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
@@ -939,7 +939,7 @@ CREATE TABLE `character_garrison_buildings` (
   `guid` bigint(20) unsigned NOT NULL,
   `plotInstanceId` int(10) unsigned NOT NULL DEFAULT '0',
   `buildingId` int(10) unsigned NOT NULL DEFAULT '0',
-  `timeBuilt` bigint(20) unsigned NOT NULL,
+  `timeBuilt` bigint(20) NOT NULL,
   `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`plotInstanceId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -1250,7 +1250,7 @@ CREATE TABLE `character_queststatus` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
   `quest` int(10) unsigned NOT NULL DEFAULT '0',
   `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `timer` int(10) unsigned NOT NULL DEFAULT '0',
+  `timer` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`quest`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1274,7 +1274,7 @@ DROP TABLE IF EXISTS `character_queststatus_daily`;
 CREATE TABLE `character_queststatus_daily` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
   `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
-  `time` int(10) unsigned NOT NULL DEFAULT '0',
+  `time` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`quest`),
   KEY `idx_guid` (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
@@ -1372,7 +1372,7 @@ CREATE TABLE `character_queststatus_objectives_criteria_progress` (
   `guid` bigint(20) unsigned NOT NULL,
   `criteriaId` int(10) unsigned NOT NULL,
   `counter` bigint(20) unsigned NOT NULL,
-  `date` int(10) unsigned NOT NULL DEFAULT '0',
+  `date` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`criteriaId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1570,8 +1570,8 @@ DROP TABLE IF EXISTS `character_spell_charges`;
 CREATE TABLE `character_spell_charges` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
   `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier',
-  `rechargeStart` int(10) unsigned NOT NULL DEFAULT '0',
-  `rechargeEnd` int(10) unsigned NOT NULL DEFAULT '0',
+  `rechargeStart` bigint(20) NOT NULL DEFAULT '0',
+  `rechargeEnd` bigint(20) NOT NULL DEFAULT '0',
   KEY `idx_guid` (`guid`) USING BTREE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1596,9 +1596,9 @@ CREATE TABLE `character_spell_cooldown` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
   `spell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
   `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier',
-  `time` int(10) unsigned NOT NULL DEFAULT '0',
+  `time` bigint(20) NOT NULL DEFAULT '0',
   `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id',
-  `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0',
+  `categoryEnd` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`spell`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1806,11 +1806,11 @@ CREATE TABLE `characters` (
   `cinematic` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `totaltime` int(10) unsigned NOT NULL DEFAULT '0',
   `leveltime` int(10) unsigned NOT NULL DEFAULT '0',
-  `logout_time` int(10) unsigned NOT NULL DEFAULT '0',
+  `logout_time` bigint(20) NOT NULL DEFAULT '0',
   `is_logout_resting` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `rest_bonus` float NOT NULL DEFAULT '0',
   `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0',
-  `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0',
+  `resettalents_time` bigint(20) NOT NULL DEFAULT '0',
   `numRespecs` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `primarySpecialization` int(10) unsigned NOT NULL DEFAULT '0',
   `trans_x` float NOT NULL DEFAULT '0',
@@ -1822,7 +1822,7 @@ CREATE TABLE `characters` (
   `stable_slots` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `at_login` smallint(5) unsigned NOT NULL DEFAULT '0',
   `zone` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `death_expire_time` int(10) unsigned NOT NULL DEFAULT '0',
+  `death_expire_time` bigint(20) NOT NULL DEFAULT '0',
   `taxi_path` text,
   `totalKills` int(10) unsigned NOT NULL DEFAULT '0',
   `todayKills` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1846,7 +1846,7 @@ CREATE TABLE `characters` (
   `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `deleteInfos_Account` int(10) unsigned DEFAULT NULL,
   `deleteInfos_Name` varchar(12) DEFAULT NULL,
-  `deleteDate` int(10) unsigned DEFAULT NULL,
+  `deleteDate` bigint(20) DEFAULT NULL,
   `honor` int(10) unsigned NOT NULL DEFAULT '0',
   `honorLevel` int(10) unsigned NOT NULL DEFAULT '1',
   `honorRestState` tinyint(3) unsigned NOT NULL DEFAULT '2',
@@ -1964,7 +1964,7 @@ DROP TABLE IF EXISTS `creature_respawn`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `creature_respawn` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `respawnTime` bigint(20) NOT NULL DEFAULT '0',
   `mapId` smallint(10) unsigned NOT NULL DEFAULT '0',
   `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
   PRIMARY KEY (`guid`,`instanceId`),
@@ -2015,7 +2015,7 @@ DROP TABLE IF EXISTS `game_event_save`;
 CREATE TABLE `game_event_save` (
   `eventEntry` tinyint(3) unsigned NOT NULL,
   `state` tinyint(3) unsigned NOT NULL DEFAULT '1',
-  `next_start` int(10) unsigned NOT NULL DEFAULT '0',
+  `next_start` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`eventEntry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2038,7 +2038,7 @@ DROP TABLE IF EXISTS `gameobject_respawn`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `gameobject_respawn` (
   `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `respawnTime` bigint(20) NOT NULL DEFAULT '0',
   `mapId` smallint(10) unsigned NOT NULL DEFAULT '0',
   `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
   PRIMARY KEY (`guid`,`instanceId`),
@@ -2066,7 +2066,7 @@ CREATE TABLE `gm_bug` (
   `id` int(10) unsigned NOT NULL,
   `playerGuid` bigint(20) unsigned NOT NULL,
   `note` text NOT NULL,
-  `createTime` int(10) unsigned NOT NULL DEFAULT '0',
+  `createTime` bigint(20) NOT NULL DEFAULT '0',
   `mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
   `posX` float NOT NULL DEFAULT '0',
   `posY` float NOT NULL DEFAULT '0',
@@ -2099,7 +2099,7 @@ CREATE TABLE `gm_complaint` (
   `id` int(10) unsigned NOT NULL,
   `playerGuid` bigint(20) unsigned NOT NULL,
   `note` text NOT NULL,
-  `createTime` int(10) unsigned NOT NULL DEFAULT '0',
+  `createTime` bigint(20) NOT NULL DEFAULT '0',
   `mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
   `posX` float NOT NULL DEFAULT '0',
   `posY` float NOT NULL DEFAULT '0',
@@ -2134,7 +2134,7 @@ DROP TABLE IF EXISTS `gm_complaint_chatlog`;
 CREATE TABLE `gm_complaint_chatlog` (
   `complaintId` int(10) unsigned NOT NULL,
   `lineId` int(10) unsigned NOT NULL,
-  `timestamp` int(10) unsigned NOT NULL,
+  `timestamp` bigint(20) NOT NULL,
   `text` text NOT NULL,
   PRIMARY KEY (`complaintId`,`lineId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -2160,7 +2160,7 @@ CREATE TABLE `gm_suggestion` (
   `id` int(10) unsigned NOT NULL,
   `playerGuid` bigint(20) unsigned NOT NULL,
   `note` text NOT NULL,
-  `createTime` int(10) unsigned NOT NULL DEFAULT '0',
+  `createTime` bigint(20) NOT NULL DEFAULT '0',
   `mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
   `posX` float NOT NULL DEFAULT '0',
   `posY` float NOT NULL DEFAULT '0',
@@ -2316,7 +2316,7 @@ DROP TABLE IF EXISTS `guild_achievement`;
 CREATE TABLE `guild_achievement` (
   `guildId` bigint(20) unsigned NOT NULL,
   `achievement` int(10) unsigned NOT NULL,
-  `date` int(10) unsigned NOT NULL DEFAULT '0',
+  `date` bigint(20) NOT NULL DEFAULT '0',
   `guids` text NOT NULL,
   PRIMARY KEY (`guildId`,`achievement`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -2342,7 +2342,7 @@ CREATE TABLE `guild_achievement_progress` (
   `guildId` bigint(20) unsigned NOT NULL,
   `criteria` int(10) unsigned NOT NULL,
   `counter` bigint(20) unsigned NOT NULL,
-  `date` int(10) unsigned NOT NULL DEFAULT '0',
+  `date` bigint(20) NOT NULL DEFAULT '0',
   `completedGuid` bigint(20) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guildId`,`criteria`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -2373,7 +2373,7 @@ CREATE TABLE `guild_bank_eventlog` (
   `ItemOrMoney` bigint(20) unsigned NOT NULL DEFAULT '0',
   `ItemStackCount` smallint(5) unsigned NOT NULL DEFAULT '0',
   `DestTabId` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id',
-  `TimeStamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time',
+  `TimeStamp` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time',
   PRIMARY KEY (`guildid`,`LogGuid`,`TabId`),
   KEY `guildid_key` (`guildid`),
   KEY `Idx_PlayerGuid` (`PlayerGuid`),
@@ -2485,7 +2485,7 @@ CREATE TABLE `guild_eventlog` (
   `PlayerGuid1` bigint(20) unsigned NOT NULL COMMENT 'Player 1',
   `PlayerGuid2` bigint(20) unsigned NOT NULL COMMENT 'Player 2',
   `NewRank` tinyint(3) unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)',
-  `TimeStamp` int(10) unsigned NOT NULL COMMENT 'Event UNIX time',
+  `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time',
   PRIMARY KEY (`guildid`,`LogGuid`),
   KEY `Idx_PlayerGuid1` (`PlayerGuid1`),
   KEY `Idx_PlayerGuid2` (`PlayerGuid2`),
@@ -2516,7 +2516,7 @@ CREATE TABLE `guild_finder_applicant` (
   `classRole` tinyint(3) unsigned DEFAULT '0',
   `interests` tinyint(3) unsigned DEFAULT '0',
   `comment` varchar(255) DEFAULT NULL,
-  `submitTime` int(10) unsigned DEFAULT NULL,
+  `submitTime` bigint(20) DEFAULT NULL,
   PRIMARY KEY (`guildId`,`playerGuid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2631,7 +2631,7 @@ CREATE TABLE `guild_newslog` (
   `PlayerGuid` bigint(20) unsigned NOT NULL DEFAULT '0',
   `Flags` int(10) unsigned NOT NULL DEFAULT '0',
   `Value` int(10) unsigned NOT NULL DEFAULT '0',
-  `TimeStamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time',
+  `TimeStamp` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time',
   PRIMARY KEY (`guildid`,`LogGuid`),
   KEY `guildid_key` (`guildid`),
   KEY `Idx_PlayerGuid` (`PlayerGuid`),
@@ -2685,7 +2685,7 @@ DROP TABLE IF EXISTS `instance`;
 CREATE TABLE `instance` (
   `id` int(10) unsigned NOT NULL DEFAULT '0',
   `map` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `resettime` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `resettime` bigint(20) NOT NULL DEFAULT '0',
   `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `completedEncounters` int(10) unsigned NOT NULL DEFAULT '0',
   `data` tinytext NOT NULL,
@@ -2716,7 +2716,7 @@ DROP TABLE IF EXISTS `instance_reset`;
 CREATE TABLE `instance_reset` (
   `mapid` smallint(5) unsigned NOT NULL DEFAULT '0',
   `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `resettime` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `resettime` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`mapid`,`difficulty`),
   KEY `difficulty` (`difficulty`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -2892,7 +2892,7 @@ CREATE TABLE `instance_scenario_progress` (
   `id` int(10) unsigned NOT NULL,
   `criteria` int(10) unsigned NOT NULL,
   `counter` bigint(20) unsigned NOT NULL,
-  `date` int(10) unsigned NOT NULL DEFAULT '0',
+  `date` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`criteria`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3353,8 +3353,8 @@ CREATE TABLE `mail` (
   `subject` longtext,
   `body` longtext,
   `has_items` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `expire_time` int(10) unsigned NOT NULL DEFAULT '0',
-  `deliver_time` int(10) unsigned NOT NULL DEFAULT '0',
+  `expire_time` bigint(20) NOT NULL DEFAULT '0',
+  `deliver_time` bigint(20) NOT NULL DEFAULT '0',
   `money` bigint(20) unsigned NOT NULL DEFAULT '0',
   `cod` bigint(20) unsigned NOT NULL DEFAULT '0',
   `checked` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -3491,8 +3491,8 @@ DROP TABLE IF EXISTS `pet_spell_charges`;
 CREATE TABLE `pet_spell_charges` (
   `guid` int(10) unsigned NOT NULL,
   `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier',
-  `rechargeStart` int(10) unsigned NOT NULL DEFAULT '0',
-  `rechargeEnd` int(10) unsigned NOT NULL DEFAULT '0',
+  `rechargeStart` bigint(20) NOT NULL DEFAULT '0',
+  `rechargeEnd` bigint(20) NOT NULL DEFAULT '0',
   KEY `idx_guid` (`guid`) USING BTREE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3516,9 +3516,9 @@ DROP TABLE IF EXISTS `pet_spell_cooldown`;
 CREATE TABLE `pet_spell_cooldown` (
   `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
   `spell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
-  `time` int(10) unsigned NOT NULL DEFAULT '0',
+  `time` bigint(20) NOT NULL DEFAULT '0',
   `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id',
-  `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0',
+  `categoryEnd` bigint(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`spell`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/characters/master/2021_04_05_00_charactrers.sql b/sql/updates/characters/master/2021_04_05_00_charactrers.sql
new file mode 100644
index 00000000000..5b66a62f108
--- /dev/null
+++ b/sql/updates/characters/master/2021_04_05_00_charactrers.sql
@@ -0,0 +1,93 @@
+ALTER TABLE `account_data` MODIFY `time` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `account_instance_times` MODIFY `releaseTime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `auctionhouse`
+  MODIFY `startTime` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `endTime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `blackmarket_auctions` MODIFY `time` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `calendar_events`
+  MODIFY `Date` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `LockDate` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `calendar_invites` MODIFY `ResponseTime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `channels` MODIFY `lastUsed` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_account_data` MODIFY `time` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_achievement` MODIFY `date` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_achievement_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_banned`
+  MODIFY `bandate` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `unbandate` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_garrison_buildings` MODIFY `timeBuilt` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_queststatus` MODIFY `timer` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_queststatus_daily` MODIFY `time` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_queststatus_objectives_criteria_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_spell_charges`
+  MODIFY `rechargeStart` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `rechargeEnd` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `character_spell_cooldown`
+  MODIFY `time` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `categoryEnd` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `characters`
+  MODIFY `logout_time` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `resettalents_time` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `death_expire_time` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `deleteDate` bigint(20) unsigned DEFAULT NULL;
+
+ALTER TABLE `creature_respawn` MODIFY `respawnTime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `game_event_save` MODIFY `next_start` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `gameobject_respawn` MODIFY `respawnTime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `gm_bug` MODIFY `createTime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `gm_complaint` MODIFY `createTime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `gm_complaint_chatlog` MODIFY `timestamp` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `gm_suggestion` MODIFY `createTime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `guild_achievement` MODIFY `date` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `guild_achievement_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `guild_bank_eventlog` MODIFY `TimeStamp` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time';
+
+ALTER TABLE `guild_eventlog` MODIFY `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time';
+
+ALTER TABLE `guild_finder_applicant` MODIFY `submitTime` bigint(20) DEFAULT NULL;
+
+ALTER TABLE `guild_newslog` MODIFY `TimeStamp` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time';
+
+ALTER TABLE `instance` MODIFY `resettime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `instance_reset` MODIFY `resettime` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `instance_scenario_progress` MODIFY `date` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `mail`
+  MODIFY `expire_time` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `deliver_time` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `pet_spell_charges`
+  MODIFY `rechargeStart` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `rechargeEnd` bigint(20) NOT NULL DEFAULT '0';
+
+ALTER TABLE `pet_spell_cooldown`
+  MODIFY `time` bigint(20) NOT NULL DEFAULT '0',
+  MODIFY `categoryEnd` bigint(20) NOT NULL DEFAULT '0';