Homewrite.as

Fix "NOT NULL column with NULL" error in v5 SQLite migration

Authored by matt on Mar 3 2020, 5:43 PM.

Description

Fix "NOT NULL column with NULL" error in v5 SQLite migration

Previously, this migration would cause the error: "Cannot add a NOT NULL
column with default value NULL". This fixes that by setting the default
value for new columns to '' (empty string). It updates the query builder
to support this, too.

Details

Committed
mattMar 3 2020, 5:43 PM
Parents
rWFbb5da1d3f579: Break up v5 table ALTERs for SQLite
Branches
Unknown
Tags
Unknown