Chronicle Element for SubscriptionClass/Chronicles (ADF)
Provides a location for specifying information about one subscription chronicle table.
Sintaxis
<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 |
|
Child elements |
ChronicleName Element for SubscriptionClass/Chronicles/Chronicle (ADF) SqlSchema Element for SubscriptionClass/Chronicles/Chronicle (ADF) |
Notas
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 Actualizar una aplicación.
Ejemplo
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 = 'StockSubscriptionChron')
DROP TABLE StockSubscriptionChron
</SqlStatement>
<SqlStatement>
CREATE TABLE StockSubscriptionChron
(
SubscriberId bigint,
StockSymbol char(10),
StockPrice money
PRIMARY KEY (SubscriberId)
);
</SqlStatement>
</SqlSchema>
</Chronicle>
Vea también
Referencia
Application Definition File Reference
Otros recursos
Definir crónicas para una clase de suscripción
Actualizar instancias y aplicaciones