Resources Table

Article
11/12/2009

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

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

Partager via

Resources Table

See Also

Other Resources

Ressources supplémentaires