]>
iEval git - gruntmaster-data.git/blob - db.sql
3 passphrase
TEXT, -- NOT NULL,
4 admin BOOLEAN NOT NULL DEFAULT FALSE,
5 name TEXT, -- NOT NULL,
6 email
TEXT, -- NOT NULL,
7 phone
TEXT, -- NOT NULL,
8 town
TEXT, -- NOT NULL,
9 university
TEXT, -- NOT NULL,
10 level TEXT, -- NOT NULL,
14 CREATE TABLE contests (
19 owner TEXT NOT NULL REFERENCES users
ON DELETE CASCADE,
20 CONSTRAINT positive_duration
CHECK (stop
> start)
23 CREATE TABLE contest_status (
24 contest
TEXT NOT NULL REFERENCES contests
ON DELETE CASCADE,
25 owner TEXT NOT NULL REFERENCES users
ON DELETE CASCADE,
29 PRIMARY KEY (owner, contest
)
32 CREATE TABLE problems (
36 generator
TEXT NOT NULL,
41 owner TEXT NOT NULL REFERENCES users
ON DELETE CASCADE,
42 private
BOOLEAN NOT NULL DEFAULT FALSE,
45 statement TEXT NOT NULL,
48 timeout
REAL NOT NULL,
56 CREATE TABLE contest_problems (
57 contest
TEXT REFERENCES contests
ON DELETE CASCADE,
58 problem
TEXT NOT NULL REFERENCES problems
ON DELETE CASCADE,
59 PRIMARY KEY (contest
, problem
)
63 id SERIAL
PRIMARY KEY,
64 contest
TEXT REFERENCES contests
ON DELETE CASCADE,
68 extension
TEXT NOT NULL,
70 private
BOOLEAN NOT NULL DEFAULT FALSE,
71 problem
TEXT NOT NULL REFERENCES problems
ON DELETE CASCADE,
76 owner TEXT NOT NULL REFERENCES users
ON DELETE CASCADE
79 CREATE TABLE problem_status (
80 problem
TEXT NOT NULL REFERENCES problems
ON DELETE CASCADE,
81 owner TEXT NOT NULL REFERENCES users
ON DELETE CASCADE,
82 job SERIAL
NOT NULL REFERENCES jobs
ON DELETE CASCADE,
83 solved
BOOLEAN NOT NULL DEFAULT FALSE,
85 PRIMARY KEY (owner, problem
)
89 contest
TEXT NOT NULL REFERENCES contests
ON DELETE CASCADE,
90 problem
TEXT NOT NULL REFERENCES problems
ON DELETE CASCADE,
91 owner TEXT NOT NULL REFERENCES users
ON DELETE CASCADE,
93 PRIMARY KEY (contest
, problem
, owner)
This page took 0.040769 seconds and 4 git commands to generate.