From a5895b1655be3e81f451844a911eab8b798fa7ab Mon Sep 17 00:00:00 2001 From: Thorbjørn Lindeijer Date: Tue, 25 Oct 2011 21:14:13 +0200 Subject: End the confusion about the missing upgrade script Version 15 was skipped, and we'll never go back. Renamed the 15_to_16 update scripts to 14_to_16 to avoid confusing everybody who wants to update their DBs. Reviewed-by: Yohann Ferreira --- src/sql/mysql/updates/update_14_to_16.sql | 7 +++++++ src/sql/mysql/updates/update_15_to_16.sql | 7 ------- src/sql/sqlite/updates/update_14_to_16.sql | 7 +++++++ src/sql/sqlite/updates/update_15_to_16.sql | 7 ------- 4 files changed, 14 insertions(+), 14 deletions(-) create mode 100644 src/sql/mysql/updates/update_14_to_16.sql delete mode 100644 src/sql/mysql/updates/update_15_to_16.sql create mode 100644 src/sql/sqlite/updates/update_14_to_16.sql delete mode 100644 src/sql/sqlite/updates/update_15_to_16.sql (limited to 'src') diff --git a/src/sql/mysql/updates/update_14_to_16.sql b/src/sql/mysql/updates/update_14_to_16.sql new file mode 100644 index 00000000..df94f995 --- /dev/null +++ b/src/sql/mysql/updates/update_14_to_16.sql @@ -0,0 +1,7 @@ +ALTER TABLE mana_characters CHANGE map_id map_id smallint(5); + +-- Update database version. +UPDATE mana_world_states +SET value = '16', +moddate = UNIX_TIMESTAMP() +WHERE state_name = 'database_version'; diff --git a/src/sql/mysql/updates/update_15_to_16.sql b/src/sql/mysql/updates/update_15_to_16.sql deleted file mode 100644 index df94f995..00000000 --- a/src/sql/mysql/updates/update_15_to_16.sql +++ /dev/null @@ -1,7 +0,0 @@ -ALTER TABLE mana_characters CHANGE map_id map_id smallint(5); - --- Update database version. -UPDATE mana_world_states -SET value = '16', -moddate = UNIX_TIMESTAMP() -WHERE state_name = 'database_version'; diff --git a/src/sql/sqlite/updates/update_14_to_16.sql b/src/sql/sqlite/updates/update_14_to_16.sql new file mode 100644 index 00000000..aa5d4646 --- /dev/null +++ b/src/sql/sqlite/updates/update_14_to_16.sql @@ -0,0 +1,7 @@ +-- No changes required. It was only an issue with mysql. + +-- Update the database version, and set date of update +UPDATE mana_world_states + SET value = '16', + moddate = strftime('%s','now') + WHERE state_name = 'database_version'; diff --git a/src/sql/sqlite/updates/update_15_to_16.sql b/src/sql/sqlite/updates/update_15_to_16.sql deleted file mode 100644 index aa5d4646..00000000 --- a/src/sql/sqlite/updates/update_15_to_16.sql +++ /dev/null @@ -1,7 +0,0 @@ --- No changes required. It was only an issue with mysql. - --- Update the database version, and set date of update -UPDATE mana_world_states - SET value = '16', - moddate = strftime('%s','now') - WHERE state_name = 'database_version'; -- cgit v1.2.3-60-g2f50