Table Name | Change | Table Changes |
|---|
ADDRESSES
| Updated | | Expand |
|---|
| | Code Block |
|---|
| alter table ADDRESSES
drop index ADDRESSES_1
create unique index ADDRESSES_1
on ADDRESSES (
TENANTS_RECID,
STREET_ADDRESS,
ADDRESS2,
CITY,
STATE,
ZIP_CODE,
HOUSE_NUMBER,
HOUSE_NUMBER_SUFFIX,
PREFIX_DIRECTIONAL,
STREET_NAME,
STREET_SUFFIX,
POST_DIRECTIONAL
);
alter table ADDRESSES
drop constraint ADDRESSES_1
alter table ADDRESSES
add constraint ADDRESSES_1
unique (
TENANTS_RECID,
STREET_ADDRESS,
ADDRESS2,
CITY,
STATE,
ZIP_CODE,
HOUSE_NUMBER,
HOUSE_NUMBER_SUFFIX,
PREFIX_DIRECTIONAL,
STREET_NAME,
STREET_SUFFIX,
POST_DIRECTIONAL
); |
|
|
API_PERMISSIONS
| Updated | | Code Block |
|---|
| INSERT INTO `API_PERMISSIONS` (`TENANTS_RECID`, `MODIFIED_DATE`, `MODIFIED_BY`, `PERMISSION_NAME`) VALUES ('0', now(), 'pcr360', 'Report');
INSERT INTO `API_PERMISSIONS` (`TENANTS_RECID`, `MODIFIED_DATE`, `MODIFIED_BY`, `PERMISSION_NAME`) VALUES ('0', now(), 'pcr360', 'CableViewPath'); |
|
CONTACTS_EMAILS
| Updated | ALTER TABLE `CONTACTS_EMAILS` MODIFY COLUMN `EMAIL` VARCHAR(100) NOT NULL;
|
EQP_CATALOG_CHARGES
| Updated | | Code Block |
|---|
| alter table EQP_CATALOG_CHARGES
add PO_PRICING_MARKUP_PERCENT int null;
alter table EQP_CATALOG_CHARGES
add PO_PRICING_MARKUP_FLATRATE int null; |
|
EXPORT_FORMATS
| Updated | ALTER TABLE `EXPORT_FORMATS` ADD `REPORTS_RECID` INT NULL;
|
EVENTS
| Updated | | Code Block |
|---|
| INSERT INTO EVENTS
(TENANTS_RECID, MODIFIED_DATE, MODIFIED_BY, BROADCAST_BY, EVENT, LISTENER_CLASS, LISTENER_METHOD, OCCURRED_DATE, STATUS,
ATTEMPTS, FREQUENCY, NEXT_RUN_DATE, PROCESS_LOCKED)
VALUES (0, NOW(), 'system', 'pcr360-cli', 'sd-scheduled', 'Servicedesk_Model_ServiceDesk', 'eventScheduled', NOW(),
'PENDING', '0', 'Every 5 Minutes', NOW(), '0'); |
|
GRID_INDEX
| Added | CREATE TABLE `GRID_INDEX`
|
LISTS
| Updated | | Code Block |
|---|
| INSERT INTO LISTS
(TENANTS_RECID, STATUS, MODIFIED_DATE, MODIFIED_BY, LIST_TYPES_RECID, CODE, LISTS_ORDER, VALUE, DESCRIPTION, SYSTEM_USE)
VALUES (0, 1, NOW(), 'system', @list_types_recid, 'COMPLETE_ON', 9, 'Complete On',
'Service Desk Item or Action scheduled for completion', 1),
(0, 1, NOW(), 'system', @list_types_recid, 'FINALIZE_ON', 10, 'Finalize On',
'Service Desk Item or Action scheduled for finalization', 1); |
|
PURCHASE_ORDER
| Updated | | Code Block |
|---|
| alter table PURCHASE_ORDER
add SERVICE_DESK_RECID int null;
alter table PURCHASE_ORDER
add constraint PURCHASE_ORDER_5_FK
foreign key (SERVICE_DESK_RECID) references SERVICE_DESK (RECID); |
|
REPORTS
| Updated | ALTER TABLE `REPORTS` ADD `PDF_OPTIONS` LONGTEXT NULL;
|
REPORTS_BATCH
| Updated | | Code Block |
|---|
| ALTER TABLE `REPORTS_BATCH` MODIFY COLUMN `EVENTS_RECID` INT NULL;
ALTER TABLE `REPORTS_BATCH` ADD `SQL` LONGTEXT NOT NULL;
ALTER TABLE `REPORTS_BATCH` ADD `NOTIFICATION_SUBJECT` VARCHAR(200) NULL;
ALTER TABLE `REPORTS_BATCH` ADD `NOTIFICATION_MESSAGE` LONGTEXT NULL;
ALTER TABLE `REPORTS_BATCH` ADD `NOTIFICATION_ATTACH` TINYINT(1) DEFAULT 0 NOT NULL; |
|
REPORTS_SAVED
| Updated | ALTER TABLE `REPORTS_SAVED` MODIFY COLUMN `QUERY_STRING` VARCHAR(1024) NULL;
|
SERVICE_DESK
| Updated | | Code Block |
|---|
| ALTER TABLE `SERVICE_DESK` ADD `COMPLETE_ON_DATE` DATETIME NULL;
ALTER TABLE `SERVICE_DESK` ADD `FINALIZE_ON_DATE` DATETIME NULL; |
|
SERVICE_DESK_ACTIONS
| Updated | | Code Block |
|---|
| ALTER TABLE `SERVICE_DESK_ACTIONS` ADD `COMPLETE_ON_DATE` DATETIME NULL;
ALTER TABLE `SERVICE_DESK_ACTIONS` ADD `FINALIZE_ON_DATE` DATETIME NULL; |
|
SERVICE_DESK_ACTIVITY
| Updated | | Code Block |
|---|
| alter table SERVICE_DESK_ACTIVITY
add SERVICE_REMARK_DATE datetime null; |
|
SERVICE_DESK_EQP
| Updated | | Code Block |
|---|
| alter table SERVICE_DESK_EQP
add PURCHASE_ORDER_RECID int null;
alter table SERVICE_DESK_EQP
add constraint SERVICE_DESK_EQP_10_FK
foreign key (PURCHASE_ORDER_RECID) references PURCHASE_ORDER (RECID); |
|
TENANTS
| Updated | | Code Block |
|---|
| alter table TENANTS
add PO_PRICING_CONFIGURATION varchar(50) null;
alter table TENANTS
add PO_PRICING_MARKUP_PERCENT int null;
alter table TENANTS
add PO_PRICING_MARKUP_FLATRATE int null; |
|
USERS_PERSPECTIVES
| Updated | | Code Block |
|---|
| UPDATE USERS_PERSPECTIVES
SET IDENTIFIER = 'Application_Grid_Location_Default,default'
WHERE IDENTIFIER = 'Application_Grid_Location_Location,default';
UPDATE USERS_PERSPECTIVES
SET IDENTIFIER = 'Cabling_Grid_CableMain,default'
WHERE IDENTIFIER = 'Cabling_Grid_Cable,default'; |
|
