I want to suggest an improvement

About file age ( https://docs.nextcloud.com/server/15/admin_manual/file_workflows/retention.html#file-age ):
do you want to extend table “oc_systemtag_object_mapping” like this:
ALTER TABLE oc_systemtag_object_mapping ADD ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
or else:
ALTER TABLE oc_systemtag_object_mapping
ADD ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
ADD time_type tinyint NOT NULL DEFAULT 0;
(0 - retention by timestamp of file, 1 - by timestamp of tag)

1 Like