applied a patch from Peter Vrabec (Thanks!) to integrate klogd into the

    rsyslog package. That removes dependency on the original sysklogd
    package.

1 files changed, 37 insertions, 37 deletions

diff --git a/createDB.sql b/createDB.sql
index 10eabd69..211cfb0e 100644
--- a/createDB.sql
+++ b/createDB.sql
@@ -1,37 +1,37 @@
-CREATE DATABASE Syslog;

-USE Syslog;

-CREATE TABLE SystemEvents

-(

-        ID int unsigned not null auto_increment primary key,

-        CustomerID bigint,

-        ReceivedAt datetime NULL,

-        DeviceReportedTime datetime NULL,

-        Facility smallint NULL,

-        Priority smallint NULL,

-        FromHost varchar(60) NULL,

-        Message text,

-        NTSeverity int NULL,

-        Importance int NULL,

-        EventSource varchar(60),

-        EventUser varchar(60) NULL,

-        EventCategory int NULL,

-        EventID int NULL,

-        EventBinaryData text NULL,

-        MaxAvailable int NULL,

-        CurrUsage int NULL,

-        MinUsage int NULL,

-        MaxUsage int NULL,

-        InfoUnitID int NULL ,

-        SysLogTag varchar(60),

-        EventLogType varchar(60),

-        GenericFileName VarChar(60),

-        SystemID int NULL

-);

-

-CREATE TABLE SystemEventsProperties

-(

-        ID int unsigned not null auto_increment primary key,

-        SystemEventID int NULL ,

-        ParamName varchar(255) NULL ,

-        ParamValue text NULL

-);
\ No newline at end of file
+CREATE DATABASE Syslog;
+USE Syslog;
+CREATE TABLE SystemEvents
+(
+        ID int unsigned not null auto_increment primary key,
+        CustomerID bigint,
+        ReceivedAt datetime NULL,
+        DeviceReportedTime datetime NULL,
+        Facility smallint NULL,
+        Priority smallint NULL,
+        FromHost varchar(60) NULL,
+        Message text,
+        NTSeverity int NULL,
+        Importance int NULL,
+        EventSource varchar(60),
+        EventUser varchar(60) NULL,
+        EventCategory int NULL,
+        EventID int NULL,
+        EventBinaryData text NULL,
+        MaxAvailable int NULL,
+        CurrUsage int NULL,
+        MinUsage int NULL,
+        MaxUsage int NULL,
+        InfoUnitID int NULL ,
+        SysLogTag varchar(60),
+        EventLogType varchar(60),
+        GenericFileName VarChar(60),
+        SystemID int NULL
+);
+
+CREATE TABLE SystemEventsProperties
+(
+        ID int unsigned not null auto_increment primary key,
+        SystemEventID int NULL ,
+        ParamName varchar(255) NULL ,
+        ParamValue text NULL
+);