CREATE TABLE IF NOT EXISTS log_table (
  record_id int(255) NOT NULL AUTO_INCREMENT,
  time_stamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  device_name varchar(255) NOT NULL,
  value1 varchar(255) NOT NULL,
  ip_address varchar(255) NOT NULL,
  PRIMARY KEY (record_id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;