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=110 DEFAULT CHARSET=latin1;
INSERT INTO tng_eventtypes (eventtypeID,tag,description,display,keep,collapse,ordernum,ldsevent,type) VALUES
("1","CENS","","Census","1","0","0","0","I"),
("2","_FLGS","","Flag","1","0","0","0","I"),
("3","_USED","","Given Name Used","1","0","-1","0","I"),
("4","*AKA ","","Given Name Used","1","0","-1","0","I"),
("5","RESI","","Residence","1","0","0","0","I"),
("6","EDUC","","Education","1","0","0","0","I"),
("7","EVEN","Holiday (single)","Holiday (single)","1","0","0","0","I"),
("8","OCCU","","Occupation","1","0","0","0","I"),
("9","PROP","","Possessions","1","0","0","0","I"),
("10","WILL","","Will","1","0","0","0","I"),
("11","EVEN","Funeral","Funeral","1","0","0","0","I"),
("12","DEAT","","Death","1","0","0","0","I"),
("13","EVEN","Employment","Employment","1","0","0","0","I"),
("14","EVEN","Enlisted","Enlisted","1","0","0","0","I"),
("15","EVEN","Service","Service","1","0","0","0","I"),
("16","EVEN","Rank","Rank","1","0","0","0","I"),
("17","CONF","","Confirmation","1","0","0","0","I"),
("18","EVEN","Interest","Interest","1","0","0","0","I"),
("19","EVEN","? Death Informant","? Death Informant","1","0","0","0","I"),
("20","EVEN","? Marriage Witness","? Marriage Witness","1","0","0","0","I"),
("21","NAME","","Name","1","0","0","0","I"),
("22","EVEN","Examination","Examination","1","0","0","0","I"),
("23","GRAD","","Graduation","1","0","0","0","I"),
("24","BURI","","Burial","1","0","0","0","I"),
("25","EVEN","Attested","Attested","1","0","0","0","I"),
("26","EVEN","Regiment","Regiment","1","0","0","0","I"),
("27","EVEN","Service No.","Service No.","1","0","0","0","I"),
("28","EVEN","Height","Height","1","0","0","0","I"),
("29","EVEN","Eyes","Eyes","1","0","0","0","I"),
("30","EVEN","Hair","Hair","1","0","0","0","I"),
("31","EVEN","Complexion","Complexion","1","0","0","0","I"),
("32","EVEN","Chest Size","Chest Size","1","0","0","0","I"),
("33","EVEN","Trade/Skill","Trade/Skill","1","0","0","0","I"),
("34","EVEN","Embarked","Embarked","1","0","0","0","I"),
("35","EVEN","Theatre of War","Theatre of War","1","0","0","0","I"),
("36","EVEN","Posted","Posted","1","0","0","0","I"),
("37","EVEN","Transferred","Transferred","1","0","0","0","I"),
("38","EVEN","Discharged (Military)","Discharged (Military)","1","0","0","0","I"),
("39","EVEN","Medal","Medal","1","0","0","0","I"),
("40","IMMI","","Immigration","1","0","0","0","I"),
("41","EMIG","","Emigration","1","0","0","0","I"),
("42","EVEN","Military ID","Military ID","1","0","0","0","I"),
("43","EVEN","Military Service","Military Service","1","0","0","0","I"),
("44","EVEN","Letter from","Letter from","1","0","0","0","I"),
("45","EVEN","Visa","Visa","1","0","0","0","I"),
("46","EVEN","Departure","Departure","1","0","0","0","I"),
("47","EVEN","Flew","Flew","1","0","0","0","I"),
("48","EVEN","Arrival","Arrival","1","0","0","0","I"),
("49","EVEN","? Birth Informant","? Birth Informant","1","0","0","0","I"),
("50","PROB","","Probate","1","0","0","0","I"),
("51","EVEN","? Residence Resident","? Residence Resident","1","0","0","0","I"),
("52","RELI","","Religion","1","0","0","0","I"),
("53","EVEN","? Death Informant and Informant","? Death Informant and Informant","1","0","0","0","I"),
("54","DSCR","","Physical Description","1","0","0","0","I"),
("55","RETI","","Retired","1","0","0","0","I"),
("56","EVEN","Funeral Service","Funeral Service","1","0","0","0","I"),
("57","NATI","","Nationality","1","0","0","0","I"),
("58","EVEN","? Probate Beneficiary","? Probate Beneficiary","1","0","0","0","I"),
("59","EVEN","? Burial Mourner","? Burial Mourner","1","0","0","0","I"),
("60","EVEN","Apprenticeship","Apprenticeship","1","0","0","0","I"),
("61","EVEN","Holiday","Holiday","1","0","0","0","I"),
("62","EVEN","Hobby","Hobby","1","0","0","0","I"),
("63","IDNO","","National ID Number","1","0","0","0","I"),
("64","EVEN","? Will Executor and Beneficiary","? Will Executor and Beneficiary","1","0","0","0","I"),
("65","EVEN","Salary","Salary","1","0","0","0","I"),
("66","FCOM","","First Communion","1","0","0","0","I"),
("67","EVEN","Letter to","Letter to","1","0","0","0","I"),
("68","EVEN","Memorial","Memorial","1","0","0","0","I"),
("69","EVEN","? Birth Father","? Birth Father","1","0","0","0","I"),
("70","EVEN","Grave Location","Grave Location","1","0","0","0","I"),
("71","EVEN","Military Discharge","Military Discharge","1","0","0","0","I"),
("72","EVEN","? Marriage Best man","? Marriage Best man","1","0","0","0","I"),
("73","EVEN","? Marriage Bridesmaid","? Marriage Bridesmaid","1","0","0","0","I"),
("74","BAPM","","Baptism","1","0","0","0","I"),
("75","EVEN","Medical History","Medical History","1","0","0","0","I"),
("76","_UID","","_UID","1","0","0","0","I"),
("77","EVEN","Wounded","Wounded","1","0","0","0","I"),
("78","EVEN","? Marriage Role Unknown","? Marriage Role Unknown","1","0","0","0","I"),
("79","EVEN","Campaign Medal","Campaign Medal","1","0","0","0","I"),
("80","EVEN","Weight (Military)","Weight (Military)","1","0","0","0","I"),
("81","REFN","","Reference Number","1","0","0","0","I"),
("82","EVEN","Joined","Joined","1","0","0","0","I"),
("83","EVEN","Demobbed","Demobbed","1","0","0","0","I"),
("84","CHR","","Christening","1","0","0","0","I"),
("85","NMR","","Count of Marriages","1","0","0","0","I"),
("86","NCHI","","Count of Children","1","0","0","0","I"),
("87","EVEN","Wedding reception","Wedding reception","1","0","0","0","F"),
("88","EVEN","Honeymoon","Honeymoon","1","0","0","0","F"),
("89","EVEN","Holiday","Holiday","1","0","0","0","F"),
("90","DIVF","","Divorce Filed","1","0","0","0","F"),
("91","EVEN","Party","Party","1","0","0","0","F"),
("92","EVEN","? Residence:RESI","? Residence:RESI","1","0","0","0","F"),
("93","EVEN","Possession","Possession","1","0","0","0","F"),
("94","NCHI","","Count of Children","1","0","0","0","F"),
("95","EVEN","Officiating Minister","Officiating Minister","1","0","0","0","F"),
("96","MARB","","Marriage Banns","1","0","0","0","F"),
("97","MARR","","Married","1","0","0","0","F"),
("98","WWW","","WWW","1","0","0","0","R"),
("99","REFN","","Reference Number","1","0","0","0","R"),
("100","PHON","","Phone","1","0","0","0","R"),
("101","EMAIL","","EMAIL","1","0","0","0","R"),
("102","_PLAC","","_PLAC","1","0","0","0","R"),
("103","FACT","","FACT","1","0","0","0","I"),
("104","_STAT","","_STAT","1","0","0","0","F"),
("105","RESI","","Residence","1","0","0","0","F"),
("106","_ATTR","","_ATTR","1","0","0","0","F"),
("107","_SRCT","","_SRCT","1","0","0","0","S"),
("108","_FIELD","","_FIELD","1","0","0","0","S"),
("109","_TYPE","","_TYPE","1","0","0","0","S");