ResourceProps Table
The ResourceProps table stores the actual resource property values. Together with the Resources, SiteResources, and Sites tables, this table stores the data for the Administration database.
The columns of the ResourceProps table are described in the following table.
| ResourceProps Columns | Description |
| i_ResourceID | An integer that identifies the resource with which this property is associated. Values in this column correspond to the values in the i_ResourceID columns in the PupDBScript, Resources, and SiteResources tables. |
| s_PropertyName | Set to an arbitrary string that serves as the internal name of the property, and is used when accessing the property programmatically with the GlobalConfig, SiteConfig, and SiteConfigReadOnly objects.
Typically, this name is descriptive and begins with a letter indicating the data type of the property and an underscore. For example, "i_AuctionOptions" indicates an integer data type. |
| f_IsConnStr | When set to "1", indicates that the property is an OLE DB connection string. If set, Commerce Server Manager uses a Universal Data Link (UDL) dialog box to set the value, and Commerce Server Site Packager will prompt for connect information for a specific database when unpacking.
See note below for additional information about this flag and its relationship to connection string configuration values. |
| f_IsHidden | When set to "1", the Generic Resource dialog will not display the property. Set this flag to "1" for properties for which there is a custom MMC snap-in. |
| f_IsSimpleList | When set to "1", indicates that the new property is a SimpleList object. This feature allows the storage of multi-valued properties. |
| s_Description | This column is not used. |
| i_Vartype | An integer indicating the Variant type of the data being stored. For example, 8 indicates a string and 8200 indicates an array of strings. All Variant types except SafeArray, IUnknown, and IDispatch are allowed.
Set to an integer value indicating the data type of the new property. The value 8200 indicates a Variant array of strings. |
| s_Value | The value of the property. |
| s_DisplayName | A user-friendly display name for the property that is shown in the Generic Resource dialog box. |
.gif "Ee823619.note(en-US,CS.10).gif")
Notes
Commerce Server Site Packager performs special processing for resource properties that have names beginning with "connstr_db". The values associated with these properties are packaged, but when they are unpacked, the packaged value is ignored and they are provided with default connection string values. If you choose to perform quick unpacking, these defaults are automatically accepted. If you choose custom unpacking, the defaults are displayed and you have the opportunity to change them. Even though they are ignored during unpacking, these connection strings are packaged in clear text, exposing them as a potential security risk.
The packaging of connection string values presents a potential security risk because the value, including any password, is stored as clear text in the site package. The following mechanism has been developed to avoid this security risk.
The f_connstr attribute provides a mechanism for suppressing the packaging of connection string values (or potentially, any sensitive configuration property). When this attribute is set to one (1), the associated property value is not packaged.
If you want a connection string to be packaged and unpacked without any user interaction, and you are willing to assume the potential security risk, do not begin your connection string property name with "connstr_db" and do not set the associated f_connstr attribute to one (1). Alternatively, you could create a Component Object Model (COM) object that implements the IPuP interface, and let that object handle the packaging and unpacking of your connection string.