-- SQLite does not support adding check with alter table, as a result, adding a check -- involve creating a new table and copying the data over. It is over kill with adding -- a boolean type column. The application write to the table needs to ensure the data -- integrity. ALTER TABLE collection_metadata ADD COLUMN bool_value INTEGER; ALTER TABLE segment_metadata ADD COLUMN bool_value INTEGER;