Database-conversion.md

@@ -1526,6 +1526,7 @@ UPDATE `artifacts_updates` SET
 
 Update some empty fields to null
 
+```sql
 UPDATE `artifacts` SET `cdli_comments`= NULL  WHERE  `cdli_comments` = "";
 UPDATE `artifacts_updates` SET `cdli_comments`= NULL WHERE `cdli_comments` = "";
 
@@ -1595,3 +1596,22 @@ UPDATE `artifacts_updates` SET `shadow_acquisition_history`= NULL WHERE `shadow_
 
 UPDATE `artifacts_shadow` SET `cdli_comments`= NULL  WHERE  `cdli_comments` = "";
 UPDATE `artifacts_updates` SET `shadow_cdli_comments`= NULL WHERE `shadow_cdli_comments` = "";
+```
+
+
+Permissions update   
+  
+
+```sql
+UPDATE `artifacts` SET
+`is_public` = 0,
+`is_atf_public`= 0,
+`are_images_public`= 0
+WHERE designation like "%non-public%" ;
+
+UPDATE `artifacts_updates` SET
+`is_public` = 0,
+`is_atf_public`= 0,
+`are_images_public`= 0
+WHERE designation like "%non-public%" ;
+```
\ No newline at end of file