   PRIMARY KEY(id),
   UNIQUE KEY item_classification_label(label(300)),
   FULLTEXT KEY item_classification_ft_label(label)
-  
+
 ) ENGINE=MyISAM COMMENT 'Item Classification (autocompletion for free text, can include Dewey Decimal Classification)'
 ;
 

;
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', 
  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)',


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

) ENGINE=MyISAM COMMENT 'Web Log'
;
