boinc/db/bolt_constraints.sql

12 lines
251 B
MySQL
Raw Permalink Normal View History

alter table bolt_course
add unique(name);
alter table bolt_enrollment
add unique(user_id, course_id);
alter table bolt_view
add index bv_cs(course_id, start_time);
alter table bolt_refresh
add unique br_u(user_id, course_id, name);