versions


Description

Describes the installation and upgrade version history for the application and all installed plugins.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
version_id BIGINT UNSIGNED 20 null
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 itself

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)
PRIMARY Primary key Asc version_id
versions_unique Must be unique Asc/Asc/Asc/Asc/Asc/Asc product_type + product + major + minor + revision + build

Diagram producer might be missing

No diagrams were produced please see application output for any errors