Backup Logs Table Schema (backup_logs)


To store all the logs from backup and restore operations (by db logger)

backup_logs table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
backupid varchar 32
backup_controllers.backupid backlogs_bac2_fk R

backupid the log record belongs to

loglevel smallint 4 null

level of the log (debug...error)

message longtext 2147483647 null

text logged

timecreated bigint 10 null

timestamp this log entry was created

Table contained -1 rows

backup_logs table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
backlogs_bac_ix Performance Asc backupid
backlogs_bacid_uix Must be unique Asc/Asc backupid + id

backup_logs table relationships