>> ALTER TABLE testTable SET DEFAULT FOR testField TO 0 > > Not all values in this column might actually be stored on disk. > Changing the default value could change those rows.
it would be perfectly okay if you document this to either * apply the new default to all NULL values * not change existing rows. Than I do the UPDATE Statement myself. > It is actually possible to do this, if you force all rows to be > rewritten first, and then change the table definition: > http://stackoverflow.com/questions/25911191/altering-a-sqlite-table-to-add-a-timestamp-column-with-default-value You really want us to modify the Table Definitions? Sincerely Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/
