[8409] Fixed guild creation date loading, and added another guild loading optimization - last one.

    Signed-off-by: Triply <triply@getmangos.com>

--HG--
branch : trunk

2 files changed, 19 insertions, 2 deletions

diff --git a/sql/characters.sql b/sql/characters.sql
index 870545cc065..b431c09e800 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -23,7 +23,7 @@
 
 DROP TABLE IF EXISTS `character_db_version`;
 CREATE TABLE `character_db_version` (
-  `required_8402_02_characters_guild_bank_eventlog` bit(1) default NULL
+  `required_8409_01_characters_guild` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
 
 --
@@ -1117,7 +1117,7 @@ CREATE TABLE `guild` (
   `BackgroundColor` int(5) NOT NULL default '0',
   `info` text NOT NULL,
   `motd` varchar(255) NOT NULL default '',
-  `createdate` datetime default NULL,
+  `createdate` bigint(20) NOT NULL default '0',
   `BankMoney` bigint(20) NOT NULL default '0',
   PRIMARY KEY  (`guildid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
diff --git a/sql/updates/5360_8409_characters_guild.sql b/sql/updates/5360_8409_characters_guild.sql
new file mode 100644
index 00000000000..db517e723b6
--- /dev/null
+++ b/sql/updates/5360_8409_characters_guild.sql
@@ -0,0 +1,17 @@
+-- ALTER TABLE character_db_version CHANGE COLUMN required_8402_02_characters_guild_bank_eventlog required_8409_01_characters_guild bit;
+
+
+-- Change createdate column type from datetime to bigint(20)
+
+-- add temporary column
+ALTER TABLE guild ADD COLUMN created_temp bigint(20) default '0';
+-- update temporary columns data
+UPDATE guild SET created_temp = UNIX_TIMESTAMP(createdate);
+-- drop current column
+ALTER TABLE guild DROP COLUMN createdate;
+-- create new column with correct type
+ALTER TABLE guild ADD COLUMN createdate bigint(20) NOT NULL default '0' AFTER motd;
+-- copy data to new column
+UPDATE guild set createdate = created_temp;
+-- remove old column
+ALTER TABLE guild DROP COLUMN created_temp;
\ No newline at end of file