1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| 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
) |
Partager