H5p Libraries Table Schema (h5p_libraries)


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