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 following table describes the columns of the ResourceProps 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 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 you access the property programmatically with the GlobalConfigFreeThreaded, GlobalConfig2FreeThreaded, SiteConfigFreeThreaded, and SiteConfigReadOnlyFreeThreaded objects. Typically, this name is descriptive and starts with a letter that indicates the data type of the property and an underscore. For example, "i_RetryInterval" 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 the note later in this topic for more information about this flag and its relationship to connection string configuration values. |
f_IsHidden |
When set to "1", the Generic Resource dialog box 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 enables the storage of multivalued properties. |
s_Description |
This column is not used. |
i_Vartype |
An integer that indicates 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. |
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. |
Note
Commerce Server Site Packager performs special processing for resource properties that have names that start 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 decide to perform quick unpacking, these defaults are automatically accepted. If you decide custom unpacking, the defaults are displayed and you can 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 is stored as clear text in the site package. This includes any password. The following mechanism has been developed to avoid this security risk.