Chronicle Element for SubscriptionClass/Chronicles (ADF)

Provides a location for specifying information about one subscription chronicle table.

구문

<SubscriptionClasses>
    <SubscriptionClass>
        ...
        <Chronicles>
            <Chronicle>

Element Characteristics

Characteristic	Description
Data type	None.
Default value	None.
Occurrence	Required once or more within a Chronicles element.
Updates	Can be added and deleted when updating the application.

Element Relationships

Relationship	Elements
Parent element	Chronicles Element for SubscriptionClass (ADF)
Child elements	ChronicleName Element for SubscriptionClass/Chronicles/Chronicle (ADF) SqlSchema Element for SubscriptionClass/Chronicles/Chronicle (ADF)

주의

If you delete a Chronicle element, updating the application re-creates the subscription class to which it corresponds. SQL Server 2005 Notification Services renames the existing tables for the subscription class by appending "Old" to the table names. Existing subscription table indexes are left unchanged. If you want to transfer data between the old and new subscription tables, it must be done manually. For more information, see 응용 프로그램 업데이트.

예

The following example shows a Chronicle element that deletes any existing table named StockSubscriptionChron and then creates the StockSubscriptionChron chronicle table.

<Chronicle>
    <ChronicleName>StockSubscriptionChron</ChronicleName>
    <SqlSchema>
        <SqlStatement>
        IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES 
        WHERE TABLE_NAME = &apos;StockSubscriptionChron&apos;)
        DROP TABLE StockSubscriptionChron
        </SqlStatement>
        <SqlStatement>
        CREATE TABLE StockSubscriptionChron
        (
        SubscriberId bigint,
        StockSymbol char(10),
        StockPrice money
        PRIMARY KEY (SubscriberId)
        );
        </SqlStatement>
    </SqlSchema>
</Chronicle>

참고 항목

참조

Application Definition File Reference

관련 자료

구독 클래스에 대한 기록 정의
인스턴스 및 응용 프로그램 업데이트

도움말 및 정보

SQL Server 2005 지원 받기