Adding a New Column

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

1. Modify the schemas of the RAPStore and RAPCache databases:
   1. Modify both the RAPStore and RAPCache PowerDesigner models (PDM) and generate new data definition language (DDL) scripts.
   2. Run the scripts to update the database. See Data Model and Queries > Generating DDL Scripts.
2. Update RDS message templates:
   1. Locate an RDS message file connected to the table you are adding the column to, and add a field definition block to the file.
   2. Ensure that all publishers and subscribers are updated with the new RDS message templates by copying them into all subscribers.
3. Add a new call to the publisher API:
   1. Make a new publisher API call to the appropriate pub_setField API, based on the data type of the field.
4. Stop, shut down, and restart the subscribers and publishers to apply the changes.