-- Facts-TranslateNames.sql
BEGIN;
DROP TABLE IF EXISTS xFactTypeTranslTable;
CREATE TABLE xFactTypeTranslTable (FactTypeID INTEGER PRIMARY KEY, Name_Eng TEXT, Abbrev_Eng TEXT, Name_Tra TEXT, Abbrev_Tra TEXT);
INSERT INTO xFactTypeTranslTable VALUES(1,'Birth','Birth','Né','Né');
INSERT INTO xFactTypeTranslTable VALUES(2,'Death','Death','Mort','Mort');
INSERT INTO xFactTypeTranslTable VALUES(3,'Christen','Chr','Baptisé','Baptisé');
INSERT INTO xFactTypeTranslTable VALUES(4,'Burial','Burial','Enterré','Enterré');
INSERT INTO xFactTypeTranslTable VALUES(5,'Cremation','Cremation','Incinéré','Incinéré');
INSERT INTO xFactTypeTranslTable VALUES(6,'Adoption','Adoption','Adopté','Adopté');
INSERT INTO xFactTypeTranslTable VALUES(7,'Baptism','Baptism','Baptisée','Baptisée');
INSERT INTO xFactTypeTranslTable VALUES(8,'Bar Mitzvah','Bar Mitzvah','Bar Mitzvah','Bar Mitzvah');
INSERT INTO xFactTypeTranslTable VALUES(9,'Bas Mitzvah','Bas Mitzvah','Bas Mitzvah','Bas Mitzvah');
INSERT INTO xFactTypeTranslTable VALUES(10,'Blessing','Blessing','Béni','Béni');
INSERT INTO xFactTypeTranslTable VALUES(11,'Christen (adult)','Chr (adult)','Baptisé ( adulte)','Baptisé ( adulte)');
INSERT INTO xFactTypeTranslTable VALUES(12,'Confirmation','Confirmation','Confirmation','Confirmation');
INSERT INTO xFactTypeTranslTable VALUES(13,'First communion','First comm','Première communion','1ière communion');
INSERT INTO xFactTypeTranslTable VALUES(14,'Ordination','Ordination','Ordonné','Ordonné');
INSERT INTO xFactTypeTranslTable VALUES(15,'Naturalization','Naturalization','Naturalisé','Naturalisé');
INSERT INTO xFactTypeTranslTable VALUES(16,'Emigration','Emigration','Émigré','Émigré');
INSERT INTO xFactTypeTranslTable VALUES(17,'Immigration','Immigration','Immigré','Immigré');
INSERT INTO xFactTypeTranslTable VALUES(18,'Census','Census','Dénombré','Dénombré');
INSERT INTO xFactTypeTranslTable VALUES(19,'Probate','Probate','Homologué','Homologué');
INSERT INTO xFactTypeTranslTable VALUES(20,'Will','Will','Testament','Testament');
INSERT INTO xFactTypeTranslTable VALUES(21,'Graduation','Graduation','Diplômé','Diplômé');
INSERT INTO xFactTypeTranslTable VALUES(22,'Retirement','Retirement','Retraite','Retraite');
INSERT INTO xFactTypeTranslTable VALUES(23,'Description','Description','Description','Description');
INSERT INTO xFactTypeTranslTable VALUES(24,'Education','Education','Éducation','Éducation');
INSERT INTO xFactTypeTranslTable VALUES(25,'Nationality','Nationality','Nationalité','Nationalité');
INSERT INTO xFactTypeTranslTable VALUES(26,'Occupation','Occupation','Occupation','Occupation');
INSERT INTO xFactTypeTranslTable VALUES(27,'Property','Property','Propriété','Propriété');
INSERT INTO xFactTypeTranslTable VALUES(28,'Religion','Religion','Religion','Religion');
INSERT INTO xFactTypeTranslTable VALUES(29,'Residence','Residence','Résidence','Résidence');
INSERT INTO xFactTypeTranslTable VALUES(30,'Soc Sec No','SSN','Soc Sec No.','SSN');
INSERT INTO xFactTypeTranslTable VALUES(31,'LDS Baptism','LDS Bapt','LDS Baptême','LDS Bapt');
INSERT INTO xFactTypeTranslTable VALUES(32,'LDS Endowment','LDS Endow','Taille du LDS','LDS Endow');
INSERT INTO xFactTypeTranslTable VALUES(33,'LDS Seal to parents','LDS SealPar','LDS Seal aux parents','LDS SealPar');
INSERT INTO xFactTypeTranslTable VALUES(34,'Ancestral File Number','AFN','Ancestral File Number','AFN');
INSERT INTO xFactTypeTranslTable VALUES(35,'Reference No','Ref #','Numéro de référence','Réf #');
INSERT INTO xFactTypeTranslTable VALUES(36,'Caste','Caste','Caste','Caste');
INSERT INTO xFactTypeTranslTable VALUES(37,'Title (Nobility)','Title','Titre (Noblesse)','Titre');
INSERT INTO xFactTypeTranslTable VALUES(38,'LDS Confirmation','LDS Conf','LDS Confirmation','LDS Conf');
INSERT INTO xFactTypeTranslTable VALUES(39,'LDS Initiatory','LDS Init','LDS initiatique','LDS Init');
INSERT INTO xFactTypeTranslTable VALUES(300,'Marriage','Marriage','Mariage','Mariage');
INSERT INTO xFactTypeTranslTable VALUES(301,'Annulment','Annulment','Annulation','Annulation');
INSERT INTO xFactTypeTranslTable VALUES(302,'Divorce','Divorce','Divorce','Divorce');
INSERT INTO xFactTypeTranslTable VALUES(303,'Divorce filed','Div. filed','Divorce déposée','Div . déposée');
INSERT INTO xFactTypeTranslTable VALUES(304,'Engagement','Engagement','Engagement','Engagement');
INSERT INTO xFactTypeTranslTable VALUES(305,'Marriage Bann','Marr Bann','Bans de mariage','Bans mar.');
INSERT INTO xFactTypeTranslTable VALUES(306,'Marriage Contract','Marr Contract','Contrat de mariage','Contrat mar.');
INSERT INTO xFactTypeTranslTable VALUES(307,'Marriage License','Marr Lic','Licence de mariage','Lic. Mar.');
INSERT INTO xFactTypeTranslTable VALUES(308,'Marriage Settlement','Marr Settlement','Mariage Règlement','Mar. règlement');
INSERT INTO xFactTypeTranslTable VALUES(309,'LDS Seal to spouse','LDS SealSp','LDS Seal au conjoint','LDS SealSp');
INSERT INTO xFactTypeTranslTable VALUES(310,'Residence (family)','Residence (fam)','Résidence (famille)','Résidence (fam)');
INSERT INTO xFactTypeTranslTable VALUES(311,'Census (family)','Census (fam)','Recensement (famille)','Recensement (fam)');
INSERT INTO xFactTypeTranslTable VALUES(500,'Degree','Degree','Degré','Degré');
INSERT INTO xFactTypeTranslTable VALUES(501,'Military','Military','Militaire','Militaire');
INSERT INTO xFactTypeTranslTable VALUES(502,'Mission','Mission','Mission','Mission');
INSERT INTO xFactTypeTranslTable VALUES(503,'Stillborn','Stillborn','Mort-né','Mort-né');
INSERT INTO xFactTypeTranslTable VALUES(504,'Illness','Illness','Maladie','Maladie');
INSERT INTO xFactTypeTranslTable VALUES(505,'Living','Living','Vivant','Vivant');
INSERT INTO xFactTypeTranslTable VALUES(507,'Election','Elected','Élection','Élu');
INSERT INTO xFactTypeTranslTable VALUES(508,'Excommunication','Excomm','Excommunication','Excommunié');
INSERT INTO xFactTypeTranslTable VALUES(509,'Namesake','Namesake','Homonyme','Homonyme');
INSERT INTO xFactTypeTranslTable VALUES(510,'Separation','Separation','Séparation','Séparation');
INSERT INTO xFactTypeTranslTable VALUES(900,'Alternate name','Alt. Name','Nom alternatif','Nom Alt.');
INSERT INTO xFactTypeTranslTable VALUES(901,'DNA test','DNA','Test d''ADN','ADN');
INSERT INTO xFactTypeTranslTable VALUES(999,'Miscellaneous','Misc','Divers','Divers');
UPDATE FactTypeTable SET Name=(SELECT Name_Tra FROM xFactTypeTranslTable X WHERE FactTypeTable.FactTypeID = X.FactTypeID) WHERE FactTypeID<1000;
UPDATE FactTypeTable SET Abbrev=(SELECT Abbrev_Tra FROM xFactTypeTranslTable X WHERE FactTypeTable.FactTypeID = X.FactTypeID) WHERE FactTypeID<1000;
COMMIT;
-- end of script