#author("2023-08-29T03:37:50+00:00","default:iseki","iseki")
** Recycle Bin (Moodle) [#r5481c38]
- Moodle のごみ箱機能
*** DB [#hb78048e]
MariaDB [moodle_db]> show columns from mdl_tool_recyclebin_course;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| courseid | bigint(10) | NO | MUL | NULL | |
| section | bigint(10) | NO | | NULL | |
| module | bigint(10) | NO | | NULL | |
| name | varchar(255) | YES | | NULL | |
| timecreated | bigint(10) | NO | MUL | 0 | |
+-------------+--------------+------+-----+---------+----------------+
6 rows in set (0.000 sec)
MariaDB [moodle_db]> select * from mdl_tool_recyclebin_course;
+-----+----------+---------+--------+--------------------+-------------+
| id | courseid | section | module | name | timecreated |
+-----+----------+---------+--------+--------------------+-------------+
| 166 | 200 | 7097 | 9 | 説明用 | 1650873328 |
| 171 | 199 | 7085 | 9 | 変数、代入、演算 | 1650888302 |
| 172 | 98 | 1447 | 15 | 222222 | 1650930602 |
+-----+----------+---------+--------+--------------------+-------------+
4 rows in set (0.000 sec)