elections.sql | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 049b99f1050ad23a398457e703f7fd96c46a3e66
Author: Nigel Jones <dev(a)nigelj.com>
Date: Tue Jul 15 00:01:21 2008 +1200
Schema oopsie
diff --git a/elections.sql b/elections.sql
index c257ea4..13bb90a 100644
--- a/elections.sql
+++ b/elections.sql
@@ -56,7 +56,7 @@ primary key (id)
create view votecount as select candidate_id, election_id, sum(weight) as novotes from votes group by candidate_id, election_id order by novotes desc;
-create view fvotecount as select c.id, c.name, v.election_id, v.novotes from votecount v, candidates c where c.id = v.candidate_id order by novotesdesc;
+create view fvotecount as select c.id, c.name, v.election_id, v.novotes from votecount v, candidates c where c.id = v.candidate_id order by novotes desc;
create view uservotes as select election_id, voter, count(voter) as novotes from
votes group by election_id, voter;