CREATE DATABASE HCCLogIP;

USE HCCLogIP;

CREATE TABLE HCCLogIP (
  id        bigint(20)    unsigned zerofill NOT NULL auto_increment,
  username  varchar(8)    NOT NULL default '',
  ip        varchar(15)   NOT NULL default '',
  timestamp timestamp(14) NOT NULL,
  UNIQUE KEY id (id)
) TYPE=MyISAM;