48 lines
2.2 KiB
SQL
48 lines
2.2 KiB
SQL
-- Migration 009 Down: Remove Secure Messenger System
|
|
|
|
-- Drop triggers
|
|
DROP TRIGGER IF EXISTS messenger_relay_nodes_updated ON messenger_relay_nodes;
|
|
DROP TRIGGER IF EXISTS messenger_conversations_updated ON messenger_conversations;
|
|
DROP TRIGGER IF EXISTS messenger_contact_groups_updated ON messenger_contact_groups;
|
|
DROP TRIGGER IF EXISTS messenger_contacts_updated ON messenger_contacts;
|
|
DROP TRIGGER IF EXISTS messenger_profiles_updated ON messenger_profiles;
|
|
|
|
DROP FUNCTION IF EXISTS update_messenger_timestamp();
|
|
|
|
-- Drop indexes
|
|
DROP INDEX IF EXISTS idx_messenger_relay_active;
|
|
DROP INDEX IF EXISTS idx_messenger_peer_registry_trusted;
|
|
DROP INDEX IF EXISTS idx_messenger_peer_registry_type;
|
|
DROP INDEX IF EXISTS idx_messenger_messages_ipfs;
|
|
DROP INDEX IF EXISTS idx_messenger_messages_created;
|
|
DROP INDEX IF EXISTS idx_messenger_messages_sender;
|
|
DROP INDEX IF EXISTS idx_messenger_messages_conversation;
|
|
DROP INDEX IF EXISTS idx_messenger_members_user;
|
|
DROP INDEX IF EXISTS idx_messenger_members_conversation;
|
|
DROP INDEX IF EXISTS idx_messenger_conversations_owner;
|
|
DROP INDEX IF EXISTS idx_messenger_conversations_type;
|
|
DROP INDEX IF EXISTS idx_messenger_blocklist_peer;
|
|
DROP INDEX IF EXISTS idx_messenger_blocklist_blocked;
|
|
DROP INDEX IF EXISTS idx_messenger_blocklist_owner;
|
|
DROP INDEX IF EXISTS idx_messenger_contacts_messaging_id;
|
|
DROP INDEX IF EXISTS idx_messenger_contacts_status;
|
|
DROP INDEX IF EXISTS idx_messenger_contacts_owner;
|
|
DROP INDEX IF EXISTS idx_messenger_keys_type;
|
|
DROP INDEX IF EXISTS idx_messenger_keys_user_active;
|
|
DROP INDEX IF EXISTS idx_messenger_profiles_status;
|
|
DROP INDEX IF EXISTS idx_messenger_profiles_peer_id;
|
|
DROP INDEX IF EXISTS idx_messenger_profiles_messaging_id;
|
|
|
|
-- Drop tables in reverse dependency order
|
|
DROP TABLE IF EXISTS messenger_relay_nodes;
|
|
DROP TABLE IF EXISTS messenger_peer_registry;
|
|
DROP TABLE IF EXISTS messenger_read_receipts;
|
|
DROP TABLE IF EXISTS messenger_messages;
|
|
DROP TABLE IF EXISTS messenger_conversation_members;
|
|
DROP TABLE IF EXISTS messenger_conversations;
|
|
DROP TABLE IF EXISTS messenger_blocklist;
|
|
DROP TABLE IF EXISTS messenger_contact_groups;
|
|
DROP TABLE IF EXISTS messenger_contacts;
|
|
DROP TABLE IF EXISTS messenger_keys;
|
|
DROP TABLE IF EXISTS messenger_profiles;
|