{"slug":"intranetos-employee-intranet","name":"IntranetOS Employee Intranet with Entra ID","description":"Employee intranet for WordPress + Microsoft 365: Entra ID SSO, directory sync, unified search, intranet blocks and a full engagement pack. 100% free.","author":"wadimelouk","active_installs":0,"version":"1.12.1","wp_org_url":"https://wordpress.org/plugins/intranetos-employee-intranet/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"eicp_announcements","full_table_name":"wp_eicp_announcements","description":"Stores eicp announcements data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"eicp_employees","full_table_name":"wp_eicp_employees","description":"Stores eicp employees data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"entra_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"display_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"job_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"department","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"manager_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"birthday","type":"date","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"photo_url","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"hash","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"last_sync","type":"datetime","nullable":true,"primary_key":false},{"name":"synced_at","type":"datetime","nullable":true,"primary_key":false},{"name":"module","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"items_synced","type":"int(11)","nullable":true,"primary_key":false},{"name":"error_json","type":"text","nullable":true,"primary_key":false},{"name":"started_at","type":"datetime","nullable":true,"primary_key":false},{"name":"finished_at","type":"datetime","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"body","type":"text","nullable":false,"primary_key":false},{"name":"author_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"is_pinned","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"sender_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"recipient_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"recipient_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"recipient_email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"message","type":"text","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"question","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"options","type":"text","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"poll_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"option_index","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"question","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"answer","type":"text","nullable":false,"primary_key":false},{"name":"category","type":"varchar(190)","nullable":true,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"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 );"},{"table_name":"eicp_faqs","full_table_name":"wp_eicp_faqs","description":"Stores eicp faqs data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"eicp_kudos","full_table_name":"wp_eicp_kudos","description":"Stores eicp kudos data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"eicp_poll_votes","full_table_name":"wp_eicp_poll_votes","description":"Stores eicp poll votes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"eicp_polls","full_table_name":"wp_eicp_polls","description":"Stores eicp polls data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"eicp_sync_logs","full_table_name":"wp_eicp_sync_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":7}