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 ). See also the.

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

Variable replacement
The first two need to be used in patch files, as in the example above.


 * will be replaced with.
 * will be replaced with an index prefix.
 * will be replaced with the value of.
 * 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.