Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Introduce primary keys for all tables in the APIM schema #5026

Open
nuwand opened this issue Feb 2, 2018 · 2 comments
Open

Introduce primary keys for all tables in the APIM schema #5026

nuwand opened this issue Feb 2, 2018 · 2 comments

Comments

@nuwand
Copy link
Contributor

nuwand commented Feb 2, 2018

Some tables in the APIM schema including some IDN_ tables are missing primary keys. This becomes a problem for multi master data replication. Therefore we need to make sure all tables have primary keys in the APIM schema.

@rizmir22
Copy link

rizmir22 commented Feb 2, 2018

Related issue: Primary keys need to be fixed in the registry tables as well.
Public Jira: https://wso2.org/jira/browse/CARBON-16157

@uvindra
Copy link
Contributor

uvindra commented Feb 6, 2018

Even adding a unique constraint to an existing column where suitable would suffice. In that case we dont have to add a new column as a primary key. The requirement is to have a column that is indexed(both primary keys and unique constraints cause indexes to be created)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants