| Index: trunk/extensions/EducationProgram/sql/AddExtraFields.sql |
| — | — | @@ -4,12 +4,10 @@ |
| 5 | 5 | -- Author: Jeroen De Dauw < jeroendedauw@gmail.com > |
| 6 | 6 | |
| 7 | 7 | ALTER TABLE /*_*/ep_orgs ADD COLUMN org_courses SMALLINT unsigned NOT NULL; |
| 8 | | -ALTER TABLE /*_*/ep_orgs ADD COLUMN org_mentors SMALLINT unsigned NOT NULL; |
| 9 | 8 | ALTER TABLE /*_*/ep_orgs ADD COLUMN org_terms SMALLINT unsigned NOT NULL; |
| 10 | 9 | ALTER TABLE /*_*/ep_orgs ADD COLUMN org_students INT unsigned NOT NULL; |
| 11 | 10 | |
| 12 | 11 | CREATE INDEX /*i*/ep_org_courses ON /*_*/ep_orgs (org_courses); |
| 13 | | -CREATE INDEX /*i*/ep_org_mentors ON /*_*/ep_orgs (org_mentors); |
| 14 | 12 | CREATE INDEX /*i*/ep_org_terms ON /*_*/ep_orgs (org_terms); |
| 15 | 13 | CREATE INDEX /*i*/ep_org_students ON /*_*/ep_orgs (org_students); |
| 16 | 14 | |
| Index: trunk/extensions/EducationProgram/sql/EducationProgram.sql |
| — | — | @@ -19,7 +19,6 @@ |
| 20 | 20 | CREATE UNIQUE INDEX /*i*/ep_org_name ON /*_*/ep_orgs (org_name); |
| 21 | 21 | CREATE INDEX /*i*/ep_org_terms ON /*_*/ep_orgs (org_terms); |
| 22 | 22 | CREATE INDEX /*i*/ep_org_courses ON /*_*/ep_orgs (org_courses); |
| 23 | | -CREATE INDEX /*i*/ep_org_mentors ON /*_*/ep_orgs (org_mentors); |
| 24 | 23 | CREATE INDEX /*i*/ep_org_students ON /*_*/ep_orgs (org_students); |
| 25 | 24 | CREATE INDEX /*i*/ep_org_active ON /*_*/ep_orgs (org_active); |
| 26 | 25 | |