TNG 13.x Database Structure Update

ALTER TABLE tng_dna_tests CHANGE y_results y_results VARCHAR(512) NOT NULL ... done
UPDATE tng_dna_tests SET mtdna_haplogroup = haplogroup WHERE test_type = 'mtDNA' ... done
UPDATE tng_dna_tests SET ydna_haplogroup = haplogroup WHERE test_type = 'Y-DNA' ... done
UPDATE tng_dna_tests SET ydna_confirmed = confirmed WHERE test_type = 'Y-DNA' ... done
UPDATE tng_dna_tests SET mtdna_confirmed = confirmed WHERE test_type = 'mtDNA' ... done
ALTER TABLE tng_saveimport MODIFY filename VARCHAR(255) NULL ... done
Entering new template settings into the database...success.

The Next Generation database has now been updated to v13.x specs.