1 CREATE TABLE scan_requests (
3 uid INTEGER NOT NULL REFERENCES users(uid),
4 planet INTEGER NOT NULL REFERENCES planets(id),
7 tick INTEGER NOT NULL DEFAULT tick(),
8 time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
9 sent BOOL NOT NULL DEFAULT FALSE,
10 UNIQUE (tick,planet,type,uid)
13 CREATE INDEX scan_requests_time_not_sent_index ON scan_requests(time) WHERE NOT sent;