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.

-derek

_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Reply via email to