[mariocaz]

if the table complete is vblgv, Is this one the correct instruction ?

CREATE TABLE vblgv (
id int(7) 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)
) TYPE=MyISAM

or like this:

CREATE TABLE lgv (
id int(7) 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)
) TYPE=MyISAM

Sorry if I am stupid, but I want to be sure before to run it.