{"table_name":"candidates","full_table_name":"wp_candidates","description":"Stores candidates data created by this plugin.","detection_method":"static","confidence":"high","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","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}],"plugin":{"slug":"vacancy-lab","name":"Vacancy Lab","active_installs":0,"version":"0.7","wp_org_url":"https://wordpress.org/plugins/vacancy-lab/"}}