Network System Laboratory - Source of OpenSim/osGroup

View the diff.
Go to OpenSim/osGroup.
** 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)
« Prev
Backup list of OpenSim/osGroup
Backup source of OpenSim/osGroup(No. All)
- 1: 2016-07-20 (Wed) 16:51:28 iseki
- Cur: 2016-07-20 (Wed) 16:57:59 iseki
Source of OpenSim/osGroup

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter

Source of OpenSim​/osGroup

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter

Source of OpenSim/osGroup
