Cleanup Unnecessary Tables from DB scrips

[omindu]

Is your suggestion related to an experience ? Please describe.

There can be tables in our DB scripts coming from removed features, features that were moved out as a connector. Need to cleanup these from the scripts.

Before removing these features are actually removed from the product, or the connector documentation has proper instructions to create tables

Few possible tables:

IDN_REMOTE_FETCH_CONFIG
IDN_OPENID_ASSOCIATIONS
IDN_OPENID_USER_RPS
IDN_OPENID_REMEMBER_ME
IDN_THRIFT_SESSION

Describe the improvement

Additional context

[AnuradhaSK]

Tables related to legacy B2B connector which are not in use after IS-7.0.0 OOTB B2B Solution.

• UM_ORG_PERMISSION
• UM_ORG_ROLE
• UM_ORG_ROLE_GROUP
• UM_ORG_ROLE_PERMISSION
• UM_ORG_ROLE_USER

[sadilchamishka]

The customers who onboarded directly to IS 7.0 will have those mentioned tables, and we can update the schemas[1] to delete these tables.

[1] - https://github.com/wso2-enterprise/identity-migration-resources/blob/master/components/org.wso2.is.migration/migration-resources/7.1.0/dbscripts/step1/identity/mysql.sql

[inthirakumaaran]

For tracking purposes creating separate issues for each sub-team

1. [Authentication & registration] Cleanup Unnecessary Tables from DB scripts #22254
2. [API AccessMgt & Authorization] Cleanup Unnecessary Tables from DB scripts #22253
3. [Identity Server Core] Cleanup Unnecessary Tables from DB scripts #22256
4. [User & identity adminstration] Cleanup Unnecessary Tables from DB scripts #22257
5. [B2B] Cleanup Unnecessary Tables from DB scripts #22258