OpenSim​/Flotsam Group​/DB​/group_role

+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | bigint(11)   | NO   | PRI | NULL    | auto_increment |
| groupid     | varchar(64)  | NO   | MUL |         |                |
| roleid      | varchar(64)  | NO   |     |         |                |
| name        | varchar(255) | NO   |     |         |                |
| description | varchar(255) | NO   |     |         |                |
| title       | varchar(255) | NO   |     |         |                |
| powers      | bigint(20)   | NO   |     | 0       |                |
+-------------+--------------+------+-----+---------+----------------+

+-----+--------------------------------------+--------------------------------------+--------------+------------------------------------------------+------------------------+------------------+
| id  | groupid                              | roleid                               | name         | description                                    | title                  | powers           |
+-----+--------------------------------------+--------------------------------------+--------------+------------------------------------------------+------------------------+------------------+
|   1 | bab01d9a-68b0-427c-87b4-9b28ac885bb5 | 00000000-0000-0000-0000-000000000000 | Everyone   　| Everyone in the group is in the everyone role. | Member of admin        |    8796495740928 |
|  41 | df9948dc-3279-4ca1-b206-8e80e8e17a92 | 13e4fb51-82e1-41c8-b7dd-0144b04e174f | Co-owner     | なんでも許される人                             | ラムだっちゃ           |  439804651110398 |
|  42 | c709f6eb-db52-4a99-bbce-d818f603fafa | 00000000-0000-0000-0000-000000000000 | Everyone     | Everyone in the group is in the everyone role. | Member of WONDERGARDEN |    8796495740928 |
|  43 | c709f6eb-db52-4a99-bbce-d818f603fafa | 48011fae-e17b-43ae-8e06-c3afe11c2aba | Owners       | Owners of WONDERGARDEN                         | Owner of WONDERGARDEN  |  349644697632766 |
|  44 | 8697f4b4-bc50-45f1-b4bb-37e52057f5d3 | 00000000-0000-0000-0000-000000000000 | Everyone     | Everyone in the group is in the everyone role. | Member of NAGANO fan   |    8796495740928 |
|  45 | 8697f4b4-bc50-45f1-b4bb-37e52057f5d3 | b8aa4031-6da2-4997-84cd-dee59822b97a | Owners       | Owners of NAGANO fan                           | Owner of NAGANO fan    |  349644697632766 |
|  46 | 8697f4b4-bc50-45f1-b4bb-37e52057f5d3 | dfb80856-4fc5-47d8-b84d-c7ba62f3d6fe | NAGANO staff | 運営手伝ってくれそうな人                       |  長野県民              |   16443199520770 |
|  47 | 23680490-d490-48fa-b96b-b47b2514d898 | 00000000-0000-0000-0000-000000000000 | 全員         | Everyone in the group is in the everyone role. | Professo of ikim dou   |    8796495740930 |
|  48 | 23680490-d490-48fa-b96b-b47b2514d898 | 255ee706-c837-4217-803c-f22d9de40a15 | ????         | ?????                                          | 地球防衛隊♥            |  349644697632766 |
|  49 | f91a4e2c-ada8-4007-9ef7-776abb050d94 | 00000000-0000-0000-0000-000000000000 | Everyone     | Everyone in the group is in the everyone role. | 青い鳥 Member          |  149533984096256 |
|  50 | f91a4e2c-ada8-4007-9ef7-776abb050d94 | fca57ead-9651-4c28-89f5-617bf8b4e78c | Owners       | Owners of bluebird owner                       | 青い鳥 Owner           |  349644697632766 |