{"slug":"kanpress","name":"Kanpress","description":"A kanban board for managing the creation of Wordpress posts","author":"Isra","active_installs":10,"version":"1.1","wp_org_url":"https://wordpress.org/plugins/kanpress/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"kanpress_task","full_table_name":"wp_kanpress_task","description":"Stores kanpress task data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kanpress_task` (\\n  `task_id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `proposed_by` bigint unsigned NOT NULL,\\n  `assigned_to` bigint unsigned DEFAULT NULL,\\n  `revised_by` bigint unsigned DEFAULT NULL,\\n  `term_id` bigint unsigned NOT NULL,\\n  `post_id` bigint unsigned DEFAULT NULL,\\n  `priority` tinyint unsigned NOT NULL,\\n  `status` tinyint unsigned NOT NULL COMMENT '0=propuesta, 1=asignada, 2=pendiente, 3=terminada',\\n  `summary` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,\\n  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,\\n  `time_proposed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  `time_assigned` timestamp NULL DEFAULT '0000-00-00 00:00:00',\\n  `time_done` timestamp NULL DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`task_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"}],"table_count":1}