|
1: 2016-04-29 (Fri) 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 | | |
| | + | +----------------+-------------+------+-----+---------+----------------+ |
