sql

CREATE TABLE `facility` (
`facilityID` varchar(2) NOT NULL default '',
`description` varchar(30) default NULL,
PRIMARY KEY (`facilityID`)
);

CREATE TABLE `system` (
`systemID` varchar(3) NOT NULL default '',
`ipAddress` varchar(16) default NULL,
`dnsName` varchar(50) default NULL,
`network` varchar(50) default NULL,
`type` varchar(20) default NULL,
PRIMARY KEY (`systemID`)
);

CREATE TABLE `severity` (
`severityID` char(1) NOT NULL default '',
`level` varchar(30) default NULL,
PRIMARY KEY (`severityID`)
);


CREATE TABLE `event` (
`eventID` varchar(4) NOT NULL default '',
`systemID` varchar(3) default NULL,
`facilityID` varchar(2) default NULL,
`severityID` char(1) default NULL,
`dateSent` date default NULL,
`timeSent` time default NULL,
`dateReceived` date default NULL,
`timeReceived` time default NULL,
`message` varchar(300) default NULL,
PRIMARY KEY (`eventID`),
KEY `systemID` (`systemID`),
KEY `facilityID` (`facilityID`),
KEY `severityID` (`severityID`)
);


INSERT INTO `facility` VALUES ('0','kernel messages'),('1','user-level messages'),('2','mail system'),('3','system daemons'),('4','security/authorization message'),('5','messages generated internally '),('6','line printer subsystem'),('7','network news subsystem'),('8','UUCP subsystem'),('9','clock daemon'),('10','security/authorization message'),('11','FTP daemon'),('12','NTP subsystem'),('13','log audit'),('14','log alert'),('15','clock daemon'),('16','local use 0'),('17','local use 1'),('18','local use 2'),('19','local use 3'),('20','local use 4'),('21','local use 5'),('22','local use 6'),('23','local use 7');
INSERT INTO `severity` VALUES ('0','Emergency'),('1','Alert'),('2','Critical'),('3','Error'),('4','Warning'),('5','Notice'),('6',' Informational'),('7','Debug');
INSERT INTO `system` VALUES ('0','127.0.0.1','monitor','green.local','Syslog server');