Actions
Task #122
closed
Foreign constraint and index naming conventions in core sql script
Start date:
07/05/2016
Due date:
07/05/2016
% Done:
100%
Estimated time:
4.00 h
Owner:
Description
- Create core sql change script for rename foreign constraint and index by naming conventions: https://github.com/bcvsolutions/CzechIdMng/blob/master/Realization/frontend/CONTRIBUTING.md.
- Create appropriate index for foreign keys.
Related issues
Updated by Radek Tomiška over 7 years ago
- Follows Task #70: Databázové skripty added
Updated by Radek Tomiška over 7 years ago
- Status changed from New to Needs feedback
- Assignee set to Ondřej Kopr
- % Done changed from 0 to 90
I've remaned foreign keys and added indexes to all entities in modules core and acc. I've added indexes to hibernate layer to (generated model is used in integration tests).
Could you make a review and test, please.
Updated by Ondřej Kopr over 7 years ago
- Status changed from Needs feedback to Resolved
- Assignee changed from Ondřej Kopr to Radek Tomiška
- % Done changed from 90 to 100
Feedback:
Found change script: V1_00_013__fk-indexes.sql
Check database state via pgAdmin and keys match with java class annotation. I added prefix _idm to IdmRoleGuarantee.
Result - OK.
Updated by Radek Tomiška over 7 years ago
- Status changed from Resolved to Closed
thx for index rename .)
Actions