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