USE test;

CREATE TABLE Host_Hits (
   id        INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
   ymd       INT UNSIGNED NOT NULL,
   hms       INT(6) UNSIGNED ZEROFILL NOT NULL,
   host_id   INT UNSIGNED NOT NULL,
   hit       VARCHAR(255) NOT NULL,
   status    SMALLINT UNSIGNED NOT NULL,
   bytes     INT UNSIGNED DEFAULT 0,
   ref_id    INT UNSIGNED DEFAULT NULL,
   username  VARCHAR(64) DEFAULT NULL,
   se_hit_id INT UNSIGNED DEFAULT NULL
);