{"slug":"circlekit-community","name":"CircleKit Community","description":"Free community platform for WordPress with member profiles, public groups, activity feed, and notifications.","author":"Abdul Wahab Taqi","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/circlekit-community/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"circlekit_activity","full_table_name":"wp_circlekit_activity","description":"Stores circlekit activity data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"circlekit_activity_bookmarks","full_table_name":"wp_circlekit_activity_bookmarks","description":"Stores circlekit activity bookmarks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"circlekit_activity_comments","full_table_name":"wp_circlekit_activity_comments","description":"Stores circlekit activity comments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"circlekit_connections","full_table_name":"wp_circlekit_connections","description":"Stores circlekit connections data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"circlekit_field_data","full_table_name":"wp_circlekit_field_data","description":"Stores circlekit field data data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"circlekit_field_groups","full_table_name":"wp_circlekit_field_groups","description":"Stores circlekit field 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(255)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"sort_order","type":"INT(11)","nullable":true,"primary_key":false},{"name":"is_signup","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"group_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"alternate_title","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"field_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"is_required","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"default_visibility","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"allow_override","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"options","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"conditions","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"sort_order","type":"INT(11)","nullable":true,"primary_key":false},{"name":"is_protected","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"field_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"visibility","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"meta_key","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"meta_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"initiator_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"receiver_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"group_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"visibility","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"template","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"cover_image","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"avatar","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"settings","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"member_count","type":"INT(11)","nullable":true,"primary_key":false},{"name":"created_by","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"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":"role","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"joined_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"group_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"content","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"media","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"privacy","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"is_pinned","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"pin_order","type":"INT(11)","nullable":true,"primary_key":false},{"name":"comments_enabled","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"comment_count","type":"INT(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","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":"parent_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"content","type":"TEXT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","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":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"actor_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"object_type","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"object_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"message","type":"TEXT","nullable":true,"primary_key":false},{"name":"link","type":"TEXT","nullable":true,"primary_key":false},{"name":"is_read","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"reporter_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"content_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"content_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"reason","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"details","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"resolution","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"resolved_by","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"resolved_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_circlekit_field_groups ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, slug VARCHAR(100) NOT NULL, description TEXT, sort_order INT(11) DEFAULT 0, is_signup TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY slug (slug) ) {$charset};\"; // Profile field definitions. $sql[] = \"CREATE TABLE wp_circlekit_fields ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, group_id BIGINT(20) UNSIGNED NOT NULL, name VARCHAR(255) NOT NULL, slug VARCHAR(100) NOT NULL, alternate_title VARCHAR(255) DEFAULT NULL, description TEXT, field_type VARCHAR(50) NOT NULL DEFAULT 'text', is_required TINYINT(1) DEFAULT 0, default_visibility VARCHAR(20) DEFAULT 'public', allow_override TINYINT(1) DEFAULT 1, options LONGTEXT, conditions LONGTEXT, sort_order INT(11) DEFAULT 0, is_protected TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY group_id (group_id), KEY slug (slug) ) {$charset};\"; // Profile field values per user. $sql[] = \"CREATE TABLE wp_circlekit_field_data ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, field_id BIGINT(20) UNSIGNED NOT NULL, value LONGTEXT, visibility VARCHAR(20) DEFAULT 'public', updated_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY user_field (user_id, field_id), KEY field_id (field_id) ) {$charset};\"; // Profile meta (avatar, cover, completion, etc.) $sql[] = \"CREATE TABLE wp_circlekit_profile_meta ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, meta_key VARCHAR(100) NOT NULL, meta_value LONGTEXT, PRIMARY KEY (id), KEY user_meta (user_id, meta_key) ) {$charset};\"; // Connections (follow + friend). $sql[] = \"CREATE TABLE wp_circlekit_connections ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, initiator_id BIGINT(20) UNSIGNED NOT NULL, receiver_id BIGINT(20) UNSIGNED NOT NULL, type VARCHAR(20) NOT NULL DEFAULT 'follow', status VARCHAR(20) NOT NULL DEFAULT 'active', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY connection_pair (initiator_id, receiver_id, type), KEY receiver_id (receiver_id), KEY status (status) ) {$charset};\"; // Groups. $sql[] = \"CREATE TABLE wp_circlekit_groups ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, slug VARCHAR(100) NOT NULL, description TEXT, group_type VARCHAR(50) NOT NULL DEFAULT 'public', visibility VARCHAR(20) NOT NULL DEFAULT 'public', template VARCHAR(50) DEFAULT 'custom', cover_image VARCHAR(500) DEFAULT NULL, avatar VARCHAR(500) DEFAULT NULL, settings LONGTEXT, member_count INT(11) DEFAULT 0, created_by BIGINT(20) UNSIGNED NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY slug (slug), KEY visibility (visibility), KEY created_by (created_by) ) {$charset};\"; // Group members. $sql[] = \"CREATE TABLE wp_circlekit_group_members ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, group_id BIGINT(20) UNSIGNED NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, role VARCHAR(20) NOT NULL DEFAULT 'member', status VARCHAR(20) NOT NULL DEFAULT 'active', joined_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY group_user (group_id, user_id), KEY user_id (user_id), KEY role (role) ) {$charset};\"; // Activity posts. $sql[] = \"CREATE TABLE wp_circlekit_activity ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, group_id BIGINT(20) UNSIGNED DEFAULT 0, type VARCHAR(50) NOT NULL DEFAULT 'post', content LONGTEXT, media LONGTEXT, privacy VARCHAR(20) NOT NULL DEFAULT 'public', is_pinned TINYINT(1) DEFAULT 0, pin_order INT(11) DEFAULT 0, comments_enabled TINYINT(1) DEFAULT 1, comment_count INT(11) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY group_id (group_id), KEY type (type), KEY is_pinned (is_pinned), KEY created_at (created_at) ) {$charset};\"; // Activity comments. $sql[] = \"CREATE TABLE wp_circlekit_activity_comments ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, activity_id BIGINT(20) UNSIGNED NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, parent_id BIGINT(20) UNSIGNED DEFAULT 0, content TEXT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY activity_id (activity_id), KEY user_id (user_id), KEY parent_id (parent_id) ) {$charset};\"; // Activity bookmarks. $sql[] = \"CREATE TABLE wp_circlekit_activity_bookmarks ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, activity_id BIGINT(20) UNSIGNED NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY activity_user (activity_id, user_id), KEY user_id (user_id) ) {$charset};\"; // Notifications. $sql[] = \"CREATE TABLE wp_circlekit_notifications ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, type VARCHAR(50) NOT NULL, actor_id BIGINT(20) UNSIGNED DEFAULT 0, object_type VARCHAR(50) DEFAULT NULL, object_id BIGINT(20) UNSIGNED DEFAULT 0, message TEXT, link TEXT DEFAULT NULL, is_read TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY is_read (is_read), KEY created_at (created_at) ) {$charset};\"; // Reports / moderation. $sql[] = \"CREATE TABLE wp_circlekit_reports ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, reporter_id BIGINT(20) UNSIGNED NOT NULL, content_type VARCHAR(50) NOT NULL, content_id BIGINT(20) UNSIGNED NOT NULL, reason VARCHAR(100) NOT NULL, details TEXT, status VARCHAR(20) NOT NULL DEFAULT 'pending', resolution VARCHAR(50) DEFAULT NULL, resolved_by BIGINT(20) UNSIGNED DEFAULT NULL, resolved_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY content (content_type, content_id), KEY status (status) ) {$charset};\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $sql as $query ) { dbDelta( $query );"},{"table_name":"circlekit_fields","full_table_name":"wp_circlekit_fields","description":"Stores circlekit fields data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"circlekit_group_members","full_table_name":"wp_circlekit_group_members","description":"Stores circlekit group members data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"circlekit_groups","full_table_name":"wp_circlekit_groups","description":"Stores circlekit groups data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"circlekit_notifications","full_table_name":"wp_circlekit_notifications","description":"Stores circlekit notifications data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"circlekit_profile_meta","full_table_name":"wp_circlekit_profile_meta","description":"Stores additional metadata (key-value pairs) for circlekit profile records.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"circlekit_reports","full_table_name":"wp_circlekit_reports","description":"Stores circlekit reports data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":12}