Déposer des fichiers ici

Téléversement SQL ( 0 ) x -

Serveur: localhost »Base de données: dpub_mainbdd
Paramètres relatifs à la page Cliquer sur la barre pour faire défiler en haut de page
Faire Ctrl+Entrée pour exécuter la requête Faire Entrée pour exécuter la requête
croissant
décroissant
Ordre :
Déboguer SQL
Nombre
Ordre d'exécution
Temps nécessaire
Trier par :
Regrouper les requêtes
Dissocier les groupes
Réduire Développer Afficher le suivi Masquer le suivi Nombre Temps nécessaire
Signets
Actualiser
Ajouter
Aucun signet
Ajouter un signet
Options
Définir par défaut





Réduire Développer Exécuter la requête à nouveau Éditer Expliquer Profilage Signet La requête a échoué Base de données : Daté du :

Structure de base de données

Choisir les détails à afficher dans la liste des tables.

Documentation Afficher ou masquer une colonne affichant le jeu de caractères pour toutes les tables.
Documentation Afficher ou masquer une colonne affichant les commentaires pour toutes les tables.
Documentation Afficher ou masquer une colonne contenant la date de création pour toutes les tables.
Documentation Afficher ou masquer une colonne contenant l'horodatage de dernière mise à jour pour toutes les tables.
Documentation Afficher ou masquer une colonne contenant l'horodatage de dernière vérification pour toutes les tables.
Filtres
Table Croissant Décroissant Action Lignes Peut être approximatif. Cliquer sur le nombre pour obtenir le compte exact. Voir FAQ 3.11. Type Interclassement Taille Perte
access_keys 0 InnoDB utf8_general_ci 32,0 kio -
announcements 0 InnoDB utf8_general_ci 32,0 kio -
announcement_settings 0 InnoDB utf8_general_ci 32,0 kio -
announcement_types 0 InnoDB utf8_general_ci 32,0 kio -
announcement_type_settings 0 InnoDB utf8_general_ci 32,0 kio -
authors 0 InnoDB utf8_general_ci 32,0 kio -
author_settings 0 InnoDB utf8_general_ci 32,0 kio -
auth_sources 0 InnoDB utf8_general_ci 16,0 kio -
categories 0 InnoDB utf8_general_ci 48,0 kio -
category_settings 0 InnoDB utf8_general_ci 16,0 kio -
citations 0 InnoDB utf8_general_ci 48,0 kio -
citation_settings 0 InnoDB utf8_general_ci 32,0 kio -
completed_payments 0 InnoDB utf8_general_ci 16,0 kio -
controlled_vocabs 0 InnoDB utf8_general_ci 32,0 kio -
controlled_vocab_entries 0 InnoDB utf8_general_ci 32,0 kio -
controlled_vocab_entry_settings 0 InnoDB utf8_general_ci 32,0 kio -
custom_issue_orders 0 InnoDB utf8_general_ci 16,0 kio -
custom_section_orders 0 InnoDB utf8_general_ci 16,0 kio -
data_object_tombstones 0 InnoDB utf8_general_ci 32,0 kio -
data_object_tombstone_oai_set_objects 0 InnoDB utf8_general_ci 32,0 kio -
data_object_tombstone_settings 0 InnoDB utf8_general_ci 32,0 kio -
edit_decisions 0 InnoDB utf8_general_ci 48,0 kio -
email_log 0 InnoDB utf8_general_ci 32,0 kio -
email_log_users 0 InnoDB utf8_general_ci 16,0 kio -
email_templates 0 InnoDB utf8_general_ci 32,0 kio -
email_templates_default 59 InnoDB utf8_general_ci 32,0 kio -
email_templates_default_data 177 InnoDB utf8_general_ci 192,0 kio -
email_templates_settings 0 InnoDB utf8_general_ci 32,0 kio -
event_log 0 InnoDB utf8_general_ci 32,0 kio -
event_log_settings 0 InnoDB utf8_general_ci 48,0 kio -
files 0 InnoDB utf8_general_ci 16,0 kio -
filters 27 InnoDB utf8_general_ci 16,0 kio -
filter_groups 27 InnoDB utf8_general_ci 32,0 kio -
filter_settings 0 InnoDB utf8_general_ci 32,0 kio -
genres 12 InnoDB utf8_general_ci 16,0 kio -
genre_settings 24 InnoDB utf8_general_ci 32,0 kio -
institutional_subscriptions 0 InnoDB utf8_general_ci 48,0 kio -
institutional_subscription_ip 0 InnoDB utf8_general_ci 64,0 kio -
issues 0 InnoDB utf8_general_ci 48,0 kio -
issue_files 0 InnoDB utf8_general_ci 32,0 kio -
issue_galleys 0 InnoDB utf8_general_ci 48,0 kio -
issue_galley_settings 0 InnoDB utf8_general_ci 32,0 kio -
issue_settings 0 InnoDB utf8_general_ci 48,0 kio -
item_views 0 InnoDB utf8_general_ci 32,0 kio -
jobs 0 InnoDB utf8_general_ci 32,0 kio -
journals 1 InnoDB utf8_general_ci 32,0 kio -
journal_settings 42 InnoDB utf8_general_ci 32,0 kio -
library_files 0 InnoDB utf8_general_ci 48,0 kio -
library_file_settings 0 InnoDB utf8_general_ci 32,0 kio -
metadata_descriptions 0 InnoDB utf8_general_ci 32,0 kio -
metadata_description_settings 0 InnoDB utf8_general_ci 32,0 kio -
metrics 0 InnoDB utf8_general_ci 80,0 kio -
navigation_menus 1 InnoDB utf8_general_ci 16,0 kio -
navigation_menu_items 7 InnoDB utf8_general_ci 16,0 kio -
navigation_menu_item_assignments 7 InnoDB utf8_general_ci 16,0 kio -
navigation_menu_item_assignment_settings 0 InnoDB utf8_general_ci 32,0 kio -
navigation_menu_item_settings 7 InnoDB utf8_general_ci 32,0 kio -
notes 0 InnoDB utf8_general_ci 32,0 kio -
notifications 0 InnoDB utf8_general_ci 80,0 kio -
notification_mail_list 0 InnoDB utf8_general_ci 32,0 kio -
notification_settings 0 InnoDB utf8_general_ci 32,0 kio -
notification_subscription_settings 0 InnoDB utf8_general_ci 16,0 kio -
oai_resumption_tokens 0 InnoDB utf8_general_ci 16,0 kio -
plugin_settings 16 InnoDB utf8_general_ci 32,0 kio -
publications 0 InnoDB utf8_general_ci 64,0 kio -
publication_categories 0 InnoDB utf8_general_ci 16,0 kio -
publication_galleys 0 InnoDB utf8_general_ci 64,0 kio -
publication_galley_settings 0 InnoDB utf8_general_ci 48,0 kio -
publication_settings 0 InnoDB utf8_general_ci 48,0 kio -
queries 0 InnoDB utf8_general_ci 32,0 kio -
query_participants 0 InnoDB utf8_general_ci 16,0 kio -
queued_payments 0 InnoDB utf8_general_ci 16,0 kio -
review_assignments 0 InnoDB utf8_general_ci 80,0 kio -
review_files 0 InnoDB utf8_general_ci 48,0 kio -
review_forms 0 InnoDB utf8_general_ci 16,0 kio -
review_form_elements 0 InnoDB utf8_general_ci 32,0 kio -
review_form_element_settings 0 InnoDB utf8_general_ci 32,0 kio -
review_form_responses 0 InnoDB utf8_general_ci 32,0 kio -
review_form_settings 0 InnoDB utf8_general_ci 32,0 kio -
review_rounds 0 InnoDB utf8_general_ci 48,0 kio -
review_round_files 0 InnoDB utf8_general_ci 48,0 kio -
scheduled_tasks 7 InnoDB utf8_general_ci 16,0 kio -
sections 0 InnoDB utf8_general_ci 32,0 kio -
section_settings 0 InnoDB utf8_general_ci 32,0 kio -
sessions 5 InnoDB utf8_general_ci 32,0 kio -
site 1 InnoDB utf8_general_ci 16,0 kio -
site_settings 5 InnoDB utf8_general_ci 16,0 kio -
stage_assignments 0 InnoDB utf8_general_ci 80,0 kio -
static_pages 0 InnoDB utf8_general_ci 16,0 kio -
static_page_settings 0 InnoDB utf8_general_ci 32,0 kio -
subeditor_submission_group 0 InnoDB utf8_general_ci 64,0 kio -
submissions 0 InnoDB utf8_general_ci 48,0 kio -
submission_comments 0 InnoDB utf8_general_ci 32,0 kio -
submission_files 0 InnoDB utf8_general_ci 64,0 kio -
submission_file_revisions 0 InnoDB utf8_general_ci 48,0 kio -
submission_file_settings 0 InnoDB utf8_general_ci 32,0 kio -
submission_search_keyword_list 0 InnoDB utf8_general_ci 32,0 kio -
submission_search_objects 0 InnoDB utf8_general_ci 32,0 kio -
submission_search_object_keywords 0 InnoDB utf8_general_ci 32,0 kio -
submission_settings 0 InnoDB utf8_general_ci 32,0 kio -
submission_tombstones 0 InnoDB utf8_general_ci 48,0 kio -
subscriptions 0 InnoDB utf8_general_ci 16,0 kio -
subscription_types 0 InnoDB utf8_general_ci 16,0 kio -
subscription_type_settings 0 InnoDB utf8_general_ci 32,0 kio -
temporary_files 0 InnoDB utf8_general_ci 32,0 kio -
usage_stats_temporary_records 0 InnoDB utf8_general_ci 16,0 kio -
users 1 InnoDB utf8_general_ci 48,0 kio -
user_groups 15 InnoDB utf8_general_ci 64,0 kio -
user_group_settings 108 InnoDB utf8_general_ci 16,0 kio -
user_group_stage 30 InnoDB utf8_general_ci 64,0 kio -
user_interests 0 InnoDB utf8_general_ci 16,0 kio -
user_settings 2 InnoDB utf8_general_ci 48,0 kio -
user_user_groups 1 InnoDB utf8_general_ci 48,0 kio -
versions 48 InnoDB utf8_general_ci 32,0 kio -
114 tables Somme 630 InnoDB utf8_unicode_ci 4,0 Mio 0 o

Nouvelle table
Nom:
Nombre de colonnes: