create table userdata ( username varchar(32), password varchar(32), email varchar(64), timestamp varchar(20), su tinyint(1) ); create table hostdata ( username varchar(32), domain varchar(32), hostname varchar(64), current_ip varchar(16), last_access varchar(20), last_update varchar(20), registration_ip varchar(16), registration_date varchar(20) ); create table domain ( domain varchar(32) , username varchar(32), timestamp varchar(20) );