Database Changes in 6.3.1

1 Database Changes in 6.3.1

MSS 6.3.1 includes all the database changes that were included in the 6.3 patches. For detailed information about the database changes made in each release, see MSS 6.3 Database Change Reference.

Table 1-1 lists the database changes in 6.3.1. Database changes for subsequent patch releases will be added to this table as they are released.

Table 1-1 Database Changes in 6.3.1

Release	Prodfixsql File	Change	SQL
6.3.1.74/ASR 61	31203683.sql	New Columns	Alter Table ASAP.NS_NS_COMP ADD NS_INGRESS_EGRESS_IND CHAR(1) NULL
6.3.1.192/ASR 62	32007520.sql	New Columns	alter table ASAP.ASR_CONTACT_INFORMATION add IMPL_CONTACT_EMAIL Varchar2(60) Null
6.3.1.192/ASR 62	32007520.sql	New Columns	alter table ASAP.ACCESS_SERVICE_REQUEST add VARIABLE_TERM_AGMT_IND Char(1) Null
6.3.1.192/ASR 62	32007520.sql	New Columns	alter table ASAP.ACCESS_PROVIDER_ROLE add OEC_VTAI Char(1) Null
6.3.1.192/ASR 62	26980505.sql	New Columns	ALTER TABLE ASAP.BEHAVIOR_TASK_TYPE ADD ( REOPEN_ON_CANCEL_IND CHAR(1) DEFAULT ''N'', BYPASS_ON_CANCEL_IND CHAR(1) DEFAULT ''N'' )
6.3.1.192/ASR 62	26980505.sql	New Columns	ALTER TABLE ASAP.PROVISIONING_PLAN_TASK ADD ( REOPEN_ON_CANCEL_IND CHAR(1) DEFAULT ''N'', BYPASS_ON_CANCEL_IND CHAR(1) DEFAULT ''N'' )
6.3.1.192/ASR 62	26980505.sql	New Columns	ALTER TABLE ASAP.TASK ADD ( REOPEN_ON_CANCEL_IND CHAR(1) DEFAULT ''N'', BYPASS_ON_CANCEL_IND CHAR(1) DEFAULT ''N'', BEEN_READY_IND CHAR(1) DEFAULT ''N'' )
6.3.1.192/ASR 62	31768184.sql	New Columns	ALTER TABLE ASAP.CIRCUIT ADD (CPN_OVERRIDE_IND CHAR(1))
6.3.1.192/ASR 62	31768184.sql	New Columns	ALTER TABLE ASAP.CIRCUIT_POSITION ADD (CHANNEL_ALIAS VARCHAR2(15))
6.3.1.223	31785197.sql	Modify Columns	ALTER TABLE ASAP.PORT_ADDRESS MODIFY SOFT_OVERRIDE_NODE_ADDRESS VARCHAR2(48)
6.3.1.223	31785197.sql	Modify Columns	ALTER TABLE ASAP.PORT_ADDRESS MODIFY NODE_ADDRESS VARCHAR2(48)
6.3.1.267/ASR 63	29520710.sql	New Columns	ALTER TABLE ASAP.DV_ASSIGN_LOG ADD NC_CIRCUIT_DESIGN_ID NUMBER(9,0)
6.3.1.267/ASR 63	29520710.sql	Modify Columns	ALTER TABLE ASAP.DS_DVRSTY_SET MODIFY DS_DVRSTY_SET_TYPE_CD VARCHAR2(2)
6.3.1.267/ASR 63	32889981.sql	Modify Columns	ALTER TABLE ebond.foc_provider_circuit MODIFY UNIT_CHANNEL VARCHAR2(25)
6.3.1.267/ASR 63	32889981.sql	Modify Columns	ALTER TABLE ASAP.DESIGN_DLR_ISI MODIFY INTEREXCHANGE_CARRIER_NM VARCHAR2(25)
6.3.1.267/ASR 63	32889981.sql	Modify Columns	ALTER TABLE ASAP.DESIGN_LAYOUT_REPORT MODIFY INTEREXCHANGE_CARRIER_NAME VARCHAR2(25)
6.3.1.333	33110375.sql	New Columns	ALTER TABLE ASAP.SERVICE_TYPE add FLEX_GRID_IND CHAR(1) DEFAULT ''N''
6.3.1.333	33110375.sql	New Columns	ALTER TABLE ASAP.TRANSMISSION_FACILITY_CIRCUIT add FLEX_GRID_IND CHAR(1) DEFAULT ''N''
6.3.1.333	33110375.sql	New Table	CREATE TABLE ASAP.FLEX_GRID_PROFILE ( FLEX_GRID_PROFILE_ID Number(3,0) Not Null, PROFILE_NAME Varchar2(30) Not Null, LOW_FREQUENCY Number(4,1) Not Null, HIGH_FREQUENCY Number(4,1) Not Null, CHANNEL_SPACING Number(4,2) Not Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA
6.3.1.333	33110375.sql	New Index	create unique index ASAP.PK_FLEX_GRID_PROFILE on ASAP.FLEX_GRID_PROFILE (FLEX_GRID_PROFILE_ID asc) tablespace INDEXES
6.3.1.333	33110375.sql	New Constraint	alter table ASAP.FLEX_GRID_PROFILE add constraint PK_FLEX_GRID_PROFILE primary key (FLEX_GRID_PROFILE_ID)
6.3.1.333	33110375.sql	New Sequence	CREATE SEQUENCE ASAP.SQ_FLEX_GRID_PROFILE MINVALUE 100 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 100 CACHE 20 NOORDER NOCYCLE
6.3.1.333	33110375.sql	New Synonym	CREATE PUBLIC SYNONYM FLEX_GRID_PROFILE FOR ASAP.FLEX_GRID_PROFILE
6.3.1.333	33110375.sql	New Table	CREATE TABLE ASAP.SERVICE_TYPE_FLEX_GRID_PROFILE_REL ( SERVICE_TYPE_CATEGORY Varchar2(20) Not Null, SERVICE_TYPE_CODE Varchar2(10) Not Null, FLEX_GRID_PROFILE_ID Number(3,0) Not Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA
6.3.1.333	33110375.sql	New Index	create unique index ASAP.PK_SERV_TYP_FLEX_GRID_PROF_REL on SERVICE_TYPE_FLEX_GRID_PROFILE_REL ("SERVICE_TYPE_CATEGORY", "SERVICE_TYPE_CODE", "FLEX_GRID_PROFILE_ID") tablespace INDEXES
6.3.1.333	33110375.sql	New Constraint	alter table ASAP.SERVICE_TYPE_FLEX_GRID_PROFILE_REL add constraint PK_SERV_TYP_FLEX_GRID_PROF_REL primary key ("SERVICE_TYPE_CATEGORY", "SERVICE_TYPE_CODE", "FLEX_GRID_PROFILE_ID")
6.3.1.333	33110375.sql	New Constraint	alter table ASAP.SERVICE_TYPE_FLEX_GRID_PROFILE_REL add constraint FK_SERTYP_FLEX_REL__FLEX_GRID_PROF foreign key (FLEX_GRID_PROFILE_ID) references ASAP.FLEX_GRID_PROFILE (FLEX_GRID_PROFILE_ID)
6.3.1.333	33110375.sql	New Constraint	alter table ASAP.SERVICE_TYPE_FLEX_GRID_PROFILE_REL add constraint FK_SERTYP_FLEX_REL__SERV_TYPE foreign key ("SERVICE_TYPE_CATEGORY","SERVICE_TYPE_CODE") references ASAP.SERVICE_TYPE ("SERVICE_TYPE_CATEGORY","SERVICE_TYPE_CODE")
6.3.1.333	33110375.sql	New Synonym	create public synonym SERVICE_TYPE_FLEX_GRID_PROFILE_REL for ASAP.SERVICE_TYPE_FLEX_GRID_PROFILE_REL
6.3.1.333	33110375.sql	New Columns	alter table ASAP.CIRCUIT_POSITION add CENTER_FREQUENCY NUMBER (8,5) Null
6.3.1.333	33110375.sql	New Columns	alter table ASAP.CIRCUIT_POSITION add CHANNEL_WIDTH NUMBER (9,1) Null
6.3.1.333	33110375.sql	New Columns	alter table ASAP.CIRCUIT_POSITION add LOW_FREQUENCY NUMBER (8,5) Null
6.3.1.333	33110375.sql	New Columns	alter table ASAP.CIRCUIT_POSITION add HIGH_FREQUENCY NUMBER (8,5) Null
6.3.1.333	33110375.sql	New Columns	alter table ASAP.TRANSMISSION_FACILITY_CIRCUIT add FLEX_GRID_PROFILE_ID Number(3,0)
6.3.1.333	33110375.sql	New Constraint	alter table ASAP.TRANSMISSION_FACILITY_CIRCUIT add constraint FK_TFC__FLEX_GRID_PROF foreign key (FLEX_GRID_PROFILE_ID) references ASAP.FLEX_GRID_PROFILE (FLEX_GRID_PROFILE_ID)
6.3.1.417	31214920.sql^**	New Table	CREATE TABLE ASAP.NET_LOC_GEOMETRY ( LOCATION_ID NUMBER(9,0) , LONG_DEC NUMBER(9,6), LAT_DEC NUMBER(9,6), GEOMETRY SDO_GEOMETRY, "LAST_MODIFIED_USERID" VARCHAR2(8 BYTE), "LAST_MODIFIED_DATE" DATE ) tablespace DATA
6.3.1.417	31214920.sql^**	New Index	create unique index ASAP.PK_NET_LOC_GEOMETRY on ASAP.NET_LOC_GEOMETRY (LOCATION_ID asc) tablespace INDEXES
6.3.1.417	31214920.sql^**	New Constraint	alter table ASAP.NET_LOC_GEOMETRY add constraint PK_NET_LOC_GEOMETRY primary key (LOCATION_ID)
6.3.1.417	31214920.sql^**	New Synonym	create public synonym NET_LOC_GEOMETRY for ASAP.NET_LOC_GEOMETRY
6.3.1.417	31214920.sql^**	New Index	CREATE INDEX NET_LOC_GEOMETRY_SPATIAL_IDX ON ASAP.NET_LOC_GEOMETRY (GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX
6.3.1.452/ASR 65	34090885.sql	New Column	ALTER TABLE ASAP.ACCESS_SERVICE_REQUEST ADD NEXT_GEN_911 Char(1) Null
6.3.1.587/ASR 66	34776614.sql	New Column	ALTER TABLE ASAP.ACCESS_SERVICE_REQUEST ADD PRILOC_SITE_SURVEY_DATE_IND DATE NULL
6.3.1.587/ASR 66	34776614.sql	New Column	ALTER TABLE ASAP.ACCESS_SERVICE_REQUEST ADD SECLOC_SITE_SURVEY_DATE_IND DATE NULL
6.3.1.643	34987038.sql	New Table	CREATE TABLE ASAP.NI_NBR_INV_CONDITION ( NBR_INV_ID NUMBER(9,0) NOT NULL, CONDITION_CODE VARCHAR2(20) Not Null, COMMENTS VARCHAR2(250), LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE DATE Not Null, EXPIRE_DT DATE ) tablespace DATA
6.3.1.643	34987038.sql	New Index	create unique index ASAP.PK_NI_NBR_INV_CONDITION on ASAP.NI_NBR_INV_CONDITION (NBR_INV_ID,CONDITION_CODE) tablespace INDEXES
6.3.1.643	34987038.sql	New Constraint	alter table ASAP.NI_NBR_INV_CONDITION add constraint PK_NI_NBR_INV_CONDITION primary key (NBR_INV_ID,CONDITION_CODE)
6.3.1.643	34987038.sql	New Constraint	alter table ASAP.NI_NBR_INV_CONDITION add constraint FK_NI_NBR_INV_CONDITION_CON_COD foreign key (CONDITION_CODE) references ASAP.CONDITION_CODE (CONDITION_CODE)
6.3.1.643	34987038.sql	New Constraint	alter table ASAP.NI_NBR_INV_CONDITION add constraint FK_NI_NBR_INV_CONDITION_NI_NBR_INV foreign key (NBR_INV_ID) references ASAP.NI_NBR_INV (NBR_INV_ID)
6.3.1.643	34987038.sql	New Synonym	CREATE PUBLIC SYNONYM NI_NBR_INV_CONDITION FOR ASAP.NI_NBR_INV_CONDITION
6.3.1.705 / ASR67	13054390.sql	New Columns	Alter table ASAP.task_sequence add NR_TASK_DEP_ID NUMBER(9) NULL
6.3.1.705 / ASR67	13054390.sql	New Table	create table ASAP.NotReq_Task_Sequences (NR_TASK_ID NUMBER(9) NOT NULL, DOCUMENT_NUMBER NUMBER(9) NOT NULL, TASK_NUMBER NUMBER(9) NOT NULL, RELATED_DOCUMENT_NUMBER NUMBER(9) NOT NULL, RELATED_TASK_NUMBER NUMBER(9) NOT NULL, LAST_MODIFIED_USERID VARCHAR2(8) NOT NULL, LAST_MODIFIED_DATE DATE NOT NULL) tablespace DATA;
6.3.1.705 / ASR67	13054390.sql	New Table	create table ASAP.NotReq_Task_dependencies (NR_TASK_DEP_ID NUMBER(9) NOT NULL, NR_TASK_ID NUMBER(9) NOT NULL, LAST_MODIFIED_USERID VARCHAR2(8) NOT NULL, LAST_MODIFIED_DATE DATE NOT NULL) tablespace DATA;
6.3.1.705/ASR67	13054390.sql	New Constraint	ALTER TABLE ASAP.task_sequence ADD CONSTRAINT UK_NR_TASK_DEP_ID UNIQUE (NR_TASK_DEP_ID);
6.3.1.705/ASR67	13054390.sql	New Constraint	ALTER TABLE ASAP.NotReq_Task_Sequences ADD CONSTRAINT UK_NotReq_Task_Sequences UNIQUE (DOCUMENT_NUMBER,TASK_NUMBER,RELATED_DOCUMENT_NUMBER,RELATED_TASK_NUMBER);
6.3.1.705/ASR67	13054390.sql	New Constraint	alter table ASAP.NotReq_Task_Sequences add constraint PK_NotReq_Task_Sequences primary key (NR_TASK_ID);
6.3.1.705/ASR67	13054390.sql	New Constraint	alter table ASAP.NotReq_Task_dependencies add constraint PK_NotReq_Task_dependencies primary key (NR_TASK_DEP_ID,NR_TASK_ID)
6.3.1.705/ASR67	13054390.sql	New Constraint	alter table ASAP.NotReq_Task_dependencies add constraint FK_NR_TASK_DEP_ID foreign key (NR_TASK_DEP_ID) references ASAP.Task_Sequence (NR_TASK_DEP_ID)
6.3.1.705/ASR67	13054390.sql	New Constraint	alter table ASAP.NotReq_Task_dependencies add constraint FK_NR_TASK_ID foreign key (NR_TASK_ID) references ASAP.NotReq_Task_Sequences (NR_TASK_ID)
6.3.1.705/ASR67	13054390.sql	New Sequence	CREATE SEQUENCE ASAP.SQ_TASK_SEQ_NR_TASK_DEP_ID MINVALUE 1000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1000 CACHE 20 NOORDER NOCYCLE;
6.3.1.705/ASR67	13054390.sql	New Sequence	CREATE SEQUENCE ASAP.SQ_NotReq_Task_Sequences MINVALUE 1000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1000 CACHE 20 NOORDER NOCYCLE;
6.3.1.705/ASR67	13054390.sql	New Synonym	CREATE PUBLIC SYNONYM NotReq_Task_Sequences FOR ASAP.NotReq_Task_Sequences;
6.3.1.705/ASR67	13054390.sql	New Synonym	CREATE PUBLIC SYNONYM NotReq_Task_dependencies FOR ASAP.NotReq_Task_dependencies;
6.3.1.705/ASR67	35163615.sql	New Columns	alter table ASAP.EVC_DETAIL add EVC_QTY number(1) Null ;
6.3.1.705/ASR67	35163615.sql	New Columns	alter table ASAP.FOC_EVC add EVC_NBR varchar2(4) default ''0001'' NOT Null;
6.3.1.705/ASR67	35163615.sql	New Columns	ALTER table ASAP.FOC_EVC_OAM add EVC_NBR varchar2(4) default ''0001'' NOT Null;
6.3.1.705/ASR67	35163615.sql	New Columns	ALTER table ASAP.PTA_VIRTUAL_CIRCUIT_DETAIL add VC_NUM varchar2(4) default ''0001'' NOT Null;
6.3.1.705/ASR67	35163615.sql	New Index	CREATE UNIQUE INDEX ASAP.PFXPK_FOC_EVC_NEW ON ASAP.FOC_EVC (FOC_DESIGN_ID, EVC_NBR, UNI_REF_NBR) TABLESPACE INDEXES;
6.3.1.705/ASR67	35163615.sql	Drop Constraint	ALTER TABLE ASAP.FOC_EVC DROP CONSTRAINT PFXPK_FOC_EVC;
6.3.1.705/ASR67	35163615.sql	Drop Index	DROP INDEX ASAP.PFXPK_FOC_EVC;
6.3.1.705/ASR67	35163615.sql	New Constraint	ALTER TABLE ASAP.FOC_EVC ADD CONSTRAINT PFXPK_FOC_EVC_NEW PRIMARY KEY (FOC_DESIGN_ID, EVC_NBR, UNI_REF_NBR) USING INDEX ASAP.PFXPK_FOC_EVC_NEW ENABLE;
6.3.1.705/ASR67	35163615.sql	Rename Constraint	ALTER TABLE ASAP.FOC_EVC RENAME CONSTRAINT PFXPK_FOC_EVC_NEW TO PFXPK_FOC_EVC;
6.3.1.705/ASR67	35163615.sql	Rename Index	ALTER INDEX ASAP.PFXPK_FOC_EVC_NEW RENAME TO PFXPK_FOC_EVC;
6.3.1.705/ASR67	35163615.sql	New Index	CREATE UNIQUE INDEX ASAP.PFXPK_FOC_EVC_OAM_NEW ON ASAP.FOC_EVC_OAM (FOC_EVC_OAM_ID,EVC_NBR) TABLESPACE INDEXES ;
6.3.1.705/ASR67	35163615.sql	Drop Constraint	ALTER TABLE ASAP.FOC_EVC_OAM DROP CONSTRAINT PFXPK_FOC_EVC_OAM;
6.3.1.705/ASR67	35163615.sql	Drop Index	DROP INDEX ASAP.PFXPK_FOC_EVC_OAM;
6.3.1.705/ASR67	35163615.sql	New Constraint	ALTER TABLE ASAP.FOC_EVC_OAM ADD CONSTRAINT PFXPK_FOC_EVC_OAM_NEW PRIMARY KEY (FOC_EVC_OAM_ID,EVC_NBR) USING INDEX ASAP.PFXPK_FOC_EVC_OAM_NEW ENABLE;
6.3.1.705/ASR67	35163615.sql	Rename Constraint	ALTER INDEX ASAP.PFXPK_FOC_EVC_OAM_NEW RENAME TO PFXPK_FOC_EVC_OAM;
6.3.1.705/ASR67	35163615.sql	Rename Index	ALTER INDEX ASAP.PFXPK_FOC_EVC_OAM_NEW RENAME TO PFXPK_FOC_EVC_OAM;
6.3.1.705/ASR67	35163615.sql	New Index	CREATE UNIQUE INDEX ASAP.PFXPK_PTA_VCKT_DETAIL_NEW ON ASAP.PTA_VIRTUAL_CIRCUIT_DETAIL (PTA_ID, VC_NUM, UNI_REF_NBR) TABLESPACE INDEXES ;
6.3.1.705/ASR67	35163615.sql	Drop Constraint	ALTER TABLE ASAP.PTA_VIRTUAL_CIRCUIT_DETAIL DROP CONSTRAINT PFXPK_PTA_VCKT_DETAIL;
6.3.1.705/ASR67	35163615.sql	Drop Index	DROP INDEX ASAP.PFXPK_PTA_VCKT_DETAIL;
6.3.1.705/ASR67	35163615.sql	New Constraint	ALTER TABLE ASAP.PTA_VIRTUAL_CIRCUIT_DETAIL ADD CONSTRAINT PFXPK_PTA_VCKT_DETAIL_NEW PRIMARY KEY (PTA_ID, VC_NUM, UNI_REF_NBR) USING INDEX ASAP.PFXPK_PTA_VCKT_DETAIL_NEW ENABLE;
6.3.1.705/ASR67	35163615.sql	Rename Constraint	ALTER TABLE ASAP.PTA_VIRTUAL_CIRCUIT_DETAIL RENAME CONSTRAINT PFXPK_PTA_VCKT_DETAIL_NEW TO PFXPK_PTA_VCKT_DETAIL ;
6.3.1.705/ASR67	35163615.sql	Rename Index	ALTER INDEX ASAP.PFXPK_PTA_VCKT_DETAIL_NEW RENAME TO PFXPK_PTA_VCKT_DETAIL;
6.3.1.750	35631081.sql	New Columns	Alter table ASAP.PORT_ADDRESS_CONDITION ADD EQ_SPEC_IND CHAR(1) NULL;
6.3.1.750	35631081.sql	New Columns	Alter table ASAP.MOUNTING_POSITION_CONDITION ADD EQ_SPEC_IND CHAR(1) NULL;
6.3.1.750	35631081.sql	New Table	Create table ASAP.EQ_SPEC_MOUNTING_POSITION_CONDITION (EQUIPMENT_SPEC_ID NUMBER(9,0) NOT NULL, MOUNTPOS_SEQ NUMBER(5,0) NOT NULL, CONDITION_CODE VARCHAR2(20) NOT NULL, COMMENTS VARCHAR2(255), LAST_MODIFIED_DATE DATE NOT NULL, LAST_MODIFIED_USERID VARCHAR2(8) NOT NULL, EXPIRE_DT DATE);
6.3.1.750	35631081.sql	New Table	Create table ASAP.EQ_SPEC_PORT_ADDRESS_CONDITION (EQUIPMENT_SPEC_ID NUMBER(9,0) NOT NULL, PORTADDR_SEQ NUMBER(9,0) NOT NULL, CONDITION_CODE VARCHAR2(20) NOT NULL, COMMENTS VARCHAR2(255), LAST_MODIFIED_DATE DATE NOT NULL, LAST_MODIFIED_USERID VARCHAR2(8) NOT NULL, EXPIRE_DT DATE);
6.3.1.750	35631081.sql	New Constraint	Alter table ASAP.EQ_SPEC_MOUNTING_POSITION_CONDITION add constraint PK_EQ_SPEC_MOUNTING_POSITION_CONDITION primary key (EQUIPMENT_SPEC_ID, MOUNTPOS_SEQ, CONDITION_CODE)';
6.3.1.750	35631081.sql	New Constraint	Alter table ASAP.EQ_SPEC_MOUNTING_POSITION_CONDITION add constraint FK_EQ_SPEC_MOU_POS_CON__CON_COD foreign key (CONDITION_CODE) references ASAP.CONDITION_CODE (CONDITION_CODE)';
6.3.1.750	35631081.sql	New Constraint	Alter table ASAP.EQ_SPEC_MOUNTING_POSITION_CONDITION add constraint FK_EQ_SPEC_MOU_POS_CON__EQ_SPEC_MOU_POS foreign key (EQUIPMENT_SPEC_ID, MOUNTPOS_SEQ) references ASAP.EQUIPMENT_SPEC_MOUNTING_POS (EQUIPMENT_SPEC_ID, MOUNTPOS_SEQ)';
6.3.1.750	35631081.sql	New Index	create index FKIDX_EQ_SPEC_MOU_POS_CON__CON_COD on ASAP.EQ_SPEC_MOUNTING_POSITION_CONDITION (CONDITION_CODE)';
6.3.1.750	35631081.sql	New Constraint	Alter table ASAP.EQ_SPEC_PORT_ADDRESS_CONDITION add constraint PK_EQ_SPEC_PORT_ADDRESS_CONDITION primary key (EQUIPMENT_SPEC_ID, PORTADDR_SEQ, CONDITION_CODE)';
6.3.1.750	35631081.sql	New Constraint	Alter table ASAP.EQ_SPEC_PORT_ADDRESS_CONDITION add constraint FK_EQ_SPEC_POR_ADD_CON__CON_COD foreign key (CONDITION_CODE) references ASAP.CONDITION_CODE (CONDITION_CODE)';
6.3.1.750	35631081.sql	New Constraint	Alter table ASAP.EQ_SPEC_PORT_ADDRESS_CONDITION add constraint FK_EQ_SPEC_POR_ADD_CON__EQ_SPEC_POR_ADD foreign key (EQUIPMENT_SPEC_ID, PORTADDR_SEQ) references ASAP.EQUIPMENT_SPEC_PORT_ADDRESS (EQUIPMENT_SPEC_ID, PORTADDR_SEQ)';
6.3.1.750	35631081.sql	New Index	create index FKIDX_EQ_SPEC_POR_ADD_CON__CON_COD on ASAP.EQ_SPEC_PORT_ADDRESS_CONDITION (CONDITION_CODE)';
6.3.1.750	35631081.sql	New Synonym	CREATE PUBLIC SYNONYM EQ_SPEC_MOUNTING_POSITION_CONDITION FOR ASAP.EQ_SPEC_MOUNTING_POSITION_CONDITION';
6.3.1.750	35631081.sql	New Synonym	CREATE PUBLIC SYNONYM EQ_SPEC_PORT_ADDRESS_CONDITION FOR ASAP.EQ_SPEC_PORT_ADDRESS_CONDITION';
6.3.1.788/ASR68	35872720.sql	New Columns	alter table ASAP.ACCESS_SERVICE_REQUEST add EVC_QTY number(1) Null
6.3.1.845/ASR69	36469941.sql	Modify Columns	alter table ASAP.REMARK modify REMARK varchar2(450)
6.3.1.845/ ASR69	36469941.sql	Modify Columns	alter table ASAP.ASR_AUDIT_HISTORY modify CURRENT_FIELD_VALUE varchar2(450)
6.3.1.845/ASR69	36469941.sql	Modify Columns	alter table ASAP.ASR_AUDIT_HISTORY modify PREVIOUS_FIELD_VALUE varchar2(450)
6.3.1.845/ASR69	36469941.sql	Modify Columns	alter table ASAP.ASR_SUPPLEMENT_HISTORY modify CURRENT_FIELD_VALUE varchar2(450)
6.3.1.845/ASR69	36469941.sql	Modify Columns	alter table ASAP.ASR_SUPPLEMENT_HISTORY modify PREVIOUS_FIELD_VALUE varchar2(450)
6.3.1.915/ASR70	37242508.sql	Modify Columns	alter table ASAP.CLARIFICATION_REQUEST_ERRORS modify CR_ERROR_MESSAGE Varchar2(180)
6.3.1.915/ASR70	37242508.sql	Modify Columns	alter table ASAP.ASR_ERROR modify CURRENT_VALUE Varchar2(200)

**This is optional and the corresponding database changes occur only when you run MapsInstall.sql to use the Engineering Maps View feature within MSS.