diff options
| author | Spp <spp@jorge.gr> | 2012-11-07 23:21:19 +0100 |
|---|---|---|
| committer | Spp <spp@jorge.gr> | 2012-11-07 23:21:19 +0100 |
| commit | 9659f0335f3dad4cf84dca70fa436cb4b214ba39 (patch) | |
| tree | 93e93eedb1e0bf0e8126a002892acab1e4ce2279 /sql | |
| parent | 06eff945065b65cf707837eca6c940ecbf8c7122 (diff) | |
Core/Guilds: Multiple changes
- Fix Delete Rank
- Fix Rank order after Rank is deleted
- Send correct event after Guild Tab purchase
- Better debug msgs
- Move news to Event Logs (internal struct is like Event Logs and Bank Event Logs). Max news configurable
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/characters/2012_11_07_00_characters_guild_newslog_434.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/characters/2012_11_07_00_characters_guild_newslog_434.sql b/sql/updates/characters/2012_11_07_00_characters_guild_newslog_434.sql new file mode 100644 index 00000000000..1504bd3b6e5 --- /dev/null +++ b/sql/updates/characters/2012_11_07_00_characters_guild_newslog_434.sql @@ -0,0 +1,21 @@ +-- Rename table and column to fit the other guild_*log tables and columns and create indexes +RENAME TABLE `guild_news_log` TO `guild_newslog`; + +ALTER TABLE `guild_newslog` +CHANGE COLUMN `guild` `guildid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator', +CHANGE COLUMN `id` `LogGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column', +CHANGE COLUMN `eventType` `EventType` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Event type', +CHANGE COLUMN `playerGuid` `PlayerGuid` int(10) unsigned NOT NULL DEFAULT '0', +CHANGE COLUMN `data` `Value` int(10) unsigned NOT NULL DEFAULT '0', +CHANGE COLUMN `flags` `Flags` int(10) unsigned NOT NULL DEFAULT '0' AFTER `PlayerGuid`, +CHANGE COLUMN `date` `TimeStamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', +ADD KEY `guildid_key` (`guildid`), +ADD KEY `Idx_PlayerGuid` (`PlayerGuid`), +ADD KEY `Idx_LogGuid` (`LogGuid`); + +-- Create missing tabs + +ALTER TABLE `guild_member_withdraw` +ADD COLUMN `tab6` int(10) unsigned NOT NULL DEFAULT '0' AFTER `tab5`, +ADD COLUMN `tab7` int(10) unsigned NOT NULL DEFAULT '0' AFTER `tab6`; + |