"GetSingleModuleDefinition" Stored Procedure

Description:

This stored procedure returns a single module type definition from the database. The input parameter is ModuleDefID, the primary key for the record. The return values include the type's friendly name as well as paths for the desktop and mobile versions of the module.

This stored procedure is used by the edit page for module type definitions.

Definition:
    
    CREATE PROCEDURE GetSingleModuleDefinition
    (
        @ModuleDefID int
    )
    AS

    SELECT
        FriendlyName,
        DesktopSrc,
        MobileSrc

    FROM
        ModuleDefinitions

    WHERE
        ModuleDefID = @ModuleDefID
        
Database Tables Used:

ModuleDefinitions:  Each record in the ModuleDefinitions table defines a different type of modules that may be used in the selected portal. Individual modules reference this definition via the ModuleDefID, the primary key for this table. All modules must define a Desktop module version; optionally they may also define a Mobile version.