{"slug":"grand-job","name":"Grand Job","description":"This plugin is used to create a job board site with lots of powerful functions","author":"SFThemes","active_installs":10,"version":"1.2.1","wp_org_url":"https://wordpress.org/plugins/grand-job/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"gj_email_queue","full_table_name":"wp_gj_email_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"send_time","type":"int(11)","nullable":false,"primary_key":false},{"name":"priority","type":"tinyint(3)","nullable":false,"primary_key":false},{"name":"attemp","type":"tinyint(3)","nullable":false,"primary_key":false},{"name":"from_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"from_address","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"recipients","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"subject","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"content","type":"text","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gj_email_queue ( `ID` int(11) NOT NULL AUTO_INCREMENT, `send_time` int(11) NOT NULL, `priority` tinyint(3) NOT NULL, `attemp` tinyint(3) NOT NULL, `from_name` varchar(255) NOT NULL, `from_address` varchar(255) NOT NULL, `recipients` varchar(255) NOT NULL, `subject` varchar(255) NOT NULL, `content` text NOT NULL, PRIMARY KEY (`ID`) ) $collate;\"; dbDelta($sql);"},{"table_name":"gj_follows","full_table_name":"wp_gj_follows","description":"Stores gj follows data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gj_follows ( `ID` int(11) NOT NULL AUTO_INCREMENT, `post_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `Post ID` (`post_id`), KEY `User ID` (`user_id`) ) $collate;\"; dbDelta($sql);"},{"table_name":"gj_save_jobs","full_table_name":"wp_gj_save_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gj_save_jobs ( `ID` int(11) NOT NULL AUTO_INCREMENT, `post_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `Post ID` (`post_id`), KEY `User ID` (`user_id`) ) $collate;\"; dbDelta($sql);"},{"table_name":"gj_save_resums","full_table_name":"wp_gj_save_resums","description":"Stores gj save resums data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gj_save_resums ( `ID` int(11) NOT NULL AUTO_INCREMENT, `post_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `Post ID` (`post_id`), KEY `User ID` (`user_id`) ) $collate;\"; dbDelta($sql);"}],"table_count":4}