Quick Navigation
×
Moodle 4.2 XRef and Diffs
Home
Quick Navigation
Moodle 4.2
Classes
Functions
Variables
Constants
Namespaces
Statistics
Moodle 4.2 Database Schema
Versions
Moodle 4.3
Moodle 4.2
Moodle 4.1
Moodle 4.0
Moodle 3.11
Moodle 3.10
Moodle 3.9
Classes
Functions
Variables
Constants
Tables
Namespaces
Search
Search moodle.org's
Developer Documentation
Search
See Release Notes
Bug fixes for general core bugs in 4.2.x will end 22 April 2024 (12 months).
Bug fixes for security issues in 4.2.x will end 7 October 2024 (18 months).
PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.1.x is supported too.
Moodle 4.2 Database Schema (by Marcus Green)
dbtype
[
Top level directory
]
Variable Cross Reference
at:
/admin/tool/dbtransfer/locallib.php
->
line 141
/lib/ddl/postgres_sql_generator.php
->
line 153
/lib/ddl/postgres_sql_generator.php
->
line 155
/lib/ddl/postgres_sql_generator.php
->
line 157
/lib/ddl/postgres_sql_generator.php
->
line 161
/lib/ddl/postgres_sql_generator.php
->
line 171
/lib/ddl/postgres_sql_generator.php
->
line 174
/lib/ddl/postgres_sql_generator.php
->
line 179
/lib/ddl/postgres_sql_generator.php
->
line 186
/lib/ddl/postgres_sql_generator.php
->
line 189
/lib/ddl/postgres_sql_generator.php
->
line 192
/lib/phpunit/classes/database_driver_testcase.php
->
line 84
/lib/ddl/mssql_sql_generator.php
->
line 202
/lib/ddl/mssql_sql_generator.php
->
line 204
/lib/ddl/mssql_sql_generator.php
->
line 206
/lib/ddl/mssql_sql_generator.php
->
line 210
/lib/ddl/mssql_sql_generator.php
->
line 220
/lib/ddl/mssql_sql_generator.php
->
line 223
/lib/ddl/mssql_sql_generator.php
->
line 228
/lib/ddl/mssql_sql_generator.php
->
line 235
/lib/ddl/mssql_sql_generator.php
->
line 238
/lib/ddl/mssql_sql_generator.php
->
line 241
/lib/ddl/mysql_sql_generator.php
->
line 409
/lib/ddl/mysql_sql_generator.php
->
line 411
/lib/ddl/mysql_sql_generator.php
->
line 413
/lib/ddl/mysql_sql_generator.php
->
line 415
/lib/ddl/mysql_sql_generator.php
->
line 417
/lib/ddl/mysql_sql_generator.php
->
line 422
/lib/ddl/mysql_sql_generator.php
->
line 432
/lib/ddl/mysql_sql_generator.php
->
line 435
/lib/ddl/mysql_sql_generator.php
->
line 449
/lib/ddl/mysql_sql_generator.php
->
line 462
/lib/ddl/mysql_sql_generator.php
->
line 471
/lib/ddl/mysql_sql_generator.php
->
line 474
/lib/testing/classes/util.php
->
line 1060
/lib/xhprof/xhprof_moodle.php
->
line 681
/lib/ddl/database_manager.php
->
line 1023
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 165
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 173
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 181
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 189
/lib/classes/lock/lock_config.php
->
line 60
/lib/ddl/sqlite_sql_generator.php
->
line 150
/lib/ddl/sqlite_sql_generator.php
->
line 153
/lib/ddl/sqlite_sql_generator.php
->
line 163
/lib/ddl/sqlite_sql_generator.php
->
line 173
/lib/ddl/sqlite_sql_generator.php
->
line 180
/lib/ddl/sqlite_sql_generator.php
->
line 183
/lib/ddl/sqlite_sql_generator.php
->
line 186
/lib/adodb/adodb.inc.php
->
line 2031
/lib/ddl/oracle_sql_generator.php
->
line 233
/lib/ddl/oracle_sql_generator.php
->
line 237
/lib/ddl/oracle_sql_generator.php
->
line 250
/lib/ddl/oracle_sql_generator.php
->
line 257
/lib/ddl/oracle_sql_generator.php
->
line 260
/lib/ddl/oracle_sql_generator.php
->
line 263
Referenced 180 times:
/admin/tool/log/store/database/classes/log/store.php
->
line 80
/admin/tool/log/store/database/classes/log/store.php
->
line 82
/admin/tool/log/store/database/classes/log/store.php
->
line 83
/lib/tests/hub/registration_test.php
->
line 49
/question/engine/tests/questionusage_autosave_test.php
->
line 451
/question/engine/tests/questionusage_autosave_test.php
->
line 522
/admin/tool/dbtransfer/cli/migrate.php
->
line 97
/admin/tool/dbtransfer/cli/migrate.php
->
line 98
/admin/tool/dbtransfer/cli/migrate.php
->
line 98
/admin/tool/dbtransfer/cli/migrate.php
->
line 107
/admin/tool/dbtransfer/cli/migrate.php
->
line 108
/admin/tool/dbtransfer/cli/migrate.php
->
line 155
/admin/tool/dbtransfer/locallib.php
->
line 141
/admin/tool/dbtransfer/locallib.php
->
line 144
/admin/tool/dbtransfer/locallib.php
->
line 149
/admin/tool/dbtransfer/locallib.php
->
line 154
/lib/ddl/postgres_sql_generator.php
->
line 153
/lib/ddl/postgres_sql_generator.php
->
line 155
/lib/ddl/postgres_sql_generator.php
->
line 157
/lib/ddl/postgres_sql_generator.php
->
line 161
/lib/ddl/postgres_sql_generator.php
->
line 163
/lib/ddl/postgres_sql_generator.php
->
line 165
/lib/ddl/postgres_sql_generator.php
->
line 167
/lib/ddl/postgres_sql_generator.php
->
line 171
/lib/ddl/postgres_sql_generator.php
->
line 174
/lib/ddl/postgres_sql_generator.php
->
line 179
/lib/ddl/postgres_sql_generator.php
->
line 183
/lib/ddl/postgres_sql_generator.php
->
line 186
/lib/ddl/postgres_sql_generator.php
->
line 189
/lib/ddl/postgres_sql_generator.php
->
line 192
/lib/ddl/postgres_sql_generator.php
->
line 195
/admin/tool/dbtransfer/index.php
->
line 40
/admin/tool/dbtransfer/index.php
->
line 41
/admin/tool/dbtransfer/index.php
->
line 70
/admin/tool/dbtransfer/index.php
->
line 70
/admin/tool/dbtransfer/index.php
->
line 71
/lib/phpunit/classes/database_driver_testcase.php
->
line 84
/lib/phpunit/classes/database_driver_testcase.php
->
line 92
/admin/tool/dbtransfer/lang/en/tool_dbtransfer.php
->
line 42
/lib/behat/lib.php
->
line 389
/lib/classes/hub/registration.php
->
line 185
/.github/workflows/config-template.php
->
line 32
/lib/phpunit/bootstrap.php
->
line 167
/lib/phpunit/bootstrap.php
->
line 167
/lang/en/admin.php
->
line 641
/lib/ddl/tests/ddl_test.php
->
line 1819
/lib/ddl/mssql_sql_generator.php
->
line 202
/lib/ddl/mssql_sql_generator.php
->
line 204
/lib/ddl/mssql_sql_generator.php
->
line 206
/lib/ddl/mssql_sql_generator.php
->
line 210
/lib/ddl/mssql_sql_generator.php
->
line 212
/lib/ddl/mssql_sql_generator.php
->
line 214
/lib/ddl/mssql_sql_generator.php
->
line 216
/lib/ddl/mssql_sql_generator.php
->
line 220
/lib/ddl/mssql_sql_generator.php
->
line 223
/lib/ddl/mssql_sql_generator.php
->
line 228
/lib/ddl/mssql_sql_generator.php
->
line 232
/lib/ddl/mssql_sql_generator.php
->
line 235
/lib/ddl/mssql_sql_generator.php
->
line 238
/lib/ddl/mssql_sql_generator.php
->
line 241
/lib/ddl/mssql_sql_generator.php
->
line 244
/admin/tool/log/store/database/test_settings.php
->
line 46
/admin/tool/log/store/database/test_settings.php
->
line 47
/admin/tool/log/store/database/test_settings.php
->
line 48
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 90
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 161
/lib/setuplib.php
->
line 830
/mod/quiz/report/statistics/tests/test_quiz_statistics_report.php
->
line 64
/lib/dml/moodle_database.php
->
line 268
/admin/cli/install.php
->
line 245
/admin/cli/install.php
->
line 245
/admin/cli/install.php
->
line 516
/admin/cli/install.php
->
line 523
/admin/cli/install.php
->
line 525
/lib/ddl/mysql_sql_generator.php
->
line 409
/lib/ddl/mysql_sql_generator.php
->
line 411
/lib/ddl/mysql_sql_generator.php
->
line 413
/lib/ddl/mysql_sql_generator.php
->
line 415
/lib/ddl/mysql_sql_generator.php
->
line 417
/lib/ddl/mysql_sql_generator.php
->
line 419
/lib/ddl/mysql_sql_generator.php
->
line 422
/lib/ddl/mysql_sql_generator.php
->
line 424
/lib/ddl/mysql_sql_generator.php
->
line 426
/lib/ddl/mysql_sql_generator.php
->
line 428
/lib/ddl/mysql_sql_generator.php
->
line 432
/lib/ddl/mysql_sql_generator.php
->
line 435
/lib/ddl/mysql_sql_generator.php
->
line 439
/lib/ddl/mysql_sql_generator.php
->
line 441
/lib/ddl/mysql_sql_generator.php
->
line 443
/lib/ddl/mysql_sql_generator.php
->
line 445
/lib/ddl/mysql_sql_generator.php
->
line 449
/lib/ddl/mysql_sql_generator.php
->
line 453
/lib/ddl/mysql_sql_generator.php
->
line 456
/lib/ddl/mysql_sql_generator.php
->
line 458
/lib/ddl/mysql_sql_generator.php
->
line 462
/lib/ddl/mysql_sql_generator.php
->
line 465
/lib/ddl/mysql_sql_generator.php
->
line 467
/lib/ddl/mysql_sql_generator.php
->
line 471
/lib/ddl/mysql_sql_generator.php
->
line 474
/lib/ddl/mysql_sql_generator.php
->
line 476
/lib/testing/classes/util.php
->
line 1060
/lib/testing/classes/util.php
->
line 1060
/lib/testing/classes/util.php
->
line 1063
/lib/xhprof/xhprof_moodle.php
->
line 681
/lib/xhprof/xhprof_moodle.php
->
line 681
/lib/xhprof/xhprof_moodle.php
->
line 697
/lib/ddl/database_manager.php
->
line 1023
/lib/ddl/database_manager.php
->
line 1028
/lib/ddl/database_manager.php
->
line 1042
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 165
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 168
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 169
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 173
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 176
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 177
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 181
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 184
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 185
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 189
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 192
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 193
/lib/dmllib.php
->
line 312
/lib/dmllib.php
->
line 314
/lib/dmllib.php
->
line 318
/lib/dmllib.php
->
line 322
/lib/dmllib.php
->
line 335
/lib/dmllib.php
->
line 336
/lib/tests/performance/filtersettingsperformancetester.php
->
line 54
/lib/classes/lock/lock_config.php
->
line 60
/lib/classes/lock/lock_config.php
->
line 63
/admin/tool/log/store/database/tests/store_test.php
->
line 65
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 153
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 222
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 280
/install.php
->
line 112
/install.php
->
line 122
/install.php
->
line 142
/install.php
->
line 142
/install.php
->
line 280
/install.php
->
line 372
/install.php
->
line 398
/install.php
->
line 416
/lib/ddl/sqlite_sql_generator.php
->
line 150
/lib/ddl/sqlite_sql_generator.php
->
line 153
/lib/ddl/sqlite_sql_generator.php
->
line 155
/lib/ddl/sqlite_sql_generator.php
->
line 157
/lib/ddl/sqlite_sql_generator.php
->
line 159
/lib/ddl/sqlite_sql_generator.php
->
line 163
/lib/ddl/sqlite_sql_generator.php
->
line 165
/lib/ddl/sqlite_sql_generator.php
->
line 167
/lib/ddl/sqlite_sql_generator.php
->
line 169
/lib/ddl/sqlite_sql_generator.php
->
line 173
/lib/ddl/sqlite_sql_generator.php
->
line 177
/lib/ddl/sqlite_sql_generator.php
->
line 180
/lib/ddl/sqlite_sql_generator.php
->
line 183
/lib/ddl/sqlite_sql_generator.php
->
line 186
/lib/ddl/sqlite_sql_generator.php
->
line 189
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 60
/config-dist.php
->
line 41
/lib/adodb/adodb.inc.php
->
line 2031
/lib/adodb/adodb.inc.php
->
line 2032
/lib/adodb/adodb.inc.php
->
line 2036
/lib/adodb/adodb.inc.php
->
line 2036
/auth/db/settings.php
->
line 49
/auth/db/settings.php
->
line 50
/auth/db/settings.php
->
line 50
/lib/dml/tests/dml_test.php
->
line 5639
/lib/dml/tests/dml_test.php
->
line 5686
/lib/dml/tests/dml_test.php
->
line 6342
/lib/ddl/oracle_sql_generator.php
->
line 233
/lib/ddl/oracle_sql_generator.php
->
line 237
/lib/ddl/oracle_sql_generator.php
->
line 239
/lib/ddl/oracle_sql_generator.php
->
line 241
/lib/ddl/oracle_sql_generator.php
->
line 243
/lib/ddl/oracle_sql_generator.php
->
line 250
/lib/ddl/oracle_sql_generator.php
->
line 254
/lib/ddl/oracle_sql_generator.php
->
line 257
/lib/ddl/oracle_sql_generator.php
->
line 260
/lib/ddl/oracle_sql_generator.php
->
line 263
/lib/ddl/oracle_sql_generator.php
->
line 266