 ;
 CREATE TABLE log(
   id INTEGER NOT NULL AUTO_INCREMENT,
-  date_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date/Time of operation', 
+  date_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date/Time of operation',
   type ENUM('START','STOP','SETUP','WEBSERVICE') NOT NULL DEFAULT 'START' COMMENT 'Type of operation',
   label TEXT NOT NULL COMMENT 'Associated label',
   request TEXT NOT NULL COMMENT 'Associated request (URL/Location/Path)',

  FULLTEXT KEY item_ft_description(description),
  FULLTEXT KEY item_ft_isbn13(isbn13),
  FULLTEXT KEY item_ft_series_title(series_title),
  FULLTEXT KEY item_ft_classification(classification)

)  ENGINE=MyISAM COMMENT 'Search engine for items (MyISAM Format for FULL TEXT SEARCHES)'
;


  PRIMARY KEY(id),
  KEY log_dt_type_request(date_time,type,request(64))

) ENGINE=MyISAM COMMENT 'Web Log'
;
