wp_arshid6social_xprofile_groups

Column Definitions

CREATE TABLE Statement

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 );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_arshid6social_xprofile_groups`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from 6Arshid Social Community