[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.
Generated at Mon Apr 06 09:41:44 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.