summaryrefslogtreecommitdiffstats
path: root/src/sql/mysql
diff options
context:
space:
mode:
Diffstat (limited to 'src/sql/mysql')
-rw-r--r--src/sql/mysql/updates/update_19_to_20.sql4
-rw-r--r--src/sql/mysql/updates/update_20_to_21.sql4
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 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;
diff --git a/src/sql/mysql/updates/update_20_to_21.sql b/src/sql/mysql/updates/update_20_to_21.sql
index d66f220..0bf9b34 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;