create table tblunit ( unitid int not null auto_increment, unitname varchar(30), url text, primary key(unitid) ); create table tblunitvist( id int not null auto_increment, unitid int, vdate date, pv int, primary key(id), foreign key(unitid) references tblunit(unitid) )