summaryrefslogtreecommitdiff
path: root/src/sql/mysql/updates/update_13_to_14.sql
diff options
context:
space:
mode:
authorYohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>2010-12-29 07:41:49 +0100
committerYohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>2010-12-29 07:41:49 +0100
commit5f03e73484a50c9689956b32ef97630b56d2a00d (patch)
treeca6d3d7467d4582a2f64be4a45c056f55642fd17 /src/sql/mysql/updates/update_13_to_14.sql
parent4ead8e0b6af924132a6fb227325a868db0df335c (diff)
downloadmanaserv-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.sql11
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';