14 lines
286 B
PL/PgSQL
14 lines
286 B
PL/PgSQL
BEGIN;
|
|
|
|
ALTER TABLE firmware_release
|
|
DROP COLUMN created_source,
|
|
DROP COLUMN published_at,
|
|
DROP COLUMN mandatory,
|
|
DROP COLUMN release_channel,
|
|
ALTER COLUMN household_id SET NOT NULL;
|
|
|
|
ALTER TABLE firmware_rollout
|
|
ALTER COLUMN household_id SET NOT NULL;
|
|
|
|
COMMIT;
|