1: 2016-04-29 (金) 17:43:42 iseki |
現: 2016-07-20 (水) 16:58:41 iseki |
- | * DB of Flotsam Group Function [#bb669970] | + | ** DB of Flotsam Group Function [#bb669970] |
| | | |
- | *** Modlos [#j706cb8f] | + | *** DB [#x047fdfa] |
- | | mdl_modlos_group_active | | + | |
- | | mdl_modlos_group_invite | | + | |
- | | mdl_modlos_group_list | | + | |
- | | mdl_modlos_group_membership | | + | |
- | | mdl_modlos_group_notice | | + | |
- | | mdl_modlos_group_role | | + | |
- | | mdl_modlos_group_rolemembership | | + | |
| | | |
- | MariaDB [moodle_db]> show columns from mdl_modlos_group_active; | + | **** group_active [#a60145b5] |
- | +---------------+-------------+------+-----+---------+----------------+ | + | MariaDB [opensim_op]> show columns from group_active; |
- | | Field | Type | Null | Key | Default | Extra | | + | +---------------+-------------+------+-----+---------+-------+ |
- | +---------------+-------------+------+-----+---------+----------------+ | + | | Field | Type | Null | Key | Default | Extra | |
- | | id | bigint(11) | NO | PRI | NULL | auto_increment | | + | +---------------+-------------+------+-----+---------+-------+ |
- | | agentid | varchar(64) | NO | UNI | | | | + | | agentid | varchar(64) | NO | PRI | | | |
- | | activegroupid | varchar(64) | NO | | | | | + | | activegroupid | varchar(64) | NO | | | | |
- | +---------------+-------------+------+-----+---------+----------------+ | + | +---------------+-------------+------+-----+---------+-------+ |
| + | 2 rows in set (0.00 sec) |
| + | - os_groups_principals に相当 |
| + | #br |
| | | |
- | MariaDB [moodle_db]> show columns from mdl_modlos_group_invite; | + | **** group_invite [#v88f567a] |
- | +----------+-------------+------+-----+---------+----------------+ | + | MariaDB [opensim_op]> show columns from group_invite; |
- | | Field | Type | Null | Key | Default | Extra | | + | +----------+-------------+------+-----+---------+-------+ |
- | +----------+-------------+------+-----+---------+----------------+ | + | | Field | Type | Null | Key | Default | Extra | |
- | | id | bigint(11) | NO | PRI | NULL | auto_increment | | + | +----------+-------------+------+-----+---------+-------+ |
- | | inviteid | varchar(64) | NO | UNI | | | | + | | inviteid | varchar(64) | NO | PRI | | | |
- | | groupid | varchar(64) | NO | MUL | | | | + | | groupid | varchar(64) | NO | MUL | | | |
- | | roleid | varchar(64) | YES | | NULL | | | + | | roleid | varchar(64) | YES | | NULL | | |
- | | agentid | varchar(64) | NO | | | | | + | | agentid | varchar(64) | NO | | | | |
- | | tmstamp | bigint(11) | NO | | NULL | | | + | | 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 | Extra | |
| + | +----------------+--------------+------+-----+---------+-------+ |
| + | | 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 | Extra | |
| + | +----------------+-------------+------+-----+---------+-------+ |
| + | | 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 | Extra | |
| + | +--------------+--------------+------+-----+---------+-------+ |
| + | | 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 | Extra | |
| + | +-------------+--------------+------+-----+---------+-------+ |
| + | | 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_rolemembership; |
| + | +---------+-------------+------+-----+---------+-------+ |
| + | | 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) |
| | | |
- | MariaDB [moodle_db]> show columns from mdl_modlos_group_list ; | + | *** Modlos (Moodle) [#k14164aa] |
- | +----------------+--------------+------+-----+---------+----------------+ | + | - [[mdl_modlos_group_list>./group_list]] |
- | | Field | Type | Null | Key | Default | Extra | | + | - [[mdl_modlos_group_active>./group_active]] |
- | +----------------+--------------+------+-----+---------+----------------+ | + | - [[mdl_modlos_group_invite>./group_invite]] |
- | | id | bigint(11) | NO | PRI | NULL | auto_increment | | + | - [[mdl_modlos_group_membership>./group_membership]] |
- | | groupid | varchar(64) | NO | UNI | | | | + | - [[mdl_modlos_group_notice>./group_notice]] |
- | | name | varchar(255) | NO | UNI | | | | + | - [[mdl_modlos_group_role>./group_role]] |
- | | charter | longtext | NO | | NULL | | | + | - [[mdl_modlos_group_rolemembership>./group_rolemembership]] |
- | | insigniaid | varchar(64) | NO | | | | | + | #br |
- | | 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 | | | | | + | |
- | +----------------+--------------+------+-----+---------+----------------+ | + | |
- | | + | |
- | MariaDB [moodle_db]> show columns from mdl_modlos_group_membership; | + | |
- | +----------------+-------------+------+-----+---------+----------------+ | + | |
- | | Field | Type | Null | Key | Default | Extra | | + | |
- | +----------------+-------------+------+-----+---------+----------------+ | + | |
- | | id | bigint(11) | NO | PRI | NULL | auto_increment | | + | |
- | | groupid | varchar(64) | NO | MUL | | | | + | |
- | | agentid | varchar(64) | NO | | | | | + | |
- | | selectedroleid | varchar(64) | NO | | | | | + | |
- | | contribution | bigint(11) | NO | | 0 | | | + | |
- | | listinprofile | bigint(11) | NO | | 1 | | | + | |
- | | acceptnotices | bigint(11) | NO | | 1 | | | + | |
- | +----------------+-------------+------+-----+---------+----------------+ | + | |