Index of /database/direct_delivery/build/changelog/ddl/procedures/reference

Name ↑SizeModified
⬆..📄not_safe_to_delete.sql2.2 KB2026-07-13 03:27📄ripper_image_status.sql644 B2026-07-13 03:27📄ripper_track_status.sql731 B2026-07-13 03:27📄ripper_video_status.sql689 B2026-07-13 03:27📄safe_to_delete.sql2.2 KB2026-07-13 03:27📄sp_add_asset_location_details.sql1.5 KB2026-07-13 03:27📄sp_add_dd_asset.sql2.5 KB2026-07-13 03:27📄sp_add_dd_asset_location.sql1.7 KB2026-07-13 03:27📄sp_add_to_asset.sql2.8 KB2026-07-13 03:27📄sp_add_to_asset_received_details.sql488 B2026-07-13 03:27📄sp_add_to_asset_received_queue.sql637 B2026-07-13 03:27📄sp_add_to_delivery_batch.sql843 B2026-07-13 03:27📄sp_add_to_queue.sql609 B2026-07-13 03:27📄sp_batch_idle_check.sql697 B2026-07-13 03:27📄sp_batch_increment.sql640 B2026-07-13 03:27📄sp_batch_reset.sql1.1 KB2026-07-13 03:27📄sp_change_storage_drive.sql1.0 KB2026-07-13 03:27📄sp_chk_enc_queue_detail.sql447 B2026-07-13 03:27📄sp_chk_enc_queue_detail_status.sql1.3 KB2026-07-13 03:27📄sp_claim_asset_for_backup.sql1.2 KB2026-07-13 03:27📄sp_claim_asset_received.sql1.2 KB2026-07-13 03:27📄sp_claim_asset_to_backup.sql4.3 KB2026-07-13 03:27📄sp_claim_delivery_job.sql1.1 KB2026-07-13 03:27📄sp_claim_encoding_detail.sql705 B2026-07-13 03:27📄sp_claim_hd_delivery_from_direct.sql2.3 KB2026-07-13 03:27📄sp_claim_hd_delivery_job.sql1003 B2026-07-13 03:27📄sp_claim_ioda_asset_processed_dd.sql1.1 KB2026-07-13 03:27📄sp_claim_ioda_asset_processed_rb.sql1.1 KB2026-07-13 03:27📄sp_claim_sync_asset.sql5.6 KB2026-07-13 03:27📄sp_clean_up_asset_errors.sql346 B2026-07-13 03:27📄sp_clean_up_delivery_queue.sql1.2 KB2026-07-13 03:27📄sp_clean_up_pickup_queue.sql330 B2026-07-13 03:27📄sp_clear_vector_delivery.sql760 B2026-07-13 03:27📄sp_close_asset_backup.sql1006 B2026-07-13 03:27📄sp_close_asset_to_sync.sql646 B2026-07-13 03:27📄sp_close_delivery_batch.sql367 B2026-07-13 03:27📄sp_close_delivery_job.sql1.5 KB2026-07-13 03:27📄sp_close_delivery_job_vtf.sql1.5 KB2026-07-13 03:27📄sp_close_enc_job.sql509 B2026-07-13 03:27📄sp_close_enc_job_vtf.sql478 B2026-07-13 03:27📄sp_close_hd_delivery_job.sql1.4 KB2026-07-13 03:27📄sp_create_direct_delivery_location.sql579 B2026-07-13 03:27📄sp_create_enc_queue_detail.sql620 B2026-07-13 03:27📄sp_create_enc_queue_detail_dms.sql1016 B2026-07-13 03:27📄sp_create_encoding_queue.sql585 B2026-07-13 03:27📄sp_create_hd_storage_drive.sql836 B2026-07-13 03:27📄sp_delete_asset_location.sql714 B2026-07-13 03:27📄sp_fail_asset_backup.sql942 B2026-07-13 03:27📄sp_fail_asset_sync.sql616 B2026-07-13 03:27📄sp_fail_delivery_job.sql1.2 KB2026-07-13 03:27📄sp_fail_delivery_job_vtf.sql1.2 KB2026-07-13 03:27📄sp_fail_hd_delivery_job.sql1.4 KB2026-07-13 03:27📄sp_get_all_asset_type_detail.sql442 B2026-07-13 03:27📄sp_get_all_storage_drive_details.sql547 B2026-07-13 03:27📄sp_get_all_storage_drives.sql636 B2026-07-13 03:27📄sp_get_asset_backup.sql395 B2026-07-13 03:27📄sp_get_asset_details_by_id.sql1.6 KB2026-07-13 03:27📄sp_get_asset_location.sql597 B2026-07-13 03:27📄sp_get_asset_mapping.sql305 B2026-07-13 03:27📄sp_get_asset_type_detail.sql441 B2026-07-13 03:27📄sp_get_asset_types.sql317 B2026-07-13 03:27📄sp_get_assets_path_by_upc.sql1.0 KB2026-07-13 03:27📄sp_get_batch_info.sql676 B2026-07-13 03:27📄sp_get_claim_encoding_details.sql2.7 KB2026-07-13 03:27📄sp_get_claim_encoding_details_HD.sql3.4 KB2026-07-13 03:27📄sp_get_claim_encoding_details_skipped.sql3.3 KB2026-07-13 03:27📄sp_get_claim_encoding_details_UK.sql3.0 KB2026-07-13 03:27📄sp_get_customers.sql328 B2026-07-13 03:27📄sp_get_dd_assets.sql751 B2026-07-13 03:27📄sp_get_dd_assets_from_all.sql715 B2026-07-13 03:27📄sp_get_dd_eo_ids.sql420 B2026-07-13 03:27📄sp_get_delivery_job_info_vtf.sql1.0 KB2026-07-13 03:27📄sp_get_delivery_queue.sql909 B2026-07-13 03:27📄sp_get_direct_delivery_location.sql1.7 KB2026-07-13 03:27📄sp_get_encoded_jobs.sql806 B2026-07-13 03:27📄sp_get_encoding_details.sql1016 B2026-07-13 03:27📄sp_get_encoding_queue.sql1.1 KB2026-07-13 03:27📄sp_get_encoding_spec_by_dms_master_id.sql1.5 KB2026-07-13 03:27📄sp_get_eo_perf_job_summary.sql2.9 KB2026-07-13 03:27📄sp_get_location_drive_ids.sql447 B2026-07-13 03:27📄sp_get_machines.sql474 B2026-07-13 03:27📄sp_get_next_batch_to_close.sql2.0 KB2026-07-13 03:27📄sp_get_next_for_delivery.sql3.2 KB2026-07-13 03:27📄sp_get_next_for_delivery_itunes.sql32.7 KB2026-07-13 03:27📄sp_get_next_for_delivery_UK.sql32.3 KB2026-07-13 03:27📄sp_get_next_hd_delivery_job.sql1010 B2026-07-13 03:27📄sp_get_next_hd_delivery_job_UK.sql1000 B2026-07-13 03:27📄sp_get_next_high_priority_delivery_jobs.sql1.3 KB2026-07-13 03:27📄sp_get_next_upc.sql898 B2026-07-13 03:27📄sp_get_pickup_queue.sql832 B2026-07-13 03:27📄sp_get_priorities.sql685 B2026-07-13 03:27📄sp_get_ready_queue.sql1.8 KB2026-07-13 03:27📄sp_get_release_track_info.sql974 B2026-07-13 03:27📄sp_get_renewed_dd_items.sql1.2 KB2026-07-13 03:27📄sp_get_renewed_dd_items_vtf.sql1.0 KB2026-07-13 03:27📄sp_get_storage_drive_detail.sql543 B2026-07-13 03:27📄sp_get_storage_drive_for_asset.sql839 B2026-07-13 03:27📄sp_get_storage_drives.sql632 B2026-07-13 03:27📄sp_get_store_realtime_details.sql2.8 KB2026-07-13 03:27📄sp_get_vector_assets.sql1.2 KB2026-07-13 03:27📄sp_get_vector_next_highest_priority_jobs.sql4.5 KB2026-07-13 03:27📄sp_insert_bulk_vector_perf_end.sql1.8 KB2026-07-13 03:27📄sp_insert_bulk_vector_perf_error.sql2.0 KB2026-07-13 03:27📄sp_insert_bulk_vector_perf_start.sql1.8 KB2026-07-13 03:27📄sp_insert_delivery_history_detail.sql2.3 KB2026-07-13 03:27📄sp_insert_delivery_queue.sql566 B2026-07-13 03:27📄sp_insert_pickup_queue.sql526 B2026-07-13 03:27📄sp_insert_vector_jobs.sql2.8 KB2026-07-13 03:27📄sp_insert_vector_perf_error_summary.sql1.3 KB2026-07-13 03:27📄sp_insert_vector_perf_job_error_summary.sql2.6 KB2026-07-13 03:27📄sp_insert_vector_perf_job_summary.sql4.0 KB2026-07-13 03:27📄sp_insert_vector_perf_store_profile_summary.sql1.5 KB2026-07-13 03:27📄sp_insert_vector_perf_store_summary.sql1.3 KB2026-07-13 03:27📄sp_insert_vector_perf_summary.sql1.1 KB2026-07-13 03:27📄sp_insert_vector_store_state_history.sql2.0 KB2026-07-13 03:27📄sp_ioda_check_release.sql356 B2026-07-13 03:27📄sp_ioda_get_itunes_channel.sql405 B2026-07-13 03:27📄sp_job_archive.sql285 B2026-07-13 03:27📄sp_job_unarchive.sql2.6 KB2026-07-13 03:27📄sp_migrate_audio_asset.sql1.3 KB2026-07-13 03:27📄sp_migrate_image_asset.sql1.1 KB2026-07-13 03:27📄sp_next_for_delivery.sql3.2 KB2026-07-13 03:27📄sp_next_for_delivery_itunes.sql3.2 KB2026-07-13 03:27📄sp_next_for_delivery_UK.sql3.1 KB2026-07-13 03:27📄sp_pickup_queue_status.sql374 B2026-07-13 03:27📄sp_populate_encoding_pickup_queue.sql1.0 KB2026-07-13 03:27📄sp_populate_sync_queue_ioda_migrate.sql1.8 KB2026-07-13 03:27📄sp_populate_vector_system_backlog_snapshot.sql2.0 KB2026-07-13 03:27📄sp_populate_vector_system_summary_by_day.sql3.4 KB2026-07-13 03:27📄sp_read_asset_error_log.sql446 B2026-07-13 03:27📄sp_release_enc_jobs.sql527 B2026-07-13 03:27📄sp_release_hd_delivery_job.sql1.3 KB2026-07-13 03:27📄sp_remove_asset.sql556 B2026-07-13 03:27📄sp_remove_backup_asset.sql568 B2026-07-13 03:27📄sp_renew_lost_queue_items.sql572 B2026-07-13 03:27📄sp_restart_errors.sql659 B2026-07-13 03:27📄sp_safe_to_delete.sql2.6 KB2026-07-13 03:27📄sp_safe_to_delete_UK.sql1.4 KB2026-07-13 03:27📄sp_set_batch_to_open.sql378 B2026-07-13 03:27📄sp_set_job_for_delivery.sql833 B2026-07-13 03:27📄sp_set_job_to_queued_for_delivery.sql702 B2026-07-13 03:27📄sp_set_non_batched_job_for_hd_delivery.sql519 B2026-07-13 03:27📄sp_set_to_encoding.sql745 B2026-07-13 03:27📄sp_start_enc_job.sql381 B2026-07-13 03:27📄sp_store_track_time.sql680 B2026-07-13 03:27📄sp_truncate_sync_queue.sql313 B2026-07-13 03:27📄sp_update_asset_location_status.sql498 B2026-07-13 03:27📄sp_update_batch_status.sql474 B2026-07-13 03:27📄sp_update_bulk_deliver_upc_jobs_status.sql957 B2026-07-13 03:27📄sp_update_bulk_vector_encoding_job.sql590 B2026-07-13 03:27📄sp_update_delivery_status.sql433 B2026-07-13 03:27📄sp_update_enc_detail_status.sql554 B2026-07-13 03:27📄sp_update_vector_delivery.sql1.7 KB2026-07-13 03:27📄sp_update_vector_encoding_job_status.sql4.3 KB2026-07-13 03:27📄sp_vector_insert_substore.sql1.5 KB2026-07-13 03:27