Page created: 25 Mar 2020
|
Page updated: 15 Jul 2020
Since PingFederate 7.1 R3, two indexes have been added to the pingfederate_access_grant table.
PingFederate version | Column | Index |
---|---|---|
7.3 |
expires
|
EXPIRESIDX
|
7.1 R3 |
client_id
|
CLIENTIDIDX
|
If you are upgrading from PingFederate 6.5 through 7.1.4, you must add both indexes to your existing pingfederate_access_grant table.
If you are upgrading from PingFederate 7.1 R3, 7.2.x, or 7.2 R2, you must add the
EXPIRESIDX
index for the expires
column.
While there is no alter-table script provided, you can derive the setup from the new table-setup scripts,<pf_install>/pingfederate/server/default/conf/access-grant/sql-scripts/access-grant-<databaseServer>.sql.