From aaef7a778957912a721f4ca64114147b95d6aad3 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Fri, 26 Sep 2008 11:56:54 +0200 Subject: [PATCH] Scan request infrastructure --- database/scan_requests.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 database/scan_requests.sql diff --git a/database/scan_requests.sql b/database/scan_requests.sql new file mode 100644 index 0000000..32e1b8b --- /dev/null +++ b/database/scan_requests.sql @@ -0,0 +1,14 @@ +CREATE TABLE scan_requests ( + id SERIAL PRIMARY KEY, + uid INTEGER NOT NULL REFERENCES users(uid), + planet INTEGER NOT NULL REFERENCES planets(id), + type TEXT NOT NULL, + nick TEXT NOT NULL, + tick INTEGER NOT NULL DEFAULT tick(), + time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), + sent BOOL NOT NULL DEFAULT FALSE, + UNIQUE (tick,planet,type,uid) +); + +CREATE INDEX scan_requests_time_not_sent_index ON scan_requests(time) WHERE NOT sent; + -- 2.39.2