ExtendedProps Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The ExtendedProps table stores the characteristics of the custom resource properties that can be defined for a resource. Together with the SystemProps table, this table defines the schema of the Administration (MSCS_Admin) database.
The columns of the ExtendedProps table are described in the following table.
Note
Do not modify the definition of this table for any reason. It is described here for reference.
Column |
Description |
---|---|
s_ResourceType |
A string that is used to map a single row in the SystemProps table, representing a single resource type, with the associated resource properties in this table. The corresponding column in the SystemProps table is also named s_ResourceType. |
s_PropertyName |
Set to an arbitrary string that serves as the internal name of the property, and 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 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 the Commerce Server Site Packager will prompt for connect information for a specific database when it unpacks. For additional information about this flag and its relationship to connection string configuration values, see the note in ResourceProps Table. |
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 allows for the storage of multi-valued properties. |
s_Description |
An arbitrary descriptive string that is displayed in the Generic Resource dialog box. |
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. |
s_Value |
The default value for this resource property, if any. |
s_DisplayName |
A user-friendly display name for the property that is shown in the Generic Resource dialog box. |