create table ALARM
(
	ID 		BIGINT 		NOT NULL AUTO_INCREMENT,
	IP 		CHAR(16)  	not null,
	DATE_NEW	DATETIME,
	DATE_CHANGED	DATETIME,
	DATE_CLEARED	DATETIME,
	SEVERITY	ENUM('indeterminate', 'critical', 'major', 'minor', 'warning', 'cleared'),
	TYPE		CHAR(50),
	RESSOURCE	CHAR(50),
	CAUSE		CHAR(100),
	PROBLEM		CHAR(100),
	DIVERS		CHAR(120),

	PRIMARY KEY (ID)
);