inspektr required table for MySql

inspektr_mysql.sql

CREATE TABLE `COM_AUDIT_TRAIL` (
  `AUD_USER`      varchar(100)  NOT NULL ,
  `AUD_CLIENT_IP` VARCHAR(15)    NOT NULL ,
  `AUD_SERVER_IP` VARCHAR(15)    NOT NULL ,
  `AUD_RESOURCE`  varchar(100)  NOT NULL ,
  `AUD_ACTION`    varchar(100)  NOT NULL ,
  `APPLIC_CD`     varchar(5)    NOT NULL ,
  `AUD_DATE`      TIMESTAMP      NOT NULL 
 );
ALTER TABLE `COM_AUDIT_TRAIL`
  ADD CONSTRAINT `COM_AUDIT_TRAIL_PK`
  PRIMARY KEY (
    `AUD_USER`,
    `AUD_CLIENT_IP`,
    `AUD_SERVER_IP`,
    `AUD_RESOURCE`,
    `AUD_ACTION`,
    `APPLIC_CD`,
    `AUD_DATE`
  ) ;
 
CREATE TABLE `COM_STATISTICS` (
  `STAT_SERVER_IP` varchar(15) NOT NULL ,
  `STAT_DATE` datetime NOT NULL ,
  `APPLIC_CD` varchar(5) NOT NULL ,
  `STAT_PRECISION` varchar(6) NOT NULL ,
  `STAT_COUNT` numeric NOT NULL ,
  `STAT_NAME` varchar(100)
);
ALTER TABLE `COM_STATISTICS`
  ADD CONSTRAINT `COM_STATISTICS_PK`
  PRIMARY KEY (
    `STAT_SERVER_IP`,
    `STAT_DATE`,
    `APPLIC_CD`,
    `STAT_PRECISION`,
    `STAT_NAME`
  ) ;
  
CREATE INDEX `COM_AUDIT_TRAIL_DATE_I`
  ON `COM_AUDIT_TRAIL` (`AUD_DATE`);

CREATE INDEX `COM_AUDIT_TRAIL_CLIENT_DATE_
I`
  ON `COM_AUDIT_TRAIL` (`AUD_CLIENT_IP`, `AUD_DATE`);

CREATE INDEX `COM_AUDIT_TRAIL_USER_DATE_I`
  ON `COM_AUDIT_TRAIL` (`AUD_USER`, `AUD_DATE`);

CREATE INDEX `COM_AUDIT_TRAIL_ACTION_DATE_I`
  ON `COM_AUDIT_TRAIL` (`AUD_ACTION`, `AUD_DATE`);

CREATE INDEX `COM_STATISTICS_DATE_I`
  ON `COM_STATISTICS` (`STAT_DATE`);

CREATE INDEX `COM_STATISTICS_NAME_DATE_I`
  ON `COM_STATISTICS` (`STAT_NAME`, `STAT_DATE`);