trigger settings table structure#
This table intends to allow the enabled and disabling of certain triggers
Field |
Type |
NULL allowed |
Default Value |
---|---|---|---|
name* |
TEXT |
YES |
|
enabled |
INTEGER |
NO |
TRUE |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE if not exists trigger_settings (name TEXT PRIMARY KEY, enabled INTEGER NOT NULL DEFAULT TRUE);
INSERT INTO trigger_settings (name, enabled) VALUES('new_link_a_or_b_node', TRUE);
INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('trigger_settings', 'name', 'name for trigger to query against');
INSERT INTO 'attributes_documentation' (name_table, attribute, description) VALUES('trigger_settings', 'enabled', 'boolean value');