[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_differential.differential_revision
   2    ADD viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin;
   3  
   4  ALTER TABLE {$NAMESPACE}_differential.differential_revision
   5    ADD editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin;
   6  
   7  UPDATE {$NAMESPACE}_differential.differential_revision
   8    SET viewPolicy = 'users' WHERE viewPolicy = '';
   9  
  10  UPDATE {$NAMESPACE}_differential.differential_revision
  11    SET editPolicy = 'users' WHERE editPolicy = '';
  12  
  13  ALTER TABLE {$NAMESPACE}_differential.differential_revision
  14    ADD repositoryPHID VARCHAR(64) COLLATE utf8_bin;
  15  
  16  ALTER TABLE {$NAMESPACE}_differential.differential_revision
  17    ADD KEY (repositoryPHID);