Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -red8ffee68dc14ae6edd9454b98c575d84b495993 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision ed8ffee68dc14ae6edd9454b98c575d84b495993) @@ -24,6 +24,7 @@ REFERENCES `tl_laqa11_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; +ALTER TABLE tl_laqa11_usr_resp MODIFY COLUMN qa_que_content_id BIGINT(20) DEFAULT NULL; ALTER TABLE tl_laqa11_usr_resp DROP FOREIGN KEY FK_tl_laqa11_usr_resp_2; ALTER TABLE tl_laqa11_usr_resp ADD CONSTRAINT FK_tl_laqa11_usr_resp_2 FOREIGN KEY (`qa_que_content_id`) REFERENCES `tl_laqa11_que_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE;