Communauté  • Livre d'or
Chats noirs.jpg Actualités, astuces, interview... Venez lire la gazette de ce printemps de Vikidia ! DessinInterview.png

Vikidia:Demandes aux développeurs/es.vikidia

Aller à la navigation Aller à la recherche

Cette page est dédié a es: et aux actions prises pour debuggé la base de données.


Ticket n°20130328192746[modifier | modifier le wikicode]

[BUG] problème de création de compte sur Vikidia en espagnol (n°20130328192746)

  • Date de création : jeudi 28 mars 2013 à 20:27
  • Rapporteur : Astirmays (d · c · b)
  • État : clos
  • Pris en charge par Vivi-1 (d • c • b)

Description :
J'ai eu un message à propos de la création de compte bloquée sur vikidia en espagnol, j'ai vérifié et en effet, on arrive sur le message : 

Error de la base de datos
Ha ocurrido un error de sintaxis en una consulta a la base de datos. Esto puede indicar un error en el software. La última consulta a la base de datos que se intentó fue:

    (Consulta SQL oculta)

dentro de la función "User::addToDatabase". El error devuelto "1054: Unknown column 'user_options' in 'field list' (sql)".

Comment le débloquer ?

Outch es:special:version ils ne tournent pas avec la même version que nous :( Cela dit le support à un thread sur le problème. Je vais voir ce soir ce que je peux faire, mais j'ai un doute. Plyd connais mieux le sujet que moi. Vivi-1 (d • c | B • P • S) 15 mai 2013 à 10:12 (CEST)
    INSERT INTO `user` (user_id,user_name,user_password,user_newpassword,user_newpass_time,user_email,user_email_authenticated,user_real_name,user_options,user_token,user_registration,user_editcount) VALUES (NULL,'Vivi-1','','','20130517194302','HIDDEN_BY_VIVI-1',NULL,'','','9b2a67faa2d9ede43fcfde15cb62709a','20130517194302','0')

dentro de la función "User::addToDatabase". El error devuelto "1054: Unknown column 'user_options' in 'field list' (localhost)".

Backtrace:

#0 C:\Program Files (x86)\wamp\www\w\includes\db\Database.php(538): DatabaseBase->reportQueryError('Unknown column ...', 1054, 'INSERT INTO `u...', 'User::addToData...', false)
#1 C:\Program Files (x86)\wamp\www\w\includes\db\Database.php(1171): DatabaseBase->query('INSERT INTO `u...', 'User::addToData...')
#2 C:\Program Files (x86)\wamp\www\w\includes\User.php(2632): DatabaseBase->insert('user', Array, 'User::addToData...')
#3 C:\Program Files (x86)\wamp\www\w\includes\specials\SpecialUserlogin.php(378): User->addToDatabase()
#4 C:\Program Files (x86)\wamp\www\w\includes\specials\SpecialUserlogin.php(363): LoginForm->initUser(Object(User), false)
#5 C:\Program Files (x86)\wamp\www\w\includes\specials\SpecialUserlogin.php(170): LoginForm->addNewAccountInternal()
#6 C:\Program Files (x86)\wamp\www\w\includes\specials\SpecialUserlogin.php(112): LoginForm->addNewAccount()
#7 C:\Program Files (x86)\wamp\www\w\includes\specials\SpecialUserlogin.php(17): LoginForm->execute()
#8 [internal function]: wfSpecialUserlogin(NULL, Object(SpecialPage))
#9 C:\Program Files (x86)\wamp\www\w\includes\SpecialPage.php(791): call_user_func('wfSpecialUserlo...', NULL, Object(SpecialPage))
#10 C:\Program Files (x86)\wamp\www\w\includes\SpecialPage.php(559): SpecialPage->execute(NULL)
#11 C:\Program Files (x86)\wamp\www\w\includes\Wiki.php(254): SpecialPage::executePath(Object(Title))
#12 C:\Program Files (x86)\wamp\www\w\includes\Wiki.php(64): MediaWiki->handleSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
#13 C:\Program Files (x86)\wamp\www\w\index.php(117): MediaWiki->performRequestForTitle(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest))
#14 {main}
La BDD semble OK, je pense que le soucis vient des fichiers, je passe en 1.20.3 en local pour test Vivi-1 (d • c | B • P • S) 17 mai 2013 à 21:49 (CEST)
Débuggé en local :
  • mise a jours BDD en 1.20.3
  • purge des fichiers *.php dans w/ (non récursif)
  • purge du w/includes/ (j'ai viré le dossier complet)
  • copie des fichiers 1.20.3 dans w/
  • désactivation de toutes les extensions dans le localsettings.php
ça fonctionne pour le moment, je test en mettant a jours les extensions. Vivi-1 (d • c | B • P • S) 17 mai 2013 à 22:19 (CEST)
Je n'ai pas encore regardé de près, merci pour le travail ! Astirmays (d · c · b) 19 mai 2013 à 12:38 (CEST)
C'est en vrac depuis [1] un moment :( Vivi-1 (d • c | B • P • S) 20 mai 2013 à 21:40 (CEST)

Pour vous référer à ce ticket dans un texte, utilisez {{ticket|20130328192746}}.

Extensions[modifier | modifier le wikicode]

liste

Trucs encore buggés[modifier | modifier le wikicode]

  • problème d'accent lien rapide pour Vivi-1]
    • ok dans le dump (utf8_bin) Ou pas dans le dump c'est pas bon
    • pas bon en DB (utf8_bin)
    • Ça merde à l'import de la DB
  • faut check le script d'update

J'ai filé le bébé a mw: : https://www.mediawiki.org/wiki/Thread:Project:Support_desk/Pagetitle_encoding_eroblems_when_upgrading_a_wiki Vivi-1 (d • c | B • P • S) 18 mai 2013 à 15:36 (CEST)

Y'a une reponse, mais je suis pas chez moi, si un autre dev a le temps de faire les tests. Vivi-1 (d • c | B • P • S) 18 mai 2013 à 17:15 (CEST)
Solutions possibles :
  • Corriger les pages après migration (comme fait ici a une époque)
  • arriver a corriger ce problème dans la DB via SQL
  • réimporter le contenu de la DB sur une structure "propre" généré en 1.20.X (ne résoudra pas tout, mais y'aura une base propre pour la suite)
  • corriger via un script les accents (pas motivé pour le coup)
  • arrêter le massacre et aller boire une bière ?
Vivi-1 (d • c | B • P • S) 19 mai 2013 à 17:19 (CEST)
echo utf8_decode($data);

On peut regarder du coté de [2] qui est un hack :) (solution temporaire, mais si ça aide ...)

cf la page [3] du bug report. Vivi-1 (d • c | B • P • S) 21 mai 2013 à 22:26 (CEST)


Code pour corriger un dump.sql[modifier | modifier le wikicode]

Les fichiers à encoder sont a placer dans ./sql/ et il faut aussi créer ./sql_utf8/ qui contiendra les fichiers encodés.


Pour des raisons d'efficacité, je recommande d'utiliser plusieurs fichiers .sql (un par base, certaines n'ont pas besoin d'être modifié (ne contiennent que des BLOBs)).

Je recommande aussi d'utiliser une structure pour vos tables provenant de la dernière version MW disponible, afin d'éviter d'autres soucis par la suite.

Le fichier Encoding.php : [4] 

<?php
namespace ForceUTF8;
error_reporting( -1 );
ini_set( 'display_errors', 1 );
ini_set('default_charset', 'utf-8');

require_once('Encoding.php');
$handle = opendir('./sql/');
$dirIgnore = array ('.','..');

while ($file = readdir($handle)) {
    if (!in_array($file, $dirIgnore)) {
        echo 'Encoding '. $file ."\n";
        file_put_contents('./sql_utf8/'. $file, Encoding::fixUTF8(file_get_contents('./sql/'. $file)));
    }
}

?>

Bilan[modifier | modifier le wikicode]

Bon, dans la DB on a des trucs comme ça : Imágenes et PHP me sort ça : Imágenes. Je sais pas ou ça merde, je sais pas pourquoi, et j'ai plus aucune idée pour le moment. PHP vois un truc, MW en vois un autre, et MySQL contient encore autre chose. C'est le dawa format binaire avec une bonne grosse touche de WTF. Si quelqu'un a une fucking idée, je suis preneur. Ça fait 5 j que je suis dessus, voici mon bilan : la DB est en grande partie foutue, les dernières pages crées sont en grande partie irrécupérable (Encoding::fixUTF8($data[$column['Field']]); n'arrive même pas a afficher un truc correct pour eux).

  • Conseil : Fermer es: en écriture pour les IP's le temps de trouver une solution "viable".
  • Il est peut être possible d'avoir quelque chose de correct en utilisant ini_set('default_charset', 'utf-8'); dans le localsettings.php Non, même ça ne marche pas.

Je lâche l'affaire pour le moment. Vivi-1 (d • c | B • P • S) 20 mai 2013 à 19:14 (CEST)

Structure de la DB[modifier | modifier le wikicode]

Passer une colonne en utf8_bin: 

ALTER TABLE `archive` CHANGE `ar_title` `ar_title` BLOB;
ALTER TABLE `archive` CHANGE `ar_title` `ar_title` TEXT CHARACTER SET utf8 COLLATE utf8_bin;



es.vikidia clean install (MW:1.20.5)
CREATE TABLE IF NOT EXISTS `archive` ( 
 `ar_namespace` int(11) NOT NULL DEFAULT '0',
 `ar_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `ar_text` mediumblob NOT NULL,
 `ar_comment` tinyblob NOT NULL,
 `ar_user` int(10) unsigned NOT NULL DEFAULT '0',
 `ar_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `ar_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `ar_minor_edit` tinyint(4) NOT NULL DEFAULT '0',
 `ar_flags` tinyblob NOT NULL,
 `ar_rev_id` int(10) unsigned DEFAULT NULL,
 `ar_text_id` int(10) unsigned DEFAULT NULL,
 `ar_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `ar_len` int(10) unsigned DEFAULT NULL,
 `ar_page_id` int(10) unsigned DEFAULT NULL,
 `ar_parent_id` int(10) unsigned DEFAULT NULL,
 `ar_sha1` varbinary(32) NOT NULL DEFAULT ,
 KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`),
 KEY `usertext_timestamp` (`ar_user_text`,`ar_timestamp`),
 KEY `ar_revid` (`ar_rev_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `archive` ( 
 `ar_namespace` int(11) NOT NULL DEFAULT '0',
 `ar_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `ar_text` mediumblob NOT NULL,
 `ar_comment` tinyblob NOT NULL,
 `ar_user` int(10) unsigned NOT NULL DEFAULT '0',
 `ar_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `ar_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `ar_minor_edit` tinyint(4) NOT NULL DEFAULT '0',
 `ar_flags` tinyblob NOT NULL,
 `ar_rev_id` int(10) unsigned DEFAULT NULL,
 `ar_text_id` int(10) unsigned DEFAULT NULL,
 `ar_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `ar_len` int(10) unsigned DEFAULT NULL,
 `ar_page_id` int(10) unsigned DEFAULT NULL,
 `ar_parent_id` int(10) unsigned DEFAULT NULL,
 `ar_sha1` varbinary(32) NOT NULL DEFAULT ,
 KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`),
 KEY `usertext_timestamp` (`ar_user_text`,`ar_timestamp`),
 KEY `ar_revid` (`ar_rev_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `category` ( 
 `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `cat_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `cat_pages` int(11) NOT NULL DEFAULT '0',
 `cat_subcats` int(11) NOT NULL DEFAULT '0',
 `cat_files` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`cat_id`),
 UNIQUE KEY `cat_title` (`cat_title`),
 KEY `cat_pages` (`cat_pages`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7480 ;

CREATE TABLE IF NOT EXISTS `category` ( 
 `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `cat_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `cat_pages` int(11) NOT NULL DEFAULT '0',
 `cat_subcats` int(11) NOT NULL DEFAULT '0',
 `cat_files` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`cat_id`),
 UNIQUE KEY `cat_title` (`cat_title`),
 KEY `cat_pages` (`cat_pages`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `categorylinks` ( 
 `cl_from` int(10) unsigned NOT NULL DEFAULT '0',
 `cl_to` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `cl_sortkey` varbinary(230) NOT NULL DEFAULT ,
 `cl_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `cl_sortkey_prefix` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `cl_collation` varbinary(32) NOT NULL DEFAULT ,
 `cl_type` enum('page','subcat','file') NOT NULL DEFAULT 'page',
 UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
 KEY `cl_timestamp` (`cl_to`,`cl_timestamp`),
 KEY `cl_collation` (`cl_collation`),
 KEY `cl_sortkey` (`cl_to`,`cl_type`,`cl_sortkey`,`cl_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `categorylinks` ( 
 `cl_from` int(10) unsigned NOT NULL DEFAULT '0',
 `cl_to` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `cl_sortkey` varbinary(230) NOT NULL DEFAULT ,
 `cl_sortkey_prefix` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `cl_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `cl_collation` varbinary(32) NOT NULL DEFAULT ,
 `cl_type` enum('page','subcat','file') NOT NULL DEFAULT 'page',
 UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
 KEY `cl_sortkey` (`cl_to`,`cl_type`,`cl_sortkey`,`cl_from`),
 KEY `cl_timestamp` (`cl_to`,`cl_timestamp`),
 KEY `cl_collation` (`cl_collation`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `change_tag` ( 
 `ct_rc_id` int(11) DEFAULT NULL,
 `ct_log_id` int(11) DEFAULT NULL,
 `ct_rev_id` int(11) DEFAULT NULL,
 `ct_tag` varchar(255) NOT NULL,
 `ct_params` blob,
 UNIQUE KEY `change_tag_rc_tag` (`ct_rc_id`,`ct_tag`),
 UNIQUE KEY `change_tag_log_tag` (`ct_log_id`,`ct_tag`),
 UNIQUE KEY `change_tag_rev_tag` (`ct_rev_id`,`ct_tag`),
 KEY `change_tag_tag_id` (`ct_tag`,`ct_rc_id`,`ct_rev_id`,`ct_log_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `change_tag` ( 
 `ct_rc_id` int(11) DEFAULT NULL,
 `ct_log_id` int(11) DEFAULT NULL,
 `ct_rev_id` int(11) DEFAULT NULL,
 `ct_tag` varchar(255) NOT NULL,
 `ct_params` blob,
 UNIQUE KEY `change_tag_rc_tag` (`ct_rc_id`,`ct_tag`),
 UNIQUE KEY `change_tag_log_tag` (`ct_log_id`,`ct_tag`),
 UNIQUE KEY `change_tag_rev_tag` (`ct_rev_id`,`ct_tag`),
 KEY `change_tag_tag_id` (`ct_tag`,`ct_rc_id`,`ct_rev_id`,`ct_log_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `cu_changes` ( 
 `cuc_id` int(11) NOT NULL AUTO_INCREMENT,
 `cuc_namespace` int(11) NOT NULL DEFAULT '0',
 `cuc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `cuc_user` int(11) NOT NULL DEFAULT '0',
 `cuc_user_text` varchar(255) NOT NULL DEFAULT ,
 `cuc_actiontext` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `cuc_comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `cuc_minor` tinyint(1) NOT NULL DEFAULT '0',
 `cuc_page_id` int(10) unsigned NOT NULL DEFAULT '0',
 `cuc_this_oldid` int(10) unsigned NOT NULL DEFAULT '0',
 `cuc_last_oldid` int(10) unsigned NOT NULL DEFAULT '0',
 `cuc_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `cuc_timestamp` char(14) NOT NULL DEFAULT ,
 `cuc_ip` varchar(255) DEFAULT ,
 `cuc_ip_hex` varchar(255) DEFAULT NULL,
 `cuc_xff` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT ,
 `cuc_xff_hex` varchar(255) DEFAULT NULL,
 `cuc_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
 `cuc_private` mediumblob,
 PRIMARY KEY (`cuc_id`),
 KEY `cuc_ip_hex_time` (`cuc_ip_hex`,`cuc_timestamp`),
 KEY `cuc_user_ip_time` (`cuc_user`,`cuc_ip`,`cuc_timestamp`),
 KEY `cuc_xff_hex_time` (`cuc_xff_hex`,`cuc_timestamp`),
 KEY `cuc_timestamp` (`cuc_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=38340 ;

élément
CREATE TABLE IF NOT EXISTS `cu_log` ( 
 `cul_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `cul_timestamp` binary(14) NOT NULL,
 `cul_user` int(10) unsigned NOT NULL,
 `cul_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `cul_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `cul_type` varbinary(30) NOT NULL,
 `cul_target_id` int(10) unsigned NOT NULL DEFAULT '0',
 `cul_target_text` blob NOT NULL,
 `cul_target_hex` varbinary(255) NOT NULL DEFAULT ,
 `cul_range_start` varbinary(255) NOT NULL DEFAULT ,
 `cul_range_end` varbinary(255) NOT NULL DEFAULT ,
 PRIMARY KEY (`cul_id`),
 KEY `cul_timestamp` (`cul_timestamp`),
 KEY `cul_user` (`cul_user`,`cul_timestamp`),
 KEY `cul_type_target` (`cul_type`,`cul_target_id`,`cul_timestamp`),
 KEY `cul_target_hex` (`cul_target_hex`,`cul_timestamp`),
 KEY `cul_range_start` (`cul_range_start`,`cul_timestamp`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=52 ;

élément
CREATE TABLE IF NOT EXISTS `externallinks` ( 
 `el_from` int(10) unsigned NOT NULL DEFAULT '0',
 `el_to` blob NOT NULL,
 `el_index` blob NOT NULL,
 KEY `el_from` (`el_from`,`el_to`(40)),
 KEY `el_to` (`el_to`(60),`el_from`),
 KEY `el_index` (`el_index`(60))

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `externallinks` ( 
 `el_from` int(10) unsigned NOT NULL DEFAULT '0',
 `el_to` blob NOT NULL,
 `el_index` blob NOT NULL,
 KEY `el_from` (`el_from`,`el_to`(40)),
 KEY `el_to` (`el_to`(60),`el_from`),
 KEY `el_index` (`el_index`(60))

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `external_user` ( 
 `eu_local_id` int(10) unsigned NOT NULL,
 `eu_external_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 PRIMARY KEY (`eu_local_id`),
 UNIQUE KEY `eu_external_id` (`eu_external_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `external_user` ( 
 `eu_local_id` int(10) unsigned NOT NULL,
 `eu_external_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 PRIMARY KEY (`eu_local_id`),
 UNIQUE KEY `eu_external_id` (`eu_external_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `filearchive` ( 
 `fa_id` int(11) NOT NULL AUTO_INCREMENT,
 `fa_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `fa_archive_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT ,
 `fa_storage_group` varbinary(16) DEFAULT NULL,
 `fa_storage_key` varbinary(64) DEFAULT ,
 `fa_deleted_user` int(11) DEFAULT NULL,
 `fa_deleted_timestamp` binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `fa_deleted_reason` text,
 `fa_size` int(10) unsigned DEFAULT '0',
 `fa_width` int(11) DEFAULT '0',
 `fa_height` int(11) DEFAULT '0',
 `fa_metadata` mediumblob,
 `fa_bits` int(11) DEFAULT '0',
 `fa_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE',
   'TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
 `fa_major_mime` enum('unknown','application','audio','image','text','video','message',
   'model','multipart') DEFAULT 'unknown',
 `fa_minor_mime` varbinary(100) DEFAULT 'unknown',
 `fa_description` tinyblob,
 `fa_user` int(10) unsigned DEFAULT '0',
 `fa_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
 `fa_timestamp` binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `fa_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`fa_id`),
 KEY `fa_name` (`fa_name`,`fa_timestamp`),
 KEY `fa_storage_group` (`fa_storage_group`,`fa_storage_key`),
 KEY `fa_deleted_timestamp` (`fa_deleted_timestamp`),
 KEY `fa_user_timestamp` (`fa_user_text`,`fa_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=106 ;

CREATE TABLE IF NOT EXISTS `filearchive` ( 
 `fa_id` int(11) NOT NULL AUTO_INCREMENT,
 `fa_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `fa_archive_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT ,
 `fa_storage_group` varbinary(16) DEFAULT NULL,
 `fa_storage_key` varbinary(64) DEFAULT ,
 `fa_deleted_user` int(11) DEFAULT NULL,
 `fa_deleted_timestamp` binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `fa_deleted_reason` text,
 `fa_size` int(10) unsigned DEFAULT '0',
 `fa_width` int(11) DEFAULT '0',
 `fa_height` int(11) DEFAULT '0',
 `fa_metadata` mediumblob,
 `fa_bits` int(11) DEFAULT '0',
 `fa_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE',
   'TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
 `fa_major_mime` enum('unknown','application','audio','image','text','video','message',
   'model','multipart') DEFAULT 'unknown',
 `fa_minor_mime` varbinary(100) DEFAULT 'unknown',
 `fa_description` tinyblob,
 `fa_user` int(10) unsigned DEFAULT '0',
 `fa_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
 `fa_timestamp` binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `fa_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`fa_id`),
 KEY `fa_name` (`fa_name`,`fa_timestamp`),
 KEY `fa_storage_group` (`fa_storage_group`,`fa_storage_key`),
 KEY `fa_deleted_timestamp` (`fa_deleted_timestamp`),
 KEY `fa_user_timestamp` (`fa_user_text`,`fa_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `hidden` ( 
 `hidden_page` int(11) NOT NULL DEFAULT '0',
 `hidden_namespace` int(11) NOT NULL DEFAULT '0',
 `hidden_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `hidden_comment` tinyblob NOT NULL,
 `hidden_user` int(5) unsigned NOT NULL DEFAULT '0',
 `hidden_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `hidden_timestamp` char(14) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `hidden_minor_edit` tinyint(1) NOT NULL DEFAULT '0',
 `hidden_deleted` tinyint(1) NOT NULL DEFAULT '0',
 `hidden_rev_id` int(8) unsigned DEFAULT NULL,
 `hidden_text_id` int(8) unsigned DEFAULT NULL,
 `hidden_by_user` int(11) DEFAULT NULL,
 `hidden_on_timestamp` char(14) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
 `hidden_reason` text,
 KEY `page_title_timestamp` (`hidden_page`,`hidden_timestamp`),
 KEY `name_title_timestamp` (`hidden_namespace`,`hidden_title`,`hidden_timestamp`),
 KEY `hidden_on_timestamp` (`hidden_on_timestamp`),
 KEY `hidden_by_user` (`hidden_by_user`,`hidden_on_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

élément
CREATE TABLE IF NOT EXISTS `hitcounter` ( 
 `hc_id` int(10) unsigned NOT NULL

) ENGINE=MEMORY DEFAULT CHARSET=utf8 MAX_ROWS=25000;

CREATE TABLE IF NOT EXISTS `hitcounter` ( 
 `hc_id` int(10) unsigned NOT NULL

) ENGINE=MEMORY DEFAULT CHARSET=latin1 MAX_ROWS=25000;

CREATE TABLE IF NOT EXISTS `image` ( 
 `img_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `img_size` int(10) unsigned NOT NULL DEFAULT '0',
 `img_width` int(11) NOT NULL DEFAULT '0',
 `img_height` int(11) NOT NULL DEFAULT '0',
 `img_metadata` mediumblob NOT NULL,
 `img_bits` int(11) NOT NULL DEFAULT '0',
 `img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE',
   'TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
 `img_major_mime` enum('unknown','application','audio','image','text','video','message',
   'model','multipart') NOT NULL DEFAULT 'unknown',
 `img_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown',
 `img_description` tinyblob NOT NULL,
 `img_user` int(10) unsigned NOT NULL DEFAULT '0',
 `img_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `img_timestamp` varbinary(14) NOT NULL DEFAULT ,
 `img_sha1` varbinary(32) NOT NULL DEFAULT ,
 PRIMARY KEY (`img_name`),
 KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
 KEY `img_size` (`img_size`),
 KEY `img_timestamp` (`img_timestamp`),
 KEY `img_sha1` (`img_sha1`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `image` ( 
 `img_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `img_size` int(10) unsigned NOT NULL DEFAULT '0',
 `img_width` int(11) NOT NULL DEFAULT '0',
 `img_height` int(11) NOT NULL DEFAULT '0',
 `img_metadata` mediumblob NOT NULL,
 `img_bits` int(11) NOT NULL DEFAULT '0',
 `img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE',
   'TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
 `img_major_mime` enum('unknown','application','audio','image','text','video','message',
   'model','multipart') NOT NULL DEFAULT 'unknown',
 `img_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown',
 `img_description` tinyblob NOT NULL,
 `img_user` int(10) unsigned NOT NULL DEFAULT '0',
 `img_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `img_timestamp` varbinary(14) NOT NULL DEFAULT ,
 `img_sha1` varbinary(32) NOT NULL DEFAULT ,
 PRIMARY KEY (`img_name`),
 KEY `img_usertext_timestamp` (`img_user_text`,`img_timestamp`),
 KEY `img_size` (`img_size`),
 KEY `img_timestamp` (`img_timestamp`),
 KEY `img_sha1` (`img_sha1`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `imagelinks` ( 
 `il_from` int(10) unsigned NOT NULL DEFAULT '0',
 `il_to` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 UNIQUE KEY `il_from` (`il_from`,`il_to`),
 UNIQUE KEY `il_to` (`il_to`,`il_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `imagelinks` ( 
 `il_from` int(10) unsigned NOT NULL DEFAULT '0',
 `il_to` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 UNIQUE KEY `il_from` (`il_from`,`il_to`),
 UNIQUE KEY `il_to` (`il_to`,`il_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `interwiki` ( 
 `iw_prefix` varchar(32) NOT NULL,
 `iw_url` blob NOT NULL,
 `iw_local` tinyint(1) NOT NULL,
 `iw_trans` tinyint(4) NOT NULL DEFAULT '0',
 `iw_api` blob NOT NULL,
 `iw_wikiid` varchar(64) NOT NULL,
 UNIQUE KEY `iw_prefix` (`iw_prefix`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `interwiki` ( 
 `iw_prefix` varchar(32) NOT NULL,
 `iw_url` blob NOT NULL,
 `iw_api` blob NOT NULL,
 `iw_wikiid` varchar(64) NOT NULL,
 `iw_local` tinyint(1) NOT NULL,
 `iw_trans` tinyint(4) NOT NULL DEFAULT '0',
 UNIQUE KEY `iw_prefix` (`iw_prefix`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ipblocks` ( 
 `ipb_id` int(11) NOT NULL AUTO_INCREMENT,
 `ipb_address` tinyblob NOT NULL,
 `ipb_user` int(10) unsigned NOT NULL DEFAULT '0',
 `ipb_by` int(10) unsigned NOT NULL DEFAULT '0',
 `ipb_by_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `ipb_reason` tinyblob NOT NULL,
 `ipb_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `ipb_auto` tinyint(1) NOT NULL DEFAULT '0',
 `ipb_anon_only` tinyint(1) NOT NULL DEFAULT '0',
 `ipb_create_account` tinyint(1) NOT NULL DEFAULT '1',
 `ipb_enable_autoblock` tinyint(1) NOT NULL DEFAULT '1',
 `ipb_expiry` varbinary(14) NOT NULL DEFAULT ,
 `ipb_range_start` tinyblob NOT NULL,
 `ipb_range_end` tinyblob NOT NULL,
 `ipb_deleted` tinyint(1) NOT NULL DEFAULT '0',
 `ipb_block_email` tinyint(1) NOT NULL DEFAULT '0',
 `ipb_allow_usertalk` tinyint(1) NOT NULL DEFAULT '1',
 `ipb_parent_block_id` int(11) DEFAULT NULL,
 PRIMARY KEY (`ipb_id`),
 UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`),
 KEY `ipb_user` (`ipb_user`),
 KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)),
 KEY `ipb_timestamp` (`ipb_timestamp`),
 KEY `ipb_expiry` (`ipb_expiry`),
 KEY `ipb_parent_block_id` (`ipb_parent_block_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6135 ;

CREATE TABLE IF NOT EXISTS `ipblocks` ( 
 `ipb_id` int(11) NOT NULL AUTO_INCREMENT,
 `ipb_address` tinyblob NOT NULL,
 `ipb_user` int(10) unsigned NOT NULL DEFAULT '0',
 `ipb_by` int(10) unsigned NOT NULL DEFAULT '0',
 `ipb_by_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `ipb_reason` tinyblob NOT NULL,
 `ipb_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `ipb_auto` tinyint(1) NOT NULL DEFAULT '0',
 `ipb_anon_only` tinyint(1) NOT NULL DEFAULT '0',
 `ipb_create_account` tinyint(1) NOT NULL DEFAULT '1',
 `ipb_enable_autoblock` tinyint(1) NOT NULL DEFAULT '1',
 `ipb_expiry` varbinary(14) NOT NULL DEFAULT ,
 `ipb_range_start` tinyblob NOT NULL,
 `ipb_range_end` tinyblob NOT NULL,
 `ipb_deleted` tinyint(1) NOT NULL DEFAULT '0',
 `ipb_block_email` tinyint(1) NOT NULL DEFAULT '0',
 `ipb_allow_usertalk` tinyint(1) NOT NULL DEFAULT '0',
 `ipb_parent_block_id` int(11) DEFAULT NULL,
 PRIMARY KEY (`ipb_id`),
 UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`),
 KEY `ipb_user` (`ipb_user`),
 KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)),
 KEY `ipb_timestamp` (`ipb_timestamp`),
 KEY `ipb_expiry` (`ipb_expiry`),
 KEY `ipb_parent_block_id` (`ipb_parent_block_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `iwlinks` ( 
 `iwl_from` int(10) unsigned NOT NULL DEFAULT '0',
 `iwl_prefix` varbinary(20) NOT NULL DEFAULT ,
 `iwl_title` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT ,
 UNIQUE KEY `iwl_from` (`iwl_from`,`iwl_prefix`,`iwl_title`),
 UNIQUE KEY `iwl_prefix_title_from` (`iwl_prefix`,`iwl_title`,`iwl_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `iwlinks` ( 
 `iwl_from` int(10) unsigned NOT NULL DEFAULT '0',
 `iwl_prefix` varbinary(20) NOT NULL DEFAULT ,
 `iwl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 UNIQUE KEY `iwl_from` (`iwl_from`,`iwl_prefix`,`iwl_title`),
 UNIQUE KEY `iwl_prefix_title_from` (`iwl_prefix`,`iwl_title`,`iwl_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `job` ( 
 `job_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `job_cmd` varbinary(60) NOT NULL DEFAULT ,
 `job_namespace` int(11) NOT NULL,
 `job_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `job_params` blob NOT NULL,
 `job_timestamp` varbinary(14) DEFAULT NULL,
 PRIMARY KEY (`job_id`),
 KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`),
 KEY `job_timestamp` (`job_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `job` ( 
 `job_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `job_cmd` varbinary(60) NOT NULL DEFAULT ,
 `job_namespace` int(11) NOT NULL,
 `job_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `job_timestamp` varbinary(14) DEFAULT NULL,
 `job_params` blob NOT NULL,
 PRIMARY KEY (`job_id`),
 KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`,`job_params`(128)),
 KEY `job_timestamp` (`job_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `l10n_cache` ( 
 `lc_lang` varbinary(32) NOT NULL,
 `lc_key` varchar(255) NOT NULL,
 `lc_value` mediumblob NOT NULL,
 KEY `lc_lang_key` (`lc_lang`,`lc_key`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `l10n_cache` ( 
 `lc_lang` varbinary(32) NOT NULL,
 `lc_key` varchar(255) NOT NULL,
 `lc_value` mediumblob NOT NULL,
 KEY `lc_lang_key` (`lc_lang`,`lc_key`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `langlinks` ( 
 `ll_from` int(10) unsigned NOT NULL DEFAULT '0',
 `ll_lang` varbinary(20) NOT NULL DEFAULT ,
 `ll_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`),
 KEY `ll_lang` (`ll_lang`,`ll_title`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `langlinks` ( 
 `ll_from` int(10) unsigned NOT NULL DEFAULT '0',
 `ll_lang` varbinary(20) NOT NULL DEFAULT ,
 `ll_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`),
 KEY `ll_lang` (`ll_lang`,`ll_title`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `logging` ( 
 `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `log_type` varbinary(32) NOT NULL,
 `log_action` varbinary(32) NOT NULL,
 `log_timestamp` binary(14) NOT NULL DEFAULT '19700101000000',
 `log_user` int(10) unsigned NOT NULL DEFAULT '0',
 `log_namespace` int(11) NOT NULL DEFAULT '0',
 `log_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `log_comment` varchar(255) NOT NULL DEFAULT ,
 `log_params` blob NOT NULL,
 `log_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `log_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `log_page` int(10) unsigned DEFAULT NULL,
 PRIMARY KEY (`log_id`),
 KEY `type_time` (`log_type`,`log_timestamp`),
 KEY `user_time` (`log_user`,`log_timestamp`),
 KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
 KEY `times` (`log_timestamp`),
 KEY `log_user_type_time` (`log_user`,`log_type`,`log_timestamp`),
 KEY `log_page_id_time` (`log_page`,`log_timestamp`),
 KEY `type_action` (`log_type`,`log_action`,`log_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18235 ;

CREATE TABLE IF NOT EXISTS `logging` ( 
 `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `log_type` varbinary(32) NOT NULL DEFAULT ,
 `log_action` varbinary(32) NOT NULL DEFAULT ,
 `log_timestamp` binary(14) NOT NULL DEFAULT '19700101000000',
 `log_user` int(10) unsigned NOT NULL DEFAULT '0',
 `log_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `log_namespace` int(11) NOT NULL DEFAULT '0',
 `log_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `log_page` int(10) unsigned DEFAULT NULL,
 `log_comment` varchar(255) NOT NULL DEFAULT ,
 `log_params` blob NOT NULL,
 `log_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`log_id`),
 KEY `type_time` (`log_type`,`log_timestamp`),
 KEY `user_time` (`log_user`,`log_timestamp`),
 KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
 KEY `times` (`log_timestamp`),
 KEY `log_user_type_time` (`log_user`,`log_type`,`log_timestamp`),
 KEY `log_page_id_time` (`log_page`,`log_timestamp`),
 KEY `type_action` (`log_type`,`log_action`,`log_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1

CREATE TABLE IF NOT EXISTS `log_search` ( 
 `ls_field` varbinary(32) NOT NULL,
 `ls_value` varchar(255) NOT NULL,
 `ls_log_id` int(10) unsigned NOT NULL DEFAULT '0',
 UNIQUE KEY `ls_field_val` (`ls_field`,`ls_value`,`ls_log_id`),
 KEY `ls_log_id` (`ls_log_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `log_search` ( 
 `ls_field` varbinary(32) NOT NULL,
 `ls_value` varchar(255) NOT NULL,
 `ls_log_id` int(10) unsigned NOT NULL DEFAULT '0',
 UNIQUE KEY `ls_field_val` (`ls_field`,`ls_value`,`ls_log_id`),
 KEY `ls_log_id` (`ls_log_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `math` ( 
 `math_inputhash` varbinary(16) NOT NULL,
 `math_outputhash` varbinary(16) NOT NULL,
 `math_html_conservativeness` tinyint(4) NOT NULL,
 `math_html` text,
 `math_mathml` text,
 UNIQUE KEY `math_inputhash` (`math_inputhash`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

élément
CREATE TABLE IF NOT EXISTS `module_deps` ( 
 `md_module` varbinary(255) NOT NULL,
 `md_skin` varbinary(32) NOT NULL,
 `md_deps` mediumblob NOT NULL,
 UNIQUE KEY `md_module_skin` (`md_module`,`md_skin`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `module_deps` ( 
 `md_module` varbinary(255) NOT NULL,
 `md_skin` varbinary(32) NOT NULL,
 `md_deps` mediumblob NOT NULL,
 UNIQUE KEY `md_module_skin` (`md_module`,`md_skin`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `msg_resource` ( 
 `mr_resource` varbinary(255) NOT NULL,
 `mr_lang` varbinary(32) NOT NULL,
 `mr_blob` mediumblob NOT NULL,
 `mr_timestamp` binary(14) NOT NULL,
 UNIQUE KEY `mr_resource_lang` (`mr_resource`,`mr_lang`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `msg_resource` ( 
 `mr_resource` varbinary(255) NOT NULL,
 `mr_lang` varbinary(32) NOT NULL,
 `mr_blob` mediumblob NOT NULL,
 `mr_timestamp` binary(14) NOT NULL,
 UNIQUE KEY `mr_resource_lang` (`mr_resource`,`mr_lang`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `msg_resource_links` ( 
 `mrl_resource` varbinary(255) NOT NULL,
 `mrl_message` varbinary(255) NOT NULL,
 UNIQUE KEY `mrl_message_resource` (`mrl_message`,`mrl_resource`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `msg_resource_links` ( 
 `mrl_resource` varbinary(255) NOT NULL,
 `mrl_message` varbinary(255) NOT NULL,
 UNIQUE KEY `mrl_message_resource` (`mrl_message`,`mrl_resource`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `objectcache` ( 
 `keyname` varbinary(255) NOT NULL DEFAULT ,
 `value` mediumblob,
 `exptime` datetime DEFAULT NULL,
 UNIQUE KEY `keyname` (`keyname`),
 KEY `exptime` (`exptime`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `objectcache` ( 
 `keyname` varbinary(255) NOT NULL DEFAULT ,
 `value` mediumblob,
 `exptime` datetime DEFAULT NULL,
 PRIMARY KEY (`keyname`),
 KEY `exptime` (`exptime`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `oldimage` ( 
 `oi_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `oi_archive_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `oi_size` int(10) unsigned NOT NULL DEFAULT '0',
 `oi_width` int(11) NOT NULL DEFAULT '0',
 `oi_height` int(11) NOT NULL DEFAULT '0',
 `oi_bits` int(11) NOT NULL DEFAULT '0',
 `oi_description` tinyblob NOT NULL,
 `oi_user` int(10) unsigned NOT NULL DEFAULT '0',
 `oi_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `oi_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `oi_metadata` mediumblob NOT NULL,
 `oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE',
   'TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
 `oi_major_mime` enum('unknown','application','audio','image','text','video','message',
   'model','multipart') NOT NULL DEFAULT 'unknown',
 `oi_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown',
 `oi_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `oi_sha1` varbinary(32) NOT NULL DEFAULT ,
 KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
 KEY `oi_name_timestamp` (`oi_name`,`oi_timestamp`),
 KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
 KEY `oi_sha1` (`oi_sha1`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `oldimage` ( 
 `oi_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `oi_archive_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `oi_size` int(10) unsigned NOT NULL DEFAULT '0',
 `oi_width` int(11) NOT NULL DEFAULT '0',
 `oi_height` int(11) NOT NULL DEFAULT '0',
 `oi_bits` int(11) NOT NULL DEFAULT '0',
 `oi_description` tinyblob NOT NULL,
 `oi_user` int(10) unsigned NOT NULL DEFAULT '0',
 `oi_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `oi_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `oi_metadata` mediumblob NOT NULL,
 `oi_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE',
   'TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
 `oi_major_mime` enum('unknown','application','audio','image','text','video','message',
   'model','multipart') NOT NULL DEFAULT 'unknown',
 `oi_minor_mime` varbinary(100) NOT NULL DEFAULT 'unknown',
 `oi_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `oi_sha1` varbinary(32) NOT NULL DEFAULT ,
 KEY `oi_usertext_timestamp` (`oi_user_text`,`oi_timestamp`),
 KEY `oi_name_timestamp` (`oi_name`,`oi_timestamp`),
 KEY `oi_name_archive_name` (`oi_name`,`oi_archive_name`(14)),
 KEY `oi_sha1` (`oi_sha1`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `page` ( 
 `page_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `page_namespace` int(11) NOT NULL,
 `page_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `page_restrictions` tinyblob NOT NULL,
 `page_counter` bigint(20) unsigned NOT NULL DEFAULT '0',
 `page_is_redirect` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `page_is_new` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `page_random` double unsigned NOT NULL,
 `page_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `page_latest` int(10) unsigned NOT NULL,
 `page_len` int(10) unsigned NOT NULL,
 PRIMARY KEY (`page_id`),
 UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
 KEY `page_random` (`page_random`),
 KEY `page_len` (`page_len`),
 KEY `page_redirect_namespace_len` (`page_is_redirect`,`page_namespace`,`page_len`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9984 ;

CREATE TABLE IF NOT EXISTS `page` ( 
 `page_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `page_namespace` int(11) NOT NULL,
 `page_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `page_restrictions` tinyblob NOT NULL,
 `page_counter` bigint(20) unsigned NOT NULL DEFAULT '0',
 `page_is_redirect` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `page_is_new` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `page_random` double unsigned NOT NULL,
 `page_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `page_latest` int(10) unsigned NOT NULL,
 `page_len` int(10) unsigned NOT NULL,
 PRIMARY KEY (`page_id`),
 UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
 KEY `page_random` (`page_random`),
 KEY `page_len` (`page_len`),
 KEY `page_redirect_namespace_len` (`page_is_redirect`,`page_namespace`,`page_len`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `pagelinks` ( 
 `pl_from` int(10) unsigned NOT NULL DEFAULT '0',
 `pl_namespace` int(11) NOT NULL DEFAULT '0',
 `pl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 UNIQUE KEY `pl_from` (`pl_from`,`pl_namespace`,`pl_title`),
 UNIQUE KEY `pl_namespace` (`pl_namespace`,`pl_title`,`pl_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `pagelinks` ( 
 `pl_from` int(10) unsigned NOT NULL DEFAULT '0',
 `pl_namespace` int(11) NOT NULL DEFAULT '0',
 `pl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 UNIQUE KEY `pl_from` (`pl_from`,`pl_namespace`,`pl_title`),
 UNIQUE KEY `pl_namespace` (`pl_namespace`,`pl_title`,`pl_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `page_props` ( 
 `pp_page` int(11) NOT NULL,
 `pp_propname` varbinary(60) NOT NULL,
 `pp_value` blob NOT NULL,
 PRIMARY KEY (`pp_page`,`pp_propname`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `page_props` ( 
 `pp_page` int(11) NOT NULL,
 `pp_propname` varbinary(60) NOT NULL,
 `pp_value` blob NOT NULL,
 UNIQUE KEY `pp_page_propname` (`pp_page`,`pp_propname`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `page_restrictions` ( 
 `pr_page` int(11) NOT NULL,
 `pr_type` varbinary(60) NOT NULL,
 `pr_level` varbinary(60) NOT NULL,
 `pr_cascade` tinyint(4) NOT NULL,
 `pr_user` int(11) DEFAULT NULL,
 `pr_expiry` varbinary(14) DEFAULT NULL,
 `pr_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 PRIMARY KEY (`pr_page`,`pr_type`),
 UNIQUE KEY `pr_id` (`pr_id`),
 KEY `pr_typelevel` (`pr_type`,`pr_level`),
 KEY `pr_level` (`pr_level`),
 KEY `pr_cascade` (`pr_cascade`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=89 ;

CREATE TABLE IF NOT EXISTS `page_restrictions` ( 
 `pr_page` int(11) NOT NULL,
 `pr_type` varbinary(60) NOT NULL,
 `pr_level` varbinary(60) NOT NULL,
 `pr_cascade` tinyint(4) NOT NULL,
 `pr_user` int(11) DEFAULT NULL,
 `pr_expiry` varbinary(14) DEFAULT NULL,
 `pr_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 PRIMARY KEY (`pr_id`),
 UNIQUE KEY `pr_pagetype` (`pr_page`,`pr_type`),
 KEY `pr_typelevel` (`pr_type`,`pr_level`),
 KEY `pr_level` (`pr_level`),
 KEY `pr_cascade` (`pr_cascade`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `patrollers` ( 
 `ptr_change` int(8) NOT NULL,
 `ptr_timestamp` varchar(14) NOT NULL,
 UNIQUE KEY `ptr_change` (`ptr_change`),
 KEY `ptr_timestamp` (`ptr_timestamp`)

) ENGINE=MEMORY DEFAULT CHARSET=utf8;

élément
CREATE TABLE IF NOT EXISTS `protected_titles` ( 
 `pt_namespace` int(11) NOT NULL,
 `pt_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `pt_user` int(10) unsigned NOT NULL,
 `pt_reason` tinyblob,
 `pt_timestamp` binary(14) NOT NULL,
 `pt_expiry` varbinary(14) NOT NULL DEFAULT ,
 `pt_create_perm` varbinary(60) NOT NULL,
 PRIMARY KEY (`pt_namespace`,`pt_title`),
 KEY `pt_timestamp` (`pt_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `protected_titles` ( 
 `pt_namespace` int(11) NOT NULL,
 `pt_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `pt_user` int(10) unsigned NOT NULL,
 `pt_reason` tinyblob,
 `pt_timestamp` binary(14) NOT NULL,
 `pt_expiry` varbinary(14) NOT NULL DEFAULT ,
 `pt_create_perm` varbinary(60) NOT NULL,
 UNIQUE KEY `pt_namespace_title` (`pt_namespace`,`pt_title`),
 KEY `pt_timestamp` (`pt_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `querycache` ( 
 `qc_type` varbinary(32) NOT NULL,
 `qc_value` int(10) unsigned NOT NULL DEFAULT '0',
 `qc_namespace` int(11) NOT NULL DEFAULT '0',
 `qc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 KEY `qc_type` (`qc_type`,`qc_value`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `querycache` ( 
 `qc_type` varbinary(32) NOT NULL,
 `qc_value` int(10) unsigned NOT NULL DEFAULT '0',
 `qc_namespace` int(11) NOT NULL DEFAULT '0',
 `qc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 KEY `qc_type` (`qc_type`,`qc_value`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `querycachetwo` ( 
 `qcc_type` varbinary(32) NOT NULL,
 `qcc_value` int(10) unsigned NOT NULL DEFAULT '0',
 `qcc_namespace` int(11) NOT NULL DEFAULT '0',
 `qcc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `qcc_namespacetwo` int(11) NOT NULL DEFAULT '0',
 `qcc_titletwo` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 KEY `qcc_type` (`qcc_type`,`qcc_value`),
 KEY `qcc_title` (`qcc_type`,`qcc_namespace`,`qcc_title`),
 KEY `qcc_titletwo` (`qcc_type`,`qcc_namespacetwo`,`qcc_titletwo`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `querycachetwo` ( 
 `qcc_type` varbinary(32) NOT NULL,
 `qcc_value` int(10) unsigned NOT NULL DEFAULT '0',
 `qcc_namespace` int(11) NOT NULL DEFAULT '0',
 `qcc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `qcc_namespacetwo` int(11) NOT NULL DEFAULT '0',
 `qcc_titletwo` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 KEY `qcc_type` (`qcc_type`,`qcc_value`),
 KEY `qcc_title` (`qcc_type`,`qcc_namespace`,`qcc_title`),
 KEY `qcc_titletwo` (`qcc_type`,`qcc_namespacetwo`,`qcc_titletwo`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `querycache_info` ( 
 `qci_type` varbinary(32) NOT NULL DEFAULT ,
 `qci_timestamp` binary(14) NOT NULL DEFAULT '19700101000000',
 UNIQUE KEY `qci_type` (`qci_type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `querycache_info` ( 
 `qci_type` varbinary(32) NOT NULL DEFAULT ,
 `qci_timestamp` binary(14) NOT NULL DEFAULT '19700101000000',
 UNIQUE KEY `qci_type` (`qci_type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `recentchanges` ( 
 `rc_id` int(11) NOT NULL AUTO_INCREMENT,
 `rc_timestamp` varbinary(14) NOT NULL DEFAULT ,
 `rc_cur_time` varbinary(14) NOT NULL DEFAULT ,
 `rc_user` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `rc_namespace` int(11) NOT NULL DEFAULT '0',
 `rc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rc_comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rc_minor` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_bot` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_new` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_cur_id` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_this_oldid` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_last_oldid` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_moved_to_ns` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_moved_to_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rc_patrolled` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_ip` varbinary(40) NOT NULL DEFAULT ,
 `rc_old_len` int(11) DEFAULT NULL,
 `rc_new_len` int(11) DEFAULT NULL,
 `rc_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_logid` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_log_type` varbinary(255) DEFAULT NULL,
 `rc_log_action` varbinary(255) DEFAULT NULL,
 `rc_params` blob,
 PRIMARY KEY (`rc_id`),
 KEY `rc_timestamp` (`rc_timestamp`),
 KEY `rc_namespace_title` (`rc_namespace`,`rc_title`),
 KEY `rc_cur_id` (`rc_cur_id`),
 KEY `new_name_timestamp` (`rc_new`,`rc_namespace`,`rc_timestamp`),
 KEY `rc_ip` (`rc_ip`),
 KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
 KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=38337 ;

CREATE TABLE IF NOT EXISTS `recentchanges` ( 
 `rc_id` int(11) NOT NULL AUTO_INCREMENT,
 `rc_timestamp` varbinary(14) NOT NULL DEFAULT ,
 `rc_cur_time` varbinary(14) NOT NULL DEFAULT ,
 `rc_user` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `rc_namespace` int(11) NOT NULL DEFAULT '0',
 `rc_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rc_comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rc_minor` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_bot` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_new` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_cur_id` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_this_oldid` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_last_oldid` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_moved_to_ns` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_moved_to_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rc_patrolled` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_ip` varbinary(40) NOT NULL DEFAULT ,
 `rc_old_len` int(11) DEFAULT NULL,
 `rc_new_len` int(11) DEFAULT NULL,
 `rc_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rc_logid` int(10) unsigned NOT NULL DEFAULT '0',
 `rc_log_type` varbinary(255) DEFAULT NULL,
 `rc_log_action` varbinary(255) DEFAULT NULL,
 `rc_params` blob,
 PRIMARY KEY (`rc_id`),
 KEY `rc_timestamp` (`rc_timestamp`),
 KEY `rc_namespace_title` (`rc_namespace`,`rc_title`),
 KEY `rc_cur_id` (`rc_cur_id`),
 KEY `new_name_timestamp` (`rc_new`,`rc_namespace`,`rc_timestamp`),
 KEY `rc_ip` (`rc_ip`),
 KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
 KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `redirect` ( 
 `rd_from` int(10) unsigned NOT NULL DEFAULT '0',
 `rd_namespace` int(11) NOT NULL DEFAULT '0',
 `rd_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rd_interwiki` varchar(32) DEFAULT NULL,
 `rd_fragment` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
 PRIMARY KEY (`rd_from`),
 KEY `rd_ns_title` (`rd_namespace`,`rd_title`,`rd_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `redirect` ( 
 `rd_from` int(10) unsigned NOT NULL DEFAULT '0',
 `rd_namespace` int(11) NOT NULL DEFAULT '0',
 `rd_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rd_interwiki` varchar(32) DEFAULT NULL,
 `rd_fragment` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
 PRIMARY KEY (`rd_from`),
 KEY `rd_ns_title` (`rd_namespace`,`rd_title`,`rd_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `revision` ( 
 `rev_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `rev_page` int(10) unsigned NOT NULL,
 `rev_text_id` int(10) unsigned NOT NULL,
 `rev_comment` tinyblob NOT NULL,
 `rev_user` int(10) unsigned NOT NULL DEFAULT '0',
 `rev_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rev_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `rev_minor_edit` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rev_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rev_len` int(10) unsigned DEFAULT NULL,
 `rev_parent_id` int(10) unsigned DEFAULT NULL,
 `rev_sha1` varbinary(32) NOT NULL DEFAULT ,
 PRIMARY KEY (`rev_page`,`rev_id`),
 UNIQUE KEY `rev_id` (`rev_id`),
 KEY `rev_timestamp` (`rev_timestamp`),
 KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
 KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
 KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`),
 KEY `page_user_timestamp` (`rev_page`,`rev_user`,`rev_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 MAX_ROWS=10000000 AVG_ROW_LENGTH=1024 AUTO_INCREMENT=31918 ;

CREATE TABLE IF NOT EXISTS `revision` ( 
 `rev_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `rev_page` int(10) unsigned NOT NULL,
 `rev_text_id` int(10) unsigned NOT NULL,
 `rev_comment` tinyblob NOT NULL,
 `rev_user` int(10) unsigned NOT NULL DEFAULT '0',
 `rev_user_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `rev_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `rev_minor_edit` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rev_deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rev_len` int(10) unsigned DEFAULT NULL,
 `rev_parent_id` int(10) unsigned DEFAULT NULL,
 `rev_sha1` varbinary(32) NOT NULL DEFAULT ,
 PRIMARY KEY (`rev_id`),
 UNIQUE KEY `rev_page_id` (`rev_page`,`rev_id`),
 KEY `rev_timestamp` (`rev_timestamp`),
 KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
 KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
 KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`),
 KEY `page_user_timestamp` (`rev_page`,`rev_user`,`rev_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 MAX_ROWS=10000000 AVG_ROW_LENGTH=1024 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `searchindex` ( 
 `si_page` int(10) unsigned NOT NULL,
 `si_title` varchar(255) NOT NULL DEFAULT ,
 `si_text` mediumtext NOT NULL,
 UNIQUE KEY `si_page` (`si_page`),
 FULLTEXT KEY `si_title` (`si_title`),
 FULLTEXT KEY `si_text` (`si_text`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `searchindex` ( 
 `si_page` int(10) unsigned NOT NULL,
 `si_title` varchar(255) NOT NULL DEFAULT ,
 `si_text` mediumtext NOT NULL,
 UNIQUE KEY `si_page` (`si_page`),
 FULLTEXT KEY `si_title` (`si_title`),
 FULLTEXT KEY `si_text` (`si_text`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `site_stats` ( 
 `ss_row_id` int(10) unsigned NOT NULL,
 `ss_total_views` bigint(20) unsigned DEFAULT '0',
 `ss_total_edits` bigint(20) unsigned DEFAULT '0',
 `ss_good_articles` bigint(20) unsigned DEFAULT '0',
 `ss_total_pages` bigint(20) DEFAULT '-1',
 `ss_users` bigint(20) DEFAULT '-1',
 `ss_admins` int(11) DEFAULT '-1',
 `ss_images` int(11) DEFAULT '0',
 `ss_active_users` bigint(20) DEFAULT '-1',
 UNIQUE KEY `ss_row_id` (`ss_row_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `site_stats` ( 
 `ss_row_id` int(10) unsigned NOT NULL,
 `ss_total_views` bigint(20) unsigned DEFAULT '0',
 `ss_total_edits` bigint(20) unsigned DEFAULT '0',
 `ss_good_articles` bigint(20) unsigned DEFAULT '0',
 `ss_total_pages` bigint(20) DEFAULT '-1',
 `ss_users` bigint(20) DEFAULT '-1',
 `ss_active_users` bigint(20) DEFAULT '-1',
 `ss_admins` int(11) DEFAULT '-1',
 `ss_images` int(11) DEFAULT '0',
 UNIQUE KEY `ss_row_id` (`ss_row_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `tag_summary` ( 
 `ts_rc_id` int(11) DEFAULT NULL,
 `ts_log_id` int(11) DEFAULT NULL,
 `ts_rev_id` int(11) DEFAULT NULL,
 `ts_tags` blob NOT NULL,
 UNIQUE KEY `tag_summary_rc_id` (`ts_rc_id`),
 UNIQUE KEY `tag_summary_log_id` (`ts_log_id`),
 UNIQUE KEY `tag_summary_rev_id` (`ts_rev_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `tag_summary` ( 
 `ts_rc_id` int(11) DEFAULT NULL,
 `ts_log_id` int(11) DEFAULT NULL,
 `ts_rev_id` int(11) DEFAULT NULL,
 `ts_tags` blob NOT NULL,
 UNIQUE KEY `tag_summary_rc_id` (`ts_rc_id`),
 UNIQUE KEY `tag_summary_log_id` (`ts_log_id`),
 UNIQUE KEY `tag_summary_rev_id` (`ts_rev_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `templatelinks` ( 
 `tl_from` int(10) unsigned NOT NULL DEFAULT '0',
 `tl_namespace` int(11) NOT NULL DEFAULT '0',
 `tl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 UNIQUE KEY `tl_from` (`tl_from`,`tl_namespace`,`tl_title`),
 UNIQUE KEY `tl_namespace` (`tl_namespace`,`tl_title`,`tl_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `templatelinks` ( 
 `tl_from` int(10) unsigned NOT NULL DEFAULT '0',
 `tl_namespace` int(11) NOT NULL DEFAULT '0',
 `tl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 UNIQUE KEY `tl_from` (`tl_from`,`tl_namespace`,`tl_title`),
 UNIQUE KEY `tl_namespace` (`tl_namespace`,`tl_title`,`tl_from`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `text` ( 
 `old_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `old_text` mediumblob NOT NULL,
 `old_flags` tinyblob NOT NULL,
 PRIMARY KEY (`old_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 MAX_ROWS=10000000 AVG_ROW_LENGTH=10240 AUTO_INCREMENT=31486 ;

CREATE TABLE IF NOT EXISTS `text` ( 
 `old_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `old_text` mediumblob NOT NULL,
 `old_flags` tinyblob NOT NULL,
 PRIMARY KEY (`old_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 MAX_ROWS=10000000 AVG_ROW_LENGTH=10240 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `trackbacks` ( 
 `tb_id` int(11) NOT NULL AUTO_INCREMENT,
 `tb_page` int(11) DEFAULT NULL,
 `tb_title` varchar(255) NOT NULL,
 `tb_url` blob NOT NULL,
 `tb_ex` text,
 `tb_name` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`tb_id`),
 KEY `tb_page` (`tb_page`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

élément
CREATE TABLE IF NOT EXISTS `transcache` ( 
 `tc_url` varbinary(255) NOT NULL,
 `tc_contents` text,
 `tc_time` binary(14) DEFAULT NULL,
 UNIQUE KEY `tc_url_idx` (`tc_url`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `transcache` ( 

 `tc_url` varbinary(255) NOT NULL,
 `tc_contents` text,
 `tc_time` binary(14) NOT NULL,
 UNIQUE KEY `tc_url_idx` (`tc_url`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `updatelog` ( 
 `ul_key` varchar(255) NOT NULL,
 `ul_value` blob,
 PRIMARY KEY (`ul_key`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `updatelog` ( 
 `ul_key` varchar(255) NOT NULL,
 `ul_value` blob,
 PRIMARY KEY (`ul_key`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `uploadstash` ( 
 `us_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `us_user` int(10) unsigned NOT NULL,
 `us_key` varchar(255) NOT NULL,
 `us_orig_path` varchar(255) NOT NULL,
 `us_path` varchar(255) NOT NULL,
 `us_source_type` varchar(50) DEFAULT NULL,
 `us_timestamp` varbinary(14) NOT NULL,
 `us_status` varchar(50) NOT NULL,
 `us_size` int(10) unsigned NOT NULL,
 `us_sha1` varchar(31) NOT NULL,
 `us_mime` varchar(255) DEFAULT NULL,
 `us_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE',
   'TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
 `us_image_width` int(10) unsigned DEFAULT NULL,
 `us_image_height` int(10) unsigned DEFAULT NULL,
 `us_image_bits` smallint(5) unsigned DEFAULT NULL,
 `us_chunk_inx` int(10) unsigned DEFAULT NULL,
 PRIMARY KEY (`us_id`),
 UNIQUE KEY `us_key` (`us_key`),
 KEY `us_user` (`us_user`),
 KEY `us_timestamp` (`us_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `uploadstash` ( 
 `us_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `us_user` int(10) unsigned NOT NULL,
 `us_key` varchar(255) NOT NULL,
 `us_orig_path` varchar(255) NOT NULL,
 `us_path` varchar(255) NOT NULL,
 `us_source_type` varchar(50) DEFAULT NULL,
 `us_timestamp` varbinary(14) NOT NULL,
 `us_status` varchar(50) NOT NULL,
 `us_chunk_inx` int(10) unsigned DEFAULT NULL,
 `us_size` int(10) unsigned NOT NULL,
 `us_sha1` varchar(31) NOT NULL,
 `us_mime` varchar(255) DEFAULT NULL,
 `us_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE',
   'TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
 `us_image_width` int(10) unsigned DEFAULT NULL,
 `us_image_height` int(10) unsigned DEFAULT NULL,
 `us_image_bits` smallint(5) unsigned DEFAULT NULL,
 PRIMARY KEY (`us_id`),
 UNIQUE KEY `us_key` (`us_key`),
 KEY `us_user` (`us_user`),
 KEY `us_timestamp` (`us_timestamp`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `user` ( 
 `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `user_real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `user_password` tinyblob NOT NULL,
 `user_newpassword` tinyblob NOT NULL,
 `user_newpass_time` binary(14) DEFAULT NULL,
 `user_email` tinytext NOT NULL,
 `user_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `user_token` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `user_email_authenticated` binary(14) DEFAULT NULL,
 `user_email_token` binary(32) DEFAULT NULL,
 `user_email_token_expires` binary(14) DEFAULT NULL,
 `user_registration` binary(14) DEFAULT NULL,
 `user_editcount` int(11) DEFAULT NULL,
 PRIMARY KEY (`user_id`),
 UNIQUE KEY `user_name` (`user_name`),
 KEY `user_email_token` (`user_email_token`),
 KEY `user_email` (`user_email`(50))

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2173 ;

CREATE TABLE IF NOT EXISTS `user` ( 
 `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `user_real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `user_password` tinyblob NOT NULL,
 `user_newpassword` tinyblob NOT NULL,
 `user_newpass_time` binary(14) DEFAULT NULL,
 `user_email` tinytext NOT NULL,
 `user_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `user_token` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
 `user_email_authenticated` binary(14) DEFAULT NULL,
 `user_email_token` binary(32) DEFAULT NULL,
 `user_email_token_expires` binary(14) DEFAULT NULL,
 `user_registration` binary(14) DEFAULT NULL,
 `user_editcount` int(11) DEFAULT NULL,
 PRIMARY KEY (`user_id`),
 UNIQUE KEY `user_name` (`user_name`),
 KEY `user_email_token` (`user_email_token`),
 KEY `user_email` (`user_email`(50))

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `user_former_groups` ( 
 `ufg_user` int(10) unsigned NOT NULL DEFAULT '0',
 `ufg_group` varbinary(32) NOT NULL DEFAULT ,
 UNIQUE KEY `ufg_user_group` (`ufg_user`,`ufg_group`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `user_former_groups` ( 
 `ufg_user` int(10) unsigned NOT NULL DEFAULT '0',
 `ufg_group` varbinary(32) NOT NULL DEFAULT ,
 UNIQUE KEY `ufg_user_group` (`ufg_user`,`ufg_group`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `user_groups` ( 
 `ug_user` int(10) unsigned NOT NULL DEFAULT '0',
 `ug_group` varbinary(32) NOT NULL DEFAULT ,
 PRIMARY KEY (`ug_user`,`ug_group`),
 KEY `ug_group` (`ug_group`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `user_groups` ( 
 `ug_user` int(10) unsigned NOT NULL DEFAULT '0',
 `ug_group` varbinary(32) NOT NULL DEFAULT ,
 UNIQUE KEY `ug_user_group` (`ug_user`,`ug_group`),
 KEY `ug_group` (`ug_group`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `user_newtalk` ( 
 `user_id` int(11) NOT NULL DEFAULT '0',
 `user_ip` varbinary(40) NOT NULL DEFAULT ,
 `user_last_timestamp` varbinary(14) DEFAULT NULL,
 KEY `user_id` (`user_id`),
 KEY `user_ip` (`user_ip`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `user_newtalk` ( 
 `user_id` int(11) NOT NULL DEFAULT '0',
 `user_ip` varbinary(40) NOT NULL DEFAULT ,
 `user_last_timestamp` varbinary(14) DEFAULT NULL,
 KEY `user_id` (`user_id`),
 KEY `user_ip` (`user_ip`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `user_properties` ( 
 `up_user` int(11) NOT NULL,
 `up_property` varbinary(255) DEFAULT NULL,
 `up_value` blob,
 UNIQUE KEY `user_properties_user_property` (`up_user`,`up_property`),
 KEY `user_properties_property` (`up_property`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `user_properties` ( 

 `up_user` int(11) NOT NULL,
 `up_property` varbinary(255) NOT NULL,
 `up_value` blob,
 UNIQUE KEY `user_properties_user_property` (`up_user`,`up_property`),
 KEY `user_properties_property` (`up_property`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `valid_tag` ( 
 `vt_tag` varchar(255) NOT NULL,
 PRIMARY KEY (`vt_tag`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `valid_tag` ( 
 `vt_tag` varchar(255) NOT NULL,
 PRIMARY KEY (`vt_tag`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `watchlist` ( 
 `wl_user` int(10) unsigned NOT NULL,
 `wl_namespace` int(11) NOT NULL DEFAULT '0',
 `wl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `wl_notificationtimestamp` varbinary(14) DEFAULT NULL,
 UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`),
 KEY `namespace_title` (`wl_namespace`,`wl_title`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `watchlist` ( 

 `wl_user` int(10) unsigned NOT NULL,
 `wl_namespace` int(11) NOT NULL DEFAULT '0',
 `wl_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ,
 `wl_notificationtimestamp` varbinary(14) DEFAULT NULL,
 UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`),
 KEY `namespace_title` (`wl_namespace`,`wl_title`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

élément élément
Récupérée de « http://fr.vikidia.org/w/index.php?title=Vikidia:Demandes_aux_développeurs/es.vikidia&oldid=516974 »