|
1: 2014-05-14 (水) 16:47:02 iseki  |
| | + | ** Moodle 2.7 [#v4e64b97] |
| | + | *** Log [#bef0ca17] |
| | + | - mdl_logstore_standard_log |
| | + | MariaDB [moodle_db]> show columns from mdl_logstore_standard_log; |
| | + | +-------------------+--------------+------+-----+---------+----------------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +-------------------+--------------+------+-----+---------+----------------+ |
| | + | | id | bigint(10) | NO | PRI | NULL | auto_increment | |
| | + | | eventname | varchar(255) | NO | | | | |
| | + | | component | varchar(100) | NO | | | | |
| | + | | action | varchar(100) | NO | | | | |
| | + | | target | varchar(100) | NO | | | | |
| | + | | objecttable | varchar(50) | YES | | NULL | | |
| | + | | objectid | bigint(10) | YES | | NULL | | |
| | + | | crud | varchar(1) | NO | | | | |
| | + | | edulevel | tinyint(1) | NO | | NULL | | |
| | + | | contextid | bigint(10) | NO | | NULL | | |
| | + | | contextlevel | bigint(10) | NO | | NULL | | |
| | + | | contextinstanceid | bigint(10) | NO | | NULL | | |
| | + | | userid | bigint(10) | NO | MUL | NULL | | |
| | + | | courseid | bigint(10) | YES | MUL | NULL | | |
| | + | | relateduserid | bigint(10) | YES | | NULL | | |
| | + | | anonymous | tinyint(1) | NO | | 0 | | |
| | + | | other | longtext | YES | | NULL | | |
| | + | | timecreated | bigint(10) | NO | MUL | NULL | | |
| | + | | origin | varchar(10) | YES | | NULL | | |
| | + | | ip | varchar(45) | YES | | NULL | | |
| | + | | realuserid | bigint(10) | YES | | NULL | | |
| | + | +-------------------+--------------+------+-----+---------+----------------+ |
| | + | 21 rows in set (0.00 sec) |
