Database-conversion.md

@@ -1676,6 +1676,12 @@ from cdli_db.publications
 join cdli_db.artifacts_publications on cdli_db.artifacts_publications.publication_id = cdli_db.publications.id
 group by cdli_db.artifacts_publications.artifact_id;
 
+set publication_comments = 
+REPLACE(publication_comments,';',',');
+
+UPDATE `artifacts_publications` SET `publication_comments`=null WHERE `publication_comments` = "";
+
+
 update cdli_db.artifacts_updates
 join cdli_db_tmp.artifacts_publications on cdli_db_tmp.artifacts_publications.artifact_id = cdli_db.artifacts_updates.artifact_id
 set cdli_db.artifacts_updates.publications_key = cdli_db_tmp.artifacts_publications.publications_key,