0224__fix_blobIds.sql 634 B

1234567891011121314
  1. UPDATE blobs SET blobId = REPLACE(blobId, '+', 'X');
  2. UPDATE blobs SET blobId = REPLACE(blobId, '/', 'Y');
  3. UPDATE notes SET blobId = REPLACE(blobId, '+', 'X');
  4. UPDATE notes SET blobId = REPLACE(blobId, '/', 'Y');
  5. UPDATE attachments SET blobId = REPLACE(blobId, '+', 'X');
  6. UPDATE attachments SET blobId = REPLACE(blobId, '/', 'Y');
  7. UPDATE revisions SET blobId = REPLACE(blobId, '+', 'X');
  8. UPDATE revisions SET blobId = REPLACE(blobId, '/', 'Y');
  9. UPDATE entity_changes SET entityId = REPLACE(entityId, '+', 'X') WHERE entityName = 'blobs';
  10. UPDATE entity_changes SET entityId = REPLACE(entityId, '/', 'Y') WHERE entityName = 'blobs';