{"slug":"vacancy-lab","name":"Vacancy Lab","description":"Add Vacancy Search and Candidate submissions that are powered by Vacancy Lab onto your Wordpress website.","author":"jarrettandlam","active_installs":0,"version":"0.7","wp_org_url":"https://wordpress.org/plugins/vacancy-lab/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"candidates","full_table_name":"wp_candidates","description":"Stores candidates data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"title","type":"varchar(5)","nullable":false,"primary_key":false},{"name":"firstname","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"lastname","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"mobile","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"home","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"positionsought","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"dob","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"street","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"city","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"county","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"postcode","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"salary","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"permanent","type":"set('0','1')","nullable":false,"primary_key":false},{"name":"contract","type":"set('0','1')","nullable":false,"primary_key":false},{"name":"preferredloc","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"cv","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `candidates` ( `title` varchar(5) NOT NULL DEFAULT '', `firstname` varchar(32) NOT NULL DEFAULT '', `lastname` varchar(32) NOT NULL DEFAULT '', `email` varchar(255) NOT NULL DEFAULT '', `mobile` varchar(32) NOT NULL DEFAULT '', `home` varchar(32) NOT NULL DEFAULT '', `positionsought` varchar(32) NOT NULL DEFAULT '', `dob` varchar(10) NOT NULL DEFAULT '', `street` varchar(255) NOT NULL DEFAULT '', `city` varchar(32) NOT NULL DEFAULT '', `county` varchar(32) NOT NULL DEFAULT '', `postcode` varchar(32) NOT NULL DEFAULT '', `country` varchar(32) NOT NULL DEFAULT '', `salary` varchar(32) NOT NULL DEFAULT '', `permanent` set('0','1') NOT NULL DEFAULT '', `contract` set('0','1') NOT NULL DEFAULT '', `preferredloc` varchar(32) NOT NULL DEFAULT '', `cv` varchar(255), `message` text, UNIQUE KEY `email` (`email`) ) ENGINE"},{"table_name":"tblvacancies","full_table_name":"wp_tblvacancies","description":"Stores tblvacancies data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"WebLocation","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"Reference","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"Position","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"Salary","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"SalaryPeriod","type":"varchar(9)","nullable":true,"primary_key":false},{"name":"SalaryCurrency","type":"varchar(9)","nullable":true,"primary_key":false},{"name":"Consultant","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"Email","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"Skills","type":"text","nullable":true,"primary_key":false},{"name":"Location","type":"text","nullable":true,"primary_key":false},{"name":"Type","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"Description","type":"text","nullable":true,"primary_key":false},{"name":"CreDate","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `tblvacancies` ( `WebLocation` varchar(50) DEFAULT NULL, `Reference` varchar(20) NOT NULL DEFAULT '', `Position` varchar(100) DEFAULT NULL, `Salary` decimal(10,2) DEFAULT NULL, `SalaryPeriod` varchar(9) DEFAULT NULL, `SalaryCurrency` varchar(9) DEFAULT NULL, `Consultant` varchar(50) DEFAULT NULL, `Email` varchar(50) DEFAULT NULL, `Skills` text, `Location` text, `Type` varchar(10) DEFAULT NULL, `Description` text, `CreDate` datetime DEFAULT NULL, PRIMARY KEY (`Reference`) ) ENGINE"},{"table_name":"tblvacancies_temp","full_table_name":"wp_tblvacancies_temp","description":"Stores tblvacancies temp data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"WebLocation","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"Reference","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"Position","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"Salary","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"SalaryPeriod","type":"varchar(9)","nullable":true,"primary_key":false},{"name":"SalaryCurrency","type":"varchar(9)","nullable":true,"primary_key":false},{"name":"Consultant","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"Email","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"Skills","type":"text","nullable":true,"primary_key":false},{"name":"Location","type":"text","nullable":true,"primary_key":false},{"name":"Type","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"Description","type":"text","nullable":true,"primary_key":false},{"name":"CreDate","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `tblvacancies_temp` ( `WebLocation` varchar(50) DEFAULT NULL, `Reference` varchar(20) NOT NULL DEFAULT '', `Position` varchar(100) DEFAULT NULL, `Salary` decimal(10,2) DEFAULT NULL, `SalaryPeriod` varchar(9) DEFAULT NULL, `SalaryCurrency` varchar(9) DEFAULT NULL, `Consultant` varchar(50) DEFAULT NULL, `Email` varchar(50) DEFAULT NULL, `Skills` text, `Location` text, `Type` varchar(10) DEFAULT NULL, `Description` text, `CreDate` datetime DEFAULT NULL, PRIMARY KEY (`Reference`) ) ENGINE"}],"table_count":3}