https://www.mediawiki.org/wiki/Special:Code/MediaWiki/112219
Revision: 112219
Author: jeroendedauw
Date: 2012-02-23 16:54:33 +0000 (Thu, 23 Feb 2012)
Log Message:
-----------
index fix: multiple users can work on the same article for the same course
Modified Paths:
--------------
trunk/extensions/EducationProgram/sql/EducationProgram.sql
Modified: trunk/extensions/EducationProgram/sql/EducationProgram.sql
===================================================================
--- trunk/extensions/EducationProgram/sql/EducationProgram.sql 2012-02-23
16:44:37 UTC (rev 112218)
+++ trunk/extensions/EducationProgram/sql/EducationProgram.sql 2012-02-23
16:54:33 UTC (rev 112219)
@@ -89,7 +89,7 @@
CREATE INDEX /*i*/ep_articles_user_id ON /*_*/ep_articles (article_user_id);
CREATE INDEX /*i*/ep_articles_course_id ON /*_*/ep_articles
(article_course_id);
CREATE INDEX /*i*/ep_articles_page_id ON /*_*/ep_articles (article_page_id);
-CREATE UNIQUE INDEX /*i*/ep_articles_course_page ON /*_*/ep_articles
(article_course_id, article_page_id);
+CREATE UNIQUE INDEX /*i*/ep_articles_course_page ON /*_*/ep_articles
(article_course_id, article_user_id, article_page_id);
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs