search

wso2 / product-is

Welcome to the WSO2 Identity Server source code! For info on working with the WSO2 Identity Server repository and contributing code, click the link below.
http://wso2.github.io/
Apache License 2.0
742 stars 720 forks source link

Add PK or Unique Indexes for each tables #4215

Open harsha1979 opened 5 years ago

harsha1979 commented 5 years ago

Since we need to support multi-region deployment in database level, we have to have this in order to avoid the slowness when the replication happens.

Here are the tables that we found without having any keys.

IDN_OAUTH2_ACCESS_TOKEN_AUDIT IDN_OAUTH2_SCOPE_BINDING REG_RESOURCE_COMMENT REG_RESOURCE_PROPERTY REG_RESOURCE_RATING REG_RESOURCE_TAG ODE_SCHEMA_VERSION STORE_PROC_TO_PROP HT_HUMANROLE_ORGENTITY

swgkg commented 5 years ago

Since we need to support multi-region deployment in database level, we have to have this in order to avoid the slowness when the replication happens.

Here are the tables that we found without having any keys.

IDN_OAUTH2_ACCESS_TOKEN_AUDIT IDN_OAUTH2_SCOPE_BINDING REG_RESOURCE_COMMENT REG_RESOURCE_PROPERTY REG_RESOURCE_RATING REG_RESOURCE_TAG ODE_SCHEMA_VERSION STORE_PROC_TO_PROP HT_HUMANROLE_ORGENTITY UM_SHARED_USER_ROLE