| 1 | SHOW FULL COLUMNS FROM `users` | | 41 | 41 | 7 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 0 |
| 3 | SHOW FULL COLUMNS FROM `offices` | | 8 | 8 | 1 |
| 4 | SHOW FULL COLUMNS FROM `countries` | | 9 | 9 | 1 |
| 5 | SHOW FULL COLUMNS FROM `cities` | | 7 | 7 | 8 |
| 6 | SHOW FULL COLUMNS FROM `provinces` | | 6 | 6 | 1 |
| 7 | SHOW FULL COLUMNS FROM `ciip_sessions` | | 11 | 11 | 11 |
| 8 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin'; | | 1 | 1 | 0 |
| 9 | SHOW FULL COLUMNS FROM `teams` | | 5 | 5 | 1 |
| 10 | SHOW FULL COLUMNS FROM `lmi_categories` | | 5 | 5 | 1 |
| 11 | SHOW FULL COLUMNS FROM `participation_lmis` | | 19 | 19 | 8 |
| 12 | SHOW FULL COLUMNS FROM `participations` | | 6 | 6 | 5 |
| 13 | SHOW FULL COLUMNS FROM `profiles` | | 70 | 70 | 5 |
| 14 | SHOW FULL COLUMNS FROM `occupations` | | 8 | 8 | 2 |
| 15 | SHOW FULL COLUMNS FROM `feedback` | | 36 | 36 | 9 |
| 16 | SHOW FULL COLUMNS FROM `families` | | 6 | 6 | 1 |
| 17 | SHOW FULL COLUMNS FROM `participation_reasons` | | 25 | 25 | 3 |
| 18 | SHOW FULL COLUMNS FROM `delivery_methods` | | 6 | 6 | 2 |
| 19 | SHOW FULL COLUMNS FROM `participation_pilots` | | 20 | 20 | 3 |
| 20 | SHOW FULL COLUMNS FROM `nature_of_activities` | | 5 | 5 | 1 |
| 21 | SHOW FULL COLUMNS FROM `templates` | | 10 | 10 | 1 |
| 22 | SHOW FULL COLUMNS FROM `participation_pilot_categories` | | 6 | 6 | 1 |
| 23 | SHOW FULL COLUMNS FROM `pilot_head_offices` | | 5 | 5 | 1 |
| 24 | SHOW FULL COLUMNS FROM `participation_pilot_partners` | | 6 | 6 | 1 |
| 25 | SHOW FULL COLUMNS FROM `partners` | | 11 | 11 | 12 |
| 26 | SHOW FULL COLUMNS FROM `agency_types` | | 5 | 5 | 2 |
| 27 | SHOW FULL COLUMNS FROM `agencies` | | 9 | 9 | 2 |
| 28 | SHOW FULL COLUMNS FROM `referrals` | | 17 | 17 | 8 |
| 29 | SHOW FULL COLUMNS FROM `partner_contacts` | | 10 | 10 | 2 |
| 30 | SHOW FULL COLUMNS FROM `partner_types` | | 6 | 6 | 2 |
| 31 | SHOW FULL COLUMNS FROM `partner_users` | | 6 | 6 | 1 |
| 32 | SHOW FULL COLUMNS FROM `participation_lmi_offices` | | 5 | 5 | 1 |
| 33 | SHOW FULL COLUMNS FROM `participation_lmi_names` | | 5 | 5 | 1 |
| 34 | SHOW FULL COLUMNS FROM `participation_counsellors` | | 19 | 19 | 4 |
| 35 | SHOW FULL COLUMNS FROM `participation_counsellor_offices` | | 5 | 5 | 1 |
| 36 | SHOW FULL COLUMNS FROM `participation_counsellor_names` | | 5 | 5 | 1 |
