wp_erp_holidays_indv
StaticStores erp holidays indv data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| holiday_id | int(11) | YES |
| title | varchar(255) | YES |
| date | date | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| user_id | int(11) | YES |
| request_id | int(11) | YES |
| title | varchar(255) | YES |
| date | date | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_erp_holidays_indv` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `holiday_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_user_leaves` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `request_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { dbDelta( $table );Safe to delete?
If you have uninstalled ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support, 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_erp_holidays_indv`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support