2020-08-08 04:32:06 +00:00
|
|
|
CREATE TABLE scores (
|
|
|
|
|
url varchar,
|
|
|
|
|
score int NOT NULL DEFAULT 0,
|
2020-10-19 00:24:24 +00:00
|
|
|
scoreModifier int NOT NULL DEFAULT 0,
|
2020-08-08 04:32:06 +00:00
|
|
|
PRIMARY KEY (url),
|
2020-11-01 20:07:16 +00:00
|
|
|
FOREIGN KEY (url) REFERENCES requests(url) ON DELETE CASCADE
|
2020-08-08 04:32:06 +00:00
|
|
|
);
|
