Manual:SQL patch file/pt-br

---

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

Exemplo

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

BEGIN;
 
CREATE TABLE /*_*/foo_bar(
-- Primary key
fb_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
-- user.user_id of the user who foobared the wiki
fb_user INT UNSIGNED NOT NULL,
-- user.user_text of the user who foobared the wiki
fb_user_text VARCHAR(256),
-- Timestamp of when the wiki was foobared
fb_timestamp varbinary(14) NOT NULL default NULL ''
)/*$wgDBTableOptions*/;

CREATE INDEX /*i*/fb_user ON /*_*/foo_bar (fb_user);
CREATE INDEX /*i*/fb_user_text ON /*_*/foo_bar (fb_user_text);
COMMIT;

Variable replacement

/*_*/ will be replaced with $wgDBprefixManual:$wgDBprefix. /*i*/ will be replaced with an index prefix. /*$wgDBTableOptions*/ will be replaced with the value of $wgDBTableOptionsManual:$wgDBTableOptions. 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.

Links externos

• W3Schools, CREATE TABLE
• W3Schools, ALTER TABLE - Used to add, modify, drop columns

Bancos de dadosManual:Database layout

Gerenciadores: MySQL/MariaDBManual:MySQL – OracleManual:Oracle – PostgreSQLManual:PostgreSQL – SQLiteManual:SQLite Documentação técnica: EsquemaManual:Database layout (tabelasCategory:MediaWiki database tables) – Associações de propriedades da APIAPI:Database field and API property associations – Prefixos de campoDatabase field prefixes – Primary key storage in other fieldsManual:Primary key storage in other fields – Tabelas de extensões da WikimediaCategory:Wikimedia extension database tables Configuração: DefiniçõesManual:Configuration_settings#Database_settings – CompartilhamentoManual:Shared database Desenvolvimento: AcessoManual:Database access – OtimizaçãoDatabase optimization – PolíticasDevelopment policy#Database_patches – AtualizaçãoManual:DatabaseUpdater.php – Atualizações de esquemas de extensõesManual:Hooks/LoadExtensionSchemaUpdates – Arquivo de correçãoManual:SQL patch file Tabelas de núcleo: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_identifiers - site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – tag_summary – valid_tag – watchlist