![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-09-02T05:12:43+00:00","default:iseki","iseki") ** osGroup Module for OpenSim [#h16f3801] *** DB [#e26248b1] **** os_groups_groups [#g2aca6d5] MariaDB [jogrid_db]> show columns from os_groups_groups; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | GroupID | char(36) | NO | PRI | | | | Location | varchar(255) | NO | | | | | Name | varchar(255) | NO | UNI | | | | Charter | text | NO | | NULL | | | InsigniaID | char(36) | NO | | | | | FounderID | char(36) | NO | | | | | MembershipFee | int(11) | NO | | 0 | | | OpenEnrollment | varchar(255) | NO | | | | | ShowInList | int(4) | NO | | 0 | | | AllowPublish | int(4) | NO | | 0 | | | MaturePublish | int(4) | NO | | 0 | | | OwnerRoleID | char(36) | NO | | | | +----------------+--------------+------+-----+---------+-------+ 12 rows in set (0.00 sec) **** os_groups_invites [#ac28c91d] MariaDB [jogrid_db]> show columns from os_groups_invites; +-------------+--------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+-------------------+-----------------------------+ | InviteID | char(36) | NO | PRI | | | | GroupID | char(36) | NO | MUL | | | | RoleID | char(36) | NO | | | | | PrincipalID | varchar(255) | NO | | | | | TMStamp | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-------------+--------------+------+-----+-------------------+-----------------------------+ 5 rows in set (0.00 sec) **** os_groups_membership [#b9fcd51b] MariaDB [jogrid_db]> show columns from os_groups_membership; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | GroupID | char(36) | NO | PRI | | | | PrincipalID | varchar(255) | NO | PRI | | | | SelectedRoleID | char(36) | NO | | | | | Contribution | int(11) | NO | | 0 | | | ListInProfile | int(4) | NO | | 1 | | | AcceptNotices | int(4) | NO | | 1 | | | AccessToken | char(36) | NO | | | | +----------------+--------------+------+-----+---------+-------+ 7 rows in set (0.00 sec) **** os_groups_notices [#jfec1be3] MariaDB [jogrid_db]> show columns from os_groups_notices; +-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | GroupID | char(36) | NO | MUL | | | | NoticeID | char(36) | NO | PRI | | | | TMStamp | int(10) unsigned | NO | MUL | 0 | | | FromName | varchar(255) | NO | | | | | Subject | varchar(255) | NO | | | | | Message | text | NO | | NULL | | | HasAttachment | int(4) | NO | | 0 | | | AttachmentType | int(4) | NO | | 0 | | | AttachmentName | varchar(128) | NO | | | | | AttachmentItemID | char(36) | NO | | | | | AttachmentOwnerID | varchar(255) | NO | | | | +-------------------+------------------+------+-----+---------+-------+ 11 rows in set (0.00 sec) **** os_groups_principals [#r214e414] MariaDB [jogrid_db]> show columns from os_groups_principals; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | PrincipalID | varchar(255) | NO | PRI | | | | ActiveGroupID | char(36) | NO | | | | +---------------+--------------+------+-----+---------+-------+ 2 rows in set (0.00 sec) **** os_groups_rolemembership [#n6953714] MariaDB [jogrid_db]> show columns from os_groups_rolemembership; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | GroupID | char(36) | NO | PRI | | | | RoleID | char(36) | NO | PRI | | | | PrincipalID | varchar(255) | NO | PRI | | | +-------------+--------------+------+-----+---------+-------+ 3 rows in set (0.02 sec) **** os_groups_roles; [#tce985b1] MariaDB [jogrid_db]> show columns from os_groups_roles; +-------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------+------+-----+---------+-------+ | GroupID | char(36) | NO | PRI | | | | RoleID | char(36) | NO | PRI | | | | Name | varchar(255) | NO | | | | | Description | varchar(255) | NO | | | | | Title | varchar(255) | NO | | | | | Powers | bigint(20) unsigned | NO | | 0 | | +-------------+---------------------+------+-----+---------+-------+ 6 rows in set (0.00 sec)
