Phil Longstaff <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] wrote:
>> Quoting Phil Longstaff <[EMAIL PROTECTED]>:
>>
>>> 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.
>>
> Just committed. A per-table version number is kept, so the lots backend
> code can see what version currently exists in the db, what the
> up-to-date version is, and make the appropriate changes.
Cool. Thanks!
> Phil
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
[EMAIL PROTECTED] PGP key available
_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
