MODULES

In SignalSQL, the MODULES table provides a mechanism for applications to enable or disable modules. By managing the entries in the MODULES table, applications can toggle the activation status of specific modules, tailoring the functionality of SignalSQL to meet their specific requirements.

CREATE TABLE MODULES (
    ID INT AUTO_INCREMENT PRIMARY KEY,  -- The id of this MODULE.
    Name VARCHAR(255),                  -- Name name of this module
    Enabled TINY                        -- 0 if the module is disabled and 1 if enabled
)

The ID column is generated dynamically and will vary between different restarts of SignalSQL. This can be used for queries but should no be stored by the application.

The Name column gives the short name of the module. This is normally the same as the table name in SignalSQL.

By setting the Enable column to zero, the corresponding module is deactivated.