-- WORDLY REAL-TIME DASHBOARD ACTIVITY (IDEMPOTENT)
-- Import sekali pada database wordly_db.
SET @has_event_key = (
 SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
 WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='user_activity' AND COLUMN_NAME='event_key'
);
SET @sql_event_key = IF(@has_event_key=0,
 'ALTER TABLE user_activity ADD COLUMN event_key VARCHAR(80) NULL DEFAULT NULL',
 'SELECT "event_key sudah tersedia"');
PREPARE stmt_event_key FROM @sql_event_key;
EXECUTE stmt_event_key;
DEALLOCATE PREPARE stmt_event_key;

SET @has_event_key_index = (
 SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS
 WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='user_activity' AND INDEX_NAME='uq_user_activity_event_key'
);
SET @sql_event_key_index = IF(@has_event_key_index=0,
 'ALTER TABLE user_activity ADD UNIQUE KEY uq_user_activity_event_key (event_key)',
 'SELECT "index event_key sudah tersedia"');
PREPARE stmt_event_key_index FROM @sql_event_key_index;
EXECUTE stmt_event_key_index;
DEALLOCATE PREPARE stmt_event_key_index;

-- Tidak menghapus riwayat XP/coins pengguna. Angka mingguan di dashboard
-- dihitung ulang dari aktivitas server sejak 6 hari sebelum hari ini.
