diff options
author | Rainer Gerhards <rgerhards@adiscon.com> | 2004-12-08 16:53:54 +0000 |
---|---|---|
committer | Rainer Gerhards <rgerhards@adiscon.com> | 2004-12-08 16:53:54 +0000 |
commit | 9deb0c2b787680fb958624925815b62e02bddc47 (patch) | |
tree | 14e945ddbb5a15b4533c5c3310b38e85751249e1 /createDB.sql | |
parent | d7ca742bcb11ab3d68288afe08d517f6513a1b93 (diff) | |
download | rsyslog-9deb0c2b787680fb958624925815b62e02bddc47.tar.gz rsyslog-9deb0c2b787680fb958624925815b62e02bddc47.tar.xz rsyslog-9deb0c2b787680fb958624925815b62e02bddc47.zip |
hopefully ready for initial beta...
Diffstat (limited to 'createDB.sql')
-rw-r--r-- | createDB.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/createDB.sql b/createDB.sql new file mode 100644 index 00000000..10eabd69 --- /dev/null +++ b/createDB.sql @@ -0,0 +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 |