Table 1-1 lists the database changes that were included in 6.2.1 patches. The build number where the change was first introduced is referenced.
Table 1-1 Database Changes in 6.2.1 Patches
| Release | Prodfixsql File | Change | SQL |
|---|---|---|---|
|
6.2.1.b240 |
13463161.SQL |
Modify Columns |
alter table ASAP.NETWORK_NODE modify IP_ADDRESS VarChar2(39) |
|
6.2.1.b240 |
13463161.SQL |
New Columns |
alter table ASAP.NI_IP_ADDR add IPV6NETWORK_TYPE Char(1) null |
|
6.2.1.b240 |
13463161.SQL |
New Columns |
alter table ASAP.NI_IP_ADDR add IPV6NODE_1 VarChar2(4) null |
|
6.2.1.b240 |
13463161.SQL |
New Columns |
alter table ASAP.NI_IP_ADDR add IPV6NODE_2 VarChar2(4) null |
|
6.2.1.b240 |
13463161.SQL |
New Columns |
alter table ASAP.NI_IP_ADDR add IPV6NODE_3 VarChar2(4) null |
|
6.2.1.b240 |
13463161.SQL |
New Columns |
alter table ASAP.NI_IP_ADDR add IPV6NODE_4 VarChar2(4) null |
|
6.2.1.b240 |
13463161.SQL |
New Columns |
alter table ASAP.NI_IP_ADDR add IPV6NODE_5 VarChar2(4) null |
|
6.2.1.b240 |
13463161.SQL |
New Columns |
alter table ASAP.NI_IP_ADDR add IPV6NODE_6 VarChar2(4) null |
|
6.2.1.b240 |
13463161.SQL |
New Columns |
alter table ASAP.NI_IP_ADDR add IPV6NODE_7 VarChar2(4) null |
|
6.2.1.b240 |
13463161.SQL |
New Columns |
alter table ASAP.NI_IP_ADDR add IPV6NODE_8 VarChar2(4) null |
|
6.2.1.b240 |
13949971.SQL |
Modify Columns |
alter table ASAP.SPECIAL_ACCESS modify PROFILE_EGRESS VarChar2(30) alter table ASAP.SPECIAL_ACCESS modify PROFILE_INGRESS VarChar2(30) alter table ASAP.ACI_SRSI modify PROFILE_EGRESS VarChar2(30) alter table ASAP.ACI_SRSI modify PROFILE_INGRESS VarChar2(30) |
|
6.2.1.b240 |
13949971.SQL |
New Columns |
alter table ASAP.SPECIAL_ACCESS add BUM_OPTION CHAR(1) null alter table ASAP.SPECIAL_ACCESS add BUNDLING_INDICATOR CHAR(1) null alter table ASAP.ACI_SRSI add BUM_OPTION CHAR(1) null alter table ASAP.ACI_SRSI add BUNDLING_INDICATOR CHAR(1) null alter table ASAP.EVC_UNI_MAP add OEC_TERMINATING VarChar2(4) null alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT CHAR(1) null alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_1 CHAR(1) null alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_2 CHAR(1) null alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_3 CHAR(1) null alter table ASAP.EVC_UNI_MAPadd CUST_EDGE_VACT_4 CHAR(1) null alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_5 CHAR(1) null alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_6 CHAR(1) null alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_7 CHAR(1) null alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_8 CHAR(1) null alter table ASAP.EVC_UNI_MAP add CUST_EDGE_VACT_9 CHAR(1) null |
|
6.2.1.b296 |
14754431.SQL |
Modify Columns |
alter table ASAP.ITEM_SPEC_EQUIP_SPEC_REL Modify PRIORITY_SEQ NUMBER(3) |
|
6.2.1.b296 |
14737246.SQL |
Modify Columns |
alter table ASAP.EVC_UNI_MAP modify STACKED_VLAN VarChar2(9) |
|
6.2.1.b296 |
14737246.SQL |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add NETWORK_ACCESS_GROOM CHAR(1) null alter table ASAP.SPECIAL_ACCESS add LINK_AGGREGATION_GRP_PROTECT VarChar2(2) null alter table ASAP.CLARIFICATION_REQUEST add SUBSEQUENT_DISPATCH_INDICATOR CHAR(1) null alter table ASAP.FIRM_ORDER_CONFIRMATION add LINK_AGGREGATION_GROUP_ID VarChar2(24) null alter table ASAP.EVC_UNI_MAP add S_VACT CHAR(1) null alter table ASAP.EVC_UNI_MAP add S_VACT1 CHAR(1) null alter table ASAP.EVC_UNI_MAP add S_VLAN1 VarChar2(9) null alter table ASAP.EVC_UNI_MAP add S_VACT2 CHAR(1) null alter table ASAP.EVC_UNI_MAP add S_VLAN2 VarChar2(9) null alter table ASAP.EVC_DETAIL add SVLAN_ID_PRESERVATION CHAR(1) null |
|
6.2.1.b337 |
14336877.SQL |
Modify Columns |
Alter Table ASAP.CUST_ACCT Modify (COMPANY_NAME VARCHAR2(125)) |
|
6.2.1.b337 |
14336877.SQL |
Modify Columns |
Alter Table ASAP.CUST_ACCT_ADDR Modify (COMPANY_NAME VARCHAR2(125)) |
|
6.2.1.b348 |
15900554.SQL |
New Index |
create index ASAP.IDX_DCDL__BLOCK_IND on ASAP.DLR_CIRCUIT_DESIGN_LINE (SUBSTR(block_ind,1,2)) tablespace INDEXES |
|
6.2.1.b394 |
16627050.SQL |
Modify Columns |
alter table ASAP.ASR_CONTACT_INFORMATION modify BILLING_PHONE_NMBR VarChar2(17) alter table ASAP.ASR_CONTACT_INFORMATION modify INITIATOR_PHONE_NMBR VarChar2(17) alter table ASAP.ASR_CONTACT_INFORMATION modify DESIGNER_PHONE_NMBR VarChar2(17) alter table ASAP.ACCESS_BILLING_DATA modify CABS_BILL_CONTACT_PHONE VarChar2(17) alter table ASAP.FOC_EVC modify STACKED_VLAN VARCHAR2(9) |
|
6.2.1.b394 |
16627050.SQL |
New Columns |
alter table ASAP.SPECIAL_ACCESS add SUPPLEMENTAL_BANDWIDTH VarChar2(7) null alter table ASAP.SPECIAL_ACCESS add SUPPLEMENTAL_BANDWIDTH_UOM CHAR(1) null alter table ASAP.SPECIAL_ACCESS add INDEPENDENT_CO_LOCATION VarChar2(8) null alter table ASAP.FIRM_ORDER_CONFIRMATION add NETWORK_FAC_REQUIRE_TYPE_1 CHAR(1) null alter table ASAP.FIRM_ORDER_CONFIRMATION add NETWORK_FAC_REQUIRE_TYPE_2 CHAR(1) null alter table ASAP.EVC_UNI_MAP add ENNI_INDICATOR CHAR(1) null alter table ASAP.FOC_EVC add S_VLAN1 VARCHAR2(9) null alter table ASAP.FOC_EVC add S_VLAN2 VARCHAR2(9) null |
|
6.2.1.b498 |
16244675.SQL |
Modify Columns |
alter table ASAP.TASK modify SEQUENCE NUMBER(4) |
|
6.2.1.b498 |
15931168.SQL |
Modify Columns |
alter table ASAP.DLR_NOTES modify DLR_NOTES_SEQUENCE_NBR NUMBER(4) |
|
6.2.1.b528 |
17769155.SQL |
Modify Columns |
alter table ASAP.PARTY_ROLE_ADDRESS modify PARTY_ROLE_ADDR_SEQ NUMBER(9) |
|
6.2.1.b528 |
17769155.SQL |
Modify Columns |
alter table ASAP.NET_LOC_ADDR_PR_ADDR modify PARTY_ROLE_ADDR_SEQ NUMBER(9) |
|
6.2.1.b528 |
17769155.SQL |
Modify Columns |
alter table ASAP.SR_LOC modify PARTY_ROLE_ADDR_SEQ NUMBER(9) |
|
6.2.1.b528 |
17619356.SQL |
New Columns |
alter table ASAP.CLARIFICATION_REQUEST add ESTIMATED_DUE_DATE DATE null |
|
6.2.1.b528 |
17619356.SQL |
New Columns |
alter table ASAP.RING_SRSI add SECLOC_EUNAME VARCHAR(24) null |
|
6.2.1.b589 |
17838220.SQL |
Modify Columns |
alter table ASAP.REMARK modify SEQUENCE_NUMBER NUMBER(9) |
|
6.2.1.b589 |
18058766.SQL |
Modify Columns |
alter table ASAP.SI_LOC modify PARTY_ROLE_ADDR_SEQ NUMBER(9) |
|
6.2.1.b589 |
18058766.SQL |
Modify Columns |
alter table ASAP.SR_PARTY_ROLE_ADDRESS modify PARTY_ROLE_ADDR_SEQ NUMBER(9) |
|
6.2.1.b654 |
16535471.SQL |
New Table |
Create table ASAP.ACU_LOG ( ACU_LOG_ID NUMBER(9) not null, SEQ_NO NUMBER(9) not null, LOG_DETAIL VARCHAR2(4000) null, STATUS CHAR(1) null, START_DATE DATE null, END_DATE DATE null, USERID VARCHAR2(8) not null ) Tablespace Data |
|
6.2.1.b654 |
16535471.SQL |
New Synonym |
CREATE PUBLIC SYNONYM ACU_LOG FOR ASAP.ACU_LOG |
|
6.2.1.b654 |
16535471.SQL |
New Index |
create unique index PFXPK_ACU_LOG on ACU_LOG (ACU_LOG_ID asc, SEQ_NO asc) Tablespace INDEXES |
|
6.2.1.b654 |
16535471.SQL |
New Constraint |
alter table ACU_LOG add constraint PFXPK_ACU_LOG primary key (ACU_LOG_ID,SEQ_NO) |
|
6.2.1.b654 |
16535471.SQL |
New Sequence |
create sequence ASAP.SQ_ACU_LOG INCREMENT BY 1 START WITH 1000 MINVALUE 1000 MAXVALUE 999999999999999999999999999 NOCYCLE NOORDER CACHE 20 |
|
6.2.1.b654 |
16535471.SQL |
New Synonym |
CREATE PUBLIC SYNONYM SQ_ACU_LOG FOR ASAP.SQ_ACU_LOG |
|
6.2.1.b654 |
16535471.SQL |
New Index |
CREATE INDEX PFXPK_ACT_END_USER_LOC ON DLR_CIRCUIT_DESIGN_LINE (END_USER_LOCATION_ID asc, LOCATION_ID asc) Tablespace INDEXES nologging |
|
6.2.1.b696 |
18542980.SQL |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add Switched_Ethernet_Indicator Char(1) null |
|
6.2.1.b696 |
18542980.SQL |
New Columns |
alter table ASAP.FIRM_ORDER_CONFIRMATION add Ethernet_Service_Point NUMBER(9) null |
|
6.2.1.b696 |
18542980.SQL |
New Columns |
alter table ASAP.EVC_UNI_MAP add Autonomous_System_Number VarChar2(5) null |
|
6.2.1.b696 |
18542980.SQL |
New Columns |
alter table ASAP.EVC_UNI_MAP add VPN_Identifier_Activity Char(1) null |
|
6.2.1.b696 |
18542980.SQL |
New Columns |
alter table ASAP.EVC_UNI_MAP add VPN_Identifier VarChar2(10) null |
|
6.2.1.b696 |
18542980.SQL |
New Table |
CREATE TABLE ASAP.Switched_Ethernet_Service ( DOCUMENT_NUMBER NUMBER(9) not null, SEC_NETWORK_CHANNEL_INTERFACE VarChar2(12) null, Special_Routing_Code_PriLoc Char(1) null, Special_Routing_Code_Io_Fac Char(1) null, Special_Routing_Code_Secloc Char(1) null, Supplemental_Bandwidth VarChar2(7) null, Supplemental_Bandwidth_Uom Char(1) null, BUM_option Char(1) null, Bundling_Indicator Char(1) null, Egress_Scheduler Char(1) null, Profile_Egress VarChar2(30) null, Profile_Ingress VarChar2(30) null, Link_Aggregation_Group_ID VarChar2(24) null, Link_Aggregation_Grp_Protect VarChar2(2) null, Diverse_Circuit_ID VarChar2(36) null, Diverse_PON VarChar2(16) null, Cross_Connect_Eq_Assign VarChar2(60) null, Gen_Exch_Tariff_Opt_ses Char(1) null, Gen_Exch_Tar_Opt_Bill_Tel_Nmbr VarChar2(10) null, GEN_EXCH_TARIFF_OPT_CONTACT_NM VarChar2(25) null, GEN_EXCHG_TARIFF_OPT_TEL_NBR VarChar2(14) null, IP_Address VarChar2(39) null, INT_PROTOCOL_ADDRESS_IDENT Char(1) null, Subnet_Mask VarChar2(15) null, Ethernet_Service_Point Number(9) null, Other_Exchange_Company VarChar2(4) null, LAST_MODIFIED_USERID VarChar2(20) not null, LAST_MODIFIED_DATE DATE not null ) tablespace DATA |
|
6.2.1.b696 |
18542980.SQL |
New Index |
create unique index ASAP.PFXPK_SES on Switched_Ethernet_Service (DOCUMENT_NUMBER asc) tablespace INDEXES |
|
6.2.1.b696 |
18542980.SQL |
New Constraint |
alter table ASAP.Switched_Ethernet_Service add constraint PFXPK_SES primary key (DOCUMENT_NUMBER) |
|
6.2.1.b696 |
18542980.SQL |
New Constraint |
alter table ASAP.Switched_Ethernet_Service add constraint PFXFK_SES_ACC_SERV_REQ foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER) |
|
6.2.1.b696 |
18542980.SQL |
New Synonym |
create public synonym Switched_Ethernet_Service for ASAP.Switched_Ethernet_Service |
|
6.2.1.b738 |
19168504.SQL |
Modify Columns |
ALTER table ASAP.SERV_ITEM Modify TRUNK_SEG Varchar2(5) |
|
6.2.1.b738 |
19168504.SQL |
Modify Columns |
ALTER table ASAP.SERV_REQ_SI Modify TRUNK_SEG Varchar2(5) |
|
6.2.1.b751 |
13341865.SQL |
New Table |
CREATE GLOBAL TEMPORARY TABLE map_circuit_pos_processed (circuit_id NUMBER(9,0), equipment_id NUMBER(9,0), port_address_seq NUMBER(9,0) ) ON COMMIT DELETE ROWS |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.SPECIAL_ACCESS add LAYER2_CTRL_PROTOCOL_PEERING VarChar2(25) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.SPECIAL_ACCESS add LAYER2_CTRL_PROTOCOL_ADDRESS VarChar2(5) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.SPECIAL_ACCESS add UNI_MAX_SERVICE_FRAME_SIZE VarChar2(5) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.ACI_SRSI add SYNCHRONOUS_MODE Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.ACI_SRSI add UNI_MAX_SERVICE_FRAME_SIZE VarChar2(5) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add HIGH_VOLTAGE_PROTECTION Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add LAYER2_CTRL_PROTOCOL_PEERING VarChar2(25) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add LAYER2_CTRL_PROTOCOL_ADDRESS VarChar2(5) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add SYNCHRONOUS_MODE Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add UNI_MAX_SERVICE_FRAME_SIZE VarChar2(5) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_UNI_MAP add BROADCAST_FRAME_DELIVERY Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_UNI_MAP add UNICAST_FRAME_DELIVERY Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_UNI_MAP add MULTICAST_FRAME_DELIVERY Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_DETAIL add CEVLAN_ID_PRESERVATION Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_DETAIL add CEVLAN_COS_PRESERVATION Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_DETAIL add MAX_SERVICE_FRAME_SIZE VarChar2(5) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_LVL_SERV add COMMITTED_INFO_RATE_INGRESS VarChar2(6) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_LVL_SERV add COMMITTED_INFO_RATE_INGR_UOM Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_LVL_SERV add COMMITTED_BURST_SIZE_INGRESS VarChar2(7) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_LVL_SERV add EXCESS_INFO_RATE_INGRESS VarChar2(6) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_LVL_SERV add EXCESS_INFO_RATE_INGRESS_UOM Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_LVL_SERV add EXCESS_BURST_SIZE_INGRESS VarChar2(7) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_LVL_SERV add COLOR_MODE_IDENTIFIER_INGRESS Char(1) null |
|
6.2.1.b804 |
19856022.SQL |
New Columns |
alter table ASAP.EVC_LVL_SERV add BDW_COUPLING_FLAG_INGRESS Char(1) null |
|
6.2.1.b849 |
20342947.SQL |
New Columns |
ALTER TABLE ASAP.EVENT ADD CUST_SQL_IND CHAR(1) DEFAULT ''N'' |
|
6.2.1.b849 |
20342947.SQL |
New Columns |
ALTER TABLE ASAP.EVENT ADD CUST_SQL_EXPRESSION_VALUE VARCHAR2(4000) |
|
6.2.1.b849 |
20342947.SQL |
Modify Columns |
ALTER TABLE ASAP.EVENT MODIFY CUST_SQL_IND CHAR(1) NOT NULL |
|
6.2.1.870 |
18191708.SQL |
New Columns |
Alter Table ASAP.NST_CONFIGURATION_TYPE ADD DISABLE_DELETE_GRAPHICS Char(1) null |
|
6.2.1.b914 |
20954197.SQL |
Modify Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST modify CASE_NUMBER Varchar2(16) |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add END_USER_INDICATOR Char(1) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add PVC_IND Char(1) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add NBR_OF_PERM_VIRTUAL_CONN Varchar2(2) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACI_SRSI add OPTICAL_FIBER_CONN_PRILOC VarChar2(15) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACI_SRSI add OPTICAL_FIBER_CONN_SECLOC VarChar2(15) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACI_SRSI add IP_ADDRESS2 VarChar2(39) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACI_SRSI add INT_PROTOCOL_ADDRESS_IDENT2 Char(1) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACI_SRSI add SUBNET_MASK2 VarChar2(15) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACI_SRSI add ACCESS_CIRCUIT_ID VarChar2(42) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACI_SRSI add ETH_ACCESS_SUPPL_BANDWIDTH VarChar2(7) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.ACI_SRSI add ETH_ACCESS_SUPPL_BANDWIDTH_UOM Char(1) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add WORK_AUTH_CKT_DETAIL_LINK_1 VarChar2(36) null |
|
6.2.1.b914 |
20954197.SQL |
Modify Columns |
alter table ASAP.RCONF_ECHO modify CASE_NUMBER VarChar2(16) |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table EBOND.FOC_PROVIDER_CIRCUIT add ACCESS_CIRCUIT_ORDER_NUMBER VarChar2(17) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table EBOND.FOC_PROVIDER_CIRCUIT add ACCESS_CIRCUIT_ID VarChar2(42) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.END_USER_LOCATION_USAGE add OPTICAL_FIBER_CONN VarChar2(15) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.EVC_DETAIL add EGRESS_PROFILE_SELECTION VarChar2(30) null |
|
6.2.1.b914 |
20954197.SQL |
New Columns |
alter table ASAP.EVC_UNI_MAP add VPN_NAME VarChar2(30) null |
|
6.2.1.b914 |
20954197.SQL |
Drop Constraint |
alter table ASAP.FOC_EVC_DETAIL drop constraint PFXFK_EVC_DETAIL__FOC_EVC_DET |
|
6.2.1.b914 |
20954197.SQL |
Modify Columns |
alter table ASAP.SERV_REQ modify CASE_NUMBER Varchar2(16) |
|
6.2.1.b914 |
20954197.SQL |
New Table |
CREATE TABLE ASAP.DEDICATED_INTERNET_SERVICE ( DOCUMENT_NUMBER NUMBER(9,0) not null, SEC_NETWORK_CHANNEL_INTERFACE VarChar2(12) null, SPECIAL_ROUTING_CODE_PRILOC Char(1) null, SPECIAL_ROUTING_CODE_IO_FAC Char(1) null, SPECIAL_ROUTING_CODE_SECLOC Char(1) null, SUPPLEMENTAL_BANDWIDTH VarChar2(7) null, SUPPLEMENTAL_BANDWIDTH_UOM Char(1) null, ETH_ACCESS_SUPPL_BANDWIDTH VarChar2(7) null, ETH_ACCESS_SUPPL_BANDWIDTH_UOM Char(1) null, ACCESS_TYPE VARCHAR2(12) null, LINK_AGGREGATION_GROUP_ID VarChar2(24) null, LINK_AGGREGATION_GRP_PROTECT VarChar2(2) null, ROUTER Number(9,0) null, PROFILE_EGRESS VarChar2(30) null, AUTONOMOUS_SYSTEM_NUMBER Varchar2(10) null, INT_PROTOCOL_ADDRESS_IDENT Char(1) null, IP_ADDRESS VarChar2(39) null, SUBNET_MASK VarChar2(15) null, INT_PROTOCOL_ADDRESS_IDENT_2 Char(1) null, IP_ADDRESS_2 VarChar2(39) null, SUBNET_MASK_2 VarChar2(15) null, CROSS_CONNECT_EQ_ASSIGN VarChar2(60) null, GEN_EXCH_TARIFF_OPT_DIS Char(1) null, GEN_EXCH_TAR_OPT_BILL_TEL_NMBR VarChar2(10) null, GEN_EXCH_TARIFF_OPT_CONTACT_NM VarChar2(25) null, GEN_EXCHG_TARIFF_OPT_TEL_NBR VarChar2(14) null, DIVERSE_CIRCUIT_ID VarChar2(36) null, DIVERSE_PON VarChar2(16) null, SECLOC Number(9,0) null, OTHER_EXCHANGE_COMPANY VarChar2(4) null, LAST_MODIFIED_USERID VarChar2(8) not null, LAST_MODIFIED_DATE DATE not null ) tablespace DATA |
|
6.2.1.b914 |
20954197.SQL |
New Index |
create unique index ASAP.PFXPK_DIS on DEDICATED_INTERNET_SERVICE (DOCUMENT_NUMBER asc) tablespace INDEXES |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXPK_DIS primary key (DOCUMENT_NUMBER) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXFK_DIS__ACC_SERV_REQ foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXFK_DIS__NET_LOC_ROUTER foreign key (ROUTER) references NETWORK_LOCATION (LOCATION_ID) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXFK_DIS__NET_LOC_SECLOC foreign key (SECLOC) references NETWORK_LOCATION (LOCATION_ID) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.DEDICATED_INTERNET_SERVICE add constraint PFXFK_DIS__NCI_SECNCI foreign key (SEC_NETWORK_CHANNEL_INTERFACE) references NETWORK_CHANNEL_INTERFACE (NETWORK_CHANNEL_INTERFACE_CODE) |
|
6.2.1.b914 |
20954197.SQL |
New Synonym |
create public synonym DEDICATED_INTERNET_SERVICE for ASAP.DEDICATED_INTERNET_SERVICE |
|
6.2.1.b914 |
20954197.SQL |
New Table |
CREATE TABLE ASAP.PRIVATE_INTERNET_PROTOCOL ( DOCUMENT_NUMBER NUMBER(9,0) not null, SEC_NETWORK_CHANNEL_INTERFACE VarChar2(12) null, SPECIAL_ROUTING_CODE_PRILOC Char(1) null, SPECIAL_ROUTING_CODE_IO_FAC Char(1) null, SPECIAL_ROUTING_CODE_SECLOC Char(1) null, ACCESS_TYPE VARCHAR2(12) null, INT_PROTOCOL_ADDRESS_IDENT Char(1) null, INT_PROTOCOL_ADDRESS_IDENT_2 Char(1) null, ETH_ACCESS_SUPPL_BANDWIDTH VarChar2(7) null, ETH_ACCESS_SUPPL_BANDWIDTH_UOM Char(1) null, LINK_MGMT_PROTOCOL Char(1) null, ROUTER Number(9,0) null, EGRESS_SCHEDULER Char(1) null, PROFILE_EGRESS VarChar2(30) null, ACCESS_CIRCUIT_ID VarChar2(42) null, CROSS_CONNECT_EQ_ASSIGN VarChar2(60) null, GEN_EXCH_TARIFF_OPT_PIP Char(1) null, GEN_EXCH_TAR_OPT_BILL_TEL_NMBR VarChar2(10) null, GEN_EXCH_TARIFF_OPT_CONTACT_NM VarChar2(25) null,GEN_EXCHG_TARIFF_OPT_TEL_NBR VarChar2(14) null, DIVERSE_CIRCUIT_ID VarChar2(36) null, DIVERSE_PON VarChar2(16) null,SECLOC Number(9,0) null, OTHER_EXCHANGE_COMPANY VarChar2(4) null, LAST_MODIFIED_USERID VarChar2(8) not null, LAST_MODIFIED_DATE DATE not null) tablespace DATA |
|
6.2.1.b914 |
20954197.SQL |
New Index |
create unique index ASAP.PFXPK_PIP on PRIVATE_INTERNET_PROTOCOL (DOCUMENT_NUMBER asc) tablespace INDEXES |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXPK_PIP primary key (DOCUMENT_NUMBER) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXFK_PIP__ACC_SERV_REQ foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXFK_PIP__NET_LOC_ROUTER foreign key (ROUTER) references NETWORK_LOCATION (LOCATION_ID) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXFK_PIP__NET_LOC_SECLOC foreign key (SECLOC) references NETWORK_LOCATION (LOCATION_ID) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PRIVATE_INTERNET_PROTOCOL add constraint PFXFK_PIP__NCI_SECNCI foreign key (SEC_NETWORK_CHANNEL_INTERFACE) references NETWORK_CHANNEL_INTERFACE (NETWORK_CHANNEL_INTERFACE_CODE) |
|
6.2.1.b914 |
20954197.SQL |
New Synonym |
create public synonym PRIVATE_INTERNET_PROTOCOL for ASAP.PRIVATE_INTERNET_PROTOCOL', 40, 'CREATE TABLE ASAP.PVC_COMMON ( DOCUMENT_NUMBER NUMBER(9,0) not null, PVC_COMMON_ID NUMBER(9,0) not null, NETWORK_CHANNEL_SERVICE_CODE VarChar2(2) null, NETWORK_CHANNEL_OPTION_CODE VarChar2(2) null, NETWORK_CHANNEL_INTERFACE_CODE VarChar2(12) null, RELATED_PORT_IDENTIFIER VarChar2(28) null, LAST_MODIFIED_USERID VarChar2(8) not null, LAST_MODIFIED_DATE DATE not null) tablespace DATA |
|
6.2.1.b914 |
20954197.SQL |
New Index |
create unique index ASAP.PFXPK_PVC_COMMON on PVC_COMMON (DOCUMENT_NUMBER asc, PVC_COMMON_ID asc) tablespace INDEXES |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PVC_COMMON add constraint PFXPK_PVC_COMMON primary key (DOCUMENT_NUMBER, PVC_COMMON_ID) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PVC_COMMON add constraint PFXFK_PVC_COM__ACC_SERV_REQ foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PVC_COMMON add constraint PFXFK_PVC_COM__NE_CH_OP foreign key (NETWORK_CHANNEL_SERVICE_CODE,NETWORK_CHANNEL_OPTION_CODE) references NETWORK_CHANNEL_OPTION (NETWORK_CHANNEL_SERVICE_CODE,NETWORK_CHANNEL_OPTION_CODE) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PVC_COMMON add constraint PFXFK_PVC_COM__NCI foreign key (NETWORK_CHANNEL_INTERFACE_CODE) references NETWORK_CHANNEL_INTERFACE (NETWORK_CHANNEL_INTERFACE_CODE) |
|
6.2.1.b914 |
20954197.SQL |
New Sequence |
CREATE SEQUENCE ASAP.SQ_PVC_COMMON MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE |
|
6.2.1.b914 |
20954197.SQL |
New Synonym |
CREATE PUBLIC SYNONYM SQ_PVC_COMMON FOR ASAP.SQ_PVC_COMMON |
|
6.2.1.b914 |
20954197.SQL |
New Synonym |
create public synonym PVC_COMMON for ASAP.PVC_COMMON |
|
6.2.1.b914 |
20954197.SQL |
New Table |
CREATE TABLE ASAP.PVC_CIRCUIT_DETAIL ( PVC_CIRCUIT_DETAIL_ID NUMBER(9,0) not null, DOCUMENT_NUMBER NUMBER(9,0) not null, PVC_COMMON_ID NUMBER(9,0) not null, PVC_NBR VarChar2(4) not null, PVC_ACTIVITY Char(1) null, PVC_ID VarChar2(28) null, VPN_NAME VarChar2(30) null, DATA_LINK_CONN_IDENTIFIER Varchar2(4) null, AUTONOMOUS_SYSTEM_NUMBER Varchar2(10) null, PVC_CKR VarChar2(53) null, EGRESS_PROFILE_SECTION VarChar2(30) null, LAST_MODIFIED_USERID VarChar2(8) not null, LAST_MODIFIED_DATE DATE not null) tablespace DATA |
|
6.2.1.b914 |
20954197.SQL |
New Index |
create unique index ASAP.PFXPK_PVC_CKT_DETAIL on PVC_CIRCUIT_DETAIL (PVC_CIRCUIT_DETAIL_ID asc) tablespace INDEXES |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PVC_CIRCUIT_DETAIL add constraint PFXPK_PVC_CKT_DETAIL primary key (PVC_CIRCUIT_DETAIL_ID) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PVC_CIRCUIT_DETAIL add constraint PFXFK_PVC_CKT_DET__ASR foreign key (DOCUMENT_NUMBER) references ACCESS_SERVICE_REQUEST (DOCUMENT_NUMBER) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PVC_CIRCUIT_DETAIL add constraint PFXFK_PVC_CKT_DET__PVC_COM foreign key (DOCUMENT_NUMBER, PVC_COMMON_ID) references PVC_COMMON (DOCUMENT_NUMBER, PVC_COMMON_ID) |
|
6.2.1.b914 |
20954197.SQL |
New Sequence |
CREATE SEQUENCE ASAP.SQ_PVC_CIRCUIT_DETAIL MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE |
|
6.2.1.b914 |
20954197.SQL |
New Synonym |
CREATE PUBLIC SYNONYM SQ_PVC_CIRCUIT_DETAIL FOR ASAP.SQ_PVC_CIRCUIT_DETAIL |
|
6.2.1.b914 |
20954197.SQL |
New Synonym |
create public synonym PVC_CIRCUIT_DETAIL for ASAP.PVC_CIRCUIT_DETAIL |
|
6.2.1.b914 |
20954197.SQL |
New Table |
CREATE TABLE ASAP.PVC_LVL_SERV ( PVC_LVL_SERV_ID NUMBER(9,0) not null, PVC_CIRCUIT_DETAIL_ID NUMBER(9,0) not null, DOCUMENT_NUMBER NUMBER(9,0) not null, LVL_OF_SERV_REF_NBR Char(1) null, LVL_OF_SERV_ACT_CD Char(1) null, LVL_OF_SERV_NM Varchar2(20) null, SERVICE_AND_PRODUCT_ENHANC_COD Varchar2(7) null, BANDWIDTH Varchar2(6) null, BANDWIDTH_UOM Char(1) null, LAST_MODIFIED_USERID VarChar2(8) not null, LAST_MODIFIED_DATE DATE not null) tablespace DATA |
|
6.2.1.b914 |
20954197.SQL |
New Index |
create unique index ASAP.PFXPK_PVC_LVL_SERV on PVC_LVL_SERV (PVC_LVL_SERV_ID asc) tablespace INDEXES |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PVC_LVL_SERV add constraint PFXPK_PVC_LVL_SERV primary key (PVC_LVL_SERV_ID) |
|
6.2.1.b914 |
20954197.SQL |
New Constraint |
alter table ASAP.PVC_LVL_SERV add constraint PFXFK_PVC_LV_SER__PVC_CKT_DET foreign key (PVC_CIRCUIT_DETAIL_ID) references PVC_CIRCUIT_DETAIL (PVC_CIRCUIT_DETAIL_ID) |
|
6.2.1.b914 |
20954197.SQL |
New Sequence |
CREATE SEQUENCE ASAP.SQ_PVC_LVL_SERV MINVALUE 10000 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 15469 CACHE 20 NOORDER NOCYCLE |
|
6.2.1.b914 |
20954197.SQL |
New Synonym |
CREATE PUBLIC SYNONYM SQ_PVC_LVL_SERV FOR ASAP.SQ_PVC_LVL_SERV |
|
6.2.1.b914 |
20954197.SQL |
New Synonym |
create public synonym PVC_LVL_SERV for ASAP.PVC_LVL_SERV |
|
6.2.1.b914 |
20954197.SQL |
Modify Columns |
alter table ASAP.ASR_GUIDELINE_RULE modify RULE Varchar2(1500) |
|
6.2.1.b914 |
20661032.SQL |
New Table |
CREATE TABLE ASAP.ASR_Audit_History ( ASR_Audit_history_Id NUMBER(10,0) not null, DOCUMENT_NUMBER NUMBER(9,0) not null, PON Varchar2(16) Not null, Version Varchar2(2) Not null, Form_name Varchar2(50) Not null, Form_Reference_Number VarChar2(15) null, Field_name Varchar2(50) Not null, Current_Field_Value Varchar2(256) null, Previous_Field_Value Varchar2(256) null, Last_Modified_Date Date Not null, Last_Modified_Userid VarChar2(8) Not null ) tablespace DATA |
|
6.2.1.b914 |
20661032.SQL |
New Synonym |
create public synonym ASR_Audit_History for ASAP.ASR_Audit_History |
|
6.2.1.b914 |
20661032.SQL |
New Index |
CREATE INDEX ASAP.IDX_AUDIT_DOCUMENT_NO ON ASR_AUDIT_HISTORY (DOCUMENT_NUMBER) tablespace INDEXES |
|
6.2.1.b914 |
20661032.SQL |
New Constraint |
alter table ASAP.ASR_Audit_History add constraint PFXPK_audt_hist_id primary key (ASR_Audit_history_Id) |
|
6.2.1.b914 |
20661032.SQL |
New Table |
CREATE TABLE ASAP.ASR_Supplement_History ( ASR_SUPPLEMENT_HISTORY_ID NUMBER(10) not null, DOCUMENT_NUMBER NUMBER(9,0) not null, PON Varchar2(16) Not null, Current_Version Varchar2(2) Not null, Previous_Version Varchar2(2) Not null, SUPP_TYPE char(1) Not null, Form_name Varchar2(50) Not null, Form_Reference_Number VarChar2(15) null, Field_name Varchar2(50) Not null, Current_Field_Value Varchar2(256) null, Previous_Field_Value Varchar2(256) null, Supplemented_Date Date Not null, Supplemented_By VarChar2(8) Not null) tablespace DATA |
|
6.2.1.b914 |
20661032.SQL |
New Synonym |
create public synonym ASR_SUPPLEMENT_HISTORY for ASAP.ASR_SUPPLEMENT_HISTORY |
|
6.2.1.b914 |
20661032.SQL |
New Constraint |
alter table ASAP.ASR_SUPPLEMENT_HISTORY add constraint PFXPK_ASHD_id primary key (ASR_SUPPLEMENT_HISTORY_ID) |
|
6.2.1.b914 |
20661032.SQL |
New Sequence |
create sequence ASAP.SQ_ASR_AUDIT_HISTORY INCREMENT BY 1 START WITH 0 MINVALUE 0 MAXVALUE 999999999999999999999999999 NOCYCLE NOORDER CACHE 20 |
|
6.2.1.b914 |
20661032.SQL |
New Synonym |
CREATE PUBLIC SYNONYM SQ_ASR_AUDIT_HISTORY FOR ASAP.SQ_ASR_AUDIT_HISTORY |
|
6.2.1.b914 |
20661032.SQL |
New Sequence |
create sequence ASAP.SQ_ASR_SUPPLEMENT_HISTORY INCREMENT BY 1 START WITH 0 MINVALUE 0 MAXVALUE 999999999999999999999999999 NOCYCLE NOORDER CACHE 20 |
|
6.2.1.b914 |
20661032.SQL |
New Synonym |
CREATE PUBLIC SYNONYM SQ_ASR_SUPPLEMENT_HISTORY FOR ASAP.SQ_ASR_SUPPLEMENT_HISTORY |
|
6.2.1.b914 |
20661032.SQL |
New Columns |
alter table ASAP.SERV_REQ add SR_AUDIT_IND Char(1) null |
|
6.2.1.1005 |
21958448.sql |
New Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST add WIRELESS_SITE_IND_PRILOC Char(1) null |
|
6.2.1.1005 |
21958448.sql |
Modify Columns |
alter table ASAP.ACCESS_SERVICE_REQUEST modify BILLING_ACCOUNT_NUMBER Varchar2(13) |
|
6.2.1.1005 |
21958448.sql |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add COLOR_IDENTIFIER Varchar2(3) null |
|
6.2.1.1005 |
21958448.sql |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add MULTI_CHAS_LINK_AGGR_GROUP Char(1) null |
|
6.2.1.1005 |
21958448.sql |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add MULTI_CHAS_LINK_AGGR_GROUP_ID VarChar2(24) null |
|
6.2.1.1005 |
21958448.sql |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add MULTI_CHAS_LINK_AGGR_GROUP_P VarChar2(2) null |
|
6.2.1.1005 |
21958448.sql |
Modify Columns |
alter table ASAP.FIRM_ORDER_CONFIRMATION modify BILLING_ACCOUNT_NUMBER Varchar2(13) |
|
6.2.1.1005 |
21958448.sql |
New Columns |
alter table ASAP.FIRM_ORDER_CONFIRMATION add MULTI_CHAS_LINK_AGGR_GROUP_ID VarChar2(24) null |
|
6.2.1.1005 |
21958448.sql |
Modify Columns |
alter table ASAP.END_USER_LOCATION_USAGE modify ALT_ACC_TEL_NBR VarChar2(17) |
|
6.2.1.1005 |
21958448.sql |
Modify Columns |
alter table ASAP.END_USER_LOCATION_USAGE modify ALT_CONTACT_TEL_NBR VarChar2(17) |
|
6.2.1.1005 |
21958448.sql |
Modify Columns |
alter table ASAP.END_USER_LOCATION_USAGE modify ADDL_ALT_CONTACT_TEL_NBR VarChar2(17) |
|
6.2.1.1005 |
21958448.sql |
New Columns |
alter table ASAP.EVC_LVL_SERV add PRIORITY_BIT_COLOR_INGRESS VarChar2(8) null |
|
6.2.1.1005 |
21958448.sql |
New Columns |
alter table ASAP.EVC_LVL_SERV add PRIORITY_BIT_COLOR_EGRESS VarChar2(2) null |
|
6.2.1.1005 |
21958448.sql |
Modify Columns |
alter table ASAP.ACCESS_PROVIDER_ROLE modify BILLING_ACCOUNT_NUMBER VarChar2(13) |
|
6.2.1.1005 |
21958448.sql |
Modify Columns |
alter table ASAP.ACCESS_BILLING_CIRCUIT_DATA modify CABS_BILLING_NUMBER VarChar2(13) |
|
6.2.1.1005 |
21958448.sql |
Modify Columns |
alter table ASAP.ACCESS_BILLING_DATA modify BILLING_ACCOUNT_NUMBER VarChar2(13) |
|
6.2.1.1039 |
22239114.sql |
New Columns |
ALTER TABLE ASAP.TEL_NUM_CATEGORY_TYPE_SUBTYPE ADD ASSIGNABLE_IND CHAR(1) DEFAULT 'Y' |
|
6.2.1.1067 |
23220010.sql |
New Columns |
alter table ASAP.ACI_SRSI add RELATED_CIRCUIT_ID VarChar2(28) null |
|
6.2.1.1067 |
23220010.sql |
New Columns |
alter table ASAP.ACI_SRSI add POWER_TYPE_AND_VOLTAGE |
|
6.2.1.1067 |
23220010.sql |
New Columns |
alter table ASAP.SPECIAL_ACCESS add RELATED_CIRCUIT_ID Varchar2(28) null |
|
6.2.1.1067 |
23220010.sql |
New Columns |
alter table ASAP.SPEC_ACCESS_AND_LINE_DETAIL add RELATED_CIRCUIT_ID Varchar2(28) null |
|
6.2.1.1067 |
23220010.sql |
New Columns |
alter table ASAP.SWITCHED_ETHERNET_SERVICE add POWER_TYPE_AND_VOLTAGE VarChar2(5) null |
|
6.2.1.1135 |
24786270.sql |
New Columns |
alter table ASAP.ASR_CONTACT_INFORMATION add SITE_CONTACT_NAME VarChar2(15) null |
|
6.2.1.1135 |
24786270.sql |
New Columns |
alter table ASAP.ASR_CONTACT_INFORMATION add SITE_PHONE_NMBR Varchar2(17) null |
|
6.2.1.1135 |
24786270.sql |
New Columns |
alter table ASAP.ASR_CONTACT_INFORMATION add SITE_EMAIL_ADDR Varchar2(60) null |
|
6.2.1.1135 |
24921842.sql |
Modify Columns |
ALTER TABLE ASAP.EQUIPMENT MODIFY WORK_ORDER_NUMBER VARCHAR2(17) |
|
6.2.1.1135 |
24756742.sql |
Drop Index |
DROP INDEX ASAP.SYS_C0054464 |
|
6.2.1.1182 |
25509095.sql |
New Columns |
ALTER TABLE ASAP.EQUIPMENT_SPEC ADD EQUIP_SPEC_CREATE_DATE DATE |
|
6.2.1.1182 |
25529139.sql |
Modify Columns |
ALTER TABLE ASAP.CHECKPOINT_RESTART MODIFY (LAST_ROW_SAVED VarChar2(7)) |
|
6.2.1.1182 |
25542417.sql |
New Columns |
ALTER TABLE ASAP.DESIGN ADD ACCESS_CUST_TERMINAL_LOCATION VarChar2(20) null |
|
6.2.1.1182 |
25542417.sql |
New Columns |
ALTER TABLE ASAP.DESIGN ADD ADDITIONAL_POINT_OF_TERMINATIO VarChar2(20) |
|
6.2.1.1182 |
25542417.sql |
New Columns |
ALTER TABLE ASAP.DESIGN ADD NETWORK_CHANNEL_CODE VarChar2(4) |
|
6.2.1.1182 |
25542417.sql |
New Columns |
ALTER TABLE ASAP.DESIGN ADD NETWORK_CHANNEL_OPTION_CODE VarChar2(2) |
|
6.2.1.1182 |
25542417.sql |
New Columns |
ALTER TABLE ASAP.DESIGN ADD NETWORK_CHANNEL_INTERFACE_CODE VarChar2(12) |
|
6.2.1.1182 |
25542417.sql |
New Columns |
ALTER TABLE ASAP.DESIGN ADD SEC_NETWORK_CHANNEL_INTERFACE VarChar2(12) |
|
6.2.1.1182 |
25962277.sql |
Modify Columns |
alter table asap.circuit_position modify (ADDITIONAL_ASSIGNMENT_SEQ_NBR number(3)) |
|
6.2.1.1182 |
25962277.sql |
Modify Columns |
alter table asap.dlr_notes modify (DLR_NOTES_SEQUENCE_NBR number(5)) |