1: 2016-04-29 (金) 17:43:42 iseki  |
2: 2016-04-29 (金) 18:49:38 iseki |
| - | * DB of Flotsam Group Function [#bb669970] | + | ** DB of Flotsam Group Function [#bb669970] |
| | + | |
| | + | *** Tbales [#c81bd2bf] |
| | + | - [[group_list>./group_list]] |
| | + | - [[group_active>./group_active]] |
| | + | - [[group_invite>./group_invite]] |
| | + | - [[group_membership>./group_membership]] |
| | + | - [[group_notice>./group_notice]] |
| | + | - [[group_role>./group_role]] |
| | + | - [[group_rolemembership>./group_rolemembership]] |
| | + | #br |
| | | | |
| | *** Modlos [#j706cb8f] | | *** Modlos [#j706cb8f] |
| | + | **** tables [#k5acf0e7] |
| | | mdl_modlos_group_active | | | | mdl_modlos_group_active | |
| | | mdl_modlos_group_invite | | | | mdl_modlos_group_invite | |
| | | mdl_modlos_group_role | | | | mdl_modlos_group_role | |
| | | mdl_modlos_group_rolemembership | | | | mdl_modlos_group_rolemembership | |
| | + | |
| | + | #br |
| | + | |
| | + | **** columns [#ya58c869] |
| | + | 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_active; | | MariaDB [moodle_db]> show columns from mdl_modlos_group_active; |
| | | tmstamp | bigint(11) | NO | | NULL | | | | | 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; | | MariaDB [moodle_db]> show columns from mdl_modlos_group_membership; |
| | | acceptnotices | bigint(11) | NO | | 1 | | | | | acceptnotices | bigint(11) | NO | | 1 | | |
| | +----------------+-------------+------+-----+---------+----------------+ | | +----------------+-------------+------+-----+---------+----------------+ |
| | + | |
| | + | MariaDB [moodle_db]> show columns from mdl_modlos_group_notice; |
| | + | +--------------+--------------+------+-----+---------+----------------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +--------------+--------------+------+-----+---------+----------------+ |
| | + | | id | bigint(11) | NO | PRI | NULL | auto_increment | |
| | + | | groupid | varchar(64) | NO | MUL | | | |
| | + | | noticeid | varchar(64) | NO | | | | |
| | + | | timestamp | bigint(11) | NO | MUL | 0 | | |
| | + | | fromname | varchar(255) | NO | | | | |
| | + | | subject | varchar(255) | NO | | | | |
| | + | | message | longtext | NO | | NULL | | |
| | + | | binarybucket | longblob | NO | | NULL | | |
| | + | +--------------+--------------+------+-----+---------+----------------+ |
| | + | |
| | + | MariaDB [moodle_db]> show columns from mdl_modlos_group_role; |
| | + | +-------------+--------------+------+-----+---------+----------------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +-------------+--------------+------+-----+---------+----------------+ |
| | + | | id | bigint(11) | NO | PRI | NULL | auto_increment | |
| | + | | groupid | varchar(64) | NO | MUL | | | |
| | + | | roleid | varchar(64) | NO | | | | |
| | + | | name | varchar(255) | NO | | | | |
| | + | | description | varchar(255) | NO | | | | |
| | + | | title | varchar(255) | NO | | | | |
| | + | | powers | bigint(20) | NO | | 0 | | |
| | + | +-------------+--------------+------+-----+---------+----------------+ |
| | + | |
| | + | MariaDB [moodle_db]> show columns from mdl_modlos_group_rolemembership; |
| | + | +---------+-------------+------+-----+---------+----------------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +---------+-------------+------+-----+---------+----------------+ |
| | + | | id | bigint(11) | NO | PRI | NULL | auto_increment | |
| | + | | groupid | varchar(64) | NO | MUL | | | |
| | + | | roleid | varchar(64) | NO | | | | |
| | + | | agentid | varchar(64) | NO | | | | |
| | + | +---------+-------------+------+-----+---------+----------------+ |
