Backup Trusted Files Table Schema (backup_trusted_files)


List of files that are trusted

backup_trusted_files table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
contenthash VARCHAR 40

SHA1 has of the file content, the same as in files table

filesize BIGINT 19 null
backupid VARCHAR 32 null

id of the backup if known

timeadded BIGINT 19 null

when was this content hash registered as secure

userid BIGINT 19 null backtrusfile_use2_fk R

logged in user at the time of registration

Table contained -1 rows

backup_trusted_files table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
backtrusfile_con_uix Must be unique Asc contenthash
backtrusfile_use_ix Performance Asc userid

backup_trusted_files table relationships