CREATE TABLE vblgv ( id smallint(5) unsigned NOT NULL auto_increment, ipaddress VARCHAR(25) NOT NULL default '0.0.0.0', firstaccess INT UNSIGNED NOT NULL DEFAULT '0', views INT(4) NOT NULL DEFAULT '0', lastactivity INT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY indexs (ipaddress,views,lastactivity) )