create table names (
   name_id INT NOT NULL auto_increment,
   name_str VARCHAR(255)
   );

create table ipaddresses (
   ipaddress_id INT NOT NULL auto_increment,
   ipaddress_value VARCHAT(255)
   );

create table ip_names (
   name_id INT NOT NULL,
   ipaddress_id INT NOT NULL
   );