8: 2021-09-02 (Thu) 14:43:53 iseki  |
9: 2021-09-05 (Sun) 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 |
