diff options
author | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2010-12-29 07:41:49 +0100 |
---|---|---|
committer | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2010-12-29 07:41:49 +0100 |
commit | 5f03e73484a50c9689956b32ef97630b56d2a00d (patch) | |
tree | ca6d3d7467d4582a2f64be4a45c056f55642fd17 /src/sql/mysql/updates/update_13_to_14.sql | |
parent | 4ead8e0b6af924132a6fb227325a868db0df335c (diff) | |
download | manaserv-5f03e73484a50c9689956b32ef97630b56d2a00d.tar.gz manaserv-5f03e73484a50c9689956b32ef97630b56d2a00d.tar.bz2 manaserv-5f03e73484a50c9689956b32ef97630b56d2a00d.tar.xz manaserv-5f03e73484a50c9689956b32ef97630b56d2a00d.zip |
Made the server handle properly the characters slots.
I turned the vector storing character data into a map,
keeping the character's slot.
Fixed a memleak along the way.
Reviewed-by: Crush.
Diffstat (limited to 'src/sql/mysql/updates/update_13_to_14.sql')
-rw-r--r-- | src/sql/mysql/updates/update_13_to_14.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/sql/mysql/updates/update_13_to_14.sql b/src/sql/mysql/updates/update_13_to_14.sql new file mode 100644 index 00000000..ea5b7e25 --- /dev/null +++ b/src/sql/mysql/updates/update_13_to_14.sql @@ -0,0 +1,11 @@ +-- +-- Modify the table `mana_characters` to add the slot field. +-- + +ALTER TABLE `mana_characters` ADD COLUMN `slot` smallint(5) unsigned NOT NULL; + +-- Update database version. +UPDATE mana_world_states +SET value = '14', +moddate = UNIX_TIMESTAMP() +WHERE state_name = 'database_version'; |