9 lines
360 B
SQL
9 lines
360 B
SQL
-- BizMatch Phase 2 — module 4 follow-up
|
|
-- The value comes from scanned intake sheets where the field is frequently
|
|
-- left blank. NULL therefore has to mean "not answered" and stay distinct
|
|
-- from false, which means "explicitly no".
|
|
|
|
ALTER TABLE buyer
|
|
ALTER COLUMN interested_in_updates DROP NOT NULL,
|
|
ALTER COLUMN interested_in_updates DROP DEFAULT;
|