{"slug":"6arshid-social-community","name":"6Arshid Social Community","description":"Build a fast, secure WordPress social network with member profiles, activity feeds, groups, messaging, notifications, polls, moderation, and more.","author":"6arshid","active_installs":0,"version":"1.8.3","wp_org_url":"https://wordpress.org/plugins/6arshid-social-community/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"arshid6social_activity","full_table_name":"wp_arshid6social_activity","description":"Stores arshid6social activity data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_activity_media","full_table_name":"wp_arshid6social_activity_media","description":"Stores arshid6social activity media data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_activity_meta","full_table_name":"wp_arshid6social_activity_meta","description":"Stores additional metadata (key-value pairs) for arshid6social activity records.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_activity_reactions","full_table_name":"wp_arshid6social_activity_reactions","description":"Stores arshid6social activity reactions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_ads","full_table_name":"wp_arshid6social_ads","description":"Stores arshid6social ads data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_attachments","full_table_name":"wp_arshid6social_attachments","description":"Stores arshid6social attachments data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"parent_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"parent_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"file_url","type":"VARCHAR(500)","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 UNSIGNED","nullable":false,"primary_key":false},{"name":"mime_type","type":"VARCHAR(127)","nullable":false,"primary_key":false},{"name":"media_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"uploader_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"wp_attachment_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_attachments ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, parent_id BIGINT UNSIGNED NOT NULL, parent_type VARCHAR(20) NOT NULL DEFAULT 'comment', file_url VARCHAR(500) NOT NULL, file_path VARCHAR(500) NOT NULL DEFAULT '', file_name VARCHAR(255) NOT NULL, file_size BIGINT UNSIGNED NOT NULL DEFAULT 0, mime_type VARCHAR(127) NOT NULL, media_type VARCHAR(20) NOT NULL DEFAULT 'file', uploader_id BIGINT UNSIGNED NOT NULL, wp_attachment_id BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY parent (parent_id, parent_type), KEY uploader_id (uploader_id) ) $charset;\" );"},{"table_name":"arshid6social_audit_log","full_table_name":"wp_arshid6social_audit_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_blocks","full_table_name":"wp_arshid6social_blocks","description":"Stores arshid6social blocks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_bookmark_collections","full_table_name":"wp_arshid6social_bookmark_collections","description":"Stores arshid6social bookmark collections data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_bookmark_collections ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, name VARCHAR(191) NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id) ) $charset;\" );"},{"table_name":"arshid6social_bookmarks","full_table_name":"wp_arshid6social_bookmarks","description":"Stores arshid6social bookmarks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"object_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"collection_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_bookmarks ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, object_id BIGINT UNSIGNED NOT NULL, object_type VARCHAR(50) NOT NULL DEFAULT 'activity', collection_id BIGINT UNSIGNED DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY user_object (user_id, object_id, object_type), KEY user_id (user_id), KEY collection_id (collection_id) ) $charset;\" );"},{"table_name":"arshid6social_categories","full_table_name":"wp_arshid6social_categories","description":"Stores arshid6social categories data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_close_friends","full_table_name":"wp_arshid6social_close_friends","description":"Stores arshid6social close friends data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_embed_cache","full_table_name":"wp_arshid6social_embed_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_favorites","full_table_name":"wp_arshid6social_favorites","description":"Stores arshid6social favorites data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_follow","full_table_name":"wp_arshid6social_follow","description":"Stores arshid6social follow data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_friends","full_table_name":"wp_arshid6social_friends","description":"Stores arshid6social friends data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_groups","full_table_name":"wp_arshid6social_groups","description":"Stores arshid6social groups data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_groups_groupmeta","full_table_name":"wp_arshid6social_groups_groupmeta","description":"Stores arshid6social groups groupmeta data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_groups_members","full_table_name":"wp_arshid6social_groups_members","description":"Stores arshid6social groups members data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_hashtag_follows","full_table_name":"wp_arshid6social_hashtag_follows","description":"Stores arshid6social hashtag follows data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"hashtag_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_hashtag_follows ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, hashtag_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY hashtag_user (hashtag_id, user_id) ) $charset;\" );"},{"table_name":"arshid6social_hashtag_relations","full_table_name":"wp_arshid6social_hashtag_relations","description":"Stores arshid6social hashtag relations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"hashtag_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"object_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_hashtag_relations ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, hashtag_id BIGINT UNSIGNED NOT NULL, object_id BIGINT UNSIGNED NOT NULL, object_type VARCHAR(50) NOT NULL DEFAULT 'activity', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY hashtag_id (hashtag_id), KEY object_id_type (object_id, object_type) ) $charset;\" );"},{"table_name":"arshid6social_hashtags","full_table_name":"wp_arshid6social_hashtags","description":"Stores arshid6social hashtags data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"hashtag","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_hashtags ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, hashtag VARCHAR(191) NOT NULL, slug VARCHAR(191) NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY slug (slug) ) $charset;\" );"},{"table_name":"arshid6social_invitations","full_table_name":"wp_arshid6social_invitations","description":"Stores arshid6social invitations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_listing_media","full_table_name":"wp_arshid6social_listing_media","description":"Stores arshid6social listing media data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_listings","full_table_name":"wp_arshid6social_listings","description":"Stores arshid6social listings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"uid","type":"varchar(12)","nullable":false,"primary_key":false},{"name":"seller_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"title","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"description","type":"longtext","nullable":false,"primary_key":false},{"name":"price","type":"DECIMAL(15,4)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"item_condition","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"category_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"location_city","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"location_country","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"lat","type":"DECIMAL(10,7)","nullable":true,"primary_key":false},{"name":"lng","type":"DECIMAL(10,7)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"is_negotiable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_free","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"views","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":true,"primary_key":false},{"name":"listing_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"attachment_id","type":"bigint(20) unsigned","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":"is_primary","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"parent_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"name","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"icon","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"listing_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"listing_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"seller_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"buyer_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"rating","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"comment","type":"text","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"listing_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"buyer_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"amount","type":"DECIMAL(15,4)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"message_thread_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"note","type":"text","nullable":true,"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":"label","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"query_json","type":"longtext","nullable":false,"primary_key":false},{"name":"notify","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"last_notified","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_listings ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, uid varchar(12) NOT NULL DEFAULT '', seller_id bigint(20) unsigned NOT NULL, title varchar(200) NOT NULL DEFAULT '', description longtext NOT NULL, price DECIMAL(15,4) NOT NULL DEFAULT '0.0000', currency varchar(10) NOT NULL DEFAULT '', item_condition varchar(20) NOT NULL DEFAULT 'used', category_id bigint(20) unsigned NOT NULL DEFAULT 0, location_city varchar(100) NOT NULL DEFAULT '', location_country varchar(10) NOT NULL DEFAULT '', lat DECIMAL(10,7) DEFAULT NULL, lng DECIMAL(10,7) DEFAULT NULL, status varchar(20) NOT NULL DEFAULT 'draft', is_negotiable tinyint(1) NOT NULL DEFAULT 0, is_free tinyint(1) NOT NULL DEFAULT 0, views bigint(20) unsigned NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', expires_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY uid (uid), KEY status_category (status, category_id), KEY seller_id (seller_id), KEY lat_lng (lat, lng), KEY expires_at (expires_at), KEY status (status), KEY created_at (created_at) ) $charset_collate;\"; // ── Listing media ───────────────────────────────────────────────────── // attachment_id links to WP Media Library; file_url/file_path are the // actual stored file so listings survive media library purges. $tables[] = \"CREATE TABLE wp_arshid6social_listing_media ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, listing_id bigint(20) unsigned NOT NULL, attachment_id bigint(20) unsigned NOT NULL DEFAULT 0, file_url varchar(2083) NOT NULL DEFAULT '', file_path varchar(500) NOT NULL DEFAULT '', is_primary tinyint(1) NOT NULL DEFAULT 0, sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY listing_id (listing_id), KEY is_primary (is_primary) ) $charset_collate;\"; // ── Categories ──────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_categories ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, parent_id bigint(20) unsigned NOT NULL DEFAULT 0, name varchar(150) NOT NULL DEFAULT '', slug varchar(150) NOT NULL DEFAULT '', icon varchar(100) NOT NULL DEFAULT '', sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY slug (slug), KEY parent_id (parent_id) ) $charset_collate;\"; // ── Favorites ───────────────────────────────────────────────────────── $tables[] = \"CREATE TABLE wp_arshid6social_favorites ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, listing_id bigint(20) unsigned NOT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY user_listing (user_id, listing_id), KEY user_id (user_id), KEY listing_id (listing_id) ) $charset_collate;\"; // ── Reviews ─────────────────────────────────────────────────────────── // One review per buyer per listing; moderated before display. $tables[] = \"CREATE TABLE wp_arshid6social_reviews ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, listing_id bigint(20) unsigned NOT NULL, seller_id bigint(20) unsigned NOT NULL, buyer_id bigint(20) unsigned NOT NULL, rating tinyint(1) NOT NULL DEFAULT 5, comment text NOT NULL, status varchar(20) NOT NULL DEFAULT 'pending', created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY listing_buyer (listing_id, buyer_id), KEY seller_id (seller_id), KEY buyer_id (buyer_id), KEY status (status) ) $charset_collate;\"; // ── Offers ──────────────────────────────────────────────────────────── // Optional haggling record; money never flows through the plugin. // message_thread_id links to {prefix}arshid6social_messages_threads for context. $tables[] = \"CREATE TABLE wp_arshid6social_offers ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, listing_id bigint(20) unsigned NOT NULL, buyer_id bigint(20) unsigned NOT NULL, amount DECIMAL(15,4) NOT NULL DEFAULT '0.0000', status varchar(20) NOT NULL DEFAULT 'pending', message_thread_id bigint(20) unsigned DEFAULT NULL, note text, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY listing_id (listing_id), KEY buyer_id (buyer_id), KEY status (status) ) $charset_collate;\"; // ── Saved searches ──────────────────────────────────────────────────── // query_json stores the serialised filter state for re-running searches // and for the cron alert job to match new listings against. $tables[] = \"CREATE TABLE wp_arshid6social_saved_searches ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, label varchar(100) NOT NULL DEFAULT '', query_json longtext NOT NULL, notify tinyint(1) NOT NULL DEFAULT 0, last_notified datetime DEFAULT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY user_id (user_id), KEY notify (notify) ) $charset_collate;\"; foreach ( $tables as $sql ) { dbDelta( $sql );"},{"table_name":"arshid6social_messages","full_table_name":"wp_arshid6social_messages","description":"Stores arshid6social messages data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_messages_hidden","full_table_name":"wp_arshid6social_messages_hidden","description":"Stores arshid6social messages hidden data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_messages_meta","full_table_name":"wp_arshid6social_messages_meta","description":"Stores additional metadata (key-value pairs) for arshid6social messages records.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_messages_recipients","full_table_name":"wp_arshid6social_messages_recipients","description":"Stores arshid6social messages recipients data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_messages_threads","full_table_name":"wp_arshid6social_messages_threads","description":"Stores arshid6social messages threads data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_muted_stories","full_table_name":"wp_arshid6social_muted_stories","description":"Stores arshid6social muted stories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_notifications","full_table_name":"wp_arshid6social_notifications","description":"Stores arshid6social notifications data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_offers","full_table_name":"wp_arshid6social_offers","description":"Stores arshid6social offers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_poll_options","full_table_name":"wp_arshid6social_poll_options","description":"Stores arshid6social poll options data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"poll_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"option_text","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"option_image","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"option_image_path","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"is_correct","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"sort_order","type":"SMALLINT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_poll_options ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, poll_id BIGINT UNSIGNED NOT NULL, option_text VARCHAR(500) NOT NULL, option_image VARCHAR(500) DEFAULT NULL, option_image_path VARCHAR(500) DEFAULT NULL, is_correct TINYINT(1) NOT NULL DEFAULT 0, sort_order SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY poll_id (poll_id) ) $charset;\" );"},{"table_name":"arshid6social_poll_votes","full_table_name":"wp_arshid6social_poll_votes","description":"Stores arshid6social poll votes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"poll_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"option_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"rank","type":"SMALLINT","nullable":false,"primary_key":false},{"name":"voted_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_poll_votes ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, poll_id BIGINT UNSIGNED NOT NULL, option_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL, rank SMALLINT NOT NULL DEFAULT 1, voted_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY actor_poll_option (poll_id, option_id, user_id), KEY poll_id (poll_id), KEY user_id (user_id) ) $charset;\" );"},{"table_name":"arshid6social_polls","full_table_name":"wp_arshid6social_polls","description":"Stores arshid6social polls data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"activity_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"question","type":"TEXT","nullable":false,"primary_key":false},{"name":"poll_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"anonymous","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"allow_change_vote","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"results_visibility","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"allow_voter_suggest","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"end_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"start_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_polls ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, activity_id BIGINT UNSIGNED NOT NULL DEFAULT 0, user_id BIGINT UNSIGNED NOT NULL, question TEXT NOT NULL, poll_type VARCHAR(20) NOT NULL DEFAULT 'single', anonymous TINYINT(1) NOT NULL DEFAULT 0, allow_change_vote TINYINT(1) NOT NULL DEFAULT 1, results_visibility VARCHAR(20) NOT NULL DEFAULT 'always', allow_voter_suggest TINYINT(1) NOT NULL DEFAULT 0, end_date DATETIME DEFAULT NULL, start_date DATETIME DEFAULT NULL, status VARCHAR(20) NOT NULL DEFAULT 'open', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY activity_id (activity_id), KEY user_id (user_id), KEY status (status) ) $charset;\" );"},{"table_name":"arshid6social_post_tag_coords","full_table_name":"wp_arshid6social_post_tag_coords","description":"Stores arshid6social post tag coords data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"tag_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"x_percent","type":"DECIMAL(5,2)","nullable":false,"primary_key":false},{"name":"y_percent","type":"DECIMAL(5,2)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_post_tag_coords ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, tag_id BIGINT UNSIGNED NOT NULL, x_percent DECIMAL(5,2) NOT NULL DEFAULT 0.00, y_percent DECIMAL(5,2) NOT NULL DEFAULT 0.00, PRIMARY KEY (id), KEY tag_id (tag_id) ) $charset;\" );"},{"table_name":"arshid6social_post_tags","full_table_name":"wp_arshid6social_post_tags","description":"Stores arshid6social post tags data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"object_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"tagged_user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"tagger_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_post_tags ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, object_id BIGINT UNSIGNED NOT NULL, object_type VARCHAR(50) NOT NULL DEFAULT 'activity', tagged_user_id BIGINT UNSIGNED NOT NULL, tagger_id BIGINT UNSIGNED NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'approved', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY object_id (object_id, object_type), KEY tagged_user_id (tagged_user_id) ) $charset;\" );"},{"table_name":"arshid6social_reports","full_table_name":"wp_arshid6social_reports","description":"Stores arshid6social reports data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_reviews","full_table_name":"wp_arshid6social_reviews","description":"Stores arshid6social reviews data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_saved_searches","full_table_name":"wp_arshid6social_saved_searches","description":"Stores arshid6social saved searches data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"arshid6social_shares","full_table_name":"wp_arshid6social_shares","description":"Stores arshid6social shares data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"original_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"root_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"target_type","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"target_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"comment","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_shares ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, original_id BIGINT UNSIGNED NOT NULL, root_id BIGINT UNSIGNED NOT NULL, target_type VARCHAR(30) NOT NULL DEFAULT 'profile', target_id BIGINT UNSIGNED DEFAULT NULL, comment TEXT DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY original_id (original_id), KEY root_id (root_id) ) $charset;\" );"},{"table_name":"arshid6social_sticky","full_table_name":"wp_arshid6social_sticky","description":"Stores arshid6social sticky data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"object_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"scope","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"scope_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_by","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arshid6social_sticky ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, object_id BIGINT UNSIGNED NOT NULL, object_type VARCHAR(50) NOT NULL DEFAULT 'activity', scope VARCHAR(20) NOT NULL DEFAULT 'profile', scope_id BIGINT UNSIGNED DEFAULT NULL, expires_at DATETIME DEFAULT NULL, created_by BIGINT UNSIGNED NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY object_id (object_id), KEY scope (scope, scope_id) ) $charset;\" );"},{"table_name":"arshid6social_stories","full_table_name":"wp_arshid6social_stories","description":"Stores arshid6social stories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_story_highlights","full_table_name":"wp_arshid6social_story_highlights","description":"Stores arshid6social story highlights data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_story_items","full_table_name":"wp_arshid6social_story_items","description":"Stores arshid6social story items data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_story_reactions","full_table_name":"wp_arshid6social_story_reactions","description":"Stores arshid6social story reactions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_story_views","full_table_name":"wp_arshid6social_story_views","description":"Stores arshid6social story views data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_verification_requests","full_table_name":"wp_arshid6social_verification_requests","description":"Stores arshid6social verification requests data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_verifications","full_table_name":"wp_arshid6social_verifications","description":"Stores arshid6social verifications data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_xprofile_data","full_table_name":"wp_arshid6social_xprofile_data","description":"Stores arshid6social xprofile data data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"arshid6social_xprofile_fields","full_table_name":"wp_arshid6social_xprofile_fields","description":"Stores arshid6social xprofile fields data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"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","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}],"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 );"}],"table_count":53}