FileDuplicateTable.php

См. документацию.

<?php
namespace Bitrix\Main\File\Internal;
 
use Bitrix\Main\ORM\Data;
use Bitrix\Main\ORM\Fields;

class FileDuplicateTable extends Data\DataManager
{
    use Data\Internal\MergeTrait;
 
    public static function getTableName()
    {
        return 'b_file_duplicate';
    }
 
    public static function getMap()
    {
        return [
            (new Fields\IntegerField("DUPLICATE_ID"))
                ->configurePrimary(true),
 
            (new Fields\IntegerField("ORIGINAL_ID"))
                ->configurePrimary(true),
 
            (new Fields\IntegerField("COUNTER"))
                ->configureDefaultValue(1),
 
            (new Fields\BooleanField("ORIGINAL_DELETED"))
                ->configureValues("N", "Y")
                ->configureDefaultValue("N"),
        ];
    }

    public static function markDeleted($originalId)
    {
        $originalId = (int)$originalId;
        $conn = static::getEntity()->getConnection();
        $table = static::getTableName();
 
        $conn->query("
            update {$table} 
            set ORIGINAL_DELETED = 'Y' 
            where ORIGINAL_ID = {$originalId} and ORIGINAL_DELETED = 'N'
        ");
 
        static::cleanCache();
    }
}