id int NOT NULL auto_increment, useragent char(32) NOT NULL, ip char(32) NOT NULL, date char(32) NOT NULL, useragent char(32), -- added field for ua primary key (id)