Resource Old Table Schema (resource_old)


backup of all old resource instances from 1.9

resource_old table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
course BIGINT 19 0
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

Table contained -1 rows

resource_old table 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