<commit_before>CREATE OR REPLACE VIEW {# geotrek.trekking #}.v_treks AS (
	SELECT e.geom, e.id, i.*
	FROM trekking_trek AS i, core_topology AS e
	WHERE i.topo_object_id = e.id
	AND e.deleted = FALSE
);

CREATE OR REPLACE VIEW {# geotrek.trekking #}.v_pois AS (
	SELECT e.geom, e.id, i.*
	FROM trekking_poi AS i, core_topology AS e
	WHERE i.topo_object_id = e.id
	AND e.deleted = FALSE
);
<commit_msg>Add UUID to trekking views<commit_after>CREATE OR REPLACE VIEW {# geotrek.trekking #}.v_treks AS (
	SELECT e.geom, e.id, e.uuid, i.*
	FROM trekking_trek AS i, core_topology AS e
	WHERE i.topo_object_id = e.id
	AND e.deleted = FALSE
);

CREATE OR REPLACE VIEW {# geotrek.trekking #}.v_pois AS (
	SELECT e.geom, e.id, e.uuid, i.*
	FROM trekking_poi AS i, core_topology AS e
	WHERE i.topo_object_id = e.id
	AND e.deleted = FALSE
);

{'fraction_non_alphanumeric': 0.11338962605548854, 'fraction_numerical': 0.0, 'mean_word_length': 3.742857142857143, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6255916', 'n_tokens_mistral': 366, 'n_tokens_neox': 356, 'n_words': 102}