Here's an early design. I still haven't found the latest one.
Quote
continents
continent_id - Primary Key SMALLINT (2) UNSIGNED NOT NULL DEFAULT 0 AUTOINCREMENT
continent_name - VARCHAR (25) continent_flag - VARCHAR (25)

countries
country_id - Primary Key SMALLINT (3) UNSIGNED NOT NULL DEFAULT 0 AUTOINCREMENT
country_name - VARCHAR (180)
country_flag - VARCHAR (25)
country_background_color CHAR (6)
continent_id - INT UNSIGNED NOT NULL

states_provinces
state_province_id - Primary Key SMALLINT (5) UNSIGNED NOT NULL DEFAULT 0 AUTOINCREMENT
state_province_name - VARCHAR (180)
state_province_flag - VARCHAR (25)
state_province_background_color - CHAR (6)

cities
city_id - Primary Key SMALLINT (8) UNSIGNED NOT NULL DEFAULT 0 AUTOINCREMENT
city_name - VARCHAR (180)
city_text_color - CHAR (6)

Members
member_id - Primary Key SMALLINT (6) UNSIGNED NOT NULL DEFAULT 0 AUTOINCREMENT
member_name - VARCHAR (150)
member_nickname - VARCHAR (25)
member_email_address - VARCHAR (150)
member_city_id - INT UNSIGNED NOT NULL
member_state_id- INT UNSIGNED NOT NULL
member_country_id - INT UNSIGNED NOT NULL
member_year_make_model - VARCHAR (180)
member_url - VARCHAR (255)
timestamp - DATETIME NOT NULL

Paul Schmehl CI 6
geek@stovebolt.com
Stovebolt Staff: Geek