2 -- purpose: add field to allow ratings opt-out
4 ALTER TABLE users ADD COLUMN block_ratings int;
5 UPDATE users SET block_ratings=0;
6 ALTER TABLE users ALTER COLUMN block_ratings SET NOT NULL;
7 ALTER TABLE users ALTER COLUMN block_ratings SET DEFAULT 0;