drop table fy_con;
drop sequence fy_con_id_seq;
create table fy_con (
	ID serial,
	loginid integer,
	type character (8),
	firstname character (15),
	middlename character (15),
	lastname character (15),
	nickname character (15),
	descr varchar,
	PRIMARY KEY (ID)
);

drop table fy_con_types;
drop sequence fy_con_types_id_seq;
create table fy_con_types (
	ID serial,
	type character (8),
	PRIMARY KEY (ID)
);

drop table fy_con_addresses;
drop sequence fy_con_addresses_id_seq;
create table fy_con_addresses (
	ID serial,
	FID integer,
	type character (5),
	streetaddress character (30),
	city character (15),
	state character (2),
	zip character (10),
	PRIMARY KEY (ID)
);

drop table fy_con_addresses_types;
drop sequence fy_con_addresses_types_id_seq;
create table fy_con_addresses_types (
	ID serial,
	type character (5),
	PRIMARY KEY (ID)
);

drop table fy_con_emails;
drop sequence fy_con_emails_id_seq;
create table fy_con_emails (
	ID serial,
	FID integer,
	type character (6),
	address character (50),
	PRIMARY KEY (ID)
);

drop table fy_con_emails_types;
drop sequence fy_con_emails_types_id_seq;
create table fy_con_emails_types (
	ID serial,
	type character (6),
	PRIMARY KEY (ID)
);

drop table fy_con_numbers;
drop sequence fy_con_numbers_id_seq;
create table fy_con_numbers (
	ID serial,
	FID integer,
	type character (5),
	number character (10),
	PRIMARY KEY (ID)
);

drop table fy_con_numbers_types;
drop sequence fy_con_numbers_types_id_seq;
create table fy_con_numbers_types (
	ID serial,
	type character (5),
	PRIMARY KEY (ID)
);

drop table fy_con_notes;
drop sequence fy_con_notes_id_seq;
create table fy_con_notes (
	ID serial,
	FID integer,
	notedate date,
	subject character (50),
	note varchar,
	by_id integer,
	PRIMARY KEY (ID)
);

drop table fy_con_notes_admin;
drop sequence fy_con_notes_admin_id_seq;
create table fy_con_notes_admin (
	ID serial,
	FID integer,
	notedate date,
	subject character (50),
	note varchar,
	by_id integer,
	PRIMARY KEY (ID)
);

drop table fy_con_groups;
drop sequence fy_con_groups_id_seq;
create table fy_con_groups (
	ID serial,
	FID integer,
	group_id character (2),
	primary_gh character (1),
	coordinator character (1),
	startdate date,
	enddate date,
	PRIMARY KEY (ID)
);

drop table fy_con_races;
drop sequence fy_con_races_id_seq;
create table fy_con_races (
	ID serial,
	race character (30),
	PRIMARY KEY (ID)
);
