30 lines
774 B
SQL
30 lines
774 B
SQL
PRAGMA journal_mode = WAL;
|
|
|
|
CREATE TABLE users(
|
|
id INTEGER PRIMARY KEY,
|
|
name TEXT NOT NULL,
|
|
city TEXT,
|
|
active INTEGER NOT NULL
|
|
);
|
|
|
|
CREATE TABLE events(
|
|
id INTEGER PRIMARY KEY,
|
|
user_id INTEGER NOT NULL,
|
|
kind TEXT NOT NULL,
|
|
created_at TEXT NOT NULL,
|
|
payload TEXT,
|
|
FOREIGN KEY(user_id) REFERENCES users(id)
|
|
);
|
|
|
|
CREATE INDEX idx_events_user_kind ON events(user_id, kind);
|
|
|
|
INSERT INTO users(name, city, active) VALUES
|
|
('Ada', 'London', 1),
|
|
('Bob', NULL, 0),
|
|
('Cara', 'Paris', 1);
|
|
|
|
INSERT INTO events(user_id, kind, created_at, payload) VALUES
|
|
(1, 'login', '2026-04-21T09:00:00Z', '{"ip":"127.0.0.1"}'),
|
|
(1, 'build', '2026-04-21T09:05:00Z', '{"target":"release-fast"}'),
|
|
(3, 'login', '2026-04-21T10:00:00Z', NULL);
|