Hatte ich das richtig verstanden das diese Updats nur gemacht werden sollen wenn man kein innoDB verwendet?
[SPOILER]Revision: f7af49291bea4497082e62e11480cd070495210e
Author: leak
Date: 20.01.2011 02:11:49
Message:
SQL: Characters db storage type cleanup No. 7 (final) - Note:
-
It is strongly recommended to extensively test the recent changes before applying them to live data
-
To fully resync the character db layout with TC releases it is recommended to dump the characters table with
mysqldump --no-data characters > characters_database_livedata.sql
and use a diff tool to compare it against sql/base/characters_database.sql
Modified : sql/base/characters_database.sql
Added : sql/updates/2011_01_20_0_characters_item_soulbound_trace_data.sql
Added : sql/updates/2011_01_20_0_characters_lag_reports.sql
Added : sql/updates/2011_01_20_0_characters_mail.sql
Added : sql/updates/2011_01_20_0_characters_mail_items.sql
Added : sql/updates/2011_01_20_0_characters_pet_aura.sql
Added : sql/updates/2011_01_20_0_characters_pet_spell.sql
Added : sql/updates/2011_01_20_0_characters_pet_spell_cooldown.sql
Added : sql/updates/2011_01_20_0_characters_petition.sql
Added : sql/updates/2011_01_20_0_characters_petition_sign.sql
Added : sql/updates/2011_01_20_0_characters_worldstates.sql
Modified : src/server/game/Entities/Pet/Pet.cpp
Modified : src/server/game/Entities/Player/Player.cpp
Modified : src/server/game/Globals/ObjectMgr.cpp
Modified : src/server/game/Server/Protocol/Handlers/PetitionsHandler.cpp
Modified : src/server/game/World/World.cpp
Revision: c59ea4726e078a844f465407e5d893a1afee06fb
Author: leak
Date: 20.01.2011 01:02:24
Message:
SQL: Characters db storage type cleanup No. 6
Modified : sql/base/characters_database.sql
Added : sql/updates/2011_01_20_0_characters_guild_bank_item.sql
Added : sql/updates/2011_01_20_0_characters_guild_bank_right.sql
Added : sql/updates/2011_01_20_0_characters_guild_bank_tab.sql
Added : sql/updates/2011_01_20_0_characters_guild_eventlog.sql
Added : sql/updates/2011_01_20_0_characters_guild_member.sql
Added : sql/updates/2011_01_20_0_characters_guild_rank.sql
Added : sql/updates/2011_01_20_0_characters_instance.sql
Added : sql/updates/2011_01_20_0_characters_instance_reset.sql
Added : sql/updates/2011_01_20_0_characters_item_instance.sql
Added : sql/updates/2011_01_20_0_characters_item_refund_instance.sql
Modified : src/server/game/Entities/Item/Item.cpp
Modified : src/server/game/Entities/Player/Player.cpp
Modified : src/server/game/Guilds/Guild.cpp
Modified : src/server/game/Instances/InstanceSaveMgr.cpp
Revision: a486eb0c2fcc6bb43693e3c5404f8f82988e2531
Author: leak
Date: 20.01.2011 00:08:45
Message:
SQL: Characters db storage type cleanup No. 5
Modified : sql/base/characters_database.sql
Added : sql/updates/2011_01_20_0_characters_game_event_save.sql
Added : sql/updates/2011_01_20_0_characters_gameobject_respawn.sql
Added : sql/updates/2011_01_20_0_characters_gm_subsurveys.sql
Added : sql/updates/2011_01_20_0_characters_gm_surveys.sql
Added : sql/updates/2011_01_20_0_characters_gm_tickets.sql
Added : sql/updates/2011_01_20_0_characters_group_instance.sql
Added : sql/updates/2011_01_20_0_characters_group_member.sql
Added : sql/updates/2011_01_20_0_characters_groups.sql
Added : sql/updates/2011_01_20_0_characters_guild.sql
Added : sql/updates/2011_01_20_0_characters_guild_bank_eventlog.sql
Modified : src/server/game/Events/GameEventMgr.cpp
Modified : src/server/game/Globals/ObjectMgr.cpp
Modified : src/server/game/Guilds/Guild.cpp
Modified : src/server/game/Server/Protocol/Handlers/TicketHandler.cpp
Modified : src/server/game/Tickets/TicketMgr.cpp
Revision: a7df9ddff1a4dc24d02e0c28276ff7a5f18dd764
Author: leak
Date: 19.01.2011 22:46:21
Message:
SQL: Characters db storage type cleanup No. 4
Modified : sql/base/characters_database.sql
Added : sql/updates/2011_01_19_0_characters_character_social.sql
Added : sql/updates/2011_01_19_0_characters_character_spell.sql
Added : sql/updates/2011_01_19_0_characters_character_spell_cooldown.sql
Added : sql/updates/2011_01_19_0_characters_character_stats.sql
Added : sql/updates/2011_01_19_0_characters_character_talent.sql
Added : sql/updates/2011_01_19_0_characters_character_tutorial.sql
Added : sql/updates/2011_01_19_0_characters_characters.sql
Added : sql/updates/2011_01_19_0_characters_corpse.sql
Added : sql/updates/2011_01_19_0_characters_creature_respawn.sql
Added : sql/updates/2011_01_19_0_characters_game_event_condition_save.sql
Modified : src/server/game/Entities/Corpse/Corpse.cpp
Modified : src/server/game/Entities/Player/Player.cpp
Modified : src/server/game/Globals/ObjectMgr.cpp
Modified : src/server/game/Guilds/Guild.cpp
Modified : src/server/game/Instances/InstanceSaveMgr.cpp
Modified : src/server/game/Server/Protocol/Handlers/CharacterHandler.cpp
Modified : src/server/scripts/Commands/cs_account.cpp
Modified : src/server/worldserver/CommandLine/CliRunnable.cpp
Revision: 471b6f138d3025a01c5410f19862f8ee05c4007d
Author: leak
Date: 19.01.2011 18:40:36
Message:
SQL: Characters db storage type cleanup No. 3 - Note:
There is a chance that you will be getting importing errors / data truncation warnings because of ancient invalid pet names.
SELECT * FROM character_pet WHERE CHAR_LENGTH(name) > 21;
Modified : sql/base/characters_database.sql
Added : sql/updates/2011_01_19_0_characters_character_homebind.sql
Added : sql/updates/2011_01_19_0_characters_character_instance.sql
Added : sql/updates/2011_01_19_0_characters_character_inventory.sql
Added : sql/updates/2011_01_19_0_characters_character_pet.sql
Added : sql/updates/2011_01_19_0_characters_character_pet_declinedname.sql
Added : sql/updates/2011_01_19_0_characters_character_queststatus.sql
Added : sql/updates/2011_01_19_0_characters_character_queststatus_daily.sql
Added : sql/updates/2011_01_19_0_characters_character_queststatus_weekly.sql
Added : sql/updates/2011_01_19_0_characters_character_reputation.sql
Added : sql/updates/2011_01_19_0_characters_character_skills.sql
Modified : src/server/game/Entities/Pet/Pet.cpp
Modified : src/server/game/Entities/Player/Player.cpp
Modified : src/server/game/Reputation/ReputationMgr.cpp
Modified : src/server/game/Server/Protocol/Handlers/NPCHandler.cpp
Modified : src/server/game/World/World.cpp
Revision: c306acf298ade5547512e04351a8f9ae4fdbae6d
Author: leak
Date: 19.01.2011 14:04:33
Message:
SQL: Characters db storage type cleanup No. 2
Modified : sql/base/characters_database.sql
Deleted : sql/updates/2011_01_19_0_characters_bug_report.sql
Added : sql/updates/2011_01_19_0_characters_character_action.sql
Added : sql/updates/2011_01_19_0_characters_character_arena_stats.sql
Added : sql/updates/2011_01_19_0_characters_character_aura.sql
Added : sql/updates/2011_01_19_0_characters_character_banned.sql
Added : sql/updates/2011_01_19_0_characters_character_battleground_data.sql
Added : sql/updates/2011_01_19_0_characters_character_battleground_random.sql
Added : sql/updates/2011_01_19_0_characters_character_declinedname.sql
Added : sql/updates/2011_01_19_0_characters_character_equipmentsets.sql
Added : sql/updates/2011_01_19_0_characters_character_gifts.sql
Added : sql/updates/2011_01_19_0_characters_character_glyphs.sql
Modified : src/server/game/Chat/Commands/Level3.cpp
Modified : src/server/game/Entities/Player/Player.cpp
Revision: b8210f4396cd266137ad69ea0ae4efe715072926
Author: leak
Date: 19.01.2011 02:53:44
Message:
SQL: Characters db storage type cleanup #1 - Note:
-
MySQL numeric types can NOT be altered in value range or or storage size at all, so things like INT(32) are entirely pointless. As TC currently doesn’t use the display width of numeric types, use the default width to avoid confusion. (see MySQL numeric types docs)
-
Timestamps can be stored as INT(10) UNSIGNED. As the max value of this type is 4294967295 which translates into year 2106 using it as timestamp we are NOT affected by the year 2038 bug. If the timestamp needs to be negative in some cases, i.e. for displaying infinity using -1, use BIGINT(20) instead.
-
Do NOT set ROW_FORMAT for InnoDB tables unless you specifically want COMPRESSED tables (which we don’t for performance reasons). MySQL will chose the appropriate ROW_FORMAT by itself depending on the innodb_file_format setting of the server. (FIXED is only available for MyISAM)
-
Even though VARCHAR does require less storage space than CHAR for values with variable length, the length still needs to be chosen wisely as this doesn’t apply to memory consumption.
Modified : sql/base/characters_database.sql
Added : sql/updates/2011_01_19_0_characters_account_data.sql
Added : sql/updates/2011_01_19_0_characters_addons.sql
Added : sql/updates/2011_01_19_0_characters_arena_team.sql
Added : sql/updates/2011_01_19_0_characters_auctionhouse.sql
Added : sql/updates/2011_01_19_0_characters_bug_report.sql
Added : sql/updates/2011_01_19_0_characters_bugreport.sql
Added : sql/updates/2011_01_19_0_characters_channels.sql
Added : sql/updates/2011_01_19_0_characters_character_account_data.sql
Added : sql/updates/2011_01_19_0_characters_character_achievement.sql
Added : sql/updates/2011_01_19_0_characters_character_achievement_progress.sql
Modified : src/server/game/Achievements/AchievementMgr.cpp
Modified : src/server/game/Battlegrounds/ArenaTeam.cpp
Modified : src/server/game/Server/WorldSession.cpp
[/SPOILER]