Upgrade Responder Tables
To create tables, views, and indices in the Responder database, use the scripts provided with the Responder server installation. By default, the scripts are installed here: Program Files\Miner and Miner\Responder\Developer Resources\. At the time of installation, the user may elect to have them installed elsewhere.
If you have Responder already installed and are upgrading to a later release, you need only run the appropriate Upgrade scripts. The upgrade folders are named with the starting release and the release to which you are going. For example, 9.1 SP1 - 9.1.2 Upgrade Scripts. If your current release is more than one behind the one to which you are upgrading, you will need to run all of the upgrade scripts between your old release and the new release. This ensures that all of the database enhancements made between the releases are available on your Responder database.
If you are implementing Responder for the first time, you need only run the Implementation Scripts. Do not run any Upgrade scripts for a new implementation.
If the upgrade script adds a new table to your database, your Database Administrator must update the read/write permissions. The table below indicates whether the upgrade tool adds new tables to the database. The table does not list all of the tasks performed, only whether tables are added. "None" does NOT mean the upgrade script does nothing.
|
Release |
Tables Added |
|---|---|
|
10.6.1 |
None |
|
10.2.1d |
None |
|
10.2.1c |
None |
|
10.2.1b |
RX_JUMPER_STEPS RX_JUMPER_STEPS_HISTORY RX_JUMPER_STEPS_ARCHIVE |
|
10.2.1a |
RX_JUMPERS_ARCHIVE RX_JUMPERS_HISTORY |
|
10.2.1 |
No scripts for this release. |
|
10.2 |
No scripts for this release. |
|
10.1.1 |
RX_JUMPERS |
|
10.1 |
None |
|
10.0.3 |
None |
|
10.0.2 |
RX_LINEDISPLAY_STATUS |
|
10.0.1 SP1 |
None |
|
10.0.1 |
No scripts for this release. |
|
9.3.1 SP1 |
RX_AFFECTED_XFRS RX_EVENTS_FEEDERLOCK RX_FAULT_LOCATIONS RX_SIMULATED_SO_LOADPOINTS RX_SWITCHING_FOLDERS RX_SWITCHING_ORDER_FEATURES RX_SWITCHING_ORDER_REQUESTS RX_SW_OR_AFFECTED_LOADPOINTS RX_SW_OR_AFFECTED_XFRS RX_SW_OR_FEATURES_HISTORY RX_SW_OR_REQUESTS_HISTORY |
|
9.3.1 |
No scripts for this release. |
|
9.3 Rev2 |
RX_RMA_TIMES |
|
9.3 SP1 |
RX_FAULT_LOCATIONS |
|
9.3 |
None |
|
9.2.1 |
RX_REGION_CUSTOMERS RX_XLOCK |
|
9.2 SP3 |
None |
|
9.2 SP2 |
RX_REGION_ETR RX_FEEDER_ETR |
|
9.2 |
RX_HAZARD_ASSIGN_ARCHIVE RX_HAZARD_ASSIGN_HISTORY RX_HAZARD_ASSIGNMENTS RX_HAZARDS_ARCHIVE RX_HAZARDS_HISTORY RX_HAZARDS RX_INC_DEV_ASSIGN_ARCHIVE RX_INC_DEV_ASSIGN_HISTORY RX_INC_DEV_ASSIGNMENTS RX_INC_FEAT_ASSIGN_ARCHIVE RX_INC_FEAT_ASSIGN_HISTORY RX_INC_FEAT_ASSIGNMENTS RX_PERMISSION RX_PROBABLE_STATE_CANDIDATE RX_REGION_MODE_ASSIGNMENTS RX_ROLE_TASKS RX_ROLE RX_TASK_PERMISSIONS RX_TASK RX_USER_MEMBERSHIP RX_USER_ROLES |
|
9.1.2 SP1 |
None |
|
9.1.2 |
RX_INCIDENT_FEATURES RX_INCIDENTS_ARCHIVE RX_INCIDENT_DEVICES_ARCHIVE RX_INCIDENT_FEATURES_ARCHIVE RX_LOADPOINTS_ARCHIVE RX_CUSTOMERS_ARCHIVE RX_CUST_LOADPOINTS_ARCHIVE RX_CREW_ASSIGNMENTS_ARCHIVE RX_CREWS_ARCHIVE RX_CREW_MEMBERS_ARCHIVE RX_TRUCKS_ARCHIVE RX_TAGS_AND_GROUNDS_ARCHIVE RX_FEEDER_CUSTOMERS RX_T_MAJOR_EVENT_DAY |
|
9.1 SP1 |
RX_REGIONS RX_USERS RX_REGION_ASSIGNMENTS RX_FEEDERS RX_ELEMENT_LOCKS |