Manuel:table uploadstash
| ↑ Manuel:Contenu | Schéma de base de données MédiaWiki | table uploadstash |
| Version de MediaWiki : | ≥ 1.18 |
La table uploadstash enregistre les informations concernant les fichiers téléversés récemment, avant qu'ils ne soient stockés dans le dépôt actuel, voir également Manual:UploadStash. Elle contient les informations à propos des téléversements incomplets qui peuvent se produire par exemple lorsque l'utilisateur quitte la page de téléversement avant que celui-ci ne soit terminé. Le script de maintenance cleanupUploadStash.php peut être utilisé pour supprimer les entrées orphelines de cette table.
Champs
us_id
Clé primaire.
us_user
Utilisateur qui a téléversé le fichier.
us_key
Clé du fichier. C'est la manière pour les applications, de rechercher le fichier. Ceci pourrait disparaître, ou devenir la clé primaire.
us_orig_path
Chemin originel.
us_path
Chemin temporaire de l'emplacement du fichier.
us_source_type
Type de téléversement par lequel le fichier est arrivé (quelques fois). Par exemple : "url"
us_timestamp
Date et heure à laquelle le fichier a été ajouté
us_status
Par exemple : "finished"
us_chunk_inx
| Version de MediaWiki : | ≥ 1.19 |
Le compteur de blocs commence à zéro, le décalage actuel est enregistré dans us_size
us_props
| Version de MediaWiki : | ≥ 1.21 |
Propriétés de fichier sérialisé de File::getPropsFromPath
us_size
Propriétés de fichier File::getPropsFromPath. Ceci peut s'avérer inutile.
us_sha1
Cette valeur de hachage provient de File::sha1Base36() et s'étend sur 31 caractères
us_mime
Combinaison de img_major_mime et img_minor_mime. Par exemple : image/png
us_media_type
Type de média tel qu'il est défini par les constantes MEDIATYPE_xxx, doit correspondre à la définition de la table des images.
us_image_width
Propriété spécifique des images.
us_image_height
Propriété spécifique des images.
us_image_bits
Propriétés spécifiques des images.
Résumé du schéma
| Version de MediaWiki : | ≥ 1.41 |
DESCRIBE uploadstash;
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| us_user | int(10) unsigned | NO | MUL | NULL | |
| us_key | varbinary(255) | NO | UNI | NULL | |
| us_orig_path | varbinary(255) | NO | | NULL | |
| us_path | varbinary(255) | NO | | NULL | |
| us_source_type | varbinary(50) | YES | | NULL | |
| us_timestamp | binary(14) | NO | MUL | NULL | |
| us_status | varbinary(50) | NO | | NULL | |
| us_chunk_inx | int(10) unsigned | YES | | NULL | |
| us_props | blob | YES | | NULL | |
| us_size | bigint(20) unsigned | NO | | NULL | |
| us_sha1 | varbinary(31) | NO | | NULL | |
| us_mime | varbinary(255) | YES | | NULL | |
| us_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| us_image_width | int(10) unsigned | YES | | NULL | |
| us_image_height | int(10) unsigned | YES | | NULL | |
| us_image_bits | smallint(5) unsigned | YES | | NULL | |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Versions de MediaWiki : | 1.36 – 1.40 |
DESCRIBE uploadstash;
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| us_user | int(10) unsigned | NO | MUL | NULL | |
| us_key | varbinary(255) | NO | UNI | NULL | |
| us_orig_path | varbinary(255) | NO | | NULL | |
| us_path | varbinary(255) | NO | | NULL | |
| us_source_type | varbinary(50) | YES | | NULL | |
| us_timestamp | binary(14) | NO | MUL | NULL | |
| us_status | varbinary(50) | NO | | NULL | |
| us_chunk_inx | int(10) unsigned | YES | | NULL | |
| us_props | blob | YES | | NULL | |
| us_size | int(10) unsigned | NO | | NULL | |
| us_sha1 | varbinary(31) | NO | | NULL | |
| us_mime | varbinary(255) | YES | | NULL | |
| us_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| us_image_width | int(10) unsigned | YES | | NULL | |
| us_image_height | int(10) unsigned | YES | | NULL | |
| us_image_bits | smallint(5) unsigned | YES | | NULL | |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Versions de MediaWiki : | 1.30 – 1.35 |
DESCRIBE uploadstash;
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| us_user | int(10) unsigned | NO | MUL | NULL | |
| us_key | varbinary(255) | NO | UNI | NULL | |
| us_orig_path | varbinary(255) | NO | | NULL | |
| us_path | varbinary(255) | NO | | NULL | |
| us_source_type | varbinary(50) | YES | | NULL | |
| us_timestamp | varbinary(14) | NO | MUL | NULL | |
| us_status | varbinary(50) | NO | | NULL | |
| us_chunk_inx | int(10) unsigned | YES | | NULL | |
| us_props | blob | YES | | NULL | |
| us_size | int(10) unsigned | NO | | NULL | |
| us_sha1 | varbinary(31) | NO | | NULL | |
| us_mime | varbinary(255) | YES | | NULL | |
| us_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| us_image_width | int(10) unsigned | YES | | NULL | |
| us_image_height | int(10) unsigned | YES | | NULL | |
| us_image_bits | smallint(5) unsigned | YES | | NULL | |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Versions de MediaWiki : | 1.21 – 1.29 |
DESCRIBE uploadstash;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| us_user | int(10) unsigned | NO | MUL | NULL | |
| us_key | varbinary(255) | NO | UNI | NULL | |
| us_orig_path | varbinary(255) | NO | | NULL | |
| us_path | varbinary(255) | NO | | NULL | |
| us_source_type | varbinary(50) | YES | | NULL | |
| us_timestamp | varbinary(14) | NO | MUL | NULL | |
| us_status | varbinary(50) | NO | | NULL | |
| us_chunk_inx | int(10) unsigned | YES | | NULL | |
| us_props | blob | YES | | NULL | |
| us_size | int(10) unsigned | NO | | NULL | |
| us_sha1 | varbinary(31) | NO | | NULL | |
| us_mime | varbinary(255) | YES | | NULL | |
| us_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| us_image_width | int(10) unsigned | YES | | NULL | |
| us_image_height | int(10) unsigned | YES | | NULL | |
| us_image_bits | smallint(5) unsigned | YES | | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Versions de MediaWiki : | 1.19 – 1.20 |
DESCRIBE uploadstash;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| us_user | int(10) unsigned | NO | MUL | NULL | |
| us_key | varbinary(255) | NO | UNI | NULL | |
| us_orig_path | varbinary(255) | NO | | NULL | |
| us_path | varbinary(255) | NO | | NULL | |
| us_source_type | varbinary(50) | YES | | NULL | |
| us_timestamp | varbinary(14) | NO | MUL | NULL | |
| us_status | varbinary(50) | NO | | NULL | |
| us_chunk_inx | int(10) unsigned | YES | | NULL | |
| us_size | int(10) unsigned | NO | | NULL | |
| us_sha1 | varbinary(31) | NO | | NULL | |
| us_mime | varbinary(255) | YES | | NULL | |
| us_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| us_image_width | int(10) unsigned | YES | | NULL | |
| us_image_height | int(10) unsigned | YES | | NULL | |
| us_image_bits | smallint(5) unsigned | YES | | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Version de MediaWiki : | 1.18 |
DESCRIBE uploadstash;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| us_user | int(10) unsigned | NO | MUL | NULL | |
| us_key | varbinary(255) | NO | UNI | NULL | |
| us_orig_path | varbinary(255) | NO | | NULL | |
| us_path | varbinary(255) | NO | | NULL | |
| us_source_type | varbinary(50) | YES | | NULL | |
| us_timestamp | varbinary(14) | NO | MUL | NULL | |
| us_status | varbinary(50) | NO | | NULL | |
| us_size | int(10) unsigned | NO | | NULL | |
| us_sha1 | varbinary(31) | NO | | NULL | |
| us_mime | varbinary(255) | YES | | NULL | |
| us_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| us_image_width | int(10) unsigned | YES | | NULL | |
| us_image_height | int(10) unsigned | YES | | NULL | |
| us_image_bits | smallint(5) unsigned | YES | | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Les index
| Version de MediaWiki : | ≥ 1.18 |
SHOW INDEX IN uploadstash;
+-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | uploadstash | 0 | PRIMARY | 1 | us_id | A | 0 | NULL | NULL | | BTREE | | | | uploadstash | 0 | us_key | 1 | us_key | A | 0 | NULL | NULL | | BTREE | | | | uploadstash | 1 | us_user | 1 | us_user | A | 0 | NULL | NULL | | BTREE | | | | uploadstash | 1 | us_timestamp | 1 | us_timestamp | A | 0 | NULL | NULL | | BTREE | | | +-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+