TNG 11.x Database Structure Update

ALTER TABLE tng_albums MODIFY albumname VARCHAR(100) NOT NULL ... done
ALTER TABLE tng_associations MODIFY relationship VARCHAR(75) NOT NULL ... done
ALTER TABLE tng_cemeteries MODIFY maplink VARCHAR(255) NOT NULL ... done
ALTER TABLE tng_cemeteries MODIFY latitude VARCHAR(22) NULL ... done
ALTER TABLE tng_cemeteries MODIFY longitude VARCHAR(22) NULL ... done
CREATE TABLE tng_dna_links (ID int(11) NOT NULL AUTO_INCREMENT, testID int(11) NOT NULL, personID varchar(22) NOT NULL, gedcom varchar(20) NOT NULL, PRIMARY KEY (ID)) ENGINE = MYISAM ... failed or done previously
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, personID varchar(22) NOT NULL, gedcom varchar(20) NOT NULL, urls text NOT NULL, haplogroup varchar(40) NOT NULL, significant_snp varchar(80) NOT NULL, terminal_snp varchar(80) NOT NULL, markers varchar(40) NOT NULL, PRIMARY KEY (testID), INDEX test_date (test_date)) ENGINE = MYISAM ... failed or done previously
ALTER TABLE tng_families MODIFY marrtype VARCHAR(90) NOT NULL ... done
ALTER TABLE tng_languages ADD norels VARCHAR(1) NOT NULL after charset ... failed or done previously
ALTER TABLE tng_media MODIFY latitude VARCHAR(22) NULL ... done
ALTER TABLE tng_media MODIFY longitude VARCHAR(22) NULL ... done
ALTER TABLE tng_medialinks MODIFY personID VARCHAR(248) NOT NULL ... done
ALTER TABLE tng_mediatypes ADD localpath VARCHAR(250) NOT NULL after ordernum ... failed or done previously
ALTER TABLE tng_places MODIFY latitude VARCHAR(22) NOT NULL ... done
ALTER TABLE tng_places MODIFY longitude VARCHAR(22) NOT NULL ... done
ALTER TABLE tng_sources MODIFY callnum VARCHAR(120) NOT NULL ... done
ALTER TABLE tng_users ADD languageID SMALLINT(6) NOT NULL after website ... failed or done previously

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