create table fy_con (
	ID int unsigned not null auto_increment,
	loginid integer,
	type character (8),
	firstname character (15),
	middlename character (15),
	lastname character (15),
	nickname character (15),
	descr varchar(255),
	PRIMARY KEY (ID)
);

create table fy_con_types (
	ID int unsigned not null auto_increment,
	type character (8),
	PRIMARY KEY (ID)
);

create table fy_con_addresses (
	ID int unsigned not null auto_increment,
	FID integer,
	type character (5),
	streetaddress character (30),
	city character (15),
	state character (2),
	zip character (10),
	PRIMARY KEY (ID)
);

create table fy_con_addresses_types (
	ID int unsigned not null auto_increment,
	type character (5),
	PRIMARY KEY (ID)
);

create table fy_con_emails (
	ID int unsigned not null auto_increment,
	FID integer,
	type character (6),
	address character (50),
	PRIMARY KEY (ID)
);

create table fy_con_emails_types (
	ID int unsigned not null auto_increment,
	type character (6),
	PRIMARY KEY (ID)
);

create table fy_con_numbers (
	ID int unsigned not null auto_increment,
	FID integer,
	type character (5),
	number character (10),
	PRIMARY KEY (ID)
);

create table fy_con_numbers_types (
	ID int unsigned not null auto_increment,
	type character (5),
	PRIMARY KEY (ID)
);

create table fy_con_notes (
	ID int unsigned not null auto_increment,
	FID integer,
	notedate date,
	subject character (50),
	note varchar(255),
	by_id integer,
	PRIMARY KEY (ID)
);

create table fy_con_notes_admin (
	ID int unsigned not null auto_increment,
	FID integer,
	notedate date,
	subject character (50),
	note varchar(255),
	by_id integer,
	PRIMARY KEY (ID)
);

create table fy_con_groups (
	ID int unsigned not null auto_increment,
	FID integer,
	group_id character (2),
	primary_gh character (1),
	coordinator character (1),
	startdate date,
	enddate date,
	PRIMARY KEY (ID)
);

create table fy_con_races (
	ID int unsigned not null auto_increment,
	race character (30),
	PRIMARY KEY (ID)
);
