[Summary view] [Print] [Text view]

   1  TRUNCATE {$NAMESPACE}_user.user_externalaccount;
   2  
   3  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
   4    CHANGE accountDomain accountDomain varchar(64) NOT NULL COLLATE utf8_bin;
   5  
   6  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
   7    CHANGE displayName displayName varchar(255) COLLATE utf8_bin;
   8  
   9  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
  10    ADD username VARCHAR(255) COLLATE utf8_bin;
  11  
  12  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
  13    ADD realName VARCHAR(255) COLLATE utf8_bin;
  14  
  15  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
  16    ADD email VARCHAR(255) COLLATE utf8_bin;
  17  
  18  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
  19    ADD emailVerified BOOL NOT NULL COLLATE utf8_bin;
  20  
  21  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
  22    ADD accountURI VARCHAR(255) COLLATE utf8_bin;
  23  
  24  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
  25    ADD profileImagePHID VARCHAR(64) COLLATE utf8_bin;
  26  
  27  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
  28    ADD properties LONGTEXT NOT NULL COLLATE utf8_bin;
  29  
  30  ALTER TABLE {$NAMESPACE}_user.user_externalaccount
  31    ADD KEY `key_userAccounts` (userPHID);