Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
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 |
|||||||||||
| metadatasettings | LONGTEXT | 2147483647 | √ | null |
|
|
Library metadata settings |
|||||||||||
| tutorial | LONGTEXT | 2147483647 | √ | null |
|
|
Tutorial URL |
|||||||||||
| example | LONGTEXT | 2147483647 | √ | null |
|
|
Example URL |
|||||||||||
| enabled | BIT | 1 | √ | 1 |
|
|
Defines if this library is enabled (1) or not (0) |
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 |