diff options
| -rw-r--r-- | src/sql/mysql/updates/update_20_to_21.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/sql/mysql/updates/update_20_to_21.sql b/src/sql/mysql/updates/update_20_to_21.sql new file mode 100644 index 00000000..d66f2208 --- /dev/null +++ b/src/sql/mysql/updates/update_20_to_21.sql @@ -0,0 +1,11 @@ +BEGIN; + +ALTER TABLE mana_char_specials ADD COLUMN special_current_mana int(10) unsigned NOT NULL; + +-- Update database version. +UPDATE mana_world_states + SET value = '21', + moddate = UNIX_TIMESTAMP() + WHERE state_name = 'database_version'; + +END; |