MSS 6.3 includes all the database changes that were included in 6.0.16 patches, 6.2.0 patches, and 6.2.1 patches. For detailed information about the database changes made in each release, see MSS 6.2.1 Database Change Reference.
Table 1-1 lists the database changes that were included in 6.3 patches. The build number where the change was first introduced is referenced.
Table 1-1 Database Changes in 6.3 Patches
| Release | Prodfixsql File | Change | SQL |
|---|---|---|---|
|
6.3.0.555 |
25940130.sql |
Modify Columns |
alter table asap.equipment_spec modify (equipment_acronym varchar2(25)) |
|
6.3.0.639 |
26878933.sql |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add PREVIOUS_PON Varchar2(16) null |
|
6.3.0.639 |
26878933.sql |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add TERM_LIABILITY_EXCEPTION char(1) null |
|
6.3.0.639 |
26878933.sql |
New Columns |
alter table ASAP.EVC_LVL_SERV add PER_PACKET_CLASS_OF_SERVICE Varchar2(21) null |
|
6.3.0.639 |
26878933.sql |
New Columns |
alter table ASAP.ACCESS_PROVIDER_ROLE add OEC_DESIRE_DUE_DATE Date null |
|
6.3.0.639 |
26435406.sql |
Modify Columns |
alter table asap.dl_dlr_line_isi modify (LOCATION varchar2 (50)) |
|
6.3.0.639 |
21196090.sql |
Modify Columns |
alter table asap.Provisioning_plan_task modify (EXPEDITED_COMPLETION_DAYS number (3), COMPLETION_DAYS number(3)) |
|
6.3.0.639 |
21196090.sql |
Modify Columns |
alter table asap.BEHAVIOR_TASK_TYPE modify (EXPEDITED_COMPLETION_DAYS number (3), COMPLETION_DAYS number(3)) |
|
6.3.0.639 |
21196090.sql |
Modify Columns |
alter table asap.TASK modify (EXPEDITED_COMPLETION_DAYS number (3), COMPLETION_DAYS number(3)) |
|
6.3.0.639 |
25542432.sql |
New Columns |
alter table ASAP.DESIGN_LAYOUT_REPORT add PRILOC_ALT_CONTACT_NM Varchar2(15) null |
|
6.3.0.639 |
25542432.sql |
New Columns |
alter table ASAP.DESIGN_LAYOUT_REPORT add SECLOC_ALT_CONTACT_NM Varchar2(15) null |
|
6.3.0.639 |
25542432.sql |
New Columns |
alter table ASAP.DESIGN_LAYOUT_REPORT add PRILOC_LOCAL_CONTACT_EMAIL Varchar2(60) null |
|
6.3.0.639 |
25542432.sql |
New Columns |
alter table ASAP.DESIGN_LAYOUT_REPORT add SECLOC_LOCAL_CONTACT_EMAIL Varchar2(60) null |
|
6.3.0.639 |
25542432.sql |
New Columns |
alter table ASAP.DESIGN_LAYOUT_REPORT add PRILOC_ALT_LOCAL_CONTACT_EMAIL Varchar2(60) null |
|
6.3.0.639 |
25542432.sql |
New Columns |
alter table ASAP.DESIGN_LAYOUT_REPORT add SECLOC_ALT_LOCAL_CONTACT_EMAIL Varchar2(60) null |
|
6.3.0.639 |
25542432.sql |
New Columns |
alter table ASAP.DESIGN_LAYOUT_REPORT add PRILOC_ALT_CONTACT_TEL_NBR Varchar2(17) null |
|
6.3.0.639 |
25542432.sql |
New Columns |
alter table ASAP.DESIGN_LAYOUT_REPORT add SECLOC_ALT_CONTACT_TEL_NBR Varchar2(17) null |
|
6.3.0.733 |
27756814.sql |
Modify Columns |
alter table ASAP.ADDRESS add LATITUDE Varchar2(9) null |
|
6.3.0.733 |
27756814.sql |
Modify Columns |
alter table ASAP.ADDRESS add LONGITUDE Varchar2(11) null |
|
6.3.0.733 |
27756814.sql |
New Table |
CREATE TABLE ASAP.PROVIDER_TEST_ACCEPTANCE ( PTA_ID Number(9,0) Not Null, DOCUMENT_NUMBER Number(9,0) Not Null, ASR_VERSION_IDENTIFICATION Varchar2(2) Null, ASR_NUMBER Varchar2(18) Null, ACCESS_PROVIDER_SERV_CTR_CODE Varchar2(4) Null, DATE_TIME_SENT Date Null, AP_CONTACT_NAME Varchar2(15) Null, AP_CONTACT_TELEPHONE_NUMBER Varchar2(17) Null, AP_MTCE_TELEPHONE_NUMBER Varchar2(10) Null, AP_EMAIL Varchar2(60) Null, PTA_VER Varchar2(2) Null, TEST_ACCEPTANCE_COMPLETION_DT Date Null, LINK_AGGREGATION_GROUP_ID Varchar2(24) Null, MULTI_CHAS_LINK_AGGR_GROUP_ID Varchar2(24) Null, TEST_LOCAL_CONTACT_NAME Varchar2(15) Null, TEST_ACCESS_TELEPHONE_NUMBER Varchar2(17) Null, TEST_LOCAL_CONTACT_EMAIL Varchar2(60) Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA |
|
6.3.0.733 |
27756814.sql |
New Index |
create unique index ASAP.PFXPK_PTA on PROVIDER_TEST_ACCEPTANCE (PTA_ID asc) tablespace INDEXES |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PROVIDER_TEST_ACCEPTANCE add constraint PFXPK_PTA primary key (PTA_ID) |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PROVIDER_TEST_ACCEPTANCE add constraint PFXFK_PTA_ACC_SERV_REQ foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER) |
|
6.3.0.733 |
27756814.sql |
New Sequence |
CREATE SEQUENCE ASAP.SQ_PTA MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE |
|
6.3.0.733 |
27756814.sql |
New Synonym |
CREATE PUBLIC SYNONYM SQ_PTA FOR ASAP.SQ_PTA |
|
6.3.0.733 |
27756814.sql |
New Synonym |
create public synonym PROVIDER_TEST_ACCEPTANCE for ASAP.PROVIDER_TEST_ACCEPTANCE |
|
6.3.0.733 |
27756814.sql |
New Table |
CREATE TABLE ASAP.PTA_LOCATION ( PTA_ID Number(9,0) Not Null, PTA_SERV_LOC_USE Varchar2(10) Not Null, ADDRESS_NUMBER_PREFIX Varchar2(6) Null, ADDRESS_NUMBER Varchar2(10) Null, ADDRESS_NUMBER_SUFFIX Varchar2(4) Null, STREET_DIRECTIONAL_PREFIX Varchar2(2) Null, STREET_NAME Varchar2(60) Null, STREET_TYPE Varchar2(7) Null, STREET_DIRECTIONAL_SUFFIX Varchar2(2) Null, LOCATION_DESIGNATOR1 Varchar2(4) Null, LOCATION_VALUE1 Varchar2(10) Null, LOCATION_DESIGNATOR2 Varchar2(4) Null, LOCATION_VALUE2 Varchar2(10) Null, LOCATION_DESIGNATOR3 Varchar2(4) Null, LOCATION_VALUE3 Varchar2(10) Null, GA_INSTANCE_ID_CITY Number(9) Null, GA_INSTANCE_ID_STATE_CD Number(9) Null, GA_INSTANCE_ID_COUNTRY Number(9) Null, ZIP_CODE Varchar2(12) Null, LOCATION_ID Number(9,0) Null, ADD_ADDRESS_DMARC_INFO Varchar2(120) Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA |
|
6.3.0.733 |
27756814.sql |
New Index |
create unique index ASAP.PFXPK_PTA_LOC on PTA_LOCATION (PTA_ID asc,PTA_SERV_LOC_USE asc) tablespace INDEXES |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_LOCATION add constraint PFXPK_PTA_LOC primary key (PTA_ID,PTA_SERV_LOC_USE) |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_LOCATION add constraint PFXFK_PTALOC_PTA foreign key (PTA_ID) references ASAP.PROVIDER_TEST_ACCEPTANCE (PTA_ID) |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_LOCATION add constraint PFXFK_PTALOC_NETLOC foreign key (LOCATION_ID) references ASAP.NETWORK_LOCATION (LOCATION_ID) |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_LOCATION add constraint PFXFK_PTALOC_CITY FOREIGN KEY (GA_INSTANCE_ID_CITY) REFERENCES ASAP.GA_INSTANCE (GA_INSTANCE_ID) |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_LOCATION add constraint PFXFK_PTALOC_STATE FOREIGN KEY (GA_INSTANCE_ID_STATE_CD) REFERENCES ASAP.GA_INSTANCE (GA_INSTANCE_ID) |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_LOCATION add constraint PFXFK_PTALOC_CNTRY FOREIGN KEY (GA_INSTANCE_ID_COUNTRY) REFERENCES ASAP.GA_INSTANCE (GA_INSTANCE_ID) |
|
6.3.0.733 |
27756814.sql |
New Synonym |
create public synonym PTA_LOCATION for ASAP.PTA_LOCATION |
|
6.3.0.733 |
27756814.sql |
New Table |
CREATE TABLE ASAP.PTA_CIRCUIT ( PTA_ID Number(9,0) Not Null, REFERENCE_NUMBER Varchar2(4) Not Null, ECCKT Varchar2(53) Null, ACCESS_ECCKT Varchar2(42) Null, CKR Varchar2(53) Null, JACK_CODE Varchar2(5) Null, NETWORK_INTERFACE_DEVICE_TYPE Varchar2(3) Null, RACK Varchar2(10) Null, PORT Varchar2(4) Null, EXTENDED_WIRING_INDICATOR char(1) Null, EXTENDED_WIRING_TYPE Char(1) Null, CONNECTING_FACILITY_ASSIGNMENT Varchar2(42) Null, CROSS_CONNECT_EQ_ASSIGN Varchar2(60) Null, PORT_SPEED Varchar2(6) Null, PORT_SPEED_UOM Char(1) Null, ACCESS_SPEED Varchar2(8) Null, ORDER_NUMBER Varchar2(17) Null, COMPLETED_WITH_RELATED_ORDER Varchar2(17) Null, TESTING_TYPE Varchar2(124) Null, TESTING_RESULTS Varchar2(124) Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA |
|
6.3.0.733 |
27756814.sql |
New Index |
create unique index ASAP.PFXPK_PTA_CKT on PTA_CIRCUIT (PTA_ID asc, REFERENCE_NUMBER asc) tablespace INDEXES |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_CIRCUIT add constraint PFXPK_PTA_CKT primary key (PTA_ID, REFERENCE_NUMBER) |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_CIRCUIT add constraint PFXFK_PTACKT_PTA foreign key (PTA_ID) references ASAP.PROVIDER_TEST_ACCEPTANCE (PTA_ID) |
|
6.3.0.733 |
27756814.sql |
New Synonym |
create public synonym PTA_CIRCUIT for ASAP.PTA_CIRCUIT |
|
6.3.0.733 |
27756814.sql |
New Table |
CREATE TABLE ASAP.PTA_VIRTUAL_CIRCUIT ( PTA_ID Number(9,0) Not Null, VC_NUM Varchar2(4) Not Null, UNI_REF_NBR Varchar2(2) Not Null, VC_ID Varchar2(28) Null, VC_ORD Varchar2(17) Null, VC_CKR Varchar2(53) Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA |
|
6.3.0.733 |
27756814.sql |
New Index |
create unique index ASAP.PFXPK_PTA_VIRT_CKT on PTA_VIRTUAL_CIRCUIT (PTA_ID asc,VC_NUM asc,UNI_REF_NBR asc) tablespace INDEXES |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_VIRTUAL_CIRCUIT add constraint PFXPK_PTA_VIRT_CKT primary key (PTA_ID,VC_NUM,UNI_REF_NBR) |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_VIRTUAL_CIRCUIT add constraint PFXFK_PTAVIRCKT_PTA foreign key (PTA_ID) references ASAP.PROVIDER_TEST_ACCEPTANCE (PTA_ID) |
|
6.3.0.733 |
27756814.sql |
New Synonym |
create public synonym PTA_VIRTUAL_CIRCUIT for ASAP.PTA_VIRTUAL_CIRCUIT |
|
6.3.0.733 |
27756814.sql |
New Table |
CREATE TABLE ASAP.PTA_VIRTUAL_CIRCUIT_DETAIL ( PTA_ID Number(9) Not Null, UNI_REF_NBR Varchar2(2) Not Null, STACKED_VLAN Varchar2(9) Null, CUSTOMER_EDGE_VLAN Varchar2(9) Null, REL_UNI_IDENT Varchar2(28) Null, INTERFACE_HANDOFF Varchar2(10) Null, INTERFACE_MODE Varchar2(8) Null, LVL_OF_SERV_NM_1 Varchar2(20) Null, LVL_OF_SERV_NM_2 Varchar2(20) Null, LVL_OF_SERV_NM_3 Varchar2(20) Null, LVL_OF_SERV_NM_4 Varchar2(20) Null, LVL_OF_SERV_NM_5 Varchar2(20) Null, BANDWIDTH_1 Varchar2(6) Null, BANDWIDTH_UOM_1 char(1) Null, BANDWIDTH_2 Varchar2(6) Null, BANDWIDTH_UOM_2 char(1) Null, BANDWIDTH_3 Varchar2(6) Null, BANDWIDTH_UOM_3 char(1) Null, BANDWIDTH_4 Varchar2(6) Null, BANDWIDTH_UOM_4 char(1) Null, BANDWIDTH_5 Varchar2(6) Null, BANDWIDTH_UOM_5 char(1) Null, COMMITTED_INFO_RATE_INGRESS Varchar2(6) Null, COMMITTED_INFO_RATE_INGR_UOM Char(1) Null, TESTING_TYPE Varchar2(124) Null, TESTING_RESULTS Varchar2(124) Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA |
|
6.3.0.733 |
27756814.sql |
New Index |
create unique index ASAP.PFXPK_PTA_VCKT_DETAIL on PTA_VIRTUAL_CIRCUIT_DETAIL (PTA_ID asc,UNI_REF_NBR asc) tablespace INDEXES |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_VIRTUAL_CIRCUIT_DETAIL add constraint PFXPK_PTA_VCKT_DETAIL primary key (PTA_ID,UNI_REF_NBR) |
|
6.3.0.733 |
27756814.sql |
New Constraint |
alter table ASAP.PTA_VIRTUAL_CIRCUIT_DETAIL add constraint PFXFK_PTAVCKT_DTL_PTA foreign key (PTA_ID) references ASAP.PROVIDER_TEST_ACCEPTANCE (PTA_ID) |
|
6.3.0.733 |
27756814.sql |
New Synonym |
create public synonym PTA_VIRTUAL_CIRCUIT_DETAIL for ASAP.PTA_VIRTUAL_CIRCUIT_DETAIL |
|
6.3.0.733 |
27615889.sql |
New Index |
CREATE INDEX ASAP.IDX_DE_LA_RE_TE_SE_PR ON ASAP.DESIGN_LAYOUT_REPORT (TELECOM_SERVICE_PRIORITY) |
|
6.3.0.733 |
27615889.sql |
New Index |
CREATE INDEX ASAP.IDX_DESIGN_TE_SE_PR ON ASAP.DESIGN (TELECOM_SERVICE_PRIORITY) |
|
6.3.0.733 |
27615889.sql |
New Index |
CREATE INDEX ASAP.IDX_value_label ON ASAP.serv_req_si_value (value_label) |
|
6.3.0.772 |
27616093.sql |
New Table |
CREATE TABLE ASAP.CIRCUIT_PRIORITY( PRIORITY_ID NUMBER(2) NOT NULL, PRIORITY_CODE VARCHAR2(20) NOT NULL, PRIORITY_CODE_DESC VARCHAR2(50) NOT NULL, PRIORITY_LEVEL NUMBER(1) NOT NULL, LAST_MODIFIED_USERID VARCHAR2(8) NOT NULL, LAST_MODIFIED_DATE DATE NOT NULL) |
|
6.3.0.772 |
27616093.sql |
New Constraint |
ALTER TABLE ASAP.CIRCUIT_PRIORITY ADD CONSTRAINT PK_CIRCUIT_PRIORITY PRIMARY KEY (PRIORITY_ID) |
|
6.3.0.772 |
27616093.sql |
New Synonym |
CREATE PUBLIC SYNONYM SQ_CIRCUIT_PRIORITY FOR ASAP.SQ_CIRCUIT_PRIORITY |
|
6.3.0.772 |
27616093.sql |
New Sequence |
CREATE SEQUENCE ASAP.SQ_CIRCUIT_PRIORITY MINVALUE 1 MAXVALUE 99 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE |
|
6.3.0.772 |
27616093.sql |
Modify Columns |
ALTER TABLE ASAP.CIRCUIT ADD PRIORITY_ID NUMBER(2) NULL |
|
6.3.0.772 |
27616093.sql |
New Constraint |
ALTER TABLE ASAP.CIRCUIT ADD CONSTRAINT FK_CIRCUIT_CIRCUIT_PRIORITY foreign key (PRIORITY_ID) references ASAP.CIRCUIT_PRIORITY(PRIORITY_ID) |
|
6.3.0.772 |
28465486.sql |
Modify Columns |
ALTER TABLE ASAP.EQUIPMENT_SPEC ADD VLAN_PORT_CAPABLE_IND CHAR(1) DEFAULT ''N'' NOT NULL |
|
6.3.0.842 |
28694073.sql |
New Columns |
alter table ASAP.SPECIAL_ACCESS add LATENCY Varchar2(7) Null |
|
6.3.0.842 |
28694073.sql |
New Columns |
alter table ASAP.EVC_DETAIL add OAM_INDICATOR Char(1) Null |
|
6.3.0.842 |
28694073.sql |
New Table |
CREATE TABLE ASAP.EVC_OAM_DETAIL ( EVC_OAM_DETAIL_ID Number(9,0) Not Null, DOCUMENT_NUMBER Number(9,0) Not Null, EVC_NBR Varchar2(4) Not Null, OAM_ACTIVITY Char(1) Null, MAINT_ENTITY_GROUP_LEVEL Char(1) Null, MAINT_END_POINT_IDENTIFIER Varchar2(4) Null, SHORT_MAINT_ASSOC_NAME Varchar2(45) Null, SHORT_MAINT_ASSOC_NAME_FORMAT Varchar2(2) Null, SUBSCRIBER_MEG_MIP Char(1) Null, PEER_MEP_ID_ACT_IND1 Char(1) Null, PEER_MEP_ID1 Varchar2(4) Null, PEER_MEP_ID_ACT_IND2 Char(1) Null, PEER_MEP_ID2 Varchar2(4) Null, PEER_MEP_ID_ACT_IND3 Char(1) Null, PEER_MEP_ID3 Varchar2(4) Null, PEER_MEP_ID_ACT_IND4 Char(1) Null, PEER_MEP_ID4 Varchar2(4) Null, PEER_MEP_ID_ACT_IND5 Char(1) Null, PEER_MEP_ID5 Varchar2(4) Null, PEER_MEP_ID_ACT_IND6 Char(1) Null, PEER_MEP_ID6 Varchar2(4) Null, PEER_MEP_ID_ACT_IND7 Char(1) Null, PEER_MEP_ID7 Varchar2(4) Null, PEER_MEP_ID_ACT_IND8 Char(1) Null, PEER_MEP_ID8 Varchar2(4) Null, PEER_MEP_ID_ACT_IND9 Char(1) Null, PEER_MEP_ID9 Varchar2(4) Null, PEER_MEP_ID_ACT_IND10 Char(1) Null, PEER_MEP_ID10 Varchar2(4) Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA |
|
6.3.0.842 |
28694073.sql |
New Index |
create unique index ASAP.PFXPK_EVC_OAM_DETAIL on EVC_OAM_DETAIL (EVC_OAM_DETAIL_ID asc) tablespace INDEXES |
|
6.3.0.842 |
28694073.sql |
New Constraint |
alter table ASAP.EVC_OAM_DETAIL add constraint PFXPK_EVC_OAM_DETAIL primary key (EVC_OAM_DETAIL_ID) |
|
6.3.0.842 |
28694073.sql |
New Constraint |
alter table ASAP.EVC_OAM_DETAIL add constraint PFXFK_EV_OA_DE__EV_DE foreign key (DOCUMENT_NUMBER,EVC_NBR) references EVC_DETAIL (DOCUMENT_NUMBER,EVC_NBR) |
|
6.3.0.842 |
28694073.sql |
New Sequence |
CREATE SEQUENCE ASAP.SQ_EVC_OAM_DETAIL MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE |
|
6.3.0.842 |
28694073.sql |
New Synonym |
CREATE PUBLIC SYNONYM EVC_OAM_DETAIL FOR ASAP.EVC_OAM_DETAIL |
|
6.3.0.842 |
28694073.sql |
New Table |
CREATE TABLE ASAP.CR_ADDRESS_MODIFICATION ( CR_ADDR_MOD_ID Number(9,0) Not Null, DOCUMENT_NUMBER Number(9,0) Not Null, CR_SEQ Number(3) Not Null, SUP_IDENT CHAR(1) Null, REF_NUM Varchar2(4) Null, PRILOC_IND Char(1) Null, ADDRESS_NUMBER_PREFIX Varchar2(6) Null, ADDRESS_NUMBER Varchar2(10) Null, ADDRESS_NUMBER_SUFFIX Varchar2(4) Null, STREET_DIRECTIONAL_PREFIX Varchar2(2) Null, STREET_NAME Varchar2(60) Null, STREET_TYPE Varchar2(7) Null, STREET_DIRECTIONAL_SUFFIX Varchar2(2) Null, LOCATION_DESIGNATOR1 Varchar2(4) Null, LOCATION_VALUE1 Varchar2(10) Null, LOCATION_DESIGNATOR2 Varchar2(4) Null, LOCATION_VALUE2 Varchar2(10) Null, LOCATION_DESIGNATOR3 Varchar2(4) Null, LOCATION_VALUE3 Varchar2(10) Null, GA_INSTANCE_ID_CITY Number(9) Null, GA_INSTANCE_ID_STATE_CD Number(9) Null, GA_INSTANCE_ID_COUNTRY Number(9) Null, ZIP_CODE Varchar2(12) Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA |
|
6.3.0.842 |
28694073.sql |
New Index |
create unique index ASAP.PFXPK_CR_ADDR_MOD on CR_ADDRESS_MODIFICATION (CR_ADDR_MOD_ID asc) tablespace INDEXES |
|
6.3.0.842 |
28694073.sql |
New Constraint |
alter table ASAP.CR_ADDRESS_MODIFICATION add constraint PFXPK_CR_ADDR_MOD primary key (CR_ADDR_MOD_ID) |
|
6.3.0.842 |
28694073.sql |
New Constraint |
alter table ASAP.CR_ADDRESS_MODIFICATION add constraint PFXFK_CR_AD_MO__CL_RE foreign key (DOCUMENT_NUMBER,CR_SEQ) references ASAP.CLARIFICATION_REQUEST (DOCUMENT_NUMBER,CR_SEQ) |
|
6.3.0.842 |
28694073.sql |
New Index |
create index ASAP.PFXFK_CR_AD_MO__CL_RE on CR_ADDRESS_MODIFICATION (DOCUMENT_NUMBER,CR_SEQ) tablespace INDEXES |
|
6.3.0.842 |
28694073.sql |
New Constraint |
alter table ASAP.CR_ADDRESS_MODIFICATION add constraint PFXFK_CR_ADDR_MOD_CITY FOREIGN KEY (GA_INSTANCE_ID_CITY) REFERENCES ASAP.GA_INSTANCE (GA_INSTANCE_ID) |
|
6.3.0.842 |
28694073.sql |
New Constraint |
alter table ASAP.CR_ADDRESS_MODIFICATION add constraint PFXFK_CR_ADDR_MOD_STATE FOREIGN KEY (GA_INSTANCE_ID_STATE_CD) REFERENCES ASAP.GA_INSTANCE (GA_INSTANCE_ID) |
|
6.3.0.842 |
28694073.sql |
New Constraint |
alter table ASAP.CR_ADDRESS_MODIFICATION add constraint PFXFK_CR_ADDR_MOD_CNTRY FOREIGN KEY (GA_INSTANCE_ID_COUNTRY) REFERENCES ASAP.GA_INSTANCE (GA_INSTANCE_ID) |
|
6.3.0.842 |
28694073.sql |
New Sequence |
CREATE SEQUENCE ASAP.SQ_CR_ADDRESS_MODIFICATION MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE |
|
6.3.0.842 |
28694073.sql |
New Synonym |
create public synonym CR_ADDRESS_MODIFICATION for ASAP.CR_ADDRESS_MODIFICATION |
|
6.3.0.842 |
28694073.sql |
New Table |
CREATE TABLE ASAP.FOC_EVC_OAM ( FOC_EVC_OAM_ID Number(9,0) Not Null, FOC_DESIGN_ID Number(9,0) Not Null, MAINT_END_POINT_IDENTIFIER Varchar2(4) Null, SHORT_MAINT_ASSOC_NAME Varchar2(45) Null, PEER_MEP_ID1 Varchar2(4) Null, PEER_MEP_ID2 Varchar2(4) Null, PEER_MEP_ID3 Varchar2(4) Null, PEER_MEP_ID4 Varchar2(4) Null, PEER_MEP_ID5 Varchar2(4) Null, PEER_MEP_ID6 Varchar2(4) Null, PEER_MEP_ID7 Varchar2(4) Null, PEER_MEP_ID8 Varchar2(4) Null, PEER_MEP_ID9 Varchar2(4) Null, PEER_MEP_ID10 Varchar2(4) Null, LAST_MODIFIED_USERID Varchar2(8) Not Null, LAST_MODIFIED_DATE Date Not Null ) tablespace DATA |
|
6.3.0.842 |
28694073.sql |
New Index |
create unique index ASAP.PFXPK_FOC_EVC_OAM on FOC_EVC_OAM (FOC_EVC_OAM_ID asc) tablespace INDEXES |
|
6.3.0.842 |
28694073.sql |
New Constraint |
alter table ASAP.FOC_EVC_OAM add constraint PFXPK_FOC_EVC_OAM primary key (FOC_EVC_OAM_ID) |
|
6.3.0.842 |
28694073.sql |
New Constraint |
alter table ASAP.FOC_EVC_OAM add constraint PFXFK_FO_EV_OA__FI_OR_CO foreign key (FOC_DESIGN_ID) references ASAP.FIRM_ORDER_CONFIRMATION (FOC_DESIGN_ID) |
|
6.3.0.842 |
28694073.sql |
New Sequence |
CREATE SEQUENCE ASAP.SQ_FOC_EVC_OAM MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE |
|
6.3.0.842 |
28694073.sql |
New Synonym |
create public synonym FOC_EVC_OAM for ASAP.FOC_EVC_OAM |
|
6.3.0.842 |
28800383.sql |
New Sequence |
Alter sequence asap.sq_circuit_priority MaxValue 99999 |
|
6.3.0.842 |
28800383.sql |
Modify Columns |
Alter table asap.circuit Modify PRIORITY_ID NUMBER(5) |
|
6.3.0.842 |
28800383.sql |
Modify Columns |
Alter table asap.circuit_priority Modify PRIORITY_ID NUMBER(5) |
|
6.3.0.904 |
26520590.sql |
Modify Columns |
Alter table asap.EQUIPMENT_SPEC Modify VENDOR_MODEL_NUMBER VARCHAR2(35) |
|
6.3.0.904 |
29472095.sql |
New Synonym |
CREATE OR REPLACE PUBLIC SYNONYM SQ_EVC_OAM_DETAIL FOR ASAP.SQ_EVC_OAM_DETAIL |
|
6.3.0.904 |
29472095.sql |
New Synonym |
CREATE OR REPLACE PUBLIC SYNONYM SQ_CR_ADDRESS_MODIFICATION FOR ASAP.SQ_CR_ADDRESS_MODIFICATION |
|
6.3.0.904 |
29472095.sql |
New Synonym |
CREATE OR REPLACE PUBLIC SYNONYM SQ_FOC_EVC_OAM FOR ASAP.SQ_FOC_EVC_OAM |
|
6.3.0.904 |
24843698.sql |
New Columns |
alter table ASAP.DRAWING_OBJECT add DESCRIPTION Varchar2(150) null |
|
6.3.0.904 |
29718584.sql |
New Columns |
Alter table asap.EQUIPMENT_SPEC ADD SLOTS_FIRST CHAR(1) DEFAULT 'N' |
|
6.3.0.982 |
29718566.sql |
New Columns |
Alter Table ASAP.EQUIPMENT_SPEC_PORT_ADDRESS ADD PORTADDR_SEQ_EXT NUMBER(9,0) null |
|
6.3.0.1003 |
30423535.sql |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add GOVERNMENT Char(1) Null |
|
6.3.0.1003 |
30423535.sql |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add TERM_LIABILITY_REVIEW Char(1) Null |
|
6.3.0.1003 |
30423535.sql |
New Columns |
alter table ASAP.FIRM_ORDER_CONFIRMATION add PROMOTION_NBR Varchar2(20) Null |
|
6.3.0.1003 |
30469724.sql |
Modify Columns |
Alter table asap.EMPLOYEE MODIFY system_userid VARCHAR2(50) |