create table countries (
id integer auto_increment,
country_name text not null,
country_prefix text,
country_shortname text not null
);

create table users (
id integer auto_increment,
username text not null,
password text not null,
hostip text
);

create table dids (
country_id integer references countries (id),
user_id integer references users (id),
assigned enum('y','n','p'),
did text not null
);