10 lines
320 B
MySQL
10 lines
320 B
MySQL
|
-- Drop indexes
|
||
|
|
DROP INDEX IF EXISTS idx_otp_sessions_is_used;
|
||
|
|
DROP INDEX IF EXISTS idx_otp_sessions_expires_at;
|
||
|
|
DROP INDEX IF EXISTS idx_otp_sessions_purpose;
|
||
|
|
DROP INDEX IF EXISTS idx_otp_sessions_phone_number;
|
||
|
|
DROP INDEX IF EXISTS idx_otp_sessions_token;
|
||
|
|
|
||
|
|
-- Drop OTP sessions table
|
||
|
|
DROP TABLE IF EXISTS otp_sessions;
|