[Summary view] [Print] [Text view]

   1  --
   2  -- Fix wrong asset name for com_content basic workflow stage if a new asset with the right
   3  -- name hasn't been created yet when saving the workflow stage in backend in past.
   4  --
   5  UPDATE "#__assets"
   6     SET "name" = 'com_content.stage.1'
   7   WHERE "name" = 'com_content.state.1'
   8     AND (SELECT c."count" FROM (SELECT COUNT(b."id") AS "count" FROM "#__assets" b WHERE b."name" = 'com_content.stage.1') AS c) = 0;
   9  
  10  --
  11  -- Fix wrong asset titles for workflow transitions
  12  --
  13  UPDATE "#__assets" SET "title" = 'Unpublish' WHERE "name" = 'com_content.transition.1' AND "title" = 'Publish';
  14  UPDATE "#__assets" SET "title" = 'Publish'   WHERE "name" = 'com_content.transition.2' AND "title" = 'Unpublish';
  15  UPDATE "#__assets" SET "title" = 'Trash'     WHERE "name" = 'com_content.transition.3' AND "title" = 'Archive';
  16  UPDATE "#__assets" SET "title" = 'Archive'   WHERE "name" = 'com_content.transition.4' AND "title" = 'Trash';