Schema Element for SubscriptionClass (ADF)

Contains elements that define subscription class fields.

Syntax

<SubscriptionClasses>
    <SubscriptionClass>
        ...
        <Schema>

Element Characteristics

Element Relationships

Remarks

A subscription class schema defines a subscription class table in the application database. Notification Services automatically adds SubscriberID, Created, Updated, and Enabled columns to the subscription class schema.

Example

The following example shows a Schema element that creates four subscription fields:

• A 255-character subscriber device name field. You typically include this field if your application supports multiple device types.
• A 10-character subscriber locale. You typically include this field if your application supports multiple locales.
• A 10-character stock symbol field.
• A stock trigger price field that accepts monetary data.

<Schema>
    <Field>
        <FieldName>DeviceName</FieldName>
        <FieldType>nvarchar(255)</FieldType>
        <FieldTypeMods>NOT NULL</FieldTypeMods>
    </Field>
    <Field>
        <FieldName>SubscriberLocale</FieldName>
        <FieldType>nvarchar(10)</FieldType>
        <FieldTypeMods>NOT NULL</FieldTypeMods>
    </Field>
    <Field>
        <FieldName>StockSymbol</FieldName>
        <FieldType>char(10)</FieldType>
        <FieldTypeMods>NOT NULL</FieldTypeMods>
    </Field>
    <Field>
        <FieldName>StockTriggerPrice</FieldName>
        <FieldType>money</FieldType>
        <FieldTypeMods>NOT NULL DEFAULT 10</FieldTypeMods>
    </Field>
</Schema>

See Also

Reference

Application Definition File Reference

Other Resources

Defining the Subscription Schema
Updating Instances and Applications

Help and Information

Getting SQL Server 2005 Assistance