Déposer des fichiers ici

Téléversement SQL ( 0 ) x -

Serveur: localhost »Base de données: journalsbdd
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 320,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 36 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 59 InnoDB utf8_general_ci 64,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 5 InnoDB utf8_general_ci 80,0 kio -
navigation_menus 3 InnoDB utf8_general_ci 16,0 kio -
navigation_menu_items 24 InnoDB utf8_general_ci 16,0 kio -
navigation_menu_item_assignments 23 InnoDB utf8_general_ci 16,0 kio -
navigation_menu_item_assignment_settings 0 InnoDB utf8_general_ci 32,0 kio -
navigation_menu_item_settings 24 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 39 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 1 InnoDB utf8_general_ci 32,0 kio -
section_settings 3 InnoDB utf8_general_ci 32,0 kio -
sessions 20 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 13 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 18 InnoDB utf8_general_ci 64,0 kio -
user_group_settings 139 InnoDB utf8_general_ci 16,0 kio -
user_group_stage 31 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 2 InnoDB utf8_general_ci 48,0 kio -
versions 50 InnoDB utf8_general_ci 32,0 kio -
114 tables Somme 809 InnoDB utf8mb4_general_ci 4,2 Mio 0 o

Nouvelle table
Nom:
Nombre de colonnes: