summaryrefslogtreecommitdiffstats
path: root/src/sql
diff options
context:
space:
mode:
authorFreeyorp <Freeyorp101@hotmail.com>2010-08-18 23:23:12 +1200
committerFreeyorp <Freeyorp101@hotmail.com>2010-08-18 23:24:46 +1200
commit7db9f6fe36b737d2eec7c6070497035b0834def2 (patch)
tree016f8747e418cb194da1388bab01e976c4a0c353 /src/sql
parenta822f8f257aaec37174a11add3543ef70a29e206 (diff)
downloadmanaserv-7db9f6fe36b737d2eec7c6070497035b0834def2.tar.gz
manaserv-7db9f6fe36b737d2eec7c6070497035b0834def2.tar.xz
manaserv-7db9f6fe36b737d2eec7c6070497035b0834def2.zip
Change references from database version 10 to version 11 to reflect changes made to mainline
Diffstat (limited to 'src/sql')
-rw-r--r--src/sql/mysql/createTables.sql2
-rw-r--r--src/sql/mysql/updates/update_10_to_11.sql (renamed from src/sql/mysql/updates/update_9_to_10.sql)2
-rw-r--r--src/sql/sqlite/createTables.sql2
3 files changed, 3 insertions, 3 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 0312981..a76cc33 100644
--- a/src/sql/mysql/createTables.sql
+++ b/src/sql/mysql/createTables.sql
@@ -420,7 +420,7 @@ AUTO_INCREMENT=0 ;
INSERT INTO mana_world_states VALUES('accountserver_startup',NULL,NULL, NOW());
INSERT INTO mana_world_states VALUES('accountserver_version',NULL,NULL, NOW());
-INSERT INTO mana_world_states VALUES('database_version', NULL,'10', NOW());
+INSERT INTO mana_world_states VALUES('database_version', NULL,'11', NOW());
-- all known transaction codes
diff --git a/src/sql/mysql/updates/update_9_to_10.sql b/src/sql/mysql/updates/update_10_to_11.sql
index 5bb722a..66922f1 100644
--- a/src/sql/mysql/updates/update_9_to_10.sql
+++ b/src/sql/mysql/updates/update_10_to_11.sql
@@ -46,4 +46,4 @@ CREATE TABLE IF NOT EXISTS `mana_char_equips` (
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
-UPDATE mana_world_states SET value = '10', moddate = UNIX_TIMESTAMP() WHERE state_name = 'database_version';
+UPDATE mana_world_states SET value = '11', moddate = UNIX_TIMESTAMP() WHERE state_name = 'database_version';
diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql
index 94aabda..8c57e45 100644
--- a/src/sql/sqlite/createTables.sql
+++ b/src/sql/sqlite/createTables.sql
@@ -405,7 +405,7 @@ AS
INSERT INTO mana_world_states VALUES('accountserver_startup',NULL,NULL, strftime('%s','now'));
INSERT INTO mana_world_states VALUES('accountserver_version',NULL,NULL, strftime('%s','now'));
-INSERT INTO mana_world_states VALUES('database_version', NULL,'10', strftime('%s','now'));
+INSERT INTO mana_world_states VALUES('database_version', NULL,'11', strftime('%s','now'));
-- all known transaction codes