wp_hrp_shifts
StaticStores hrp shifts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | bigint(20) UNSIGNED | NO |
| title | varchar(191) | YES |
| start_time | time | YES |
| end_time | time | YES |
| holidays | varchar(190) | YES |
| status | tinyint(1) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_hrp_shifts`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(191) DEFAULT NULL, `start_time` time DEFAULT NULL, `end_time` time DEFAULT NULL, `holidays` varchar(190) DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (ID), KEY `title` (`title`), KEY `start_time` (`start_time`), KEY `end_time` (`end_time`), KEY `status` (`status`) ) ENGINE
Safe to delete?
If you have uninstalled HR Press Lite, 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_hrp_shifts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from HR Press Lite