DROP TABLE IF EXISTS tng_dna_tests;
CREATE TABLE `tng_dna_tests` (
  `testID` int(11) NOT NULL AUTO_INCREMENT,
  `test_type` varchar(40) NOT NULL,
  `test_number` varchar(50) NOT NULL,
  `notes` text NOT NULL,
  `vendor` varchar(100) NOT NULL,
  `test_date` date NOT NULL,
  `match_date` date NOT NULL,
  `personID` varchar(22) NOT NULL,
  `gedcom` varchar(20) NOT NULL,
  `person_name` varchar(100) NOT NULL,
  `urls` text NOT NULL,
  `mtdna_haplogroup` varchar(40) NOT NULL,
  `ydna_haplogroup` varchar(30) NOT NULL,
  `significant_snp` varchar(255) NOT NULL,
  `terminal_snp` varchar(80) NOT NULL,
  `markers` varchar(40) NOT NULL,
  `y_results` varchar(512) NOT NULL,
  `hvr1_results` varchar(100) NOT NULL,
  `hvr2_results` varchar(100) NOT NULL,
  `mtdna_confirmed` varchar(2) NOT NULL,
  `ydna_confirmed` varchar(2) NOT NULL,
  `markeropt` varchar(2) NOT NULL,
  `notesopt` varchar(2) NOT NULL,
  `linksopt` varchar(2) NOT NULL,
  `surnamesopt` tinyint(4) NOT NULL,
  `private_dna` varchar(2) NOT NULL,
  `private_test` varchar(2) NOT NULL,
  `dna_group` varchar(128) NOT NULL,
  `dna_group_desc` varchar(128) NOT NULL,
  `surnames` text NOT NULL,
  `MD_ancestorID` varchar(20) NOT NULL,
  `MRC_ancestorID` varchar(20) NOT NULL,
  `admin_notes` text NOT NULL,
  `medialinks` text NOT NULL,
  `ref_seq` text NOT NULL,
  `xtra_mut` text NOT NULL,
  `coding_reg` text NOT NULL,
  `GEDmatchID` varchar(30) NOT NULL,
  `relationship_range` varchar(80) NOT NULL,
  `suggested_relationship` varchar(80) NOT NULL,
  `actual_relationship` varchar(40) NOT NULL,
  `related_side` varchar(120) NOT NULL,
  `shared_cMs` varchar(10) NOT NULL,
  `shared_segments` varchar(10) NOT NULL,
  `chromosome` varchar(4) NOT NULL,
  `segment_start` varchar(40) NOT NULL,
  `segment_end` varchar(40) NOT NULL,
  `centiMorgans` varchar(40) NOT NULL,
  `matching_SNPs` varchar(10) NOT NULL,
  `x_match` varchar(2) NOT NULL,
  PRIMARY KEY (`testID`),
  KEY `test_date` (`test_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
