wp_eicp_employees
StaticStores eicp employees data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| entra_id | varchar(255) | NO |
| display_name | varchar(255) | NO |
| varchar(255) | NO | |
| job_title | varchar(255) | YES |
| department | varchar(255) | YES |
| manager_id | varchar(255) | YES |
| birthday | date | YES |
| start_date | date | YES |
| photo_url | varchar(500) | YES |
| hash | varchar(64) | YES |
| last_sync | datetime | YES |
| synced_at | datetime | YES |
| module | varchar(100) | NO |
| status | varchar(50) | NO |
| items_synced | int(11) | YES |
| error_json | text | YES |
| started_at | datetime | YES |
| finished_at | datetime | YES |
| title | varchar(255) | NO |
| body | text | NO |
| author_id | bigint(20) | NO |
| is_pinned | tinyint(1) | YES |
| created_at | datetime | YES |
| sender_id | bigint(20) | NO |
| recipient_id | bigint(20) | NO |
| recipient_name | varchar(255) | YES |
| recipient_email | varchar(255) | YES |
| message | text | NO |
| created_at | datetime | YES |
| question | varchar(500) | NO |
| options | text | NO |
| is_active | tinyint(1) | YES |
| created_at | datetime | YES |
| poll_id | bigint(20) | NO |
| user_id | bigint(20) | NO |
| option_index | int(11) | NO |
| created_at | datetime | YES |
| question | varchar(500) | NO |
| answer | text | NO |
| category | varchar(190) | YES |
| sort_order | int(11) | YES |
| created_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_eicp_employees ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, entra_id varchar(255) NOT NULL, display_name varchar(255) NOT NULL, email varchar(255) NOT NULL, job_title varchar(255) DEFAULT '', department varchar(255) DEFAULT '', manager_id varchar(255) DEFAULT '', birthday date DEFAULT NULL, start_date date DEFAULT NULL, photo_url varchar(500) DEFAULT '', hash varchar(64) DEFAULT '', last_sync datetime DEFAULT NULL, synced_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY entra_id (entra_id) ) $charset_collate;"; $tables[] = "CREATE TABLE wp_eicp_sync_logs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, module varchar(100) NOT NULL, status varchar(50) NOT NULL, items_synced int(11) DEFAULT 0, error_json text, started_at datetime DEFAULT NULL, finished_at datetime DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;"; // Engagement Pack tables. $tables[] = "CREATE TABLE wp_eicp_announcements ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, body text NOT NULL, author_id bigint(20) NOT NULL DEFAULT 0, is_pinned tinyint(1) DEFAULT 0, created_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY is_pinned (is_pinned) ) $charset_collate;"; $tables[] = "CREATE TABLE wp_eicp_kudos ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, sender_id bigint(20) NOT NULL, recipient_id bigint(20) NOT NULL, recipient_name varchar(255) DEFAULT '', recipient_email varchar(255) DEFAULT '', message text NOT NULL, created_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY recipient_id (recipient_id) ) $charset_collate;"; $tables[] = "CREATE TABLE wp_eicp_polls ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, question varchar(500) NOT NULL, options text NOT NULL, is_active tinyint(1) DEFAULT 1, created_at datetime DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;"; $tables[] = "CREATE TABLE wp_eicp_poll_votes ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, poll_id bigint(20) NOT NULL, user_id bigint(20) NOT NULL, option_index int(11) NOT NULL DEFAULT 0, created_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY poll_user (poll_id,user_id) ) $charset_collate;"; $tables[] = "CREATE TABLE wp_eicp_faqs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, question varchar(500) NOT NULL, answer text NOT NULL, category varchar(190) DEFAULT 'General', sort_order int(11) DEFAULT 0, created_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY category (category) ) $charset_collate;"; foreach ( $tables as $sql ) { dbDelta( $sql );Safe to delete?
If you have uninstalled IntranetOS Employee Intranet with Entra ID, 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_eicp_employees`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from IntranetOS Employee Intranet with Entra ID