19 lines
694 B
SQL
19 lines
694 B
SQL
-- ©AngelaMos | 2026
|
|
-- 011_indexes.sql
|
|
|
|
-- +goose Up
|
|
CREATE INDEX idx_events_service_data ON events USING GIN (service_data);
|
|
CREATE INDEX idx_events_tags ON events USING GIN (tags);
|
|
CREATE INDEX idx_sessions_mitre ON sessions USING GIN (mitre_techniques);
|
|
CREATE INDEX idx_sessions_tags ON sessions USING GIN (tags);
|
|
CREATE INDEX idx_attackers_tags ON attackers USING GIN (tags);
|
|
CREATE INDEX idx_iocs_tags ON iocs USING GIN (tags);
|
|
|
|
-- +goose Down
|
|
DROP INDEX IF EXISTS idx_iocs_tags;
|
|
DROP INDEX IF EXISTS idx_attackers_tags;
|
|
DROP INDEX IF EXISTS idx_sessions_tags;
|
|
DROP INDEX IF EXISTS idx_sessions_mitre;
|
|
DROP INDEX IF EXISTS idx_events_tags;
|
|
DROP INDEX IF EXISTS idx_events_service_data;
|