SQL reference: 98_production_refinement

Production API: https://asi-database-node-api.arybit.co.ke

Source: Database/98_production_refinement.sql

Engine: MySQL legacy. Status: disabled; qualification pending.

Migration ID: 98_production_refinement. SHA-256 (LF): 61a2a597906b648b83855241b4c89aaa260091ccb4d74cd9eb496e8da98373d6.

Pending isolated MySQL/MariaDB compatibility, dependency and tenant-isolation validation.

Source overview

================================================================= Arybit Auth - Production Update Script (MySQL) MODULE: 98_production_refinement VERSION: 4.6.1 • March 2026 Safe for live database (idempotent) - can be re-run anytime

Fix FKs on tier_platforms

Critical index on transactions

Negative balance guard trigger

Declared objects

add_tx_index
add_user_queue_visibility_index
check_post_processed
claim_next_batch_posts
claim_next_best_post
claim_specific_user_pending_post
enqueue_sentiment_recovery
enqueue_trace_event
fetch_pending_sentiment_recoveries
fetch_pending_social_posts
fetch_research_backlog_for_publishing
fix_arsik_queue_columns
fix_engagement_metrics_columns
fix_moderation_logs_bias_col
fix_pricing_plans_currency
fix_security_alerts_meta_col
fix_social_post_queue_fk
fix_tier_platforms_fk
get_global_bias_score
get_post_by_external_id
get_queue_pressure
get_roi_analysis
growth_feedback
idx_tx_user_type_status_created
idx_user_queue_visibility
ingest_social_feedback_to_research
intelligence_job_queue
log_rejected_content
mark_post_as_sent
mark_post_failed
mark_research_as_published
marketing_campaigns
moderation_logs
queue_social_post
record_revenue_event
refine_social_post_queue_columns
reinforce_growth_model
research_feedback
revenue_events
revenue_pipeline
security_alerts
sensitive_operation_log
sentiment_recovery_queue
social_post_audit
social_post_dlq
social_post_errors
social_post_queue
social_post_sent_hashes
system_trace_events
trg_guard_negative_balance
update_growth_feedback
vw_ua_efficiency

This is a static source reference, not a runtime qualification. Object extraction does not interpret SQL semantics. Review the source and manifest before any schema change.

Connection guide · Migration qualification · SQL catalog