Codex
20 lines
887 B
SQL
20 lines
887 B
SQL
SELECT column_name FROM information_schema.columns
|
|
WHERE table_schema = DATABASE() AND table_name = 'qipai_stores'
|
|
AND column_name IN ('cancellation_cutoff_minutes', 'cancellation_fee_bps')
|
|
ORDER BY column_name;
|
|
|
|
SELECT column_name FROM information_schema.columns
|
|
WHERE table_schema = DATABASE() AND table_name = 'qipai_orders'
|
|
AND column_name IN ('adjustment_amount_cents', 'operator_note')
|
|
ORDER BY column_name;
|
|
|
|
SELECT table_name FROM information_schema.tables
|
|
WHERE table_schema = DATABASE() AND table_name = 'qipai_order_adjustments';
|
|
|
|
SELECT index_name FROM information_schema.statistics
|
|
WHERE table_schema = DATABASE() AND table_name = 'qipai_order_adjustments'
|
|
AND index_name IN ('uq_qipai_order_adjustment_trace', 'idx_qipai_order_adjustment_order')
|
|
GROUP BY index_name ORDER BY index_name;
|
|
|
|
SELECT version, name FROM qipai_schema_migrations WHERE version = '2026062013';
|