Sites Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The Sites table is the starting point for retrieving data about a site. It maps the site name with a site ID. This ID differs from the Internet Information Services (IIS) metabase ID for the site. Together with the ResourceProps, Resources, and SiteResources tables, this table stores the data for the Administration database.
Entries in the Sites table have a one-to-many relationship with entries in the SiteResources table.
The following table describes the columns of the Sites table.
Note
Do not modify the definition of this table for any reason. It is described here for reference.
Column |
Description |
|---|---|
i_SiteID |
An integer that identifies a particular site. This column corresponds to the i_SiteID columns in the PupDBScripts and SiteResources tables. |
s_Name |
A string that contains a user-friendly name for the site. |
s_Description |
An optional string that contains a user-friendly description for the site. |
i_Status |
This column is currently not used. |
d_DateCreated |
The date and time that this site entry was created. |
d_DateModified |
The date and time that this site entry was last modified. |