8 lines
336 B
MySQL
8 lines
336 B
MySQL
|
-- Remove indexes for email and phone_number columns
|
||
|
|
DROP INDEX IF EXISTS idx_organizations_email;
|
||
|
|
DROP INDEX IF EXISTS idx_organizations_phone_number;
|
||
|
|
|
||
|
|
-- Remove email and phone_number columns from organizations table
|
||
|
|
ALTER TABLE organizations DROP COLUMN IF EXISTS email;
|
||
|
|
ALTER TABLE organizations DROP COLUMN IF EXISTS phone_number;
|