🔧 Correction Base de Données RCI CV Import
🔍 Diagnostic de la base de données
✅ Connexion à la base de données OK
📋 Tables existantes : activity_logs, candidate_assignments, candidates, clients, cv_uploads, daily_stats, yfbv_actionscheduler_actions, yfbv_actionscheduler_claims, yfbv_actionscheduler_groups, yfbv_actionscheduler_logs, yfbv_brb_business, yfbv_brb_review, yfbv_cli_visitor_details, yfbv_commentmeta, yfbv_comments, yfbv_jetpack_sync_queue, yfbv_layerslider, yfbv_layerslider_drafts, yfbv_layerslider_revisions, yfbv_links, yfbv_litespeed_avatar, yfbv_litespeed_crawler, yfbv_litespeed_crawler_blacklist, yfbv_litespeed_img_optming, yfbv_litespeed_url, yfbv_litespeed_url_file, yfbv_mailchimp_carts, yfbv_mailchimp_jobs, yfbv_ninja_forms_uploads, yfbv_options, yfbv_postmeta, yfbv_posts, yfbv_rci_api_keys, yfbv_rci_job_applications, yfbv_redirection_404, yfbv_redirection_groups, yfbv_redirection_items, yfbv_redirection_logs, yfbv_term_relationships, yfbv_term_taxonomy, yfbv_termmeta, yfbv_terms, yfbv_tutor_earnings, yfbv_tutor_email_queue, yfbv_tutor_notifications, yfbv_tutor_quiz_attempt_answers, yfbv_tutor_quiz_attempts, yfbv_tutor_quiz_question_answers, yfbv_tutor_quiz_questions, yfbv_tutor_withdraws, yfbv_um_metadata, yfbv_usermeta, yfbv_users, yfbv_wc_admin_note_actions, yfbv_wc_admin_notes, yfbv_wc_category_lookup, yfbv_wc_customer_lookup, yfbv_wc_download_log, yfbv_wc_order_addresses, yfbv_wc_order_coupon_lookup, yfbv_wc_order_operational_data, yfbv_wc_order_product_lookup, yfbv_wc_order_stats, yfbv_wc_order_tax_lookup, yfbv_wc_product_attributes_lookup, yfbv_wc_product_download_directories, yfbv_wc_product_meta_lookup, yfbv_wc_rate_limits, yfbv_wc_reserved_stock, yfbv_wc_tax_rate_classes, yfbv_wc_webhooks, yfbv_wfauditevents, yfbv_wfblockediplog, yfbv_wfblocks7, yfbv_wfconfig, yfbv_wfcrawlers, yfbv_wffilechanges, yfbv_wffilemods, yfbv_wfhits, yfbv_wfhoover, yfbv_wfissues, yfbv_wfknownfilelist, yfbv_wflivetraffichuman, yfbv_wflocs, yfbv_wflogins, yfbv_wfls_2fa_secrets, yfbv_wfls_role_counts, yfbv_wfls_settings, yfbv_wfnotifications, yfbv_wfpendingissues, yfbv_wfreversecache, yfbv_wfsecurityevents, yfbv_wfsnipcache, yfbv_wfstatus, yfbv_wftrafficrates, yfbv_wfwaffailures, yfbv_woocommerce_api_keys, yfbv_woocommerce_attribute_taxonomies, yfbv_woocommerce_downloadable_product_permissions, yfbv_woocommerce_log, yfbv_woocommerce_order_itemmeta, yfbv_woocommerce_order_items, yfbv_woocommerce_payment_tokenmeta, yfbv_woocommerce_payment_tokens, yfbv_woocommerce_sessions, yfbv_woocommerce_shipping_zone_locations, yfbv_woocommerce_shipping_zone_methods, yfbv_woocommerce_shipping_zones, yfbv_woocommerce_tax_rate_locations, yfbv_woocommerce_tax_rates, yfbv_wpc_accesslocks, yfbv_wpc_login_fails, yfbv_wpmembers_user_search_crud, yfbv_yoast_indexable, yfbv_yoast_indexable_hierarchy, yfbv_yoast_migrations, yfbv_yoast_primary_term, yfbv_yoast_seo_links, yfbv_yoast_seo_meta
📋 Structure de la table 'candidates' :| Colonne | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| first_name | varchar(100) | NO | | |
| last_name | varchar(100) | NO | | |
| email | varchar(255) | YES | UNI | |
| phone | varchar(50) | YES | | |
| position | varchar(255) | YES | | |
| experience_years | int(11) | YES | | 0 |
| skills | text | YES | | |
| education | text | YES | | |
| languages | text | YES | | |
| cv_filename | varchar(255) | YES | | |
| cv_path | varchar(500) | YES | | |
| status | enum('pending','processing','completed','error') | YES | | pending |
| client_id | int(11) | YES | MUL | |
| created_at | timestamp | NO | | current_timestamp() |
| updated_at | timestamp | NO | | current_timestamp() |
| cats_title_enriched | varchar(300) | YES | | |
| cats_skills_enriched | longtext | YES | | |
| cats_status | varchar(100) | YES | | |
| cats_address | text | YES | | |
| cats_can_relocate | tinyint(1) | YES | | |
| cats_desired_salary | varchar(100) | YES | | |
| cats_notes_internal | longtext | YES | | |
| cats_last_activity | datetime | YES | | |
| cats_rating | decimal(3,2) | YES | | |
| cats_pipeline_stage | varchar(100) | YES | | |
| cats_last_sync | timestamp | YES | | |
| cats_sync_status | enum('pending','success','error','partial') | YES | | pending |
| cats_sync_error | text | YES | | |
| cats_data_hash | varchar(64) | YES | | |
✅ Toutes les colonnes requises sont présentes 📋 Structure de la table 'clients' :| Colonne | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| name | varchar(255) | NO | | |
| email | varchar(255) | NO | UNI | |
| contact_person | varchar(255) | YES | | |
| phone | varchar(50) | YES | | |
| status | enum('active','inactive') | YES | | active |
| created_at | timestamp | NO | | current_timestamp() |
| updated_at | timestamp | NO | | current_timestamp() |
✅ Toutes les colonnes requises sont présentes 📋 Structure de la table 'cv_uploads' :| Colonne | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | |
| filename | varchar(255) | NO | | |
| original_name | varchar(255) | NO | | |
| file_path | varchar(500) | NO | | |
| file_size | int(11) | NO | | |
| mime_type | varchar(100) | NO | | |
| status | enum('uploaded','processing','processed','error') | YES | | uploaded |
| candidate_id | int(11) | YES | MUL | |
| processed_data | text | YES | | |
| error_message | text | YES | | |
| created_at | timestamp | NO | | current_timestamp() |
| updated_at | timestamp | NO | | current_timestamp() |
✅ Toutes les colonnes requises sont présentes