projects
/
gruntmaster-data.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
9325f82
)
Remove editorial from contest_entry
author
Marius Gavrilescu
<marius@ieval.ro>
Tue, 31 Mar 2015 09:27:31 +0000
(12:27 +0300)
committer
Marius Gavrilescu
<marius@ieval.ro>
Tue, 31 Mar 2015 09:27:31 +0000
(12:27 +0300)
db.sql
patch
|
blob
|
blame
|
history
diff --git
a/db.sql
b/db.sql
index 44e2420b88fd4ca354e6a9c4e68cf04c98d72c3f..d2f658e03f979a8b90ba7942aba685ad67203bc0 100644
(file)
--- 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
This page took
0.011204 seconds
and
4
git commands to generate.