r112219 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r112218‎ | r112219 | r112220 >
Date:16:54, 23 February 2012
Author:jeroendedauw
Status:deferred
Tags:
Comment:
index fix: multiple users can work on the same article for the same course
Modified paths:
  • /trunk/extensions/EducationProgram/sql/EducationProgram.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/EducationProgram/sql/EducationProgram.sql
@@ -89,7 +89,7 @@
9090 CREATE INDEX /*i*/ep_articles_user_id ON /*_*/ep_articles (article_user_id);
9191 CREATE INDEX /*i*/ep_articles_course_id ON /*_*/ep_articles (article_course_id);
9292 CREATE INDEX /*i*/ep_articles_page_id ON /*_*/ep_articles (article_page_id);
93 -CREATE UNIQUE INDEX /*i*/ep_articles_course_page ON /*_*/ep_articles (article_course_id, article_page_id);
 93+CREATE UNIQUE INDEX /*i*/ep_articles_course_page ON /*_*/ep_articles (article_course_id, article_user_id, article_page_id);
9494
9595
9696

Status & tagging log