Resources Table

The Resources table defines actual instances of resources. Together with the ResourceProps, SiteResources, and Sites tables, this table stores the data for the Administration database.

Entries in the Resources table have a one-to-many relationship with entries in the ResourceProps table. For more information about one-to-many relations, see One-To-Many Relation.

The columns of the Resources table are described in the following table.

Resources Columns Description
i_ResourceID An integer that identifies a resource in this table. Values in this column correspond to the values in the i_ResourceID columns in the PupDBScript, ResourceProps, and SiteResources tables.
s_DisplayName A string that stores the programmatic name for the resource, as used when accessing the resource through the Fields property of the GlobalConfig, SiteConfig, and SiteConfigReadOnly objects. For more information, see GlobalConfig.Fields, SiteConfig.Fields, and SiteConfigReadOnly.Fields, respectively.
s_Description A string that stores the user-friendly name for the resource.
s_Type A string that indicates the type of this resource. This column maps to the s_ResourceType columns in the SystemProps and ExtendedProps tables.
f_IsGlobal A flag that indicates whether a resource is global (1) or site-specific (0).
f_ResourceFlags The values in this column are bit fields that store information about a number of Boolean characteristics of resources. Commerce Server Manager and Commerce Server Site Packager examine these characteristics to determine how each resource should be treated. The bits are defined as follows:
  • 0x00000001 – Set when this row is a reference to a global resource.


  • 0x00000002 – Set when this resource can be displayed in MMC.

    Constant: IS_SNAPINITEM

  • 0x00000004 – Set when this resource has its own snap-in. The ProgID of the snap-in extension must be in the s_ProgIDSnapIn column when this bit is set.


  • 0x00000008 – Set when this resource is an application in a site. Not used externally.

    Constant: IS_ADDRESS

  • 0x00000010 – Set when this resource is a physical resource. Affects delete functionality. Defaults to the first global resource like it. During custom unpacking, requires user to select existing global resource. Used in combination with IS_REFTOGROUPRES.

    Constant: IS_PHYSICAL

  • 0x00000020 – Not used.

    Constant: IS_ALWAYSPACK

  • 0x00000040 – Set for Addresses and AddressItems, which may not be related to Commerce Server.

    Constant: IS_NONCOMMERCE

  • 0x00000080 – Set for resources that use a non-standard snap-in extension (currently only used by our Data Warehouse resource). The use of this flag is not recommended because of the special programming considerations that are required.

    Constant: IS_SNAPIN_NNSE

  • 0x00000100 – Set for resources that are never to be packaged by Commerce Server Site Packager. Set this bit when you do not want to transfer resources from one machine to another.

    Constant: IS_NOTPACKED

The constants are defined in the ConfigFlags enumeration in the file cssnapin.h.

s_ProgIDSnapIn A string that provides the ProgID of a snap-in extension for this resource. The snap-in extension must implement the IDispatch interface. The IS_SNAPINAVAILABLE bit of the f_ResourceFlags column should be set when this column has a value.
s_Computer A string that optionally shows the name of the computer where Commerce Server is installed.
i_Status This column is not currently used.
f_PupFlags When set to zero (0), tells Commerce Server Site Packager that the name passed when packaging and unpacking is a file name. When set to one (1), tells Commerce Server Site Packager that the name passed when packaging and unpacking is a folder name.
s_ProgIDPUP A string that provides the ProgID of a COM component that implements the Commerce Server Site Packager (IPuP) interface. For more information, see Site Packager Interface.
s_PupParam1 A string that contains a comma-delimited list of names of the database tables to be packaged and unpacked for the resource.
s_PupParam2 A string that contains a comma-delimited list of the names of the SQL schema scripts to execute when importing the resource.
s_PupParam3 A string that contains a comma-delimited list of the names of the SQL scripts to execute when deleting the resource.

All rights reserved.