Database Schema Changes

rest_qos_session_data Changes

Table 2-1 lists the changes to the rest_qos_session_data table.

Table 2-1 rest_qos_session_data Table Changes

New Column Name	Data Type
SESSIONID	VARCHAR2(255)
APPINSTGRPID	VARCHAR2(255)
ENDUSERID	VARCHAR2(255)
PLUGINID	VARCHAR2(255)
REQUESTID	VARCHAR2(255)
NODEID	NUMBER(38)
DURATION	NUMBER(38)
FEATURENAME	VARCHAR2(255)
SESSIONDATA	BLOB
STORED_TS	NUMBER(38)

rest_qos_template Changes

Table 2-2 lists the changes to the rest_qos_template table.

Table 2-2 rest_qos_template Table Changes

New Column Name	Data Type
NAME	VARCHAR2(255)
PLUGININSTANCEID	VARCHAR2(255)
MATCHRULE	VARCHAR2(255)
CONTENT	BLOB
QOSTEMPLATEDATA	BLOB
STORED_TS	NUMBER(38)

prm2_apis Changes

Table 2-3 lists the changes to the prm2_apis table.

Table 2-3 prm2_apis Table Changes

New Column Name	Data Type
APIID	VARCHAR2(100)
STATUS	NUMBER(38)
APIVERSION	VARCHAR2(50)
CONTRACTNAME	VARCHAR2(100)
ACCESSTYPE	NUMBER(38)
DESCRIPTION	VARCHAR2(1000)
PROTOCOL	VARCHAR2(200)
PRIVILEGELEVEL	NUMBER(38)
SERVICETYPE	VARCHAR2(100)
LINK	VARCHAR2(1000)
WADLCONTENT	BLOB
CSSERVICETYPE	VARCHAR2(500)
FACADE	VARCHAR2(100)
ICON	VARCHAR2(200)
NETWORKTOKENURI	VARCHAR2(200)
NORTHBOUNDWADLCONTENT	BLOB
CONTRACTVERSION	VARCHAR2(10)
NETWORKCLIENTREDIRECTURI	VARCHAR2(200)
DIRECTION	NUMBER(38)
APINAME	VARCHAR2(100)
AUTHTOKEN	VARCHAR2(100)
CSOPTION	NUMBER(38)
AUTHTYPE	NUMBER(38)
ACCESSURL	VARCHAR2(200)
NETWORKAUTHORIZATIONURI	VARCHAR2(200)
CONTRACTCONTENT	BLOB
NETWORKPROXY	VARCHAR2(200)
STORED_TS	NUMBER(38)

prm2_apiinterfacemethods Changes

Table 2-4 lists the changes to the prm2_apiinterfacemethods table.

Table 2-4 prm2_apiinterfacemethods Table Changes

