diff options
| -rw-r--r-- | src/sql/mysql/updates/update_19_to_20.sql | 4 | ||||
| -rw-r--r-- | src/sql/mysql/updates/update_20_to_21.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/sql/mysql/updates/update_19_to_20.sql b/src/sql/mysql/updates/update_19_to_20.sql index affdc99c..dfc38878 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; diff --git a/src/sql/mysql/updates/update_20_to_21.sql b/src/sql/mysql/updates/update_20_to_21.sql index d66f2208..0bf9b347 100644 --- a/src/sql/mysql/updates/update_20_to_21.sql +++ b/src/sql/mysql/updates/update_20_to_21.sql @@ -1,4 +1,4 @@ -BEGIN; +START TRANSACTION; ALTER TABLE mana_char_specials ADD COLUMN special_current_mana int(10) unsigned NOT NULL; @@ -8,4 +8,4 @@ UPDATE mana_world_states moddate = UNIX_TIMESTAMP() WHERE state_name = 'database_version'; -END; +COMMIT; |