diff options
| author | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2011-01-22 01:02:20 +0100 |
|---|---|---|
| committer | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2011-01-22 01:02:20 +0100 |
| commit | ab16d3c465b2cef2c69b937b2e00224580e8d8fe (patch) | |
| tree | 607dfee347f34a297f730d56f7afd72b63d47cc4 /src/sql/mysql/updates | |
| parent | 968815437750fd1b76cb78d16799cd25bafa9ef6 (diff) | |
| download | manaserv-ab16d3c465b2cef2c69b937b2e00224580e8d8fe.tar.gz manaserv-ab16d3c465b2cef2c69b937b2e00224580e8d8fe.tar.xz manaserv-ab16d3c465b2cef2c69b937b2e00224580e8d8fe.zip | |
Fix the default slot values when upgrading the database to version 14.
Reviewed-by: Cody.
Resolves: Mana-Mantis #284.
Diffstat (limited to 'src/sql/mysql/updates')
| -rw-r--r-- | src/sql/mysql/updates/update_13_to_14.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/sql/mysql/updates/update_13_to_14.sql b/src/sql/mysql/updates/update_13_to_14.sql index ea5b7e2..c4eb819 100644 --- a/src/sql/mysql/updates/update_13_to_14.sql +++ b/src/sql/mysql/updates/update_13_to_14.sql @@ -2,7 +2,7 @@ -- Modify the table `mana_characters` to add the slot field. -- -ALTER TABLE `mana_characters` ADD COLUMN `slot` smallint(5) unsigned NOT NULL; +ALTER TABLE `mana_characters` ADD COLUMN `slot` smallint(5) unsigned NOT NULL DEFAULT '0'; -- Update database version. UPDATE mana_world_states |