Database-conversion.md

@@ -46,6 +46,25 @@ insert into cdli_db.inscriptions (id, artifact_id, atf)
 select revhistories.id, revhistories.object_id, revhistories.new_text from revhistories
 ```
 
+Update inscriptions with fulltrans data
+
+
+```sql
+update cdli_db.inscriptions
+join cdli_db_old.fulltrans on cdli_db_old.fulltrans.object_id = cdli_db.inscriptions.artifact_id
+set  
+cdli_db.inscriptions.is_latest =1,
+cdli_db.inscriptions.transliteration = cdli_db_old.fulltrans.transliteration,
+cdli_db.inscriptions.transliteration_clean = cdli_db_old.fulltrans.transliteration_clean,
+cdli_db.inscriptions.transliteration_for_search = cdli_db_old.fulltrans.transliteration_for_search
+where 
+cdli_db_old.fulltrans.object_id = cdli_db.inscriptions.artifact_id
+and 
+cdli_db_old.fulltrans.wholetext = cdli_db.inscriptions.atf
+```
+
+
+
 Prepare or update tmp author and credits table:   
   
 author_inscriptions_single: