USE fetchmetrics;

DROP TABLE IF EXISTS fetchmetrics.DOG_Distraction_Temp;

SELECT CONCAT('WARNING: Table ', TABLE_SCHEMA, '.', TABLE_NAME, ' already exists.') AS msg_warning 
FROM INFORMATION_SCHEMA.TABLES 
WHERE 
        TABLE_SCHEMA = 'fetchmetrics' 
    AND TABLE_NAME = 'DOG_Distraction_Temp'
;

CREATE TABLE IF NOT EXISTS fetchmetrics.DOG_Distraction_Temp (
	  id_temp INT NOT NULL PRIMARY KEY AUTO_INCREMENT
    , id_distraction INT
	-- , id_assessment INT
    , id_assessment_command_link INT
	, id_distraction_type INT
	, id_intensity_level_emotional INT
	, id_intensity_level_scent INT
	, id_intensity_level_sight INT
	, id_intensity_level_sound INT
	, id_intensity_level_touch INT
	, quantity INT
	, proximity_metres FLOAT
--    , difficulty_level DOUBLE
    , notes TEXT
	, active BIT

    , does_meet_id_filters BIT
    , does_meet_non_id_filters BIT
    
    , guid BINARY(36)
);