learn-request-queue/db/20-requests.sql

10 lines
287 B
MySQL
Raw Permalink Normal View History

2020-08-08 04:32:06 +00:00
CREATE TABLE requests (
url varchar NOT NULL,
2020-08-08 04:32:06 +00:00
requester int NOT NULL,
state varchar NOT NULL DEFAULT 'Requested',
reqTimestamp timestamptz NOT NULL DEFAULT NOW(),
PRIMARY KEY (url),
FOREIGN KEY (requester) REFERENCES users(userid),
FOREIGN KEY (state) REFERENCES states(state)
);