Quick Navigation
×
Moodle 4.0 XRef and Diffs
Home
Quick Navigation
Moodle 4.0
Classes
Functions
Variables
Constants
Namespaces
Statistics
Moodle 4.0 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.0.x will end 8 May 2023 (12 months).
Bug fixes for security issues in 4.0.x will end 13 November 2023 (18 months).
PHP version: minimum PHP 7.3.0 Note: the minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is also supported.
Moodle 4.0 Database Schema (by Marcus Green)
dbtype
[
Top level directory
]
Variable Cross Reference
at:
/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/ddl/database_manager.php
->
line 1023
/lib/xhprof/xhprof_moodle.php
->
line 681
/lib/adodb/adodb.inc.php
->
line 1727
/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/ddl/mysql_sql_generator.php
->
line 407
/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 420
/lib/ddl/mysql_sql_generator.php
->
line 430
/lib/ddl/mysql_sql_generator.php
->
line 433
/lib/ddl/mysql_sql_generator.php
->
line 447
/lib/ddl/mysql_sql_generator.php
->
line 460
/lib/ddl/mysql_sql_generator.php
->
line 469
/lib/ddl/mysql_sql_generator.php
->
line 472
/lib/testing/classes/util.php
->
line 1121
/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
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 163
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 171
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 179
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 187
/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
/lib/phpunit/classes/database_driver_testcase.php
->
line 84
/lib/classes/lock/lock_config.php
->
line 60
/admin/tool/dbtransfer/locallib.php
->
line 141
Referenced 174 times:
/lib/dml/tests/dml_test.php
->
line 5527
/lib/dml/tests/dml_test.php
->
line 5574
/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/store_test.php
->
line 65
/lib/ddl/database_manager.php
->
line 1023
/lib/ddl/database_manager.php
->
line 1028
/lib/ddl/database_manager.php
->
line 1042
/lib/xhprof/xhprof_moodle.php
->
line 681
/lib/xhprof/xhprof_moodle.php
->
line 681
/lib/xhprof/xhprof_moodle.php
->
line 697
/auth/db/settings.php
->
line 49
/auth/db/settings.php
->
line 50
/auth/db/settings.php
->
line 50
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 86
/lib/adodb/adodb.inc.php
->
line 1727
/lib/adodb/adodb.inc.php
->
line 1728
/lib/adodb/adodb.inc.php
->
line 1732
/lib/adodb/adodb.inc.php
->
line 1732
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 60
/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/phpunit/bootstrap.php
->
line 167
/lib/phpunit/bootstrap.php
->
line 167
/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
/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/mysql_sql_generator.php
->
line 407
/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 420
/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 430
/lib/ddl/mysql_sql_generator.php
->
line 433
/lib/ddl/mysql_sql_generator.php
->
line 437
/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 447
/lib/ddl/mysql_sql_generator.php
->
line 451
/lib/ddl/mysql_sql_generator.php
->
line 454
/lib/ddl/mysql_sql_generator.php
->
line 456
/lib/ddl/mysql_sql_generator.php
->
line 460
/lib/ddl/mysql_sql_generator.php
->
line 463
/lib/ddl/mysql_sql_generator.php
->
line 465
/lib/ddl/mysql_sql_generator.php
->
line 469
/lib/ddl/mysql_sql_generator.php
->
line 472
/lib/ddl/mysql_sql_generator.php
->
line 474
/lib/testing/classes/util.php
->
line 1121
/lib/testing/classes/util.php
->
line 1121
/lib/testing/classes/util.php
->
line 1124
/lib/behat/lib.php
->
line 389
/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/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
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 163
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 166
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 167
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 171
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 174
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 175
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 179
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 182
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 183
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 187
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 190
/mod/lti/service/gradebookservices/backup/moodle2/restore_ltiservice_gradebookservices_subplugin.class.php
->
line 191
/.github/workflows/config-template.php
->
line 32
/question/engine/tests/questionusage_autosave_test.php
->
line 451
/question/engine/tests/questionusage_autosave_test.php
->
line 522
/lang/en/admin.php
->
line 604
/lib/dml/moodle_database.php
->
line 264
/lib/setuplib.php
->
line 846
/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/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
/config-dist.php
->
line 41
/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/phpunit/classes/database_driver_testcase.php
->
line 84
/lib/phpunit/classes/database_driver_testcase.php
->
line 92
/lib/classes/lock/lock_config.php
->
line 60
/lib/classes/lock/lock_config.php
->
line 63
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 141
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 199
/lib/tests/performance/filtersettingsperformancetester.php
->
line 54
/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/tests/ddl_test.php
->
line 1819
/admin/tool/dbtransfer/lang/en/tool_dbtransfer.php
->
line 42
/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