From 1e74ea5962c3f62829e5012e242fe28a53ae17aa Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Tue, 09 Dec 2008 15:23:16 -0500
Subject: [PATCH] Added lists for datalog and ispconfig log in the interface.
---
install/sql/ispconfig3.sql | 23 ++++++++++++++++++++++-
1 files changed, 22 insertions(+), 1 deletions(-)
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index d830051..00f87bd 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -911,7 +911,9 @@
`tstamp` bigint(20) NOT NULL default '0',
`user` varchar(255) NOT NULL default '',
`data` text NOT NULL,
- PRIMARY KEY (`datalog_id`)
+ `status` set('pending','ok','warning','error') NOT NULL default 'pending',
+ PRIMARY KEY (`datalog_id`),
+ KEY `server_id` (`server_id`,`status`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
--
@@ -996,6 +998,25 @@
-- --------------------------------------------------------
--
+-- Tabellenstruktur f�r Tabelle `sys_log`
+--
+
+CREATE TABLE `sys_log` (
+ `syslog_id` int(10) unsigned NOT NULL auto_increment,
+ `server_id` int(10) unsigned NOT NULL default '0',
+ `loglevel` tinyint(4) NOT NULL default '0',
+ `tstamp` int(10) unsigned NOT NULL,
+ `message` text,
+ PRIMARY KEY (`syslog_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Daten f�r Tabelle `sys_log`
+--
+
+-- --------------------------------------------------------
+
+--
-- Tabellenstruktur f�r Tabelle `sys_user`
--
--
Gitblit v1.9.1