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. These three need to be used in patch files, as in the example above. There are other variable replacements but they are not used in practice. See the documentation of DatabaseBase::replaceVars for the full list.