The triggers table contains details of the triggers created by the Macrotone Joomla Audit component.
Table 5.2. Triggers table description
Column Name |
Type |
Size |
Not Null? |
Constraints |
Description |
|---|---|---|---|---|---|
id |
Int |
11 |
Yes |
Primary key |
The system generated unique identifier for the record. Populated by an auto-sequence. |
table_name |
Varchar |
255 |
Yes |
None |
Name of the table for which the trigger applies. |
trigger_schema |
Varchar |
255 |
Yes |
None |
The database schema to which the trigger applies. MySQL databases may have multiple schemas. |
trigger_name |
Varchar |
255 |
Yes |
None |
The name of the trigger. This is automatically generated based upon the name of the table upon which it is apples. |
trigger_event |
Varchar |
255 |
Yes |
AFTER |
The type of trigger. i.e. BEFORE or AFTER. Some databases may contain other trigger events. |
trigger_event |
Varchar |
255 |
Yes |
INSERT |
The type of trigger, or more accurately when the trigger fires. i.e. INSERT, UPDATE or DELETE. |
trigger_text |
Medium Text |
Yes |
None |
The actual trigger text from the specified criteria. |
|
columns |
Text |
255 |
Yes |
All |
The columns to which the trigger applies. |
action_orientation |
Varchar |
10 |
No |
ROW |
How the trigger is applied. |
applied |
TinyInt |
4 |
Yes |
Inactive |
State of the specific trigger. i.e. Active or Inactive. |
created_by |
Integer |
11 |
Yes |
None |
The Joomla id of the use who created the trigger text. Automatically populated. |
created_by_alias |
Varchar |
255 |
No |
None |
The name of the person who created the trigger text. |
created_on |
DateTime |
n/a |
No |
None |
Date the record was changed. |