"UpdateModule" Stored Procedure

Description:

This stored procedure is used by the ModuleSettings administration page to set the properties of a specific module. The input parameters include the item's primary key (ModuleID), plus title, position within the tab and security settings.

Definition:

    CREATE PROCEDURE UpdateModule
    (
        @ModuleID       int,
        @ModuleOrder    int,
        @ModuleTitle    nvarchar(256),
        @PaneName       nvarchar(50),
        @CacheTime      int,
        @EditRoles      nvarchar(256),
        @ShowMobile     bit
    )
    AS

    UPDATE
        Modules

    SET
        ModuleOrder = @ModuleOrder,
        ModuleTitle = @ModuleTitle,
        PaneName    = @PaneName,
        CacheTime   = @CacheTime,
        ShowMobile  = @ShowMobile,
        AuthorizedEditRoles = @EditRoles

    WHERE
        ModuleID = @ModuleID
        
Database Tables Used:

Modules:  Each record in the Modules table represents a single module instance on a specific tab in the selected portal. The definition for the module type is pulled via the ModuleDefID field from the ModuleDefinitions table. The data for the module is stored in a database table for the selected module type, and indexed by ModuleID.

The primary key in this table is the ModuleID identity field.