New Column Name	Data Type
APINAME	VARCHAR2(100)
INTERFACENAME	VARCHAR2(100)
METHODNAME	VARCHAR2(100)
SERVICEPATH	VARCHAR2(200)
DISPLAYNAME	VARCHAR2(100)
EXPOSE	NUMBER(38
PATH	VARCHAR2(200)
CHARGECODE	VARCHAR2(100)
SERVICEHTTPVERB	VARCHAR2(100)
HTTPVERB	VARCHAR2(100)
SETTLECODE	VARCHAR2(100)
STORED_TS	NUMBER(38)

prm2_application Changes

Table 2-5 lists the changes to the prm2_application table.

Table 2-5 prm2_application Table Changes

New Column Name	Data Type
ID	VARCHAR2(128)
STATUS	NUMBER(38)
APPINSTANCE	VARCHAR2(200)
DESCRIPTION	VARCHAR2(500)
ADDITIONALINFO	VARCHAR2(500)
EFFECTFROMDAT	NUMBER(38)
NEEDREAD	NUMBER(38)
ICON	VARCHAR2(200)
QTADAYS	NUMBER(38)
RTTIMEPERIOD	NUMBER(38)
RTREQLIMIT	NUMBER(38)
APPLICATIONNAME	VARCHAR2(100)
LOCKSTATUS	NUMBER(38)
QTALIMITEXCEEDOK	NUMBER(38)
QTALIMIT	NUMBER(38)
PARTNERNAME	VARCHAR2(100)
EFFECTTODATE	NUMBER(38)
SUBMITDATE	NUMBER(38)
STORED_TS	NUMBER(38)

prm2_notification Changes

Table 2-6 lists the changes to the prm2_notification table.

Table 2-6 prm2_notification Table Changes

New Column Name	Data Type
ID	VARCHAR2(64)
STATUS	NUMBER(38)
DATE_TIME	NUMBER(38)
CONTENT	VARCHAR2(255)
COMMENTS	VARCHAR2(2048)
RECEIVER	VARCHAR2(100)
SENDER_COMPANY	VARCHAR2(50)
REDIRECTOBJECT	BLOB
SENDER	VARCHAR2(100
STORED_TS	NUMBER(38)

prm2_partner_profile_data Changes

Table 2-7 lists the changes to the prm2_portal_profile_data table.

Table 2-7 prm2_partner_profile_data Table Changes

New Column Name	Data Type
USERNAME	VARCHAR2(100)
STATE	VARCHAR2(200)
BANKROUTINGNUMBER	VARCHAR2(100)
COMPANYURL	VARCHAR2(300)
SECURITYANSWER	VARCHAR2(200)
PHONENUMBER	VARCHAR2(100)
ZIPCODE	VARCHAR2(100)
EMAIL	VARCHAR2(100)
LASTNAME	VARCHAR2(100)
FINANCIALCITY	VARCHAR2(100)
COMPANY	VARCHAR2(200)
BANKACCOUNTNUMBER	VARCHAR2(200)
COUNTRY	VARCHAR2(100)
FINANCIALZIPCODE	VARCHAR2(200)
CITY	VARCHAR2(100)
STATUS	NUMBER(38)
PASSWORD	VARCHAR2(400)
STREETADDRESS	VARCHAR2(200)
INVOICETO	VARCHAR2(200)
USERTYPE	NUMBER(38)
BANKNAME	VARCHAR2(200)
TAXID	VARCHAR2(100)
BANKADDRESS	VARCHAR2(200)
SECURITYQUESTION	VARCHAR2(200)
FINANCIALSTATE	VARCHAR2(100)
FINANCIALCOUNTRY	VARCHAR2(100)
FIRSTNAME	VARCHAR2(100)
REFERENCEACCOUNT	VARCHAR2(100)
STORED_TS	NUMBER(38)

prm2_app_apis_methods Changes

Table 2-8 lists the changes to the prm2_app_apis_methods table.

Table 2-8 prm2_app_apis_methods Table Changes

New Column Name	Data Type
ID	VARCHAR2(128)
APINAME	VARCHAR2(100
TYPE	NUMBER(38)
RTTIMEPERIOD	NUMBER(38)
RTREQLIMIT	NUMBER(38)
INTERFACENAME	VARCHAR2(100)
METHODNAME	VARCHAR2(100)
QTALIMITEXCEEDOK	NUMBER(38)
QTALIMIT	NUMBER(38)
TIMEPERIODGUARANTEE	NUMBER(38)
REQLIMITGUARANTEE	NUMBER(38)
APPLICATIONID	VARCHAR2(100)
QTADAYS	NUMBER(38)
STORED_TS	NUMBER(38)

wlng_configuration Changes

Table 2-9 lists the changes to the wlng_configuration table.

Table 2-9 wlng_configuration Table Changes

New Column Name	Data Type
PARAMETER_KEY	VARCHAR2(100)
NAME	VARCHAR2(100)
INSTANCE	VARCHAR2(120)
VALUE	VARCHAR2(255)
VALUE_TYPE	NUMBER(38)
STORED_TS	NUMBER(38)

oauth2_resource_owner Changes

Table 2-10 lists the changes to the oauth2_resource_owner table.

Table 2-10 oauth2_resource_owner Table Changes

New Column Name	Data Type
ADDRESS	VARCHAR2(255)
RESOURCE_SCOPE	VARCHAR2(255)
ANONYMOUS_ID	VARCHAR2(64)
STORED_TS	NUMBER(38)
FROMRESOURCERULE	NUMBER(38)

oauth2_client Changes

Table 2-11 lists the changes to the oauth2_client table.

Table 2-11 oauth2_client Table Changes

New Column Name	Data Type
CLIENT_ID	VARCHAR2(32)
CLIENT_SECRET	VARCHAR2(64)
DESCRIPTION	VARCHAR2(255)
NAME	VARCHAR2(64)
APPINSTANCEID	VARCHAR2(32)
ALLOWEDREDIRECTIONURIS	VARCHAR2(2048)
STORED_TS	NUMBER(38)
SUPPORTIMPLICITGRANT	NUMBER(38)

wlng_internal_group_access Changes

Table 2-12 lists the changes to the wlng_internal_group_access table.

Table 2-12 wlng_internal_group_access Table Changes

New Column Name	Data Type
REQUESTER	VARCHAR2(255)
GROUP_ADDRESS	VARCHAR2(255)
STORED_TS	NUMBER(38)
ADMINPERMISSION	NUMBER(38)
ADDPERMISSION	NUMBER(38)
DELETEPERMISSION	NUMBER(38)
QUERYPERMISSION	NUMBER(38)

prm2_partnercontracts Changes

Table 2-13 lists the changes to the prm2_partnercontracts table.

Table 2-13 prm2_partnercontracts Table Changes

New Column Name	Data Type
APINAME	VARCHAR2(100)
PARTNERNAME	VARCHAR2(100)
READSTATUS	NUMBER(38)
STORED_TS	NUMBER(38)
NEEDREAD	NUMBER(38)

2 Database Schema Changes