[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.
Phil _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
