wp_tblvacancies_temp

Static

Stores tblvacancies temp data created by this plugin.

Column Definitions

ColumnTypeNullable
WebLocationvarchar(50)YES
Referencevarchar(20)NO
Positionvarchar(100)YES
Salarydecimal(10,2)YES
SalaryPeriodvarchar(9)YES
SalaryCurrencyvarchar(9)YES
Consultantvarchar(50)YES
Emailvarchar(50)YES
SkillstextYES
LocationtextYES
Typevarchar(10)YES
DescriptiontextYES
CreDatedatetimeYES

CREATE TABLE Statement

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

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_temp`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Vacancy Lab