"GetModuleDefinitions" Stored Procedure

Description:

This stored procedure returns all of the module type definitions for the specified portal. The input parameter is the PortalID.

Definition:
    
    CREATE PROCEDURE GetModuleDefinitions
    (
        @PortalID  int
    )
    AS

    SELECT  
        FriendlyName,
        DesktopSrc,
        MobileSrc,
        ModuleDefID

    FROM
        ModuleDefinitions
        
    WHERE   
        PortalID = @PortalID
        
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 modules version; optionally they may also define a Mobile version.