Database

Databases

The standard mysql database of the ilias system is used to store the information of the plugin.

Related entries with the plugin

The following statements can be used to find all pugin related database entries:

SELECT * FROM ilias.qpl_qst_type it WHERE it.type_tag = 'assProgQuestion';
SELECT * FROM ilias.il_plugin ip WHERE ip.name = 'assProgQuestion';
SELECT * FROM ilias.il_qpl_qst_prog_config;
SELECT * FROM ilias.il_qpl_qst_prog_quest;
SELECT * FROM ilias.il_qpl_qst_prog_params;
SELECT * FROM ilias.il_qpl_qst_prog_params_seq

Update the database when the plugin evolves

If you develop your plugin the version number has to be increased every time you change the code. When the Version number increases, the plugin is automatically deactivated. To activate the plugin you have to go to the administration tab and explicitly update the proposals. This triggers a process where all steps from the dbupdate.php are executed that were not executed in the last version. The information which dpupdate steps for which version were executed is stored in the ilias.il_plugin table.