Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20131212.sql
===================================================================
diff -u -r9908e067a5350bea350dea231dbe734558e67be8 -r5f17c3cb67da973c8210adb711298bd363d4ceed
--- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20131212.sql	(.../patch20131212.sql)	(revision 9908e067a5350bea350dea231dbe734558e67be8)
+++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20131212.sql	(.../patch20131212.sql)	(revision 5f17c3cb67da973c8210adb711298bd363d4ceed)
@@ -15,7 +15,6 @@
 ALTER TABLE tl_lascrt11_answer_log DROP FOREIGN KEY FK_NEW_610529188_693580A441F9365D;
 ALTER TABLE tl_lascrt11_answer_log DROP INDEX  FK_NEW_610529188_693580A441F9365D;
 ALTER TABLE tl_lascrt11_answer_log DROP COLUMN user_uid;
-ALTER TABLE tl_lascrt11_answer_log ADD INDEX sessionIdIndex (session_id);
 
 -- Make mark belong to session and not user, thus being shared by all users
 ALTER TABLE tl_lascrt11_session ADD COLUMN mark INTEGER DEFAULT 0;
@@ -31,6 +30,10 @@
 		WHERE tl_lascrt11_user.uid = tl_lascrt11_session.group_leader_uid;
 ALTER TABLE tl_lascrt11_user DROP COLUMN scratching_finished;
 
+ALTER TABLE tl_lascrt11_session ADD UNIQUE INDEX session_id_UNIQUE (session_id ASC);
+ALTER TABLE tl_lascrt11_answer_log ADD INDEX sessionIdIndex (session_id), ADD CONSTRAINT sessionIdIndex FOREIGN KEY (session_id) REFERENCES tl_lascrt11_session (session_id);
+ALTER TABLE tl_lascrt11_scratchie_answer ADD INDEX FK_scratchie_answer_1 (scratchie_item_uid), ADD CONSTRAINT FK_scratchie_answer_1 FOREIGN KEY (scratchie_item_uid) REFERENCES tl_lascrt11_scratchie_item (uid);
+
 ----------------------Put all sql statements above here-------------------------
 
 -- If there were no errors, commit and restore autocommit to on