From owner-svn-src-user@FreeBSD.ORG Mon May 21 18:39:50 2012 Return-Path: Delivered-To: svn-src-user@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 43529106567C; Mon, 21 May 2012 18:39:50 +0000 (UTC) (envelope-from des@FreeBSD.org) Received: from svn.freebsd.org (svn.freebsd.org [IPv6:2001:4f8:fff6::2c]) by mx1.freebsd.org (Postfix) with ESMTP id 2EBDA8FC15; Mon, 21 May 2012 18:39:50 +0000 (UTC) Received: from svn.freebsd.org (localhost [127.0.0.1]) by svn.freebsd.org (8.14.4/8.14.4) with ESMTP id q4LIdnVO068468; Mon, 21 May 2012 18:39:49 GMT (envelope-from des@svn.freebsd.org) Received: (from des@localhost) by svn.freebsd.org (8.14.4/8.14.4/Submit) id q4LIdnjB068466; Mon, 21 May 2012 18:39:49 GMT (envelope-from des@svn.freebsd.org) Message-Id: <201205211839.q4LIdnjB068466@svn.freebsd.org> From: Dag-Erling Smorgrav Date: Mon, 21 May 2012 18:39:49 +0000 (UTC) To: src-committers@freebsd.org, svn-src-user@freebsd.org X-SVN-Group: user MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Cc: Subject: svn commit: r235730 - user/des/fbce/db X-BeenThere: svn-src-user@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: "SVN commit messages for the experimental " user" src tree" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 21 May 2012 18:39:50 -0000 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;