This chapter lists the database schema changes between Services Gatekeeper 6.0 and Services Gatekeeper 6.1.
The following database tables are new in this release. The column names are listed in ascending order.
Table 2-1 lists the columns in the new table, prm2_daf_actionAPIMap, added in this release.
Table 2-2 lists the columns in the new table, endpoint_authentication_config, added in this release.
The following database tables were updated for this release:
The column names are listed in ascending order.
Table 2-3 lists the updated oauth2_access_token table.
Table 2-3 oauth2_access_token Table
New Column Name | Data Type |
---|---|
ACCESS_TOKEN |
VARCHAR2(64) |
APPINSTANCE_ID |
VARCHAR2(100) |
CLIENT_ID |
VARCHAR2(100) |
EXPIRED_TIME |
NUMBER(38) |
INVOKE_COUNT |
NUMBER(38) |
ISSUE_TIME |
NUMBER(38) |
MAC_ALGORITHM |
VARCHAR2(40) |
MAC_KEY |
VARCHAR2(20) |
NONCE_AGE |
NUMBER(38) |
NONCE_RANDOM |
VARCHAR2(128) |
PARAMETER |
VARCHAR2(512) |
RESOURCE_OWNER |
VARCHAR2(128) |
RESOURCE_SCOPE |
VARCHAR2(4000) |
STATE |
VARCHAR2(512) |
STORED_TS |
NUMBER(38) |
TOKEN_TYPE |
VARCHAR2(32) |
Table 2-4 lists the updated oauth2_authorization_code table.
Table 2-4 oauth2_authorization_code Table
New Column Name | Data Type |
---|---|
ACCESS_TOKEN |
VARCHAR2(64) |
CLIENT_ID |
VARCHAR2(100) |
CODE |
VARCHAR2(64) |
EXPIRED_TIME |
NUMBER(38) |
PARAMETER |
VARCHAR2(512) |
REDIRECT_URI |
VARCHAR2(128) |
REFRESH_TOKEN |
VARCHAR2(64) |
RESOURCE_OWNER |
VARCHAR2(128) |
RESOURCE_SCOPE |
VARCHAR2(4000) |
RESPONSE_TYPE |
VARCHAR2(32) |
STATE |
VARCHAR2(32) |
STORED_TS |
NUMBER(38) |
Table 2-5 lists the updated oauth2_client table.
Table 2-6 lists the updated oauth2_refresh_token table.
Table 2-7 lists the updated oauth2_resource_owner table.
Table 2-8 lists the updated pl_payment_reservation_data table.
Table 2-8 pl_payment_reservation_data Table
New Column Name | Data Type |
---|---|
APP_ID |
VARCHAR2(255) |
CURRENCY |
VARCHAR2(3) |
EXPIRATIONTIME |
NUMBER(38) |
OWNER |
VARCHAR2(255) |
REFERENCESEQUENCE |
NUMBER(38) |
REQUESTEDAMOUNT |
VARCHAR2(255) |
REQUESTNUMBER |
NUMBER(38) |
SERVICECONTEXTID |
VARCHAR2(255) |
SESSIONID |
VARCHAR2(255) |
SP_ID |
VARCHAR2(255) |
STORED_TS |
NUMBER(38) |
SUBSCRIPTIONID |
VARCHAR2(255) |
USEDAMOUNT |
VARCHAR2(255) |
Table 2-9 lists the updated pl_payment_volume_reservation table.
Table 2-9 pl_payment_volume_reservation Table
New Column Name | Data Type |
---|---|
APP_ID |
VARCHAR2(255) |
BILLING_TEXT |
VARCHAR2(255) |
ENDUSERID |
VARCHAR2(255) |
EXPIRATIONTIME |
NUMBER(38) |
OWNER |
VARCHAR2(255) |
REFERENCESEQUENCE |
NUMBER(38) |
REQUESTEDVOLUME |
NUMBER(38) |
REQUESTNUMBER |
NUMBER(38) |
SERVICECONTEXTID |
VARCHAR2(255) |
SESSIONID |
VARCHAR2(255) |
SP_ID |
VARCHAR2(255) |
STORED_TS |
NUMBER(38) |
USEDVOLUME |
NUMBER(38) |
Table 2-10 lists the updated prm2_api_actions table.
Table 2-11 lists the updated prm2_app_apis_methods table.
Table 2-11 prm2_app_apis_methods Table
New Column Name | Data Type |
---|---|
APINAME |
VARCHAR2(100 |
APPLICATIONID |
VARCHAR2(100) |
ID |
VARCHAR2(128) |
INTERFACENAME |
VARCHAR2(100) |
METHODNAME |
VARCHAR2(100) |
QTADAYS |
NUMBER(38) |
QTALIMIT |
NUMBER(38) |
QTALIMITEXCEEDOK |
NUMBER(38) |
REQLIMITGUARANTEE |
NUMBER(38) |
RTREQLIMIT |
NUMBER(38) |
RTTIMEPERIOD |
NUMBER(38) |
STORED_TS |
NUMBER(38) |
SUSPENDED |
NUMBER(38) |
TIMEPERIODGUARANTEE |
NUMBER(38) |
TYPE |
NUMBER(38) |
Table 2-12 lists the updated prm2_application table.
Table 2-12 prm2_application Table
New Column Name | Data Type |
---|---|
ADDITIONALINFO |
VARCHAR2(500) |
APPINSTANCE |
VARCHAR2(200) |
APPLICATIONNAME |
VARCHAR2(100) |
CLIENTID |
VARCHAR2(200) |
DESCRIPTION |
VARCHAR2(500) |
EFFECTFROMDATE |
NUMBER(38) |
EFFECTTODATE |
NUMBER(38) |
ICON |
VARCHAR2(200) |
ID |
VARCHAR2(128) |
LOCKSTATUS |
NUMBER(38) |
NEEDREAD |
NUMBER(38) |
PARTNERNAME |
VARCHAR2(100) |
QTADAYS |
NUMBER(38) |
QTALIMIT |
NUMBER(38) |
QTALIMITEXCEEDOK |
NUMBER(38) |
RTREQLIMIT |
NUMBER(38) |
RTTIMEPERIOD |
NUMBER(38) |
STATUS |
NUMBER(38) |
STORED_TS |
NUMBER(38) |
SUBMITDATE |
NUMBER(38) |
Table 2-13 lists the updated prm2_apis table.
New Column Name | Data Type |
---|---|
ACCESSTYPE |
NUMBER(38) |
ACCESSURL |
VARCHAR2(200) |
APIDISPLAYNAME |
VARCHAR2(100) |
APIID |
VARCHAR2(100) |
APINAME |
VARCHAR2(100) |
APIVERSION |
VARCHAR2(50) |
AUTHTOKEN |
VARCHAR2(100) |
AUTHTYPE |
NUMBER(38) |
CONTRACTCONTENT |
BLOB |
CONTRACTNAME |
VARCHAR2(100) |
CONTRACTVERSION |
VARCHAR2(10) |
CSOPTION |
NUMBER(38) |
CSSERVICETYPE |
VARCHAR2(500) |
DESCRIPTION |
VARCHAR2(1000) |
DIRECTION |
NUMBER(38) |
FACADE |
VARCHAR2(100) |
ICON |
VARCHAR2(200) |
LINK |
VARCHAR2(1000) |
NETWORKAUTHORIZATIONURI |
VARCHAR2(200) |
NETWORKCLIENTREDIRECTURI |
VARCHAR2(200) |
NETWORKPROXY |
VARCHAR2(200) |
NETWORKTOKENURI |
VARCHAR2(200) |
NORTHBOUNDWADLCONTENT |
BLOB |
PRIVILEGELEVEL |
NUMBER(38) |
PROTOCOL |
VARCHAR2(200) |
SERVICETYPE |
VARCHAR2(100) |
STATUS |
NUMBER(38) |
STORED_TS |
NUMBER(38) |
WADLCONTENT |
BLOB |
Table 2-14 lists the updated prm2_daf_actions table.
Table 2-15 lists the updated rest_qos_session_data table.
Table 2-15 rest_qos_session_data Table Changes
New Column Name | Data Type |
---|---|
APPINSTGRPID |
VARCHAR2(255) |
DESTINATIONHOST |
VARCHAR2(255) |
DURATION |
NUMBER(38) |
ENDUSERID |
VARCHAR2(255) |
FEATURENAME |
VARCHAR2(255) |
NODEID |
NUMBER(38) |
PLUGINID |
VARCHAR2(255) |
REQUESTID |
VARCHAR2(255) |
SESSIONDATA |
BLOB |
SESSIONID |
VARCHAR2(255) |
STORED_TS |
NUMBER(38) |
Table 2-16 lists the updated south_oauth2_client table.
Table 2-17 lists the updated wlng_internal_subscriber table.