DROP TABLE IF EXISTS tng_eventtypes;
CREATE TABLE `tng_eventtypes` (
  `eventtypeID` int(11) NOT NULL AUTO_INCREMENT,
  `tag` varchar(10) NOT NULL,
  `description` varchar(90) NOT NULL,
  `display` text NOT NULL,
  `keep` tinyint(4) NOT NULL,
  `collapse` tinyint(4) NOT NULL,
  `ordernum` smallint(6) NOT NULL,
  `ldsevent` tinyint(4) NOT NULL,
  `type` char(1) NOT NULL,
  PRIMARY KEY (`eventtypeID`),
  UNIQUE KEY `typetagdesc` (`type`,`tag`,`description`),
  KEY `ordernum` (`ordernum`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
INSERT INTO tng_eventtypes (eventtypeID,tag,description,display,keep,collapse,ordernum,ldsevent,type) VALUES
("1","FSID","","FSID","1","0","0","0","I"),
("2","_DNA","","_DNA","1","0","0","0","I"),
("3","EVEN","Special","Special","1","0","0","0","I"),
("4","_MILT","","_MILT","1","0","0","0","I"),
("5","EVEN","Arrival","Arrival","1","0","0","0","I"),
("6","RELI","","Religion","1","0","0","0","I"),
("7","EVEN","Find A Grave","Find A Grave","1","0","0","0","I"),
("8","NAME","","Name","1","0","0","0","I"),
("9","OCCU","","Occupation","1","0","0","0","I"),
("10","BAPM","","Baptism","1","0","0","0","I"),
("11","NATU","","Naturalization","1","0","0","0","I"),
("12","CHR","","Christening","1","0","0","0","I"),
("13","TITL","","Title","1","0","0","0","I"),
("14","DEAT","","Death","1","0","0","0","I"),
("15","BIRT","","Birth","1","0","0","0","I"),
("16","NATI","","Nationality","1","0","0","0","I"),
("17","EMIG","","Emigration","1","0","0","0","I"),
("18","MARR","","Married","1","0","0","0","F"),
("19","EMAIL","","EMAIL","1","0","0","0","R"),
("20","PHON","","Phone","1","0","0","0","R");