Share via


ExtendedProps Table

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.

See Also

Other Resources

ResourceProps Table

Resources Table

SiteResources Table

Sites Table

SystemProps Table

Resource Tables in the Administration Database