INSERT INTO `leshommesdebout_wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES
(1891, 'wise_chat_options_name', 'a:146:{s:11:\"access_mode\";i:0;s:12:\"access_roles\";a:1:{i:0;s:13:\"administrator\";}s:25:\"force_user_name_selection\";i:0;s:23:\"read_only_for_anonymous\";i:0;s:12:\"user_actions\";N;s:18:\"collect_user_stats\";i:1;s:22:\"enable_opening_control\";i:0;s:12:\"opening_days\";a:5:{i:0;s:6:\"Monday\";i:1;s:7:\"Tuesday\";i:2;s:9:\"Wednesday\";i:3;s:8:\"Thursday\";i:4;s:6:\"Friday\";}s:13:\"opening_hours\";a:4:{s:7:\"opening\";s:4:\"8:00\";s:11:\"openingMode\";s:2:\"AM\";s:7:\"closing\";s:4:\"4:00\";s:11:\"closingMode\";s:2:\"PM\";}s:19:\"read_only_for_roles\";a:0:{}s:23:\"anonymous_login_enabled\";i:0;s:22:\"facebook_login_enabled\";i:0;s:21:\"facebook_login_app_id\";s:0:\"\";s:25:\"facebook_login_app_secret\";s:0:\"\";s:21:\"twitter_login_enabled\";i:0;s:21:\"twitter_login_api_key\";s:0:\"\";s:24:\"twitter_login_api_secret\";s:0:\"\";s:20:\"google_login_enabled\";i:0;s:22:\"google_login_client_id\";s:0:\"\";s:26:\"google_login_client_secret\";s:0:\"\";s:26:\"enable_title_notifications\";i:0;s:24:\"enable_join_notification\";i:1;s:23:\"join_sound_notification\";s:0:\"\";s:25:\"enable_leave_notification\";i:1;s:24:\"leave_sound_notification\";s:0:\"\";s:26:\"mention_sound_notification\";s:0:\"\";s:18:\"sound_notification\";s:0:\"\";s:18:\"message_max_length\";i:400;s:16:\"allow_post_links\";i:0;s:17:\"emoticons_enabled\";i:1;s:17:\"allow_post_images\";i:0;s:22:\"enable_images_uploader\";i:0;s:23:\"enable_twitter_hashtags\";i:0;s:27:\"enable_attachments_uploader\";i:0;s:24:\"attachments_file_formats\";s:12:\"pdf,doc,docx\";s:22:\"attachments_size_limit\";i:3145728;s:17:\"images_size_limit\";i:3145728;s:18:\"images_width_limit\";i:1000;s:19:\"images_height_limit\";i:1000;s:28:\"images_thumbnail_width_limit\";i:60;s:29:\"images_thumbnail_height_limit\";i:60;s:14:\"enable_youtube\";i:0;s:13:\"youtube_width\";i:186;s:14:\"youtube_height\";i:105;s:22:\"enable_message_actions\";i:0;s:30:\"permission_delete_message_role\";s:13:\"administrator\";s:24:\"permission_ban_user_role\";s:13:\"administrator\";s:23:\"moderation_ban_duration\";i:1440;s:5:\"theme\";s:0:\"\";s:21:\"background_color_chat\";s:0:\"\";s:15:\"text_color_chat\";s:0:\"\";s:14:\"text_size_chat\";s:0:\"\";s:14:\"messages_limit\";i:30;s:16:\"background_color\";s:0:\"\";s:22:\"background_color_input\";s:0:\"\";s:10:\"text_color\";s:0:\"\";s:15:\"text_color_user\";s:0:\"\";s:22:\"text_color_logged_user\";s:0:\"\";s:22:\"text_color_input_field\";s:0:\"\";s:10:\"chat_width\";s:4:\"100%\";s:11:\"chat_height\";s:5:\"200px\";s:14:\"show_user_name\";i:0;s:17:\"link_wp_user_name\";i:0;s:23:\"link_user_name_template\";s:0:\"\";s:26:\"show_message_submit_button\";i:0;s:22:\"allow_change_user_name\";i:0;s:17:\"multiline_support\";i:0;s:10:\"show_users\";i:0;s:18:\"show_users_counter\";i:0;s:23:\"input_controls_location\";s:0:\"\";s:14:\"messages_order\";s:0:\"\";s:13:\"custom_styles\";s:0:\"\";s:16:\"allow_mute_sound\";s:0:\"\";s:18:\"messages_time_mode\";s:0:\"\";s:27:\"background_color_users_list\";s:0:\"\";s:21:\"text_color_users_list\";s:0:\"\";s:9:\"text_size\";s:0:\"\";s:20:\"text_size_users_list\";s:0:\"\";s:23:\"allow_change_text_color\";i:0;s:16:\"users_list_width\";s:0:\"\";s:27:\"show_emoticon_insert_button\";i:1;s:16:\"show_users_flags\";i:0;s:27:\"show_users_city_and_country\";i:0;s:19:\"autohide_users_list\";i:0;s:25:\"autohide_users_list_width\";i:300;s:25:\"users_list_hide_anonymous\";i:0;s:21:\"users_list_hide_roles\";a:0:{}s:18:\"users_list_linking\";i:0;s:8:\"channels\";N;s:13:\"admin_actions\";N;s:16:\"auto_clean_after\";N;s:19:\"channel_users_limit\";N;s:14:\"channels_limit\";N;s:16:\"filter_bad_words\";i:1;s:7:\"filters\";N;s:10:\"filter_add\";N;s:26:\"bad_words_replacement_text\";s:0:\"\";s:4:\"bans\";N;s:7:\"ban_add\";N;s:14:\"enable_autoban\";i:0;s:17:\"autoban_threshold\";s:1:\"3\";s:16:\"autoban_duration\";i:1440;s:20:\"enable_flood_control\";i:0;s:23:\"flood_control_threshold\";i:200;s:24:\"flood_control_time_frame\";i:1;s:26:\"flood_control_ban_duration\";i:1440;s:12:\"hint_message\";s:18:\"Enter message here\";s:16:\"user_name_prefix\";s:9:\"Anonymous\";s:29:\"message_submit_button_caption\";s:4:\"Send\";s:12:\"message_save\";s:4:\"Save\";s:13:\"message_reset\";s:5:\"Reset\";s:12:\"message_name\";s:4:\"Name\";s:17:\"message_customize\";s:9:\"Customize\";s:15:\"message_sending\";s:11:\"Sending ...\";s:15:\"message_error_1\";s:65:\"Only letters, number, spaces, hyphens and underscores are allowed\";s:15:\"message_error_2\";s:29:\"This name is already occupied\";s:15:\"message_error_3\";s:37:\"You were banned from posting messages\";s:15:\"message_error_4\";s:50:\"Only logged in users are allowed to enter the chat\";s:15:\"message_error_5\";s:22:\"The chat is closed now\";s:15:\"message_error_6\";s:38:\"The chat is full now. Try again later.\";s:15:\"message_error_7\";s:25:\"Unsupported type of file.\";s:15:\"message_error_8\";s:43:\"The size of the file exceeds allowed limit.\";s:15:\"message_error_9\";s:17:\"Invalid password.\";s:16:\"message_error_10\";s:90:\"You cannot enter the chat due to the limit of channels you can participate simultaneously.\";s:16:\"message_error_11\";s:38:\"You are not allowed to enter the chat.\";s:12:\"window_title\";s:0:\"\";s:19:\"message_mute_sounds\";s:11:\"Mute sounds\";s:18:\"message_text_color\";s:10:\"Text color\";s:19:\"message_total_users\";s:11:\"Total users\";s:15:\"message_sec_ago\";s:8:\"sec. ago\";s:15:\"message_min_ago\";s:8:\"min. ago\";s:17:\"message_yesterday\";s:9:\"yesterday\";s:23:\"message_insert_emoticon\";s:18:\"Insert an emoticon\";s:27:\"message_insert_into_message\";s:19:\"Insert into message\";s:27:\"message_picture_upload_hint\";s:16:\"Upload a picture\";s:24:\"message_attach_file_hint\";s:13:\"Attach a file\";s:43:\"message_channel_password_authorization_hint\";s:47:\"This channel is protected. Enter your password:\";s:13:\"message_login\";s:6:\"Log in\";s:23:\"message_enter_user_name\";s:19:\"Enter your username\";s:19:\"message_input_title\";s:49:\"Use Shift+ENTER in order to move to the next line\";s:28:\"message_has_left_the_channel\";s:20:\"has left the channel\";s:30:\"message_has_joined_the_channel\";s:22:\"has joined the channel\";s:11:\"ajax_engine\";s:11:\"lightweight\";s:21:\"messages_refresh_time\";i:3000;s:15:\"show_powered_by\";i:1;s:13:\"enabled_debug\";i:0;}', 'yes'),
(1706, 'kiwi_settings', 'a:13:{s:20:\"kiwi-enable-on-posts\";s:1:\"1\";s:20:\"kiwi-enable-on-pages\";s:1:\"1\";s:26:\"kiwi-enable-share-position\";s:11:\"after-posts\";s:18:\"kiwi-display-sizes\";s:15:\"kiwi-large-size\";s:20:\"kiwi-enable-facebook\";s:1:\"1\";s:19:\"kiwi-enable-twitter\";s:1:\"1\";s:23:\"kiwi-enable-google-plus\";s:1:\"1\";s:21:\"kiwi-enable-pinterest\";s:1:\"1\";s:20:\"kiwi-enable-linkedin\";s:1:\"1\";s:18:\"kiwi-enable-reddit\";s:1:\"1\";s:17:\"kiwi-enable-email\";s:1:\"1\";s:22:\"general-settings-order\";s:0:\"\";s:25:\"kiwi-design-choose-layout\";s:18:\"kiwi-default-style\";}', 'yes'),
(1707, 'uncr_settings', 'a:9:{s:15:\"public_key_text\";s:0:\"\";s:16:\"private_key_text\";s:0:\"\";s:19:\"captcha_theme_radio\";s:5:\"light\";s:18:\"captcha_type_radio\";s:5:\"image\";s:23:\"captcha_language_select\";s:0:\"\";s:15:\"uncr_login_form\";s:0:\"\";s:18:\"uncr_register_form\";s:0:\"\";s:17:\"uncr_comment_form\";s:0:\"\";s:13:\"uncr_lost_pwd\";s:0:\"\";}', 'yes'),
(1716, 'bp-blogs-first-install', '', 'yes'),
(1717, 'bp-disable-profile-sync', '', 'yes'),
(1718, 'hide-loggedout-adminbar', '', 'yes'),
(1719, 'bp-disable-avatar-uploads', '', 'yes'),
(643, 'recently_activated', 'a:6:{s:28:\"wise-chat/wise-chat-core.php\";i:1483375513;s:25:\"cm-answers/cm-answers.php\";i:1483349295;s:69:\"videowhisper-video-conference-integration/videowhisper_conference.php\";i:1483349274;s:30:\"wordapp-mobile-app/WordApp.php\";i:1483348954;s:28:\"transcoder/rt-transcoder.php\";i:1483348929;s:66:\"videowhisper-live-streaming-integration/videowhisper_streaming.php\";i:1483348911;}', 'yes'),
(1720, 'bp-disable-cover-image-uploads', '', 'yes'),
(1721, 'bp-disable-group-avatar-uploads', '', 'yes'),
(1722, 'bp-disable-group-cover-image-uploads', '', 'yes'),
(1723, 'bp-disable-account-deletion', '', 'yes'),
(1699, '_transient_cc2_theme_active', '', 'yes'),
(1700, 'theme_mods_cc2', 'a:4:{i:0;b:0;s:18:\"custom_css_post_id\";i:-1;s:16:\"sidebars_widgets\";a:2:{s:4:\"time\";i:1482744722;s:4:\"data\";a:6:{s:19:\"wp_inactive_widgets\";a:0:{}s:7:\"sidebar\";a:6:{i:0;s:8:\"search-2\";i:1;s:14:\"recent-posts-2\";i:2;s:17:\"recent-comments-2\";i:3;s:10:\"archives-2\";i:4;s:12:\"categories-2\";i:5;s:6:\"meta-2\";}s:8:\"footer-1\";N;s:8:\"footer-2\";N;s:8:\"footer-3\";N;s:8:\"footer-4\";N;}}s:9:\"_modified\";i:1483352014;}', 'yes'),
(2011, 'kleo_kleo', 'a:271:{s:8:\"last_tab\";s:0:\"\";s:16:\"maintenance_mode\";s:1:\"0\";s:15:\"maintenance_msg\";s:62:\"We are currently in maintenance mode. Please check back later.\";s:4:\"logo\";a:5:{s:3:\"url\";s:92:\"http://leshommesdebout.org/wp-content/uploads/2017/01/signature-université-minimale_07.png\";s:2:\"id\";s:2:\"35\";s:6:\"height\";s:3:\"245\";s:5:\"width\";s:4:\"1994\";s:9:\"thumbnail\";s:100:\"http://leshommesdebout.org/wp-content/uploads/2017/01/signature-université-minimale_07-150x150.png\";}s:11:\"logo_retina\";a:5:{s:3:\"url\";s:0:\"\";s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}s:7:\"favicon\";a:5:{s:3:\"url\";s:77:\"http://leshommesdebout.org/wp-content/themes/kleo/kleo/assets/ico/favicon.png\";s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}s:7:\"apple57\";a:5:{s:3:\"url\";s:101:\"http://leshommesdebout.org/wp-content/themes/kleo/kleo/assets/ico/apple-touch-icon-57-precomposed.png\";s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}s:8:\"apple114\";a:5:{s:3:\"url\";s:102:\"http://leshommesdebout.org/wp-content/themes/kleo/kleo/assets/ico/apple-touch-icon-114-precomposed.png\";s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}s:7:\"apple72\";a:5:{s:3:\"url\";s:101:\"http://leshommesdebout.org/wp-content/themes/kleo/kleo/assets/ico/apple-touch-icon-72-precomposed.png\";s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}s:8:\"apple144\";a:5:{s:3:\"url\";s:102:\"http://leshommesdebout.org/wp-content/themes/kleo/kleo/assets/ico/apple-touch-icon-144-precomposed.png\";s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}s:9:\"analytics\";s:0:\"\";s:9:\"quick_css\";s:0:\"\";s:13:\"socket_enable\";s:1:\"1\";s:11:\"footer_text\";s:203:\"<p style=\"text-align: center;\"><strong>©[current-year] KLEO Template</strong> a premium and multipurpose theme from <a href=\"http://www.seventhqueen.com\" target=\"_blank\">Seven<sup>th</sup> Queen</a></p>\";s:10:\"site_style\";s:4:\"wide\";s:10:\"boxed_size\";s:4:\"1440\";s:7:\"body_bg\";a:7:{s:16:\"background-color\";s:0:\"\";s:17:\"background-repeat\";s:6:\"repeat\";s:15:\"background-size\";s:0:\"\";s:21:\"background-attachment\";s:0:\"\";s:19:\"background-position\";s:0:\"\";s:16:\"background-image\";s:77:\"http://leshommesdebout.org/wp-content/themes/kleo/kleo/assets/img/bg-body.gif\";s:5:\"media\";a:4:{s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}}s:14:\"global_sidebar\";s:3:\"3lr\";s:16:\"main_width_2cols\";s:1:\"9\";s:16:\"main_width_3cols\";s:1:\"6\";s:6:\"go_top\";s:1:\"1\";s:14:\"title_location\";s:10:\"breadcrumb\";s:12:\"contact_form\";s:1:\"0\";s:20:\"contact_form_builtin\";s:1:\"1\";s:15:\"contact_form_to\";s:0:\"\";s:18:\"contact_form_title\";s:10:\"CONTACT US\";s:17:\"contact_form_text\";s:89:\"We\'re not around right now. But you can send us an email and we\'ll get back to you, asap.\";s:11:\"performance\";s:1:\"0\";s:16:\"perf_combine_css\";s:1:\"0\";s:15:\"perf_combine_js\";s:1:\"0\";s:17:\"perf_remove_query\";s:1:\"0\";s:19:\"module_testimonials\";s:1:\"1\";s:14:\"module_clients\";s:1:\"1\";s:16:\"module_portfolio\";s:1:\"1\";s:15:\"sh_feature_item\";s:1:\"1\";s:16:\"sh_kleo_register\";s:1:\"1\";s:13:\"sh_news_focus\";s:1:\"1\";s:17:\"sh_news_highlight\";s:1:\"1\";s:14:\"sh_news_ticker\";s:1:\"1\";s:6:\"sh_poi\";s:1:\"1\";s:16:\"sh_pricing_table\";s:1:\"1\";s:13:\"header_layout\";s:6:\"normal\";s:13:\"header_banner\";s:19:\"Banner text/AD here\";s:11:\"menu_height\";s:2:\"88\";s:15:\"menu_two_height\";s:2:\"88\";s:11:\"sticky_menu\";s:1:\"1\";s:11:\"resize_logo\";s:1:\"1\";s:20:\"menu_height_scrolled\";s:0:\"\";s:24:\"menu_two_height_scrolled\";s:0:\"\";s:16:\"transparent_logo\";s:1:\"0\";s:15:\"menu_full_width\";s:1:\"0\";s:9:\"menu_size\";s:0:\"\";s:15:\"header_flexmenu\";s:1:\"0\";s:9:\"show_lang\";s:1:\"1\";s:20:\"header_overlay_hover\";s:1:\"0\";s:11:\"ajax_search\";s:1:\"1\";s:12:\"show_top_bar\";s:1:\"1\";s:14:\"top_bar_darker\";s:1:\"1\";s:17:\"breadcrumb_status\";s:1:\"1\";s:10:\"title_info\";s:177:\"<em class=\"muted\">feel free to call us</em> &nbsp;&nbsp;<i class=\"icon-phone\"></i> +91.33.26789234 &nbsp;&nbsp;&nbsp;&nbsp;<i class=\"icon-mail-alt\"></i> youremail@yourdomain.com\";s:12:\"title_layout\";s:6:\"normal\";s:13:\"title_padding\";a:2:{s:11:\"padding-top\";s:4:\"10px\";s:14:\"padding-bottom\";s:4:\"10px\";}s:9:\"side_menu\";s:1:\"0\";s:16:\"side_menu_button\";s:1:\"1\";s:16:\"side_menu_mobile\";s:1:\"0\";s:18:\"side_menu_position\";s:4:\"left\";s:14:\"side_menu_type\";s:7:\"default\";s:16:\"side_menu_before\";s:0:\"\";s:15:\"side_menu_after\";s:19:\"[kleo_social_icons]\";s:11:\"blog_layout\";s:5:\"right\";s:10:\"cat_layout\";s:5:\"right\";s:16:\"blog_post_layout\";s:7:\"default\";s:9:\"blog_type\";s:7:\"masonry\";s:12:\"blog_columns\";s:1:\"3\";s:18:\"blog_switch_layout\";s:1:\"0\";s:20:\"blog_enabled_layouts\";a:3:{i:0;s:7:\"masonry\";i:1;s:5:\"small\";i:2;s:8:\"standard\";}s:23:\"featured_content_layout\";s:8:\"carousel\";s:21:\"featured_grid_columns\";s:1:\"3\";s:15:\"blog_custom_img\";s:1:\"0\";s:21:\"blog_img_single_width\";s:4:\"1038\";s:22:\"blog_img_single_height\";s:4:\"9999\";s:20:\"blog_img_single_crop\";s:1:\"0\";s:23:\"blog_img_standard_width\";s:3:\"480\";s:24:\"blog_img_standard_height\";s:3:\"270\";s:22:\"blog_img_standard_crop\";s:1:\"1\";s:19:\"blog_img_grid_width\";s:3:\"480\";s:20:\"blog_img_grid_height\";s:4:\"9999\";s:18:\"blog_img_grid_crop\";s:1:\"0\";s:20:\"blog_img_small_width\";s:3:\"480\";s:21:\"blog_img_small_height\";s:3:\"270\";s:19:\"blog_img_small_crop\";s:1:\"1\";s:17:\"blog_archive_meta\";s:1:\"1\";s:16:\"blog_meta_status\";s:1:\"1\";s:18:\"blog_meta_elements\";a:5:{i:0;s:4:\"date\";i:1;s:11:\"author_link\";i:2;s:10:\"categories\";i:3;s:4:\"tags\";i:4;s:8:\"comments\";}s:13:\"blog_meta_sep\";s:2:\", \";s:18:\"blog_standard_meta\";s:4:\"left\";s:16:\"blog_single_meta\";s:4:\"left\";s:16:\"blog_tags_footer\";s:1:\"0\";s:17:\"blog_media_status\";s:1:\"1\";s:14:\"blog_get_image\";s:1:\"1\";s:18:\"blog_default_image\";a:5:{s:3:\"url\";s:0:\"\";s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}s:15:\"post_navigation\";s:1:\"1\";s:13:\"related_posts\";s:1:\"1\";s:20:\"related_custom_posts\";s:1:\"0\";s:10:\"page_media\";s:1:\"1\";s:13:\"page_comments\";s:1:\"0\";s:17:\"blog_social_share\";s:1:\"1\";s:16:\"blog_share_types\";a:1:{i:0;s:4:\"post\";}s:18:\"blog_share_exclude\";s:0:\"\";s:26:\"blog_social_share_facebook\";s:1:\"1\";s:25:\"blog_social_share_twitter\";s:1:\"1\";s:28:\"blog_social_share_googleplus\";s:1:\"1\";s:27:\"blog_social_share_pinterest\";s:1:\"1\";s:26:\"blog_social_share_linkedin\";s:1:\"1\";s:26:\"blog_social_share_whatsapp\";s:1:\"1\";s:22:\"blog_social_share_mail\";s:1:\"1\";s:12:\"likes_status\";s:1:\"1\";s:13:\"likes_exclude\";s:0:\"\";s:10:\"likes_ajax\";s:1:\"0\";s:15:\"likes_zero_text\";s:5:\"likes\";s:14:\"likes_one_text\";s:4:\"like\";s:15:\"likes_more_text\";s:5:\"likes\";s:13:\"likes_already\";s:21:\"You already like this\";s:14:\"like_this_text\";s:9:\"Like this\";s:16:\"st__header__text\";s:7:\"#444444\";s:20:\"st__header__headings\";s:7:\"#111111\";s:14:\"st__header__bg\";s:7:\"#ffffff\";s:20:\"st__header__bg_image\";a:6:{s:17:\"background-repeat\";s:0:\"\";s:15:\"background-size\";s:0:\"\";s:21:\"background-attachment\";s:0:\"\";s:19:\"background-position\";s:0:\"\";s:16:\"background-image\";s:0:\"\";s:5:\"media\";a:4:{s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}}s:18:\"st__header__border\";s:7:\"#e5e5e5\";s:16:\"st__header__link\";s:7:\"#444444\";s:22:\"st__header__link_hover\";s:7:\"#777777\";s:22:\"st__header__high_color\";s:7:\"#ffffff\";s:19:\"st__header__high_bg\";s:7:\"#00b9f7\";s:18:\"st__header__alt_bg\";s:7:\"#f7f7f7\";s:22:\"st__header__alt_border\";s:7:\"#e5e5e5\";s:14:\"st__main__text\";s:7:\"#777777\";s:18:\"st__main__headings\";s:7:\"#444444\";s:12:\"st__main__bg\";s:7:\"#ffffff\";s:18:\"st__main__bg_image\";a:6:{s:17:\"background-repeat\";s:0:\"\";s:15:\"background-size\";s:0:\"\";s:21:\"background-attachment\";s:0:\"\";s:19:\"background-position\";s:0:\"\";s:16:\"background-image\";s:0:\"\";s:5:\"media\";a:4:{s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}}s:16:\"st__main__border\";s:7:\"#e5e5e5\";s:14:\"st__main__link\";s:7:\"#367bb7\";s:20:\"st__main__link_hover\";s:7:\"#00b9f7\";s:20:\"st__main__high_color\";s:7:\"#ffffff\";s:17:\"st__main__high_bg\";s:7:\"#00b9f7\";s:16:\"st__main__alt_bg\";s:7:\"#f7f7f7\";s:20:\"st__main__alt_border\";s:7:\"#e5e5e5\";s:19:\"st__alternate__text\";s:7:\"#777777\";s:23:\"st__alternate__headings\";s:7:\"#444444\";s:17:\"st__alternate__bg\";s:7:\"#f7f7f7\";s:23:\"st__alternate__bg_image\";a:6:{s:17:\"background-repeat\";s:0:\"\";s:15:\"background-size\";s:0:\"\";s:21:\"background-attachment\";s:0:\"\";s:19:\"background-position\";s:0:\"\";s:16:\"background-image\";s:0:\"\";s:5:\"media\";a:4:{s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}}s:21:\"st__alternate__border\";s:7:\"#e5e5e5\";s:19:\"st__alternate__link\";s:7:\"#367bb7\";s:25:\"st__alternate__link_hover\";s:7:\"#00b9f7\";s:25:\"st__alternate__high_color\";s:7:\"#ffffff\";s:22:\"st__alternate__high_bg\";s:7:\"#00b9f7\";s:21:\"st__alternate__alt_bg\";s:7:\"#ffffff\";s:25:\"st__alternate__alt_border\";s:7:\"#e5e5e5\";s:14:\"st__side__text\";s:7:\"#777777\";s:18:\"st__side__headings\";s:7:\"#aaaaaa\";s:12:\"st__side__bg\";s:7:\"#1c1c1c\";s:18:\"st__side__bg_image\";a:6:{s:17:\"background-repeat\";s:0:\"\";s:15:\"background-size\";s:0:\"\";s:21:\"background-attachment\";s:0:\"\";s:19:\"background-position\";s:0:\"\";s:16:\"background-image\";s:0:\"\";s:5:\"media\";a:4:{s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}}s:16:\"st__side__border\";s:7:\"#333333\";s:14:\"st__side__link\";s:7:\"#cccccc\";s:20:\"st__side__link_hover\";s:7:\"#777777\";s:20:\"st__side__high_color\";s:7:\"#ffffff\";s:17:\"st__side__high_bg\";s:7:\"#00b9f7\";s:16:\"st__side__alt_bg\";s:7:\"#272727\";s:20:\"st__side__alt_border\";s:7:\"#333333\";s:16:\"st__footer__text\";s:7:\"#777777\";s:20:\"st__footer__headings\";s:7:\"#aaaaaa\";s:14:\"st__footer__bg\";s:7:\"#1c1c1c\";s:20:\"st__footer__bg_image\";a:6:{s:17:\"background-repeat\";s:0:\"\";s:15:\"background-size\";s:0:\"\";s:21:\"background-attachment\";s:0:\"\";s:19:\"background-position\";s:0:\"\";s:16:\"background-image\";s:0:\"\";s:5:\"media\";a:4:{s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}}s:18:\"st__footer__border\";s:7:\"#333333\";s:16:\"st__footer__link\";s:7:\"#cccccc\";s:22:\"st__footer__link_hover\";s:7:\"#777777\";s:22:\"st__footer__high_color\";s:7:\"#ffffff\";s:19:\"st__footer__high_bg\";s:7:\"#00b9f7\";s:18:\"st__footer__alt_bg\";s:7:\"#272727\";s:22:\"st__footer__alt_border\";s:7:\"#333333\";s:16:\"st__socket__text\";s:7:\"#515151\";s:20:\"st__socket__headings\";s:7:\"#cccccc\";s:14:\"st__socket__bg\";s:7:\"#171717\";s:20:\"st__socket__bg_image\";a:6:{s:17:\"background-repeat\";s:0:\"\";s:15:\"background-size\";s:0:\"\";s:21:\"background-attachment\";s:0:\"\";s:19:\"background-position\";s:0:\"\";s:16:\"background-image\";s:0:\"\";s:5:\"media\";a:4:{s:2:\"id\";s:0:\"\";s:6:\"height\";s:0:\"\";s:5:\"width\";s:0:\"\";s:9:\"thumbnail\";s:0:\"\";}}s:18:\"st__socket__border\";s:7:\"#333333\";s:16:\"st__socket__link\";s:7:\"#515151\";s:22:\"st__socket__link_hover\";s:7:\"#777777\";s:22:\"st__socket__high_color\";s:7:\"#ffffff\";s:19:\"st__socket__high_bg\";s:7:\"#00b9f7\";s:18:\"st__socket__alt_bg\";s:7:\"#f7f7f7\";s:22:\"st__socket__alt_border\";s:7:\"#272727\";s:7:\"font_h1\";a:10:{s:11:\"font-family\";s:16:\"Roboto Condensed\";s:12:\"font-options\";s:0:\"\";s:6:\"google\";s:1:\"1\";s:11:\"font-backup\";s:0:\"\";s:11:\"font-weight\";s:3:\"300\";s:10:\"font-style\";s:0:\"\";s:7:\"subsets\";s:0:\"\";s:10:\"text-align\";s:0:\"\";s:9:\"font-size\";s:4:\"36px\";s:11:\"line-height\";s:4:\"48px\";}s:7:\"font_h2\";a:10:{s:11:\"font-family\";s:16:\"Roboto Condensed\";s:12:\"font-options\";s:0:\"\";s:6:\"google\";s:1:\"1\";s:11:\"font-backup\";s:0:\"\";s:11:\"font-weight\";s:3:\"300\";s:10:\"font-style\";s:0:\"\";s:7:\"subsets\";s:0:\"\";s:10:\"text-align\";s:0:\"\";s:9:\"font-size\";s:4:\"28px\";s:11:\"line-height\";s:4:\"36px\";}s:7:\"font_h3\";a:10:{s:11:\"font-family\";s:16:\"Roboto Condensed\";s:12:\"font-options\";s:0:\"\";s:6:\"google\";s:1:\"1\";s:11:\"font-backup\";s:0:\"\";s:11:\"font-weight\";s:3:\"300\";s:10:\"font-style\";s:0:\"\";s:7:\"subsets\";s:0:\"\";s:10:\"text-align\";s:0:\"\";s:9:\"font-size\";s:4:\"22px\";s:11:\"line-height\";s:4:\"28px\";}s:7:\"font_h4\";a:10:{s:11:\"font-family\";s:16:\"Roboto Condensed\";s:12:\"font-options\";s:0:\"\";s:6:\"google\";s:1:\"1\";s:11:\"font-backup\";s:0:\"\";s:11:\"font-weight\";s:3:\"300\";s:10:\"font-style\";s:0:\"\";s:7:\"subsets\";s:0:\"\";s:10:\"text-align\";s:0:\"\";s:9:\"font-size\";s:4:\"18px\";s:11:\"line-height\";s:4:\"28px\";}s:7:\"font_h5\";a:10:{s:11:\"font-family\";s:16:\"Roboto Condensed\";s:12:\"font-options\";s:0:\"\";s:6:\"google\";s:1:\"1\";s:11:\"font-backup\";s:0:\"\";s:11:\"font-weight\";s:3:\"300\";s:10:\"font-style\";s:0:\"\";s:7:\"subsets\";s:0:\"\";s:10:\"text-align\";s:0:\"\";s:9:\"font-size\";s:4:\"17px\";s:11:\"line-height\";s:4:\"27px\";}s:7:\"font_h6\";a:10:{s:11:\"font-family\";s:16:\"Roboto Condensed\";s:12:\"font-options\";s:0:\"\";s:6:\"google\";s:1:\"1\";s:11:\"font-backup\";s:0:\"\";s:11:\"font-weight\";s:3:\"300\";s:10:\"font-style\";s:0:\"\";s:7:\"subsets\";s:0:\"\";s:10:\"text-align\";s:0:\"\";s:9:\"font-size\";s:4:\"16px\";s:11:\"line-height\";s:4:\"24px\";}s:9:\"font_body\";a:10:{s:11:\"font-family\";s:9:\"Open Sans\";s:12:\"font-options\";s:0:\"\";s:6:\"google\";s:1:\"1\";s:11:\"font-backup\";s:0:\"\";s:11:\"font-weight\";s:3:\"400\";s:10:\"font-style\";s:0:\"\";s:7:\"subsets\";s:0:\"\";s:10:\"text-align\";s:0:\"\";s:9:\"font-size\";s:4:\"13px\";s:11:\"line-height\";s:4:\"20px\";}s:24:\"portfolio_custom_archive\";s:1:\"1\";s:14:\"portfolio_page\";s:0:\"\";s:14:\"portfolio_name\";s:9:\"Portfolio\";s:14:\"portfolio_slug\";s:9:\"portfolio\";s:15:\"portfolio_style\";s:7:\"default\";s:21:\"portfolio_title_style\";s:6:\"normal\";s:17:\"portfolio_excerpt\";s:1:\"1\";s:17:\"portfolio_per_row\";s:1:\"4\";s:16:\"portfolio_filter\";s:3:\"yes\";s:15:\"portfolio_image\";s:7:\"480x270\";s:22:\"portfolio_video_height\";s:3:\"160\";s:23:\"portfolio_slider_action\";s:7:\"default\";s:22:\"portfolio_media_status\";s:1:\"1\";s:17:\"portfolio_back_to\";s:1:\"1\";s:18:\"portfolio_comments\";s:1:\"1\";s:20:\"portfolio_navigation\";s:1:\"1\";s:9:\"bp_layout\";s:3:\"3lr\";s:21:\"bp_layout_members_dir\";s:3:\"3lr\";s:17:\"bp_layout_profile\";s:3:\"3lr\";s:16:\"bp_layout_groups\";s:3:\"3lr\";s:18:\"bp_layout_activity\";s:3:\"3lr\";s:18:\"bp_layout_register\";s:7:\"default\";s:17:\"bp_title_location\";s:7:\"default\";s:20:\"bp_breadcrumb_status\";s:1:\"1\";s:14:\"bp_custom_info\";s:1:\"0\";s:13:\"bp_title_info\";s:177:\"<em class=\"muted\">feel free to call us</em> &nbsp;&nbsp;<i class=\"icon-phone\"></i> +91.33.26789234 &nbsp;&nbsp;&nbsp;&nbsp;<i class=\"icon-mail-alt\"></i> support@seventhqueen.com\";s:29:\"bp_profile_breadcrumb_disable\";s:1:\"0\";s:15:\"bp_full_profile\";s:1:\"1\";s:13:\"bp_full_group\";s:1:\"1\";s:16:\"bp_online_status\";s:1:\"1\";s:17:\"member_navigation\";s:1:\"1\";s:17:\"bp_notif_interval\";s:5:\"20000\";s:18:\"bp_members_perpage\";s:2:\"24\";s:17:\"bp_groups_perpage\";s:2:\"24\";s:18:\"mobile_app_capable\";s:1:\"1\";s:24:\"apple_mobile_app_capable\";s:1:\"0\";s:16:\"meta_theme_color\";s:0:\"\";s:19:\"sitewide_animations\";s:7:\"enabled\";s:9:\"admin_bar\";s:1:\"1\";s:14:\"login_redirect\";s:7:\"default\";s:21:\"login_redirect_custom\";s:0:\"\";s:17:\"homepage_redirect\";s:8:\"disabled\";s:24:\"homepage_redirect_custom\";s:0:\"\";s:14:\"facebook_login\";s:1:\"0\";s:9:\"fb_app_id\";s:0:\"\";s:15:\"facebook_avatar\";s:1:\"0\";s:17:\"facebook_register\";s:1:\"0\";s:11:\"let_it_snow\";s:1:\"0\";s:24:\"magnific_disable_gallery\";s:1:\"0\";s:8:\"dev_mode\";s:1:\"0\";s:17:\"show_social_icons\";s:1:\"1\";s:14:\"social_twitter\";s:0:\"\";s:15:\"social_facebook\";s:0:\"\";s:15:\"social_dribbble\";s:0:\"\";s:20:\"social_vimeo-squared\";s:0:\"\";s:13:\"social_tumblr\";s:0:\"\";s:15:\"social_linkedin\";s:0:\"\";s:12:\"social_gplus\";s:0:\"\";s:13:\"social_flickr\";s:0:\"\";s:14:\"social_youtube\";s:0:\"\";s:24:\"social_pinterest-circled\";s:0:\"\";s:17:\"social_foursquare\";s:0:\"\";s:17:\"social_instagramm\";s:0:\"\";s:13:\"social_github\";s:0:\"\";s:11:\"social_xing\";s:0:\"\";s:11:\"tf_username\";s:0:\"\";s:9:\"tf_apikey\";s:0:\"\";s:14:\"search_context\";s:0:\"\";s:18:\"st__header__preset\";i:0;s:16:\"st__main__preset\";i:0;s:21:\"st__alternate__preset\";i:0;s:16:\"st__side__preset\";i:0;s:18:\"st__footer__preset\";i:0;s:18:\"st__socket__preset\";i:0;}', 'yes'),
(7384, '_site_transient_timeout_theme_roots', '1496784992', 'no'),
(7385, '_site_transient_theme_roots', 'a:8:{s:16:\"custom-community\";s:7:\"/themes\";s:10:\"kleo-child\";s:7:\"/themes\";s:9:\"kleo/kleo\";s:7:\"/themes\";s:15:\"portfolio-press\";s:7:\"/themes\";s:13:\"twentyfifteen\";s:7:\"/themes\";s:14:\"twentyfourteen\";s:7:\"/themes\";s:15:\"twentyseventeen\";s:7:\"/themes\";s:13:\"twentysixteen\";s:7:\"/themes\";}', 'no'),
(1918, 'bpic_avatar_height', '50', 'yes'),
(1917, 'bpic_avatar_width', '50', 'yes'),
(1994, '_site_transient_timeout_wporg_theme_feature_list', '1483384182', 'no'),
(1995, '_site_transient_wporg_theme_feature_list', 'a:3:{s:6:\"Layout\";a:7:{i:0;s:11:\"grid-layout\";i:1;s:10:\"one-column\";i:2;s:11:\"two-columns\";i:3;s:13:\"three-columns\";i:4;s:12:\"four-columns\";i:5;s:12:\"left-sidebar\";i:6;s:13:\"right-sidebar\";}s:8:\"Features\";a:20:{i:0;s:19:\"accessibility-ready\";i:1;s:10:\"buddypress\";i:2;s:17:\"custom-background\";i:3;s:13:\"custom-colors\";i:4;s:13:\"custom-header\";i:5;s:11:\"custom-menu\";i:6;s:12:\"editor-style\";i:7;s:21:\"featured-image-header\";i:8;s:15:\"featured-images\";i:9;s:15:\"flexible-header\";i:10;s:14:\"footer-widgets\";i:11;s:20:\"front-page-post-form\";i:12;s:19:\"full-width-template\";i:13;s:12:\"microformats\";i:14;s:12:\"post-formats\";i:15;s:20:\"rtl-language-support\";i:16;s:11:\"sticky-post\";i:17;s:13:\"theme-options\";i:18;s:17:\"threaded-comments\";i:19;s:17:\"translation-ready\";}s:7:\"Subject\";a:9:{i:0;s:4:\"blog\";i:1;s:10:\"e-commerce\";i:2;s:9:\"education\";i:3;s:13:\"entertainment\";i:4;s:14:\"food-and-drink\";i:5;s:7:\"holiday\";i:6;s:4:\"news\";i:7;s:11:\"photography\";i:8;s:9:\"portfolio\";}}', 'no');

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_postmeta`
--

