OpenSim/flotsam_Group/DB

DB of Flotsam Group Function†[edit]

DB†[edit]

group_active†[edit]

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†[edit]

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†[edit]

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†[edit]

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†[edit]

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†[edit]

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†[edit]

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)

Modlos (Moodle)†[edit]

• mdl_modlos_group_list
• mdl_modlos_group_active
• mdl_modlos_group_invite
• mdl_modlos_group_membership
• mdl_modlos_group_notice
• mdl_modlos_group_role
• mdl_modlos_group_rolemembership

最新の30件

[edit]