Network System Laboratory - OpenSim/Flotsam Group/DB [DB of Flotsam Group Function]

[ Freeze | Diff | Backup | Reload ]

Table of contents

- DB of Flotsam Group Function
  - DB
  - Modlos (Moodle)

DB of Flotsam Group Function

DB

group_active

MariaDB [opensim_op]> show columns from group_active;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| agentid       | varchar(64) | NO   | PRI |         |       |
| activegroupid | varchar(64) | NO   |     |         |       |
+---------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

os_groups_principals に相当

group_invite

MariaDB [opensim_op]> show columns from group_invite;

+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| inviteid | varchar(64) | NO   | PRI |         |       |
| groupid  | varchar(64) | NO   | MUL |         |       |
| roleid   | varchar(64) | YES  |     | NULL    |       |
| agentid  | varchar(64) | NO   |     |         |       |
| tmstamp  | bigint(11)  | NO   |     | NULL    |       |
+----------+-------------+------+-----+-------
5 rows in set (0.00 sec)

group_list

MariaDB [opensim_op]> show columns from  group_list;
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| groupid        | varchar(64)  | NO   | PRI |         |       |
| name           | varchar(255) | NO   | UNI |         |       |
| charter        | longtext     | NO   |     | NULL    |       |
| insigniaid     | varchar(64)  | NO   |     |         |       |
| founderid      | varchar(64)  | NO   |     |         |       |
| membershipfee  | bigint(11)   | NO   |     | 0       |       |
| openenrollment | varchar(255) | NO   |     |         |       |
| showinlist     | tinyint(1)   | NO   |     | 0       |       |
| allowpublish   | tinyint(1)   | NO   |     | 0       |       |
| maturepublish  | tinyint(1)   | NO   |     | 0       |       |
| ownerroleid    | varchar(128) | NO   |     |         |       |
+----------------+--------------+------+-----+---------+-------+
11 rows in set (0.00 sec)

group_membership

MariaDB [opensim_op]> show columns from group_membership;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| groupid        | varchar(64) | NO   | PRI |         |       |
| agentid        | varchar(64) | NO   | PRI |         |       |
| selectedroleid | varchar(64) | NO   |     |         |       |
| contribution   | bigint(11)  | NO   |     | 0       |       |
| listinprofile  | bigint(11)  | NO   |     | 1       |       |
| acceptnotices  | bigint(11)  | NO   |     | 1       |       |
+----------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

group_notice

MariaDB [opensim_op]> show columns from group_notice;
+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| groupid      | varchar(64)  | NO   | PRI |         |       |
| noticeid     | varchar(64)  | NO   | PRI |         |       |
| timestamp    | bigint(11)   | NO   | MUL | 0       |       |
| fromname     | varchar(255) | NO   |     |         |       |
| subject      | varchar(255) | NO   |     |         |       |
| message      | longtext     | NO   |     | NULL    |       |
| binarybucket | longblob     | NO   |     | NULL    |       |
+--------------+--------------+------+-----+---------+-------+
7 rows in set (0.00 sec)

group_role

MariaDB [opensim_op]> show columns from group_role;
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| groupid     | varchar(64)  | NO   | PRI |         |       |
| roleid      | varchar(64)  | NO   | PRI |         |       |
| name        | varchar(255) | NO   |     |         |       |
| description | varchar(255) | NO   |     |         |       |
| title       | varchar(255) | NO   |     |         |       |
| powers      | bigint(20)   | NO   |     | 0       |       |
+-------------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

group_rolemembership

MariaDB [opensim_op]> show columns from group_rolemembership;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| groupid | varchar(64) | NO   | PRI |         |       |
| roleid  | varchar(64) | NO   | PRI |         |       |
| agentid | varchar(64) | NO   | PRI |         |       |
+---------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)