| Index: trunk/extensions/EducationProgram/sql/AddExtraFields.sql |
| — | — | @@ -1,26 +0,0 @@ |
| 2 | | - |
| 3 | | -ALTER TABLE /*_*/ep_orgs ADD COLUMN org_courses SMALLINT unsigned NOT NULL; |
| 4 | | -ALTER TABLE /*_*/ep_orgs ADD COLUMN org_terms SMALLINT unsigned NOT NULL; |
| 5 | | -ALTER TABLE /*_*/ep_orgs ADD COLUMN org_students INT unsigned NOT NULL; |
| 6 | | - |
| 7 | | -CREATE INDEX /*i*/ep_org_courses ON /*_*/ep_orgs (org_courses); |
| 8 | | -CREATE INDEX /*i*/ep_org_terms ON /*_*/ep_orgs (org_terms); |
| 9 | | -CREATE INDEX /*i*/ep_org_students ON /*_*/ep_orgs (org_students); |
| 10 | | - |
| 11 | | -ALTER TABLE /*_*/ep_courses ADD COLUMN course_lang VARCHAR(10) NOT NULL; |
| 12 | | -ALTER TABLE /*_*/ep_courses ADD COLUMN course_students SMALLINT unsigned NOT NULL; |
| 13 | | - |
| 14 | | -CREATE INDEX /*i*/ep_course_lang ON /*_*/ep_courses (course_lang); |
| 15 | | -CREATE INDEX /*i*/ep_course_students ON /*_*/ep_courses (course_students); |
| 16 | | - |
| 17 | | -ALTER TABLE /*_*/ep_students ADD COLUMN student_first_enroll varbinary(14) NOT NULL; |
| 18 | | -ALTER TABLE /*_*/ep_students ADD COLUMN student_last_active varbinary(14) NOT NULL; |
| 19 | | -ALTER TABLE /*_*/ep_students ADD COLUMN student_active_enroll TINYINT unsigned NOT NULL; |
| 20 | | - |
| 21 | | -CREATE INDEX /*i*/ep_students_first_enroll ON /*_*/ep_students (student_first_enroll); |
| 22 | | -CREATE INDEX /*i*/ep_students_last_active ON /*_*/ep_students (student_last_active); |
| 23 | | -CREATE INDEX /*i*/ep_students_active_enroll ON /*_*/ep_students (student_active_enroll); |
| \ No newline at end of file |
| Index: trunk/extensions/EducationProgram/sql/AddStatusFields.sql |
| — | — | @@ -1,12 +0,0 @@ |
| 2 | | - |
| 3 | | -ALTER TABLE /*_*/ep_orgs ADD COLUMN org_active TINYINT unsigned NOT NULL default 1; |
| 4 | | - |
| 5 | | -CREATE INDEX /*i*/ep_org_active ON /*_*/ep_orgs (org_active); |
| 6 | | - |
| 7 | | -ALTER TABLE /*_*/ep_courses ADD COLUMN course_active TINYINT unsigned NOT NULL default 1; |
| 8 | | - |
| 9 | | -CREATE INDEX /*i*/ep_course_active ON /*_*/ep_courses (course_active); |
| \ No newline at end of file |
| Index: trunk/extensions/EducationProgram/sql/AddMentorFields.sql |
| — | — | @@ -1,9 +0,0 @@ |
| 2 | | - |
| 3 | | -ALTER TABLE /*_*/ep_courses ADD COLUMN course_instructors BLOB NOT NULL; |
| 4 | | - |
| 5 | | -ALTER TABLE /*_*/ep_terms ADD COLUMN term_online_ambs BLOB NOT NULL; |
| 6 | | -ALTER TABLE /*_*/ep_terms ADD COLUMN term_campus_ambs BLOB NOT NULL; |
| Index: trunk/extensions/EducationProgram/sql/AddStudentsField.sql |
| — | — | @@ -1,8 +0,0 @@ |
| 2 | | - |
| 3 | | -ALTER TABLE /*_*/ep_terms ADD COLUMN term_students SMALLINT unsigned NOT NULL default 0; |
| 4 | | - |
| 5 | | -CREATE INDEX /*i*/ep_term_students ON /*_*/ep_terms (term_students); |
| \ No newline at end of file |
| Index: trunk/extensions/EducationProgram/EducationProgram.hooks.php |
| — | — | @@ -28,39 +28,6 @@ |
| 29 | 29 | 'ep_orgs', |
| 30 | 30 | dirname( __FILE__ ) . '/sql/EducationProgram.sql' |
| 31 | 31 | ); |
| 32 | | - |
| 33 | | - $updater->addExtensionUpdate( array( |
| 34 | | - 'addField', |
| 35 | | - 'ep_orgs', |
| 36 | | - 'org_courses', |
| 37 | | - dirname( __FILE__ ) . '/sql/AddExtraFields.sql', |
| 38 | | - true |
| 39 | | - ) ); |
| 40 | | - |
| 41 | | - $updater->addExtensionUpdate( array( |
| 42 | | - 'addField', |
| 43 | | - 'ep_orgs', |
| 44 | | - 'org_active', |
| 45 | | - dirname( __FILE__ ) . '/sql/AddStatusFields.sql', |
| 46 | | - true |
| 47 | | - ) ); |
| 48 | | - |
| 49 | | - $updater->addExtensionUpdate( array( |
| 50 | | - 'addField', |
| 51 | | - 'ep_courses', |
| 52 | | - 'course_instructors', |
| 53 | | - dirname( __FILE__ ) . '/sql/AddMentorFields.sql', |
| 54 | | - true |
| 55 | | - ) ); |
| 56 | | - |
| 57 | | - $updater->addExtensionUpdate( array( |
| 58 | | - 'addField', |
| 59 | | - 'ep_terms', |
| 60 | | - 'term_students', |
| 61 | | - dirname( __FILE__ ) . '/sql/AddStudentsField.sql', |
| 62 | | - true |
| 63 | | - ) ); |
| 64 | | - |
| 65 | 32 | return true; |
| 66 | 33 | } |
| 67 | 34 | |