15 lines
492 B
SQL
15 lines
492 B
SQL
CREATE TABLE IF NOT EXISTS site_visits (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
project_id INTEGER NOT NULL REFERENCES projects(id),
|
|
path TEXT NOT NULL,
|
|
referrer TEXT,
|
|
ua_hash TEXT,
|
|
ip_hash TEXT,
|
|
visited_at DATETIME DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_visits_project_time
|
|
ON site_visits(project_id, visited_at DESC);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_visits_project_path
|
|
ON site_visits(project_id, path);
|