CREATE TABLE `log` (
	`timestamp` TIMESTAMP NOT NULL ,
	`message` VARCHAR(255) NOT NULL ,
	`priority` SMALLINT NOT NULL ,
	`priorityName` VARCHAR( 10 ) NOT NULL
	,INDEX  (`timestamp`)
) TYPE = MEMORY