[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_user.user
   2    ADD isEmailVerified INT UNSIGNED NOT NULL;
   3  
   4  ALTER TABLE {$NAMESPACE}_user.user
   5    ADD isApproved INT UNSIGNED NOT NULL;
   6  
   7  ALTER TABLE {$NAMESPACE}_user.user
   8    ADD KEY `key_approved` (isApproved);
   9  
  10  UPDATE {$NAMESPACE}_user.user SET isApproved = 1;