r17503 - gnucash/trunk/src/backend/sql - Remove constraint that lot.account_guid must not be null. Unfortunately,

[Phil Longstaff]

Yes, that might be possible.  I'll look at it further.

Phil

warlord at MIT.EDU wrote:
> Quoting Phil Longstaff <plongstaff at cvs.gnucash.org>:
>
>> Remove constraint that lot.account_guid must not be null.  
>> Unfortunately,
>> sqlite doesn't support ALTER TABLE which modifies column constraints, so
>> existing databases can't be modified programmatically.
>
> Can't you alter the table by creating a new temporary table with the
> new constraints and then renaming it back to the original table name?
>
> We really need a process to be able to automatically update the
> database schema as we update it.
>
> -derek
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com 
> Version: 8.0.169 / Virus Database: 270.6.21/1669 - Release Date: 9/12/2008 2:18 PM
>
>