{"table_name":"batchpilot_operations","full_table_name":"wp_batchpilot_operations","description":"Stores batchpilot operations data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_batchpilot_operations ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, type VARCHAR(64) NOT NULL, target VARCHAR(64) NOT NULL, user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, filters_json LONGTEXT NULL, params_json LONGTEXT NULL, queued_ids_json LONGTEXT NULL, affected_count INT UNSIGNED NOT NULL DEFAULT 0, affected_ids_json LONGTEXT NULL, status VARCHAR(32) NOT NULL DEFAULT 'pending', error_message TEXT NULL, created_at DATETIME NOT NULL, completed_at DATETIME NULL, PRIMARY KEY (id), KEY user_created (user_id, created_at), KEY status (status) ) {$charset_collate};\"; $snapshots = \"CREATE TABLE wp_batchpilot_snapshots ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, operation_id BIGINT UNSIGNED NOT NULL, object_type VARCHAR(64) NOT NULL, object_id BIGINT UNSIGNED NOT NULL, field VARCHAR(64) NOT NULL, old_value LONGTEXT NULL, PRIMARY KEY (id), KEY operation_id (operation_id), KEY object (object_type, object_id) ) {$charset_collate};\"; $schedules = \"CREATE TABLE wp_batchpilot_schedules ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, operation_type VARCHAR(64) NOT NULL, target_type VARCHAR(64) NOT NULL, filters_json LONGTEXT NULL, params_json LONGTEXT NULL, recurrence_json LONGTEXT NULL, action_scheduler_id BIGINT UNSIGNED NULL, enabled TINYINT(1) NOT NULL DEFAULT 1, last_run_at DATETIME NULL, next_run_at DATETIME NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), KEY enabled_next_run (enabled, next_run_at) ) {$charset_collate};\"; dbDelta( $operations );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"type","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"target","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"filters_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"params_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"queued_ids_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"affected_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"affected_ids_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"error_message","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"completed_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"operation_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"object_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"field","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"old_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"operation_type","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"target_type","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"filters_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"params_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"recurrence_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"action_scheduler_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"enabled","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"last_run_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"next_run_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"batchpilot","name":"BatchPilot","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/batchpilot/"}}