Page created: 16 Jul 2021
|
Page updated: 19 Jan 2022
Since PingFederate7.1 R3, two indexes have been added to the pingfederate_access_grant table.
| PingFederate version | Column | Index |
|---|---|---|
|
7.3 |
|
|
|
7.1 R3 |
|
|
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.
Although 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.