gistfile1.sql

CREATE TABLE  test.`PROF` (
`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`COMMAND` VARCHAR( 250 ) NOT NULL ,
`HOST` VARCHAR( 250 ) NOT NULL ,
`STATE` VARCHAR( 250 ) NOT NULL ,
`INFO` TEXT NOT NULL ,
`INFO_PROCESSED` TEXT NULL ,
`TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`PROCESSED` INT NOT NULL DEFAULT  '0',
INDEX (  `COMMAND` ,  `HOST` ,  `TIME` ,  `PROCESSED` )
) ENGINE = InnoDB ;