Index of /database/content_review/build/changelog/dml

..📄MAINT-mark-product-complete.sql197 B2026-07-13 03:27📄PEACE-432-insert-stuck-product.sql222 B2026-07-13 03:27📄PEACE-448-insert-stuck-product.sql222 B2026-07-13 03:27📄PEACE-462-reset-stuck-product.sql526 B2026-07-13 03:27📄PEACE-463-reinsert-stuck-product.sql243 B2026-07-13 03:27📄PEACE-464-remove-revision-approvals-accidentally-performed-qa-vapi-instead-of-prod-vapi.sql2.1 KB2026-07-13 03:27📄PEACE-482-insert-test-product.sql233 B2026-07-13 03:27📄PEACE-496-unsubmit-deleted-label-products.sql233 B2026-07-13 03:27📄PEACE-520-insert-approval.sql391 B2026-07-13 03:27📄PEACE-528-unsubmit-deleted-products.sql229 B2026-07-13 03:27📄PEACE-528-unsubmit-previously-deleted-products.sql191 B2026-07-13 03:27📄PEACE-551-unsubmit-deleted-product.sql193 B2026-07-13 03:27📄PEACE-566-insert-stuck-product-approvals-3.sql487 B2026-07-13 03:27📄PEACE-566-insert-stuck-product-approvals.sql483 B2026-07-13 03:27📄PEACE-581-insert-stuck-product-approvals.sql4.5 KB2026-07-13 03:27📄PEACE-586-resubmit-products-into-queue.sql3.4 KB2026-07-13 03:27📄PEACE-629-approve-stuck-product.sql490 B2026-07-13 03:27📄PEACE-631-approve-stuck-product.sql490 B2026-07-13 03:27📄PEACE-649-insert-stuck-product.sql611 B2026-07-13 03:27📄PEACE-649-insert-stuck-revisions.sql806 B2026-07-13 03:27📄PEACE-658-approve-stuck-product.sql493 B2026-07-13 03:27📄PEACE-686-fix-review-queue-item-and-approval-created_datetimes.sql383 B2026-07-13 03:27📄PEACE-686-insert-approvals-into-content-review-for-approved-products.sql4.2 KB2026-07-13 03:27📄PEACE-686-insert-record-into-content-review-for-product-approved-by-ddex-ingester-set-product-to-complete.sql402 B2026-07-13 03:27📄PEACE-714-insert-stuck-product-approvals.sql948 B2026-07-13 03:27📄PEACE-727-unstick-products.sql710 B2026-07-13 03:27📄PEACE-741-remove-diy-tier-1-products.sql399 B2026-07-13 03:27📄PEACE-741-remove-v1-products.sql839 B2026-07-13 03:27📄PEACE-764-approve-stuck-product.sql533 B2026-07-13 03:27📄PEACE-766-remove-products.sql2.0 KB2026-07-13 03:27📄PEACE-806-insert-skipped-products.sql1.3 KB2026-07-13 03:27📄PEACE-806-insert-stuck-products-2.sql248 B2026-07-13 03:27📄PEACE-806-insert-stuck-products-3.sql384 B2026-07-13 03:27📄PEACE-806-insert-stuck-products-4.sql417 B2026-07-13 03:27📄PEACE-823-remove-stuck-product.sql239 B2026-07-13 03:27📄PEACE-close-stuck-products.sql346 B2026-07-13 03:27📄PEACE-drop-stuck-product.sql247 B2026-07-13 03:27📄PEACE-insert-stuck-product-approval.sql473 B2026-07-13 03:27📄REVIEW-1010-insert-escalation-type.sql2.5 KB2026-07-13 03:27📄REVIEW-1010-language-support-escal-type.sql348 B2026-07-13 03:27📄REVIEW-1010-turn-off-show_in_ui.sql193 B2026-07-13 03:27📄REVIEW-1018-remove-deleted-product.sql300 B2026-07-13 03:27📄REVIEW-1019-complete-products-2.sql222 B2026-07-13 03:27📄REVIEW-1019-complete-products.sql222 B2026-07-13 03:27📄REVIEW-1033-insert-account-context-notes.sql2.2 KB2026-07-13 03:27📄REVIEW-1111-remove-deleted-product.sql1.0 KB2026-07-13 03:27📄REVIEW-1141-escal-notification-failed-to-send.sql5.5 KB2026-07-13 03:27📄REVIEW-1150-backfill-canned-response-note.sql29.8 KB2026-07-13 03:27📄REVIEW-1150-backfill-canned-responses-and-note.sql2.5 KB2026-07-13 03:27⚙️REVIEW-1150-canned-response-note-41.xml1.7 KB2026-07-13 03:27📄REVIEW-1150-change-note-text-column-type.sql238 B2026-07-13 03:27📄REVIEW-1150-prod-backfill-canned-response-tables.sql35.9 KB2026-07-13 03:27📄REVIEW-1150-remove-closing-statement.sql25.4 KB2026-07-13 03:27📄REVIEW-1156-backfill-translated-canned-responses.sql31.7 KB2026-07-13 03:27📄REVIEW-1156-es-backfill-translated-canned-responses.sql28.7 KB2026-07-13 03:27📄REVIEW-1156-fr-backfill-translated-canned-responses.sql31.3 KB2026-07-13 03:27📄REVIEW-1156-it-backfill-canned-responses.sql29.6 KB2026-07-13 03:27📄REVIEW-1156-jp-backfill-translated-canned-responses.sql35.8 KB2026-07-13 03:27📄REVIEW-1156-kr-backfill-canned-responses.sql30.2 KB2026-07-13 03:27📄REVIEW-1156-pt-backfill-canned-responses.sql27.6 KB2026-07-13 03:27📄REVIEW-1156-ru-backfill-canned-responses.sql45.5 KB2026-07-13 03:27📄REVIEW-1156-tr-backfill-canned-responses.sql28.6 KB2026-07-13 03:27📄REVIEW-1156-translated-canned-response-20.sql1.1 KB2026-07-13 03:27⚙️REVIEW-1156-translated-canned-response-note-41.xml9.0 KB2026-07-13 03:27📄REVIEW-1156-zhCN-backfill-canned-responses.sql24.3 KB2026-07-13 03:27📄REVIEW-1156-zhTW-backfill-canned-responses.sql25.0 KB2026-07-13 03:27📄REVIEW-1157-update-canned-response-acr.sql298 B2026-07-13 03:27📄REVIEW-1158-canned-response-template.sql5.1 KB2026-07-13 03:27📄REVIEW-1171-remove-stuck-product.sql333 B2026-07-13 03:27📄REVIEW-1200-insert-escalation-type.sql720 B2026-07-13 03:27📄REVIEW-1266-delete-canned-response-template.sql323 B2026-07-13 03:27📄REVIEW-1267-edit-approval-reasons.sql2.1 KB2026-07-13 03:27📄REVIEW-1267-mark-products-for-deletion.sql806 B2026-07-13 03:27📄REVIEW-1267-remove-approval-reasons.sql1.6 KB2026-07-13 03:27📄REVIEW-1267-update-approval-reasons.sql2.5 KB2026-07-13 03:27📄REVIEW-1273-approve-stuck-product.sql497 B2026-07-13 03:27📄REVIEW-1299-unappove-product-b.sql566 B2026-07-13 03:27📄REVIEW-1299-unappove-product.sql566 B2026-07-13 03:27📄REVIEW-1311-other-category-canned-response.sql510 B2026-07-13 03:27📄REVIEW-1319-change-status-from-applying.sql323 B2026-07-13 03:27⚙️REVIEW-1401-update-spanish-canned-response-notes.xml43.2 KB2026-07-13 03:27📄REVIEW-1448-insert-stuck-product.sql502 B2026-07-13 03:27📄REVIEW-1476_update_product_status_and_move_history.sql195 B2026-07-13 03:27📄REVIEW-1496-insert-stuck-product.sql627 B2026-07-13 03:27📄REVIEW-1579-unapprove-product-failing-complete-review.sql221 B2026-07-13 03:27📄REVIEW-1601-insert-new-stuck-products.sql1.9 KB2026-07-13 03:27📄REVIEW-1649-move-review-queue-items-to-on-hold.sql109.3 KB2026-07-13 03:27📄REVIEW-1662-insert-stuck-products.sql1.6 KB2026-07-13 03:27📄REVIEW-1670-fix-stuck-revision-product.sql223 B2026-07-13 03:27📄REVIEW-1680-fix-stuck-revision-product.sql223 B2026-07-13 03:27📄REVIEW-1681-insert-update-account-notes.sql20.0 KB2026-07-13 03:27📄REVIEW-1681a_update_account_note.sql10.9 KB2026-07-13 03:27📄REVIEW-1683-reindex-stuck-product.sql467 B2026-07-13 03:27📄REVIEW-1704-update-approval-reasons-04-2025.sql1.6 KB2026-07-13 03:27📄REVIEW-1704-update-keywords-canned-response.sql2.4 KB2026-07-13 03:27📄REVIEW-1717-delete-references-to-nonexistent-error-correction.sql2.3 KB2026-07-13 03:27📄REVIEW-1725-update-stuck-product-status-applying.sql355 B2026-07-13 03:27📄REVIEW-1730-update-product-stuck-in-applying.sql292 B2026-07-13 03:27📄REVIEW-1731-turn_off_show_in_ui.sql186 B2026-07-13 03:27📄REVIEW-1731-turn_off_show_in_ui_in_prod.sql186 B2026-07-13 03:27📄REVIEW-1732-update-product-stuck-in-applying.sql292 B2026-07-13 03:27📄REVIEW-1736-update-stuck-product-status-applying.sql312 B2026-07-13 03:27📄REVIEW-1739-1740_unapprove_revision_product.sql605 B2026-07-13 03:27📄REVIEW-1741_unapprove_revision_product.sql235 B2026-07-13 03:27📄REVIEW-1744-remove-stuck-product-from-review-queue.sql560 B2026-07-13 03:27📄REVIEW-1756_unsubmit_product.sql519 B2026-07-13 03:27📄REVIEW-1776-reinsert-products-missing-potential-audio-inf.sql1.8 KB2026-07-13 03:27📄REVIEW-1778-update-stuck-product-status-applying.sql314 B2026-07-13 03:27📄REVIEW-1822-backfill-french-canned-response-note.sql26.1 KB2026-07-13 03:27📄REVIEW-1822-backfill-german-canned-response-note.sql25.0 KB2026-07-13 03:27📄REVIEW-1822-backfill-italian-canned-response-note.sql24.2 KB2026-07-13 03:27📄REVIEW-1822-backfill-japanese-canned-response-note.sql30.9 KB2026-07-13 03:27📄REVIEW-1822-backfill-korean-canned-response-note.sql25.2 KB2026-07-13 03:27📄REVIEW-1822-backfill-new-canned-responses.sql4.9 KB2026-07-13 03:27📄REVIEW-1822-backfill-pt-canned-response-note.sql24.0 KB2026-07-13 03:27📄REVIEW-1822-backfill-russian-canned-response-note.sql39.9 KB2026-07-13 03:27📄REVIEW-1822-backfill-spanish-canned-response.sql24.9 KB2026-07-13 03:27📄REVIEW-1822-backfill-turkish-canned-response-note.sql24.3 KB2026-07-13 03:27📄REVIEW-1822-other-canned-response.sql317 B2026-07-13 03:27📄REVIEW-1822-turn-on-canned-response-update-prod.sql905 B2026-07-13 03:27📄REVIEW-1822-update-all-lang-note.sql52.0 KB2026-07-13 03:27📄REVIEW-1822-update-canned-response-note-en.sql22.8 KB2026-07-13 03:27📄REVIEW-1822-update-existing-note-text-en.sql6.1 KB2026-07-13 03:27📄REVIEW-1822-update-zhtw-note-text.sql10.9 KB2026-07-13 03:27📄REVIEW-1855-update-label-manager-target-group-name.sql277 B2026-07-13 03:27📄REVIEW-1855_update_target_group_label_manager_naming.sql208 B2026-07-13 03:27📄REVIEW-1874-add-bulk-approval-canned-response.sql817 B2026-07-13 03:27📄REVIEW-1920-update-escalated-to-user.sql3.2 KB2026-07-13 03:27📄REVIEW-1977_reindex_missing_products.sql1.2 KB2026-07-13 03:27📄REVIEW-2003-backfill-zh-CN.sql25.2 KB2026-07-13 03:27📄REVIEW-2003-backfill-zh-TW-canned-response-note.sql27.1 KB2026-07-13 03:27📄REVIEW-2048-update-canned-response-template.sql4.8 KB2026-07-13 03:27📄REVIEW-2101-unapprove-stuck-product.sql279 B2026-07-13 03:27📄REVIEW-2128-create-score-history-table.sql1.1 KB2026-07-13 03:27📄REVIEW-2130-remove-score-record.sql154 B2026-07-13 03:27📄REVIEW-2176-update-isrc-related-canned-responses.sql47.3 KB2026-07-13 03:27📄REVIEW-2202-update-escalation-type-values.sql576 B2026-07-13 03:27📄REVIEW-2307-complete-old-failed-error-corrections.sql238 B2026-07-13 03:27📄REVIEW-2310_set_correction_review_to_completed.sql227 B2026-07-13 03:27📄REVIEW-2323-alter-prod-ai-track-chinese-transaltions.sql1.0 KB2026-07-13 03:27📄REVIEW-2323-insert-new-canned-response-reason.sql4.5 KB2026-07-13 03:27📄REVIEW-2355_blocklist_approval_reasons.sql1.5 KB2026-07-13 03:27📄REVIEW-2359-revert-gen-ai-artwork-canned-response.sql319 B2026-07-13 03:27📄REVIEW-2359-update-canned-response-gen-ai-content.sql3.8 KB2026-07-13 03:27📄REVIEW-2359-update-canned-responses-gen-ai-artwork.sql4.1 KB2026-07-13 03:27📄REVIEW-2384-update-pai-de-translation.sql1.4 KB2026-07-13 03:27📄REVIEW-2409-delete-from-content-review.sql220 B2026-07-13 03:27📄REVIEW-2415-complete-deleted-products.sql297 B2026-07-13 03:27📄REVIEW-2433_change_queue_item_status_to_new.sql295 B2026-07-13 03:27📄REVIEW-2471-complete-stuck-product.sql189 B2026-07-13 03:27📄REVIEW-2490-move-to-under-investigation.sql3.5 KB2026-07-13 03:27📄REVIEW-2500-fix-primary-artist-track-level-canned-response.sql1.0 KB2026-07-13 03:27📄REVIEW-2507-remove-old-rejection.sql807 B2026-07-13 03:27📄REVIEW-2521_remove_product_entry_from_queue.sql523 B2026-07-13 03:27📄REVIEW-2551-delete-approval.sql326 B2026-07-13 03:27📄REVIEW-2571_complete_bundle_product.sql240 B2026-07-13 03:27📄REVIEW-2630_insert_product_approval.sql636 B2026-07-13 03:27📄REVIEW-2630_insert_product_approval_bulk.sql16.5 KB2026-07-13 03:27📄REVIEW-2635-update-blocklist-canned-responses.sql3.0 KB2026-07-13 03:27📄REVIEW-2636-remove-canned-responses.sql387 B2026-07-13 03:27⚙️REVIEW-2637_backfill_content_guidelines_violation_canned_response.xml7.1 KB2026-07-13 03:27⚙️REVIEW-2637_backfill_producer_as_primary_canned_response_notes.xml8.6 KB2026-07-13 03:27⚙️REVIEW-2637_backfill_producer_credit_canned_response_notes.xml5.2 KB2026-07-13 03:27⚙️REVIEW-2637_backfill_producer_mismatch_canned_response_notes.xml4.6 KB2026-07-13 03:27⚙️REVIEW-2637_update_arrangement_notes_canned_response_notes.xml17.8 KB2026-07-13 03:27⚙️REVIEW-2637_update_remixer_credits_canned_response_notes.xml10.3 KB2026-07-13 03:27📄REVIEW-2652-add-cr-products-bulk.sql308.8 KB2026-07-13 03:27📄REVIEW-2652-add-cr-products.sql965 B2026-07-13 03:27📄REVIEW-2652-bulk-complete-approve-cr-products.sql5.4 KB2026-07-13 14:46⚙️REVIEW-2659_add_canned_response_for_rejection.xml10.4 KB2026-07-13 03:27📄REVIEW-2708-update-review-queue-status-to-new.sql280 B2026-07-13 03:27📄REVIEW-2710-bulk-reject-vendor-799173.sql24.8 KB2026-07-13 03:27📄REVIEW-739-backfill-submission-datetime.sql432 B2026-07-13 03:27📄REVIEW-867-add-assigned-reviewer-target-group.sql441 B2026-07-13 03:27📄REVIEW-867-show-assigned-reviewer-in-ui.sql235 B2026-07-13 03:27📄REVIEW-872-COPY-data-into-columns-queue-move-history.sql764 B2026-07-13 03:27📄REVIEW-872-delete-unwanted-columns-queue-move-history.sql448 B2026-07-13 03:27📄REVIEW-872-populate-move-target-and-target-group-tables.sql681 B2026-07-13 03:27📄REVIEW-882-remove-label-manager-in-ui.sql224 B2026-07-13 03:27📄REVIEW-894-insert-stuck-product-approvals.sql433 B2026-07-13 03:27📄REVIEW-902-approve-stuck-product-2.sql487 B2026-07-13 03:27📄REVIEW-902-approve-stuck-product.sql487 B2026-07-13 03:27📄REVIEW-903-approve-stuck-product.sql487 B2026-07-13 03:27📄REVIEW-904-backfill-error-correction-ids.sql8.7 KB2026-07-13 03:27📄REVIEW-911-move-limbo-products-to-on-hold-queue.sql97.9 KB2026-07-13 03:27📄REVIEW-918-backfill-current-queue-submission-type.sql166.6 KB2026-07-13 03:27📄REVIEW-919-backfille-submission-type-01.sql361.4 KB2026-07-13 03:27📄REVIEW-919-backfille-submission-type-02.sql1.5 MB2026-07-13 03:27📄REVIEW-919-backfille-submission-type-03.sql1.5 MB2026-07-13 03:27📄REVIEW-919-backfille-submission-type-04.sql1.5 MB2026-07-13 03:27📄REVIEW-919-backfille-submission-type-05.sql1.4 MB2026-07-13 03:27📄REVIEW-919-backfille-submission-type-06.sql1.3 MB2026-07-13 03:27📄REVIEW-919-backfille-submission-type-07.sql287 B2026-07-13 03:27📄REVIEW-924-approve-stuck-product-4478272.sql496 B2026-07-13 03:27📄REVIEW-924-unsubmit-stuck-product-4760161.sql524 B2026-07-13 03:27📄REVIEW-944_add_will_not_deliver_as_canned_response.sql1003 B2026-07-13 03:27📄REVIEW-949-backfill-submission-count.sql41.6 KB2026-07-13 03:27📄REVIEW-950-move-limbo-products-to-on-hold-queue.sql53.2 KB2026-07-13 03:27📄REVIEW-973-update-target-group-display-name.sql415 B2026-07-13 03:27📄REVIEW-980-approve-stuck-products.sql850 B2026-07-13 03:27📄REVIEW-981-remove-stuck-product.sql273 B2026-07-13 03:27📄REVIEW-984_move-limbo-products-on-hold-queue.sql51.7 KB2026-07-13 03:27📄REVIEW-990-backfill-queue-move-target-users.sql5.7 KB2026-07-13 03:27📄REVIEW-994-backfill-orchadmin-user-id-queue-move-history.sql762 B2026-07-13 03:27📄REVIEW-994-delete-email-column-move-target.sql326 B2026-07-13 03:27📄REVIEW-994-set-orchadmin-user-id-move-target.sql232 B2026-07-13 03:27📄REVIEW-drop-rollback-tables-oct-1-2025.sql1.1 KB2026-07-13 03:27