create or replace table playerips ( id int auto_increment primary key, playerInfoId int not null, ipInfoId int not null, date text not null ) charset=latin1;