TNG 10.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_branches DROP PRIMARY KEY ... done
ALTER TABLE tng_branches ADD PRIMARY KEY (gedcom, branch) ... done
ALTER TABLE tng_branches ADD personID VARCHAR(22) NOT NULL after description ... failed or done previously
ALTER TABLE tng_branches ADD agens INT(11) NOT NULL after personID ... failed or done previously
ALTER TABLE tng_branches ADD dgens INT(11) NOT NULL after agens ... failed or done previously
ALTER TABLE tng_branches ADD dagens INT(11) NOT NULL after dgens ... failed or done previously
ALTER TABLE tng_branches ADD inclspouses TINYINT(4) NOT NULL after dagens ... failed or done previously
ALTER TABLE tng_branches ADD action TINYINT(4) NOT NULL after inclspouses ... failed or done previously
ALTER TABLE tng_cemeteries MODIFY maplink VARCHAR(255) NOT NULL ... done
ALTER TABLE tng_families MODIFY marrtype VARCHAR(90) NOT NULL ... done
ALTER TABLE tng_people ADD burialtype TINYINT(4) NOT NULL after burialplace ... failed or done previously
ALTER TABLE tng_people ADD confdate VARCHAR(50) NOT NULL after baptplace ... failed or done previously
ALTER TABLE tng_people ADD confdatetr DATE NOT NULL after confdate ... failed or done previously
ALTER TABLE tng_people ADD confplace TEXT NOT NULL after confdatetr ... failed or done previously
ALTER TABLE tng_people ADD initdate VARCHAR(50) NOT NULL after confplace ... failed or done previously
ALTER TABLE tng_people ADD initdatetr DATE NOT NULL after initdate ... failed or done previously
ALTER TABLE tng_people ADD initplace TEXT NOT NULL after initdatetr ... failed or done previously
ALTER TABLE tng_eventtypes ADD collapse TINYINT(4) NOT NULL after keep ... failed or done previously
ALTER TABLE tng_media MODIFY mediakey VARCHAR(255) NOT NULL ... done
ALTER TABLE tng_media MODIFY path VARCHAR(255) NULL ... done
ALTER TABLE tng_media MODIFY thumbpath VARCHAR(255) NULL ... done
ALTER TABLE tng_medialinks MODIFY personID VARCHAR(248) NOT NULL ... done
ALTER TABLE tng_mediatypes ADD disabled TINYINT(4) NOT NULL after exportas ... failed or done previously
INSERT IGNORE INTO tng_mediatypes (mediatypeID,display,path,liketype,icon,thumb,exportas,disabled,ordernum) VALUES('photos','','','','','','',0,-6) ... done
INSERT IGNORE INTO tng_mediatypes (mediatypeID,display,path,liketype,icon,thumb,exportas,disabled,ordernum) VALUES('documents','','','','','','',0,-5) ... done
INSERT IGNORE INTO tng_mediatypes (mediatypeID,display,path,liketype,icon,thumb,exportas,disabled,ordernum) VALUES('headstones','','','','','','',0,-4) ... done
INSERT IGNORE INTO tng_mediatypes (mediatypeID,display,path,liketype,icon,thumb,exportas,disabled,ordernum) VALUES('histories','','','','','','',0,-3) ... done
INSERT IGNORE INTO tng_mediatypes (mediatypeID,display,path,liketype,icon,thumb,exportas,disabled,ordernum) VALUES('recordings','','','','','','',0,-2) ... done
INSERT IGNORE INTO tng_mediatypes (mediatypeID,display,path,liketype,icon,thumb,exportas,disabled,ordernum) VALUES('videos','','','','','','',0,-1) ... done
ALTER TABLE tng_saveimport MODIFY ID INT(11) NOT NULL AUTO_INCREMENT ... done
ALTER TABLE tng_sources MODIFY callnum VARCHAR(120) NOT NULL ... done
ALTER TABLE tng_trees ADD importfilename VARCHAR(100) NOT NULL after lastimportdate ... failed or done previously
Setting permissions for mmconfig.php...success

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