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 /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 'createDB.sql')
-rw-r--r-- | createDB.sql | 37 |
1 files changed, 0 insertions, 37 deletions
diff --git a/createDB.sql b/createDB.sql deleted file mode 100644 index 211cfb0e..00000000 --- a/createDB.sql +++ /dev/null @@ -1,37 +0,0 @@ -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 -); |