| Index: trunk/extensions/EducationProgram/sql/EducationProgram.sql |
| — | — | @@ -12,9 +12,9 @@ |
| 13 | 13 | |
| 14 | 14 | org_active TINYINT unsigned NOT NULL, -- If the org has any active courses |
| 15 | 15 | org_courses SMALLINT unsigned NOT NULL, -- Amount of courses |
| 16 | | - org_instructors SMALLINT unsigned NOT NULL -- Amount of instructors |
| 17 | | - org_online_ambs INT unsigned NOT NULL -- Amount of online ambassadors |
| 18 | | - org_campus_ambs INT unsigned NOT NULL -- Amount of campus ambassadors |
| | 16 | + org_instructors SMALLINT unsigned NOT NULL, -- Amount of instructors |
| | 17 | + org_online_ambs INT unsigned NOT NULL, -- Amount of online ambassadors |
| | 18 | + org_campus_ambs INT unsigned NOT NULL, -- Amount of campus ambassadors |
| 19 | 19 | org_students INT unsigned NOT NULL -- Amount of students |
| 20 | 20 | ) /*$wgDBTableOptions*/; |
| 21 | 21 | |
| — | — | @@ -147,7 +147,7 @@ |
| 148 | 148 | -- Online ambassadors. In essence this is an extension to the user table. |
| 149 | 149 | CREATE TABLE IF NOT EXISTS /*_*/ep_oas ( |
| 150 | 150 | oa_id INT unsigned NOT NULL auto_increment PRIMARY KEY, |
| 151 | | - oa_user_id INT unsigned NOT NULL -- Foreign key on user.user_id |
| | 151 | + oa_user_id INT unsigned NOT NULL, -- Foreign key on user.user_id |
| 152 | 152 | |
| 153 | 153 | oa_bio TEXT NOT NULL, -- Bio of the ambassador |
| 154 | 154 | oa_photo VARCHAR(255) NOT NULL -- Name of a photo of the ambassador on commons |