![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-09-02T05:13:32+00:00","default:iseki","iseki") ** DB of Flotsam Group Function [#bb669970] *** DB [#x047fdfa] **** group_active [#a60145b5] 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 [#v88f567a] 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 [#ma143d09] 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 [#a52998dd] 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 [#e2c98624] 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 [#e990dad6] 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 [#a5710585] 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) [#k14164aa] - [[mdl_modlos_group_list>./group_list]] - [[mdl_modlos_group_active>./group_active]] - [[mdl_modlos_group_invite>./group_invite]] - [[mdl_modlos_group_membership>./group_membership]] - [[mdl_modlos_group_notice>./group_notice]] - [[mdl_modlos_group_role>./group_role]] - [[mdl_modlos_group_rolemembership>./group_rolemembership]]
