Received-SPF: pass (google.com: domain of eyeonus@gmail.com designates 209.85.215.50 as permitted sender) client-ip=209.85.215.50;
MIME-Version: 1.0
In-Reply-To: <201208062322.50346.phma@phma.optus.nu>
References: <201208062214.29953.phma@phma.optus.nu>
	<CAMKwHj37bPzvFT7Q5uY=SJBLLX30tzmnGkhkp6DL4_PwMKng4A@mail.gmail.com>
	<201208062322.50346.phma@phma.optus.nu>
Date: Mon, 6 Aug 2012 21:27:48 -0600
Message-ID: <CAMKwHj108TL9OmHGUKU0iw+77wcAtqAKv1YxK17ToTidbQm9+g@mail.gmail.com>
Subject: Re: Should we keep track of people who pass the test?
From: Jonathan Jones <eyeonus@gmail.com>
To: lojban-lbck@googlegroups.com
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: multipart/alternative; boundary=f46d0401236f1b820004c6a4943b
X-Spam_score: 0.0
X-Spam_score_int: 0
X-Spam_bar: /

--f46d0401236f1b820004c6a4943b
Content-Type: text/plain; charset=ISO-8859-1

On Mon, Aug 6, 2012 at 9:22 PM, Pierre Abbat <phma@phma.optus.nu> wrote:

> 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.
>

I was thinking of how GPA is reported, which is the average of credits
completed to credits attempted.

>
> 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
>


-- 
mu'o mi'e .aionys.

.i.e'ucai ko cmima lo pilno be denpa bu .i doi.luk. mi patfu do zo'o
(Come to the Dot Side! Luke, I am your father. :D )

--f46d0401236f1b820004c6a4943b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">On Mon, Aug 6, 2012 at 9:22 PM, Pierre A=
bbat <span dir=3D"ltr">&lt;<a href=3D"mailto:phma@phma.optus.nu" target=3D"=
_blank">phma@phma.optus.nu</a>&gt;</span> wrote:<br><blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex">
<div class=3D"im">On Monday 06 August 2012 22:16:53 Jonathan Jones wrote:<b=
r>
&gt; &quot;Real name / Lojban name / tests attempted / tests passed / profi=
ciency<br>
&gt; level&quot;?<br>
<br>
</div>&quot;tests attempted&quot; and &quot;tests passed&quot; should be in=
 a different table. It is<br>
possible to put arrays in a table column, but I don&#39;t know how to use t=
hem or<br>
how portable it is. Do we really need &quot;tests attempted&quot;? I don=
9;t see the need<br>
to enter someone who&#39;s never passed a test or authored a question.<br><=
/blockquote><div><br>I was thinking of how GPA is reported, which is the av=
erage of credits completed to credits attempted. <br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pad=
ding-left:1ex">

<br>
Here&#39;s that part of the database schema with your fields added (I chang=
ed the<br>
table name from &quot;cipfihi&quot; to &quot;prenu&quot;:<br>
<br>
create table prenu<br>
(nacycme serial primary key,<br>
=A0cipfihi boolean,<br>
=A0plicme text,<br>
=A0sivyvla text,<br>
=A0rarbaucme text,<br>
=A0jbocme text,<br>
=A0nilcertu short<br>
=A0);<br>
<br>
create table ciptoi<br>
(tercipra int references prenu,<br>
=A0detri date,<br>
=A0nilnandu short,<br>
=A0snada boolean<br>
=A0);<br>
<div class=3D"im"><br>
&gt; Also, where is this test?<br>
<br>
</div>We&#39;re still designing it.<br>
<span class=3D"HOEnZb"><font color=3D"#888888"><br>
Pierre<br>
--<br>
lo ponse be lo mruli po&#39;o cu ga&#39;ezga roda lo ka dinko<br>
</font></span></blockquote></div><br><br clear=3D"all"><br>-- <br>mu&#39;o =
mi&#39;e .aionys.<br><br>.i.e&#39;ucai ko cmima lo pilno be denpa bu .i doi=
.luk. mi patfu do zo&#39;o<br>(Come to the Dot Side! Luke, I am your father=
. :D )<br>
<br>

--f46d0401236f1b820004c6a4943b--