14 lines
506 B
SQL
14 lines
506 B
SQL
-- Rollback: Remove session events table and view
|
|
|
|
DROP VIEW IF EXISTS session_current_state;
|
|
|
|
DROP INDEX IF EXISTS idx_session_events_user_sessions;
|
|
DROP INDEX IF EXISTS idx_session_events_session_timeline;
|
|
DROP INDEX IF EXISTS idx_session_events_session_type;
|
|
DROP INDEX IF EXISTS idx_session_events_event_type;
|
|
DROP INDEX IF EXISTS idx_session_events_created_at;
|
|
DROP INDEX IF EXISTS idx_session_events_username;
|
|
DROP INDEX IF EXISTS idx_session_events_session_id;
|
|
|
|
DROP TABLE IF EXISTS session_events;
|