search

sakaicontrib / attendance

A simple Sakai tool for tracking attendance that integrates with the Gradebook.
Educational Community License v2.0
12 stars 20 forks source link

Fix #95 by setting a proper unique index and adjusting column lengths… #96

Closed ottenhoff closed 2 years ago

ottenhoff commented 2 years ago

ALTER TABLE ATTENDANCE_RECORD_T MODIFY COLUMN USER_ID varchar(99), MODIFY COLUMN STATUS varchar(20), ADD UNIQUE INDEX user_record(USER_ID, A_EVENT_ID);

davidpbauer commented 2 years ago

LGTM. We've seen this same thing super rarely so I appreciate the fix

ottenhoff commented 2 years ago

Okay fixing PR now .............

davidpbauer commented 2 years ago

Sorry, I completely read over that user_key was added to the wrong place