[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_repository.repository_summary
   2    ADD KEY `key_epoch` (epoch);
   3  
   4  ALTER TABLE {$NAMESPACE}_repository.repository
   5    ADD KEY `key_name` (name);
   6  
   7  ALTER TABLE {$NAMESPACE}_repository.repository
   8    ADD KEY `key_vcs` (versionControlSystem);
   9  
  10  ALTER TABLE {$NAMESPACE}_repository.repository
  11    ADD viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin;
  12  
  13  ALTER TABLE {$NAMESPACE}_repository.repository
  14    ADD editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin;
  15  
  16  UPDATE {$NAMESPACE}_repository.repository
  17    SET viewPolicy = 'users' WHERE viewPolicy = '';
  18  
  19  UPDATE {$NAMESPACE}_repository.repository
  20    SET editPolicy = 'admin' WHERE editPolicy = '';