Release 2019.2 is now available. This patch contains a number of stabilization fixes and refinements. We will begin scheduling 2019.2 updates on customer Test systems starting April 24th, 2019.
Note: All versions after 2018.1 require an upgrade to PHP 7.2, hosted customers and customers who have 2018.1 already have the php upgrade. Most updates to test systems will need to occur during non-business hours. Please send any scheduling requests to help@pcr.com.
This release contains some table changes that could cause issues with Adhocs, API calls, or other custom processes. Please review the Database Changes in 2019.2 to review the changes and make the necessary changes to your customizations.
Licensed Customers will need to install PHP 7.2 before we can upgrade test to 2019.2, the instructions can be found here: PHP 7.2 Upgrade. Please consult PCR before upgrading your system.
Key
Toggle cloak |
---|
Cloak | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
...
Anchor | ||||
---|---|---|---|---|
|
Table Name | Change | Table Changes |
---|
APIS
Removed
AUTHENTICATION_LOG
Added AUTH_SOURCE VARCHAR(20)
BILLS
Added BILL_END_DATE DATETIME NULL
Changed BILL_END_DATE to not allow NULL
API_KEYS
API_KEYS_PERMISSIONS
API_KEYS_USERS
API_KEYS_USERS_TOKENS
API_PERMISSIONS
API_REQUESTS
CONTACTS_REMARKS | update | ADD COLUMN HTML_REMARKS NOT NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS |
DEPT_HIERARCHY_REMARKS | update | ADD COLUMN HTML_REMARKS NOT NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS |
SERVICES_REMARKS | update | ADD COLUMN HTML_REMARKS NOT NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS |
EQUIPMENT_REMARKS | update | ADD COLUMN HTML_REMARKS NOT NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS |
SERVICE_DESK_ACTIVITY | update | ADD COLUMN HTML_REMARKS DEFAULT NULL ADD COLUMN PLAIN_REMARKS DEFAULT NULL DROP COLUMN REMARKS |
PURCHASE_ORDER_ACTIVITY | update | ADD COLUMN HTML_REMARKS DEFAULT NULL ADD COLUMN PLAIN_REMARKS DEFAULT NULL DROP COLUMN REMARKS |
RETURN_ORDER_ACTIVITY | update | ADD COLUMN HTML_REMARKS DEFAULT NULL ADD COLUMN PLAIN_REMARKS DEFAULT NULL DROP COLUMN REMARKS |
PAYMENTS_REMARKS | update | ADD COLUMN HTML_REMARKS NO NULL ADD COLUMN PLAIN_REMARKS NOT NULL DROP COLUMN REMARKS |
PACKAGES | update | ADD COLUMN PACKAGE_TYPE_LISTS_RECID INTEGER NOT NULL |
IMPORT_RECORD_TYPES_COLS | update | Removed BILLED_DATE, CONSUMED, SDA_NUMBER and AVAILABLE_SERVICE_HOST as column options. |
LOCATIONS_REMARKS | update | |
GLA_ACTIVITY | update | |
AVAYA_AARDIGITCONVERSION | update | Renamed AVAYA_AARDIGITCONVERSION TO AVAYA_AARDIGITCONVERSIONS |
AVAYA_ABBREVIATEDDIALINGGROUP | update | Renamed AVAYA_ABBREVIATEDDIALINGGROUP TO AVAYA_ABBREVIATEDDIALINGGROUPS |
AVAYA_AGENT | update | Renamed AVAYA_AGENT TO AVAYA_AGENTS |
AVAYA_ANNOUNCEMENT | update | Renamed AVAYA_ANNOUNCEMENT TO AVAYA_ANNOUNCEMENTS |
AVAYA_ARSDIGITCONVERSION | update | Renamed AVAYA_ARSDIGITCONVERSION TO AVAYA_ARSDIGITCONVERSIONS |
AVAYA_AUDIOGROUP | update | Renamed AVAYA_AUDIOGROUP TO AVAYA_AUDIOGROUPS |
AVAYA_AUTHORIZATIONCODE | update | Renamed AVAYA_AUTHORIZATIONCODE TO AVAYA_AUTHORIZATIONCODES |
AVAYA_CABINET | update | Renamed AVAYA_CABINET TO AVAYA_CABINETS |
AVAYA_COR | update | Renamed AVAYA_COR TO AVAYA_CORS |
AVAYA_COVERAGEPATH | update | Renamed AVAYA_COVERAGEPATH TO AVAYA_COVERAGEPATHS |
AVAYA_CTILINK | update | Renamed AVAYA_CTILINK TO AVAYA_CTILINKS |
AVAYA_EXTENSIONTYPE | update | Renamed AVAYA_EXTENSIONTYPE TO AVAYA_EXTENSIONTYPES |
AVAYA_HUNTGROUP | update | Renamed AVAYA_HUNTGROUP TO AVAYA_HUNTGROUPS |
AVAYA_IPSERVERINTERFACE | update | Renamed AVAYA_IPSERVERINTERFACE TO AVAYA_IPSERVERINTERFACES |
AVAYA_MEDIAGATEWAY | update | Renamed AVAYA_MEDIAGATEWAY TO AVAYA_MEDIAGATEWAYS |
AVAYA_PICKUPGROUP | update | Renamed AVAYA_PICKUPGROUP TO AVAYA_PICKUPGROUPS |
AVAYA_PORT | update | Renamed AVAYA_PORT TO AVAYA_PORTS |
AVAYA_REGISTEREDIPSTATION | update | Renamed AVAYA_REGISTEREDIPSTATION TO AVAYA_REGISTEREDIPSTATIONS |
AVAYA_ROUTEPATTERN | update | Renamed AVAYA_ROUTEPATTERN TO AVAYA_ROUTEPATTERNS |
AVAYA_SIGNALINGGROUP | update | Renamed AVAYA_SIGNALINGGROUP TO AVAYA_SIGNALINGGROUPS |
AVAYA_STATION | update | Renamed AVAYA_STATION TO AVAYA_STATIONS |
AVAYA_TRUNKGROUP | update | Renamed AVAYA_TRUNKGROUP TO AVAYA_TRUNKGROUPS |
AVAYA_UNIFORMDIALPLAN | update | Renamed AVAYA_UNIFORMDIALPLAN TO AVAYA_UNIFORMDIALPLANS |
AVAYA_VDN | update | Renamed AVAYA_VDN TO AVAYA_VDNS |
AVAYA_VECTOR | update | Renamed AVAYA_VECTOR TO AVAYA_VECTORS |
AVAYA_WITNESSSTATION | update | Renamed AVAYA_WITNESSSTATION TO AVAYA_WITNESSSTATIONS |