From 9fe43fa9c0bd21f6c203072f19a77a570680ecab Mon Sep 17 00:00:00 2001
From: XTZGZoReX <none@none>
Date: Thu, 19 Mar 2009 21:13:52 +0100
Subject: * 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
---
 sql/realmd.sql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'sql/realmd.sql')

diff --git a/sql/realmd.sql b/sql/realmd.sql
index 2e2be75ef47..b7b55cc15d9 100644
--- a/sql/realmd.sql
+++ b/sql/realmd.sql
@@ -104,6 +104,27 @@ LOCK TABLES `ip_banned` WRITE;
 /*!40000 ALTER TABLE `ip_banned` ENABLE KEYS */;
 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`
 --
-- 
cgit v1.2.3