H5p Libraries Table Schema (h5p_libraries)


Description

Stores information about libraries used by H5P content.

h5p_libraries table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
h5p.mainlibraryid h5p_mai2_fk R
h5p_contents_libraries.libraryid h5pcontlibr_lib2_fk R
h5p_libraries_cachedassets.libraryid h5plibrcach_lib2_fk R
h5p_library_dependencies.libraryid h5plibrdepe_lib2_fk R
h5p_library_dependencies.requiredlibraryid h5plibrdepe_req2_fk R

Primary Key: The id of the library

machinename VARCHAR 255

The library machine name

title VARCHAR 255

The human readable name of this library

majorversion SMALLINT 5 null
minorversion SMALLINT 5 null
patchversion SMALLINT 5 null
runnable BIT 1 null

Can this library be started by the module? i.e. not a dependency.

fullscreen BIT 1 0

Display fullscreen button

embedtypes VARCHAR 255

List of supported embed types

preloadedjs LONGTEXT 2147483647 √ null

Comma separated list of scripts to load.

preloadedcss LONGTEXT 2147483647 √ null

Comma separated list of stylesheets to load.

droplibrarycss LONGTEXT 2147483647 √ null

List of libraries that should not have CSS included if this library is used. Comma separated list.

semantics LONGTEXT 2147483647 √ null

The semantics definition in json format

addto LONGTEXT 2147483647 √ null

Plugin configuration data

coremajor SMALLINT 5 √ null

H5P core API major version required

coreminor SMALLINT 5 √ null

H5P core API minor version required

Table contained -1 rows

h5p_libraries table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
h5plibr_macmajminpatrun_ix Performance Asc/Asc/Asc/Asc/Asc machinename + majorversion + minorversion + patchversion + runnable

h5p_libraries table relationships