diff options
Diffstat (limited to 'src/sql/mysql/updates/update_19_to_20.sql')
-rw-r--r-- | src/sql/mysql/updates/update_19_to_20.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/sql/mysql/updates/update_19_to_20.sql b/src/sql/mysql/updates/update_19_to_20.sql index affdc99..dfc3887 100644 --- a/src/sql/mysql/updates/update_19_to_20.sql +++ b/src/sql/mysql/updates/update_19_to_20.sql @@ -1,4 +1,4 @@ -BEGIN; +START TRANSACTION; -- Set existing world variables to the world map (0) UPDATE mana_world_states SET map_id = 0 WHERE map_id IS NULL; @@ -22,4 +22,4 @@ UPDATE mana_world_states moddate = UNIX_TIMESTAMP() WHERE state_name = 'database_version'; -END; +COMMIT; |