From ab16d3c465b2cef2c69b937b2e00224580e8d8fe Mon Sep 17 00:00:00 2001 From: Yohann Ferreira Date: Sat, 22 Jan 2011 01:02:20 +0100 Subject: Fix the default slot values when upgrading the database to version 14. Reviewed-by: Cody. Resolves: Mana-Mantis #284. --- src/sql/sqlite/updates/update_13_to_14.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/sql/sqlite') diff --git a/src/sql/sqlite/updates/update_13_to_14.sql b/src/sql/sqlite/updates/update_13_to_14.sql index a4c4a38..5066814 100644 --- a/src/sql/sqlite/updates/update_13_to_14.sql +++ b/src/sql/sqlite/updates/update_13_to_14.sql @@ -1,6 +1,6 @@ -- Add the slot column to table mana_characters -ALTER TABLE mana_characters ADD slot INTEGER NOT NULL; +ALTER TABLE mana_characters ADD slot INTEGER NOT NULL DEFAULT (0); -- Update the database version, and set date of update UPDATE mana_world_states -- cgit