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