Duplicated roles

[CodingDive]

We seem to have some duplicated roles. In particular, the german/english/spanish/french/hindi reviewer, helpers, admins, moderators, etc. all have a de/en/es/fr/hi version too. Are the non-abbreviated roles still in use?

mysql> SELECT * FROM role;
+----+-------------------------+-------------+
| id | name                    | description |
+----+-------------------------+-------------+
|  1 | guest                   | NULL        |
|  2 | login                   | NULL        |
|  3 | german_reviewer         | NULL        |
|  4 | german_helper           | NULL        |
|  5 | german_admin            | NULL        |
|  6 | german_horizonhelper    | NULL        |
|  7 | german_moderator        | NULL        |
|  8 | german_ambassador       | NULL        |
|  9 | german_langhelper       | NULL        |
| 10 | german_langadmin        | NULL        |
| 11 | sysadmin                | NULL        |
| 12 | english_reviewer        | NULL        |
| 13 | english_helper          | NULL        |
| 14 | english_admin           | NULL        |
| 15 | english_horizonhelper   | NULL        |
| 16 | english_moderator       | NULL        |
| 17 | english_ambassador      | NULL        |
| 18 | english_langhelper      | NULL        |
| 19 | english_langadmin       | NULL        |
| 20 | spanish_reviewer        | NULL        |
| 21 | spanish_helper          | NULL        |
| 22 | spanish_admin           | NULL        |
| 24 | spanish_horizonhelper   | NULL        |
| 25 | spanish_moderator       | NULL        |
| 26 | spanish_ambassador      | NULL        |
| 27 | spanish_langhelper      | NULL        |
| 28 | spanish_langadmin       | NULL        |
| 29 | hindi_reviewer          | NULL        |
| 30 | hindi_helper            | NULL        |
| 31 | hindi_admin             | NULL        |
| 32 | hindi_horizonhelper     | NULL        |
| 33 | hindi_moderator         | NULL        |
| 34 | hindi_ambassador        | NULL        |
| 35 | hindi_langhelper        | NULL        |
| 36 | hindi_langadmin         | NULL        |
| 37 | role_admin              | NULL        |
| 38 | tamil_reviewer          | NULL        |
| 39 | tamil_helper            | NULL        |
| 40 | tamil_admin             | NULL        |
| 41 | tamil_horizonhelper     | NULL        |
| 42 | tamil_moderator         | NULL        |
| 43 | tamil_ambassador        | NULL        |
| 44 | tamil_langhelper        | NULL        |
| 45 | tamil_langadmin         | NULL        |
| 46 | french_reviewer         | NULL        |
| 47 | french_helper           | NULL        |
| 48 | french_admin            | NULL        |
| 49 | french_horizonhelper    | NULL        |
| 50 | french_moderator        | NULL        |
| 51 | french_ambassador       | NULL        |
| 52 | french_langhelper       | NULL        |
| 53 | french_langadmin        | NULL        |
| 54 | de_moderator            | NULL        |
| 55 | de_reviewer             | NULL        |
| 56 | de_architect            | NULL        |
| 57 | de_static_pages_builder | NULL        |
| 58 | de_admin                | NULL        |
| 59 | en_moderator            | NULL        |
| 60 | en_reviewer             | NULL        |
| 61 | en_architect            | NULL        |
| 62 | en_static_pages_builder | NULL        |
| 63 | en_admin                | NULL        |
| 64 | es_moderator            | NULL        |
| 65 | es_reviewer             | NULL        |
| 66 | es_architect            | NULL        |
| 67 | es_static_pages_builder | NULL        |
| 68 | es_admin                | NULL        |
| 69 | fr_moderator            | NULL        |
| 70 | fr_reviewer             | NULL        |
| 71 | fr_architect            | NULL        |
| 72 | fr_static_pages_builder | NULL        |
| 73 | fr_admin                | NULL        |
| 74 | hi_moderator            | NULL        |
| 75 | hi_reviewer             | NULL        |
| 76 | hi_architect            | NULL        |
| 77 | hi_static_pages_builder | NULL        |
| 78 | hi_admin                | NULL        |
| 79 | ta_moderator            | NULL        |
| 80 | ta_reviewer             | NULL        |
| 81 | ta_architect            | NULL        |
| 82 | ta_static_pages_builder | NULL        |
| 83 | ta_admin                | NULL        |
+----+-------------------------+-------------+