wp_slf_schedule_post_title_log

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_slf_schedule_post_title_log ( id mediumint(9) NOT NULL AUTO_INCREMENT, title text NOT NULL, status varchar(1000) NOT NULL, postid int(100) NOT NULL, charaters int(100) NOT NULL, modelused varchar(100) NOT NULL, indicat varchar(100) NOT NULL, log_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, PRIMARY KEY (id) ) $charset_collate;"; // ── LEGACY TABLE 2: generated titles ───────────────────────────────── // Retained from v1 — keeps all existing generated title records. $statements[] = "CREATE TABLE wp_slf_generated_title ( id mediumint(9) NOT NULL AUTO_INCREMENT, promt_title text NOT NULL, generate_title text NOT NULL, protid int(100) NOT NULL, ctime datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, PRIMARY KEY (id) ) $charset_collate;"; // ── NEW TABLE 1: brand voice profile ───────────────────────────────── $statements[] = "CREATE TABLE wp_sfba_brand_voice ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, site_id BIGINT UNSIGNED NOT NULL DEFAULT 1, vocabulary_profile LONGTEXT NOT NULL, avg_sentence_length SMALLINT UNSIGNED NOT NULL DEFAULT 0, tone_keywords LONGTEXT NOT NULL, style_markers LONGTEXT NOT NULL, sample_posts LONGTEXT NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY site_id (site_id) ) $charset_collate;"; // ── NEW TABLE 2: generations — central AI cost/audit log ────────────── // Every AI operation across ALL features inserts a row here. // The `feature` column is MANDATORY on every insert. // Valid feature values: // title_generation | blog_generation | seo_analysis | // repurposing | internal_linking | brand_voice | // calendar | image_generation $statements[] = "CREATE TABLE wp_sfba_generations ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT UNSIGNED NOT NULL DEFAULT 0, user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, provider VARCHAR(64) NOT NULL DEFAULT '', model VARCHAR(128) NOT NULL DEFAULT '', feature VARCHAR(64) NOT NULL DEFAULT '', prompt_tokens INT UNSIGNED NOT NULL DEFAULT 0, completion_tokens INT UNSIGNED NOT NULL DEFAULT 0, cost_usd DECIMAL(10,6) NOT NULL DEFAULT 0.000000, content_type VARCHAR(64) NOT NULL DEFAULT 'blog', generation_time_ms INT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY post_id (post_id), KEY user_id (user_id), KEY provider (provider), KEY feature (feature), KEY created_at (created_at) ) $charset_collate;"; // ── NEW TABLE 3: content calendar ──────────────────────────────────── $statements[] = "CREATE TABLE wp_sfba_content_calendar ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(500) NOT NULL DEFAULT '', target_keyword VARCHAR(255) NOT NULL DEFAULT '', keyword_volume INT UNSIGNED NOT NULL DEFAULT 0, keyword_difficulty TINYINT UNSIGNED NOT NULL DEFAULT 0, suggested_date DATE NULL DEFAULT NULL, status VARCHAR(32) NOT NULL DEFAULT 'idea', post_id BIGINT UNSIGNED NOT NULL DEFAULT 0, source VARCHAR(32) NOT NULL DEFAULT 'manual', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY suggested_date (suggested_date) ) $charset_collate;"; // ── NEW TABLE 4: performance snapshots (Google Search Console) ──────── $statements[] = "CREATE TABLE wp_sfba_performance ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT UNSIGNED NOT NULL, week_start DATE NOT NULL, impressions INT UNSIGNED NOT NULL DEFAULT 0, clicks INT UNSIGNED NOT NULL DEFAULT 0, avg_position DECIMAL(5,2) NOT NULL DEFAULT 0.00, ctr DECIMAL(5,4) NOT NULL DEFAULT 0.0000, source VARCHAR(64) NOT NULL DEFAULT 'search_console', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY post_week (post_id, week_start), KEY post_id (post_id) ) $charset_collate;"; // ── NEW TABLE 5: model routing rules ────────────────────────────────── $statements[] = "CREATE TABLE wp_sfba_routing_rules ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, content_type VARCHAR(64) NOT NULL DEFAULT 'blog', provider VARCHAR(64) NOT NULL DEFAULT '', model VARCHAR(128) NOT NULL DEFAULT '', max_tokens INT UNSIGNED NOT NULL DEFAULT 4096, temperature DECIMAL(3,2) NOT NULL DEFAULT 0.70, priority TINYINT UNSIGNED NOT NULL DEFAULT 10, is_active TINYINT(1) NOT NULL DEFAULT 1, PRIMARY KEY (id), KEY content_type (content_type), KEY is_active (is_active) ) $charset_collate;"; // ── NEW TABLE 6: internal links (keyword index + accepted links) ─────── // Index rows : target_post_id = 0, status = 'indexed' (one per post) // Link records: target_post_id > 0, status = 'accepted' $statements[] = "CREATE TABLE wp_sfba_internal_links ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, source_post_id BIGINT UNSIGNED NOT NULL DEFAULT 0, target_post_id BIGINT UNSIGNED NOT NULL DEFAULT 0, anchor_text VARCHAR(500) NOT NULL DEFAULT '', target_url VARCHAR(2048) NOT NULL DEFAULT '', context LONGTEXT NOT NULL DEFAULT '', status VARCHAR(32) NOT NULL DEFAULT 'indexed', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY source_post_id (source_post_id), KEY target_post_id (target_post_id), KEY status (status) ) $charset_collate;"; foreach ( $statements as $sql ) { dbDelta( $sql );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_slf_schedule_post_title_log`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Super Fast Blog AI – AI Content Generator, Repurposer & SEO Writer