[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