Share via

Resources Table

  • Article

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.

The following table describes the columns of the Resources table.

Note

Do not modify the definition of this table for any reason. It is described here for reference.

Column

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 pupscrcripts, ResourceProps, and SiteResources tables.

s_DisplayName

A string that stores the programmatic name for the resource, as used when you access the resource through the Fields property of the GlobalConfigFreeThreaded, GlobalConfig2FreeThreaded, SiteConfigFreeThreaded, and SiteConfigReadOnlyFreeThreaded objects.

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 many 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.

  • 0x00000004 – Set when this resource has its own snap-in. The programmatic identifier (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. A resource with this bit set is known as address resource. Web service resources are a type of address resource. Therefore ,have this bit set (together with the 0x00000400 bit, and potentially one of the bits defined for the four Commerce Server 2009 Web services: 0x00000800, 0x00001000, 0x00002000, and 0x00004000).

  • 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 the global resource bit (0x00000001).

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

  • 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 computer to another.

  • 0x00000400 – Set when this resource is a Web service.

  • 0x00000800 – Set when this resource is the Commerce Server Orders Web Service.

  • 0x00001000 – Set when this resource is the Commerce Server Catalog Web Service.

  • 0x00002000 – Set when this resource is the Commerce Server Marketing Web Service.

  • 0x00004000 – Set when this resource is the Commerce Server Profiles Web Service.

  • 0x00010000 – Set when this resource is a SharePoint Commerce Application for a non-default zone.

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. Bit 0x00000004 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 2009 is installed.

i_Status

This column is currently not 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 you delete the resource.

See Also

Other Resources

ExtendedProps Table

ResourceProps Table

SiteResources Table

Sites Table

SystemProps Table

Resource Tables in the Administration Database