Received-SPF: neutral (google.com: 69.132.101.103 is neither permitted nor denied by best guess record for domain of phma@phma.optus.nu) client-ip=69.132.101.103;
From: Pierre Abbat <phma@phma.optus.nu>
To: lojban-lbck@googlegroups.com
Subject: Re: Should we keep track of people who pass the test?
Date: Mon, 6 Aug 2012 23:22:49 -0400
User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405)
References: <201208062214.29953.phma@phma.optus.nu> <CAMKwHj37bPzvFT7Q5uY=SJBLLX30tzmnGkhkp6DL4_PwMKng4A@mail.gmail.com>
In-Reply-To: <CAMKwHj37bPzvFT7Q5uY=SJBLLX30tzmnGkhkp6DL4_PwMKng4A@mail.gmail.com>
MIME-Version: 1.0
Message-Id: <201208062322.50346.phma@phma.optus.nu>
Reply-To: lojban-lbck@googlegroups.com
Precedence: list
Mailing-list: list lojban-lbck@googlegroups.com; contact lojban-lbck+owners@googlegroups.com
Sender: lojban-lbck@googlegroups.com
Content-Type: text/plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Spam_score: -0.7
X-Spam_score_int: -6
X-Spam_bar: /

On Monday 06 August 2012 22:16:53 Jonathan Jones wrote:
> "Real name / Lojban name / tests attempted / tests passed / proficiency
> level"?

"tests attempted" and "tests passed" should be in a different table. It is 
possible to put arrays in a table column, but I don't know how to use them or 
how portable it is. Do we really need "tests attempted"? I don't see the need 
to enter someone who's never passed a test or authored a question.

Here's that part of the database schema with your fields added (I changed the 
table name from "cipfihi" to "prenu":

create table prenu
(nacycme serial primary key,
 cipfihi boolean,
 plicme text,
 sivyvla text,
 rarbaucme text,
 jbocme text,
 nilcertu short
 );

create table ciptoi
(tercipra int references prenu,
 detri date,
 nilnandu short,
 snada boolean
 );

> Also, where is this test?

We're still designing it.

Pierre
-- 
lo ponse be lo mruli po'o cu ga'ezga roda lo ka dinko