-- Datetime format : https://www.sqlite.org/lang_datefunc.html
-- %Y-%m-%d %H:%M:%S
-- https://www.tutorialspoint.com/sqlite/sqlite_data_types.htm

----------------------------
-- *****   REFERENTIELS *******
----------------------------

INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('1', 'Url du mcd', 'MCD', 'https://editor.ponyorm.com/user/lo27/Mcd_2022_03_02/designer', 'href', 'Pour information.');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('2', 'Nom du fichier Gedcom exporté', 'GEDCOMFILE', '/home/laurent/Bureau/export.ged', 'gedcom', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('3', 'Date du fichier Gedcom exporté', 'GEDCOMDATE', ' ', 'gedcom', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('4', 'Auteur du fichier Gedcom exporté', 'GEDCOMAUT', 'moi@fai.com', 'gedcom', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('5', 'Nom du système', 'GEDCOMSOUR', 'SIMPLE_GENEA', 'gedcom', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('6', 'Numéro de version du système', 'GEDCOMSOURVERS', '1.0', 'gedcom', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('7', 'Nom du système sourcesource', 'GEDCOMSOURNAME', 'Simple Genea', 'gedcom', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('8', 'Nom du système sourcesource', 'GEDCOMVERS', '5.5.1', 'gedcom', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('9', 'Nom du système sourcesource', 'GEDCOMCHAR', 'UTF-8', 'gedcom', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('11', 'Dossier destination de l''exportation', 'EXPORTDIR', '/home/laurent/Bureau/OUTTMP', '', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('12', 'Exportation des données privées', 'EXPORTPRIVATE', '1', '', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('13', 'Ouvrir l''index après l''exportation', 'EXPORTOPENRESULT', '1', '', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('14', 'Tracer les données dans le log', 'EXPORTTRACEDATAS', '1', '', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('15', 'Modèle utilisé pour l''exportation', 'EXPORTPATHROOT', 'templates/basique/', '', '');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('16', 'Nombre de niveaux pour l''arbre des ascendants', 'TREASCLEVELMAX', '99', '', 'Nombre de neiveau à prendre en compte lors de la cr&ation de l''arbre des ascendants.');
INSERT INTO "main"."Metadata" ("id", "name", "code", "value", "type", "description") VALUES ('17', 'Identifiant de l''individu Decujus de l''arbre des ascendants', 'TREEASCDECUJUS', '11', '', 'Idendifiant de l''individu Decujus pour la création de l''arbre des ascendants.');


INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('1', 'Document de registre paroissial', 'PAROI', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('2', 'Document de registre d''état civil', 'CIVIL', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('3', 'Document personnel', 'PERSO', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('4', 'Site Web', 'WEB', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('5', 'Livre', 'LIVRE', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('6', 'Photographie', 'PHOTO', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('7', 'Article de journal', 'JOUR', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('8', 'Objet', 'OBJ', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('9', 'Enregistrement sonore', 'SON', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('10', 'Enregistrement vidéo', 'VID', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('11', 'Témoignage', 'TEM', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('12', 'Courrier', 'COUR', '', '');
INSERT INTO "main"."Documenttype" ("id", "name", "code", "description", "icon") VALUES ('13', 'Carte postale', 'POSTAL', '', '');

INSERT INTO "main"."Depot" ("id", "name", "code", "description", "icon", "url", "adress_1", "adress_2", "city", "zip", "country") VALUES ('1', 'Archives départementales de Seine-Maritime', 'AD76', '', '', 'https://www.archivesdepartementales76.net/', '42 Rue Henri-II-de-Plantagenêt', 'Pôle culturel Grammont', 'Rouen', '76100', 'France');
INSERT INTO "main"."Depot" ("id", "name", "code", "description", "icon", "url", "adress_1", "adress_2", "city", "zip", "country") VALUES ('2', 'Archives départementales de L''Orne', 'AD61', '', '', 'https://archives.orne.fr/index.php/consulter-nos-archives-en-ligne', 'Direction des archives et du patrimoine culturel de l''Orne', '8 avenue de Basingstoke', 'Alençon', '61017', 'France');
INSERT INTO "main"."Depot" ("id", "name", "code", "description", "icon", "url", "adress_1", "adress_2", "city", "zip", "country") VALUES ('3', 'Maison', 'MAISON', '', '', '', '', '', '', '', '');
INSERT INTO "main"."Depot" ("id", "name", "code", "description", "icon", "url", "adress_1", "adress_2", "city", "zip", "country") VALUES ('4', 'Musée des antiquités de Rouen', 'MUANTIQR', '', '', '', '', '', '', '', '');
INSERT INTO "main"."Depot" ("id", "name", "code", "description", "icon", "url", "adress_1", "adress_2", "city", "zip", "country") VALUES ('5', 'Page Web', 'WEBPAGE', '', '', '', '', '', '', '', '');
INSERT INTO "main"."Depot" ("id", "name", "code", "description", "icon", "url", "adress_1", "adress_2", "city", "zip", "country") VALUES ('6', 'Dans la famille', 'FAM', '', '', '', '', '', '', '', '');

INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('1', 'Annulation d''un mariage', 'ANUL', 'FAM1', 'Déclaration de non existence d''un mariage depuis le début, comme s''il n''avait jamais existé.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('2', 'Mariage', 'MARR', 'FAM0', 'Un événement légal, civil ou coutumier donnant naissance à une famille entre un homme et une femme en tant que mari et femme.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('3', 'Divorce', 'DIV', 'FAM1', 'Événement qui met fin à un mariage au travers d''une action civile.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('4', 'Fiançailles', 'ENGA', 'FAM1', 'Événement par lequel on va enregistrer ou annoncer l''accord entre deux personnes qui souhaitent se marier.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('5', 'Bans de mariage', 'MARB', 'FAM1', 'Publication officielle de l''intention de mariage entre deux personnes');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('6', 'Autorisation de mariage', 'MARL', 'FAM1', 'Certificats ou autorisations : Événement permettant d''obtenir une autorisation légale à l''effet de se marier.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('7', 'Séparation', '_SEPA', 'FAM1', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('8', 'Union', '_UNION', 'FAM0', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('9', 'Décès', 'DEAT', 'INDI', 'Le moment où la vie terrestre s''arrête.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('10', 'Naissance', 'BIRT', 'FAM2', 'Le moment où commence la vie terrestre.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('11', 'Signature', '_SIGN', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('12', 'Témoin au mariage', '_TEMOIN', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('13', 'Adoption', 'ADOP', 'FAM2', 'Création d''un lien enfant-parent qui n''existe pas biologiquement.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('14', 'Enterrement', 'BURI', 'INDI', 'XVIe siècle, inhumation, dérivé d''inhumer. Action d''inhumer, de porter en terre le corps d''un défunt ; Événement par lequel on va disposer des restes d''une personne décédée.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('15', 'Crémation', 'CREM', 'INDI', 'Soumettre au feu le corps d''une personne décédée.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('16', 'Vivant (living)', '_LVG', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('17', 'Émigration, départ d''un endroit', 'EMIG', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('18', 'Immigration, arrivée dans un endroit', 'IMMI', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('19', 'Association', 'ASSO', 'INDI', 'Un indicateur pour relier des amis, voisins, parents ou toute personne associée à un individu.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('20', 'Relation', 'RELA', 'INDI', 'Indique la relation qui peut exister entre deux événements et/ou entités..');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('21', 'Historique, chronologie de l''individu', '_HIST', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('22', 'Naturalisation', 'NATU', 'INDI', 'L''événement qui marque l''obtention de la citoyenneté.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('23', 'Anoblissement', '_NOBL', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('24', 'Confirmation', 'CONF', 'INDI', 'Cérémonie religieuse (non Mormone) par laquelle un individu acquiert la qualité de membre à part entière de son Église.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('25', 'Première communion', 'FCOM', 'INDI', 'Un rite religieux, le premier acte de partage de la Cène (Eucharistie) pour montrer son appartenance à l''Église.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('26', 'Religion pratiquée', 'RELI', 'INDI', 'Une dénomination religieuse à laquelle une personne a adhéré ou pour laquelle un enregistrement s''applique.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('27', 'Ondoiement', '_ONDO', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('28', 'Ordination, entrée en religion', 'ORDN', 'INDI', 'Événement religieux donnant autorité pour agir dans le domaine religieux.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('29', 'Liste de passagers', '_PASL', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('30', 'Ouverture d''un testament', 'PROB', 'INDI', 'Événement permettant une détermination juridique de la validité d''un testament.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('31', 'Résidence', 'RESI', 'INDI', 'Le fait de résider à une adresse pendant une période donnée.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('32', 'Remarque', '_RMRK', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('33', 'Pierre tombale', '_TBS', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('34', 'Testament', 'WILL', 'INDI', 'Un document ayant force légale traité comme un événement, par lequel une personne dispose de ses biens, et devant prendre effet à son décès. La date de l''événement est celle à laquelle le testament a été signé pendant que la personne était vivante.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('35', 'Crime', '_CRIM', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('36', 'Donation', '_DONA', 'INDI', '');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('37', 'Éducation', 'EDUC', 'INDI', 'Indicateur d''un niveau d''éducation atteint.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('38', 'Diplôme', 'GRAD', 'INDI', 'Événement marquant l''attribution d''un degré éducatif ou autre à un individu.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('39', 'Métier', 'OCCU', 'INDI', 'Le type de travail ou profession d''un individu.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('40', 'Retraite', 'RETI', 'INDI', 'Événement qui marque la fin d''une relation professionnelle par un employé vis à vis de son travail après une période d''activité.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('41', 'Requête en divorce', 'DIVF', 'INDI', 'Événement par lequel un(e) époux(se) va demander le divorce.');
INSERT INTO "main"."Eventtype" ("id", "name", "code", "category", "description") VALUES ('42', 'Rôle', 'ROLE', 'INDI', 'Une dénomination donnée au rôle joué par une personne en relation avec un événement.');

INSERT INTO "main"."Place" ("id", "name", "description", "private", "icon", "adress1", "adress2", "zipcode", "city", "cityinsee", "country", "url", "gpslat", "gpslon", "datecreated") VALUES ('1', 'Paris', '', '0', '', '', '', '75000', 'Paris', '', 'France', '', '48.864716', '2.349014', '2022-03-13 12:21');
INSERT INTO "main"."Place" ("id", "name", "description", "private", "icon", "adress1", "adress2", "zipcode", "city", "cityinsee", "country", "url", "gpslat", "gpslon", "datecreated") VALUES ('2', 'Rouen', '', '0', '', '', '', '76000', 'Rouen', '', 'France', '', '49.442536', '1.092968', '2022-03-12 10:04');
INSERT INTO "main"."Place" ("id", "name", "description", "private", "icon", "adress1", "adress2", "zipcode", "city", "cityinsee", "country", "url", "gpslat", "gpslon", "datecreated") VALUES ('3', 'Aubusson', '', '0', '', '', '', '61100', 'Aubusson', '', 'France', '', '48.787039', '-0.552578', '2022-03-12 10:04');
INSERT INTO "main"."Place" ("id", "name", "description", "private", "icon", "adress1", "adress2", "zipcode", "city", "cityinsee", "country", "url", "gpslat", "gpslon", "datecreated") VALUES ('4', 'Saint Georges des G.', '', '0', '', '', '', '61100', 'Saint Georges des Groseillers', '', 'France', '', '48.76993', '-0.56768', '2022-03-12 10:06');
INSERT INTO "main"."Place" ("id", "name", "description", "private", "icon", "adress1", "adress2", "zipcode", "city", "cityinsee", "country", "url", "gpslat", "gpslon", "datecreated") VALUES ('5', 'Canteleu', '', '0', '', '', '', '76000', 'Canteleu', '', 'France', '', '49.45325', '1.03323', '2022-03-12 10:04');
INSERT INTO "main"."Place" ("id", "name", "description", "private", "icon", "adress1", "adress2", "zipcode", "city", "cityinsee", "country", "url", "gpslat", "gpslon", "datecreated") VALUES ('6', 'Les Authieux Sur le Port Saint Ouen', '', '0', '', '', '', '76000', 'Les Authieux Sur le Port Saint Ouen', '', 'France', '', '49.340477', '1.130991', '2022-03-12 10:10');
INSERT INTO "main"."Place" ("id", "name", "description", "private", "icon", "adress1", "adress2", "zipcode", "city", "cityinsee", "country", "url", "gpslat", "gpslon", "datecreated") VALUES ('7', 'Bonsecours', '', '0', '', '', '', '76200', 'Bonsecours', '', 'France', '', '49.423407', '1.127386', '2022-03-12 10:04');
INSERT INTO "main"."Place" ("id", "name", "description", "private", "icon", "adress1", "adress2", "zipcode", "city", "cityinsee", "country", "url", "gpslat", "gpslon", "datecreated") VALUES ('8', 'Mesnil-Esnard', '', '0', '', '', '', '76420', 'Mesnil Esnard', '', 'France', '', '49.411991', '1.139173', '2022-03-12 10:05');
INSERT INTO "main"."Place" ("id", "name", "description", "private", "icon", "adress1", "adress2", "zipcode", "city", "cityinsee", "country", "url", "gpslat", "gpslon", "datecreated") VALUES ('9', 'Franqueville Saint Pierre', '', '0', '', '', '', '61100', 'Franqueville Saint Pierre', '', 'France', '', '49.404198', '1.175108', '2022-03-12 10:04');

-- **********************************************************************

---------------------
-- *****   DATAS *******
---------------------

-- ***************************  Individus
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('1', 'Pierre Premier', 'k0', '', 'Pierre', 'Premier', '0', 'PHOTOS/blier-4.png', 'M', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('2', 'Marie Second', 'k1', '', 'Marie', 'Second', '0', '', 'F', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('3', 'Roger Le Tiers', 'k2', '', 'Roger', 'Le Tiers', '0', '', 'M', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('4', 'Louise Quart', 'k3', '', 'Louise', 'Quart', '0', '', 'F', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('5', 'Kevin Grand', 'k4', '', 'Kevin', 'Grand', '0', '', 'M', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('6', 'Julie Hebert', 'k5', '', 'Julie', 'Herbert', '0', '', 'F', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('7', 'Toto Z', 'k6', '', 'Toto', 'Z', '0', '', 'M', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('8', 'Jean Pierrot', 'k7', '', 'Jean', 'Pierrot', '0', '', 'M', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('9', 'nouvelle personne', '', '', 'PRENOM', 'NOM DE FAMILLE', '0', 'PHOTOS/woman-3169726_960_720.webp', 'F', '', '', '', '', '', '2022-05-14 20:17');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('10', 'Titi', 'k8', '', 'le prénom', 'TITI 1Er', '0', '', 'M', '', '', '', '', '', '2022-05-14 19:28');
INSERT INTO "main"."Person" ("id", "name", "key", "description", "firstname", "lastname", "private", "icon", "sex", "notesearch", "firstnameprefix", "firtsnameothers", "lastnamesuffix", "surname", "datecreated") VALUES ('11', 'Fils titi', 'k9', '', 'roger', 'Titi', '0', 'PHOTOS/675-536x354.jpg', 'M', '', '', '', '', '', '2022-05-14 20:10');

-- ***************************  Evenements
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('3', 'Naissance de Louise Quart (mère=Marie Second père=Pierre Premier)', '', '0', '', '1866-05-07 00:00', '', '', '2022-05-13 11:59', '4', '2', '1', '10', '1');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('5', 'Décès de Pierre Premier ', '', '0', '', '1880-01-18 15:21', '', '', '2022-05-13 11:59', '1', '', '', '9', '3');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('6', 'Mariage de Louise Quart et Roger Le Tiers', '', '0', '', '1870-07-22 00:00', 'ABT', '', '2022-05-13 11:59', '3', '4', '', '2', '6');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('7', 'Naissance de Kevin Grand (mère=Louise Quart, père=Roger Le Tiers)', '', '0', '', '1888-09-08 16:42', '', '', '2022-05-13 11:59', '5', '4', '3', '10', '4');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('8', 'Naissance de Pierre Premier', '', '0', '', '1833-07-12 18:59', '', 'à corriger', '2022-05-15 13:48', '1', '', '', '10', '1');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('9', 'Mariage Pierre Premier et Marie Second', 'Description du mariage ici ...', '0', 'PHOTOS/Mariage Maurice Leblanc et Marthe Leblanc.png', '1859-09-20 00:00', '', '', '2022-05-13 11:59', '1', '2', '', '2', '8');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('10', 'Naissance de julie', '', '0', '', '1862-01-11 00:00', '', '', '2022-05-13 11:59', '6', '2', '1', '10', '5');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('11', 'Mariage Toto Z et julie', '', '0', '', '1882-07-12 00:00', '', '', '2022-05-13 11:59', '7', '6', '', '2', '5');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('12', 'Naissande de J. Pierrot', '', '0', '', '1867-10-12 00:00', '', '', '2022-05-13 11:59', '8', '2', '1', '10', '2');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('13', 'Départ d''Aubusson vers Canteleu', '', '0', '', '1781-10-17 00:00', 'ABT', '', '2022-05-13 11:59', '8', '', '', '17', '3');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('14', 'Naissance de nouvel individu', '', '0', '', '1891-07-12 00:00', '', '', '2022-05-14 19:17', '9', '4', '3', '10', '9');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('15', 'Mariage titi', '', '0', '', '1912-01-10 00:00', '', '', '2022-05-14 19:30', '10', '9', '', '2', '7');
INSERT INTO "main"."Event" ("id", "name", "description", "private", "icon", "date_begin", "date_begin_accurate", "notesearch", "datecreated", "person_1_id", "person_2_id", "person_3_id", "eventtype_id", "place_id") VALUES ('16', 'Naissance roger titi', '', '0', 'PHOTOS/675-536x354.jpg', '1914-12-10 00:00', '', '', '2022-05-14 20:09', '11', '9', '10', '10', '7');

-- ***************************  Documents
INSERT INTO "main"."Document" ("id", "name", "description", "private", "icon", "url", "cote", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id") VALUES ('1', 'Acte de mariage Pierre Premier - Marie Second', '', '', '', 'http://iso.fissa.net', '', '', '', '2022-05-13 11:17', '1', '3');
INSERT INTO "main"."Document" ("id", "name", "description", "private", "icon", "url", "cote", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id") VALUES ('2', 'Acte de naissance de Kevin Grand', '', '', '', 'http://iso.fissa.net/xxxx', '', '', '', '2022-05-13 11:17', '1', '2');
INSERT INTO "main"."Document" ("id", "name", "description", "private", "icon", "url", "cote", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id") VALUES ('3', 'Livre des soldats de la première guerre mondiale', '', '', '', '', '', '', '', '2022-05-13 11:17', '3', '5');
INSERT INTO "main"."Document" ("id", "name", "description", "private", "icon", "url", "cote", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id") VALUES ('4', 'Photographie de mariage Maurice Leblanc', '', '', '', '/mesdocuments/leblanc/mariagemaurice.png', '', '', '', '2022-05-13 11:17', '3', '6');
INSERT INTO "main"."Document" ("id", "name", "description", "private", "icon", "url", "cote", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id") VALUES ('5', 'Registre paroissial des Authieux sur Le Port Saint Ouen, 1785-1791', '', '0', '', 'https://www.archivesdepartementales76.net/archive/catalogue/communes76/authieux-sur-le-port-saint-ouen-les/n:168', 'AS760001', '', '10', '2022-05-13 11:48', '1', '1');
INSERT INTO "main"."Document" ("id", "name", "description", "private", "icon", "url", "cote", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id") VALUES ('6', 'Second document', '', '0', '', '', '', '', '20', '2022-05-13 11:48', '3', '4');

-- ***************************  Sources 
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('3', 'Acte de naissance annoté de Kevin Grand', '', '0', '', '', 'vardon jean X pierre/N-17760408-vardon-0-AD76-3E 00264-47-g3-02.png', '', '', '', '', '', '', '20', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('5', 'Acte de mariage de Louise Grand et Roger Le Tiers', '', '0', '', '', '', 'http://www.duckduckgo.com', '', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('6', 'Naissance de Louise Quart', '', '0', '', '', 'farin eugène pierre - dehays marie alphonsine/N-18690219-farin-0-AD76- 3 E 999-4-g1-01.jpg', '', '', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('7', 'Mariage de Pierre Premier et  Marie Second', 'Description de l''acte de marriage ...', '0', '', '0', 'vardon jean baptiste alexandre - guillard amélie thérese/M-18301018-vardon-0-AD76-3 E 999-v20-g3-01.jpg,vardon henry gustave - farin marie alphonsine/N-18960213-farin-0-AD76-cote-18-d-01.png', '', '***** texte en plus', '125', 'en haut à droite', '', '', '10', '2022-05-13 23:54');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('8', 'Acte de naissance de Pierre Premier', '', '0', '', '3', 'farin pierre - gohée marie augustine/M-18690509-farin-0--AD76-3 E 999-9-d1-01.jpg', '', '', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('9', 'Source mariage de Julie', '', '0', '', '', 'vardon pierre - blot marie madeleine/M-17750627-vardon-0-AD76-4 E 1438-196-d3-01.jpg,vardon pierre - blot marie madeleine/M-17750627-vardon-0-AD76-4 E 1438-196-g1-02.jpg', '', '', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('10', 'Seconde source mariage pm', '', '0', '', '', 'vardon mathilde zéphyrin - guillard rose euphrasie/M-18660818-vardon-0-AD76-cote-vue-02.png', '', '', '58', 'en bas', '', '', '40', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('11', 'Source audio du départ', 'Description de la source audio', '0', '', '2', '', 'dossier_audio/audio.mp3', '« sdfsdf sd fsdf psfd psf description de la source audio ... »', '', '', '', '', '', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('12', 'Source audio du mariage', '', '0', '', '', '', 'PHOTOS/Mauricette Leblanc - A propos de Charlotte Coquerel.flac', '', '', '', '', '', '15', '2022-05-14 20:23');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('13', 'Source vidéo', '', '0', '', '', '', 'PHOTOS/MOV-010-VIDEO0028.mp4', '', '', 'à la 4em minute...', '', '', '20', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('14', 'Source de type texte', '', '0', '', '', '', '', 'Lorem ipsum ....', '', '', '', '', '60', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('15', 'Acte de naissance PDf', '', '0', '', '', '', 'PHOTOS/cellules_solaris.pdf', '', '', '', '', '', '10', '2022-05-13 11:59');
INSERT INTO "main"."Source" ("id", "name", "description", "private", "icon", "quality", "localurl", "sourceurl", "sourcetext", "page", "citation", "textdraduction", "notesearch", "sortorder", "datecreated") VALUES ('16', 'Source primaire de naissance', '', '0', 'PHOTOS/234-536x354.jpg', '', 'vardon jean baptiste - cousin marie victoire margueritte geneviève/E-17810901-cousin-0-AD76-cote-vue-01.jpg', '', '', '99', 'au milieu de la page', '', '', '10', '2022-05-14 20:17');

-- ***************************  Liens evenements - sources
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('2', '6', '5', '1', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('3', '7', '3', '', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('5', '9', '7', '5', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('6', '9', '7', '6', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('7', '9', '7', '', '2022-05-13 23:54');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('8', '8', '8', '', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('9', '11', '9', '', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('10', '9', '10', '', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('11', '13', '11', '', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('12', '9', '12', '', '2022-05-14 20:23');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('13', '9', '13', '', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('14', '9', '14', '', '2022-05-13 11:59');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('15', '14', '16', '', '2022-05-14 19:27');
INSERT INTO "main"."Event_source" ("id", "event_id", "source_id", "document_id", "datecreated") VALUES ('16', '14', '16', '', '2022-05-14 20:17');

-- ***************************  Médias
INSERT INTO "main"."Media" ("id", "name", "url", "datemedia", "description", "dimension", "origin", "private", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id", "event_id") VALUES ('1', 'Média enregistrement audio', 'PHOTOS/Mauricette Leblanc - A propos de Charlotte Coquerel.flac', '0001-01-01 00:00', '', '', 'Enregistrement personnel', '0', '', '20', '2022-05-13 11:56', '6', '9', '9');
INSERT INTO "main"."Media" ("id", "name", "url", "datemedia", "description", "dimension", "origin", "private", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id", "event_id") VALUES ('2', 'Média de type PDF', 'PHOTOS/contact-sheet.pdf', '0001-01-01 00:00', '', '', '', '2', '', '30', '2022-05-13 11:56', '5', '12', '');
INSERT INTO "main"."Media" ("id", "name", "url", "datemedia", "description", "dimension", "origin", "private", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id", "event_id") VALUES ('3', 'Media photo', 'PHOTOS/blier-5.png', '0001-01-01 00:00', '', '', '', '0', '', '10', '2022-05-13 11:57', '5', '6', '8');
INSERT INTO "main"."Media" ("id", "name", "url", "datemedia", "description", "dimension", "origin", "private", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id", "event_id") VALUES ('4', 'média vidéo', 'PHOTOS/MOV-010-VIDEO0028.mp4', '0001-01-01 00:00', '', '', '', '0', '', '40', '2022-05-13 11:56', '6', '10', '');
INSERT INTO "main"."Media" ("id", "name", "url", "datemedia", "description", "dimension", "origin", "private", "notesearch", "sortorder", "datecreated", "depot_id", "documenttype_id", "event_id") VALUES ('5', 'Exemple de média', 'PHOTOS/happy-man-tiny.jpg', '0001-01-01 00:00', '', '', '', '0', '', '', '2022-05-13 11:54', '3', '', '');

-- ***************************  Liens médias - invividus
INSERT INTO "main"."Media_person" ("id", "media_id", "person_id", "datecreated") VALUES ('1', '1', '1', '2022-05-10 11:44');
INSERT INTO "main"."Media_person" ("id", "media_id", "person_id", "datecreated") VALUES ('2', '2', '1', '2022-05-10 16:00');
INSERT INTO "main"."Media_person" ("id", "media_id", "person_id", "datecreated") VALUES ('3', '3', '1', '2022-05-09 17:25');
INSERT INTO "main"."Media_person" ("id", "media_id", "person_id", "datecreated") VALUES ('4', '4', '1', '2022-05-10 11:43');
INSERT INTO "main"."Media_person" ("id", "media_id", "person_id", "datecreated") VALUES ('5', '5', '2', '2022-05-10 19:02');