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

UP_PERMISSION does not have a primary key #2163

Open
bjagg opened this issue Sep 10, 2020 · 1 comment
Open

UP_PERMISSION does not have a primary key #2163

bjagg opened this issue Sep 10, 2020 · 1 comment
Labels

Comments

@bjagg
Copy link
Member

bjagg commented Sep 10, 2020

Describe the bug
Table does not have a primary key. This is needed for some db features such as replication in SQL Server.

To Reproduce
Steps to reproduce the behavior:

  1. run gradlew dataInit

Expected behavior
Tables should have primary keys

Additional context
Effort likely entails adding an ID column and sequence.

@bjagg bjagg added the bug label Sep 10, 2020
@jgribonvald
Copy link
Contributor

This should not be a compound key ? It would permit to set a unique key based on nearly all keys, and it would avoid problems for large uses !

I suggest this change to avoid database migration problems, and the change would be more easy than adding a primary key (which would need to stop the service export datas before to truncate and recreate the table and import database, unlike a simple one alter table to run)

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

No branches or pull requests

2 participants