create table oldGenomicLoci
(
Loci_ID int not null,
TUG_ID	varchar(50) not null,
TUG_Type	enum('Contig','Singlet')	NOT null,
MemberGSS_GI	varchar(50)	NOT NULL,
MemberGSS_Acc	varchar(50)	NOT NULL,
MemberGSS_StanfordID	varchar(50)	NOT NULL,
GridLoc	enum('G','H','I','K','M','P')	NOT NULL,
GridRowLoc	tinyint,
GridColLoc	tinyint,
primary key (MemberGSS_GI),
index (TUG_ID),
unique (MemberGSS_Acc)

);