[CORE-304] Database: Remove primary key & add index to PM_USER_LOGIN Created: 19/Apr/18 Updated: 25/Apr/18 Resolved: 23/Apr/18 |
|
| Status: | Resolved |
| Project: | i2b2 Core Software |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 1.7.10 |
| Type: | Improvement | Priority: | Major |
| Reporter: | Janice Donahoe | Assignee: | Janice Donahoe |
| Resolution: | Done | Votes: | 0 |
| Labels: | database, wikirelease | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Rank: | 0|i003y7: |
| Participant/s: |
| Description |
|
The PM_USER_LOGIN table should not have a primary key. The existing primary key is on the user_id and will be removed. An index will be added to the table. This index will be
PM_USER_LOGIN_IDX ON PM_USER_LOGIN(USER_ID, ENTRY_DATE) |
| Comments |
| Comment by Janice Donahoe [ 19/Apr/18 ] |
| remove PK add index |
| Comment by Janice Donahoe [ 19/Apr/18 ] |
| remove PK add index |
| Comment by Janice Donahoe [ 23/Apr/18 ] |
| Tested and verified this change has been made to both the new install and upgrade scripts for the 1.7.10 release. |