Adding a New Table

Add a new table to your RAPStore and RAPCache database schemas if the standard schemas do not suit your needs, or to use custom messages.

1. Modify the RAPStore and RAPCache database schemas:
   1. Generate both the RAPStore and RAPCache PowerDesigner model (PDM) and data definition language (DDL) scripts for the new table.
   2. Run the scripts to update the database. See Data Model and Queries > Generating DDL Scripts.
2. Create a new RDS message template:
   1. Create a new RDS message definition specifying the new table as the destination table.
   2. Ensure that the message type has a unique value across all RDS message definitions.
   3. For each column in the new database table, add a field definition block to the message definition.
   4. Ensure that all publishers and subscribers are updated with the new RDS message templates by copying the new information to all subscribers.
3. Modify the publisher code:
   1. Make a call to the pub_beginMessage API specifying the new message definition's message type.
   2. For each field in the message, make a call to the appropriate pub_setField API to pass in the field data.
   3. Make a call to the pub_sendMessage API to send the data.
4. Stop, shut down, and restart the subscribers and publishers for the changes to take effect.