[Summary view] [Print] [Text view]

   1  ALTER TABLE `{$NAMESPACE}_phame`.`phame_blog`
   2    ADD `viewPolicy` varchar(64) COLLATE utf8_bin;
   3  
   4  UPDATE `{$NAMESPACE}_phame`.`phame_blog` SET viewPolicy = 'users'
   5    WHERE viewPolicy IS NULL;
   6  
   7  ALTER TABLE `{$NAMESPACE}_phame`.`phame_blog`
   8    ADD `editPolicy` varchar(64) COLLATE utf8_bin;
   9  
  10  UPDATE `{$NAMESPACE}_phame`.`phame_blog` SET editPolicy = 'users'
  11    WHERE editPolicy IS NULL;
  12  
  13  ALTER TABLE `{$NAMESPACE}_phame`.`phame_blog`
  14    ADD `joinPolicy` varchar(64) COLLATE utf8_bin;
  15  
  16  UPDATE `{$NAMESPACE}_phame`.`phame_blog` SET joinPolicy = 'users'
  17    WHERE joinPolicy IS NULL;