Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
If you want to see English page, please click "English" Button at Left.
[
タイトル一覧
|
ページ一覧
|
新規
|
単語検索
|
最終更新
|
ヘルプ
]
OpenSim/Flotsam Group/DB
をテンプレートにして作成
[
トップ
]
[ ]
開始行:
** 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
終了行:
** 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
ページ名:
サイト内 検索
高度な検索
ログイン
ユーザー名:
パスワード:
パスワード紛失
新規登録
サブ メニュー
新着情報
Books
リンク
サイトマップ
e-Learning
TUIS 認証局証明書
ミニカレンダー
2024年 5月
日
月
火
水
木
金
土
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
<今日>
オンライン状況
96 人のユーザが現在オンラインです。 (20 人のユーザが xpwiki を参照しています。)
登録ユーザ: 0
ゲスト: 96
もっと...
アクセスカウンタ
今日 :
昨日 :
総計 :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com