github.com/status-im/status-go@v1.1.0/appdatabase/migrationsprevnodecfg/sql/1629123384_add_id_to_app_metrics.up.sql (about)

     1  ALTER TABLE app_metrics RENAME TO temp_app_metrics;
     2  CREATE TABLE app_metrics (
     3      id INTEGER PRIMARY KEY AUTOINCREMENT,
     4      event VARCHAR NOT NULL,
     5      value TEXT NOT NULL,
     6      app_version VARCHAR NOT NULL,
     7      operating_system VARCHAR NOT NULL,
     8      created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     9      session_id VARCHAR,
    10      processed BOOLEAN NOT NULL DEFAULT FALSE);
    11  INSERT INTO app_metrics(event, value, app_version, operating_system, created_at, session_id)
    12  SELECT event, value, app_version, operating_system, created_at, session_id
    13  FROM temp_app_metrics;
    14  DROP TABLE temp_app_metrics;