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)
dboptions
[
Top level directory
]
Variable Cross Reference
at:
/admin/tool/log/store/database/classes/log/store.php
->
line 88
/lib/dml/pgsql_native_moodle_database.php
->
line 135
/lib/dml/pdo_moodle_database.php
->
line 62
/admin/tool/dbtransfer/cli/migrate.php
->
line 163
/admin/tool/dbtransfer/index.php
->
line 42
/lib/dml/sqlsrv_native_moodle_database.php
->
line 190
/lib/dml/oci_native_moodle_database.php
->
line 134
/lib/phpunit/classes/database_driver_testcase.php
->
line 90
/lib/dml/moodle_read_slave_trait.php
->
line 133
/lib/dml/moodle_read_slave_trait.php
->
line 148
/admin/tool/log/store/database/test_settings.php
->
line 58
/lib/dml/moodle_database.php
->
line 304
/lib/dml/moodle_database.php
->
line 316
/lib/dml/moodle_database.php
->
line 376
/lib/dml/sqlite3_pdo_moodle_database.php
->
line 89
/lib/dml/tests/pgsql_native_recordset_test.php
->
line 68
/lib/dml/mysqli_native_moodle_database.php
->
line 62
/lib/dml/mysqli_native_moodle_database.php
->
line 541
/lib/dml/tests/dml_read_slave_test.php
->
line 70
/lib/dml/tests/fixtures/read_slave_moodle_database.php
->
line 57
/auth/db/settings.php
->
line 44
/lib/dml/tests/dml_test.php
->
line 6376
Referenced 278 times:
/admin/tool/log/store/database/classes/log/store.php
->
line 88
/admin/tool/log/store/database/classes/log/store.php
->
line 89
/admin/tool/log/store/database/classes/log/store.php
->
line 90
/admin/tool/log/store/database/classes/log/store.php
->
line 91
/admin/tool/log/store/database/classes/log/store.php
->
line 92
/admin/tool/log/store/database/classes/log/store.php
->
line 93
/admin/tool/log/store/database/classes/log/store.php
->
line 94
/admin/tool/log/store/database/classes/log/store.php
->
line 97
/lib/dml/pgsql_native_moodle_database.php
->
line 135
/lib/dml/pgsql_native_moodle_database.php
->
line 147
/lib/dml/pgsql_native_moodle_database.php
->
line 152
/lib/dml/pgsql_native_moodle_database.php
->
line 154
/lib/dml/pgsql_native_moodle_database.php
->
line 156
/lib/dml/pgsql_native_moodle_database.php
->
line 158
/lib/dml/pgsql_native_moodle_database.php
->
line 160
/lib/dml/pgsql_native_moodle_database.php
->
line 163
/lib/dml/pgsql_native_moodle_database.php
->
line 167
/lib/dml/pgsql_native_moodle_database.php
->
line 170
/lib/dml/pgsql_native_moodle_database.php
->
line 175
/lib/dml/pgsql_native_moodle_database.php
->
line 176
/lib/dml/pgsql_native_moodle_database.php
->
line 179
/lib/dml/pgsql_native_moodle_database.php
->
line 183
/lib/dml/pgsql_native_moodle_database.php
->
line 184
/lib/dml/pgsql_native_moodle_database.php
->
line 196
/lib/dml/pgsql_native_moodle_database.php
->
line 214
/lib/dml/pgsql_native_moodle_database.php
->
line 225
/lib/dml/pgsql_native_moodle_database.php
->
line 229
/lib/dml/pgsql_native_moodle_database.php
->
line 920
/lib/dml/pgsql_native_moodle_database.php
->
line 921
/lib/dml/pgsql_native_moodle_database.php
->
line 1209
/lib/dml/pgsql_native_moodle_database.php
->
line 1210
/lib/dml/pdo_moodle_database.php
->
line 62
/lib/dml/pdo_moodle_database.php
->
line 69
/lib/dml/pdo_moodle_database.php
->
line 97
/question/engine/tests/questionusage_autosave_test.php
->
line 448
/question/engine/tests/questionusage_autosave_test.php
->
line 449
/question/engine/tests/questionusage_autosave_test.php
->
line 452
/question/engine/tests/questionusage_autosave_test.php
->
line 519
/question/engine/tests/questionusage_autosave_test.php
->
line 520
/question/engine/tests/questionusage_autosave_test.php
->
line 523
/lib/installlib.php
->
line 181
/lib/installlib.php
->
line 187
/lib/installlib.php
->
line 190
/lib/installlib.php
->
line 191
/admin/tool/dbtransfer/cli/migrate.php
->
line 163
/admin/tool/dbtransfer/cli/migrate.php
->
line 165
/admin/tool/dbtransfer/cli/migrate.php
->
line 168
/admin/tool/dbtransfer/cli/migrate.php
->
line 172
/admin/tool/dbtransfer/index.php
->
line 42
/admin/tool/dbtransfer/index.php
->
line 44
/admin/tool/dbtransfer/index.php
->
line 47
/admin/tool/dbtransfer/index.php
->
line 50
/lib/dml/sqlsrv_native_moodle_database.php
->
line 190
/lib/dml/sqlsrv_native_moodle_database.php
->
line 209
/lib/dml/sqlsrv_native_moodle_database.php
->
line 217
/lib/dml/sqlsrv_native_moodle_database.php
->
line 222
/lib/dml/sqlsrv_native_moodle_database.php
->
line 223
/lib/dml/sqlsrv_native_moodle_database.php
->
line 228
/lib/dml/sqlsrv_native_moodle_database.php
->
line 229
/lib/dml/sqlsrv_native_moodle_database.php
->
line 1356
/lib/dml/sqlsrv_native_moodle_database.php
->
line 1358
/lib/dml/oci_native_moodle_database.php
->
line 134
/lib/dml/oci_native_moodle_database.php
->
line 157
/lib/dml/oci_native_moodle_database.php
->
line 158
/lib/dml/oci_native_moodle_database.php
->
line 167
/lib/dml/oci_native_moodle_database.php
->
line 168
/lib/dml/oci_native_moodle_database.php
->
line 170
/lib/dml/oci_native_moodle_database.php
->
line 174
/lib/phpunit/classes/database_driver_testcase.php
->
line 90
/lib/phpunit/classes/database_driver_testcase.php
->
line 99
/.github/workflows/config-template.php
->
line 39
/lib/phpunit/bootstrap.php
->
line 174
/lib/phpunit/bootstrap.php
->
line 174
/lib/ddl/tests/ddl_test.php
->
line 1816
/lib/ddl/tests/ddl_test.php
->
line 1817
/lib/ddl/tests/ddl_test.php
->
line 1820
/lib/dml/moodle_read_slave_trait.php
->
line 133
/lib/dml/moodle_read_slave_trait.php
->
line 148
/lib/dml/moodle_read_slave_trait.php
->
line 154
/lib/dml/moodle_read_slave_trait.php
->
line 156
/lib/dml/moodle_read_slave_trait.php
->
line 157
/lib/dml/moodle_read_slave_trait.php
->
line 159
/lib/dml/moodle_read_slave_trait.php
->
line 162
/lib/dml/moodle_read_slave_trait.php
->
line 163
/lib/dml/moodle_read_slave_trait.php
->
line 164
/lib/dml/moodle_read_slave_trait.php
->
line 175
/lib/dml/moodle_read_slave_trait.php
->
line 175
/lib/dml/moodle_read_slave_trait.php
->
line 196
/lib/dml/moodle_read_slave_trait.php
->
line 199
/admin/tool/log/store/database/test_settings.php
->
line 58
/admin/tool/log/store/database/test_settings.php
->
line 59
/admin/tool/log/store/database/test_settings.php
->
line 60
/admin/tool/log/store/database/test_settings.php
->
line 61
/admin/tool/log/store/database/test_settings.php
->
line 62
/admin/tool/log/store/database/test_settings.php
->
line 63
/admin/tool/log/store/database/test_settings.php
->
line 64
/admin/tool/log/store/database/test_settings.php
->
line 68
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 80
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 81
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 83
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 86
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 87
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 91
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 153
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 154
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 156
/lib/dml/tests/dml_mysqli_read_slave_test.php
->
line 162
/mod/quiz/report/statistics/tests/test_quiz_statistics_report.php
->
line 65
/lib/dml/moodle_database.php
->
line 89
/lib/dml/moodle_database.php
->
line 275
/lib/dml/moodle_database.php
->
line 276
/lib/dml/moodle_database.php
->
line 276
/lib/dml/moodle_database.php
->
line 304
/lib/dml/moodle_database.php
->
line 316
/lib/dml/moodle_database.php
->
line 322
/lib/dml/moodle_database.php
->
line 322
/lib/dml/moodle_database.php
->
line 376
/lib/dml/moodle_database.php
->
line 515
/lib/dml/moodle_database.php
->
line 516
/lib/dml/moodle_database.php
->
line 516
/lib/dml/moodle_database.php
->
line 517
/admin/cli/install.php
->
line 167
/admin/cli/install.php
->
line 584
/admin/cli/install.php
->
line 587
/admin/cli/install.php
->
line 589
/admin/cli/install.php
->
line 590
/admin/cli/install.php
->
line 595
/admin/cli/install.php
->
line 597
/admin/cli/install.php
->
line 601
/admin/cli/install.php
->
line 604
/admin/cli/install.php
->
line 636
/admin/cli/install.php
->
line 636
/admin/cli/install.php
->
line 640
/admin/cli/install.php
->
line 640
/admin/cli/install.php
->
line 645
/admin/cli/install.php
->
line 645
/analytics/classes/analysis.php
->
line 944
/analytics/classes/analysis.php
->
line 944
/analytics/classes/analysis.php
->
line 948
/enrol/database/tests/sync_test.php
->
line 65
/enrol/database/tests/sync_test.php
->
line 66
/enrol/database/tests/sync_test.php
->
line 75
/enrol/database/tests/sync_test.php
->
line 76
/enrol/database/tests/sync_test.php
->
line 92
/enrol/database/tests/sync_test.php
->
line 93
/enrol/database/tests/sync_test.php
->
line 97
/enrol/database/tests/sync_test.php
->
line 98
/enrol/database/tests/sync_test.php
->
line 99
/enrol/database/tests/sync_test.php
->
line 100
/enrol/database/tests/sync_test.php
->
line 101
/enrol/database/tests/sync_test.php
->
line 116
/enrol/database/tests/sync_test.php
->
line 117
/lib/dml/sqlite3_pdo_moodle_database.php
->
line 89
/lib/dml/sqlite3_pdo_moodle_database.php
->
line 121
/lib/dml/sqlite3_pdo_moodle_database.php
->
line 122
/lib/dml/tests/pgsql_native_recordset_test.php
->
line 68
/lib/dml/tests/pgsql_native_recordset_test.php
->
line 68
/lib/dml/tests/pgsql_native_recordset_test.php
->
line 69
/lib/dml/tests/pgsql_native_recordset_test.php
->
line 71
/lib/dml/mysqli_native_moodle_database.php
->
line 62
/lib/dml/mysqli_native_moodle_database.php
->
line 69
/lib/dml/mysqli_native_moodle_database.php
->
line 70
/lib/dml/mysqli_native_moodle_database.php
->
line 70
/lib/dml/mysqli_native_moodle_database.php
->
line 71
/lib/dml/mysqli_native_moodle_database.php
->
line 75
/lib/dml/mysqli_native_moodle_database.php
->
line 78
/lib/dml/mysqli_native_moodle_database.php
->
line 97
/lib/dml/mysqli_native_moodle_database.php
->
line 97
/lib/dml/mysqli_native_moodle_database.php
->
line 98
/lib/dml/mysqli_native_moodle_database.php
->
line 99
/lib/dml/mysqli_native_moodle_database.php
->
line 100
/lib/dml/mysqli_native_moodle_database.php
->
line 166
/lib/dml/mysqli_native_moodle_database.php
->
line 167
/lib/dml/mysqli_native_moodle_database.php
->
line 193
/lib/dml/mysqli_native_moodle_database.php
->
line 229
/lib/dml/mysqli_native_moodle_database.php
->
line 241
/lib/dml/mysqli_native_moodle_database.php
->
line 242
/lib/dml/mysqli_native_moodle_database.php
->
line 300
/lib/dml/mysqli_native_moodle_database.php
->
line 541
/lib/dml/mysqli_native_moodle_database.php
->
line 548
/lib/dml/mysqli_native_moodle_database.php
->
line 552
/lib/dml/mysqli_native_moodle_database.php
->
line 553
/lib/dml/mysqli_native_moodle_database.php
->
line 553
/lib/dml/mysqli_native_moodle_database.php
->
line 554
/lib/dml/mysqli_native_moodle_database.php
->
line 558
/lib/dml/mysqli_native_moodle_database.php
->
line 561
/lib/dml/mysqli_native_moodle_database.php
->
line 567
/lib/dml/mysqli_native_moodle_database.php
->
line 576
/lib/dml/mysqli_native_moodle_database.php
->
line 577
/lib/dml/mysqli_native_moodle_database.php
->
line 597
/lib/dml/mysqli_native_moodle_database.php
->
line 598
/lib/dml/mysqli_native_moodle_database.php
->
line 598
/lib/dml/mysqli_native_moodle_database.php
->
line 722
/lib/dml/mysqli_native_moodle_database.php
->
line 1518
/lib/dml/mysqli_native_moodle_database.php
->
line 1519
/lib/dml/mysqli_native_moodle_database.php
->
line 2141
/lib/dml/mysqli_native_moodle_database.php
->
line 2142
/auth/db/tests/db_test.php
->
line 63
/auth/db/tests/db_test.php
->
line 64
/auth/db/tests/db_test.php
->
line 73
/auth/db/tests/db_test.php
->
line 74
/auth/db/tests/db_test.php
->
line 90
/auth/db/tests/db_test.php
->
line 91
/auth/db/tests/db_test.php
->
line 95
/auth/db/tests/db_test.php
->
line 96
/auth/db/tests/db_test.php
->
line 97
/auth/db/tests/db_test.php
->
line 98
/auth/db/tests/db_test.php
->
line 99
/auth/db/tests/db_test.php
->
line 114
/auth/db/tests/db_test.php
->
line 115
/lib/dmllib.php
->
line 327
/lib/dmllib.php
->
line 328
/lib/dmllib.php
->
line 332
/lib/dmllib.php
->
line 340
/admin/tool/log/store/database/tests/store_test.php
->
line 71
/admin/tool/log/store/database/tests/store_test.php
->
line 76
/admin/tool/log/store/database/tests/store_test.php
->
line 77
/admin/tool/log/store/database/tests/store_test.php
->
line 81
/admin/tool/log/store/database/tests/store_test.php
->
line 82
/admin/tool/log/store/database/tests/store_test.php
->
line 86
/admin/tool/log/store/database/tests/store_test.php
->
line 87
/admin/tool/log/store/database/tests/store_test.php
->
line 91
/admin/tool/log/store/database/tests/store_test.php
->
line 92
/admin/tool/log/store/database/tests/store_test.php
->
line 96
/admin/tool/log/store/database/tests/store_test.php
->
line 97
/lib/dml/tests/dml_read_slave_test.php
->
line 70
/lib/dml/tests/dml_read_slave_test.php
->
line 72
/lib/dml/tests/dml_read_slave_test.php
->
line 76
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 143
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 144
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 146
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 147
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 154
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 212
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 213
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 215
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 216
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 223
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 272
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 273
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 275
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 281
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 66
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 71
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 72
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 76
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 77
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 81
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 82
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 86
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 87
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 91
/admin/tool/log/store/database/tests/privacy/provider_test.php
->
line 92
/lib/dml/tests/fixtures/read_slave_moodle_database.php
->
line 57
/lib/dml/tests/fixtures/read_slave_moodle_database.php
->
line 58
/lib/dml/tests/fixtures/read_slave_moodle_database.php
->
line 58
/config-dist.php
->
line 48
/auth/db/settings.php
->
line 44
/auth/db/settings.php
->
line 50
/auth/db/settings.php
->
line 55
/lib/dml/tests/dml_test.php
->
line 5626
/lib/dml/tests/dml_test.php
->
line 5627
/lib/dml/tests/dml_test.php
->
line 5632
/lib/dml/tests/dml_test.php
->
line 5633
/lib/dml/tests/dml_test.php
->
line 5634
/lib/dml/tests/dml_test.php
->
line 5636
/lib/dml/tests/dml_test.php
->
line 5640
/lib/dml/tests/dml_test.php
->
line 5683
/lib/dml/tests/dml_test.php
->
line 5684
/lib/dml/tests/dml_test.php
->
line 5687
/lib/dml/tests/dml_test.php
->
line 6321
/lib/dml/tests/dml_test.php
->
line 6322
/lib/dml/tests/dml_test.php
->
line 6325
/lib/dml/tests/dml_test.php
->
line 6340
/lib/dml/tests/dml_test.php
->
line 6343
/lib/dml/tests/dml_test.php
->
line 6346
/lib/dml/tests/dml_test.php
->
line 6347
/lib/dml/tests/dml_test.php
->
line 6376