OpenSim/Flotsam Group/DB
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
** DB of Flotsam Group Function [#bb669970]
*** DB [#x047fdfa]
**** group_active [#a60145b5]
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 に相当
**** group_invite [#v88f567a]
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 [#ma143d09]
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 [#a52998dd]
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 [#e2c98624]
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 [#e990dad6]
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 [#a5710585]
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) [#k14164aa]
- [[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...
終了行:
** DB of Flotsam Group Function [#bb669970]
*** DB [#x047fdfa]
**** group_active [#a60145b5]
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 に相当
**** group_invite [#v88f567a]
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 [#ma143d09]
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 [#a52998dd]
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 [#e2c98624]
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 [#e990dad6]
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 [#a5710585]
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) [#k14164aa]
- [[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...
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
