Connect insertions/type changes to the database.

[pkanalytics] / stats.cpp

diff --git a/stats.cpp b/stats.cpp
index 9d621249cdafdb873b627bb20bb8f3fcfea4f823..6a96266a217806839237cd4ded48047266fd29c9 100644 (file)
--- a/stats.cpp
+++ b/stats.cpp
@@ -152,7 +152,7 @@ sqlite3 *open_db(const char *filename)
        )", nullptr, nullptr, nullptr);  // Ignore errors.
 
        sqlite3_exec(db, R"(
-               CREATE TABLE IF NOT EXISTS event (t INTEGER, player INTEGER, type VARCHAR, FOREIGN KEY (player) REFERENCES player(player));
+               CREATE TABLE IF NOT EXISTS event (event INTEGER PRIMARY KEY, t INTEGER, player INTEGER, type VARCHAR, FOREIGN KEY (player) REFERENCES player(player));
        )", nullptr, nullptr, nullptr);  // Ignore errors.
 
        sqlite3_exec(db, "PRAGMA journal_mode=WAL", nullptr, nullptr, nullptr);  // Ignore errors.