11 lines
508 B
SQL
11 lines
508 B
SQL
-- BizMatch Phase 2 — module 5
|
|
-- One-time reset of buyer.interested_in_updates.
|
|
--
|
|
-- Every existing row got its `false` from the DEFAULT that 002 shipped with,
|
|
-- i.e. before 003 made the column tri-state. Under the new semantics that
|
|
-- `false` reads as "explicitly said no", which nobody ever recorded. All rows
|
|
-- predate the tri-state semantics and the table holds test data only, so the
|
|
-- honest value for every one of them is NULL = "not answered".
|
|
|
|
UPDATE buyer SET interested_in_updates = NULL;
|