blob: 1732fb224d5915c5fb0b0155b32655d495cf2435 (
plain)
1
2
3
4
5
6
7
8
9
|
-- +goose Up
CREATE INDEX IF NOT EXISTS idx_frequency_network ON frequencies (network_id);
CREATE INDEX IF NOT EXISTS idx_frequency_messages ON messages (frequency_id);
CREATE INDEX IF NOT EXISTS idx_direct_messages ON messages (sender_id, receiver_id);
-- +goose Down
DROP INDEX IF EXISTS idx_frequency_network;
DROP INDEX IF EXISTS idx_frequency_messages;
DROP INDEX IF EXISTS idx_direct_messages;
|
