-- Re-imposing NOT NULL requires backfilling any NULLs first.
UPDATE users SET sampradaya = 'gaudiya' WHERE sampradaya IS NULL;
ALTER TABLE users
    ALTER COLUMN sampradaya SET NOT NULL;