diff options
author | Erik Schilling <ablu.erikschilling@googlemail.com> | 2012-04-04 20:23:35 +0200 |
---|---|---|
committer | Erik Schilling <ablu.erikschilling@googlemail.com> | 2012-04-04 20:28:27 +0200 |
commit | f541b77d2ee0cad675ac60897e136322555ef5bc (patch) | |
tree | e955b595391badaa97223bef6287f0299cc2cc74 | |
parent | 4d84c4ffd2c4f25a67b2f094baf6ac81c68ebb07 (diff) | |
download | manaserv-f541b77d2ee0cad675ac60897e136322555ef5bc.tar.gz manaserv-f541b77d2ee0cad675ac60897e136322555ef5bc.tar.bz2 manaserv-f541b77d2ee0cad675ac60897e136322555ef5bc.tar.xz manaserv-f541b77d2ee0cad675ac60897e136322555ef5bc.zip |
Added mysql update script for the special commit
Forgot to add this to git when doing the commit. Sorry.
Reviewed-by: bjorn.
-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; |