Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
OpenSim/osGroup
[
Front page
]
[ ]
Start:
** osGroup Module for OpenSim
*** DB
**** os_groups_groups
MariaDB [jogrid_db]> show columns from os_groups_groups;
+----------------+--------------+------+-----+---------+...
| Field | Type | Null | Key | Default |...
+----------------+--------------+------+-----+---------+...
| 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
MariaDB [jogrid_db]> show columns from os_groups_invites;
+-------------+--------------+------+-----+-------------...
| Field | Type | Null | Key | Default ...
+-------------+--------------+------+-----+-------------...
| InviteID | char(36) | NO | PRI | ...
| GroupID | char(36) | NO | MUL | ...
| RoleID | char(36) | NO | | ...
| PrincipalID | varchar(255) | NO | | ...
| TMStamp | timestamp | NO | | CURRENT_TIME...
+-------------+--------------+------+-----+-------------...
5 rows in set (0.00 sec)
**** os_groups_membership
MariaDB [jogrid_db]> show columns from os_groups_members...
+----------------+--------------+------+-----+---------+...
| Field | Type | Null | Key | Default |...
+----------------+--------------+------+-----+---------+...
| 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
MariaDB [jogrid_db]> show columns from os_groups_notices;
+-------------------+------------------+------+-----+---...
| Field | Type | Null | Key | De...
+-------------------+------------------+------+-----+---...
| 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 | | NU...
| 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
MariaDB [jogrid_db]> show columns from os_groups_princip...
+---------------+--------------+------+-----+---------+-...
| Field | Type | Null | Key | Default | ...
+---------------+--------------+------+-----+---------+-...
| PrincipalID | varchar(255) | NO | PRI | | ...
| ActiveGroupID | char(36) | NO | | | ...
+---------------+--------------+------+-----+---------+-...
2 rows in set (0.00 sec)
**** os_groups_rolemembership
MariaDB [jogrid_db]> show columns from os_groups_rolemem...
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| 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;
MariaDB [jogrid_db]> show columns from os_groups_roles;
+-------------+---------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+-------------+---------------------+------+-----+------...
| 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)
End:
** osGroup Module for OpenSim
*** DB
**** os_groups_groups
MariaDB [jogrid_db]> show columns from os_groups_groups;
+----------------+--------------+------+-----+---------+...
| Field | Type | Null | Key | Default |...
+----------------+--------------+------+-----+---------+...
| 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
MariaDB [jogrid_db]> show columns from os_groups_invites;
+-------------+--------------+------+-----+-------------...
| Field | Type | Null | Key | Default ...
+-------------+--------------+------+-----+-------------...
| InviteID | char(36) | NO | PRI | ...
| GroupID | char(36) | NO | MUL | ...
| RoleID | char(36) | NO | | ...
| PrincipalID | varchar(255) | NO | | ...
| TMStamp | timestamp | NO | | CURRENT_TIME...
+-------------+--------------+------+-----+-------------...
5 rows in set (0.00 sec)
**** os_groups_membership
MariaDB [jogrid_db]> show columns from os_groups_members...
+----------------+--------------+------+-----+---------+...
| Field | Type | Null | Key | Default |...
+----------------+--------------+------+-----+---------+...
| 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
MariaDB [jogrid_db]> show columns from os_groups_notices;
+-------------------+------------------+------+-----+---...
| Field | Type | Null | Key | De...
+-------------------+------------------+------+-----+---...
| 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 | | NU...
| 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
MariaDB [jogrid_db]> show columns from os_groups_princip...
+---------------+--------------+------+-----+---------+-...
| Field | Type | Null | Key | Default | ...
+---------------+--------------+------+-----+---------+-...
| PrincipalID | varchar(255) | NO | PRI | | ...
| ActiveGroupID | char(36) | NO | | | ...
+---------------+--------------+------+-----+---------+-...
2 rows in set (0.00 sec)
**** os_groups_rolemembership
MariaDB [jogrid_db]> show columns from os_groups_rolemem...
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| 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;
MariaDB [jogrid_db]> show columns from os_groups_roles;
+-------------+---------------------+------+-----+------...
| Field | Type | Null | Key | Defau...
+-------------+---------------------+------+-----+------...
| 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)
Page:
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
May 2025
Su
Mo
Tu
We
Th
Fr
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Today
Who's Online
68 user(s) are online (19 user(s) are browsing xpwiki)
Members: 0
Guests: 68
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com