DROP TABLE log_db.log;
CREATE TABLE log_db.log (
  id int(11) NOT NULL AUTO_INCREMENT,
  category varchar(255) DEFAULT NULL,
  level int(11) DEFAULT NULL,
  SERVER_PROTOCOL varchar(250) DEFAULT NULL,
  REQUEST_METHOD varchar(250) DEFAULT NULL,
  REQUEST_TIME double DEFAULT NULL,
  QUERY_STRING varchar(250) DEFAULT NULL,
  HTTP_ACCEPT_ENCODING varchar(250) DEFAULT NULL,
  HTTP_CONNECTION varchar(250) DEFAULT NULL,
  HTTP_HOST varchar(250) DEFAULT NULL,
  HTTP_REFERER varchar(250) DEFAULT NULL,
  HTTP_USER_AGENT varchar(250) DEFAULT NULL,
  HTTPS varchar(250) DEFAULT NULL,
  REMOTE_ADDR varchar(32) DEFAULT NULL,
  REMOTE_PORT smallint(6) DEFAULT NULL,
  SCRIPT_FILENAME varchar(250) DEFAULT NULL,
  REQUEST_URI varchar(250) DEFAULT NULL,
  sessionid varchar(32) DEFAULT NULL,
  session_data text,
  post_data text,
  user varchar(64) DEFAULT NULL,
  message text,
  zeitpunkt timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id,zeitpunkt),
  KEY user (user)
)

PARTITION BY RANGE (UNIX_TIMESTAMP(zeitpunkt)) (
    PARTITION p201806 VALUES LESS THAN (UNIX_TIMESTAMP('2018-07-01 00:00:00')),
    PARTITION p201807 VALUES LESS THAN (UNIX_TIMESTAMP('2018-08-01 00:00:00')),
    PARTITION p201808 VALUES LESS THAN (UNIX_TIMESTAMP('2018-09-01 00:00:00'))
)
;