wp_hrp_attendances
StaticStores hrp attendances data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | bigint(20) UNSIGNED | NO |
| employee_id | bigint(20) | YES |
| checkin | time | YES |
| checkout | time | YES |
| breakin | time | YES |
| breakout | time | YES |
| date | date | YES |
| comment | text | YES |
| status | tinyint(1) | YES |
| ip_address | text | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_hrp_attendances`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `employee_id` bigint(20) DEFAULT NULL, `checkin` time DEFAULT NULL, `checkout` time DEFAULT NULL, `breakin` time DEFAULT NULL, `breakout` time DEFAULT NULL, `date` date NULL DEFAULT NULL, `comment` text DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, ip_address text DEFAULT NULL, PRIMARY KEY (ID), KEY employee_id (employee_id), KEY `date` (`date`) ) 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_attendances`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from HR Press Lite