0000_runtime_audit_init.up.sql (1096B)
1 CREATE TABLE myc_operation_audit ( 2 audit_record_id INTEGER PRIMARY KEY, 3 recorded_at_unix INTEGER NOT NULL, 4 operation TEXT NOT NULL, 5 outcome TEXT NOT NULL, 6 relay_url TEXT, 7 connection_id TEXT, 8 request_id TEXT, 9 attempt_id TEXT, 10 planned_repair_relays_json TEXT NOT NULL, 11 blocked_relays_json TEXT NOT NULL, 12 blocked_reason TEXT, 13 delivery_policy TEXT, 14 required_acknowledged_relay_count INTEGER, 15 publish_attempt_count INTEGER, 16 relay_count INTEGER NOT NULL, 17 acknowledged_relay_count INTEGER NOT NULL, 18 relay_outcome_summary TEXT NOT NULL 19 ); 20 21 CREATE INDEX idx_myc_operation_audit_recorded_at 22 ON myc_operation_audit(recorded_at_unix, audit_record_id); 23 24 CREATE INDEX idx_myc_operation_audit_connection_id 25 ON myc_operation_audit(connection_id, recorded_at_unix, audit_record_id); 26 27 CREATE INDEX idx_myc_operation_audit_attempt_id 28 ON myc_operation_audit(attempt_id, recorded_at_unix, audit_record_id); 29 30 CREATE INDEX idx_myc_operation_audit_operation_attempt 31 ON myc_operation_audit(operation, recorded_at_unix, audit_record_id);