svn commit: r235730 - user/des/fbce/db
Dag-Erling Smorgrav
des at FreeBSD.org
Mon May 21 18:39:50 UTC 2012
Author: des
Date: Mon May 21 18:39:49 2012
New Revision: 235730
URL: http://svn.freebsd.org/changeset/base/235730
Log:
Remove chaff, add RCS tag
Modified:
user/des/fbce/db/fbce.sql (contents, props changed)
Modified: user/des/fbce/db/fbce.sql
==============================================================================
--- user/des/fbce/db/fbce.sql Mon May 21 18:28:09 2012 (r235729)
+++ user/des/fbce/db/fbce.sql Mon May 21 18:39:49 2012 (r235730)
@@ -1,13 +1,6 @@
--- drop table if exists config cascade;
--- create table config (
--- key varchar not null primary key,
--- value varchar not null,
--- unique(key)
--- );
--- insert into config values('reg_open', '2010-06-09T00:00:00');
--- insert into config values('reg_close', '2010-06-16T00:00:00');
--- insert into config values('vote_open', '2010-06-17T00:00:00');
--- insert into config values('vote_close', '2010-07-14T00:00:00');
+--
+-- $FreeBSD$
+--
drop table if exists persons cascade;
create table persons (
@@ -50,5 +43,3 @@ create view results as
select persons.id, persons.login as login, persons.realname as realname, persons.incumbent, count(votes.*) as votes
from persons join votes on persons.id = votes.candidate
group by persons.id, persons.login, persons.realname, persons.incumbent;
-
--- select * from results order by votes limit 9;
More information about the svn-src-user
mailing list