[geeklog-devel] MS SQL Upgrade
Randy Kolenko
Randy.Kolenko at nextide.ca
Fri May 23 13:47:56 EDT 2008
The issue in the upgrade is that the qid column is a primary key and it
cannot be null..
Problem with the query is that its missing the qid value.
Question becomes: whats the qid value then?
> -----Original Message-----
> From: Dirk Haun [mailto:dirk at haun-online.de]
> Sent: Friday, May 23, 2008 1:45 PM
> To: geeklog-devel
> Subject: Re: [geeklog-devel] MS SQL Upgrade
>
>
> Michael Jervis wrote:
>
> >Who did the work on polls?
>
> Oliver
>
>
> >Can someone who did the work or understands
> >it tell me what the schema should be? Should qid be an
> >autonumber/identity field? etc.
>
> In 1.5, a polltopic (pid) can have several pollquestions
> (qid) each of which can have several pollanswers (aid).
>
> None of them should be autoincrement, from what I understand.
>
> The pid is user-editable and part of the URL. The qid starts
> over from 0 for every new polltopic. As does the aid, only
> that it seems to be 1-based.
>
> HTH
>
> bye, Dirk
>
>
> --
> http://www.haun-online.de/accu/
>
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> http://eight.pairlist.net/mailman/listinfo/geeklog-devel
>
More information about the geeklog-devel
mailing list