Skip to content
Update Database conversion authored by Émilie Pagé-Perron's avatar Émilie Pagé-Perron
...@@ -106,7 +106,7 @@ SET cdli_db.update_events.created_by = ...@@ -106,7 +106,7 @@ SET cdli_db.update_events.created_by =
SELECT cdli_db.authors.id FROM cdli_db.authors SELECT cdli_db.authors.id FROM cdli_db.authors
join cdli_db_tmp.authors_view on cdli_db_tmp.authors_view.author_id = cdli_db.authors.id join cdli_db_tmp.authors_view on cdli_db_tmp.authors_view.author_id = cdli_db.authors.id
join cdli_db.update_events on cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created join cdli_db.update_events on cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created
WHERE cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created AND cdli_db.update_events.type = "atf" WHERE cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created AND cdli_db.update_events.update_type = "atf"
LIMIT 1 LIMIT 1
); );
``` ```
... ...
......