9XbqhPGr

1PRAGMA foreign_keys = ON;
2
3CREATE TABLE IF NOT EXISTS occupants (
4	occupant_id INTEGER PRIMARY KEY ASC,
5	name TEXT,
6	company TEXT,
7	tier INTEGER,
8	icon TEXT
9);
10
11CREATE TABLE IF NOT EXISTS passage (
12	timestamp INTEGER,
13	direction INTEGER,
14	passage_occupant INTEGER,
15	FOREIGN KEY(passage_occupant) REFERENCES occupants(occupant_id)
16);