{"slug":"awesome-project-manager","name":"Awesome Project Manager","description":"A Single Page(SPA) WordPress project management plugin in WordPress plugin repository. Built with cutting edge technologies like VueJs.","author":"Rokib","active_installs":10,"version":"1.0.6","wp_org_url":"https://wordpress.org/plugins/awesome-project-manager/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"fpm_activities","full_table_name":"wp_fpm_activities","description":"Stores fpm activities data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"userID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"projectID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"parentID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"activity_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"activity_type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"activity","type":"text","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fpm_activities` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `userID` int(11) unsigned, `user_name` varchar(100), `projectID` int(11) unsigned, `parentID` int(11) unsigned, `activity_id` int(11) unsigned, `activity_type` varchar(50), `activity` text, `created` datetime, PRIMARY KEY (`ID`) ) ENGINE"},{"table_name":"fpm_comments","full_table_name":"wp_fpm_comments","description":"Stores fpm comments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"userID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"projectID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"commentable_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"commentable_type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"comment","type":"text","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fpm_comments` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `userID` int(11) unsigned, `user_name` varchar(100), `projectID` int(11) unsigned, `commentable_id` int(11) unsigned, `commentable_type` varchar(50), `comment` text, `created` datetime, PRIMARY KEY (`ID`) ) ENGINE"},{"table_name":"fpm_folders","full_table_name":"wp_fpm_folders","description":"Stores fpm folders data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"folder_title","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"file_ids","type":"longtext","nullable":true,"primary_key":false},{"name":"projectID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"project_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"userID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"is_archive","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fpm_folders` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `folder_title` varchar(250), `file_ids` longtext, `projectID` int(11) unsigned, `project_title` varchar(255), `userID` int(11) unsigned, `user_name` varchar(100), `is_archive` tinyint(1) NOT NULL DEFAULT '0', `created` datetime, PRIMARY KEY (`ID`) ) ENGINE"},{"table_name":"fpm_lists","full_table_name":"wp_fpm_lists","description":"Stores fpm lists data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"list_title","type":"varchar(300)","nullable":true,"primary_key":false},{"name":"userID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"projectID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fpm_lists` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `list_title` varchar(300), `userID` int(11) unsigned, `user_name` varchar(100), `projectID` int(11) unsigned, `created` datetime, PRIMARY KEY (`ID`) ) ENGINE"},{"table_name":"fpm_messages","full_table_name":"wp_fpm_messages","description":"Stores fpm messages data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"message_title","type":"varchar(300)","nullable":true,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false},{"name":"userID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"projectID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"project_title","type":"varchar(300)","nullable":true,"primary_key":false},{"name":"file_ids","type":"longtext","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fpm_messages` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `message_title` varchar(300), `message` text, `userID` int(11) unsigned, `projectID` int(11) unsigned, `user_name` varchar(100), `project_title` varchar(300), `file_ids` longtext, `created` datetime, PRIMARY KEY (`ID`) ) ENGINE"},{"table_name":"fpm_project_user","full_table_name":"wp_fpm_project_user","description":"Stores fpm project user data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"userID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"projectID","type":"int(11) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fpm_project_user` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `userID` int(11) unsigned, `projectID` int(11) unsigned, PRIMARY KEY (`ID`) ) ENGINE"},{"table_name":"fpm_projects","full_table_name":"wp_fpm_projects","description":"Stores fpm projects data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"project_title","type":"varchar(300)","nullable":true,"primary_key":false},{"name":"project_desc","type":"text","nullable":true,"primary_key":false},{"name":"userID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false},{"name":"is_complete","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fpm_projects` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `project_title` varchar(300), `project_desc` text, `userID` int(11) unsigned, `created` datetime, `is_complete` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE"},{"table_name":"fpm_subtasks","full_table_name":"wp_fpm_subtasks","description":"Stores fpm subtasks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"subtask","type":"text","nullable":true,"primary_key":false},{"name":"todoID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"userID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"is_complete","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fpm_subtasks` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `subtask` text, `todoID` int(11) unsigned, `userID` int(11) unsigned, `is_complete` tinyint(1) NOT NULL DEFAULT '0', `created` datetime, PRIMARY KEY (`ID`) ) ENGINE"},{"table_name":"fpm_todos","full_table_name":"wp_fpm_todos","description":"Stores fpm todos data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"todo","type":"text","nullable":true,"primary_key":false},{"name":"is_complete","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"listID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"userID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"assignee_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"assigneeID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"projectID","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"file_ids","type":"longtext","nullable":true,"primary_key":false},{"name":"due_date","type":"datetime","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fpm_todos` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `todo` text, `is_complete` tinyint(1) NOT NULL DEFAULT '0', `listID` int(11) unsigned, `userID` int(11) unsigned, `user_name` varchar(100), `assignee_name` varchar(100), `assigneeID` int(11) unsigned, `projectID` int(11) unsigned, `file_ids` longtext, `due_date` datetime, `created` datetime, PRIMARY KEY (`ID`) ) ENGINE"}],"table_count":9}