From 4a1a82c5e223ab5fa35ae898783c7771fc73fef4 Mon Sep 17 00:00:00 2001 From: megamage Date: Mon, 24 Aug 2009 20:25:32 -0500 Subject: [8409] Fixed guild creation date loading, and added another guild loading optimization - last one. Signed-off-by: Triply --HG-- branch : trunk --- sql/characters.sql | 4 ++-- sql/updates/5360_8409_characters_guild.sql | 17 +++++++++++++++++ 2 files changed, 19 insertions(+), 2 deletions(-) create mode 100644 sql/updates/5360_8409_characters_guild.sql (limited to 'sql') 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 -- cgit v1.2.3