Manual:SQL patch file/en

You might write an SQL file either for a schema change in the core (see Development_policy#Database_patches, ) or for an extension (see ).

Example
An SQL file to create a table might look something like this:

Variable replacement
will be replaced with. will be replaced with an index prefix. will be replaced with the value of. The first two need to be used in patch files, as in the example above. is only used for database backends. There are other variable replacements but they are not used in practice. See the documentation of Database::replaceVars for the full list.