CREATE TABLE IF NOT EXISTS facebook_group_vitality (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, facebook_group_id BIGINT UNSIGNED NOT NULL,
 members_count INT UNSIGNED NULL, active_people_estimate INT UNSIGNED NULL, posts_7d INT UNSIGNED NULL,
 sampled_posts INT UNSIGNED NOT NULL DEFAULT 0, avg_reactions DECIMAL(8,2) NULL, avg_comments DECIMAL(8,2) NULL,
 coherence_score TINYINT UNSIGNED NULL, exchange_quality_score TINYINT UNSIGNED NULL,
 spam_rate TINYINT UNSIGNED NULL, off_topic_rate TINYINT UNSIGNED NULL, trolling_rate TINYINT UNSIGNED NULL,
 life_score TINYINT UNSIGNED NULL, value_score TINYINT UNSIGNED NULL, life_label VARCHAR(40) NULL,
 summary TEXT NULL, audited_at DATETIME NOT NULL, UNIQUE KEY group_vitality (facebook_group_id), INDEX(value_score), INDEX(life_score)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
