Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id F3C642E0074 for ; Thu, 3 Apr 2008 20:12:09 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 16590-02 for ; Thu, 3 Apr 2008 20:12:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from davinci.ethosmedia.com (unknown [209.128.84.227]) by developer.postgresql.org (Postfix) with ESMTP id AC45A2E0064 for ; Thu, 3 Apr 2008 20:12:06 -0300 (ADT) X-EthosMedia-Virus-Scanned: no infections found Received: from [64.81.245.111] (account josh@agliodbs.com HELO temoku.sf.agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 16237564; Thu, 03 Apr 2008 16:11:51 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: pgsql-www@postgresql.org Subject: Re: Databasing sponsors Date: Thu, 3 Apr 2008 16:15:45 -0700 User-Agent: KMail/1.8 Cc: "Joshua D. Drake" References: <20080403101150.56301a10@commandprompt.com> In-Reply-To: <20080403101150.56301a10@commandprompt.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200804031615.46168.josh@agliodbs.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/22 X-Sequence-Number: 14770 Josh, > sponsor table: > > id - serial pk > stype - the type of sponsor > description - how they sponsor name - sponsor name link - sponsor link image - sponsor logo image location location - sponsor location (of HQ, if appropriate) source - source of sponsor information > sponsor_type: > > stype: the type of sponsor (pk) I'd like to expand this system to cover doing the full sponsor breakdown we discussed and approved 1.5 years ago but never implemented. So as long as I can stuff giving categories into "stype", I'm good with it. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco