diff options
| author | XTZGZoReX <none@none> | 2009-03-19 21:13:52 +0100 |
|---|---|---|
| committer | XTZGZoReX <none@none> | 2009-03-19 21:13:52 +0100 |
| commit | 9fe43fa9c0bd21f6c203072f19a77a570680ecab (patch) | |
| tree | 5592cf3a9b39a04e7e81295408625713a6fdd2bd /sql/realmd.sql | |
| parent | fd2f768dfd7c877880942477a7d1b1645f5bfab9 (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.sql | 21 |
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` -- |
