[geeklog-devel] MS SQL Upgrade
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?
> >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.
> bye, Dirk
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
More information about the geeklog-devel