|
1: 2016-07-20 (Wed) 16:51:28 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) |
