Database-conversion.md

@@ -1286,9 +1286,35 @@ insert into cdli_db.artifacts_publications (artifact_id, publication_id, publica
 select artifact_id, publication_id, type from cdli_db_tmp.pub_history
 
 UPDATE `publications` SET designation = bibtexkey WHERE designation is null;
+
+
+
+
+```
+Refresh accepted by and accepted status
+
+```
+update cdli_db.publications Set accepted_by = 820;
+update cdli_db.publications Set accepted = 1;
 ```
 
 
+bibtexkey
+
+
+For the about 500 publications coming from curated bib collections update designation from bibtex key
+
+`UPDATE `publications` SET designation = bibtexkey WHERE designation is null;`
+
+#### Create bibtex keys from ids
+```
+UPDATE publications
+SET bibtexkey = id
+Where bibtexkey is null
+```
+
+
+
 
 # 4 Artifacts updates / update events & cat credits
 check for missing new fields before running the query