Database-conversion.md

@@ -1495,6 +1495,28 @@ 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;
 
 ```
+
+Add translation note to event comments
+```sql
+update cdli_db.update_events
+
+join cdli_db.artifacts_updates on 
+cdli_db.update_events.id = cdli_db.artifacts_updates.update_events_id
+join cdli_db_old.cataloguesnew on
+cdli_db_old.cataloguesnew.id_text = cdli_db.artifacts_updates.artifact_id
+
+set cdli_db.update_events.event_comments = 
+concat(event_comments, ' translation from: ', (select translation_source from cdli_db_old.cataloguesnew
+
+where 
+cdli_db_old.cataloguesnew.id_text = cdli_db.artifacts_updates.artifact_id
+And cdli_db_old.cataloguesnew.translation_source is not null 
+And cdli_db_old.cataloguesnew.translation_source != ""
+));
+```
+
+
+
 adding composites to artifacts_updates
 
 ```sql