{"slug":"all-sources-images","name":"All Sources Images – Free Images from Pixabay, Unsplash, Openverse, Pexels & Giphy","description":"Search Pixabay and Unsplash images, set automatic featured images, and generate AI images for WordPress posts.","author":"Esteban","active_installs":600,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/all-sources-images/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"allsi_bulk_jobs","full_table_name":"wp_allsi_bulk_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ALLSI_bulk_jobs` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `job_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `job_status` enum('pending','processing','paused','completed','failed','cancelled') COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `total_posts` int unsigned DEFAULT '0',\\n  `processed_posts` int unsigned DEFAULT '0',\\n  `successful_posts` int unsigned DEFAULT '0',\\n  `failed_posts` int unsigned DEFAULT '0',\\n  `images_per_post` int unsigned DEFAULT '1',\\n  `selection_mode` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'custom',\\n  `post_types` text COLLATE utf8mb4_unicode_520_ci,\\n  `settings` text COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `started_at` datetime DEFAULT NULL,\\n  `completed_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  `created_by` bigint unsigned DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `job_status` (`job_status`),\\n  KEY `created_at` (`created_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"allsi_bulk_posts","full_table_name":"wp_allsi_bulk_posts","description":"Stores allsi bulk posts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_ALLSI_bulk_posts` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `job_id` bigint unsigned NOT NULL,\\n  `post_id` bigint unsigned NOT NULL,\\n  `post_type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `post_title` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` enum('pending','processing','completed','failed','skipped') COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `retry_count` tinyint unsigned DEFAULT '0',\\n  `featured_image_id` bigint unsigned DEFAULT NULL,\\n  `featured_image_status` enum('pending','completed','failed','skipped') COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `additional_images` text COLLATE utf8mb4_unicode_520_ci,\\n  `error_message` text COLLATE utf8mb4_unicode_520_ci,\\n  `search_keyword` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `image_source` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `processed_at` datetime DEFAULT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `job_id` (`job_id`),\\n  KEY `post_id` (`post_id`),\\n  KEY `status` (`status`),\\n  CONSTRAINT `wp_ALLSI_bulk_posts_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `wp_ALLSI_bulk_jobs` (`id`) ON DELETE CASCADE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":2}