Déposer des fichiers ici

Téléversement SQL ( 0 ) x -

Serveur: localhost »Base de données: journalsbddcopy
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 6 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 5 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 118 InnoDB utf8_general_ci 144,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 12 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 5 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 10 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 2 InnoDB utf8_general_ci 32,0 kio -
journal_settings 83 InnoDB utf8_general_ci 80,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 7 InnoDB utf8_general_ci 80,0 kio -
navigation_menus 3 InnoDB utf8_general_ci 16,0 kio -
navigation_menu_items 34 InnoDB utf8_general_ci 16,0 kio -
navigation_menu_item_assignments 29 InnoDB utf8_general_ci 16,0 kio -
navigation_menu_item_assignment_settings 1 InnoDB utf8_general_ci 32,0 kio -
navigation_menu_item_settings 92 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 43 InnoDB utf8_general_ci 32,0 kio -
publications 1 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 6 InnoDB utf8_general_ci 32,0 kio -
site 1 InnoDB utf8_general_ci 16,0 kio -
site_settings 4 InnoDB utf8_general_ci 16,0 kio -
stage_assignments 1 InnoDB utf8_general_ci 80,0 kio -
static_pages 9 InnoDB utf8_general_ci 16,0 kio -
static_page_settings 18 InnoDB utf8_general_ci 64,0 kio -
subeditor_submission_group 0 InnoDB utf8_general_ci 64,0 kio -
submissions 1 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 31 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 104 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 866 InnoDB utf8mb4_general_ci 4,0 Mio 0 o

Nouvelle table
Nom:
Nombre de colonnes: