resource_old

0 rows


Description

backup of all old resource instances from 1.9

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
course BIGINT 19 0
course.id Defined in XMLR
name VARCHAR 255 ''
type VARCHAR 30 ''
reference VARCHAR 255 ''
intro LONGTEXT 2147483647 √ NULL
introformat SMALLINT 5 0
alltext LONGTEXT 2147483647 null
popup LONGTEXT 2147483647 null
options VARCHAR 255 ''
timemodified BIGINT 19 0
oldid BIGINT 19 null
cmid BIGINT 19 √ NULL
newmodule VARCHAR 50 √ NULL
newid BIGINT 19 √ NULL
migrated BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
resoold_cmi_ix Performance Asc cmid
resoold_old_uix Must be unique Asc oldid

Relationships