X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=9343d0b82b7235b0f90b72913e50d9c0d49d0f76;hb=eeed37371c59015eb9ba3aa1194dea913762f727;hp=107fa7195adf0426a8d3c9cfd2001163272ac395;hpb=902c527f40edd9dc911441382976f29630faeaf0;p=gruntmaster-data.git diff --git a/db.sql b/db.sql index 107fa71..9343d0b 100644 --- a/db.sql +++ b/db.sql @@ -205,18 +205,3 @@ CREATE OR REPLACE VIEW job_entry AS (SELECT LENGTH(source) AS size FROM jobs ORDER BY id DESC); - --- CREATE OR REPLACE FUCNTION source_private(jobid INT) RETURNS BOOLEAN AS $$ --- BEGIN --- private BOOLEAN; --- problem TEXT; --- contest TEXT; - --- SELECT private, problem, contest INTO STRICT private, problem, contest FROM jobs WHERE id = jobid; --- IF private THEN --- RETURN TRUE; --- END IF - --- IF --- END; --- $$