Database-conversion.md

@@ -141,6 +141,16 @@ I first create a table in cdli_db_tmp with a list of association between atf_sou
 ```sql
 
 
+```
+Update project id for atf updates
+Set projects from all credits fields (cataloguesnew and revhistories)
+
+```
+update cdli_db.update_events 
+join cdli_db_tmp.cat_event_link on cdli_db.update_events.event_comments = cdli_db_tmp.cat_event_link.comm 
+set  cdli_db.update_events.external_resource_id = cdli_db_tmp.cat_event_link.project_id
+where cdli_db.update_events.event_comments = cdli_db_tmp.cat_event_link.comm and 
+cdli_db_tmp.cat_event_link.project_id is not null;
 ```