X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=d2f658e03f979a8b90ba7942aba685ad67203bc0;hb=89dadd7b183137904770e9d40121263680f789de;hp=44e2420b88fd4ca354e6a9c4e68cf04c98d72c3f;hpb=9325f8289dd512a0e7f8f3d8dc22bcee91bb495b;p=gruntmaster-data.git diff --git a/db.sql b/db.sql index 44e2420..d2f658e 100644 --- a/db.sql +++ b/db.sql @@ -173,7 +173,7 @@ CREATE OR REPLACE VIEW user_list AS (SELECT ORDER BY solved DESC, attempted DESC, id); CREATE OR REPLACE VIEW contest_entry AS (SELECT - id,name,description,editorial,start,stop,owner, + id,name,description,start,stop,owner, (EXTRACT(epoch from NOW()) >= start) AS started, (EXTRACT(epoch from NOW()) >= stop) AS finished FROM contests