* Implementing database logging:

** LogTime and LogColors config options removed due to incompatibility.
** Old file logging still available.
** Totally redone the Log class.
** Config options added: EnableLogDB, DBLogLevel, LogDB.Char, LogDB.RA, LogDB.GM -- remember to update config file.
** SQL updates attached.

--HG--
branch : trunk

2 files changed, 29 insertions, 0 deletions

diff --git a/sql/realmd.sql b/sql/realmd.sql
index 2e2be75ef47..b7b55cc15d9 100644
--- a/sql/realmd.sql
+++ b/sql/realmd.sql
@@ -105,6 +105,27 @@ LOCK TABLES `ip_banned` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `logs`
+--
+
+DROP TABLE IF EXISTS `logs`;
+CREATE TABLE `logs` (
+  `time` int(14) NOT NULL,
+  `realm` int(4) NOT NULL,
+  `type` int(4) NOT NULL,
+  `string` text
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `logs`
+--
+
+LOCK TABLES `logs` WRITE;
+/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
+/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `realmcharacters`
 --
 
diff --git a/sql/updates/2020_realmd.sql b/sql/updates/2020_realmd.sql
new file mode 100644
index 00000000000..fb81c0e99c8
--- /dev/null
+++ b/sql/updates/2020_realmd.sql
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS `logs`;
+-- create logs table
+CREATE TABLE `logs` (
+  `time` int(14) NOT NULL,
+  `realm` int(4) NOT NULL,
+  `type` int(4) NOT NULL,
+  `string` text
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;