-- 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"."Map" ("name") VALUES ('Ressources locales');

INSERT INTO "main"."Category" ("id", "name", "checked", "form", "iconurl", "owner", "map_id") VALUES ('1', 'Exutoires', '1', 'exutoires', 'icons/default.png', 'laurent', '1');
INSERT INTO "main"."Category" ("id", "name", "checked", "form", "iconurl", "owner", "map_id") VALUES ('2', 'Basiques', '1', 'basiques', 'icons/default.png', 'laurent', '1');


INSERT INTO "main"."Propertyref" ("id", "name", "description", "category_id") VALUES ('1', 'Localisation', 'Description de l''emplacement, et de la façon d''y acceder', '1');
INSERT INTO "main"."Propertyref" ("id", "name", "description", "category_id") VALUES ('2', 'Commune', 'Nom de la commune', '1');
INSERT INTO "main"."Propertyref" ("id", "name", "description", "category_id") VALUES ('3', 'Insee', 'Code Insee de la commune', '1');
INSERT INTO "main"."Propertyref" ("id", "name", "description", "category_id") VALUES ('4', 'Accès', 'Note sur la facilité d''accès à la ressource (0= facile à 4=impossible)', '1');
INSERT INTO "main"."Propertyref" ("id", "name", "description", "category_id") VALUES ('5', 'Aménagement', 'La source bénéficie-t-elle d''un aménagement entrenetu ? : bac, entretien etc.', '1');
INSERT INTO "main"."Propertyref" ("id", "name", "description", "category_id") VALUES ('6', 'Débit', 'Estimation visuelle du débit (pas de débit, débit faible, débit fort ..)', '1');

INSERT INTO "main"."Propertyref" ("id", "name", "description", "category_id") VALUES ('7', 'Horaires', 'Horaires d´ouverture', '2');


----------------------------
-- DATAS
----------------------------
INSERT INTO "main"."Marker" ("id", "key", "name", "type", "description", "lat", "lon", "alt", "url", "iconurl", "photoprefix", "category_id", "datemaj", "datecreated") VALUES ('1', '', 'Source aux serpents', '1', 'Exutoire en pleine forêt domaniale de Lyons-la-Forêt.', '49.424192', '1.400452', '0', '', 'icons/water-green.png', 'A-E-2-serpents', '1', 'Juillet 2022', '2022-08-15 15:01');
INSERT INTO "main"."Marker" ("id", "key", "name", "type", "description", "lat", "lon", "alt", "url", "iconurl", "photoprefix", "category_id", "datemaj", "datecreated") VALUES ('2', '', 'Source Bout de Sainte-Honorine', '1', 'Bac semi-aménagé, situé sur le bord de la route.Entretenu par un bénévole.', '49.415387176222204', '1.3982073255109253', '0', '', 'icons/water-green.png', 'A-E-6-bout', '1', 'Juillet 2022', '2022-08-15 15:01');
INSERT INTO "main"."Marker" ("id", "key", "name", "type", "description", "lat", "lon", "alt", "url", "iconurl", "photoprefix", "category_id", "datemaj", "datecreated") VALUES ('3', '', 'Le petit magasin', '1', 'Par un bénévole.', '49.425222204', '1.3825109253', '0', '', '', 'Magasin', '2', '08/2022', '2022-08-15 15:01');

INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('1', '1', '1', 'Une centaine de mètres dans la forêt domaniale de Lyons (anciennement source aux arpents)', '2022-08-15 14:54');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('2', '2', '1', 'Les Hogues', '2022-08-15 14:54');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('3', '3', '1', '27338', '2022-08-15 14:55');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('4', '4', '1', 'Difficile ⭐️', '2022-08-15 14:55');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('5', '5', '1', 'Aucun aménagement', '2022-08-15 14:56');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('6', '6', '1', 'Débit faible. Pas de débit apparent.', '2022-08-15 14:56');


INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('7', '1', '2', 'A la sortie de Sainte-Honorine en direction de Perriers-Sur-Andelle. Accessible à pied et en voiture.)', '2022-08-15 14:54');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('8', '2', '2', 'Les Hogues', '2022-08-15 14:54');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('9', '3', '2', '27338', '2022-08-15 14:55');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('10', '4', '2', 'Facile ⭐️⭐⭐', '2022-08-15 14:55');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('11', '5', '2', 'Bac naturel, entretenu', '2022-08-15 14:56');
INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('12', '6', '2', 'Débit faible. Pas de débit apparent (600 litres/jour).', '2022-08-15 14:56');

INSERT INTO "main"."Propertyval" ("id", "propertyref_id", "marker_id", "value", "datecreated") VALUES ('13', '7', '3', 'Ouvert le matin seulement', '2022-08-15 14:56');