|
1: 2016-04-29 (金) 17:43:42 iseki |
| + | * DB of Flotsam Group Function [#bb669970] |
| | | |
| + | *** Modlos [#j706cb8f] |
| + | | 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; |
| + | +---------------+-------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +---------------+-------------+------+-----+---------+----------------+ |
| + | | id | bigint(11) | NO | PRI | NULL | auto_increment | |
| + | | agentid | varchar(64) | NO | UNI | | | |
| + | | activegroupid | varchar(64) | NO | | | | |
| + | +---------------+-------------+------+-----+---------+----------------+ |
| + | |
| + | MariaDB [moodle_db]> show columns from mdl_modlos_group_invite; |
| + | +----------+-------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +----------+-------------+------+-----+---------+----------------+ |
| + | | id | bigint(11) | NO | PRI | NULL | auto_increment | |
| + | | inviteid | varchar(64) | NO | UNI | | | |
| + | | groupid | varchar(64) | NO | MUL | | | |
| + | | roleid | varchar(64) | YES | | NULL | | |
| + | | agentid | varchar(64) | NO | | | | |
| + | | tmstamp | bigint(11) | NO | | NULL | | |
| + | +----------+-------------+------+-----+---------+----------------+ |
| + | |
| + | MariaDB [moodle_db]> show columns from mdl_modlos_group_list ; |
| + | +----------------+--------------+------+-----+---------+----------------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +----------------+--------------+------+-----+---------+----------------+ |
| + | | id | bigint(11) | NO | PRI | NULL | auto_increment | |
| + | | groupid | varchar(64) | NO | UNI | | | |
| + | | 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 | | | | |
| + | +----------------+--------------+------+-----+---------+----------------+ |
| + | |
| + | 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 | | |
| + | +----------------+-------------+------+-----+---------+----------------+ |