agentsversion

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AgentId INT 10 null
Version INT UNSIGNED 10 0
webextensionschemaversion.Version Implied ConstraintR

This column stores the version number of the monitor (agent), and should not be manually updated. Instead, allow the AgentsAfterInsert/AgentsAfterDelete/AgentsAfterUpdate (AFTER INSERT/DELETE/UPDATE on agents), DCIncrementVersionOnInsert (AFTER INSERT on DataCollectors) and DCIncrementVersionOnDelete (AFTER DELETE on DataCollectors) triggers perform any and all updates on this column. This column can (and should) also be left blank and it will default to a version of ‘0’.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc AgentId

Relationships