How to change dataset from checkedOut to checkedIn (in DB)

CheckedOut to CheckedIn

1. Important: Do not change or delete directly in the database without a current backup!
2. Important: Depending on the reason for checkedOut either keep the new dataset version or delete it.

Keep Dataset version

Table Datasets

• Set status to „2“
• remove name from “checkoutuser”

Table Datasetversions

• Filter by Dataset ID: SELECT * FROM public.datasetversions WHERE datasetref = '2349' ORDER BY id DESC;
• Set status 2

Delete Dataset version

Table datasets

• Set status to „2“
• remove name from “checkoutuser”

Table datasetversions

• Filter by Dataset ID: SELECT * FROM datasetversions WHERE datasetref = '2349' ORDER BY id DESC;

Table contentdescriptors (necessary if files have been uploaded in a previous step)

• SELECT * FROM contentdescriptors WHERE datasetversionref in (newestest / 2nd newested datsetversion ID) If content is identical, delete all entries referring to the newest datasetversion id

Table datasetversions

• Filter by Dataset ID: SELECT * FROM datasetversions WHERE datasetref = '2349' ORDER BY id DESC;
• Delete newest datasetversion (status 1)
• Set status 2 to the new newest Version