Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
OpenSim/Flotsam Group/DB
[
Front page
]
[ ]
Start:
** DB of Flotsam Group Function
*** DB
**** group_active
MariaDB [opensim_op]> show columns from group_active;
+---------------+-------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+---------------+-------------+------+-----+---------+--...
| agentid | varchar(64) | NO | PRI | | ...
| activegroupid | varchar(64) | NO | | | ...
+---------------+-------------+------+-----+---------+--...
2 rows in set (0.00 sec)
- os_groups_principals に相当
#br
**** group_invite
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
MariaDB [opensim_op]> show columns from group_list;
+----------------+--------------+------+-----+---------+...
| Field | Type | Null | Key | Default |...
+----------------+--------------+------+-----+---------+...
| 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
MariaDB [opensim_op]> show columns from group_membership;
+----------------+-------------+------+-----+---------+-...
| Field | Type | Null | Key | Default | ...
+----------------+-------------+------+-----+---------+-...
| 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
MariaDB [opensim_op]> show columns from group_notice;
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| 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
MariaDB [opensim_op]> show columns from group_role;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| 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
MariaDB [opensim_op]> show columns from group_rolemember...
+---------+-------------+------+-----+---------+-------+
| 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)
- [[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_rolemembershi...
#br
End:
** DB of Flotsam Group Function
*** DB
**** group_active
MariaDB [opensim_op]> show columns from group_active;
+---------------+-------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+---------------+-------------+------+-----+---------+--...
| agentid | varchar(64) | NO | PRI | | ...
| activegroupid | varchar(64) | NO | | | ...
+---------------+-------------+------+-----+---------+--...
2 rows in set (0.00 sec)
- os_groups_principals に相当
#br
**** group_invite
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
MariaDB [opensim_op]> show columns from group_list;
+----------------+--------------+------+-----+---------+...
| Field | Type | Null | Key | Default |...
+----------------+--------------+------+-----+---------+...
| 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
MariaDB [opensim_op]> show columns from group_membership;
+----------------+-------------+------+-----+---------+-...
| Field | Type | Null | Key | Default | ...
+----------------+-------------+------+-----+---------+-...
| 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
MariaDB [opensim_op]> show columns from group_notice;
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| 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
MariaDB [opensim_op]> show columns from group_role;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| 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
MariaDB [opensim_op]> show columns from group_rolemember...
+---------+-------------+------+-----+---------+-------+
| 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)
- [[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_rolemembershi...
#br
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
103 user(s) are online (15 user(s) are browsing xpwiki)
Members: 0
Guests: 103
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com