wp_aipgp_skills

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_aipgp_skills ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, slug VARCHAR(191) NOT NULL, name VARCHAR(191) NOT NULL, version VARCHAR(32) NULL, task_types VARCHAR(255) NULL, source ENUM('bundled','uploaded','remote') NOT NULL, file_path VARCHAR(512) NULL, checksum VARCHAR(64) NULL, body LONGTEXT NULL, enabled TINYINT(1) DEFAULT 1, updated_at DATETIME NULL, KEY slug (slug) ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_sources ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, type ENUM('published_posts','uploaded_file','product_research','random') NOT NULL, config LONGTEXT NULL, enabled TINYINT(1) DEFAULT 1 ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_link_relations ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, product_slug VARCHAR(191) NULL, label VARCHAR(191) NULL, type VARCHAR(64) NULL, url VARCHAR(512) NULL, notes TEXT NULL, KEY product_slug (product_slug) ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_generation_jobs ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, source_id BIGINT UNSIGNED NULL, source_type VARCHAR(64) NULL, topic LONGTEXT NULL, status VARCHAR(64) NOT NULL DEFAULT 'pending', post_id BIGINT UNSIGNED NULL, tokens_in INT UNSIGNED DEFAULT 0, tokens_out INT UNSIGNED DEFAULT 0, step_data LONGTEXT NULL, error_log TEXT NULL, scheduled_at DATETIME NULL, created_at DATETIME NULL, updated_at DATETIME NULL, KEY status (status), KEY status_scheduled (status, scheduled_at), KEY updated_at (updated_at), KEY post_id (post_id) ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_generation_logs ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, job_id BIGINT UNSIGNED NULL, step VARCHAR(64) NULL, provider VARCHAR(64) NULL, model VARCHAR(64) NULL, tokens_in INT NULL, tokens_out INT NULL, raw_response LONGTEXT NULL, created_at DATETIME NULL, KEY job_id (job_id) ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_social_drafts ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NULL, platform VARCHAR(32) NULL, content LONGTEXT NULL, source VARCHAR(32) DEFAULT 'ai', status ENUM('draft','approved','published','n/a') DEFAULT 'draft', scheduled_publish_at DATETIME NULL, auto_publish TINYINT(1) DEFAULT 0, profile_keys TEXT NULL, template_id BIGINT UNSIGNED NULL, share_count INT DEFAULT 0, last_shared_at DATETIME NULL, created_at DATETIME NULL, updated_at DATETIME NULL, KEY post_id (post_id) ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_social_profiles ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, platform VARCHAR(32) NOT NULL, profile_key VARCHAR(191) NOT NULL, profile_id VARCHAR(191) NULL, name VARCHAR(255) NULL, username VARCHAR(255) NULL, thumbnail_url VARCHAR(512) NULL, account_type VARCHAR(32) NULL, status TINYINT(1) DEFAULT 1, app_id VARCHAR(255) NULL, app_secret TEXT NULL, access_token LONGTEXT NULL, refresh_token LONGTEXT NULL, token_expires_at DATETIME NULL, platform_settings LONGTEXT NULL, created_by BIGINT UNSIGNED NULL, created_at DATETIME NULL, updated_at DATETIME NULL, UNIQUE KEY uq_profile_key (profile_key), KEY idx_platform (platform), KEY idx_status (status) ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_social_queue ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL, draft_id BIGINT UNSIGNED NULL, platform VARCHAR(32) NOT NULL, profile_key VARCHAR(191) NOT NULL, content LONGTEXT NULL, media_urls TEXT NULL, status VARCHAR(32) NOT NULL DEFAULT 'pending', scheduled_at DATETIME NULL, published_at DATETIME NULL, platform_post_id VARCHAR(255) NULL, platform_post_url VARCHAR(512) NULL, error_message TEXT NULL, retry_count INT DEFAULT 0, created_at DATETIME NULL, updated_at DATETIME NULL, KEY idx_post_id (post_id), KEY idx_status_scheduled (status, scheduled_at), KEY idx_platform (platform), KEY idx_profile_key (profile_key) ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_social_templates ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, platform VARCHAR(32) NOT NULL, name VARCHAR(191) NOT NULL, template_structure LONGTEXT NOT NULL, content_type VARCHAR(32) DEFAULT 'statuswithlink', content_source VARCHAR(32) DEFAULT 'content', character_limit INT DEFAULT 280, include_featured_image TINYINT(1) DEFAULT 1, include_categories_as_tags TINYINT(1) DEFAULT 1, clean_html_and_shortcodes TINYINT(1) DEFAULT 1, is_default TINYINT(1) DEFAULT 0, created_at DATETIME NULL, updated_at DATETIME NULL, KEY idx_platform (platform), UNIQUE KEY uq_platform_name (platform, name) ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_schedule_slots ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, day_of_week TINYINT UNSIGNED NOT NULL, time_slot TIME NOT NULL, post_types VARCHAR(255) DEFAULT 'post', category_ids TEXT NULL, is_active TINYINT(1) DEFAULT 1, created_at DATETIME NULL, KEY idx_day_time (day_of_week, time_slot), KEY idx_active (is_active) ) $charset_collate;"; $sql[] = "CREATE TABLE wp_aipgp_email_logs ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL, event_type VARCHAR(32) NOT NULL, recipient_email VARCHAR(255) NOT NULL, recipient_name VARCHAR(255) NULL, recipient_role VARCHAR(64) NULL, subject VARCHAR(255) NULL, status VARCHAR(32) DEFAULT 'sent', error_message TEXT NULL, sent_at DATETIME NULL, KEY idx_post_event (post_id, event_type), KEY idx_sent_at (sent_at) ) $charset_collate;"; foreach ( $sql as $statement ) { dbDelta( $statement );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_aipgp_skills`;

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

Other tables from Postloom – AI Post Generator and Publisher | Autonomous Post Publishing Engine