wp_hrp_announcements
StaticStores hrp announcements data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | bigint(20) UNSIGNED | NO |
| title | varchar(190) | YES |
| send_to | varchar(190) | YES |
| announcement | text | YES |
| announced_to | text | YES |
| created_at | datetime | NO |
| updated_at | datetime | NO |
| user_id | bigint(20) | YES |
| status | tinyint(1) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_hrp_announcements`( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(190) DEFAULT NULL, send_to varchar(190) DEFAULT NULL, announcement text DEFAULT NULL, announced_to text DEFAULT NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, `user_id` bigint(20) DEFAULT NULL, `status` tinyint(1) DEFAULT 1, PRIMARY KEY (ID), KEY send_to (send_to) ) 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_announcements`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from HR Press Lite