From grbounce-1SmKRQUAAADb_R2oRU4VvVPYnC2H_cF3=phma=phma.optus.nu@googlegroups.com Wed Sep 9 22:19:33 2009 Return-Path: X-Original-To: phma@localhost Delivered-To: phma@localhost Received: from chausie.ixazon.lan (localhost [127.0.0.1]) by chausie (Postfix) with ESMTP id 764563CF0 for ; Wed, 9 Sep 2009 22:19:33 -0400 (EDT) Delivered-To: phma@phma.optus.nu Received: from 192.168.7.2 [192.168.7.2] by chausie.ixazon.lan with IMAP (fetchmail-6.3.8) for (single-drop); Wed, 09 Sep 2009 22:19:33 -0400 (EDT) Received: from mail-vw0-f137.google.com (mail-vw0-f137.google.com [209.85.212.137]) by ixazon.dynip.com (Postfix) with ESMTP id 43CC6CE76E for ; Wed, 9 Sep 2009 22:17:36 -0400 (EDT) Received: by vws1 with SMTP id 1so10195168vws.17 for ; Wed, 09 Sep 2009 19:17:35 -0700 (PDT) Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=beta; h=domainkey-signature:received:received:x-sender:x-apparently-to :received:received:received:received-spf:received:received:from:to :subject:date:user-agent:references:in-reply-to:mime-version :content-type:message-id:reply-to:sender:precedence:x-google-loop :mailing-list:list-id:list-post:list-help:list-unsubscribe :x-beenthere-env:x-beenthere; bh=WcEoGk7uIT0UdKnb0EMiFNAP0QAAfgjeL39738wWTJM=; b=gEwVWCMS29tNCxJSUKkr1HnR2isUC1/rDldevhaNfStxG+8teJ37z1LuU/a4xcEuNu G6W01oEGpu5/bs1Ua9kLW+am3nakxr7E1KXvJYO5sukncg5YfcsOczsZ2zxrAaOzJMrt lTrSqGJUyBXZ03qLYDGeGY9lvyGWQ3PkRKvBk= Domainkey-Signature: a=rsa-sha1; c=nofws; d=googlegroups.com; s=beta; h=x-sender:x-apparently-to:received-spf:authentication-results:from :to:subject:date:user-agent:references:in-reply-to:mime-version :content-type:message-id:reply-to:sender:precedence:x-google-loop :mailing-list:list-id:list-post:list-help:list-unsubscribe :x-beenthere-env:x-beenthere; b=H3FnAGqijWv2YRzOU+8UgLodj2PE1MGRs79KSujIC2nWW5cZ3mXOo4Wp1PDLdIRdW6 O1xree7SHU8z8QU5wRIn6jeag1mhBUrNLdCEyArYg4NCis0Tcwx7JAHM2anhi78tOJkv 859mSHvMFcmNj3PxTcLA2AnIwJLPGv7tiFoDs= Received: by 10.220.58.195 with SMTP id i3mr116049vch.22.1252549055760; Wed, 09 Sep 2009 19:17:35 -0700 (PDT) Received: by 10.230.15.132 with SMTP id k4gr30vba.0; Wed, 09 Sep 2009 19:17:35 -0700 (PDT) X-Sender: phma@phma.optus.nu X-Apparently-To: lojban-lbck@googlegroups.com Received: by 10.220.120.5 with SMTP id b5mr89367vcr.5.1252549055366; Wed, 09 Sep 2009 19:17:35 -0700 (PDT) Received: by 10.220.120.5 with SMTP id b5mr89366vcr.5.1252549055322; Wed, 09 Sep 2009 19:17:35 -0700 (PDT) Received: from cdptpa-omtalb.mail.rr.com (cdptpa-omtalb.mail.rr.com [75.180.132.123]) by gmr-mx.google.com with ESMTP id 20si128510vws.11.2009.09.09.19.17.34; Wed, 09 Sep 2009 19:17:34 -0700 (PDT) Received-SPF: neutral (google.com: 75.180.132.123 is neither permitted nor denied by best guess record for domain of phma@phma.optus.nu) client-ip=75.180.132.123; Authentication-Results: gmr-mx.google.com; spf=neutral (google.com: 75.180.132.123 is neither permitted nor denied by best guess record for domain of phma@phma.optus.nu) smtp.mail=phma@phma.optus.nu Received: from chausie ([71.75.215.96]) by cdptpa-omta03.mail.rr.com with ESMTP id <20090910021734547.ODMD26991@cdptpa-omta03.mail.rr.com> for ; Thu, 10 Sep 2009 02:17:34 +0000 Received: from localhost (localhost [127.0.0.1]) by chausie (Postfix) with ESMTP id F0C34B9BD for ; Wed, 9 Sep 2009 22:17:33 -0400 (EDT) From: Pierre Abbat To: lojban-lbck@googlegroups.com Subject: Re: number of alternatives? Date: Wed, 9 Sep 2009 22:17:31 -0400 User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405) References: <200909090027.38831.phma@phma.optus.nu> <925d17560909091446u2c0208bch132e704f35f6948b@mail.gmail.com> <200909092149.33668.phma@phma.optus.nu> In-Reply-To: <200909092149.33668.phma@phma.optus.nu> MIME-Version: 1.0 Content-Type: Multipart/Mixed; boundary="Boundary-00=_8GGqKrGIrGmaGFl" Message-ID: <200909092217.32444.phma@phma.optus.nu> Reply-To: lojban-lbck@googlegroups.com Sender: lojban-lbck@googlegroups.com Precedence: bulk X-Google-Loop: groups Mailing-List: list lojban-lbck@googlegroups.com; contact lojban-lbck+owner@googlegroups.com List-ID: List-Post: List-Help: List-Unsubscribe: , X-Beenthere-Env: lojban-lbck@googlegroups.com X-Beenthere: lojban-lbck@googlegroups.com --Boundary-00=_8GGqKrGIrGmaGFl Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline On Wednesday 09 September 2009 21:49:32 Pierre Abbat wrote: > The database doesn't exist yet. I posted a tentative tarmi of it a week > ago. I can put it on my box for testing, but it should, I think, be hosted > on the same box as lojban.org when it goes into production. What DBMSs are > available there? The database now exists. The attached file is valid in both MySQL and PostgreSQL. Pierre --Boundary-00=_8GGqKrGIrGmaGFl Content-Type: text/plain; charset="iso-8859-1"; name="jbocipra" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jbocipra" drop table preti; drop table retygri; drop table cipfihi; create table cipfihi (nacycme serial primary key, cmene text ); create table retygri (nacycme serial primary key, nilnandu int2, -- or real, or maybe several of these pagbu int2, -- which part of the test this goes in, e.g. finti int references cipfihi, zgana int references cipfihi, -- Who reviewed the question group. jarco_namcu int2, -- Number of questions to ask. The number of questions in the group you can get by a count query. jufra text -- HTML in UTF8; may contain img tags. ); create table preti (nacycme serial primary key, retygri int references retygri, jufra text, -- HTML (in case we want to add italics or fonts) in UTF8 (in case we want to zoi-quote a foreign word) xo_tercuha int2, danfu1 text, -- HTML in UTF8 danfu2 text, danfu3 text, danfu4 text, danfu5 text, drani char, -- A through E jufydrani text, -- for fill-in-blank questions cunpoi boolean -- true if the answers should be randomized ); --Boundary-00=_8GGqKrGIrGmaGFl--