Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| major | INT | 10 | 0 |
|
|
Major component of version number, e.g. the 2 in OJS 2.3.8-0 |
||
| minor | INT | 10 | 0 |
|
|
Minor component of version number, e.g. the 3 in OJS 2.3.8-0 |
||
| revision | INT | 10 | 0 |
|
|
Revision component of version number, e.g. the 8 in OJS 2.3.8-0 |
||
| build | INT | 10 | 0 |
|
|
Build component of version number, e.g. the 0 in OJS 2.3.8-0 |
||
| date_installed | DATETIME | 19 | null |
|
|
|||
| current | SMALLINT | 5 | 0 |
|
|
1 iff the version entry being described is currently active. This permits the table to store past installation history for forensic purposes. |
||
| product_type | VARCHAR | 30 | √ | NULL |
|
|
Describes the type of product this row describes, e.g. “plugins.generic” (for a generic plugin) or “core” for the application itelf |
|
| product | VARCHAR | 30 | √ | NULL |
|
|
Uniquely identifies the product this version row describes, e.g. “ojs2” for OJS 2.x, “languageToggle” for the language toggle block plugin, etc. |
|
| product_class_name | VARCHAR | 80 | √ | NULL |
|
|
Specifies the class name associated with this product, for plugins, or the empty string where not applicable. |
|
| lazy_load | SMALLINT | 5 | 0 |
|
|
1 iff the row describes a lazy-load plugin; 0 otherwise |
||
| sitewide | SMALLINT | 5 | 0 |
|
|
1 iff the row describes a site-wide plugin; 0 otherwise |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| versions_pkey | Must be unique | Asc/Asc/Asc/Asc/Asc/Asc | product_type + product + major + minor + revision + build |
Relationships
Close relationships within degrees of separation
