]>
iEval git - gruntmaster-data.git/blob - db.sql
1 CREATE TYPE ULEVEL
AS ENUM ('Highschool', 'Undergraduate', 'Master', 'Doctorate', 'Other');
2 CREATE TYPE PLEVEL
AS ENUM ('beginner', 'easy', 'medium', 'hard');
3 CREATE TYPE GENERATOR
AS ENUM ('File', 'Run', 'Undef');
4 CREATE TYPE RUNNER
AS ENUM ('File', 'Verifier', 'Interactive');
5 CREATE TYPE JUDGE
AS ENUM ('Absolute', 'Points');
9 name TEXT, -- NOT NULL,
10 email
TEXT, -- NOT NULL,
11 phone
TEXT, -- NOT NULL,
12 town
TEXT, -- NOT NULL,
13 university
TEXT, -- NOT NULL,
14 level TEXT, --ULEVEL NOT NULL,
18 CREATE TABLE contests (
23 owner TEXT NOT NULL REFERENCES users
,
24 CONSTRAINT positive_duration
CHECK (stop
> start)
27 CREATE TABLE problems (
30 generator GENERATOR
NOT NULL,
32 level PLEVEL
NOT NULL,
35 owner TEXT NOT NULL REFERENCES users
,
36 private
BOOLEAN NOT NULL DEFAULT FALSE,
37 runner RUNNER
NOT NULL,
38 statement TEXT NOT NULL,
41 timeout
REAL NOT NULL,
49 CREATE TABLE contest_problems (
50 contest
TEXT REFERENCES contests
,
51 problem
TEXT NOT NULL REFERENCES problems
,
52 PRIMARY KEY (contest
, problem
)
56 id SERIAL
PRIMARY KEY,
57 contest
TEXT REFERENCES contests
,
61 extension
TEXT NOT NULL,
63 private
BOOLEAN NOT NULL DEFAULT FALSE,
64 problem
TEXT NOT NULL REFERENCES problems
,
69 owner TEXT NOT NULL REFERENCES users
73 contest
TEXT NOT NULL REFERENCES contests
,
74 problem
TEXT NOT NULL REFERENCES problems
,
75 owner TEXT NOT NULL REFERENCES users
,
77 PRIMARY KEY (contest
, problem
, owner)
This page took 0.045639 seconds and 4 git commands to generate.