mSJiz4WT

1DROP TABLE IF EXISTS log_matches;
2
3CREATE TABLE IF NOT EXISTS log_matches AS (
4	SELECT * FROM log_civicrm_uf_match WHERE date(log_date) = '2019-04-17'
5);
6
7DROP TABLE IF EXISTS match_restore;
8
9CREATE TABLE IF NOT EXISTS match_restore AS (
10SELECT DISTINCT lm.id, lm.domain_id, lm.uf_id, lm.uf_name, lm.contact_id, lm.language
11FROM log_matches AS lm
12LEFT JOIN civicrm_uf_match AS ufm
13ON lm.uf_id = ufm.uf_id
14WHERE lm.log_action = 'Delete' AND lm.log_date BETWEEN '2019-04-17 14:16:58' AND '2019-04-17 14:19:00'
15AND ufm.uf_id IS NULL
16);
17
18INSERT INTO civicrm_uf_match (domain_id, uf_id, uf_name, contact_id, language)
19SELECT domain_id, uf_id, uf_name, contact_id, language
20FROM match_restore
21;
22
23DROP TABLE IF EXISTS log_matches;
24
25DROP TABLE IF EXISTS match_restore;