wp_tblvacancies
StaticStores tblvacancies data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| WebLocation | varchar(50) | YES |
| Reference | varchar(20) | NO |
| Position | varchar(100) | YES |
| Salary | decimal(10,2) | YES |
| SalaryPeriod | varchar(9) | YES |
| SalaryCurrency | varchar(9) | YES |
| Consultant | varchar(50) | YES |
| varchar(50) | YES | |
| Skills | text | YES |
| Location | text | YES |
| Type | varchar(10) | YES |
| Description | text | YES |
| CreDate | datetime | YES |
CREATE TABLE Statement
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
Safe 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_tblvacancies`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Vacancy Lab