<?php
if ( ! defined( 'ABSPATH' ) ) exit;
class BCHAT_Activator {
public static function activate() {
global $wpdb;
$charset_collate = $wpdb->get_charset_collate();
$prefix = $wpdb->prefix . 'BCHAT_';
// Table des thématiques
$sql_topics = "CREATE TABLE IF NOT EXISTS {$prefix}topics (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
slug VARCHAR(255) NOT NULL,
description TEXT,
language VARCHAR(5) NOT NULL DEFAULT 'fr',
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY slug (slug)
) $charset_collate;";
// Table du calendrier éditorial (sujets suggérés/confirmés)
$sql_calendar = "CREATE TABLE IF NOT EXISTS {$prefix}calendar (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
topic_id BIGINT UNSIGNED NOT NULL,
title VARCHAR(500) NOT NULL,
slug_suggestion VARCHAR(500),
meta_description TEXT,
focus_keyword VARCHAR(255),
status ENUM('pending','confirmed','to_review','rejected','generated') NOT NULL DEFAULT 'pending',
language VARCHAR(5) NOT NULL DEFAULT 'fr',
scheduled_date DATE,
wp_post_id BIGINT UNSIGNED,
notes TEXT,
ai_outline LONGTEXT,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
source VARCHAR(20) NOT NULL DEFAULT 'advanced',
PRIMARY KEY (id),
KEY topic_id (topic_id),
KEY status (status)
) $charset_collate;";
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
dbDelta( $sql_topics );
dbDelta( $sql_calendar );
// Options par défaut
$defaults = array(
'bchat_anthropic_api_key' => '',
'bchat_mistral_api_key' => '',
'bchat_anthropic_model' => 'claude-sonnet-4-6',
'bchat_mistral_model' => 'mistral-medium-latest',
'bchat_openai_api_key' => '',
'bchat_openai_model' => 'gpt-4o-mini',
'bchat_google_api_key' => '',
'bchat_google_model' => 'gemini-1.5-flash',
'bchat_provider_global' => 'anthropic',
'bchat_provider_suggest' => '',
'bchat_provider_write' => '',
'bchat_provider_image' => '',
'bchat_license_key' => '',
'bchat_license_status' => 'unchecked',
'bchat_license_email' => '',
'bchat_license_expires' => '',
'bchat_article_length' => '1100',
'bchat_default_language' => ( strpos( get_locale(), 'fr' ) === 0 ) ? 'fr' : 'en',
'bchat_default_category' => '1',
'bchat_placeholder_images'=> array(),
'bchat_post_status' => 'draft',
'bchat_author_id' => get_current_user_id(),
'bchat_seo_plugin' => 'yoast', // yoast | rankmath | none
'bchat_show_advanced_mode' => '0',
'bchat_show_optimizer' => '0',
);
foreach ( $defaults as $key => $value ) {
if ( get_option( $key ) === false ) {
add_option( $key, $value );
}
}
update_option( 'bchat_db_version', BCHAT_VERSION );
// Forcer la mise à jour des modèles obsolètes
$obsolete = array( 'claude-sonnet-4-20250514', 'claude-opus-4-20250514', 'claude-sonnet-3-7-20250219', 'claude-sonnet-4-6-20250217', 'claude-opus-4-6-20250205' );
if ( in_array( get_option( 'bchat_anthropic_model' ), $obsolete, true ) ) {
update_option( 'bchat_anthropic_model', 'claude-sonnet-4-6' );
}
}
/**
* Migration automatique : ajoute les colonnes manquantes sans recréer la table.
* Appelée à chaque chargement du plugin si la version DB est inférieure.
*/
public static function maybe_upgrade() {
$installed = get_option( 'bchat_db_version', '0' );
if ( version_compare( $installed, BCHAT_VERSION, '>=' ) ) {
return; // Déjà à jour
}
global $wpdb;
$table = $wpdb->prefix . 'bchat_calendar';
// Récupère les colonnes existantes
$columns = $wpdb->get_col( "SHOW COLUMNS FROM `$table`", 0 ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- SHOW COLUMNS cannot use prepare; $table is static prefix
if ( empty( $columns ) ) {
// Table absente → on rejoue l'activation complète
self::activate();
return;
}
// Liste des colonnes à ajouter si absentes : [ nom => définition SQL ]
$missing = array(
'notes' => "ALTER TABLE `$table` ADD COLUMN `notes` TEXT NULL AFTER `wp_post_id`",
'ai_outline' => "ALTER TABLE `$table` ADD COLUMN `ai_outline` LONGTEXT NULL AFTER `notes`",
'updated_at' => "ALTER TABLE `$table` ADD COLUMN `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `created_at`",
'source' => "ALTER TABLE `$table` ADD COLUMN `source` VARCHAR(20) NOT NULL DEFAULT 'advanced' AFTER `updated_at`",
);
foreach ( $missing as $col => $sql ) {
if ( ! in_array( $col, $columns, true ) ) {
$wpdb->query( $sql ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- ALTER TABLE DDL cannot use prepare; $sql is a hardcoded string constant
}
}
update_option( 'bchat_db_version', BCHAT_VERSION );
}
public static function deactivate() {
// On ne supprime pas les données à la désactivation
}
}