blob: 8f30bdef673a08d8f7003951962400a609ec64f0 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
BEGIN TRANSACTION;
CREATE TABLE Events (
id INTEGER PRIMARY KEY,
type TEXT NOT NULL,
timestamp INTEGER NOT NULL,
event_json TEXT NOT NULL
);
CREATE TABLE EventsOutbox (
event_id INTEGER NOT NULL,
FOREIGN KEY (event_id) REFERENCES Events (id)
);
COMMIT;
|