Viewing File: /home/ubuntu/code_review/phabricator/resources/sql/patches/20131112.userverified.1.col.sql

ALTER TABLE {$NAMESPACE}_user.user
  ADD isEmailVerified INT UNSIGNED NOT NULL;

ALTER TABLE {$NAMESPACE}_user.user
  ADD isApproved INT UNSIGNED NOT NULL;

ALTER TABLE {$NAMESPACE}_user.user
  ADD KEY `key_approved` (isApproved);

UPDATE {$NAMESPACE}_user.user SET isApproved = 1;