aboutsummaryrefslogtreecommitdiff
path: root/sql/realmd.sql
diff options
context:
space:
mode:
authorXTZGZoReX <none@none>2009-03-19 21:13:52 +0100
committerXTZGZoReX <none@none>2009-03-19 21:13:52 +0100
commit9fe43fa9c0bd21f6c203072f19a77a570680ecab (patch)
tree5592cf3a9b39a04e7e81295408625713a6fdd2bd /sql/realmd.sql
parentfd2f768dfd7c877880942477a7d1b1645f5bfab9 (diff)
* 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
Diffstat (limited to 'sql/realmd.sql')
-rw-r--r--sql/realmd.sql21
1 files changed, 21 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`
--