From a07f3af045d1aaa2152168c42739dd23705b6b2f Mon Sep 17 00:00:00 2001
From: Blaymoira <none@none>
Date: Mon, 19 Jan 2009 17:38:03 +0100
Subject: *Merged db_version and script_db_version table in one table - by Zor

--HG--
branch : trunk
---
 src/trinitycore/Master.cpp | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'src/trinitycore/Master.cpp')

diff --git a/src/trinitycore/Master.cpp b/src/trinitycore/Master.cpp
index ed526f497c3..63c88807738 100644
--- a/src/trinitycore/Master.cpp
+++ b/src/trinitycore/Master.cpp
@@ -458,6 +458,9 @@ bool Master::_StartDB()
     ///- Clean the database before starting
     clearOnlineAccounts();
 
+	///- Insert version info into DB
+    WorldDatabase.PExecute("UPDATE `version` SET `core_version` = '%s'", _FULLVERSION);
+
     sWorld.LoadDBVersion();
 
     sLog.outString("Using %s", sWorld.GetDBVersion());
-- 
cgit v1.2.3


From f28fb06d711c03ca777d04b546f5eceff0ca46b5 Mon Sep 17 00:00:00 2001
From: Blaymoira <none@none>
Date: Mon, 19 Jan 2009 18:11:08 +0100
Subject: *Added another column for version table - by Zor

--HG--
branch : trunk
---
 sql/updates/919_world.sql  | 2 ++
 sql/updates/CMakeLists.txt | 2 ++
 src/trinitycore/Master.cpp | 2 +-
 3 files changed, 5 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/919_world.sql

(limited to 'src/trinitycore/Master.cpp')

diff --git a/sql/updates/919_world.sql b/sql/updates/919_world.sql
new file mode 100644
index 00000000000..24267d49223
--- /dev/null
+++ b/sql/updates/919_world.sql
@@ -0,0 +1,2 @@
+ALTER TABLE version
+   ADD `core_revision` BIGINT UNSIGNED AFTER `core_version`;
\ No newline at end of file
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index 13649ebd133..dc983f8c14d 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -140,4 +140,6 @@ INSTALL(FILES
 871_world.sql
 884_world.sql
 905_world_scripts.sql
+917_world.sql
+919_world.sql
 DESTINATION share/trinity/sql/updates)
diff --git a/src/trinitycore/Master.cpp b/src/trinitycore/Master.cpp
index 63c88807738..938f1753c0b 100644
--- a/src/trinitycore/Master.cpp
+++ b/src/trinitycore/Master.cpp
@@ -459,7 +459,7 @@ bool Master::_StartDB()
     clearOnlineAccounts();
 
 	///- Insert version info into DB
-    WorldDatabase.PExecute("UPDATE `version` SET `core_version` = '%s'", _FULLVERSION);
+    WorldDatabase.PExecute("UPDATE `version` SET `core_version` = '%s', `core_rev` = '%s'", _FULLVERSION, _REVISION);
 
     sWorld.LoadDBVersion();
 
-- 
cgit v1.2.3