Manual:SQL patch file

You might write an SQL file either for a schema change in the core (see Development_policy#Database_patches, Manual:DatabaseUpdater.php) or for an extension (see Manual:Hooks/LoadExtensionSchemaUpdates).

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