Implementing CONNECT 10r5.1.0

Files in CONNECT 10r5.1.0

CONNECT 10r5.1.0 is packaged as a complete release distribution and should be installed or upgraded by following the instructions in the Installation manual.

Note: CONNECT 10r5.1.0 is the first public release of the 10r5 series. CONNECT 10r5.0.0 was a limited-availability release and all changes since 10r4.3 have been incorporated into these release notes.

Schema Changes in Connect 10r5.1.0

Table 1.
Table Column Type Usage
       
CONTENT_REPOSITORY_MASTER NEW TABLE   New table to manage URLs and login information for content repositories.
DEPLOYMENT_MASTER SMPP_VERSION_UPDATE_IND char(1) Used to manage propagation of configuration information from database to deployed nodes.
DEPLOYMENT_MASTER VERSION_UPDATE_IND char(1) Used to manage propagation of configuration information from database to deployed nodes.
ETL2_CONFIG COMPANY_ID number Add company_id to match other etl2 tables.
KEY_MASTER NEW TABLE   New table used for storing cryptographic keys.
KNOWN_HOSTS_MASTER NEW TABLE   New table for storing SSH host keys in the database instead of in a file on the UI nodes.
LICENSE_MASTER NEW TABLE   License keys are now stored in the database instead of in files on each node.
SEND_HANDLER_MASTER CERTIFICATE blob Used to store certificates associated with delivery channels; primarily used by the APNS / iOS delivery channel.
SEND_HANDLER_MASTER FILTER_ID number Add link to the targeting query filter for the deliver channel address attribute.
SEND_HANDLER_PROPERTIES NEW TABLE   New table for storing configuration properties for delivery channels.
SEND_HANDLER_PROPERTIES_NAMES NEW TABLE   New table for storing the names of configuration properties for delivery channels.
USER_AGENT_MASTER BROWSER varchar(256) User to filter user agent strings by browser
USER_AGENT_MASTER BROWSER_VERSION varchar(256) User to filter user agent strings by browser version
USER_AGENT_MASTER PLATFORM varchar(256) User to filter user agent strings by platform