License Table Schema (license)


store licenses used by moodle

license table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
shortname VARCHAR 255 null
fullname LONGTEXT 2147483647 null
source VARCHAR 255 null
enabled BIT 1 1
version BIGINT 19 0
custom BIT 1 0

If this flag is set, license is custom and can be updated or deleted, otherwise license is a core license and cannot be edited.

sortorder MEDIUMINT 7 0

Table contained -1 rows

license table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id