8: 2021-09-02 (木) 14:43:53 iseki |
9: 2021-09-05 (日) 00:21:40 iseki |
| - mdl_prs_[volume name] = | | - mdl_prs_[volume name] = |
| | | |
| + | - (mdl_grname=) |
| + | - (mdl_option=) |
| - (mdl_sessioninfo=) | | - (mdl_sessioninfo=) |
| + | - (mdl_iframe=) |
| #br | | #br |
| | | |
| | | |
| *** LTI Module of Moodle [#s5023ba8] | | *** LTI Module of Moodle [#s5023ba8] |
- | **** DB [#vf633496] | + | - [[LTI]] |
- | MariaDB [moodle_db]> show columns from mdl_lti; | + | |
- | +-------------------------------+--------------+------+-----+---------+----------------+ | + | |
- | | Field | Type | Null | Key | Default | Extra | | + | |
- | +-------------------------------+--------------+------+-----+---------+----------------+ | + | |
- | | id | bigint(10) | NO | PRI | NULL | auto_increment | | + | |
- | | course | bigint(10) | NO | MUL | 0 | | | + | |
- | | name | varchar(255) | NO | | | | | + | |
- | | intro | longtext | YES | | NULL | | | + | |
- | | introformat | smallint(4) | YES | | 0 | | | + | |
- | | timecreated | bigint(10) | NO | | 0 | | | + | |
- | | timemodified | bigint(10) | NO | | 0 | | | + | |
- | | typeid | bigint(10) | YES | | NULL | | | + | |
- | | toolurl | longtext | NO | | NULL | | | + | |
- | | securetoolurl | longtext | YES | | NULL | | | + | |
- | | instructorchoicesendname | tinyint(1) | YES | | NULL | | | + | |
- | | instructorchoicesendemailaddr | tinyint(1) | YES | | NULL | | | + | |
- | | instructorchoiceallowroster | tinyint(1) | YES | | NULL | | | + | |
- | | instructorchoiceallowsetting | tinyint(1) | YES | | NULL | | | + | |
- | | instructorcustomparameters | longtext | YES | | NULL | | | + | |
- | | instructorchoiceacceptgrades | tinyint(1) | YES | | NULL | | | + | |
- | | grade | bigint(10) | NO | | 100 | | | + | |
- | | launchcontainer | tinyint(2) | NO | | 1 | | | + | |
- | | resourcekey | varchar(255) | YES | | NULL | | | + | |
- | | password | varchar(255) | YES | | NULL | | | + | |
- | | debuglaunch | tinyint(1) | NO | | 0 | | | + | |
- | | showtitlelaunch | tinyint(1) | NO | | 0 | | | + | |
- | | showdescriptionlaunch | tinyint(1) | NO | | 0 | | | + | |
- | | servicesalt | varchar(40) | YES | | NULL | | | + | |
- | | icon | longtext | YES | | NULL | | | + | |
- | | secureicon | longtext | YES | | NULL | | | + | |
- | +-------------------------------+--------------+------+-----+---------+----------------+ | + | |
- | | + | |
- | - select id,course,name,instructorcustomparameters from mdl_lti; | + | |
| #br | | #br |