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 | |
| parent | 968815437750fd1b76cb78d16799cd25bafa9ef6 (diff) | |
| download | manaserv-ab16d3c465b2cef2c69b937b2e00224580e8d8fe.tar.gz manaserv-ab16d3c465b2cef2c69b937b2e00224580e8d8fe.tar.bz2 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')
| -rw-r--r-- | src/sql/mysql/updates/update_13_to_14.sql | 2 | ||||
| -rw-r--r-- | src/sql/sqlite/updates/update_13_to_14.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/sql/mysql/updates/update_13_to_14.sql b/src/sql/mysql/updates/update_13_to_14.sql index ea5b7e25..c4eb8194 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 diff --git a/src/sql/sqlite/updates/update_13_to_14.sql b/src/sql/sqlite/updates/update_13_to_14.sql index a4c4a38a..50668147 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 |