wp_circlekit_field_groups

Column Definitions

CREATE TABLE Statement

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

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_circlekit_field_groups`;

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

Other tables from CircleKit Community