| Index: trunk/extensions/EducationProgram/sql/EducationProgram.sql |
| — | — | @@ -62,7 +62,7 @@ |
| 63 | 63 | CREATE INDEX /*i*/ep_term_year ON /*_*/ep_terms (term_year); |
| 64 | 64 | CREATE INDEX /*i*/ep_term_start ON /*_*/ep_terms (term_start); |
| 65 | 65 | CREATE INDEX /*i*/ep_term_end ON /*_*/ep_terms (term_end); |
| 66 | | -CREATE UNIQUE INDEX /*i*/ep_trem_period ON /*_*/ep_terms (term_org_id, term_start, term_start); |
| | 66 | +CREATE UNIQUE INDEX /*i*/ep_trem_period ON /*_*/ep_terms (term_org_id, term_start, term_end); |
| 67 | 67 | CREATE INDEX /*i*/ep_term_students ON /*_*/ep_terms (term_students); |
| 68 | 68 | |
| 69 | 69 | -- Students. In essence this is an extension to the user table. |