diff options
Diffstat (limited to 'src/sql/mysql/updates')
| -rw-r--r-- | src/sql/mysql/updates/update_22_to_23.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/src/sql/mysql/updates/update_22_to_23.sql b/src/sql/mysql/updates/update_22_to_23.sql new file mode 100644 index 00000000..c4affaed --- /dev/null +++ b/src/sql/mysql/updates/update_22_to_23.sql @@ -0,0 +1,15 @@ +START TRANSACTION; + +-- There is no way to convert all your skills to attributes. You will have to +-- do this manually. + +ALTER TABLE mana_characters DROP COLUMN level; + +-- Update database version. +UPDATE mana_world_states + SET value = '23', + moddate = UNIX_TIMESTAMP() + WHERE state_name = 'database_version'; + +COMMIT; + |