Backup Controllers Table Schema (backup_controllers)


To store the backup_controllers as they are used

backup_controllers table columns

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

unique id of the backup

operation varchar 20 backup

Type of operation (backup/restore)

type varchar 10

Type of the backup (activity/section/course)

itemid bigint 10 null

id of the module/section/activity being backup

format varchar 20

format of the backup (moodle/imscc...)

interactive smallint 4 null

is the backup interactive (1-yes/0-no)

purpose smallint 4 null

purpose (target) of the backup (general, import, hub...)

userid bigint 10 null backcont_use2_fk R

user that owns/performs the backup

status smallint 4 null

current status of the backup (configured, ui, running...)

execution smallint 4 null

type of execution (immediate/delayed)

executiontime bigint 10 null

epoch secs when the backup should be executed (for delayed backups only)

checksum varchar 32

checksum of the backup_controller object

timecreated bigint 10 null

time the controller was created

timemodified bigint 10 null

last time the controller was modified

controller longtext 2147483647 null

serialised backup_controller object

Table contained -1 rows

backup_controllers table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
backcont_bac_uix Must be unique Asc backupid
backcont_typite_ix Performance Asc/Asc type + itemid
backcont_use_ix Performance Asc userid

backup_controllers table relationships