diff options
author | Rainer Gerhards <rgerhards@adiscon.com> | 2007-09-26 10:24:14 +0000 |
---|---|---|
committer | Rainer Gerhards <rgerhards@adiscon.com> | 2007-09-26 10:24:14 +0000 |
commit | 88bbc402201c8bf088d310a9048bf38b77fb2f8e (patch) | |
tree | a35e8422723f8461360900f5d32539b8c368f267 /plugins/ommysql/createDB.sql | |
parent | 1c91a20427fe6af60bb385f695ce8768406fa194 (diff) | |
download | rsyslog-88bbc402201c8bf088d310a9048bf38b77fb2f8e.tar.gz rsyslog-88bbc402201c8bf088d310a9048bf38b77fb2f8e.tar.xz rsyslog-88bbc402201c8bf088d310a9048bf38b77fb2f8e.zip |
applied patch provided by varmojfekoj to support building ommysql in its
own way (now also resides in a plugin subdirectory)
Diffstat (limited to 'plugins/ommysql/createDB.sql')
-rw-r--r-- | plugins/ommysql/createDB.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/plugins/ommysql/createDB.sql b/plugins/ommysql/createDB.sql new file mode 100644 index 00000000..211cfb0e --- /dev/null +++ b/plugins/ommysql/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 +); |