wp_candidates
StaticStores candidates data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| title | varchar(5) | NO |
| firstname | varchar(32) | NO |
| lastname | varchar(32) | NO |
| varchar(255) | NO | |
| mobile | varchar(32) | NO |
| home | varchar(32) | NO |
| positionsought | varchar(32) | NO |
| dob | varchar(10) | NO |
| street | varchar(255) | NO |
| city | varchar(32) | NO |
| county | varchar(32) | NO |
| postcode | varchar(32) | NO |
| country | varchar(32) | NO |
| salary | varchar(32) | NO |
| permanent | set('0','1') | NO |
| contract | set('0','1') | NO |
| preferredloc | varchar(32) | NO |
| cv | varchar(255) | YES |
| message | text | YES |
CREATE TABLE Statement
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`) ) ENGINESafe to delete?
If you have uninstalled Vacancy Lab, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_candidates`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Vacancy Lab