46 rows


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


Column Type Size Nulls Auto Default Children Parents Comments
major int4 10 0

Major component of version number, e.g. the 2 in OJS 2.3.8-0

minor int4 10 0

Minor component of version number, e.g. the 3 in OJS 2.3.8-0

revision int4 10 0

Revision component of version number, e.g. the 8 in OJS 2.3.8-0

build int4 10 0

Build component of version number, e.g. the 0 in OJS 2.3.8-0

date_installed timestamp 22 null
current int2 5 '0'::smallint

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 int2 5 '0'::smallint

1 iff the row describes a lazy-load plugin; 0 otherwise

sitewide int2 5 '0'::smallint

1 iff the row describes a site-wide plugin; 0 otherwise


Constraint Name Type Sort Column(s)
versions_pkey 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