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)
XMLDB_TYPE_CHAR
[
Top level directory
]
Constant Cross Reference
at:
/lib/xmldb/xmldb_constants.php
->
line 50
Referenced 257 times:
/lib/ddl/postgres_sql_generator.php
->
line 178
/lib/ddl/postgres_sql_generator.php
->
line 279
/lib/ddl/postgres_sql_generator.php
->
line 293
/auth/lti/db/upgrade.php
->
line 46
/auth/lti/db/upgrade.php
->
line 47
/auth/lti/db/upgrade.php
->
line 48
/lib/xmldb/xmldb_index.php
->
line 364
/lib/xmldb/xmldb_index.php
->
line 366
/lib/xmldb/xmldb_field.php
->
line 255
/lib/xmldb/xmldb_field.php
->
line 314
/lib/xmldb/xmldb_field.php
->
line 428
/lib/xmldb/xmldb_field.php
->
line 464
/lib/xmldb/xmldb_field.php
->
line 565
/lib/xmldb/xmldb_field.php
->
line 591
/lib/xmldb/xmldb_field.php
->
line 644
/lib/xmldb/xmldb_field.php
->
line 645
/lib/xmldb/xmldb_field.php
->
line 720
/lib/xmldb/xmldb_field.php
->
line 739
/lib/xmldb/xmldb_field.php
->
line 827
/lib/xmldb/xmldb_field.php
->
line 829
/admin/tool/xmldb/actions/edit_field_save/edit_field_save.class.php
->
line 192
/auth/ldap/auth.php
->
line 693
/lib/ddl/tests/ddl_test.php
->
line 49
/lib/ddl/tests/ddl_test.php
->
line 50
/lib/ddl/tests/ddl_test.php
->
line 94
/lib/ddl/tests/ddl_test.php
->
line 95
/lib/ddl/tests/ddl_test.php
->
line 96
/lib/ddl/tests/ddl_test.php
->
line 573
/lib/ddl/tests/ddl_test.php
->
line 605
/lib/ddl/tests/ddl_test.php
->
line 628
/lib/ddl/tests/ddl_test.php
->
line 631
/lib/ddl/tests/ddl_test.php
->
line 877
/lib/ddl/tests/ddl_test.php
->
line 1022
/lib/ddl/tests/ddl_test.php
->
line 1036
/lib/ddl/tests/ddl_test.php
->
line 1054
/lib/ddl/tests/ddl_test.php
->
line 1090
/lib/ddl/tests/ddl_test.php
->
line 1181
/lib/ddl/tests/ddl_test.php
->
line 1189
/lib/ddl/tests/ddl_test.php
->
line 1268
/lib/ddl/tests/ddl_test.php
->
line 1284
/lib/ddl/tests/ddl_test.php
->
line 1293
/lib/ddl/tests/ddl_test.php
->
line 1314
/lib/ddl/tests/ddl_test.php
->
line 1319
/lib/ddl/tests/ddl_test.php
->
line 1350
/lib/ddl/tests/ddl_test.php
->
line 1402
/lib/ddl/tests/ddl_test.php
->
line 1416
/lib/ddl/tests/ddl_test.php
->
line 1556
/lib/ddl/tests/ddl_test.php
->
line 1763
/lib/ddl/tests/ddl_test.php
->
line 1769
/lib/ddl/tests/ddl_test.php
->
line 1959
/lib/ddl/tests/ddl_test.php
->
line 1960
/lib/ddl/tests/ddl_test.php
->
line 1986
/lib/ddl/tests/ddl_test.php
->
line 2008
/lib/ddl/tests/ddl_test.php
->
line 2033
/lib/ddl/tests/ddl_test.php
->
line 2060
/lib/ddl/tests/ddl_test.php
->
line 2061
/lib/ddl/tests/ddl_test.php
->
line 2086
/lib/ddl/tests/ddl_test.php
->
line 2087
/lib/ddl/tests/ddl_test.php
->
line 2110
/lib/ddl/tests/ddl_test.php
->
line 2161
/lib/ddl/mssql_sql_generator.php
->
line 227
/lib/ddl/mssql_sql_generator.php
->
line 364
/lib/ddl/mssql_sql_generator.php
->
line 411
/lib/ddl/mssql_sql_generator.php
->
line 416
/lib/ddl/mssql_sql_generator.php
->
line 421
/lib/ddl/mssql_sql_generator.php
->
line 426
/lib/ddl/mssql_sql_generator.php
->
line 434
/lib/ddl/mssql_sql_generator.php
->
line 439
/mod/h5pactivity/db/upgrade.php
->
line 103
/mod/h5pactivity/db/upgrade.php
->
line 105
/admin/tool/xmldb/actions/check_oracle_semantics/check_oracle_semantics.class.php
->
line 69
/lib/ddl/mysql_sql_generator.php
->
line 161
/lib/ddl/mysql_sql_generator.php
->
line 448
/lib/tests/persistent_test.php
->
line 50
/lib/tests/persistent_test.php
->
line 51
/lib/tests/persistent_test.php
->
line 55
/lib/tests/persistent_test.php
->
line 84
/lib/dml/tests/dml_table_test.php
->
line 55
/lib/dml/tests/dml_table_test.php
->
line 111
/lib/dml/tests/dml_table_test.php
->
line 130
/lib/xmldb/xmldb_constants.php
->
line 50
/enrol/database/tests/sync_test.php
->
line 132
/enrol/database/tests/sync_test.php
->
line 133
/enrol/database/tests/sync_test.php
->
line 134
/enrol/database/tests/sync_test.php
->
line 135
/enrol/database/tests/sync_test.php
->
line 149
/enrol/database/tests/sync_test.php
->
line 150
/enrol/database/tests/sync_test.php
->
line 151
/enrol/database/tests/sync_test.php
->
line 152
/lib/ddl/database_manager.php
->
line 974
/lib/ddl/database_manager.php
->
line 1060
/mod/lti/service/gradebookservices/db/upgrade.php
->
line 65
/backup/util/dbops/backup_controller_dbops.class.php
->
line 128
/backup/util/dbops/backup_controller_dbops.class.php
->
line 129
/backup/util/dbops/backup_controller_dbops.class.php
->
line 150
/backup/util/dbops/backup_controller_dbops.class.php
->
line 152
/backup/util/dbops/backup_controller_dbops.class.php
->
line 153
/lib/dml/tests/pgsql_native_recordset_test.php
->
line 77
/lib/tests/upgradelib_test.php
->
line 1391
/enrol/lti/db/upgrade.php
->
line 65
/enrol/lti/db/upgrade.php
->
line 67
/enrol/lti/db/upgrade.php
->
line 68
/enrol/lti/db/upgrade.php
->
line 95
/enrol/lti/db/upgrade.php
->
line 104
/enrol/lti/db/upgrade.php
->
line 123
/enrol/lti/db/upgrade.php
->
line 124
/enrol/lti/db/upgrade.php
->
line 171
/enrol/lti/db/upgrade.php
->
line 175
/enrol/lti/db/upgrade.php
->
line 176
/enrol/lti/db/upgrade.php
->
line 177
/enrol/lti/db/upgrade.php
->
line 178
/enrol/lti/db/upgrade.php
->
line 179
/enrol/lti/db/upgrade.php
->
line 180
/enrol/lti/db/upgrade.php
->
line 181
/enrol/lti/db/upgrade.php
->
line 208
/enrol/lti/db/upgrade.php
->
line 256
/enrol/lti/db/upgrade.php
->
line 272
/enrol/lti/db/upgrade.php
->
line 321
/enrol/lti/db/upgrade.php
->
line 335
/enrol/lti/db/upgrade.php
->
line 370
/enrol/lti/db/upgrade.php
->
line 393
/enrol/lti/db/upgrade.php
->
line 414
/auth/db/tests/db_test.php
->
line 126
/auth/db/tests/db_test.php
->
line 127
/auth/db/tests/db_test.php
->
line 128
/auth/db/tests/db_test.php
->
line 129
/auth/db/tests/db_test.php
->
line 130
/auth/db/tests/db_test.php
->
line 131
/lib/dml/tests/pgsql_native_moodle_database_test.php
->
line 191
/lib/dml/tests/pgsql_native_moodle_database_test.php
->
line 296
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 229
/lib/dml/tests/dml_pgsql_read_slave_test.php
->
line 244
/lib/ddl/sql_generator.php
->
line 582
/lib/ddl/sql_generator.php
->
line 596
/lib/ddl/sqlite_sql_generator.php
->
line 172
/mod/quiz/db/upgrade.php
->
line 168
/lib/db/upgrade.php
->
line 184
/lib/db/upgrade.php
->
line 199
/lib/db/upgrade.php
->
line 210
/lib/db/upgrade.php
->
line 281
/lib/db/upgrade.php
->
line 453
/lib/db/upgrade.php
->
line 486
/lib/db/upgrade.php
->
line 487
/lib/db/upgrade.php
->
line 508
/lib/db/upgrade.php
->
line 528
/lib/db/upgrade.php
->
line 529
/lib/db/upgrade.php
->
line 532
/lib/db/upgrade.php
->
line 533
/lib/db/upgrade.php
->
line 535
/lib/db/upgrade.php
->
line 671
/lib/db/upgrade.php
->
line 752
/lib/db/upgrade.php
->
line 856
/lib/db/upgrade.php
->
line 869
/lib/db/upgrade.php
->
line 872
/lib/db/upgrade.php
->
line 873
/lib/db/upgrade.php
->
line 1128
/lib/db/upgrade.php
->
line 1145
/lib/db/upgrade.php
->
line 1146
/lib/db/upgrade.php
->
line 1147
/lib/db/upgrade.php
->
line 1174
/lib/db/upgrade.php
->
line 1175
/lib/db/upgrade.php
->
line 1282
/lib/db/upgrade.php
->
line 1462
/lib/db/upgrade.php
->
line 1481
/lib/db/upgrade.php
->
line 1484
/lib/db/upgrade.php
->
line 1485
/lib/db/upgrade.php
->
line 1528
/lib/db/upgrade.php
->
line 1530
/lib/db/upgrade.php
->
line 1531
/lib/db/upgrade.php
->
line 1532
/lib/db/upgrade.php
->
line 1533
/lib/db/upgrade.php
->
line 1553
/lib/db/upgrade.php
->
line 1554
/lib/db/upgrade.php
->
line 1575
/lib/db/upgrade.php
->
line 1639
/lib/db/upgrade.php
->
line 1660
/lib/db/upgrade.php
->
line 1661
/lib/db/upgrade.php
->
line 1682
/lib/db/upgrade.php
->
line 1683
/lib/db/upgrade.php
->
line 2029
/lib/db/upgrade.php
->
line 2058
/lib/db/upgrade.php
->
line 2076
/lib/db/upgrade.php
->
line 2077
/lib/db/upgrade.php
->
line 2098
/lib/db/upgrade.php
->
line 2099
/lib/db/upgrade.php
->
line 2503
/lib/db/upgrade.php
->
line 2506
/lib/db/upgrade.php
->
line 2509
/lib/db/upgrade.php
->
line 2512
/lib/db/upgrade.php
->
line 2802
/lib/db/upgrade.php
->
line 2990
/lib/db/upgrade.php
->
line 3164
/lib/db/upgrade.php
->
line 3167
/lib/db/upgrade.php
->
line 3169
/admin/tool/usertours/db/upgrade.php
->
line 68
/admin/tool/xmldb/actions/edit_field/edit_field.class.php
->
line 136
/admin/tool/xmldb/actions/edit_field/edit_field.class.php
->
line 136
/lib/statslib.php
->
line 1601
/lib/statslib.php
->
line 1618
/lib/statslib.php
->
line 1643
/lib/dml/tests/dml_test.php
->
line 557
/lib/dml/tests/dml_test.php
->
line 583
/lib/dml/tests/dml_test.php
->
line 587
/lib/dml/tests/dml_test.php
->
line 802
/lib/dml/tests/dml_test.php
->
line 806
/lib/dml/tests/dml_test.php
->
line 1027
/lib/dml/tests/dml_test.php
->
line 1118
/lib/dml/tests/dml_test.php
->
line 1272
/lib/dml/tests/dml_test.php
->
line 2134
/lib/dml/tests/dml_test.php
->
line 2209
/lib/dml/tests/dml_test.php
->
line 2488
/lib/dml/tests/dml_test.php
->
line 2661
/lib/dml/tests/dml_test.php
->
line 2869
/lib/dml/tests/dml_test.php
->
line 3057
/lib/dml/tests/dml_test.php
->
line 3163
/lib/dml/tests/dml_test.php
->
line 3361
/lib/dml/tests/dml_test.php
->
line 3891
/lib/dml/tests/dml_test.php
->
line 3901
/lib/dml/tests/dml_test.php
->
line 3925
/lib/dml/tests/dml_test.php
->
line 3978
/lib/dml/tests/dml_test.php
->
line 4035
/lib/dml/tests/dml_test.php
->
line 4100
/lib/dml/tests/dml_test.php
->
line 4138
/lib/dml/tests/dml_test.php
->
line 4139
/lib/dml/tests/dml_test.php
->
line 4194
/lib/dml/tests/dml_test.php
->
line 4270
/lib/dml/tests/dml_test.php
->
line 4369
/lib/dml/tests/dml_test.php
->
line 4370
/lib/dml/tests/dml_test.php
->
line 4505
/lib/dml/tests/dml_test.php
->
line 4585
/lib/dml/tests/dml_test.php
->
line 4592
/lib/dml/tests/dml_test.php
->
line 4674
/lib/dml/tests/dml_test.php
->
line 4706
/lib/dml/tests/dml_test.php
->
line 4786
/lib/dml/tests/dml_test.php
->
line 4787
/lib/dml/tests/dml_test.php
->
line 4788
/lib/dml/tests/dml_test.php
->
line 4821
/lib/dml/tests/dml_test.php
->
line 4822
/lib/dml/tests/dml_test.php
->
line 4862
/lib/dml/tests/dml_test.php
->
line 4863
/lib/dml/tests/dml_test.php
->
line 4906
/lib/dml/tests/dml_test.php
->
line 4952
/lib/dml/tests/dml_test.php
->
line 4982
/lib/dml/tests/dml_test.php
->
line 5131
/lib/dml/tests/dml_test.php
->
line 5134
/lib/dml/tests/dml_test.php
->
line 5729
/lib/dml/tests/dml_test.php
->
line 5819
/lib/dml/tests/dml_test.php
->
line 6077
/lib/dml/tests/dml_test.php
->
line 6168
/lib/ddl/oracle_sql_generator.php
->
line 246
/lib/ddl/oracle_sql_generator.php
->
line 462
/lib/ddl/oracle_sql_generator.php
->
line 476
/admin/tool/xmldb/actions/check_defaults/check_defaults.class.php
->
line 70
/mod/bigbluebuttonbn/db/upgrade.php
->
line 166
/mod/bigbluebuttonbn/db/upgrade.php
->
line 322
/mod/bigbluebuttonbn/db/upgrade.php
->
line 473
/mod/bigbluebuttonbn/db/upgrade.php
->
line 479