X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=a9ea727f3e64f5f861fd03150604dfb60e50e49f;hb=6dda1f23dd233eaca23859432922dfdceb68358f;hp=ba8a62198ee753f9c0e4a8cca78ea98528ff978b;hpb=78ee4c0a1c9334a263f67f3bd08a6f370e1df502;p=gruntmaster-data.git

diff --git a/db.sql b/db.sql
index ba8a621..a9ea727 100644
--- a/db.sql
+++ b/db.sql
@@ -99,6 +99,13 @@ CREATE TABLE opens (
 	PRIMARY KEY (contest, problem, owner)
 );
 
+CREATE TABLE limits (
+	problem TEXT NOT NULL REFERENCES problems ON DELETE CASCADE,
+	format  TEXT NOT NULL,
+	timeout REAL NOT NULL,
+	PRIMARY KEY (problem, format)
+);
+
 CREATE TABLE table_comments (
 	table_name   TEXT NOT NULL PRIMARY KEY,
 	comment_text TEXT NOT NULL
@@ -119,6 +126,7 @@ INSERT INTO table_comments VALUES ('contest_problems', 'Many-to-many bridge betw
 INSERT INTO table_comments VALUES ('jobs',   'List of jobs');
 INSERT INTO table_comments VALUES ('problem_status', 'List of (problem, user, result)');
 INSERT INTO table_comments VALUES ('opens', 'List of (contest, problem, user, time when user opened problem)');
+INSERT INTO table_comments VALUES ('limits', 'Time limit overrides for certain problem/format pairs');
 
 INSERT INTO column_comments VALUES ('users', 'passphrase', 'RFC2307-encoded passphrase');
 INSERT INTO column_comments VALUES ('users', 'name', 'Full name of user');