Rearrange Roles on Contributor Selection

[lomky]

Move 'Point of Contact' role next to the role 'Author' (sort order), so that selection of multiple roles is easier. Currently, the most common multiple roles are POC and Author.

[lomky]

@amruelama Here is the current sort_order on role_type.

gcis=# select * from role_type ORDER BY sort_key ASC;
        identifier        |          label           | sort_key | comment
--------------------------+--------------------------+----------+---------
 convening_lead_author    | Convening Lead Author    |       10 |
 coordinating_lead_author | Coordinating Lead Author |       11 |
 lead_author              | Lead Author              |       20 |
 principal_author         | Principal Author         |       30 |
 primary_author           | Primary Author           |       40 |
 secondary_author         | Secondary Author         |       50 |
 contributing_author      | Contributing Author      |       60 |
 author                   | Author                   |       70 |
 contributing_editor      | Contributing Editor      |       73 |
 executive_editor         | Executive Editor         |       74 |
 editor                   | Editor                   |       75 |
 coordinator              | Coordinator              |       78 |
 data_producer            | Data Producer            |       80 |
 data_archive             | Data Archive             |       90 |
 funding_agency           | Funding Agency           |      100 |
 distributor              | Distributor              |      110 |
 host                     | Host                     |      120 |
 scientist                | Scientist                |      130 |
 analyst                  | Analyst                  |      140 |
 graphic_artist           | Graphic Artist           |      150 |
 point_of_contact         | Point of Contact         |      160 |
 advisor                  | Advisor                  |      170 |
 engineer                 | Engineer                 |      190 |
 manager                  | Manager                  |      200 |
 lead_agency              | Lead Agency              |      300 |
 contributing_agency      | Contributing Agency      |      310 |
 publisher                | Publisher                |      500 |
 contributor              | Contributor              |      999 |
(28 rows)

And here is the order by most often used:

gcis=# select count(*) as num, role_type_identifier from contributor group by role_type_identifier ORDER BY num DESC;
  num  |   role_type_identifier
-------+--------------------------
 15297 | author
  1097 | point_of_contact
   822 | editor
   408 | contributing_author
   378 | publisher
   348 | funding_agency
   312 | lead_author
   244 | distributor
   181 | contributor
   136 | host
   107 | data_archive
   100 | convening_lead_author
    84 | scientist
    75 | advisor
    56 | contributing_agency
    54 | data_producer
    26 | coordinating_lead_author
    25 | primary_author
    14 | analyst
    13 | graphic_artist
    12 | executive_editor
    11 | lead_agency
     7 | coordinator
     5 | principal_author
     2 | engineer
     1 | manager
(26 rows)

How would you like me to update the sort_order?

[lomky]

We just discovered this is editable by the data manager!
Yay!

[amruelama]

Rearranged roles by the preferred sort order.