{"table_name":"arshid6social_xprofile_groups","full_table_name":"wp_arshid6social_xprofile_groups","description":"Stores arshid6social xprofile groups data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_arshid6social_xprofile_groups ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(150) NOT NULL DEFAULT '', description longtext, group_order int(11) NOT NULL DEFAULT 0, can_delete tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (id) ) $charset_collate;\"; // ── xProfile fields ───────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_xprofile_fields ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, group_id bigint(20) unsigned NOT NULL, parent_id bigint(20) unsigned NOT NULL DEFAULT 0, type varchar(64) NOT NULL DEFAULT 'textbox', name varchar(150) NOT NULL DEFAULT '', description longtext, is_required tinyint(1) NOT NULL DEFAULT 0, is_default_option tinyint(1) NOT NULL DEFAULT 0, field_order int(11) NOT NULL DEFAULT 0, option_order int(11) NOT NULL DEFAULT 0, can_delete tinyint(1) NOT NULL DEFAULT 1, visibility varchar(32) NOT NULL DEFAULT 'public', PRIMARY KEY (id), KEY group_id (group_id) ) $charset_collate;\"; // ── xProfile field data (user values) ─────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_xprofile_data ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, field_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NOT NULL, value longtext NOT NULL, last_updated datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY field_id_user_id (field_id, user_id), KEY user_id (user_id) ) $charset_collate;\"; // ── Activity items ─────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_activity ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL DEFAULT 0, component varchar(75) NOT NULL, type varchar(75) NOT NULL, action text NOT NULL, content longtext NOT NULL, primary_link varchar(2083) NOT NULL DEFAULT '', item_id bigint(20) NOT NULL DEFAULT 0, secondary_item_id bigint(20) NOT NULL DEFAULT 0, date_recorded datetime NOT NULL DEFAULT '0000-00-00 00:00:00', hide_sitewide tinyint(1) NOT NULL DEFAULT 0, mptt_left int(11) NOT NULL DEFAULT 0, mptt_right int(11) NOT NULL DEFAULT 0, is_spam tinyint(1) NOT NULL DEFAULT 0, privacy varchar(32) NOT NULL DEFAULT 'public', uid varchar(23) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY user_id (user_id), KEY component (component), KEY type (type), KEY date_recorded (date_recorded), KEY item_id (item_id), KEY secondary_item_id (secondary_item_id), KEY hide_sitewide (hide_sitewide), KEY uid (uid) ) $charset_collate;\"; // ── Activity meta ──────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_activity_meta ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, activity_id bigint(20) unsigned NOT NULL, meta_key varchar(255) DEFAULT NULL, meta_value longtext, PRIMARY KEY (id), KEY activity_id (activity_id), KEY meta_key (meta_key(191)) ) $charset_collate;\"; // ── Reactions / Likes ──────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_activity_reactions ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, activity_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NOT NULL, reaction_type varchar(32) NOT NULL DEFAULT 'like', date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY activity_user (activity_id, user_id), KEY user_id (user_id) ) $charset_collate;\"; // ── Groups ─────────────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_groups ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, creator_id bigint(20) unsigned NOT NULL, name varchar(200) NOT NULL, slug varchar(200) NOT NULL, description longtext NOT NULL, status varchar(10) NOT NULL DEFAULT 'public', is_suspended tinyint(1) NOT NULL DEFAULT 0, suspend_reason varchar(300) NOT NULL DEFAULT '', parent_id bigint(20) unsigned NOT NULL DEFAULT 0, enable_forum tinyint(1) NOT NULL DEFAULT 0, date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY slug (slug), KEY creator_id (creator_id), KEY status (status), KEY is_suspended (is_suspended) ) $charset_collate;\"; // ── Group members ──────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_groups_members ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, group_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NOT NULL, inviter_id bigint(20) unsigned NOT NULL DEFAULT 0, is_admin tinyint(1) NOT NULL DEFAULT 0, is_mod tinyint(1) NOT NULL DEFAULT 0, user_title varchar(100) NOT NULL DEFAULT '', date_modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00', comments longtext, is_confirmed tinyint(1) NOT NULL DEFAULT 1, is_banned tinyint(1) NOT NULL DEFAULT 0, invite_sent tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY group_user (group_id, user_id), KEY group_id (group_id), KEY user_id (user_id), KEY is_admin (is_admin), KEY is_mod (is_mod) ) $charset_collate;\"; // ── Group meta ─────────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_groups_groupmeta ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, group_id bigint(20) unsigned NOT NULL, meta_key varchar(255) DEFAULT NULL, meta_value longtext, PRIMARY KEY (id), KEY group_id (group_id), KEY meta_key (meta_key(191)) ) $charset_collate;\"; // ── Friends / connections ──────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_friends ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, initiator_user_id bigint(20) unsigned NOT NULL, friend_user_id bigint(20) unsigned NOT NULL, is_confirmed tinyint(1) NOT NULL DEFAULT 0, date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY initiator_friend (initiator_user_id, friend_user_id), KEY initiator_user_id (initiator_user_id), KEY friend_user_id (friend_user_id) ) $charset_collate;\"; // ── Follow relationships ───────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_follow ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, follower_id bigint(20) unsigned NOT NULL, followee_id bigint(20) unsigned NOT NULL, date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY follower_followee (follower_id, followee_id), KEY follower_id (follower_id), KEY followee_id (followee_id) ) $charset_collate;\"; // ── Blocks ─────────────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_blocks ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, blocker_id bigint(20) unsigned NOT NULL, blocked_id bigint(20) unsigned NOT NULL, reason text, date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY blocker_blocked (blocker_id, blocked_id), KEY blocker_id (blocker_id), KEY blocked_id (blocked_id) ) $charset_collate;\"; // ── Private messages (threads) ─────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_messages_threads ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, uniqid varchar(36) NOT NULL DEFAULT '', subject varchar(200) NOT NULL DEFAULT '', is_group tinyint(1) NOT NULL DEFAULT 0, date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY uniqid (uniqid) ) $charset_collate;\"; // ── Message recipients / inbox view ────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_messages_recipients ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, thread_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NOT NULL, unread_count int(11) NOT NULL DEFAULT 0, sender_only tinyint(1) NOT NULL DEFAULT 0, is_deleted tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY thread_user (thread_id, user_id), KEY user_id (user_id), KEY thread_id (thread_id) ) $charset_collate;\"; // ── Messages ───────────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_messages ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, thread_id bigint(20) unsigned NOT NULL, sender_id bigint(20) unsigned NOT NULL, message longtext NOT NULL, date_sent datetime NOT NULL DEFAULT '0000-00-00 00:00:00', is_deleted tinyint(1) NOT NULL DEFAULT 0, is_edited tinyint(1) NOT NULL DEFAULT 0, edited_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY thread_id (thread_id), KEY sender_id (sender_id), KEY date_sent (date_sent) ) $charset_collate;\"; $tables[] = \"CREATE TABLE wp_arshid6social_messages_hidden ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, message_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NOT NULL, PRIMARY KEY (id), UNIQUE KEY message_user (message_id, user_id) ) $charset_collate;\"; // ── Message meta ───────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_messages_meta ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, message_id bigint(20) unsigned NOT NULL, meta_key varchar(255) DEFAULT NULL, meta_value longtext, PRIMARY KEY (id), KEY message_id (message_id), KEY meta_key (meta_key(191)) ) $charset_collate;\"; // ── Notifications ──────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_notifications ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, item_id bigint(20) unsigned NOT NULL DEFAULT 0, secondary_item_id bigint(20) unsigned NOT NULL DEFAULT 0, component_name varchar(75) NOT NULL, component_action varchar(75) NOT NULL, date_notified datetime NOT NULL DEFAULT '0000-00-00 00:00:00', is_new tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (id), KEY user_id (user_id), KEY is_new (is_new), KEY component_name (component_name), KEY component_action (component_action) ) $charset_collate;\"; // ── Site invitations ───────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_invitations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, inviter_id bigint(20) unsigned NOT NULL, email varchar(100) NOT NULL DEFAULT '', invite_key varchar(64) NOT NULL DEFAULT '', status varchar(20) NOT NULL DEFAULT 'pending', date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', date_accepted datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY invite_key (invite_key), KEY inviter_id (inviter_id), KEY email (email), KEY status (status) ) $charset_collate;\"; // ── Activity media attachments ─────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_activity_media ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, activity_id bigint(20) unsigned NOT NULL, media_type varchar(32) NOT NULL DEFAULT 'image', file_url varchar(2083) NOT NULL DEFAULT '', file_path varchar(500) NOT NULL DEFAULT '', file_name varchar(255) NOT NULL DEFAULT '', file_size bigint(20) NOT NULL DEFAULT 0, mime_type varchar(100) NOT NULL DEFAULT '', date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY activity_id (activity_id), KEY media_type (media_type) ) $charset_collate;\"; // ── Reports / moderation ───────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_reports ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, reporter_id bigint(20) unsigned NOT NULL, item_id bigint(20) unsigned NOT NULL, item_type varchar(50) NOT NULL, reason varchar(200) NOT NULL DEFAULT '', notes text, attachment_url varchar(500) NOT NULL DEFAULT '', status varchar(20) NOT NULL DEFAULT 'pending', date_reported datetime NOT NULL DEFAULT '0000-00-00 00:00:00', date_resolved datetime DEFAULT NULL, resolved_by bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (id), KEY reporter_id (reporter_id), KEY item_id (item_id), KEY item_type (item_type), KEY status (status) ) $charset_collate;\"; // ── Stories ────────────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_stories ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, privacy varchar(32) NOT NULL DEFAULT 'public', close_friends tinyint(1) NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', expires_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', highlight_id bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY expires_at (expires_at), KEY highlight_id (highlight_id) ) $charset_collate;\"; $tables[] = \"CREATE TABLE wp_arshid6social_story_items ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, story_id bigint(20) unsigned NOT NULL, media_type varchar(32) NOT NULL DEFAULT 'text', attachment_id bigint(20) unsigned DEFAULT NULL, file_url varchar(2083) NOT NULL DEFAULT '', file_path varchar(500) NOT NULL DEFAULT '', text_content text, bg_color varchar(32) NOT NULL DEFAULT '#2563eb', overlays_json longtext, sort_order int(11) NOT NULL DEFAULT 0, duration int(11) NOT NULL DEFAULT 5, PRIMARY KEY (id), KEY story_id (story_id), KEY sort_order (sort_order) ) $charset_collate;\"; $tables[] = \"CREATE TABLE wp_arshid6social_story_views ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, story_item_id bigint(20) unsigned NOT NULL, viewer_id bigint(20) unsigned NOT NULL, viewed_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY item_viewer (story_item_id, viewer_id), KEY story_item_id (story_item_id), KEY viewer_id (viewer_id) ) $charset_collate;\"; $tables[] = \"CREATE TABLE wp_arshid6social_story_reactions ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, story_item_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NOT NULL, reaction varchar(32) NOT NULL DEFAULT 'like', created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY item_user (story_item_id, user_id), KEY story_item_id (story_item_id), KEY user_id (user_id) ) $charset_collate;\"; $tables[] = \"CREATE TABLE wp_arshid6social_story_highlights ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, title varchar(150) NOT NULL DEFAULT '', cover_url varchar(2083) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY user_id (user_id) ) $charset_collate;\"; $tables[] = \"CREATE TABLE wp_arshid6social_close_friends ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, friend_id bigint(20) unsigned NOT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY user_friend (user_id, friend_id), KEY user_id (user_id) ) $charset_collate;\"; $tables[] = \"CREATE TABLE wp_arshid6social_muted_stories ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, muted_user_id bigint(20) unsigned NOT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY user_muted (user_id, muted_user_id), KEY user_id (user_id) ) $charset_collate;\"; // ── Verification ───────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_verification_requests ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, type varchar(64) NOT NULL DEFAULT '', fields_json longtext, document_paths longtext, status varchar(20) NOT NULL DEFAULT 'pending', reviewer_id bigint(20) unsigned DEFAULT NULL, reason text, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', decided_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY status (status), KEY created_at (created_at) ) $charset_collate;\"; $tables[] = \"CREATE TABLE wp_arshid6social_verifications ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, type varchar(64) NOT NULL DEFAULT 'general', badge varchar(32) NOT NULL DEFAULT '✓', granted_by bigint(20) unsigned NOT NULL DEFAULT 0, granted_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', expires_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY user_id (user_id), KEY type (type), KEY expires_at (expires_at) ) $charset_collate;\"; // ── Ads ────────────────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_ads ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL DEFAULT '', ad_type varchar(20) NOT NULL DEFAULT 'image', file_url varchar(2083) NOT NULL DEFAULT '', click_url varchar(2083) NOT NULL DEFAULT '', js_code longtext NOT NULL, placement varchar(20) NOT NULL DEFAULT 'both', every_n_posts int(10) unsigned NOT NULL DEFAULT 5, impressions bigint(20) unsigned NOT NULL DEFAULT 0, clicks bigint(20) unsigned NOT NULL DEFAULT 0, status varchar(10) NOT NULL DEFAULT 'active', start_date date DEFAULT NULL, end_date date DEFAULT NULL, date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY status (status), KEY placement (placement) ) $charset_collate;\"; // ── Audit log ──────────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_audit_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL DEFAULT 0, action varchar(100) NOT NULL, object_type varchar(50) NOT NULL DEFAULT '', object_id bigint(20) unsigned NOT NULL DEFAULT 0, details longtext, ip_address varchar(45) NOT NULL DEFAULT '', date_created datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY user_id (user_id), KEY action (action), KEY date_created (date_created) ) $charset_collate;\"; // ── Social Embed cache ──────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_embed_cache ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, url_hash char(64) NOT NULL DEFAULT '', provider varchar(50) NOT NULL DEFAULT '', html longtext NOT NULL, data_json longtext NOT NULL, fetched_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', expires_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY url_hash (url_hash), KEY expires_at (expires_at) ) $charset_collate;\"; foreach ( $tables as $sql ) { dbDelta( $sql );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"description","type":"longtext","nullable":true,"primary_key":false},{"name":"group_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"can_delete","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"group_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"parent_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"description","type":"longtext","nullable":true,"primary_key":false},{"name":"is_required","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_default_option","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"field_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"option_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"can_delete","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"visibility","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"field_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"value","type":"longtext","nullable":false,"primary_key":false},{"name":"last_updated","type":"datetime","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"component","type":"varchar(75)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(75)","nullable":false,"primary_key":false},{"name":"action","type":"text","nullable":false,"primary_key":false},{"name":"content","type":"longtext","nullable":false,"primary_key":false},{"name":"primary_link","type":"varchar(2083)","nullable":false,"primary_key":false},{"name":"item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"secondary_item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"date_recorded","type":"datetime","nullable":false,"primary_key":false},{"name":"hide_sitewide","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"mptt_left","type":"int(11)","nullable":false,"primary_key":false},{"name":"mptt_right","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_spam","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"privacy","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"uid","type":"varchar(23)","nullable":false,"primary_key":false},{"name":"activity_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"activity_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"reaction_type","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"creator_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"description","type":"longtext","nullable":false,"primary_key":false},{"name":"status","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"is_suspended","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"suspend_reason","type":"varchar(300)","nullable":false,"primary_key":false},{"name":"parent_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"enable_forum","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"group_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"inviter_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"is_admin","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_mod","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"user_title","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"date_modified","type":"datetime","nullable":false,"primary_key":false},{"name":"comments","type":"longtext","nullable":true,"primary_key":false},{"name":"is_confirmed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_banned","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"invite_sent","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"group_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"initiator_user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"friend_user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"is_confirmed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"follower_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"followee_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"blocker_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"blocked_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"reason","type":"text","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"uniqid","type":"varchar(36)","nullable":false,"primary_key":false},{"name":"subject","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"is_group","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"thread_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"unread_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"sender_only","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_deleted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"thread_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"sender_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"message","type":"longtext","nullable":false,"primary_key":false},{"name":"date_sent","type":"datetime","nullable":false,"primary_key":false},{"name":"is_deleted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_edited","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"edited_at","type":"datetime","nullable":true,"primary_key":false},{"name":"message_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"message_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"secondary_item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"component_name","type":"varchar(75)","nullable":false,"primary_key":false},{"name":"component_action","type":"varchar(75)","nullable":false,"primary_key":false},{"name":"date_notified","type":"datetime","nullable":false,"primary_key":false},{"name":"is_new","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"inviter_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"invite_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"date_accepted","type":"datetime","nullable":true,"primary_key":false},{"name":"activity_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"media_type","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"file_url","type":"varchar(2083)","nullable":false,"primary_key":false},{"name":"file_path","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"file_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"file_size","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"mime_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"reporter_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"item_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"reason","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"attachment_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"date_reported","type":"datetime","nullable":false,"primary_key":false},{"name":"date_resolved","type":"datetime","nullable":true,"primary_key":false},{"name":"resolved_by","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"privacy","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"close_friends","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":false,"primary_key":false},{"name":"highlight_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"story_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"media_type","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"attachment_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"file_url","type":"varchar(2083)","nullable":false,"primary_key":false},{"name":"file_path","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"text_content","type":"text","nullable":true,"primary_key":false},{"name":"bg_color","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"overlays_json","type":"longtext","nullable":true,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"duration","type":"int(11)","nullable":false,"primary_key":false},{"name":"story_item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"viewer_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"viewed_at","type":"datetime","nullable":false,"primary_key":false},{"name":"story_item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"reaction","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"title","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"cover_url","type":"varchar(2083)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"friend_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"muted_user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"fields_json","type":"longtext","nullable":true,"primary_key":false},{"name":"document_paths","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"reviewer_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"reason","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"decided_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"badge","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"granted_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"granted_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ad_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"file_url","type":"varchar(2083)","nullable":false,"primary_key":false},{"name":"click_url","type":"varchar(2083)","nullable":false,"primary_key":false},{"name":"js_code","type":"longtext","nullable":false,"primary_key":false},{"name":"placement","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"every_n_posts","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"impressions","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"clicks","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"status","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"action","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"object_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"object_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"details","type":"longtext","nullable":true,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"url_hash","type":"char(64)","nullable":false,"primary_key":false},{"name":"provider","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"html","type":"longtext","nullable":false,"primary_key":false},{"name":"data_json","type":"longtext","nullable":false,"primary_key":false},{"name":"fetched_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"6arshid-social-community","name":"6Arshid Social Community","active_installs":0,"version":"1.8.3","wp_org_url":"https://wordpress.org/plugins/6arshid-social-community/"}}