[geeklog-devel] MS SQL Upgrade

[Randy Kolenko]

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

>