diff options
| -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 |