]>
Commit | Line | Data |
---|---|---|
4623c9f2 MG |
1 | CREATE FUNCTION tm() RETURNS BIGINT IMMUTABLE LANGUAGE SQL AS $$ |
2 | SELECT EXTRACT(epoch FROM NOW())::bigint | |
3 | $$; | |
4 | ||
5 | -- USERS | |
6 | ||
7 | INSERT INTO users (id, admin) VALUES ('MGV', TRUE); | |
8 | INSERT INTO users (id, admin) VALUES ('nobody', FALSE); | |
9 | ||
10 | -- CONTESTS | |
11 | ||
12 | ALTER TABLE contests ALTER owner SET DEFAULT 'MGV'; | |
13 | ||
14 | INSERT INTO contests (id, start, stop, name) VALUES ('fc', tm() - 2000, tm() - 1000, 'Finished contest'); | |
15 | INSERT INTO contests (id, start, stop, name) VALUES ('rc', tm() - 1000, tm() + 1000, 'Running contest'); | |
16 | INSERT INTO contests (id, start, stop, name) VALUES ('pc', tm() + 1000, tm() + 2000, 'Pending contest'); | |
17 | ||
18 | -- PROBLEMS | |
19 | ||
20 | ALTER TABLE problems ALTER generator SET DEFAULT 'Undef', | |
21 | ALTER runner SET DEFAULT 'File', | |
22 | ALTER judge SET DEFAULT 'Absolute', | |
23 | ALTER level SET DEFAULT 'beginner', | |
24 | ALTER value SET DEFAULT 100, | |
25 | ALTER owner SET DEFAULT 'MGV', | |
26 | ALTER statement SET DEFAULT 'Sample Text', | |
27 | ALTER solution SET DEFAULT 'Sample Text', | |
28 | ALTER testcnt SET DEFAULT 1, | |
29 | ALTER timeout SET DEFAULT 1; | |
30 | ||
31 | INSERT INTO problems (id, name, private) VALUES ('fca', 'FC problem A', FALSE); | |
32 | INSERT INTO problems (id, name, private) VALUES ('rca', 'RC problem A', TRUE); | |
33 | INSERT INTO problems (id, name, private) VALUES ('pca', 'PC problem A', TRUE); | |
34 | INSERT INTO problems (id, name, private) VALUES ('arc', 'Problem in archive', FALSE); | |
35 | INSERT INTO problems (id, name, private) VALUES ('prv', 'Private problem', TRUE); | |
36 | ||
37 | INSERT INTO contest_problems (contest, problem) VALUES ('fc', 'fca'); | |
38 | INSERT INTO contest_problems (contest, problem) VALUES ('rc', 'rca'); | |
39 | INSERT INTO contest_problems (contest, problem) VALUES ('pc', 'pca'); | |
40 | ||
41 | INSERT INTO limits (problem, format, timeout) VALUES ('arc', 'C', 0.1); | |
42 | INSERT INTO limits (problem, format, timeout) VALUES ('arc', 'CPP', 0.1); | |
43 | ||
44 | -- JOBS | |
45 | ||
46 | ALTER TABLE jobs ALTER date SET DEFAULT tm() - 1500, | |
47 | ALTER errors SET DEFAULT 'Errors here', | |
48 | ALTER extension SET DEFAULT 'pl', | |
49 | ALTER format SET DEFAULT 'PERL', | |
50 | ALTER result SET DEFAULT 0, | |
51 | ALTER result_text SET DEFAULT 'Accepted', | |
52 | ALTER results SET DEFAULT '[]', | |
53 | ALTER source SET DEFAULT 'print "Hello, world!"', | |
54 | ALTER owner SET DEFAULT 'nobody'; | |
55 | ||
56 | INSERT INTO jobs (contest, problem, owner) VALUES ('fc', 'fca', 'MGV'); | |
57 | INSERT INTO jobs (contest, problem, result, result_text, date) VALUES ('fc', 'fca', 1, 'Wrong Answer', tm() - 1600); | |
58 | INSERT INTO jobs (contest, problem) VALUES ('fc', 'fca'); | |
59 | INSERT INTO jobs (problem, date) VALUES ('fca', tm() - 500); | |
60 | INSERT INTO jobs (problem, date) VALUES ('arc', tm() - 100); | |
61 | INSERT INTO jobs (problem, private, owner) VALUES ('pca', TRUE, 'MGV'); | |
62 | INSERT INTO jobs (problem, private, owner, result, result_text, results) VALUES ('prv', TRUE, 'MGV', NULL, NULL, NULL); |