Date: Mon, 21 May 2012 18:39:49 +0000 (UTC) From: Dag-Erling Smorgrav <des@FreeBSD.org> To: src-committers@freebsd.org, svn-src-user@freebsd.org Subject: svn commit: r235730 - user/des/fbce/db Message-ID: <201205211839.q4LIdnjB068466@svn.freebsd.org>
next in thread | raw e-mail | index | archive | help
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;
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201205211839.q4LIdnjB068466>