Page MenuHomePhabricator

Confusing/out of date comment in ep_users_per_course table SQL
Closed, ResolvedPublic

Description

  • Links the students with their courses.

CREATE TABLE IF NOT EXISTS /*_*/ep_users_per_course (

upc_user_id                INT unsigned        NOT NULL, -- Foreign key on ep_user.user_id
upc_course_id              INT unsigned        NOT NULL, -- Foreign key on ep_courses.course_id
upc_role                   TINYINT unsigned    NOT NULL, -- The role the user has for the course
upc_time                   varbinary(14)       NOT NULL -- Time at which the link was made

) /*$wgDBTableOptions*/;

ep_user.user_id doesn't exist. Is this actually the core user table user_id column?


Version: unspecified
Severity: minor

Details

Reference
bz70938

Event Timeline

bzimport raised the priority of this task from to High.
bzimport set Reference to bz70938.
bzimport added a subscriber: Unknown Object (MLST).
Reedy created this task.Sep 17 2014, 12:19 PM

gerritadmin wrote:

Change 160955 had a related patch set uploaded by Reedy:
ep_user -> user

https://gerrit.wikimedia.org/r/160955

gerritadmin wrote:

Change 160955 merged by jenkins-bot:
ep_user -> user

https://gerrit.wikimedia.org/r/160955

andrew.green.df wrote:

Yes, that's it.