CREATE TABLE `leshommesdebout_wp_postmeta` (
  `meta_id` bigint UNSIGNED NOT NULL,
  `post_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_postmeta`
--

INSERT INTO `leshommesdebout_wp_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES
(1, 2, '_wp_page_template', 'default'),
(5, 5, '_wp_attachment_metadata', 'a:5:{s:5:\"width\";i:2592;s:6:\"height\";i:1944;s:4:\"file\";s:16:\"2016/07/4848.jpg\";s:5:\"sizes\";a:7:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:16:\"4848-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:6:\"medium\";a:4:{s:4:\"file\";s:16:\"4848-300x225.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:225;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:12:\"medium_large\";a:4:{s:4:\"file\";s:16:\"4848-768x576.jpg\";s:5:\"width\";i:768;s:6:\"height\";i:576;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:5:\"large\";a:4:{s:4:\"file\";s:17:\"4848-1024x768.jpg\";s:5:\"width\";i:1024;s:6:\"height\";i:768;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:19:\"portfolio-thumbnail\";a:4:{s:4:\"file\";s:16:\"4848-360x260.jpg\";s:5:\"width\";i:360;s:6:\"height\";i:260;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:15:\"portfolio-large\";a:4:{s:4:\"file\";s:16:\"4848-690x518.jpg\";s:5:\"width\";i:690;s:6:\"height\";i:518;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:19:\"portfolio-fullwidth\";a:4:{s:4:\"file\";s:16:\"4848-980x735.jpg\";s:5:\"width\";i:980;s:6:\"height\";i:735;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:3:\"2.8\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:6:\"DSC-W7\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:10:\"1120822213\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:3:\"7.9\";s:3:\"iso\";s:3:\"100\";s:13:\"shutter_speed\";s:6:\"0.0025\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"1\";s:8:\"keywords\";a:0:{}}}'),
(4, 5, '_wp_attached_file', '2016/07/4848.jpg'),
(6, 2, '_edit_lock', '1468995227:1'),
(7, 1, '_edit_lock', '1482744277:1'),
(11, 33, '_last_poster', '1'),
(10, 33, '_resolved', '0'),
(12, 33, '_listeners', 'a:2:{i:0;s:0:\"\";i:1;i:1;}'),
(13, 33, '_votes', '0'),
(14, 33, '_highest_rated_answer', '0'),
(15, 35, '_wp_attached_file', '2017/01/signature-université-minimale_07.png'),
(16, 35, '_wp_attachment_metadata', 'a:5:{s:5:\"width\";i:1994;s:6:\"height\";i:245;s:4:\"file\";s:46:\"2017/01/signature-université-minimale_07.png\";s:5:\"sizes\";a:9:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:46:\"signature-université-minimale_07-150x150.png\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:9:\"image/png\";}s:6:\"medium\";a:4:{s:4:\"file\";s:45:\"signature-université-minimale_07-300x37.png\";s:5:\"width\";i:300;s:6:\"height\";i:37;s:9:\"mime-type\";s:9:\"image/png\";}s:12:\"medium_large\";a:4:{s:4:\"file\";s:45:\"signature-université-minimale_07-768x94.png\";s:5:\"width\";i:768;s:6:\"height\";i:94;s:9:\"mime-type\";s:9:\"image/png\";}s:5:\"large\";a:4:{s:4:\"file\";s:47:\"signature-université-minimale_07-1024x126.png\";s:5:\"width\";i:1024;s:6:\"height\";i:126;s:9:\"mime-type\";s:9:\"image/png\";}s:18:\"rt_media_thumbnail\";a:4:{s:4:\"file\";s:46:\"signature-université-minimale_07-150x150.png\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:9:\"image/png\";}s:23:\"rt_media_activity_image\";a:4:{s:4:\"file\";s:46:\"signature-université-minimale_07-320x240.png\";s:5:\"width\";i:320;s:6:\"height\";i:240;s:9:\"mime-type\";s:9:\"image/png\";}s:21:\"rt_media_single_image\";a:4:{s:4:\"file\";s:45:\"signature-université-minimale_07-800x98.png\";s:5:\"width\";i:800;s:6:\"height\";i:98;s:9:\"mime-type\";s:9:\"image/png\";}s:23:\"rt_media_featured_image\";a:4:{s:4:\"file\";s:46:\"signature-université-minimale_07-100x100.png\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:9:\"image/png\";}s:32:\"twentyseventeen-thumbnail-avatar\";a:4:{s:4:\"file\";s:46:\"signature-université-minimale_07-100x100.png\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:9:\"image/png\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}'),
(17, 36, '_wp_attached_file', '2017/01/cropped-signature-université-minimale_07.png'),
(18, 36, '_wp_attachment_context', 'custom-logo'),
(19, 36, '_wp_attachment_metadata', 'a:5:{s:5:\"width\";i:248;s:6:\"height\";i:250;s:4:\"file\";s:54:\"2017/01/cropped-signature-université-minimale_07.png\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:54:\"cropped-signature-université-minimale_07-150x150.png\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:9:\"image/png\";}s:32:\"twentyseventeen-thumbnail-avatar\";a:4:{s:4:\"file\";s:54:\"cropped-signature-université-minimale_07-100x100.png\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:9:\"image/png\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}'),
(22, 38, '_wp_attached_file', '2017/01/Slider_retour_ceremonie_JPSauvage.jpg'),
(23, 38, '_wp_attachment_metadata', 'a:5:{s:5:\"width\";i:1050;s:6:\"height\";i:350;s:4:\"file\";s:45:\"2017/01/Slider_retour_ceremonie_JPSauvage.jpg\";s:5:\"sizes\";a:8:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:45:\"Slider_retour_ceremonie_JPSauvage-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:6:\"medium\";a:4:{s:4:\"file\";s:45:\"Slider_retour_ceremonie_JPSauvage-300x100.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:12:\"medium_large\";a:4:{s:4:\"file\";s:45:\"Slider_retour_ceremonie_JPSauvage-768x256.jpg\";s:5:\"width\";i:768;s:6:\"height\";i:256;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:5:\"large\";a:4:{s:4:\"file\";s:46:\"Slider_retour_ceremonie_JPSauvage-1024x341.jpg\";s:5:\"width\";i:1024;s:6:\"height\";i:341;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:18:\"rt_media_thumbnail\";a:4:{s:4:\"file\";s:45:\"Slider_retour_ceremonie_JPSauvage-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:23:\"rt_media_activity_image\";a:4:{s:4:\"file\";s:45:\"Slider_retour_ceremonie_JPSauvage-320x240.jpg\";s:5:\"width\";i:320;s:6:\"height\";i:240;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:21:\"rt_media_single_image\";a:4:{s:4:\"file\";s:45:\"Slider_retour_ceremonie_JPSauvage-800x267.jpg\";s:5:\"width\";i:800;s:6:\"height\";i:267;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:23:\"rt_media_featured_image\";a:4:{s:4:\"file\";s:45:\"Slider_retour_ceremonie_JPSauvage-100x100.jpg\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}'),
(24, 39, '_wp_attached_file', '2017/01/cropped-Slider_retour_ceremonie_JPSauvage.jpg'),
(25, 39, '_wp_attachment_context', 'custom-header'),
(26, 39, '_wp_attachment_metadata', 'a:5:{s:5:\"width\";i:1170;s:6:\"height\";i:249;s:4:\"file\";s:53:\"2017/01/cropped-Slider_retour_ceremonie_JPSauvage.jpg\";s:5:\"sizes\";a:4:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:53:\"cropped-Slider_retour_ceremonie_JPSauvage-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:6:\"medium\";a:4:{s:4:\"file\";s:52:\"cropped-Slider_retour_ceremonie_JPSauvage-300x64.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:64;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:12:\"medium_large\";a:4:{s:4:\"file\";s:53:\"cropped-Slider_retour_ceremonie_JPSauvage-768x163.jpg\";s:5:\"width\";i:768;s:6:\"height\";i:163;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:5:\"large\";a:4:{s:4:\"file\";s:54:\"cropped-Slider_retour_ceremonie_JPSauvage-1024x218.jpg\";s:5:\"width\";i:1024;s:6:\"height\";i:218;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}'),
(27, 39, '_wp_attachment_custom_header_last_used_custom-community', '1483352199'),
(28, 39, '_wp_attachment_is_custom_header', 'custom-community'),
(33, 41, '_wp_attached_file', 'rtMedia/users/1/2017/01/DSC_0498.jpg'),
(34, 41, '_wp_attachment_metadata', 'a:5:{s:5:\"width\";i:4288;s:6:\"height\";i:2848;s:4:\"file\";s:36:\"rtMedia/users/1/2017/01/DSC_0498.jpg\";s:5:\"sizes\";a:4:{s:18:\"rt_media_thumbnail\";a:4:{s:4:\"file\";s:20:\"DSC_0498-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:23:\"rt_media_activity_image\";a:4:{s:4:\"file\";s:20:\"DSC_0498-320x240.jpg\";s:5:\"width\";i:320;s:6:\"height\";i:240;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:21:\"rt_media_single_image\";a:4:{s:4:\"file\";s:20:\"DSC_0498-800x531.jpg\";s:5:\"width\";i:800;s:6:\"height\";i:531;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:23:\"rt_media_featured_image\";a:4:{s:4:\"file\";s:20:\"DSC_0498-100x100.jpg\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:2:\"10\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:9:\"NIKON D90\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:10:\"1471035928\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:2:\"18\";s:3:\"iso\";s:3:\"200\";s:13:\"shutter_speed\";s:8:\"0.003125\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"1\";s:8:\"keywords\";a:0:{}}}'),
(35, 42, '_wp_attached_file', 'rtMedia/users/1/2017/01/DSC_0462.jpg'),
(36, 42, '_wp_attachment_metadata', 'a:5:{s:5:\"width\";i:4288;s:6:\"height\";i:2848;s:4:\"file\";s:36:\"rtMedia/users/1/2017/01/DSC_0462.jpg\";s:5:\"sizes\";a:4:{s:18:\"rt_media_thumbnail\";a:4:{s:4:\"file\";s:20:\"DSC_0462-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:23:\"rt_media_activity_image\";a:4:{s:4:\"file\";s:20:\"DSC_0462-320x240.jpg\";s:5:\"width\";i:320;s:6:\"height\";i:240;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:21:\"rt_media_single_image\";a:4:{s:4:\"file\";s:20:\"DSC_0462-800x531.jpg\";s:5:\"width\";i:800;s:6:\"height\";i:531;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:23:\"rt_media_featured_image\";a:4:{s:4:\"file\";s:20:\"DSC_0462-100x100.jpg\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"9\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:9:\"NIKON D90\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:10:\"1470963704\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:2:\"18\";s:3:\"iso\";s:3:\"200\";s:13:\"shutter_speed\";s:5:\"0.008\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"1\";s:8:\"keywords\";a:0:{}}}'),
(39, 1, 'notification_already_sent', '1'),
(79, 30, '_wp_page_template', 'default'),
(42, 1, '_wp_old_slug', 'bonjour-tout-le-monde'),
(45, 1, '_thumbnail_id', ''),
(78, 30, '_edit_last', '1'),
(77, 30, '_edit_lock', '1483720283:1'),
(50, 48, '_wp_attached_file', 'rtMedia/users/1/2017/01/communication.jpeg'),
(51, 48, '_wp_attachment_metadata', 'a:5:{s:5:\"width\";i:6661;s:6:\"height\";i:4678;s:4:\"file\";s:42:\"rtMedia/users/1/2017/01/communication.jpeg\";s:5:\"sizes\";a:4:{s:18:\"rt_media_thumbnail\";a:4:{s:4:\"file\";s:26:\"communication-150x150.jpeg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:23:\"rt_media_activity_image\";a:4:{s:4:\"file\";s:26:\"communication-320x240.jpeg\";s:5:\"width\";i:320;s:6:\"height\";i:240;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:21:\"rt_media_single_image\";a:4:{s:4:\"file\";s:26:\"communication-800x562.jpeg\";s:5:\"width\";i:800;s:6:\"height\";i:562;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:23:\"rt_media_featured_image\";a:4:{s:4:\"file\";s:26:\"communication-100x100.jpeg\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}'),
(56, 51, '_edit_last', '1'),
(57, 51, '_edit_lock', '1483374132:1'),
(58, 51, '_wp_page_template', 'page-templates/left-right-sidebars.php'),
(73, 51, 'sbg_selected_sidebar_replacement', 'a:1:{i:0;s:1:\"0\";}'),
(63, 51, '_kleo_transparent_menu_color', 'white'),
(64, 51, '_kleo_title_color', '#'),
(65, 51, '_kleo_title_bg', 'a:5:{s:3:\"url\";s:0:\"\";s:6:\"repeat\";s:6:\"repeat\";s:4:\"size\";s:7:\"inherit\";s:10:\"attachment\";s:6:\"scroll\";s:8:\"position\";s:8:\"left top\";}'),
(66, 51, '_kleo_title_bg_color', '#'),
(67, 51, '_kleo_page_menu', 'menu-gauche'),
(72, 51, 'sbg_selected_sidebar', 'a:1:{i:0;s:1:\"0\";}'),
(74, 2, '_item_likes', '0'),
(75, 51, '_item_likes', '0'),
(76, 1, '_item_likes', '0'),
(90, 30, 'sbg_selected_sidebar_replacement', 'a:1:{i:0;s:1:\"0\";}'),
(89, 30, 'sbg_selected_sidebar', 'a:1:{i:0;s:1:\"0\";}'),
(84, 30, '_kleo_transparent_menu_color', 'white'),
(85, 30, '_kleo_title_color', '#'),
(86, 30, '_kleo_title_bg', 'a:5:{s:3:\"url\";s:0:\"\";s:6:\"repeat\";s:6:\"repeat\";s:4:\"size\";s:7:\"inherit\";s:10:\"attachment\";s:6:\"scroll\";s:8:\"position\";s:8:\"left top\";}'),
(87, 30, '_kleo_title_bg_color', '#'),
(88, 30, '_kleo_page_menu', 'default');

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_posts`
--

CREATE TABLE `leshommesdebout_wp_posts` (
  `ID` bigint UNSIGNED NOT NULL,
  `post_author` bigint UNSIGNED NOT NULL DEFAULT '0',
  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content` longtext NOT NULL,
  `post_title` text NOT NULL,
  `post_excerpt` text NOT NULL,
  `post_status` varchar(20) NOT NULL DEFAULT 'publish',
  `comment_status` varchar(20) NOT NULL DEFAULT 'open',
  `ping_status` varchar(20) NOT NULL DEFAULT 'open',
  `post_password` varchar(255) NOT NULL DEFAULT '',
  `post_name` varchar(200) NOT NULL DEFAULT '',
  `to_ping` text NOT NULL,
  `pinged` text NOT NULL,
  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content_filtered` longtext NOT NULL,
  `post_parent` bigint UNSIGNED NOT NULL DEFAULT '0',
  `guid` varchar(255) NOT NULL DEFAULT '',
  `menu_order` int NOT NULL DEFAULT '0',
  `post_type` varchar(20) NOT NULL DEFAULT 'post',
  `post_mime_type` varchar(100) NOT NULL DEFAULT '',
  `comment_count` bigint NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_posts`
--

INSERT INTO `leshommesdebout_wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES
(1, 1, '2016-07-19 23:02:52', '2016-07-19 21:02:52', 'Bienvenue dans WordPress. Ceci est votre premier article. Modifiez-le ou supprimez-le, puis lancez-vous !', 'La communiction grand public', '', 'publish', 'open', 'open', '', 'la-communiction-grand-public', '', '', '2017-01-02 11:34:38', '2017-01-02 10:34:38', '', 0, 'http://leshommesdebout.org/?p=1', 0, 'post', '', 0),
(2, 1, '2016-07-19 23:02:52', '2016-07-19 21:02:52', 'Voici un exemple de page. Elle est différente d’un article de blog, en cela qu’elle restera à la même place, et s’affichera dans le menu de navigation de votre site (en fonction de votre thème). La plupart des gens commencent par écrire une page « À Propos » qui les présente aux visiteurs potentiels du site. Vous pourriez y écrire quelque chose de ce tenant :\n\n<blockquote>Bonjour ! Je suis un mécanicien qui aspire à devenir un acteur, et voici mon blog. J’habite à Bordeaux, j’ai un super chien baptisé Russell, et j’aime la vodka-ananas (ainsi que regarder la pluie tomber).</blockquote>\n\n...ou bien quelque chose comme ça :\n\n<blockquote>La société 123 Machin Truc a été créée en 1971, et n’a cessé de proposer au public des machins-trucs de qualité depuis lors. Située à Saint-Remy-en-Bouzemont-Saint-Genest-et-Isson, 123 Machin Truc emploie 2 000 personnes, et fabrique toutes sortes de bidules super pour la communauté bouzemontoise.</blockquote>\n\nÉtant donné que vous êtes un nouvel utilisateur de WordPress, vous devriez vous rendre sur votre <a href=\"http://leshommesdebout.org/wp-admin/\">Tableau de bord</a> pour effacer la présente page, et créer de nouvelles pages avec votre propre contenu. Amusez-vous bien !', 'Page d&rsquo;exemple', '', 'publish', 'closed', 'open', '', 'page-d-exemple', '', '', '2016-07-19 23:02:52', '2016-07-19 21:02:52', '', 0, 'http://leshommesdebout.org/?page_id=2', 0, 'page', '', 0),
(52, 1, '2017-01-02 17:24:04', '2017-01-02 16:24:04', '', 'Page 1 menu gauche', '', 'inherit', 'closed', 'closed', '', '51-revision-v1', '', '', '2017-01-02 17:24:04', '2017-01-02 16:24:04', '', 51, 'http://leshommesdebout.org/2017/01/02/51-revision-v1/', 0, 'revision', '', 0),
(5, 1, '2016-07-19 23:08:17', '2016-07-19 21:08:17', '', '4848', '', 'inherit', 'open', 'closed', '', '4848', '', '', '2016-07-19 23:08:17', '2016-07-19 21:08:17', '', 0, 'http://leshommesdebout.org/wp-content/uploads/2016/07/4848.jpg', 0, 'attachment', 'image/jpeg', 0),
(6, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 'Activités du site', '', 'publish', 'closed', 'closed', '', 'activites-du-site', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/activites-du-site/', 0, 'page', '', 0),
(7, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 'Membres', '', 'publish', 'closed', 'closed', '', 'membres', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/membres/', 0, 'page', '', 0),
(8, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', '{{poster.name}} a répondu à une de vos mises à jour:\n\n<blockquote>&quot;{{usermessage}}&quot;</blockquote>\n\n<a href=\"{{{thread.url}}}\">Accès à la discussion</a> pour répondre ou continuer la conversation.', '[{{{site.name}}}] {{poster.name}} a répondu à une de vos mises à jour', '{{poster.name}} a répondu à une de vos mises à jour: \n\n\"{{usermessage}}\"\n\nAccès à la discussion pour répondre ou continuer la conversation: {{{thread.url}}}', 'publish', 'closed', 'closed', '', 'site-name-poster-name-a-repondu-a-une-de-vos-mises-a-jour', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=8', 0, 'bp-email', '', 0),
(9, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', '{{poster.name}} a répondu à un de vos commentaires: :\n\n<blockquote>&quot;{{usermessage}}&quot;</blockquote>\n\n<a href=\"{{{thread.url}}}\">Afficher la discussion</a> pour répondre ou continuer la conversation.', '[{{{site.name}}}] {{poster.name}} a répondu à un de vos commentaires', '{{poster.name}} a répondu à un de vos commentaires: \n\n\"{{usermessage}}\"\n\nAccès à la discussion pour répondre ou continuer la conversation: {{{thread.url}}}', 'publish', 'closed', 'closed', '', 'site-name-poster-name-a-repondu-a-un-de-vos-commentaires', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=9', 0, 'bp-email', '', 0),
(10, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', '{{poster.name}} vous a mentionné dans une mise à jour de statut:\n\n<blockquote>&quot;{{usermessage}}&quot;</blockquote>\n\n<a href=\"{{{mentioned.url}}}\">Aller à la discussion</a> pour répondre ou continuer la conversation', '[{{{site.name}}}] {{poster.name}} vous a mentionné dans une mise à jour de statut', '{{poster.name}} vous a mentionné dans une mise à jour de statut: \n\n\"{{usermessage}}\"\n\nPour y répondre ou continuer la conversation, rendez-vous sur: {{{mentioned.url}}}', 'publish', 'closed', 'closed', '', 'site-name-poster-name-vous-a-mentionne-dans-une-mise-a-jour-de-statut', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=10', 0, 'bp-email', '', 0),
(11, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', '{{poster.name}} vous a cité dans le groupe \"{{group.name}}\":\n\n<blockquote>&quot;{{usermessage}}&quot;</blockquote>\n\n<a href=\"{{{mentioned.url}}}\">Afficher la discussion</a> pour répondre ou continuer la conversation.', '[{{{site.name}}}] {{poster.name}} vous a mentionné dans une mise à jour', '{{poster.name}} vous a cité dans le groupe \"{{group.name}}\":\n\n\"{{usermessage}}\"\n\nAccès à la discussion pour répondre ou continuer la conversation: {{{mentioned.url}}}', 'publish', 'closed', 'closed', '', 'site-name-poster-name-vous-a-mentionne-dans-une-mise-a-jour', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=11', 0, 'bp-email', '', 0),
(12, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', 'Merci de vous être enregistré! \n\nPour compléter l\'activation de  votre compte, veuillez suivre le lien suivant: <a href=\"{{{activate.url}}}\">{{{activate.url}}}</a>', '[{{{site.name}}}] Activez votre compte', 'Merci de vous être enregistré! \n\nPour compléter l\'activation de  votre compte, veuillez vous rendre à cette adresse: {{{activate.url}}}', 'publish', 'closed', 'closed', '', 'site-name-activez-votre-compte', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=12', 0, 'bp-email', '', 0),
(13, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', 'Merci de vous être enregistré! \n\nPour compléter l\'activation de  votre compte et de votre site, veuillez suivre le lien suivant <a href=\"{{{activate-site.url}}}\">{{{activate-site.url}}}</a>.\n\nUne fois votrre compte activé, vous pourrez accéder à votre site ici: <a href=\"{{{user-site.url}}}\">{{{user-site.url}}}</a>.', '[{{{site.name}}}] Activation de {{{user-site.url}}}', 'Merci de vous être enregistré! \n\nPour compléter l\'activation de  votre compte et de votre site, veuillez vous rendre à cette adresse: {{{activate-site.url}}}\n\nUne fois votrre compte activé, vous pourrez accéder à votre site depuis {{{user-site.url}}}.', 'publish', 'closed', 'closed', '', 'site-name-activation-de-user-site-url', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=13', 0, 'bp-email', '', 0),
(14, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', '<a href=\"{{{initiator.url}}}\">{{initiator.name}}</a> souhaite vous ajouter à sa liste d\'amis.\n\nPour accepter sa demande ou gérer d\'autres demandes en attente, rendez-vous sur: <a href=\"{{{friend-requests.url}}}\">{{{friend-requests.url}}}</a>', '[{{{site.name}}}] Nouvelle demande de contact de la part de {{initiator.name}}', '{{initiator.name}} souhaite vous ajouter à sa liste de contacts. \n\nPour accepter sa demande et gérer d\'autres demandes en attente, rendez-vous sur: {{{friend-requests.url}}}\n\nPour voir le profil de {{initiator.name}}, rendez-vous sur: {{{initiator.url}}}', 'publish', 'closed', 'closed', '', 'site-name-nouvelle-demande-de-contact-de-la-part-de-initiator-name', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=14', 0, 'bp-email', '', 0),
(15, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', '<a href=\"{{{friendship.url}}}\">{{friend.name}}</a> a accepté votre demande de contact.', '[{{{site.name}}}] {{friend.name}} a accepté votre demande de contact', '{{friend.name}} a accepté votre dmande de contact. \n\nPour en savoir plus, visitez son profil: {{{friendship.url}}}', 'publish', 'closed', 'closed', '', 'site-name-friend-name-a-accepte-votre-demande-de-contact', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=15', 0, 'bp-email', '', 0),
(16, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', 'Les informations sur le groupe &quot;<a href=\"{{{group.url}}}\">{{group.name}}</a>&quot; ont été mises à jour:\n<blockquote>{{changed_text}}</blockquote>', '[{{{site.name}}}] Mise à jour des informations du groupe', 'Les détails sur le groupe \"{{group.name}}\" ont été mis à jour:\n\n{{changed_text}}\n\nPour voir le groupe, cliquez ici: {{{group.url}}}', 'publish', 'closed', 'closed', '', 'site-name-mise-a-jour-des-informations-du-groupe', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=16', 0, 'bp-email', '', 0),
(17, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', '<a href=\"{{{inviter.url}}}\">{{inviter.name}}</a> vous invite à rejoindre le groupe: &quot;{{group.name}}&quot;.\n<a href=\"{{{invites.url}}}\">Accepter l\'invitation</a> ou  <a href=\"{{{group.url}}}\">visiter le groupe</a>pour en savoir plus.', '[{{{site.name}}}] Vous êtes invité par le groupe: \"{{group.name}}\"', '{{inviter.name}} vous invite à rejoindre le groupe: \"{{group.name}}\".\n\nPour accepter cette invitation, cliquez sur ce lien: {{{invites.url}}}\n\nPour en savoir plus sur le groupe, cliquez ici {{{group.url}}}.\nPour en savoir plus sur {{inviter.name}}, visitez son profil: {{{inviter.url}}}', 'publish', 'closed', 'closed', '', 'site-name-vous-etes-invite-par-le-groupe-group-name', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=17', 0, 'bp-email', '', 0),
(18, 1, '2016-12-26 10:39:40', '2016-12-26 09:39:40', 'Vous avez été promu comme <b>{{promoted_to}}</b> du groupe &quot;<a href=\"{{{group.url}}}\">{{group.name}}</a>&quot;.', '[{{{site.name}}}] Vous êtes promu dans le groupe: \"{{group.name}}\"', 'Vous avez été promu comme {{promoted_to}} du groupe: \"{{group.name}}\".\n\nPour visiter le groupe, cliquez ici: {{{group.url}}}', 'publish', 'closed', 'closed', '', 'site-name-vous-etes-promu-dans-le-groupe-group-name', '', '', '2016-12-26 10:39:40', '2016-12-26 09:39:40', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=18', 0, 'bp-email', '', 0),
(19, 1, '2016-12-26 10:39:41', '2016-12-26 09:39:41', '<a href=\"{{{profile.url}}}\">{{requesting-user.name}}</a> souhaite rejoindre le groupe &quot;{{group.name}}&quot;. En tant qu\'administrateur de ce groupe, vous pouvez accepter ou rejeter cette demande\n\n<a href=\"{{{group-requests.url}}}\">Gérer la demande</a> ainsi que d\'autres demandes en attente.', '[{{{site.name}}}] Demande d\'adhésion au groupe: {{group.name}}', '{{requesting-user.name}} demande à rejoindre le groupe \"{{group.name}}\". En tant qu\'administrateur de ce groupe, vous avez la possibilité d\'accepter ou de rejeter cette demande.\n\nPour traiter cette demande et celles qui sont en attente, cliquez ici: {{{group-requests.url}}}\n\nPour en savoir plus sur {{requesting-user.name}}, visitez son profil: {{{profile.url}}}', 'publish', 'closed', 'closed', '', 'site-name-demande-dadhesion-au-groupe-group-name', '', '', '2016-12-26 10:39:41', '2016-12-26 09:39:41', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=19', 0, 'bp-email', '', 0),
(20, 1, '2016-12-26 10:39:41', '2016-12-26 09:39:41', '{{sender.name}} vous a envoyé un nouveau message: &quot;{{usersubject}}&quot;\n\n<blockquote>&quot;{{usermessage}}&quot;</blockquote>\n\n<a href=\"{{{message.url}}}\">Accès à la discussion</a> pour répondre ou continuer la conversation.', '[{{{site.name}}}] Nouveau message de {{sender.name}}', '{{sender.name}} vous a envoyé un nouveau message intitulé: \"{{usersubject}}\"\n\n\"{{usermessage}}\"\n\nPour lui répondre ou poursuivre la conversation, cliquez ici: {{{message.url}}}', 'publish', 'closed', 'closed', '', 'site-name-nouveau-message-de-sender-name', '', '', '2016-12-26 10:39:41', '2016-12-26 09:39:41', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=20', 0, 'bp-email', '', 0),
(21, 1, '2016-12-26 10:39:41', '2016-12-26 09:39:41', 'Vous avez récemment modifié l\'adresse mail associée à votre compte sur {{site.name}} pour {{user.email}}.  Si elle est correcte,<a href=\"{{{verify.url}}}\">cliquez ici pour confirmer votre modification</a>.\n\nSinon, si vous avez changé d\'avis ou que vous pensez que cet email vous a été adressé par erreur, ne tenez pas compte de ce message et supprimez-le.', '[{{{site.name}}}] Vérifiez votre nouvelle adresse email', 'Vous avez récemment modifié l\'adresse mail associée à votre compte sur {{site.name}} pour {{user.email}}.  Si elle est correcte, suivez ce lien pour confirmer votre modification: {{{verify.url}}}\n\nSinon, si vous avez changé d\'avis ou que vous pensez que cet email vous a été adressé par erreur, ne tenez pas compte de ce message et supprimez-le.', 'publish', 'closed', 'closed', '', 'site-name-verifiez-votre-nouvelle-adresse-email', '', '', '2016-12-26 10:39:41', '2016-12-26 09:39:41', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=21', 0, 'bp-email', '', 0),
(22, 1, '2016-12-26 10:39:41', '2016-12-26 09:39:41', 'Votre demande d\'adhésion au groupe &quot;<a href=\"{{{group.url}}}\">{{group.name}}</a>&quot; a été acceptée.', '[{{{site.name}}}] votre demande d\'adhésion au groupe \"{{group.name}}\" a été acceptée', 'Votre demande d\'adhésion au groupe \"{{group.name}}\" a été acceptée.\n\nPour voir le groupe, cliquez ici: {{{group.url}}}', 'publish', 'closed', 'closed', '', 'site-name-votre-demande-dadhesion-au-groupe-group-name-a-ete-acceptee', '', '', '2016-12-26 10:39:41', '2016-12-26 09:39:41', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=22', 0, 'bp-email', '', 0),
(23, 1, '2016-12-26 10:39:41', '2016-12-26 09:39:41', 'Votre demande d\'adhésion au groupe &quot;<a href=\"{{{group.url}}}\">{{group.name}}</a>&quot; a été rejetée.', '[{{{site.name}}}] votre demande d\'adhésion au groupe \"{{group.name}}\" a été rejetée', 'Votre demande d\'adhésion au groupe \"{{group.name}}\" a été rejetée.\n\nPour solliciter une nouvelle demande, cliquez ici: {{{group.url}}}', 'publish', 'closed', 'closed', '', 'site-name-votre-demande-dadhesion-au-groupe-group-name-a-ete-rejetee', '', '', '2016-12-26 10:39:41', '2016-12-26 09:39:41', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=23', 0, 'bp-email', '', 0),
(24, 1, '2016-12-26 10:40:11', '2016-12-26 09:40:11', '', 'Groupes', '', 'publish', 'closed', 'closed', '', 'groupes', '', '', '2016-12-26 10:40:11', '2016-12-26 09:40:11', '', 0, 'http://leshommesdebout.org/groupes/', 0, 'page', '', 0),
(25, 0, '2017-01-02 09:07:42', '2017-01-02 08:07:42', '[bp-instant-chat]', 'Chat', '', 'publish', 'closed', 'closed', '', 'chat', '', '', '2017-01-02 09:07:42', '2017-01-02 08:07:42', '', 0, 'http://leshommesdebout.org/chat/', 0, 'page', '', 0),
(26, 1, '2017-01-02 10:07:42', '2017-01-02 09:07:42', '', 'Messages sur le mur', '', 'hidden', 'closed', 'closed', '', 'messages-sur-le-mur', '', '', '2017-01-02 10:07:42', '2017-01-02 09:07:42', '', 0, 'http://leshommesdebout.org/2017/01/02/messages-sur-le-mur/', 0, 'rtmedia_album', '', 0),
(27, 1, '2017-01-02 10:07:46', '2017-01-02 09:07:46', '{{organizer.name}} planifie un nouveau rendez-vous: {{{rendezvous.content}}}\n\nAidez le à fixer la date en vous connectant sur: <a href=\"{{{rendezvous.url}}}\">{{rendezvous.title}}</a>.', '[{{{site.name}}}] {{organizer.name}} vous a invité à un nouveau rendez-vous', '{{organizer.name}} planifie un nouveau rendez-vous: {{rendezvous.content}}\n\nAidez le à fixer la date en vous connectant sur: \n\n{{{rendezvous.url}}}.', 'publish', 'closed', 'closed', '', 'site-name-organizer-name-vous-a-invite-a-un-nouveau-rendez-vous', '', '', '2017-01-02 10:07:46', '2017-01-02 09:07:46', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=27', 0, 'bp-email', '', 0),
(28, 1, '2017-01-02 10:07:46', '2017-01-02 09:07:46', '{{organizer.name}} {{rendezvous.action}} pour le rendez-vous: {{{rendezvous.content}}}\n\nPour en savoir plus connectez vous sur: <a href=\"{{{rendezvous.url}}}\">{{rendezvous.title}}</a>.', '[{{{site.name}}}] {{organizer.name}} a mis à jour un rendez-vous', '{{organizer.name}} {{rendezvous.action}} pour le rendez-vous: {{rendezvous.content}}\n\nPour en savoir plus connectez vous sur: \n\n{{{rendezvous.url}}}.', 'publish', 'closed', 'closed', '', 'site-name-organizer-name-a-mis-a-jour-un-rendez-vous', '', '', '2017-01-02 10:07:46', '2017-01-02 09:07:46', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=28', 0, 'bp-email', '', 0),
(29, 1, '2017-01-02 10:07:46', '2017-01-02 09:07:46', '{{attendee.name}} a indiqué ses préférences au sujet du rendez-vous: {{{rendezvous.content}}}\n\nPour en savoir plus connectez vous sur: <a href=\"{{{rendezvous.url}}}\">{{rendezvous.title}}</a>.', '[{{{site.name}}}] {{attendee.name}} a fait un choix de date(s) pour un rendez-vous', '{{attendee.name}} a indiqué ses préférences au sujet du rendez-vous: {{rendezvous.content}}\n\nPour en savoir plus connectez vous sur: \n\n{{{rendezvous.url}}}.', 'publish', 'closed', 'closed', '', 'site-name-attendee-name-a-fait-un-choix-de-dates-pour-un-rendez-vous', '', '', '2017-01-02 10:07:46', '2017-01-02 09:07:46', '', 0, 'http://leshommesdebout.org/?post_type=bp-email&p=29', 0, 'bp-email', '', 0),
(30, 1, '2017-01-02 10:09:09', '2017-01-02 09:09:09', '[videowhisper_channel_manage]', 'Broadcast Live', '', 'publish', 'closed', 'closed', '', 'broadcast-live', '', '', '2017-01-06 17:33:41', '2017-01-06 16:33:41', '', 6, 'http://leshommesdebout.org/broadcast-live/', 0, 'page', '', 0),
(31, 1, '2017-01-02 10:09:09', '2017-01-02 09:09:09', '[videowhisper_channels]', 'Channels', '', 'publish', 'closed', 'closed', '', 'channels', '', '', '2017-01-02 10:09:09', '2017-01-02 09:09:09', '', 0, 'http://leshommesdebout.org/channels/', 0, 'page', '', 0),
(33, 1, '2017-01-02 10:26:34', '2017-01-02 09:26:34', 'moi', 'qui suis je ?', '', 'publish', 'closed', 'closed', '', 'qui-suis-je', '', '', '2017-01-02 10:26:34', '2017-01-02 09:26:34', '', 0, 'http://leshommesdebout.org/answers/qui-suis-je/', 0, 'cma_thread', '', 0),
(35, 1, '2017-01-02 11:04:23', '2017-01-02 10:04:23', '', 'signature-université-minimale_07', '', 'inherit', 'open', 'closed', '', 'signature-universite-minimale_07', '', '', '2017-01-02 11:04:23', '2017-01-02 10:04:23', '', 0, 'http://leshommesdebout.org/wp-content/uploads/2017/01/signature-université-minimale_07.png', 0, 'attachment', 'image/png', 0),
(36, 1, '2017-01-02 11:04:40', '2017-01-02 10:04:40', 'http://leshommesdebout.org/wp-content/uploads/2017/01/cropped-signature-université-minimale_07.png', 'cropped-signature-université-minimale_07.png', '', 'inherit', 'open', 'closed', '', 'cropped-signature-universite-minimale_07-png', '', '', '2017-01-02 11:04:40', '2017-01-02 10:04:40', '', 0, 'http://leshommesdebout.org/wp-content/uploads/2017/01/cropped-signature-université-minimale_07.png', 0, 'attachment', 'image/png', 0),
(38, 1, '2017-01-02 11:16:26', '2017-01-02 10:16:26', '', 'Slider_retour_ceremonie_JPSauvage', '', 'inherit', 'open', 'closed', '', 'slider_retour_ceremonie_jpsauvage', '', '', '2017-01-02 11:16:26', '2017-01-02 10:16:26', '', 0, 'http://leshommesdebout.org/wp-content/uploads/2017/01/Slider_retour_ceremonie_JPSauvage.jpg', 0, 'attachment', 'image/jpeg', 0),
(39, 1, '2017-01-02 11:16:37', '2017-01-02 10:16:37', '', 'cropped-Slider_retour_ceremonie_JPSauvage.jpg', '', 'inherit', 'open', 'closed', '', 'cropped-slider_retour_ceremonie_jpsauvage-jpg', '', '', '2017-01-02 11:16:37', '2017-01-02 10:16:37', '', 0, 'http://leshommesdebout.org/wp-content/uploads/2017/01/cropped-Slider_retour_ceremonie_JPSauvage.jpg', 0, 'attachment', 'image/jpeg', 0),
(41, 1, '2017-01-02 11:21:28', '2017-01-02 10:21:28', '', 'DSC_0498', '', 'inherit', 'open', 'closed', '', 'dsc_0498', '', '', '2017-01-02 11:21:28', '2017-01-02 10:21:28', '', 26, 'http://leshommesdebout.org/wp-content/uploads/rtMedia/users/1/2017/01/DSC_0498.jpg', 0, 'attachment', 'image/jpeg', 0),
(42, 1, '2017-01-02 11:22:27', '2017-01-02 10:22:27', '', 'DSC_0462', '', 'inherit', 'open', 'closed', '', 'dsc_0462', '', '', '2017-01-02 11:22:27', '2017-01-02 10:22:27', '', 26, 'http://leshommesdebout.org/wp-content/uploads/rtMedia/users/1/2017/01/DSC_0462.jpg', 0, 'attachment', 'image/jpeg', 1),
(43, 1, '2017-01-02 11:34:38', '2017-01-02 10:34:38', 'Bienvenue dans WordPress. Ceci est votre premier article. Modifiez-le ou supprimez-le, puis lancez-vous&nbsp;!', 'Bonjour tout le monde&nbsp;!', '', 'inherit', 'closed', 'closed', '', '1-revision-v1', '', '', '2017-01-02 11:34:38', '2017-01-02 10:34:38', '', 1, 'http://leshommesdebout.org/2017/01/02/1-revision-v1/', 0, 'revision', '', 0),
(44, 1, '2017-01-02 11:34:38', '2017-01-02 10:34:38', 'Bienvenue dans WordPress. Ceci est votre premier article. Modifiez-le ou supprimez-le, puis lancez-vous&nbsp;!', 'La communiction grand public', '', 'inherit', 'closed', 'closed', '', '1-revision-v1', '', '', '2017-01-02 11:34:38', '2017-01-02 10:34:38', '', 1, 'http://leshommesdebout.org/2017/01/02/1-revision-v1/', 0, 'revision', '', 0),
(45, 1, '2017-01-02 11:34:38', '2017-01-02 10:34:38', 'Bienvenue dans WordPress. Ceci est votre premier article. Modifiez-le ou supprimez-le, puis lancez-vous !', 'La communiction grand public', '', 'inherit', 'closed', 'closed', '', '1-revision-v1', '', '', '2017-01-02 11:34:38', '2017-01-02 10:34:38', '', 1, 'http://leshommesdebout.org/2017/01/02/1-revision-v1/', 0, 'revision', '', 0),
(54, 1, '2017-01-06 17:33:41', '2017-01-06 16:33:41', '[videowhisper_channel_manage]', 'Broadcast Live', '', 'inherit', 'closed', 'closed', '', '30-revision-v1', '', '', '2017-01-06 17:33:41', '2017-01-06 16:33:41', '', 30, 'http://leshommesdebout.org/2017/01/06/30-revision-v1/', 0, 'revision', '', 0),
(48, 1, '2017-01-02 17:11:42', '2017-01-02 16:11:42', '', 'communication', '', 'inherit', 'open', 'closed', '', 'communication', '', '', '2017-01-02 17:11:42', '2017-01-02 16:11:42', '', 26, 'http://leshommesdebout.org/wp-content/uploads/rtMedia/users/1/2017/01/communication.jpeg', 0, 'attachment', 'image/jpeg', 1),
(51, 1, '2017-01-02 17:24:04', '2017-01-02 16:24:04', '', 'Page 1 menu gauche', '', 'publish', 'closed', 'closed', '', 'page-1-menu-gauche', '', '', '2017-01-02 17:24:28', '2017-01-02 16:24:28', '', 0, 'http://leshommesdebout.org/?page_id=51', 0, 'page', '', 0);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_rt_rtm_activity`
--

CREATE TABLE `leshommesdebout_wp_rt_rtm_activity` (
  `activity_id` bigint DEFAULT NULL,
  `user_id` bigint NOT NULL,
  `privacy` int DEFAULT NULL,
  `blog_id` bigint DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_rt_rtm_activity`
--

INSERT INTO `leshommesdebout_wp_rt_rtm_activity` (`activity_id`, `user_id`, `privacy`, `blog_id`) VALUES
(3, 1, 0, 1),
(7, 1, -1, 1),
(9, 1, -1, 1),
(10, 1, -1, 1);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_rt_rtm_api`
--

CREATE TABLE `leshommesdebout_wp_rt_rtm_api` (
  `id` bigint NOT NULL,
  `user_id` bigint NOT NULL DEFAULT '0',
  `ip` varchar(255) NOT NULL DEFAULT '0',
  `token_time` varchar(1000) DEFAULT NULL,
  `token` varchar(1000) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `last_access` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_rt_rtm_media`
--

CREATE TABLE `leshommesdebout_wp_rt_rtm_media` (
  `id` bigint NOT NULL,
  `blog_id` bigint DEFAULT NULL,
  `media_id` bigint NOT NULL,
  `media_author` bigint NOT NULL,
  `media_title` text,
  `album_id` bigint DEFAULT NULL,
  `media_type` varchar(100) DEFAULT NULL,
  `context` varchar(100) DEFAULT NULL,
  `context_id` bigint DEFAULT NULL,
  `source` varchar(100) DEFAULT NULL,
  `source_id` bigint DEFAULT NULL,
  `activity_id` bigint DEFAULT NULL,
  `cover_art` varchar(250) DEFAULT NULL,
  `privacy` int DEFAULT NULL,
  `views` bigint DEFAULT '0',
  `downloads` bigint DEFAULT '0',
  `ratings_total` bigint DEFAULT '0',
  `ratings_count` bigint DEFAULT '0',
  `ratings_average` decimal(4,2) DEFAULT '0.00',
  `likes` bigint DEFAULT '0',
  `dislikes` bigint DEFAULT '0',
  `upload_date` datetime DEFAULT '0000-00-00 00:00:00',
  `file_size` bigint DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_rt_rtm_media`
--

INSERT INTO `leshommesdebout_wp_rt_rtm_media` (`id`, `blog_id`, `media_id`, `media_author`, `media_title`, `album_id`, `media_type`, `context`, `context_id`, `source`, `source_id`, `activity_id`, `cover_art`, `privacy`, `views`, `downloads`, `ratings_total`, `ratings_count`, `ratings_average`, `likes`, `dislikes`, `upload_date`, `file_size`) VALUES
(1, 1, 26, 1, 'Messages sur le mur', NULL, 'album', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0.00, 0, 0, '0000-00-00 00:00:00', NULL),
(2, 1, 41, 1, 'DSC_0498', 1, 'photo', 'profile', 1, NULL, NULL, 3, NULL, 0, 0, 0, 0, 0, 0.00, 0, 0, '2017-01-02 11:21:28', 5123830),
(3, 1, 42, 1, 'DSC_0462', 1, 'photo', 'profile', 1, NULL, NULL, 3, NULL, 0, 0, 0, 0, 0, 0.00, 0, 0, '2017-01-02 11:22:27', 6355892),
(4, 1, 48, 1, 'communication', 1, 'photo', 'profile', 1, NULL, NULL, 7, NULL, 0, 0, 0, 0, 0, 0.00, 0, 0, '2017-01-02 17:11:42', 2190431);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_rt_rtm_media_interaction`
--

CREATE TABLE `leshommesdebout_wp_rt_rtm_media_interaction` (
  `id` bigint NOT NULL,
  `user_id` bigint NOT NULL DEFAULT '0',
  `media_id` bigint NOT NULL DEFAULT '0',
  `action` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `action_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_rt_rtm_media_interaction`
--

INSERT INTO `leshommesdebout_wp_rt_rtm_media_interaction` (`id`, `user_id`, `media_id`, `action`, `value`, `action_date`) VALUES
(1, 1, 3, 'view', '3', '2017-01-02 10:33:23'),
(2, 1, 4, 'view', '1', '2017-01-02 16:12:14'),
(3, 2, 3, 'view', '1', '2017-01-02 20:59:05');

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_rt_rtm_media_meta`
--

CREATE TABLE `leshommesdebout_wp_rt_rtm_media_meta` (
  `id` bigint NOT NULL,
  `media_id` bigint NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_signups`
--

CREATE TABLE `leshommesdebout_wp_signups` (
  `signup_id` bigint NOT NULL,
  `domain` varchar(200) NOT NULL DEFAULT '',
  `path` varchar(100) NOT NULL DEFAULT '',
  `title` longtext NOT NULL,
  `user_login` varchar(60) NOT NULL DEFAULT '',
  `user_email` varchar(100) NOT NULL DEFAULT '',
  `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `activated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `activation_key` varchar(50) NOT NULL DEFAULT '',
  `meta` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_spidercalendar_calendar`
--

CREATE TABLE `leshommesdebout_wp_spidercalendar_calendar` (
  `id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `gid` varchar(255) NOT NULL,
  `def_zone` varchar(255) NOT NULL,
  `time_format` tinyint(1) NOT NULL,
  `allow_publish` varchar(255) NOT NULL,
  `def_year` varchar(512) NOT NULL,
  `def_month` varchar(255) NOT NULL,
  `published` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_spidercalendar_calendar`
--

INSERT INTO `leshommesdebout_wp_spidercalendar_calendar` (`id`, `title`, `gid`, `def_zone`, `time_format`, `allow_publish`, `def_year`, `def_month`, `published`) VALUES
(1, 'Mes événements', '', 'Asia/Muscat', 0, '', '2017', '', 1);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_spidercalendar_event`
--

CREATE TABLE `leshommesdebout_wp_spidercalendar_event` (
  `id` int NOT NULL,
  `calendar` int NOT NULL,
  `date` date NOT NULL,
  `date_end` date NOT NULL,
  `title` text NOT NULL,
  `category` int DEFAULT NULL,
  `time` varchar(20) NOT NULL,
  `text_for_date` longtext NOT NULL,
  `userID` varchar(255) NOT NULL,
  `repeat_method` varchar(255) NOT NULL,
  `repeat` varchar(255) NOT NULL,
  `week` varchar(255) NOT NULL,
  `month` varchar(255) NOT NULL,
  `month_type` varchar(255) NOT NULL,
  `monthly_list` varchar(255) NOT NULL,
  `month_week` varchar(255) NOT NULL,
  `year_month` varchar(255) NOT NULL,
  `published` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_spidercalendar_event_category`
--

CREATE TABLE `leshommesdebout_wp_spidercalendar_event_category` (
  `id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `color` varchar(255) NOT NULL,
  `description` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_spidercalendar_theme`
--

CREATE TABLE `leshommesdebout_wp_spidercalendar_theme` (
  `id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `width` varchar(255) NOT NULL,
  `cell_height` varchar(255) NOT NULL,
  `bg_top` varchar(255) NOT NULL,
  `bg_bottom` varchar(255) NOT NULL,
  `border_color` varchar(255) NOT NULL,
  `text_color_year` varchar(255) NOT NULL,
  `text_color_month` varchar(255) NOT NULL,
  `text_color_week_days` varchar(255) NOT NULL,
  `text_color_other_months` varchar(255) NOT NULL,
  `text_color_this_month_unevented` varchar(255) NOT NULL,
  `text_color_this_month_evented` varchar(255) NOT NULL,
  `event_title_color` varchar(255) NOT NULL,
  `current_day_border_color` varchar(255) NOT NULL,
  `bg_color_this_month_evented` varchar(255) NOT NULL,
  `next_prev_event_arrowcolor` varchar(255) NOT NULL,
  `show_event_bgcolor` varchar(255) NOT NULL,
  `cell_border_color` varchar(255) NOT NULL,
  `arrow_color_year` varchar(255) NOT NULL,
  `week_days_cell_height` varchar(255) NOT NULL,
  `arrow_color_month` varchar(255) NOT NULL,
  `text_color_sun_days` varchar(255) NOT NULL,
  `title_color` varchar(255) NOT NULL,
  `next_prev_event_bgcolor` varchar(255) NOT NULL,
  `title_font_size` varchar(255) NOT NULL,
  `title_font` varchar(255) NOT NULL,
  `title_style` varchar(255) NOT NULL,
  `date_color` varchar(255) NOT NULL,
  `date_size` varchar(255) NOT NULL,
  `date_font` varchar(255) NOT NULL,
  `date_style` varchar(255) NOT NULL,
  `popup_width` varchar(255) NOT NULL,
  `popup_height` varchar(255) NOT NULL,
  `number_of_shown_evetns` varchar(255) NOT NULL,
  `sundays_font_size` varchar(255) NOT NULL,
  `other_days_font_size` varchar(255) NOT NULL,
  `weekdays_font_size` varchar(255) NOT NULL,
  `border_width` varchar(255) NOT NULL,
  `top_height` varchar(255) NOT NULL,
  `bg_color_other_months` varchar(255) NOT NULL,
  `sundays_bg_color` varchar(255) NOT NULL,
  `weekdays_bg_color` varchar(255) NOT NULL,
  `week_start_day` varchar(255) NOT NULL,
  `weekday_sunday_bg_color` varchar(255) NOT NULL,
  `border_radius` varchar(255) NOT NULL,
  `year_font_size` varchar(255) NOT NULL,
  `month_font_size` varchar(255) NOT NULL,
  `arrow_size` varchar(255) NOT NULL,
  `next_month_text_color` varchar(255) NOT NULL,
  `prev_month_text_color` varchar(255) NOT NULL,
  `next_month_arrow_color` varchar(255) NOT NULL,
  `prev_month_arrow_color` varchar(255) NOT NULL,
  `next_month_font_size` varchar(255) NOT NULL,
  `prev_month_font_size` varchar(255) NOT NULL,
  `month_type` varchar(255) NOT NULL,
  `date_format` varchar(255) NOT NULL,
  `show_time` int NOT NULL,
  `show_cat` int NOT NULL,
  `show_repeat` int NOT NULL,
  `date_bg_color` varchar(255) NOT NULL,
  `event_bg_color1` varchar(255) NOT NULL,
  `event_bg_color2` varchar(255) NOT NULL,
  `event_num_bg_color1` varchar(255) NOT NULL,
  `event_num_bg_color2` varchar(255) NOT NULL,
  `event_num_color` varchar(255) NOT NULL,
  `date_font_size` varchar(255) NOT NULL,
  `event_num_font_size` varchar(255) NOT NULL,
  `event_table_height` varchar(255) NOT NULL,
  `date_height` varchar(255) NOT NULL,
  `ev_title_bg_color` varchar(255) NOT NULL,
  `week_font_size` varchar(255) NOT NULL,
  `day_month_font_size` varchar(255) NOT NULL,
  `week_font_color` varchar(255) NOT NULL,
  `day_month_font_color` varchar(255) NOT NULL,
  `views_tabs_bg_color` varchar(255) NOT NULL,
  `views_tabs_text_color` varchar(255) NOT NULL,
  `views_tabs_font_size` varchar(255) NOT NULL,
  `day_start` int NOT NULL,
  `header_format` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_spidercalendar_theme`
--

INSERT INTO `leshommesdebout_wp_spidercalendar_theme` (`id`, `title`, `width`, `cell_height`, `bg_top`, `bg_bottom`, `border_color`, `text_color_year`, `text_color_month`, `text_color_week_days`, `text_color_other_months`, `text_color_this_month_unevented`, `text_color_this_month_evented`, `event_title_color`, `current_day_border_color`, `bg_color_this_month_evented`, `next_prev_event_arrowcolor`, `show_event_bgcolor`, `cell_border_color`, `arrow_color_year`, `week_days_cell_height`, `arrow_color_month`, `text_color_sun_days`, `title_color`, `next_prev_event_bgcolor`, `title_font_size`, `title_font`, `title_style`, `date_color`, `date_size`, `date_font`, `date_style`, `popup_width`, `popup_height`, `number_of_shown_evetns`, `sundays_font_size`, `other_days_font_size`, `weekdays_font_size`, `border_width`, `top_height`, `bg_color_other_months`, `sundays_bg_color`, `weekdays_bg_color`, `week_start_day`, `weekday_sunday_bg_color`, `border_radius`, `year_font_size`, `month_font_size`, `arrow_size`, `next_month_text_color`, `prev_month_text_color`, `next_month_arrow_color`, `prev_month_arrow_color`, `next_month_font_size`, `prev_month_font_size`, `month_type`, `date_format`, `show_time`, `show_cat`, `show_repeat`, `date_bg_color`, `event_bg_color1`, `event_bg_color2`, `event_num_bg_color1`, `event_num_bg_color2`, `event_num_color`, `date_font_size`, `event_num_font_size`, `event_table_height`, `date_height`, `ev_title_bg_color`, `week_font_size`, `day_month_font_size`, `week_font_color`, `day_month_font_color`, `views_tabs_bg_color`, `views_tabs_text_color`, `views_tabs_font_size`, `day_start`, `header_format`) VALUES
(13, 'Shiny Blue', '700', '90', '005478', 'F8F8F8', '005478', 'F9F2F4', 'F9F2F4', 'CCD1D2', '004B6C', '004B6C', '004B6C', '005478', '005478', 'F8F8F8', '97A0A6', 'B4C5CC', 'CCD1D2 ', 'CCD1D2', '30', 'CCD1D2', '004B6C', 'FFFFFF', '00608A', '', '', 'normal', '262626', '', '', 'normal', '600', '500', '1', '17', '17', '17', '0', '90', 'F8F8F8', 'F8F8F8', '006285', 'su', '006285', '0', '25', '25', '25', 'CCD1D2', 'CCD1D2', 'CCD1D2', '1010A4', '16', '16', '2', 'w/d/m/y', 1, 1, 1, 'D6D4D5', 'F8F8F8', 'DEDCDD', '005478', '006E91', 'FFFFFF', '15', '13', '30', '25', 'F8F8F8', '15', '12', '005476', '737373', '01799C', 'FFFFFF', '13', 1, 'w/d/m/y');

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_spidercalendar_widget_theme`
--

CREATE TABLE `leshommesdebout_wp_spidercalendar_widget_theme` (
  `id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `ev_title_color` varchar(255) DEFAULT NULL,
  `width` varchar(255) NOT NULL,
  `week_start_day` varchar(255) NOT NULL,
  `show_cat` int NOT NULL,
  `font_year` varchar(255) NOT NULL,
  `font_month` varchar(255) NOT NULL,
  `font_day` varchar(255) NOT NULL,
  `font_weekday` varchar(255) NOT NULL,
  `header_bgcolor` varchar(255) NOT NULL,
  `footer_bgcolor` varchar(255) NOT NULL,
  `text_color_month` varchar(255) NOT NULL,
  `text_color_week_days` varchar(255) NOT NULL,
  `text_color_other_months` varchar(255) NOT NULL,
  `text_color_this_month_unevented` varchar(255) NOT NULL,
  `text_color_this_month_evented` varchar(255) NOT NULL,
  `bg_color_this_month_evented` varchar(255) NOT NULL,
  `bg_color_selected` varchar(255) NOT NULL,
  `arrow_color` varchar(255) NOT NULL,
  `text_color_selected` varchar(255) NOT NULL,
  `border_day` varchar(255) NOT NULL,
  `text_color_sun_days` varchar(255) NOT NULL,
  `weekdays_bg_color` varchar(255) NOT NULL,
  `su_bg_color` varchar(255) NOT NULL,
  `cell_border_color` varchar(255) NOT NULL,
  `year_font_size` varchar(255) NOT NULL,
  `year_font_color` varchar(255) NOT NULL,
  `year_tabs_bg_color` varchar(255) NOT NULL,
  `date_format` varchar(255) NOT NULL,
  `title_color` varchar(255) NOT NULL,
  `title_font_size` varchar(255) NOT NULL,
  `title_font` varchar(255) NOT NULL,
  `title_style` varchar(255) NOT NULL,
  `date_color` varchar(255) NOT NULL,
  `date_size` varchar(255) NOT NULL,
  `date_font` varchar(255) NOT NULL,
  `date_style` varchar(255) NOT NULL,
  `next_prev_event_bgcolor` varchar(255) NOT NULL,
  `next_prev_event_arrowcolor` varchar(255) NOT NULL,
  `show_event_bgcolor` varchar(255) NOT NULL,
  `popup_width` varchar(255) NOT NULL,
  `popup_height` varchar(255) NOT NULL,
  `show_repeat` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_spidercalendar_widget_theme`
--

INSERT INTO `leshommesdebout_wp_spidercalendar_widget_theme` (`id`, `title`, `ev_title_color`, `width`, `week_start_day`, `show_cat`, `font_year`, `font_month`, `font_day`, `font_weekday`, `header_bgcolor`, `footer_bgcolor`, `text_color_month`, `text_color_week_days`, `text_color_other_months`, `text_color_this_month_unevented`, `text_color_this_month_evented`, `bg_color_this_month_evented`, `bg_color_selected`, `arrow_color`, `text_color_selected`, `border_day`, `text_color_sun_days`, `weekdays_bg_color`, `su_bg_color`, `cell_border_color`, `year_font_size`, `year_font_color`, `year_tabs_bg_color`, `date_format`, `title_color`, `title_font_size`, `title_font`, `title_style`, `date_color`, `date_size`, `date_font`, `date_style`, `next_prev_event_bgcolor`, `next_prev_event_arrowcolor`, `show_event_bgcolor`, `popup_width`, `popup_height`, `show_repeat`) VALUES
(1, 'Shiny Blue', '005478', '200', 'mo', 1, '', '', '', '', '005478', 'E1E1E1', 'FFFFFF', '2F647D', '939699', '989898', 'FBFFFE', '005478', '005478', 'CED1D0', 'FFFFFF', '005478', '989898', 'D6D6D6', 'B5B5B5', 'D2D2D2', '13', 'ACACAC', 'ECECEC', 'w/d/m/y', 'FFFFFF', '', '', 'normal', '262626', '', '', 'normal', '00608A', '97A0A6', 'B4C5CC', '600', '500', '1');

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_termmeta`
--

CREATE TABLE `leshommesdebout_wp_termmeta` (
  `meta_id` bigint UNSIGNED NOT NULL,
  `term_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_terms`
--

CREATE TABLE `leshommesdebout_wp_terms` (
  `term_id` bigint UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(200) NOT NULL DEFAULT '',
  `term_group` bigint NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_terms`
--

INSERT INTO `leshommesdebout_wp_terms` (`term_id`, `name`, `slug`, `term_group`) VALUES
(1, 'Non classé', 'non-classe', 0),
(2, 'activity-comment', 'activity-comment', 0),
(3, 'activity-comment-author', 'activity-comment-author', 0),
(4, 'activity-at-message', 'activity-at-message', 0),
(5, 'groups-at-message', 'groups-at-message', 0),
(6, 'core-user-registration', 'core-user-registration', 0),
(7, 'core-user-registration-with-blog', 'core-user-registration-with-blog', 0),
(8, 'friends-request', 'friends-request', 0),
(9, 'friends-request-accepted', 'friends-request-accepted', 0),
(10, 'groups-details-updated', 'groups-details-updated', 0),
(11, 'groups-invitation', 'groups-invitation', 0),
(12, 'groups-member-promoted', 'groups-member-promoted', 0),
(13, 'groups-membership-request', 'groups-membership-request', 0),
(14, 'messages-unread', 'messages-unread', 0),
(15, 'settings-verify-email-change', 'settings-verify-email-change', 0),
(16, 'groups-membership-request-accepted', 'groups-membership-request-accepted', 0),
(17, 'groups-membership-request-rejected', 'groups-membership-request-rejected', 0),
(18, 'rendez-vous-new-item', 'rendez-vous-new-item', 0),
(19, 'rendez-vous-item-edited', 'rendez-vous-item-edited', 0),
(20, 'rendez-vous-preference-set', 'rendez-vous-preference-set', 0),
(21, 'Menu gauche', 'menu-gauche', 0);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_term_relationships`
--

CREATE TABLE `leshommesdebout_wp_term_relationships` (
  `object_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `term_order` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_term_relationships`
--

INSERT INTO `leshommesdebout_wp_term_relationships` (`object_id`, `term_taxonomy_id`, `term_order`) VALUES
(1, 1, 0),
(8, 2, 0),
(9, 3, 0),
(10, 4, 0),
(11, 5, 0),
(12, 6, 0),
(13, 7, 0),
(14, 8, 0),
(15, 9, 0),
(16, 10, 0),
(17, 11, 0),
(18, 12, 0),
(19, 13, 0),
(20, 14, 0),
(21, 15, 0),
(22, 16, 0),
(23, 17, 0),
(27, 18, 0),
(28, 19, 0),
(29, 20, 0);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_term_taxonomy`
--

CREATE TABLE `leshommesdebout_wp_term_taxonomy` (
  `term_taxonomy_id` bigint UNSIGNED NOT NULL,
  `term_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `parent` bigint UNSIGNED NOT NULL DEFAULT '0',
  `count` bigint NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_term_taxonomy`
--

INSERT INTO `leshommesdebout_wp_term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES
(1, 1, 'category', '', 0, 1),
(2, 2, 'bp-email-type', 'Un membre répond à une mise à jour d\'activité publié par le destinataire.', 0, 1),
(3, 3, 'bp-email-type', 'Un membre répond à un commentaire d\'activité publié par le destinataire.', 0, 1),
(4, 4, 'bp-email-type', 'Le destinataire a été mentionné dans une mise à jour d\'activité.', 0, 1),
(5, 5, 'bp-email-type', 'Le destinataire a été mentionné dans une mise à jour d\'activité d\'un groupe.', 0, 1),
(6, 6, 'bp-email-type', 'Le destinataire a ouvert un compte.', 0, 1),
(7, 7, 'bp-email-type', 'Le destinataire a ouvert un compte et un site.', 0, 1),
(8, 8, 'bp-email-type', 'Un membre demande à être ajouté comme ami du destinataire.', 0, 1),
(9, 9, 'bp-email-type', 'Le destinataire a été accepté comme ami par un membre.', 0, 1),
(10, 10, 'bp-email-type', 'Des informations sur le groupe ont été mises à jour.', 0, 1),
(11, 11, 'bp-email-type', 'Un membre envoye une invitation à rejoindre un groupe au destinatiare', 0, 1),
(12, 12, 'bp-email-type', 'Le statut du destinataire dans un groupe a été modifié.', 0, 1),
(13, 13, 'bp-email-type', 'Un membre demande à rejoindre un groupe.', 0, 1),
(14, 14, 'bp-email-type', 'Le destinataire a reçu un message privé.', 0, 1),
(15, 15, 'bp-email-type', 'Le destinataire a modifié son adresse mail.', 0, 1),
(16, 16, 'bp-email-type', 'Le destinataire est autorisé à rejoindre un groupe.', 0, 1),
(17, 17, 'bp-email-type', 'Le destinataire n\'est pas autorisé à rejoindre un groupe.', 0, 1),
(18, 18, 'bp-email-type', 'Un membre a invité des membres à un nouveau rendez-vous', 0, 1),
(19, 19, 'bp-email-type', 'Un membre a mis à jour un rendez-vous', 0, 1),
(20, 20, 'bp-email-type', 'Un membre a fait un choix de date(s) pour un rendez-vous', 0, 1),
(21, 21, 'nav_menu', '', 0, 0);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_usermeta`
--

CREATE TABLE `leshommesdebout_wp_usermeta` (
  `umeta_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_usermeta`
--

INSERT INTO `leshommesdebout_wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
(1, 1, 'nickname', 'bruno.bernard'),
(2, 1, 'first_name', ''),
(3, 1, 'last_name', ''),
(4, 1, 'description', ''),
(5, 1, 'rich_editing', 'true'),
(6, 1, 'comment_shortcuts', 'false'),
(7, 1, 'admin_color', 'fresh'),
(8, 1, 'use_ssl', '0'),
(9, 1, 'show_admin_bar_front', 'true'),
(10, 1, 'leshommesdebout_wp_capabilities', 'a:1:{s:13:\"administrator\";b:1;}'),
(11, 1, 'leshommesdebout_wp_user_level', '10'),
(12, 1, 'dismissed_wp_pointers', ''),
(13, 1, 'show_welcome_panel', '1'),
(20, 1, 'session_tokens', 'a:1:{s:64:\"b0328bc2c0b8759e2b178506549815809788d52c5fbe49d0f49793f4f948b8ca\";a:4:{s:10:\"expiration\";i:1484901952;s:2:\"ip\";s:14:\"130.79.230.168\";s:2:\"ua\";s:76:\"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0\";s:5:\"login\";i:1484729152;}}'),
(15, 1, 'leshommesdebout_wp_dashboard_quick_press_last_post_id', '55'),
(18, 1, 'last_activity', '2017-01-18 08:54:20'),
(19, 1, 'rtmedia_counts_1', NULL),
(16, 1, 'leshommesdebout_wp_user-settings', 'libraryContent=browse'),
(17, 1, 'leshommesdebout_wp_user-settings-time', '1468995319'),
(21, 1, 'bp_favorite_activities', 'a:1:{i:0;s:1:\"5\";}'),
(22, 1, 'total_group_count', '1'),
(23, 1, 'bp_latest_update', 'a:2:{s:2:\"id\";i:9;s:7:\"content\";s:6:\"test 2\";}'),
(24, 1, 'leshommesdebout_wp_r_tru_u_x', 'a:2:{s:2:\"id\";i:0;s:7:\"expires\";i:1483377952;}'),
(25, 2, 'nickname', 'Bruno'),
(26, 2, 'first_name', 'Bruno'),
(27, 2, 'last_name', 'Bernard'),
(28, 2, 'description', ''),
(29, 2, 'rich_editing', 'true'),
(30, 2, 'comment_shortcuts', 'false'),
(31, 2, 'admin_color', 'fresh'),
(32, 2, 'use_ssl', '0'),
(33, 2, 'show_admin_bar_front', 'true'),
(34, 2, 'locale', ''),
(35, 2, 'leshommesdebout_wp_capabilities', 'a:1:{s:10:\"subscriber\";b:1;}'),
(36, 2, 'leshommesdebout_wp_user_level', '0'),
(37, 2, 'dismissed_wp_pointers', ''),
(41, 2, 'total_friend_count', '1'),
(39, 2, 'last_activity', '2017-01-02 20:56:14'),
(40, 1, 'friendship_request_messages', 'a:0:{}'),
(43, 2, 'rtmedia_counts_1', 'a:0:{}'),
(42, 1, 'total_friend_count', '1'),
(44, 2, 'session_tokens', 'a:1:{s:64:\"12b6bfa01d1a14209a87ea1275644c225ce1515fe5d12b3828a62c0d75f5e609\";a:4:{s:10:\"expiration\";i:1483563358;s:2:\"ip\";s:13:\"77.204.215.99\";s:2:\"ua\";s:125:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36 OPR/42.0.2393.94\";s:5:\"login\";i:1483390558;}}');

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_users`
--

CREATE TABLE `leshommesdebout_wp_users` (
  `ID` bigint UNSIGNED NOT NULL,
  `user_login` varchar(60) NOT NULL DEFAULT '',
  `user_pass` varchar(255) NOT NULL DEFAULT '',
  `user_nicename` varchar(50) NOT NULL DEFAULT '',
  `user_email` varchar(100) NOT NULL DEFAULT '',
  `user_url` varchar(100) NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(255) NOT NULL DEFAULT '',
  `user_status` int NOT NULL DEFAULT '0',
  `display_name` varchar(250) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_users`
--

INSERT INTO `leshommesdebout_wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES
(1, 'bruno.bernard', '$P$B.f3L4aCcKrcJeQbmm9lWWj.2oB0AP.', 'bruno-bernard', 'brunoreiki@gmail.com', '', '2016-07-19 21:02:52', '', 0, 'bruno.bernard'),
(2, 'Bruno', '$P$Ba6Af15KNdJzwocvO2wWYuXP/dmkt3.', 'bruno', 'bruno.bernard@unistra.fr', '', '2017-01-02 16:46:52', '1483375612:$P$BSJ7wPChCYBvl43CqW0a1aQ0x2Xlkg0', 0, 'Bruno Bernard');

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_vw_lsrooms`
--

CREATE TABLE `leshommesdebout_wp_vw_lsrooms` (
  `id` int NOT NULL,
  `name` varchar(64) NOT NULL,
  `owner` int NOT NULL,
  `sdate` int NOT NULL,
  `edate` int NOT NULL,
  `btime` int NOT NULL,
  `wtime` int NOT NULL,
  `rdate` int NOT NULL,
  `status` tinyint NOT NULL,
  `type` tinyint NOT NULL,
  `options` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Video Whisper: Rooms - 2014@videowhisper.com';

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_vw_lwsessions`
--

CREATE TABLE `leshommesdebout_wp_vw_lwsessions` (
  `id` int NOT NULL,
  `session` varchar(64) NOT NULL,
  `username` varchar(64) NOT NULL,
  `room` varchar(64) NOT NULL,
  `message` text NOT NULL,
  `sdate` int NOT NULL,
  `edate` int NOT NULL,
  `status` tinyint NOT NULL,
  `type` tinyint NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Video Whisper: Subscriber Sessions - 2009@videowhisper.com';

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_vw_sessions`
--

CREATE TABLE `leshommesdebout_wp_vw_sessions` (
  `id` int NOT NULL,
  `session` varchar(64) NOT NULL,
  `username` varchar(64) NOT NULL,
  `room` varchar(64) NOT NULL,
  `message` text NOT NULL,
  `sdate` int NOT NULL,
  `edate` int NOT NULL,
  `status` tinyint NOT NULL,
  `type` tinyint NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Video Whisper: Broadcaster Sessions - 2009@videowhisper.com';

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_vw_vcrooms`
--

CREATE TABLE `leshommesdebout_wp_vw_vcrooms` (
  `id` int NOT NULL,
  `name` varchar(64) NOT NULL,
  `owner` int NOT NULL,
  `sdate` int NOT NULL,
  `edate` int NOT NULL,
  `capacity` int NOT NULL,
  `status` tinyint NOT NULL,
  `type` tinyint NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Video Whisper: Rooms - 2014@videowhisper.com';

--
-- Déchargement des données de la table `leshommesdebout_wp_vw_vcrooms`
--

INSERT INTO `leshommesdebout_wp_vw_vcrooms` (`id`, `name`, `owner`, `sdate`, `edate`, `capacity`, `status`, `type`) VALUES
(1, 'Lobby', 1, 2017, 2017, 100, 1, 1);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_vw_vcsessions`
--

CREATE TABLE `leshommesdebout_wp_vw_vcsessions` (
  `id` int NOT NULL,
  `session` varchar(64) NOT NULL,
  `username` varchar(64) NOT NULL,
  `room` varchar(64) NOT NULL,
  `message` text NOT NULL,
  `sdate` int NOT NULL,
  `edate` int NOT NULL,
  `status` tinyint NOT NULL,
  `type` tinyint NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Video Whisper: Sessions - 2009@videowhisper.com';

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_wise_chat_actions`
--

CREATE TABLE `leshommesdebout_wp_wise_chat_actions` (
  `id` mediumint NOT NULL,
  `time` bigint NOT NULL DEFAULT '0',
  `user_id` bigint DEFAULT NULL,
  `command` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_wise_chat_actions`
--

INSERT INTO `leshommesdebout_wp_wise_chat_actions` (`id`, `time`, `user_id`, `command`) VALUES
(1, 1483354199, 1, '{\"name\":\"refreshPlainUserName\",\"data\":{\"name\":\"Anonymous2\"}}'),
(2, 1483354204, 1, '{\"name\":\"refreshPlainUserName\",\"data\":{\"name\":\"bruno.bernard\"}}'),
(3, 1483354214, 1, '{\"name\":\"refreshPlainUserName\",\"data\":{\"name\":\"Anonymous2\"}}'),
(4, 1483354223, 1, '{\"name\":\"refreshPlainUserName\",\"data\":{\"name\":\"bruno.bernard\"}}');

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_wise_chat_bans`
--

CREATE TABLE `leshommesdebout_wp_wise_chat_bans` (
  `id` mediumint NOT NULL,
  `time` bigint NOT NULL DEFAULT '0',
  `created` bigint NOT NULL DEFAULT '0',
  `ip` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_wise_chat_channels`
--

CREATE TABLE `leshommesdebout_wp_wise_chat_channels` (
  `id` mediumint NOT NULL,
  `name` text NOT NULL,
  `password` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_wise_chat_channels`
--

INSERT INTO `leshommesdebout_wp_wise_chat_channels` (`id`, `name`, `password`) VALUES
(1, 'global', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_wise_chat_channel_users`
--

CREATE TABLE `leshommesdebout_wp_wise_chat_channel_users` (
  `id` mediumint NOT NULL,
  `channel_id` bigint DEFAULT NULL,
  `user_id` bigint DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `last_activity_time` bigint NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_wise_chat_channel_users`
--

INSERT INTO `leshommesdebout_wp_wise_chat_channel_users` (`id`, `channel_id`, `user_id`, `active`, `last_activity_time`) VALUES
(1, 1, 1, 0, 1483354888),
(2, 1, 2, 1, 1483375441);

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_wise_chat_messages`
--

CREATE TABLE `leshommesdebout_wp_wise_chat_messages` (
  `id` mediumint NOT NULL,
  `time` bigint NOT NULL DEFAULT '0',
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `user` tinytext NOT NULL,
  `user_id` bigint DEFAULT NULL,
  `chat_user_id` bigint DEFAULT NULL,
  `channel` text NOT NULL,
  `text` text NOT NULL,
  `ip` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_wise_chat_messages`
--

INSERT INTO `leshommesdebout_wp_wise_chat_messages` (`id`, `time`, `admin`, `user`, `user_id`, `chat_user_id`, `channel`, `text`, `ip`) VALUES
(1, 1483354386, 0, 'bruno.bernard', 1, 1, 'global', 'test', '82.235.57.215');

-- --------------------------------------------------------

--
-- Structure de la table `leshommesdebout_wp_wise_chat_users`
--

CREATE TABLE `leshommesdebout_wp_wise_chat_users` (
  `id` bigint NOT NULL,
  `wp_id` bigint DEFAULT NULL,
  `name` text NOT NULL,
  `session_id` text NOT NULL,
  `ip` text,
  `created` bigint NOT NULL DEFAULT '0',
  `data` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Déchargement des données de la table `leshommesdebout_wp_wise_chat_users`
--

INSERT INTO `leshommesdebout_wp_wise_chat_users` (`id`, `wp_id`, `name`, `session_id`, `ip`, `created`, `data`) VALUES
(1, 1, 'bruno.bernard', 'b0a54a9011e125d8eac152c62ceabf87', '82.235.57.215', 1483348061, '{\"country\":\"France\",\"countryCode\":\"FR\",\"region\":\"Alsace\",\"regionCode\":\"C1\",\"city\":\"Strasbourg\",\"continentCode\":\"EU\",\"latitude\":\"48.5839\",\"longitude\":\"7.7455\",\"currencyCode\":\"EUR\"}'),
(2, 1, 'bruno.bernard', 'eb58bfe306f0e4ae298d113450cd376a', '82.235.57.215', 1483370055, '[]'),
(3, 1, 'bruno.bernard', 'eb58bfe306f0e4ae298d113450cd376a', '82.235.57.215', 1483371249, '[]');

-- --------------------------------------------------------

--
-- Structure de la table `mdl_adminpresets`
--

CREATE TABLE `mdl_adminpresets` (
  `id` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `comments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `site` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `moodleversion` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `moodlerelease` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `iscore` tinyint(1) NOT NULL DEFAULT '0',
  `timecreated` bigint NOT NULL DEFAULT '0',
  `timeimported` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Table to store presets data' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_adminpresets`
--

INSERT INTO `mdl_adminpresets` (`id`, `userid`, `name`, `comments`, `site`, `author`, `moodleversion`, `moodlerelease`, `iscore`, `timecreated`, `timeimported`) VALUES
(1, 0, 'Débutant', 'Moodle avec ses fonctionnalités les plus appréciées, comprenant Devoir, Feedback, Forum, H5P, Test et suivi d’achèvement.', 'https://bia-facile.fr', '', '', '', 1, 1728145855, 0),
(2, 0, 'Complet', 'Toutes les fonctionnalités du préréglage Débutant, avec en plus Outil LTI, SCORM, Atelier, Analyse de données, Badges, Compétences, Plans d’apprentissage et bien d’autres choses encore.', 'https://bia-facile.fr', '', '', '', 2, 1728145856, 0);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_adminpresets_app`
--

CREATE TABLE `mdl_adminpresets_app` (
  `id` bigint NOT NULL,
  `adminpresetid` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `time` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Applied presets' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_adminpresets_app_it`
--

CREATE TABLE `mdl_adminpresets_app_it` (
  `id` bigint NOT NULL,
  `adminpresetapplyid` bigint NOT NULL,
  `configlogid` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Admin presets applied items. To maintain the relation with c' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_adminpresets_app_it_a`
--

CREATE TABLE `mdl_adminpresets_app_it_a` (
  `id` bigint NOT NULL,
  `adminpresetapplyid` bigint NOT NULL,
  `configlogid` bigint NOT NULL,
  `itemname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Attributes of the applied items' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_adminpresets_app_plug`
--

CREATE TABLE `mdl_adminpresets_app_plug` (
  `id` bigint NOT NULL,
  `adminpresetapplyid` bigint NOT NULL,
  `plugin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `value` smallint NOT NULL DEFAULT '0',
  `oldvalue` smallint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Admin presets plugins applied' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_adminpresets_it`
--

CREATE TABLE `mdl_adminpresets_it` (
  `id` bigint NOT NULL,
  `adminpresetid` bigint NOT NULL,
  `plugin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Table to store settings' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_adminpresets_it`
--

INSERT INTO `mdl_adminpresets_it` (`id`, `adminpresetid`, `plugin`, `name`, `value`) VALUES
(1, 1, 'none', 'usecomments', '0'),
(2, 1, 'none', 'usetags', '0'),
(3, 1, 'none', 'enablenotes', '0'),
(4, 1, 'none', 'enableblogs', '0'),
(5, 1, 'none', 'enablebadges', '0'),
(6, 1, 'none', 'enableanalytics', '0'),
(7, 1, 'core_competency', 'enabled', '0'),
(8, 1, 'core_competency', 'pushcourseratingstouserplans', '0'),
(9, 1, 'tool_dataprivacy', 'showdataretentionsummary', '0'),
(10, 1, 'none', 'forum_maxattachments', '3'),
(11, 1, 'none', 'guestloginbutton', '0'),
(12, 1, 'none', 'activitychoosertabmode', '4'),
(13, 2, 'none', 'usecomments', '1'),
(14, 2, 'none', 'usetags', '1'),
(15, 2, 'none', 'enablenotes', '1'),
(16, 2, 'none', 'enableblogs', '1'),
(17, 2, 'none', 'enablebadges', '1'),
(18, 2, 'none', 'enableanalytics', '1'),
(19, 2, 'core_competency', 'enabled', '1'),
(20, 2, 'core_competency', 'pushcourseratingstouserplans', '1'),
(21, 2, 'tool_dataprivacy', 'showdataretentionsummary', '1'),
(22, 2, 'none', 'forum_maxattachments', '9'),
(23, 2, 'none', 'guestloginbutton', '1'),
(24, 2, 'none', 'activitychoosertabmode', '3');

-- --------------------------------------------------------

--
-- Structure de la table `mdl_adminpresets_it_a`
--

CREATE TABLE `mdl_adminpresets_it_a` (
  `id` bigint NOT NULL,
  `itemid` bigint NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Admin presets items attributes. For settings with attributes' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_adminpresets_plug`
--

CREATE TABLE `mdl_adminpresets_plug` (
  `id` bigint NOT NULL,
  `adminpresetid` bigint NOT NULL,
  `plugin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `enabled` smallint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Admin presets plugins status, to store information about whe' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_adminpresets_plug`
--

INSERT INTO `mdl_adminpresets_plug` (`id`, `adminpresetid`, `plugin`, `name`, `enabled`) VALUES
(1, 1, 'mod', 'chat', 0),
(2, 1, 'mod', 'data', 0),
(3, 1, 'mod', 'lti', 0),
(4, 1, 'mod', 'imscp', 0),
(5, 1, 'mod', 'lesson', 0),
(6, 1, 'mod', 'scorm', 0),
(7, 1, 'mod', 'survey', 0),
(8, 1, 'mod', 'wiki', 0),
(9, 1, 'mod', 'workshop', 0),
(10, 1, 'availability', 'grouping', 0),
(11, 1, 'availability', 'profile', 0),
(12, 1, 'block', 'activity_modules', 0),
(13, 1, 'block', 'blog_menu', 0),
(14, 1, 'block', 'blog_tags', 0),
(15, 1, 'block', 'comments', 0),
(16, 1, 'block', 'completionstatus', 0),
(17, 1, 'block', 'course_summary', 0),
(18, 1, 'block', 'course_list', 0),
(19, 1, 'block', 'tag_flickr', 0),
(20, 1, 'block', 'globalsearch', 0),
(21, 1, 'block', 'badges', 0),
(22, 1, 'block', 'lp', 0),
(23, 1, 'block', 'myprofile', 0),
(24, 1, 'block', 'login', 0),
(25, 1, 'block', 'site_main_menu', 0),
(26, 1, 'block', 'mentees', 0),
(27, 1, 'block', 'mnet_hosts', 0),
(28, 1, 'block', 'private_files', 0),
(29, 1, 'block', 'blog_recent', 0),
(30, 1, 'block', 'rss_client', 0),
(31, 1, 'block', 'search_forums', 0),
(32, 1, 'block', 'section_links', 0),
(33, 1, 'block', 'selfcompletion', 0),
(34, 1, 'block', 'social_activities', 0),
(35, 1, 'block', 'tags', 0),
(36, 1, 'block', 'tag_youtube', 0),
(37, 1, 'block', 'feedback', 0),
(38, 1, 'block', 'online_users', 0),
(39, 1, 'block', 'recentlyaccessedcourses', 0),
(40, 1, 'block', 'starredcourses', 0),
(41, 1, 'format', 'social', 0),
(42, 1, 'dataformat', 'json', 0),
(43, 1, 'enrol', 'cohort', 0),
(44, 1, 'enrol', 'guest', 0),
(45, 1, 'filter', 'mathjaxloader', -9999),
(46, 1, 'filter', 'activitynames', -9999),
(47, 1, 'qbehaviour', 'adaptivenopenalty', 0),
(48, 1, 'qbehaviour', 'deferredcbm', 0),
(49, 1, 'qbehaviour', 'immediatecbm', 0),
(50, 1, 'qtype', 'calculated', 0),
(51, 1, 'qtype', 'calculatedmulti', 0),
(52, 1, 'qtype', 'calculatedsimple', 0),
(53, 1, 'qtype', 'ddmarker', 0),
(54, 1, 'qtype', 'ddimageortext', 0),
(55, 1, 'qtype', 'multianswer', 0),
(56, 1, 'qtype', 'numerical', 0),
(57, 1, 'qtype', 'randomsamatch', 0),
(58, 1, 'repository', 'local', 0),
(59, 1, 'repository', 'url', 0),
(60, 1, 'repository', 'wikimedia', 0),
(61, 2, 'mod', 'data', 1),
(62, 2, 'mod', 'lti', 1),
(63, 2, 'mod', 'imscp', 1),
(64, 2, 'mod', 'lesson', 1),
(65, 2, 'mod', 'scorm', 1),
(66, 2, 'mod', 'wiki', 1),
(67, 2, 'mod', 'workshop', 1),
(68, 2, 'availability', 'grouping', 1),
(69, 2, 'availability', 'profile', 1),
(70, 2, 'block', 'activity_modules', 1),
(71, 2, 'block', 'blog_menu', 1),
(72, 2, 'block', 'blog_tags', 1),
(73, 2, 'block', 'comments', 1),
(74, 2, 'block', 'completionstatus', 1),
(75, 2, 'block', 'course_list', 1),
(76, 2, 'block', 'tag_flickr', 1),
(77, 2, 'block', 'globalsearch', 1),
(78, 2, 'block', 'badges', 1),
(79, 2, 'block', 'lp', 1),
(80, 2, 'block', 'myprofile', 1),
(81, 2, 'block', 'login', 1),
(82, 2, 'block', 'site_main_menu', 1),
(83, 2, 'block', 'mentees', 1),
(84, 2, 'block', 'mnet_hosts', 1),
(85, 2, 'block', 'private_files', 1),
(86, 2, 'block', 'blog_recent', 1),
(87, 2, 'block', 'search_forums', 1),
(88, 2, 'block', 'section_links', 1),
(89, 2, 'block', 'social_activities', 1),
(90, 2, 'block', 'tags', 1),
(91, 2, 'block', 'online_users', 1),
(92, 2, 'block', 'recentlyaccessedcourses', 1),
(93, 2, 'block', 'starredcourses', 1),
(94, 2, 'format', 'social', 1),
(95, 2, 'dataformat', 'json', 1),
(96, 2, 'enrol', 'cohort', 1),
(97, 2, 'enrol', 'guest', 1),
(98, 2, 'filter', 'mathjaxloader', 1),
(99, 2, 'filter', 'activitynames', 1),
(100, 2, 'qbehaviour', 'adaptivenopenalty', 1),
(101, 2, 'qbehaviour', 'deferredcbm', 1),
(102, 2, 'qbehaviour', 'immediatecbm', 1),
(103, 2, 'qtype', 'calculated', 1),
(104, 2, 'qtype', 'calculatedmulti', 1),
(105, 2, 'qtype', 'calculatedsimple', 1),
(106, 2, 'qtype', 'ddmarker', 1),
(107, 2, 'qtype', 'ddimageortext', 1),
(108, 2, 'qtype', 'multianswer', 1),
(109, 2, 'qtype', 'numerical', 1),
(110, 2, 'qtype', 'randomsamatch', 1),
(111, 2, 'repository', 'local', 1),
(112, 2, 'repository', 'url', 1),
(113, 2, 'repository', 'wikimedia', 1);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_ai_action_generate_image`
--

CREATE TABLE `mdl_ai_action_generate_image` (
  `id` bigint NOT NULL,
  `prompt` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `numberimages` bigint NOT NULL,
  `quality` varchar(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `aspectratio` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `style` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `sourceurl` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `revisedprompt` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_ai_action_generate_text`
--

CREATE TABLE `mdl_ai_action_generate_text` (
  `id` bigint NOT NULL,
  `prompt` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `responseid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `fingerprint` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `generatedcontent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `finishreason` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `prompttokens` bigint DEFAULT NULL,
  `completiontoken` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_ai_action_register`
--

CREATE TABLE `mdl_ai_action_register` (
  `id` bigint NOT NULL,
  `actionname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `actionid` bigint NOT NULL,
  `success` tinyint(1) NOT NULL DEFAULT '0',
  `userid` bigint NOT NULL,
  `contextid` bigint NOT NULL,
  `provider` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `errorcode` smallint DEFAULT NULL,
  `errormessage` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `timecreated` bigint NOT NULL,
  `timecompleted` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_ai_action_summarise_text`
--

CREATE TABLE `mdl_ai_action_summarise_text` (
  `id` bigint NOT NULL,
  `prompt` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `responseid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `fingerprint` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `generatedcontent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `finishreason` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `prompttokens` bigint DEFAULT NULL,
  `completiontoken` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_ai_policy_register`
--

CREATE TABLE `mdl_ai_policy_register` (
  `id` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `contextid` bigint NOT NULL,
  `timeaccepted` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_analytics_indicator_calc`
--

CREATE TABLE `mdl_analytics_indicator_calc` (
  `id` bigint NOT NULL,
  `starttime` bigint NOT NULL,
  `endtime` bigint NOT NULL,
  `contextid` bigint NOT NULL,
  `sampleorigin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `sampleid` bigint NOT NULL,
  `indicator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `value` decimal(10,2) DEFAULT NULL,
  `timecreated` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stored indicator calculations' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_analytics_models`
--

CREATE TABLE `mdl_analytics_models` (
  `id` bigint NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `trained` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(1333) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `indicators` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `timesplitting` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `predictionsprocessor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `version` bigint NOT NULL,
  `contextids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `timecreated` bigint DEFAULT NULL,
  `timemodified` bigint NOT NULL,
  `usermodified` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Analytic models.' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_analytics_models`
--

INSERT INTO `mdl_analytics_models` (`id`, `enabled`, `trained`, `name`, `target`, `indicators`, `timesplitting`, `predictionsprocessor`, `version`, `contextids`, `timecreated`, `timemodified`, `usermodified`) VALUES
(1, 0, 0, NULL, '\\core_course\\analytics\\target\\course_dropout', '[\"\\\\core\\\\analytics\\\\indicator\\\\any_access_after_end\",\"\\\\core\\\\analytics\\\\indicator\\\\any_access_before_start\",\"\\\\core\\\\analytics\\\\indicator\\\\any_write_action_in_course\",\"\\\\core\\\\analytics\\\\indicator\\\\read_actions\",\"\\\\core_course\\\\analytics\\\\indicator\\\\completion_enabled\",\"\\\\core_course\\\\analytics\\\\indicator\\\\potential_cognitive_depth\",\"\\\\core_course\\\\analytics\\\\indicator\\\\potential_social_breadth\",\"\\\\mod_assign\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_assign\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_book\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_book\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_chat\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_chat\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_choice\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_choice\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_data\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_data\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_feedback\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_feedback\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_folder\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_folder\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_forum\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_forum\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_glossary\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_glossary\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_imscp\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_imscp\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_label\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_label\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_lesson\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_lesson\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_lti\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_lti\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_page\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_page\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_quiz\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_quiz\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_resource\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_resource\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_scorm\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_scorm\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_survey\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_survey\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_url\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_url\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_wiki\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_wiki\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_workshop\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_workshop\\\\analytics\\\\indicator\\\\social_breadth\"]', NULL, NULL, 1728145859, NULL, 1728145859, 1728145859, 0),
(2, 1, 1, NULL, '\\core_course\\analytics\\target\\no_teaching', '[\"\\\\core_course\\\\analytics\\\\indicator\\\\no_teacher\",\"\\\\core_course\\\\analytics\\\\indicator\\\\no_student\"]', '\\core\\analytics\\time_splitting\\single_range', NULL, 1728145859, NULL, 1728145859, 1728145859, 0),
(3, 1, 1, NULL, '\\core_user\\analytics\\target\\upcoming_activities_due', '[\"\\\\core_course\\\\analytics\\\\indicator\\\\activities_due\"]', '\\core\\analytics\\time_splitting\\upcoming_week', NULL, 1728145859, NULL, 1728145859, 1728145859, 0),
(4, 1, 1, NULL, '\\core_course\\analytics\\target\\no_access_since_course_start', '[\"\\\\core\\\\analytics\\\\indicator\\\\any_course_access\"]', '\\core\\analytics\\time_splitting\\one_month_after_start', NULL, 1728145859, NULL, 1728145859, 1728145859, 0),
(5, 1, 1, NULL, '\\core_course\\analytics\\target\\no_recent_accesses', '[\"\\\\core\\\\analytics\\\\indicator\\\\any_course_access\"]', '\\core\\analytics\\time_splitting\\past_month', NULL, 1728145859, NULL, 1728145859, 1728145859, 0);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_analytics_models_log`
--

CREATE TABLE `mdl_analytics_models_log` (
  `id` bigint NOT NULL,
  `modelid` bigint NOT NULL,
  `version` bigint NOT NULL,
  `evaluationmode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `indicators` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `timesplitting` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `score` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `dir` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `timecreated` bigint NOT NULL,
  `usermodified` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Analytic models changes during evaluation.' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_analytics_predictions`
--

CREATE TABLE `mdl_analytics_predictions` (
  `id` bigint NOT NULL,
  `modelid` bigint NOT NULL,
  `contextid` bigint NOT NULL,
  `sampleid` bigint NOT NULL,
  `rangeindex` mediumint NOT NULL,
  `prediction` decimal(10,2) NOT NULL,
  `predictionscore` decimal(10,5) NOT NULL,
  `calculations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `timecreated` bigint NOT NULL DEFAULT '0',
  `timestart` bigint DEFAULT NULL,
  `timeend` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Predictions' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_analytics_prediction_actions`
--

CREATE TABLE `mdl_analytics_prediction_actions` (
  `id` bigint NOT NULL,
  `predictionid` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `actionname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `timecreated` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Register of user actions over predictions.' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_analytics_predict_samples`
--

CREATE TABLE `mdl_analytics_predict_samples` (
  `id` bigint NOT NULL,
  `modelid` bigint NOT NULL,
  `analysableid` bigint NOT NULL,
  `timesplitting` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `rangeindex` bigint NOT NULL,
  `sampleids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `timecreated` bigint NOT NULL DEFAULT '0',
  `timemodified` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Samples already used for predictions.' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_analytics_train_samples`
--

CREATE TABLE `mdl_analytics_train_samples` (
  `id` bigint NOT NULL,
  `modelid` bigint NOT NULL,
  `analysableid` bigint NOT NULL,
  `timesplitting` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `sampleids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `timecreated` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Samples used for training' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_analytics_used_analysables`
--

CREATE TABLE `mdl_analytics_used_analysables` (
  `id` bigint NOT NULL,
  `modelid` bigint NOT NULL,
  `action` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `analysableid` bigint NOT NULL,
  `firstanalysis` bigint NOT NULL,
  `timeanalysed` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='List of analysables used by each model' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_analytics_used_analysables`
--

INSERT INTO `mdl_analytics_used_analysables` (`id`, `modelid`, `action`, `analysableid`, `firstanalysis`, `timeanalysed`) VALUES
(1, 2, 'prediction', 1, 1730573148, 1730573148);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_analytics_used_files`
--

CREATE TABLE `mdl_analytics_used_files` (
  `id` bigint NOT NULL,
  `modelid` bigint NOT NULL DEFAULT '0',
  `fileid` bigint NOT NULL DEFAULT '0',
  `action` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `time` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Files that have already been used for training and predictio' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assign`
--

CREATE TABLE `mdl_assign` (
  `id` bigint NOT NULL,
  `course` bigint NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `intro` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `introformat` smallint NOT NULL DEFAULT '0',
  `alwaysshowdescription` tinyint NOT NULL DEFAULT '0',
  `nosubmissions` tinyint NOT NULL DEFAULT '0',
  `submissiondrafts` tinyint NOT NULL DEFAULT '0',
  `sendnotifications` tinyint NOT NULL DEFAULT '0',
  `sendlatenotifications` tinyint NOT NULL DEFAULT '0',
  `duedate` bigint NOT NULL DEFAULT '0',
  `allowsubmissionsfromdate` bigint NOT NULL DEFAULT '0',
  `grade` bigint NOT NULL DEFAULT '0',
  `timemodified` bigint NOT NULL DEFAULT '0',
  `requiresubmissionstatement` tinyint NOT NULL DEFAULT '0',
  `completionsubmit` tinyint NOT NULL DEFAULT '0',
  `cutoffdate` bigint NOT NULL DEFAULT '0',
  `gradingduedate` bigint NOT NULL DEFAULT '0',
  `teamsubmission` tinyint NOT NULL DEFAULT '0',
  `requireallteammemberssubmit` tinyint NOT NULL DEFAULT '0',
  `teamsubmissiongroupingid` bigint NOT NULL DEFAULT '0',
  `blindmarking` tinyint NOT NULL DEFAULT '0',
  `hidegrader` tinyint NOT NULL DEFAULT '0',
  `revealidentities` tinyint NOT NULL DEFAULT '0',
  `attemptreopenmethod` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'untilpass',
  `maxattempts` mediumint NOT NULL DEFAULT '1',
  `markingworkflow` tinyint NOT NULL DEFAULT '0',
  `markingallocation` tinyint NOT NULL DEFAULT '0',
  `markinganonymous` tinyint NOT NULL DEFAULT '0',
  `sendstudentnotifications` tinyint NOT NULL DEFAULT '1',
  `preventsubmissionnotingroup` tinyint NOT NULL DEFAULT '0',
  `activity` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `activityformat` smallint NOT NULL DEFAULT '0',
  `timelimit` bigint NOT NULL DEFAULT '0',
  `submissionattachments` tinyint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table saves information about an instance of mod_assign' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assignfeedback_comments`
--

CREATE TABLE `mdl_assignfeedback_comments` (
  `id` bigint NOT NULL,
  `assignment` bigint NOT NULL DEFAULT '0',
  `grade` bigint NOT NULL DEFAULT '0',
  `commenttext` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `commentformat` smallint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Text feedback for submitted assignments' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assignfeedback_editpdf_annot`
--

CREATE TABLE `mdl_assignfeedback_editpdf_annot` (
  `id` bigint NOT NULL,
  `gradeid` bigint NOT NULL DEFAULT '0',
  `pageno` bigint NOT NULL DEFAULT '0',
  `x` bigint DEFAULT '0',
  `y` bigint DEFAULT '0',
  `endx` bigint DEFAULT '0',
  `endy` bigint DEFAULT '0',
  `path` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'line',
  `colour` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'black',
  `draft` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='stores annotations added to pdfs submitted by students' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assignfeedback_editpdf_cmnt`
--

CREATE TABLE `mdl_assignfeedback_editpdf_cmnt` (
  `id` bigint NOT NULL,
  `gradeid` bigint NOT NULL DEFAULT '0',
  `x` bigint DEFAULT '0',
  `y` bigint DEFAULT '0',
  `width` bigint DEFAULT '120',
  `rawtext` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `pageno` bigint NOT NULL DEFAULT '0',
  `colour` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'black',
  `draft` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores comments added to pdfs' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assignfeedback_editpdf_quick`
--

CREATE TABLE `mdl_assignfeedback_editpdf_quick` (
  `id` bigint NOT NULL,
  `userid` bigint NOT NULL DEFAULT '0',
  `rawtext` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `width` bigint NOT NULL DEFAULT '120',
  `colour` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'yellow'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores teacher specified quicklist comments' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assignfeedback_editpdf_rot`
--

CREATE TABLE `mdl_assignfeedback_editpdf_rot` (
  `id` bigint NOT NULL,
  `gradeid` bigint NOT NULL DEFAULT '0',
  `pageno` bigint NOT NULL DEFAULT '0',
  `pathnamehash` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `isrotated` tinyint(1) NOT NULL DEFAULT '0',
  `degree` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores rotation information of a page.' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assignfeedback_file`
--

CREATE TABLE `mdl_assignfeedback_file` (
  `id` bigint NOT NULL,
  `assignment` bigint NOT NULL DEFAULT '0',
  `grade` bigint NOT NULL DEFAULT '0',
  `numfiles` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores info about the number of files submitted by a student' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assignsubmission_file`
--

CREATE TABLE `mdl_assignsubmission_file` (
  `id` bigint NOT NULL,
  `assignment` bigint NOT NULL DEFAULT '0',
  `submission` bigint NOT NULL DEFAULT '0',
  `numfiles` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Info about file submissions for assignments' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assignsubmission_onlinetext`
--

CREATE TABLE `mdl_assignsubmission_onlinetext` (
  `id` bigint NOT NULL,
  `assignment` bigint NOT NULL DEFAULT '0',
  `submission` bigint NOT NULL DEFAULT '0',
  `onlinetext` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `onlineformat` smallint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Info about onlinetext submission' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assign_grades`
--

CREATE TABLE `mdl_assign_grades` (
  `id` bigint NOT NULL,
  `assignment` bigint NOT NULL DEFAULT '0',
  `userid` bigint NOT NULL DEFAULT '0',
  `timecreated` bigint NOT NULL DEFAULT '0',
  `timemodified` bigint NOT NULL DEFAULT '0',
  `grader` bigint NOT NULL DEFAULT '0',
  `grade` decimal(10,5) DEFAULT '0.00000',
  `attemptnumber` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Grading information about a single assignment submission.' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assign_overrides`
--

CREATE TABLE `mdl_assign_overrides` (
  `id` bigint NOT NULL,
  `assignid` bigint NOT NULL DEFAULT '0',
  `groupid` bigint DEFAULT NULL,
  `userid` bigint DEFAULT NULL,
  `sortorder` bigint DEFAULT NULL,
  `allowsubmissionsfromdate` bigint DEFAULT NULL,
  `duedate` bigint DEFAULT NULL,
  `cutoffdate` bigint DEFAULT NULL,
  `timelimit` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The overrides to assign settings.' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assign_plugin_config`
--

CREATE TABLE `mdl_assign_plugin_config` (
  `id` bigint NOT NULL,
  `assignment` bigint NOT NULL DEFAULT '0',
  `plugin` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `subtype` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `name` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Config data for an instance of a plugin in an assignment.' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assign_submission`
--

CREATE TABLE `mdl_assign_submission` (
  `id` bigint NOT NULL,
  `assignment` bigint NOT NULL DEFAULT '0',
  `userid` bigint NOT NULL DEFAULT '0',
  `timecreated` bigint NOT NULL DEFAULT '0',
  `timemodified` bigint NOT NULL DEFAULT '0',
  `timestarted` bigint DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `groupid` bigint NOT NULL DEFAULT '0',
  `attemptnumber` bigint NOT NULL DEFAULT '0',
  `latest` tinyint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table keeps information about student interactions with' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assign_user_flags`
--

CREATE TABLE `mdl_assign_user_flags` (
  `id` bigint NOT NULL,
  `userid` bigint NOT NULL DEFAULT '0',
  `assignment` bigint NOT NULL DEFAULT '0',
  `locked` bigint NOT NULL DEFAULT '0',
  `mailed` smallint NOT NULL DEFAULT '0',
  `extensionduedate` bigint NOT NULL DEFAULT '0',
  `workflowstate` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `allocatedmarker` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='List of flags that can be set for a single user in a single ' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_assign_user_mapping`
--

CREATE TABLE `mdl_assign_user_mapping` (
  `id` bigint NOT NULL,
  `assignment` bigint NOT NULL DEFAULT '0',
  `userid` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Map an assignment specific id number to a user' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_auth_lti_linked_login`
--

CREATE TABLE `mdl_auth_lti_linked_login` (
  `id` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `issuer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `issuer256` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `sub` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `sub256` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `timecreated` bigint NOT NULL,
  `timemodified` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Accounts linked to a users Moodle account.' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_auth_oauth2_linked_login`
--

CREATE TABLE `mdl_auth_oauth2_linked_login` (
  `id` bigint NOT NULL,
  `timecreated` bigint NOT NULL,
  `timemodified` bigint NOT NULL,
  `usermodified` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `issuerid` bigint NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `email` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `confirmtoken` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `confirmtokenexpires` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Accounts linked to a users Moodle account.' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_backup_controllers`
--

CREATE TABLE `mdl_backup_controllers` (
  `id` bigint NOT NULL,
  `backupid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `operation` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'backup',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `itemid` bigint NOT NULL,
  `format` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `interactive` smallint NOT NULL,
  `purpose` smallint NOT NULL,
  `userid` bigint NOT NULL,
  `status` smallint NOT NULL,
  `execution` smallint NOT NULL,
  `executiontime` bigint NOT NULL,
  `checksum` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `timecreated` bigint NOT NULL,
  `timemodified` bigint NOT NULL,
  `progress` decimal(15,14) NOT NULL DEFAULT '0.00000000000000',
  `controller` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='To store the backup_controllers as they are used' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_backup_controllers`
--

INSERT INTO `mdl_backup_controllers` (`id`, `backupid`, `operation`, `type`, `itemid`, `format`, `interactive`, `purpose`, `userid`, `status`, `execution`, `executiontime`, `checksum`, `timecreated`, `timemodified`, `progress`, `controller`) VALUES
(1, '5ade0d9869dce7fdf9fe95da45b35fc6', 'backup', 'activity', 7, 'moodle2', 0, 50, 2, 1000, 1, 0, '46443cc989c864bc026a275b5508d9e5', 1730657964, 1730657965, 0.00000000000000, ''),
(2, '5885bd0122ad90355cf5105694d3bac4', 'backup', 'activity', 51, 'moodle2', 0, 20, 2, 1000, 1, 0, 'af59224ff5cedcd3de8123decc18863a', 1734476813, 1734476815, 0.00000000000000, ''),
(3, 'cb68312a7bc18264bba5c190e85ad984', 'restore', 'activity', 7, 'moodle2', 0, 20, 2, 1000, 1, 0, 'd62051daa830471d6e4ee7f1f869eeae', 1734476815, 1734476816, 0.00000000000000, ''),
(4, 'baa7b86b5e3df1fc0104f24f288e7654', 'backup', 'activity', 90, 'moodle2', 1, 70, 2, 500, 2, 0, '116cc815bd11ac5800da1e7144f292ad', 1735582128, 0, 0.00000000000000, '[encoded data, 27484 characters]'),
(5, '61fd033921c4456a54d9555a4ea58d2b', 'backup', 'activity', 105, 'moodle2', 0, 20, 2, 1000, 1, 0, '9380847fefaf43f38266543258111b26', 1736007693, 1736007694, 0.00000000000000, ''),
(6, '752425f3cfdbd7ab202f4750d86456fb', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, 'ddae98f0d0d77f9d7f08241e7bcaa11b', 1736007694, 1736007695, 0.00000000000000, ''),
(7, 'aadc4148f9c5801599f56530936ae93f', 'backup', 'activity', 108, 'moodle2', 0, 20, 2, 1000, 1, 0, 'fab8042f01f0dae40becb462c8196a89', 1736012508, 1736012509, 0.00000000000000, ''),
(8, 'e414b54569dc2ff71f8f79332b5e0067', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, 'b626877e0e892e198aded0122873d8aa', 1736012509, 1736012509, 0.00000000000000, ''),
(9, 'e58b582814784ee0fdc89621f9ba970c', 'backup', 'activity', 111, 'moodle2', 0, 20, 2, 1000, 1, 0, '55f74b9c780fe78b5b9677e6f18daaa7', 1736318057, 1736318057, 0.00000000000000, ''),
(10, 'b7ece3f59c49d0b98a45205ca79a5a80', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, '2da461493d3f6de295b7265ce820b18f', 1736318057, 1736318059, 0.00000000000000, ''),
(11, '4d4be9f0b16aaeac91fee6777d767962', 'backup', 'activity', 111, 'moodle2', 0, 20, 2, 1000, 1, 0, '3622703646fe5a0281eb6cf7855ed17e', 1736318379, 1736318379, 0.00000000000000, ''),
(12, '8113b8ed8f9bea211241f5df94f362a2', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, 'c4cac0c2bb27922d46a8a887039e4944', 1736318379, 1736318379, 0.00000000000000, ''),
(13, '082cd13a7583c45f9e0b8f636a0c4287', 'backup', 'activity', 111, 'moodle2', 0, 20, 2, 1000, 1, 0, '6430774da5e1ecd12f1e78fc71889789', 1736318385, 1736318385, 0.00000000000000, ''),
(14, '0ed548c4fb998cfb42d81f343fca1ace', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, '18144daa7df08ad7a9dc1b594d9a8cfe', 1736318385, 1736318386, 0.00000000000000, ''),
(15, '8116752caa38a98d69144daa6877d803', 'backup', 'activity', 113, 'moodle2', 0, 20, 2, 1000, 1, 0, '9f8103cd5cb4ecb923af5cb72fe3a27a', 1736318908, 1736318908, 0.00000000000000, ''),
(16, 'aa39ee25b3274b5fda7694862325e683', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, '1d339fc3b26d9e00dbe5bf20ad37b639', 1736318908, 1736318909, 0.00000000000000, ''),
(17, 'ed7fcb3360a955ec2673fe252ed2f80c', 'backup', 'activity', 113, 'moodle2', 0, 20, 2, 1000, 1, 0, '26650a9093ae9bbe6b505be98855febc', 1736318913, 1736318913, 0.00000000000000, ''),
(18, '6e1f56eec49fc592c5a0dc653c6a36ab', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, '34b3aa4889320c88b78b22a38e02cedc', 1736318913, 1736318913, 0.00000000000000, ''),
(19, 'd02a348245c5df7e396de951e471a44c', 'backup', 'activity', 113, 'moodle2', 0, 20, 2, 1000, 1, 0, '8ceace26fabdf7dc5ead61ea87052def', 1736318916, 1736318916, 0.00000000000000, ''),
(20, 'd7ada60d78aa84d856622b90ec19e67f', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, 'fa9217ce0704b0a2b24bc3450f1b121e', 1736318916, 1736318917, 0.00000000000000, ''),
(21, '546cd14c1b4bfc432d5b0c5206330717', 'backup', 'activity', 118, 'moodle2', 0, 20, 2, 1000, 1, 0, '7832d7091c8e3f62edd3b608fb580957', 1736319566, 1736319567, 0.00000000000000, ''),
(22, '47c30735fcba5860f78515fbbe6a58d3', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, 'b36b9027b49575da5c4ea11b3371aeb5', 1736319567, 1736319567, 0.00000000000000, ''),
(23, '35d1bba1602f9361d6ee81124455e699', 'backup', 'activity', 118, 'moodle2', 0, 20, 2, 1000, 1, 0, '68443f30c348f02733954853b2c87c29', 1736319572, 1736319572, 0.00000000000000, ''),
(24, '403bb50252a7af1b602f99101903bdd7', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, 'a7101b3885109bddd8631513b063a5c1', 1736319572, 1736319573, 0.00000000000000, '');
INSERT INTO `mdl_backup_controllers` (`id`, `backupid`, `operation`, `type`, `itemid`, `format`, `interactive`, `purpose`, `userid`, `status`, `execution`, `executiontime`, `checksum`, `timecreated`, `timemodified`, `progress`, `controller`) VALUES
(25, '92cbd762e8c0b8154cd92fa26adfc968', 'backup', 'activity', 145, 'moodle2', 1, 70, 2, 500, 2, 0, '797787b21abc535166237f4bf732db3e', 1736403029, 0, 0.00000000000000, '[encoded data, 27456 characters]'),
(26, '02bb26263cc07f250144274e46a18cb2', 'backup', 'activity', 147, 'moodle2', 0, 20, 2, 1000, 1, 0, '22d44cc967c7a9a5e8900c059cec4d1d', 1736434456, 1736434457, 0.00000000000000, ''),
(27, '3e2740403bd028259577ea7b2c4c6494', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, '2637f19bebff25b8ed10e45114c2c660', 1736434457, 1736434457, 0.00000000000000, ''),
(28, '07d839ee652dda50c46ad68816ccad02', 'backup', 'activity', 147, 'moodle2', 0, 20, 2, 1000, 1, 0, 'aa5a9acf7d427c34d38c1edcb2a1e613', 1736434462, 1736434462, 0.00000000000000, ''),
(29, '09c4351dec3aa3ac799549c7a1b0a23c', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, 'af0cee0bbde55fb11075d7b3885d55ed', 1736434462, 1736434462, 0.00000000000000, ''),
(30, 'ccfc530102ac346d85ca51326fa0e48d', 'backup', 'activity', 147, 'moodle2', 0, 20, 2, 1000, 1, 0, '2d435289d77dcb42e4bb4886f307ea5a', 1736434466, 1736434466, 0.00000000000000, ''),
(31, '1b6943c4bc5ae0384d1c51f1934cfcab', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, '3e9ca762a4ded981fbf878dbbe9e494a', 1736434466, 1736434466, 0.00000000000000, ''),
(32, '1c37e0b45ad77728b08cefc55df249c5', 'backup', 'activity', 147, 'moodle2', 0, 20, 2, 1000, 1, 0, 'ef261d4fce40465007707807b67e5b42', 1736434469, 1736434470, 0.00000000000000, ''),
(33, '5136454a203c83ecbc7bc3051a8231c2', 'restore', 'activity', 4, 'moodle2', 0, 20, 2, 1000, 1, 0, '1d5d0c7adbe92c5d654ce8b11577cee0', 1736434470, 1736434470, 0.00000000000000, '');

-- --------------------------------------------------------

--
-- Structure de la table `mdl_backup_courses`
--

CREATE TABLE `mdl_backup_courses` (
  `id` bigint NOT NULL,
  `courseid` bigint NOT NULL DEFAULT '0',
  `laststarttime` bigint NOT NULL DEFAULT '0',
  `lastendtime` bigint NOT NULL DEFAULT '0',
  `laststatus` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '5',
  `nextstarttime` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='To store every course backup status' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_backup_logs`
--

CREATE TABLE `mdl_backup_logs` (
  `id` bigint NOT NULL,
  `backupid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `loglevel` smallint NOT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `timecreated` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='To store all the logs from backup and restore operations (by' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge`
--

CREATE TABLE `mdl_badge` (
  `id` bigint NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `timecreated` bigint NOT NULL DEFAULT '0',
  `timemodified` bigint NOT NULL DEFAULT '0',
  `usercreated` bigint NOT NULL,
  `usermodified` bigint NOT NULL,
  `issuername` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `issuerurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `issuercontact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `expiredate` bigint DEFAULT NULL,
  `expireperiod` bigint DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `courseid` bigint DEFAULT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `messagesubject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `attachment` tinyint(1) NOT NULL DEFAULT '1',
  `notification` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `nextcron` bigint DEFAULT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `imageauthorname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `imageauthoremail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `imageauthorurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `imagecaption` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines badge' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_badge`
--

INSERT INTO `mdl_badge` (`id`, `name`, `description`, `timecreated`, `timemodified`, `usercreated`, `usermodified`, `issuername`, `issuerurl`, `issuercontact`, `expiredate`, `expireperiod`, `type`, `courseid`, `message`, `messagesubject`, `attachment`, `notification`, `status`, `nextcron`, `version`, `language`, `imageauthorname`, `imageauthoremail`, `imageauthorurl`, `imagecaption`) VALUES
(1, 'Test Badge', 'Description du badge ', 1734374678, 1734374753, 2, 2, 'Brevet d\'Initiation Aéronautique (BIA)', 'https://bia-facile.fr', '', NULL, NULL, 2, 7, '<p>On vous a délivré le badge « %badgename% »!</p>\n<p>Plus d’information sur ce badge est disponible ici : %badgelink%.</p>\n<p>Vous pouvez gérer et télécharger le badge sur votre page <a href=\"https://bia-facile.fr/badges/mybadges.php\">Gérer les badges</a>.</p>', 'Félicitations ! Vous venez de recevoir un badge !', 1, 0, 1, NULL, '', 'fr', '', '', '', ''),
(2, 'Mon premier badge', 'Description du premier badge', 1734381653, 1734381653, 2, 2, 'Brevet d\'Initiation Aéronautique (BIA)', 'https://bia-facile.fr', '', NULL, NULL, 2, 7, '<p>On vous a délivré le badge « %badgename% »!</p>\n<p>Plus d’information sur ce badge est disponible ici : %badgelink%.</p>\n<p>Vous pouvez gérer et télécharger le badge sur votre page <a href=\"https://bia-facile.fr/badges/mybadges.php\">Gérer les badges</a>.</p>', 'Félicitations ! Vous venez de recevoir un badge !', 1, 0, 0, NULL, '', 'fr', '', '', '', ''),
(3, 'Test Badge', 'Description du badge ', 1734374678, 1734374753, 2, 2, 'Brevet d\'Initiation Aéronautique (BIA)', 'https://bia-facile.fr', '', NULL, NULL, 2, 7, '<p>On vous a délivré le badge « %badgename% »!</p>\n<p>Plus d’information sur ce badge est disponible ici : %badgelink%.</p>\n<p>Vous pouvez gérer et télécharger le badge sur votre page <a href=\"https://bia-facile.fr/badges/mybadges.php\">Gérer les badges</a>.</p>', 'Félicitations ! Vous venez de recevoir un badge !', 1, 0, 0, NULL, '', 'fr', '', '', '', ''),
(4, 'Mon premier badge', 'Description du premier badge', 1734381653, 1734381653, 2, 2, 'Brevet d\'Initiation Aéronautique (BIA)', 'https://bia-facile.fr', '', NULL, NULL, 2, 7, '<p>On vous a délivré le badge « %badgename% »!</p>\n<p>Plus d’information sur ce badge est disponible ici : %badgelink%.</p>\n<p>Vous pouvez gérer et télécharger le badge sur votre page <a href=\"https://bia-facile.fr/badges/mybadges.php\">Gérer les badges</a>.</p>', 'Félicitations ! Vous venez de recevoir un badge !', 1, 0, 0, NULL, '', 'fr', '', '', '', ''),
(5, 'Aviateur', 'Félicitations vous avez obtenu la badge Aviateur.', 1735905630, 1735905837, 2, 2, 'Brevet d\'Initiation Aéronautique (BIA)', 'https://bia-facile.fr', '', NULL, NULL, 1, NULL, '<p>On vous a délivré le badge « %badgename% »!</p>\r\n<p>Plus d’information sur ce badge est disponible ici : %badgelink%.</p>\r\n<p>Vous pouvez gérer et télécharger le badge sur votre page <a href=\"https://bia-facile.fr/badges/mybadges.php\">Gérer les badges</a>.</p>', 'Félicitations ! Vous venez de recevoir un badge !', 1, 1, 1, NULL, '', 'fr', '', '', '', '');

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_alignment`
--

CREATE TABLE `mdl_badge_alignment` (
  `id` bigint NOT NULL,
  `badgeid` bigint NOT NULL DEFAULT '0',
  `targetname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `targeturl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `targetdescription` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `targetframework` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `targetcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines alignment for badges' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_backpack`
--

CREATE TABLE `mdl_badge_backpack` (
  `id` bigint NOT NULL,
  `userid` bigint NOT NULL DEFAULT '0',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `backpackuid` bigint NOT NULL,
  `autosync` tinyint(1) NOT NULL DEFAULT '0',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `externalbackpackid` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines settings for connecting external backpack' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_backpack_oauth2`
--

CREATE TABLE `mdl_badge_backpack_oauth2` (
  `id` bigint NOT NULL,
  `usermodified` bigint NOT NULL DEFAULT '0',
  `timecreated` bigint NOT NULL DEFAULT '0',
  `timemodified` bigint NOT NULL DEFAULT '0',
  `userid` bigint NOT NULL,
  `issuerid` bigint NOT NULL,
  `externalbackpackid` bigint NOT NULL,
  `token` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `refreshtoken` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `expires` bigint DEFAULT NULL,
  `scope` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Default comment for the table, please edit me' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_criteria`
--

CREATE TABLE `mdl_badge_criteria` (
  `id` bigint NOT NULL,
  `badgeid` bigint NOT NULL DEFAULT '0',
  `criteriatype` bigint DEFAULT NULL,
  `method` tinyint(1) NOT NULL DEFAULT '1',
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `descriptionformat` tinyint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines criteria for issuing badges' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_badge_criteria`
--

INSERT INTO `mdl_badge_criteria` (`id`, `badgeid`, `criteriatype`, `method`, `description`, `descriptionformat`) VALUES
(1, 1, 0, 1, '', 1),
(2, 1, 4, 1, '<p>Description de l\'achèvement </p>', 1),
(3, 3, 0, 1, '', 1),
(4, 3, 4, 1, '<p>Description de l\'achèvement </p>', 1),
(5, 5, 0, 1, '', 1),
(6, 5, 5, 1, '', 0);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_criteria_met`
--

CREATE TABLE `mdl_badge_criteria_met` (
  `id` bigint NOT NULL,
  `issuedid` bigint DEFAULT NULL,
  `critid` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `datemet` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines criteria that were met for an issued badge' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_criteria_param`
--

CREATE TABLE `mdl_badge_criteria_param` (
  `id` bigint NOT NULL,
  `critid` bigint NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines parameters for badges criteria' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_badge_criteria_param`
--

INSERT INTO `mdl_badge_criteria_param` (`id`, `critid`, `name`, `value`) VALUES
(1, 2, 'grade_7', '3'),
(2, 2, 'bydate_7', '1765839600'),
(3, 2, 'course_7', '7'),
(4, 4, 'grade_7', '3'),
(5, 4, 'bydate_7', '1765839600'),
(6, 4, 'course_7', '7'),
(7, 6, 'course_9', '9');

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_endorsement`
--

CREATE TABLE `mdl_badge_endorsement` (
  `id` bigint NOT NULL,
  `badgeid` bigint NOT NULL DEFAULT '0',
  `issuername` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `issuerurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `issueremail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `claimid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `claimcomment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `dateissued` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines endorsement for badge' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_external`
--

CREATE TABLE `mdl_badge_external` (
  `id` bigint NOT NULL,
  `backpackid` bigint NOT NULL,
  `collectionid` bigint NOT NULL,
  `entityid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `assertion` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Setting for external badges display' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_external_backpack`
--

CREATE TABLE `mdl_badge_external_backpack` (
  `id` bigint NOT NULL,
  `backpackapiurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `backpackweburl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `apiversion` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1.0',
  `sortorder` bigint NOT NULL DEFAULT '0',
  `oauth2_issuerid` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines settings for site level backpacks that a user can co' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_badge_external_backpack`
--

INSERT INTO `mdl_badge_external_backpack` (`id`, `backpackapiurl`, `backpackweburl`, `apiversion`, `sortorder`, `oauth2_issuerid`) VALUES
(1, 'https://api.badgr.io/v2', 'https://badgr.io', '2', 1, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_external_identifier`
--

CREATE TABLE `mdl_badge_external_identifier` (
  `id` bigint NOT NULL,
  `sitebackpackid` bigint NOT NULL,
  `internalid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `externalid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Setting for external badges mappings' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_issued`
--

CREATE TABLE `mdl_badge_issued` (
  `id` bigint NOT NULL,
  `badgeid` bigint NOT NULL DEFAULT '0',
  `userid` bigint NOT NULL DEFAULT '0',
  `uniquehash` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `dateissued` bigint NOT NULL DEFAULT '0',
  `dateexpire` bigint DEFAULT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT '0',
  `issuernotified` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines issued badges' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_manual_award`
--

CREATE TABLE `mdl_badge_manual_award` (
  `id` bigint NOT NULL,
  `badgeid` bigint NOT NULL,
  `recipientid` bigint NOT NULL,
  `issuerid` bigint NOT NULL,
  `issuerrole` bigint NOT NULL,
  `datemet` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Track manual award criteria for badges' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_badge_related`
--

CREATE TABLE `mdl_badge_related` (
  `id` bigint NOT NULL,
  `badgeid` bigint NOT NULL DEFAULT '0',
  `relatedbadgeid` bigint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Defines badge related for badges' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_bigbluebuttonbn`
--

CREATE TABLE `mdl_bigbluebuttonbn` (
  `id` bigint NOT NULL,
  `type` tinyint NOT NULL DEFAULT '0',
  `course` bigint NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `intro` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `introformat` smallint NOT NULL DEFAULT '1',
  `meetingid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `moderatorpass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `viewerpass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `wait` tinyint(1) NOT NULL DEFAULT '0',
  `record` tinyint(1) NOT NULL DEFAULT '0',
  `recordallfromstart` tinyint(1) NOT NULL DEFAULT '0',
  `recordhidebutton` tinyint(1) NOT NULL DEFAULT '0',
  `welcome` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `voicebridge` mediumint NOT NULL DEFAULT '0',
  `openingtime` bigint NOT NULL DEFAULT '0',
  `closingtime` bigint NOT NULL DEFAULT '0',
  `timecreated` bigint NOT NULL DEFAULT '0',
  `timemodified` bigint NOT NULL DEFAULT '0',
  `presentation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `participants` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `userlimit` smallint NOT NULL DEFAULT '0',
  `recordings_html` tinyint(1) NOT NULL DEFAULT '0',
  `recordings_deleted` tinyint(1) NOT NULL DEFAULT '1',
  `recordings_imported` tinyint(1) NOT NULL DEFAULT '0',
  `recordings_preview` tinyint(1) NOT NULL DEFAULT '0',
  `clienttype` tinyint(1) NOT NULL DEFAULT '0',
  `muteonstart` tinyint(1) NOT NULL DEFAULT '0',
  `disablecam` tinyint(1) NOT NULL DEFAULT '0',
  `disablemic` tinyint(1) NOT NULL DEFAULT '0',
  `disableprivatechat` tinyint(1) NOT NULL DEFAULT '0',
  `disablepublicchat` tinyint(1) NOT NULL DEFAULT '0',
  `disablenote` tinyint(1) NOT NULL DEFAULT '0',
  `hideuserlist` tinyint(1) NOT NULL DEFAULT '0',
  `completionattendance` int NOT NULL DEFAULT '0',
  `completionengagementchats` int NOT NULL DEFAULT '0',
  `completionengagementtalks` int NOT NULL DEFAULT '0',
  `completionengagementraisehand` int NOT NULL DEFAULT '0',
  `completionengagementpollvotes` int NOT NULL DEFAULT '0',
  `completionengagementemojis` int NOT NULL DEFAULT '0',
  `guestallowed` tinyint DEFAULT '0',
  `mustapproveuser` tinyint DEFAULT '1',
  `guestlinkuid` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `guestpassword` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `showpresentation` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The bigbluebuttonbn table to store information about a meeti' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_bigbluebuttonbn_logs`
--

CREATE TABLE `mdl_bigbluebuttonbn_logs` (
  `id` bigint NOT NULL,
  `courseid` bigint NOT NULL,
  `bigbluebuttonbnid` bigint NOT NULL,
  `userid` bigint DEFAULT NULL,
  `timecreated` bigint NOT NULL DEFAULT '0',
  `meetingid` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `log` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The bigbluebuttonbn table to store meeting activity events' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_bigbluebuttonbn_recordings`
--

CREATE TABLE `mdl_bigbluebuttonbn_recordings` (
  `id` bigint NOT NULL,
  `courseid` bigint NOT NULL,
  `bigbluebuttonbnid` bigint NOT NULL,
  `groupid` bigint DEFAULT NULL,
  `recordingid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `headless` tinyint(1) NOT NULL DEFAULT '0',
  `imported` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `importeddata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `timecreated` bigint NOT NULL DEFAULT '0',
  `usermodified` bigint NOT NULL DEFAULT '0',
  `timemodified` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The bigbluebuttonbn table to store references to recordings' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_block`
--

CREATE TABLE `mdl_block` (
  `id` bigint NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `cron` bigint NOT NULL DEFAULT '0',
  `lastcron` bigint NOT NULL DEFAULT '0',
  `visible` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='contains all installed blocks' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_block`
--

INSERT INTO `mdl_block` (`id`, `name`, `cron`, `lastcron`, `visible`) VALUES
(1, 'accessreview', 0, 0, 1),
(2, 'activity_modules', 0, 0, 1),
(3, 'activity_results', 0, 0, 1),
(4, 'admin_bookmarks', 0, 0, 1),
(5, 'badges', 0, 0, 1),
(6, 'blog_menu', 0, 0, 1),
(7, 'blog_recent', 0, 0, 1),
(8, 'blog_tags', 0, 0, 1),
(9, 'calendar_month', 0, 0, 1),
(10, 'calendar_upcoming', 0, 0, 1),
(11, 'comments', 0, 0, 1),
(12, 'completionstatus', 0, 0, 1),
(13, 'course_list', 0, 0, 1),
(14, 'course_summary', 0, 0, 0),
(15, 'feedback', 0, 0, 0),
(16, 'globalsearch', 0, 0, 1),
(17, 'glossary_random', 0, 0, 1),
(18, 'html', 0, 0, 1),
(19, 'login', 0, 0, 1),
(20, 'lp', 0, 0, 1),
(21, 'mentees', 0, 0, 1),
(22, 'mnet_hosts', 0, 0, 1),
(23, 'myoverview', 0, 0, 1),
(24, 'myprofile', 0, 0, 1),
(25, 'navigation', 0, 0, 1),
(26, 'news_items', 0, 0, 1),
(27, 'online_users', 0, 0, 1),
(28, 'private_files', 0, 0, 1),
(29, 'recent_activity', 0, 0, 1),
(30, 'recentlyaccessedcourses', 0, 0, 1),
(31, 'recentlyaccesseditems', 0, 0, 1),
(32, 'rss_client', 0, 0, 0),
(33, 'search_forums', 0, 0, 1),
(34, 'section_links', 0, 0, 1),
(35, 'selfcompletion', 0, 0, 0),
(36, 'settings', 0, 0, 1),
(37, 'site_main_menu', 0, 0, 1),
(38, 'social_activities', 0, 0, 1),
(39, 'starredcourses', 0, 0, 1),
(40, 'tag_flickr', 0, 0, 1),
(41, 'tag_youtube', 0, 0, 0),
(42, 'tags', 0, 0, 1),
(43, 'timeline', 0, 0, 1),
(44, 'openai_chat', 0, 0, 1),
(45, 'xp', 0, 0, 1),
(46, 'completion_progress', 0, 0, 1),
(47, 'completion_levels', 0, 0, 1),
(48, 'point_view', 0, 0, 1);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_block_instances`
--

CREATE TABLE `mdl_block_instances` (
  `id` bigint NOT NULL,
  `blockname` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `parentcontextid` bigint NOT NULL,
  `showinsubcontexts` smallint NOT NULL,
  `requiredbytheme` smallint NOT NULL DEFAULT '0',
  `pagetypepattern` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `subpagepattern` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `defaultregion` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `defaultweight` bigint NOT NULL,
  `configdata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `timecreated` bigint NOT NULL,
  `timemodified` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='This table stores block instances. The type of block this is' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_block_instances`
--

INSERT INTO `mdl_block_instances` (`id`, `blockname`, `parentcontextid`, `showinsubcontexts`, `requiredbytheme`, `pagetypepattern`, `subpagepattern`, `defaultregion`, `defaultweight`, `configdata`, `timecreated`, `timemodified`) VALUES
(2, 'recentlyaccesseditems', 1, 0, 0, 'my-index', '2', 'side-post', 0, '', 1728145888, 1728145888),
(3, 'timeline', 1, 0, 0, 'my-index', '2', 'content', 0, '', 1728145888, 1728145888),
(4, 'calendar_month', 1, 0, 0, 'my-index', '2', 'content', 1, '', 1728145888, 1728145888),
(5, 'myoverview', 1, 0, 0, 'my-index', '3', 'content', 0, '', 1728145888, 1728145888),
(9, 'recentlyaccesseditems', 24, 0, 0, 'my-index', '7', 'side-post', 0, '', 1730590294, 1730590294),
(10, 'timeline', 24, 0, 0, 'my-index', '7', 'content', 0, '', 1730590294, 1730590294),
(11, 'calendar_month', 24, 0, 0, 'my-index', '7', 'content', 1, '', 1730590294, 1730590294),
(13, 'recentlyaccesseditems', 35, 0, 0, 'my-index', '8', 'side-post', 0, '', 1730785947, 1730785947),
(14, 'timeline', 35, 0, 0, 'my-index', '8', 'content', 0, '', 1730785947, 1730785947),
(15, 'calendar_month', 35, 0, 0, 'my-index', '8', 'content', 1, '', 1730785947, 1730785947),
(21, 'recentlyaccesseditems', 51, 0, 0, 'my-index', '9', 'side-post', 0, '', 1731012006, 1731012006),
(22, 'timeline', 51, 0, 0, 'my-index', '9', 'content', 0, '', 1731012006, 1731012006),
(23, 'calendar_month', 51, 0, 0, 'my-index', '9', 'content', 1, '', 1731012006, 1731012006),
(24, 'html', 1, 1, 0, '*', NULL, 'side-pre', 1, 'Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJ0aXRsZSI7czoxODoiTGVzIGluZGlzcGVuc2FibGVzIjtzOjY6ImZvcm1hdCI7czoxOiIxIjtzOjQ6InRleHQiO3M6MTEzMDoiPHA+PGEgdGl0bGU9Imh0dHBzOi8vcGVkYWdvZ2llLmFjLW1vbnRwZWxsaWVyLmZyL3NpdGVzL2RlZmF1bHQvZmlsZXMvcmVzc291cmNlcy9tYW51ZWwtMDMtMTAtXzEwMjAwMDEucGRmIiBocmVmPSJodHRwczovL3BlZGFnb2dpZS5hYy1tb250cGVsbGllci5mci9zaXRlcy9kZWZhdWx0L2ZpbGVzL3Jlc3NvdXJjZXMvbWFudWVsLTAzLTEwLV8xMDIwMDAxLnBkZiI+PGltZyBjbGFzcz0iaW1nLWZsdWlkIiBzcmM9IkBAUExVR0lORklMRUBAL0NhcHR1cmUlMjBkJUUyJTgwJTk5JUMzJUE5Y3JhbiUyMGR1JTIwMjAyNC0xMi0xMyUyMDE3LTM1LTUwLnBuZyIgYWx0PSJMYSBjb3V2ZXJ0dXJlIGR1IG1hbnVlbCBkdSBCSUEiIHdpZHRoPSI2MDMiIGhlaWdodD0iODU4Ij48L2E+PC9wPg0KPHA+TGUgPGEgaHJlZj0iaHR0cHM6Ly9wZWRhZ29naWUuYWMtbW9udHBlbGxpZXIuZnIvc2l0ZXMvZGVmYXVsdC9maWxlcy9yZXNzb3VyY2VzL21hbnVlbC0wMy0xMC1fMTAyMDAwMS5wZGYiPk1hbnVlbCBkdSBCcmV2ZXQgZCdpbml0aWF0aW9uPC9hPiDDoCBsJ2HDqXJvbmF1dGlxdWUgcXVpIGVzdCBsZSBkb2N1bWVudCBkZSByw6lmw6lyZW5jZSBkZXMgbm90aW9ucyDDoCBjb25uYcOudHJlIGxlIGpvdXIgZGUgbCdleGFtZW4uPC9wPg0KPGg0PkxlcyB2aWTDqW9zPC9oND4NCjxwPjxhIHRpdGxlPSJodHRwczovL3d3dy55b3V0dWJlLmNvbS9wbGF5bGlzdD9saXN0PVBMY2lZTWZGT1RBWmFuYkJUSDctckJuYlMtMGtvdjZsV0siIGhyZWY9Imh0dHBzOi8vd3d3LnlvdXR1YmUuY29tL3BsYXlsaXN0P2xpc3Q9UExjaVlNZkZPVEFaYW5iQlRINy1yQm5iUy0wa292NmxXSyI+PGltZyBjbGFzcz0iaW1nLWZsdWlkIiBzcmM9IkBAUExVR0lORklMRUBAL2Nhc3QtY2FuYWxiaWEtMTU2MzIucG5nIiBhbHQ9IkltYWdlIGRlIGxhIGNoYWluZSAmcXVvdDtjYW5hbCBCSUEmcXVvdDsiIHdpZHRoPSI1MDAiIGhlaWdodD0iMjIwIj48L2E+PC9wPg0KPHA+TGEgY2hhw65uZSDCqyBjYW5hbCBCSUEgwrsgb3Ugdm91cyB0cm91dmVyZXogdG91dGVzIGxlcyByZXNzb3VyY2VzIGVuIHZpZMOpb3MsIGFmaW4gZGUgcHLDqXBhcmVyIGxlIEJyZXZldCBkJ2luaXRpYXRpb24gw6AgbCdhw6lyb25hdXRpcXVlLjwvcD4NCjxwPjwvcD4iO30=', 1734108199, 1735636919),
(26, 'settings', 1, 1, 1, '*', NULL, 'side-pre', 0, '', 1734261426, 1734261426),
(29, 'recentlyaccesseditems', 92, 0, 0, 'my-index', '11', 'side-post', 0, '', 1734381115, 1734381115),
(30, 'timeline', 92, 0, 0, 'my-index', '11', 'content', 0, '', 1734381115, 1734381115),
(31, 'calendar_month', 92, 0, 0, 'my-index', '11', 'content', 1, '', 1734381115, 1734381115),
(37, 'xp', 68, 0, 0, 'course-view-*', NULL, 'side-pre', 0, '', 1734394201, 1734394201),
(39, 'xp', 22, 0, 0, 'course-view-*', NULL, 'side-pre', 0, '', 1734394457, 1734394457),
(40, 'xp', 14, 0, 0, 'course-view-*', NULL, 'side-pre', 0, '', 1734394596, 1734394596),
(41, 'xp', 18, 1, 0, '*', NULL, 'side-pre', 0, 'Tzo4OiJzdGRDbGFzcyI6MDp7fQ==', 1734394645, 1734507291),
(42, 'xp', 16, 0, 0, 'course-view-*', NULL, 'side-pre', 0, '', 1734394665, 1734394665),
(43, 'xp', 20, 0, 0, 'course-view-*', NULL, 'side-pre', 0, '', 1734394682, 1734394682),
(48, 'xp', 68, 0, 0, 'course-edit', NULL, 'side-pre', 2, '', 1734415984, 1734415984),
(52, 'xp', 117, 0, 0, 'course-view-*', NULL, 'side-pre', 2, '', 1734466694, 1734466694),
(56, 'completion_levels', 68, 0, 0, 'course-*', NULL, 'side-pre', 2, 'Tzo4OiJzdGRDbGFzcyI6MTU6e3M6MTA6ImJsb2NrdGl0bGUiO3M6MjA6IlZvdHJlIHBvc2l0aW9ubmVtZW50IjtzOjEyOiJwcm9ncmVzc292ZXIiO3M6MDoiIjtzOjE0OiJtYXJrYWN0aXZpdGllcyI7czoxOiIwIjtzOjE5OiJmaWx0ZXJpbmFjdGl2ZXVzZXJzIjtzOjE6IjEiO3M6MTQ6IndhbGxvZmZhbWVzaXplIjtzOjE6IjMiO3M6MTQ6InRyYWNraW5nbWV0aG9kIjtzOjE6IjEiO3M6ODoiYWN0aXZpdHkiO2E6NDp7aTozMzthOjI6e3M6ODoiY2hlY2tib3giO3M6MToiMSI7czo2OiJ3ZWlnaHQiO2k6MTt9aTozOTthOjI6e3M6ODoiY2hlY2tib3giO3M6MToiMSI7czo2OiJ3ZWlnaHQiO2k6MTt9aTo1MjthOjI6e3M6ODoiY2hlY2tib3giO3M6MToiMSI7czo2OiJ3ZWlnaHQiO2k6MTt9aTo1MDthOjI6e3M6ODoiY2hlY2tib3giO3M6MToiMSI7czo2OiJ3ZWlnaHQiO2k6MTt9fXM6ODoibWF4bGV2ZWwiO2k6MTA7czo5OiJwaXhzZWxlY3QiO3M6NjoiY3VzdG9tIjtzOjEwOiJsZXZlbHNfcGl4IjtOO3M6Mjc6InNlbmRjb21wbGV0aW9ubm90aWZpY2F0aW9ucyI7czoxOiIxIjtzOjE5OiJzZW5kbm90aWZpY2F0aW9uc3RvIjthOjE6e2k6MjtzOjE6IjEiO31zOjk6ImFub255bW91cyI7czoxOiIwIjtzOjE3OiJ1c2VhbHRlcm5hdGVuYW1lcyI7czoxOiIwIjtzOjE2OiJzaG93b25seWNvZ3JvdXBzIjtzOjE6IjAiO30=', 1734592937, 1734605239),
(58, 'recentlyaccesseditems', 5, 0, 0, 'my-index', '14', 'side-pre', -1, '', 1734600123, 1734606801),
(59, 'timeline', 5, 0, 0, 'my-index', NULL, 'content', 0, 'Tzo4OiJzdGRDbGFzcyI6MDp7fQ==', 1734600123, 1734606523),
(60, 'calendar_month', 5, 0, 0, 'my-index', '14', 'content', 1, '', 1734600123, 1734600123),
(61, 'completion_levels', 16, 1, 0, '*', NULL, 'side-pre', 2, 'Tzo4OiJzdGRDbGFzcyI6MTU6e3M6MTA6ImJsb2NrdGl0bGUiO3M6MTQ6IlBvc2l0aW9ubmVtZW50IjtzOjEyOiJwcm9ncmVzc292ZXIiO3M6MDoiIjtzOjE0OiJtYXJrYWN0aXZpdGllcyI7czoxOiIxIjtzOjE5OiJmaWx0ZXJpbmFjdGl2ZXVzZXJzIjtzOjE6IjEiO3M6MTQ6IndhbGxvZmZhbWVzaXplIjtzOjE6IjMiO3M6OToiYW5vbnltb3VzIjtzOjE6IjAiO3M6MTc6InVzZWFsdGVybmF0ZW5hbWVzIjtzOjE6IjAiO3M6MTY6InNob3dvbmx5Y29ncm91cHMiO3M6MToiMCI7czoxNDoidHJhY2tpbmdtZXRob2QiO3M6MToiMCI7czo4OiJhY3Rpdml0eSI7YToxMDp7aTo5O2E6Mjp7czo4OiJjaGVja2JveCI7aTowO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTY7YToyOntzOjg6ImNoZWNrYm94IjtpOjA7czo2OiJ3ZWlnaHQiO2k6MTt9aTo0MDthOjI6e3M6ODoiY2hlY2tib3giO2k6MDtzOjY6IndlaWdodCI7aToxO31pOjcyO2E6Mjp7czo4OiJjaGVja2JveCI7aTowO3M6Njoid2VpZ2h0IjtpOjE7fWk6NzM7YToyOntzOjg6ImNoZWNrYm94IjtzOjE6IjEiO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTg7YToyOntzOjg6ImNoZWNrYm94IjtpOjA7czo2OiJ3ZWlnaHQiO2k6MTt9aToxOTthOjI6e3M6ODoiY2hlY2tib3giO2k6MDtzOjY6IndlaWdodCI7aToxO31pOjIwO2E6Mjp7czo4OiJjaGVja2JveCI7aTowO3M6Njoid2VpZ2h0IjtpOjE7fWk6MjE7YToyOntzOjg6ImNoZWNrYm94IjtpOjA7czo2OiJ3ZWlnaHQiO2k6MTt9aToyMzthOjI6e3M6ODoiY2hlY2tib3giO2k6MDtzOjY6IndlaWdodCI7aToxO319czo4OiJtYXhsZXZlbCI7aToxMDtzOjEwOiJsZXZlbHNfcGl4IjtOO3M6Mjc6InNlbmRjb21wbGV0aW9ubm90aWZpY2F0aW9ucyI7czoxOiIxIjtzOjE5OiJzZW5kbm90aWZpY2F0aW9uc3RvIjthOjE6e2k6MjtzOjE6IjEiO31zOjk6InBpeHNlbGVjdCI7czo2OiJjdXN0b20iO30=', 1734605990, 1734606212),
(62, 'completion_levels', 5, 0, 0, 'my-index', '14', 'side-pre', -3, '', 1734606574, 1734606597),
(63, 'online_users', 68, 0, 0, 'course-*', NULL, 'side-pre', 2, 'Tzo4OiJzdGRDbGFzcyI6MDp7fQ==', 1734606734, 1734606759),
(64, 'completion_progress', 5, 0, 0, 'my-index', NULL, 'content', 2, 'Tzo4OiJzdGRDbGFzcyI6MDp7fQ==', 1734606846, 1734606862),
(65, 'completion_progress', 68, 0, 0, 'course-view-*', NULL, 'side-pre', 2, '', 1734606969, 1734606969),
(67, 'completion_progress', 18, 0, 0, 'course-view-*', NULL, 'side-pre', 2, '', 1736403803, 1736403803),
(68, 'completion_levels', 18, 1, 0, '*', NULL, 'side-pre', 2, 'Tzo4OiJzdGRDbGFzcyI6MTQ6e3M6MTA6ImJsb2NrdGl0bGUiO3M6MTk6IlZvdHJlIG5pdmVhdSBhY3R1ZWwiO3M6MTI6InByb2dyZXNzb3ZlciI7czowOiIiO3M6MTQ6Im1hcmthY3Rpdml0aWVzIjtzOjE6IjEiO3M6MTk6ImZpbHRlcmluYWN0aXZldXNlcnMiO3M6MToiMSI7czoxNDoid2FsbG9mZmFtZXNpemUiO3M6MToiMyI7czo5OiJhbm9ueW1vdXMiO3M6MToiMCI7czoxNzoidXNlYWx0ZXJuYXRlbmFtZXMiO3M6MToiMCI7czoxNjoic2hvd29ubHljb2dyb3VwcyI7czoxOiIwIjtzOjE0OiJ0cmFja2luZ21ldGhvZCI7czoxOiIwIjtzOjg6ImFjdGl2aXR5IjthOjIyOntpOjk4O2E6Mjp7czo4OiJjaGVja2JveCI7czoxOiIxIjtzOjY6IndlaWdodCI7aToxO31pOjExNjthOjI6e3M6ODoiY2hlY2tib3giO2k6MDtzOjY6IndlaWdodCI7aToxO31pOjEyNzthOjI6e3M6ODoiY2hlY2tib3giO3M6MToiMSI7czo2OiJ3ZWlnaHQiO2k6MTt9aToxMjg7YToyOntzOjg6ImNoZWNrYm94IjtzOjE6IjEiO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTI5O2E6Mjp7czo4OiJjaGVja2JveCI7czoxOiIxIjtzOjY6IndlaWdodCI7aToxO31pOjEzMDthOjI6e3M6ODoiY2hlY2tib3giO3M6MToiMSI7czo2OiJ3ZWlnaHQiO2k6MTt9aToxMzE7YToyOntzOjg6ImNoZWNrYm94IjtzOjE6IjEiO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTEyO2E6Mjp7czo4OiJjaGVja2JveCI7aTowO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTI0O2E6Mjp7czo4OiJjaGVja2JveCI7czoxOiIxIjtzOjY6IndlaWdodCI7aToxO31pOjEyNTthOjI6e3M6ODoiY2hlY2tib3giO3M6MToiMSI7czo2OiJ3ZWlnaHQiO2k6MTt9aToxMjY7YToyOntzOjg6ImNoZWNrYm94IjtzOjE6IjEiO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTQ0O2E6Mjp7czo4OiJjaGVja2JveCI7aTowO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTE0O2E6Mjp7czo4OiJjaGVja2JveCI7aTowO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTE1O2E6Mjp7czo4OiJjaGVja2JveCI7aTowO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTE3O2E6Mjp7czo4OiJjaGVja2JveCI7aTowO3M6Njoid2VpZ2h0IjtpOjE7fWk6MTQzO2E6Mjp7czo4OiJjaGVja2JveCI7aTowO3M6Njoid2VpZ2h0IjtpOjE7fWk6Mjk7YToyOntzOjg6ImNoZWNrYm94IjtpOjA7czo2OiJ3ZWlnaHQiO2k6MTt9aToxMDA7YToyOntzOjg6ImNoZWNrYm94IjtpOjA7czo2OiJ3ZWlnaHQiO2k6MTt9aToxMDE7YToyOntzOjg6ImNoZWNrYm94IjtpOjA7czo2OiJ3ZWlnaHQiO2k6MTt9aToxMDI7YToyOntzOjg6ImNoZWNrYm94IjtpOjA7czo2OiJ3ZWlnaHQiO2k6MTt9aToxMDM7YToyOntzOjg6ImNoZWNrYm94IjtpOjA7czo2OiJ3ZWlnaHQiO2k6MTt9aToxNDI7YToyOntzOjg6ImNoZWNrYm94IjtpOjA7czo2OiJ3ZWlnaHQiO2k6MTt9fXM6ODoibWF4bGV2ZWwiO2k6MTA7czoxMDoibGV2ZWxzX3BpeCI7aTo5Nzk1NzUzMzE7czoyNzoic2VuZGNvbXBsZXRpb25ub3RpZmljYXRpb25zIjtzOjE6IjEiO3M6MTk6InNlbmRub3RpZmljYXRpb25zdG8iO2E6MTp7aToyO3M6MToiMSI7fX0=', 1736404492, 1736456085),
(70, 'navigation', 1, 1, 1, '*', NULL, 'side-post', 0, '', 1736414960, 1736414960),
(72, 'news_items', 18, 1, 0, '*', NULL, 'side-pre', 3, 'Tzo4OiJzdGRDbGFzcyI6MDp7fQ==', 1736455947, 1736455998);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_block_openai_chat_log`
--

CREATE TABLE `mdl_block_openai_chat_log` (
  `id` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `usermessage` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `airesponse` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `contextid` bigint NOT NULL,
  `timecreated` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Log of chat messages for block_openai_chat' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_block_point_view`
--

CREATE TABLE `mdl_block_point_view` (
  `id` bigint NOT NULL,
  `courseid` bigint NOT NULL,
  `cmid` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `vote` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Save the user''s votes by types for the different activities' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_block_positions`
--

CREATE TABLE `mdl_block_positions` (
  `id` bigint NOT NULL,
  `blockinstanceid` bigint NOT NULL,
  `contextid` bigint NOT NULL,
  `pagetype` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `subpage` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `visible` smallint NOT NULL,
  `region` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `weight` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores the position of a sticky block_instance on a another ' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_block_positions`
--

INSERT INTO `mdl_block_positions` (`id`, `blockinstanceid`, `contextid`, `pagetype`, `subpage`, `visible`, `region`, `weight`) VALUES
(5, 52, 117, 'course-view-topics', '', 1, 'side-pre', -1),
(6, 52, 117, 'course-view-section-topics', '', 1, 'side-pre', 0),
(7, 56, 68, 'course-view-topics', '', 1, 'side-pre', -3),
(8, 61, 16, 'course-view-topics', '', 1, 'side-pre', -3),
(9, 63, 68, 'course-view-topics', '', 1, 'side-pre', -4),
(10, 65, 68, 'course-view-topics', '', 1, 'side-pre', -2),
(11, 41, 18, 'course-view-topics', '', 1, 'side-pre', -1),
(12, 67, 18, 'course-view-topics', '', 1, 'side-pre', -3),
(13, 68, 18, 'course-view-topics', '', 1, 'side-pre', -4),
(14, 41, 18, 'course-view-section-topics', '', 1, 'side-pre', -1),
(15, 67, 18, 'course-view-section-topics', '', 1, 'side-pre', -3),
(16, 68, 18, 'course-view-section-topics', '', 1, 'side-pre', -4),
(17, 41, 18, 'course-view-tiles', '', 1, 'side-pre', -1),
(18, 67, 18, 'course-view-tiles', '', 1, 'side-pre', -3),
(19, 24, 18, 'course-view-tiles', '', 1, 'side-pre', 2),
(20, 68, 18, 'course-view-tiles', '', 1, 'side-pre', -5),
(21, 72, 18, 'course-view-tiles', '', 1, 'side-pre', -4);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_block_recentlyaccesseditems`
--

CREATE TABLE `mdl_block_recentlyaccesseditems` (
  `id` bigint NOT NULL,
  `courseid` bigint NOT NULL,
  `cmid` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `timeaccess` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Most recently accessed items accessed by a user' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_block_recentlyaccesseditems`
--

INSERT INTO `mdl_block_recentlyaccesseditems` (`id`, `courseid`, `cmid`, `userid`, `timeaccess`) VALUES
(18, 3, 21, 5, 1731012165),
(19, 3, 19, 5, 1731012685),
(21, 2, 17, 5, 1731013099),
(30, 2, 26, 5, 1731613103),
(45, 7, 39, 3, 1735917326),
(49, 7, 39, 6, 1734605085),
(73, 3, 73, 3, 1734551448),
(76, 3, 73, 6, 1734591305),
(77, 7, 52, 3, 1734591772),
(78, 6, 71, 3, 1735001685),
(80, 7, 77, 3, 1735127111),
(86, 9, 83, 3, 1735554461),
(88, 9, 84, 6, 1735574806),
(91, 9, 86, 6, 1735574800),
(98, 9, 89, 6, 1735636225),
(101, 9, 94, 3, 1736011146),
(105, 9, 95, 3, 1735924708),
(106, 4, 98, 2, 1736455892),
(116, 4, 116, 3, 1736155344),
(120, 4, 142, 2, 1736434839),
(122, 4, 103, 2, 1736434842),
(123, 4, 101, 2, 1736436825),
(124, 4, 102, 2, 1736434845),
(128, 4, 145, 6, 1736403964),
(129, 3, 72, 2, 1736405094),
(130, 4, 143, 2, 1736455773),
(131, 4, 101, 6, 1736436060),
(132, 7, 39, 2, 1736436785),
(133, 4, 98, 6, 1736436890),
(134, 1, 15, 2, 1736447310),
(135, 4, 144, 6, 1736456580);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_block_recent_activity`
--

CREATE TABLE `mdl_block_recent_activity` (
  `id` bigint NOT NULL,
  `courseid` bigint NOT NULL,
  `cmid` bigint NOT NULL,
  `timecreated` bigint NOT NULL,
  `userid` bigint NOT NULL,
  `action` tinyint(1) NOT NULL,
  `modname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Recent activity block' ROW_FORMAT=COMPRESSED;

--
-- Déchargement des données de la table `mdl_block_recent_activity`
--

INSERT INTO `mdl_block_recent_activity` (`id`, `courseid`, `cmid`, `timecreated`, `userid`, `action`, `modname`) VALUES
(1, 3, 6, 1730591945, 2, 0, NULL),
(2, 3, 6, 1730592018, 2, 1, NULL),
(3, 3, 6, 1730592018, 2, 1, NULL),
(4, 3, 6, 1730592143, 2, 1, NULL),
(5, 3, 6, 1730592378, 2, 1, NULL),
(6, 3, 6, 1730592379, 2, 1, NULL),
(7, 3, 6, 1730592420, 2, 1, NULL),
(8, 3, 6, 1730592421, 2, 1, NULL),
(9, 2, 7, 1730646521, 2, 0, NULL),
(10, 2, 7, 1730646538, 2, 1, NULL),
(11, 2, 7, 1730646538, 2, 1, NULL),
(12, 2, 7, 1730657954, 2, 1, NULL),
(13, 2, 7, 1730657965, 2, 1, NULL),
(14, 2, 7, 1730657965, 2, 2, 'dataform'),
(15, 2, 8, 1730659397, 2, 0, NULL),
(16, 3, 9, 1730662290, 2, 0, NULL),
(17, 2, 10, 1730663723, 2, 0, NULL),
(18, 2, 11, 1730663821, 2, 0, NULL),
(19, 2, 12, 1730872390, 2, 0, NULL),
(20, 2, 13, 1730960082, 2, 0, NULL),
(21, 2, 14, 1730960128, 2, 0, NULL),
(22, 3, 16, 1730960582, 2, 0, NULL),
(23, 2, 17, 1730962523, 2, 0, NULL),
(24, 3, 18, 1731006839, 2, 0, NULL),
(25, 3, 19, 1731011132, 2, 0, NULL),
(26, 3, 20, 1731011612, 2, 0, NULL),
(27, 3, 21, 1731011911, 2, 0, NULL),
(28, 2, 22, 1731012926, 2, 0, NULL),
(29, 3, 23, 1731085907, 2, 0, NULL),
(30, 2, 24, 1731392744, 2, 0, NULL),
(31, 2, 24, 1731392871, 2, 1, NULL),
(32, 2, 25, 1731563052, 2, 0, NULL),
(33, 2, 26, 1731569598, 2, 0, NULL),
(34, 2, 27, 1731653579, 2, 0, NULL),
(35, 2, 28, 1731663280, 2, 0, NULL),
(36, 4, 29, 1732112744, 2, 0, NULL),
(37, 4, 29, 1732113328, 2, 1, NULL),
(38, 6, 30, 1732114479, 2, 0, NULL),
(39, 6, 31, 1734011349, 2, 0, NULL),
(40, 7, 32, 1734166929, 2, 1, NULL),
(41, 7, 33, 1734167870, 2, 0, NULL),
(42, 7, 34, 1734170881, 2, 0, NULL),
(43, 7, 35, 1734170918, 2, 0, NULL),
(44, 7, 36, 1734170987, 2, 0, NULL),
(45, 7, 35, 1734205007, 2, 1, NULL),
(46, 1, 37, 1734265971, 2, 0, NULL),
(47, 1, 37, 1734266114, 2, 1, NULL),
(48, 1, 37, 1734266554, 2, 1, NULL),
(49, 1, 37, 1734266581, 2, 1, NULL),
(50, 1, 37, 1734266607, 2, 1, NULL),
(51, 1, 38, 1734267198, 2, 0, NULL),
(52, 1, 38, 1734267479, 2, 1, NULL),
(53, 1, 38, 1734267512, 2, 1, NULL),
(54, 1, 38, 1734267551, 2, 1, NULL),
(55, 1, 38, 1734267574, 2, 1, NULL),
(56, 1, 38, 1734267632, 2, 1, NULL),
(57, 1, 38, 1734267693, 2, 1, NULL),
(58, 1, 38, 1734267763, 2, 1, NULL),
(59, 1, 38, 1734267786, 2, 1, NULL),
(60, 1, 38, 1734267805, 2, 1, NULL),
(61, 1, 38, 1734267826, 2, 1, NULL),
(62, 1, 37, 1734268370, 2, 1, NULL),
(63, 7, 39, 1734269127, 2, 0, NULL),
(64, 3, 40, 1734269424, 2, 0, NULL),
(65, 2, 41, 1734270749, 2, 0, NULL),
(66, 1, 38, 1734274114, 2, 1, NULL),
(67, 7, 42, 1734274196, 2, 0, NULL),
(68, 7, 43, 1734274683, 2, 0, NULL),
(69, 7, 43, 1734274840, 2, 1, NULL),
(70, 7, 43, 1734274897, 2, 1, NULL),
(71, 7, 44, 1734275011, 2, 0, NULL),
(72, 7, 44, 1734275577, 2, 1, NULL),
(73, 7, 45, 1734275826, 2, 0, NULL),
(74, 7, 45, 1734275923, 2, 1, NULL),
(75, 7, 44, 1734275988, 2, 1, NULL),
(76, 7, 44, 1734276007, 2, 1, NULL),
(77, 7, 46, 1734276536, 2, 0, NULL),
(78, 7, 46, 1734277041, 2, 1, NULL),
(79, 7, 46, 1734277231, 2, 1, NULL),
(80, 7, 39, 1734277753, 2, 1, NULL),
(81, 7, 39, 1734277772, 2, 1, NULL),
(82, 1, 47, 1734294080, 2, 0, NULL),
(83, 1, 48, 1734294770, 2, 0, NULL),
(84, 1, 48, 1734294902, 2, 1, NULL),
(85, 1, 48, 1734295032, 2, 1, NULL),
(86, 7, 49, 1734337776, 2, 0, NULL),
(87, 7, 44, 1734415695, 2, 1, NULL),
(88, 7, 43, 1734415829, 2, 1, NULL),
(89, 7, 45, 1734416683, 2, 1, NULL),
(90, 7, 50, 1734417164, 2, 0, NULL),
(91, 7, 51, 1734417756, 2, 0, NULL),
(92, 7, 52, 1734418065, 2, 0, NULL),
(93, 7, 52, 1734418584, 2, 1, NULL),
(94, 7, 51, 1734418646, 2, 1, NULL),
(95, 7, 52, 1734418865, 2, 1, NULL),
(96, 7, 52, 1734419826, 2, 1, NULL),
(97, 1, 37, 1734466225, 2, 1, NULL),
(98, 8, 54, 1734466943, 2, 0, NULL),
(99, 8, 54, 1734467155, 2, 1, NULL),
(100, 8, 53, 1734467334, 2, 1, NULL),
(101, 8, 55, 1734467406, 2, 0, NULL),
(102, 8, 56, 1734468924, 2, 0, NULL),
(103, 8, 56, 1734468976, 2, 1, NULL),
(104, 8, 57, 1734469071, 2, 0, NULL),
(105, 8, 57, 1734469161, 2, 1, NULL),
(106, 8, 58, 1734469220, 2, 0, NULL),
(107, 8, 58, 1734469355, 2, 1, NULL),
(108, 8, 59, 1734469442, 2, 0, NULL),
(109, 8, 60, 1734469630, 2, 0, NULL),
(110, 8, 60, 1734469748, 2, 1, NULL),
(111, 8, 61, 1734469833, 2, 0, NULL),
(112, 8, 62, 1734470000, 2, 0, NULL),
(113, 8, 63, 1734471460, 2, 0, NULL),
(114, 8, 64, 1734473740, 2, 0, NULL),
(115, 8, 65, 1734474195, 2, 0, NULL),
(116, 8, 56, 1734474285, 2, 1, NULL),
(117, 7, 39, 1734476092, 2, 1, NULL),
(118, 7, 66, 1734476816, 2, 0, NULL),
(119, 8, 67, 1734477003, 2, 0, NULL),
(120, 8, 68, 1734477110, 2, 0, NULL),
(121, 8, 68, 1734477166, 2, 1, NULL),
(122, 5, 69, 1734503628, 2, 0, NULL),
(123, 8, 68, 1734503797, 2, 1, NULL),
(124, 5, 69, 1734504601, 2, 1, NULL),
(125, 5, 70, 1734504960, 2, 0, NULL),
(126, 1, 37, 1734505880, 2, 1, NULL),
(127, 1, 38, 1734510783, 2, 1, NULL),
(128, 6, 71, 1734511926, 2, 0, NULL),
(129, 6, 71, 1734512026, 2, 1, NULL),
(130, 3, 72, 1734512496, 2, 0, NULL),
(131, 3, 72, 1734512559, 2, 1, NULL),
(132, 3, 73, 1734512731, 2, 0, NULL),
(133, 3, 73, 1734512822, 2, 1, NULL),
(134, 3, 72, 1734512881, 2, 1, NULL),
(135, 8, 64, 1734588679, 2, 1, NULL),
(136, 8, 74, 1734588915, 2, 0, NULL),
(137, 8, 58, 1734589365, 2, 1, NULL),
(138, 8, 58, 1734589595, 2, 1, NULL),
(139, 7, 52, 1734592381, 2, 1, NULL),
(140, 7, 39, 1734593404, 2, 1, NULL),
(141, 8, 75, 1734598044, 2, 0, NULL),
(142, 1, 37, 1734605014, 2, 1, NULL),
(143, 8, 68, 1734711646, 2, 1, NULL),
(144, 1, 37, 1734711691, 2, 1, NULL),
(145, 7, 76, 1735123397, 2, 0, NULL),
(146, 7, 76, 1735123916, 2, 1, NULL),
(147, 7, 76, 1735123948, 2, 1, NULL),
(148, 7, 77, 1735124096, 2, 0, NULL),
(149, 2, 78, 1735368491, 2, 0, NULL),
(150, 2, 78, 1735368594, 2, 1, NULL),
(151, 2, 78, 1735369365, 2, 1, NULL),
(152, 2, 78, 1735369408, 2, 1, NULL),
(153, 2, 78, 1735369459, 2, 1, NULL),
(154, 2, 78, 1735369523, 2, 1, NULL),
(155, 2, 78, 1735369782, 2, 1, NULL),
(156, 2, 78, 1735369841, 2, 1, NULL),
(157, 2, 78, 1735369986, 2, 1, NULL),
(158, 2, 78, 1735370111, 2, 1, NULL),
(159, 2, 78, 1735370164, 2, 1, NULL),
(160, 2, 78, 1735370987, 2, 1, NULL),
(161, 2, 78, 1735371311, 2, 1, NULL),
(162, 2, 78, 1735371334, 2, 1, NULL),
(163, 2, 78, 1735371362, 2, 1, NULL),
(164, 2, 78, 1735426053, 2, 1, NULL),
(165, 2, 79, 1735426169, 2, 0, NULL),
(166, 2, 79, 1735426308, 2, 1, NULL),
(167, 2, 80, 1735426367, 2, 0, NULL),
(168, 2, 79, 1735426435, 2, 1, NULL),
(169, 2, 81, 1735426898, 2, 0, NULL),
(170, 2, 81, 1735426958, 2, 1, NULL),
(171, 2, 81, 1735426998, 2, 1, NULL),
(172, 8, 68, 1735548413, 2, 1, NULL),
(173, 8, 74, 1735551166, 2, 1, NULL),
(174, 8, 74, 1735551371, 2, 1, NULL),
(175, 9, 83, 1735553330, 2, 0, NULL),
(176, 9, 83, 1735554116, 2, 1, NULL),
(177, 9, 83, 1735554742, 2, 1, NULL),
(178, 9, 84, 1735568567, 2, 0, NULL),
(179, 9, 85, 1735569484, 2, 0, NULL),
(180, 9, 86, 1735574130, 2, 0, NULL),
(181, 9, 87, 1735578177, 2, 0, NULL),
(182, 9, 87, 1735578209, 2, 1, NULL),
(183, 9, 88, 1735581072, 2, 0, NULL),
(184, 9, 88, 1735581381, 2, 1, NULL),
(185, 9, 89, 1735581741, 2, 0, NULL),
(186, 9, 89, 1735581847, 2, 1, NULL),
(187, 9, 90, 1735582121, 2, 0, NULL),
(188, 9, 91, 1735583988, 2, 0, NULL),
(189, 9, 92, 1735595221, 2, 0, NULL),
(190, 9, 93, 1735637548, 2, 0, NULL),
(191, 9, 94, 1735637693, 2, 0, NULL),
(192, 9, 94, 1735643437, 2, 1, NULL),
(193, 9, 94, 1735644377, 2, 1, NULL),
(194, 9, 94, 1735644409, 2, 1, NULL),
(195, 7, 45, 1735900546, 2, 1, NULL),
(196, 7, 45, 1735900596, 2, 1, NULL),
(197, 1, 37, 1735904303, 2, 1, NULL),
(198, 1, 37, 1735904331, 2, 1, NULL),
(199, 1, 37, 1735906286, 2, 1, NULL),
(200, 8, 68, 1735906618, 2, 1, NULL),
(201, 8, 74, 1735906748, 2, 1, NULL),
(202, 9, 95, 1735920802, 2, 0, NULL),
(203, 2, 96, 1735934354, 2, 0, NULL),
(204, 2, 97, 1735936095, 2, 0, NULL),
(205, 2, 96, 1735936802, 2, 1, NULL),
(206, 2, 96, 1735937477, 2, 1, NULL),
(207, 1, 37, 1735989323, 2, 1, NULL),
(208, 1, 37, 1735989618, 2, 1, NULL),
(209, 4, 98, 1735990032, 2, 0, NULL),
(210, 4, 99, 1735990226, 2, 0, NULL),
(211, 4, 99, 1735990254, 2, 1, NULL),
(212, 4, 100, 1735990523, 2, 0, NULL),
(213, 4, 101, 1735990541, 2, 0, NULL),
(214, 4, 102, 1735990553, 2, 0, NULL),
(215, 4, 103, 1735990570, 2, 0, NULL),
(216, 4, 98, 1735990818, 2, 1, NULL),
(217, 4, 98, 1735990869, 2, 1, NULL),
(218, 4, 104, 1735993738, 2, 0, NULL),
(219, 4, 104, 1736005204, 2, 1, NULL),
(220, 4, 105, 1736006882, 2, 0, NULL),
(221, 4, 105, 1736007625, 2, 1, NULL),
(222, 4, 106, 1736007695, 2, 1, NULL),
(223, 4, 106, 1736007695, 2, 0, NULL),
(224, 4, 107, 1736008417, 2, 0, NULL),
(225, 4, 108, 1736008881, 2, 0, NULL),
(226, 4, 108, 1736009313, 2, 1, NULL),
(227, 4, 104, 1736009333, 2, 1, NULL),
(228, 4, 108, 1736009499, 2, 1, NULL),
(229, 4, 109, 1736009644, 2, 0, NULL),
(230, 4, 109, 1736009733, 2, 1, NULL),
(231, 4, 104, 1736009923, 2, 1, NULL),
(232, 4, 108, 1736009996, 2, 1, NULL),
(233, 4, 104, 1736010325, 2, 1, NULL),
(234, 4, 104, 1736010373, 2, 1, NULL),
(235, 4, 110, 1736012509, 2, 1, NULL),
(236, 4, 110, 1736012509, 2, 0, NULL),
(237, 4, 108, 1736012559, 2, 1, NULL),
(238, 4, 108, 1736013260, 2, 1, NULL),
(239, 4, 108, 1736013475, 2, 1, NULL),
(240, 4, 108, 1736016261, 2, 1, NULL),
(241, 4, 108, 1736017428, 2, 1, NULL),
(242, 4, 108, 1736018384, 2, 1, NULL),
(243, 4, 108, 1736019726, 2, 1, NULL),
(244, 4, 108, 1736020562, 2, 1, NULL),
(245, 4, 108, 1736021385, 2, 1, NULL),
(246, 4, 108, 1736021504, 2, 1, NULL),
(247, 4, 108, 1736021884, 2, 1, NULL),
(248, 4, 108, 1736072096, 2, 1, NULL),
(249, 4, 108, 1736077766, 2, 1, NULL),
(250, 4, 108, 1736079159, 2, 1, NULL),
(251, 4, 108, 1736079843, 2, 1, NULL),
(252, 4, 108, 1736079940, 2, 1, NULL),
(253, 4, 108, 1736080732, 2, 1, NULL),
(254, 4, 108, 1736081986, 2, 1, NULL),
(255, 4, 108, 1736082417, 2, 1, NULL),
(256, 4, 108, 1736083944, 2, 1, NULL),
(257, 4, 108, 1736084436, 2, 1, NULL),
(258, 4, 108, 1736085169, 2, 1, NULL),
(259, 4, 108, 1736085333, 2, 1, NULL),
(260, 4, 111, 1736085374, 2, 0, NULL),
(261, 4, 111, 1736085415, 2, 1, NULL),
(262, 4, 108, 1736086537, 2, 1, NULL),
(263, 4, 108, 1736086607, 2, 1, NULL),
(264, 4, 109, 1736086677, 2, 1, NULL),
(265, 4, 99, 1736086742, 2, 1, NULL),
(266, 4, 111, 1736092757, 2, 1, NULL),
(267, 4, 111, 1736094650, 2, 1, NULL),
(268, 4, 99, 1736094910, 2, 1, NULL),
(269, 4, 111, 1736095030, 2, 1, NULL),
(270, 4, 108, 1736095059, 2, 1, NULL),
(271, 4, 112, 1736096272, 2, 0, NULL),
(272, 4, 111, 1736098117, 2, 1, NULL),
(273, 4, 111, 1736099198, 2, 1, NULL),
(274, 4, 111, 1736100472, 2, 1, NULL),
(275, 4, 111, 1736101174, 2, 1, NULL),
(276, 4, 111, 1736102474, 2, 1, NULL),
(277, 4, 111, 1736103601, 2, 1, NULL),
(278, 4, 111, 1736104773, 2, 1, NULL),
(279, 4, 111, 1736105291, 2, 1, NULL),
(280, 4, 111, 1736105585, 2, 1, NULL),
(281, 4, 113, 1736105786, 2, 0, NULL),
(282, 4, 114, 1736105869, 2, 0, NULL),
(283, 4, 115, 1736105887, 2, 0, NULL),
(284, 4, 116, 1736105932, 2, 0, NULL),
(285, 4, 111, 1736106177, 2, 1, NULL),
(286, 4, 111, 1736106399, 2, 1, NULL),
(287, 4, 113, 1736106896, 2, 1, NULL),
(288, 4, 113, 1736107152, 2, 1, NULL),
(289, 4, 113, 1736107177, 2, 1, NULL),
(290, 4, 113, 1736108218, 2, 1, NULL),
(291, 4, 113, 1736109316, 2, 1, NULL),
(292, 4, 113, 1736109645, 2, 1, NULL),
(293, 4, 113, 1736110377, 2, 1, NULL),
(294, 4, 113, 1736110501, 2, 1, NULL),
(295, 4, 117, 1736110755, 2, 0, NULL),
(296, 4, 118, 1736110784, 2, 0, NULL),
(297, 4, 118, 1736110829, 2, 1, NULL),
(298, 4, 119, 1736110859, 2, 0, NULL),
(299, 4, 118, 1736111022, 2, 1, NULL),
(300, 4, 120, 1736111042, 2, 0, NULL),
(301, 4, 120, 1736111090, 2, 1, NULL),
(302, 4, 120, 1736111120, 2, 1, NULL),
(303, 4, 108, 1736112375, 2, 1, NULL),
(304, 8, 121, 1736112806, 2, 0, NULL),
(305, 1, 37, 1736113021, 2, 1, NULL),
(306, 1, 37, 1736113104, 2, 1, NULL),
(307, 4, 109, 1736137266, 2, 1, NULL),
(308, 4, 118, 1736138933, 2, 1, NULL),
(309, 4, 118, 1736139552, 2, 1, NULL),
(310, 4, 118, 1736139911, 2, 1, NULL),
(311, 4, 120, 1736140837, 2, 1, NULL),
(312, 2, 122, 1736140910, 2, 0, NULL),
(313, 2, 122, 1736140957, 2, 1, NULL),
(314, 4, 120, 1736142467, 2, 1, NULL),
(315, 4, 120, 1736143511, 2, 1, NULL),
(316, 4, 120, 1736144302, 2, 1, NULL),
(317, 4, 120, 1736144769, 2, 1, NULL),
(318, 4, 120, 1736151778, 2, 1, NULL),
(319, 4, 120, 1736162398, 2, 1, NULL),
(320, 4, 120, 1736179777, 2, 1, NULL),
(321, 4, 120, 1736180867, 2, 1, NULL),
(322, 4, 120, 1736180997, 2, 1, NULL),
(323, 4, 120, 1736181323, 2, 1, NULL),
(324, 4, 123, 1736187443, 2, 0, NULL),
(325, 4, 123, 1736187559, 2, 1, NULL),
(326, 4, 124, 1736187724, 2, 0, NULL),
(327, 4, 125, 1736187757, 2, 0, NULL),
(328, 4, 126, 1736187788, 2, 0, NULL),
(329, 4, 124, 1736187885, 2, 1, NULL),
(330, 4, 125, 1736188680, 2, 1, NULL),
(331, 4, 126, 1736188774, 2, 1, NULL),
(332, 4, 108, 1736188804, 2, 1, NULL),
(333, 4, 112, 1736188843, 2, 1, NULL),
(334, 4, 124, 1736189964, 2, 1, NULL),
(335, 4, 125, 1736190007, 2, 1, NULL),
(336, 4, 126, 1736190047, 2, 1, NULL),
(337, 4, 125, 1736190071, 2, 1, NULL),
(338, 4, 124, 1736190094, 2, 1, NULL),
(339, 4, 126, 1736190120, 2, 1, NULL),
(340, 4, 124, 1736190355, 2, 1, NULL),
(341, 4, 125, 1736190400, 2, 1, NULL),
(342, 4, 126, 1736190426, 2, 1, NULL),
(343, 4, 111, 1736255877, 2, 1, NULL),
(344, 4, 120, 1736256695, 2, 1, NULL),
(345, 4, 127, 1736256820, 2, 0, NULL),
(346, 4, 128, 1736256858, 2, 0, NULL),
(347, 4, 129, 1736256894, 2, 0, NULL),
(348, 4, 130, 1736256922, 2, 0, NULL),
(349, 4, 131, 1736256944, 2, 0, NULL),
(350, 4, 129, 1736256969, 2, 1, NULL),
(351, 4, 120, 1736257004, 2, 1, NULL),
(352, 4, 127, 1736257068, 2, 1, NULL),
(353, 4, 127, 1736257130, 2, 1, NULL),
(354, 4, 128, 1736257244, 2, 1, NULL),
(355, 4, 131, 1736257304, 2, 1, NULL),
(356, 4, 129, 1736257432, 2, 1, NULL),
(357, 4, 130, 1736257509, 2, 1, NULL),
(358, 4, 130, 1736257601, 2, 1, NULL),
(359, 4, 130, 1736257904, 2, 1, NULL),
(360, 4, 130, 1736257948, 2, 1, NULL),
(361, 4, 125, 1736316696, 2, 1, NULL),
(362, 4, 130, 1736316855, 2, 1, NULL),
(363, 4, 130, 1736317478, 2, 1, NULL),
(364, 4, 130, 1736317917, 2, 1, NULL),
(365, 4, 130, 1736318004, 2, 1, NULL),
(366, 4, 134, 1736318059, 2, 1, NULL),
(367, 4, 134, 1736318059, 2, 0, NULL),
(368, 4, 135, 1736318379, 2, 1, NULL),
(369, 4, 135, 1736318380, 2, 0, NULL),
(370, 4, 136, 1736318386, 2, 1, NULL),
(371, 4, 136, 1736318386, 2, 0, NULL),
(372, 4, 134, 1736318470, 2, 1, NULL),
(373, 4, 135, 1736318623, 2, 1, NULL),
(374, 4, 136, 1736318728, 2, 1, NULL),
(375, 4, 111, 1736318790, 2, 1, NULL),
(376, 4, 137, 1736318909, 2, 1, NULL),
(377, 4, 137, 1736318909, 2, 0, NULL),
(378, 4, 138, 1736318913, 2, 1, NULL),
(379, 4, 138, 1736318913, 2, 0, NULL),
(380, 4, 139, 1736318917, 2, 1, NULL),
(381, 4, 139, 1736318917, 2, 0, NULL),
(382, 4, 113, 1736318981, 2, 1, NULL),
(383, 4, 139, 1736319084, 2, 1, NULL),
(384, 4, 138, 1736319269, 2, 1, NULL),
(385, 4, 137, 1736319336, 2, 1, NULL),
(386, 4, 113, 1736319354, 2, 1, NULL),
(387, 4, 140, 1736319567, 2, 1, NULL),
(388, 4, 140, 1736319567, 2, 0, NULL),
(389, 4, 141, 1736319573, 2, 1, NULL),
(390, 4, 141, 1736319573, 2, 0, NULL),
(391, 4, 140, 1736319643, 2, 1, NULL),
(392, 4, 141, 1736319710, 2, 1, NULL),
(393, 4, 118, 1736319849, 2, 1, NULL),
(394, 4, 111, 1736319947, 2, 1, NULL),
(395, 4, 136, 1736319979, 2, 1, NULL),
(396, 4, 135, 1736319990, 2, 1, NULL),
(397, 4, 134, 1736320005, 2, 1, NULL),
(398, 4, 136, 1736320127, 2, 1, NULL),
(399, 4, 125, 1736321822, 2, 1, NULL),
(400, 4, 142, 1736323392, 2, 0, NULL),
(401, 4, 98, 1736324385, 2, 1, NULL),
(402, 4, 98, 1736324553, 2, 1, NULL),
(403, 4, 103, 1736326128, 2, 1, NULL),
(404, 4, 142, 1736326369, 2, 1, NULL),
(405, 4, 29, 1736346325, 2, 1, NULL),
(406, 4, 29, 1736346370, 2, 1, NULL),
(407, 4, 143, 1736346464, 2, 0, NULL),
(408, 4, 99, 1736365446, 2, 1, NULL),
(409, 4, 99, 1736366158, 2, 1, NULL),
(410, 4, 99, 1736366211, 2, 1, NULL),
(411, 4, 144, 1736366290, 2, 0, NULL),
(412, 4, 126, 1736400738, 2, 1, NULL),
(413, 4, 145, 1736401302, 2, 0, NULL),
(414, 4, 145, 1736401526, 2, 1, NULL),
(415, 4, 147, 1736434440, 2, 0, NULL),
(416, 4, 148, 1736434457, 2, 1, NULL),
(417, 4, 148, 1736434458, 2, 0, NULL),
(418, 4, 149, 1736434462, 2, 1, NULL),
(419, 4, 149, 1736434463, 2, 0, NULL),
(420, 4, 150, 1736434467, 2, 1, NULL),
(421, 4, 150, 1736434467, 2, 0, NULL),
(422, 4, 151, 1736434470, 2, 1, NULL),
(423, 4, 151, 1736434470, 2, 0, NULL),
(424, 4, 147, 1736434517, 2, 1, NULL),
(425, 4, 151, 1736434573, 2, 1, NULL),
(426, 4, 150, 1736434647, 2, 1, NULL),
(427, 4, 150, 1736434672, 2, 1, NULL),
(428, 4, 149, 1736434779, 2, 1, NULL),
(429, 4, 148, 1736434826, 2, 1, NULL),
(430, 4, 143, 1736435386, 2, 1, NULL),
(431, 4, 143, 1736435687, 2, 1, NULL),
(432, 1, 37, 1736438151, 2, 1, NULL),
(433, 4, 124, 1736454046, 2, 1, NULL),
(434, 4, 124, 1736454651, 2, 1, NULL),
(435, 4, 124, 1736454733, 2, 1, NULL),
(436, 4, 126, 1736455556, 2, 1, NULL),
(437, 1, 37, 1736496774, 2, 1, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `mdl_block_rss_client`
--

CREATE TABLE `mdl_block_rss_client` (
  `id` bigint NOT NULL,
  `userid` bigint NOT NULL DEFAULT '0',
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `preferredtitle` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `shared` tinyint NOT NULL DEFAULT '0',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `skiptime` bigint NOT NULL DEFAULT '0',
  `skipuntil` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Remote news feed information. Contains the news feed id, the' ROW_FORMAT=COMPRESSED;

-- --------------------------------------------------------

--
-- Structure de la table `mdl_block_xp`
--

