From 89dadd7b183137904770e9d40121263680f789de Mon Sep 17 00:00:00 2001 From: Marius Gavrilescu Date: Tue, 31 Mar 2015 12:27:31 +0300 Subject: [PATCH] Remove editorial from contest_entry --- db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 -- 2.39.2